SUMMARY

• 12 years of IT experience in OBIEE 11g/10g, Siebel Analytics, BI Publisher, demonstrating prolific level of achievement in OBIEE Dashboards Reports development, Real time and OLAP reporting.
• Excellent experience and customer appreciated performance in playing the role of Business Analyst
• Strong Knowledge of all phases of Software Development Life Cycle SDLC such as Requirement Analysis, Design, Development, Testing, UAT, Implementation and Post production support.
• Experience in OBIEE 11g Enterprise installation and Administration.
• Experience in repository development and modeling 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 in jobs scheduling using Oracle DB console.
• Experience in demonstrating POC's for business proposals at customer locations directly
• Excellent skills in OLAP/BI Tools OBIEE,BI Publisher
• 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.
• Professionally certified with PMP Project Management Professional , OCA Oracle Certified PL/SQL Developer , MCSD, Microsoft .NET Framework Application Development Foundation, Macromedia Cold Fusion 7, SCJP 2.0 and Teradata Basics and V2R5 .
• Extensive expertise and hands-on in other Oracle Fusion Middleware suite of applications like SOA Suite 11g, BPEL, Mediator, OSB, OWSM, Adapters, BAM, MDS, Oracle B2B and in JDBC and XML technologies.
• Highly competent in other technologies like Business Objects, ColdFusion, Teradata, Oracle PL/SQL scripts, Shell Scripting, Mercury QC, SQL Server, ASP, JSP, VC .

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Gathering of report requirements, participate in JAD sessions with LAUSD users to get a clear understanding of their Staff performance Evaluation system.
• 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 Infrastructure.
• Design Data model for custom Repository development from various 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 canned reports on Teacher Summary, Evaluation, LEAD, Course Assignment, and Staff Attendance.
• Design the LDAP authentication provider and authorization of users for various roles.
• Design and model complex reports for their history reports, Summary reports.
• Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports by implementing Aggregate navigation, cache management, assigning roles and permissions to users for dashboard based on policy settings in tables and row level data security.
• Develop in line record view with action links both conditionally and otherwise.
• Assist in performance of Gap Analysis related to Data Models and map client requirements into OBIEE Analytics functionality
• Debugged and implemented the best practices in mappings, sessions, and workflows for data extraction and loading from source to target databases.

Environment: OBIEE 11.1.1.7.1/10.1.3.4.1, Oracle 11g, Linux 5, Oracle Weblogic, Oracle PL/SQL

Confidential

Sr. OBIEE Consultant / Lead Developer

Responsibilities:

• Gathering of report requirements, participate in JAD sessions with Demand Media to get a clear understanding of their financial system and analysis of system report transactions interfaced from SQL Server DB ENOM into Oracle.
• 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 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 Accrued Payables, Advertising cost split, various GL Transactions OLTP and deferral reports.
• Develop complex reports for their forecasting like future waterfall reports, history reports, Summary reports with roll forward.
• Design reports with positional hierarchies for resellers.
• Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports by implementing Aggregate navigation, cache management, assigning roles and permissions to users for dashboard based on EBS defined roles and materialized views.
• Designed the OTAE subject area in the repository .rpd across the three layers Physical, BMM and Presentation and implemented the row level data security based on org id.
• Develop in line record view with action links and develop reports with guided navigation links
• Lead and Coordinating with offshore team from onsite for project execution and delivery responsibility
• Assist in performance of Gap Analysis related to Data Models and map client requirements into OBIEE/ Siebel Analytics functionality
• Debugged and implemented the best practices in mappings, sessions, and workflows for data extraction and loading from source to target databases.
• Created Repository Users/ Groups and Web Groups and assigned permissions to the user groups to define security in the repository.
• Created and customized various Reports and Dashboards for various user groups.
• Created reports with different views Compound, Chart, Table, Pivot and Narrative
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers.
• Expertise in writing the queries using PL/SQL.
• Secured Dashboards and Reports by defining user roles.
• Implemented OBIEE security at the data and object levels.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.
• Created user manuals and troubleshooting guides.

Environment: OBIEE 11g/10.1.3.4.1, Oracle 11g, Linux 5, Oracle Weblogic

Confidential

BI Consultant/Lead Developer

Responsibilities

