SUMMARY

• Over Eight (8) years of IT experience in design, analysis, development, documentation, coding and implementation including Databases, Data Warehouse, ETL Design, Oracle, PL/SQL, SQL, Informatica 9.x/8.x/7.x and designing RPD, Reports and dashboards using OBIEE.
• Well versed with Business Process flows in Oracle Service Contracts & installed base, TCA, Order management and Inventory.
• Expertise in the ETL Tool Informatica and have extensive experience in Power Center Client tools including Designer, Repository Manager, Workflow Manager/ Workflow Monitor.
• Extensively worked with complex mappings using various transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Unconnected / Connected Lookup, Aggregator, Stored Procedure, Sequence Generator, Update Strategy, User Defined Functions, Mapplets, etc.
• Experienced in mapping techniques for Type 1 and Type 2 Slowly Changing Dimensions
• Extensive experience in debugging mappings, identifying bottlenecks in existing mappings by analyzing the data flow and evaluating transformations.
• Strong data modeling knowledge of Star schema, Snowflake schema design, Fact, Dimensions tables, Physical and Logical data modeling (Ralph Kimball/Bill Inmon).
• Expert in analyzing Business & Functional Specifications, creating Technical Design Document and Unit Test cases.
• Hands on experience of Linux/UNIX, Shell scripting, sound knowledge in command line utilities like PMCMD to execute workflows in non - windows environments.
• Extensive experience in implementation of Data Scrubbing & cleanup, procedures, transformations, Scripts, and execution of test plans for loading the data successfully into the targets.
• Emphasized on Performance of Mapping Optimizations in Informatica.
• Actively involved with cross-functional teams in gathering & analyzing the requirements and translated them into system solutions.
• Developed many Reports / Dashboards with different Analytics Views to provide an accurate view to assimilated top management in taking right decision to boost the organization's growth and revenue.
• Created numerous executive level reports by using various BI analytical features like Drill-Down, Pivot Table, Chart, Column Selector, Tabular with global & local Filters, Prompts.
• Technical abilities are complemented by sound communication and good user interaction abilities well versed with the quality processes.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.1/8.6.1/8.1.1/7.1.3 (Repository Manager, Designer, Work Flow Monitor, Work Flow Manager) & Datamart.

BI & Reporting: OBIEE 10g/11g.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, ERwin.

Data Analysis: Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.

Databases: Oracle 10g/9i, Oracle 8i, Oracle11i, MS SQL Server 2008/2005,DB2,Teradata.

Programming: Unix Shell Scripting, SQL, PL/SQL.

Environment: Linux, UNIX (Sun Solaris, HP-UX, AIX).

Scheduling and Deployment Tools: Dollar U, Autosys and Kintana.

Version Control Tools: PVCS, SVN and CVS.

PROFESSIONAL EXPERIENCE

Confidential, Mountain View, CA

Informatica Developer

Responsibilities:

• Efficiently & effectively handled the task of converting user requirements into well documented mapping designs.
• Worked with Business Analyst in analyzing and decoding requirements into various Specs and Involved in weekly team meetings to implement the same.
• Developed complex mappings (SCD Type1&2) using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, SQL Server and loading to Oracle target database.
• Extensively used various types of transformations such as Expression, Joiner, Router, Update strategy, Aggregator, Lookup (Connected and Unconnected) to load the data.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Debugging the Mappings, which were raised by QA at Testing Environment.
• Performed Mapping Optimizations to ensure maximum Efficiency.
• Implemented complex mapping such as Slowly Changing Dimensions (Type II) using Flag.
• Data scrubbing and error handling.
• Encoding data for change data capture.
• Created Mapplets which provides reusability in mappings.
• Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency of session.
• Used CVS for version control of code and objects
• Scheduling the workflow jobs, running and monitoring the jobs through Autosys scheduler.
• Excellent rapport with cross functional teams for successful completion of given requirements.
• Extensively involved with BI team in building RPD for reporting purposes.
• Designed the layout for different dashboards and reports.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the Lease Revenue data by product, Customer and Region wise.

Confidential

Responsibilities:

• Created Technical Design documents based on Functional Specifications.
• Created mapping for extraction of the Service request information from HPCC to SOMPS tables using Informatica ETL Tools.
• Developed complex mappings (SCD Type1&2) using Informatica Power Center Designer.
• Created various mappings to implement the business logic using different transformations like Lookup, Router, Expression, Update Strategy, Filter, Sequence generator and Joiners.
• Apply many business validation rules on staging tables and load the data into SOMPS tables.
• TunedInformaticaMappings and Sessions for optimum performance.
• Created Email Task to send the Successes or Failure post-session messages.
• Used CVS for version control of code and objects
• Scheduling the workflow jobs, running and monitoring the jobs through Autosys scheduler.
• Excellent rapport with cross functional teams for successful completion of given requirements.
• Extensively involved with BI team in building RPD for reporting purposes.
• Developed many Reports with different Analytical Views (Drill-Down, Pivot Table, Chart, Column Selector and Tabular with global and local Filters).
• Developed customized Dashboards by integrating various Reports of service Activities, Revenue vs expense on various services, Actual Vs Forecasted Response rates in rendering variety of services, Segment and Offer responses etc.

