In my position, I help clients in their business transformations by generating net new ideas and redesigning the processes based on best in class industry experience and expertise. The core of these implementations is to assist clients in elevating financial performance and human experiences.I help clients in evaluating their key business values, their pain areas and architect, design and implement solutions using new ways of working. In this journey, I use my expertise on excel, VBA, power point and other tools and methodologies to run end to end data visualization and reporting which is presented to CEO level executives. I architect end to end reports using my expertise on VBA platform by evaluating requirements and client needs.I also serve as counsellor to a team of practitioners across various levels as Analysts, Consultants and Senior Consultants. In this role, I coach them on various internal McKinsey tools on technical and functional skills which help in driving the transformation.Project Experience:• American financial services and bank holding company (October, 2019 – Present) in Massachusetts, USA• American financial, retirement and investment company(November, 2018 to October, 2019) in New York, USA• Multinational conglomerate holding company (September, 2018 to October, 2018) in Japan• Electronics company (June, 2018 to August, 2018) in Hungary• Retail company (March, 2018 to June, 2018) in New Zealand• Data Analyst in Wave team(July, 2016 to February, 2018) in Gurgaon, IndiaHighlights:• Assisted client in their overall project roadmap designing by conducting idea generation sessions within different business units• Designed the futuristic tracking process by automating various reporting tools• Led various meetings with clients on requirements, steering committees etc.• Headed the functional and reporting team with daily status tracking and monitoring the scope of work and project commercials, signs offs and milestone deliverables.

• Setting project management office at client site and ensure that the PMO process and processes are kept up to date• Responsible for tracking and monitoring progress of project office as well as coordinate delivery dates• Perform responsibilities like maintaining existing policies and procedures of project office• Generate, update and improve project strategies and methodologies• Provide support and guidance to associates and engagement managers with the help of Lead PMO• Prepare status reports and update the same to the Management team• Coordinate with PMO lead in preparing adhoc presentations and other essential tasks as required• Handle tasks like reviewing, maintaining and highlighting the changes in project plan• Prepare and maintain weekly and monthly project status reports• Maintain fiscal systems for the purpose of recording, forecasting, monitoring and budgeting project expenditure• Review deliverable(s) at the final stage /phase of the project

• Interact with Clients and stake holders to get problem/design requirements and design mock dashboards using Excel/VBA• Design and implement visually appealing dashboards in Tableau and Excel for easy communication of the results• Optimize different reports depending on the requirements.• Work distribution, timeline management & status reporting to the client.• On demand (Adhoc) business analysis.• Create custom tools as per requirement using VBA.

Involved in data interpretation, manipulation, cleansing & processing Excel & VBA, SQL (query and ETL). Building knowledge of a client’s business strategy (product offerings, target market segments, positioning/value proposition, etc.) and market forces (suppliers, customers, competitors, regulatory environment etc.Developed requirement gathering template to help streamline the process. TAT and SLA agreement, budget and stakeholder management. Deadlines and Quality of deliverables.Data transformation and crunching for different solution and custom reports.Create ad-hoc automated custom reports as per the client requirement by using Excel, VBA, Access & SQL.

I have created macros and dashboards to provide high quality reports to clients. I have also worked towards ensuring that team members are motivated, monitored and measured in line with the company’s targets and performance standards. I have also interacted with clients on regular basis to understand new reports/requirements to see the areas of automation and improvements, challenges associated with the manual reporting and work upon them.