PROFESSIONAL SUMMARY:

• Having 9 + years of solid experience in Extraction, Transformation and Loading (ETL) mechanism using Ab Initio. Knowledge of full life cycle development for building a data warehouse.
• Experience with Ab Initio Co>Operating System, application tuning and debugging strategies.
• Hands on experience in end - to-end of Data warehousing ETL routines, which includes developing Ab-Initio Plans/graphs, UNIX scripts, and data quality process.
• Experience in UNIX Shell Scripts including Korn Shell Scripts.
• Having good knowledge on Ab Initio Products Like Express > It, Data Quality Enivironment, Metadata Hub, Control Center, EME,and Conduct >IT.
• Developed UNIX Korn shell wrapper scripts to accept parameters and scheduled the processes using Control-M.
• Experience in using schedulers Control-M, Autosys and Tivoli.
• Having good Knowledge on understanding Java and Python programs.
• Having good knowledge on working Massage Queues.
• Having good Knowledge on setting up the data linage using Metadata Hub.
• Having good Experience in designing MFS system to handling Large volume data
• Experience in integration of various data sources such as flat files, ASCII, EBCDIC, Unicode and XML files, DB tables etc.
• Experience in reading and writing data to Hadoop file system using Ab Initio Components.
• Have developed the complex wrapper scripts to automate ETL process using UNIX K-shell scripts.
• Having good knowledge on writing and understanding the Windows CMD batch scripts.
• Ability to co-ordinate effectively with development team, business partners, end users and management.
• Ability to handle multiple tasks, initiative and adaptable. Proactive team player with capability of handling responsibilities independently as well. Adeptness in handling the complete SDLC and flair for adopting & keeping abreast the latest IT trends/ technologies and providing innovative and alternative solutions to the Customers.
• Good Communication Skills to deal effectively with a broad range of contacts from technical staff, to clients, to management.
• Domain expertise in Banking, Cards and Mortgage applications.
• Experienced in Agile Development process for diverse requirements.
• Willing to update my knowledge and learn new skills to perform efficiently.

TECHNICAL SKILL:

Data warehousing and BI Tools: Ab Initio 3.3.1, 3.2.6, 3.1.4, 3.0.4, 2.15

Relational Databases: Oracle, Teradata, DB2, SQL Server

Operating Systems: UNIX (AIX), Linux, MS Windows

Programming or Scripting Languages: UNIX Shell & Python Scripting, Batch Scripting, PL/SQL, SQL

Tools: /Utilities/Packaged Software: TOAD, PL/SQL Developer, Control -M, Auto Sys, Tivoli Scheduler, HP Quality Center, Microsoft Office Tools (WinWord, Excel, Project, PowerPoint, Visio, Internet Explorer)

PROFESSIONAL EXPERIENCE:

Confidential

Charlotte, NC

Senior ETL Developer

Responsibilities:

• Understand the complex requirements and develop, test and deliver Ab initio code within given time lines without compromising quality.
• Involved in frequent meetings with clients get business requirements.
• Created run calendars to support the scheduling requirements of Auto sys Jobs.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Involved in preparation of the System Test Strategy for Ab Initio graphs and scripts and also created processes to generate test data.
• Developed common Ab Initio plans/graphs as per requirements.
• Working with downstream applications to make sure they don’t have any impact with new Ab-Initio Code and Provide solutions to them if they are any impacts.
• Created Appconf’s by updating the mapping rules as per business requirements in common Express > It templates.
• Develop Conduct > It plans to avoid the external scheduling dependencies.
• Involved in rigorous regression testing when we are doing the changes to existing applications.
• Involved in test data driven development to deliver the quality code for each sprint.
• Extensively worked on creating and track work status using Jira.
• Worked under Agile Practice in 2 weeks deliverables .
• Involved in sprint planning and retrospective meeting sessions.

