SANCHI SHARMA
Business Intelligence
Delhi
Summary
Prudent Business Intelligence Analyst with 10+years providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keen support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.
Overview
15
15
years of professional experience
Work History
Hilti India Pvt Ltd
01.2018 - Current
- Engaged in extensive collaboration with stakeholders from various business units (Finance, Marketing, HR & Sales) to effectively capture reporting requirements that align with organizational goals and objectives
- Subsequently, developed interactive business dashboards and performance cockpits that provide a comprehensive overview of the organization's health and effectively showcase the performance of key performance indicators (KPIs)
- Create efficient SQL procedures that extract the necessary data and generate customized reports, resulting in streamlined reporting workflows
- Create data models in Power BI to establish relationships between different data sources, enabling efficient data analysis and exploration
- Use DAX (Data Analysis Expressions) to develop calculations, measures, and KPIs that provide deeper insights into the data
- Developing impactful dashboards utilizing the data visualization tool SAP Analytics Cloud (SAC)
- Additionally, managing and identifying data sources using platforms like SAP BW, BW4/HANA, and other relevant technologies.
British Telecom
08.2015 - 01.2018
- Consolidate financial performance and conduct variance analyses (Actual Vs Forecast)
- Conduct monthly reviews with Business Support managers to address variance issues and identify forecast opportunities
- Create monthly P&L and provide variance analysis for management review with the reasoning
- Improve financial status by analyzing results and variances; identifying trends; recommending actions
- Pulling Hyperion reports as per business support requirement
- Interact with LOB’s on daily basis via phone calls or e-mails to provide updates of current work status
- Research and resolve Business Unit(s) inquiries for assigned functional areas
- Extract & Analyse massive and highly complex data sets, performing data manipulation and data reporting using systems SAS, Oracle, Essbase, Hyperion and various Mannual files in different formats
- Part of Let’s simplify team - Automating and simplifying by coordinating and working with respective report owners.
EXL Services
09.2012 - 08.2015
- Gathering, analyzing, preparing and summarizing recommendations for SG&A expense plan numbers
- Analysing the Variance/Movement in Expense on MoM & YoY basis to be presented to the top management for decision making
- Formulating forecasts and conducting variance analysis to determine difference between plan & actual expenses
- Preparation of FTE analysis report to be presented to the top management at Organization Level on weekly basis
- Prepartion of Organization hierarchy by using Essbase
- Helping clients in SOX and audit requirements
- Interaction with various business owners on a daily basis and caters to any adhoc requests
- Take lead on Automation Project given by Onshore
- Reviewing the components that are to be delivered to the client.
Aon Hewitt
01.2009 - 09.2012
- Month End activities
- Calculate commission for sales executives and ensure timely delivery of the commissions statements of 40 different locations
- Update Ms Access queries on the basis of changes incorporated in commission calculation
- Virtually Transitioned a new process, Complink for Hewitt
- Involve in testing phase of the process (UAT testing) with technical team
- In the absence of an Operation Manager, taking the feedback calls with the Hewitt stateside team regarding the performance of the associates in the team
- Conduct training workshops and designing training modules related to products and procedures
- Created and facilitated training programs for new joiners’ and on floor team members
- Creating and maintaining reports for capacity utilization (MIS) such as Quest Report, Utilization Report, Audit Score Card, MIS Report, etc
- And communicating the same to the managers.
Education
CFA -
Institute of Chartered Financial Analysts of India
Bachelor in Commerce - undefined
P.G.D.A.V College, Delhi University
Skills
Information Flow
Database Management
Business Analysis
Data dashboard design
Data Warehousing
KPI Monitoring
Data Analysis
Advanced Excel
SQL Programming
Timeline
Hilti India Pvt Ltd
01.2018 - Current
British Telecom
08.2015 - 01.2018
EXL Services
09.2012 - 08.2015
Aon Hewitt
01.2009 - 09.2012
CFA -
Institute of Chartered Financial Analysts of India
Bachelor in Commerce - undefined
P.G.D.A.V College, Delhi University