SUMMARY

TECHNICAL SUMMARY
OLAP Tools: OBIEE 11g/10.1.3.2/10.1.3.3/10.1.3.4, OBIA, BI / XML Publisher,
Siebel Analytics 7.8.2, Hyperion Essbase 9.3.1
Oracle E-Business: Oracle 11.5.9, 11.5.10.2 (GL, AP, AR, PO)
Oracle Tools: Oracle Discoverer10g, Discoverer 4i, Developer 6i (Reports Builder 6.0.8, Forms Version 6.0.8), SQL*Plus, SQL*Loader, PL/SQL, Oracle Designer/2000
RDBMS: Oracle Versions 7, 8i, 9i, 10g
ETL Tools: Informatica Power Center, Informatica PowerMart , DAC, Oracle Warehouse Builder
Languages: C, SQL, HTML4.0, VBScript5.0, Java/J2EE/Java Script, XML
Software: MS Word, MS Excel, Visio, PowerPoint, FrontPage, Access, MS Project, Visio, SharePoint, Toad6.2, PVCS6.5
O/S: HP–UX, MS–DOS, UNIX, Linux, Windows XP, NT, 98, 2000

PROFESSIONAL SUMMARY

• Around 7+ years of experience in Complete Software Development Life Cycle (SDLC) implementation of various Business Intelligence and Data Warehouse / Data Marts that covers gathering Business Requirements, Design / Modeling (Star and Snow flake), Development, Testing, Implementations and Documentation
• Experience in installing, configuring OBIEE, OBI Apps, Informatica and DAC
• Extensive Business Intelligence experience using OBIA 7.9.x, Oracle BIEE 10.1.3.X, Siebel Analytics 7.x and Informatica 8.x/7.x/6.x
• Very strong experience in developing OBIEE / Siebel Analytics Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using page and dashboard prompts, Security Setup (groups, object and data level), LDAP, External Tables, configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots
• Slice and Dice data using filters and used pivot tables and charts for better presentation
• Customized and developed repository, configured metadata objects (Subject area table column) and Web Catalog Objects (Dashboards, Pages, Folders, Reports)
• Experience in developing Informatica Mappings / Mapplets using various transformations for ETL of data from Multiple Sources to Data Warehouse
• Working knowledge of Disconnected Analytics and BI Publisher
• Developed and configured various Interactive Dashboards with drill-down capabilities, Dashboard Prompts and Contextual Guided Navigation links
• Experience in extracting data from Siebel CRM, Oracle EBS and integrating, loading data to OLAP systems
• Expertise in debugging, optimizing the Performance Tuning of Oracle BI / Siebel Analytics Repository & Dashboards / Reports and Informatica / Mappings / Workflows
• Experience in setting up a Multi-User Development Environment (MUDE)
• Developed automation tools to seed and purge the cache in Admin tool
• Experience in DAC to configure, monitor and schedule ETL routines
• ImplementedUsage trackingto analyze and tune the query performance
• Multi-Platform experience on UNIX / Linux and Windows Server family of products
• Business Analysis experience with excellent communication & interpersonal skills, broad understanding of business operations and requirements

EXPERIENCE

Confidential,Los Angeles, CA. 02/2011 – Present
Sr. OBIEE Admin/Developer

Environment: Business Planning & Forecasting – Revenue, School Reports & Operating Planning project for implementing Oracle Business Intelligence & Oracle BI Integrated Planning solution for LAUSD. Oracle Business Intelligence Enterprise Edition (OBIEE 10.1.3.4), Oracle R12 (GL, AP, AR, TCA, PO, FA), Oracle 10g, SQL, PL/SQL, Oracle Warehouse Builder (11gR2), Oracle Express Reports, Discoverer, BI Publisher, Unix, Toad, SQL Plus, SQL Loader, JIRA (Atlassian)

Responsibilities:

• Developing District, School, Classroom, Teacher and Student level dashboards, reports and performance records
• Introduced, Implemented, Trained and Administered MUDE (Multi User Development Environment) in the company RPD development process
• Worked in testing the existing reports in 11g for future implementation process
• Assisted developers in understanding and using MUDE development
• Worked as an Admin in deployment, maintenance and security of RPD in UNIX environment
• Worked in RPD development, RPD migrations, Security setup, creating variables, dashboards, reports, answers and prompts
• Worked on prompt and row level security
• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects
• Involved and assisted BI’s in testing and bug fixing RPD, Reports and Dashboard issues using JIRA
• Involved in performance tuning of the existing reports by using aggregation levels, summary tables and materialized views
• Involved and assisted in ETL development, applying business rules according to user requirement, mappings and testing
• Bug fixing and debugging using TOAD and SQL developer
• Implementing level based security in Classroom and School Level reports according to the requirements at different levels (Principal, District Admin, Teacher, Dean etc)
• Developed new Star and Snowflake schemas and also altered existing schemas for better performance
• Worked on Standardizing and clearing all the unused schemas in RPD and also from catalog
• Helped and assisted Users and Director during the new release(project) planning and developments

