SUMMARY:

• 12 + years of Total IT experience in the Requirement Analysis, Data Analysis, Application Design, Application Development, Implementation and Testing of Applications in Data warehousing and worked in various sectors like Elections, Financial, Banking, and Insurance domains.
• Experience in Designing and Developing Business Intelligence solutions in Data Warehousing Decision Support Systems using ETL Tools like Oracle Warehouse Builder(OWB), SQL Server Integration Services (SSIS), Informatica PowerMart / PowerCenter v4.7, 5.1, 6.2, 7.1, 8.6 SypherLink Spoon and Pervasive.
• Strong programming and debugging skills in PL/SQL, SQL, DB2 and Dynamic SQL.
• Extensive experience with SQL Server and T - SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Strong ETL experience using Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Mappings, Mapplets, Transformations)
• Created ODI interfaces for loading the data from Oracle to CDW and from CDW to different Marts using - Topology, Security Manager, Designer and Operator.
• Experience in Data warehousing and Business Intelligence applications focusing on data warehouse analysis and design. Data sourcing, Mapping creation, transformation and loading and performance tuning.
• Expertise in utilizing Oracle Utility tools like SQL*Loader, Import and Export.
• Extensive Experience in Informatica Production Support.
• Data modeling experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.x.
• Good communication skills, interpersonal skills, team coordination and versed with Software Development processes.
• Extremely Hardworking, Sincere and Self dependent in resolving critical Issues.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi site development.

TECHNICAL SKILLS:

Primary skills: Informatica Power Center 8.6.1, 9.0.1, 9.1.0, 9.5.0, 9.6.1, IDQ 9.1.0, PWX 9.1.0 and PWX 9.6.1

Modeling Tool: Power Designer 12.5, Oracle Sql Developer Data Modeler

Domain skills: Finance, Manufacturing, Elections

Languages known: SQL, PL/SQL, T-SQL, Unix Shell, C/C++, Java, VB 6.0, VB.net, ASP.net, C#, VBA.

Scheduling Tools: Autosys, Control-M, ESP

Migration Tool: Kintana

Data Warehousing: Oracle Warehouse Builder, Oracle Data Integrator (ODI), SQL Server Integration Services (SSIS), SypherLInk, Informatica Power Center 9.6.1 / Power Mart 8.6, 9.1, Pervasive, Informatica Data Quality, Meta Data Management (MDM)

Operating System: MS DOS 6.22, Win 3.x/95/98, Win NT 4.0, 2003/2000/XP, Sun Solaris, Linux and AIX.

Other tools: TOAD 9.5, Query Analyzer, Remedy BMC Software, Quality Center

PROFESSIONAL EXPERIENCE:

Confidential, WI

Sr. Informatica Developer/ Middleware Administrator

Responsibilities:

• Extensive experience with Informatica Power Exchange, Replicator, Power Center transformation types and reusable components
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Developed mappings/sessions using Informatica Power Center 9.6.1 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Installed and configured Power Center 9.1.0 and 9.6.1 on UNIX and Windows platform.
• Installed and configured Informatica Power Exchange CDC 9.1.0 and 9.6.1 for Sql Server on UNIX/Windows platform.
• Installed and configured Metadata Manager Service, Data Analyzer and Web Service Hub.
• Performed Informatica upgrade from 9.1.0 to 9.6.1.
• Installed and configured the IDQ 9.6 components on AIX UNIX/Windows Servers.
• Configured OS Profiles and LDAP Authentication.
• Monitor and troubleshoot the Informatica domain, Creating and maintaining Grids and Nodes
• Installed and configured Informatica Support Console 1.5 to proactively monitor the environment.
• Designed and documented ETL standards document.
• Creation and maintenance of Informatica users and privileges.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments. Created Groups, roles, privileges and assigned them to each user group. worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and scripts using Informatica Command line utilities

Environment: Informatica Power Center, 9.1.0 HF6, 9.6.1 HF4, PWX 9.1.0, PWX 9.6.1, Informatica Data Quality 9.1.0, Sql Server 2008, MFT server (Managed File Transfer) and Control-M.