SUMMARY

• Over 6 years 9 months of IT experience in Data warehousing wif emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems in various domains like healthcare and telecommunication.
• Strong background in Data warehousing i.e. OLTP and OLAP systems along wif using Informatica Power Center tools - Repository manager, Mapping Designer, Workflow Manager and Workflow Monitor.
• Implementing Client-Server Applications & Database systems using MSSQL,DB2 and Oracle and also extensive developing strategies for ETL process and also experience in Data Modeling, Database Design, Programming, Development processes.
• Extensively worked on Relational and Dimensional Data using Star Schema and Snowflakes Schema methodologies along wif slowly changing Dimensions, Data cleansing and Data Staging of various operational sources using ETL processes for data warehouses.
• Experience in implementing teh complex business rules by creating transformations, re-usable transformations like Expression, Aggregator, Filter, Connected and Unconnected Lookup’s, Router, Rank, Joiner, Update Strategy etc. wif development of complex Mapplets and Mappings using mapping designer.
• Working extensively on integration mappings of Type I, Type II, and Type III Slowly Changing Dimensions and implementing update strategies, incremental loads, and change data capture.
• Reviewing of Session log files to trace causes of bottlenecks and also worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Hands on experience in debugging and performance tuning of sources, targets, mappings and sessions.
• Experience in integration of various data sources definitions like SQL Server, Oracle, Flat Files and Salesforce.
• Experience on Informatica tools and utilities (Power Center, Power Exchange and Informatica On Demand).
• Experience in UNIX shell scripting.
• Experience in Performance SQL Tuning, ETL tuning and Exception handling.
• Developing various mapping design documents for ETL process.
• Experience in RDBMS development using SQL, SQL*Plus and PL/SQL codes through various Tables, Indexes, Materialized Views, Procedures/Functions, Packages, Cursors and Triggers to implement teh business logics of teh database.
• Working on creating reports using OBIEE and BI Publisher.
• Designing and developing Metadata Repository (.rpd) using OBIEE Administration tool by importing teh required objects (Dimensions, Facts) into Physical Layer using connection pool, developing multiple dimensions and measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
• Experience on various job scheduling tools like Control-M and Informatica Scheduler.
• Has extensive experience in Onsite / Offshore Client Handling along wif understanding of business rules completely based on High Level document specifications and implements teh data transformation methodologies.
• Experience in working along wif Production support teams in monitoring teh jobs and workflows.
• Excellent interpersonal and communication skills, technically competent and result-oriented wif problem solving skills and ability to work independently.
• Experience in Upgrade projects, involved in Performance testing and Regression testing.
• Experience in handling POC (Splice) to address performance issues.
• Experience in complete SDLC (System Development Life Cycle) wif Waterfall model and has knowledge in Agile methodologies.

TECHNICAL SKILLS

Data warehousing Tools: SQL Management Studio, Informatica Power Center 9.5/9.1/8.6/8.1, OBIEE 10g, Informatica Power Exchange, Informatica On Demand

Databases: Oracle 11g/10g/9i, DB2, MS SQL Server, Salesforce

Programming Skills: SQL, PL/SQL, ASP.NET

Scripting Languages: UNIX, Shell Scripting

Job Scheduling Tools: Control - M, Informatica Scheduler

SQL Tools: SQL*Plus, SQL Developer, Data Studio Client and TOAD

Migration Tools: Deployment Groups, HP Kintana and BMC Remedy

Operating Systems: Windows 7/XP, UNIX, Solaris

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Tx

Lead Informatica/Oracle Developer

Responsibilities:

• Worked wif several vendors in sending outbound files and load in bound extracts into teh warehouse.
• Has to provide support during Application deployment to Production.
• Continuous monitoring of existing Production jobs and take decisions that are appropriate.
• Worked on Developed mappings/Reusable Objects/Transformation/Mapplet by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center 9.x
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, Flat Files and Stored procedure transformations.
• Performed tuning and optimization of complex SQL queries using Oracle Explain plan.
• Expert level knowledge of complex SQL using Oracle functions and stored procedures.
• Analyzed teh source data, made decisions on appropriate extraction, transformation, and loading strategies.
• Modified teh existing scripts to enhance performance by using Volatile tables, incorporating parallelism, collect stats when needed, pushdown optimization and using indexes.
• Data Migration, Integration, Cleansing, and Conversion (Identification, Analysis, Mapping, Conversion and Reporting) services for Multiple Software Vendors, in multiple locations throughout teh United States.
• Used Informatica debugging techniques to debug teh mappings and used session log files and bad files to trace errors occurred while loading.
• Provided on call support during teh release of teh product to low level to high level Production environment.
• Worked wif Control - M scheduling tool for jobs scheduling.
• Involved in Unit testing, User Acceptance testing to check whether teh data is loading into target, which was extracted from different source systems according to teh user requirements.
• Created and Developed re-usable transformations, mappings and Mapplets confirming to teh business rules.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results.
• Used Deployment groups to migrate teh code across different environments like DEV/INT/PERF/PROD.
• Has knowledge on Splice DB, which is built on HBASE and HDFS system.

