SUMMARY:

• 13+ years of experience in IT Industry with experience in analysis, design, testing, development, documentation and implementation of client server applications.
• 8+ years of Informatica Admin Experience using Informatica Power Center 10.1/9.5/9.1/8.5/7.1 , Power Exchange 9.5/9.1/8.6/8.0 , Warehouse Designer, Power Connect, Power Plug, ETL, Datamart, TIDAL, OLAP, OLTP, Business Objects 5.1/5.0 (Web - Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0).
• 2+ years of experience with Informatica B2B Data Exchange and Data Transformation Studio.
• 2+ years of experience with Informatica Data Quality (IDQ).
• Strong analytical and conceptual skills in database design and development using Oracle 11g/9i/8i/8.0/7.3, MS Access, MS Excel, Sybase 12.0/11.x/10, MS SQL Server 2000/7.0/6.5/6.0 , DB2.
• Installation and upgrade of Informatica Version 9.5/9.1 and version and 8.6 on Solaris/Linux/AIX/Windows.
• Responsible for interacting with business partners to identify information needs and business requirements for reports.

TECHNICAL SUMMARY:

Data Warehousing: Informatica (PowerCenter 10.1/9.5/9.1//8.6 , Informatica PowerMart 5.1.2/5.0/4.7.2 , Data Warehousing Designer, Mapping Designer, Transformations), HA Recovery, Server Grid, Informatica B2B DX/DTS, TIDAL Scheduler 2.5, Siebel 2000, Datamart, OLAP, OLTP, SQL*Plus, SQL*Loader, WS FTP Pro 9.0.

Databases: Oracle 11g/9i/8i, MS SQL Server 2000/7.0/6.5/6.0 , Sybase 12.0/11.x/10, DB2, MS Access 7.0/’97/2000, MS Excel VBA

BI Tools: Business Objects 5.1/5.0, Business Objects SDK, Web Intelligence 2.5/2.6, Info view 1.0 and, Business Objects Designer 5.1, Business Minor 4.2, BO Developer Suite (Broadcast Agent, Supervisor, Designer, Info View), Business Objects Universe Developer, Crystal Reports 4.0/6.0, Business Objects Reporting, MS Access Reports

Data Modeling: Erwin 4.0, Designer 2000, Star Schema, Snowflake Schema

Programming: Java 2.0, ASP, HTML, SQL Server 7.0, Oracle 8.0, Unix Shell Scripting, Korn Shell, SQL, SQL-Plus, PL/SQL, XML.

Environment: Win 3.x/95/98/XP/2000, Win NT 4.0, Sun Solaris 2.6/2.7, Unix, MS-DOS 6.22.

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Informatica Admin

Responsibilities:

• Experience with Informatica 10.1/9.1/9.5 server administration.
• Worked on Informatica DX by creating partners, accounts, profiles, endpoints and workflows to trigger file pickup from server.
• Configured event monitors to track file success/ failure for load/transfer
• Created various partners according to different business requirements
• Configured and installed Informatica MDM hub server, cleanse server, resource kit in development
• Upgraded for different versions of informatica. (v9.1 to v9.5) (v9.5 to v10.1).
• Experience using Data Transformation (v9) and Data Processor Transformation (v10).
• Experience in Informatica repository troubleshooting, creation, Backup and Restore
• Experience in monitoring informatica repository health through informatica admin console
• Experience with PowerExchange for Tableau, Informatica Data Explorer (IDE), Informatica Data Quality (IDQ), Metadata Manager, and Pushdown Optimization.
• Installed the v10.1/v9.5/v9.1 Powercenter on AIX.
• Performance tuning of Oracle PL/SQL Scripts

Environment: Informatica Powercenter 10.1/9.5, Informatica B2B DX, Data Processor, Informatica Developer 9.5, Oracle 10g, AIX, UNIX Shell Scripting, SQL, PL/SQL, SQL Plus 9.2, TOAD 8.0.

Confidential, Buffalo Grove, IL

Production Support Analyst

Responsibilities:

• Experience with Integration tools such as Network Automation’s Automate or IBM’s Cast Iron
• Informatica ETL troubleshooting and development.
• Debugging and troubleshooting skills with ability to read and write complex SQL statements.
• Highly skilled on databases, SQL queries, writing complex joins.
• Performance tuning of Oracle PL/SQL Scripts

Environment: Informatica 9.5, Oracle 10g, AIX, UNIX Shell Scripting, SQL, PL/SQL, SQL Plus 9.2, TOAD 8.0.

Confidential, Chicago, IL

Informatica Senior Developer Analyst

Responsibilities:

• Experience with Integration tools such as Network Automation’s Automate or IBM’s Cast Iron
• Knowledge of file transfer mechanisms.
• Knowledge of Encryption mechanisms.
• Used SSIS ETL for data migration from different sources like flat files, excel sheets and Oracle DB’s to client specific SQL server DB’s hosted locally.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Highly skilled on databases, SQL queries, writing complex joins.
• Performance tuning of Oracle PL/SQL Scripts

Environment: MS SQL Server 2012/2008R2, T-SQL, Tableau, SSIS, Tortoise SVN, SSRS, MS Excel, Visio

Confidential, Richmond, VA

Informatica Admin

Responsibilities:

• Experience with Informatica 9.1/9.5 server administration.
• Configured and installed Informatica MDM hub server, cleanse server, resource kit in development
• Upgraded for different versions of informatica. (v8.6 to v9.1) (v9.1 to v9.5)
• Experience in Informatica repository trouble shooting, creation, Backup and Restore
• Experience in monitoring informatica repository health through informatica admin console
• Experience with PowerExchange for SAP/webMethods, Informatica Data Explorer (IDE), Informatica Data Quality (IDQ), Metadata Manager, and Pushdown Optimization.
• Installed the v9.1/v9.5 Powercenter on AIX.
• Performance tuning of Oracle PL/SQL Scripts

Environment: Informatica Powercenter9.1.0,Informatica IDQ, Oracle 10g, AIX, UNIX Shell Scripting,SAP BW, SQL, PL/SQL, SQL Plus 9.2, TOAD 8.0.

Confidential, Dallas, TX

Informatica Admin

Responsibilities:

• Experience with Informatica 9.1 server administration.
• Upgraded for different versions of informatica. (v8.6 to v9.1)
• Experience in Informatica repository trouble shooting, creation, Backup and Restore
• Experience in monitoring informatica repository health through informatica admin console
• Experience with PowerExchange for SAP/webMethods, Informatica Data Explorer (IDE), Informatica Data Quality (IDQ), Metadata Manager, and Pushdown Optimization.
• Installed the v9.1 Powercenter on AIX.
• Performance tuning of Oracle PL/SQL Scripts

Environment: Informatica 9.1.0/8.6.1 , Oracle 10g, AIX, UNIX Shell Scripting, SQL, PL/SQL, SQL Plus 9.2, TOAD 8.0.

Confidential, PA

Informatica Admin

Responsibilities:

• Informatica administrator of the Informatica repository Service and Informatica Integration Service.
• Responsible for migrations/upgrades for different versions of informatica. (v8.6 to v9.1)
• Configured the HA/Grid setup for High Availability and recoverability.
• Responsible for Software/application configuration management.
• Wrote scripts to monitor the application. (Repository Service and Integration Service).
• Responsible for overall of all Informatica development.
• Performance tuned the long running sessions.
• Installed software upgrades and patches.
• Responsible for applying EBF.
• Installed the v9.1 Powercenter on Linux.
• Performance tuning of Oracle PL/SQL Scripts

Environment: Informatica 9.1.0/8.6.1 , Oracle 11g, RedHat Linux, UNIX Shell Scripting, SQL, PL/SQL, SQL Plus 9.2, TOAD 8.0.

Confidential, Baltimore, MD

DW Support Analyst/ Informatica Admin

Responsibilities:

• Responsible for program and project management support for the CMS NDW for Department of Health and Human Services.
• Informatica administrator of the Informatica repository server and Informatica pmserver
• Responsible for migrations/upgrades for different versions of informatica. (v7 to v8.5)
• Functioning in a business analyst role by interfacing with traders and other users to identify gaps between the new and old securities end to end system, and introducing enhancements to the new system’s securities pricing processes.
• Responsible for overall of all Informatica development.
• Responsible for migrations/upgrades for different versions of informatica. (v7 to v8.5)
• Performance tuning of Oracle PL/SQL Scripts

Environment: Informatica 8.6.1, Oracle 11g, Windows NT 4.0, UNIX Shell Scripting, SQL, PL/SQL, SQL Plus 9.2, TOAD 8.0.

Confidential, Parsipanny, NJ

Informatica Admin

Responsibilities:

• Responsible for applying EBF and Upgrading Informatica from version 7.1.3 to 8.1 then onto 8.5 and 8.6.
• Informatica administrator of the Informatica repository server and Informatica pmserver
• Responsible for migrations/upgrades for different versions of informatica. (v7 to v8.5)
• Performance tuning was done for various complex mappings (facts and dimension maps) to reduce the load time.
• Responsible for configuring the Server Grid/HA Recovery and set the sessions to recover automatically in case of any failure which are configured on a 4 node Grid.
• Responsible for registering the AS400 tables for changed data capture using power exchange and creating PowerExchange CDC maps.

Environment: Informatica 8.6.1, Oracle 11g, Windows NT 4.0, UNIX Shell Scripting, SQL, PL/SQL, SQL Plus 9.2, TOAD 8.0.

Confidential, Houston, Texas

Informatica Admin

Responsibilities:

• Responsible for overall delivery of all Informatica development done locally and in New York
• Responsible for providing knowledge transfer and mentoring junior developers with new versions of informatica, Grid functionality and HA Recovery.
• Created Test Strategies, Test Plans and assisted the manager in generating estimates based on approved BRD.
• Responsible for creating comprehensive test artifacts (test plans, test cases, bug reports, etc.) and documented ETL Test Plans.
• Responsible for testing different versions of informatica and resolving the issues identified in the new version with the Informatica Support Team.
• Functioning in a business analyst role by interfacing with traders and other users to identify gaps between the new and old securities end to end system, and introducing enhancements to the new system’s securities pricing processes.
• Improved development time by leveraging metadata, and reduced IT coordination costs by providing a common working business model across the Company’s enterprise architecture.
• Working directly with traders to automate manual processes that previously caused losses in revenue
• Leading the day-to-day functions of a four person operate team that is responsible for the support of the Informatica application delivered in Phase I of the project.
• Designed architecture of Informatica and database environments for development, test and production.
• Performance tuning of Oracle PL/SQL Scripts
• Designed and developed UNIX shell scripts.
• Optimized/Tuned mappings for better performance and efficiency
• Created complex joins, transformations of all types to pass data through ETL maps.
• Acting as technical lead in Informatica, assisting in implementation of best practices, development standards, migration, and operating procedures
• Mentoring other Informatica Power Center developers
• Upgraded the application from informatica v6 to v7.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Used UNIX Shell scripting for automation of the process, invoking PL/SQL procedures, and Informatica sessions.
• Did Unit/Stress Testing for the entire application.

Environment: Informatica 8.5.1/7.1.2/6.2 , Oracle 9i/10g, DB2,MS SQL Server 2000, Windows NT 4.0, UNIX Shell Scripting, SQL, PL/SQL, SQL Plus 9.2, TOAD 8.0.