PROFESSIONAL SUMMARY:

• Over 8 years of total IT experience and Technical proficiency in the Data Warehousing teamed with Data Analysis, Data Modeling, Business Requirements Analysis, Application Design, Development Testing, Data profiling, data standardization Quality Control and full life cycle Implementation of Data Warehouse.
• Proficiency in interviewing stakeholders, requirements analysis and realization using Use Cases, deriving testable functional / non-functional system requirements, providing strategic and tactical inputs and coordinating with business functions and technical project teams from conception through deployment.
• Involved in Requirement gathering, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Data Quality in different Data warehouse Projects
• Experience in business requirements gathering, define and capture metadata for business rules, system analysis, design, development, production support, testing, user training, and strategic decision making, problem solving associated with the ETL processes by working closely with BI team.
• Experience in Data Modeling Data Analysis experience using Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake Modeling, FACT Dimensions tables, Physical Logical Data Modeling.
• SCD Management including Type 1, 2, 3, Hybrid Type 3, De-normalization, Cleansing, Conversion, Aggregation, Performance Optimization, Audit, etc.
• Designed complex Mappings and have expertise in performance tuning and slowly-changing Dimension Tables and Fact tables.
• Followed Application ILM in Data Warehousing Development.
• Experience and Efficient in Informatica Siperian MDM including batch based and real-time processing.
• Experience in Master Data Management MDM architectures and business processes.
• Experience in Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Experience with MDM Hub configurations - Data modeling Data Mappings, Data validation.
• Experience with Informatica Data Quality for Data Validation.
• Experience in PL/SQL Programming and in writing Stored Procedures, Functions etc
• Experience in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading ETL mechanism by using Informatica 9.x/8.x/7.x
• Worked extensively on performance tuning of ETL maps and considerably decreased the ETL load timings
• Experience in source systems analysis and data extraction from various sources like Flat files, Oracle 11g/10g/9i/8i, IBMDB2 UDB,SQL Server,Teradata.
• Expertise in Tuning the DW environment including Oracle SQL query tuning, Database tuning and in Informatica Power center to identify bottlenecks, tune and remove bottlenecks. Query Rewrite, tuning Mappings and Sessions.
• Involved in production support, resolving the production job failures, interacting with the operations support group for resuming the failed jobs.
• Experience in writing complex sub queries, PL/SQL programs functions, procedures, packages , stored procedures, and UNIX shell scripting, Perl scripting and automation of ETL Processes
• Expertise in tuning Oracle queries using Explain Plan and TSQL queries using query plan.
• Experience in using Business Objects, OBIEE for developing and maintaining reports.
• Prepared user requirement documentation for mapping and additional functionality.
• Extensively used ETL to load data using PowerCenter from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle. Analyzed the existing systems and made a Feasibility Study.
• Analyzed current system and programs and prepared gap analysis documents
• Have developed skills in system analysis, troubleshooting, debugging, deployment, prioritizing tasks and customer handling.

TECHNICAL SKILLS

ETL Tools: InformaticaPowerCenter9.5/9.1/8.6/7.x, Informatica Power Exchange, Informatica PC for SAP, JMS.

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, Teradata V2R4/V2R3, DB2 UDB 8.1, MS SQL Server 2008/2005.

Operating Systems: UNIX Sun-Solaris, HP-UX,AIX

Programming SQL, SQL-Plus, PL/SQL, UNIX Shell Scripting Korn, C

Reporting Tools: Business Objects, OBIEE

Modeling Tools: Erwin 4.1 and MS Visio

Other Tools: SQL Navigator, Rapid SQL for DB2, Quest Toad for Oracle, SQL Developer 1.5.1, Autosys, Serena Dimensions Version Manager, MS SharePoint, Mercury Quality center.

Methodologies:Ralph Kimball,Inmon

PROFESSIONAL EXPERIENCE:

Confidential

Data WareHouse Developer

• Gathered requirements and built source to target mapping documents and ETL data flow documents
• Performed major role in understanding the business requirements and designing and loading the data into data warehouse ETL .
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source Target definitions and coded the process of data flow from source system to data warehouse.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Used Informatica Data Quality to develop Data Quality Plans for Data Governance.
• Used Informatica MDM for Security, Fund and Client Data Management.
• Manage ETL developers and allocate tasks and projects, responsible for deliveries and task/project tracking
• Provide solutions for workflow automation through ETL using Informatica
• Create test plans, strategies and documentation of results
• Create and manage best practices and standards for ETL processes
• Perform code review, bug fixing, issues tracking and resolution
• Provide solutions for workflow automation through ETL using Informatica
• Created complex SQL queries in EDW
• Worked on UNIX shell scripts for ETL Orchestration.
• Have Good knowledge in Teradata utilities MLoad, Fastload and Tpump.