Confidential,Chicago, IL. 11/2010 – 01/2011
Sr. OBIEE Developer

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE 10.1.3.4), Oracle R12 (GL, AP, AR, TCA, PO, FA), Oracle 10g, SQL, PL/SQL, OBIA/BI APPS 7.9.6.1(Financial Analytics, Supply chain, Order Management Procurement and Spend Analytics), DAC 10.1.3.4.1, Informatica Power center 8.6, Toad Data Modeler 3.5, Forms 6i, Reports 6i,SQL*Loader, Toad, Unix Shell Scripts
Responsibilities:

• Worked on Standardization project of all the Oracle Business Suite Applications (AP, GL, FA, AR, PO, etc)
• Involved in changing all the modules depending upon the standard requirement according to the client specifications
• Involved in Repository (RPD) Development and Updating after the Standardization changes which includes building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business Model and Mapping layer. Established the logical joins/keys required to support drill-down aggregation
• Made Standardization changes in RPD(Presentation and Business model layers) and altered and tested the joins to make sure reports does not break
• Also made similar standardization naming changes to the reports using Catalog Manager XML search and replace and manually making changes to the XML code in the reports
• Also made front end cosmetic and font changes to the reports and dashboards depending on specifications
• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects
• Worked extensively on the Oracle BI Admin Tool to create the Physical, Business and Presentation Layers of the RPD using the Multi User Development Environment (MUDE) in OBIEE
• Migrated web catalog by using Catalog Manager from one instance to another
• Was involved in Unit, Integration and System testing and performed data validation for the reports generated using Informatica and OBIEE
• Involved and assisted BI’s in testing and fixing RPD, Reports and Dashboard errors for Standardization Project
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client

Confidential,Charlotte, NC. 10/2007 – 10/2010
OBIEE Developer

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE 10.1.3.4), Oracle Discoverer10g, SQL, PL/SQL, Oracle E-Business Suite 11.5.10.2 (GL, AP, PO, AR), Microsoft projects, office products
Responsibilities:

• End-to-End Oracle Discoverer operations and support for Oracle E-Business. Custom extensions, security, troubleshoot, end-user support, worksheet/workbook development, migrations, performance tuning, training and daily maintenance of the application
• Managed security access to users and responsibilities to the EUL using Discoverer Administrator tool
• Experience creating worksheets and workbooks with Discoverer Desktop and Discoverer Plus
• Modified and extended Oracle pre-delivered 10g EUL for Oracle EBS 11i using Discoverer Administrator
• Experience in migrating the changes to the UAL to Production
• Participated in Discoverer to OBIEE migration effort in early spring 2009
• Gathered requirements, analysis, task management, and end-user support in the migration of Oracle Discoverer10g over to OBIEE (formerly Siebel Analytics) solution
• Prepared Functional requirement documents, performed design and solution review with OBIEE technical consultants
• Supported development and issues with EUL migration over to OBIEE Repository
• Custom development and extensions to OBIEE repository, re-do hierarchies, security model using initialization block and session variables
• Created Answers Reports and Dashboards to support development
• Setup Catalog security for Management and Analysts
• Investigated, analyzed, and resolved application problems along with data reconciliations
• Organized testing schedules and test scripts. Managed execution and sign-off tests
• Planned and supported end-user training sessions on the new product, prepared and managed operations run book for continued support
• Migration support from Development to UAT to Production

Confidential,Moline, IL. 03/2006 – 09/2007
BI Consultant

Environment: Oracle 11.5.10(AP, AR, GL, FA, Purchasing (PO), OM ,Service contracts (CRM),AOL), OBIEE 10.1.3.2, Siebel Analytics 7.x, OBIA/BI APPS 7.9.4 ,DAC, Informatica 8.1.1, 7.x, Oracle 9i, 10g, TOAD, SQL, PL/SQL, Forms 6i,Reports 6i, Discoverer 10g, XML/BI publisher 5.6.3, Workflow Builder 2.6, SQL, SQL*Loader, UNIX Shell Scripts.
Resource Administration:

