Professional Summary

• Over 7 years of experience in analyzing , designing, developing, implementing and supporting of Business AnalyticalApplications using SAP BW, SAP BI, SAP Business Objects and SAP Portal
• Involved two full implementations and Successfully executed the BI Upgrade Strategy
• Good understanding of all the phases of system development life cycle and implemented in various projects
• Proficient with ASAP Methodologies and Gap Analysis in project implementation phases like requirementgathering, business blueprint, development, realization, go-live, production support and end user documentation
• Strong experience with OLTP, OLAP Data Warehousing and Business Intelligence using Business Objects XIR3.1, Crystal Reports 2008 and Xcelsius 2008
• Very good understanding of Business Objects 4.0 Components and Good Experience in Healthcare, Financial, Banking, Insurance and Pharmaceutical Domains
• Expertise in Modeling and Re-Modeling SAP BW/BI objects based on Enhancement requirements.
• Proficient in Data Extraction from SAP R/3 (SD,MM,FI/CO, HR and CRM), UD & DB, flat files into BW in the form of data loads using extraction structures such as LO, LIS, FI-GL,FI-AR, FI-AP, CO-PA and GenericExtractors
• Created Info spokes / Open Hub to get data out of BW/BI
• Proficient in designing, developing , debugging and publishing SAP BO reports, using Universe, OLAP Universe, WebI, WebI Rich Client, Crystal Reports, Live Office, QAAWS, Xcelsius, Voyager, Widgets and InfoView
• Vast experience in Crystal Reports (Designing, Sub-reporting, Cubes, OLAP, Adhoc queries, Drilldown, Cross-tab etc.), Crystal Enterprise Server (Publishing, Scheduling, Creating Users/Groups/Roles, Export/Import, Mailing reports to respective target users in Intranet/Internet), Client/Server
• Expertise in generating SAP BW/ BI reports using BEx Query Designer, Analyzer, WAD
• Performance Tuning with Aggregates, Compression, Rollup, Partition, Query Mode, Multi-Provider, Line Item Dimension, Infocube Analysis (RSRV), Query Monitor (RSRT), Indexes and Archiving
• Enhanced standard business content extractors and data sources in various applications and transformations
• Proficient in Schedule reports and maintaining Events, Process Chains to automate data loads
• Experience in integrating SAP BW, SAP BI templates and SAP BO reporting documents in SAP Portal
• Experience in working with Security team while preparing security matrix for data and report access
• Extensively worked on Testing & Transporting of extractors, data loads, reports, queries and dashboards from development to testing and testing to production
• Production Supporting experience in load monitoring, enhancements, report access and change requests
• Experience in training to support and business teams and mentoring off shore team
• Excellent analytical, problem-solving, decision making, human relations and communication skills

Technical Skills

Business Objects XI 4.0/3.1, Info view, Web Intelligence/ Desktop Intelligence, Designer, Broadcast Agent Scheduler, Dashboard Manager, Scorecards, Query As A Web service, Import Wizard, Report Conversion Tool, Life Cycle Manager, Query Builder, Dashboard builder, Crystal Reports 2008, Xcelsius2008, Live Office, Widgets, Integration KIT for SAP, SAP BI 7.0, Business Explorer (BEx) Analyzer

Net Weaver Versions

SAP BI 7.0, 7.1 (NW 2004s) and SAP BW 3.5

ERP Versions

ECC 6.0/ECC 5.0 and SAP R/3 - 4.7

SAP Modules

FI/CO, Logistics (SD, MM, PP), CRM, SCM and HR

Programming

C, C++, Java, ABAP(Routines)

Operating Systems

Windows 95/98/2000/2003/XP/7, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Client: Confidential, Denver, CO Feb 2012 - Till date
Role: Sr. SAP BI/BO Consultant
Environment: SAP Business Objects 3.1 and 4.0, SAP BI, ECC 6.0,SCM,PM, WAD, HCM, Crystal Reports 2008 and Xcelsius 2008

Responsibilities:

• Interacted with Business Users, Business Owners to understand their Business views in developing and modifying Universes and Reports accordingly
• Identified the gaps and suggested necessary enhancements for Transaction data and Master data extractors
• Performed migration of emulated data source using with Export and without Export
• Defined Business Objects landscape for PM and SCM modules
• Managed and Maintained Universe content in Business objects administration
• Queries were developed using Filters, Restricted Key figures, Calculated Key figures and Variables for Characteristics, Key figures, Hierarchies
• Designed and created custom Multiprovider, InfoCube, DSO, Infoset, Enhance extractors, Transformation, DTP and Info package
• Created technical specification for all the reports for PM and SCM
• Review functional specification for all the tracks and come up with mockups for the reports
• Design and develop the universe and map them with SAP report fields
• Performed performance tuning by creating Aggregates, Indexes, Compression and data partitioning within the Infocubes
• Created Ad-hoc reports using Slice and Dice, Drill Down, CrossTab, multiple data-providers, multiple table/section and master detail type reports
• Queries were developed using Filters, Restricted Key figures, Calculated Key figures and Variables for Characteristics, Key figures, Hierarchies
• Coordinating with offshore team to answer the clarification raised by them
• Implemented Query Stripping for the Performance efficiency in WEBI Reports
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops/Ambiguities and checked the Integrity of the Universes
• Suggesting client to add additional components and merging of KPI's for reporting
• Created WEBI reports and crystal reports and deployed them through InfoView with BW universe as source and created BI Quality dash boards using Xcelsius

Client: Confidential, Rochester, NY Mar 2011 - Jan 2012
Role: Sr. SAP BI/BO Consultant
Environment: BI 7.0, SAP BO 3.1, WEBi, Crystal, ECC 6.0, SD, MM, FI
Responsibilities:

• Involved in requirements gathering, proto typing, GAP analysis, design, development, testing and migration to Production environment and post go-live support
• Developed Technical specifications, design documents and cutover procedures
• Involved in the development of the various cubes for SD, MM and FI
• Worked with the R2R reporting project team that analyzes Sales, In-Transit, Demand and actual sales for Demand/Supply analysis from involves multiple Sources systems
• Developed and supported various roll outs in phases for all international territories
• Migrated the AR Aging reports to WEbi and integrated it with the BO Broadcasting agent
• Developed the Daily Sales Reporting for US and Europe Regions using BEx workbooks
• Developed varies reports in the SD area of Order, Delivery and Sales Quantities, top customer analysis etc
• Worked on developing universes using Universe Design Tool based on SAP BW/BI BEx queries, DSO's and Info cubes
• Worked on developing WEBI, Crystal Reports for Sales and Distribution (SD), Finance and Control (FICO), Production and Planning Modules
• Worked on Crystal Reports using formulas, Grouping, Parameters, Hyperlinks, Sub Reports, Running Totals and Hierarchies to handle the end user requests
• Worked on publication to scheduled reports to run on a periodic basis
• Worked on XCELSIUS Dashboard development using QAAWS on Production Lead Time data to know the Actual and Target Lead times for each MRP Control and Material Groups by Year/Month
• Performed performance tuning for InfoCubes/Queries through Partitioning, Aggregates and compression
• Worked with cross team members in resolving data issues and configuration issues

Client: Confidential, Dallas TX Sep 2009 - Feb 2011
Role: SAP BI/BO Consultant
Environment: BI 7.0, BW 3.x, SAP ECC 6.0, SD, FI, BO XIR3

Responsibilities:

• Complete life cycle implementation of SAP BI for SD and FI modules
• Gathered requirements from users and designed documentation for BI and modeled the custom cube along with activation of business content by performing GAP analysis between blue print and business content
• Worked with financial users and SME's to define functions, processes, mappings, implementation and configuration in SAP Account payables, Receivables and General Ledger entries
• Involved in various development activities for Order Analysis cube, Purchasing cube, Purchasing Forecast Cube and Customer Lead Time Analysis Cube
• Created Multi Providers on Info Cubes (Orders, Delivery, and Billing for specific queries) and DSO for unique restricted document level data
• Extracted the transaction data from SAP R/3 (PUR, SD and FI) and flat files to BI using LO Cockpit by maintaining the extract structures, maintaining Data Source, replicating the data sources into BI.
• Worked on performance tuning using BI Statistics, by choosing appropriate query modes and using RSRV to check info cube modeling and data
• Created aggregates and indices, deleted PSA tables, DSO Change logs and performed fine tunes routines where necessary
• Worked with basis team to schedule early watch reports in Solution Manager to monitor BI system.
• Developed report jump targets using RRI (RSBBS) to other reports. Created RRI reports for drilling down from aggregated reporting on cube to line item detail report on DSO
• Created Universe using Designer component of BO XIR/3 and exported it to Info view for other users to generate reports
• Used Business Objects Developer Suite (Publisher View, CMC, Designer, and InfoView) to perform various tasks specific to every component
• Developed SAP BOBI 4.0 Universe and WEBI Reports for PMO's using Information design tool
• Designed and developed XCelsius Dashboards usingUniverse (Query as a Web service), and also used Open Document to drill down from Dash board to detail level of reports created using Web Intelligence
• Used Import Wizard to migrate Universes from one environment to another environment
• Used Business View Manager to create Business Elements, Business Views to use data in CRM, Oracle and generated reports using Crystal Reports
• Created reports, cross-tab reports using WEBi rich client by utilizing prompts, alerteretc and provided Executive Summary report of Managers and representative performances to directors as dash boards in XCelsius bound to Live Office using prompts
• Created management reports, audit summaries & financial statement reports using XCelsius
• Involve in building financial & budgeting reports and applying functions based on requirements
• Used open hub destination concept to extract data from SAP BW system and loaded it into new Info Provider
• Worked in Production support and handled batch jobs, load failures, and system issues

