Summary:

• I am a Senior OBIEE technical consultant with around 10 years of experience in designing, building and customizing the OBIEE application Version 10.1.3.X 11.1.1.X and various data warehouse modules. I have good experience as an OBIA/OBIEE Technical Support Lead which includes managing the releases in the recent projects. I also have vast experience writing functional documentation as a Business Analyst as well as preparing and presenting the User Training Manuals. I have experience in managing the offshore and onsite teams as a Support Lead and in setting up and training the offshore support team. I am a very good team player and a quick learner. I have good communication and interpersonal skills. I am a quick learner and am open to new ideas. I not only remain motivated all the time but also motivate the team members by my abilities I have extensive experience working with Financial, Communication, Pharmaceutical and Insurance clients.

• Around 10 years of total IT experience in implementing end-to-end of various functionalities of Data Warehouse, Data Marts, Business Intelligence and Transactional applications.
• 10 years of extensive Business Intelligence and Data warehousing experience with using Oracle Business Intelligence and BI Publisher knowledge in DAC and Informatica.
• Expertise in design and development of Oracle Business Intelligence OBI Repository .rpd at three layers Physical Layer, Business Model Presentation Layer , Time Series Objects, configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Security Setup Data Level and Object Level using Oracle BI repository security , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers/iBots, creating Reports/Dashboards, cache monitor, and building OBIEE Repository.
• Developed many Reports using different Analytics Views Pivot Table, Chart, and Column Selector , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters. Extensively used OBIEE Delivers and iBots
• Worked extensively in Oracle BI Security, Web Object Security and Data Level security.
• Administering the OBIEE Dashboards and Reports, Data Visibility
• Executed the SQL queries using Sql developer
• Involved in writing SQL queries using Oracle 10g/11g
• Proficient experience in different Databases like Oracle and SQL Server
• Proficient in installation and configuration of all BI, ETL and data warehousing products.
• Good understanding of Data modeling tool Erwin
• Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Excellent Written and Verbal Skills Results oriented and Self- Starter looking for challenges Ability to rapidly learn and apply new technologies and improve processes Self motivated and results- oriented with solid work ethic.

TECHNICAL SUMMARY

• ERP: Oracle Financials R12/11i/11.3/10.7sc AP, FA, GL, AR.
• Oracle BI EE: Oracle BI Admin Tool, Answers Analysis , Dashboard, BI Publisher, and Delivers.
• Oracle BIA: Financial Analytics, SCM and Order Management Analytics, and HR Analytics.
• Databases: Oracle 11g/10g/9i/8i/8/7.x, Teradata 12, MySQL, MS SQL Server 6.5/7.0/2000.
• Platforms: Windows 2003/200.x Server, Windows XP, HP-Unix, Solaris-Unix, Linux and Novell 4.x
• Business Intelligence: Hyperion 9.3, OBIEE10g/11g, and OBIA 7.9.x
• Oracle Tools: SQL PLUS, SQL Loader, Forms/Reports6i, Oracle FSG, JDeveloper.
• Languages: SQL, PL/SQL, XML XSLT, XPATH, XQUERY , Java
• ETL: Informatica 7.9.5/8.6.1, Oracle Warehouse builder 10.2
• Platform: HP-UNIX, Solaris-UNIX, Linux, Windows Server, and Novell 4.x
• Version Control Tools: PVCS, Clear Case, HP Application Lifecycle Management
• IDE: TOAD7.6/9.5,Oracle SQL Developer.

EXPERIENCE:

Confidential

Position: Sr OBIEE Developer

• I am responsible for leading the Enterprise Business Reporting Team on implementing and developing Business Intelligence applications using Oracle Business Intelligence Enterprise Edition OBIEE 11g. Worked with BI Publisher, Interactive Dashboards, Analytics, and SQL for DOD Federal Agency supporting is Civilian Personnel Management Service now known Defense Civilian Personnel Advisory.

• Worked closely with all levels of user community, technical staff and application development software staff to ensure successful project implementation, including but not limited to: requirements gathering, understanding the business process, and ensuring projects fit into the goals of the Department.
• Developed solutions for operational reports using OBIEE Answers/Dashboard. Involved in code review, code migration to both test and production environments.
• Configured OBIEE Repository Physical, business and presentation layer to provide Analytical Reporting solutions to business.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features.
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs.
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
• Used several OBI reporting features Navigational, Drill Down, Drill Across, Guided Navigation, and Security. etc .
• Developed and tune SQL queries as needed to support data initiatives.
• Utilized Cascading Style Sheets and other HTML methodologies, wrap OBIEE objects into web pages.
• Resolve system issues through thorough problem analysis and/or effective user interaction.
• Provided some technical knowledge to direct and coordinate system analysts and programmers in their related activities.
• Completed assigned training and other task as assigned by management.
• Prepared project feasibility studies, compute time and cost estimates, human resources and equipment requirements.
• Developed testing plans for unit and/or system tests and create unit and/or system test data.
• Analyzed requirements, implemented prebuilt business intelligence solutions using the Oracle Business Intelligence Analytics platform

