SUMMARY:

• Oracle Certified 13 years’ experience with powerful blend of technical knowledge, revenue - driven business acumen, and organization and execution skills to get things done. Specialized in Oracle Analytical Applications- Oracle BI Apps. BIgdata, Business Intelligence / Data Warehousing solutions, Data Quality, MDM, Revpro.
• 12 OBIA implementations have done successfully end to end.
• Expertise in OBIA implementations with Confidential (11.1.1.7.1/ 11.1.1.8.1 ).
• Expertise OBIA (Informatica/DAC) implementations have done successfully end to end.
• Expertise in SQL Performance turning, PL/SQL & Oracle certified.
• Expertise customizing OOTB RPD, Dashboards as per client requirements.
• Expertise customizing OOTB Confidential ’s( Confidential /INFORMATICA) as per client requirement.
• Expertise in Big Data Technologies - Hadoop ecosystem/HDFS/ Map-Reduce Framework, NoSql DB-Hbase and HIVE data warehousing tool.
• Customized Confidential ’s for AP/AR aging process to EBS aging reports (7 buckets/4 buckets).
• Demonstrated knowledge of Oracle R12 EBS Financial Models: GL, FA, AP, AR, CE, OM and PO.
• Hands on Oracle forms of R12 module Finance Purchasing (PO), Accounts Payable (AP), General Ledger (GL),Order Management (OM), Shipping (WSH),
• Inventory (INV), Accounts Receivables(AR), Cash Management(CE).
• Good understanding in ASCP,OPM.
• Hands on EBS tables (GL/AP/AR/OM/INV/PO).
• Experience and knowledgeable in Demantra/EBS/Revpro Integration data model
• Developed Custom Confidential ’s for AR/AP aging reports (7Buckets) and it should match with EBS AR/AP aging reports.
• Performed architectural reviews of all BI & Analytics solutions for assigned projects.
• Installed OBIA (11.1.1.8.1/7.9.6.4 ) in Linux & maintained.
• Developed & Customized Confidential rpd for many implementations (Physical Layer, Business Model & Presentation Layer).
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Physical and Logical data modeling.
• Extensive Working Experience in creating Calculation Measures, Time Dependent Measures, Initialization Blocks and Repository Variables.
• Performed architectural reviews of all BI & Analytics solutions for assigned projects
• Highly proficient in Manage, Design, Development, Implementation, Administration, Customization and Support of Oracle BI Apps, Prebuilt Analytics, Informatica Toolset, DAC.
• Demonstrated knowledge SFDC sources with Informatica Integration.
• Effectively working in a collaborative environment with good client interfacing, communication skills and able to work in both a team environment as well as individually across cross functional teams
• Ownership and strong contributions in architecting, designing and planning business intelligence solutions, configuring BI services, aggregating data from multiple sources into a data warehouse.
• Effectively applying architectural and engineering concepts to design a solution that meets operational requirements such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability.

TECHNICAL SKILLS:

Tools: Informatica 9.0.1/8.6/7.1/6.2/5.1, Data Quality 9.0.1, Power Exchange 9.01

Reporting Tools: Confidential 11.1.1.7.1/ 11.1.1.6, 1 /10.1.3.x/Siebel Analytics 7.8.x

MDM: Informatica MDM

RDBMS: Oracle 11g/1g/9i,TERADATA,VERTICA,SQL Server,MY SQL

ERP: Oracle EBS, PeopleSoft, Siebel, JD Edwards, SAP (With regard to Oracle BI)

BI Applications: Oracle BI Apps 11.1.8.1/11.1.7.1/7.9.6.4/, Financial,SCM, Procurement & spend, Project,Service, Pharma, Sales, Order management, HR

Languages: Java, Python, Perl, Javascript

BigData: Hadoop & Hadoop Ecosystem, Apache Spark and its Ecosystem, Storm

NoSQL: HBase, Cassandra, MongoDB, Neo4j

Hadoop SQL: Hive, Pig, PrestoDB, Impala, SparkQL

