SUMMARY:

• Well - versed in architecting Business Intelligence Systems, physical data warehouses, SAP Business Objects XI & BI 4.x, MicroStrategy, Pentaho, Qlikview, Tableau, Jaspersoft, Cognos, and SAP HANA implementations. Effectively advances efficient productivity within teams and motivates people to achieve higher standards.
• Strong ethics and takes responsibility for financial statement representations.
• Extensive working knowledge of all stages of Business Intelligence development in the retail, healthcare, financial services and pharmaceutical industries.
• Captures industry best practices and infuses into the corporate standard..
• Demonstrated experience building and leading high-performance Analytics teams.
• Extensive management and hands on experience in developing Business Intelligence solutions in Retail, Healthcare, Financial Services, Oil & Gas, Government and Pharmaceutical domains.
• Proven ability to listen and communicate with C-level executives and senior management to achieve desired results.
• Strong technology skill set and implementation experience with multiple business intelligence/ETL tools: SAP HANA, MicroStrategy, Pentaho, Qlikview, Tableau, SAP Business Objects, Xcelsius, Jaspersoft, Crystal Reports, Microsoft (SSRS, SSAS, SSIS), Cognos, EPIC Clarity 2012, Power View for Excel, Datawatch Modeler, SAP Power Designer, Oracle (OBIEE), PL/SQL, Teradata, SQL, T-SQL, Informatica, Datastage, Deltek Maconomy BPM and MS SQL Server.

AREAS OF EXPERTISE:

Business Intelligence

• Leader in Business Intelligence strategy formation, big data analytics, and executive consultation.
• Leader of Analytics Team that won the TDWI 2010 Best Practices Award for Data Warehousing and Business Intelligence for a Non-Profit group utilizing QlikView data visualization tool and Jaspersoft.
• Expert in designing SAP HANA/Business Objects XI 3 and BI 4.x, Xcelsius Dashboards, and Web Intelligence Reports. Migration expertise in SAP BW and ECC data into SAP HANA.
• Ability to customize EPIC universes to meet healthcare systems specific reporting/dashboard needs.
• Certified in development of MicroStrategy (9.02) projects, dashboards, documents, reports & Mobile BI.
• Lead designer of Capital Risk Management dashboard for leading Global Investment Bank, helping to define their Business Intelligence Strategy and designed the logical data model to create web intelligence reports linked to the dashboard.
• Project leader for Confidential Business Intelligence strategy and implementation of sales and marketing revenue reporting system via Business Objects XI 2.0 installation on Oracle 10g.
• Project Manager of corporate-wide “agent analytics” dashboard incorporating actionable metrics for Leading North American Insurance Company.
• Industry pioneering leader in designing Executive Business Intelligence systems using PDA’s for a national retailer; invented a process to transform mainframe report information into a database designed for the HP200 LX handheld PDA for use by CEO and Chairman of the Board.
• Developed “Best Practice Dashboard Selection tool” for client to select the best Dashboard tool (Xcelsius, Dashboard Manager, Performance Manager) used by SAP/Business Objects.
• Business Objects XI 3 and BI 4.x implementer, MicroStrategy Developer, trainer, data warehouse and universe designer for retail, healthcare, financial services and pharmaceutical companies.

Data Warehouse and Data Mart Development

• Provided data governance and managed enterprise and global data warehouse implementations including: Ingenious Med, State Fund of California, Confidential, Confidential, CHS, Confidential Insurance, Confidential, Confidential, Lifeway Stores and Service Merchandise.
• Dimensional Data Model developer of the North Dakota State Government - Eligibility Reporting (EDM) data mart for the DHS dept. use in state and federal ACA Medicaid Eligibility reporting on Oracle 11g.
• Designed the physical database schema and the logical data model of a large Physician Prescription Data Warehouse, managed performance, created star schema design for the Business Objects Universe, consulted with business users to develop reports and implement security on Oracle 10g.
• Data Architect and Modeler, Logical Data Modeling and Physical Data Modeling projects in Healthcare, Retail, Manufacturing, Insurance, Government Services and Financial Services. (Primarily using Visio, Sybase Power Designer, SAP HANA SPS3, Oracle databases 8-11g and SQL Server )

