SUMMARY

• Business Intelligence professional lead / Architect /senior Developer with around 8+ years of OBIEE (Oracle Business Intelligence) expertise, focused on delivering BI solutions to medium and large IT departments and with overall 17+ years of BI/ETL/Data Warehouse /Oracle Application & Database systems (SQL/PL/SQL) experience.
• Successfully planned and executed full life - cycle Oracle/ETL /OBIEE Projects as a senior technical and lead role.
• Worked as a consultant for client such as Confidential, Confidential, Confidential, Confidential .
• Good understanding of teh industry’s best practices, trends and methodologies around Data Modeling,, ETL, Data Quality
• Well-organized, accustomed to working under tight deadlines and demonstrated abilities in programming with excellent crisis handling and user interaction skills.
• Collaborate with business and data owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution.
• Experienced in Full Systems Development Life Cycle (SDLC) Implementation of Various Oracle and business intelligence (OBIEE) Projects.
• Installation, configuration and migration of OBIEE reporting from 10g to 11g and patching of 11g environment.
• Troubleshoot Production issues, identify root cause and migrate fixes. Develop reporting standards and best practices to ensure data standardization and consistency. Perform data cleansing and data auditing as necessary to ensure data quality. Define and develop physical and logical data models to support departmental and functional reporting needs.
• Migration of Reporting from legacy reporting to OBIEE scope.
• Performance tuning and enforcing repository best practices.
• Developed Metadata Repository (.rpd) using BI Server Administration tool by importing teh required objects (Dimensions/Facts/Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, RPD merges, Star schema/Snowflake modelling, developing multiple dimensions (Drill-down Hierarchies) and Logical/Facts/Measure objects inBusiness Model Layer, and created Presentation Catalog in Presentation Layer.
• Extensive experience in providing end-to-end business intelligence solution by creating interactive Dashboards and answer/analysis / Reports with drill-down capabilities using global & local Filters, scheduling iBots.
• Extensive experience on OBIEE features (i.e. Security, cache management, usage tracking, dimensional hierarchy, aggregate navigation, and OBIEE Variables/Initialization Blocks configuration).
• Advanced working experience / Knowledge in Oracle Business Intelligence Enterprise Edition and Oracle Business Intelligence Publisher Reporting.
• ImplementedData Level Security, Object LevelSecurityand LDAP autantication and external table authorization.
• Experience in implementing Oracle BI security setup according to user requirements by setting up group/data access, Web Catalog Objects (Dashboards/pages/folders/reports).
• Security set up in 11g environment using custom Application roles/policies and corresponding grants to Web Catalog Objects
• Experience in configuring BI Publisher with Oracle Business Intelligence and developing reports.
• Solid design / development & support experience in using Oracle DB, Oracle Development Tools- SQL & PL/SQL (Oracle objects, Materialized views, Packages, Database Stored Procedures, Functions, Triggers, Collections, BULK Collection, SQL*Loader) including oracle forms/ report development.
• Worked on implementation of Data Warehouse, BI solutions and a strong understanding of Data Warehouse concepts, ETL, Star Schema, Data Modeling, Business Process Analysis, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
• Dimensional modelling and ETL with SSIS tool.
• Experienced in Database schema Design, Entity-Relationship modeling, Dimensional modeling, and Star schema, Kimball/Inmon methodology /approaches / Data Warehouse Architecture.
• Performance improvements / SQL tuning / Unix shell scripting
• Functional testing / unit testing and implementing in production environment.
• Proficient at interviewing stakeholders and end users, and in translating users’ statements of needed system behavior and functionality into Business and Technical Requirements.
• Deliverables of ERD/ Data Models, Data/Process Flow Diagrams, Use Cases, Gap Analysis.
• Knowledge /Experience in oracle /SQL server database, Oracle Discoverer, ETL tool SSIS, Oracle EBIS(Oracle E-Business Suite), Oracle Data Integrator( ODI), Informatica, OBIA
• Exposure to SAP Business Objects
• Conducting POC on reporting and Data ware housing, sharing BEST Practices, assisting /training stake holders etc.

TECHNICAL SKILLS

Database: 8/9/10g/11g on Unix/Linux

Languages: SQL, PL/SQL, C, UNIX and Pro*C.

Tools: OBIEE 11g /10x (Admin tool (RPD), Dashboard, Analysis), Forms 4.5/6i, Reports 2.5/6i, Oracle Designer 2000, Discoverer 4, TOAD, Essbase Cube

Oracle Applications: GL, AP, HRMS

Script Language: UNIX Shell Scripting, Java Script

Testing Tools: Test Director, QC

Others: HTML/J2EE

Operating System: AIX, Sun Solaris, HP-UX & Windows NT/2008 R2.

PROFESSIONAL EXPERIENCE

Sr. OBIEE /Oracle Lead/ Architect / Technical consultant

Confidential, NJ

Responsibilities:

• Delivered interactive OBIEE dashboard and KPIs (16+ dashboard pages, more than 300 analysis) to monitor, govern, support and reporting of initiative planning / program management, financials utilizing multiple operational sources.
• Involved in Analysis, Design, development and customization of Reports and Dashboards in OBIEE with daily client interaction. Created /guided Oracle BI publisher reports as per user requirements.
• Created new analysis / reporting (Pivot Table, Chart and Column Selector, view selector, report selector), with drill-down and drill across capabilities, guided navigation and dashboard and page prompts.
• Built teh Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository (RPD) by using Star Schemas along with Alias and Extension tables /Opaque views as per requirement to fit teh reporting requirement.
• Implemented Dimensional Hierarchies, Level Based Measures, Aggregate navigation and setting up content levels, content filters and also multiple logical sources to support teh snow flake schema from physical layer to meet teh reporting requirements for financial and planning data.
• Completed Installation, configuration and migration of OBIEE from 10g version to 11g version.
• Responsible for full cycle Implementation of OBIEE reporting.
• Customization of look and feel (skin changes)
• Used Cascading Style Sheets (CSS) / HTML methodologies, wrap OBIEE objects into web pages.
• Implemented Security by creating custom Application roles /Policies / web groups, External database table authorization and LDAP autantication with Active Directory.
• Involved in usage Tracking Table and Dashboards, Performance Tuning using optimization efforts such as re-organizing teh data, Cache Management, indexes, Oracle materialized views and reports changes.
• Design, configuration and documentation of Logical and Physical Data Model. Worked on creation of Database objects for Fact and dimension tables, views, materialized views, packages, and triggers.
• Design/ development of ETL process (SSIS) with Oracle SQL / PL/SQL.
• Gathering and analyzing business requirements from various sources, ensuring teh needs and delivery feasibility and to provide better & enhanced reporting solution.
• Dimensional modeling, and Star schema
• Completed teh proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts.

Environment: OBIEE 11g /10x, Oracle 11g/10g, SQL, PL/SQL, TOAD, Windows Server 2008 R2, SSIS

Confidential

:Responsibilities:

• Responsible for creating database environment for finance data area. Responsible for teh analysis of teh source systems, design and development of teh database objects and stored Package/Procedure/Functions for processing data as per business needs in PL/SQL custom code.
• Creation of Fact Dimension table / structures for OBIEE reporting for finance data fed from sub Ledger systems.
• Partitioning of tables, performance tuning of teh oracle process / SQL queries.
• Automating feeds to downstream systems as flat/excel file from database based on downstream application needs and Production Support, bug fixing, and enhancement of teh database system as a whole.
• Provide database views to business user with proper grant / data select which are processed data as per business logic defined.
• Technical documentation, functional / unit testing / performance testing

Environment: Oracle 11g/10g, Oracle, PL/SQL, LINUX/UNIX, TOAD, Windows, OBIEE 10x

Confidential

Responsibilities:

• Involved in developing 12 Dashboards / 50 + answer reports for various business LOBs/ departments on project cost across sub LOBs.
• Created answer reports using different Views (Pivot Table, Chart and Column Selector, report selector), with drill-down and drill across capabilities, guided navigation and dashboard and page prompts.
• Designed and Developed OBIEE Repository at 3 layers i.e., Physical Layer (connecting to Data Warehouse & imported objects with joins), Business Model / data mapping (created Logical tables, level based hierarchies, parent-child hierarchies, complex joins, content levels, content filters and setting up multiple logical sources to support teh snow flake schema from physical layer) and Presentation Layer level (created presentation catalogs, folders, setup permissions test and validate teh model).
• Responsible for full cycle Implementation of OBIEE
• Implemented Dimensional Hierarchies, Aggregate navigation and other various features to meet teh business requirements.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Designed and worked extensively on building teh data level and object level security model to support financials, projects and HR reports.
• Implemented Security by creating roles & web groups, External database table autantication
• Enabled Multi-user(MUDE) for users to works on teh same subject area in teh rpd
• Enabled Usage Tracking Table and Dashboards.
• Performance Tuning using optimization efforts such as re-organizing teh data, aggregate navigation, Cache Management, indexes, Oracle materialized views and reports changes
• Customization of look and feel (skin changes) of teh dashboard page by modifying OBIEE internal files in catalogue res folder for different dashboards.
• Design, configuration and documentation of Logical and Physical Data Model and PL/SQL ETL process.
• Database preparation in respect to DB objects / star schemas, ETL processing, business logic implementation in PL/SQL using oracle stored procedures/ function.
• Gathering and analyzing business requirements from various sources, ensuring teh needs and delivery feasibility and to provide better & enhanced reporting solution.

Environment: OBIEE 10.x, Oracle 10g, Oracle PL/SQL, Windows 2003 server for OBIEE

Confidential

Responsibilities:

• Responsible for teh full life cycle of teh warehouse from analysis through implementation into a production data warehouse
• Designing and developing scripts to extract fact and dimension data as files in UNIX system from source SQL server system and hence to Oracle database environment as external table.
• Extensive PL/SQL coding for processing teh data in Data warehouse system for business reporting needs.
• Designing and developing stored Package/Procedure/Functions in PL/SQL.
• Creating Shell scripts for automation and email notification.
• Unit testing and system testing.
• Creating Oracle Database objects based on teh requirement.
• Performance tuning of teh oracle process / SQL queries.
• Preparing technical documentation.
• Automating feeds to downstream systems as flat/excel file from database.
• Production Support of BEN Data warehouse, bug fixing, and enhancement.
• Create oracle Discoverer standard/ static reporting and support business to do adhoc reporting

Environment: Oracle 9i/10g, oracle PL/SQL, SQL Server 2005, UNIX, TOAD, oracle Discoverer

Confidential

Responsibilities:

• Involved in Design and development of new oracle Apps form from template form.
• Added validation and functional logic in teh forms PL/SQL code/ Trigger.
• Integration of forms in Oracle Apps system.
• Preparing technical documentation.
• Unit and system testing.

Environment: Oracle 8i/10g, Oracle Apps 11i, PL/SQL, UNIX, forms 6i

Confidential

Responsibilities:

• Analyzing response time of teh Oracle processes and server statistics (CPU Utilization) during teh test.
• Preparing performance test and result documentation.

Environment: Oracle 8i/10g, Oracle Apps 11i, PL/SQL, UNIX

Confidential

Responsibilities:

• Designing back end processing of campus recruitment ensuring teh applicant data flow from teh front end .NET application components into Oracle HRMS.
• Extensive PL/SQL and UNIX shell script coding.
• Develop PL\SQL packages\ procedures for IREC/ HR API calls for inserting data to iRecruitment / HRMS system. Teh wrapping SQL code executes these API packages sequentially.
• Development of shell scripts that executes SQL and manage email notifications through autosys in batch mode.
• Develop policies and test cases to ensure quality control by Validation Testing, Logical Testing, and functionality & Integration Testing for campus recruitment for iRecruitment/ HRMS requirement.

Environment: Oracle 8i/10g, Oracle Apps (HRMS), PL/SQL, UNIX

Oracle technical consultant

Confidential, PA

Responsibilities:

• Requirement analysis by interacting with teh business users.
• Involved in designing technical specification and individual screens of development
• Data analysis and functional QA of developed UI.
• Extensive coding in PL/SQL for developing program units and wrote PL/SQL codes for validation of data entered during data entry.
• Wrote block /form /item level Triggers, Forms level Procedures/Functions And stored Package/Procedure/Functions in PL/SQL and Database triggers
• Creating Packages, Stored Procedures and Stored Functions
• Unit testing of developed forms/reports and system testing
• Involved in SQL Tuning(Explain Plan),loading data into Oracle tables using SQL*Loader

Environment: UNIX (Sun Solaris), Windows NT/2000, Oracle 8i/10g.

Oracle Technical Consultant

Confidential, San Jose, CA

Responsibilities:

• Functional QA
• Production support, data analysis.
• Primary production support for applications.
• Working with application end users and business team to facilitate issue resolution
• Support and maintain production $U scheduled jobs.
• Analyze / troubleshoot functional / technical application issues. Identification of production bugs in teh applications.
• Design /develop technical solutions to production bugs identified.
• Requirement analysis and solution to support business needs / enhancement.

Environment: PL/SQL, SQL, Perl/CGI, TOAD 7.3, Oracle 8i