Summary
Overview
Work History
Education
Skills
Timeline
Generic

Shrusti Kanamadi

San Jose,CA

Summary

Dynamic Lead Business Consultant with a proven track record at o9 Solutions, adept in complex data transformations and mentoring teams. Excelled in enhancing business processes and implementing digital transformations, significantly boosting efficiency. Skilled in SQL, Hadoop, and fostering team development, consistently delivering solutions that drive company success and client satisfaction.

Overview

8
8
years of professional experience

Work History

Lead Business Consultant

o9 Solutions
03.2022 - 01.2023
  • Managed a team of 4 to successfully complete project requirements using mPower, SSIS and SQL
  • Trained 3 members of the team to become fully competent in SQL, SSIS and mPower
  • Consolidated and supervised the resource management throughout the company to train for a management position

Senior Business Consultant

o9 Solutions
04.2018 - 03.2022
  • Analyzed and interpreted data to determine any problems or areas that need improvement
  • Conducted assessments and counselled clients regarding controls, risks, process issues and productivity inefficiencies
  • Devised processes to boost long-term business success and increase profit levels, for example, reducing the run times of long running SSIS procedures by hours, thus saving the company time and resources
  • Set, enforced and optimized internal policies to maintain responsiveness to demands
  • Streamlined operations by delivering recommendations for knowledge-based processes and procedures
  • Solved supply chain problems for distinguished clientele, e.g., Wal-Mart, Del Monte, Party City, Pepsi Co., Starbucks, Bridgestone, etc
  • Built automated data analyzing and transforming packages and integrated them with the company platform
  • Planned, oversaw and executed the entire SSIS projects for Wal-Mart, Canada, Starbucks, AsianPaints Procurement and Wal-Mart, US
  • Documented essential problem-solving techniques and detailed steps to the same
  • Learnt and headed HADOOP based integration on Visual Studio for Wal-Mart, Canada
  • One of the first people to learn and lead Hive based integration company-wide
  • Resolved tough and expensive problems while switching from SQL Server based integration to Hive based integration
  • Saved the company time and money by hashing out issues within the integration by involving proper channels and diligently pursuing the solution
  • Led a company-wide training program for juniors and staff to train them on Supply Chain Solver and SSIS

Business Consultant

o9 Solutions
07.2015 - 04.2018
  • Successfully contributed to project teams through the following activities: product design and development, test of design prototypes, preparation of specifications, process capability studies, research investigations, report preparation, and process/test documentation
  • Learnt and mastered mPower, the company platform, within 2 months
  • Implemented and solved sales planning and Demand Planning for AsianPaints
  • Built SSIS packages using SQL, SQL Server from scratch for Demand Planning and Sales Planning for AsianPaints
  • Helped build SSIS packages for data transformation and data analysis for multiple other projects
  • Solved sales and operation problems for multiple clients, e.g., AsianPaints Sales Planning, Restoration Hardware, AsianPaints Procurement, AsianPaints CRM, AsianPaints Sales and Operation, etc
  • Customized and visualized data presentation on the company platform
  • Wrote and executed JavaScript based WebAPI’s from scratch to facilitate a smooth client interaction with the company website
  • Learnt and mastered JavaScript and WebAPI within 3 months
  • Mastered SQL, SQL Server, SSIS, mPower and Data Analytics

Education

Bachelor’s - Electronics and Communication

National Institute of Technology
Karnataka, India

Skills

  • Complex data transformations
  • Data Operations Abilities
  • MS Office
  • Data analysis
  • JavaScript
  • Web API Integration
  • SQL
  • SQL Server
  • Python
  • SQL Server Integration Services
  • Visual Studio
  • Big Data
  • Hadoop
  • Hive
  • Supply Chain Solver
  • IBPL
  • mPower
  • Root Cause Analysis
  • Process Improvement
  • Demand Planning
  • Supply Planning
  • Procurement planning
  • Execution and distribution planning
  • Problem solving
  • Mentoring and training
  • Strategy Realignment
  • Rapid Visualization
  • Data analytics
  • Digital transformation
  • Business analysis
  • Cost reduction
  • Planning and execution
  • Staff mentoring

Timeline

Lead Business Consultant

o9 Solutions
03.2022 - 01.2023

Senior Business Consultant

o9 Solutions
04.2018 - 03.2022

Business Consultant

o9 Solutions
07.2015 - 04.2018

Bachelor’s - Electronics and Communication

National Institute of Technology
Shrusti Kanamadi