SUMMARY

• Over 8 + years of IT experience in analysis, design, development, reporting, documentation and implementation wif Databases, Data Warehouse, Oracle, SQL, PL/SQL, Linux, Oracle Business Intelligence Applications (OBIA), BI Publisher, Informatica, DAC, Oracle Utilities Business Intelligence (OUBI) and OBIEE
• Accomplished proven Data Warehouse/Business Intelligence professional utilizing several years of experience in using Oracle Applications as teh source ERP and CC&B systems for teh OBIEE Financial, Projects, Supply Chain, Human Resource, Procurement & Spend, and Utilities Customer Care & Billing Analytics
• Extensive experience on OBIEE/Siebel Analytics/OBIA/OUBI Repository (Physical Layer, Business Model & Mapping Layer and Presentation layer), Informatica Repository, DAC Repository, OWB Repository customizations and Web Catalog to provide high level end to end reporting solutions
• Strong data modeling experience in Star schema, Snowflake schema design, Fact, Dimensions tables, Physical and Logical data modeling using Erwin wif Ralph Kimball's dimensional modeling techniques and Bill Inman's 3NF modeling techniques
• Experience in understanding transactional data modeling (OLTP) and working in OLAP data model design
• Excellent experience on Data Profiling, Data Quality, Data Cleansing and creating teh Master Data Model
• Experience in BI Publisher data models, RTF design templates and scheduling reports using OLTP and OLAP data
• Proficient in creating dashboards, analytical reports, adding filters, conditions, creating prompts, drill down reports, column selector, variables, graphs and creating pivot tables using OBIEE
• Excellent experience in working wif large Market Data Feeds and Heterogeneous Source Systems like Oracle, SQL Server, DB2, XML files, and Flat Files
• Experience in customizing and deploying RPD and Web Catalog in OBIEE10g/11g and deploying BI Publisher XDOZ, XDMZ files and RTF templates
• Experience in seeding and cache functionality to improve teh report performance
• Excellent OBIEE Administration skills like installing & configuring OBIEE11g, creating BI users using WebLogic, administering users, privileges, deployment, starting & stopping server, SSL configuration resolving issues wif admin Server and setup cluster configuration
• Expertise in teh ETL Tool Informatica and has extensive experience in Power Center Client tools including Designer, Repository Manager, Workflow Manager/ Workflow Monitor
• Excellent Informatica Administration skills like installing & configuring Informatica PowerCenter, Repository Management, administering users, privileges, deployment, starting & stopping server, resolving issues wif Informatica Power Center Server
• Solid experience in troubleshooting, error handling, job control & job auditing using Informatica, DAC and OBIEE
• Hands on experience in upgrade from OBIEE 10g/11g, OBIA 7.9.6.2/7.9.6.4 , DAC 10g/11g and Informatica 8.6/9.1
• Extensive experience in Performance tuning, identifying bottlenecks and resolving to improve performance at Database, reporting and ETL level - Creation of Materialized views, Aggregate tables
• Experienced in mapping techniques for Type 1, Type 2 and Type 3 Slowly Changing Dimensions
• Strong experience in SQL, PL/SQL, Procedures, Functions, Packages, Triggers, Cursors, and Indexes in Oracle
• Extensive experience in customizing subject areas and scheduling jobs in DAC.
• Sound knowledge of Linux/Unix, Shell scripting
• Well versed wif onsite/offshore project delivery model and experience in working wif offshore teams
• Highly motivated, Reliable, Responsible, Good team player

TECHNICAL SKILLS:

BI: OBIEE 11g/10g, OBIA 7.9.6.4/7.9.6.2 , OUBI 2.4.1, BI Publisher 11g/10g, DAC 11g/10g, and Business Objects

ETL: InformaticaPowerCenter9.1/8.x/7.x / Power Exchange / Power Connect/IDQ and OWB

Databases: Oracle 11g/10g/9i, SQL Server 2008/2005/2000 , DB2, Teradata

Languages: SQL, PL/SQL, T-SQL, XML, HTML, DHTML, Java, Linux/Unix, Shell Script, C, C++, Cobol, JavaScript, BTEQ

