SUMMARY

• Over 15 years of experience in System Analysis, Design, development and implementation of Relational Database (OLTP) and Data Warehousing Systems (OLAP) using Informatica, Oracle, Teradata, Sybase, SQL Server, flat files and .csv files.
• Expertise in Software Development Life Cycle and good understanding of Database Design, Dimension Modeling, ETL framework, Data Mart designs and production support.
• Extensive experience working with Teradata, Oracle, Sybase, SQL Server and MS Access databases.
• Experience in performance tuning of mappings and sessions with complex transformations using Informatica.
• Expertise in implementing complex business rules by creating robust mappings, mapplets and reusable transformations using Informatica Power Center and Power Mart.
• Experience with performance tuning of SQLs and creating procedures and macros in RDBMS.
• Experienced in handling and working with large database systems, developing and supporting ETL and Front - End development teams.
• Strong experience in all phases of SDLC encompassing Requirement Analysis, Design, Code development, Unit Testing, and application support.
• Experience in Data warehousing concepts, star-schema & snow-flake design and ETL processes.
• Worked on Operating systems such as Sun Solaris, UNIX, Linux and Windows.
• Experience Designing, Developing, Documenting and Testing of ETL Jobs and Mappings.
• Experience with Change Data Capture (CDC) of Informatica power exchange.
• Involved in the design of Initial load and incremental load mappings to load data on daily/weekly/monthly basis.
• Developed Unix Shell scripts to run Informatica workflows and used Control-M scheduling tool.
• Experience in Onshore and Offshore model and driving daily meetings.
• Interacting with different teams (Informatica Admin, Database Admin, Network Admin, UNIX, Offshore Team, Onsite Team, Business (End Users), Third Party, ETL, Scheduling).
• Worked on Master documents like Informatica naming standard, Development & Review check list.
• Ability to quickly understand business requirements and analyze large amounts of data, build cross-checks and validation, identify discrepancies, and resolve them.
• Good communication, analytical and interpersonal skills. Enthusiastic and ability to adapt to new environment quickly.

TECHNICAL SKILLS

ETL Tools: Informatica 5.x through to 9.0.1, Informatica power exchange.

RDBMS: Teradata, Oracle, Sybase, SQL Server and MS Access

Programming skills: Shell scripting, PL/SQL, C#

Operating systems: Sun Solaris, Linux, Windows

Scheduling tools: Control-M, Maestro Microsoft Visual Studio .Net (C#) Borland C++ Builder Visual basic 6.0

PROFESSIONAL EXPERIENCE

Confidential, Cary, NC

Lead

Responsibilities:

• Developed Informatica mappings, sessions and workflows for POCs.
• Query tuning for SQLs and Informatica.
• Coding changes in shells script (Shell programming).
• Redesigned the ETL model with stage tables and also the process to increase performance.
• Performance tuning of mappings and sessions with complex transformations using Informatica.
• Code Reviews, Training and mentoring offshore resources.
• Gathering Business knowledge & Sharing to offshore team.
• Requirement gathering for enhancements and bug fixes.
• Interacting with different teams (Informatica Admin, Database Admin, Network Admin, Unix, Offshore Team, Onsite Team, Business (End Users), Third Party, ETL, Scheduling).
• ETL Design and development for migration.
• Coding Complex and Critical Views, Stored procedures, SQLs.
• Developed mappings, table/s Migration from Oracle to DB2 RDBMS.

Confidential, New York, NY

Lead

Responsibilities:

• Query tuning for SQLs and Informatica.
• Performance tuning of mappings and sessions with complex transformations using Informatica.
• ETL Design and development.
• Developed Informatica mappings, sessions and workflows.
• Creating mappings, sessions and workflows.
• Coding shells script (Shell programming).
• Code Reviews, training and mentoring offshore resources.
• Coding Complex and Critical Stored procedures, Views and SQLs.
• Coding in c#, Microsoft Visual Studio .Net 2010.
• Developing batch process using Windows and control-M scheduler.
• Gathering Business knowledge & Sharing to offshore team.
• Interacting with different teams (Informatica Admin, Database Admin, Network Admin, UNIX, Offshore Team, Onsite Team, Business (End Users), Third Party, ETL, Scheduling).
• Redesigned the ETL model with stage tables and also the process to increase performance.
• Requirement gathering for enhancements, bug fixes, training and mentoring offshore resources.
• Coding in Teradata Macros & BTEQs.
• Developed ETL for CLOB & BLOB table/s Migration.
• Auto Batch Grids ETL has been developed using C# for the end user reports.
• Sync process has been done from oracle to Teradata using C# code.
• Production support has been done for completed modules.

Confidential, Stamford, CT

Senior Developer

Responsibilities:

• Developed Informatica mappings, sessions and workflows
• Query tuning for SQLs and Informatica
• Developing batch process using Windows and control-M scheduler
• Coding shells script (Shell programming).
• Redesigned the ETL model with stage tables and also the process to increase performance.
• Performance tuning of mappings and sessions with complex transformations using Informatica.
• Code Reviews, training and mentoring offshore resources.
• Requirement gathering, gathering Business knowledge & Sharing to offshore team
• Interacting with different teams (Informatica Admin, Database Admin, Network Admin, Unix, Offshore Team, Onsite Team, Business (End Users), Third Party, ETL, Scheduling).
• ETL Design and development.
• Creating mappings, sessions and workflows.
• Coding Complex and Critical Views, Stored procedures, SQLs.

Confidential

Senior Developer

Responsibilities:

• Developed Procedures in Oracle.
• Coding Complex and Critical Views, SQLs
• Requirement gathering.
• Coding in ASP.Net
• Application Testing and bug fixing.
• Creating tables and Indexes and PKs and FKs in Oracle

Confidential

Developer

Responsibilities:

• Developed Procedures in Oracle.
• Coding Complex and Critical Views, SQLs
• Requirement gathering.
• Coding in ASP.Net, Visual Studio 6.0.
• Application and ETL Testing and bug fixing.
• Creating tables and Indexes and PKs and FKs in Oracle

Confidential

Developer

Responsibilities:

• Developed Procedures in Sybase & SQL Server.
• Coding Complex and Critical Views, SQLs
• Requirement gathering.
• Coding in ASP.Net, Visual Studio 6.0 & Borland C++ Builder
• Application and ETL Testing and bug fixing.
• Creating tables and Indexes and PKs and FKs in Sybase and SQL Server.