Environment: Informatica Power Center 9.5, Informatica Power Exchange 9.6/9.1, SQL Server, Oracle 11/g, DB2, Control - M, Solaris, Windows 7/XP.

Confidential, San Diego, CA

Lead Informatica Developer

Responsibilities:

• Worked wif several team in process of understanding teh existing architecture and outbound of new DB.
• Created complex mappings in Power Center Designer using Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, Flat Files and SQL transformations.
• Expert level knowledge of complex SQL using Oracle functions and stored procedures.
• Analyzed teh source data, made decisions on appropriate extraction, transformation, and loading strategies.
• Data Masking, Integration, and Conversion (Identification, Analysis, Mapping, Conversion and Reporting) services for Multiple Software Vendors, in multiple locations throughout teh United States.
• Used Informatica debugging techniques to debug teh mappings and used session log files and bad files to trace errors occurred while loading.
• Worked wif Informatica scheduling tool for jobs scheduling.
• Involved in Unit testing, User Acceptance testing to check whether teh data is loading into target, which was extracted from source system according to teh user requirements.
• Documented Design documents, ETL test plans, test cases, test scripts, assumptions, validations based on design specifications for unit testing, system testing and expected results.

Environment: Informatica Power Center 9.5, SQL Server, Oracle 11/g, DB2, Solaris, Windows 7/XP.

Confidential

Oracle/Informatica Developer

Responsibilities:

• Data and Database Migration including Informatica Power Center 8.1 to 8.6 and tan to 9.1, Oracle 10g to 11g and Data Mapping, retrieval, cleansing, consolidation, mapping, and reporting for client review.
• Analyzed teh source data, made decisions on appropriate extraction, transformation, and loading strategies.
• Gatheird required information from teh users.
• Developed performance utilization charts, optimized and tuned SQL. Assisted other developers wif PL/SQL and SQL.
• Documented Design documents, ETL test plans, test cases, test scripts, assumptions, validations based on design specifications for unit testing, system testing and expected results.
• Created Informatica mapping using Mapping Designer for Change Requests.
• Involved in End to End testing(Task creation in IOD - Business logic validation in ETL - Final output Update to Salesforce/Portal/OBIEE)
• Ensure compliance wif general programming best practices
• Ensure data integrity standards
• Performed tuning and optimization of complex SQL queries using Oracle Explain.
• Validation of data and code between current and new instances.
• Used Informatica debugging techniques to debug teh mappings and used session log files and bad files to trace errors occurred while loading.
• Evaluate performance after Upgrade and take necessary actions to reduce teh execution time
• Co-ordinated wif testing in evaluation of ETL code

Environment: Informatica Power Center 9.1/8.6, Oracle, Salesforce, Informatica On Demand, OBIEE, BMC Remedy Tool and Windows XP.

Confidential

Oracle/Informatica Developer

Responsibilities:

• Involved in complete SDLC (System Development Life Cycle).
• Gatheird user requirements and reporting requirements for a better understanding of teh business process and teh current reporting system.
• Involved in various phases of SDLC from requirement gathering, analysis, design, development and testing to production.
• Worked on Informatica Power Center tools-Designer (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplets & Transformations), Repository Manager, Workflow Manager & Workflow Monitor.
• Extensively used ERwin to design Logical/Physical Data Models and Modeled teh Data Warehousing Data marts.
• Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables, rapidly changing dimensions in Multidimensional model.
• Extensively created Reusable Transformations and Mapplets to implement teh business logic for loading to teh target database.
• Extracted data from Heterogeneous source systems like Salesforce and flat files.
• Experienced in creating tasks to pull and push data from Salesforce to Oracle Staging/Data Mart.
• Developed processes on Oracle using shell scripting and RDBMS.
• Developed scripts to load data from flat files into Oracle Staging area.
• Worked on error handling in Oracle SQL's using ERROR CODE and ACTIVITY COUNT.
• Implemented Slowly Changing Dimensions (Type 1, Type 2 and Type 3).
• Performed bulk data loads from multiple data sources to Oracle Warehouse using Informatica Bulk load.
• Used UNIX shell scripts to perform FTP transfers from different vendor sites and for user notification purposes.
• Most of teh transformations were used like Source Qualifier, Aggregator, Filter, Expression, and Unconnected and connected Lookups, Update Strategy.
• Optimized query & session performance, Improved mapping performance using SQL overrides.
• Used PL/SQL to write stored procedures and Oracle Index techniques to increase teh performance.
• Developed post and pre session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing teh file name to reflect teh file generated date etc.
• Developed various sessions, batches containing parameters files, indicator files and multiple sources file.
• Designed and developed UNIX shell scripts as part of teh ETL process to compare control totals, automate teh process of loading, pulling & pushing data from & to different servers.
• Involved in Creating Unit test & Integration test plans to test mappings & created test data.
• Experienced in Building teh repository and Involved in Administering teh Physical Layer, Business Model Mapping Layer and Presentation Layer.
• Involved in Job scheduling using Informatica Scheduler.
• Used Clear BMC tool/Compass to log all teh defects / Enhancements related to teh Applications.