• Extensively used page prompts and dashboard prompts for filtering data values in financial reports

• Created drill down charts and drill down tables to gather more information on Financial Analytics and Supply Chain using navigation
• Used LDAP Server for Security Authentication.
• Created security settings to setup groups, query privileges and access privileges
• Coordinated the OBIEE RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Created reports with PDF, RTF and Excel templates using the BI Publisher.
• Delivers Ibots are created and scheduled.
• Performance tuning on the Dashboards and Answers.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the Adhoc report according to the client needs.
• Successfully configured OBIEE EBS for oracle BI Applications.
• Configured the Extract date, Global Currencies, Exchange Rate Types, and Fiscal Calendar.
• Performed the necessary impact analysis in upgrading the OAS to Oracle WebLogic 11g environments as far as the web server technologies are concerned thereby, ensuring that present functionality exists for all the CPMS applications.
• Performed the configuration of the OAS and WebLogic 11g servers, including the server and client-based secure socket layer SSL configurations using X509 and CAC-based authentication.
• Created any new Windows Server-based OBIEE or Oracle BI Publisher Suite environment based on customer priorities.
• Tested new enhancements and changes as a part of our OBIEE test bed environment
• Designed and Documented Requirements for DIUCS v.3 as needed.
• Implemented Oracle Database and Middle-Tier Changes to Accommodate DIUCS v3
• Worked with DBA resources to support Database Replication across Servers.

Environment: OBIA Apps Version is 7.9.6.3 OBIEE 11.1.1.7.1, Informatica Version and Hotfix is 9.0.1 Hotfix 2, DAC Version is 10.1.3.4.1 , Source System is PeopleSoft Financials 9.1 on an 11.2.0.2 Oracle Database, Data Warehouse Database EDWP is Oracle 11.2.0.3

Confidential

Sr OBIEE Developer

• I was in the Enterprise Business Reporting Team on implementing Oracle Business Intelligence Enterprise Edition OBIEE for CMS DECC contract that is over 300.00 mil in design / development / consolidation program to improve health care quality for ESRD Medicare Medicaid Beneficiaries.

• Developed OBIEE Repository per user requirements and available information in DW.
• Implemented security by creating roles and web groups, checks with External tables and LDAP.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager. Version 8.6
• Extensively used OBIEE Admin tool to import the required objects Dimensions and Facts with integrity constraints into Physical Layer using connection pool
• Developed multiple Dimensions Drill-Down Hierarchies and Logical and Facts / Measures objects in Business Model Layer, and has successfully created the Presentation catalogs in Presentation Layer.
• Developed Dashboards such as Default Dashboard for the users when after login directed to a default dashboard based on the department they work
• Successfully developed row based calculations in a pivot table for the reports based on sales RPD.
• Created session variables for users to provide row- level data level security and used the session variable in OBIEE answers to build the query.
• Had developed chart and tabular reports for the total sales for Quarterly, half-yearly and annually using global and local filters.
• Scheduled iBots and seeded server cache using Delivers to improve system performance.
• Developed iBots such as Purge to clear server cache using nqcmd utility and had developed Scheduled reports to be e-mailed using iBots.
• Developed and debugged Dashboards/ reports visibility with respect to user's responsibility and web groups in an integrated environment.
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Have used Administration Tool configure Multiuser Development Environment MUDE for multiple users for the development environment.
• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.

Environment: OBIA Apps Version is 7.9.6.3 OBIEE 11.1.1.7.1, Informatica Version and Hotfix is 9.0.1 Hotfix 2, DAC Version is 10.1.3.4.1 , Source System is PeopleSoft Financials 9.1 on an 11.2.0.2 Oracle Database, Data Warehouse Database EDWP is Oracle 11.2.0.3

Confidential

Position: Sr OBIEE Developer

• Cox Communications is one of the most established corporations in USA. The requirement of the client was to deliver a business solution to the Finance users to provide insight into the financial reporting. Our initial project was to offer a demonstration of OBIEE capabilities using internal data from different sources that custom designed dashboards.

• Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.
• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Used the OBIEE Admin Tool to develop the three layers in the Repository.
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked extensively on OBIEE Answers to create the reports as per the client requirements.
• Defined additional views compound, table, chart views of the data returned by the request to visualize data in many different ways.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Created Proactive agents iBots and configured Interactive dashboards to alert the employees as per the requirements.
• Built parameter page using image prompts that enables users to visually select the input parameters.
• Created groups in the repository and added user to the groups and granted privileges explicitly through group inheritance.
• Enabled Single Sign On for OBIEE to allow authorized users to login automatically to OBIEE without entering user credentials.
• Worked extensively on performance tuning including creating aggregate tables, caching and event polling tables.
• Created custom CSS classes and styles, java scripts and HTML scripts to enhance the dashboard functionality and produce reports that meet user requirements.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
• Worked on improving the dashboard performance, readability, and security.

Environment: OBIEE 10.1.3, Windows 2003, Oracle 9.0.2, PL/SQL, SQL Server, TOAD, DAC, OLAP

Confidential

Position: Senior Oracle Applications Developer

• In this position he is responsible for implementation of OBIEE for United Health Group manages Medicare and Medicaid in all states. Reporting to the Vice President of Information Technology my functions included strategizing, planning, architecting, designing, developing and administrating OBIEE repository and dashboards, corporate data warehouse and data marts over multiple project lifecycles from requirements gathering through production support. I functioned as a lead architect, advisor and developer on multiple OBIEE and data warehouse projects.
• Designed, developed and maintaining Hyperion reporting across Hyperion Interactive Reporting, Web Analysis, SmartView and Financial Reporting.
• OBIEE-BIP development and support for the client. Configuring EBS-BIP bursting for reports in Oracle EBS 11.5.10.2.
• Oracle E-Business support with Forms personalizations, CUSTOM.pll mods, Reports, and XML Publisher templates.
• SQL tuning for reports running slow and PL/SQL packages using SQLTXPLAIN, TKPROF, EXPLAIN plan, applying indexing and HINTS.
• Developed a PL/SQL package to upload data to a custom table, refreshing some materialized views from the PL/SQL package using a Hyperion report query.
• Created Hyperion .oce files, Data Models, and Reports using Hyperion Interactive Reporting Studio.
• OBIEE Implementation Fit GAP analysis to compare the existing Business Intelligence and Reporting Tools to assess the gaps with what OBIEE offers. Documenting OBIEE implementation infrastructural requirements including hardware and environmental prerequisites.
• Designing ETL Data Flow Mappings using OWB for data integration preparing a data warehouse creating mapping from source systems to Data warehouse targets from Oracle R12 EBS applications database and several other data sources.
• Testing and debugging Mappings using mapping debugger is embedded in the OWB Mapping Editor.
• Deploying Objects in the Target Warehouse deployed the external tables, the dimensions, the cube, and ETL mappings.
• Created Reusable Transformations Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalize and Rank and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Created Reusable Tasks Sessions, Command, Email and Non-Reusable Tasks Decision, Event Wait, Event Raise, Timer, Assignment, Control .
• Installed OBIEE platform on Linux, BI applications onto OBIEE platform for Release 12 Financials, Procurement, Supply Chain, and HR , Informatica, and DAC.
• Restored out of the box Informatica Repository and DAC Repository. Performed extensions and customizations to the RPD, Reports and Dashboards
• Customized data models and designed additional Subject Areas to support extensions. Extensive performance tuning with data volume, table partitions, fragmentation and Caching concepts within OBIEE
• Training and mentor support to OBIEE Developers, and end-users.
• Used the Data Warehouse Administration Console DAC to configure, manage, and load the Oracle Business Analytics Warehouse.

Confidential

Position: Oracle Developer