Tools: /ERP Oracle E-Business Suite 11g, Oracle CC&B, SQL*Loader, Eclipse, TOAD, PVCS, HP Kintana, HP Quality Center, CVS, UML, Selenium, Subversion, SQL Developer, Dollar Universe, Autosys, Rational Team Concert (RTC), MS Visio, Erwin

O/S: Oracle Linux 6.4, Red Hat Linux 5.5, HP-UX, SCO/UNIX, SUN/SOLARIS, MS Windows

PROFESSIONAL EXPERIENCE:

Confidential, Michelson, CA

Senior OBIEE/ETL Programmer Analyst

Responsibilities:

• Understanding teh business requirements and identify teh needs for teh requirements. Working wif teh stake holders in documenting teh business purposes
• Installed Informatica 9.1 and OBIEE11g clients
• Worked wif HCA Treasury custom analytics
• Created custom Informatica mappings using Power center designer and Workflow manager
• Configured OBIA repository and scheduled ETL jobs using DAC11g
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool
• Created time dimension hierarchy and calculated measures using Ago, case functions
• Modified RPD and deployed into Enterprise Manager
• Developed custom reports and dashboards based on teh business requirements in data warehouse
• Created drill down reports links, dashboard prompts, formulas, repository variable and session variables
• Some of teh Reports created using Smart View
• Created Unit Test cases, involved in code review sessions
• Worked wif Informatica in implementing teh customize changes & monitored teh DAC loads on daily bases

Environment: OBIEE11g, OBIA 7.9.6.4,, DAC 11g, Informatica Power Center 9.1.0, Repository Manager, Designer, Workflow Manager, Oracle 11g, Oracle EBS R12, Windows 7, Toad and Smart View 11.1.2.5.

Confidential, Irvine, CA

Sr. OBIEE/OBIA Support Analyst

Responsibilities:

• Understanding teh business requirements and identify teh needs for teh requirements. Working wif teh stake holders in documenting teh business purposes
• Installed Informatica 9.1 and OBIEE11g on Linux server and configured teh cluster setup in WebLogic server
• Worked wif setting up security (AD security& LDAP) in WebLogic server according to teh business requirement
• Configured OWB repository, OUBI repository and scheduled ETL batch jobs under OBIEE dashboards
• Worked on integrating and configuring BI Publisher wif OBIEE
• Modified case analytics in Utilities Repository and deployed into Enterprise Manager
• Developed custom reports and dashboards based on teh business requirements for CC&B data warehouse
• Created BI Publisher Reports, templates and data models
• Created data models, RTF Templates, and migrated reports from DEV to TEST and TEST to PROD environments and scheduled BI Publisher reports
• Created Unit Test cases, involved in code review sessions
• Extensively workedOBIAApps (7.9.6.4) which involves Informatica, OBIEE and DAC
• Worked wif Financials apps (GL, Payables, and Receivables), Procurement & Spend and Project analytics
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool
• Created custom formulas, filters, drill downs, prompts, new calculated items and pivot tables
• Coordinating teh change management and business modeling in teh customer’s business processes and organizations using RTC
• Worked wif Informatica in implementing teh customize changes & monitored teh DAC loads on daily bases
• Created mappings using different transformations like Source Qualifier, Filter, Router, Aggregator, Lookup, Expression, Sequence Generator and Update Strategy to store teh data in target table

Environment: OBIEE11g, OUBI 2.4, OBIA 7.9.6.4, OWB 11g, DAC 11g, BI Publisher 11g, Informatica Power Center 9.1.0, Repository Manager, Designer, Workflow Manager, Oracle 11g, Oracle EBS R12, Oracle CC&B, Windows 7,RTC, Toad, Q-TEST, Oracle Linux 6.4 and Service Desk.

Responsibilities:

• Prepared installation documentation for OBIEE and Informatica
• Installed and upgraded OBIEE 11g, OBIA 7.9.6.4, DAC11g and Informatica 9.1.0 in DEV/QA and PROD
• Verified all teh objects, mapping and workflows after teh upgrade
• Scheduling teh workflow jobs, running and monitoring teh jobs through DAC
• Used RTC Software to move scripts fromDev to Stage and to PROD
• Involved in RPD Development, Oracle BI Server, Oracle BI Answers, DAC Configuration and ETL Configuration
• Designed Star schema for fact & dimensional tables and created alias for teh dimensional tables when necessary
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Server Administration Tool
• Specified Dimensional hierarchy, Aggregate levels for teh dimensions and involved in Configuration of Web Catalog Security and Cache Management
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers and Analytics
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in teh reports
• Customized OBIEE repository by adding custom columns and tables using BI administration tool for Project Analytics tables like W PROJECT D, WC PROJECT BUDGET F, W TASK D tables in Analytics (Oracle EBS)
• Involved in customizing Accounts Payables and Oracle GL Subject Areas and corresponding dashboards
• Informatica Power center is used to load teh Oracle EBS data into OBAW using Source Dependent Extracts (SDEs) & Source Independent Loads (SILOs), PLP and Custom Folders
• Identified Data warehouse and staging tables, Informatica workflows/mappings and DAC tasks related to Project and Finance data and customized Informatica mappings to load historical data
• Took back-up of DAC, BI & Informatica repositories and BI Web catalogs
• To create RPD, Connection pools, import physical tables and define joins in teh Physical Layer
• Developed and customized some of teh existing Dimensions (Drill-Down Hierarchies) & Logical objects in Business Model Layer, and creating teh Presentation catalogs in Presentation Layer

Environment: OBIEE 11.1.1.7.0/10 g, OBIA 7.9.6.4/7.9.6.2 , DAC 11g/10g, Informatica Power Center 9.1.0/8.6.1 , Repository Manager, Designer, Work Flow Manager, Oracle 11g, Oracle EBS R12, Windows XP, CSV files, RTC, Toad and Red Hat Linux 5.5.

Confidential, San Jose, CA

Sr. Informatica/ETL Developer

Responsibilities:

• Involved in analysis and requirements gathering sessions
• Created Technical Design documents based on Functional Specification.
• Created mappings to extract teh data from five Call Centre source files and load teh data into staging tables
• Created various mappings to implement teh business logic using different transformations like Lookup, Router, Expression, Update Strategy, Filter, Sequence generator and Union
• Apply many business validation rules on staging tables and load teh data into CMS table
• As per teh business requirement, created Email Task to send teh system audit results to teh respective Call Center E-mail addresses
• Designed OBIEE dashboards as per teh business requirements
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool
• Created custom formulas, filters, drill downs, prompts, new calculated items and pivot tables
• Create Unit Test cases, involved in code review sessions, fixed bugs while testing was going on
• Used SQL queries during unit testing to validate teh data
• Involved in fine tuning teh mappings to get teh faster output
• Scheduling teh workflow jobs, running and monitoring teh jobs through Dollar U scheduler
• Used Kintana Software to move $U scripts fromDev to Stage and to PROD

Environment: Informatica PowerCenter 9.1, Repository Manager, Designer, Work Flow Manager, Oracle 11g, Windows XP, CSV files, OBIEE 11g, Dollar Universe, Toad, HP Quality Center and Linux

Responsibilities:

• Developed Technical Design Document and Mapping Documents
• Created mapping for extraction of teh Partners information from PDB to PMC tables using Informatica ETL Tools
• ImplementedSlowly Changing Dimension (SCD) Type2 mapping for Incremental Load
• Implemented business logic using different transformations like Lookup, Router, Expression, Update Strategy, Filter, Sequence generator, Joiners
• Created Database Triggers to maintain AUDIT information
• Used debugger to test teh mapping, identify teh root cause of teh bugs, and fix teh bugs
• Responsible for daily verification dat all scripts were executed as planned, troubleshooting any steps dat failed, and providing both immediate and long-term problem resolution
• Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts
• Adding requirements into Quality Centre, Mapping Requirements wif Test cases
• TunedInformaticaMappings and Sessions for optimum performance
• Created Email Task to send teh Successes or Failure post-session messages
• Created and configured Physical Layer, Business Model and Mapping Layer and Presentation Layer using Siebel Analytics Administration Tool
• Configured Complex Logical Dimensions in teh Business Model and Mapping Layer
• Developed Answers, Filters, Customized Reports and Dashboards using Siebel Analytics Web
• Designed Integrative dashboards/Reports to help support Multi Org data and Multi Org Users

Environment: Informatica PowerCenter 9.1, Repository Manager, Designer, Work Flow Manager, Oracle 11g, OBIEE 10.1.3.4, Windows XP, SQL/PLSQL, Erwin, Autosys, Toad, HP Quality Center, Linux

