SUMMARY

• 7 years of IT experience on Data Warehouse, Data Analysis, Application Development and Business Intelligence with ETL tools Informatica Power Center 9.5.1/9.0.1 /8.6.1/8.5.1/8.5.
• Strong technical exposure with good degree of competence in business systems such as Financial, Banking, Insurance, Healthcare, Pharmaceutical, and Telecommunications.
• Responsible for Production Support to resolve the ongoing issues and troubleshoot the problems.
• Good understanding of Star and Snowflake Schema, Dimensional Modeling, Relational Data Modeling, ERWin 7.2/4.x, Microsoft Visio 2003.
• Good flexibility in the design of strategies for ETL mechanism using Informatica Power center that involves development of data warehouses, OLAP.
• Involved in Activities like Code Migration, Creating and Restoring Repository Backups
• Experience in Installation, Configuration and administration of Informatica Power Center 8.x (server and Client) on windows 2003 server.
• Extensively worked on Power Center client (Repository, Designer, workflow manager and workflow Monitor) to extract, transform and load data.
• Designed mappings using Informatica Union, Lookup (Connected, Unconnected, Persistence, Dynamic and Static), Unstructured Data Object (B2B), Update strategy, expression, Transaction Control to create dynamic file names, Aggregator, Joiner, Expression, Router, XML, and Normalizer Transformations.
• Developed common logic using Reusable transformations and mapplets.
• Developed and tested complex mappings for Slowly Changing Dimensions Type I, II (Flag and time stamp) and Change Data Capture based on requirements using Power Exchange 8x/9.01 HF3.
• Extensively used Informatica to load data into ODS, Data Warehouse on integration of various sources that involve relational databases - Oracle 11g/10g/9i, MS SQL Server 2008/2005/2000 , DB2 UDB 8.1, flat files, XLS and XML system.
• Efficient in troubleshooting bottlenecks, performance tuning of mappings, Debugging, System Testing and Optimization of ETL.
• Experience in Task Automation of Pre-Session and Post-Session UNIX scripts (Korn) using Control-M schedulers and Performed data migration from development to QA, Test Process, Move to PROD and maintain ETL process in coordination with supervisor, team members and users.
• Proficient in parameterizing DB connections, file paths, error handling and interacted with Informatica server from command mode using PMCMD command.
• Involved in all aspects of ETL- requirement gathering, coming up with standard interfaces to be used by operational sources, coming up with data load strategies, designing and developing various mappings, unit testing, integration testing, regression testing and UAT in development.
• An Energetic, flexible, well organized, self-motivated fast learner with minimal supervision, good listener, independent and team-oriented, process focused professional in various team sizes performing cross functional roles in a fun filled, challenging environment.
• Excellent analytical, problem solving, communication and interpersonal skills, with an ability to interact with individuals at all levels.

TECHNICAL SKILLS

Data Warehousing ETL: Informatica Power Center 9.5/9.0/8.6/7. x/6.x and Informatica Server, ETL, Power Exchange 8.0,Power Mart4.7.2/5.1 andPower Connect.

Data Modeling: Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Cardinality, ER Diagrams, ERWIN 7/4.0/3.0, MS VISIO 2000.

Databases: Teradata V2R12/V2R6/V2R5, Oracle 11g/10g/9i, MS SQL server 2000/2005/2008 , DB2 UDB 8.1, MS Access

Programming: SQL, PL/SQL, Unix & Shell Scripting, SQL Tuning/Optimization, C, C++

Tools: TOAD, SSIS/DTS, SQL *Plus, SQL* LOADER, Clear View, Excel, Word, Power Point, Autosys, Control-M, ERWin 3.5.2/4.0, IBM Tivoli Workload

Operating System: Sun Solaris, Linux, MS-DOS, Windows 7/95/98/NT/2000/2003/XP/Vista/Server.

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Involved in Requirement Gathering, Design & Development, Testing and Documentation.
• Worked with Business Analyst and Architect to analyze data and document Functional aspects.
• Participated in scrum meetings to discuss the status of the everyday development.
• Designed and created Mappings, Sessions and Workflows using Informatica PowerCenter Tools to load the data from Sources such as DB2/400, Oracle, XML, EDI and Flat Files into various targets.
• Developer the ETL processes to handle complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner, Router, Union etc.
• Processes to generate Daily, Weekly and Monthly data extracts were developed and the data files were sent across to the downstream applications.
• Used Source Qualifier & Lookup SQL overrides, Persistent caches, Incremental Aggregation etc for better performance.
• Defined and used Mapping Parameters and Parameter files to provide values dynamically at session run time.
• Defined and used Mapping Variables to capture changed data from the source tables.
• Created sessions to use pre & post session SQL commands to drop & create indexes on tables for better performance.
• Used Event wait Task, Control Task, Email Tasks, Command Tasks and Link conditions in workflows.
• Write PL/SQL procedures which are called from Stored Procedure transformation to perform database actions such as truncate the target before load, delete records based on a condition, rename the tables etc.
• Used Oracle SQL Loader utility to Bulk Load data from flat files into database tables.
• Created & modified Unix Shell scripts.
• Provided data loads for QA testing and worked on resolving the defects.
• Performed Informatica code migrations.
• Created Technical Design documents, Test Cases documents and Application work books.

