Rakesh Solanke
Data Analytics, Data Architect, Financial Planning And Analysis
Pune
Summary
Seasoned Project Management Professional (PMP) with expertise in financial planning and analysis, data management, business excellence, presales, project management and program management. Excellent leadership, planning, and organizational skills built during successful career stints at various fortune 500 companies. Collaborative leader with dedication to partnering with coworkers to promote, engage, empowering work culture. Documented strengths in building and maintaining relationships with diverse range of stakeholders in dynamic world. Bringing successful 18 years career in financial, business & project roles within large public and private companies.
Overview
21
21
years of professional experience
7
7
years of post-secondary education
Work History
Senior General Manager Finance
Johnson Controls
Pune, Maharashtra
08.2024 - 02.2025
- Conduct month-end close process of 7 entities, driving an annual revenue of $22.95 billion.
- Oversee finance department operations, optimize company capital, and ensure cash flow is managed efficiently.
- Evaluate current financial operational data and information and report findings to the CFO.
- Transitioned the Power BI dashboards and reports for FP&A team and setup the systems, process.
- Contributed in Annual planning, budgeting, forecasting by sharing outlook and actuals data.
- Allocate resources & assign tasks to make sure the team is performing to support FP&A stakeholders.
- Evaluated market trends and competitor activities for informed decision-making on pricing strategies, product development opportunities, and overall business direction.
- Championed customer-centric approaches for better service delivery, resulting in increased client retention rates and positive brand reputation.
- Drove revenue growth with targeted marketing campaigns designed to increase brand awareness among potential customers.
- Built strong relationships with key stakeholders both internally and externally to foster collaboration on mutually beneficial initiatives.
Senior Data Analyst / Business Analyst 3 /Financial Analyst
Red Hat India Pvt Ltd
11.2018 - 02.2024
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
- Created and automated data visualizations to present insights and tell compelling stories.
- Assessed large datasets, drew valid inferences and prepared insights in narrative or visual forms.
- Leveraged text, charts and graphs to communicate findings in understandable format.
- Interpreted business questions and collaborated with engineering teams to identify data sources.
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
- Developed and implemented data collection systems and other strategies to optimize statistical efficiency and data quality.
- Managed key tasks and resources to achieve cost, schedule and strategic growth initiatives.
- Identified, reviewed and evaluated data management metrics to recommend ways to strengthen data across enterprise.
- Developed and implemented data governance policies and procedures.
- Identified patterns and trends in large data sets and provided actionable insights.
- Utilized data visualization techniques to present and explain complex data sets.
- Implemented business intelligence solutions to increase operational efficiency.
- Generated standard and custom reports to provide insights into business performance.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Created data models to support decision-making processes.
- Generated ad-hoc reports to evaluate specific business requirements.
- Optimized data access and storage to improve performance of analytics systems.
- Developed and maintained data warehouses and data marts to support business operations.
- Developed complex dashboard and reporting tools to track business performance metrics.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Created dashboards to monitor and track key performance indicators.
- Designed and developed data pipelines to acquire, clean and process data.
- Deployed predictive analytics models to forecast future trends.
- Assisted with creating data cubes and OLAP models to improve data analysis.
- Developed data mining algorithms to identify and classify patterns in data.
- Provided technical support for troubleshooting analytics and reporting issues.
- Collaborated with stakeholders to identify business needs and data sources.
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
- Analyzed open orders, backlog, and sales data to provide sales team with insights.
- Conducted interviews with key business users to collect information on business processes and user requirements.
- Improved business direction by prioritizing customers and implementing changes based on collected feedback.
- Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
- Executed analysis of risks and identified risk mitigation strategies.
- Surveyed clients to ascertain requirements and expectations for product.
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
- Drafted reports on company financial metrics to assess successes and account for deficiencies.
- Collaborated with stakeholders to define project objectives and criteria.
- Delivered analysis of market, sales and consumer trend impact on long and short-term strategies.
- Performed gap analysis to identify areas of improvement.
- Assessed business requirements to forecast annual budgetary operational costs.
- Generated business intelligence reports to inform strategic decision-making.
- Collected data and developed detailed spreadsheets to identify trends and create revenue, profitability, and expense forecasts.
- Reviewed financial reports and streamlined operations to increase productivity and company profits.
- Collected data from other divisions to support quarterly forecasts.
- Provided strategic planning advice and financial oversight for corporate stakeholders.
- Developed and implemented financial models to analyze complex information and assess health of organization.
- Used relevant financial technology to generate reports and recommended courses of action to upper management.
- Assisted in preparation of presentations, data tables and other documents for investor meetings.
- Monitored market trends and news to identify emerging opportunities.
- Created and maintained precise and accurate models, charts and reports.
- Developed financial models to assess potential investments and identify potential risks.
Senior Financial Analyst FP&A – Supply chain projects & Ops
Target Corporation India Pvt Ltd
03.2017 - 09.2017
- Finance lead of supply chain division driving financial analysis and reporting to help smooth in-store customer experience and improve supply chain efficiency
- Report performance of key business drivers for plan vs actual and prior year
- Write business commentary & insights to help aid business decision
- Financial Planning and Analysis of US retail business forecasting down to store and distribution centre / fulfilment centre level
- Periodic reporting to Senior Management and Supply chain business leaders
- Plan compensation and report payroll hours productivity & volume
- Perform quarterly P&L closing with detailed budgeting forecasting analysis within established timelines and report business performance
- Migrate reports from Hyperion essbase to MSBI SQL server and SSAS
- End to end finance business analytics and complete FP&A projects
- Administered financial strategy of ten divisions & six locations of US
- Developed and implemented forecasting system improving activity level forecasting with collaboration of project managers
- Developed detailed profitability analysis by category by SBU to understand customer behaviour and develop strategic P&L improvement strategies.
Business Excellence Analyst1 – Asia Technology Centre
Unisys India Pvt Ltd
02.2016 - 01.2017
- Team lead for Asia Technology centre to support financial and business operations activities for three countries representing US $95 million in annual gross cost
- Lead operations team to support collection consolidation and compliance of data from the Regional Business Units (RBUs) to produce the annual corporate strategic plan and track business performance
- Preparation of cost analysis for APAC Business Leaders with review of intellectual rights and indirect & technical allocations
- Delivered project to design develop & deploy dynamic & interactive excel dashboards operational scorecards ad hoc and canned reports based on requirements using excel VBA and formulas / excel queries
- Completed project to develop tableau dashboard to view operations cost.
Sr. Financial Analyst FP&A– Honeywell Process Solutions
Honeywell Technology Solutions
11.2010 - 01.2016
- Project lead for financial planning and analysis of six APAC countries supporting Sales & Cost functions of business in excess of US $700M turnover
- Lead the month/quarter end process which involves P/L analysis reporting business performance & variance analysis to business partners as well as WW finance
- Finance Business partner to APAC business head
- Preparation of quarterly forecasts 5 Year plan (STRAP) and Annual Operating Plan (AOP) with monthly & YTD actuals as maintained by regional Accounting teams
- Detailed forecasting, planning and analysis of line of business revenue streams and establishing stretch but achievable business targets.
Senior Executive F & A IBM FP&A & Intercompany
IBM Global business services Pvt Ltd
05.2008 - 10.2010
- Estimate budget & get funding of headcounts in tech projects
- Create Intercompany agreements between IBM subsidiaries.
Finance Manager
Space Concepts Bengaluru
03.2007 - 04.2008
Accountant
Renuka Associates Hubballi Karnataka
05.2004 - 12.2007
Education
Project Managment Professional (PMP) Certification - Project Management
Project Management Institute
United States Of America 04.2024 - 04.2027
Post Graduate Diploma - Financial Management
P G Diploma in Business Administration
Pune 06.2011 - 05.2012
Bachelor of Commerce - Commerce
J G College of Commerce - Karnatak Univerity
Hubballi Karnataka India 06.2021 - 05.2024
Skills
Budgeting, Forecasting & Variance AnalysisBusiness Analysis / Business Performance ManagementFinancial Control / Financial Modelling / Statistical AnalysisFinancial Reporting / Investment ManagementProject Management / PMO / Data Science / Data analyticsData Visualization / Big Data
ETL Processes
Algorithm Development
NoSQL Databases
Python Programming
Data Warehousing
Data Security
Advanced Analytics
Machine Learning
Statistical Modeling
Advanced Excel
Business Intelligence
Requirements Analysis
Systems Analysis
Strategic Planning
Data Modeling
System Development
Data Mapping
Data Mining
Risk Assessment
Model Development
Project Management
Gap Analysis
Workflow Analysis
KPI Tracking
Predictive Modeling
Tableau
Technical Design Documentation
Stakeholder Communication
Adaptability
Intelligence Analysis
Task Prioritization
Reliability
Financial Management
Continuous Improvement
Financial Data Analysis
Relationship Building
Data Synthesizing
Market Analysis
Process Development
Business Process Mapping
Business and financial acumen
Financial data assessments
Financial database proficiency
Business understanding
Master Data Management
Data optimization
Financial data interpretation
Financial data analysis
Financial expert
Data integrity
HRIS database management
Financial approvals
Affiliations
- Project Management Institute USA
- Symbiosis CDL Pune, India
- JG College of Commerce Hubballi Karnataka
Tools Used
- Oracle ERP
- SAP ERP
- Hyperion Planning
- Cognos TM1
- MSBI SSAS
- Power BI
- VBA
- Tableau
- Business Objects BI
- SAS enterprise guide–Teradata
- Redshift
- Salesforce
- Hyperion Financial Management
- Concur
- SQL
- Excel VBA
- Hyperion Brio explorer
- SQL server assistant
- Siebel
- PeopleSoft
- Tally
- Jira
Awards
- Individual Excellence Award at Honeywell
- Promoted to Senior Financial Analyst at Honeywell
- International Assignments
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins
Timeline
Senior General Manager Finance
Johnson Controls
08.2024 - 02.2025
Project Managment Professional (PMP) Certification - Project Management
Project Management Institute
04.2024 - 04.2027
Bachelor of Commerce - Commerce
J G College of Commerce - Karnatak Univerity
06.2021 - 05.2024
Senior Data Analyst / Business Analyst 3 /Financial Analyst
Red Hat India Pvt Ltd
11.2018 - 02.2024
Senior Financial Analyst FP&A – Supply chain projects & Ops
Target Corporation India Pvt Ltd
03.2017 - 09.2017
Business Excellence Analyst1 – Asia Technology Centre
Unisys India Pvt Ltd
02.2016 - 01.2017
Post Graduate Diploma - Financial Management
P G Diploma in Business Administration
06.2011 - 05.2012
Sr. Financial Analyst FP&A– Honeywell Process Solutions
Honeywell Technology Solutions
11.2010 - 01.2016
Senior Executive F & A IBM FP&A & Intercompany
IBM Global business services Pvt Ltd
05.2008 - 10.2010
Finance Manager
Space Concepts Bengaluru
03.2007 - 04.2008
Accountant
Renuka Associates Hubballi Karnataka
05.2004 - 12.2007