Healthcare and Financial Systems Conversions and Innovations

• Successfully implemented Pentaho Enterprise Edition 5.0 BA and DI servers for a Pharmaceutical therapy management company and their CMS Part D Stars client report portal project.
• Financial Systems conversion expert that converted healthcare patient data sets for chain of hospitals (65) into a new McKesson Horizon system format adhering to clinical standards.
• Successfully implemented large scale (JDA) ERP system for 400+ multi-store retail chain.
• Designed, developed and implemented the process of transferring mainframe report information by download to personal computer for use in spreadsheet and/or database models and saving $1 million in annual labor and paper costs while increasing the speed of information delivery.
• Merchandise Reporting Manager for large-scale Catalogue retailer, designed and programmed the first web page to start E-Commerce and Internet capability.
• Initiated the start-up training of Internal Auditors and Loss Prevention Analysts in a mid-sized retailer (100+ Stores) and helped company develop new procedures for identifying employee theft through centralized daily sales transaction auditing resulting in realized loss reduction of $250,000 in first year.

TECHNICAL & BUSINESS SKILLS

Business Intelligence: Business Objects Enterprise 5x/6x/XI 2.0, 3.1, 4.0, Web Intelligence 5x/6x/XI 2.0,3.1,4.0, Business Objects Supervisor /CMS/CMC 5x/6x/XI 2.0, 3.1, 4.0, Business Objects Designer 5x/6x/XI 2.0,3.1, 4.0, Query as a Web Service XI 2.0,3.1, 4.0 Live Office, Crystal Xcelsius 4.5, 2008 Dashboard Designer, EQM Deployment Explorer, Microsoft Dynamics, SSRS, MicroStrategy 8.0, 9.2 certified, 10, BIRT Mobile, Actuate, Pentaho BI Suite, Talend, Oracle BI (OBIEE), BOSS reporting, EQM Deployment Mgmt., Tableau Visualization - VizQL 8.0, 9, SAP BW/BI, Tableau Desktop v3.0, 8.0, BIDS - Microsoft SSAS,SSRS, Tableau Pro 3.6, 8.0, 9.0, Tableau Server 1.6, 8.0, Cognos 8.0, 10, Framework Manager, Qlikview 8.1, 9.0, 10.0 and 11, BizAgi Process Modeler, Jasper Reports, Jaspersoft, SAP HANA 1.0 SPS03, SAP HANA RDS-Operational Reports, SAP BI 4.0, SAP Lumeria, SAP Predictive Analytics, ProClarity Professional Pentaho BA Enterprise 5.0, Pentaho Instaview 5.0, Pentaho Mobile, Qlik Sense (2014, 2015, 2016), Deltek Maconomy BPM Reporting, Google Data Studio, Amazon QuickSight,Programming SQL, T - SQL, SQL ANSI92, PL/SQL, JavaScript, JSON, HTML, HTML5, COBOL, VBA, .Net, XML

Operating Systems & Networking Technologies: MS WinNT4, MS/DOS, Win2K, XP, Win 7, TCP/IP, VM Ware, Novell

Database, Data Warehouse, ETL & OLAP Technologies: Oracle 8i /9i / 10g /APEX / 11g, MS SQL Server, MySQL, PostgreSQL, Win 2003, 2008 Server, Teradata SQL, IBM WebSphere, IBM Initiate, Informatica PowerCenter 8, MS SQL Server 2005 SSIS, JDA (ERP System - Retail), IBM DB2/AS400/Neteeza/QMF 10.1, Sybase IQ, Sybase Unwired Platform (SUP), SAP R3, SAP BW, ECC, Data Services, DataStage, Expressor, SQLite, SQL Server 2008 R2, SSIS, SSRS, SSAS, Sybase Power Designer 16.1, ADABAS, PLSQL Developer, Pentaho Data Integration 5.0, Kettle, Spoon, Team Foundation Server ALM, Alteryx 10.6, DM Express, JIRA, Tortoise SVN

Internet Development: Tomcat, Joomla, Apache HTTP Server, MS Internet Information Server

