SUMMARY:

• Managing consultant, Analytics & Strategy, BI Solution Architect
• Experience below reflects a career in various industries & technologies over 30 yrs 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.
• 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 Confidential 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: Confidential Watson,Python

Tools: 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 etcBig Data Hadoop, Cassandra, Cloudera, MongoDB, NoSQL Databases,HBase,Hive,Redshift, etc

Languages: Javascript, SQL, Python, SQR, MDX, PL/SQL,ABAP/4Methodologies 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 Confidential 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:

Confidential, Alphareta, GA

Senior Analytics engineer

Responsibilities:

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

Confidential

Managing Consultant, BI, Analytics & Strategy

Responsibilities:

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

Confidential

BI Architect

Responsibilities:

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

Confidential, Washington, DC

BI Architect

Responsibilities:

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

Confidential, GA

BI Architect

Responsibilities:

• 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 RockTenntechnology 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.

Confidential, PA

BI Architect and Tech lead

Responsibilities:

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

Confidential, RI

DW/BI Analyst

Responsibilities:

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

Confidential, FL

Report (BI) Analyst/Solution Architect

Responsibilities:

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

Confidential, OH

Senior Hyperion Analyst/Developer

Responsibilities:

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