• Complete resource administration from picking up orders, to fulfillment of orders, to recruiting, on-boarding, and resource management
• Maintained and updated various State and Federal Human Resources compliance documents
• Preparation and maintenance of employee/contractor related documentation
• Provided recruiting support including all tasks associated with on-boarding an employee/contractor
• Performed as a SharePoint Administrator in maintaining HR Corporate repository

Sales Support:

• End-to-End sales support from proposal writing, proposal workflow management, preparation of SOWs, and support recruiting for the same
• Identify key resources, assign tasks to deliver content for Proposals
• Manage tasks, consolidate content, finalize Proposals/SOWs, etc. to Sales

Responsibilities:

• Involved in the full life cycle implementation of Invoices Tracking Analytics Application used by Accounting Team to monitor the invoices made to Point-of-Sale (POS) customers, Commercial / Business customers and third-parties
• Interacted with Billing and Account Receivables Subject Matter Experts (SME), Stake Holders, Business Analysts and Key Business Users in gathering the Analytics / Reports Requirements
• Participated in the installation and configuration of Oracle BI EE 10.x in the windows as well as the Linux environment
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository
• Developed Dashboards / Reports using different Views (Pivot Table, Chart and Column Selector), with drill-down and drill across capabilities, guided navigation and dashboard and page prompts
• Performance Tuning using optimization efforts such as re-organizing the data, aggregate navigation, Cache Management, indexes, Oracle materialized views and reports changes
• Involved in Reconciliation Process Oracle BI Reports output with Excel Reports
• Worked with ETL Team for enhancement to Facts / Dimensions in developing the Initial and Incremental ETL process
• Developed Informatica Mappings using various transformations for ETL enhancements of Items, Components Cost and Vendors information
• Implemented the session partitions (Database and Informatica) for performance issues

Confidential, 09/2003 – 10/2005
Discoverer Consultant

Environment: Discoverer4i, SQL, Reporting Data Warehouse, Oracle based Order Management transactional application support

Responsibilities:

• Assisted with data interpretation, analyze business requirements, problems and available technologies to define systems solutions to assist management with decision–making
• Identified emerging issues and opportunities to management and make recommendations for correction action
• Maintained existing metrics and continuously identify process improvement opportunities where possible
• Worked closely with other Operation units and Business Units to create efficient and timely reporting to meet needs on a daily, weekly, monthly and ad hoc basis
• Interfaced with System Developers and Programmers in developing reporting/Business Intelligence solutions using Discoverer4i as the reporting tool, and custom data warehouse solution using PL/SQL and SQL*Loader
• Worked extensively with Discoverer Plus to create workbooks, drill–down functionality, drill–across etc. to cater to Management reporting needs
• Participated in Testing and Quality Assurance functions
• Mentored/trained other users on Discoverer functionality

Confidential,India.
Application Consultant 01/2003 – 08/2003
Project: Interface Development
Description: Confidential,is a government organization to manufacture and assemble Defense related parts. My involvement in this project is mainly with Sys Administration, AOL, Workflow, OE, AR and GL modules.
Environment: C Oracle Applications Release 10.0.3, XML Publisher, Business Objects, Sql Loader, Oracle Toad, Forms 6i, Reports 6i,Windows NT, Unix.
Responsibilities:

• Developed and implemented RICE components
• Designed and developed the interface for Customer details that loads data from legacy systems into Oracle Receivables
• Assigned new users with privileges by using system Administration to which were attached specific menus, data groups, and request groups through responsibility for restricted end user access
• Developed executive level Forms and reports for Invoice details by customer, by item, by product type using Oracle Forms, Reports, and Business Objects
• Converted several custom Oracle Reports, into XML Publisher templates. Some examples include Finance reports (Budgets VS Actuals), Payables Invoice Registry reports, Checks, and Purchase Order templates
• Involved in creating various reports, which includes Tabular, Group by matrix and Form Letter types.
• Data Conversion Converting the existing Data like Customer Data, Account Details, GL Balance Transfer
• Imported Legacy Journals into General Ledger using SQL*Loader, GL Interface and Journal Import.

EDUCATION
Bachelor of Technology
Oracle 9i certified DBA
TRAINING
OBIEE workshop on Server Architecture, Answers and Dashboards from Oracle/Metric Sphere
Data Modeling and Data Warehousing concepts
ERWIN and Informatica Tools
Oracle Version 7 Server Database Administration I
Internet Expert (HTML4.0, VBScript5.0, ASP2.0, Microsoft Visual InterDev)