We provide IT Staff Augmentation Services!

Sr Sap Business Intelligence Consultant Resume

TennesseE

SUMMARY

  • I am a highly organized, creative and motivated professional BI expert with over 25 years of extensive experience in SAP Business Intelligence, Business Objects, HANA and Crystal Reports.
  • I also have industry development experience using SISENSE, Looker, Board, Tableau, Qlikview, and Qlik Sense BI tools. Possess technical and analytical expertise working in multiple roles as a Senior BSA, Solutions Architect and Project Manager in diverse global industries helping my clients realize enhanced productivity levels, and ensuring on - time & budget project delivery.
  • Detail oriented problem solver who is known for aligning with global operational leaders and stakeholders.
  • I truly enjoy working in dynamic and fast paced global organizations where I’m continually challenged and also able to help make immediate and long-term operational transformations and process efficiencies.

TECHNICAL SKILLS

Business Intelligence Tools: Sap Business Objects XI - 4.2 * Design Studio 1.6 * Lumira 2.0 * Crystal Reports 1.0 - 2016 * Business Objects Data Services * Data Quality * Sap HANA studio Eclipse platform 3.6. * Sap HANA Cloud (PaaS) * QlikView Versions 9-12 * Qlik Sense Enterprise - Cloud * Tableau 9-10 * SAS Visual Analytics 8.1 * Power BI 2x * Microsoft SSRS, SSAS, SSIS * Pentaho * Hadoop * Apache Spark * IBM Websphere integration

Software Packages & Modules: SAP BPC Budgeting Planning & Consolidation * SAP ECC ERP Central Component * SAP CRM - Customer Relationship Management * SAP PLM - Product Lifecycle Management. * SAP SCM Supply Chain Management * SAP SRM - Supplier Relationship Management * SAP ERP Enterprise Resource Planning * Microsoft Dynamics Great Plaines * Salesforce Einstein Analytics * Microsoft SharePoint * GE Centricity EMR * Lawson ERP * Siemens Invision * Health Care VMS * Health Data Archiver * HIMS * Epic

Query Languages: T-SQL * PL/SQL * SQL

Relational Data Base Management Systems: Oracle version 7x - 12 * MS SQL Server * MySQL * Teradata * SAP Sybase

PROFESSIONAL EXPERIENCE

Confidential - Tennessee

SR SAP Business Intelligence Consultant

Responsibilities:

  • Managed BI project scope and deliverables for BI initiatives throughout the organization using the Agile methodology as well as served as Scrum Master
  • Worked with clients, designers, and programmers to identify requirements, provide cost analysis, assist with creating user interfaces, and develop implementation timelines.
  • Worked with senior level executives to obtain KPI requirements for dashboard and reports.
  • Managed project lifecycle, including all phases of system and software development, testing, quality assurance and networking.
  • Developed and deployed upgrade plan for upgrade from 3.x to 4.2 platform. This included migrating Crystal reports, Webi reports, Lumira, Design Studio dashboards, Security models etc for roll-out to 6 different companies.
  • Assisted Data Scientists on development of multiple predictive analytics models for turnover and behavioral analysis processed using HANA cloud
  • Developed strategy for delivering dashboard content displayed on TV monitors throughout the enterprise.
  • Converted SSRS and SSAS content from Microsoft to SAP BI platform
  • Re-wrote SSIS projects using SAP data services.
  • Developed Universes and data marts against MS SQL Server for GP financial reports and analytics
  • Designed Business Objects Enterprise security model based on roles.
  • Developed UAT and Version control process for SAP Business Objects
  • Developed predictive analytics models with Lumira for turnover
  • Managed onsite and offshore resources.
  • Developed complex dashboards using Design Studio
  • Developed complex Webi reports for financials
  • Having precise expertise in understanding the R/3 and ECC 6.0 System and considerable Experience in SAP BW/BI, documenting, design and Analysis of reports Using BExAnalyser.
  • Developed architecture strategy for moving hardware, software and databases to a cloud environment hosting HANA and Business Objects
  • Created fact and dimension tables against the TMS EDW
  • Managed the project using Innatos. Manage time, resources and sprints using Atassian Jira Software

