Shankar Dutt
VBA Developer
NEW DELHI
Judge a man by his questions rather than his answers.
Voltaire
Summary
CAREER SUMMARY 6+ years VBA development experience (User Defined Functions, Automation Macros and scratch written code, both procedural and class oriented, Error Handling, Process Validation). Confident in querying in SQL and DAX queries. Proficient in handling multiple tasks and projects simultaneously in challenging environments. Ability to work independently, as well as part of a team, as a committed team player with flexibility in approach. Seeking opportunities to contribute my technical expertise and problem-solving skills to drive business success. Resourceful Specialist offering expertise in problem-solving, data analysis and customer service. Adept at quickly learning new technologies and processes for driving success. Proven track record of successfully managing multiple projects and developing innovative solutions. Ready to help team achieve company goals.
Overview
7
7
years of professional experience
Work History
Macro Specialist
Clifford Chance Business services Pvt. Ltd
2018.04 - Current
- Designed and developed interactive dashboards using Filters (Slicers), Drill-down Reports in Power BI
- 300h saved on a monthly basis by implementing VBA automation tools
- Automate word and Excel using VBA macro for internal and external clients
- Auditing macros for other departments and upgrading the same as per requirements
- In responsible of mentoring and assisting YB projects for the Continuous Improvement team
- Responsible for creating monthly CI dashboard and sharing with the senior stakeholders
- Created many template for auto-sending email and extracting outlook info using VBA.
- Created and delivered presentations to internal and external stakeholders to showcase work
- Evaluated staff performance and provided coaching to address inefficiencies
Senior Analyst
Beacon Analytics
Gurgaon
2016.12 - 2018.04
- Automated critical Billing Report and saved times
- Created Daily, Weekly Status Reports for Senior Management
- Created Templates/Dashboard for various departments as per their requirements using excel VBA
- Assisting in automation of Operation (FMCG) & Analysis department’s manual processes by writing VBA code, using macros and formulas to speed up processes and maximize accuracy
- PROJECTS Prepared BI dashboard for compliance pack reports
Education
Master of Computer Applications - Computer
Skills
Fluent in [Excel, VBA and Power Tools: Power-BI, Power-Query, Power- Automate, DAX Functions]
undefinedAdditional Information
- ACHIEVEMENTS/OTHER ACTIVITIES ,
- Awarded Star of the Month in the month of Jan-2021 in Clifford Chance.
- Appreciated with Pat on the back for delivering project on time in the Month of Aug-2020 in Clifford Chance.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Macro Specialist - Clifford Chance Business services Pvt. Ltd
2018.04 - Current
Senior Analyst - Beacon Analytics
2016.12 - 2018.04
Indira Gandhi Open University - Master of Computer Applications, Computer
Similar Profiles
Aman VijAman Vij
Team Lead - Compliance & Data Privacy at Clifford Chance Business Services Pvt. Ltd.Team Lead - Compliance & Data Privacy at Clifford Chance Business Services Pvt. Ltd.
Karan AroraKaran Arora
Deputy Manager at Clifford Chance Business Services Pvt. LtdDeputy Manager at Clifford Chance Business Services Pvt. Ltd
Buddhita MehraBuddhita Mehra
Finance Process Sr. Analyst at Accenture India Pvt. Ltd.Finance Process Sr. Analyst at Accenture India Pvt. Ltd.