SUMMARY:

• 8+ years of expert level experience in Business Requirements Gathering & Analysis, Development, Implementation of dashboards, scorecards, analytical reporting and OBIEE meta data modeling for OBIA Sales Analytics and customer loyalty analytics for high technology vertical market. I have extensive knowledge of OBIEE financial analytics, customer loyalty analytics, including needs assessment, business process flows, Analytics repository management and administration and the development of custom modules for the Warehouse using Oracle Business Intelligence Enterprise Edition, Siebel Analytics, Informatica and DAC.
• 6+ years of Dimensional Data Modeling experience using Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling using OBIEE.
• 5+ years experience in business process re - engineering, requirements gathering and translation of business requirements into technology solutions.
• 6+ years experience in Dashboard and Scorecard development, customization and detailing Metrics, KPI and critical to quality metrics.
• More than 5 years of experience with OBIEE, OBI applications and PL/SQL programming.. I nstalling DAC, configuring, administering and managing the repository, creating complex reports and role based Analytics Intelligence Dashboards using OBIEE, OBIA/Informatica Mappings
• 6+ years of experience using Oracle, MS SQL Server 2000, PL/SQL, SQL Anywhere, Windows 95/98/2000 XP, Win NT 4.0 and UNIX Sun Solaris 2.x.
• Enthusiastic team player, with excellent communication and interpersonal skills. Can take up individual responsibilities and detailed in the analysis and process optimization.

TECHNICAL SKILLS:

Operating Systems: Windows OS, UNIX OS and Red Hat Linux.

Virtual Machines: VMware Server and Workstations

Programming Languages: C programming, Java Script, HTML, Unix Shell Programming, PL/SQL

Databases: Oracle 10G/11G, Microsoft SQL Server 8.0

Tools: Adobe Photoshop, Quest Toad, SQL Developer & SQLPLUS, OBIEE Admin Tool, Oracle Answers, Oracle Delivers

Data Integration Tools: Informatica PowerCenter 8.1.1, SP4 and Oracle DAC

Data Warehouse: Oracle 10G/11G data warehouse for Oracle Apps, Siebel CRM DW

Oracle Fusion Middleware: Oracle OAAM 10.1.3.4, OAAM, OAM, Oracle Identity Manager, Oracle WebCenter 11gR1, WebLogic 10.1.3, Jdeveloper, SOA, BAM, BEPL

Business Intelligence: Oracle OBIEE10g OBIEE 11g, OBI Applications 7.9.6, custom Customer Loyalty Analytics, Sales Analytics for OBIEE 10g, OBIEE 11g platform

PROFESSIONAL EXPERIENCE:

Confidential,Cupertino,CA

Siebel Analytics Developer

Responsibilities:

• Report development for Oracle HCM cloud using BIPublisher for Macys Human Resources.
• Designed and developed complex data models using SQL spanning payroll tables.
• Rewrote complex payroll reports existing ( PeopleSoft HCM) in Oracle HCM cloud .
• Created reports in BI publisher using OTBI as source as well

Confidential,Ca

Siebel Analytics Developer

Responsibilities:

• Hands-on with OBIEE/OBIA full lifecycle
• QA testing the reports
• Validation of headcount metrics
• Validation Organizational hierarchy
• Experience in modeling aggregate tables to speed processing and building calculated measures for the fact tables.
• Experience in troubleshooting SQL queries and improve data delivery performance.
• Experience in building, configuring and managing repository, creating and managing Oracle
• Capable of designing/creating, Subject Area in Analytics Repository (RPD) based on the Business requirements.
• Created EDW test Cases, Dashboard and Report test cases
• Disease category report data validation
• Experience in creating patients survey, patients health net usage reports
• Experience in testing the data validation from source to EDW and EDW to reports Includes but not limited to testing of a) No of records compare between source, EDW Stage and EDW Target b) Data compare between Target data and source data c) Incremental data count. d) checking dimensional Data warehouse keys not null e) Fact Tables data warehouse foreign keys with dimension table primary keys joins f) check the validity of any logic used to build fact value

Confidential

Siebel Analytics Developer

• Hands-on with OBIEE full lifecycle and OBIA Sales Analytics / Informatica development.
• Experience in Migration of objects across Local (DEV), Test (QA) and Central Locations (PROD).
• Experience in Cache management and Performance tuning in OBIEE and Informatica
• Experience in Analysis and collecting business requirements from Business Analysts and users.
• Experience in modeling aggregate tables to speed processing and building calculated measures for the fact tables.
• Experience in troubleshooting SQL queries and improve data delivery performance.
• Experience in building, configuring and managing repository, creating and managing Oracle/ Siebel Intelligent Dashboards, Oracle/S iebel Answers.
• Capable of designing/creating, Subject Area in Analytics Repository (RPD) based on the Business requirements.
• Hands on experience in developing Oracle Business Intelligence and Siebel Analytics Repository consisting of three layers (viz. Physical Layer Business Model & Mapping Layer and Presentation Layer).
• Experience with repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports). Added Metadata changes to the OBI/Siebel Analytics .rpd.
• Experience in designing Star Schema/Snowflake Schema methodologies using OBIEE Administration tool.
• Expertise in using Database tools like TOAD
• Developed many complex mappings and mapplets using various transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data into Data Warehouse.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying complex mappings.
• Responsible for monitoring sessions that are running, scheduled, completed and failed using Informatica Power Center 7.1.5

Confidential,Santa Clara,CA

OBIEE Developer

• Performed Data Warehouse analysis and identified the required Facts, Dimensions, Hierarchies of dimension joins for the Loyalty Analytics
• Built a generic Customer Loyalty Data Model
• Built dashboard for the partner relationship management analytics such as
• Partner demographic
• Partner performance
• Partner certification
• Configured Web Catalog Objects (Dashboards, Pages, Folders, and Reports).
• Implemented column selector to select different column values.
• Designed and developed Reports/Dashboards with different Analytics Views using Oracle Business Intelligence Presentation Services.
• Created guided navigation links to help files within the dashboards to help the end users.
• Dashboard development including top 10, trend analysis, variation analysis, customer demographics, historical performance management and comparative analysis.

Confidential,Santa Clara,CA

OBIEE Developer

• Functional Analyst for Contract Price Auditing and Sales Reporting.
• Organized and lead meetings with business representatives for BRD for Reports/Dashboards.
• Designed and presented information flow through dashboards as well as User Interface customizations.
• Led workshop sessions with Business Power Users on the complex formulas whose definition ran over 5 pages.
• This led to breaking down the complexity of the formulas into process flow diagrams and identified bugs in formula calculations.
• Led design meetings with IT in moving the complex calculations from the reports to ETL.
• Designed and developed ETL data mapping documents and workflows in excel and Visio.
• Designed and developed Contract Price Audit data model in the semantic layer and optimized report generation.
• Designed and developed Contract Price Audit reports in Oracle Discoverer and also embedded MS Excel macros into the reports for dynamic calculations from OBIEE into Excel based on the user inputs.
• Performed Data Warehouse analysis and identified the required Facts. Dimensions, Levels / Hierarchies of Dimensional and referential joins for Contract Price Audit report.
• Designed and developed the OBIEE/ Metadata Repository (.rpd) using OBIEE Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.