Candidates About

                               Managing consultant, Analytics & Strategy, BI Solution Architect

Experience below reflects a career in various industries & technologies over 30 years  as a contractor /consultant.       

 I work in an advisory, strategist, research role providing thought leadership developing strategies & roadmaps in technology implementations aligned with client needs & priorities. Strong business  acumen, leadership skills and comfortable managing senior level  relationships .  Keep current with evolving technologies and trends. Support transitioning from legacy to new and evolving systems, new technology implementation in projects involving BI & Analytics, Visualization, Big data.

  

Career summary:

Provided  business  metrics using a broad range of tools on multiple platforms & business domains .  

Industry  experience  in Insurance, Healthcare, Telecommunications, Retail, Public Utilities, Manufacturing, Engineering, Oil and Gas. Range of  activities  within the SDLC process from requirements gathering, client interfacing through development and implementation. Solicit business requirements from departments; confer with architects, ETL developers, business analysts, business users and upper management bringing key partners together to achieve strategic goals.

Broad  Summary  of experience below as a Managing Consultant, Strategist, BI Architect.

 

TECHNICAL SUMMARY

Emerging technologies: Cognitive & Predictive Analytics using IBM Watson, MLP,NLP 

                                                                                                Big Data & Analytics – Hadoop & ,NoSql databases, Cloudera, MongoDB, Data lakes

                                                                                                Pentaho (Kettle) & Big data integration, Sqoop

                                                                                                SPSS – Data mining & modeling for Predictive Analytics

                                                                                                Cloud-Azure, AWS, streaming Analytics

 

 

BI Tools:                OBIEE (11g,12C), Interactive Reports, Cognos(Powerplay),MicroStratg, Transformer,BIDS, B.O, Pentaho

Self- service

analytics tools:      Tableau,  Qlikview, Qliksense Alteryx

Cognitive

& Predictive Analytics:    IBM Watson,Python

Tools/Software:      EPM V 11, Essbase Studio, System 9.3,  SSAS (2008),  ERP (Oracle EBS)

Modeling tools:      Essbase Studio, Visual Studio (BIDS), Erwin, Oracle SQL developer

ETL tools:              ODI, Talend, Informatica, Toad, SQL, Pentaho PDI(Kettle)

Databases:                Oracle, Essbase, SSAS (MS Analysis Services), OLAP, DB2, Teradata, SQL Server 2008, MySQL etc,

Big Data :                 Hadoop, Cassandra, Cloudera, MongoDB, NoSQL Databases,HBase,Hive,Redshift ,etc

Languages:              Javascript, SQL, Python, SQR, MDX, PL/SQL,ABAP/4,

Methodologies:       Scrum, Agile,Waterfall

   

 

Synopsis of Oracle Hyperion BI / EPM tasks

Interactive Reports - Create dashboards, pivots, charts, reports with data sourced from Essbase , Oracle, SQL Server, Teradata, DB2, data modeling

 

Financial Reporting – Formatted financial reports, books, data Sourced from Essbase

 

Web Analysis – Online analysis, reporting data sourced from Essbase, planning

OBIEE – Design repository, Create RPD, Physical, Business, Logical layer, Presentation layer, Identification & integration of data sources, Performance Improvement, Essbase Integration, BI Publisher integration, Dashboards & Analysis.  

 

OLAP and RDBMS for Reporting and Dashboards.

 

Relational Databases: Oracle, SQL Server, Teradata, DB2, MySQL etc

Datamarts, Warehouse creation, star schemas, multi-dimensional modeling, query optimization.

 

Essbase – Essbase Admin Svcs (EAS, AAS) functions, analyzing sample reports, data sources, defining dimensions and hierarchies for block storage outlines based on report granularity, data modeling, create applications and databases, create dimensions, members, assign dense / sparse settings, consolidation order, member formulas, attribute dimensions, rules file for dimension builds and data loads, calculation scripts, tuning and optimization, ASO, Basic MDX and MaxL.  Address functionality variances between v 7 through v11. Essbase Studio.

 

SSAS – Define dimensions, hierarchies, create cubes using Visual Studio for sales marketing and actuarial applications

 

