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.
• 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 and Mainframe Datasets etc.
• Experience in reading and writing data to Hadoop file system (HDFS) 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.
• Have worked on defect tracking tool like CDTS, HP - Quality Center
• Willing to update my knowledge and learn new skills to perform efficiently.

TECHNICAL SKILLS

Data warehousing and BI Tools: Ab Initio 3.3.1, 3.2.6, 3.1.4, 3.0.4, 2.15 (Co>Operating System GDEEME, Metadata >Hub, Conduct >It, Control Center, Express >It (ACE/BRE), Data Quality Environment (DQE) )

Relational Databases: Oracle, Teradata, DB2, MS SQL Server

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

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

Tools: /Utilities/Packaged Software: Mainframe, TOAD, PL/SQL Developer, Control -M, AutoSysTivoli Scheduler, HP Quality Center, Microsoft Office Tools (WinWord, Excel, Project, PowerPoint, Visio, Internet Explorer), SVN, Jira, Anthill Pro,Hadoop File System (HDFS)

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 using 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.
• Developed test data management in order to perform unit/regression testing

Environment: Ab Initio 3.2.7, Express > It(ACE/BRE), Conduct > It, Control Center, Linux, Mainframe, Autosys, Windows XP, Putty, Python, Anthil Pro, TeraData, MQ’s, Jira, SVN,CDTS 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 to 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, SVN, CDTS 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: MS SSIS, SQL Developer, Windows XP, VEDIT, MS Excel, MS Project, Cygwin, Win SCP and Task Scheduler

Confidential, Cleveland, OH

Senior Developer

Responsibilities:

• Developed complex Ab Initio graphs and shell scripts.
• Ran the Data profiling process for new data sources to understand the data.
• Helped Business analysts to define requirements by providing Data Profile results in excel sheet.
• 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, Data Profiler, Conduct>It, 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.
• 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-Q

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