PROFESSIONAL SUMMARY:

• Overall 11+ Years of extensive experience in IT industry, which includes Experience with OLAP reporting tool like OBIEE (Siebel Analytics), BI Publisher, Business Intelligence Applications (OBIA) including DAC, Informatica, ODI, BIACM, FSM
• 9+ years of experience in OBIEE / OBIA. Completed five full OBIEE / OBIA Implementations.
• Extensive experience in Analysis, Design, Development, Data conversion, Data Modeling in various domains i.e. Financial, sales, Marketing and call center.
• Good understanding of source applications like E - business suite, Siebel CRM and Legacy Applications.
• Expertise in Data Analysis, Identification of slowly changing dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures and Hierarchies
• Experienced in creating Data security & Object level security to the users using OBIEE.
• Worked in BI Apps mappings for different source applications i.e. EBS, Siebel and also implemented Incremental vs. Full load mechanisms at various clients.
• Worked on Business Intelligence Applications (OBIA) Customizations for Oracle EBS R12 GL, AP, AR and OM Modules
• Good Understanding on BIAPPS 7.9.6.4, BIAPPS 11.1.8.1 and ODI (Oracle Data Integrator)
• Strong in building Informatica mappings & ODI Interfaces sourcing from heterogeneous data sources.
• In depth knowledge on Data Mapping, Data Conversion, and Data Cleansing.
• Experienced in designing Star Schema/ Snowflake Schema methodologies.
• Experienced in Configuring and publishing the iBots / Agents to deliver analytics content based on schedule, automated iBots queries to obtain daily & weekly transactions to all the departments in the organization by Emails.
• Proficient in using Informatica tools like Designer, Workflow Manager and Repository Manager to create, schedule and configure the repositories, mappings and workflows.
• Experienced in configuring DAC, BIACM for executing, scheduling and monitoring various ETL tasks (Execution plans).
• Extensively used DAC to implement Index management strategies and Database statistical updates for efficient query performance.
• Extensively worked on Performance tuning strategies by tuning the rpd for OBIEE to generate efficient queries.
• Extensively used Catalog Manager for web catalog migrations and also Administered web catalog upgrades.
• Strong experience with oracle Database in writing SQL queries, coding PL/SQL Procedures, Functions, Cursors, Triggers and Packages, Materialized view.
• Good analytical & functional skills, ability to effectively communicate with technical & business users.
• Managing the entire Oracle BI environments, including Installation, Configuration, Upgrades and build deployments on OBIEE/OBIA 11g.
• Experienced in Troubleshooting and providing work around solutions to the business users for bugs in OBIEE 11g.
• Multi-Platform experience on UNIX / Linux and Windows Server family of products.
• Experience in WebLogic and WebSphere to Deploy the data
• Experience in setting up a Multi-User Development Environment (MUDE).
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Data warehousing development using ETL Tools such as Informatica Power Center and experience in DAC (Data warehouse Application Console) Configuration.
• Design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Informatica Power Center 9.x
• Worked with various Transformation Components like Source Qualifier, Expression, Aggregator, Filter, Router, Sorter, Lookup, Joiner and Sequence Generator.
• Have Good knowledge and understanding of OBIEE 11g/12c Architecture, functionality and features.
• Business Analysis experience with excellent communication & interpersonal skills, broad understanding of business operations and requirements.
• Experienced in extracting (ETL) data from SAP R/3 using Logistics (LO Cockpit) and Generic Extractors
• Involved to develop various aggregation levels, planning functions and planning sequences.
• Good functional knowledge in FI, SD, HR, OTC, Budgeting, Planning, Order Tracking and HR.

TECHNICAL SKILLS:

Oracle Business Intelligence Apps and Methodologies: Financials, Supply Chain and Order Management, Sales, Health Care, Environmental Science, Food Services, Procurement and Spend, eAM, Operations, Manufacturing, HR, P2P, EDW OFSAA, Logistics, Production Orders, Shipping, Pricing, Project, Marketing, Usage Tracking, Inventory, Fixed Assets, Risk Management, Retention, Data Modeling, Agile, Scrum, Waterfall methodologies, Dashboards, Score Cards, KPIs.

Business Intelligence: OBIEE 12c/11.x/10.x, OBIA 7.9.x, BI Publisher 11.X/10.x, Discoverer 10g/6i, Tableau 8.x, Cognos 8.4.x/10.2.x, SSRS, Hyperion 11..x, Big Data, Hadoop, Essbase Cubes, SQR Reporting, VIZIYA Analytics, Noetix Views

