SUMMARY:

• Certified SAP Application Associate - SAP Business Objects - 4.0, 4.1, 4.2
• 8+ Years experience in providing end-to-end solutions for data warehousing, Analytics, Reporting, Predictive Analytics, ETL, using SAP, Microsoft technologies - BODS / SSIS / SSRS, Tableau, Python, Hadoop, HANA, BW.
• Over 6 successful implementations with Automobile, Hospitality, Higher Education, Manufacturing and Logistics, Healthcare industries.
• Strong Data Analysis to discover data, clean data, Business Analyst skills to act as liaison between Business and IT team, requirements gathering.
• Led small to mid size Business Intelligence team - ETL developers, Business Analyst, Data Analyst, Data Visualization.
• Extensive experience designing reports and dashboards using Tableau on HANA, Relational database, AWS.
• Hands on Python programming to create data visualization using Seaborn, Jupyter for data analysis, arrays.
• Leading projects to transform existing Analytics environment and setting up new standards for new implementation.
• Designed and Developed Design Studio Dashboards on HANA, BW sources, multi-layer Geo-Maps, multi-tab, relative open doc.
• Relational database modeling - star schema, snow-flake schema, SCD - Slowly changing dimension modeling, complex sql queries - SAP BODS, ETL, Power Designer
• Designed complex Webi Reports, LUMIRA dashboards, Design Studio Dashboards - using CSS scripting, JAVA scripting.
• Designed new components in GitHub to leverage in Design Studio dashboards.
• Setting up Business Objects servers, multi-clustered, Architect for SAP Business Objects 4.x, fresh installation and upgradation.
• Row level security using AD groups and implementing security in IDT - object level.
• Predictive Analytics leveraging SAP Predictive Analytics, Tableau, LUMIRA on HANA,
• Designed & created Xcelsius dashboards using Live Office, QaaWS, BIWS, BICS, Query Browser connections
• Extensive knowledge of Standard and Custom Info Cubes, Info Objects, Data Store Objects, Info packages, Multi-providers, Transformations (Start & End Routines), DTP and Process chains
• Extensively worked on Central Management Console (CMC) in maintaining Objects, Universes, Connections, Folders, Resources, Calendars, Users, User Groups and Categories in Confidential 4.0/XI 3.1
• SAP BODS to for slowly changing dimension modeling, history preservation, object mapping, amongst other transformation.

TECHNICAL SKILLS:

Analytical Tools: SAP Business Objects 3.x / 4.x, Tableau, Cognos, LUMIRA, Webi, Design Studio, Hadoop, Big Data, SAP BW, HANA, Jupyter

SAP ERP: SAP ECC 6.0/5.0, R/3, 4.7/4.6c

ETL Tools: Data Services 4.x, Informatica, Power Designer, HANA

Databases: HANA, Oracle, SQL Servers, Teradata, Google Cloud / Analytics, AWS

Languages: C, C++, Java, ASP.Net, VB.Net, HTML, XML, CSS, Python, R

Other Tools: MS Office 2010/2007/2003 (Excel, PowerPoint, Word, Outlook, Project), Visual Studio, HP Quality Centre, Remedy, Share Point

WORK EXPERIENCE:

Confidential, Denver, CO

Business Intelligence Solutions Architect

Responsibilities:

• Re-vamping existing Business Intelligence environment with SAP technologies - Analytics and Reporting solutions
• Creating Visualizations using Python Programming, Seaborn, Jupyter.
• Data Modeling using Power Designer, ETL using SAP BODS - SCD - Slowly Changing dimension to capture history to report on and predict growth next 7 years
• Reporting solutions on SAP Business Objects, Webi Reports, Design studio, LUMIRA
• Analytics solutions on Tableau, SAP Predictive Analytics, Data Science, python programs to predict future enrollment numbers
• Solutions for University, State and Federal Reporting standards
• Using structured and unstructured data to extract knowledge, gathering insights for data mining
• Data modeling for Student Enrollment data mart, Finance, Financial Aid.
• Phase - 2, creating HANA views to replace Relational Model for real-time reporting - tracking Applications, Enrollments, Course Registration (for State and Federal Reporting).

Environment: SAP Business Objects, SAP BODS, ETL, Tableau, HANA, LUMIRA, Tableau, Oracle, Python, PeopleSoft Business Area: Admission, Enrollment, HR, Financial Aid, Finance, CRM - Salesforce, Python, Jupyter, Seaborn

Confidential, St. Paul, MN

Sr. SAP Design Studio / HANA Consultant

Responsibilities:

• Leading Analytical team for designing dashboards - SAP Design Studio 1.6
• Designing 2 Dashboards for executives across Confidential, with 12 KPIs each
• Creating HANA views on studio to optimize performance of reports / dashboards for real-time Analytics
• Upgrading SAP BO 4.1 to 4.2 sp 2
• Integrating SAP BW with HANA, creating Bex queries, reporting off BICS connections
• Administering BIP - Business Intelligence platform, servers, access levels, ASPs.

