SUMMARY

• Over 8+ years of information Technology and 6 years of experience in OBIEE 11.1.1.7.x,OBIEE 10.1.3.x, BI Publisher 10g/11g, Informatica 9.x/8.x/, Oracle 9i/10g/11g which includes experience in Business Requirement Gatherings, Analysis, Design, Data Modeling, Development, Testing and Implementation of Data warehouse/Business Intelligence.
• Expertise with developing dynamic and interactive Dashboards with drill - down & drill-across capabilities, and Web Catalog using Oracle Business Intelligence Tool.
• Experience in Setting up Dynamic, System and Non-System Variables.
• Experience in Configuring External Database Authentication Security and LDAP Security to Store User and User Groups Credentials.
• Experience in Setting creating Time Dimensions and Time Series Measures like AGO and To-Date functions and also created Level Based Measures.
• Experience in Creating Complex Aggregation Tables and Dimensional Hierarchies.
• Experience in Configuring Usage Tracking to keep track of Query Performance, Query Log and Report Usage.
• Experience in creating KPI and Scorecards and embedded on OBIEE Dashboard.
• Experience in using Oracle, Oracle Utilities, ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI), SQL scripting and Relational Database modeling
• Expertise in Building Metadata Repositories (.rpd), building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool.
• Experience in Configuring Multi User Environment (MUDE) on Shared environment to allow Development team to work as well as 2-Way Merge and 3-Way Merge.
• Experience with OBIEE/Siebel components like OBI Server/Client, OBI Answers, Oracle BI Presentation Services, Scheduler, Config files, other tools and utilities.
• Active participation in Presentation of Project concept, status, plans and progress.
• Excellent communication skills, versatile team player with excellent interpersonal skills.

TECHNICAL SKILLS

Business Intelligence: OBIEE 11.1.1.7.x, OBIEE 11.1.1.6.x, OBIEE 10.1.3.x, BI Apps 7.9.6.2/7.9.5

Data modeling/ETL: Informatics power center 9.x/ 8.x/7.x, Star & Snowflake schema.

RDBMS: Oracle 8i/9i/10g/11g,MS-SQL SERVER, IBM DB2

Database Tools: SQL*plus 8.x/9.x,PL/SQL 8.x/9.x

Programming Languages: C, C++, SQL, PL/SQL and shell scripting.

Operating Systems: Windows 7/ XP/2000/2003/NT,UNIX(Solaris, UNIX)

PROFESSIONAL EXPERIENCE

Confidential, Leawood, KS

Sr. OBIEE / OBIA Consultant

Responsibilities:

• Involved in Gathering the requirement and Design the FSD as per the user Requirement.
• Involved in Day-to-Day meeting, discuss about the progress activity, and show stoppers.
• Worked on Design and Implementation of OBIEE RPD(Physical/BMM/Presentation Layer)
• Worked on ODI Mapping for Different Data Source using Knowledge Module as per the Requirement.
• Co-ordinate with other co-worker and share the RPD work of merging the work as well of other work together.
• Worked on Administration Activity with respect to OBIEE Server for Build Release activity and deployment of View on Different Database.
• Worked on RPD Design for Around 30 Subject Area with Data Level Security Implementation across Each Subject Area in Presentation Layer.
• Worked on Development Activity with ODI Mapping, Administration, and migration of Mapping from Development to QA to UAT Environment.
• Worked on Management Reporting for 90 calculated measure columns and worked on designing the logic for each separate with RH Code account.
• Co-ordinate with other co-worker and share the RPD work of merging the work as well of other work together.
• Worked on Solving the Report and Dashboard level issue with respect to Data and Application perspective.
• Worked with the Data-Level Security feature implemented in Project.
• Worked on RPD Design and Report Development activity and involved in Administration activity.

Environment: OBIEE 11.9.x, OFFSA, ODI 11g, Oracle Database, Oracle EBS R 12, SQL Developer Tool, HP ALM, XML (BI) Publisher, BI Discoverer 11g, PL/SQL.

Confidential, Washington D.C

Sr.OBIEE Consultant/Senior functional

Responsibilities:

• Involved in Gathering the New requirement and Design the FSD and TSD as per the user Requirement.
• Manage the SharePoint about the updated document and take care of Release Activity.
• Involved with Performance Tuning technique and work with Teradata base Team.
• Involved activity of taking care of offshore team involves 3 Developer and 2 Tester.
• Worked on analysis, Design and Development of RPD and Dashboard /Reports.
• Worked with the Data-Level Security feature implemented in Project.
• Following the Agile Methodology for meeting and keeping track of work with the offshore and on-site work.
• Worked with BI Architect on the design of logical and physical data models using Star Schema and dimensional data modeling.
• Develop test scripts and perform system and unit end-to-end testing.
• Modified all the OBIEE Security that has been completely changed from the previous Versions OFFSA /Cubes to the newer version of OBIEE 11g with respect to TERADATA base.
• According to the new security setup - Refreshed all the (GUI’s) Global Unique Identifiers of the users to login to the OBIEE 11G Analytics.
• Expertise with developing dynamic and interactive Dashboards with drill-down & drill-across capabilities, and Web Catalog using Oracle Business Intelligence Tool.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures.
• Trouble shooting the issues related to repository models and report development.
• Utilized Siebel Delivers for sending real-time personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.
• Carrying forward with Testing End- to - End Application, Data-level and regression testing
• Act as the application and process SME for the supply chain planning functions.
• Analyze business and other data processing problems to implement and improve supply chain processes of applications to provide Lumentum with comprehensive business and industry solutions.
• Specifically, analyze user requirements, procedures, and problems to automate and improve cross-functional systems and process projects related to operations, particularly in the areas of Manufacturing, Supply Chain Management, Inventory Optimization, and Supply Planning.
• Analyze system/process changes and enhancement requests, and work with supply chain to prioritize requests.
• Develop Solution Design and Functional Requirements documentation
• Perform functional design, architecture, regression, and user acceptance testing for business system applications enhancements.
• Develop and deliver Super User and End User training, for a global user base.

