SUMMARY

• 8+ years of Experience in analysis, design, development, implementation and troubleshooting of Data warehouse applications.
• Data integration experience in developing ETL mappings and scripts using Informatica Power Center 9.x/8.x/7.x and Power Exchange 8.x/7.x.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in creating High Level Design and Detailed Design in the Design phase.
• Experience WebLogicDiagnostic Framework modules.
• Extensively worked on the ETL mappings, analysis and documentation ofOLAP reports requirements.
• Experience in 2NF,3NF and Object Models
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Skilled in Unix Shell Scripting and experience on different UNIX platforms.
• Installed and configured PowerCenter 9.0.1 and 9.1.0 on UNIX platform.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources like Oracle, Teradata, Netezza, DB2, Sybase, SQL server and MS access and non-relational sources like Flat files, XML files, XMD into staging area.
• Experience in Designing Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs. Also involved in migration/conversion of ETL processes from development to production.
• Experience in loading data from Oracle database and MS SQL Server database to Teradata database.
• Experience in active data ware housing on the Teradata platform, extended use of Teradata Parallel Transport, TPump, Fast Load, BTEQ and migrating legacy systems into Teradata.
• Experience in the concepts of building Fact Tables, Dimensional Tables, handling Slowly Changing Dimensions and Surrogate Keys.
• Performed reverse-engineering from Informatica codes, UNIX shell scripts, stored procedures, metadata to understand the existing process, data and relationships.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions and packages.
• Worked on Transact-SQL and .net sevices
• Extensively worked on developing and debuggingInformaticamappings, mapplets, sessions and workflows.
• Worked on Informatica Data Quality (IDQ), Data Explorer, Data analyzer and Informatica Analyst.
• Worked on UnstructedData Option (UDO), Partitiong, etc.
• Worked on creating Unit Test Cases for mapping and code reviews.
• Experience in Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Re engineered the Fact Dimension models by extending the Snowflake to Star schemas.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Experience in logical/physical data models and Forward/Reverse Engineering using ERwin.
• Have knowledge in Business Intelligence tools like Cognos 10/8.x/7.x, Business Objects XI R2.
• Thoroughly examined the DE normalized strategies i.e.relational algebra, query trees, and join cost functionunder various scenarios to improve relational system.
• Have knowledge of coordinating all of the entities involved in a supply chain.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
• Extensive functional and technical exposure. Experience working on high-visibility projects.
• Team player with strong communication and interpersonal skills.

TECHNICAL SKILLS

ETL: InformaticaPower Center9.x/8.x/7.x/6.x, B2B Data Transformation,Power Mart6.1/5.1,Power Connect 8.5.1/8.1.1 , Informatica Data Quality (IDQ).

OLAP/DSS Tools: Hyperion Essabase 7.2Business Objects6.5.1, Supervisor, Designer, COGNOS (Impromptu6.1, Transformer and Power Play 6.1), crystal reports 8.1, crystal enterprise, OBIEE 10.1.3.4.1

Database Modeling: ERwin 4.5/4.0/3.5

Databases: Oracle 11g,10g,9i,8i, Teradata, SQL Server 2008.

GUI: VisualBasic6.0, Developer2000 (Forms 6i/6.0/5.0/4.5 and Reports 6i/6.0/3.0/2.5)

Languages: SQL, PL/SQL, C, COBOL, JAVA, C++,Shell Scripting

DB Tools: Toad, Sql Developer, SQL* plus, SQL* Loader, Import, Export

Scripting: HTML, XML, JavaScript, VBScript, ASP

OS: Windows 7/Vista/XP/2003/2000/NT/98/95, Sun Solaris 2.x, HP-Unix, UNIX (AIX).

PROFESSIONAL EXPERIENCE

Confidential, Grand Rapids, MI

Informatica Consultant

Responsibilities:

• Developed complex Informatica mappings to load the data from various sources using different transformations like Source qualifier, Connected and Unconnected Lookup, Expression, Aggregator, Joiner, Filter, Normalizer, Rank and Router Transformations.
• Created the Test Plans, Test Cases for the project.
• Worked Informatica power center tools like Source Analyzer, Mapping designer, Mapplet and Transformations.
• Developed Informatica mappings and also tuned for better performance.
• Extracted data from Flat files and Oracle and loaded them into Teradata.
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Teradata, Oracle, Flat files and loaded into target.
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server
• Developed, tested and implemented Unix Shell scripts, FTP, SFTP’s, file transfers, Teradata BTEQ, Fast Load, Mload, TPump, FastExport Oracle/DB2 stored procs & Bulk loads.
• Designed and developed data warehouse solutions, integrate new files and data’s from other applications into Enterprise data warehouse, Utilize Teradata for reporting, OLAP & history.
• Developed Procedures and Functions in PL/SQL.
• Used Procedure Transformations to invoke Oracle PL/SQL Procedures.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Designed and Developed ETL logic for implementing CDC and Replication Technologies by tracking the changes in critical fields required by the user.
• Extensively used Informatica to load data from Flat files, Oracle database.
• Extensively performed Data Masking for preserving the referential integrity of the user data.
• Performed Data Encryption on user data and client data for maintaining consistency and security.
• Responsible for Performance Tuning at the Mapping Level and Session level.
• Worked with SQL Override in the Source Qualifier and Lookup transformation.
• Extensively worked with both Connected and Unconnected Lookup Transformations.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Involved in Unit testing and System testing of the individual.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Analyzed existing system and developed business documentation on changes required.
• Performed detail data analysis of both data elements requested by the business and data source and documenting data source definition, source-to-target mapping, and logical structures for the data warehouse/data mart
• Was involved in design, development, and the administration of Oracle data mart, the distribution of global data from the Data Warehouse.
• Used UNIX to create Parameter files and for real time applications.
• Developed shell scripts.
• Extensively involved in testing the system from beginning to end to ensure the quality if the adjustments made to oblige the source system up-gradation.
• Worked with many existing Informatica mappings to produce correct output.
• Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Prepared SQL scripts for validation of the ETL business logics involved.
• Prepared the SQL scripts and validated the data shown in the reports.
• Responsible for scheduling the Test status calls with users and the project management team.
• Prepared the test sign off documents.
• Detail system defects are created to inform the project team about the status throughout the process.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache.
• Used Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic.
• Developed Re-Usable Transformations and Re-Usable Mapplets.
• Developed Slowly Changing Dimensions Mapping for Type 1 SCD and Type 2 SCD.

