SUMMARY

• 10+ 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, GAP Analysis, Design/ Modeling (Star and Snow flake), Development, Testing, Implementations and Documentation.
• 5 +Years of work experience on OBIEE and BI Publisher/XML Publisher
• 3 Years of hands - on experience on ELT & ETL Tools like Oracle Data Integrator (ODI) and Informatica
• 5 years of hands on experience on Oracle ERP modules like INV, PO, OM, BOM, WIP, AP, AR and GL
• Strong experience in developing warehousing applications and customizing Reports using OBIEE 12c, 11.1.1.x, 10.1.3.4.x/10.1.3.2.x, XML/BI Publisher.
• Experience in providing end-to-end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling.
• Experienced in developing stored procedures, functions, packages and database triggers using Oracle SQL Developer and PL/SQL to improve query performance.
• Strong SQL knowledge. Familiar with creating queries, tables, views and other relational objects, and maintaining the referential and data integrity.
• Expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
• Expertise in Fit Gap analysis to gather, define and document business requirements. Both for Data warehouse models and Business intelligence models.
• Worked on Installation and configuration of Financials, Supply Chain Analytics, Procurement and Spend Analytics, HR Analytics, Manufacturing Analytics and Order Management Analytics.
• Experience in data warehousing such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification, and OLAP.
• Expertise in developing Custom Reports and Implementing Projects in FSM for BIAPPS Configurations
• Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, Access privileges, LDAP authentication setup, External table and configuration of Multiuser Development Environment.
• Migrated Repository and Web Catalog from one environment to another environment.
• Experience in creating and using Initialization blocks, Dynamic, Static, and Session Variables.
• Strong experience in OBIEE Administration and developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
• Successfully configured Interactive dashboards to alert the Business/Field users as per the requirements.
• Extensively used Presentation variables in FILTER function in the report, to filter each report based on the user requirements.
• Implemented Multi-user Development Environment (MUDE) Using Oracle BI Administration Tool.
• Devised strategy for refreshing reports Query caching. Optimized database indexes and run statistics process for enhancing query performance.
• Worked on ETL configuration files related to GL Account .ora files in ETL source Directory.
• Expertise in implementing Oracle BI Apps in all phases like implementing, Designing ETL, metadata management using DAC, Creating Oracle provided Data Warehouse, OBIEE RPD development, OBIEE reports and Dashboards.
• Strong experience in developing and customizing Reports and Forms using OBIEE 10.1.3.x/11.1.1.x.
• Experience in supporting the production system and handling day-to-day issues.
• Experience in training business users on OBIEE Answers and Dashboards and educating technical super users and administrators on repository and web catalog migrations procedures with Oracle best practices.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self-motivated to work independently with excellent communication skills.
• Vast experience in designing, developing and tuning complex mappings from varied transformation logic like lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Rank etc.
• Migrated Repository and Web Catalog from one environment to another environment.
• Experience in creating and using Initialization blocks, Dynamic, Static, and Session Variables.
• Experience in XML/BI Publisher, which includes working on report development objects like data templates and RTFs.
• Devised strategy for refreshing reports Query caching. Optimized database indexes and run statistics process for enhancing query performance.
• Worked on BIACM and FSM to set up tasks related to biapps configurations
• Experience in supporting the production system and handling day-to-day issues.
• Created numerous Interfaces to load data from Flat files, CSV files, and Oracle tables into staging tables and then into respective FACT/DIMENSION/Look-up Tables in Data Warehouse.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self-motivated to work independently with excellent communication skills.
• Extensively worked on Oracle Data Integrator (ODI) Topology manager, Designer, Operator.
• Created various data integration project components Interfaces, Packages, Procedures using Oracle Data Integrator’s Designer.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses.
• Experienced in Installing and Configuring Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic.
• Upgrades, performing source-to-target mappings, storage capacity planning and developing ETL.
• Good conceptual knowledge and experience in creating ODI scenarios and scheduled using agents at regular intervals.
• Strong Knowledge in using various knowledge modules and customizing knowledge modules.
• Strong knowledge and Experience on ODI jobs monitoring, debugging any failed jobs and production support using ODI’s Operator.

TECHNICAL SKILLS

Application Tools: OBIEE 12C, OBIEE, 11.1.1.1.7/.8/.9/.10 , OBIEE 10G/11G, OBIA 7.9.6/9.5,BIP/XMLP 10G/11G, Hyperion Brio 8, Tableau 8/9,Oracle Report Builder 8,SSRS 2008/10

