SUMMARY

• Strong in Data warehousing tools such as Informatica PowerMart & Power Center on ETL side.
• Extensive Experience in Informatica for data Extraction Transformation and Loading. Used Informatica IDQ for Cleansing.
• Experience in generating reports using BUSINESS OJECTS
• Extensive experience in Oracle Database - Design, Writing Stored Procedures, Functions, Triggers and Queries
• Proficient Programming in Visual Basic and ASP
• Experience in all phases of project life cycle including Performance Tuning and Maintenance.
• Strong interpersonal skills and ability to work in a team environment
• Excellent team member with problem-solving and trouble-shooting capabilities.
• Industry Experience: Financial, Health Care/Medical Device, Marketing, Travel and Hospitality.

TECHNICAL SKILLS

ETL: Informatica Power Center 5.0/5.1/6.1/7.1/8.6/9.1/9.6/10.1 , Informatica PowerMart 4.5, Data stage 7.1, Informatica Power Exchange, Informatica Power Connect, Informatica IDQ.

Data Modeling/OS: ER/Studio 3.5 / 4.0, Erwin 4.1, Sybase Power Designer, Windows NT / 9 / XP, UNIX

Databases: Oracle 10g/9i/8i/7.x, Sybase 11.0, MS Access, MS SQL server, DB2.

Reporting Tools:

Cognos BI: Cognos Impromptu 5.2/6.0,7.x, Cognos Transformer & Power Play, Impromptu Web Reports (IWR), Cognos Query, Cognos Visualizer, Cognos Scheduler, Cognos Architect, Cognos Script Editor, Cognos Upfront, Cognos Power Play Enterprise Server.

ReportNet: Report Studio, Query Studio, Framework Manager.

Languages: C, C++, PL/SQL, Java, VBScript, Java Script, HTML, XML, XSL, XSLT.

Client /Server: Visual Basic, Active Server Pages, Developer 2000

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Involved in extracting the data from SQL Server, Flat files using Informatica Power Center.
• Used Informatica IDQ Address Doctor transformation for address cleansing.
• Created the Dynamic stored procedures to move the data from load ready tables to the DW tables.
• Involved in creating the XML target files for the Data Eco System downstream extracts.
• Actively involving in the data analysis /data profiling.
• Used Informatica Power Center Designer to create complex mappings using different transformations
• Tuning SQL queries for speedy extraction of data.
• Creating sessions, batches and unit testing of the mapping/sessions and batches.
• Used Pre and Post session emails to know the session failures and success and scheduled jobs for loads on daily basis.
• Involved in performance tuning to improve the session performance
• Prepared the Unit test and system test documents for the developed mappings
• Involved in creating the deployment groups to migrate the code from DEV Environment to TEST and TEST to STAGE repositories.
• Involved in writing the Batch scripts to handle the file list creations.
• Involved in creating the Jobs and Job plans using UC4.

Environment: Informatica Power Center 10.4.1, Windows, MS SQL Server, XML, UC4, Informatica IDQ

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Involved in extracting the data from SAP using Informatica SAP R3 connector, Informatica BCI and also from diverse data sources using Informatica power center (Flat files, Relational tables, XML).
• Used Informatica IDQ Address Doctor transformation for address cleansing.
• Created SOAP Web Service for Address Doctor in Informatica Developer tool.
• Build the process to consume the Messages from JMS Queues on JBOSS.
• Used Informatica Power Center Designer to create complex mappings using different transformations
• Tuning SQL queries for speedy extraction of data.
• Creating sessions, batches and unit testing of the mapping/sessions and batches.
• Used Pre and Post session emails to know the session failures and success and scheduled jobs for loads on daily basis.
• Involved in performance tuning to improve the session performance
• Prepared the Unit test and system test documents for the developed mappings
• Involved in creating the deployment groups to migrate the code from DEV Environment to TEST and TEST to STAGE repositories.
• Involved in writing the Unix scripts.
• Involved in creating the Jobs and Job plans using UC4.