Environment: InformaticaPowerCenter 9.5Informatica Power Connect SAP, Informatica Power Connect JMS, Oracle 11g, MS SQL Server 2008, Teradata 11, Toad, Business Objects, Autosys, LINUX.

Confidential

Sr. Informatica Developer

Responsibilities:

• Worked with Business Users in understanding the requirements.
• Documented the requirement specifications and created source to target mapping documents.
• Responsible for designing and implementing data masking solutions.
• Used Data masking to hide the confidential customer account information.
• Hands on development using Data Masking tools.
• Good knowledge on applying rules and policies using ILM for Data Masking Transformation and loading in to targets.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created Mapplets, reusable transformations and used them in different mappings.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Used database objects like Views and Stored Procedures for accomplishing Complex logical situations.
• Involved in Unit testing, System testing to check whether the data loading into target are accurate, which was extracted from different source systems according to the user requirements.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like Session Partitioning, setting DTM Buffer Size and Cache Calculation Data/Index cache to manage very large volume of data.
• Worked with DBA's in tuning SQL queries using Execution Plan, Partitioned tables, compressed tables and Purged the data periodically.
• Actively participated in Design Reviews and Code Reviews to follow Standards and Best Practices.
• Used Autosys scheduling and Informatica Scheduler to schedule the workflows.

Environment: InformaticaPowerCenter 8.6, SQL Server 2008, Oracle 10g, Teradata, Power Exchange, Autosys.

Confidential

Sr. Informatica Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Interacted with Business Users and Managers in gathering business requirements.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively worked on PowerCenter Client Tools like PowerCenter Designer, WorkflowManager, and Workflow Monitor
• Extensively worked on PowerCenter9.6 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Created Parameter files and validation scripts.
• Created Process Control and Metadata for informatica jobs.
• Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager.
• Involved in providing 24/7 production support to solve critical issues.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Assisted with peer code reviews and testing of development team's T-SQL code.
• Performed Unit testing and Data validation testing using Validation scripts.
• Proven Accountability including professional documentation and weekly status report.
• Provided production support for the Executive Management Information System EMIS , a web reporting portal to informatica and teradata data sources
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Environment: InformaticaPowerCenter 8.6, Oracle 11g, Flat Files, SQL Server 2005, UNIX, SQL Plus, Putty

Confidential

ETL Developer

Responsibilities:

• Documented Informaticamappings, design and validation rules.
• Developed different mapping logic using various transformations to extract data from different sources like flat files, Oracle
• Developed mapping logic using various transformations like Expression, Lookups Connected and Unconnected , Joiner, Filter, Sorter, Update strategy and Sequence generator.
• Actively implemented Informatica performance tuning by identifying and removing the bottlenecks and optimized session performance by tuning complex mappings
• Extensively involved in unit testing, integration testing and system testing of the mappings and writing Unit and System Test Plan.
• Migrated objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Involved in production support, resolving the production job failures, interacting with the operations support group for resuming the failed jobs.
• Unix Scripts were written at various situations like event automation and job scheduling.

Environment: InformaticaPowerCenter 7.1.4, Autosys 4.5, HP-UNIX 11i, Oracle 9i, PL/SQL, IBM DB2 8.5.

Confidential

ETL/Oracle Developer

Responsibilities:

• Extraction, Transformation and data loading were performed using Informatica into the database. Involved in Logical and Physical modeling of the drugs database.
• Based on the requirements created Functional design documents and Technical design specification documents for ETL.
• Created tables, views, indexes, sequences and constraints.
• Developed stored procedures, functions and database triggers using PL/SQL according to specific business logic.
• Transferred data using SQL Loader to database.
• Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
• Used legacy systems, Oracle, and SQL Server sources to extract the data and to load the data.
• Involved in design and development of data validation, load process and error control routines.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Generated monthly and quarterly drugs inventory/purchase reports.
• Coordinated database requirements with Oracle programmers and wrote reports for sales data.

Environment: Informatica Power Center,Oracle 8i, SQL, PL/SQL,UNIX.