Environment: OBIEE 11.7.x, OFFSA, Teradata base (Teradata 14.10. .10.05.03 Version),Informatica 9.x Teradata SQL Assistant, SQL Developer Tool, HP ALM, XML (BI) Publisher, BI Discoverer 11g, PL/SQL. Oracle R12 Oracle Payroll

Confidential, Boston, MA

OBIEE / BIP Consultant

Responsibilities:

• Involved in developing & deploying RPD, including physical layer, business model and mapping layer, and presentation layers in OBIEE 11g.
• Worked on developing and deploying Analysis, Dashboards, BI Publisher, and Web Catalog in OBIEE 11g.
• Worked with business user gather the requirement, design the functional specification document based on provided BRD and convert to technical specification document.
• Worked on creating business critical Reports, Dashboards, RPD development and visualizations.
• Tracing the sql query for better performance and part of performance tuning Activity.
• Involved in understanding the Business need. Support Account Managers(SAM) work with NetApp customers, and the assigned Account/Sales Team by providing expertise in the following areas: Personalized Service, Centralized Support Management, Customized Proactive Care
• Data model design and documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts)
• Design and develop ER diagrams and map the source data into data warehouse objects
• Develop OBIEE meta-data layer; Configure repository on all the three layers (Physical Layer, Business Logic and Mapping Layer and Presentation Layer).
• Objects must be accessible to all stakeholders, internal and external.
• Analyze existing Configuration and formulate logic for new OBIEE analyses, dashboards and reports Analyze, design, develop, modify and test OBIEE Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters. for complex agency information technology systems
• Works with Architect(s) to understand design and configure repository metadata and build dashboards & reports
• Experience with Troubleshoot and resolve issues/challenges and Performance tuning of BI Reports
• Design and optimize the physical, logical and presentation layers within the OBIEE Repository
• Involved in Migrate OBIEE objects Dev to UAT and UAT to Production
• Analyze problems and provide recommendations for OBIEE Repository and Middle Tier configurations
• Prepared detailed documentation for all objects developed and Prepare transition documents; other duties as assigned
• End-End Unit testing by using HP ALM Tool

Environment: OBIEE 11G, OBAW, SQL Server, Netezza, Teradata, EPM 11, TOAD,HANA, HP ALM, Oracle E-Business Suite R12\11i, XML (BI) Publisher, BI Discoverer 11g, PL/SQL.

Confidential, Plano, TX

OBIEE Consultant/ Project coordinator

Responsibilities:

• CreatedRequirements Traceability Matrix and Mapping Documentto trace requirements in BI implementation.
• ConductedFunctional Requirements review and walk throughwith BI Lead, Designers, and Stakeholders.
• Analyzed the data and developedLogical Star Schemamodel with consultation from Data Modelers and Business Analysts.
• Developed metadata repository usingOBIEE Administration toolin Physical, Business Model and Mapping, and Presentation Layer.
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Designed and developed variousInteractive Dashboardsand reports with drilldowns, guided navigation, filters, and prompts.
• Created varioussession and repository variablesand initialized them in theInitialization Blocks change metadata dynamically as the environment changes.
• ConfiguredBI SchedulerandOracle BI Delivers- Agentsto deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
• Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts and DBAs.

Environment: OBIEE 11G, OBAW, Oracle11g, EPM 11, SQL Developer, Oracle E-Business Suite R12\11i, XML (BI) Publisher, BI Discoverer 11g, PL/SQL.

Confidential, NY

OBIEE developer

Responsibilities:

• BI Publisher SharePoint integration.
• Administering all facets of the BI Publisher reporting implementation - data definitions, template definitions, document delivery and performance tuning.
• Designing a quality front end user experience using the presentation layer, BI Publisher, and Answers.
• Worked on integrating BI publisher with Siebel, Converting actuate reports to BI publisher reports.
• Developing Reporting specifications and technical Design.
• Design, develop, and implement new Oracle BI reporting, dashboard, and analytics solutions as part of a development team leveraging the presentation layer, BI Publisher, and Answers.
• Perform requirements gathering and work with business stakeholders on report design and layout with respective to the BI Publisher.
• Develop test scripts and perform system and unit End-to-End testing.
• Work with users and developers/programmers to correct recurring problems and troubleshoot critical issues.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures.
• Created auto purge for repository projects and scheduled as per the demand.
• Trouble shooting the issues related to repository models and report development.
• Utilized Siebel Delivers for sending real-time personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.

Environment: OBIEE 11G, Informatics 8.6/8.1.1, OBAW, Oracle11g/10g, EPM 11, SQL Developer, PeopleSoft, XML (BI) Publisher, BI Discoverer 10g, PL/SQL.

Confidential

Project Co-coordinator

Responsibilities:

• Developing Reporting specifications and technical Design.
• Design, develop, and implement new Oracle BI reporting, dashboard, and analytics solutions as part of a development team leveraging the presentation layer, BI Publisher, and Answers.
• Perform requirements gathering and work with business stakeholders on report design and layout with respective to the BI Publisher.
• Develop test scripts and perform system and unit End-to-End testing.
• Work with users and developers/programmers to correct recurring problems and troubleshoot critical issues.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures.