SUMMARY:

• 9 years ofTotal IT experiencein Business Requirements Analysis, Designing, Coding, Development, Testing and Implementation with RDBMS, Data Warehouse/Data marts, ETL, OLAP, Client/Server environment.
• Expert knowledge in Data Warehouse applications, involved in the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse Using Informatica Power Center 9.1/8.x/7.1/6.2.
• Expert knowledge in SQL, PL/SQL and more than five years as Oracle 7x, 8i / 9i/10g of Oracle Database designer experience
• Team lead experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing, Production support and Documentation
• Proficient in writing UNIX shell scripts.
• Worked extensively and given support to large volumes of oracle database ranging to Tera bytes.
• Excellent skill over UNIT Testing. Integration testing and User acceptance testing.
• Commendable contributions towards Data Integration Projects.
• Cataloged projects from conceptual phase to go - live phase by utilizing Technical and Project Management skills.

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter 9.1/8.6.1/8.6/8.0/7.1. x/

BI & Reporting: Cognos 7.1/7.3/7.4 and Cognos -8, Business Objects XI/6.5/6.0 Power play, Transformer, Impromptu Web Reports (IWR), Business Objects

Databases: Oracle 10g/9i/8i/8.0/7.3, SQL Server, Tera Data

Programming: SQL, PL/SQL, UNIX Shell Scripting, Batch Scripting, Perl Scripts

Job Scheduling: Appworx

Environment: UNIX (Sun Solaris, HP-UX, AIX), Windows server 2007/2003/2000/ XP/98, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, New Orleans LA

Lead ETL/Data Warehouse Developer

Responsibilities:

• Co-coordinating with the end users for the requirements and converting them into technical specifications.
• Creation and versions maintenance for Functional Specification document, Technical Design Document, as a part of Project Management Methodologies (dPMM) tollgate reviews, design reviews,code reviews, detailed functional specifications,detailed technical design documents and risk assessments
• Extensively used Informatica Transformations, which includes Union, Look Up, Rank, Aggregator, Filter, Router, Joiner, Sequence Generator, Update Strategy, Stored procedure, and Expression
• Involved in complete life cycle of Software Development process right from Requirement gathering to Deployment of code to Production.
• Along with NACH file format, handled multiple data sources (Flat files, SQL Server, COBOL) into Data Warehouses.
• Used Repository Server Administration console to perform Repository maintenance tasks like add, edit repositories, Backup and restore repositories, Releasing locks and promoting a local repository to global repository etc
• Developed batch scripts to manage the incoming source files and to automize the loads.
• Involved in designing the Data warehouse, creating tables, Indexes, Procedures, Packages, Sequences and other performance methodologies as a part of Performance tuning.
• Involved in performance tuning of the Informatica mapping using various components like Parameter files, Variables and Dynamic Cache.
• Documenting the ETL design specifications and mappings and maintaining the version control of mappings, which are changed according to the business rules
• Involved in test case preparation and Performed UNIT Testing. Integration Testing and User acceptance testing.

Environment: Informatica Power Center 9.1(Power Center Designer, workflow manager, workflow monitor, Admin Console, Repository Manager), SQL Server, WINDOWS, COBOL, Batch Scripts

Confidential, Cincinnati OH

Lead ETL/Data Warehouse Developer

Responsibilities:

• Lead a team of developers involving them in making the client tasks successful using ETL and oracle as well.
• Documenting the ETL design specifications and mappings and maintaining the version control of mappings, which are changed according to the business rules
• Creation and versions maintenance for Functional Specification document, Technical Design Document, as a part of Project Management Methodologies (dPMM) tollgate reviews, design reviews,code reviews, detailed functional specifications,detailed technical design documents and risk assessments
• Designed and customized data models for data warehouse supporting data from multiple sources.
• Involved in Data Architecture and System Architecture and designed Database Tables for RDBMS system using ERWIN.
• Developed various Mapplets, Transformations and validated and fine-tuned the ETL logic coded into mappings.Extensively used Informatica Transformations, which includes Union, Look Up, Rank, Aggregator, Filter, Router, Joiner, Sequence Generator, Update Strategy, Stored procedure, and Expression
• Writing PL/SQL procedures to handle complex Business logic.
• Provided operational support, maintenance and development of a 15to30 terabyte Oracle based Data warehouse.
• Used Repository Server Administration console to perform Repository maintenance tasks like add, edit repositories, Backup and restore repositories, Releasing locks and promoting a local repository to global repository etc.
• Developed data loading plans to seamlessly automate the data loading procedures from multiple data sources (Flat files, SQL Server, Oracle) into Data Warehouses.
• Maintenance of hierarchies that were extracted through Smartview.
• Involved in designing the Data warehouse, creating tables, Indexes, Procedures, Packages, Sequences and other performance methodologies as a part of Performance tuning.
• Used shell scripts for making the running procedure of mapping automated and as event based.
• Involved in test case preparation and Performed UNIT Testing. Integration testing and User acceptance testing.

