Profile Summary
Business Analytics consultant offering 9+ Years of experience in business strategy, data analysis, visualization, commercial program management, process improvement, and commercial excellence. Led the pricing insights and analytics Project implementation, collaboration, and engagement with teams across the world Well versed with financial modelling and pricing analytics using Alteryx, Tableau, Power BI, SQL and Excel VBA Academic Details
MBA Finance from Indian Institute of Management Rohtak, 2017 Bachelors in Computer Science from Gautam Buddh Technical University, 2011 Organizational Experience
Bekaert Industries
Jul 2021 to Sep 2022
Global Financial Analyst
Global Program Manager for Pricing under the commercial excellence initiative of Steel Wire solutions (SWS) business. Partnered with Sales, Product owners and commercial finance to drive strategic initiatives through use of business analytics. Set up monthly pricing reporting and review process, and brough about increased transparency and visibility on pricing performance and drivers/mix impacts; communicate and review results with divisional senior leadership Established strategic KPIs working with leadership and monitored them in cross comparison with other geographies Translate requirements from commercial teams to technical specifications for developing pricing analysis. Implemented pricing dashboards, worked with cross-functional teams to deploy, and drive utilization of pricing analytics. Single point of contact for the division, related to all things pricing and data visualization development. Previous Experience
Asea Brown Boveri (ABB)
Aug 2018 to Jun 2021
Pricing Specialist – Business Analytics
Worked on design, development, deployment, and maintenance of Pricing Analytics in the Business analytics team of ABB. Managed Pricing Analytics development for the electrical business division of ABB (Revenue ~ USD 12 billion annually). Created comprehensive dashboards and self-serviced reports for pricing and sales performance metrics Developed pricing analytics tools using tableau dashboards for monitoring performance and tactical price improvements. Introduced analytics on Pricing performance using multiple KPIs, mainly NPV, i.e., Price, Volume and Mix variance analysis. Deployed pricing analytics tools in 20 countries across EMEA region, ABB UK, Italy, Germany, UAE, India, China to name a few. Developed analysis on Segments, discounts, peer group analysis, discount misalignments and project order management. Managed extract, transform, and load (ETL) process using Alteryx, SQL, Attunity, to build data pipelines to support automated reporting and solutions.
Consistent Net Price improvement of 2%+ in most countries after deployment of Business analytics Helped Design dashboards for rebate analytics and helped channel managers with recommendations in rebate contracts. Provided trainings and workshops to Sales, Product management and leaders in multiple countries on Pricing analytics tools. Continuous engagements with sales, product managers and leadership to help with ad-hoc analytics-based solutions. Siddhant Bakshi
Scaling new heights of success and leaving a mark of excellence in assignments related to Business Analytics, visualization, commercial excellence, Pricing and revenue management Location: Mississauga, Ontario
******************@*****.*** www.linkedin.com/in/siddhant-bakshi/ +1-647-***-**** Thomson Reuters
Feb 2017 to June 2018
Senior Lead Analyst
Developed pricing optimizer for (price increase) opportunities in the Westlaw and practical law products Created financial models for product team to help them track price trends and sales volume impact. Involved in Financial planning and analysis reporting related activities for UK and Ireland Legal business. Streamlined reporting and introduced automation in several monthly MIS activities, leading to improved utilization. Created financial models and forecasts based on operating metrics as defined by the business. Trained the Financial Planning and Analysis (FP&A) team in Excel VBA programming and Alteryx. Automation of standard monthly reports lead to saving 40 hours of monthly time savings CSC India
Jul 2011 to Jun 2015
System Admin
Perform server administration, maintenance activities, provide customer service and server utilization reports. Providing Level 2 customer support and troubleshooting issues related to Lotus Notes customer accounts and server. Drive daily and weekly service Review Meetings with the service management team as the Product Line specialist. Single Point of contact for cross functional teams on incident management and event management. ITIL V3 Foundation Certified and trained in ITIL practitioners on Service level management Weekly team call with Account Executive for Service Review and discuss service Improvement Plans for failed SLA Coordinate the Root cause analysis (RCA) for the new incidents and creating and publishing procedure documents. Internship
Green Tech Infra Pvt. Ltd., Jaipur
Apr 2016 – May 2016
Responsibilities
Market research of water purification industry for a Water Treatment Solution Created financial models and conducted cost benefit analysis for devising action plans to pitch product in local market IT Skills
Visualization: Tableau, Power BI
Microsoft Office: Expert in Excel, PowerPoint, Word Programming: Excel VBA programming
Database: SQL, Access
ERP: SAP SD, SAP BW, BO, knowledge of SAP tables
STRENGTHS
Focused on Accuracy and attention to detail and teamwork; ability to communicate effectively with people. Excellent presentation, analytical skills, and excellent use of ETL and visualization tools and process management. Extracurricular Activities
Managed as Accounts and Sponsorship activities as the of Accounts and sponsorship team o Budgeting, bookkeeping, and financing activities related to fund utilization for the fest o Creation & negotiation of the contract agreements with partnering organizations for year 2016 & 2017 Event Coordinator – IT Club IIM-Rohtak for smooth execution of events organized by the club Winner of IIM-Rohtak Football League Competition; played as Central midfielder for the team