Confidential - Boca Raton, Florida

SR Business Intelligence Consultant

Responsibilities:

  • Served as primary engagement manager for SDLC testing in clients meeting, reviewed functional and business documents to develop test plan and managed testing efforts for project's testing phases.
  • Supervised with onshore and offshore test team leads to guide all testing resources to follow testing best practices, understand the strength of each test team members and assigned testing assignments base on their strength.
  • Managed the tasks of the all the onshore and offshore testing resources.
  • Led daily status call with onshore and offshore testing team to address any questions during test preparation, product testing and open defects.
  • Worked with onshore and offshore test team lead to set up a testing approach on product testing and how to address each defects found.
  • Worked with clients, designers, and programmers to identify requirements, provide cost analysis, assist with creating user interfaces, and develop implementation timelines.
  • Worked with senior level executives to obtain KPI requirements for dashboard and reports.
  • Managed project lifecycle, including all phases of system and software development, testing, quality assurance and networking
  • Project manager for the complete BI roll-out
  • Deployed SISENSE BI solutions throughout the organization
  • Developed dashboards and reports for the retail and wholesale funding branches. I.e. Touch Count, Loan status, Locks and pull thru’s
  • Developed balanced scorecard for vendor performance
  • Developed ElastiCubes against the financial MS SQL Server data warehouse
  • Developed reports for 60+ branch offices
  • Created predictive analysis models potential client approvals
  • Converted ClearNet iNet reports to SISENSE
  • Developed stored procedures using MS SQL Server data
  • Create technical documentation and provided training

Confidential

Senior Principle Consultant

Responsibilities:

  • Worked with clients, designers, and programmers to identify requirements, provide cost analysis, assist with creating user interfaces, and develop implementation timelines.
  • Worked with senior level executives to obtain KPI requirements for dashboard and reports.
  • Managed project lifecycle, including all phases of system and software development, testing, quality assurance and networking
  • Managed the full life cycle project and resources for the following deliverables.
  • Worked as business analyst gathering business requirements and converting to business requirements
  • Developed upgrade plan for Business Objects systems from XI R2 to XI 3.1 including 3 separate environments (Development, QA and Production) used in 20+ hospitals
  • Configured SAP SharePoint Integration Kit for usage with BOE and Crystal
  • Created Xcelsius Models, utilizing Live Office, QaaWS from SAP BW.
  • Created near real-time dashboards with Xcelsius from Crystal Reports and SAP
  • Worked on SAP BI/BW designing/creating InfoObjects, InfoSources, Transfer structures, Communication Structures, InfoCubs and DSO’s
  • Developed universes against GE Centricity EMR databases/tables
  • Integration Kit from ECC
  • Created and modified over 2500 Crystal reports for GE Centricity EMR
  • Developed Xcelsius dashboards for patient care and EMR modules
  • Designed strategy for migration from Enterprise only security to AD and SSO.
  • Converted MS Access data schema to Oracle as well as re-developed Access reports using SAP Business Objects Webi and Crystal Reports
  • Performed implementation.
  • Installed and configured Data Federator
  • Trained employees in initial use of Data Federator for joining Oracle data warehouse and SQL database
  • Trained employees in use of Crystal Reports
  • Reviewed current usage of SharePoint and assisted in planning for future usage
  • Designed initial Crystal reports
  • Trained employees in design of Xcelsius dashboard and Webi report development
  • Relocated Repositories
  • Initiated improvements in BI process including email report distribution
  • Installed and initiated use of Life Cycle Management
  • Installed and trained on use of Live Office as data source for Xcelsius dashboards
  • Reviewed major client driven reports and helped client set direction to fulfill requests in structured method
  • Performed data validation and testing with customers and other subject matter experts to ensure data accuracy.
  • Developed custom reports in from the EPIC Clarity Database using SQL stored procedures and Crystal Reports.
  • Developed reports using various EPIC modules including Cadence, Prelude, ADT, Resolute/HB, Inpatient, Identity, HIM, and Ambulatory.
  • Created reports in Reporting Workbench using existing templates and use Data Courier to put into production environment.
  • Assisted in ICD10 report conversion.
  • Scheduled and provided support for scheduled reports using Business Objects Enterprise/Infoview.
  • Used Epic tools such as Record Viewer, Column Search and Clarity Data Dictionary, to assist with creation of custom reports.