Environment: Informatica Power Center 8.1(Power Center Designer, workflow manager, workflow monitor, Admin Console, Repository Manager), Oracle 10g, UNIX, COBOL, XML, Cognos 8, Oracle 10g

Confidential, Cincinnati OH

Lead ETL/Data Warehouse Developer

Responsibilities:

• Lead a team of developers involving them in making the client tasks successful using ETL and oracle as well.
• Co-coordinating with the end users for the requirements and converting them into technical specifications.
• Creation and versions maintenance for Functional Specification document, Technical Design Document, as a part of Project Management Methodologies (dPMM) tollgate reviews, design reviews,code reviews, detailed functional specifications,detailed technical design documents and risk assessments
• Designed and customized data models for data warehouse supporting data from multiple sources.
• Involved in Data Architecture and System Architecture and designed Database Tables for RDBMS system using ERWIN.
• Involved with the design of the data warehouse project.
• Designed and developed Data mart using ERWIN Tool
• Involved in creating Indexes and other performance methodologies as a part of Performance tuning.
• Involved in performance tuning of the Informatica mapping using various components like Parameter files, Variables and Dynamic Cache
• Performance tuning to decrease the load time by 60 % by using partitioning and optimization techniques.
• Worked extensively on large volumes of databases ranging to Terabytes. Majorly Involved in designing of Data warehouse and creating tables, Indexes, Procedures, Functions, Packages, Sequences using SQL, PL/SQL.
• Involved in test case preparation and performed UNIT Testing. Integration Testing and User acceptance Testing
• Used Adminstration console to add, edit repositories, Backup and restore repositories, Releasing locks and promoting a local repository to global repository etc.
• Used shell scripts for making the running procedure of mapping automated and as event based
• Created shell scripts for automation of file transfers, decoding files and scheduling the workflow runs.
• PL/SQL scripts for reporting the database activity analytics on a daily basis.

Environment: Informatica Power Center 8.1(Power Center Designer, workflow manager, workflow monitor, Admin Console, Repository Manager), Cognos 7, Oracle 9i, SQL, PL/SQL, UNIX,XML, PERL Scripting

Confidential

ETL/Data Warehouse Developer

Responsibilities:

• Involved in complete life cycle of ETL process for data movement from Transient to Staging and finally to Warehouse.
• Analyzed critical/complex processes of application packages to design ETL processes and adopted strategy to prevent failures and acted swiftly to recover from application failures
• Developed data loading plans to seamlessly automate the data loading procedures from
• Multiple data sources (Flat files, SQL Server, Oracle) into Data Warehouses
• Involved in test case preparation and performed UNIT Testing. Integration Testing and User acceptance Testing
• Supported the Informatica developers in Database Server Performance, tracking user activity, troubleshooting errors, tracking server resources and activities, tracing server events
• Creation and running of workflows and sessions in Workflow Manager.
• Involved in performance tuning of the Informatica mapping using various components like Parameter files, Variables and Dynamic Cache.
• Majorly Involved in designing of Data warehouse and creating tables, Indexes, Procedures, Functions, Packages, Sequences using SQL, PL/SQL.
• Used shell scripts for making the running procedure of mapping automated and as event based.
• Documenting the ETL design specifications and mappings and maintaining the version control of mappings, which are changed according to the business rules.
• Developed Cognos8 reports for the end users to analyze the data in Data warehouse.

Environment: Informatica Power Center 7.4, Cognos, Tera Data, SQL, PL/SQL, and UNIX

Confidential, Cincinnati OH

ETL/Data warehouse Developer

Responsibilities:

• Monitoring the jobs using Informatica Workflow Monitor and Appworx.
• Fixing the Informatica job aborts. Analyzing the root cause of the issues/aborts and providing the permanent fix using ETL tool.
• Interact with the End User to understand the problem. Involved in test case preparation and performed UNIT Testing. Integration testing and user acceptance testing.
• Majorly Involved in designing of Data warehouse and creating tables, Indexes, Procedures, Functions, Packages, Sequences using SQL, PL/SQL.
• Identifying root cause of repeatable tickets and suggest a permanent fix to these tickets. Coordinating work efforts with other support teams to find and correct root causes of problems for interface applications.
• Suggesting process improvements to optimize RTS efforts Disaster recovery support and testing.
• Maintaining the document after fixing the bug for user manual.
• Prioritizing ticket as a process of support activity to provide seems less solution.
• Attending daily call with customer to report the criticality of various applications on daily basis.

Environment: Informatica Power Center 6.2, Cognos, Tera Data, SQL, PL/SQL, UNIX.