SUMMARY:

• 8.6 years of work experience in building ETL solutions using Ab - initio tool in Banking and Financial Services domain. Currently working as a Senior Ab-initio Developer/ ETL developer.
• AWS (Amazon Web Services) certified as a solution architect - associate.
• 3.6 years of Onsite/US experience working with Confidential .
• Well versed with Financial and Banking domains.
• Very strong programming skills in Ab-initio, UNIX shell scripting, Teradata, and Control-M.
• Good hands on experience working AWS services - S3, EC2, EBS volumes, snapshots, RDS, IAM, CloudFormation, Redshift, Elastic Load Balancer(ELB), Auto Scaling Group(ASG), AWS CLI etc.
• Have basic working knowledge of Python language.
• Extensive experience and in-depth knowledge of various Ab-initio parallelism techniques and implemented Ab-initio Graphs using Data parallelism and Multi File System (MFS) techniques.
• Emphasized on automating the process using Unix Shell scripts and to fine tune the existing process.
• 5+ years of experience working in Agile Environment.
• Vast experience in working with a mix of the onsite-offshore Global Delivery model.
• Coordinated effectively with development teams, business partners, end users, and management.
• Have knowledge on Big Data environment. Exploring ways to integrate this in our project.
• Experience in reviewing and monitoring project progress, planning & managing dependencies and risks, Resource Planning, Project Budget Tracking, and Forecasting.
• Experience in working with external IT vendors in project collaboration.
• Good communication skills to deal effectively with a broad range of contacts from technical staff, clients and management and external IT vendors.
• Involved in providing production support (IPS L2-L3) to various Ab-initio ETL jobs.
• Result oriented, Fast Learner and able to work with minimum guidance.

TECHNICAL SKILLS:

Tools: Ab-initio GDE (1.13 to 3.1.3), Enterprise Meta>Environment, Metadata Hub, Conduct-it, Data Profiler, Informatica

AWS services: S3, EC2, EBS, IAM, VPC, Security Groups, RDS, Redshift, SQS, SNS.

Languages: Unix, shell scripting, Python

Database: Teradata (v12, v14), DB2, SQL Server, BTEQ

Scheduling: Control-M Enterprise/Desktop, Control-M Workload Automation 9.0, Tidal

Operating System: Windows 7/XP/NT/Vista, Unix/Linux

Agile Project Management Tool: Version One, Jira

PROFESSIONAL EXPERIENCE:

Confidential

Lead Engineer

Responsibilities:

• Met with business users/groups to understand the business process and gather requirements.
• Created a plan/tracker to arrange to provide 5 years of most recent data (comprising of 1800 files) to the new source system in the target system format.
• Developed complex SQL Teradata queries, comprising of JOINS, multiple VOLATILE tables, reformatting the data in-order to fetch the old information as the tables were in 3rd Normal Form.
• Established new Direct Connect connections to transmit the files to the new source system in a secured and timely manner.
• Created a high-level plan to move the files associated with the Fraud Decision Engine to S3, Glacier.
• Created a plan to migrate the Teradata tables to Redshift.
• Developed the Ab-initio graphs involved for the process so that the files produced will also be redirected to S3 specified buckets.
• Created the AWS security groups so that the On-Premise application could connect to the AWS services by adding the IP details for the inbound and outbound traffic.
• Setting up AWS EC2/RDS instances servers consisting of proper IAM roles to remove the Private Key - Public Key dependencies.
• Generated new Database Connectivity (DBC) files pointing to the AWS database endpoint and configuring them in the Abinitio graphs/psets to connect to the AWS instance.
• Involved in various agile iterative sessions to develop the design and discuss with business.
• Actively involved in coordinating with other teams on Integration Testing and UAT (User Acceptance Testing).

Environment: AWS services -- S3, EC2, EBS, RDS, Glacier, Security Groups, Ab-initio GDE (3.1.3.2), Co>op(3.2.5), EME, Conduct>It, Teradata (v14), Unix Scripting, Putty, Jira, Control-M, Tidal.

Confidential, Mclean, VA

Technical Lead

Responsibilities:

• Represented as a single point of contact and a DDE expert in the entire team.
• Met with business users/groups to understand the business process and gather requirements.
• Involved in various agile iterative sessions to develop the design and discuss with business.
• Prepared High-Level Designs for source data analysis, ETL process flow, Error handling, Re-startability, and extendibility.
• Developed ETL solution in Ab-initio and wrote UNIX shell scripts to automate the solutions.
• Developed number of Ab Initio Generic Graphs based on business requirements using various Ab Initio Components such as Partition by Key, Partition by Round Robin, reformat, rollup, join, scan, gather, merge etc.
• Scheduled the jobs in Control-M to execute them independently without manual intervention.
• Closely worked with the platform team and the External Target System in establishing a secure connection for exchanging files.
• Fine-tuned the legacy process for performance and for high file availability.
• Actively involved in coordinating with other teams on Integration Testing and UAT (User Acceptance Testing).
• Coordinated with several other teams for Tag Conflicts on the Public sandboxes.
• Solely involved in doing knowledge transfer to the Production Support team to monitor the jobs once the warranty period gets completed.

Environment: Ab-initio GDE (3.1.3.2), Co>Op (3.2.5), EME, Metadata hub, Conduct>It, Teradata (v14), MVS, Unix Scripting, Putty, Version One, Control-M, Tidal.