Environment: Informatica Power Center 9.6.1, 10.1, Informatica Power Exchange Net Weaver, UNIX, MS SQL Server, DB2, XML, UC4, DB2, Informatica IDQ

Confidential, Minneapolis, MN

Sr. Informatica Developer

Responsibilities:

• Involved in extracting the data from diverse data sources using Informatics power center (Flat files, Relational tables).
• Used Informatica Power Center Designer to create complex mappings using different transformations
• Tuning SQL queries for speedy extraction of data.
• Creating sessions, batches and unit testing of the mapping/sessions and batches.
• Used Pre and Post session emails to know the session failures and success and scheduled jobs for loads on daily basis.
• Involved in performance tuning to improve the session performance
• Prepared the Unit test and system test documents for the developed mappings
• Involved in writing the batch scripts and working with production control team to create jobs in Mainframe and schedule them.
• Involved in migrating repository objects from DEV Environment to TEST and t hen from TEST to PROD repositories. Used Serena Dimensions for code versioning.
• Handled various production issues in the production support period.

Environment: Informatica Power Center 9.6.1, Oracle 11g, Windows XP, Serena Dimension, Toad, MS SQL Server

Confidential, Minneapolis, MN

Sr. Informatica Developer

Responsibilities:

• Participated in Requirements Gathering involving interaction with diverse focus groups and Assisted in other Project Planning and Scoping activities.
• Worked closely with Business analyst to understand the rules and implemented required functionality.
• Involved in writing ETL code to load the MDM data into Data warehouse.
• Involved in building a process for Inbound and Outbound of MDM data for HMS (External Vendor) for Matching.
• Created XML files for HMS inbound data to load into MDM repositories.
• Created Informatica IDQ mappings for cleansing contact names and addresses.
• Involved in writing Informatica Web Services for Person and Organization searches.
• Involved in writing the Oracle stored procedures for writing Data Quality checks for Master Data.
• Involved in analyzing the data logged through DQ checks and working with Governance team to find the solutions.
• Scheduled Informatica batch jobs using Tivoli Maestro scheduling tool to run real time.
• Coordinating with Hosting team for code migrations.

Environment: Informatica Power Center 9.1, PL/SQL, Oracle10g, XML, UNIX, Windows XP, Clear Quest, Toad, IBM Maestro Tivoli(Scheduler), SAP DQM, Informatica IDQ.

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Participated in Requirements Gathering involving interaction with diverse focus groups and Assisted in other Project Planning and Scoping activities.
• Worked closely with Business analyst to understand the rules and with Data Modelers for DB Model changes and implemented required functionality.
• Created Technical design documents to achieve the requirements and involved in Design review meetings.
• Responsible for Code reviews for the ETL Code and recommended improvements in Development
• Worked with Test Leads in all test cycles and coordinated with Off Shore team to make the development changes to fix the issues occurred in testing cycles
• Coordinated with Confidential Hosting team for Code Migrations.

Environment: Informatica Power Center 9.0, PL/SQL, DB2, UNIX, Windows XP, Clear Quest, Toad, CTRL M (Scheduler).

Confidential, Minneapolis, MN

Sr. Informatica Developer

Responsibilities:

• Participating in the development and review of the architecture and high level design of the major projects
• Analyzed business requirements, performed source system analysis prepared technical design document and source to target data mappings.
• Extracted data from DW, transformed data as per the business requirements and loaded it into target tables or files based on business requirements.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, router, lookup, stored procedure, sequence generator, xml transformations
• For few interfaces configured JMS to place the Outbound files in the queue.
• Involved in writing the Interfaces to extract data from SAP BW using Informatica Power Exchange and SAP tables using Informatica Power Connect.
• Performed SQL tuning and ETL code tuning to meet the operational window.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks. Used partitioning techniques to enhance the existing mapping performance.
• Developed shell scripts to batch process Informatica workflows using pmcmd and ftp the flat files and compress the archive files to better use of file system space and splitting up the flat files into multiple files.
• Developed shell scripts to maintain archive of both records in database tables and flat files for a 4-day time period
• Scheduled Informatica batch jobs using IBM Maestro Tivoli scheduling tool both event-based and time - based.
• Developed migration plan for production move and migrated code from test to production
• Used Mapping parameters for the re usability of Informatica programs.
• Involved in analyzing the data issues and fixing the problems in production support
• Developed migration plan for production move and migrated code from test to production
• Involved in coordination with off -shore team for production support.

