Pgadmin
Simranpreet Singh Chauhan
Sr. Data Engineer
Brampton,Ontario
Summary
Enthusiastic Data Engineer eager to contribute to team success through hard work, attention to detail and excellent organizational skills. Clear understanding of SQL and Python and training in Big Data. Motivated to learn, grow and excel in Big Data & Machine Learning.
Overview
1
1
Certification
4
4
years of post-secondary education
8
8
years of professional experience
5
5
Languages
Work History
Sr. Data Engineer
GE Aviation
Cincinnati, OH
05.2018 - Current
- Designed the solution for GEA Cash helpful in Cash quarterly prediction and worked on key initiatives to increase cash holding capacity by using advance analytics and delivered various insightful dashboards.
- Modeled and developed Direct Cash space in Data Lake by setting up jobs pipeline and infusing complex business logic in Talend, Alteryx, Greenplum functions & views.
- Wrote complex PostgreSQL for data ingestion from various ERPs data sitting in standard layer.
- Designed and coded iron python scripts for building user friendly dashboards in Spotfire.
- Quickly fixed various data and technical bugs based upon user's feedback and carried out UATs and migration post business sign-off.
Data Engineer
GE Aviation
Cincinnati, OH
03.2016 - 04.2018
- Developed a Finance Data Lake that tracks $11 Billion Revenue and reconcile accounts across AR, AP GL.
- Constructed the Data Model to provide faster data insight, easy adaptability retaining all data from source ERPs.
- Worked extensively upon Talend to set up Data Pipeline by using various Greenplum database utilities.
- Designed reporting Dashboard that showcase various trends and comparisons of financial statement over period.
- Worked on migration of Data Lake including Data, ETL, Report, etc. from on-premises to AWS cloud infrastructure
- Developed customized reports using non-standard approaches and used it as framework for other clients.
- Carried out various process improvement solution and helped GE save $175K/year.
ETL Lead Developer
Tata Consultancy Services
Pune, Maharashtra
03.2013 - 02.2016
- Developed a Data Warehouse for scrutinizing the Contractual Service Agreements of GE Aviation.
- Elicited and documented business requirements through multiple cross-functional client interactions.
- Built the Snapshot Fact Dimensional Model by comprehensively investigating the database elements.
- Designed data pipeline architecture for data loading using Informatica re-useable workflows & worklets.
- Developed reporting dashboard required for analyzing the Service Bulletins of each air plane engines.
- Tuned & Optimized the reporting queries by studying their execution plan.
Database Developer
Creative Pundits
Mohali, Punjab
06.2012 - 02.2013
- Grasped the business requirement and execution plan.
- Established complex PL/SQL procedures and SQL queries for analyzing & loading the data.
- Data reconciliation report was also developed to reconcile data between stage and base tables.
- Documentation was maintained to keep track of all the enhancements done on the existing code.
- Carried out unit testing and migration across different environments.
Education
Bachelor of Science - Computer Science
Punjab Technical University
Punjab, India 08.2008 - 05.2012
Skills
SQL
undefinedAccomplishments
- Awarded as Ideator of the month by helping GE save $175k/year.
- Received Star of the Month award.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Certification
Digital Ninja Certificate in Machine Learning
Quote
The way to get started is to quit talking and begin doing.
Walt Disney
Software
Informatica
Talend
Spotfire
Tableau
Cognos
Hyperion
IDLE
Timeline
Digital Ninja Certificate in Machine Learning
04-2019
Sr. Data Engineer
GE Aviation
05.2018 - Current
Data Engineer
GE Aviation
03.2016 - 04.2018
ETL Lead Developer
Tata Consultancy Services
03.2013 - 02.2016
Database Developer
Creative Pundits
06.2012 - 02.2013
Bachelor of Science - Computer Science
Punjab Technical University
08.2008 - 05.2012
Similar Profiles
Eric BurtonEric Burton
General Laborer at GE AviationGeneral Laborer at GE Aviation
Marcus DurrellMarcus Durrell
Technical Associate at GE AviationTechnical Associate at GE Aviation
Ong Leng SoonOng Leng Soon
Technician at GE AviationTechnician at GE Aviation
Travis EcholsTravis Echols
Manufacturing Associate at GE AviationManufacturing Associate at GE Aviation
Savannah ClarkeSavannah Clarke
Community Manager & Program Coordinator at MusicOntarioCommunity Manager & Program Coordinator at MusicOntario