Applications: MS Word, Excel, PowerPoint, Visio for Enterprise Architects, ModelRight 3.0, MindMap Manager, MindJet, CA ErWIN Data Modeler 7.3, Monarch Pro, Data Pump, TOAD, iRise, @Task, MS Office Win any/XP/2013, SQL*Plus, QVScriptor x86, Lotus Notes, SameTime 6.5, SharePoint (MOSS 2007), Win/DSS/MMS, Tortoise SVN, JIRA, JDA Arthur Enterprise Planning, Maconomy Reporting - Deltek, PowerPivot & Excel 2013, Google Apps, Github, Lean Kit

Healthcare Technologies: EPIC Clarity 2012, 2014, MEDIPAC, PROCLARITY, HL - 7, McKesson Horizon Applications, ACORD XML, IM Bills (Ingenious Med), ICD-9 and ICD-10, CPT

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Engineer/Consultant

Responsibilities:

• Works with Business Innovation team members and recommends new business intelligence solutions for a variety of internal Confidential business areas.
• Develops CRM ROI and Marketing Management strategy and consolidates new data sources into new enterprise marketing dashboards and reports.
• Reviews, develops and suggests edits to Tableau, QlikView and MicroStrategy dashboards across internal clients at Confidential .
• Designs ETL workflows for Business Intelligence projects using Alteryx 10.6 and DM Express.
• Collaborates with Clinical Research to develop a Tableau Dashboard for alerting hospital management when swab and bathing protocols are met/not met for patients in CCU.
• Responsible for analyzing and documenting the needs of internal Confidential clients to help identify problems and propose solutions, liaise with internal business stakeholders, architects, and developers.
• Develops new uses for SAP Business Objects Universes and connects them to other BI Tools.

Confidential

Sr. Business Intelligence Contract Consultant

Responsibilities:

• Develops Horizon Practice Plus quality care reports that meet the State of Mississippi Dept. of Health requirements for hospital compliance reporting.
• Trains client analytics team on best practices in SAP Business Objects WEBI report design and formula creation techniques.
• Conducts GoToMeeting training sessions with key report designers of client teams.
• Recommends transition strategy steps to client in converting SAP Desktop Intelligence (DESKI) reports to Web-Intelligence (WEBI) reports in order to prevent risk when SAP drops support for DESKI report software.
• Consults with hospital systems on Accountable Care Reporting initiatives and MACRA bundled payment analytics to improve revenue for hospital and physician practice groups.

Confidential

Associate Director

Responsibilities:

• Develops database models and consolidates databases into new enterprise dimensional databases.
• Researches best data modeling tools and recommends best enterprise data modeling software.
• Performs reverse engineering, Logical and Physical Data Model development tasks on numerous databases and utilizes SAP PowerDesigner to remodel databases.
• Project Manager of Data Modeling and worked with international teams across 5 countries in agile methods to revise 132 databases and data sources for Tableau and SAP Business Objects.
• Trained and Mentored Confidential staff in Best Practices for Requirements gathering and Dimensional Data warehouse design and modeling (following Ralph Kimball methodology).
• Works with Tortoise SVN, JIRA, SQL, SAP PowerDesigner, SAP Business Objects, ERWIN, Oracle, and Tableau.

Confidential

President

Responsibilities:

• Consults with clients to help develop Business Intelligence and Digital Transformation strategy and Roadmap.
• Gathers requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, use cases, business analysis, task and workflow analysis.
• Engages for short term contracts to assist clients in database customization, performance tuning, and/or resolution of backlog reporting /dashboard requests, utilizing a variety of Business Intelligence software tools.
• Recent project involved taking EPIC Clarity 2012 universe (Notes) and customizing to meet healthcare client reporting requests.
• Frequently engaged to mentor client teams and provide project management of Business Intelligence implementations.
• Provides remote Business Intelligence services (data modeling, report development, dashboard design) on a contract basis.

Confidential

Sr. Business Intelligence Consultant

Responsibilities:

• Consult with North Dakota State Govt. to help develop Business Intelligence strategy and Roadmap.
• Reviewed current and proposed Business Intelligence state of Dept. of Human Services (DHS), State of North Dakota, and lead the requirements gathering process and data mapping process to develop a new ACA Eligibility System Data Mart.
• Mentored DHS staff on approaches to operational and analytical reporting to produce effective reports.
• Provided DHS with Business Intelligence processes and mentoring in developing strategic reporting.
• Planned and implemented the Business Intelligence Reporting of the Eligibility System Modernization project for DHS and ITD for the State of North Dakota.
• Trained and Mentored DHS staff in Best Practices for Requirements gathering, ETL, and Dimensional Data warehouse design and modeling (following Ralph Kimball methodology).
• Developed Sybase Power Designer models and wrote Oracle stored procedures for staging tables to target tables and consolidating three different data sources into one Oracle database.
• Lead the dimensional data mart mapping and design of the Eligibility Data Mart (EDM).
• Experienced in transforming logical business requirements into appropriate schemas and models.
• Drives collaboration with the Oracle DBAs & Oracle Data Integration Leads to achieve BI objectives.
• Extensive use of the following tools: SAP Powerdesigner, COGNOS, Qlik Sense, Sharepoint, PLSQL, Oracle, Excel and Word.

Confidential

Remote Pentaho Developer

Responsibilities:

• Installed and implemented Pentaho Business Analytics Enterprise Edition 5.0 and Data Integration 5.0 for Confidential.
• Served as the contract Pentaho Report and Dashboard developer remote resource for HP client report portal (a cloud based- Pentaho Proof of Concept).
• Designed Pentaho reports and dashboards and accessed HP’s SAP Business Objects as a data source in order to meet user “Proof of Concept” needs and reporting objectives.
• Presented final Pentaho reports and dashboards to client (HP) for evaluation.

Confidential

Business Intelligence Manager

Responsibilities:

• Develop new Microsoft (SSRS) reports and modify existing client reports as requested.
• Serve as the corporate consulting resource for questions related to Management reporting and Business Intelligence development.
• Work with Office 365 and SQL Server 2008 (Empire Time) time and expense database.
• Critically evaluated information gathered from multiple sources, reconciled conflicts, decomposed high-level information into details and distinguished user requests from underlying true needs.
• Developed Tableau dashboards in Proof of concept demonstration.

Confidential

Business Intelligence Lead Developer

Responsibilities:

• Installed and implemented Pentaho Business Analytics Enterprise Edition 5.0 and Data Integration 5.0 for this pharmacy medical therapy management (MTM) company.
• Served as the contract Business Intelligence developer resource for implementing Pentaho reporting, dashboard and corporate client report portal development.
• Designed, updated and managed Pentaho reports and dashboards to meet user needs and reporting initiatives.
• Trained staff in all aspects of using the Pentaho Enterprise report and dashboard software.
• Designed Pharm MD “Star Cards” for existing and new client use.
• Administered the Pentaho Business Intelligence Enterprise for Pharm MD.
• Developed and rolled-out Pentaho Mobile for iPad customers of Pharm MD to quickly access dashboards.

Confidential

Business Intelligence Lead Developer-SAP Business Objects

Responsibilities:

• Develop new Business Objects (WEBI 4.0) reports and modify existing client reports as requested.
• Serve as the corporate consulting resource for questions related to Deltek Maconomy /Business Objects reporting and Business Intelligence development (new Universe design).
• Customized Deltek Maconomy BPM Reports and modified underlying Business Objects universes.
• Update and modify universes to meet user needs and Deltek Maconomy BPM reporting initiatives.
• Experience with establishing interfaces and data feeds from external structured and non-structured data sources.
• Mentor client staff in developing better Deltek Maconomy BPM report writing skills and understanding of universe design.

  Confidential is the TOP Accounting Firm in Tennessee. Confidential is one of the Top 100 VAR's in the Nation.

Confidential

Senior Consultant

Responsibilities:

• Advising Universe Design changes/additions to improve reporting capabilities on a Global scale.
• Confidential where I was engaged in a short term contract to provide Global Reporting services using Business Objects XI 3.1 and assisting in the migration to BI 4.0 before year end.
• Performing specialized SQL design within the WEBI report(s) and training client staff in developing Global P&L reports utilizing SAP Business Objects Web Intelligence reports.
• Specifically designed a better Drill Filter that cascades down to specific segments via customized LOV.
• Consolidation of joint ventures (countries) into EDW main Global P&L reporting, utilizing WEBI.

