Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Languages
Timeline
Generic
Subham Tripathi

Subham Tripathi

Bengaluru

Summary

Goal-oriented professional successfully assists companies by developing and implementing updates to operational standards, team organization and employee engagement strategies. Proactive and personable leader with top-notch skills which includes Python, SQL , and Tableau in streamlining information, prioritizing tasks and approaching issues with analytical mindset. Bringing 8.5+ years of experience and demonstrated track record of success.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Lead Consultant

Allstate Solutions (ASPL)
06.2022 - Current
  • Provided comprehensive data analysis and visualization to senior management, offering strategic insights to support business expansion and market penetration strategies.
  • Collaborated with cross-functional teams, developing innovative strategies to achieve desired outcomes.
  • Worked with business stakeholders to gather project requirements for analytics use cases utilizing technologies such as DBT, Python, and SQL.
  • Successfully led a team of junior data analysts to synthesize reports based on data analysis and present findings across departments.
  • Developed and standardized Python-based data cleaning and testing procedures resulting in significant time savings of 4-5 hrs.
  • Developed insights, data visualizations, and monthly reports for management and key stakeholders. Translated complex data models into understandable written narratives to fulfill ad hoc information requests, resulting in a 12% increase in product sales through market and exploratory analyses.
  • Managed end-to-end interviewing procedures, streamlined onboarding processes, and implemented effective training strategies for an accomplished development team.

Consultant

KPMG Global Services
01.2021 - 06.2022
  • Worked as a consultant and handle multiple projects related to Finance domain
  • Mentored and trained junior analysts in advanced data analytics techniques using Tableau and Python, enhancing team capabilities and fostering a culture of continuous learning and development.
  • Delivered Tableau and Einstein Analytics training to different teams
  • Developed proof of concept and completed a business intelligence project utilizing Tableau CRM (Einstein Analytics).
  • Collaborated with prominent finance domain clients to assess business needs and craft functional requirements specifications, leading to the development and implementation of effective solutions
  • Collaborated with clients to develop targeted documentation, specifications, and resources for effective analysis of business data.
  • Designed and implemented integration solutions for combining data from multiple sources such as AWS S3, Oracle NetSuite, Postgres, and SQL Server.
  • Built automated workflows using Alteryx Designer for extracting, transforming, loading of large volumes of data from multiple sources into a single repository.

Data Analyst

Siemens Limited
05.2019 - 01.2021
  • Developed a comprehensive Dashboard for the CEO and senior management at Siemens India.
  • Led cross-functional team in developing and deploying automated data workflows with Alteryx, resulting in a 20% reduction in operational costs and increased data processing efficiency.
  • Extracted, manipulated, and analyzed large datasets from CRM systems and transaction databases using SQL queries to maintain data integrity and accuracy
  • Collaborated with cross-functional teams to enhance sales claims forecasting accuracy by 20% through the development of predictive models utilizing Python's Timeseries and Regression algorithms.
  • Directed data transformations and transitions using Alteryx and KNIME
  • Implemented end-to-end Business Intelligence (BI) projects, with a focus on scorecards, KPIs, reports, and dashboards.
  • Translated ad hoc requests and requirements, delivering impactful results by interpreting data.

Tableau Developer

Wipro
04.2016 - 04.2019
  • Utilized technical skills in Excel, Tableau, and SQL as a business analyst to provide enhanced insights to the company.
  • Developed Tableau dashboards for actionable insights on bench management, resulting in a 15% reduction in bench strength.
  • Deployed Tableau Server security settings including authentication methods, permissions, row-level security settings.
  • Performed unit testing on all created reports and dashboards prior to production deployment.
  • Managed the entire life cycle of projects from design and development through implementation and maintenance.
  • Developed complex calculations using Tableau functions such as LOD expressions and table calculations.
  • Assisted in designing and developing ETL processes to extract data from multiple sources into a single repository for analysis in Tableau.

Education

B.Tech/B.E. -

Future Institute of Engineering And Technology
Bareilly
04-2014

12th -

Kendriya Vidyalaya
04-2010

10th -

Kendriya Vidyalaya
04-2008

Skills

  • Tableau
  • SQL
  • Excel
  • Python
  • KNIME
  • Alteryx
  • Einstein analytics
  • DBT
  • Machine Learning

Certification

  • Data Science Master Certification
  • Tableau Desktop Specialist
  • Alteryx Designer Core

Accomplishments

  • RISING STAR- For being a quick learner and delivering excellent results in Year, 2020. We value and appreciate your exceptional performance and contribution at Siemens.
  • Got appreciation for contributing in the COVID19 Project and HR PAYROLL MIGRATION Project from senior management.
  • RISING STAR- For being a quick learner and delivering excellent results in Q3- 2021. We value and appreciate your exceptional performance and contribution at KPMG.
  • Zero Defect Delivery achieved for clients ??? Global Client. Got appreciation from the Leads for the same.

Languages

  • HINDI
  • ENGLISH

Timeline

Lead Consultant

Allstate Solutions (ASPL)
06.2022 - Current

Consultant

KPMG Global Services
01.2021 - 06.2022

Data Analyst

Siemens Limited
05.2019 - 01.2021

Tableau Developer

Wipro
04.2016 - 04.2019

B.Tech/B.E. -

Future Institute of Engineering And Technology

12th -

Kendriya Vidyalaya

10th -

Kendriya Vidyalaya

Similar Profiles

CREATE PROFILE
Subham Tripathi