Environment: Informatica Power Center 9.1/8.6, InformaticaAnalyst 9.1, InformaticaDeveloper 9.1,Windows NT, Oracle 9i/10g,Teradata, SQL/PL-SQL, T SQL, TOAD, XML.

Confidential, Cleveland, OH

Informatica Developer

Responsibilities:

• Responsible for converting Functional Requirements into Technical Specifications.
• Worked with the team to Integrate data from multiple source systems like Health Answers, Power system, Health Plex into Single Data Warehouse system.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, EDI files processing and Mapping Designer.
• Creating mappings with different transformations like Parser transformation, Standardizer transformation, Address Validator in Informatica developer (IDQ) tool.
• Used Address validator transformation in IDQ and passed the partial address and populated the full address in the target table.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator.
• Knowledge in health care domains such as HL7,FHIR AND FHIMHealthcare
• Extracted data from Flat files and Oracle and loaded them into Teradata.
• Designed the ETL processes using Informatica to load data from Oracle to target Teradata Database.
• Loaded the data into the Teradata database using Load utilities like FastExport, FastLoad, MultiLoad, and Tpump.
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Teradata, Oracle, Flat files and loaded into target.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Created Pre-Sql and Post-Sql scripts which need to be run at Informatica level.
• Developed Oracle views to identify incremental changes for full extract data sources.
• Developed Stored Procedures which truncates the Tables and reinserts all/partial records depending on the “Load Flag” Parameter passed to the procedure.
• All messages/errors/load times are logged into the log table.
• Developed the automated and scheduled load processes using Fact scheduler.
• Involved in migration of mappings and sessions from development repository to production repository.
• Responsible for Unit testing and Integration testing of mappings and workflows.
• Worked on production tickets to resolve the issues in a timely manner.
• Populated and updated data dictionary, standardized naming convention.

Environment: InformaticaPower Center 9.1/8.6, Informatica Data Quality, Teradata, Oracle 11i, DB2- Surveyor 400, Solaris UNIX, Winscp, Toad, Fact.

Confidential, Princeton, NJ

Informatica Developer/Data Analyst

Responsibilities:

• Chose critical tables and files for profiling activity with the help of business users.
• Created equivalent oracle tables in Staging area.
• Created ETL mappings to pull data from various databases to Oracle staging area.
• Created Data Maps to pull legacy data usingInformaticaPower Exchange.
• Captured various profiling results i.e. column profiling, table profiling, cross table profiling and cross application profiling results into the excel sheets so that business user can review the result.
• Involved in capturing data which requires data cleansing activity, which is also a step in migration activity.
• Participated in documentation part and tracking progress of Data Profiling project.

Environment: InformaticaPower Center 8.6, Oracle 10g, SQL Server, Toad,InformaticaPower Exchange, UNIX, SQL Plus and Windows 2000 / XP.

Confidential

ETL Developer/Sybase Developer

Responsibilities:

• Analyzed source systems, business requirements and identified business rules for building the data warehouse.
• Have written Technical Specification documents for the ETLprocess.
• Designed and developedInformaticaMappings, Workflows to load the data into Oracle DB, SQL server.
• UsedInformaticaworkflow manager, monitor, and repository manager to execute and monitor workflows and assign User Privileges.
• Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Used Debugger to test the mapping and fixed the bugs.
• Involved in Performance Tuning of Sessions and Mappings.
• Used the Workflow manager to create workflows and tasks, and also created Worklets.
• Involved in Production Support in resolving issues and bugs.
• Worked on SQL stored procedures, functions and packages in Oracle.
• Created and maintained UNIX Shell Scripts for pre/post session operations and various day-to-day operations.
• Developed Unit and System testing test cases, using System Procedures to check data consistency with adherence to the data model defined.

Environment: InformaticaPower Center 7.1, Oracle 9i, SQL server 2005, UNIX, SQL Plus, TOAD, MS Access, Windows XP.