PROFESSIONAL SUMMARY

• Over 10 years of experience in IT Industry including 7 years of expertise in Analysis, Design, Development, Implementation, Modeling, Testing, and Support for Data Warehouse applications.
• Involved in designing, development and production support of Data Warehouse.
• Extensive experience in Informatica Power Center 9.x/8.x/7.x/6.x/5.x to carry out Extraction, Transformation and Loading process.
• Thorough understanding in Data Warehouse and Business Intelligence concepts with emphasis on Repository Manager, Master Data Management MDM , Designer, Workflow Manager and Workflow Monitor.
• Extensively worked on Dimensional Modeling, Data Migration, Data Cleansing, and Data Staging of operational sources using ETL process and providing data mining features for data warehouses.
• Outstanding Technical Knowledge in Oracle Applications with Distribution/Supply Chain Modules like OM-Order Management, INV-Inventory, PO-Purchasing, WSH-Shipping financial modules like GL-General Ledger, AP-Oracle Payables, AR-Oracle Receivables, Manufacturing Modules such as BOM-Bill of Materials, WIP-Work in Progress, MRP-Material ResourcePlanning .
• Skilled in Performance Tuning, Error Handling and Production Support.
• Skilled in implementing update strategies, incremental loads and change data capture.
• Thorough understanding in complete software development life cycle including Requirement Gathering, Requirement Analysis, Cost Estimation, Project Management, Design, Development, Implementation and Testing.
• Expert skills in OLAP, developing database Schemas like Star Schema, Snowflake Schema, Conforming Dimensions and Slowly Changing Dimensions used in relational, dimensional and multi-dimensional modeling.
• Experience in various versions of Oracle, Teradata, SQL Server, SQL, PL/SQL, stored procedures and functions, triggers and exceptions. Good experience in Relational Database Concepts, Entity relational Diagrams.
• Experience in UNIX working environment, developing UNIX shell scripts for Informatica pre and post session operations.
• Development experience across business areas such as Finance, Mortgage Funding, Insurance, Pharmaceutical, Healthcare, Supply chain and Manufacturing.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

WORK EXPERIENCE

Confidential

Responsibilities

• Created the Data Maps to pull the legacy data using Informatica Power Exchange.
• Extracted and populated xml files through Informatica.
• Analyzed CURAM data and compared with Hix Common Identity data in Development region, Test regions, Staging environment and Production environment.
• Worked with Operational data sources ODS , Staging data, Data Marts and Data Warehouse.
• Created Informatica mappings for migrating data into DB2 tables.
• Converted Excel sheet into flat files.
• Performed Conversion of flat files to Oracle tables by sending them to remote node using File Zilla, extraction the data from flat files using Informatica tool.
• Worked on performance tuning in every conversion / loading process.
• Validated data in development environment and UAT environment.
• Populated error records in exception file.
• Environment: Informatica Power Center 9.5.0, Informatica Developer 9.5.1, DB2, Informatica Power Exchange, UNIX, SQL Plus.

Confidential

Responsibilities:

• Created the Data Maps to pull the legacy data using Informatica Power Exchange.
• Extracted and populated xml files through Informatica.
• Worked with Operational data sources ODS , Staging data, Data Marts and Data Warehouse.
• Created Informatica mappings for Bulk Pull and CDC Change Data Capture .
• Populated staging data for TPI Third Party Interphase Module .
• Converted of Excel sheet into flat files.
• Performed Conversion of flat files to Oracle tables by sending them to remote node using File Zilla, extraction the data from flat files using Informatica tool.
• Analyzed TPI requirements and procedures.
• Analyzed TPI data models and generated DBRs for enhancement of TPI data model.
• Created TPI mappings and populated CAIR data into corresponding tables.
• Managed duplicate TPI entries through Master Data Management MDM process.
• Used Proactive Monitoring and Metadata Manager to ensure data quality of TPI data.
• Also created ETL mappings for sub modules i.e. TPI Contracts, TPI Requests.
• Performed unit testing for the mappings and compared against production data.
• Resolved defects during testing, UAT and integration phase.
• Worked on performance tuning in every conversion / loading process.
• Created mappings to populate data for AR Account Receivables tables.
• Verified TPI Data from AR prospective and documented the errors.
• Enhanced TPI Data conversion protocol, fixed data errors and mapping errors.
• Validated data in development environment and UAT environment.
• Environment: Informatica Power Center 9.5.0, Oracle 10g, 11g, Toad, Informatica Power Exchange, UNIX, SQL Plus.

