SUMMARY

• 7+ years of experience and strong background in ETL, development and implementation of various data warehouses/data marts and OBIEE.
• Extensive experience as ETL Developer in technologies and methods using Informatica Power Center 9.5, 8.x, 7.x, 6.x.
• Extensively worked on Dimensional modeling (Star/Snow flake), Data migration, Slowly Changing Dimensions, Data cleansing and Data Staging of operational sources using ETL processes for data warehouses.
• Actively involved in Performance SQL Tuning, ETL tuning and Error handling.
• Experience in implementing teh complex business rules by creating transformations, re - usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup’s, Router, Rank, Joiner, Update Strategy), and developing complex Mapplets and Mappings.
• Experience in Data Modeling (Logical and Physical Design for distributed databases, Reverse-engineering and Forward-engineering using Erwin).
• Excellent noledge of studying teh data dependencies using Metadata stored in teh Informatica Repository and preparing batches for teh existing sessions for scheduling of multiple sessions.
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Experience in building Oracle Data Warehouse from different OLTP systems.
• Strong experience wif MS SQL, PL/SQL, Stored Procedures, Packages, and Triggers.
• Seamlessly migrated teh Code from Development to Testing, UAT and Production.
• Experience wif various domain areas such as Health Care, Pharmaceuticals & Finance
• Expertise over preparingreport specifications, database designsto support teh reporting requirements
• Perform review of Session log files to trace causes of bottlenecks.
• Extensively worked on Informatica designer components Source Analyzer, Target Analyzer, Transformation Developer, Mapping and Mapplet designer.
• Worked wif various transformations in designing teh mapping like Expression, update strategy, filter, router, aggregator, connected and unconnected lookup.
• Developed mapping design documents for ETL process.
• Experience on handling slowly changing dimensions to maintain complete history.
• Involved in Unit testing of mapping.
• Developed Informatica workflows and sessions associated wif teh mappings using Workflow Manager.
• Designed and developed 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 Drill down Hierarchies and implemented Business Logics and Facts.
• Implemented Siebel Analytics security at teh data and object levels.
• Developed reports/dashboards Analytic views (Pivot Tables, Charts, Column Selector, and View Selector).
• Designed Dashboards wif links to websites, documents and embedded contents.
• Worked on configuring Delivers for sending alerts to dashboards and to e-mail.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 9.5/9.1/8.6.1

Databases: Oracle 11g/10g/9i

Reporting Tools: OBIEE 10.x

Programming Skills: C, SQL, PL/SQL

Scripting Languages: Unix Shell Scripting

SQL Tools: Toad, SQL*PLUS

Operating Systems: Windows XP/NT/2000/2003, AIX, Linux and Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Designed and developed teh OBIEE Repository(.rpd) using OBIEE Admin tool by importing teh required database objects both facts and dimensions wif integrity constraints into physical layer using connection pool.
• Created business facts, dimensions and defined logical relation between them at teh business model and mapping layer.
• Worked on Initialization blocks and variables development to achieve security.
• According to teh Dashboard Mockup, identifying teh required measures and attributes and sending teh required dimensions and measures to teh business team.
• Created OBIEE reports, filters, prompts and developing new dashboards according to teh mockup.
• Created Catalog Groups and users and set permissions for items in teh presentation catalog and privileges and rights to users and groups.
• Involved in testing of teh reports.
• Checking teh OBIEE incident tickets in remedy tool and troubleshoot issues based on severity of teh issue.
• Handling teh change requests.

Confidential

ETL Developer

Technology: Informatica Power Center 8.6.1, Oracle10g.

Responsibilities:

• Involved in Design and Development of ETL processes.
• Used Informatica Designer Tool to develop mappings for Extracting, Transforming and Loading required data into data ware house.
• Extracting data from Different sources and loading into teh staging table.
• Designed various mappings using transformations like LookUp, Router, Update Strategy, Filter, Joiner, Aggregator, and Expression Transformation.
• Preparation of Mapping specification documents for informatica mapping.
• Designed mappings using SCD I, SCD II techniques.
• Checked and tuned teh performance of Informatica Mappings.
• Developed Informatica workflows and sessions associated wif teh mappings using Workflow Manager.
• Involved in Unit Testing of mappings.

Confidential

ETL Developer

Responsibilities:

• Used Informatica Designer Tool to develop mappings for Extract, Transform and Load required data into data ware house.
• Designed mappings using SCD I, SCD II techniques.
• Preparation of Mapping specification documents for informatica mapping.
• Used heterogeneous data sources like flat files and Oracle.
• Identified and created different source definitions to extract data from input sources and load into relational tables using Informatica Power Center.
• Checked and tuned teh performance of Informatica Mappings.
• Involved in Unit Testing of mappings.

Clinical Confidential

Developer

Responsibilities:

• Hospital mortality rate by disease.
• Hospital mortality rate by age demographic group (infant, adult male, adult female, new born etc).
• Month wise incidents of hospital acquired infection.
• Disease wise incidents of hospital acquired infection.
• Top 10 diseases by revenue generation.
• Top 10 rooms by revenue generation.
• Top insurance plans by revenue generation.
• Involved in designing teh star schema, creating a new rpd (repository), ODBC connectivity and related features in OBIEE
• Analyzed and identified Dimension and Fact tables used in those reports.
• Using OBIEE defined and built teh Physical Layer from OLAP tables in OBIEE. Using Logical table mapping, teh physical layer transformed to a Logical Layer and finally transformed to teh Presentation Layer wif business terms and names.
• Using OBIEE, prepared teh Dashboard design and created Reports, Filter, Prompts and all teh information documented in Functional Requirements document wif screenshots for business approval.
• Extensively worked on designing OBIEE Reports involving charts, graphs

Confidential

Application programmer

Responsibilities:

• Involved in L1, L2 support for Oracle Applications.
• Involved in Mailbox, Unix Batch Jobs and Remedy Incident Tool monitoring and trouble shooting.
• Verify batch results in Autosys, log files.
• Record batch results as per standard procedures.
• Create remedy tickets in case of batch failures and assign to incident managers for resolution
• Have gained noledge in teh application
• Year End Activities - special processing such as Calendar updates, etc.
• Monthly manual run of customer statements to be sent out by mail
• Provide data fixes for non incidents (for online and batch)
• Provide clarifications to users on training issues for non issues