Confidential - Knoxville Tennessee

SR Principle Consultant

Responsibilities:

  • Assisted team with the following deliverables
  • Upgraded and configured Business Objects systems from XI R2 to XI 3.1 including 3 separate environments
  • Created Xcelsius Models, utilizing Live Office, QaaWS from SAP BW
  • Created near real-time dashboards with Xcelsius from Crystal Reports and SAP
  • Designed strategy for migration from Enterprise only security to AD and SSO.
  • Trained employees in initial use of Data Federator for joining Oracle data warehouse and SQL database
  • Gathering information (specs) from the user regarding the report.
  • Providing Estimation, developing reports and performing the testing.
  • Developing and Designing the Report in EDW tool.
  • Working on Security Grid to get implemented in EDW tool as
  • Hospital Model.
  • Creating Dashboard in EDW as per the requirements.
  • Helping and working closing with EPIC Team to implement EPIC system in
  • Working on Creating Patient Satisfaction, HACs & PSI Dashboard.
  • Working on Implementing Tableau in the hospital, and then connecting it to different existing data source i.e. MS SQL, Oracle, Peoplesoft.
  • Working on mirroring the existing reports from EDW into EPIC.
  • Applied functions, calculations and filters with dynamic prompts.
  • Built formulas, variables, ranks and alerts.
  • Implemented Security Features of Business Objects like row level, Object level and report level to make the data secure.

Confidential - Knoxville Tennessee

Principle Consultant

Responsibilities:

  • Prepared and executed software and solutions demo for client.
  • Completed the discovery process and submitted findings to the CIO.
  • Completed (RFP) request for proposal and (SOW) statement of work for client finalizing the deal.
  • Managed the project and resources for the following deliverables.
  • Setup up development, test and production environments.
  • Upgraded Business Objects Enterprise from 10 to version XI
  • Upgrade Crystal reports version 10 to Business Objects XI.
  • Migration for over 700 Crystal reports and over 70 universes to new environment.
  • Upgraded BODS server

Confidential - Miami Florida

Principle Consultant

Responsibilities:

  • Managed the Business Objects project as well as 12 consultants and 4 onsite resources for the following deliverables
  • Reviewed current reporting system using MS Access and CACHE database
  • Tested CACHE database compatibility for Generic ODBC drivers with Universe Designer and WebI reports
  • Reviewed 250 MS Access Queries to determine design of Universe
  • Designed Universe to replace MS Access system
  • Created Crystal over 200 Crystal and webi reportss to replace MS Access reports
  • Reviewed and modified over 900 GE Centricity EMR Crystal Reports
  • Implemented,/ tested/ and trained staff on Row Level security to allow single universe to by utilized for 5 hospital pharmacies
  • Trained employees on Universe Designed for Cache database
  • Assisted employees in development of initial Webi reports against new Universe

Confidential

Principle Consultant

Responsibilities:

  • Coordinated design of Security model for 4 Business Objects Enterprise environments
  • Trained new Business Objects Enterprise Administrators in usage of CMC tools and processes for administering Business Objects.
  • Designed, documented, and trained on processes for promotion of Crystal reports, Webi reports, and Universes across multiple environments
  • Designed, documented, and trained on Crystal reports dynamic parameter usage, promotion, and maintenance.
  • Developed data warehouse strategy to migrate security, connections, data, reports and analysis over to HPAA - High Performance Analysis Appliance. Currently known as HANA

Hire Now