Confidential

Sr. Business Intelligence Contract Consultant - QlikView Dashboard Designer

Responsibilities:

• Responsible for developing the overall data schema model and dashboard layout covering over 20 Key Metrics for client loyalty rewards card program and developed customer sentiment analytics.
• Consults with client to gather dashboard requirements, understand business processes, and data sources in order to develop the executive Loyalty Program dashboard. (QlikView)
• Designing the client’s Loyalty Program executive dashboard using QlikView program and writing SQL scripts to access the data sources in Oracle and SQL Server databases in order to develop customer sentiment analytics.
• Contracting role - using broad skill sets in Business Intelligence:(Data modeling, QlikView, Oracle, SQL Server, SAP Business Objects, Best Practices Coaching) working with client executive BI users.
• Consulting with client in numerous focus areas (Marketing, Operations, and Customer) to improve executive insight into KPI’s on the Executive Loyalty Dashboard. (known as MAPCO Rewards)
• Provided knowledge transfer and business intelligence training for this oil and gas company.

Confidential

Sr. Consultant, BI Data Modeler, SAP HANA

Responsibilities:

• Implemented SAP HANA - RDS Operational Reports for large building products client in Midwest.
• Mentors client associates in Best Practices in Business Intelligence and developing SAP HANA databases, Business Objects Universes, WEBI/Crystal reports and Xcelsius dashboards.
• Consults with clients to gather report requirements, business processes, and data sources in order to develop SAP HANA data model for faster reporting.
• Manages, designs and implements SAP HANA and Business Objects 4.0 reports, explorer infospaces, and dashboards for clients.
• Develops Functional SAP HANA Data Foundation and Report Requirements documentation for client deliverables.
• Analyzes reports and user cases to develop data models and big data analytics for SAP HANA database development.
• Develops SAP HANA Modeling Best Practices for Confidential consultants to practice with clients.
• Architects models and develops analytic views and calculation views for SAP HANA client projects.
• Strong understanding of SAP HANA In-Memory platform, installation, data migration and upgrades.
• Develops ETL process scripts for SAP HANA from SAP BW and ECC data sources with Data Services.
• Creates big data analytics using SAP HANA.
• Obtained USDA security clearance.

Confidential

Manager/Architect

Responsibilities:

• Consults with clients to help develop Business Intelligence strategy, select BI tools, implement business intelligence tools and mentors client staff.
• Managed and created 20 Microsoft SSRS reports and designed 5 (SSRS) dashboards for a new Business Intelligence offering for a healthcare software company.
• Gathered requirements and developed new Open Source prototypes for client review, to improve corporate reporting efficiency using Pentaho, JasperSoft, and Tableau software.
• Worked with Microsoft BI stack (SSRS, SSIS, SSAS, and PowerPivot for Excel) in a SQL Server 2008 environment in development of an Enterprise wide system design, structure and usage deliverable.
• Trained in Composite virtualization software.
• Prepared and presented proof of concepts (POC’s) from MicroStrategy, Pentaho, Tableau, and SAP Business Objects for client consideration in OEM’ing the Reporting and Dashboarding features into their software. Client eventually selected MicroStrategy as their OEM tool for BI dashboards and reports.
• Client - Ingenious Med - “IM1” is currently one of the best-selling Physician Billing software tools.

Confidential

Senior Consultant/Owner

Responsibilities:

• Consults with clients to help develop Business Intelligence strategy and Roadmap.
• Attended training and passed certification in MicroStrategy Project Design (CPD), Report Design (CRD) and Document/Dashboard Design (CDD)
• Demonstrated ability to create MicroStrategy Dashboards and Mobile BI Solutions that enabled an Enterprise Wide Mobile Business Intelligence solution for client.
• Completed advanced training in the design of Mobile Business Intelligence Apps for iPad, iPhone and Blackberry devices. Certified in Microstrategy Mobile BI.
• Gathered requirements and helped internally to develop new ETL process for client in order to improve corporate reporting efficiency.

Confidential

Manager of Analytics

Responsibilities:

• Managed a team of statistical analysts, (Jasper) report writers, Oracle 10g database developers, and Qlikview creators..
• Gathered report requirements and documented metrics to produce behavioral health reports and dashboard visualizations delighting the business users and management stakeholders.
• Mentors and trains staff in best practices for business intelligence requirements gathering, role and security setup, database design, and visualization development using Qlikview in-memory tool.
• Prepared and demonstrated Qlikview capabilities and productive features to key stakeholders.
• Successfully completed (3 Year) CARF certification requirements by compiling clinical data sets and adhering to clinical standards resulting in the analytics team receiving an “Exemplary” rating.

Confidentia

Business Intelligence Technical Lead Consultant

Responsibilities:

• Prepared and demonstrated Business Objects XI r3 capabilities and productive features to key stakeholders in a large west coast Insurance company.
• Gathering report requirements and documenting metrics to produce insurance company reports through web intelligence reporting in accordance with key stakeholders requirements.
• Performed data modeling using Erwin modeling tool to define the star schema of Business Objects universe being developed to work with the 3NF Teradata model.
• Designed and presented Business Objects universe and web intelligence reports in early phase of project to help generate adoption of Business Intelligence POC roadmap
• Mentors and trains client staff in best practices for business intelligence requirements gathering, role and security setup, web intelligence reporting and Xcelsius dashboard development.

Confidential

Principal Consultant

Responsibilities:

• Creating Business Objects Universes that enable Business Intelligence for client companies.
• Developing corporate-wide Business Intelligence Strategies and identifying Key Performance Indicators.
• Performing data warehouse design modifications including aggregation and relational schema re-design, logical data modeling, physical data modeling, and fact table and dimension table design.
• Creating data mapping documentation and designing logical data models for clients in early stage data warehouse projects using CA Erwin Modeler.
• Building relationships with business users and deciphering user requirements into logical conformed dimensions and fact tables used in the design of a logical data model, practices Ralph Kimball Lifecycle Data Warehouse design methodology.
• Mentoring and training client staff in best practices for business intelligence requirements gathering, modeling, reporting and dashboard development.
• Leader in setting up Business Intelligence system using Oracle databases, Business Objects Edge XI 3.0 Universes, Webi Reporting, and Xcelsius 2008 dashboards.

Confidential

Senior Consultant

Responsibilities:

• Consults with client companies on financial analysis, database design, and productivity analysis and business intelligence strategy development.
• Made recommendations for business processes, technology platforms and tools to assist in organizational change.
• Developed (OBIEE) Oracle BI (Business Intelligence Enterprise Suite) reports for a healthcare client.
• Responsible for designing Access Database front end Forms, Tables, and Queries for QHR (Quorum Health Resources) Hospital Benchmarking database.
• Designed (frontend) Access database forms and tables. Created relational queries to build and load the benchmark data from hospital client sources using SQL server as the backend.
• Trained staff in query design, database modeling and reporting techniques of Access 2003 database.
• Wrote SQL and VBA code to perform data quality control and exception checks on incoming data sources before being loaded to final database version.
• Received training in SharePoint Server 2007 implementation.

Confidential

Senior Consultant

Responsibilities:

• Responsible for creating Business Objects queries to extract clinical data sets from Confidential Business Objects warehouses for hospitals acquired by CHS.
• Developed extract formats and automated processes to populate HMS system for CHS.
• Trained programming staff in query design, automation development and reporting techniques of Business Objects software.
• Project manager of the CHS corporate upgrade process from Business Objects 6.5 to XI 2.0 version.
• Worked with McKesson Horizon Business Intelligence module to develop clinical decision support reports utilizing Business Objects XI.
• Utilized Monarch DataPump to automate data loads and summary reports.
• Provided data privacy, security, protection and encryption.

Confidential

Senior Consulting Engineer

Responsibilities:

• Responsible for physical design modifications of enterprise data warehouse - Managed Care and DDS (Diagnosis Decision Support) Universe using Business Objects Designer 6.5.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Conducted requirements gathering sessions with clinical stakeholders and revenue cycle analysts.
• Developed web and desktop intelligence reports in Business Objects for clinical standards reporting.
• Wrote Business Objects SQL and tested with Teradata (T-SQL) for quality control.
• Created Informatica ETL scripts for transforming data into reliable database source feeds.
• Designed Crystal Reports and Access database reports for Revenue Cycle and Financial Analysts.
• Created complex Business Objects queries to test business rules, analyzing data looking for anomalies and data quality issues.
• Performed QA testing and data validation on reports to ensure quality control.