• Gathering of report requirements and templates, JAD sessions with Team Services for strategic development and implementation of cost-effective solutions that are designed to provide improved productivity, streamlined operations, and faster access to information.
• Responsible for design and development of Oracle BI Publisher reports for their Time card modules for Union and non-union crew, contract time cards for TV commercials, Model Contracts, Talent Extra, Non-Union and Principal.
• Design of data models, implementation of logic for each of the templates, formatting and publishing of the templates.
• Successfully used BI Publisher to create RTF Templates using XML sample data.
• Design of ADF interface for embedding the BI Publisher template and calling it from the Time card ADF module for supervisor approval online.
• Managing offshore component for execution of report deliverables, mentoring them in BI Publisher for proper handshake between onsite and offshore.

Environment: Oracle BI Publisher 11g, Oracle 11g

Confidential

OBIEE Lead Developer

Responsibilities

• Gathering of report requirements and templates, JAD sessions with Cricket for strategic development and implementation of cost-effective solutions that are designed to provide improved productivity, streamlined operations, and faster access to information.
• Support for existing Business Objects reports, design and development of adhoc BO reports to cater to the needs of the Accounting users.
• Design and Development of OBIEE RPD and Webcat modules based on the existing BO reports and the new requirements of the Accounting users.
• Design of self-service subject areas in the presentation layer for meeting the future reporting needs of the users.
• 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 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
• Develop in line record view with action links and develop reports with guided navigation links
• Offer SME support to the business logic used in all the reports and specialize in each subject area such as Revenue Accounting, Revenue Assurance, Metrics Reporting, Scorecard and product reporting.
• Assist in performance of Gap Analysis related to Data Models and map client requirements into OBIEE/ Siebel Analytics functionality
• Debugged and implemented the best practices in mappings, sessions, and workflows for data extraction and loading from source to target databases.
• Created Repository Users/ Groups and Web Groups and assigned permissions to the user groups to define security in the repository.
• Created and customized various Reports and Dashboards for various user groups.
• Created reports with different views Compound, Chart, Table, Pivot and Narrative
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers.
• Expertise in writing the queries using PL/SQL.
• Secured Dashboards and Reports by defining user roles.
• Implemented OBIEE security at the data and object levels.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.
• Created user manuals and troubleshooting guides.
• Trained End Users to Build Ad Hoc Reports using OBIEE.

Environment: OBIEE 10.1.3.4.1, Oracle 10g, Linux, Business Objects XI

Confidential

BI Lead Developer

Responsibilities

• Analysis of the Call Detail Records.
• Generating adhoc reports using CDRlive for a wide customer base.
• Involved in Data Modeling and design
• Conducted project planning and work estimations
• Responsible for supporting and enhancements of OBIEE
• Independently Designed and developed subject areas in the RPD
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer design of hierarchies, dimensions, and aggregates
• Define appropriate joins, calculations, dimensions and measures in the repository
• Assist in performance of Gap Analysis related to Data Models and map client requirements into OBIEE/ Siebel Analytics functionality
• Debugged and implemented the best practices in mappings, sessions, and workflows for data extraction and loading from source to target databases.
• Created Repository Users/ Groups and Web Groups and assigned permissions to the user groups to define security in the repository.
• Created and customized various Reports and Dashboards for various user groups.
• Created reports with different views Compound, Chart, Table, Pivot and Narrative
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers.
• Expertise in writing the queries using PL/SQL.
• Secured Dashboards and Reports by defining user roles.
• Implemented OBIEE security at the data and object levels.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.
• Created user manuals and troubleshooting guides.
• Trained End Users to Build Ad Hoc Reports using OBIEE.

Environment: OBIEE 10g, Oracle 10g, UNIX Scripts, SQL, PL/SQL, JSP

Confidential

Programmer Analyst

Responsibilities

• Analysis and understanding system requirements.
• Software Requirement Analysis and Design for Enhancement.
• Authored impact analysis document.
• Coding and unit testing of client requirement.
• Developing PL/SQL scripts for the Data Mock Up Tool and triggers for monitoring the Comp Engine.
• Co-ordinated with third party system testing team.
• Defect fixing and delivery.

Environment: Cold Fusion 5.0, Oracle 9i PL/SQL, Shell Scripts, Mercury Quality Center, Toad.