PROFESSIONAL SUMMARY:

• Over 13 years’ experience in Information Technology with proven ability in implementing Business Intelligence solutions, innovative analytical reporting and visualizations to often unique business requirements utilizing SAP BusinessObjects Suite of products. Capable of managing numerous projects while leading cross - functional teams and competent in all aspect of Business Objects Development, implementation, Deployment, Testing and Migration.
• Extensive experience in developing Business Intelligence (BI) solutions utilizing SAP Business Warehouse, SAP Business Objects, SAP Design Studio, SAP HANA, SAP Lumira, SAP Mobile BI and Enterprise Data warehouse (Relational and OLAP).
• Implemented Enterprise Business Intelligence Systems for diverse group of clientele such as HealthCare, Pharmaceutical, Financial Services, Service Industry, Package/Freight, Management Consulting, Consumer Goods, and Clinical Trials.
• Full life cycle implementation of Business Intelligence applications using SAP Business Objects (Universe, WebI), SAP Mobile BI, SAP HANA, SAP Design Studio, Lumira, Dashboards/ Xcelsius (qaaws, live office, BI services, and query browser), Crystal Reports, and SAP BW (BEX and InfoCube).
• Experience in Data Modeling Schemas, Packages, Attribute Views, Analytic Views, Calculation Views (graphical and SQL Script) and Analytic Privileges in HANA Studio.
• Experience in SAP BOBJ Reporting and Data Analytics (Universe, WebI, Lumira, Design Studio and Xcelsius/Dashboard) consuming data from SAP HANA, BW and SQL Server.
• Experience in Data Provisioning from ECC (LTR) and Relational databases using BODS.
• Experience in setting up User Security and Roles in HANA Studio.
• Experience with ETL tools - BODS, SSIS and Informatica.
• Experience in operational reporting using Crystal Reports for Enterprise and Previous versions.
• Experience in configuring Auditing Universe and Creating WebI reports and Dashboards utilizing Audit Database.
• Experience in SAP BEX Designer, SAP BEX Analyzer, OLAP Advanced Analysis, Analysis for Office, Tableau and Power BI.
• Experience in Business Intelligence Software Installation, Configuration, Upgrades and Migration. Experience in Business Object content Migration using XIR3.1 and BOBJ 4.0 with BIAR file system; used LCM for promotion and version management in Business Objects 4.0
• Experience in creating Cardinalities, Contexts, Joins, Prompts, LOVs, Cascading prompts, Aliases for resolving Loops, chasm Traps and Integrity check of the Universes.
• Proficient working with very large Datasets, Optimization and Performance tuning of new and existing universes and reports catering to huge databases.
• Administration and development experience in RDBMS, including MS SQL Server, Oracle, MySQL, and MS ACCESS with expertise in T-SQL, PL/SQL, OLTP and OLAP and knowledge in connecting to other databases such as Teradata, and DB2.
• Expertise in Performance Tuning SQL queries and utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and ETL package design.
• Strong understanding of Data Warehouse concepts such as Star Schema, Snowflake Schema, OLTP, OLAP, Data Marts/Models, Master Data Model, Meta Topic and Multi-Dimensional Models for query and analysis.
• Experience in designing, creating, processing of cubes using BIDS and SSAS. Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Hands on experience in SAP HANA Modeling, Administration and Development perspective using SLT and BODS.
• An enthusiastic, project-oriented team player with leadership skills and with an ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

SAP BI/BOBJ Tools: Business Objects 4.2/ 4.1/ 4.0 / 3.1/ R2, Information Designer Tool, BI Launch Pad, Analysis for Office, Universe Designer, Web Intelligence, DeskI, Xcelsius, Dashboard Designer, Central Management Console (CMC), CCM, InfoView, Scheduler, BEX (RRI), BICS, QAAWS, Live Office, Query Browser, Crystal Reports 2008/2011, Voyager, BI Workspace, Import/Export Wizard, LCM.

