SUMMARY

• I am a seasoned Business Intelligence (BI) Architect with decades of experience in implementation of large scale distributed Data warehouse, Business Intelligence applications and products in Online Banking, Finance, Retail, Internet Marketing
• Experienced Techno - functional professional Oracle Database technology, Development Tools, Hyperion Financial Management, Hyperion Planning and Budgeting Discoverer and Oracle Applications (ERP) Technology, SQL Server 2016 BI Stack, Qlik, Discoverer and Tableau
• Worked for Oracle Corp, PriceWaterhouse Coopers, Confidential, Confidential and Confidential . Started career in specialized areas like VLSI Design and Space Research
• Installation, Configuration and Administration of OBIEE
• Migration of Discoverer Business Area to OBIEE Repository
• Implementation of OBIEE 11g, BIApps 7.9.6.4, BIApps 11g, Financials, Supply Chain, Procurement, Projects, Manufacturing and Human resource Analytics.
• Oracle EPM 11.1.2.4 installation, configuration, migration from earlier versions
• FDMEE data integration and write back to EBS
• Installation and configuration of SQL Server 2016 for high performance and Real-time Operational Analytics and In Memory OLTP
• Datawarehouse Design with Oracle EBS as source using Tabular Modelling in Microsoft Analysis services
• ETL design from Oracle EBS and Salesforce using Microsoft Integration Services
• Visualization with PowerBI Desktop, Server and Reporting Services
• Installation, configuration of Tableau Server 10.x. Tableau administration skills
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices
• Migrated Dashboards from Oracle BI to Tableau
• Developing visualization from Amazon Redshift, Hadoop and various relational data sources
• Passionate about finding insights in data Experienced in working with large datasets and using advanced data analysis to answer complex questions with accuracy
• Used R, SQL, Python for Historical Sales data analysis and forecasting. Deployed the R application in both Oracle R engine and SQL Server R Services

TECHNICAL SKILLS

BI Tools: OBIEE 10g, 11g, BI Publisher, Informatica, Discoverer 10g, Hyperion Essbase, Discoverer, Tableau and Qlik, SQL Server 2016 and PowerBI

Oracle ERP/CRM/EPM: Oracle Application R12/R11i, Oracle Hyperion EPM 11.1.2.

RDBMS: Oracle 11g, Amazon Redshift, SQL Server 2016, MySQL

Programming Languages: SQL, PL/SQL, C, Pro*C

Data Science Languages: Python, R for Statistical Computing.

Software/Tools: OBIEE Answers, RPD Design Tools, Informatica, Oracle Data Integrator 11g and 12c, DAC, SQL*Plus, PL/SQL, SQL*Loader, Essbase, EPM Tools

Operating Systems: Linux, UNIX (HP, Solaris, IBM - AIX) Windows Server, Mac OSx

Cloud Infrastructure: Oracle BICS, PBCS, DBAAS, Analytics Cloud. Amazon Redshift, Tableau Online.

PROFESSIONAL EXPERIENCE

Confidential, New York NY

Oracle Analytics Services Consultant

Responsibilities:

• Migration of OBIA 11g to Oracle Analytics Services, DBAAS Cloud Services. Setting up for ODI Cloud services and Oracle Analytics Services integration with Hyperion Planning Cloud PBCS
• Performance Tuning of Oracle Analytics Services Dashboards
• Customization of ETL routines to implement component based costing using Oracle Data Integrator tool 12c
• Development of Predictive maintenance module using Python, R, SQL, Microsodoft Machine Learning Services.

Confidential, Mountain View, CA

Responsibilities:

• Design of Salesforce Services datamart
• Star Dimension modelling for SalesForce Datawarehouse using SQL Server 2016 Analysis Services
• Data load from Salsforce using Microsoft SSIS
• Data replication from Salesforce to SQL Server using Scribe
• Development of Dashboards with Microsoft PowerBI. And Reporting Services
• Migration of Oracle Datamart to Amazon Redshift

Confidential, New York NY

Oracle Business Intelligence Consultant

Responsibilities:

• Implementation of OBIA 11g Financial Analytics, Projects Analytics, Procurement Analytics and Human resource analytics
• Migration of OBIEE 11g rpd, catalog and security to OBIE 12c Technology stack. Modified to OBIEE 12c visualization for mobile devices. Migrated Informatica Workflows to Oracle Data Integrator
• Customization of Cost and Accounts Hierarchy, Account Hierarchy
• Custom ETL with Oracle Data Integrator 11g for Projects Costing, Supplier Performance and Journal Lines.
• Migration of Legacy DB2 datawarehouse GoldApple to SQL Server 2016 database.
• Physical redesign of the datawarehouse to utilize SQL Server 2016 improved in-memory OLTP engine, in-memory columnstore, and Azure cloud integration.
• Development of custom ETL programs using Oracle Data Integrator for Procurement analytics and Legacy datawarehouse
• Development of Dasboards with PowerBI, and Tableau
• Implementation of Noetix modules in Finance and Human resource analytics

Confidential, Milpitas CA

BI/HFM Consultant

Responsibilities:

• Migration of Oracle HFM from 4.x to 11.1.2.4
• Responsible for data load through FDMEE and Oracle Data Integrator from 25 different entities.
• Implementation of Security Groups for entities with FDMEE
• Custom ETL with FDMEE and Oracle Data Integrator11g on SQL Server 2016 database
• Development of Performance monitoring scripts in SQL Server 2016
• Patching the HFM and FDMEE modules
• Training on Administration, Smartview and FRG Reporting tool

Confidential, Los Angeles CA

BI/EPM Consultant

Responsibilities:

• Implementation of Sales Analytics on Oracle BI Cloud Services (BICS) stack
• Development of Sales Analytics data model. ETL load with Oracle Data Integrator, Data Sync and REST API
• Installation and administration of EPM Planning 11.1.2.4
• Responsible for data load through FDMEE and Oracle Data Integrator11g
• FDMEE Customization for EBS actual data load
• Custom Budget data load
• Smartview And Financial Reporting Studio report development
• EPM Administration
• Custom ETL with FDMEE and Oracle Data Integrator11g

Confidential, North Carolina

Oracle Business Intelligence Consultant

Responsibilities:

• OBIEE Support for Oracle Argus Products.
• BI Performance tuning of Quintile Infosario software platform which integrates the data and processes associated with a drug's life cycle and includes a data engine to collect, clean and prepare data for analysis

Confidential, Foster City, CA

Oracle Business Intelligence Consultant

Responsibilities:

• Implementation of Financial Analytics, Procurement, Employee Expenses,
• Projects with multicurrency reporting. Implementation of Visa Credit Card Analytics
• Discoverer Financial Consolidation with Intercompany elimination
• Development of Custom ETL with Informatica
• Implementation of Service Dashboards with Tableau Server and Tableau desktop. Installation and administration of Tableau server. Tableau Dashboards from Salesforce data. Embed Tableau visualizations and sales dashboards into Salesforce Canvas

Confidential, Los Angeles, CA

Oracle Business Intelligence Architect

Responsibilities:

• Implemented OBIAv 7.9.6.x for clients: Aero Vironment, Strumm Ruger, Hitachi Corp, Mitsui Foods. Amy’s Kitchen, Beats Electronics, Kama Gmes Moscow.
• Implementation of OBIEE 7.9.6.4 HR Analytics, Supply chain and Procurement Analytics, Financial Analytics, Projects Analytics, Manufacturing analytics., Agile PLM Intelligence. Implementation of Hyperion EPM, technology architect. ETL development.
• Design of custom datamart and development of custom Subject Area on Manufacturing. POC of Oracle Manufacturing Analytics
• Implemented Manufacturing analytics in OBIA 7.9.6.4 and OBIA 11g Enterprise Asset Management Analyticsand integrated with Supply chain Analytics. Implemented discrete and process manufacturing organizations optimize their supply networks by integrating data from across the enterprise value chain. Cusomized Work Otder Component based Costing ETL.
• Implemented Vanilla Manufacturing Analytics in Discrete manufacturing environment for Sunflower Electric in OBIA 11.1.10 version.

Confidential, Washington, DC

Oracle Business Intelligence Consultant

Responsibilities:

• As the BI Architect configured the OBIEE Technology stack at the Confidential Data Center
• Installation and Configuration of OBIEE High Availability Cluster in Production environment
• Integration of OBIEE with Oracle Internet Directory (OID) and single sign-on
• SSL Enabling of OBIEE
• Installation and Configuration of Oracle Data Integrator (ODI) ELT tool

Confidential

Oracle Business Intelligence Consultant

Responsibilities:

• Development of Oracle Service Contracts Custom Adaptor
• Customization of Conforming Dimensions using OBIEE, Informatica ETL and DAC
• Aspect Communications: May 2004 Jan 2009: Oracle Business Intelligence Consultant Architect
• Architect of a Business Intelligence solution using Oracle OBIEE 10.1.3.4, application design and configuration, technical architecture, integration, testing, conversion and deployment for Salesforce Intelligence, Projects Intelligence custom analytics modules. Integration of OBIEE with Sales Force and Hyperion Essbase database.
• OBIEE Administration, Installation and Configuration
• Migration from Business Objects to Oracle Discoverer
• Implementation of Oracle BIApps 7.9.5 for Financials, Supply Chain and Human Resource Analytics on Teradata. Configuration of Informatica ETL for Teradata

Confidential

Oracle Business Intelligence Consultant Architect

Responsibilities:

• As an Associate Director for Technology Consulting, involved in global (USA, Canada, UK, Europe and Asia Pacific) implementation of Oracle Applications 11i for GL, AP, AR, HR, PA and RMS
• Directly responsible for managing the DBA team and Report Development team
• Oracle 11i Business Intelligence System Assessment, Configuration and Implementation. Installation and Configuration of Discoverer 3i and 4i Server
• Installation and Maintenance of End User Layers (EUL)
• Design and development of Discoverer Reporting Repository and Summarization processes
• Creation of Custom Business Area and Discoverer Administration in Development and Production environment
• Implementation of Daily Business Intelligence 6.0 for Financials and Project Intelligence