Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

SATYA PRASAD

Farmington Hills

Summary

I am a seasoned data engineer with over 14 years of extensive experience in the IT industry, specializing in Snowflake and Oracle development in SCRUM Framework in Agile Methodology. My expertise lies in building scalable data solutions and optimizing ETL processes. I am passionate about leveraging data to drive business insights and am dedicated to mentoring upcoming talent in the field.

Results-driven data engineering professional with solid foundation in designing and maintaining scalable data systems. Expertise in developing efficient ETL processes and ensuring data accuracy, contributing to impactful business insights. Known for strong collaborative skills and ability to adapt to dynamic project requirements, delivering reliable and timely solutions.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Senior Snowflake Data Engineer

Capgemini Technologies
01.2021 - 04.2025
  • Client : HSBC
  • A leading tech company providing data solutions and consulting services.
  • Engineered scalable data solutions on Snowflake, optimizing ETL processes.
  • Collaborated with cross-functional teams to design and build data infrastructure.
  • Led migration projects from traditional databases to Snowflake environments.
  • Worked on SnowSQL and Snowpipe.
  • Created Snowpipe for continuous data load.
  • Used COPY to bulk load the data.
  • Created data sharing between two Snowflake accounts.
  • Created internal and external stage and transformed data during load.
  • Redesigned the Views in snowflake to increase the performance.
  • Unit tested the data between Redshift and Snowflake.
  • Developed data warehouse model in Snowflake for over 100 datasets using whereScape.
  • Good working knowledge of any ETL tool (Informatica or SSIS).
  • Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.

Snowflake Data Engineer

Capgemini Technologies
11.2019 - 12.2020
  • Client : The Auto Club Group
  • Build the Logical and Physical data model for Snowflake as per the changes required.
  • Define roles, privileges required to access Different database objects.
  • Define virtual warehouse sizing for Snowflake for Different type of workloads.
  • Design and code required Database structures and components.
  • Build the Logical and Physical data model for Snowflake as per the changes required.
  • Worked with cloud architect to set up the environment.
  • Worked on Oracle Databases, RedShift and Snowflakes.
  • Define virtual warehouse sizing for Snowflake for Different type of workloads.
  • Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks during data migration.
  • Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split etc Work with multiple data sources.
  • Developed Mappings, Sessions, and Workflows to extract, validate, and transform data according to the business rules.

Project Lead - Release Management

DXC Technologies (Formerly Hewlett Packard Enterprise)
06.2018 - 10.2019
  • Client : Vodafone Group Enterprise, UK
  • Led technical implementation, and delivery of Identity and Access Management (IAM) solutions for Vodafone UK, ensuring secure access and single sign-on (SSO) capabilities for enterprise and local market web applications.
  • Managed technical aspects of Vodafone’s Identity Management system migration from Oracle IDM 11gR1 to 11gR2, ensuring seamless transition and minimal disruption to portal applications and services.
  • Provided technical guidance and mentorship to a team of engineers, overseeing testing, and deployment of IAM solutions.
  • Collaborated with Vodafone stakeholders to prepare release plan, conduct go-no go reviews prior to release, and provide regular project updates.
  • Contributed to the successful delivery of the Vodafone Global Enterprise (VGE) online solution, enhancing enterprise online capabilities and streamlining user access.
  • Highlight your accomplishments, using numbers if possible.
  • Highlight your accomplishments, using numbers if possible.

Project Lead - Application Support Management

DXC Technologies (Formerly Hewlett Packard Enterprise)
05.2016 - 05.2018
  • Client : SKF
  • Responsible for providing technical leadership in the development and implementation of SAP ERP Implementation
  • Monitoring and overseeing the work activities of project teams and ensure to adhere SLA.
  • Estimating the project resource as well as planning procurement of project requirements
  • Providing necessary support in handling project risks.
  • Daily, Weekly and Monthly Metrics Submission and review with account team for project developments

Project Lead - Application Support Management

DXC Technologies (Formerly Hewlett Packard Enterprise)
09.2014 - 04.2017
  • Client : VFS Global Services
  • Managed day-to-day ticket assignments (Service Now System), escalation point of contact for 1100 remote users and Tier 2 application support.
  • Problem Management and Change Management.
  • Monitoring, troubleshooting and resolving requests within the Service Level Agreement parameters.
  • Monthly Service Management Review.
  • Provided QA support for development team with new releases and code changes .

Technical Lead - Telecom & Utility Billing

SRIT
08.2008 - 01.2014
  • Client : Billing Components, Germany
  • Led a team of 40+ engineers in the design, development, and implementation of mission-critical Utility and Telecom Billing solutions.
  • Developed and implemented GSM billing systems using Oracle 9i and Forms 6i, ensuring accurate and timely invoice generation and revenue collection for telecommunications clients.
  • Designed and implemented IP billing solutions using Java and PL/SQL, enabling effective management and monetization of internet services.
  • Developed and maintained utility billing systems using Java and PL/SQL, ensuring accurate billing and revenue management for electricity, water, and other utility providers.
  • Implemented and maintained quality management practices throughout the software development lifecycle, ensuring delivery of high-quality solutions that met industry standard

Education

Master Diploma - Computers

DATAPRO InfoWorld
09.1996

Bachelors Degree - undefined

Andhra University
09.1996

Skills

  • Technical Skills ::
  • Snowflake Data Engineering
  • AWS
  • Cloud Computing
  • Oracle Database Development
  • SQL Programming
  • ETL Process Optimization
  • Data Modeling
  • Data Architecture
  • Soft Skills: Team Leadership
  • Communication
  • Problem Solving
  • Time Management

Certification

  • SNOWPRO Core Certified — The SNOWPRO Core Certification validates your understanding of the Snowflake AI Data Cloud, demonstrating expertise in areas like data loading, virtual warehouse management, and data sharing.
  • AWS Cloud Practitioner Certified — AWS Cloud Practitioner Certification Demonstrates broad, foundational knowledge of AWS cloud services and their use cases, including pricing and billing model
  • POWER BI DATA ANALYST Certified — Power BI Data Analyst Associate certification (PL-300) ability to analyze and visualize data using Power BI, demonstrating their expertise in preparing, modeling, and analyzing data for business intelligence purpose.
  • Prince2 Foundation Certified — The PRINCE2 Foundation certification is an project management qualification focused on understanding the principles, themes, and processes of the PRINCE2 methodology.

Accomplishments

  • Cost Reduction and Performance Improvement
  • Successfully led a team to migrate critical data processes to Snowflake, reducing costs and increasing performance.
  • Enhanced Data Accessibility
  • Developed an advanced Oracle-based reporting tool that enhanced data accessibility for stakeholders.

Timeline

Senior Snowflake Data Engineer

Capgemini Technologies
01.2021 - 04.2025

Snowflake Data Engineer

Capgemini Technologies
11.2019 - 12.2020

Project Lead - Release Management

DXC Technologies (Formerly Hewlett Packard Enterprise)
06.2018 - 10.2019

Project Lead - Application Support Management

DXC Technologies (Formerly Hewlett Packard Enterprise)
05.2016 - 05.2018

Project Lead - Application Support Management

DXC Technologies (Formerly Hewlett Packard Enterprise)
09.2014 - 04.2017

Technical Lead - Telecom & Utility Billing

SRIT
08.2008 - 01.2014

Bachelors Degree - undefined

Andhra University

Master Diploma - Computers

DATAPRO InfoWorld

Similar Profiles

CREATE PROFILE
SATYA PRASAD