Confidential, Mclean, VA

Technical Lead/ Onsite Coordinator

Responsibilities:

• Interacted with business to understand and gather requirements and create requirement documents.
• Provided business solutions to achieve the end goal.
• Provided design approach to the offshore team to work on the development.
• Helped the offshore team members with the expertise on Ab-initio knowledge on the development, testing and project implementation.
• Reviewed the graphs, scripts developed by the off-shore teams and suggested them changes with logic, code performance, and efficiency.
• Coordinated in performing end to end testing of the feature. It included Integration testing and User Acceptance testing.
• Actively monitored the process and provided production support until the warranty expires and handed over to dedicated production support team called as IPS.

Environment: Ab-initio GDE (3.1.3.2), Co>Op (3.2.5), EME, Teradata (v14), MVS, Unix Shell Scripting, Putty, Version One, Control-M.

Confidential, Mclean, VA

Senior Software Developer

Responsibilities:

• Performed tasks on performing and checking the compatibility issues of our existing code at the component level.
• Worked on providing the roadmap/timelines to the business on the upgrade.
• Worked on building the new psets, plans, scripts and updating the existing artifacts.
• Created unit test cases and conduct unit testing of the code developed.
• Provide support to the QA testers in conducting system testing and regression testing in comparing the records/data between the new data and old data.
• Worked on Production implementation activities.
• Monitored the jobs/flows in production and provide support for failures.
• Provided support for bug fixes and issues reported.
• Completed the upgrade work well ahead of time which made the Client very delighted.

Environment: Ab-initio GDE (1.15 - 3.0.3), Co>Op (2.15 - 3.0), Conduct>It, EME, Teradata (v12-14), Unix Shell Scripting, Putty, Version One, Control-M.

Confidential, Mclean, VA

Senior Software Developer

Responsibilities:

• Met with business users/clients to understand the business process/goal and gather the requirements.
• Conducted data analysis and profiling using Data Profiler tool to understand the data more accurately.
• Involved in the meetings which happened with the Architects to discuss the design approach.
• Conduct and be a part of the brainstorming sessions organized among the team members to discuss the approach.
• Coordinated with the other downstream and upstream team on the progress of the development work.
• Worked on building several ETL solutions whose design were approved by the architects.
• Worked on fresh development of creating generic graphs to handle data from various source systems.
• Created UNIX shell scripts to automate and execute the ETL solutions.
• Worked with DBAs to build tables and schema's LOB wise.
• Established complete automation of the process with the help of Control-M job scheduling.
• Supported the testers in performing system testing and Integration testing on the code developed.
• Worked closely with the Data Steward team in conducting UAT (User acceptance testing) and making sure all the business requirements are fulfilled.
• Worked on deploying and implementing the code in Production.
• Monitored the jobs and provided instant support in case of failures.

Environment: Ab-initio GDE (1.15), Co>Op (2.15), Conduct>It, EME, Metadata Hub, Data Profiler, Teradata (v12), Unix Shell Scripting, Putty, Mainframe (MVS, GDG), DB2, Version One, Control-M.

Confidential, Mclean, VA

Senior Software Developer

Responsibilities:

• Analyzed and understood user requirement specification documents.
• Prepared the technical design documents in Microsoft Visio.
• Development of ETL solutions using Ab-Initio and automating it using UNIX script.
• Worked on creating ICFF file (blocked compressed lookup file)
• Prepared and conducted test cases for final delivery to the client.
• Document and review the test cases with the Technical Lead.
• Migration the ETL solutions from a test environment to the production environment.

Environment: Ab-initio GDE (1.15), Co>Op (2.15), Conduct>It, EME, ICFF (blocked compressed files), Unix Shell Scripting, Putty, Mainframe (MVS, GDG), XML files.

Confidential, Phoenix

Software Developer

Responsibilities:

• Prepared user requirement specification documents.
• Prepared the High Level and Detailed Level design document with inputs from the Architect.
• Development of ETL solutions using Ab-Initio and automating it using UNIX script.
• Prepared and conducted test cases for final delivery to the client.

Environment: Ab-initio GDE (1.15), Co>Op (2.14), EME, Unix Shell Scripting, Putty, Mainframe(MVS, GDG), flat files.

Confidential, Phoenix

Software Developer

Responsibilities:

• Prepared user requirement specification documents.
• Prepared the design documents in Microsoft Visio.
• Development of ETL solutions using Ab-Initio and automating it using UNIX script.
• Prepared and conducted test cases for final delivery to the client.
• Migration of the ETL solutions from a test environment to the production environment.

Environment: Ab-initio GDE (1.15), Co>Op (2.14), Data Profiler, Informatica, EME, Unix Shell Scripting, Putty, Mainframe (MVS, GDG), flat files.

Confidential, Phoenix

Software Developer

Responsibilities:

• Prepared user requirement specification documents.
• Prepared the design document in Microsoft Visio.
• Developed ETL solutions using Ab-Initio and automating it using UNIX script.
• Prepared and conducted test cases for final delivery to the client.
• Migration of the ETL solutions from a test environment to the production environment.

Environment: Ab-initio GDE (1.15), Co>Op (2.14), Informatica, Unix Shell Scripting, Putty, flat files.