SUMMARY

• Over 8 + years of IT experience in analysis, design, development, reporting, documentation and implementation with 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 the source ERP and CC&B systems for the 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 with 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 the 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 with 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 the 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 with admin Server and setup cluster configuration
• Expertise in the ETL Tool Informatica and have 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 with 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 with onsite/offshore project delivery model and experience in working with 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 the business requirements and identify the needs for the requirements. Working with the stake holders in documenting the business purposes
• Installed Informatica 9.1 and OBIEE11g clients
• Worked with 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 the business requirements in data warehouse
• Created drill down reports links, dashboard prompts, formulas, repository variable and session variables
• Some of the Reports created using Smart View
• Created Unit Test cases, involved in code review sessions
• Worked with Informatica in implementing the customize changes & monitored the 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 the business requirements and identify the needs for the requirements. Working with the stake holders in documenting the business purposes
• Installed Informatica 9.1 and OBIEE11g on Linux server and configured the cluster setup in WebLogic server
• Worked with setting up security (AD security& LDAP) in WebLogic server according to the business requirement
• Configured OWB repository, OUBI repository and scheduled ETL batch jobs under OBIEE dashboards
• Worked on integrating and configuring BI Publisher with OBIEE
• Modified case analytics in Utilities Repository and deployed into Enterprise Manager
• Developed custom reports and dashboards based on the 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 with 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 the change management and business modeling in the customer’s business processes and organizations using RTC
• Worked with Informatica in implementing the customize changes & monitored the 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 the 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 the objects, mapping and workflows after the upgrade
• Scheduling the workflow jobs, running and monitoring the 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 the 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 the 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 the 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 the 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 the Physical Layer
• Developed and customized some of the existing Dimensions (Drill-Down Hierarchies) & Logical objects in Business Model Layer, and creating the 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 the data from five Call Centre 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, Sequence generator and Union
• Apply many business validation rules on staging tables and load the data into CMS table
• As per the business requirement, created Email Task to send the system audit results to the respective Call Center E-mail addresses
• Designed OBIEE dashboards as per the 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 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

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 the 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 the mapping, identify the root cause of the bugs, and fix the bugs
• Responsible for daily verification that all scripts were executed as planned, troubleshooting any steps that 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 with Test cases
• TunedInformaticaMappings and Sessions for optimum performance
• Created Email Task to send the 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 the 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 with business users to collect requirements and prepared ETL technical specifications
• Designed ETL processes to load data from Flat files, Oracle and DB2 into the 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 the 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 the 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 the users, projects, permissions to promote objects properly
• Involved in trouble shooting using the debugger and recovered various faults at early time of project development
• Worked with Administrators, DBA's, PM's, Managers, QA team to perform the assigned task
• Used Quality Center to communicate with teams about the 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 the dimensions sources to dimension hierarchy tables. Build the 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 the data warehouse using various transformations
• Documented the Unit Test Cases & Integration Testing Steps and captured the results
• Prepared release notes for migrating the 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:

• The work involves understanding the business process that are to be followed and then coming up with the high level design for the implementation of the 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 the 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 the data placed into the warehouse
• Coordination and communication with 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:

• The work involved understanding of the business process that are to be followed and then coming up with the technical solutions for the implementation of the same
• Involved in analysis, design of BO reports and worked on scheduling reports on BCA (Broad Cast Agent) server
• Involved in writing the PL/SQL stored procedures for the ETL (Extraction, Transformation and Loading) process and tuned some of the 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 the 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