Databases & Tools: Oracle 12c/11g/10g/9i/8i/7.x, SQL Server 2005/08/10, TOAD, SQL*PLUS, SQL Developer, SQL* Loader, EBS 11g, EBS R12,Essbase

Modules: EBS,(Financial, Supply Chain, Procurement and Spend, HR,Order Management) Analytics,ORDM Analytics,POS,Success Factors

Scripting Languages: Unix Shell scripts.

Languages: SQL, PL/SQL, XML

Operating System: Unix, Linux, Windows NT/XP/2000/98.

ETL Tools: ODI 11g/12C, Informatica 9.1/8.6/7.x/6.x, SSIS 2005/08/10

Methodologies: Dimensional Data Modeling Logical / Physical,(ERWIN, Visio) Tools

PROFESSIONAL EXPERIENCE

Confidential, Winston Salem, NC

Sr OBIEE Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, used various data sources, development and implementation of the project.
• Experience in providing end-to-end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling.
• Provide support in OBIEE architecture of the organization through database design, modeling and implementation
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
• Responsible for updating/ tracking and documenting the development changes at both ETL level and rpd level.
• Developed, configured and tested report in the Dashboard and configured theadhocreport according to the client needs.
• Customized business reports usingBI Answers as per requirements.
• Migrated Test Code from Development to QA and QA to Production of Repository, Dashboard Reports, Informatica mappings and workflows.
• Hands on experience in the administration of creating new ids, Account modification of existing users, Password reset and Deletion of accounts.
• Managing OBIEE presentation services and object catalogs for multiple sets of business models and subject areas in a cluster environment.
• Implemented complex integration/use case of Oracle products.
• Performed Cache Management.
• Developed RPD creation by including all the functional requirements and Working extensively in Answers and Dashboards.
• Experience in Deployment, Migration and upgrades of RPD and Web Catalog across instances and environment.
• Worked on hierarchies, level based measures and time series calculations in the repository (RPD)
• Developed Delivers iBots/Agents to automate report delivery and provide alerts on Interactive Dashboards.
• Implemented various Repository Variables and System Variables depending up on user requirements.
• Have performed several product related customization to alter out of the box product behavior.
• Took the ownership of upgrade activity in client environment from OBIEE 11g to OBIEE 12c version and fixed multiple migration issues in the process.
• Involved in diagnosing and fixing ODI 11g mappings failure during the load run.
• Responsible for building and maintaining client relationships-managing operational challenges and building efficiencies in the process.
• Implemented Aggregate tables for better Performance. Enhance performance by managing Cache management.
• Configured Agents to send the Reports through Emails to the user group.
• Used presentation variable in OBIEE Answers to save prompt values and use them for conditional formatting.
• Sorted data values, applied sorts to members, measures, and rows in views such as tables, pivot tables, graphs, and maps.

Environment: EBS R12, ODI 11g, Unix, OBIEE 11.1.1.9 OBIEE 12c,BI Account Manager, Function Setup manager, ODI Console, Service Module, Power Center 9.1,SQL Server 2008/10

Confidential

Sr Technical Consultant

Responsibilities:

• Involved in requirements gathering, analysis, design, used various data sources, development and implementation of the project.
• Experience in developing OBIEE Repository at three layers (Physical Layer, Business Model & Mapping Layer and Presentation layer) - Import tables, Identifying Facts, Dimensions, created physical tables, join the tables, creating the logical tables and logical columns.
• Worked on Dimensional Hierarchies, Drill down, Level Based and Time series Functions based on Business Requirements.
• Worked on Repository Variables and Session Variables and Presentation variables.
• Implemented Aggregate tables for better Performance. Enhance performance by managing Cache management.
• Worked on session variables and dynamic variables along with initialization blocks.
• Configured many dashboards with different views like Pivot table, Chart, Tabular and View Selector and guided navigation links.
• Worked extensively on Oracle BI Answers, Delivers and Interactive Dashboards.
• Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.
• Designed Dashboards Prompts, Pages, links, Images, Embedded content, Text, Folders and Guided navigation links as per Business requirements.
• Perform Unit Testing and validating the repository. Worked on BI Publisher reports.
• Utilized Aggregation to improve query performance
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Configured groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Configured different types of Reports Drilldown techniques, Aggregation rules to meet client requirements.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
• Generated various Analytics Reports using global and local filters.
• Configured Connection Pools, defined joins and implemented authorizations in the physical layer of the repository.
• Performed initial ODI load from EBS (ODS) to BI DW tables by using initial extract dates.
• Created business reports using BI Answers as per requirements.
• Set up Incremental load plans by using ODI along with email notifications.
• Configured Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Worked with QA team in writing the appropriate test scenarios
• Used the Oracle BI Presentation Catalog in order to perform basic tasks such as creating, deleting, and copying objects and folders and Performed object-specific tasks like modifying settings Creating/ assigning an agent
• Analyzed, Designed, and Developed OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• Used Table and pivot table to display hierarchical columns.