ETL/Integration: Informatica Power Center 9.x/8.x/7.x, DAC 11.x/10.x/7.x, ODI 11.x, SSIS, Golden Gate, AutoSys, EDW, Web Logic 10g/12c.

RDBMS OLTP: Oracle 11g/10g/9i/8i, Microsoft SQL Server 2008/2012, Teradata 12/13, PeopleSoft 9.x, EDI, MS Access, Siebel 7.x/8.x

Query Tools: TOAD, SQL*PLUS, SQL Developer, Smart View

Testing Tools: Quality Center (QC), HP Service Manager

Migration Tools: HP Project and portfolio management (PPM), Clear Case, Clear Quest

Modeling Presentation: SAP Power Designer, Erwin, XPS Viewer, Visio, Project, MS Office Utilities

Languages: SQL, PL/SQL, XML, HTML, Shell Scripting, Java, C, C++.

Operating System: Sun Solaris, Unix, Linux, Windows 8/7/Vista/XP/2003/98/NT.

PROFESSIONAL EXPERIENCE:

Confidential, Toledo, OH

Lead-OBIEE Developer

Responsibilities:

• Configured BIAPPS 11.1.10.1 for Financial and Custom Analytics using pre-build Oracle Business Intelligence Applications (OBIA) in BIACM and FSM
• Migrated Custom Oracle Data Integrator (ODI) Interfaces as part of upgrade from 11.1.7.1 to 11.1.10.1 by analyzing prebuilt ODI Interfaces after Performing the GAP Analysis
• Involved in Identifying Oracle R12 Functional changes and Impacts comparing ODI Interfaces in two different containers
• Worked on different ODI Knowledge modules for extracting, Integrating and Loading data in data ware house from heterogeneous data sources by creating data servers, data stores, Interfaces, Knowledge Modules (KM) in Oracle Data Integrator (ODI)
• Extracted data from different sources ODS, DRM, Hyperion, Oracle EBS for customizations implemented Business logic and loaded into target warehouse (OBAW).
• Retrofitted and migrated OOTB ODI Interfaces and created execution plans in BIACM to schedule and run the interfaces periodically for incremental and full Loads in the Data warehouse.
• Retrofitted and Migrated ODI Interfaces, ODI Packages, ODI Procedures, ODI Scenarios as per custom requirements
• Involved in Data Validation after performing the Data load in DW and compared the Data with old environment
• Worked on ETL Load Dates to Perform Incremental and Full load logics as couple of tables undergone Incremental load after migration to new version
• Good Understanding in using Oracle pre-built RPD and Involved in Unit testing of OBIEE Reports in 12C after initial data loads
• Perform end regression testing after BI Catalog Migration Using BVT (BI Validation tool)
• Tested Object and Data level security using LDAP users/groups, OBIEE Variables and roles difined in Enterprise Manager.
• Involved in writing test scripts for testing the Reports and Dash boards
• Involved testing complex conditional base reports and role based dashboards using OBIEE 12C
• Involved in Customizing OBIEE Skins and changed the default OBIEE 12C Skin from Alta to Skyros by modifying instanceconfig.xml files

Environment: OBIEE 12C, OBIA 11.1.10.1, Oracle R12.2, ODI, BIACM, FSM, Oracle 11g (SQL/PL-SQL), Windows 2007 and Unix Server

Confidential, OH

Lead-OBIEE Developer

Responsibilities:

• Developed Oracle Business Intelligence (11g and 12c) Repository.
• Deploying repository on the server.
• Experience with version control manager - PVCS. Involved in research of using GIIT for OBIEE repository version control.
• Involved in multiple production releases. Creating and migrating package lines.
• Good experience in using MUDE - creating projects, checking out and checking in projects.
• Excellent knowledge in business model development with various functionalities like Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series, Caching & Mapping.
• Creating & Updating Meta data repository configuring metadata in BMM layer, physical Data Model and Web Catalog Objects as per the reporting requirements using OBIEE Admin and Web tool.
• Created variables and initialization blocks for data level security based on user login.
• Excellent knowledge of patch merging and three-way repository merging.
• Created Logical Dimension and Fact table in OBIEE Repository.
• Created dimension hierarchies to achieve the drill down functionality. Created presentation layer hierarchies.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.
• Created Filters and providing customized prompts appropriately to avoid excessive data showing up on reports.
• Created direct sql reports, BI Publisher Reports and dashboard pages and prompts.
• Created Prompts, set Filters and Calculations. Created Global Filters for Dashboards.
• Developed Reports and role-based Dashboard.
• Configured OBIEE agents and Bi Publisher Report jobs to deliver Analytics content based on schedule.
• Built PL/SQL Functions and procedures. Created materialized view and database views and used in repository for better performance in OBIEE reporting.
• Involved in Installation and Configured OBIEE Environment and trouble shooting in the Organization.
• Involved in repository upgrade and migration from 11g to 12c.
• Implemented caching to improve performance. Involved in performance tuning of reports.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non-Real-Time reports.
• Worked in Repository Configuration, Troubleshooting, Patching, Migration and Server Administration.

