We provide IT Staff Augmentation Services!

Services Consultant Resume

New York, NY

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 Confidential Database technology, Development Tools, Hyperion Financial Management, Hyperion Planning and Budgeting Discoverer and Confidential Applications (ERP) Technology, SQL Server 2016 BI Stack, Qlik, Discoverer and Tableau
  • 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.
  • Confidential EPM 11.1.2.4 installation, configuration, migration from earlier versions
  • Confidential 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 Confidential EBS as source using Tabular Modelling in Microsoft Analysis services
  • ETL design from Confidential 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 Confidential 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 Confidential 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

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

RDBMS: Confidential 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, Confidential 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: Confidential, PBCS, DBAAS, Analytics Cloud. Amazon Redshift, Tableau Online.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Services Consultant

Responsibilities:

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

Confidential, Mountain View, CA

Services Consultant

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 Confidential Datamart to Amazon Redshift

Confidential, New York, NY

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 Confidential Data Integrator
  • Customization of Cost and Accounts Hierarchy, Account Hierarchy
  • Custom ETL with Confidential 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 Confidential 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/ Confidential Consultant

Responsibilities:

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

Confidential, Los Angeles, CA

BI/EPM Consultant

Responsibilities:

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

Confidential, North Carolina

Business Intelligence Consultant

Responsibilities:

  • OBIEE Support for Confidential 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

Business Intelligence Consultant

Responsibilities:

  • Implementation of Financial Analytics, Procurement, Employee Expenses,
  • Projects with multicurrency reporting. Implementation of Confidential 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

Business Intelligence Architect

Responsibilities:

  • 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 Confidential 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

Confidential 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 Confidential Internet Directory (OID) and single sign-on
  • SSL Enabling of OBIEE
  • Installation and Configuration of Confidential Data Integrator (ODI) ELT tool

Confidential

Business Intelligence Consultant

Responsibilities:

  • Development of Confidential Service Contracts Custom Adaptor
  • Customization of Conforming Dimensions using OBIEE, Informatica ETL and DAC
  • Aspect Communications: May 2004 Jan 2009: Confidential Business Intelligence Consultant Architect
  • Architect of a Business Intelligence solution using Confidential 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 Confidential Discoverer
  • Implementation of Confidential BIApps 7.9.5 for Financials, Supply Chain and Human Resource Analytics on Teradata. Configuration of Informatica ETL for Teradata

Hire Now