Summary
Overview
Work History
Education
Skills
Affiliations
Tools Used
Awards
Work Availability
Quote
Timeline
Generic
Rakesh Solanke

Rakesh Solanke

Data Analytics, Data Architect, Financial Planning And Analysis
Pune

Summary

Talented Manager with expert team leadership, planning, and organizational skills built during successful career. Smoothly equip employees to independently handle daily functions and meet customer needs. Diligent trainer and mentor with exceptional management abilities and results-driven approach. Collaborative leader with dedication to partnering with coworkers to promote engaged, empowering work culture. Documented strengths in building and maintaining relationships with diverse range of stakeholders in dynamic, fast-paced settings. Strong leader and problem-solver dedicated to streamlining operations to decrease costs and promote organizational efficiency. Uses independent decision-making skills and sound judgment to positively impact company success. Personable business professional bringing successful 18 years career in financial roles within large and fast-paced corporations. Release-planning specialist trained in advanced Excel modeling. Creative solutions architect with real-time problem-solving flexibility.

Overview

20
20
years of professional experience

Work History

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

Manage Project Professionally -

PMCC Bengaluru

Post Graduate Diploma in Business Administration with specialization in Financial Management - undefined

Symbiosis CDL Pune

Bachelor of Commerce - undefined

J G College of Commerce Hubballi

Skills

Budgeting, Forecasting & Variance Analysisundefined

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 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

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

Manage Project Professionally -

PMCC Bengaluru

Post Graduate Diploma in Business Administration with specialization in Financial Management - undefined

Symbiosis CDL Pune

Bachelor of Commerce - undefined

J G College of Commerce Hubballi

Similar Profiles

CREATE PROFILE
Rakesh SolankeData Analytics, Data Architect, Financial Planning And Analysis