Hadoop Search: Hsearch, Apache Blur, Lucene, Elastic Search, Nutch

Hadoop Other: Oozie, Apace Kafka, RabbitMQ, Extjs

Data Modeling: Dimensional Data, Star Schema, Snowflake, Tables, Physical and Logical, Erwin

Tools: Toad, SQL Developer, SQL*Loader, DAC, Mercury Quality center

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++

Operating Systems: UNIX (AIX 5.1), Windows, Linux, Solaris

Scheduling tools: DAC (Data Warehouse Access Control)

PROFESSIONAL EXPERIENCE:

Confidential

Sr BI Apps Architect /Developer

Responsibilities:

• Worked with Finance/SCM business groups and individuals in the process of Requirements Gathering.
• Customized Group Accounts as per Fujitsu COA and performed various setup/configuration of csv files.
• Performed configuration activities through BIACM (configure required offerings, Load Domain Extracts then configure Data load parameters (eg:Master Org,,Inventory Category Set Ids, Purchasing Category Set Ids,Ledger,Global Currency…))
• Implemented Financial, Supply Chain Management, Procurement and Spend, Project Analytics.
• Enabled OOTB functionality & done customization based on Client requirements.
• Customized AR/AR balances related Confidential interfaces heavily to match with EBS standard Aging reports(eg:AR/AP aging 7 buckets).
• Customized OOTB Dashboard pages like Budget vs Actual, GL Balance, Cash Flow, AP Balance, Payments Due, Invoice Details, Supplier Report, AR balance, Customer Report, AR Transactions in Financial Analytics.

Confidential

Responsibilities:

• Set up the Topology including physical architecture, logical architecture and context.
• Created new models for the data sources - flat files,, Oracle, MS SQL server
• Did reverse engineering for the data sources and targets.
• Created PL/SQL stored procedures for Confidential .
• Created Confidential packages, scenarios using interfaces, variables, procedure
• Used Confidential commands like ODIFile Move, odiFileAppend, odiFilecopy etc
• Performance tuned the Confidential interfaces.
• Created custom fact groups for custom dimensions/Fact tables related scenarios.
• Created custom load plans.

Confidential

Responsibilities:

• Developed alot of Custom dashboards. Developed AR/AP aging (7 Buckets/4 Buckets) dashboards.
• Customized the Confidential Repository (physical, BMM, and presentation layers)
• Have developed Financial reports using Custom Groups/Calc Custom Groups.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Customized reporting with Confidential Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Done a lot of SQL Tuning to improve performance.
• Created smart views.

Confidential

Sr BI Apps Architect /Sr BI Apps Lead

Responsibilities:

• Installed OBIA 11.1.1.8.1 in Linux end to end (DEV/UAT/PRODUCTION).
• Implemented Financial Analytics, Supply Chain Management Analytics and Procurement and Spend Analytics, Manufacturing analytics.
• Confidential Configuration, BIACM Functional Administrator Setup, Creation of Custom Offerings, Configuration of custom load plans.
• Enabled OOTB functionality & performed customization based on Client requirements.
• Customized & created new Group accounts based on Confidential EBS setup .
• R12 (EBS) is source.
• Customized and Implemented reports for 13 Item categories.
• Customized GL Account Groups& Financial Statement Groups based on Client EBS setup.
• Have customized Financial analytics to extend COA with Department Segments and other customizations based on client requirement
• Customized OOTB interfaces for manufacturing analytics.
• Enabled ASCP/OPM for MFG analytics.
• Created custom load plans & Scheduled.
• Configured offerings through BIACM.
• Customizing the Balance Sheets/P&L statements, AR and AP aging according the clients requirements
• Working with business team to get the requirements and converting them into functional requirements

Confidential

Responsibilities:

• Installed OBIA 11.1.1.8.1 in Linux, as part of installation Confidential & Confidential and BI Apps installed and applied a lot of other patches.
• Installed Weblogic/ Confidential / Confidential & applied patches to upgrade Weblogic from 10.0.3.5 to weblogic 10.3.6
• Upgraded FSM & ATG and configured OBIA .
• 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.
• Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Enabled Financial,SCM,Manufacturer and Procurement and Spend analytics module.
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle HUB.
• Did SQL and PL/SQL programming for Confidential and oracle.
• Created PL/SQL stored procedures, functions and triggers.
• Developed interfaces for loading the lookup and transactional data.
• Installed and configured TOAD for Oracle and MS SQL Server.
• Created Confidential packages, scenarios using interfaces, variables, procedure
• Used Confidential commands like ODIFile Move, odiFileAppend, odiFilecopy etc
• Customized Interfaces & Packages as per requirement.
• Implemented logic to archive the source files with date stamp affixed after the successful load.
• Performance tuned the Confidential interfaces.
• Created Custom Fact groups.
• Optimized the knowledge modules to improve the functionality of the process.
• Performed unit and integration testing. Created various test scenarios to test the application.
• Delivered the assignments before the deadlines.
• Created custom Load plans .
• Conducted code reviews and planned the knowledge transfer to client.

Confidential

Responsibilities:

• Customized OOTB dashboards. Like Budget/Income statement where we show Actuals/Budges/Forecast.
• Done modeling and made changes in RPD. Build Dashboards with multiple fact tables with Confirmed/Non confirmed dimensions.
• Customized the Confidential Repository (physical, BMM, and presentation layers)
• Have developed Financial reports using Custom Groups/Calc Custom Groups.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Customized reporting with Confidential Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Created mockup reports and dashboards for review by the business users
• Done a lot of SQL Tuning to improve performance.

Confidential

Sr BI Apps Architect /Developer

Responsibilities:

• BI Lead / Architect for OBIA 11.1.1.7.1 - Procurement and Spend and Financial Analytics Implementation Project.
• Worked as Finance/SCM SME also for IT team.
• Confidential Configuration, BIACM Functional Administrator Setup, Creation of Custom Offerings, Configuration of custom load plans.
• Customizing Confidential Interface, Package, Procedure,KM,Scenario and Load plan.
• The Implementation involved sourcing data from ERP system (R12) including legacy data warehouse data into OBIA data warehouse.
• Employee Expenses, Payables, PO, Invoice and Voucher Management. Design and build the OBIA Solution to support business requirements.

Confidential

Sr BI Apps Architect /Developer

Responsibilities:

• Implemented the OBIA 7.9.6.4 applications and various modules (Financial Analytics, Supply Chain Management Analytics and Procurement and Spend Analytics, Manufacturing) for various clients .
• R12 (EBS) is source for all OBIA implementations.
• Worked on extensively on ORACLE EBS R12 Finance (AR,AP,GL), OM,SCM, Purchase, Inventory module.
• Have customized financial analytics to extend COA with Department Segments and other customizations based on client requirement.
• Customized GL Account Groups.
• Enabled ASCP for Manufacturing Analytics.
• Enabled OPM for Manufacturing Analytics.
• Have found DAC issues with Full load for 7.9.6.4 and resolved .
• Developed real time reporting based on EBS source system using Confidential Answers and Dashboards.
• Customized many of out of box solution reports according to the clients requirements.
• Scheduling and configuring the BI Applications informatiica mappings using DAC utility.
• Customizing the Balance Sheets/P&L statements, AR and AP aging according the clients requirements
• Working with business team to get the requirements and converting them into functional requirements
• Modified Metadata Repository model based on requirements that involved customizing Out-of-the-box OracleBIAnalyticsApps Repository.
• Customized Balance Sheet dashboards based on Customer requirements.
• Designing, Development, and Implementation of all the components Confidential tier-Informatica, Scheduling Tier-DAC, Reporting Tier - Confidential, Prebuilt Dashboards and reports.

Confidential

Responsibilities:

• Informatica 9.0.1 is used to load the Oracle EBS data into OBAW using Source Dependent Extracts (SDEs) & Source Independent Loads (SILOs), PLP and Custom Folders.
• Based on user requirements, DAC tasks and Informatica mappings have customized and DAC parameters were changed to load multiple Subject Areas into OBA Warehouse.
• Modified & Created Execution plans & tasks in DAC based on requirements.
• Configuraed Informatica servers /Connections/Logical folders setup in DAC.
• Used extensively Transformations like Lookup, Joiner, Rank and Source Qualifier,SQL transformation, Web Consumer, Normalizer in the Informatica Designer. webservice Consumer Transformation.
• Created Mapplets and used them in different Mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Persistent Cache.
• Developed very optimized workflows to load high volume data (500 ml ) quickly as part of history Loads.,
• Have developed Informatica Web services & These services are being consuming by Integration teams.
• Have optimized SQL & used Table partitions extensively.
• Have developed Informatica workflows to consume data from Web services.
• Have developed Workflow to consume data from Web service.
• Created materialized views and aggregates to improve performance.
• Done a lot of SQL Tuning to improve performance.

Confidential

Responsibilities:

• Customized the Confidential Repository (physical, BMM, and presentation layers).
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Customized reporting with Confidential Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Created mockup reports and dashboards for review by the business users
• Done a lot of SQL Tuning to improve performance.

Environment: OBIA 7.9.6.3/OBIA 7.9.6.4, Confidential 11g, EBS R12,SFDC, Informatica PowerCenter 9.1, DAC, Oracle 10g, Erwin, XML, UNIX

Confidential, San Jose, California

Sr BI Apps Architect/Developer

Responsibilities:

• Implemented the OBIA 7.9.6.4 applications and various modules (Financial Analytics,Project Analytics, SCM Analytics and Procurement and Spend Analytics) for various clients .
• Enabling Out of Box functionality & do customization based on Client Requirement.
• Worked on various Financial Analytics/ Supply Chain / Spend and Procurement analytics available in OBIA 7.9.6.4
• R12 (EBS) is source for all OBIA implementations.
• Worked on extensively on ORACLE EBS R12 OM,SCM, Finance (AP, AR,GL), Purchase, Inventory module.
• Have customized Finanacial analytics to extend COA with Department Segements and other customizations based on client requirement.
• Have found DAC issues with Full load for 7.9.6.4 and resolved .
• Developed real time reporting based on EBS source system using Confidential Answers and Dashboards.
• Customized many of out of box solution reports according to the clients requirements.
• Scheduling and configuring the BI Applications informatiica mappings using DAC utility.
• Customizating the Balance Sheets/P&L statements, AR and AP aging according the clients requirements
• Working with business team to get the requirements and converting them into functional requirements
• Modified Metadata Repository model based on requirements that involved customizing Out-of-the-box OracleBIAnalyticsApps Repository.
• Customized Balance Sheet dashboards based on Customer requirements.
• Designing, Development, and Implementation of all the components Confidential tier-Informatica, Scheduling Tier-DAC, Reporting Tier - Confidential, Prebuilt Dashboards and reports.
• Extracted Customer/Address/Contacts data from SFDC through Informatica.

Confidential

Responsibilities:

• Informatica 9.0.1 is used to load the Oracle EBS data into OBAW using Source Dependent Extracts (SDEs) & Source Independent Loads (SILOs), PLP and Custom Folders.
• Based on user requirements, DAC tasks and Informatica mappings have customized and DAC parameters were changed to load multiple Subject Areas into OBA Warehouse.
• Modified & Created Execution plans & tasks in DAC based on requirements.
• Configuraed Informatica servers /Connections/Logical folders setup in DAC.
• Used extensively Transformations like Lookup, Joiner, Rank and Source Qualifier,SQL transformation, Web Consumer, Normalizer in the Informatica Designer. webservice Consumer
• Transformation.
• Created Mapplets and used them in different Mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Persistent Cache.
• Developed very optimized workflows to load high volume data (500 ml ) quickly as part of history Loads.,
• Have developed Informatica Web services & These services are being consuming by Integration teams.
• Have optimized SQL & used Table partitions extensively.
• Have developed Informatica workflows to consume data from Webservices.
• Have developed Workflow to consume data from Web service.
• Created materialized views and aggregates to improve performance.
• Done a lot of SQL Tuning to improve performance.

