Hello!

I'm Saurabh Tripathi



A Data Analyst

My works

Name: Saurabh Tripathi

Job Role: SQL Developer & Data Analyst

Experience: 4+ Years

Address: Noida, India

Skills

SQL 95%
PYTHON 85%
Data Visualization 90%
Statistical Analysis 85%
Problem Solving 75%

About

About Me

  • Experienced Data Analyst with 4+ years of expertise in transforming complex datasets into actionable business insights, driving strategic decision-making processes.
  • Proficient in analyzing Sales & Marketing databases, including Customer Master, Market Data, Sales Data, and Sales Force Data, ensuring data integrity and accuracy through rigorous validation.
  • Strong knowledge of SQL and Data Ware-housing with a proven track record of generating dynamic reports and dashboards to evaluate business performance and key KPIs.
  • Adept at collaborating with cross-functional teams and presenting data-driven insights to stakeholders for informed decision-making.
  • Specialized experience in pharmaceutical commercial operations, providing critical insights into market trends, sales strategies, and customer behavior.
  • Recognized for excellent analytical and problem-solving skills, coupled with clear and effective communication to convey complex data insights.

    • Profile: ETL Developer & Data Analytics
    • Domain: Retail, Pharmaceutical Data & Marketing Data
    • Education: Bachelor of Technology
    • Language: English, Hindi
    • BI Tools: Microsoft Power BI, Microstrategy & Tableau
    • Other Skills: Cloud, Python, Excel, Github & Sql
    • Interest: Traveling, Coding

    • 0 +   Projects completed

    LinkedIn

    Resume

    Resume

    Seasoned Data Analyst and specialized in transforming complex data into actionable insights that drive strategic decision-making. Leveraging my expertise in Python, SQL, Tableau, MicroStrategy, AWS, Spark, and Big Data, I create automation solutions that streamline processes and enhance data reliability. My role also involves managing and resolving data incidents to ensure accuracy and operational continuity.

    With a strong foundation in data analytics, I am aspiring to advance my journey toward becoming a Data Scientist. I am particularly focused on deepening my skills in machine learning and artificial intelligence to deliver even more sophisticated, predictive insights. I’m passionate about harnessing the power of analytics to tackle challenges, fuel innovation, and contribute to intelligent, data-driven strategies.

    Experience


    Oct'21-Present

    Data Analyst

    TECH MAHINDRA LTD.

    • Successfully executed multiple end-to-end projects involving Incentive Compensation, Sales Crediting, Goal Setting, Alignment, and Placement, delivering actionable insights to support business decisions.
    • Collaborated with onshore and offshore teams to ensure high-quality deliverables were consistently produced within the anticipated timeframes.
    • Partnered with the Commercial Model Design and Operations Tech Pod to streamline data flows.
    • Managed the end-to-end data lifecycle, including requirements gathering, developing functional specifications, designing workflows, and coordinating with stakeholders.

    Apr'21-Oct'21

    Engineer 1

    CONGRUEX ASIA PACIFIC LLP

    • Planning and implementing various analyzing techniques to get data for Fiber placement areas.
    • Worked on Designing Fiber placement structures for particular area using Auto-cad for planning and final implementation.
    • Prepared structured sheets for Layout design and Traffic control Planning to reduce manual efforts and Government intervention during implementation.
    • Performed 200 Qc's on various designs and sheets to reduce cost and counts of structures.
    • Uses Advance Excel, CGIS software and FROG Software to complete data Analysis and designing in very less time.



    Education


    2017-2021

    Bachelor of Technology

    M. M. M. U. T. University Gorakhpur

    Grade: 7.99

    2015-2016

    Higher Secondary School

    N.L.K. Kanpur

    Grade: 92%

    Download CV

    Projects

    Projects

    Below are the Sample projects involved data and web Development works.

    Covid Insights Project

    This project features a detailed data analysis of COVID-19 trends, built with SQL and Tableau. The dashboard visualizes key metrics such as confirmed cases, deaths, and vaccination progress, enabling a comprehensive understanding of the pandemic’s impact. Dive in to explore dynamic visualizations and interactive insights!

    Education Gallery Website

    An end to end website where users can get the resources for their career growth, developed this website using HTML, CSS, Javascript,Bootstrap and PHP. It is compatible for Android phone also and can collect the feedback of the users in backend.

    Power Bi Employee dashboard Project

    An interactive Power BI dashboard to visualize and analyze key metrics from employee data, enabling deeper insights into workforce trends and performance. The dashboard provides a clear, intuitive interface for HR and management to make data-driven decisions.


    Realtime Fraud Detection

    This project simulates real-time financial transactions, detects fraudulent activities using a Kafka consumer, stores the results in MongoDB, and sends automated email alerts for suspicious transactions.

    Supply-Chain-Analytics

    This project demonstrates an end-to-end pipeline for ingesting supply chain data, processing it with Spark, predicting product costs using machine learning, and saving the predictions back to MongoDB.

    0 Achievements
    0 Projects
    0 Data Discussions
    0 Problems Solved

    More projects on Github

    I love to solve business data problems & uncover hidden data stories


    GitHub

    Contact

    Contact Me

    Below are the details to reach out to me!

    Address

    Noida, India

    Contact Number

    +9161445667

    Email Address

    s.t.professional85@gmail.com

    Download Resume

    resumelink



    Have a Question? Click Here


    • Find me on