Client: Confidential, IndiaMar 2008 - June 2009
Role: SAP BW Developer
Environment:SAP R3, BW3.5, SD, MM, FICO, ABAP, BEx, WAD and SAP Portal

Responsibilities:

• Required to interact with the management, identify Business requirements, and analyze reports in the SAP FI-CO and SD Functional areas
• Extracted data from FI-GL, AR and AP Transaction Figures and Line Item Data Sources
• Extensively worked on COPA extractors and External Database using DB connect
• Developed process chains for DB Connect data loads
• Monitored system load using 'sm66' transaction code
• Performed System maintenance activities like aggregate roll up, cube compression
• Repeated process chain steps in case of process chain failure
• Executed and maintained process chains for PSA data deletion
• Solved production support issues related to multi-provider mapping, data inconsistency, and job failures
• Created process chains for daily data loads
• Created and monitored process chains for data publishing using Infospoke
• Involved in Performance tuning for various loading issues from source systems, Maximum size of a data packet, no of processors
• Involved in Developing front-end queries using Query Designer and Web Application Designer and publishing results on the web
• Built formula variables and also processing variables using replacement path and customers exit.
• Worked on the extraction of SD, MM, data using LO into BW
• Handled Query performance issues using appropriate objects while construction of Query
• Developed different types of queries like Jump Query, Pre query. The results from the Created, Scheduled and monitored Info Packages and creating process chains to load data from R/3 and flat files, perform aggregate rollups, index maintenance, and Master data and ODS data activation

Client: Confidential, India Sep 2007 - Feb 2008
Role: SAP BW Developer
Environment: SAP R3, BW3.5, SD, MM, BEx

Responsibilities:

• Monitoring of info packages and analyzing the reasons for frequent failures of info packages
• Extensively involved in setting up of procedures for extracting data from SAP R3 by using Generic Extraction, Customizing LO Cockpit by using enhancements
• To communicate with the customer who post the ticket
• To inform the onsite people if there are any dead locks
• Schedule and monitor periodic data loads from SAP R/3 to BW through Delta uploads and Process Chains
• Involved in Load Monitoring Using RSPC, RSMO, SM37
• Involved in Reconciliation of data between BW -Data targets & Source system
• Involved in submitting the Ticket Status (Open/Close) report
• Handled tickets with different priority and never missed the SLA
• Maintain Work History for all the tickets until it is closed down
• Involved in maintaining lot of documentation for all the Support Activities

Client: Confidential, July 2005 - Aug 2007
Role: Project Trainee
Environment: SAP BW 3.1c, SAP R/3 4.6C, SD, MM,BEx

Responsibilities:

• Experience on designing Infocube, ODS, Multipoviders, Infoobjects, designed Dimensions in InfoCubes, Partitioned InfoCube by 0CALYEAR
• Expert in data loading from Data Staging PAS, ODS, Infocube and Designed Transformations between DSO objects and InfoCube
• Extracted the data (Delta Load) using extractor (LO, COPA Extraction) 2LIS_12_VCSCL (Sales-Shipping: Schedule Line Delivery), 2LIS_13_VDITM (Billing Document Data: Items), 2LIS_11_VAITM (Sales Order Item Data), 2LIS_03_BF for material movement, 0PUR_C01 Purchasing to Data Targets in BW and enhanced the data source
• Created new infocubes as per client ZSD_CQ01, ZSD_CQ02 Cubes
• Designed and executed queries in the BEx with calculated and restricted key figures, variables, structures, exceptions, conditions and RRI features
• Created Web templates using Web Application Designer (WAD)
• Query performance improvement and monitoring using aggregates and RSRT transaction
• Worked with security people to create new Roles for BW

Education:
Bachelors