Data Analytics Power Bi

SAURABH GANGULY

(Contact# 812-***-****; LinkedIn: https://www.linkedin.com/in/saurabh-ganguly-15a58051/ )

PROFESSIONAL SUMMARY:

Dedicated and result-driven data professional with over 10 years of experience in the data and analytics field across various industries. Proven track record in database management, SQL querying, ETL activities, and building intuitive visualizations using tools like Power BI, Tableau, and SAP Analytics Cloud. Adept at translating client requirements into technical solutions, ensuring efficient data processes and delivering actionable insights. Possess a strong understanding of business processes including Insurance, Banking,Manufacturing, Warehousing,Sales and Distribution, and Material Management.

Client: USAA

Organization: Marvel Tech Group Jan’24-Current

Role: Lead Developer Technical Lead

Dedveloped datastage jobs and resusable load jobs depending on the business requirement to load data from DB2 to Oracle and Snowflake for CFO Actuary Team for reporting process remediation.

Requirement gathering through multiple stakeholder meetings and translating the requirements into actionable items, technical capabilities, and technical requirements.

Troubleshooting, design discussion, and solution presentation in architecture review meetings.

Leading onshore and offshore team of total 13 members to deliver end to end delivery.

Deployed developed datastage jobs and E3 framework components to Test & Prod using UDB.

Mainataining repository of the developed objects in Gitlab.

Loading data using datastage job to Snowflake for business critical reporting.

Shell scripting and SQL drafting and analysis.

Supported multiple teams in calibrating and running business critical jobs during month ends.

Efficiently worked with Tech Leads to deliver the target table creation and loading with the designated timeframe.

Provided trainings to team members depending on the skill set on Snowflake, Datastage, & E3 Framework.

Ensured data referential integrity with Snowflake before providing data to downstream team before performing UAT.

Establisishing

Organization: Marvel Tech Group Apr’23-Jan’24

Role: Data Analytics and Reporting Developer

Requirement gathering through multiple stakeholder meetings and translating the requirements into functional capabilities, technical capabilities, and technical requirements.

Break up functional requirements into Micro-services and package the solution in a three-tier microservice architecture for building data analytics solutions using AWS Glue, Qucksight, and data warehousing concepts.

Implementation of an E-Commerce system on AWS in an automated way using Terraform and Ansible

Implementation of a set of EC2 instances using Terraform and AWS Systems Manager configuration with Amazon Simple Notification Service for automated installation of security officers

Client: Perdue Farms, Boston Scientific Apr’21 – Ap’23

Organization: Capgemini NA

Role: Data Analytics and Reporting Developer

Responsibilities:

Spearheaded the development of database objects in Oracle, MySQL, and Microsoft SQL Server databases.

Utilized advanced SQL techniques to construct customized queries based on specific business requirements for manufacturing department on back order and inventory management.

Building and optimizing data warehouse mapping ensuring seamless data integration and accessibility.

Implementing ETL activities using dbt & snowflake, facilitating efficient data transformation,loading, and warehousing solution.

Creating visually appealing and insightful dashboards using Power BI aiding data-driven decision-making.

Client: Medtronic, Sunnyvale, CA Feb'21-Apr’21

Organization : Iziel Healthcare

Role: Process Validation Data Specialist

Responsibilities:

Led the analysis of client requirements, translating them into technical specifications for database and analytics solutions.

Collaborated with cross-functional teams to integrate data sources, ensuring comprehensive and coherent datasets.

Conducted training sessions for team members, enhancing their proficiency in database management and analytics tools.

Client: Thermo Fisher Scientific, Millersburg, PA Jun’ 20- Jan’21

Organization: TekWissen

Role: Manufacturing Process Data Specialist

Responsibilities:

Conducted in-depth analysis of business processes, particularly in FICO, Sales and Distribution, and Material Management.

Developed and executed comprehensive test plans, ensuring the robustness of database solutions.

Provided expert consultation on process validation strategies, enhancing overall data quality and integrity.

Wayne State University Aug’ 18 – Jun’20

Role: Graduate Student Assistant

Responsibilities:

Assisted professors in data analysis for research projects, employing statistical methods and database querying techniques.

Conducted workshops on SQL and data visualization tools, enhancing students' proficiency in these areas.

Actively engaged in coursework related to data analytics and business intelligence, expanding knowledge base.

Client: Indian Jute Mills Association, Kolkata, India Oct’ 14- Aug’18

Role: Supply Chain Data Analyst Expert

Responsibilities:

Optimized supply chain operations through data-driven insights, reducing operational costs and improving efficiency.

Utilized SCD concept for building data warehouse and mapping, ensuring seamless integration of supply chain data.

Developed custom queries using advanced SQL, providing actionable insights to stakeholders and senior management.

Client: L&T, India Jun’12–Oct’14

Role: Business Analyst – Data Quality Steward

Responsibilities:

Gathered and analyzed business requirements, translating them into technical specifications for database solutions.

Implemented database objects in SAP HANA, enhancing data retrieval speed and efficiency.

Conducted regular performance assessments, implementing optimizations to improve database performance.

Skills :

Database Management: HANA, Oracle, MySQL, PostgreSQL, Microsoft SQL

Data Visualization: Power BI, SAP Analytics Cloud, Tableau

Programming: SQL, Node.js fs, JavaScript, Python

Business Processes: FICO, Sales and Distribution, Material Management

Certifications: Snowflake, AWS, SAP Analytics Cloud, SAP BW 4 HANA, Six Sigma, Quality Engineering

Soft Skills: Analytical Thinking, Problem-Solving, Team Collaboration, Communication

EDUCATION DETAILS :

MSIE (Master of Science in Industrial Engineering) from Wayne State University, Michigan -2022

BE (Bachelor of Engineering Civil) from CSVTU, Bhilai, India -2012

CERTIFICATION / TRAINING:

Snowflake SnowPro Core Certification

AWS Solutions Architect Associate

AWS Certified Cloud Practitioner

Certified SAP Analytics Cloud Application Associate

Certified SAP BW/4 HANA Application Associate

Certified ASQ Quality Engineer

Certified ASQ Six Sigma Black Belt

SAP S/4 HANA Embedded Analytics

SAP Learning Hub: SAP BTP Extension Suite

SAP Learning Hub: SAP BTP Integration Suite

Contact this candidate