SUMMARY

• Informatica 8.x Certified Developer
• 9 years of experience in database development, including Data warehousing & ETL using Informatica, Oracle, SQL Server, Windows server, UNIX and Solaris
• 3+ years of experience in Data Analysis, Data profiling and Data cleansing using Informatica Data Quality
• Data Migration / Conversion analyst with expertise, analyzing data from multiple source systems
• Experienced in performing Data Analysis and developing source to target mapping document for migration
• Proficient in Informatica Administration, data extraction, transformation and loading data using Informatica PowerCenter 9.6.1/9.5/9.0.1/8.6/8.1.1/7.1.4/7.1.3 (Admin Console, Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Informatica Power Exchange
• Experienced in all phases of Software development life cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of business requirement documents, mapping documents, development, testing, and implementation
• Experienced in integration of data sources like Oracle 10g/9i/8i, IBM DB2, MS SQL Server 2005/2000, XML files
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows
• Worked on migration of Informatica objects across Dev, Test and Prod environments using Deployment folders
• Worked on non - relational sources like Flat files and used secure FTP, SSH, WinSCP
• Worked on Performance Tuning Informatica Targets, Sources, mappings and sessions
• Worked on Incremental loading Target databases using SCD Type1/Type2 loads
• Created and maintained a several Data Base objects including tables, Views, Indexes, stored procedures
• Implemented Informatica Data Quality to do data cleansing, data matching, reporting and monitoring the XML files
• Knowledgeable with scheduling tools Autosys and Control-M
• Well versed in creating service requests, resolving issues with the help of Informatica Support
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.6.1/9.5/9.0.1/8.6/8.1/7. x, Informatica PowerExchange

Databases: Oracle 11g/10g/9i/8i, DB2, Teradata, MS-SQL Server 2000/5

Database Tools: TOAD 8.6, SQL plus, SQL Developer, ERwin 4.0

Packages: MS Office, MS Visio, MS Project

Languages: SQL, PL/SQL, C

Operating System: WIN 8/7/XP, UNIX, HP-UX, RHEL, Susie Linux, Sun Solaris

PROFESSIONAL EXPERIENCE

Informatica Consultant/Data Mapper

Confidential, Richardson, TX

Responsibilities:

• Involved in the migration of AT&T, Verizon accounts to Frontier systems
• Involved in the creation of several Informatica mappings, sessions and workflows to load data from flat files to Oracle and DB2 databases
• Designed and developed Informatica mappings to perform the Extraction, Transform and Load process by studying the business requirement from the users and the mapping documents.
• Created ETL process to generate XML files from oracle tables using Informatica
• Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files
• Developed several mappings using various active and passive transformations like Source Qualifier, Lookup, java, Router, Aggregator, Filter, Joiner, and Expression
• Implemented Data Quality solutions to do data profiling & data quality rules development using Informatica Data Quality
• Analyzed the legacy data and documented data quality issues and recommended changes
• Developed source to target mapping document for Standardizing Circuits to avoid discrepancy between plant and billing/service order systems
• Involved in the extraction of data from flat files and loading into Oracle tables using custom built Perl scripts
• Involved in the source data landing process, wrote scripts to load various source files like txt, csv, delimited and oracle dump
• Involved in creating control scripts to load data into oracle database using sql loader.
• Used Informatica Debugger to check the errors in the mapping and made appropriate changes in the mappings to generate the required results
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information required for the Maintenance and Operation of the application
• Worked with tools like TOAD, SQL Developer, SQL Plus to connect to Oracle and DB2 databases to write queries and analyze data
• Worked with business users, testing team and application development teams on analyzing, resolving and documenting the defects using HP ALM tool

Environment: Informatica PowerCenter 9.6.1 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Linux, Oracle 11g, DB2, Flat files, XML Files, SQL Developer, WinSCP, PuTTY, TextPad

Informatica Consultant

Confidential, MIAMI, FL

Responsibilities:

• Involved in the project POSXML reading the XML files from daily Point of Sale transactions from the vendor Micros and TEC systems. The XML files from MICROS system (US and CANADA) and TEC (SINGAPORE, GERMANY and CHINA) are loaded into the ODS system initially. The data is then loaded from ODS database into centralized global data warehouse. worked on Informatica Data Quality option to distill XML Background data and to deliver then to multiple targets without any error
• Utilized InformaticaIDQ to complete initialdata profiling and matching/removing duplicate data
• Validated and updated address data by fixing errors and complete partial address records using information from the reference data
• Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server, XML files and flat files to perform mappings based on company requirements and load into Oracle tables
• Worked on change data capture for slowly changing dimensions (SCD-2) to update a target table to keep full history
• Worked on migration of Informatica objects across Dev, Test and Prod environments using Deployment folders
• Worked on creating and altering tables and other DDL, DML and DCL utilities of Oracle 10g
• Created mappings involving various transformations like joiner, aggregator, lookup, sequence generator, stored procedure, update strategy, filter and router transformations to implement business logic
• Extensively used mapplets and worklets to prevent redundancy of transformation usage and maintainability
• Performed unit and regression testing, troubleshooting and bug fixing in development and QA environments
• Worked on Informatica Debugger to debug the mapping
• Well versed in using Mercury Quality Center to document defects
• Involved in Change control Management and knowledge transfer to the offshore team on the process flow

Environment: Informatica PowerCenter 8.6 (Admin Console, Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Linux, Oracle 10g, Flat files, XML Files, TOAD, SQL Developer, WinSCP, PuTTY, Winmerge, TextPad, EditPlus

ETL Consultant

Confidential, ROCKVILLE, MD

Responsibilities:

• Involved in the Release 10.2 for Thomson Advisor, to in corporate some new features like Asset level Models, Drift Analysis, Rebalancing etc. in the product. Also created ETL solutions for handling nightly batch processing and intraday processing of various feeds from outside sources at accounts, positions and securities levels.
• Designed and developed Informatica mappings to perform the Extraction, Transform and Load process by studying the business requirements from the users and the mapping documents
• Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server, XML files and flat files to perform mappings based on requirements and load into Oracle tables
• Worked on migration of Informatica objects across Dev, Test and Prod environments using export and import of objects
• Developed mappings using various transformations in Designer to extract the data from relational sources like Oracle and non relational source like flat files to perform mappings based on company requirements and load into BI system
• Created shortcuts in individually assigned folders for the sources and Targets which are imported into a Centralized shared folder
• Created XSD for XML files, imported into Designer as XML source qualifier
• Created slowly changing dimension tables - SCD type 1 & type 2 mappings using lookup, Joiner, aggregator, Filter, Update Strategy and Router Transformations
• Used different tasks (Session, Command, Decision, Timer, Email, Event-Raise, Event-Wait, Control) in the workflow
• Worked on performance tuning of Informatica Targets, Sources, mappings and sessions for large data files
• Used Informatica Debugger to check the errors in the mapping and made appropriate changes in the mappings to generate the required results
• Worked with tools like TOAD, SQL Developer to write queries and generate the result
• Performed unit and regression testing, troubleshooting and bug fixing in development and QA environment
• Managed Change control implementation
• Involved in knowledge transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings

Environment: Informatica PowerCenter 8.1.1 (Informatica Services, Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Solaris, Oracle 10g, Informatica PowerExchange, Flat files, XML Files, ERwin 4.0, TOAD 8.6, FileZilla

Informatica Developer

Confidential, ROCHESTER, NY

Responsibilities:

• Worked on integrating data from daily retail sales transactions and loaded into centralized data warehouse to provide the BI systems the capability to track and analyze sales performance from an actual and budgeted perspective and consequently decide the strategy for improving sales performance
• Worked with various business users for requirement gathering and analysis
• Designed ETL mapping document to map source data elements to the target based in Star-Schema dimensional model
• Designed and developed complex mappings using various transformations in Designer to extract the data from relational sources like Oracle, SQL Server, and non relational source like flat files to perform mappings based on company requirements and loaded into tables
• Worked extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement
• Created SCD type 1 & type 2 mappings using lookup, Joiner, aggregator, Filter, Update Strategy and Router Transformations
• Used various tasks (Session, Command, Decision, Timer, Email, Event-Raise, Event-Wait, Control) in the workflow
• Performance Tuned Informatica Targets, Sources, mappings and sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval
• Created pre-session and post-session shell scripts and mail-notifications
• Used debugger to check the errors in the mappings
• Worked with tools like TOAD to write queries and generate the result
• Managed code deployments and PROD implementations
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings

Environment: Informatica PowerCenter 8.1.1 (Designer, Workflow Manager, and Workflow Monitor), Solaris, Oracle 9i, Informatica PowerExchange, SQL Server 2005, PL/SQL, Flat files, XML Files, ERwin, TOAD

Software Engineer

Confidential

Responsibilities:

• The project involved in the creation of Information management system (IMS), a web-based application that included purchase & inventory, Human resource and information system modules of enterprise resource planning.
• Involved in design, development and maintenance of the Application
• Gathered business requirements and created design documents
• Created and maintained a several Database objects including tables, Indexes, stored procedures
• Created Views from extracting data from various tables for Report Generation
• Involved in the upgrade of Developer 4.5 to Oracle 6 using interactive mode and batch mode
• Modified PL/SQL code in the forms to adhere the syntax change
• Developed forms screens to enter customer information
• Created new stored procedures and modifying the existing ones
• Worked on improving the Query performances
• Prepared the different test scenarios and tested the SQL queries and stored procedures
• Conducted the Weekly Status meetings to Review/generate reports on the development of the software

Environment: SQL, PL/SQL, Oracle Forms, Oracle 8i, MS Access, Windows NT, UNIX