Planning – Working and process knowledge of planning.  Create application, dimensions, data load rules file, business rules, data forms, security, app settings, properties, focus on Essbase functionality within planning.

 

Emerging technologies: Cognitive & Predictive Analytics using IBM Watson, Azure,NLP, Machine learning 

                                                                                                Big Data & Analytics – Hadoop distributions,NoSql databases, Cloudera,MongoDB

                                                                                                Pentaho (Kettle) & Big data integration

                                                                                                SPSS – Data mining & modeling for Predictive Analytics

                                                                                                Cloud:Azure Machine language Svcs, AWS

PROFESSIONAL EXPERIENCE: ’85 to present (Project description- data warehouse and business intelligence)

 

 

Verizon, Alphareta,GA                                                                                                                                                                                                                                                                                                     Oct 2016- Dec 2016

Senior Analytics engineer                                                                                                                                                                                                                  

• Advisory role for evaluation of  search engine metrics on applications usage by users.
• Evaluate & Utilize Analytic tools such as Alteryx,Tableau, Aster for data management, visualizations & cognitive analytics.
• Prep,Blend data for trend & pattern evalutation & Reporting.

   

 Sabbatical (PTO)                                                                                                                                                                                                                                                                                                        Jan 2016  - Oct 2016

 

IBM, United States, Global Business Services, BA & S (Business Analytics & Strategy)                                                                April 2015 – Dec2015

Managing Consultant,  BI, Analytics & Strategy

• Function in Advisory,Consultative role & a Strategist in BI implementation. 
• Predictive Analytics, Cognitive computing using Watson & application in healthcare & financials. 
• Understand & provide a Reference Architecture in BI implementation.
•  Big Data Analytics with  Hadoop& NoSql databases.  Self- service analytical tools Tableau,Qlikview,Alteryx
• Infosphere  Informaton  Server & workings of various modules within the integrated product suite.

 

ARRIS / Motorola, PA                                                                                                                                                                                                                                                                                                      Oct 2013 – Sept2014

BI Architect,technology advisor for Common Order Management & Supply chain project. Directed & implemented strategy to transition reporting functionality from Peoplesoft & legacy systems to the Oracle space. Manage &  lead a team of  IR,OBIEE, Essbase developers, EBS 11 BSA’s, and  testers. 

•  Transition & Integration  of  Peoplesoft, Cognos Reporting environment to Oracle Supply Chain (EBS11) using IR & OBIEE Reporting tools. Provided thought-leadership & guidance for best utilization of Oracle BI stack.
•  Responsible to initiate & drive reporting strategy across 11 functional groups of the Supply Chain & Order management area.
• Migrate Cognos cubes to Essbase utilizing Essbase Studio, ODI, EAS.
• Scope & Manage offshore resources for development activities. Estimate timelines for completion of various phases within project.  

 

HUD, Washington D.C.                                                                                                                                                                                                                                                                                                     July 2013 to Sept 2013

BI Architect in Advisory role for Business Formulation & Forecasting System project

·         Working in a high level advisory role in the implementation of  the Hyperion BI stack at the Federal  Housing & Urban development department.  Evaluate  Datawarehouse structure, ensure best industry standards are implemented. Optimization and tuning of the reporting environment. Recommend appropriate utilization of COTS products  such as OBIEE, Interactive Reports. Validation of  Implementation by Implementation partner for compliance with Industry & Federal standards..   

               

 

 

RockTenn, GA                                                                                                                                                                                                                                                                                                                                    Feb 2012 to August 2012

As a BI  Architect provided guidance / consulting in developing analytics for financial, manufacturing, freight / transportation areas on the Hyperion platform. RockTenn mills produce paper, cardboard, packaging products.

•  Establish Essbase solutions that can be leveraged by multiple projects across the enterprise to address similar  business needs. Engage with key stakeholders to address business needs or problems.  
•  Leverage technical knowledge, industry trends, and other tools to identify technology options that support RockTenn technology environment.  Provided technical leadership, direction and strategy.  
• Developed blueprint to migrate Legacy transportation system to an ASO database within Essbase.
• Provided structured methodology for creating a Hyperion Planning Application.  Defined roadmap for OBIEE integration into existing reporting environment.    
•  Evaluated feasibility of using Oracle EPM tools including Essbase integration with OBIEE.
• Communicate with software vendors for selecting products to support these initiatives.
•  Verify solutions contain flexibility to adjust to future business scenarios.
• Participated in high level meetings & discussions to leverage existing technology solutions within projects.

 

