SUMMARY

• 11+ 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.
• 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 effictively as a team member as well as an individual.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5, 8.6, 8.5.1/ 8.1 / 7.1.3 / 7.0 / 6.2 , Informatica Data Explorer and Informatica Data Quality.

Databases: Oracle 8i / 9i / 10g, 11g, 12c, Teradata V2R4 / V2R5 / 13, SQL Server, MS Access, Sybase, DB2, VSAM, IMS DB/DC, UDB

Data Modeling Tools: Erwin 4.0 / 3.5, Business Objects 6.0.

Programming: COBOL, JCL / PROC, Install1, COBOL II, SQL / PL/SQL.

Operating Systems: Win 95/98/2000/XP, UNIX / Korn Shell.

Web Technologies: HTML, XML, JavaScript, and VB Script.

PROFESSIONAL EXPERIENCE

Confidential

Lead Database cum Informatica Developer

Responsibilities:

• Analyzed existing COBOL code and created equivalent code in PL/SQL stored procedure to replace old tracking system.
• Created mapping documents for existing Informatica mappings.
• Detailed analysis of existing database i.e. Oracle 10g and migrated to Oracle 11g.
• Corrected existing PL/SQL code for above migration.
• Detailed analysis for upcoming taxation and tracking projects.
• Participated in designing phase of above projects.
• Detailed analysis of Business models, logical data models and physical data models and required report structures.
• Extracted data from flat files to Oracle tables through Informatica Power Center and SQL Loader.
• Created dimension and fact tables for above projects.
• Generated sample reports to determine correctness of data.
• Created Informatica mappings to populate dimension, facts and lookup tables.

Environment: Informatica Power Center 9.6.0, Oracle 11g, Oracle 12c, Microsoft Access, Erwin5.0, SQL developer.

Confidential

Lead Informatica Developer

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.
• 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 FileZilla, 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, Informatica Data Explorer 9.5, Informatica Data Quality 9.5, IDD, DB2, Informatica Power Exchange, UNIX, SQL Plus.

Confidential, New Jersey

Lead Informatica Developer

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 FileZilla, 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, Stamford, CT

Informatica Developer cum Lead 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 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, Dallas, Texas

Informatica Developer cum Data Analyst

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, Cincinnati, Ohio

Informatica Developer

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, Charlotte, NC.

Informatica Developer cum Data Analyst

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.5Oracle Designer, Teradata V2R4 / V2R5, Toad, PL/SQL, Linux, Erwin and Windows 2000 / XP.

Confidential, Hartford, CT

Informatica Developer

Responsibilities:

• Assisted in creating fact and dimension tables as per requirement.
• Designed Data Warehousing tables in STAR schema methodology.
• Extensively used Informatica Power Center to create data maps for extracting data from Relational, Mainframe system (VSAM files) & DB2 and loaded into Oracle Staging tables initially.
• Used Informatica client tools such as Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
• 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.
• Optimized Query Performance, Session Performance and Reliability.
• Configured mappings to handle updates to preserve existing records using Update Strategy Transformation (Slowly Changing Dimensions SCD Type-2).
• Created stored procedures and functions, as per requirements in PL/SQL.
• Used Source Pre-Load, Source Post-Load, Target Pre-Load, Target Post-Load functionality of Stored Procedure Transformation.
• Performed Performance tuning of targets, sources, mappings and session.
• Involved in Partitions of Pipelines to improve performance.
• Used UNIX scripting while writing cron jobs for batch processing.
• Used Test Director to log and keep a track of defects. Worked with Test team in resolve defects.
• Provided Production Support at end of every release.
• Generated reports using Business Objects from Oracle target database.
• Created Multi-Dimensional analysis using Slice/Dice and Drill methods to organize data along with a combination of “Dimension” and “Hierarchies” giving ability to end-users to review data from various viewpoints.
• Documented Technical specifications, business requirements and functional specifications for development of ETL mappings to load data into various tables.

Environment: Informatica Power Center 7.1, Business Objects 6.1, Oracle 9i, DB2 UDB, Teradata V2R4 / V2R5, UNIX, Erwin 4.0, SQL Server, PL/SQL, SQL*Loader, Win NT/2000.