Environment: OBIEE 12.2.1.0.0, OBIEE 11.1.1.7 / 11.1.1.6, Web Logic Server, Oracle 12c/11G, SQL, PL/SQL, SQL* Plus, UNIX, OBI Publisher

Confidential, Indianapolis, IN

Senior OBIEE & OBIA Consultant

Responsibilities:

• Configured BIAPPS 11.1.8.1 for Financial, HR, Procurement and Spend, Supply Chain Analytics using pre-build Oracle Business Intelligence Applications (OBIA), Designed ELT data extraction processes using Oracle Data Integrator (ODI) as part of customizations by modifying prebuilt ODI Interfaces after Performing the GAP Analysis
• Worked on different ODI Knowledge modules for extracting, Integrating and Loading data in data ware house from heterogeneous data sources by creating data servers, data stores, Interfaces, Knowledge Modules (KM) in Oracle Data Integrator (ODI)
• Extracted data from different sources for customizations from oracle and flat files implemented Business logic and loaded into target warehouse (OBAW).
• Configured OOTB ODI Interfaces and created execution plans in BIACM to schedule and run the interfaces periodically for incremental and full Loads in the Data warehouse.
• Developed ODI Interfaces, ODI Packages, ODI Procedures, ODI Scenarios as per custom requirements
• Good Understanding in using Oracle pre-built RPD and configuring the Dimensional modeling (Star Schemas, Snowflakes) for New Reports and Dash Boards according to business requirements.
• Configured Object and Data level security using LDAP users/groups, OBIEE Variables, WebLogic Servers and Enterprise Manager as per the client requirement.
• Created OBIEE Direct DB reports and BI publisher reports based on EBS ORACLE database.
• Good Understanding in Installing, Configuring, Administering, Migrating and Managing the repository (rpd) and responsible for deploying the OBIEE code across the Stage and Production servers.
• Involved in creating and configuring complex reports and role based Intelligence Dashboards using OBIEE
• Developed and customized executive level dashboards and reports in various views such as Pivot Views, Charts, View Selectors, Column Selectors to provide insight into the Financial and Sales data
• Migrated existing OBIEE 10G, ESSBASE, APEX SFDC Reports into OBIEE 11G
• Building cache strategies using manual scripting, and schedule the same in ODI Interface for clearing OBIEE Cache after every data load
• Scheduling Reports using OBIEE Delivers to User’s Email as PDF and Implement Narrative views, Charts, Pivot tables and Compound layout to design the dashboards.
• Involved in configuring, scheduling and monitoring ETL tasks like Execution plans using BIACM as per the business requirement.
• Merging OBIEE web catalogs using Catalog Manager at the time of Deployments.

Environment: OBIEE 11G, OBIA 11.1.8.1, Oracle R1213, ODI, BIACM, FSM,Oracle 11g (SQL/PL-SQL), Windows 2007 and Unix Server.

Confidential, Phoenix, AZ

Senior OBIEE & OBIA Consultant

Responsibilities:

• Implemented current reporting outputs using SalesForce.com and EDW data delivered through the OBIEE 11.1.7.1 Dashboard and reporting capabilities.
• Involved in every aspect of project life cycle, including collaborative requirements gathering, creating work plans, functional requirements and unit testing plans
• Customized Physical Layer, Business Model and Mapping Layer and Presentation Layer of Repository (RPD) using Oracle Business Intelligence Administration Tool and performed Consistency check of the Business Model before exposing in the Presentation Layer considering errors, warnings and best practices
• Provide Ad-hoc reporting to selected business users for further data analysis by Object Level Permissions controlled Using External table.
• Developed a deep understanding of business needs and problems to analyses data and business requirements to design and deliver over a dozen dashboards containing a multitude of KPIs and metrics.
• Provided few real-time (frequently updated) reports in OBIEE using SFDC reporting and visualization functions and Loading in EDW using Informatica.
• Automate the current manual data collection process used to gather data into Data Warehouse which is updated to TL9000 system for use in reports.
• Complicated reports have been developed using multiple views like Pivot, View Selector, Chart View and Gauges and ensured pleasant User Experience and proper delivery of major requirements, minor details, and intuitive OBIEE User Interface.
• Implemented Security by creating roles & web groups, checks with External tables
• Working closely with Business Users, Team and gathering the requirements from different user groups for Migrating Current BRIO Reports into OBIEE 11G
• Implemented Cache management to handle performance issue in report generation.
• Executed OBIEE administrative tasks such as OBIEE RPD and Web catalog migration and user maintenance.
• Good Understanding of BI Publisher reports and using various templates to publish the reports as per user requirements.

