Professional Summary

Home Favorites My Photos Blog Guest Book

PROFESSIONAL SUMMARY
  • Certified in 1Z0-525 Oracle Business Intelligence Applications 7 for ERP Essentials.
  • Certified in 1Z0-591 Oracle Business intelligence Foundation Suite 11g Essentials
  • Experienced IT professional with 10+ years of experience involving in Project Bidding, Project Estimates, Resource Contour, Client Orals, requirement gathering ,design, configuration, development, testing and implementation of Data warehousing, Business Intelligence Applications (OBIEE 11g/10g)
  • Experience in Financial, Procurement Supply Chain, Manufacturing modules and Utility Analytics of Oracle Business Intelligence applications
  • Data warehousing development using ETL tool, Informatica Power Center 8.x/7.x and developed Informatica Mappings/Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and Creating Workflows & Tasks, and Scheduling using Workflow Manager.
  •  Experience configuring Oracle Data Warehouse Administration Console (DAC) and Creating Task, Task groups, Subject Areas ,Execution Plans and running the complete Informatica Workforce sessions Using DAC. Monitoring ETL full and incremental loads.
  • Designed and developed the OBIEE Analytics Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
  • Worked on customizing OBIEE dashboards and reports / Dashboards with different analytic views (Drill-Down/Dynamic, Pivot Table, Chart, Column selector, Tabular with local and global filters) using OBIEE
  • Worked closely with Users, Team members and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository
  • Technically proficient in Design and Development of RICE (Reports, Interfaces, Conversion, Enhancements) methodologies using Oracle EBS  R12/11
  • Strong Programming experience in developing SQL, PL/SQL packages, stored procedures, Triggers, Interfaces and SQL*Loader.
  • Data warehousing deployment using ELT tool, Oracle Data Integrator (ODI) which is part of OBIA 11.1.1.7.1

Industry Experience     :   Pharmaceutical, Financial Institution ,Software Services Consulting .

Technology Expertise  :   Business Intelligence OBIEE 7.0/7.5/7.7/7.8, 10.3.x, OBIEE11g (formerly Siebel Analytics),BI Publisher, OBIA 11.1.1.7., 7.9.6.4. Hyperion Essbase

Databases                    :   Oracle RDBMS 10g/9i/8i Oracle (SQL, PL/SQL, Stored Procedures, Triggers)MS SQLServer, Essbase

Operating Systems      :   UNIX (Sun Solaris, HP Unix, LINUX) WIN 2000/XP

ETL Tools                     :   Informatica- Power Center 8.x/7.x, 6.2/5.1, ODI, Talend

Scheduling Tools         :   Control-M

CDC                                      :    Attunity, Oracle Goldengate

Other                            :  Siebel CRM 7.7Hyperion Essbase 9xMS SQL Server 2005 SSASToad 6.3/7.6SQL, PL/SQLUnix shell scriptsHTML, DHTMLXML

Clients:

Credit Suisse