AMAN SHAIK
AWS Data Engineer | Ab Initio Developer
Hyderabad,TG
Summary
Having around 10 years of IT experience in software banking development projects. Having 2+ years of work experience in AWS cloud services and Control - M, 3+ years of experience in AB Initio development (GDE & Express it) and 3 years of experience in SQL and PL/SQL development. Experienced with AWS services, including EC2, S3, and Lambda. Utilizes cloud-based technologies to enhance system performance and scalability. Strong understanding of infrastructure as code and continuous integration/continuous deployment (CI/CD) pipelines. Developed pipelines to load the data from AWS to Snowflake tables. Hands on experience in tools like AB Initio (GDE, BRE), SQL developer, PL/SQL developer and Control –M. Hands on experience Oracle and Teradata Databases. Basic knowledge in Unix Commands and Shell Scripting. Working experience in Waterfall model and Agile Projects. Having strong analytical, problem solving and interpersonal skills. Good team worker and have ability to work independently.
As a fresher got placed in TCS through campus placement in May 2015. Worked as IT analyst in Tata Consultancy Services from 2015-05-01 to 2024-04-01. Currently working as Senior Consultant in JP Morgan & Chase and payroll with Virtusa from 2024-04-01 to till date.
Overview
11
11
years of professional experience
Work History
AWS Developer
JPMorgan Chase
04.2024 - Current
- Utilized Amazon Athena for server less querying of large datasets stored in S3 to support data validation and gap analysis across multiple projects
- Created, scheduled and monitored critical workflows using Control-M to ensure timely execution of dependent systems
- Implemented proactive monitoring via AWS Cloud Watch, analyzing logs to troubleshoot file transfer processes and system issues.
- Managed S3 buckets to validate timely data ingestion from MFTS System; performed file validation and analysis in UAT environments.
- Tested AWS Lambda functions to validate end-to-end file transfer flows.
- Leveraged AWS Lambda functions for serverless computing, reducing operational costs while increasing scalability.
- Improved system efficiency by optimizing AWS infrastructure and implementing cost-effective solutions.
- Implemented monitoring strategies using Amazon CloudWatch, ensuring proactive issue resolution and maintaining system reliability.
- Implemented data pipelines by creating Glue tables in AWS and Glue jobs using PySpark to load the data into the Snowflake tables.Used Swagger UI to register the datasets
Ab Initio Developer
TCSL
03.2019 - 04.2024
- Collaborated with cross-functional teams to design and develop Ab Initio GDE graphs that integrated with multiple third-party systems.
- Converted number of Data stage Jobs to Ab Initio graphs without any hassle in performance.
- Handled many complex scenarios in Ab Initio graphs by using the appropriate functions and components.
- Working experience with Serial files, MFS, PDL, Lookups, Database components, Transform components, Partition components and other Ab Initio components.
- Experience in debugging in Ab Initio.
- Experience in using UNIX commands, m commands and air commands.
- Close monitoring done to each component for performance improvement.
- Reviewed and unit testing done rigorously to provide defect free code.
- Graph tested in many phases DEV, UAT, PAT and then send to PROD.
- Deployment of graphs done through RLM.
- Worked in Oracle (source) and Teradata (Target) Databases.
- Displayed responsibility, ownership and accountability for deliverables in development lifecycle.
- Delivered high-quality code by conducting thorough unit testing, debugging, and troubleshooting of Ab Initio applications.
- Hands on experience on Express it as well.
PL/SQL Developer
TCSL
05.2015 - 03.2019
- Developed efficient stored procedures for seamless data retrieval and manipulation, increasing application response time.
- Optimized existing PLSQL routines using performance tuning techniques such as indexing, query optimization, and partitioning strategies.
- Increased application stability by troubleshooting and resolving complex PLSQL issues in a timely manner.
- Implemented advanced error handling techniques in PLSQL code, resulting in robust applications with minimal crashes.
- Improved database performance by optimizing PLSQL code and implementing best practices.
- Contributed to successful project completion by adhering to strict deadlines and meeting client requirements.
- Collaborated with cross-functional teams to integrate various systems, streamlining business processes.
Education
B Tech -
Lakireddy Balireddy college of Engineering
MylavaramIntermediate - undefined
Sri Chaitanya Junior college
VijayawadaSSC - undefined
St John’s EM School
SingarayakondaSkills
AWS Data engineer tools
AWS glue ETL development
Timeline
AWS Developer
JPMorgan Chase
04.2024 - Current
Ab Initio Developer
TCSL
03.2019 - 04.2024
PL/SQL Developer
TCSL
05.2015 - 03.2019
Intermediate - undefined
Sri Chaitanya Junior college
SSC - undefined
St John’s EM School
B Tech -
Lakireddy Balireddy college of Engineering
Projects
Project 1 : FDM,CCB-OPT, JP Morgan & Chase - Hyderabad
Project 2 : UCBRF,CCB-OPT, JP Morgan & Chase - Hyderabad
Project 3: GDGS-NAM,CITI Bank - Hyderabad
Project 4 : Tablet Compliance, Western Union Bank - Hyderabad
Project 5: Contract Management System, TCS - Internal - Mmbai