SUMMARY:

• 11.1 years of expertise in building design, development and testing of Abinitio applications.
• Worked on Ab Initio GDE version 3.1.7 and Co>OS version 3.1.6
• Worked on Health Care Insurance, Banking & Finance and Telecom domain projects.
• Always involved in coding, unit testing, debugging and documenting processes.
• Actively provided highly effective Abinitio design solutions to team and across other projects.
• Developed Continuous flow graphs in order to subscribe member and eligibility From Web Sphere MQ and publish to Ab Initio queues.
• Worked XML processing of the source Facets data.
• Sound knowledge on Conduct - IT Plan and use of PSETs for parallel processing in generic framework.
• Use of resource management in Conduct-It Plan for parallel processing.
• Generation of various excel reports using Ab Initio tool.
• Provided Ab Initio best practices, Performance improvements to several projects.
• Strong Relational database development skills using SQL, PL/SQL, Oracle 9.x/10g/11g, Teradata 13.0.1.
• Expertise in writing UNIX Shell scripting.
• Good experience on Enterprise Metadata environment, Autosys Scheduling.
• Sound experience on STAR schema and Snow Flake Schema dimensional data base models.
• Excellent in doing Business Data Analysis and also helped business for forming the business rules.
• Worked extensively in implementing Data Warehouse Applications and Business Intelligent applications.
• Involved in Specification and Requirement Analysis, Design, Development, and Testing of applications under UNIX/Windows NT platforms.
• Extensive Knowledge in Telecom, Banking and Financial domain projects.
• Excellent communication, people, team management and interpersonal skills.

TECHNICAL SKILLS:

Data warehousing Tools: Ab Initio (GDE 3.1.7, Co>Operating System 3.1.6), Conduct>IT Plan, Continuous Flows, XML file processing, EME

RDBMS: Oracle 9i/10g/11g, Teradata 13.0.1, MS SQL Server 2000/2005

Programming: UNIX Shell Scripting, C/C++, SQL*Plus, PL/SQL

Operating Systems: UNIX, LINUX, Windows NT/XP/2000

Scheduling Tools: Autosys, Control-M schedulers

Methodologies: Agile and Waterfall models

PROFESSIONAL EXPERIENCE:

Confidential

Senior Tech Lead

Responsibilities:

• Lead 2 teams size 14 members for this offshore onsite model project.
• Involved in coding and unit testing of Continuous graphs, Member subject that generate XML messages and publish in MQ.
• Worked on Continuous graphs, Product subject that subscribes XML messages from Abinitio queues and load in IDS tables.
• Worked on development and unit testing of Product subject batch graphs that read from IDS and load into EDW tables.
• Actively provided design solutions for volatile requirement changes the project being Agile model.
• Use tools like Ab Initio ETL tool, Control-M Scheduler, Teradata, Oracle for development and testing.
• Take part 2 weeks sprint planning and demo sessions at end of sprint.
• Work and co-ordinate with offshore teams to meet delivery time line.
• Implement and Support the application after the completion.
• Used parallel unloads/loads to improve performance of Ab Initio graphs.
• Used Ab Initio components like filter by expression, partition by key, partition by round robin, join, sort, roll-up, gather and reformat components extensively.
• Used 6 way data parallelism mechanism to better improve CPU utilization.
• Developed UNIX wrapper scripts to call the plan.
• Documented processes and prepared QAT, UAT and PROD release plans.

Environment: Ab Initio (CO>Operating system 3.1.6, GDE 3.1.7), UNIX, Oracle 10g, Teradata 13.0.5, Control M Scheduling, Continuous Flow, XML messages processing.

Senior Dev Lead

Responsibilities:

• Working on MaxMC to Care Radius update project coding, unit testing.
• Actively provided highly effective application design solutions which later was very much appreciated by the client management.
• This product runs on agile methodologies. As a Matador member, owe Design, Develop and Test user stories assigned to Matador in a 2 weeks sprint cycle.
• Use tools like Ab Initio ETL tool, Control-M Scheduler, Teradata, Oracle for development and testing.
• Take part 2 weeks sprint planning and demo sessions for the Matadors (Onsite Team) at end of sprint.
• Arrange sprint planning and demo session for Transformers (Offshore Team).
• Work and co-ordinate with Transformers to meet delivery time line.
• Implement and Support the application after the completion.
• Developed Ab Initio generic graphs for common unloading and loading processes.
• Created unload and load psets and execute 10 psets in parallel execution.
• Developed Conduct>IT Plans and configure resource managements to execute 10 psets in parallel.
• Used Teradata Multiload, PT Api Load, API and Teradata Parallel Transporter loading mechanism.
• Used parallel unloads/loads to improve performance of Ab Initio graphs.
• Used Ab Initio components like filter by expression, partition by key, partition by round robin, join, sort, roll-up, gather and reformat components extensively.
• Used 6 way data parallelism mechanism to better improve CPU utilization.
• Developed lookup and lookup local functions to improve performance of Ab Initio graphs.
• Used metaprogramming functions like string split no empty, record info, add fields, remove fields to dynamically add action cd column and create staging table DML.
• Used metaprogramming functions like string split, vector difference, vector append to partial load and adhoc pset list files in case of plan failure.
• Developed UNIX wrapper scripts to call the plan.
• Documented processes and prepared QAT, UAT and PROD release plans.