Environment: EBS 12.2.2,ODI 11g, Unix, Oracle r12,OBIEE 11.1.1.10BI Account Manager, Function Setup manager, ODI Console, Financial and Supply Chain analytics.

Confidential, San Jose, CA

Sr Software Engineer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Preparing MD70, MD120 and TE20 as per the functional design
• Installation, Configuration and Administration of OBIEE, Informatica and Data warehouse Administration Console (DAC).
• Performed the gap analysis, Identified Facts and Dimensions (with levels & hierarchy) and made required changes to the Data Model (Physical, Business and Presentation layer).
• Extensively used page prompts and dashboard prompts for filtering data values in financial reports.
• Archived the entire catalog, folders, or objects to unzip them in another directory location.
• Specified permissions that determine the folders and objects that users can view.
• Performed migration and merging of RPD’s in OBIEE and Involved in Migration, UAT, Go-Live, and Production Cut over.
• Set up the Topology including physical architecture, logical architecture and context.
• Created new models for the data sources - flat files, MS SQL server, Oracle.
• Did reverse engineering for the data sources and targets.
• Performed high level Implementation and Administration tasks related to the development and configuration of dashboards
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
• Extensive experience in creating executive reports with BI Publisher integrated with OBIEE.
• Highly experienced in creating Oracle BI Publisher Report Templates using BI Publisher Desktop Edition.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Used topology manager for registering source and target technologies along with logical and physical schemas.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Anticipate the end-to-end scope of analytical need of the client and design valuable BI and ETL solutions accordingly
• Use the best practices of business intelligence to design the analytical solutions
• Involve in unit and system testing to maintain the flow and relevancy of the solution
• Created workflows for full load and incremental loads to be used by DAC.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.

Environment: OBIEE 11g, BI Apps 7.9.6.4, Web Logic Server, Informatica 9.0.1, Oracle 11.2.0.2, SQL, PL/SQL, DAC 10.1.3.4,ODI 11g TOAD, SQL* Plus, Unix, Windows XP. Manufacturing Analytics,EBS 12.2.2,OBIEE 11.1.1.7/8/9/10 ,Financial,Procurement and Spend Analytics,BIACM

Confidential

Sr Software Engineer

Responsibilities:

• Interacted closely with Functional Analysts and Business Users in the client side, and designed the system accordingly.
• Customized standard reports to meet the client's requirement.
• Developed a package to validate and import purchase orders to interface tables from legacy system.
• Developed interface program to upload items and Items categories into interface tables from legacy system.
• Created and customized reports using XML Publisher / BI Publisher.
• Developed several reports and Customized as per the client requirement in Purchasing and Order Management.
• Achieved custom functionality in OM Sales Order Form through form personalization.
• Created and customized reports using XML Publisher / BI Publisher.
• Involving on up gradation of various Packages, Procedures and Functions by making the R12 necessity changes like replaced the 11i obsolete tables.
• Creation of FND objects like Value Sets, Flex fields, Responsibilities, Custom Menus, Request Groups, Profile Options Setups.
• Developed Custom shipping documents based on standard pick slip, Packing slip reports.
• Personalization on Standard Pricelist form.

Environment: Oracle 11g, XML/BI Publisher, TOAD, SQL, PL/SQL, Report Builder, Form Builder, Form Personalization, Discover Reports

Confidential

Software Engineer

Responsibilities:

• Supporting the Oracle 11i ERP Solutions
• Handling Several Technical Issues
• Creating Several CSR (Custom Change Request) and processing those till to PROD by several levels of user validations
• Modified several custom reports (RDF, Discoverer and XML) and Form Personalization and Custom.pll with Additional Functionality
• Modified several custom components
• Creating Oracle SR’s for Oracle Standard Issues
• Support Related Development for All Modules(INV,PO,OM,AR,AP,WIM,BOM and GL) of Flowserve Production Issues
• Supporting technical issues logged in Unisys peregrine and BMC Remedy for Flowserve End Users
• Supporting the Month / Quarter / Year end closing activities by generating various reports needed by the users
• Defining Concurrent Programs, Executable, Value Sets and Display Profile values
• Prepared Technical Design Documents (MDO70) and Migration Documents (MD120)

Environment: Oracle 11g, XML/BI Publisher, TOAD, SQL, PL/SQL, Report Builder, Form Builder, Form Personalization, Discover Reports