SUMMARY

• With more than 7 years of experience in the IT industry, I have worked on projects that deal with cutting edge technology, across various cross - functional and multi-cultural teams. Career began in this innovative, fast paced environment, sparking my interest in design and development of applications.
• Over 7 years of experience in the IT industry as a Lead ETL Ab Initio Developer.
• Sound knowledge of Retail Domain and extensive experience as Lead ETL Ab Initio Developer for the Supply Chain Projects of The Confidential, USA.
• Able to work independently as well as in a team environment.
• Extensive Hands-On experience to work in the USA IT Industry
• Excellent understanding of the 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 the Data warehouse loads with 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 with 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 the 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 with 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 with internal and external organizations.
• Flexible, enthusiastic and project oriented team player with excellent communication skills with 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 the details of coding scripts with strong analytical, organizational, presentation and problem solving skills.

TECHNICAL SKILLS

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

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

Lead ETL Ab Initio Developer

Confidential - Atlanta, GA

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.

Responsibilities:

• Met with business/user groups to understand the business process and gather requirements.
• Extracted and analyzed the sample data from operational systems (OLTP system) to validate the user requirements and Created high level design documents.
• Participated in data model (Logical/Physical) discussions with Data Modelers and created both logical and physical data models. Implemented Star Schema models for the above data warehouses by creating facts and dimensions.
• Carried the detailed profiling of operational data using Ab Initio Data Profiler/SQL Tool to get better understanding of the 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 the performance tuning on the Ab Initio graphs to reduce the process time.
• Created several SQL queries and created several reports using the above data mart for UAT and user reports.
• Involved in after implementation support, user training and data models walkthroughs with business/user groups.
• Automated the entire Data Mart process using UNIX Shell scripts and scheduled the process using TWS, Job Track after dependency analysis.
• Extensively used the Teradata utilities like Fast load, Multi load, DDL Commands and DML Commands (SQL).

UNIX Developer

Confidential

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

Responsibilities:

• Creating system design documents by analyzing the requirements.
• Extracted and analyzed the sample data from operational systems (OLTP system) to validate the 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 the performance tuning on the process to reduce the process time.
• Coding and Performing quality related activities such as Code Walkthrough, IQA to provide defect free delivery.
• Analyzing the problems identified either during the Unit Testing, System Testing or Integration Testing, tracking problems and applying the fixes.
• Performing implementation and code migration activities.
• Involved in after implementation support, user training and data models walkthroughs with business/user groups.

Support Executive Member

Confidential

Responsibilities:

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

Environment: Ab Initio, UNIX, Shell Scripting, PL/SQL, Data Warehouse Architect Teradata, DB2, Oracle, Talend and Data Profiling.