Highmark Insurance, PA                                                                                                                                                                                                                                                                                 April 2011 to Oct 2011

BI Architect and Tech lead for the Model Office project.

·         Understand the business needs of the finance actuarial, sales and marketing groups at UCD and define a methodology to deliver business analytics to meet those requirements and ensure the final technical solution provides timely, accurate data for business decision-making. This included high-level design of the overall delivery solution and detailed design of all components.

·         Identify the BI tools using proprietary MDD (Multi Dimensional databases) to the DGIT team and define the processes required to utilize the tools. Essbase and SSAS were evaluated with Business Objects,Pentaho, as the reporting tool.MS Analysis Services was selected based mainly on cost factors and current licensing agreements in place.

·         Coordinated with other team members to resolve technical and functional issues within the BI environment. Provided mentoring covering star schema concepts and cube design to members on team.

·         Designed star schema warehouse to support SSAS cubes. Data sourced from IMS, DB2, flat files with data integration using Informatica. Created a TPOC on a dedicated server using Oracle tables and SSAS to host the cubes. Team members focused on defining and sourcing data elements, modeling, my task defining Oracle tables, the MDD structure, hierarchies, aggregations, loading the data, and deploying the cubes.

 

Bank Of America, RI                                                                                                                                                                                                                                                                                        August 2010 to Dec 2010

DW/BI Analyst

Hyperion System 9.3 conversion from Redbrick to MYSql for v9.3 Interactive Reports. Resolved SQL incompatibilities between databases and conducted testing through all phases--unit, QA, prod.

 

Silotech Group, FL                                                                                                                                                                                                                                                                                                            Nov 2009 to July 2010

Report (BI) Analyst/Solution Architect

Analytical role with periodic consultation over past 2 yrs as a viable Hyperion resource to aid in best practices for Hyperion product implementation for their clients, in particular EPM product suite.   Addressed performance issues at system and application level for Essbase. RPD & Analysis creation. OLAP integration in OBIEE.  

 

Nationwide, OH                                                                                                                                                                                                                                                                                                                  Sep 2009 to Oct 2009

Senior Hyperion Analyst/Developer

Development, modifications, enhancements to existing Hyperion Interactive and Hyperion reports. Essbase and Teradata as backend data sources.  Performed query tuning and optimization.   Work involved: Hyperion Financial Reports v 7.0, Hyperion Analyzer, Hyperion Interactive (8.3), Essbase 

 

EPCO, TX                                                                                                                                                                                                                                                                                                                                                            Jul 2007 to Aug 2008       

Senior BI Architect/Developer/Admin

Epco is a leading North American provider of midstream energy services to producers and consumers of natural gas, crude oil and petrochemicals. Work involved using Oracle tables from their financial and EMPAC (EAM system) and creating data models for interactive reports.   Develop EIS (dashboards) apps using Javascript to drive interactive, Pivot, Charts and formatted batch reports.  Create data models for accounting, procurement, and inventory reports. Ad hoc and custom reports using SQL queries derived from these models. Query optimization, Data validation using Toad. Utilized Essbase Admin Svcs. for creation of database outlines and hierarchies, rules file, calc scripts, data loads.

Involved with tuning and optimization, web analysis, financial reporting, planning, system 9.3 migration. Migration to OBIEE.    

 

Bell South                                                                                                                                                                                                                                                                                                                                                             Jul 2006 to Dec 2006

Senior Business Intelligence Architect/Developer/Admin

Responsible for new implementation of Hyperion Performance tool as part of Application support group, developed dashboards, Javascript. Also converted Crystal Reports (Business Object) to Hyperion Intelligence. Performed server side administration to create and manage users and groups, access privileges, folder setup etc.      

 

Royal Caribbean Cruise Lines, FL                                                                                                                                                                                                                                                               Aug 2004 to Feb 2006

