SUMMARY

• Has around 12 years of extensive experience in OBIEE, Siebel Analytics, BI Publisher, Data Warehousing technologies, demonstrating prolific level of achievement in OBIEE Dashboards & Reports development, data warehouse design, maintenance, data loading, Real time and OLAP reporting
• Expertise in OBIEE, Siebel Analytics, Data Warehousing Technologies, BI Reporting
• 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
• Excellent experience and customer appreciated performance in playing the role of Business Analyst to gel Business with technology and providing optimal value adding business solutions
• Experience in integrating and configuring industry specific OBIA(Oracle Business Intelligence Applications) for modules Marketing, Sales, Customer Service, Public sector, AR, AP, Business operations
• Experience in setting up Development and Infrastructure setup for OBIEE Environment
• Expertise in working OBIEE Administration tool and design Schemas to fit business requirements
• Experience in design and development of Dimensional and Position based hierarchies
• Experience in design and development of drill down reports and dashboards for trend analysis
• Expertise in OBIEE Web Catalog Administration
• Experience in setting up Authentication and Authorization for users and groups
• Expertise in design and development of Ad - hoc Reports & Dashboards using OBIEE suite
• Excellent experience in interacting with client SME’s on-site and offshore and experience in converting business requirements to functional, technical requirements
• Experience in developing reports using BI Publisher
• Experience is design and development of ETL mappings and workflows using Informatica & ODI
• Experience in using Oracle Portal and Oracle Web center portal
• Excellent experience in complete Software Development Lifecycle
• Experience in jobs scheduling using Oracle DB console
• Experience in demonstrating POC’s for business proposals at customer locations directly
• Experience in understanding and working extensively on Siebel, EBS OLTP and OLAP model
• Experience in customizing and Master Data Management for Sales, Marketing, Financials (AR,AP,GL), SCM, TPM and Business Operations
• Excellent skills in OLAP/BI Tools - OBIEE, BI Publisher, Siebel Analytics, DAC
• Other experiences include working on Data Integration (ETL) Tools - Informatica, OWB

TECHNICAL SKILLS

OLAP/Reporting Tools: OBIEE 11.1.1.5/6/ 10.1.3.4.1 , Siebel Analytics 7.8.x, MS SSRS QlickView, Business Objects, Cognos, Tableau 8.2

ETL Tools: Informatica 8.6.1/7.1.4 , MS SSIS, ODI 11g

CRM-Apps: Siebel 8.1, EBS 11.5.10.2, EBS R12

Data Modeling Tools: Erwin 7.3, MS Visio, Rational Rose

Operating System: Windows 9x/2K /NT, XP, UNIX and Linux

Databases: Oracle 9i/10g/11g, Sql Server 2005/08

DW Utilities: DAC 10.1.3.4.1 , MS-VSS, TOAD, Oracle Sql Developer

Programming Languages: C#, Asp.Net, HTML, Java Script

PROFESSIONAL EXPERIENCE

Confidential, Redwood City, CA

OBIEE/DWBI Architect & Onsite Project Lead/Manager

Responsibilities:

• Responsible for performing Enterprise level Analytic reporting solutions for the EMEA, APAC, AMER customers
• Solution designing for reporting requirements from heterogeneous sources (EBS, Siebel, Caplogix, SingleView, IBX Master, SFDC)
• 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 and new development from non-Oracle integrated sources
• Design and development of Business model and mapping for the Business rules
• Design and development of OBIEE Dashboards, Answers and catalog Administration
• Design and develop ad-hoc reports on Boundary systems, Legal & Finance
• Develop complex reports on Weekly, Monthly wire line scorecards, IBX, Customer level
• Design and setup Data level security for the Region specific users at the enterprise and Region level
• Design reports with Position based hierarchies for Finance Module across multi regions
• Develop in line record view with action links and develop reports with guided navigation links
• Design and development of FDD, TDD, UTP
• Weekly/Monthly reviews and status update meetings with the management team and clients
• Work with DBA and GDC Singapore to identify and resolve performance bottlenecks and provide appropriate solution
• Excellent experience with Client appreciation for driving Finance, Customer Care, IBX Ops, Sales Modules
• Lead competency team for Tool evaluation (Tableau 8.2 Vs OBI Suite) for reporting needs

Environment: OBIEE 11g, EBS R12, Oracle 11g/Exadata, Citrix, OEL 5.x, Windows Server 2008, Erwin, MSSP, Toad 9, HP ALM 11.5x

Confidential, IRV-TX

OBIEE/DWBI Architect & Onsite Project Lead/Manager

Responsibilities:

• Responsible for performing Enterprise level reporting analysis for the C2C (Coast to Coast),N-ATL (North Atlantic) customers
• Solution designing for reporting requirements from heterogeneous sources (ETMS, Oasis, Oracle, VSII, My network, VZ Atlas, SDA)
• 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 and new development from non-Oracle integrated sources. Design and development of Business model and mapping for the Business rules
• Design ETL Load strategy and process to populate Dimensions and Facts. Design strategies for CDC and SCD’s
• Monitor data load and schedule jobs under VSII using the canonical data model
• Design and development of OBIEE Dashboards, Answers and catalog Administration
• Design and develop ad-hoc reports on SRR, ETMS and NFM analysis
• Develop complex reports on Weekly, Monthly wire line scorecards, Ticket summary, Region level
• Design and setup Data level security for the Region specific users at the enterprise, Region
• Design reports with Position based hierarchies for Sales module across Market
• Develop in line record view with action links and develop reports with guided navigation links
• Design and development of BRD, HLD, UTP
• Weekly/Monthly reviews and status update meetings with the management team and clients
• Work with DBA and technical team to identify and resolve performance bottlenecks and provide appropriate solution
• Work with VDSI team and Manage overall delivery from offshore modules

Environment: OBIEE 11g,ODI 11g, SmartView, Oracle 11g/Exadata, Windows Server 2008, Citrix, OEL 5.x, Erwin, Confidential MyNetwork, Toad 9

Confidential, ATL-GA

OBIEE/DWBI Architect & Onsite Project Lead

Responsibilities:

• Responsible for performing Enterprise level reporting analysis for the existing divisions by POC with Arizona Market as the active and good to go Market data
• Solution designing for reporting requirements from heterogeneous sources (OIC, EBS, SQL Server, OS/400)
• 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 tollgate approach and detailed task identification, resource estimation, coordination to prepare project plan
• Design Data model for custom Repository development from non-Oracle integrated sources
• Design and development of Business model and mapping for the Business rules
• Design and development of OBIEE Dashboards, Answers and catalog Administration
• Design and develop ad-hoc reports on Sales rep activities and Sales target analysis
• 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
• 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
• Design and development of FDD, TDD, UTP, RPR
• Lead and Coordinating with offshore team from onsite for project execution and delivery responsibility

Environment: OBIEE 11g/ 10.1.3.4.1 , OBIA 7.9.6.1/2, Informatica 8.6.1, DAC 10.1.3.4.1 , Oracle 11g, Windows Server 2008, Citrix, OEL 5.x, Erwin, HP Quality Center

Confidential

OBIEE/DWBI Architect & Onsite Project Lead

Responsibilities:

• Responsible for performing Enterprise level reporting analysis for the existing divisions by having the most active division (SouthEast) as a bench mark for analysis
• Solution designing for reporting requirements from heterogeneous sources (Siebel, EBS, SQL Server, SDB -Mainframe system)
• 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 tollgate approach and detailed task identification, resource estimation, coordination to prepare project plan
• Responsible for Environment set up for OBIEE, Informatica Infrastructure
• Design Data model for custom Repository development from non-Oracle integrated sources
• Design and development of Business model and mapping for the Business rules
• Design and development of OBIEE Dashboards, Answers and catalog Administration
• Design and develop ad-hoc reports on Sales rep activities and Sales target analysis
• Develop complex reports on Forecasting Sales Performance, Backlog analysis, True price analysis
• Design reports with Positional hierarchies for Sales module across divisions
• 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
• Design and development of FDS, TDS, UTP
• Lead and Coordinating with offshore team from onsite for project execution and delivery responsibility
• Involved in SIT, QA and Production deployment and End user training(CRPT)

Environment: Siebel 7.8, EBS 11.5.10.2, OBIEE 11g/ 10.1.3.4.1 , OBIA 7.9.6.1/2, Informatica 8.6.1, DAC 10.1.3.4.1 , Oracle 11g, Windows Server 2008, Citrix, OEL 5.x, Erwin, Share Point Portal

Confidential

OBIEE Architect/ Lead Developer

Responsibilities:

• Responsible for performing the fit Gap Analysis for the 360 degree view and understanding
• Requirements gathering, development estimation for each phase of the OBIEE reports
• Responsible for Environment set up OBIEE Server, OBI Applications
• 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
• Responsible for Administration of Oracle BI Publisher
• OBIEE server, web administration Customized analytics web user interface
• Design and development of FDS, TDS, UTP
• Involved in SIT, QA and Production deployment

Environment: Siebel 8.1, OBIEE 10.1.3.4.1 , OBIA 7.9.5.2, Informatica 8.6, DAC 10.1.3.4.1 , BI Publisher, Oracle 10g, Windows Server 2003, Citrix

Confidential

OBIEE Architect/Lead

Responsibilities:

• Responsible for setting up OBIEE Server, OBI Applications for pharmaceutical business needs
• Requirements gathering and interaction with the client SME’s to draft business requirements
• Responsible for converting business requirements into Functional and technical requirements
• Design Data model for Repository development
• Design and development of complex reports to derive Target efficiency Index, Activities, Account and Contacts
• Design and development of OBIEE Answers and Dashboards
• Design and develop ad-hoc reports for Account and Contact history
• Design and develop custom and customization of ETL mappings and workflows
• Responsible for setting up DAC execution plans and Administration
• Responsible for Administration of Oracle BI Publisher
• Design and develop complex reports for Sales module with write back options for forecast analysis
• Design and development of Business model and mapping
• OBIEE server, web administration Customized analytics web user interface
• Design users groups and maintain authentication of user groups
• Design and development of HLD,LLD and UTP
• Responsible for user manual preparation and training