Environment: Ab Initio (CO>Operating system 3.1.6, GDE 3.1.7), UNIX, Oracle 10g, Teradata 13.0.5, Control M Scheduling.

Confidential

Tech Lead

Responsibilities:

• This product runs on agile methodologies. As a Matador member, owe Design, Develop and Test user stories assigned to Matador in a 2 weeks sprint cycle.
• Use tools like Ab Initio ETL tool, Control-M Scheduler, Teradata, Oracle for development and testing.
• Take part 2 weeks sprint planning and demo sessions for the Matadors (Onsite Team) at end of sprint.
• Arrange sprint planning and demo session for Transformers (Offshore Team).
• Work and co-ordinate with Transformers to meet delivery time line.
• Implement and Support the application after the completion.
• Used Ab Initio components like filter by expression, partition by key, partition by round robin, join, sort, roll-up, gather and reformat components extensively.
• Used 6 way data parallelism mechanism to better improve CPU utilization.
• Developed lookup and lookup local functions to improve performance of Ab Initio graphs.
• Developed UNIX wrapper scripts to call the plan.
• Documented processes and prepared QAT, UAT and PROD release plans.

Environment: Ab Initio (CO>Operating system 3.1.6, GDE 3.1.7), UNIX, Oracle 10g, Teradata 13.0.5, Control-M Scheduling.

Ab Initio Tech Lead

Responsibilities:

• As a lead, I take care of 3 individual projects.
• Attend requirement gathering and understanding meeting.
• Provide estimates agreed with Citi Team Lead.
• Attend daily status call to update development work progress and any show stoppers etc.
• Development and testing work assignment with offshore team and timely deliverables.
• Arrange daily 10PM EST call with offshore team to understand bandwidth and distribute development work across team of 3 members.
• Involve in Ab Initio develop, testing for self-work assignment.
• Developed Ab Initio graphs to generate various excel reports.
• Extensively used Ab Initio components like filter by expression, join, reformat, partition by key, partition by expression, roll-up, sort, merge components.
• Used 4 way MFS system for better CPU utilization.
• Developed different ways of Ab Initio graphs development and performance bench marking.
• Developed complex Ab Initio graphs and used component parallelism, pipe line parallelism and data parallelism.
• Developed Ab Initio Continuous flow to read from Citilink message queue and write onto a queue.
• Developed Ab Initio batch programs to read files from message queue.
• Developed UNIX scripts to invoke Ab Initio graphs and execute the batch processes.
• Implement and Support Go-Live application for 3 months warranty period.

Environment: Ab Initio (CO>Operating system 3.1.1, GDE 3.0.5), UNIX, Oracle 10g, MS SQL SERVER 2008, EME, Autosys Scheduler

Ab Initio Tech Lead

Responsibilities:

• As a lead, I take care of 2 individual projects.
• Attend requirement gathering and understanding meeting with business team, BA, Citi Manager.
• Work with BA and business people to understand requirements and do analysis.
• Prioritize the requirements based on criticality and arrange team meeting to let offshore understand.
• Distributed work assignments among team members based on bandwidth.
• Development and testing work assignment with offshore team and timely deliverables.
• Interact with offshore team to understand bandwidth and distribute development work across team of 6 members.
• Involve in Ab Initio graph develop, testing for self-work assignment.
• Developed many Ab Initio batch programs for new feeds across NAM, EMEA, APAC and LATAM regions.
• Involved in high level design document and prepared low level document.
• Prepared source - target mapping sheet for Ab Initio graph development.
• Developed UNIX generic script to delete files old than 7 days in Dev, QAT and UAT environments and scheduled from Autosys.
• Implemented a number of Ab Initio graphs using Data parallelism and Multi File System (MFS) system .
• Implement and Support for the Go-Live application.

Environment: Ab Initio (GDE 1.15, Co>Operating System 2.15), UNIX, Oracle 10g, Autosys Scheduler.

Ab Initio Tech Lead

Responsibilities:

• Produced high level design and technical design.
• Ab Initio coding and unit testing.
• Offshore - Onsite team co-ordination.
• Developed complex Ab Initio graphs converting DTS SQL server scripts in Ab Initio.
• Used Ab Initio components like filter by expression, partition by key, partition by expression, partition by round robin, join, roll-up, normalize, de-normalized sorted, reformat, scan, RUN SQL, input file, output file, input table and output table components.
• Developed UNIX Shell scripts to invoke Ab Initio generated scripts.

Environment: Ab Initio (GDE 1.15, Co-op 2.15 ), UNIX, Oracle 10g, SQL Server 2000/2005 .