Confidential

Responsibilities:

• Customized the Confidential Repository (physical, BMM, and presentation layers).
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Customized reporting with Confidential Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Created mockup reports and dashboards for review by the business users
• Done a lot of SQL Tuning to improve performance.

Environment: OBIA 7.9.6.3/OBIA 7.9.6.4, Confidential 11g, EBS R12,SFDC, Informatica PowerCenter 9.1, DAC, Oracle 10g, Erwin, XML, UNIX

Confidential, San Jose, California

BI Architect

Responsibilities:

• Informatica 9.0.1 is used to load the Oracle EBS data into OBAW using Source Dependent Extracts (SDEs) & Source Independent Loads (SILOs), PLP and Custom Folders.
• Based on user requirements, DAC tasks and Informatica mappings have customized and DAC parameters were changed to load multiple Subject Areas into OBA Warehouse.
• Modified & Created Execution plans & tasks in DAC based on requirements.
• Configuraed Informatica servers /Connections/Logical folders setup in DAC.
• Used extensively Transformations like Lookup, Joiner, Rank and Source Qualifier,SQL transformation, Web Consumer, Normalizer in the Informatica Designer. webservice Consumer
• Transformation.
• Created Mapplets and used them in different Mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Persistent Cache.
• Developed very optimized workflows to load high volume data (500 ml ) quickly as part of history
• Loads.,
• Have developed Informatica Web services & These services are being consuming by Integration teams.
• Have optimized SQL & used Table partitions extensively.
• Have developed Informatica workflows to consume data from Webservices.
• Have developed Workflow to consume data from Web service.
• Created materialized views and aggregates to improve performance.
• Done a lot of SQL Tuning to improve performance.
• Extracted Customer/Address/Contacts data from SFDC through Informatica.

Confidential

Responsibilities:

• Customized the Confidential Repository (physical, BMM, and presentation layers).
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Customized reporting with Confidential Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Created mockup reports and dashboards for review by the business users
• Done a lot of SQL Tuning to improve performance.

Environment: OBIA 7.9.6.3, Confidential 11g, EBS R12,PeopleSoft, Informatica PowerCenter 9, DAC, Oracle 10g, Erwin, XML, UNIX

Confidential, San Jose, California

BI Lead /Architect- Confidential /informatica

Responsibilities:

• Involved in business requirements gathering
• Analyzed Business requirements and prepared Functional requirements.
• Review the Functional and Business requirement documents with business stakeholders
• Created Informatica mappings with transformations like Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Sequence Generator, etc.
• Created the mappings, sessions and workflows as per design documents.
• Tuning the Confidential -Informatica code in Mapping level, and session level.
• Implemented various business rules of data transformations using various Informatica transformations like Normalizer, Source Qualifier, Update Strategy, Look up(connected/unconnected/static cached/dynamic cached), Sequence Generator, expression, Aggregator, XML(source and generator), Stored Procedures.
• Heavily involved with performance tuning of Oracle database - using TKProf utility, working with partitioned tables, implementing layer of materialized views to speed up lookup queries, working with Bitmap indexes for dimension tables, DBMS Stats package to update statistics, using SQL hints.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Customized the Confidential Repository (physical, BMM, and presentation layers).
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Created materialized views and aggregates to improve performance.
• Customized reporting with Confidential Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Extensively used SQL Tuning to improve performance.
• Created mockup reports and dashboards for review by the business users
• Designed and implemented Data Mart using Informatica & Teradata.

Environment: Informatica PowerCenter 8.2/8.5, Oracle 10g,Teradata Erwin, XML, UNIX, $U scheduling tool, Teradata SQL Assistant, BTEQ, Confidential