Confidential

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 using Informatica Power 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: Informatica Power Center 8.6, Oracle 10g, 11g, SQL Server 2005, Oracle Designer, Toad, Rapid SQL, DB Visualizer for Sybase Data, Informatica Analyst 9.0 Informatica Data Explorer , Informatica Developer 9.0 Informatica Data Quality , Informatica Power Exchange, UNIX, SQL Plus and Windows 2000 / XP.

Confidential

Responsibilities

• Interacted with business users and team leads for better understanding of data cleansing requirements.
• Created ETL mapping to update staging table and cleansed table.
• Generated various types of data profiling results, profiling on all columns, profiling on selected columns and prepared profiling report.
• Generated data profiling scorecards. Score cards on columns before and after cleansing to show quality improvement of Data.
• Created data cleansing maps and Mapplets and putting them in workbench to execute all data cleansing rules at a time.
• Used almost all IDQ transformations i.e. Standardizer, Parser, Merge, Match, Labeler, Association, Case Converter, Comparison, Address Validator, Consolidation, Decision.
• Used Informatica Data Quality to cleansing data and Data Virtualization to monitor the data quality.
• Used BTEQ for import and export, Fast Load, Multi Load and Fast export utilities.
• Worked on derived, volatile and global temporary tables.
• Used TPT wizard to load data into Teradata database.
• Modified the cleansing rules and updated the workbench on requirement.
• Conducted unit testing on cleansed data before delivering to production team.
• Created documentation for data profiling and data cleansing activities.
• Environment: Informatica Power Center 8.6, Oracle 10g, SQL Server 2005, Oracle Designer, Toad, Teradata V2/R5, Informatica Analyst 9.0 Informatica Data Explorer , Informatica Developer 9.0 Informatica Data Quality SQL Plus and Windows 2000 / XP.

Confidential

Responsibilities:

• Interacted with business users and team leads for better understanding of business specifications and requirements, Identifying data sources and Development strategies.
• Analyzed business requirements, technical specifications, source repositories and physical data models for ETL mappings.
• Worked extensively with mappings using expressions, aggregators, filters, lookup, joiner, update strategy and stored procedure transformations.
• Coordinated and developed documentation related to ETL design and development.
• Used update strategy transformation to effectively migrate data from source to target.
• Used repository manager to create repository, user groups and managed users by setting up privileges.
• Created stored procedures and invoked from Informatica.
• Used Informatica debugger to debug the mappings.
• Performed partitions on sources to improve the performance.
• Optimized the mappings and implemented the complex business rules by creating re-usable transformations and mapplet.
• Used Informatica workflow manager for create, ran batches and sessions and scheduled them to run at specified time.
• Involved in Performance Tuning of mappings, SQL overrides and stored procedures.
• Improved the performance of ETL process by indexing and caching
• Created workflows, tasks, database connections, FTP connections using workflow manager.
• Created UNIX shell scripting for automation of ETL process.
• Developed simple complex mappings using Informatica to load dimension fact tables as per STAR Schema techniques
• Analyzed Session log files to resolve errors in mapping and managed session configurations
• Environment: Informatica Power Center 8.6, Oracle 10g, SQL Server 2005, Oracle Designer, Toad, PL/SQL, Linux, Erwin and Windows 2000 / XP.
• Confidential

Responsibilities:

• Prepared a detailed Technical Design Document after analyzing the Functional Specifications and Architectural Diagram. Technical Design Document captured all functional and technical requirements.
• Worked with different sources like Oracle, SQL Server, Netezza, DB2 UDB and flat files.
• Performed Data Cleansing before loading it on data warehouse.
• Developed numerous Complex Informatica Mappings, Mapplets and reusable Transformations.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions.
• Created PL/SQL Procedures for data extractions, transformation and loading.
• Developed Workflows with various Tasks and Parameter files.
• Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. This led to better session performance.
• Profiled and cleansed data by using tools i.e. Informatica Data Quality IDQ and Informatica Data Explorer IDE .
• Loaded data into Teradata by using BTEQ batch scripts.
• Used Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Modified pre-existing scripts and used them to automate scheduling process using Autosys.
• Prepared Test Cases for testing interfaces which were used by QA team.
• Extensively used Informatica Metadata Reporter to analyze and manage repository efficiently.
• Performed Code review to ensure that ETL development was done according to client's ETL standard and ensured that ETL best practices were followed.
• Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL Server 2005, Netezza 4.5,
• Oracle Designer, Teradata V2R4 / V2R5, Toad, PL/SQL, Linux, Erwin and Windows 2000 / XP.