SUMMARY

• IT professional wif 9+ years of extensive experience in project design, architecture, development and testing of various applications using Abinitio ETL Tool under AIX UNIX, Linux, Windows environments.
• Extensive experience wif development in complex and high volume Abinitio ETL applications including requirement gathering, design, implementation, unit testing, debugging, documentation under Unix Environment. Good experience in leadership as well. Excellent Data warehousing technical skill set wif robust knowledge of DWH architecture.
• Hands on experience on PDL metaprogramming, XML data processing, generic graph implementation, advanced Abinitio components, psets, Conduct IT plans and Abinitio product tools like Abinitio GDE, Cooperating system, Abinitio operational console, EME Technical Repository, metadata hub. Sound understanding of Data Profiler, Control Center, BRE.
• Strong experience in both waterfall as well as agile methodology.
• Experience in requirement gathering, impact analysis, data cleansing, data transformations, data relationships, source systems analysis.
• Adequate knowledge and experience of Data Mart, Data Modeling, Dimensional Modeling, OLTP, OLAP, star schema, snowflake schema, data warehousing concepts, fact and dimensions tables, logical & physical data modeling, ETL processes, SCD, data analysis, surrogate keys and normalization/de - normalization.
• Strong working experience in RDBMS development using Oracle, Teradata and MS SQL Server and large scale database management including building and tuning complex SQL queries. Good understanding of Teradata Architecture and load utilities.
• Good exposure to UNIX shell scripting, commands, problem solving and analytical capabilities.
• Good experience in various kinds of testing like Unit testing, Regression testing, and System integration testing, Manual testing including preparation of test plan, creation of test cases, test case documents, test data creation.
• Excellent understanding of the SDLC, PMLC.
• Extensive knowledge and experience of Banking and Financial, Retail Domain applications.
• Experience in providing 24*7 Production Support and real time issue resolution for ETL applications.
• Extensive Knowledge in Banking and Financial, Retail Projects.
• Excellent communication, interpersonal skills and strong ability to work as part of a team and as well as handle independent roles wif positive attitude towards responsibilities and challenges.

TECHNICAL SKILLS

ETL Tools: Ab Initio (GDE 3.1.6.2, Co-Operating System 3.2.4.6), EME, Ab Initio Operation Console 3.1.3.2, Metadata Hub 3.1.3.1, Technical Repository, Control Center, Conduct It, BRE

Databases: Teradata 13.0, Oracle 11.1, MS SQL Server 2000, Oracle SQL Developer 1.5.5, Toad for Data analyst 2.6

Data Modeling: Star schema and Snowflake Schemas.

Tools: IBM Job Scheduling Console, Secure CRT, Lotus Notes, SQL Assistant, Service Now, JIRA SQL Assistant, Control M, Autosys, HP ALM QC

Programming: C, C++, SQL, UNIX Shell Scripting, Korn Shell

Operating Systems: Windows NT/98/2000/XP, IBM AIX 5.0/5.2/5.3, Linux, Mainframe

EDUCATION: BE Computer (First class wif Distinction)

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Ab Initio Tech Lead and Developer

Environment: Abinitio (GDE 3.1.6.2, Co-Operating System 3.2.4.6), EME, Metadata Hub, UNIX shell Scripting, Teradata 13, Mainframe, Oracle SQL Developer 1.5.5, Unix AIX, HP ALM QC, Control M

Responsibilities:

• Implemented end to end Abinitio applications for one of the Individual extract and real time mini batch processing application, process to auto generate and send statistics consolidated report for all extract using Abinitio graphs, psets, plans, Unix Shell scripting.
• Requirement gathering by interacting wif client/business, creating impact analysis and design documents, proposing solutions, defect fixing and estimating the hours. Working proactively and independently to articulate issues/challenges to address project delivery risks.
• Worked in onshore-offshore model and lead offshore team of 6 members. Interact wif release management, configuration management and quality assurance, database modeling support, other upstream and downstream development teams and operation support team.
• Handling various kinds of activities like development of complex code, enhancements, testing, problem resolution etc.
• Providing unit testing, module testing, and regression testing and system integration testing of the scripts, graphs, psets, plans and queries.
• Code reviews to ensure code developed meets the requirements.
• Provide KT sessions, preparing documentation, mentoring junior resources.

Confidential

Onsite Ab Initio Tech Lead and Developer

Environment: Abinitio (GDE 3.1.5, Co-Operating System 3.1.5), EME, Metadata Hub, UNIX shell Scripting, Teradata 13, Mainframe, Unix AIX, HP ALM QC, Control M

Responsibilities:

• Involved in requirement gathering meetings, data planning, sprint planning, retrospective sessions and stand up calls wif client, UAT wif business users.
• Prepared impact analysis and design documents, proposing solutions, defect fixing and estimating the hours.
• Managing all development tasks and activities in JIRA.
• Working proactively and independently to articulate issues/challenges to address project delivery risks.
• Worked in onshore-offshore model and coordinating team of 8 members from onsite.
• Interact wif release management, configuration management and quality assurance, database modeling support, other upstream and downstream development teams and operation support team.
• Handling various kinds of activities like development of complex code, enhancements, testing, problem resolution etc.
• Code reviews to ensure code developed meets the requirements.
• Provide KT sessions, preparing documentation, mentoring junior resources.

Confidential

Onsite Ab Initio Tech Lead and Developer

Environment: Abinitio (GDE 3.1.2.2, Co-Operating System 3.1.2), EME, Metadata Hub, UNIX shell Scripting, Teradata 11, Mainframe, Unix AIX 7.1, HP ALM QC, Abinitio Operation Console, SQL server 2008, Service Now, Toad for data analysis, Conduct IT, BRE

Responsibilities:

• Involved in requirement gathering meetings, data planning, client meetings to understand the new requirements, existing applications problems.
• Prepared impact analysis and design documents, proposing solutions, defect fixing and estimating the hours.
• Working proactively and independently to articulate issues/challenges to address project delivery risks.
• Worked in onshore-offshore model and coordinating team of 11 members from onsite.
• Interact wif release management, configuration management and quality assurance, database modeling support, other upstream and downstream development teams and operation support team.
• Handling various kinds of activities like development of complex code, enhancements, testing, problem resolution etc.
• Code reviews to ensure code developed meets the requirements.
• Provide KT sessions, preparing documentation, mentoring junior resources.
• Providing support to developed applications, resolving problems and closing tickets.
• Generating reports for weekly status meetings wif clients.

Confidential, Cleveland, OH

Ab Initio Tech Lead and Developer

Environment: Abinitio 3.0.5, 3.1.5, SQL server, Teradata, Unix AIX, Mainframe, Autosys

Responsibilities:

• Implemented end to end Abinitio applications for one of the Individual extract and real time mini batch processing application, process to auto generate and send statistics consolidated report for all extract using Abinitio graphs, psets, plans, Unix Shell scripting.
• Requirement gathering by interacting wif client/business, creating impact analysis and design documents, proposing solutions, defect fixing and estimating the hours. Working proactively and independently to articulate issues/challenges to address project delivery risks. Worked in onshore-offshore model and lead offshore team.
• Interacting wif release management, configuration management and quality assurance, database modeling support, other upstream and downstream development teams and operation support team.
• Handling various kinds of activities like development of complex code, enhancements, testing, problem resolution etc.
• Providing unit testing, module testing, and regression testing and system integration testing of the scripts, graphs, psets, plans and queries.
• Code reviews to ensure code developed meets the requirements.
• Provide KT sessions, preparing documentation, mentoring junior resources.

Confidential

Ab Initio Tech Lead and Developer

Environment: AbInitio (GDE 3.0.2.1, Co-Operating System 3.0.2) and (GDE 1.15, Co-Operating System 2.15, UNIX shell Scripting, Teradata, Control M

Responsibilities:

• Understanding the business requirements, analyzing the FDR, creating impact analysis, technical design documents and source to target mapping documents.
• Interacting wif client to get the requirement and provide technical solutions.
• Lead and mentor the junior resources of team.
• Developing SQLs in Teradata for data analysis, verifying output and debugging of issues.
• Developing Abinitio graphs to process data coming from source systems by extracting it from Teradata tables, applying business rules to create required final Unix file.
• Unit testing, Module testing, Regression Testing and System Integration Testing of the scripts, graphs, psets, plans, queries.
• Creation of test cases, test case documents as well as test data.
• Code reviews, test case reviews to ensure code developed meets the requirements.
• Suggesting the schedule and dependencies for the jobs.

Confidential, Chicago

Ab Initio Developer

Environment: Ab Initio (GDE 1.13, 1.14, 1.15), Teradata V2 R5, Teradata, IBM AIX 5.3, Secure CRT, IBM Tivoli JS Console

Responsibilities:

• Analyzing the HLD, source to target mapping documents, understanding business requirements.
• Interacting wif OSC (Onsite Coordinator) / Client and leading the team.
• Developing Abinitio graphs to process and transfer data from UNIX files into Teradata.
• Testing the graphs using sample input data through Ad Hoc runs.
• Performing Data Quality checks on the data as-per the business requirements.
• Suggesting the schedule, and dependencies for the jobs, creating the data stores and installing the applications on production server.
• Monitoring the jobs for the first run on production before handover to support team.
• Conducting knowledge sharing sessions and mentoring junior team members.
• Involved in providing production support of already developed appication on rotation basis for a week during a span of 3-4 months.