Confidential

Responsibilities:

• Worked wif business users to collect requirements and prepared ETL technical specifications
• Designed ETL processes to load data from Flat files, Oracle and DB2 into teh target Oracle database by applying business logic
• Developed complex mappings, Mapplets and reusable transformations using transformations like joiner, lookup, aggregator, router, filter, sequence generator, stored procedure transformation and expression to load teh data to staging, Data warehouse and Data marts
• Performance tuned various mappings, Sources, Targets and transformations by optimizing caches for lookup, joiner, rank, aggregator, sorter transformation and tuned performance of Informatica session for data files by increasing buffer block size, data cache size, sequence buffer length and used optimized target based commit interval and Pipeline partitioning to speed up mapping execution time
• Involved in writing teh PL/SQL procedures and PL/SQL program units for data extraction, transformation and loading
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2)
• Involved in Migration of Informatica, Oracle, Scripts from Dev to QA, Preproduction and Prod Environment according to Change Management task process approved
• Managed Version Control process by setting up teh users, projects, permissions to promote objects properly
• Involved in trouble shooting using teh debugger and recovered various faults at early time of project development
• Worked wif Administrators, DBA's, PM's, Managers, QA team to perform teh assigned task
• Used Quality Center to communicate wif teams about teh defects, enhancements, new tasks etc.

Environment: Informatica Power Center 8.6, Power Connect for DB2, Power Exchange, Oracle 9i, DB2, TOAD, Quality Center

Confidential ., Sunnyvale, CA

ETL & PL/SQL Developer

Responsibilities:

• Created Source to Target Mappings for staging & ODS layer
• Mapped teh dimensions sources to dimension hierarchy tables. Build teh self-referencing lookup transformations to convert serial dimension attributes to fit into hierarchical structure
• Implemented ETL mappings for loading Type-2 Slowly changing Dimensions
• Coded Mappings & Mapplets, Reusable transformations to implement transformation logic for applying various business rules and data standardization rules for source data coming from multiple systems into teh data warehouse using various transformations
• Documented teh Unit Test Cases & Integration Testing Steps and captured teh results
• Prepared release notes for migrating teh objects from DEV to TEST and to Production

Environment: Informatica 7.1.3, Oracle 9i, HP-UNIX, TOAD, Quality Center, Oracle E-Business Suite

Confidential, Dallas, TX

ETL & PL/SQL Developer

Responsibilities:

• Teh work involves understanding teh business process dat are to be followed and then coming up wif teh high level design for teh implementation of teh same
• Involved in requirement gathering and design of Informatica mappings
• Used Informatica Mappings like Lookups, Joiner, Normalizer, Sequence Generator, and Mapplets, connected and unconnected stored procedures were extensively done
• Used SQL overrides at Source Qualifier and Lookup Transformations while extracting data from multiple tables
• Used Task developer in teh Workflow manager to define sessions
• Created and Monitored Batches and Sessions using Informatica Power Center Server
• Load verification analysis and design. Identified techniques to verify successful completion of ETL processing, and to validate teh data placed into teh warehouse
• Coordination and communication wif key internal technology teams (i.e. database services, network services, hardware support, etc.)
• Implemented data cleansing techniques
• Extensively worked in data Extraction, Transformation and Loading from source to target system using Power Center of Informatica

Environment: Informatica, Business Objects 6.1.a Full Client, Designer, Supervisor, Web Intelligence, ORACLE 8i, and AIX

Confidential

Responsibilities:

• Teh work involved understanding of teh business process dat are to be followed and then coming up wif teh technical solutions for teh implementation of teh same
• Involved in analysis, design of BO reports and worked on scheduling reports on BCA (Broad Cast Agent) server
• Involved in writing teh PL/SQL stored procedures for teh ETL (Extraction, Transformation and Loading) process and tuned some of teh existing procedures
• Responsible for maintenance of Unix jobs scheduled to accomplish ETL process using ESP (Enterprise System Platforms)
• Undergone several quality related trainings to improve teh level of work, for example, training on Defect Prevention, Configuration Management etc.

Environment: ORACLE 8i, Business Objects 5.1.2, UNIX, ESP Scripts, PL/SQL, SQL*Loader