Summary:

• Over 8 years of professional experience asTechnical ERP Developer/Consultant and BI Applications with expertise inGeneral ledgerGL,Account PayablesAP,Account ReceivablesAR,Fixed AssetsFA,Order ManagementOM,I procurement and Purchasing PO, HR Human Resources Analytics, Inventory INV and Payroll.
• OverFour yearsof experience inOBIEE Technical Consultant.
• Extensively worked on Installation and configuration of Financials, Supply Chain Analytics, Procurement Analytics and Spend Analytics.
• Experience in using Data Warehouse Administration Console (DAC) to schedule the Informatica jobs and metadata management.
• Expertise in design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modelling, Repository Management (RPD), Extraction Transformation and Load (ETL).
• Proficient within the Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration tool.
• Experience in configuring Interactive Dashboards with drill-drown capabilities using global and local filters, OBIEE Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
• Extensively worked on BI Server, BI Answers, BI Dashboards and BI Delivers (iBots)
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
• Proficient in Oracle Tools and Utilities such as SQL Developer, SQL * Loader, SQL * Plus, Data Loader, TOAD and UTL_FILE.
• Experienced in Complete Software Development Life Cycle (SDLC) which includes System study, Analysis, Physical and Logical design, Resource Planning, Coding, Testing and implementing business applications.
• Involved in development of RICE objects (Reports, interfaces and data conversions, customizations, extensions) for the Oracle Applications E-Business Suite implementation across major modules.
• Experience in design, analysis, development, testing and implementation of applications in Oracle E-Business Suite using PL/SQL, Developer 2000, Oracle Reports 10g/9i/6i, Oracle Discoverer 10g/4i, XML Publisher 5.6.3/5.6.2.
• Extensively worked on Oracle Discoverer, which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
• Designed Report Templates using XML/BI publisher.
• Strong Conceptual, Business, Analytical skills & highly motivated team player and ability to provide work estimates and meet deadlines.

Professional Experience:

Confidential,SanJose, CA Sep\'10 – Till Date
Role: Sr. OBIEE Developer

Responsibilities:

• Implemented Financials, Supply Chain, HR and Procurement & Spend Analytics.
• Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Hands on experience in ETL (Extraction, Transformation, and Loading) processes using Informatica Power Center 8.6/8.1/7.1/6.1.
• Extensively used ETL processes to load data from flat files into the target database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Involved in installation and configuration of OBIEE, Informatica and DAC.
• Analyze, Design and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Responsible for configuring the Source and lookup files.
• Experience in developing detailed steps for configuration, integration and security using Apex.
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables including Physical, Logical data modeling in the OBIEE Administration tool.
• Involved in integration of LDAP in OBIEE of admin tool.
• Experience in customization of pre-build OBAW BI apps.
• Experience in UI Dashboard and Answer reports using KPIs.
• Experience in modifying OBIEE models like AKA, RPG files.
• Work with end users to identify, create, and deliver reports according to requirements.
• Develop the overall data warehouse architecture and physical implementation standards.
• Act as evangelist for BI benefits across the organization; promote BI usage to relevant departments.
• Administration of all components that make up the Data Warehouse and Business Intelligence infrastructure, applications and related tools including software installation, patching, configuration, monitoring, and tuning.
• Installation and configuration of Siebel 7.8.2, 8.1.1 (Gateway, Enterprise, Web, Siebel Management Agent and server.
• Troubleshooting and problem solving of Siebel Server components, Native Load Balancer, Siebel Object Manager, Siebel Remote, Siebel Workflow, Siebel EIM and Actuate Report server.
• Analysis, Design and Development in Oracle and OBIEE 11g/10g.
• Troubleshooting and debugging of defects and production issues in the areas of Oracle, and OBIEE 11g/10g.
• Design, create and tune physical database objects (tables, views, indexes) to support logical and dimensional models. Maintain the referential integrity of the database.
• Develop and implement Data Warehouse, data mart techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models.
• Diagnose and resolve Data Warehouse access and performance issues.
• Expert in building oracle Apex Databases and Application development.
• Customizing the existing informatica repository and adding new mappings and workflows based on the requirements.
• Analyzes and develops complex Siebel Customizations, Workflows, and SmartScripts. Performs sophisticated systems analysis in the enterprise environment.
• Expert in using KPI scorecards and Repository development for marketing operattion and organizations.
• Extensively worked as a Techno-Functional consultant in providing CRM solution with excellent business domain experience in Siebel Telecom, Finance and Siebel Call Center, Sales and Marketing Applications.
• Analysis, Design and Development in SQL, Informatica and OBIEE 11g/10g.
• Developed the repository, merges the repository, performance tuning and enforcing repository best practices.
• Expert in Oracle Warehouse management system (WMS), Oracle mobile supply chain Application (MSCA) and Oracle Inventory in functional capacity.
• Troubleshooting and debugging of defects and production issues in the areas of SQL, Informatica and OBIEE 11g/10g.
• Works in conjunction with System Administrators for migration, deployment and performance tuning of repositories.
• Extensively used ETL processes to load data from flat files into the target database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Experience in Architecting large BI implementations over Enterprise Data Warehouse.
• Experience with Analysis, design, development and implementation of projects for corporate Data Warehouse.
• Extensive BI and Data warehousing experience using Siebel Analytics 7.x/OBIEE and Informatica 8.1/7.x/6.x.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web.
• Translated business requirements into functional design solutions, support development, testing and release activities.
• Created OBIEE reports & dashboards for the Marketing Operations organization.
• Develop, test and implement complex ETL flows for the Data Warehouse using PL/SQL, Oracle warehouse builder and Oracle Data Integrator.
• Worked with OWB 11G R2 for ETL and data profiling.
• Created Dimension hierarchies to achieve the drill down functionality.
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Designed and Developed Custom Mappings, Workflows and Registered in DAC.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse (OLAP) system.
• Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.
• Implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool. Migrated Analytics RPD and Web catalog from one environment to another.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Experience in designing and implementing Siebel CRM modules.
• Technical knowledge of Siebel EAI and EIM components, including Virtual Business Components
• Implemented the single sign on (SSO).
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Involved in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
• Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Created and Customized Dimension Hierarchies to achieve the drill down functionality as per Business Requirements.
• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Involved in Integrating Oracle BI Presentation Services with BI Publisher.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Designed and Developed Sessions and Workflows.
• Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
• Adding new Tables,Tasks and rebuilding the subject areas in DAC based on the changes done to the informatica repository.
• Extensive hands-on exercises using both GUI tools and SQL*Plus provide you with the practical skills to administer an Oracle 11gdatabase.
• Building an Oracle database.
• Experience in modeling, designing and developing OBIEE or any other analytical applications.
• Expert in developing OBIEE Mobile applications as BI indicators.
• Strong analytical and conceptual skills in Database design and Development using Oracle 10G,SQL Server2005, IBM DB2, SQL, Teradata and PL/SQL.
• Configuring the Anlaytics repository(RPD) and implementing the security to authenticate and authorize Oracle EBS users.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler & iBots.
• Created functions, procedures and triggers in PL/SQL.
• Created mappings using PL/SQL packages to implement business rules while loading data.
• Written test scripts to compare OLTP vs OLAP for ETL testing.

Environment: Oracle Applications R12 , General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, HR, Oracle Purchasing, OBAW, Oracle 11g/10g/9i (9.2.0), OBAW, (OBIEE 10.1.3.4.1, Siebel Analytics/OBIEE/BA, RPD, ETL, Informatica Power Center 8.x (Repository Manager, Designer, Workflow Manager and Workflow Monitor), DAC 10.1.3.4.1, XML/BI Publisher 5.6.3, Discoverer 11g, MSCA, ANSI SQL, PLSQL, SQL*PLUS, SQL*Loader, TOAD, Unix(shell scripting).

Confidential,GA Oct\'09 – Aug’10
Role: Sr OBIEE Consultant

Responsibilities:

• Involved in the installing and configuring of Financial and Supply Chain Analytics Analytics.
• Involved in implementing Human Resource Analytics HR.
• Gathered requirements from the client for GAP Analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Extensively worked on SRs as per the client’s requirement to get the reports for the Business Analyzation.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Work lets for data loads from various sources such as Oracle, Flat Files, COBOL, DB2, SQL Server etc.
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Extensively worked with various re-usable tasks, workflows, worklets, Mapplets, and re-usable transformations.
• Experience in user interface Dashboard and answer reports using KPIs.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Built Siebel Analytics Repository at 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model / data mapping (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs).
• Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.
• Design, code, test, and document all new or modified BI systems, applications, and programs.
• Create, organize, and maintain metadata layer and models using Framework Manager.
• Build and maintain Cognos Transformer Cubes.
• Develop web interfaces, graphs, and portals for components interacting with data warehouse processes using Cognos.
• Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system using DataStage.
• Troubleshoot Cognos, DataStage, and all other relevant BI systems and software; performance-tune these applications as necessary.
• Performs other duties as assigned.
• Responsible for customizing the out of box reports and creating new reports and dashboards.
• Developed Reports/Dashboards by implementing different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).Created Environment Variable on Unix/Linux Environment.
• Designed and Developed Custom Mappings in Informatica to bring the data from Legacy system.
• To implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• Expert in designing and implementing for Data Warehouse.
• Extracted various sources like Oracle tables and imported Flat files using Informatica Power center.
• Extensively developed mappings on various business areas in the project by employing the available Transformations.
• Experience converting SAP BO to OBIEE.
• Responsible for extracting Data from Oracle Apps Modules & loading into stage system and warehouse system.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Used Template, sub Template method for a creating single report with multiple Layouts.
• Used the Totals/Subtotals/group/sort features of XML/BI Publisher to make data intense operations happen at the template level.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions.
• Developed Custom Reports from OLTP without creating any Views or Tables in EBS Database in IProcurement, Payables and General ledger.
• Designed and Developed Dashboard Pages Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard.
• Designed and Developed Procurement and Spend and Supplier Performance, General Ledger Dashboards in OBIEE.
• Designed and Developed Dashboard Pages Like Trends, Exceptions, Supplier Payables, Quality Performance, Delivery Performance and Price Performance in Supplier Performance Dashboard.
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
• Designed and developed Delete Cancelled requisitions program to delete all the cancelled requisitions in iProcurement.
• Created Dimension hierarchies to achieve the drill down functionality. Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Technical knowledge of Siebel Architecture, including Gateway, Siebel, Web, and Database Servers.
• Conducted training Sessions on Informatica power center and OBIEE.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.
• Created functions, procedures and triggers in PL/SQL.
• Created mappings using PL/SQL packages to implement business rules while loading data.
• Written test scripts to compare OLTP vs OLAP for ETL testing

Environment: OBIEE 10.1.3.4, Oracle Applications R12 ,General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Supply Chain(SCM), Service Contracts, Install Base, Oracle 11g/10g/9i (9.2.0), OWB, OBAW, OBIEE 10.1.3.4.0,SIEBEL CRM/Analytics 7.x, RPD, Dashboards, Delivers.(iBots), Informatica 8.1.1, DAC 7.9.5, XML/BI Publisher 5.6.3, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, Unix(shell scripting).

Confidential,VA Apr\'08 – Sep’09
Role: OBIEE Technical Consultant

Responsibilities:

• Created Dashboards and Answers for End user.
• Implemented Invoice level security in OBIEE depending on the user level access by integrating with EBS.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, 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.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
• Responsible for extracting data from Oracle Apps Modules & loading into stage system and warehouse system.
• Created and ran 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.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool..
• Configured and Scheduled Sessions and Workflows.
• Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
• Worked on multiple folders at time to meet the dead lines of the tasks.
• Created VPD security for reports in OBIEE.
• Designed and developed logical model in BMM in Repository.
• Installed and Configured DAC.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Created custom reports in Payables in OBIEE according to user requirement.

Environment: Oracle Applications 11i/R12 iProcurement, General Ledger, Account Payables, Accounts Receivables, Fixed Assets, BI Apps 7.9.5, SIEBEL CRM/Analytics, OBIEE 10.1.3.4.0/10.1..3.3/10.1..3.2, Informatica 8.1.1, DAC 7.9.5, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i, ,SQL*PLUS, SQL*Loader, TOAD, Unix.

Confidential,FL Jan 2007- Mar 2008
OBIEE Technical Consultant

Responsibilities:

• Worked with business users to gather business requirements and provided reports in Financial, manufacturing and Supply Chain modules.
• Designed and Developed Financial Dashboard like General Ledger, Payables, Receivables.
• Created AD hoc reports in Account Payables.
• Developed Dashboard pages like Finance Structure, Cash Flow and Asset Usage in General Ledger Dashboard.
• Developed Dashboard pages like Effectiveness, Invoice Details and Payment Performance in Receivables Dashboard.
• Developed Dashboard pages like Overview, Payments Due, Effectiveness and All AP Transactions in Payables Dashboard.
• Created Dashboard prompts and advance filter criteria.
• Created reports in Answers and embedded them in Dashboards according to the requirements.
• Was part of the installation team to install OBIEE BI Apps.
• Designed and developed custom Dashboards.
• Designed and developed Customer Interface, Auto Lockbox Interface.
• Extensively Modified Shipping INBOUND/OUTBOUND interface programs to accommodate changes in business process.
• Designed Customer Products Summary Report in Install base using OBIEE.
• Created and ran Sessions & Workflows using Informatica Workflow manager to load the data into the Data warehouse.
• Worked on Service Contract interface program by using the standard API’s.
• Generated Inter Company Transaction Detail Report, Open-Debit Memo Report in General Ledger using Reports 6i.
• Customized Supplier Payment History Report in Account Payables to meet client requirements.
• Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG’s.

Environment: Oracle Applications 11i (11.5.10) General Ledger, Account Payables, Accounts Receivable, Inventory, OBIEE 10.1.3.3/10.1.3.2, XML/BI Publisher 5.6.3, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, UNIX.

Confidential,INDIA Jan 2003 - Dec 2006

Responsibilities:

• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes.
• Designed and Developed AP Check Printing Report, Invoice Detail Report by Supplier, Payment Schedule Report in XML/BI publisher.
• Customized the standard AR Aging Report and Invoice History Report using XML/BI publisher.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.
• Developed new report Credit Memos in AR using Discoverer.
• Developed GL journal Import interface program in General Ledger.
• Customized Chart of Account Detail listing, Trial Balance, Summary Income Statement in General Ledger using FSGs.
• Converted Order Detail Report, Credit Order Summary Report, Orders by Item Report in Order management from report 6i to XML/BI publisher.
• Created new responsibilities and involved in defining the required system profile options.
• Loaded data to the interface tables and populated data to Standard Tables through Standard Order Import Program.

Environment: Oracle Applications 11i (11.5.10), General Ledger, Accounts Payables, Account Receivables, Order Management, Inventory, Oracle 9i, Discoverer 10g, Windows 2000/NT, SQL*Plus, TOAD, Reports 6i ,Kintana, UNIX.

Technical Skills:

Oracle Applications :

Oracle Financials E-Business suite R12/11i (Order Management, Inventory, Purchasing, General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Cash Management, AOL, System Administrator).

Developer Tools:

OBIEE10.1.3.x,11g ,Siebel Analytics 7.5/7.7/7.8, Teradata7.2, Oracle Reports 11g/10g/6i/4i, Oracle BI Apps 7.9.x Oracle Forms 10g/6i/4i, Discoverer 10g/6i/4i, XML Publisher 5.6.3/5.6.2, TOAD 9.7.3/8.x, SQL*PLUS, Data Loader, SQL*Loader, SQL Developer.

ETL Tool:

Informatica Power Center 8.1.1, 7.1, 6.2, 5.1,DAC 10.1.3.4.1

Operating Systems:

Windows NT/XP/2000/98, UNIX, Linux

Languages:

SQL, PL/SQL, C, C++, C#, HTML, XML

RDBMS:

Oracle 10g/9i/8i, MS Access, SQL Server 7.x, 2000

Education Background:

Bachelor of Technology in Computer Science