Senior BI Architect/Developer

Working on Enterprise data warehouse implementation project. Scoping, requirements gathering, design. Focus on converting legacy reports to Hyperion 8.X environment, ensuring data and entity mapping integrity. Data integration, transformation. Used administration function on the portal to create users and groups, access privileges and adaptive states for published documents. Develop EIS / dashboards. Essbase 7.xx, data modeling, create cubes, admin functions

 

Timken, Canton, OH                                                                                                                                                                                                                                                                                                         Apr 2004 to Jun 2004      

Senior Business Intelligence Analyst/Developer

Created Industrial Performance Metrics dashboard for a leading manufacturing company using the 8.1 release of Hyperion Intelligence products. Dashboard development using EIS, Javascript on Explorer.

                                                                               

 

U.S. Dept of Agriculture (Unisys), St Louis, Mo                                                                                                                                                                                                         Nov 2003 to Jan 2004

Senior Hyperion Analyst/Developer

Created custom financial reports at state and national level for various departments within agency. Data derived from Oracle Financial applications.  Create dashboards, data modeling

 

Norfolk Southern, Roanoke, VA                                                                                                                                                                                                                                                                    Apr 2002 to Aug 2003

Senior Solution Architect/Developer

Involved in financial data warehouse implementation (full lifecycle), at a leading transportation company.  Scoping, requirements gathering. Used Brio for data analysis/validation, generating reports and dashboard/EIS applications for

end-users. Server administration.   Query optimization and tuning. Data modeling, used meta models.  Major decision making responsibility in EIS / dashboards and reports development, with user interaction at management level in areas of revenue, accounting and cost.

 

Cigna Insurance, Hartford, CT                                                                                                                                                                                                                                                                                                                      Nov 2001

Brio Analyst/Developer

Turn-key assignment to develop EIS interface model for Claims and Reimbursement reports using Brio (6.5), DB2.   

 

Bonneville Power, Portland, OR                                                                                                                                                                                                    Mar 2001 to Aug 2001 and Mar 2002

Senior Brio Architect/Developer

Worked at Dept of Energy, supported Utility operations with a data warehouse implementation

Used Brio Designer 6.2 to create EIS dashboard interface and reports for inventory management, data modeling, validation, cleansing, creation of views and tables, query tuning and optimization.

 

Washington State, Olympia            , WA                                                                                                                                                                                                                                                       Oct 2000 to Feb 2001

Senior Brio Analyst/Developer

Worked on data warehouse outreach project, used Brio Enterprise 6.2 to generate EIS / dashboard interface for Legal, Fiscal, and Field Services applications.  Created data models, data extracts, custom SQL, and pivot reports.

 

Yale University, New Haven, CT                                                                                                                                                                                                                                                                                                                   Sep 2000

Trainer

Training and mentoring IT staff in use of Brio and Javascript, new implementation of Brio required accelerated hands on training of users with legacy systems background

 

Priceline.com, Inc., Norwalk, CT                                                                                                                                                                                                                                                         May 2000 to Aug 2000                        

DW/BI Analyst/Developer

Working at a premier .com company in the data warehousing group using Javascript, Oracle (8), data warehouse, Informatica, SQL Navigator

·         Used Brio Enterprise 6.1 and associated components to provide high level management reports in areas of agent performance assessment, and travel services.

·         Created data extracts using Brio for end-users using Excel formats.

·         Created mappings and sessions using Informatica Powermart 4.5.2 for data transfer from source to target.

·         Used SQL Navigator tool  for query optimization and creating models 

 

Premier, Inc., Charlotte, NC                                                                                                                                                                                                                                                                           Mar 2000 to Apr 2000                

DW BI Analyst/Developer

Premier provides comparative data products to pharmaceutical and healthcare organizations for decision support and benchmarking.

·         Used REDBRICK data warehouse with Brio Enterprise 6.0 and Javascript to deliver business intelligence and analytical applications. Created reports, pivots, charts and used Executive Interface System (EIS), for data interface. Did performance analysis on SQL queries and web deployment of products using Citrix Server.

 

 

Liberty Life Corp., Greenville, SC