Environment: Ab Initio 3.2.7, Express > It, Conduct > It, Control Center, Linux, Mainframe, Autosys, Windows XP, Putty, Python, TeraData, MQ’s, Jira and Oracle

Confidential

Charlotte, NC

Senior ETL Developer

Responsibilities:

• Understand the complex PL/SQL quires and rewrite the logic in Ab-intio
• Set up the Ab - Initio environment to connect DB2, MS SQL and Oracle Ldap server databases.
• Understand the complex Java/Python scripts to write the mapping rules.
• Created run calendars to support the scheduling requirements of Auto sys Jobs.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Involved in preparation of the System Test Strategy for Ab Initio graphs and scripts and also created processes to generate test data.
• Developed common Ab Initio plans/graphs as per requirements.
• Understand the complex PL/SQL queries, Python scripts and developed Ab initio plans/graphs t o replace the existing jobs with Ab Initio code .
• Conducted rigorous regression testing to verify the new code does not missing and existing functionality of the Java/Python code.
• Working with downstream applications to make sure they don’t have any impact with new Ab-Initio Code and Provide solutions to them if they are any impacts.
• Created Appconf’s by updating the mapping rules as per business requirements in common Express > It templates.
• Created the complex graphs to access ldap servers and Calling web services.
• Develop Conduct > It plans to avoid the external scheduling dependencies

Environment: Ab Initio 3.2.7, Express > It, Conduct > It, Control Center, Linux, Mainframe, Autosys, Windows XP, Putty, Python, DB2, TeraData, Ms Sql and Oracle

Confidential

White Plains, NY

Senior ETL Developer

Responsibilities:

• Developed the complex SQL quires to load files into database and validate the data in database.
• Developed the complex SQL quires to implement the transformation rules.
• Developed CMD Batch scripts to automate the ETL loading process.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Involved in preparation of the System Test Strategy for Ab Initio graphs and scripts and also created processes to generate test data.
• Extensively used the VEDIT to transform the EBCDIC files.

Environment: SSIS, SQL Developer, Windows XP, VEDIT, MS Excel, MS Project, Cygwin, Win SCP and Task Scheduler

Confidential

Jersey City, NJ

Senior Developer

Responsibilities:

• Involved in requirement gathering, impact analysis of project requests.
• Provide Estimates to design, develop Ab Initio Applications/Graphs and Wrapper Scripts.
• Developed Complex Ab Initio graphs to extract data from various sources and load data into target tables.
• Developed the Conduct > IT plans to create, manage and run large-scale data processing systems.
• Developed Unix Wrapper Scripts to call Ab Initio graphs and automating manual processes.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Performed Data Profiling activities and contributed to creation of data dictionary for end users.
• Involved in preparation of the System Test Strategy for Ab Initio graphs and scripts and also created processes to generate test data.
• Work Allocation to the team members, Monitoring, tracking and status reporting.
• Coordinating with offshore and other stakeholders for timely project delivery.
• Team building and Mentoring on various technical and processes related activities.

Environment: Ab Initio 3.1, EME 3.1, UNIX (AIX), MS SQL Server, Windows XP, Putty, MS Excel, MS Project,HP Quality Center

Confidential

Cleveland, OH

Senior Developer

Responsibilities:

• Developed complex Ab Initio graphs and shell scripts.
• Developed the graphs to handle EBCIDC format datasets.
• Written Complex DML for Mainframe data to handle the multiple redefines in the COBOL copy book.
• Developed to the common Graphs to use the common functionality in different Graphs as per the requirement.
• Have created the pset's to use the common graphs to access the data from different sources.
• Have developed the PDL’s in input pset files.
• Developed the TWS scripts for scheduling the Ab Initio jobs in Tivoli scheduler.
• Involved in unit testing and regression testing.
• Performed testing of graphs and done performance tuning.
• Involved in developing new batch jobs
• In support quick fixing of abends for production jobs.
• Work Allocation to the team members, Monitoring, tracking and status reporting.