Environment: Informatica Power Center 8.6, 9.1, Power Exchange, Power Connect, PL/SQL Oracle10g, XML, UNIX, SQL Server, DB2, Windows XP, Clear Quest, Toad, IBM Maestro Tivoli (Scheduler), JMS.

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Involved in extracting the data from diverse data sources (Oracle Tables, Excel Sheets and Flat Files).
• Used Informatica Power Center Designer to create complex mappings using different transformations
• Tuning SQL queries for speedy extraction of data using various tools like SQL Navigator, TOAD.
• Involved in importing repository objects to XML file and exporting the objects from the XML file
• Creating sessions, batches and unit testing of the mapping/sessions and batches.
• Used Pre and Post session emails to know the session failures and success and scheduled jobs for loads on daily basis.
• Involved in performance tuning to improve the session performance
• Prepared the Unit test and system test documents for the developed mappings
• Involved in writing the Unix shell scripts to archive the files and to transfer the files from one server to other server
• Involved in migrating repository objects from DEV Environment to TEST and t hen from TEST to PROD repositories
• Handled various Production issues in the Production support period.

Environment: Informatica Power Center 7.1.3 PL/SQL, Oracle10g, Oracle Financials, MS Excel, UNIX, Windows XP, Clear Quest, SQL Navigator, Toad, Ctrl M (Scheduler).

Confidential, MN

Informatica Developer

Responsibilities:

• Involved in extracting the data from diverse data sources using Informatics power center and power exchange (Main Frame Sources).
• Used Informatica Power Center Designer to create complex mappings using different transformations
• Tuning SQL queries for speedy extraction of data.
• Involved in importing repository objects to XML file and exporting the objects from the XML file
• Creating sessions, batches and unit testing of the mapping/sessions and batches.
• Used Pre and Post session emails to know the session failures and success and scheduled jobs for loads on daily basis.
• Involved in performance tuning to improve the session performance
• Prepared the Unit test and system test documents for the developed mappings
• Involved in writing the Unix shell scripts
• Involved in migrating repository objects from DEV Environment to TEST and t hen from TEST to PROD repositories
• Handled various production issues in the production support period.

Environment: Informatica Power Center 7.1.3, Informatica Power Exchange, PL/SQL, Oracle10g, Oracle Financials, MS Excel, XML, UNIX, Windows XP.

Confidential

Programmer

Responsibilities:

• Involved in development of Data Flow Diagrams and ER Diagrams
• Involved in back End writing Stored Procedures, functions, Database Triggers.
• Developed Stored Procedure/Triggers in PL/SQL.
• Design and developed reports using Crystal Reports.
• Involved in Testing and Database designing

Environment: PL/SQL, Seagate Crystal Report 6.0, Oracle 7.3

Confidential

Programmer

Responsibilities:

• As an active team member contributed in analyzing the client's requirements, determining the workflow and writing the design specs.
• Designed, developed and deployed the entire application using VB as the main front-end tool and MS Office as a back end.
• Developed the voucher tracking module, the end users as well as the corporate staff can know the status of any particular voucher based upon the voucher ID. Also tested the module with simulated data.
• According to the requirement of the client generate reports using CRYSTAL REPORT.
• Developed test plans, test cases and test reports.

Environment: Visual Basic 5.0, Segagate Crystal Report 5.0, MS Office