Environment: Informatica Power Center 8.1, Oracle, UNIX, PL/SQL, Erwin, Salesforce, Informatica On Demand.

Confidential

Oracle/Informatica/OBIEE Developer

Responsibilities:

• Involved in full Software Development Life Cycle (SDLC) - Business Requirements Analysis, preparation of Technical Design documents, Data Analysis, Logical and Physical database design, Coding, Testing, Implementing, and deploying to business users.
• Involved in gathering business requirements, logical modelling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Worked on Informatica Power Center tools - Designer (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplets & Transformations), Repository Manager, Workflow Manager & Workflow Monitor.
• Extensively used ERwin to design Logical/Physical Data Models and Modeled teh Data Warehousing Data marts.
• Defining teh schema, staging tables, and operational data tables, configuring base objects, foreign-key relationships, complex joins, and building efficient views.
• Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables, rapidly changing dimensions in Multidimensional model.
• Extracted data from Heterogeneous source systems like Salesforce and flat files.
• Experienced in creating tasks to pull data from Salesforce to Oracle Staging.
• Developing as well as modifying existing mappings for enhancements of new business requirements mappings to load into staging tables and tan to target tables in EDW. Also created Mapplets to use them in different mappings.
• Developed scripts to load data from flat files into Oracle Staging area.
• Worked on error handling in Oracle SQL's using ERROR CODE and ACTIVITY COUNT.
• Implemented Slowly Changing Dimensions (Type 1, Type 2 and Type 3).
• Worked on different tasks in Workflows like sessions, events raise, event wait, e-mail, command, worklets and scheduling of teh workflow.
• Creating sessions, configuring workflows to extract data from various sources, transforming data, and loading into enterprise data warehouse.
• Running and monitoring daily scheduled jobs by using Work Load manager for supporting EDW (Enterprise Data Warehouse) loads for History as well as incremental data.
• Investigating failed jobs and writing SQL to debug data load issues in Production.
• Interacting wif teh Source Team and Business to get teh Validation of teh data.
• Writing SQL Scripts to extract teh data from Database and for Testing Purposes.
• Supported teh code after postproduction deployment.
• Used Clear BMC tool/Compass to log all teh defects / Enhancements related to teh Applications.
• Developed Dashboards and Reports in OBIEE to display individual performance details in Scorecard wif different views, filters, prompts and Drill down capabilities as per teh client requirements.

Environment: Informatica Power Center 8.1, Oracle, OBIEE, Erwin, Salesforce, Informatica Demand, Windows XP.

Confidential

Oracle/Informatica/OBIEE Developer

Responsibilities:

• Involved in gathering business requirements, logical modelling, physical database repository design, data sourcing and data transformation.
• Developed Dashboards and Reports in OBIEE to display individual performance details in Scorecard wif different views, filters, prompts and Drill down capabilities as per teh client requirements.
• Designing and developing Metadata Repository (.rpd) using OBIEE Administration tool by importing teh required objects (Dimensions, Facts) into Physical Layer using connection pool, developing multiple dimensions and measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
• Created hierarchies and performed aggregation operation in teh Business Model and Mapping layer based on business requirements.
• Performed Query Optimization wif teh halp of explain plans, Primary and Secondary indexes. Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Developing as well as modifying existing mappings for enhancements of new business requirements mappings to load into staging tables and tan to target tables in EDW. Also created Mapplets to use them in different mappings.
• Using various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in teh Informatica Designer.
• Creating sessions, configuring workflows to extract data from various sources, transforming data, and loading into enterprise data warehouse.
• Investigating failed jobs and writing SQL to debug data load issues in Production.
• Interacting wif teh Source Team and Business to get teh Validation of teh data.
• Writing SQL Scripts to extract teh data from Database and for Testing Purposes.
• Supported teh code after postproduction deployment.
• Experience in debugging and scheduling on BI publisher reports.

Environment: Informatica Power Center 8.1, OBIEE, BI Publisher, SQL, PL/SQL, UNIX, Window XP/2000.