Environment: Business Objects 4.2 SP2, SAP BW 7.4, Business Explorer (BEx), MS SQL Server, Netezza Enterprise Portal, Web Intelligence, Dashboard Design, BI LaunchPad, BICS, SAP HANA, SAP Design Studio

Confidential, Franklin, TN

Sr. SAP BO/BW Consultant

Responsibilities:

• Leading PPD - Parts and Performance Database project, including migrating data using Informatica and testing ETL results as apart of Data Analyst.
• Scope includes creating Webi Reports, Story Board - SAP LUMIRA and Dashboards on Design Studio.
• 6 Webi Reports finding out cumulative variance on Parts / Items bought over the past few years.
• 2 Story Boards on SAP LUMIRA 1.30 on Universe in IDT and SAP BW as source to help Business understand parts / items falling in a block and their cost price and variance - BICS connections queries, cubes.
• SAP Design Studio 1.5/1.6 to design and develop dashboard at enterprise level to find sales of Nissan and Infiniti cars across the globe - using GEO maps, Cross Tabs, score cards, color variations - start and end (min and max).
• POC for SAP HANA - High Performance Analytic Appliance integrating with SAP BO 4.2 sp2 and Design Studio.
• Migrating SAP BO 4.1 sp6 to SAP BO 4.2 sp2.
• Setting up recovery files, providing appropriate rights to users to current reports and creating new reports as a part of Administration activity.
• Experience with SAP HR modules such as PA, OM, BN, PT and PY
• Monitoring servers, load balancers for BI applications.
• Multi source Universe - Oracle 11g (on cloud) and SAP BW 7.4 - BICS connection.
• Working on SAP PP (Production Planning) for product launch and assigning packages / options to Nissan and Infiniti cars and report off them.
• SAP BW / SAP HR extractors - 0PA C01, 0OM C01, 0PT C01, 0PABN C01, 0HR PT 2, 0EMPLOYEE, 0HRPOSITION - for HR reporting on contracts, employees
• Extractors SAP HR – PA, OM,PT, Bex Analyzer, Infocubes, BICS.
• Using Bex Queries, creating Info Cubes, BICS connections, integrating SA BW with SAP HR and SAP Confidential
• Developed complex SAP Business Explorer 7.3 reports using Web Analyzer, Analyzer, Web Application Designer and Report Designer using SAP BW objects

Environment: Business Objects 4.1 SP6, SAP BW 7.4, Business Explorer (BEx), MS SQL Server, Netezza Enterprise Portal, Web Intelligence, Dashboard Design, BI LaunchPad, QaaWS, BICS, BIWS, IDT, LCM, Fiddler, Mobile BI, JAVA, Angular JS

Confidential, Orlando, FL

Sr. SAP BO / BW Consultant / Administrator

Responsibilities:

• Implemented SAP Business Intelligence for Culinary and Vacation Packaging Business with 2 full life cycle implementation.
• Designed and developed complex WebI reports using merged dimensions, charts, drill down, drill across and element linking functionalities.
• Created a Universe (UNX) for KPI Dashboard in Design Studio – to monitor sales and attendance of all SeaWorld Parks.
• Migrated from SAP BO 3.1 to 4.1
• Converting reports from Deski to Webi as a part of Administration activities.
• Setting up new environment for SAP 4.1 – including servers (TOMCAT)
• Converting 79 universes from UDT (UNV) to IDT (UNX) and successfully tested reports based off of these new Universe and moved to production.
• Developed complex SAP Business Explorer 7.3 reports using Web Analyzer, Analyzer, Web Application Designer and Report Designer using SAP BW objects
• Training business to utilize SAP BI to the fullest and fulfilling their ad hoc reporting requirements was a day today job.
• Created various WebI reports using input controls and drop down filters and provided interactivity to the reports.
• Created multi source universe using Jco Connector with SAP BW (7.3 / 7.4)and SQL Server as the data sources
• Created WebI reports on top of BEx queries using BICS.
• Using Data Stage to vet ETL packages.
• Created Design Studio Dashboards for Accounts Payable Metrics (days payable outstanding, average payable period), Budget vs. Actual Performance Metrics, Order Fulfillment, Inventory aging.
• KPI Dashboards using Design Studio 1.5 presenting Culinary Sales and attendance of all SeaWorld Parks.
• Engaging client to gather requirements / Business rules and ensure alignment with development team.
• Created storyboards using SAP Lumira, using Universe as data source.
• Transported BO objects using LCM between Dev/QA/Prod and created backups using BIAR files.

Environment: Business Objects 4.1 SP6, SAP BW 7.3 / 7.4, Business Explorer (BEx), MS SQL Server, Netezza Enterprise Portal, Web Intelligence, Dashboard Design, BI LaunchPad, QaaWS, BICS, BIWS, IDT, LCM, Fiddler, Mobile BIBusiness Area: SD, MM, SCM, CRM

Confidential, Orlando, FL

Sr. SAP Business Intelligence / BW Designer / Data Analyst

Responsibilities:

• Designed and developed functional specifications, technical specifications for Dashboard requirements
• Interacted with users in gathering reporting requirements and created report and dashboard mockups
• Designed, created and implemented WebI reports, Webservices (BIWS) and Design Studio Dashboards using best practices
• Created WebI reports on top of BEx queries using BICS, and created Webservices on top of WebI report blocks using BIWS to bring data into the dashboard.
• Developed complex dashboards using Dynamic Visibility functionality.
• Created multi-layered dashboards to display various tabs like Scores, Key KPIs, Spend, CAS And Alert Tool.
• Broadcasted WebI reports to individual recipients using BI LaunchPad scheduling functionality.
• Created WebI reports with multiple data providers and synchronized the data using merged dimensions.
• Implemented the GMaps Plugin to display the Territory/Location information on the Maps and created alerts based on the locations.
• Involved in End User-Training documentation, conducted User Acceptance events.
• Created linked WEBI reports and Xcelsius dashboards using Open Document (OpenDoc) functionality.
• Used Life Cycle Management (LCM) to transport WebI reports, Webservices and dashboards from Development to Test to Production systems.
• Set-up, presented and created WebI reports for SAP Mobile BI platform using the SAP BusinessObjects Mobile on Apple iPad and iPhone using simulators.
• Developed Interactive PDF functionality in the dashboard by creating the Crystal reports and embedding the flash within the report by bringing data using flash variables and Crystal Reports Data Consumer connection.
• Performed the BO upgrade from BO 3.1 version to BO SP4.
• Worked with SAP regarding various issues with the Business Objects 4.0 SP2 version.
• Developed Proof of concept on SAP HANA with SAP BW as the source.

Environment: Business Objects 4.0 SP2, SAP BW 7.3, ECC 6.0, Business Explorer (BEx), Oracle 10g, Netezza, Universe Designer, Enterprise Portal, Web Intelligence, Dashboard Design, BI LaunchPad, QaaWS, Live Office, BICS, Information Design Tool, DataServices, Confidential Explorer, Mobile BIAnalysis - Edition for Microsoft Office;

Confidential, Alpharetta, GA

SAP BO/BW Designer / Business Analyst

Responsibilities:

• Designed and developed functional specifications, technical specifications for Confidential reporting on top of SAP BI/BW and ECC as per the system landscape
• Interacted with users for customized and standard reports, gap analysis and associated solutions
• Interacted with Project manager and end-users in architecting reporting solutions by understanding the requirements and building universes, reports and Dashboards
• Working on integration projects with Confidential with different EHRs and EMRs – ALLSCRIPTS Pro, ALLSCRIPTS Enterprise, Athena, eCW, Practise Fusion, NextGen.
• Developed reports on PSURs, PBRERs, DSURs for Hospitals, practices.
• Integrating practices and hospitals and radiology to transmit CPOEs, Care Document.
• Integrating Epic with Crystal Reports using Epic – Crystal Integration SDK.
• Integration Projects involved transition of care documents (CCD), Orders export (CPOE), results import between both employed and un-employed providers.
• Created reports in BEx Query Designer and extensively used BEx Analyzer.
• Created BEx reports using filters, calculated key figures, and restricted key figures
• Created OLAP Universes on SAP data (InfoCubes / BEx queries) using Universe Designer and Information Design Tool.
• Created detailed reports with Drill-down capability using Web Intelligence in BI LauchPad / InfoView, worked on Ad hoc Query, Reporting, and Analysis
• Experience with CMC in creating User-groups and worked on security rights
• BW environments and setting up the Single Sign On (SSO) across all the environments
• Demonstrated the creation and use of information spaces and Exploration views on BWA Indexes and universes using Business Objects Explorer.

Environment: Business Objects Enterprise XI 3.1, SAP BI 7.0, BW 3.5, ECC 6.0, Business Explorer (BEx), Oracle 10g, SQL Server 2005, Netezza, Crystal Reports, Universe Designer, Web Intelligence, Xcelsius, QaawS, Live Office, Visual Composer, Confidential Explorer, Data Integrator, Microsoft SharePoint Portal;

Confidential

SAP Business Objects Report Analyst

Responsibilities:

• Loaded information from SQL Database 2005, Flat Files and excel files using SAP BODS.
• Using SAP BO dashboards created and manipulated workflows, dataflow to help cleanse data of 24000 schools and over 2.5 million students appearing for the exams.
• Implemented transforms like data transfer, date generator, row generation, map operation, query transformation.
• Constructed multiple projects, including workflows, dataflow to implement case – merge and validation transformation.
• Cleansed data using proper data types and mappings.
• Implemented SQL transformation to load data directly in the database.
• Worked closely in multiple repositories and servers.
• Implemented various look-up functions.
• Created various kinds of graphs, charts, scatter plots. Analyzed data in charts using slice/dice, drill up/drill down, using SAP BO, Web Intelligence, Crystal Reports and Xcelsius reports
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc. by using Chart expert of Crystal Reports 2008

Environment: Business Objects XI R3.1, SAP BODS, SQL Server 2008, Netezza, Oracle 9i,10g, Windows XP.