SUMMARY

• Over 12+ years of IT experience OBIEE, Siebel Analytics, Data Warehousing technologies, demonstrating prolific level of achievement in RPD development, OBIEE Dashboards & Reports development, data warehouse design, maintenance, data loading, Real time and OLAP reporting
• Expertise in Data Modeling design, analyze and implement - conceptual, logical and physical data model, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence.
• Worked Extensively on Oracle BI Administration Tool, Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Expertise in setting up Development, Test and Production environments for DWH requirements for the business needs and customize existing schemas as well develop new Subject Areas to suit business needs.
• Experience in design and development of drill down reports and dashboards for trend analysis
• Expertise in OBIEE Web Catalog Administration
• Expertise in design and development of Ad-hoc Reports & Dashboards using OBIEE suite
• Experience in demonstrating POC’s for business proposals at customer locations directly
• Excellent skills in OLAP/BI Tools
• Excellent understanding of Star Schema/Snow flake Schema methodologies and Dimensional Modeling.
• Experienced in Global Delivery Model (Onsite/Offshore). Coordinated activities onsite & offshore towards meeting project timelines.
• Expertise in ETL using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
• Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
• Expertise in Oracle DAC installation and configuration, Tasks creation, synchronization, and execution (data warehouse load).
• Experience in creating entity relational & dimensional relational data models
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository
• Strong aptitude for learning and understanding business process and needs.

TECHNICAL SKILLS

OLAP/Reporting Tools

: OBIEE 11g/ 10.1.3.4.1 , Siebel Analytics 7.8

Operating System: Windows 2K /NT, XP, Windows 7, UNIX and Linux.

ETL Tools: Informatica 9.5.1/8.6.1/7.1.4 , ODI 11g

Languages: Shell scripting.

Databases: SQL Server 2005/2008, Sybase, Oracle 9i, Oracle 10g/11g.

DW Utilities: TOAD, Oracle SQL Developer.

CRM-Apps: Siebel eBusiness Application

Tools: / Packages: PL/SQL Developer

PROFESSIONAL EXPERIENCE

OBIEE Architect

Confidential, Irvine, California

Responsibilities:

• Business requirements development on interactions with client SME’s and document the requirements
• Deriving estimations for development effort for each phase of the deployment of OBIEE Dashboards/reports.
• Preparation of Agile approach and detailed task identification, resource estimation, coordination to prepare project plan
• Design Data model for customization of existing RPD
• Design and development of Business model and mapping for the Business rules
• Responsible for performing the fit Gap Analysis for the 360 degree view and understanding
• Design ETL Load strategy and process to populate Dimensions and Facts. Design strategies for CDC and SCD’s
• Worked extensively with Physical Layer, Business Layer and Presentation Layer
• Design and developed Marketing Analytics module from Oracle BI Apps and integrated with Siebel CRM Open UI
• Developed Target levels like Confidential Customer Target Level, Confidential Vehicle Target level to do segmentation
• Developed complex segment tree and associate it to Siebel campaign with different allocation & treatment
• Developed new Campaign Load format and List output format
• Extensively worked on Marketing Cache management
• Design and development of OBIEE Dashboards, Answers and catalog Administration
• Design and develop ad-hoc reports on Vehicles match Back, Hand raiser Quote request, Sales Dashboard.
• Develop complex reports on Weekly, Monthly Hand Raiser Match back
• Design and setup Data level security for the country specific users Confidential USA and Confidential Canada based on users login
• Created different types of Customized Reports on campaign management effectiveness, response management and sales match back with Drilldown, Aggregation to meet client requirements.
• Managed security privileges for each subject area and dashboards according to user requirements
• Setting up LDAP authentication to enable Single Sign on for Users in Development environment leveraging Analytics Repository.
• Work with DBA and technical team to identify and resolve performance bottlenecks and provide appropriate solution
• Lead and Coordinating with offshore team from onsite for project execution and delivery responsibility

Environment: OBIEE 11g, ODI 11g, Oracle 11g, Epiphany, Linux Red Hat

OBIEE Architect

Confidential, St. Louis

Responsibilities:

• Responsible for Solution designing for reporting requirements for Confidential Europe Affluent project
• Preparation of tollgate approach and detailed task identification, resource estimation, coordination to prepare project plan.
• Responsible for Environment set up for OBIEE Infrastructure.
• Design Data model for customization of existing RPD development Physical, BMM & Presentation
• Design and development of OBIEE Dashboards, Answers and catalog Administration
• Design and develop ad-hoc reports to display DNIS, Country and other Europe Affluent measures.
• Develop complex reports on One time charges, Work orders, commissions, Site level
• Design and setup Data level security for the super users at the enterprise level and market level
• Design reports with Positional hierarchies for Sales module across Market
• Lead and Coordinating with offshore team from onsite for project execution and delivery responsibility

Environment: OBIEE 10g and 11g, Informatica, Oracle 11g / Exadata, Linux Red Hat

OBIEE Lead/architect

Confidential, Milwaukee

Responsibilities:

• Responsible for performing the fit Gap Analysis for the 360 degree view and understanding
• Responsible for requirements gathering and development estimation for each phase of the OBIEE reports
• Responsible for Environment set up OBIEE Servers
• Design Data model for custom Repository development
• Design and development of Business model and mapping
• Design and development of OBIEE Dashboards, Answers
• Design and develop ad-hoc reports on Customer service activities and Sales target
• Design and develop reports for Top10, KPI and trend analysis
• Develop complex reports on Target Efficiency and set up Dimensional hierarchies in reports
• Design reports with Positional hierarchies for Sales, Marketing and Customer service modules
• Design and develop real time reports using BI Publisher
• Develop in line record view with action links and develop reports with guided navigation links
• Design and develop custom and customization of ETL mappings and workflows
• Responsible for setting up DAC execution plans and Administration
• Developed on new requirements for DSC Email project to extract activity data and load into Analytics
• Developed Oracle BI Answers Requests, Oracle BI Interactive Dashboard Pages and Prompts, and Oracle Delivers iBots
• Developed the project plan for the implementation that identified the schedule, tasks, milestones and requirements
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the Siebel Analytics Repository
• Immensely worked on improving the performance issues, complex reporting requirement for Confidential and also documented the different performance improvement measures implemented at Confidential
• Responsible for Siebel repository & non-repository data migration and identify the root cause if any issues happens
• Responsible for OBIEE migration activities such as RPD, Business Catalog and managing all OBIEE related services
• Involved in post-migration activities for non-repository data like web services, work flow activations, System preferences, EAI data value maps, LOV's using ADM
• Created batch scripts for auto compile SRF & export of DAT file
• Created a batch script to trigger DAC schedule task
• Monitoring Auto-sys jobs

Senior OBIEE Consultant

Confidential, Milwaukee

Responsibilities:

• Designed and developed the Siebel Analytics Metadata Repository (.rpd) using Siebel Analytics Server 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 catalog in Presentation Layer
• Iterative development of dashboards, Answers requests, charts, pivot table layouts, dashboard prompts
• Collaborated with end-users and stakeholders to bring form and clarity to a multitude of data sources which enabled data to be displayed in a meaningful analytic way
• Some of the reports which was built for Confidential health - LEGS System were Agent effectiveness, Activity performance, Lead enhancement etc.
• Created Oracle BI Answers Requests, Oracle BI Interactive Dashboard Pages and Prompts, and Oracle Delivers iBots
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
• Developed the project plan for the implementation that identified the schedule, tasks, milestones and requirements
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the Siebel Analytics Repository
• Immensely worked on improving the performance issues, complex reporting requirement for Confidential and also documented the different performance improvement measures implemented at Confidential
• Responsible for repository & non-repository data migration and identify the root cause if any issues happens
• Involved in post-migration activities for non-repository data like web services, work flow activations, System preferences, EAI data value maps, LOV's using ADM
• Monitoring daily DAC status and Informatica session log files
• Mentored fresh resource by providing technical support and guidance in critical thinking

Senior OBIEE Consultant

Confidential, Santa Clara, California

Responsibilities:

• Participated in requirements gathering sessions with the client and finalizing the scope,
• Understanding the scope of business and existing application and converting into functional design
• Preparation of Functional Design documents involves data mapping of different subject areas (Activities, Customer, Campaign, Opportunities, Products and Marketing Events)
• Developed the schema structure per the business requirements
• Managed teams of 4 - 6 consultants
• Built the Business model (ERD) to in corporate in the functional design

Senior Consultant

Confidential

Responsibilities:

• Preparation of detail design document involves data mapping of different entities (Accounts, Contact, Opportunities, Products and Order)
• Installed and maintained Siebel Servers Gateway, Siebel, Enterprises & Database server
• Designed Siebel Analytics Repository
• Developed the schema structure per the business requirements
• Designed and developed the Siebel Analytics Metadata Repository (.rpd) using Siebel Analytics Server Admin tool by importing the required objects (Dimensions and Facts)

Consultant

Confidential

Responsibilities:

• Integrating Siebel Analytics 7.7.1 with Siebel eConsumer Goods Applications
• Developed the logical model in Siebel Analytics repository
• Involved in Siebel Analytics front end design / Presentation layer using Siebel Admin tools
• Configured dashboards
• Worked on Informatica to run the Batch process which will sync the data with OLTP & OLAP
• Involved in Gap analysis which is done between the existing data warehouse and the Siebel provided
• Modified the existing business model for Events, Accounts & Services Request
• Handled Development, SIT & UAT environment

Consultant

Confidential

Responsibilities:

• Participated in requirements gathering sessions with the client Installed and setup
• Successfully setup three environments with IIS, SAW & SAS each on a different box
• Lead a team of 4 developers at offshore in development effort towards Siebel Analytics
• Designed the architecture of the application
• Installed and setup Multi user check in/Check out Siebel Analytics Server for development and testing environment
• Install & configured Email Marketing Server, Email Sending Daemon, Bounce Handler Daemon, Click-through Daemon
• Configured Dashboard as a Siebel view using Inline methods
• Configured Siebel Analytics report within a Siebel applet using IFrame methods
• Integrating Siebel Analytics 7.7.1 with Siebel ePharma Applications 7.7.2.3
• Creating Target Lists Using Siebel Analytics
• Configured Marketing Meta Data design for Segment List format & Create Target List.
• Involved in configuring Campaign List and integrating Segment/List & Offer for sending mail to the professionals.
• Participated in Gap analysis between the existing reporting tool and Siebel Analytics

Consultant

Confidential

Responsibilities:

• Designed & Configured Business Object, Business Components and Applets in Siebel Tools as per the requirements
• Installed and maintained Siebel servers and eReport server in all environments (DEV, INT, SIT, Testing & PRD)
• Done customization at field levels for report requirements.
• Prepared a detailed design of Actuate Reports & Configuration
• Designed & configured parameter applets at Siebel tools for actuate reports.
• Wrote Siebel Visual Basic Scripting for the Customization of Siebel application at Business object & Applets