Environment: Ab Initio 3.0.4, EME 3.0.14, Linux, Mainframe, Tivoli, Windows XP, Putty, MS Excel

Confidential

Phoenix, AZ

Team Lead

Responsibilities:

• Implemented Ab-Initio configuration and set up well-tuned environments for Production Development & Testing.
• Involved in the creation of (Logical) Entity Relationship Diagram Models, including normalization and (Physical) Dimensional Database Models that satisfy application, database, and performance requirements.
• Developed Complex Ab Initio XFRs to derive new fields and solves rigorous business requirements.
• Developed the complex XFR's to handle multi byte Unicode characters.
• Performed testing of graphs and done performance tuning.
• Design and development of ETL process using Ab Initio as the tool.
• Developed shell scripts to customize the ETL Ab Initio Graphs at runtime.
• Involved in performance and tuning of Ab Initio ETL graphs, processes and load routines and provided mentoring in Ab Initio
• Check in/Check Out existing applications Using EME in order to perform the necessary modifications.

Environment: Ab Initio 2.15, EME 2.15, UNIX (AIX), DB2 UDB, Windows XP, Putty, Control-M, HP-QC

Confidential

Phoenix,AZ

Team Lead

Responsibilities:

• As an Ab Initio Developer, Analyzed requirements and prepared high level and detail design documents to list the impact to the application.
• Designed and developed Ab Initio graphs to unload lookup files, perform validation of source data, restructure and redefine record format, determine delta records, call stored procedures and publish records.
• Designed and developed graphs involving partitioning (multifiles), database, normalization and continuous flow components.
• Performed data analysis for both source and target fields/columns.
• Performed peer level design reviews and been an External Quality Analyst performing code and process reviews across projects.
• Developed UNIX shell scripts for scheduling, job control and automation of repetitive tasks like purging, file system backup and clean up.
• Performed unit testing of developed modules, created test cases, executed them and documented test results.

Environment: Ab Initio 2.15, EME 2.15, UNIX (AIX), DB2 UDB, Windows XP, Putty, Control-M, HP-QC

Confidential

Phoenix, AZ

Senior Developer

Responsibilities:

• Involved in developing the Changes in existing code. Implemented the changes to existing common Graphs to leverage the business requirements.
• Conducted various rounds of testing to make sure existing functionality of framework doesn’t have any impact with the current changes.
• Designed and Developed Ab Initio graphs for reading data from source, redefining and restructuring the data and creating load ready ASCII files to be loaded into target data marts.
• Analyzed Ab Initio log files to determine the root cause of issues during development and support operations.
• Have made the fixes to production abend jobs.

Environment: Ab Initio 2.15, EME 2.15, UNIX (AIX), DB2 UDB, Windows XP, Putty, Control-M, HP-QC

Confidential, Phoenix, AZ

Developer

Responsibilities:

• Implemented the changes to existing common Graphs to leverage the business requirements.
• Conducted various rounds of testing to make sure existing functionality of framework doesn’t have any impact with the current changes.
• Designed and Developed Ab Initio graphs for reading data from source, redefining and restructuring the data and creating load ready ASCII files to be loaded into target data marts.
• Analyzed Ab Initio log files to determine the root cause of issues during development and support operations.

Environment: Ab Initio 2.15, EME 2.15, UNIX (AIX), DB2 UDB, Windows XP, Putty, Control-M,HP-QC

Confidential

Phoenix, AZ

Developer

Responsibilities:

• Implemented the changes to existing common Graphs to leverage the business requirements.
• Conducted rigorous testing to validate the new changes does not affect the existing functionality of the common graph.
• Developed common utilities in Ab initio to use in multiple graphs.
• Provided warranty support.

Environment: Ab Initio 2.15, EME 2.15, UNIX (AIX), DB2 UDB, Windows XP, Putty, Control-M, HP-QC