Abhay Kumar Sinha
Gurgaon
Summary
Dynamic Senior Analyst with a proven track record at Morya Group of Companies, showcasing expertise in Excel data analysis and Power BI reporting. Leveraged advanced MS Word skills and effective leadership to automate operational tasks, boosting productivity by 30%. Excelled in creating impactful dashboards and strategic decision-making tools, demonstrating exceptional data analytics and teamwork abilities.
Overview
15
15
years of professional experience
Work History
Senior Analyst
Morya Group of Companies
12.2023 - Current
- Develop detailed project plans to monitor and track progress
- Designing, Developing and Troubleshooting of Power BI reports and dashboards for faster decision making as per the client requirements
- Create dynamics dashboards and analyze the data to mine fruitful information and highlight the report
- Perform detailed data analysis and create management reports in excel & Power BI
- Build develop and maintain data models, reporting systems, data automation systems, dashboard and performance metrics, that support key business decisions
- Perform risk management to minimize potential risks including developing contingency plans
- Responsible for conducting joint sessions with different teams like Business Marketing Sales Service Finance to discuss and gather the critical business requirements
- Reviewing designs created by UI designers to ensure that client standards are adhered to in terms of data visualizations on dashboards
- Working along with client-side stakeholders, technical leaders to create process flows, power Bi and excel reports as per the requirements
Senior Project Officer
Benori Knowledge
Gurgaon
04.2023 - 11.2023
- Contribute to the success of the business through strategic thought leadership, optimization, initiatives, driving change and enhancement of skillsets within the team
- Lead complex projects related to planning and resource scheduling
- Monitor the health of the business, track key metrics, analyze trends and provide analytical support to the team and Stakeholders
- Understand parameters & drivers of business processes & convert it into business KPIs
- Predict the resources required in future to manage the transactions, creation of capacity plan to have week on week view of HC
- Preparing the reports and dashboard (excel/power BI) for senior stakeholders
- Reports like, Resource management, Revenue accrual, utilization, Bench management, Invoice analysis
- Effective co-ordination with various stakeholders at regular intervals ensuring desired requirement/output is met Measures of Success
- Partner with business leadership to formulate strategy, mitigate risk & drive results
- Analyzing project as per the client requirement, prepare scoping, Resource planning, & Budgeting
- Deliver required project inputs according to time, quality, and budget requirements
- Ensure progress is accurately communicated and expectations of various stakeholders are managed effectively
- Collaborating with project lead and senior management personnel to develop cost and time estimates for application projects as well as providing technical support related to application usage and maintenance for end-users
Senior PMO
Fidelity International
Gurgaon
08.2021 - 12.2022
- Good leadership and mentoring skills as well as the ability to work well independently and in a cross- functional team
- Created Powershell scripts and VBAs to automate several operational tasks and increased productivity by at least 30%
- Devised unified framework in VBA to clean data from 5+ sources (internal)
- Effective communication and presentation skills with the ability to maintain effective relations with clients, management, and technical staff
- Monitoring overall functioning of processes, identifying improvement areas & implementing adequate measures
- Efficiently managing multiple projects and ensuring regular monitoring and timely delivery
- Review organizational reports & proactively identify risks and deploy mitigation plans
- Ensure audit compliance as per Client requirement for Client Audit
- Preparing and presenting, revenue trend analysis, forecast analysis and sharing with Executive teams
- Conversion of reports and dashboard from excel to power BI representation
- Perform data analysis and generating periodic and ad hoc reports as needed
Project Officer
Evalueserve
Gurgaon
10.2013 - 08.2021
- Develop and implement HR strategies & initiatives aligned with the business strategy
- Handling talent acquisition and ensuring smooth flow and closing the hiring requirements
- Preparing monthly MIS of the department and generating various reports out of it
- Conduct various feedback at regular intervals and share the same with VPs & AVPs to take corrective actions from time to time
- Creating and maintaining monthly/quarterly Dashboards and calculating various Metrics (like, attrition, new hiring, new initiatives, Revenue) etc
- Supporting in business process improvement
- Ensuring daily reports and meeting SLAs
- Conducting analysis and designing dashboards to provide explicit review to senior management which helps them in decision making process
- Monitoring overall function of processes, identifying improvement areas & implementing adequate measures
- Efficiently handle large sets of data and be able to confidently process them into required formats
- Preparing Utilization, group performance dashboard, staffing report for LOB and sharing the details with leadership team
- Analyze business forecasting e.g., utilization, chargeable hours, headcount against budget
- Co-coordinating with AVPs/leadership teams for proper allocation and utilization of the resource and effective bench management
- Ensures that KPIs are met as per the contract and proposals
- Prepare Analysis report and presentation for the Management reviews and Board Presentations
- Maintaining complete traction on all pending receivable revenues from different vendors and regular follow up with internal key stakeholders for better revenue management
MI Analyst
Sitel India Ltd.
Gurgaon
07.2012 - 10.2013
- Preparing daily, Weekly, Monthly, Quarterly, and adhoc report for LOB
- Automated performance report with help of VBA which helped in reviewing of performance in hourly basis
- Responsible for preparing Incentive for the LOB
- Automated agent efficiency report which helped supervisors in analyzing agent’s performance on hourly basis
- Took initiative and created template for Weekly business review and designed PPT which helped in analysis of business with Client
- Automated sales conversion report which captures sales conversion automatically on hourly basis
- Developed and maintained call monitoring sheets so that feedback is shared with agent on time
- Designed VBM dashboard and tool with help of VBA macros to find variation for different parameters
Associate Operations
MetLife Global Operation Support Center
12.2009 - 04.2011
- Worked on incentive reports
- (MetLife Stateside CSC)
- Worked on CBIT (Cognos tool), CMS AVAYA to prepare incentives reports
- Responsible for MIS reporting to client regarding DLM inventory and forecasting
- Analyzing & action planning on daily, weekly & Monthly MIS for the process
- Root cause analysis of any defects in process
- Q.C and monitoring of different reports so that it is completed without any defects
Education
Bachelor of Commerce -
Pune University
01.2006
Intermediate -
C.B.S.E. Board
01.2003
Matriculation -
C.B.S.E
01.2000
Skills
- Advanced MS Word Skills
- Excel Data Analysis Expertise
- Power BI Reporting Skills
- Power BI Data Visualization
- Proficient in PowerPoint Presentations
- Data Analytics Tools
Timeline
Senior Analyst
Morya Group of Companies
12.2023 - Current
Senior Project Officer
Benori Knowledge
04.2023 - 11.2023
Senior PMO
Fidelity International
08.2021 - 12.2022
Project Officer
Evalueserve
10.2013 - 08.2021
MI Analyst
Sitel India Ltd.
07.2012 - 10.2013
Associate Operations
MetLife Global Operation Support Center
12.2009 - 04.2011
Bachelor of Commerce -
Pune University
Intermediate -
C.B.S.E. Board
Matriculation -
C.B.S.E
Similar Profiles
PRIYA S SOUDEPRIYA S SOUDE
Sr. Accountant and Sr. Sales Coordinator at Morya Engine Sales and Service CompanySr. Accountant and Sr. Sales Coordinator at Morya Engine Sales and Service Company
Anushil BhardeAnushil Bharde
Sales Head at Morya Builders and DevelopersSales Head at Morya Builders and Developers
Litto GraciasLitto Gracias
Self Employed Owner at Morya HospitalitySelf Employed Owner at Morya Hospitality