Himanshu Sharma
Alpharetta,GA
Summary
Extensive experience of 7 years in business operations, designing, describing, and managing solution engineering to match with specific business problems, influencing client relations, project management tools. Analyzing & conceptualizing solutions to align advanced analytics, taking acceptable levels of risk control.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Business Data Analyst
Phoenix Innovations
06.2023 - Current
- Orchestrated solution design processes, aligning technical solutions with business objectives
- Employed advanced SQL queries, including Windows functions, in Snowflake for data extraction & analysis
- Designed & developed interactive Tableau dashboards, visualizing complex data sets
- Managed MS-SQL Server for database administration, ensuring data integrity and security
- Integrated Power BI seamlessly into the analytical workflow for dynamic data visualizations
- Led the successful implementation of the 'Credit and Rebates' project, driving digital transformation and automation in credit tracking processes
- Established a centralized dashboard for efficient monitoring of supplier credits, with a focus on Return Merchandise Authorization (RMA) credits, resulting in streamlined operations, reduced errors, and improved decision-making capabilities
- Conducted impactful price trend analysis to identify preferred suppliers, optimizing procurement strategies and achieving cost savings for the client
- Processed & presented large amounts of data, extracting trends to build hypotheses & convey compelling data-driven stories
- Utilized Tableau features for impactful data storytelling and insight communication
- Created compelling reports and dashboards using Power BI features
- Prioritized business & information needs, ensuring successful product & service delivery in a demanding client setting
- Facilitated requirement gathering among diverse stakeholders, fostering alignment with various needs
- Wrote and maintained user documentation, conducted user acceptance, and training sessions
- Established correlations between disparate data sources, leveraging business knowledge for robust analysis
- Studied business functions, gathering information, and acquiring domain expertise to evaluate output requirements and formats effectively
- Designed & documented business processes & data flows, establishing data pipelines supporting thorough analyses.
Apprentice Leader (Solution Architect)
Mu-Sigma
02.2023 - 05.2023
- Supported clients in data science model development and managed model operationalization cycle
- Created Tableau dashboard displaying different KPIs for flight operations to help make data-driven decisions
- Created ETL process workflows, designed & managed data architecture to streamline data processing & analysis, enabling automation of data workflows and informed decision-making using Alteryx and MS SQL
- As a Scrum Master, I facilitated agile development processes and helped cross-functional teams to deliver high-quality software products on time and within budget, while fostering a culture of continuous improvement and collaboration
Graduate Teaching Assistant
Northeastern University
08.2022 - 12.2022
- Guided by Professor Kate Ashley to help students to understand basics of statistics and data analysis for business
- Held weekly office hours to clarify doubts faced by 50+ students.
Student Success Guide
Northeastern University
01.2022 - 12.2022
- Administer support to first-year undergraduate students joining Northeastern University
- Utilized a new platform to create referrals related to Academic Habits and Career.
Business Analyst
Capgemini
01.2018 - 06.2021
- Identified common traits using clustering techniques in Python and improved user experience by 40% increase
- Worked in Agile software development process for deployment of CR; Effort time estimation using Excel
- Identified key metrics (CTQs and KPIs) that drive the business, ensuring alignment between business objective technical solutions and business performance using standardized & custom reports using Tableau
- Conducted Data Modelling, developed E-R diagram for new requirements using tool System Architect
- Led documentation and gathering of business requirements and translate them into technical requirements, created use cases, functional design, user stories and business processes to ensure development and testing teams are aligned with new functionality for new product development by acting as a liaisons between them
- Organized client demo, training sessions, supported & consulted onsite client and internal stakeholders to ensure understanding of new enhancements for each release cycle, delivering 40+ CRs in a year
- Review and provide feedback and recommendations on testing strategy, test cases, and test plans to ensure complete coverage and tracking of testing process and maintain quality standards.
Senior Analyst
Capgemini
09.2016 - 01.2018
- Forecasted sales of new cars with an accuracy rate of 95% using machine learning using Python
- Developed web application, forecasting the requirements of raw material using HTML, PLSQL and UNIX scripts
- Managed the data modeling for new requirements & removed inconsistent data in databases using SQL queries.
Education
Master of Science in Business Analytics -
Northeastern University
Boston, MA01.2022
Bachelors of Electrical Engineering -
Savitribai Phule Pune University
Pune, India01.2016
Skills
- Report Generation
- Machine Learning
- Business Intelligence
- ETL development
Certification
- Alteryx Designer Core Certified
- Google Data Analytics Professional
- CITI Social and Research Behavior
- AWS Solution Architect Associate (ongoing)
Projects And Publications
- How do bounce rate varies for different e-commerce websites based on products sold?, To study the online consumer behavior, traffic data, bounce rate, SEO using gathering data through Semrush Tool and developed Fixed Effect Model to analyze the effect of products sold on bounce rate in longitudinal marketing panel data of e-commerce websites in R.
- Donaldson Project –Sentiment Analysis (Business Analytics Capstone), Aim of the project is to understand truck and heavy equipment company sentiment for alternative powertrain (battery vehicles, fuel cell etc.) for our client Donaldson. Used the NLP on twitter data using Twitter API for data collection
- Presented a paper at the India Smart Grid Forum Notification for Springer Publication of ISGW 2017., Developed Demonstrative Context-Aware System for Load Demand Analytics: A Case Study in Pune’s Smart Grid.
Bollywood Jazz Dancing
I am a trained Bollywood Jazz dancer and have participated in shows in various conutries
Timeline
Business Data Analyst
Phoenix Innovations
06.2023 - Current
Apprentice Leader (Solution Architect)
Mu-Sigma
02.2023 - 05.2023
Graduate Teaching Assistant
Northeastern University
08.2022 - 12.2022
Student Success Guide
Northeastern University
01.2022 - 12.2022
Business Analyst
Capgemini
01.2018 - 06.2021
Senior Analyst
Capgemini
09.2016 - 01.2018
Master of Science in Business Analytics -
Northeastern University
Bachelors of Electrical Engineering -
Savitribai Phule Pune University
Similar Profiles
Greg HolmesGreg Holmes
Press Operator/Cutter Operator at Phoenix InnovationsPress Operator/Cutter Operator at Phoenix Innovations
Tejaswini PillalamarriTejaswini Pillalamarri
Manager, Analytics at Phoenix Innovations LLCManager, Analytics at Phoenix Innovations LLC
Kamdjeu LambertKamdjeu Lambert
Warehouse Forklift Operator at Dessert Innovations/Trulli Fresh Innovations BakerWarehouse Forklift Operator at Dessert Innovations/Trulli Fresh Innovations Baker
Janet HippJanet Hipp
Sr. Executive Assistant at HP, Inc.Sr. Executive Assistant at HP, Inc.
Jack WilsonJack Wilson
Produce Clerk at PublixProduce Clerk at Publix