SUMMARY:

• Certified SAP BI/BOBJ 4.x Professional with over 13 years of IT experience in building, testing, maintaining and enhancing complex Business Objects Reports, Dashboards and Universes for the Enterprise Datawarehouse environments.
• ETL expert using the SAP BODS 4.2, SAP BI 7.x, CPI - DS for IBP
• Create models & Scripts using the SAP HANA
• Experience in working on several relational databases like Oracle, Teradata, DB2 and SQL Server.
• Report Migration Specialist - Migrated from Business Objects earlier versions to XI R2 and to XI 3.1/4.x.
• Data Visualization using Desktop Intelligence, Web Intelligence, Crystal Reports, Dashboard Design, Universe Designer and Information Designer Tool.
• Expertise in designing Universe from scratch, migrating to different environments.
• Created Open Hubs to publish the data into Flatfiles from SAP BW for consumption into other databases.
• Extensively worked on creation of the BEx Queries, created universes on top of the BEx on the older versions of BOBJ and BICS connectivity on the new version (from BOBJ 4.x)
• Expertise in performing ETL tasks using SAP BI 7.x/BW 3.5 - Experience in Extraction (Generic Extraction, Flat file, LO Cockpit). Experience in creation of SAP BW Query, Multiprovider, Infoset, Infocube, DSO, InfoSource, Transformations, DTPs, Infopackages, DataSources, Business Content objects, Data Marts and Process Chains.
• Implemented the IP - Integrated Planning functionality for spreading the Unit Cost, Inflation data from Product Hierarchy Levels to Material Level
• Worked on migration of reports from other BI tools: COGNOS, BRIO, FOCUS, Microstrategy.
• Exposure to Functional modules: SAP MRS, CRM, SD, MM and FI-CO.

TECHNICAL SKILLS:

BI/Visualization Tools: BO 6.x/XIR2/XIR 3/3.1/4.1/4.2 , BI Launch pad / Infoview, Interactive Analysis

Web Intelligence), Information Design Tool: , Lifecycle Manager, Universe Designer, Business View Manager, Crystal Reports 2008/2011, Dashboard Design (Xcelsius), BEx, WAD, BOBJ Explorer, Design Studio, SAP Lumira Designer and Discovery, BRIO, COGNOS and Microstrategy.

Planning Tools: SAP IBP (Integrated Business Planning 5.0/16XX/17XX/180X) along with SAP CPI/HCI (HANA Cloud Integration) for DS (Data Services)

ETL: SAP BI 7.x/3.5, SAP BODS 4.2

Operating Systems: Windows NT /2000/XP/2003, MS-DOS, UNIX

Languages: PL/SQL, UNIX, ABAP, JAVA

Databases: Oracle 11i/10g/9i/8.x/7.x, MS Access 2000, Teradata 6.0, IBM DB2, MS SQL

Database: Design Erwin 4.0 ERP SAP R/3 4.7, SAP ECC 6.0

Distributed Technologies: MS Office Suite, Toad 7.4, UNIX, Subversion, VSS, Lotus Notes, Sametime client chat, Antivia Component for Crystal Xcelsius, DBArtisan.

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

Role: SAP BI/BOBJ 4.1 & 4.2/SAP HANA/SAP BODS Lead Consultant

Responsibilities:

• Involved in the requirement sessions with the Marketing and Sales department.
• Installation and maintenance of the SAP BO server, along with the Crystal reports server.
• Worked on SAP BO WEBI reports, Crystal Report and Dashboards for data visualization, involving the Pharmaceutical Inventory datasets, sourced from internal (SAP ECC, SAP HANA, Oracle) and external (IMS, EDI 852) system.
• Implemented the write-back functionality from a WEBI report into an Oracle database table using JAVA Scripts and SAP BO RESTful Services
• Created dashboards using Dashboard Design tool and updated the existing Dashboards provided by SAP.
• Created Business Explorer models for the IMS data sets.
• Created HANA scripts for Tables and Views creation.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data and the calculation views (both Graphical & SQL script based)
• Performed SAP HANA Data Provisioning using SAP LT Replication Server (SLT) as final model in HANA Studio
• Created Universe on top of the SAP HANA tables and Oracle tables for the WEBI reports.
• Worked on modifying the existing SAP BODS jobs to implement the changes to the business logic.
• Created WEBI reports on top of existing SAP BI system, using BEx queries and schedule on a daily/ weekly/ monthly basis.
• Perform Admin activities on the SAP BOBJ server, server upgrades, apply patch, apply user Security.

Confidential, San Francisco, California

Role: SAP BOBJ 4.1/4.2/SAP HANA/SAP BW/CPI Architect/Lead Consultant

Responsibilities:

• Create SAP BOBJ data visualization using Design Studio dashboards using GeoMaps, CrossTabs, Panel components
• Implemented Dashboards using SAP Analytics Cloud Solution
• Implemented SAP BOBJ RESTful Web Services SDK for 3rd Party Design Studio Component.
• Used the SDN Components EmbeddedFrame, Data Iterator, Timeout to implement the functionality that’s not available out of box.
• Implemented data writeback to a HANA table, using a HTTP Call to a Stored Procedure with parameters
• Create Tables and Calculated views in HANA.
• Performance Tuning the BW and HANA Datasources for the Dashboard to run within the SLA defined.
• Use the HANA Calculated Views with variables (Prompts on Design Studio) as the data source for the dashboard.
• Created SAP BEx Queries to use them as a data source on the Dashboard (Eg: License Data by DC)
• Provide support and enhancement to the Dashboard Application based on the user issues/requests.
• Worked on Migrating the Dashboard from Design Studio 1.6 to SAP Lumira Designer 2.x.
• Created Stories using the SAP Lumira Application using HANA and BW Live connections.
• Worked on SAP BO WEBI reports Oracle, SAP BW and HANA

Confidential, California

Role: SAP BOBJ 4.1/SAP BODS 4.2 Lead Consultant

Responsibilities:

• Create SAP BODS jobs to load data from the Oracle database into Oracle tables for WEBI reports.
• Worked on SAP BOBJ Data visualization using WEBI reports and Xcelsius Dashboards on Oracle Database
• Implemented the write-back functionality from a WEBI report into an Oracle database table using JAVA Scripts and SAP BO RESTful Services
• Involved in the user trainings on usage of the WEBI reports.

Confidential, Parsippany, NJ

Role: SAP BW and SAP CPI Lead Consultant

Responsibilities:

• Analyze the requirement for the SAP IBP implementation
• Meetings with the Business Reps and Architects to design the IBP Planning Area.
• Work on identifying the SAP ECC -> SAP BW -> SAP CPI mapping.
• Work on creating objects (DSO, INFOCUBE) missing in SAP BW
• Extract data from ECC into BW and schedule using Process Chains
• Create SAP CPI ETL jobs from ECC/BW to SAP IBP.
• Fix the load performance issues using lookup files.
• Created CPI jobs for the different MRP Elements for the Inventory Sync Charts Planning Area
• Create CPI jobs for Demand Planning PA.
• IBP Configuration - Set up the Attributes, Master Data Type, Time Profile, Planning Area, Planning Levels, Keyfigures, Helper Keyfigures, Snapshots, and Copy Operators.

Confidential, Greensboro, NC

Role: SAP Lead Consultant

Responsibilities:

• Analyze the reporting requirements
• Extract data using standard and Custom ECC extractors into SQL Server Tables.
• Implement delta extraction mechanism using SQL Stored Procedures and triggers.
• Implement CPI-DS ETL jobs to load data from ECC -> MS SQL Server -> IBP.
• Extracted data from 2LIS 12 VCHDR, 2LIS 12 VCITM, 2LIS 06 INV, 2LIS 13 VDHDR, 2LIS 13 VDITM in Delta mode.
• IBP Configuration - Create Attributes, Master Data Types, Time Profile, Planning Area, Planning Levels, Keyfigures
• Create complex calculations using Helper Keyfigures. Snapsohts, Copy Operators
• Create Planning Views using the EPM formatting for data visualization.

Confidential, San Francisco, CA

Role: SAP HANA Cloud Integration for Data Services (SAP HCI for DS) and SAP Integrated Business Planning (SAP IBP) Consultant

Responsibilities:

• Worked on creation of HCI Projects, Tasks and Process to perform ETL from SAP BW/SQL Server into SAP IBP and Flat files to send the data back to SAP.
• Report any bugs identified during the Development lifecycle to SAP. Work on resolving/identifying alternatives in fixing the bugs.
• Tested the data loaded into IBP using the IBP Excel Plug-in.
• Configure statistical forecast in IBP and take monthly Snapshots from IBP.
• Schedule HCI jobs to run weekly and fix any failures if schedules fail.
• Created HCI jobs for S&OP and Inventory Optimization Planning Areas

Confidential, Northbrook, IL

Role: SAP BOBJ 4.1 Lead Consultant / Onsite Coordinator

Responsibilities:

• Involve in the meetings with the Process team (Business) and the Data Architects to identify the source mapping and understand the model defined
• Create TSD for the Web Intelligence reports and share the details with the Offshore developers
• Provide detail explanation on the TSDs to the offshore team on Daily status calls
• Monitor and review the Offshore tasks on a daily basis
• Fix the defects raised during the QC, UAT phases
• Report Examples: Business Metrics Dashboard, Trend Graph P&C (Property and Causality), Trend Graph AF (Allstate Financials)
• Update the data visualizations in WEBI/Crystal reports/universe based on the review comments during the business calls
• Convert the existing Dashboards on Xcelsius to dashboards on Design Studio
• Help team identify the Report variables that can be pushed back on the universe or ETL level, to improve the performance.
• Implement combined query, merge dimensions, graphs and complex variables using Context functions.
• Implement ‘Row Level Security’ on the Universe and set the SLA on the reports.
• Provide Go-live support to the users based on the tickets raised.

Confidential coordinator/Lead and Senior Developer

Responsibilities:

• Re-design the existing Complex webi report based on the new logic from the business
• Confidential: Rescue reports, Call-center reports
• Work with the Business Analysts to get the requirements for the changes to the existing Webi reports and new reports
• Review the reports by the offshore-team and share the review comments to fix the issues
• Share the status on a daily basis with the Stakeholders
• Schedule the reports to share with the Allstate Clients

Environment: SAP Business Objects 4.1, HP Quality Center, Universe Design Tool, Information Design Tool, WEB Intelligence, Crystal Reports, Design Studio, Dashboard Design (Xcelsius), Oracle 11i.

Confidential, Raleigh, NC

Role: SAP BOBJ 3.x/4.x Lead/ Sr. Developer

Responsibilities:

• Understand the existing model and different source systems (Salesforce, Oracle EBS, CDH) and the data flow.
• Understand the enhancements to the existing model to implement the new reports and update the existing reports.
• Followed Agile methodology and attend daily scrum call to update the status to the scrum team and discuss on the issues identified.
• Build reports of the new universe and work on re-mapping the existing Webi reports based on the mapping documents.
• Help team identify the Report variables that can be pushed back on the universe or ETL level, to improve the performance.
• Implement combined query, merge dimensions, graphs and complex variables using Context functions.
• Raise defects for the backend team for the data related issues.
• Work on the INT2 testing, UAT defects and work with the users to validate the fixes.
• Involve in the meetings with the users to get requirements for post Go-live reports.

Environment: SAP Business Objects 3.x/4.x, Universe Design Tool, WEBI, Redshift, Salesforce 15, Oracle EBS.

Confidential, Boston, MA

Role: SAP BOBJ Architect and Migration Lead

Responsibilities:

• Understand the Architecture of the existing SAP BOBJ 3.1 Application
• Performed installation, applied patches and changed settings on the server to make sure the system is tuned for the 250-300 users
• Setup Windows authentication for the users
• Copy over the existing Objects (Roles, Users groups, Reports, Universes, Connections) from the existing BOBJ 3.1 Environment to the BOBJ 4.1 Application
• Train users on the new tool and new applications as part of the 4.1 toolset.
• Performed Stress testing on the new system and change the settings as needed.

Confidential

Role: SAP BOBJ 4.x Lead/ Sr. Developer

Responsibilities:

• Analyze the existing reports on the SQL Server Stored procedures and Access Database.
• Create Multi-sourced Universe on top of the base tables used for the SQL Server Stored Procedures.
• Create the Inventory reports using WEBI for IPAD.
• Apply the RLS on the universe.

Environment: SAP Business Objects 4.0 SP5 FP13 - Information Design Tool (UNX), WEBI, MobileBI Interactive Analysis, Life Cycle Manager, CMC, SQL Server 2008.

Confidential

Role: SAP BI/BOBJ 4.x Lead/ Sr. Developer, SAP BODS Lead

Responsibilities:

• Involve in validating the BOBJ Objects after the upgrade
• Identified the upgrade issues and find workarounds to minimize the impact on the users
• Work with SAP on the upgrade issues to get the fix
• Explore the new features on the 4.1 environment.

Confidential

Role - Universe Architect, Onsite coordinator/Lead and Senior Developer

Responsibilities:

• Involve in the meetings with the Process team (Business) and the Data Architects to identify the source mapping and understand the model defined.
• Develop and design the Professional Services Universe on GDW (Oracle) data source, based on the discussions with the GDW data architect and Business.
• Created 14 Contexts, custom Hierarchies, Aggregate aware objects, MTD/QTD and ITD calculations, currency conversions on the universe side.
• Worked on the Invoice Report and Unbilled, AR aging Report, forecasting report
• Active Backlog Revenue Forecast Only) and Partner Purchase Order Management Process report as part of the project deliverables.
• Implemented Merge dimensions, Created Graphs and Drill through between the Dashboard and the report.
• Confidential - Booked Amount, Invoice, Actual/Plan Cost/Margin, Revenue Amount, Unbilled, Unpaid, Backlog, Budget
• MRS Confidential - Hard/Soft booked hours, Open/Filled demand Hours, Assigned hours, Total Demand hours,
• Utilization buckets (Customer Delivery, Admin Management, Presales, Internal, Time-off hours)
• Involved in identifying the source for the BI Project Management Dashboard.
• Create the test cases for the reports and test the reports based on the identified Test cases/Scenarios.
• Implement the RLS (Row Level Security) on the Universe.
• Defects - Worked on the defects raised by the Process team and BEN Testers (based on the scripts) as part of the Mock 3 and Pre-go live phase of the project.
• Provided basic and advanced training on how to use the universe, creating basic/Complex reports, scheduling, using Contexts, implement merge dimension to Super users and end users
• Create ETL jobs using BODS for getting data from the non-SAP data sources.
• Lead 7-member team working from Offshore (IDC).
• Perform the development activities using the Agile Methodology.
• Requirement gathering from the users to design the reports.
• Design BEx Queries based on the Technical Design documents.
• Design the WEBI reports based out of Universe (.UNV/.UNX) and BEx, the designed reports were then accessed from BO Mobile App.
• Convert the existing WEBI report on BEx Query .UNV to BICS reports (BICS).
• Design the Bookings GDW (Oracle 11i) based UNX using the Information Design Tool.
• Production Support - Work on the issues raised by BOBJ users on R1 reports.
• Involved in the migration of SAP BOBJ 4.0 SP2 FP13 to SAP BOBJ 4.0 SP5 FP2.
• Design Dashboards using BOBJ Explorer components sourced from SAP HANA and SAP BW systems.
• Presented the features of Dashboard Design to the users.
• Created prototypes from Design Studio sourced from SAP BI, Universe (DS v1.2), SAP HANA, using JAVASCRIPTing.
• Created ControlM Job to trigger a report in SAP BOBJ based on the SAP BW Process Chain completion.
• Worked with Lifecycle Management (i.e. versioning, promotions between environments)
• Performed testing the SAP BOBJ 4.1 SP2 FP4 environment features.

Environment: SAP Business Objects 4.0 SP5 FP6 - Information Design Tool (UNX), Interactive Analysis, Life Cycle Manager, CMC), Analysis View for Excel, Crystal Dashboard Design (Xcelsius 2011), BOBJ Version Management, SAP BI 7.3, BEx, Oracle 11i, Peregrine Service Center(Tickets monitoring tool), SAP BOBJ Explorer, SAP BOBJ Design Studio, ControlM, SAP HANA(Source), JAVAScript.

Confidential, Rochester, MN

Role: Senior BOBJ 4.0 Consultant

Responsibilities:

• Requirement gathering from the users for the design of the dashboard.
• Interact with the ETL team to design the Data marts in the database.
• Create MQT in the DB2 database for calculating the YTD Calculations for Dashboard Data.
• Create (.UNX) using the Information Design Tool (IDT) to include 15+ metrics for every mayo location, department, divisions and Provider. Created Multi-source Universe using IDT.
• Design and develop DBR (dashboard reports) and the EUR (End user reports) using Interactive Analysis tool (Web Intelligence tool).
• Develop the dashboard framework, child-dashboards, using the Open-Document functionality, QaaWS connections on Dashboard Design (Xcelsius).
• Implemented the Centigon solutions Filtered summary and Dynamic Sort feature on Dashboards.
• Implement Flash variables to pass parameters from the framework dashboard to the child dashboard.
• Drill down from the dashboard to the report, by passing parameters from the dashboard.
• Used and implemented the Version Management tool within BO 4.0.
• Interact with SAP for fixing the issues faced during the project life cycle.
• Created sample reports using Crystal Reports 2011.
• Some of the metrics implemented: Surgical OR Total Patients, Surgical OR Variance, Off-Hour utilization, Primetime Utilization, Surgical Yield and Patient Satisfaction Index.

Environment: Business Objects 4.0 SP4 FP5 - Information Design Tool (UNX), Interactive Analysis, Life Cycle Manager, CMC), Crystal Dashboard Design (Xcelsius 2011), IBM DB2 8.0, MS SQL Server, Version management (within BO 4.0), Crystal Reports 2011.

Confidential, Dallas, TX

Senior BOBJ 4.0 Consultant

Responsibilities:

• Setup and maintain the User Security in the BO 4.0 Server.
• Migrate the User Security and BO Objects to different BO Environments using Life Cycle Manager (Environments: Sandbox, Development, Test and Production).
• Configured the BO Explorer 4.0(BO Mobile) for IPAD/IPHONE Application.
• Set-up the connectivity from the BO Server to the Source Database (Teradata, MS SQL Server).
• Install the latest service pack and fix pack on BO 4.0 Server.
• Configure/Set the BOBJ Server(Services) Parameters - Eg: Session Timeout, WEBI data Size, WEBI RAM Usage.
• Fixed the errors/issues in the BO 4.0 Server environment.
• Create Universe (UNV & .UNX) using the Universe designer and Information Design Tool to migrate the existing Microstrategy Reports to Business Objects Interactive Analysis Reports.
• Understand the Microstrategy reports and implement the same in BO Interactive Analysis and Crystal Reports 2008.
• Created drill through Interactive Analysis reports using the Open Document functionality.
• Created Xcelsius Dashboards using the LIVE Office/QaaWS Connection with dynamic filters in the dashboard (Butter Fat Content, Coliforms, Psychotropes %age, Total Quality Scorecard).
• Drill down from Dashboards to reports using the Open Document functionality.
• Train the users and developers on Business Objects Tool.

Environment: Business Objects 4.0 (Universe Designer, Information Design Tool (UNX), Interactive Analysis, Life Cycle Manager, CMC), Crystal Reports, Crystal Dashboard Design (Xcelsius 2011), Teradata 13.0, MS SQL Server, Erwin 4.0

Confidential

Role: Senior BI-BO Consultant

Responsibilities:

• Involved in the migration of BO Objects from the BOXI 3.0 to BOXI 3.1 version
• Fixed the Migration errors and issues in the Webi Reports.
• Created Custom Calendar in CMC, for scheduling the reports.
• Involved in discussion of designing the dashboards and identifying the KPI s.
• Created Xcelsius Dashboards using LIVEOffice/QaaWS Connection with dynamic filters.
• Publish the Xcelsius Dashboard in the BOE for the users.
• Integrate the Xcelsius Dashboard in the BO Infoview Portal.
• Worked on the Account Activities/events Dashboard (Data displayed in Calendar), Opportunity by stage (Funnel Dashboard), Waterfall Dashboard, CRM Account Management, Opportunity Forecast Management, Sub - account management dashboards using the CRM database.
• Drill down from a Dashboard to another and to the Webi reports.
• Created Oracle Views and Tables as per the requirement in EDW database.
• Analyzing the existing COGNOS Catalog and creating the Universe based on it.
• Create Alias/Derived tables in the Designer to enhance the capabilities and performance of the Universe
• Migrate the Existing COGNOS reports into the BO WEBI reports
• Developed Summary Recap reports, Open PO reports, AP Distribution Reports etc.
• Interacting with the users to get the Report Requirement s.
• Understand the FOCUS Language code (Legacy System) and prepare the Functional requirements
• Present the document to the Technical Architect and up on approval, create the Universe.
• Create reports on Order data. Open, Cancelled, Transfer, Shipped, Back orders. & Procurement Report.

Environment: SAP BW 3.5/7.0, SAP R/3 4.7 (SD, FI-CO, MM, HR), Oracle 9i, Toad, Windows Server 2003, Windows XP Professional, COGNOS 7, Business Objects XIR2, Crystal Reports, Crystal Xcelsius, Bex Analyzer, AHD Ticket Monitoring Business View Manager.

Confidential

PL/SQL Developer

Responsibilities:

• Troubleshooting the issues posted by the user in the form of the ticket
• Provide production support for Clients based in USA ( Confidential based in Mount Olive, NJ, USA)
• Understand the functional requirements provided by the users
• Develop technical specification documents for the PL/SQL codes and get the approvals from the respective application owners
• Write/debug complex SQL queries, PL/SQL Scripts for EDW. Write Backfill Scripts to correct the existing records in the tables
• Collect and document requirements from the client.
• Implement change controls / Enhancements involving Table/ View modifications
• Generating test cases for each specification received and test the scripts
• Addressing production issues in PL/SQL scripts like Performance Tuning and Enhancement
• Create EDW-SAP R/3 - SAP BW Mapping documents as part of the EDW Decommissioning Phase
• Involved in CMMi Activities for the project.

Environment: Oracle 9i, SQL, PL/SQL, Toad 7.4, SAP R/3, SAP BW 3.5, COGNOS 7.0, Windows Server 2003, Windows XP Professional, Windows telnet for UNIX, AHD Ticket Monitoring, Erwin 4.0.