Confidential

Senior Consultant

Responsibilities:

• Developing corporate-wide Business Intelligence Strategy and identifying Key Performance Indicators.
• Managing data warehouse and data mart design modifications including aggregation and relational schema re-design.
• Designed improved Web Intelligence reports and “actionable metric ready” Dashboards for clients.
• Developed “Best Practice Dashboard Selection tool” for client to select the best Dashboard tool (Xcelsius, Dashboard Manager, Performance Manager) based on their needs and requirements. Tool was submitted to Confidential for corporate wide use.
• Presented industry Best Practices to assist and train client’s Business Intelligence team.
• Developed integrated links to SAP BW tables for use in Business Objects reporting.
• Assisted client staff in resolving data connection and implementation issues.

Confidential, Bloomington, Illinois

Project Leader and Developer

Responsibilities:

• Identifying Key Performance Indicator Metrics.
• Leading the effort to gather key requirements from Business Users in developing the project plan.
• Designed and tested the dashboard for the presentation to the business stakeholders.
• Programmed QAAWS (query as a web service) links from dashboard for additional functionality.
• Integrated business processes to make the dashboard actionable for the users.

Confidential, Little Rock, Arkansas

Onsite Dashboard Design leader

Responsibilities:

• Review existing Oracle APEX database design and recommend any re-design. (PDM)
• Developed “Best Practice Dashboard Selection tool” for client to select the best Dashboard tool (Xcelsius, Dashboard Manager, Performance Manager) based on their needs and requirements.
• Lead trainer of new dashboard design techniques to team with an emphasis on revenue metrics.

Confidential - Manhattan, New York

Business Intelligence management resource

Responsibilities:

• Work with Senior Management to develop a “Capital Risk Management” business intelligence strategy.
• Lead developer and designer of corporate business intelligence strategy for capital risk dashboard.
• Performed the data modeling scope of the Capital Risk Analysis project.
• Requirement gathering for defining the data model according to user requirements that are actionable, definable, relevant, measurable and testable.
• Defined Data Mapping documents for inputs to the Dashboard design.
• Designed custom integrated links to client http sites within Dashboard design.
• Designed and developed Web Intelligence Reports during Reporting phase.
• Sharing Dashboard Design best practices to guide the Goldman BI team to make better design decisions.
• Retained confidentiality of details of national and international capital risk events.

Business Objects Sr. Consultant

Responsibilities:

• Business Objects XIR2 - Performance Management and KPI Identification
• Crystal Xcelsius 4.5, Advanced (non-public designer courses)
• Business Objects Universe Designer XIR2
• Business Objects XIR2 - Administration & Deployment
• Business Objects Web Intelligence XIR2

Confidential

Business Objects Project Manager

Responsibilities:

• Role consisted of establishing and implementing a Business Intelligence strategy for this Pharmaceutical leader.
• Responsible for leading the corporate rollout of the Business Objects XI r2 software primarily focused on increasing sales of leading pharmaceuticals in pipeline.
• Provided resourceful team leadership in the following areas:

Administration:

• Business Objects Administration - Refreshing, Publishing, Scheduling and Monitoring of Corporate Reports.
• Business Objects related Production Support - Resolving technical issues with repository, reports, universes and user security
• Migrating reports and universes from one Development Domain to Production Domain.
• Installation and administration of Business Objects XI R2 server and Crystal Reports XI server.
• Responsible for administration, security, maintenance, data governance, performance and physical data design of enterprise data warehouse; participation in ETL processing including aggregation, indexing and partitioning strategies along with job scheduling and automation.

Design:

• Analyzed business user needs and wrote detailed descriptions to define actionable metrics.
• Designed Physician Prescription data warehouse (Oracle 10g based) and conceived and developed the Business Objects XI R2 universe (Star schema design).
• Collaborated with the Data Warehouse team to define clustering, programming, tables and naming conventions; directed maintenance and use of the corporate data dictionary for common definition of elements. (LDM and PDM).
• Integrated SAP R3 and Oracle tables into Business Objects XI R2 universe to serve user data source requirements.
• Major duties centered on managing the transformation of physician prescription data and various corporate data sources into to the enterprise data warehouse.
• Synthesized legacy systems (SAP BW) for transition and acquisition of source data to the data warehouse.
• Designed the physical database schema and the logical data model, managed performance, created sizing estimates, assisted with loads, and implemented security.
• Formulated extraction/transformation and load programs for aggregation of source data to the data warehouse. Utilized Datastage as the ETL development tool.

Confidential

Consultant

Responsibilities:

• Performed cash flow modeling and Balance Sheet planning for client companies.
• Presented financial projections to equity investors.
• Converted financial information to other file formats and software applications as requested by client companies.
• Creation of Access databases and establishing procedures for client companies. LDM and PDM.
• Skills: Access Database Design and Development, Financial Modeling, Data analysis and presentation, Agile Project Management, Microsoft Office Excel, SOX compliance.

Confidential

Financial Analyst

Responsibilities:

• Responsible for the monthly financial analysis and revenue reporting of insurance reimbursements for physicians participating in the Confidential . (Physicians Group)
• Designed Business Objects queries and desktop intelligence reports for A/R, collections, and insurance audits of reimbursement activity for primary specialty departments and physicians.
• Recommend revenue improvement strategy for healthcare provider based on productivity suggestions.
• Reviewed and analyzed fee schedules for all Managed Insurance contracts.
• Performed month end closing routines of G/L accounts and distributed funds to physicians.
• Designed and programmed first VMG online WebSphere Contract data warehouse for HIPPA secured viewing and printing of insurance contracts. (LDM and PDM).
• Project Manager for Transplant Team utilizing Business Objects conversion from Access database applications. Recommended productivity measures that saved over $30,000 in first two years.
• Consolidated, extracted and analyzed past ten-year data of provider claims from EPIC systems to obtain settlement from two major insurers using Business Objects and Epic.

Confidential

Retail Financial Systems Analyst

Responsibilities:

• ERP System conversion (JDA) and implementation experience focused on integration testing, application data translation, and validation.
• Designed Business Objects 5.x Universe and Data Warehouse of daily store transactions to help identify fraud ($250,000) and manage inventory.
• Trained and consulted Loss Prevention Dept. in designing store specific daily transactional audit queries and recommended resolution processes for better inventory control and reduced shrink.
• Clarified and focused work teams on primary tasks in order to accomplish goals.
• Implemented paperless reporting and analysis of retail financial reports, resulting in significant cost reduction ($1.1 mill) and increased speed of information delivery.
• Business Objects 5.x database designer of Purchase Order Data warehouse to increase buyer efficiency and support merchandise planning and inventory control.
• Managed and performed daily and annual inventory control audits and resolved item adjustments by working with Store Operations and Financial Services.
• Created the EDI vendor database and performed the initial setup of EDI vendors.
• Corporate Trainer of Business Objects 5.0 to all users in Finance and Merchandise Depts.
• Frequent meetings with CEO to develop Executive Information Systems and pioneer new methods in visualization of key performance indicators.
• Designed and prepared consolidated financial planning and budgeting reports for each merchandise segment of sales, profits, margins, and inventories for CEO and senior management review.
• Managed the team of three that prepared month-end general ledger entries using Oracle software for G/L, A/R, A/P and inventory and developed accurate accounting policies for inventory valuation.
• Provided leadership in the creation and design of the Business Objects Universe and physical data warehouse for monitoring sales and inventory on division, department and item level.
• Developed and implemented the process of transferring mainframe report information by download to personal computer for use in spreadsheet and/or database models and saving $1 million in annual labor and paper costs.
• Invented the process of taking mainframe reports and converting information onto mobile personal digital assistants (PDAs) that provided innovative information solutions for travelling executives, as well as the CEO and Chairman of the Board.

Confidential

Deposit Department Manager

Responsibilities:

• Managed the deposit entry and application of millions of A/R dollars to subsidiary accounts.
• Supervised, trained, coached, and evaluated staff of 20 employees.
• Communicated with five lock box banks, reconciled statements to GAAP and SEC reporting guidelines.