Environment: Informatica Power Center 9.5.1/9.0.1 , SQL Server 2008 express, Oracle SQL Developer, Flat files, XML Files, MS Visio, Toad 7.0, Windows 2000, Putty, Power Exchange 9.0.1., 9.5.1

Confidential, Chicago, IL

Informatica/Data Masking Developer

Responsibilities:

• Involved in Project Life Cycle SDLC (application access issues to Implementation phase)
• Working closely with Architects, Lead and Project Manager for the applications assessment to all the Data Masking Team on Proxy server.
• Gathering requirements from Business Analyst’s in understanding the Databases and Structures required for masking.
• Good Knowledge on applying rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformation and loading into targets.
• Designed, developed and tested mappings/sessions/workflows to move data from source to staging to warehouse in a complex industry.
• Used Shell scripts to pre-process data in UNIX.
• Designed and developed Informatica mappings for data load and data cleansing.
• Employed Power Exchange 9.0.1 for Change Data Capture (CDC) mechanism for SCD type 1 & type 2 f mainframe files for GDG’s, in which they are rearranged and edited for proper reading of file sand avoiding errors.
• Worked on identifying Mapping Bottlenecks in Mappings and improved session performance by including partition points, modifying target load order and emphasizing more on SQL override in place of Joiners and Lookup transformations.
• Performed performance tuning on Informatica sessions, batches and other related scripts.
• Developed pre-session and post session scripts using UNIX and scheduled the workflows using Control-M and extensively applied SQL programming skills in optimizing the session performance.
• Implemented design improvements to increase scalability of the target data mart in de duping duplicate records.
• Involved in Version Control and Code Migration from DEV to SIT Environment using Serena Dimensions.
• Ensured that system testing and change management procedures are followed with an ability to prioritize and manage multiple tasks with effective time management skills.
• Precisely documented all the mappings for further reference.

Environment: Informatica Power Center 8.6.1/9.0.1 HF3, Oracle 10g/9i, MS SQL Server 2000, IBM DB2/400, Flat files, Main Frames, VSAM Files, MS Visio, Toad 7.0, Windows 2000, Unix Shell Scripting, Putty, ILM Work Bench, Power Exchange 9.0.1.

Confidential, St. Cloud, MN

Informatica Developer

Responsibilities:

• Requirements gathering from business analysts and responsible for populating the business rules using mappings into the Repository for Meta Data management.
• Performance tuning in the context of dimensional design by creating Mini Dimensions thus providing smaller entries in to the Fact table.
• Flattening out Many to Many relations by creating bridge tables as in the case of account and customer dimension tables.
• Carrying out ETL, monitoring jobs, fixing issues and tracking tickets etc Scheduling of jobs & Responsible for Monitoring of Jobs and re running if gets aborted.
• Experience in supporting and communicating with onsite/offshore team.
• Extensively used ETL and Informatica to load data from Oracle, MS SQL Server, flat files into the target Oracle database.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings and also in tuning of mappings for better performance.
• Used Informatica features to implement Type I & II changes in slowly changing dimension tables. Created and ran workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Actively participated in resolving Email tasks working on priority and non-priority issues of employee’s profiles and figuring out those issues through mappings.
• Optimized/Tuned mappings for better performance and efficiency. Performance tuning of SQL Queries, Sources, Targets and sessions.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Developed UNIX scripts to automate different tasks involved as part of loading process and scheduling and performed Unit Testing on the mappings.

Environment: Informatica Power Center 8.6.1/7.1, Oracle 10g/9i, MS SQL Server 7.0/2000, IBM DB2/400, Flat files, SQL, SQL*Loader, ERWin 3.5, Toad 7.0, Windows 2000, Unix Shell Scripting.

Confidential, Rochester, NY

Informatica Developer

Responsibilities:

• Involved in project life cycle SDLC (requirements gathering to implementation phase).
• Worked closely with Business Analyst’s and DBA’s in understanding the Databases and Structures used in the environment of star schema based data model with dimensions and facts.
• Designed, developed and tested mappings/sessions/workflows to move data from source to staging to warehouse in a complex industry.
• Used Shell scripts to pre-process data in UNIX.
• Designed and developed Informatica mappings for data load and data cleansing.
• Employed Change Data Capture (CDC) mechanism for SCD type 1 & type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Transformations.
• Worked on identifying Mapping Bottlenecks in Mappings and improved session performance by including partition points, modifying target load order and emphasizing more on SQL override in place of Joiners and Lookup transformations.
• Created Mapplets, Parameter Files wherever necessary to facilitate reusability of business logic.
• Performed performance tuning on Informatica sessions, batches and other related scripts.
• Developed pre-session and post session scripts using UNIX and scheduled the workflows using PMCMD command and extensively applied SQL programming skills in optimizing the session performance.
• Implemented design improvements to increase scalability of the target data mart to avoid duplicate records. These included the increased parallelism to allow sessions to be spread across all available processors. This scalability proved crucial in allowing enterprise wide usage of the data mart.
• Configured and scheduled DAC tasks as a part of loading DEV, UAT and PROD Data warehouse.
• Involved in Version Control and Migration of repository from DEV to UAT Environment.
• Ensured that system testing and change management procedures are followed with an ability to prioritize and manage multiple tasks with effective time management skills.

Environment: Informatica Power Center 8.6.0, UNIX, OBI DAC 10.1.3.4, Oracle 10g/9i, SQL Server 2005/2008, Windows 2003 server, SQL Developer, Microsoft Visio.

Confidential, St. Louis, MO

Informatica /ETL Developer

Responsibilities:

• Involved in analysis of three different source systems and prepared technical specifications for the ETL.
• Collaborated with other team members to create technical specifications for ETL/ELT processes based on functional specifications, participated in technical product evaluations.
• Good understanding in development of information models to support integration and semantic interoperability.
• Good knowledge in understanding of the healthcare information systems, including biomedicalterminologies like SNOMED, LO INC, FDB, RxNORM, UMLS, and healthcare interoperability standards such as HL7, ASTM.
• Created mappings and Mapplets using the transformations such as the Source qualifier, Aggregator, Expression, lookup, Router, XML, Normalizer and Update Strategy.
• Involved in enhancements of the existing mapping according to the Data mart changes.
• Developed Error/Exception handling mechanism to enhance the data quality loaded to EDW
• Involved in all stages of data migration and responsible in order to achieve an automated migration.
• Created and Scheduled tasks and Batch Process based on demand, and run on time.
• Involved in identifying bottlenecks and resolved them through performance tuning of transformations and Sessions by implementing parallelism, partitioning (key range, pass through, hash) and caching.
• Applied UNIX scripts to automate different tasks involved as part of loading process and scheduling.
• Tivoli workflow scheduler (TWS) was used as part of scheduling.
• Performed Unit Testing and Integration Testing on the mappings
• Collaborated with clients, consultants and operational staff to understand the reporting requirements.

Environment: Informatica Power Center 8.5/8.6.1, SNOMED,LO INC, UMLS,FDB, Teradata V2R12/V2R6, BTEQ, T pump, M Load, Fast Load, ERWin, Oracle, SQL, IBM Tivoli, SQL Server 2005, QTP, Windows NT/XP.

Confidential, CT

Data Warehouse Developer

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Extracted data from source systems to a staging database running on DB2.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, and Transformations Developer.
• Developed mappings with transformations and mapplets confirming to the business rules.
• Processed session data using threads and various tasks (session, command etc.), scheduled workflows and managed DSN connections.
• Created shared folders, local and global shortcuts to reuse metadata.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Used Informatica repository manager to backup and migrate metadata in development, test systems.

Environment: Informatica Power Center 7.1, SQL Server 2000, Flat Files, SQL, TOAD 8.0, Oracle 9i, DB2, Windows 98/2000.

Confidential

Oracle Developer

Responsibilities:

• Involved in the installation and configuration of Oracle 9.0.1 server and creation of databases.
• Performed database and SQL tuning to improve performance of loads.
• Developing PL/SQL programs for data manipulation.
• Installation of Oracle client tools and establishing connectivity to databases.
• Creating table spaces, tables, indexes, users and Implemented table partitioning to improve performance and data management.
• Assisted in logical and physical database design.
• Developed UNIX shell and SQL scripts for database monitoring and backups.
• Data loading using SQL*Loader to assist Data Warehouse developers.
• Implemented changes in the database design and modified stored procedures if necessary.
• Managed and monitored the use of disk space, database space, CPU, cache, user connections, processes and database security.
• Implemented procedures for backup and recovery of production servers.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.

Environment: Oracle 9.0.1, Toad 7.6, Windows 2000, PL/SQL, SQL* Loader.