Environment: Siebel 8.0, OBIEE 10.1.3.4, DAC 10.1.3.4, OBIA 7.9.5, BI Publisher, Oracle Business Intelligence Standard Edition, Oracle Warehouse Builder 10gR2, Windows Server 2003

Confidential

OBIEE/Siebel Analytics Lead/architect

Responsibilities:

• Analysis and study of existing system running over TPMS( Transaction Processing and Management System)
• Requirements gathering on coordination with client SME and BRD preparation
• Design Data model for Repository development
• Develop dimensional hierarchies for the Toll collection centre’s and collection agents
• Design and development of OBIEE Dashboards, Answers
• Development of Dashboards over the OLAP model designed for MD to deploy for various customers
• Responsible for migration of Analytics reports, repository to OBIEE Environment
• Responsible for design and development of ETL mappings and workflows
• Develop and schedule ibots for users on the collection details and dues
• Responsible for additional activity as Software Configuration Management coordinator
• Design and development of HLD,LLD, UTP
• Involved in upgrade POC from Siebel Analytics to OBIEE
• Involved in SIT, QA, deployment and post production support

Environment: Siebel 8.0, OBIEE 10.1.3.3.2 , Siebel Analytics 7.8.5, Informatica 7.1, Oracle Business Intelligence Standard Edition, Oracle Warehouse Builder 10gR2, TPMS, Windows Server 2003

Confidential

Siebel Analytics Senior Developer

Responsibilities:

• Analysis and study of existing systems placed on O2’s EAI
• Data Modeling using Rational Rose Modeler for enhancements and ad-hoc queries received
• Designing interfaces for the consumer systems based on the CDM(Canonical Data Model)
• Design Subject Areas derived from the business logic and inputs from CDM
• Siebel analytics server, web administration and user groups creation
• Design and development of hierarchies for the organization at various levels
• Involved in Writing Stored Procedures, Creating Packages and SQL code, Patches as per the SR requirement
• Design and development of Dashboards and reports for the consumer systems
• Development of ibots and scheduling jobs for user reports on payments and queries
• Design and development of FDD,TDD,UTP
• Involved in SIT, QA, Production deployment and post production support

Environment: Siebel Analytics 7.8.5, Oracle 9i, UNIX, Rational Rose, Windows Server 2003, Rational clear case

Confidential, NC

Senior Software Engineer

Responsibilities:

• Requirements gathering, estimation for development on interactions with client SME’s
• Preparation of KAD’s for the requirements gathered
• Responsible to perform sun setting analysis of existing reports
• Data Modeling for Repository development
• Design and development of Business model and mapping
• Design and development of Dashboard, Reports for clients at various locations based on the requirements and customization of existing reports
• Responsible for automation of the existing reports to the senior level management
• Involved in Writing Stored Procedures, SQL code, Patches and enhancements of existing systems
• Involved in Testing and Execution Requirement of the production reports
• Responsible for additional role as a Defect prevention council member
• Design and development of HLD,LLD,UTP
• Involved in SIT, QA, Production deployment and support

Environment: Siebel Analytics 7.8.5, Oracle 9i, Sql server 2000, Citrix, Windows NT

Confidential, Texas

Senior Software Engineer

Responsibilities:

• Requirements gathering, estimation for development on client location directly
• Develop technical specifications for information retrieval and reporting
• Analyzing the Data Model, ETL Flow and mapping details for the compensation rules
• Dashboards, answers development for information delivery to various management levels
• Implementation of EIM and Compensation business logic in BMM
• Design and develop complex reports on dimensional hierarchies for management and sales team
• Create user groups and Web catalog administration
• Preparing High level Design and Functional Specifications and Technical Design Document.
• Design, Develop, Testing of Mappings, Workflows and Reports
• Preparation of Unit Test plan document, Unit Test Case document and SR’s Release document
• Co-ordinate for SIT and UAT and rollout support

Environment: Siebel Analytics 7.8, Oracle 9i, True Comp5.X, Informatica 7.1, Windows NT

Confidential

Analytics Reports Developer

Responsibilities:

• Design and development of reports and dashboards for management reporting team
• Develop reports for Organization hierarchies and positions
• Siebel analytics server, web administration co-ordination
• Responsible for software configuration management co-ordination
• Analyzing the Data Model and in corporate the changes for enhancements
• Tested data availability for downstream applications with flat sources and POC demonstration
• Preparing High level Design and Functional Specifications and Technical Design Document
• Preparation of Unit Test plan document, Unit Test Case document and SR’s Release document

Technical Environment: Siebel Analytics 7.7, SqlServer 2000, Windows Server 2000/2003, VSS