LG Electronics

•Managing Financial Planning & analysis of Service department for MEA region.
•Responsible for setting up company target and analyzing company's service department financial performance
•Present monthly budget vs actual variance analysis to department leaders (CFO & MD), identifying opportunities to reduce expenses and increase GP margin
•Prepare 3 & 5 year long term budget, yearly budget, and monthly forecast.
•Managing distribution cost (Service-related payout- scheme wise, product wise & service level wise)
•Managing and monitoring Key Performance Indicator
•Provide accurate and timely financial information to management, relevant functional managers, and auditors
•Assemble data, analyze performance, identify trends and develop recommendations to support Project Management planning and operations
•Business partnering with stake holder to achieve budget for service department.
•Business Intelligence -Implemented Power BI reporting for MEA region in Financial Transformation project.
•Prepared several financial reporting dashboard (Financial Modeling, Revenue Dashboard, CFO Dashboard, Ratio Analysis) as per CFO and MD requirement.
•Data Analysis -Using Power BI, SQL & MS Access tools for data analysis, which is help to improve P&L profitability and strategy making.

Senior Financial Analyst

Landmark Group

▪ Supporting FP&A for Food & Beverage division spread across UAE, KSA, Qatar & Kuwait
▪ Consolidate and analyze financial data (budgets, income statement forecasts etc.) considering company’s goals and financial
standing
▪ Report on financial performance and prepare for regular leadership reviews
▪ Analyze past results, perform variance analysis, identify trends, and make recommendations for improvements
▪ Work closely with the accounting team to ensure accurate financial reporting
▪ Evaluate financial performance by comparing and analyzing actual results with budget and forecasts
▪ Guide the cost and revenue analysis process by establishing and enforcing policies and procedures
▪ Provide analysis of trends and forecasts and recommend actions for optimization
▪ Recommend actions by analyzing and interpreting data and making comparative analyses; study proposed changes in methods and
materials
▪ Identify and drive process improvements, including the creation of standard and ad-hoc reports, tools, Excel and power BI
dashboards
▪ Increase productivity by developing automated reporting/forecasting tools
▪ Perform market research, data mining, business intelligence, and valuation comps
▪ Maintain a strong financial analysis foundation creating forecasts and models

Finance Analyst (F&B Business)

Vodafone Idea Limited

Responsible for Revenue Forecast, Budgeting & Forecasting and analysis for Punjab Circle contributing 1.10 Bn/ month. 
Tracking actual vs. budgets/forecasts on monthly basis and submitting Rolling Forecast to Corporate on monthly basis. 
Performing detailed cost analysis by function to help functional heads to control cost. 
Manage product mix based monthly market intervention activities to achieve higher market penetration to sustain RMS (Revenue Market Share) leadership throughout the year.
Prepare & Submission of Business Review meeting (BRM) Report to National Business analyst team on weekly basis. 
Responsible for handling the annual operating plan for mobility line of business.
Preparing Monthly/Rolling Flash & Forecast and key performance matrices for Profit & Loss line items based on the functional inputs and current trends.
Providing Variance Analysis between planning period and AOP (Budget) for Revenue Segment.
Monthly and quarterly variance analysis and communication of the same to the functions and Corporate.
Preparation of Daily Business Reports i.e. Subscriber Report, Revenue Report, and KPI tracking. Miscellaneous business reports for Management i.e. Financial Report, Operational Report, and Revenue Variance report. Providing analysis and support for business reviews.
Business Analysis on daily business reports i.e. Subscriber and Revenue Report. Sharing of Monthly P&L, CWN, and Zonal Reports to all stakeholders. Sharing of weekly Financial Reports i.e. Post launch Products evaluation, Competition Analysis.
Business Presentations for COO/MD review. Business Analysis as per Management requirement and update to Management for circle performance with highlight on focus areas for further improvement.
Analysis & Update to COO for weak markets, Identification of low Revenue Products.  
Punching Non-Financial KPI & Financial KPI in HYPERION FINANCIAL MANAGEMENT.
Data Modeling & Data extracting from Cognos Business Intelligent Server.

Assistant Manager - Management Intelligence (Financial Analysis & Planning)

Venus Remedies Limited

Developing, Implementing and monitoring of score board / Dash Board / Performance Metric Management.
Definition and management of business reporting, business analysis, management of sales and channel performance.
Analysis of comparatives market between region & circle to identify trend.
Identification, analysis and modeling of sales data, including identifying trend and correlation between data set.
Participation / management of sales oriented project that involved cross functional coordination for provide integrated reporting solution.
Produce intelligent monthly, quarterly management reporting for high level discussion and meetings.
Automation of reporting for easy of information gathering.
Setting and tracking key performance indicator (KPI) of the sales team.
Slide presentation (Management Decay) for monthly business review for corporate level, management documenting business status, performance and pending business initiatives.
Calculation of deviation beetween plan working and actual working.

MIS Manager

airtel

•	Revenue Projection: Preparation of revenue projection for all the four circles for Mobility & Telemedia.
•	AT & CR RATE Tracker: Preparation of projected Airtime & customer rate for all circles & related analysis for revenue planning.
•	PF & FAT Tracker: Preparation of projected Processing Fee & Free airtime (FAT) for mobility on weekly basis.
•	Preparing Flash & Forecast every month, for proper planning & mid month performance 
evaluation for all units (Mobile, Telemedia & DTH).
•	Expertise in COGNOS application for the preparation of Flash & Forecast.
•	Preparation Annual Operating Plans (AOP) Telemedia & Mobile business for the circle.

Business Planning Analyst

Financial Planning & Analysis, Budgeting & Forecasting, Financial Report, Variance Analysis.
Expertise in managing operation with key focus on data analysis, dash board, score board, competitive analysis, planning & review
Team player who enjoys interacting with both technical and business oriented people.
Business / data analysis, strong analytical skills, understanding how to interpret customer business needs and translate then into application. 


Taplio

Prateek Sharma's Linkedin Analytics

Prateek Sharma

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Prateek Sharma's Linkedin Analytics

Prateek Sharma

Want to drive more opportunities from LinkedIn?

Prateek Sharma's Linkedin Analytics