Confidential, Denver CO

OBIEE/ETL Analyst and Developer

Responsibilities:

• Analyze user requirements for building BI Publisher reports for user from different departments
• Categorize requirements to build new BI Publisher reports
• Work on enhancement requests (ER) for the already existing reports for changes in code, template, data etc.
• Work on report template enhancements and parameters through BI Publisher word template builder
• Schedule and auto-deliver reports through email to different users based upon requests
• As a part of migration from 10g work on new Linux server’s setup, installation and configuration of other required software’s
• Develop and maintain BI Publisher reports for Business Unit Control (BUC) team
• Production support for RBS Americas BI Publisher reporting and ETL during the nightly batch loads
• Work on different enhancements for the existing BI Publisher reports according the business user’s requirement
• Work in conjunction with data analysts for developing dashboards and other end user reports
• Responsible for daily maintenance and enhancements of BI Publisher reports along with hardware reliability, system level security, system level performance monitoring, tuning and automation of production activities
• Work in conjunction with system administrators for migration deployment and performance tuning of repositories
• Involved in OBIEE administration and worked Configuring OBIEE with LDAP server for Security.
• Performance tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures.
• Installed and configured OBIEE. Admin tool and Siebel web components including Intelligence Dashboards, answers, delivers and Analytics web
• Developed strategy for migration from Siebel Analytics 7.9.5 to OBIEE 10.1.3.3.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 7.1.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Developed Dashboards/Reports using the Oracle Business Intelligence platform for requirement analysis.
• Developed Complex Reports by using the Different Views like Table, Pivot, Chart, Static View, Narrative View, Column Selector, View Selector and Combined with Similar Requests.
• Handled both OBIEE and BI Publisher Servers administration and report maintenance
• Performed DR Testing on OBIEE and BI Publisher servers

Environment: ODI 10.1.3.x, OBIEE 10.1.3.x, BI Publisher, Oracle 10g, SQL*Loader, PL/SQL, TOAD, UNIX, Siebel 7.8.4, Informatica Power Center 7.1, Oracle 10g, SQL, PL/SQL and TOAD, MS-Excel, PowerPoint.

Confidential, Philadelphia, PA

OBIEE/ETL Analyst and Developer

Responsibilities:

• Implemented Supply Chain and Order Management, Procurement and Spend, Financial Analytics.
• Conducted meetings with Subject Matter Experts (SME), Business Analysts and End-Users in gathering and analyzing the Business Reports Requirements.
• Upgraded and Configured OBIEE from Siebel Analytics Environment including DAC and Informatica.
• Implemented Invoice level security in OBIEE depending on the user level access by integrating with Oracle EBS.
• Implemented LDAP security in OBIEE for authenticating users.
• Developed many Reports/Dashboards with different Analytics Views (Drill-Down/Dynamic, Pivot Table, Chart, and Column Selector with global and local Filters using Oracle BI Presentation Services).
• Was involved in the installing and configuring of Financial Analytics.
• Designed and Developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
• Developed Dashboard pages like Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Developed Dashboard pages like AR Balance, Payments Due, Invoice Details and All AR Transactions in Receivables Dashboard.
• Developed Dashboard pages like AP Balance, Overview, Payments Due, Supplier Details and Invoice Details in Payables Dashboard.
• Developed Dashboard pages like Overview, Margins, Revenue, Products and Customers in Profitability Dashboard.
• Extensive experience in configuring OBIEE Interactive Dashboards with drill-down & drill-across capabilities, Guided Navigation, Alerts, Security Setup (groups, access privileges), Filters & Rules with User Identity & Roles, Profiles & Personalization, Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, and Reports).
• Extensively used Delivers and iBots for delivering personalized reports to users, the management and sales teams as per the business requirements.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
• Created new mappings, Sessions & Workflows to load the data into the Data warehouse.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Exclusively Involved in Unit Testing, Assembly Testing, Peer Testing & Regression Testing.
• Worked on multiple projects at a time to meet the dead lines of the tasks.
• Setup Multi User Development Environment (MUDE) in OBIEE.

Environment: BI Apps 7.9.x, OBIEE 10.1.3.2.x, Informatica 8.1.0, DAC, Oracle 11i, SQL Server, General Ledger, Account Payables, Accounts Receivables, TOAD, Unix and Windows XP.