PROFESSIONAL SUMMARY:

• Over 11 years of IT experience with expertise in analysis, design, development and implementation of Data warehousing using ETL,BI and Tidal tools with Oracle, DB2 and MS SQL server, databases on windows platforms.
• Experience in installation/Configuration of PowerCenter/Power Exchange/Metadata Manager versions 9.5.1/9.1.0 on Microsoft Windows 2008 Virtual Environment.
• Experience in the Informatica Upgrade PowerCenter/Power Exchange/Metadata Manager from version 8.x to 9.x
• Experience in Upgrading the Cisco Tidal Enterprise Scheduler Tool from Version 5.x to 6.X.
• Expert level experience in Data Integration and Data Warehousing using ETL tool INFORMATICA PowerCenter/7.x/8.x/9.x. Knowledge of Informatica tools Power Exchange, PowerCenter, DataAnalyzer and MetaData Manager.
• Expert - level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files, XML files, Applications, COBOL Sources and Teradata.
• Good experience in using the Informatica Server Grid for high availability of resources.
• Proficient in implementing Complex business rules by creating re-usable transformations, workflows/worklets and Mappings/Mapplets.
• Experience in Performance Tuning of targets, mappings and sessions.
• Thorough knowledge of database management concepts like conceptual, logical and physical data modeling and data definition, population and manipulation. Expertise in logical and physical database design and Data Modeling using data modeling tools like Erwin.
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access, TeraData, DB2 design and database development using SQL, PL/SQL, SQL PLUS, TOAD, SQL-LOADER. Highly proficient in writing, testing and implementation of triggers, stored procedures, functions, packages, Cursors using PL/SQL.
• Experience in Task Automation using Power Shell Scripts, Job scheduling (Tidal) and Communicating with Server using pmcmd.
• Excellent analytical, problem solving, and communication skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 7.x/8.x/9.x, Power Exchange, Microsoft DTS and SSIS.

Analysis/Reporting Tools: Microsoft Analysis Services, Microsoft Reporting Services and Business Objects.

Databases: Oracle 10g/9i/8i, MS SQL Server 7.0/ 2000/2005/2008/2012, DB2,MS Access, Excel.

DB Tools: SQL*Plus, SQL* Loader, TOAD.

Operating Systems: UNIX, HP-UX, IBM-AIX, WINDOWS XP/NT/ 2000/98/95.

Languages: C, C++, Java, SQL, PL/SQL, T-SQL, HTML, DHTML, XML, UNIX, Shell Scripting, Visual basic, XML.

Application Servers: Oracle 9iAS, Web logic, Web sphere, IIS, Apache, Tomcat.

Data Modeling: ER Studio, All-Fusion Erwin, Visio.

Scripting Languages: Java Script, VB Script, Power Shell and UNIX Shell Scripting.

Data Cleansing: Trillium, First logic.

DataModelling/Methodologies: Logical/Physical/Dimensional, Star/Snowflake, ETL, OLAP, Complete Software Development Cycle.

Scheduling Tools: Cisco Tidal Enterprise Scheduler, Informatica Scheduler

PROFESSIONAL EXPERIENCE

Sr. Informatica Administrator

Confidential, Omaha, NE

Responsibilities:

• Installed and Configured Informatica PowerCenter/PowerExchange/Metadata Manager versions 9.5.1/9.1.0 on Microsoft Windows 2008/2012 Virtual Environment.
• Successfully Upgraded Informatica PowerCenter/PowerExchange/Metadata Manager/Web Services from Version 8.x to 9.x
• Responsible for Informatica/SQL/Tidal Code Migration into different environments like Development to Test and Test to Production.
• Responsible for Informatica application and system Production Support (24X7).
• Successfully Configured LDAP in PowerCenter for the single sign-on User Authentication.
• Responsible for Scheduling jobs in Tidal and also migrate the Tidal jobs to different environments using Tidal Transporter.
• Performed Cisco Tidal Enterprise Scheduler Upgrade from version 5.x to 6.x.
• Responsible for Creating Users/Groups in Informatica PowerCenter and provide the required access.
• Responsible for automating the Informatica Administrative tasks like Purge older version objects, Purge older version Session/Workflow logs.
• Interacted with Informatica Support to implement the DR strategies.
• Involved to increase the performance of the PowerCenter Repository by analyzing the metadata tables and Purging the Metadata.
• Create and Schedule the different resources for PowerCenter, SSRS, SQL Databases and ER Studio in Metadata Manager to get end to end metadata Lineage
• Create Users/Groups and configure the security in Metadata Manager
• Administrate the Databridge ETL client to clone the mainframe DMSII data to SQL Server database.
• Administrate the Cisco Tidal Enterprise Scheduler application.
• Installed and Configured the Informatica Adaptor for Tidal Enterprise Scheduler
• Work with Informatica Support to perform the Informatica Health Check on PowerCenter Repositories
• Installed and configured Undraleu Code Review Tool to automate the Informatica code review process
• Designed the C# application to automate the Informatica Code migration process
• Conducting research into Informatica related issues and working with developers and Informatica vendor when necessary.
• Implemented the Global Parameter file to simply the usage of Parameters across the environments.
• Create Folders/Connection Strings using Informatica PowerCenter tools
• Build the SQL database Instances for Informatica/Tidal Metadata databases
• Create and migrate PowerExchange Datamaps and perform the initial Row Test
• Create the Informatica Reports using DataAnalyzer
• Perform the capacity planning required to create and maintain the databases
• Monitoring the Jobs and sever space availability and CPU Process.

Environment: Informatica PowerCenter/Power Exchange/Metadata Manager 9.5/9.1/8.5/8.1/7. x, Oracle9i, SQL Server 2000/2005/2008/2012, Windows 2008, Tidal Enterprise Scheduler, Windows XP, TOAD8.0, MS office, ER Studio.

Informatica Developer

Confidential, DES MOINES, IA

Responsibilities:

• Involved in defining the Business requirement specifications and Functional specifications by directly interacting with the end-users and proposing corresponding Technical specifications for built.
• Translated requirements into business rules & made recommendations for innovative IT solutions
• Documented data conversion, integration, load and verification specifications.
• Involved in developing Hierarchical oracle queries.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Creating the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Research Sources and identify necessary Business Components for Analysis.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy & stored procedure transformation
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, mapping designer& Mapplets, and Transformations.
• Maintain Development, Test and Production mapping migration Using Repository Manager. Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Designed and developed Informatica mappings for data loads.
• Scheduled Sessions on the Informatica Server using Informatica workflow Manager.

Environment: Informatica PowerCenter/Power Exchange/Metadata Manager 9.1, Oracle10g, Unix, Windows 2012, Windows 7, Control M, MS office, ER Studio.

Informatica Developer

Confidential, Omaha, NE

Responsibilities:

• Involved in defining the Business requirement specifications and Functional specifications by directly interacting with the end-users and proposing corresponding Technical specifications for built.
• Translated requirements into business rules & made recommendations for innovative IT solutions
• Documented data conversion, integration, load and verification specifications.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Creating the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Research Sources and identify necessary Business Components for Analysis.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy & stored procedure transformation
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, mapping designer& Mapplets, and Transformations.
• Maintain Development, Test and Production mapping migration Using Repository Manager. Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Designed and developed Informatica mappings for data loads.
• Scheduled Sessions on the Informatica Server using Informatica workflow Manager.
• Extensively used SSRS for report generation.

Environment: Informatica PowerCenter/Power Exchange/Metadata Manager 8.1/7.x, Oracle9i, SQL Server 2000/2005, Windows 2008, Windows XP, TOAD8.0, MS office, ER Studio.