• In this position I was responsible for developing and supporting Microtune's Oracle environment. This oracle environment was comprised of oracle E-Business 11i/R12 financials, manufacturing, and Oracle business Intelligence Enterprise Edition OBIEE .
• Conducted a High-Level Gap Analysis for 11i/R12 upgrade that is projected to be started early 2010.
• Developed GL daily conversion rates SQL LOADER program and a PL/SQL package to validate daily forex conversion rates and upload rates into the GL Daily Rates Interface along with MD50/MD70.
• Created a new set of books defining value sets, Accounting Flexfield Structure, segments, Flexfield qualifiers, Security rules, cross-validation, accounting Calendar, and responsibilities associated with the set of books and the MO: operating unit. Oracle Application Express APEX3.2 : developing forms and Reports on 10g.
• Configured Oracle Payables Financial options, Payables options, Internal and external banks, payment programs, created Distribution Sets, and Payment Terms along with an AIM BR100 document.
• Configured Oracle Assets- Defined assets corporate books, tax books, asset key Flexfield, category Key Flexfield, and location Flexfield. Defined Prorate Calendar and conventions, setting up Asset Book Controls, Asset Categories, Fiscal Years, Calendars, System Controls, and depreciation methods.
• Converted standard AR customer invoice report and print statement reports into xml templates in BI publisher and developed xml bursting control files for these reports to be emailed directly to customers print the ones for customers without emails in our system, and archiving copies of these documents in SharePoint.
• Customized several standard oracle reports6i Pick Slip Report, Proforma Invoice, Sales Order Acknowledgement, Invoice Print Selected Invoice and developed custom reports we later converted into XML templates.
• Oracle Application Server 10g- implemented and configured application server for OBIEE oc4j and HTTP Server . Implemented Noetix Generator for OBIEE automatically creating the Enterprise Information Model for our Oracle E-Business Suite.
• Time series modeling and dimensional hierarchy Modeling, created calculated logical columns.
• Integrating with Oracle BI EE Delivers Alerts-modifying instanceconfig.xml and credentialstore.xml
• Integrated Oracle-BIEE with Oracle E-Business Suite 11i R12 to enable Single Sign-On through Oracle E-Business suite application using existing user accounts.
• Migrated Oracle Business Intelligence Discoverer Discoverer metadata to Oracle Business Intelligence Suite Enterprise Edition Oracle BI EE , using the Oracle Discoverer Metadata Conversion Assistant.
• Exported Discoverer End User Layer EUL to create an .eex file by using Discoverer Administrator.
• Used MigrateEul.exe file for the migration and MigrationConfig.properties file to control the migration behavior helps with maintaining joins and recovering joins dropped during migration .
• Developed Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Narrative View, Dashboard Prompts and Variables.
• Setting up a Multi-User Development Environment MUDE .
• Built time and calculated measures for a fact table and created dimension hierarchies and level -based measures

Confidential

Position: Oracle Applications

• This was an Applications operations and Development support for CitiCapital two Oracle E-Business Suite 11i/R12 applications instances running AP, PO, FA, GL AND HR modules, and OBIEE-OBIA.
• Managed a team of contractor Oracle developers, some onsite and some offshore in India.
• Gathering, refining, and documentation of the business rules, functional and technical requirements.
• Performed Fit GAP analysis and prepared solution presentation for review.
• Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
• Leading assigned projects providing project planning and administration, issue resolution, monitoring project progress to plan, and obtaining and distributing project status.
• Interfacing with management on all Oracle EBS project related issues, changes, reporting and impacts ensuring that comprehensive information is provided to all stakeholders in a timely manner.
• Managed changes to project scope, requirements, design, resources, functionality and risk. Performing various administrative tasks as directed.
• Manage Oracle Applications Systems Administration Security, Profiles, Concurrent Managers, Printers, Responsibilities, Menus, Functions, and registering the new objects in Oracle applications.
• Performed a pilot on OBIEE, and later lead the OBIEE implementation with OBIA Analytics for financials, Procurement, and HR.
• Install and configure OBIEE 10.1.3.3 on Linux.
• Restored out of the box Informatica Repository and DAC Repository for Financials and Procurement.
• ETL-Configured Informatica Repository and integration Services created users in Informatica Admin Console and used client tools to customize OOTB ETL mappings, workflows, transformations and DAC.
• Configured Oracle Business Intelligence Applications for Financial Analytics for Oracle EBS and other custom Source Systems. Used DAC to configure the list and types of Ledgers R12 /set of books 11i from which to extract the GL data.
• Customized repository .rpd , in the Business Model Layer Physical Data Model and Web Catalog Objects as per the data requirements using OBI Admin tool. Configured the NQSCONFIG.INI file for Usage Tracking using direct insertion.
• Developed various Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Narrative View, Dashboard Prompts and Variables. . Setting up a Multi-User Development Environment MUDE .
• Created BI Publisher Reports based on various data source BI Answers / BI Server Subject Area / Web Services/ HTTP Data Set / File Data Set. .Built time and calculated measures for a fact table and created dimension hierarchies and level-based measures.
• Used DAC to configure domain values for Oracle Receivables and Payables Analytics.
• Configured Transaction Types for Oracle General Ledger and Profitability Analytics for Oracle EBS R12.
• Used UNIX shell programming for Converting FTP scripts into NDM scripts and writing new scripts for oracle job scheduling and file transfer automation.