SUMMARY:

• 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 SKILLS:

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

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: /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,AWS, etc

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

Methodologies: Scrum, Agile,Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, 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, PA

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

Confidential, PA

BI Architect and Tech lead

Responsibilities:

• Understand the business needs of the finance actuarial, sales and marketing groups at Confidential 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 Confidential (Multi Dimensional databases) to the Confidential 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 Confidential 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.
• Work involved: Hyperion Financial Reports v 7.0, Hyperion Analyzer, Hyperion Interactive (8.3), Essbase

Confidential, TX

Senior BI Architect/Developer/Admin

Responsibilities:

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

Confidential

Senior Business Intelligence Architect/Developer/Admin

Responsibilities:

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