SUMMARY

• A thought leader and thorough professional having 10 years of experience in Consulting, Architecting, Solution Designing, Implementation, Re - Engineering of Data Warehouse, Business Intelligence applications for Enterprises using various BI Tools like Siebel Analytics and Oracle Business Intelligence (OBIEE11g/10g). Worked in Financial, Supply Chain and Pharma domains
• 10 years of experience in OBIEE and Data warehousing
• Worked as an IT Project Manager at client location in USA
• Proficient in requirements gathering, analysis & design - played the role of Business Analyst / Project Lead on client assignments in US
• Experienced in Global Delivery Model (Onsite/Offshore). Coordinated activities onsite & offshore towards meeting project timeline
• Handled multiple roles and responsibilities - BI Architect, Technical Consultant, Technology Lead and Solution Architect for large BI / DW applications.
• Strong in project scoping, estimation and planning.
• A keen strategist, with excellent communication, negotiation and presentation skills, effective in developing and leveraging relationship to achieve business objectives proactively
• Experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuringmetadata, Answers, Deliverscreating reports / Dashboards, cache monitor, security implementation and buildingOBIEE/Siebel Analytics Repository.
• Strong hands on experience in OBIEE RPD Modeling, Security Implementation, Performance Management, Dashboards / Answers development, Publisher, Delivers, iBots using OBIEE
• Strong experience in Customizing the vanilla RPD for Oracle/Siebel CRM ( CRM Sales, CRM Service, supply chain Analytics) and Oracle Financials for GL, AP and AR Subject Areas
• Strong skills in Data Modeling, Dimensional Modeling, PL/SQL for enterprise Reporting solution.
• Oracle certified Server architect
• Attended PMP training

TECHNICAL SKILLS

Database: Oracle 9i, 10g, 11g, Sql Server

Business Intelligence Tools: OBIEE 11g/10g, OBI Apps, Siebel Analytics

Languages: SQL, PL/SQL

OS: Unix, Windows

ETL Tools: Informatica, ODI

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Senior OBIEE Architect / PM

Responsibilities:

• Was the SME for Business Intelligence on the project and played the role of the track lead
• Involved with business team to understand the reporting requirements used in legacy reports to implement the same in OBIEE
• Managed the 10 member reporting track and also played the role of the scrum master
• Involved with Project managers and business stakeholders to gather KPI's for reporting
• As part of the architecture team involved in code reviews of the development work done by all development teams.
• Responsible for formulating the OBIEE development standards, best practices and guidelines
• Based on user requirements, identified various gaps on existing Oracle analytics warehouse and developed solutions to meet users requirements and loaded the user required data into the OBAW
• Designed the core OBIEE RPD model for reporting.
• Implemented complex BI calculations to replicate the functionality of the existing legacy reports
• Used custom filters & dashboard prompts appropriately in reports and maintained effectiveness in creating the dashboards by using guided navigational links & drilldowns
• Did PL/SQL programming.Developed stored procedures and packages.
• Implemented Role based security
• Created BI publisher reports
• Trained team members on OBIEE and OLAP concepts, new techniques and methodologies

Senior OBIEE Lead

Confidential, Boston, MA

Responsibilities:

• Worked with the Business users to understand the requirements and designed the Data model and BI architecture for the right solution.
• Being the onsite coordinator managed the 5 member development team in India
• Designed & Modeled the BI Data Model (Facts & dimensions) that was required for the BI reports development
• Configured and set up the OBIEE development, UAT and production environment
• Coordinated the Unit and System testing of the OBIEE reports.
• Involved in the UAT with end users for testing the reports
• Implemented user security authentication using LDAP server directory
• Performed pre and post implementation testing and validating dashboards through data validation
• Actively interacted with team members to discuss technical enhancements and progress of work
• Involved in performance tuning for BI server and Oracle SQL queries
• Developed Dashboards / Reports using different Analytics Views (Pivot Table, Chart, View Selector and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, guided navigation, charts, tabular using global and local Filters.
• Implemented security by creating users & groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks

Confidential

Senior BI Architect (OBI Apps)

Responsibilities:

• Involved in gap analysis of OBI Apps module to validate what needed to be customized for building the OBIEE reports (matching the SAP BW reports functionality)
• Requirement gathering with client’s business users at client site
• Managed a team of 6 developers in offshore.
• Created Project Proposal document and Statement of Work
• Developed and customized some of existing multiple dimensions (Drill-Down Hierarchies) & logical objects in BMM Layer, and created presentation folders in presentation layer
• Also participated in analyzing ETL mappings using ODI 10g
• Train team members on OBIEE and OLAP concepts, new techniques and methodologies
• Code review of the development work done by all the development teams.
• Coordinated the Unit and System testing of the ODI interfaces & OBIEE reports
• Involved with the Testing team to resolve, fixing and testing problems found during the Systems integration test, QA.

Confidential

Project lead

Responsibilities:

• Did the technical design of the data model and OBIEE repository (RPD)
• Platform Upgrade for Siebel Analytics from 7.8.5.2 to Oracle BI 10.1.3.3.2 to resolve Performance issues
• Worked closely with Oracle to resolve upgrade issues.
• Multilingual Implementation (Siebel Supported and Non-supported languages)
• Supported the Unit Testing and System Testing of the OBIEE reports
• Designed and Developed custom business intelligence solutions (Metadata and Dashboards/Reports) using Siebel Analytics platform.
• Developed the OBIEE Metadata repository (.rpd) model with the necessary logic that involved creating the Physical, BMM layers with aggregates, dimensions & time series functions, Presentation layer with catalogs & folders and external table security using Admin tool.