BI Analytic / Reporting Tools: SAP Xcelsius, Dashboard Designer, SAP Design Studio (1.6), SAP Mobile BI, BODS, WebI, SSRS, Hyperion, Excel Dashboard (with SSAS OLAP Cubes), Crystal Reports, CR4E, Analysis for Office, Business Explorer (BEX), BO Explorer, Visual Intelligence, SAP Lumira (1.31), QlikView, Power BI and Tableau.

Data Modeling: Hyperion, Brio Query, SSIS, SSAS, Visio, SAP HANA Studio

ETL/Data Provisioning Tools: Informatica PowerCenter, SSIS, DTS, SSAS, Business Objects Data Integrator, Business Objects Data Services (BODS), SLT, SDA, and SAP HANA Studio

Languages: Visual Basic, PL/SQL, SQL, C and C++, VB.Net, C#, ASP.Net, VBScript, JavaScript

Databases: MS SQL Server, Oracle, MS Access, MySQL, SAP ECC, Teradata, Clarity, Epic Star Data Warehouse (Caboodle)

Web Servers: IIS, APACHE Tomcat

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SAP BOBJ Consultant

Responsibilities:

• Designed and Developed dashboards (using SAP Design Studio and WebI reports) to be used for suicide risk detection and prevention efforts, detecting and effectively managing suicide risk during routine clinical care.
• Designed and Developed SAP Lumira Visualizations and Storyboards by showcasing the functionalities and enabling business users with data discovery and self-service BI.
• Working closely with Business Analysts in designing prototypes for the Design Studio Dashboards and Web Intelligence Repo.
• Showcased the power and functionality of Geo-Mapping in Design Studio and Lumira.
• Worked with Analytics team in converting Universes (.unv) provided by EPIC to .unx format and customizing data elements per department requirements.
• Worked with BI Analytics team in setting up and testing user security and groups in CMC.
• Helped and Supported BOBJ migration from 4.1 to 4.2.
• Piloted a change to Professional Billing Universe based on Clarity Database and designed WebI Reports.
• Piloted a change to Patient Universe based on Caboodle Datawarehouse and designed Analytics dashboard in SAP Lumira.

Environment: SAP Business Objects 4.1 (SP6) / 4.2 (SP3), SAP Design Studio (1.6), SAP Lumira (1.31), Web Intelligence, IDT/UDT, Crystal Reports for Enterprise 4, MS SQL Server, SSIS, Clarity, Epic Star Data warehouse (Caboodle), Microsoft SharePoint, Tableau.

Confidential

Sr. SAP Business Objects Consultant

Responsibilities:

• Working closely with Users designing prototypes for the Design Studio Dashboards.
• Data Modeling in HANA Studio, Creating Views (Attribute, Analytical and Calculation).
• Design and implementation of new WebI reports based on the Auditing Database.
• Designed and Developed new Dashboards (Design Studio) consuming data from HANA and BW.
• Designed Applications (Geo Map) in Design Studio on SAP BW BEX Queries.
• Designed and Developed WebI reports consuming both BW and HANA database.
• Designed and Developed SAP BI Mobile Reports/Dashboards.
• Data Migration (ETL) using SAP BODS.
• Understanding user requirements, mapping data and providing solutions.
• Testing and Validation of reports with end user.
• Worked on Universe design by leveraging HANA Views.
• Worked on POC for Tableau as part of the tool evaluation project.
• Customized views in Tableau for Business Users for Self Service BI.

Environment: SAP Business Objects 4.1 (SP5), SAP HANA (SP09), Dashboards (Xcelsius), SAP Mobile BI, Design Studio, Web Intelligence, BODS, BO Query Browser, BI Services, SAP BW, BEX, IDT/UDT, Crystal Reports for Enterprise 4, MS SQL Server, Microsoft SharePoint, Tableau.

Confidential

Sr. SAP Business Objects Consultant

Responsibilities:

• Worked on a Tableau POC creating dashboards and workbooks for data Visualization and analysis. Scope of the project was to incorporate/mimic functionality of Xcelsius dashboard using Tableau. Designed and Implemented Self Service Dashboard for Business Users.
• Designed and developed a coaching dashboard to provide management an easy and seamless experience for identifying and tracking coaching opportunities. It will also serve as a single view for metrics derived from multiple source systems, while providing monthly performance review scores.
• Designed and developed a rep level dashboard to provide management and Call Center Reps (CSR) an easy and seamless experience for accessing and communicating CSR performance on a daily basis.
• Developed Dashboards to outline and analyze the key performance indicators (KPIs) deemed critical in regard to managing the performance of the revenue cycle with the objectives of improving Cash-flow, Cost, Customer Experience, Risk and Rating/Invoicing Cycle times. The KPIs addressed have been selected from an overall metrics framework developed by the Global Revenue Planning & Controls function with participation from subject matter experts embedded in the revenue cycle. The majority of these KPIs formed the basis for an executive management dashboard. The remaining framework metrics are process metrics and were organized into reports to be used at the local functional level. The geographic scope of the framework and resulting dashboard and reports is the international regions of the Confidential Express business unit, namely APAC, North America, EMEA, and LAC.

Confidential

Sr. SAP Business Objects Consultant

Responsibilities:

During the last two quarters at Confidential, I had the opportunity to work on multiple projects with diverse Groups/Teams (offshore/onshore model, Member Firms across Globe). Some of the accomplishments during this phase include Design and implementation of new WebI reports for Project CC team, Migrating/Re-designing FIGR (Finance) WebI Reports and Dashboards (Xcelsius) from 3.1 to 4.0, Implementing/Testing/Designing SAP BI Mobile Reports/Dashboards for FIGR team, and finally helping with SAP BOBJ 4.1 Upgrade/Testing and creating WebI Reports/Dashboards on the new BOBJ 4.1 Environment.

Environment: SAP Business Objects 4.1(SP2 Patch3)/4.0 (SP7 Patch 3)/3.1, Dashboards (Xcelsius), SAP Mobile BI, Web Intelligence, BODS, BO Query Browser, BI Services, QAAWS, SAP BW, BEX, Promotion Management, IDT/UDT, Crystal Reports for Enterprise 4, Oracle 11g, SQL Developer, Microsoft SharePoint.

Confidential

Sr. SAP Business Objects Consultant

Responsibilities:

Designed and Developed Xcelsius Dashboard to be used by TCI customers for their day to day analytics. There were a total 9 key metrics (KPIs) and these KPIs were presented with aggregated data at multiple levels (charge, weight, Mode, CY vs PY comparison, Quarterly trends, etc..). Row level security was implemented so that a customer could see data that are relevant/assigned to them. Heat maps were also provided for various geographic locations. Drill-down WebI Reports were also created and linked through the dashboard for detailed analysis.

Confidential

Sr. SAP Business Objects Consultant

Responsibilities:

• Data Modeling in HANA Studio, Creating Views (Attribute, Analytical and Calculation).
• Data Provisioning using Business Objects Data Services (BODS).
• Worked on Universe design by leveraging HANA Views.
• Created WebI reports and Dashboards by leveraging Universe on top of HANA views.
• Added Derived Tables to the universe that are required to generate distribution lists.
• Generated WebI reports for the Distribution List that was needed for publishing.
• Created Publications for various reports based on the distribution reports using dynamic recipients functionality.
• Configured personalization for each of the publications.
• Setting up destinations of these reports to both FTP Server and email based on the requirement.
• Created Unit Test Cases and Test Plans in Quality Center and performed unit test.
• Making sure the Data that is generated for distribution list is valid using Teradata SQL assistant.
• Scheduling the publications using BMC Control-M.

Environment: SAP Business Objects 4.0, SAP HANA, SAP BODS, WebI Rich Client, UDT, Teradata, Control-M, Quality Center

Confidential

SAP HANA /BOBJ Architect/Dashboard Designer

Responsibilities:

• As part of SAP HANA 1.0 (SP5/SP6) implementation at Confidential, kicked off a pilot project for converting the existing DLP reporting solution by leveraging the in-memory capabilities of SAP HANA. The data from Source System (Oracle) was provisioned into SAP HANA using BODS. Designed and developed data modeling (attribute views, analytic views, Calculation Views and Analytic Privileges) in HANA Studio. After the necessary views were created, designed Universe(s) in IDT based on the HANA views utilizing Relational Connection and consumed them in WebI exports, BO Explorer and SAP Visual Intelligence (LUMIRA) and Dashboards. Helped setting up Users, Roles, and Security Privileges for Pilot users in HANA Studio.
• The purpose of this project is to deploy an entirely new reporting system for the DLP. The current application is based on a .net application with limitations for BI Analysis. The scope of the project was to convert/implement the existing reports (62) into Business Objects Web Intelligence Reports. The backend database is Oracle and Universes were used as a semantic layer for the WebI reports. All the reports were implemented with row level security.
• In an effort to optimize Business needs and implement Business Intelligence solution in reporting, this project was initiated to leverage Business Objects Dashboards (Xcelsius) tool to develop interactive dashboard reporting for Argentina leaders. The backend of the dashboard is sourced from existing SAP BW system and the information needed coming from PMA ECC and external data. The business requirements were gathered to show the technical solutions, and detail the reporting requirement for the KPI Dashboard implementation. The requirements were gathered from the LATCO team and Argentina member firms. These business requirements drove the Argentina KPI dashboard implementation.

Confidential

SAP BO Architect/Dashboard Designer

Responsibilities:

Business Services and Core Sales business unit kicked off SAP Business Objects implementation with HR workforce analytics and core sales (terminals) operational dashboards. The project involved storyboarding, JAD sessions with business users to gather the requirements and functional specifications. The dashboards helped identify trends over time, and provided context around the KPI, the ability to drill through to current information, to get alerts, and to identify potential operational issues. These dashboards are used department and organization wide and helped the organization understand if its performance is on or off target, and by how much, in real time.

Confidential

SAP BI / Business Objects Architect

Responsibilities:

• Research Trials Billing and Budgeting Application implemented for the Department of Financial Grants Accounting is used internally for budgeting and also as a Business Intelligence solution for reporting Grant Funding and Spending to the outside agencies. This projects was about Grant/Budget spending, Grant Formulation and Execution. By using this application, Grants Accounting are able to view/update information of allocated resources, Grant Spending, Funds Availability and Future Projections for each Grant profile or Combination for each fiscal year auditing.
• Performance Management System implemented for the HR Department for simplifying reporting issues and providing Business Intelligence solutions. Implemented Xcelsius Dashboards allowing the executives to analyze headcount, hire separation, diversity, and performance trends and metrics for all levels of the organization.
• Database application was designed and developed in VB.Net with SQL Server as backend database. Data for this database was transformed and integrated from multiple data sources/databases such as SQL Server Data Ware house, Oracle and MS ACCESS. Business Objects (Universes and Webi Reports) were designed for the infection control department employees for various blood/STD diagnosis and information. The data for these reports are integrated from multiple databases and is used for emergency medical care in case of needle stick or other infections. Developed SSIS packages and scheduled jobs to Export and Transform the data from multiple data sources into the Application.
• Designed and developed Asset Management and Issue Tracking Applications in ASP.net and SQL Server as backend database. Business Objects WebI and Xcelsius Dashboard Reports were extensively used for designing reports such as for alerting pc upgrades, Management Reports for Asset Management. Reports were developed for emailing unresolved issues/bugs from the Issue Tracking Database. Monthly and Quarterly unresolved issues were sent as reports to the management.

Confidential

Business Objects and Systems Developer

Responsibilities:

• As a Business Objects and Systems Developer, worked with various team sizes for multi-functional departments. In this role, I was involved in developing several applications, databases and reports for multiple clinical/research trials, Pharmaceutical Sciences, Behavioral Sciences, and Outside Agencies ( Confidential, Confidential ). Converted MS Access reports to Crystal Reports, Extensively used Business Objects Reporting (Universes and WebI) for Financial Grants accounting, BRIO Query for creating Data Marts/Models for Clinical trials, Created Xcelsius Dashboards using data from both SQL Server and Oracle. Some of these projects require Extract, Transform and Loading (ETL) to/from SQL Server and Oracle Data Warehouse(s) using SSIS.