SUMMARY:

• Over 7 years of experience in teh IT industry as a Lead ETL Ab Initio Developer.
• Sound knowledge of Retail Domain and extensive experience as Lead ETL Ab Initio Developer for teh Supply Chain Projects of Confidential, USA.
• Able to work independently as well as in a team environment.
• Extensive Hands - On experience to work in teh USA IT Industry
• Excellent understanding of teh System Development Life Cycle (SDLC).
• Involved in analysis, design, development, testing, implementation, and maintenance of various applications.
• Specialized in ETL methodology for supporting data analysis in a corporate-wide-ETL solution using Ab Initio.
• Proficiency in utilizing ETL tool Abinitio 3.1.2 for developing teh Data warehouse loads wif work experience focused in Data Integration as per client requirement.
• Extensively used Ab Initio-EME data store/sandbox for version control, code promotion, and impact analysis.
• Well versed wif various Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism and Multi File System (MFS) techniques.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing using Ab Initio
• Developed Ab-Initio graphs to fetch data from DB2, Oracle, Teradata, Excel, flat files, XML Files.
• Experience in Teradata utilities Fast Load, Multi Load, Fast Export and SQL Assistant.
• In-depth knowledge of UNIX Shell scripting.
• Experience in Dimensional Layer Modeling (Facts, Dimensions, Business Measures and Grain of teh Fact etc.) and in-depth knowledge of Complex Data Models of Relational, Star, and Snowflake schema.
• Experience to create vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Experience to work wif senior management to identify strategic goals, objectives, scope, budgets and process for internal and external development and to manage risk analysis and mitigation plans, status reports and client presentations.
• Expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• Exceptional ability to work in a geographically distributed virtual team environment and to build relationships wif internal and external organizations.
• Flexible, enthusiastic and project oriented team player wif excellent communication skills wif leadership abilities to develop creative solution for challenging requirement of client.
• Ability to understand long-term project development issues at all levels, from interpersonal relationships to teh details of coding scripts wif strong analytical, organizational, presentation and problem solving skills.

TECHNICAL SKILLS:

ETL Tools: Ab- Initio (GDE 3.1.2 Co>Operating system 3.12.3)

RDBMS: DB2, Teradata, Oracle, SQL Server

DB Tool: IBM DB2 Command Center, Db Visualizer, Teradata SQL Assistant, SQL*Loader

Languages: C, C++, SQL, PL / SQL, XML, and Shell Scripting

Platforms: HP-UX UNIX, Windows, Mainframes

Modelling Tools: MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, GA

Lead ETL Ab Initio Developer

Responsibilities:

• Met wif business/user groups to understand teh business process and gather requirements.
• Extracted and analyzed teh sample data from operational systems (OLTP system) to validate teh user requirements and Created high level design documents.
• Participated in data model (Logical/Physical) discussions wif Data Modelers and created both logical and physical data models. Implemented Star Schema models for teh above data warehouses by creating facts and dimensions.
• Carried teh detailed profiling of operational data using Ab Initio Data Profiler/SQL Tool to get better understanding of teh data that can be used for analytical purpose for Business/User groups.
• Participated Agile Iterative sessions to develop Extended Logical Models and Physical Models.
• Created mapping document and ETL design document.
• Development of reusable Abinitio Graphs and Plans required as part of new process.
• Carried teh performance tuning on teh Ab Initio graphs to reduce teh process time.
• Created several SQL queries and created several reports using teh above data mart for UAT and user reports.
• Involved in after implementation support, user and data models walkthroughs wif business/user groups.
• Automated teh entire Data Mart process using UNIX Shell scripts and scheduled teh process using TWS, Job Track after dependency analysis.
• Extensively used teh Teradata utilities like Fast load, Multi load, DDL Commands and DML Commands (SQL).

Environment: Ab Initio (GDE 3.1.2 Co>Op 3.12.3), BRE, Shell Scripting, DB2, Teradata, Oracle, PL/SQL, Tivoli Workload Manager and UNIX

Confidential

UNIX Developer

Responsibilities:

• Creating system design documents by analyzing teh requirements.
• Extracted and analyzed teh sample data from operational systems (OLTP system) to validate teh user requirements and Created high level design documents.
• Created mapping document and design document.
• Development of UNIX and Informix 4GL code as part of new process.
• Carried teh performance tuning on teh process to reduce teh process time.
• Coding and Performing quality related activities such as Code Walkthrough, IQA to provide defect free delivery.
• Analyzing teh problems identified either during teh Unit Testing, System Testing or Integration Testing, tracking problems and applying teh fixes.
• Performing implementation and code migration activities.
• Involved in after implementation support, user and data models walkthroughs wif business/user groups.

Environment: UNIX, Shell Scripting, DB2, PL/SQL, Informix 4GL, C and Tivoli Workload Manager.

Confidential

Support Executive Member

Responsibilities:

• Batch Support of POS applications.
• Daily Updates to SES Zone tool
• Support Documentation Updates.

Environment: UNIX, Shell Scripting, DB2 and PL/SQL