Ab Initio Tech Lead

Responsibilities:

• Produced high level design and technical design.
• Ab Initio coding and unit testing.
• Offshore - Onsite team co-ordination.
• Developed complex Ab Initio graphs converting DTS SQL server scripts in Ab Initio.
• Used Ab Initio components like filter by expression, partition by key, partition by expression, partition by round robin, join, roll-up, normalize, de-normalized sorted, reformat, scan, RUN SQL, input file, output file, input table and output table components.
• Developed UNIX Shell scripts to invoke Ab Initio generated scripts.

Environment: Ab Initio (GDE 1.15, Co-op 2.15 ), UNIX, Oracle 10g, SQL Server 2000/2005

Senior Ab Initio Developer

Re sponsibilities:

• Prepared technical design.
• Ab Initio coding and unit testing.
• Prepared unit test cases and test plan.
• Developed UNIX scripts to move files among vendor servers.
• Used Ab Initio components like filter by expression, partition by key, partition by expression, partition by round robin, join, roll-up, normalize, de-normalized sorted, reformat, scan, RUN SQL, input file, output file, input table and output table components.
• Developed UNIX Shell scripts to invoke Ab Initio generated scripts.

Environment: Ab Initio, EME, GDE, UNIX shell scripting, Oracle 10g, Teradata, SQL Server 2000/2005

Designer/ Senior Ab Initio Developer

Re sponsibilities:

• Prepared technical design.
• Ab Initio coding and unit testing.
• Prepared unit test cases and test plan.
• Used Ab Initio components like filter by expression, partition by key, partition by expression, partition by round robin, join, roll-up, normalize, de-normalized sorted, reformat, scan, RUN SQL, input file, output file, input table and output table components.
• Developed UNIX Shell scripts to invoke Ab Initio generated scripts.

Environment: Ab Initio, EME, GDE, UNIX shell scripting, Teradata.

Designer

Re sponsibilities:

• Prepared technical design.
• Ab Initio coding and unit testing.
• Prepared unit test cases and test plan.
• Used Ab Initio components like filter by expression, partition by key, partition by expression, partition by round robin, join, roll-up, normalize, de-normalized sorted, reformat, scan, RUN SQL, input file, output file, input table and output table components.
• Developed UNIX Shell scripts to invoke Ab Initio generated scripts.
• Prepared code review checklist and build review report.
• Support PROD post implementation.

Environment: Ab Initio, EME, GDE, UNIX shell scripting, Oracle 10g, SQL Developer.

Senior Ab Initio Developer

Re sponsibilities:

• Shadowing design lead for building technical design document.
• Involved in developing complex Ab Initio graphs and unit testing.
• Co-ordinated among team for technical resolution and guidance to the team members.
• Used Ab Initio components like filter by expression, partition by key, partition by expression, partition by round robin, join, roll-up, normalize, de-normalized sorted, reformat, scan, RUN SQL, replicate, input file, output file, input table and output table components.
• Developed UNIX Shell scripts to invoke Ab Initio generated scripts.
• Developed automated PL/SQL purging script to delete historical older than 2 years.
• Support PROD post implementation.

Environment: Ab Initio, EME, GDE, UNIX shell scripting, Oracle 10g, SQL Developer.

Senior Ab Initio Developer

Re sponsibilities:

• Involved in developing complex Ab Initio graphs and unit testing.
• Co-ordinated among team for technical resolution and guidance to the team members.
• Used Ab Initio components like filter by expression, partition by key, partition by expression, partition by round robin, join, roll-up, normalize, de-normalized sorted, reformat, scan, RUN SQL, replicate, input file, output file, input table and output table components.
• Developed UNIX Shell scripts to invoke Ab Initio generated scripts.
• Developed UNIX automated script to purge files older than 30 days.
• Support PROD post implementation.

Environment: Ab Initio, EME, GDE, UNIX shell scripting, Oracle 10g, SQL Developer.

Senior Ab Initio Developer

Re sponsibilities:

• Involved in enhancing complex Ab Initio graphs and unit testing.
• Analyzed PROD issues and fixed Ab Initio code.
• Developed minimal defect Ab Initio code and unit tested.
• Co-ordinated among team for technical resolution and guidance to the team members.
• Used Ab Initio components like filter by expression, partition by key, partition by expression, partition by round robin, join, roll-up, normalize, de-normalized sorted, reformat, scan, RUN SQL, replicate, input file, output file, input table and output table components.
• PROD deployment and meeting the SLA period.
• Support PROD post implementation.

Environment: Ab Initio, EME, GDE, UNIX shell scripting, Oracle 10g, Toad.

Computer Programmer

Re sponsibilities:

• As a team member involved in analyzing the problem.
• Developed Opening Balance Sheet, Budget Head Form, Scheme Chart Schedules in Oracle form and Report.
• Data administration and management.
• General office work and report to authority.

Environment: Oracle 9i, PL/SQL, Oracle Forms and Reports.