SUMMARY:

• 9 + Experience with SAP / ERP Certified in Business Intelligence using SQL, SAP ECC/BW/ HANA / Business Objects XI - 4.0 / R3.1 / R2 / 6.x with Info view, Web Intelligence, Webi Rich Client, Desktop Intelligence, Design Studio, Lumira, Office for Analysis/ Query Designer, Bex Analyzer, Dashboard Design 4.0, Xcelsius 4.5/2008, Data Services 4.0/3.2, Data Integrator 3.2, Central Management Console (CMC), Central Management Server (CMS), Central Configuration Management (CCM), Query as a Web Service, Live Office, Publishing Wizard, Import Wizard and Report Conversion Tool.
• Worked with SAP America/China and Confidential Very Closely for a world Wide Xcelsius Dashboard Product.

PROFESSIONAL EXPERIENCE

Confidential, Ann Arbor, MI

SAP Business Objects Consultant

Environment/Tools: SAP BO 3.2/4.1/4.2, Design Studio 1.6, Lumira, SAP BW 7.3, Bex, Office for Analysis, Xcelsius 2008 SP3, Dashboard Designer, IDT, UDT, Webi Rich Client, HANA Studio / Teradata/Oracle/SQL Server.

Responsibilities:

• Worked on Implementing SAP HANA Studio / BW / BO Reporting Solutions - Complete BI Suite on their Maiden SAP PTT Venture, This includes implementing - FI, CO Modules in phases as their Primary initiative to replace 3rd party applications and bring SAP ECC / BW 7.3 / BO 4.2 and also the complete BI Suite on board to Xcel.
• Current Role Demands assisting Users with their daily Reporting Needs. Gathering Requirements, Solving Reporting Issues. Helping Users to Use SAP Business Objects to a great extent, and support moving over from legacy reporting tools., demands also include training, guidance to Xcel user base with SAP BO / BW tool set.
• Installed and configured SAP Design Studio in Dev and Test Environments
• Extensive experience in developing wire frames for Various Dashboard requirements including Meter Metrics, HR, FPT, and FERC Trial Balances for Rate case scenarios using SAP Design Studio 1.6.
• Used Design Studio best practices to enhance the performance of the dashboards (Parallel processing, Global Scripting, Load Data Sources Only When Components Get Visible, Page books etc)
• Used lots of CSS coding for enhanced visualization
• Designed advances level Dashboards using SAP BW, HANA and Universe Data Sources. These interactive dashboards can be accessed on mobile devices like iPad, mobile phones, and tablets. Designing involved developing interactive dashboards and advance data visualizations by using charts, crosstabs, etc. and alias of data source.
• Projects I have so far worked on at Confidential include SAP PTT FICO, SAP WAM Implementation, Risk Master, AP Liability, HR, RIS, Financial Management Systems (FMS), and BO Audit Metrics Projects. I have been the primary business Objects Developer for these projects, I have had the responsibility to get the Projects started, gather user requirements, Build Universes / Reports & Dashboards as required for the Projects from Start till the End.
• Using Info Burst, for Scheduling Reports / Dashboards as per the project needs.
• Have worked on developing additional Logic around Activity Universe / Analytics 8 (System Profiler) to support required BO Auditing in new SAP BO 4.1 Environment.
• SAP PTT (BW/BO Implementation) and FMS Application upgrade projects has been the most complex project that I have worked on here at Confidential till date on SAP BO 4.1, I have worked on Developing / Merging Universes, Converting the Reports from earlier legacy Universe to New universes that have been built on New Applications. The Universe Merging and Developing has been performed with utmost care to provide minimum User complexity and provide a more comfortable reporting environment for users to cope with the change with a very low learning curve. And also during this phase we introduced many new tools to the client from Lumira, Design Studio, Office for Analysis which grew from prototypes to full fledged analytical tools.

Confidential, CA

 Sr SAP BOBJ Developer

Environment/Tools: SAP Business Objects 4.0, Xcelsius 2008 SP3, Dashboard Design 4.0, Excel Functions, SAP BI/BW, MS SQL Server 2008, BICS/BIWS, Webi, QAAWS.

Responsibilities:

• Worked on SAP Business Objects 4.0 (IDT, Xcelsius, QAAWS, BIWS, Webi Rich Client, Import Wizard, CMC, Launch Pad.
• Prototype building, design changes, and user input evaluation to sign off on the final scope, solution and End production realization.
• Worked on Designing & Developing complex interactive Dashboards “HR Sempra View” & “HR Organization View” using BIWS. Dashboard Has Multiple Levels of Org Level Hierarchy Drill Down, Drill UP designed to dynamically startup based on users level of access using Centigon 3rd Party Comp.
• Dynamic Reports Using additional 4.0 Features such as Content Linking, Element Linking, Folding etc.
• Use SAP BIWS to connect dashboards to SAP Business Object Webi reports.
• Used Open Docs to connect SAP Dashboard with relevant Webi Reports and passing Parameters as required based on User Selection.

Confidential, CA

 SAP BOBJ Developer

Environment/Tools: SAP Business Objects XI 3.2/4.0, Xcelsius 2008 SP3,Data Services 4.1/4.0/3.1, Data Integrator Excel Functions, SAP BI/BW, SAP Net weaver, Bex, Webi, OLAP Universe, BIWS, QAAWS.

Responsibilities:

• Work on SAP Business Objects XI 3.2/4.0 (Universe Designer/IDT, Dashboard Design 4.0,Xcelsius, QAAWS, BIWS, Webi Rich Client, Import Wizard, CMC, Data Services, Info view etc.) and SAP BW Environments.
• Worked on Designing & Developing several complex interactive Dashboards on top of Webi reports built using Bex Queries on an OLAP Universe.
• Project 1:-Involved in a High Visibility Project involving Webi Reports / Xcelsius Dashboards at various Levels such as AVP, CSD, CSM, ASD, ASM levels for business areas related to People Metrics, Surgeon trends, Training Metrics, Productivity Metrics, for different Levels of Hierarchy.
• Project 2:- Designed and developed Contract Management Dashboard, to list the various products on the company’s line of service such as Davinci S, SI, Standard etc their Sales Qty, Contract Deal Price, Status across various geographic locations and split wide onto various business units and business sub units.
• Creating a One Point Entry Dynamic Dashboards including Virtual Data Restrictions with Certain Conditions.
• Used SAP Flash Variables namely SAP Serialized Session to support dynamic entry and query triggering design. Used to extract User name and further supply it to webi services to filer data based on user hierarchy.
• Dashboard design earned very good feedback as one of the best dashboard they currently have.
• Proficiency in Data Warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting

Confidential, MN

 SAP BOBJ Developer

Environment/Tools: SAP Business Objects XI R2, Xcelsius 2008 SP3, Excel Functions, SQL Server 2008, SAP Net weaver, Bex, Webi, Crystal, Universe, QAAWS, Live Office, Epic/Clarity Model.

Responsibilities:

• Worked on SAP Business Objects XI R2. Work involved using Tools Universe Designer, Web Intelligence, QAAWS, Live Office, Info View, and Xcelsius.
• Clinical and Operational reporting with primary emphasis on Health care Info in an EMR System.
• EMR Reporting using Clarity (EPIC Database Model) for Hospital Billing (HB) / Claims Reports.
• Creating Dashboards, Scorecards, and reports out of its Enterprise Data Warehouse example: - Patient Medical Administration Reports, Cancer, Kidney, and Women’s Health.
• Worked on Gathering Requirements, Understanding technical specifications, designing solution, identifying scope and collaborating to a great extent with the ETL team to help design a Data Warehouse to serve the project needs. The data had to be brought from EPIC Clarity etc and hosted on the SQL Server database.
• Developed Universes for Kidney / Cancer / Women’s Health Projects using Universe Designer and SQL Server 2008 as the Source Database. Used a Combination of Detail, Summary and Derived Tables and simultaneously joins (Equi, Theta, and Outer), Cardinalities, and Contexts etc. to create the Universe to work for the associated Project.
• Used Master Universe Concepts where Each project area had a master universe and any subsequent area related to project areas were separately linked further to unify and collaborate huge data requirements needs
• Used (standard extracts provided by Epic) SQL Server 2008 excessively for Data Validation, Join Determination, Table Understanding, Metric Calculation, Testing, Verification and Data/Requirement Understanding.
• Developed Webi Reports, Summary and Detail Reports, Using the Summary as the source for the Xcelsius Dashboards and the Detail is linked through Open Docs to view the User Selections from the Dashboard in Detail.
• Developed Dashboards Using the Source as Webi Reports, which were built on Universe, Imported the Webi Reports using Live Office.
• Created Dashboard User Interface Prototype for the different Projects based on User needs, Data Visualizations, Drill Downs etc. as adequately required using Xcelsius 2008 Sp4.
• Worked on Data Modeling, and Designed as per the requirements for building the dashboards in Microsoft Excel.

Confidential, NY

SAP BOBJ Developer

Environment/Tools: SAP Business Objects XI R2/3.1/4.0,Xcelsius 2008 SP3, SAP BI/BW, SAP Net weaver, Bex, Webi, Crystal, Universe, QAAWS.

Responsibilities:

• Build Xcelsius Dashboard using Live Office, & QAAWS Using Universe as the Source of data.
• Used Open Docs to allow users to move from the Dashboard to its related detailed Webi report. And also from Webi reports to another reports using hyperlinks achieved through using OPEN Docs.
• Used User row level security for data in the Dashboard. Used BO User variables and also Flash variables such as CELogon token to provide Token exchange since dashboard is deployed outside Info view.
• Worked on SAP BOBJ EPM, Performance Manager for Dashboard framework.
• Provided Architecture and Solutions Engineering regarding projects that were supposed to be implemented using SAP Business Object Tools, Such as Universe Designer, Web Intelligence, Crystal Reports, QAAWS, Live Office etc. accordingly to the architecture currently suitable for the client.
• Maintained Architecture for the BO XI R2 / 3.1 environments BO APAC, BO Emada for Canada, UK and USA for Confidential Organization.
• Worked on Performance Enhancements for the Projects built by other teams, by looking into various aspects like Architecture, Design, Server Scalability and Environment Load Handling.

Confidential, TX

SAP BOBJ Developer

Environment/Tools: SAP Business Objects XI 3.1/3.2,Xcelsius 2008 SP3, Excel Functions, SAP BI/BW.

Responsibilities:

• Build Xcelsius Dashboards using SAP BICS Connector uses SAP BW Queries to get data from SAP BW. Without the need of any BOBJ Platform to import data into excel sheet to serve as the input for the dashboard. And Then Publishing these dashboards back on the SAP Portal since Dashboards made through BICS Connector are not accessible from Info view. Involved in Projects Namely
• OTD Customer Dashboard, Webi Report & Universe.
• OTD Supplier Dashboard, Webi Report & Universe.
• Shipment (Order Fulfillment) Universe & Webi Report Designing.
• HS&E (Health Safety & Environment) Webi reports & Dashboard Development.
• Used Open Docs to allow users to move from the Dashboard to its related detailed webi report. And also from Webi reports to another reports using hyperlinks achieved through using OPEN Docs.
• Worked on production support for solving issues related to Universe, Webi reports & Dashboards Creation.
• Used Bex Queries all through the Project to build OLAP Universes, and Webi Reports & Xcelsius Dashboards.
• Worked on Bex Analyzer to test the above mentioned Xcelsius Dashboards, Webi Reports & Universe, to verify & test the Consistency of data all throughout the SAP BW & SAP BOBJ Platform.

Confidential, PA

 SAP BOBJ Developer

Environment/Tools: SAP Business Objects XI 3.1/3.2,Data Integrator XI, Xcelsius 2008 SP3, SAP BI/BW, SAP Net weaver, Bex Analyzer, VIM 6.0.

Responsibilities:

• Build Xcelsius Dashboards using SAP Web services created from SAP Net weaver. Without the need of any BOBJ Platform to import data into excel sheet to serve as the input for the dashboard.
• Various other forms of dashboard development also performed including Data from SAP BW through Bex Queries, Data from Universe using QAAWS, Data from Webi reports, Crystal Reports using Live Office etc.
• Dashboards Using Advanced Multiple Drills Down, Dynamic Visibility, and Alert Features were designed to support Complex Requirement Scenario.
• Designed dashboard using best practices and advanced filtering techniques to dynamically filter and serve as the source for the dashboard.
• Optimized dashboard performance for speed of thought analysis even with large data volumes and simultaneously allowed user customization on the fly.
• Worked Extensively with Flash Variables, web services and made Generic Dashboards to enhance Performance in Situation to Decrease Load on the Parent Dashboard, and Designed Child Dashboards to Distribute Load among Various Child Dashboards to Mitigate the Performance Issues
• Used Complex excels functions and logics to support data requirement. Ex: - Vlookup, hlookup, choose, Nested IF’s, Value, IS Number, ISNA, Match, Index etc. to name a few.
• Built Password Protected Dashboard and Created a Scenario to Trigger Multiple Web Services on User Authentication.
• Built Many Static Dashboard Models during all my Work Requirement in due process to Create Generic Live Model Using Web Services, Flash Variables etc.
• Done extensive testing across various scenarios to see the dashboard working across multiple complex and varying scenarios.
• Used various Custom SAP functions exclusively for Xcelsius to help in this process to additionally implement thousand separators and decimal Operators to support various different number formats.
• Used Data Integrator to a great extent which involves creation of complex Jobs, Workflows, Data Flows, Writing Scripts and using different Transformations to successfully load data from multiple sources into a desired target

Confidential . Kansas City, MO

SAP Business Objects Developer

Environment/Tools: SAP Business Objects XI 3.1/3.2,Data Integrator XI, SAP ECC, SAP BW, SQL Server

Responsibilities:

• Worked on user requests to solve ticket based issues, providing solutions, training and guidance.
• Answered user calls and further worked on their requests to any login issues, server issues, scheduling requirements, SAP BO Objects universe, webi, dashboard enhancement requests.
• Performed a business analyst role to convert user requirements into Functional requirement documents to further start development upon sign off and initial data mining.
• Moved objects using import wizard from DEV to QA and or Prod environments in order to support change management and backup of Sap BO Objects.
• Created User, assigned rights/roles based on new requirements or for maintaining Power users for a project.
• Supported Folder Level Hierarchy in Infoview.
• Used Data Integrator XI for various ETL needs, by using transformations like Map Operation, Table Comparison, Row-Generation, Query, SQL transformation, Query, Case, and Merge transform etc as required to perform tasks assigned.

Confidential

SAP Business Analyst

• Performed various duties concerning Confidential, below is a summary of my work reported to “ESSAR”, being “ESSAR” wants to take over the industry, they appointed me to submit the study of the industry requirements and other factors..
• Work requirements involved preparation of a Business Case Justifying an Acquisition of a Plant, thereby analyzing & simultaneously predicting other resulting consequences such as Material requirement Planning (MRP), Production Planning, Sales, & Marketing Developments required.
• Heavily Dependent on Web Intelligence for creating Ad-Hoc Reports to drill down data and analyze data etc for various purposes.
• Worked closely with the Pricing department in determining products price at regular intervals in accordance to market competition/situation based on various conditions such as the raw materials price, seasonality, marketing/advertising strategy etc, uniquely for different Distribution channels.

Confidential

Business Analyst Intern

• Worked as a full - time Intern, with Marketing, administration departments at Confidential .
• Project included working towards developing efficient and effective Enterprise Resource Planning process to improve productivity, and provide more insights to the organizations processes
• Worked on performing SWOT analysis of the company’s business processes, then studied the opportunity to market new age technology innovations from Nortel that could be beneficial for companies to improve Integration, provide better contact support, maintain better Customer relationships,
• Worked on Dashboard Development etc based on requirements etc from Business Objects platform.

Confidential

Business Analyst Intern

• Worked as a part of the team, Project included calculating forecast based on previous historical data and hence so forth worked towards devising marketing strategies to base marketing decisions. Extensively Used Crystal Reports throughout the project to analyze Quantitative Data.
• Worked on their New Product Tyron and its marketing entry into the market. Has to analyzed lots of data and understand key demographics for the product and other aspects related to its likely product strategy.