Asad S. AWS Data Engineer
Summary
- More than 8 years of Data Engineering experience in the Banking and Health sector.
- Worked on Datawarehousing and ETL pipeline projects using AWS Glue, Databrew, Lambda, Fivetran, Kinesis, Snowflake, Redshift, and Quicksight.
- Recent project involves loading data into Snowflake using Fivetran connector and automation of pipeline using Lambda and Eventbridge.
- Performed Cloud Data Migrations and automation of ETL pipeline design and implementations.
- Fluent English
- Available from 18.08.2022
Experience
Sr. Data Engineer
February 2020 - Present
Description: AWS certified solution architect and Teradata associate certified. Worked on various Data migration projects using AWS services such as AWS Glue, Kinesis, Lambda, and RDS. Designed and implemented various ETL pipelines on AWS with Python and PySpark. Worked as lead java developer on DWH testing tool.
Tools & Technologies: AWS Cloud, Teradata Vantage, Informatica, Docker, DevOps, DataOps, Python & Java
Senior Software Engineer
October 2015 - January 2020
Implementation and Customization: Oracle FLEXCUBE UBS
Description: Worked as a developer on customization of Oracle Flexcube UBS to develop a solution for banking PDM as per guidelines of State Bank of Pakistan. The same system was then converted into a standalone product to support some of the widely used UBS in Pakistan. The entire system has been developed, tested, audited, and delivered for production, currently running in one bank and two more are going through UAT.
Responsibilities:
- Extensive involvement in requirement gathering, designing, and development of the project throughout its timeline.
- Project briefings, walkthroughs & demos, and training.
- Lead a team to conduct on-site User Acceptance Testing (UAT) at various stages.
- Conduct meetings with clients to finalize testing strategies and timelines.
- Address the identified issues and provide solutions through code changes and software maintenance.
- Documentation of the system.
Tools & Technologies: Python, Pl/Sql, SQL, Java, Oracle 11G, FLEXCUBE 11.3, Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, Toad, Netbeans, Android Studio.
Migrations and Business Intelligence development: Upgrade to FLEXCUBE 11.3
Description: Implemented and migrated Islamic banking from legacy system to Oracle Flexcube UBS v11.3), and developed BI reports facilitating client processes. The whole system was implemented with various customizations and the data migrations were carried out after successful UATs. Separate UATs were conducted for reporting module. Around 50+ branches migrated in phase 1 after verifying and validating system data – removing all discrepancies in data left after migration routines – successful ETL for various financial modules of the bank, in phase two we developed PL/Sql-based BI reports that were merged to “Core Banking / Universal Banking Solution” by utilizing EXTENSIBILITY FRAMEWORK of Flexcube.
Responsibilities:
- Data migration lead.
- Performed successful data migration of up to 50 branches of the bank by creating ETL scripts.
- Designed and developed BI reports on Oracle Business Intelligence Enterprise Edition (OBIEE).
- Conducted on-site UATs for migrations and BI reporting.
Tools & Technologies: Oracle 11G, FLEXCUBE 11.3, Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, PLSQL.
Software Engineer
September 2015 - November 2015
Description: Worked as Software Engineer to develop DICOM integrated applications using Netbeans platform for Hospital Management System.
Responsibilities:
- Requirement gathering and analyzing for the possibility of customization
- Development of a system that is computable with the DICOM integrated machine
Tools: Netbean Platform Application, Java, Photoshop CS6Worked as Software Engineer to develop DICOM integrated applications using Netbeans platform for Hospital Management System.
Education
Education B.Sc Computer Engineering Ghulam Ishaq Khan Institute of Engineering Sciences & Technology,
2015
HSSC Pre-Engineering Govt. Degree College, Peshawar
2011
SSC Science Frontier Children’s Academy, Peshawar Pakistan
2009
Certificates
Teradata Vantage Associate
Teradata (Starting December 2020)