Environment: Oracle 11g/10g/9i, Informatica Power Center 9.1/8.6.1, SQL, ERwin, TOAD, Oracle Service Contracts &Installed base, TCA, Oracle Order Management, UNIX, SQL Server, PL/SQL, Flat files, SQL*Loader, OBIEE10/11g, CVS and Autosys Scheduler.

Confidential, Santa Clara, California.

Informatica Developer

Responsibilities:

• Involved in writing ETL process specifications, standards and writing best practice documents.
• Analyzing the data model and identification of heterogeneous data sources.
• Created mappings to extract the data from different Call Center source files and load the data into staging tables.
• Created various mappings to implement the business logic using different transformations like Lookup, Router, Expression, Update Strategy, Filter, Stored Procedure, Sequence generator and Joiners and Worked with large volumes of data.
• Implemented Slowly Changing Dimensions (SCD type 1&2).
• Involved in identifying bottlenecks, resolving on-going maintenance issues and bug fixes in existing mappings by analyzing the data flow and monitoring Informatica sessions.
• Designed mappings to capture CDC.
• Apply many business validation rules on staging tables and load the data into CMDB tables.
• As per the business requirement, created Email Task to send the system audit results to the respective Call Centre E-mail addresses.
• Create Unit Test cases, involved in code review sessions, fixed bugs while testing was going on.
• Used SQL queries during unit testing to validate the data.
• Involved in fine tuning the mappings to get the faster output.
• Scheduling the workflow jobs, running and monitoring the jobs through Dollar U scheduler.
• Used Kintana Software to move $U scripts fromDev to Stage and to PROD.

Confidential

Responsibilities:

• Involved In creating / developing Mapping Design Specifications and developed implementation plan and schedule.
• Experience with high volume datasets from various sources like Text Files, Relational Tables.
• Performed Informatica code migrations, test, debug, document to maintain programs and deployed.
• Scrubbing and transforming the source data by applying required business logic and developed complex mappings using Informatica Power Center Designer to transform and load the data from various sources.
• Error checking and testing of the ETL procedures and programs using Informatica session log.
• Fine-tuned existing Informatica mappings for Performance Optimization.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Designed mappings to capture CDC.
• Involved in writing ETL process specifications and standards. Involve in writing best practice documents. Analyzing the data model and identification of heterogeneous data sources.
• Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator. Worked with large volumes of data.
• Extensively used SQL*Loader scripts to load legacy data into Staging tables.
• Used Workflow manager to create, schedule, monitor, and send the messages in case of process failures. Developed several reusable transformations and Mapplets.
• Involved in troubleshooting tuning @all levels and supported engineering and QA teams in problems diagnosis.
• Implemented Unit Testing and involved in all phases of testing including Regression Testing, Integration Testing, System Testing and User Acceptance Testing.
• Developed UNIX scripts for scheduling the jobs.
• Assisted the DW/BI team in designing and creating various Subject areas.
• Generated Reports and Dashboards by using Reporting features like Pivot tables, charts and view selector.

Environment: Oracle 10g/9i, Informatica Power Center 8.6,8.1,7x, SQL, SQL*Plus, OBIEE 10g, TOAD, Oracle CRM UNIX, Linux, DB2,SQL Server, PL/SQL, Flat files, SQL*Loader, ERwin, Kintana, Dollar U.

Confidential, Walnut Creek CA.

Informatica Developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data.
• Consolidation, standardization, matching for the flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Effectively performed tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.

Environment: Informatica Power Center 8.5/8.1.1, Oracle 10g/9i, SQL Server 2005, DB2, SQL*Plus, SQL Loader, SQL Developer, ERwin, Autosys, Flat files, Toad, UNIX, Windows 2000.

Confidential

SQL Developer

Responsibilities:

• Developed prototype in MS Access and help meeting with clients. Made system design and defined functional specifications as directed by user in prototype.
• Created database schema on Oracle using case tool.
• Discussed prototype with procedural changes and suggestions.
• Designed and developed data integrity rules using PL/SQL database triggers in order to validate and integrate coming data before loading stored procedures in order to validate data on server for all clients.
• Designed and tested system implementation in test environment and moved to production environment.
• Involved in Data loading and Extracting functions using SQL*Loader.
• Designing and developing forms validation procedures for query and update of data.
• Performed DBA related tasks (Managing database objects and table spaces).
• Supervised in forms and reports designing along with guiding other members of the team in database programming.
• Wrote triggers, menus and stored procedures in PL/SQL.
• Involved in building, debugging and running forms.

Environment: Developer/2000 (Forms, Reports & Graphs), PL/SQL, Oracle 8, OEM, Server Manager, UNIX, Windows 2000/NT, Erwin and MS Access