SUMMARY

• Around 9 years of experience in SAP BW 3.5, SAP BI 7.1 and SAP BO
• Implemented 3 full life cycles, Production support and upgrade experience in BW/BI.
• Individually handled implementation of major modules right from Design/Build phase to global Rollout. Thoroughly studying ‘AS - IS’ processes and providing ‘T0-BE’ processes with the Gap Analysis.
• Implemented SAP BO successfully from scratch including environment setup, Installations, Security, Upgrade and Administration tasks etc.,
• Well-versed in BO Security for users
• Well exposed in the integration of BW and BO
• Worked on Universes design, Webi, Crystal Reports and Xcelsius Dashboards.
• Worked on Live Office and QAAWS Connections
• Transported BO Objects using Life Cycle Manager.
• Worked on SAP BI 4.0
• Proficient in working on ABAP and almost worked for 4 years in SAP BI and ECC environments.
• Involved in requirement Analysis, design, development, upgrade, production support and enhancement.
• Interacted with Business Users for business requirement and gathering of the reports.
• Exhaustive analysis of Business Content at the Project Blueprint level.
• Worked in SAP PBF module for budget formulations.
• Expert in SAP BW components including Extract Structures, Extractors (RE,PM,LIS, FI,COPA, SD, MM), Data Sources, Transfer rules, Info Sources, Update rules, Transformations InfoObjects, ODS/DSO, InfoCubes, InfoSets, Virtual Infocubes, Write-Optimized DSO, Multi Providers, APD’s.
• Experience in creating Generic Extractors, involved in enhancing existing transactional data extractors. Modified and created User Exit, function modules programs to accommodate additional fields in the extract structure of the data source.
• Involved in data extraction from legacy applications, non-SAP Data Sources, SAP ECC, data acquisition, cleansing and loading.
• Extraction, Transformation and Loading of Data (ETL) - preparing SAP R/3 for SAP BW and Defining the loading strategies, initial and delta data loads, Loading data via flat files, scheduling and monitoring data loads.
• Expertise in performance tuning of BW systems. Evaluated performance using EWA Report and Improved data load, query performance by compression of Info cubes, partition, creating aggregates
• Extensive hands-on experience with ECC and flat file loading for transactional data, master Data attributes texts and hierarchies.
• Expert in use of Process Chains to automate loading of all master and transaction data.
• Worked on broadcasting the reports to the users.
• Strong knowledge on Open Hub source - Info Spokes.
• Worked extensively on BEx Analyzer, Query Designer. Used Navigational attributes, CKF’s, RKF’s, Filters, Exceptions, Conditions, Jump targets (RRI), Variables/formula/CMOD/Authorization variables, Hierarchies and Exception Aggregation etc.
• Developed web reports, web items, and customized web templates using Web Application Designer
• Knowledge on Reporting Authorizations, users profile maintenance (PFCG).
• Enhanced standard DataSources, programmed user Exits for Data Sources and variables, customized transfer, Start routines and Update Rules, Using ABAP routines.
• Strong Knowledge of conducting training sessions for users in BW reporting.
• Experience in leading team, planning and assigning activities and proven leadership capability.
• Proactive, flexible personality and ability to work independently

TECHNICAL SKILLS

Data Warehouse Tools: SAP BW 3.5, SAP BW 7.1, Business Objects XI 3.1 and BI 4.0, Data Federator

Reporting Tools: BexDesigner, Analyzer, WAD, Broadcaster, Universe Designer, Crystal reports, Xcelsius, WEBI

Interface: RFC,BAPI,ALE,IDOC,Flat Files

Languages: ABAP/4, C, JAVA, Oracle

PROFESSIONAL EXPERIENCE

Confidential, New York

BW/BO Lead

Responsibilities:

• Acting as a lead/architect for the upgrade projects to SAP BW 7.1 and SAP BO 4.0
• Handled performance tuning of the SAP BI system
• Improved the performance of the BI system by deleting the PSA logs, building aggregates and Compression of Cubes etc.,
• Prepared the best practices document to-do tasks/activities in SAP BI and BO systems
• Had a smooth upgrade to SAP BW 7.1 EHP1 from SAP BI 7.0 SPS 13 by performing pre-upgrade and post-upgrade activities
• Downloaded the software for the BI 4.0 installation and set-up the system.
• Worked on the issues raised in the process of upgradation by applying s-notes
• Involved in upgradation of BO system from Edge 3.1 to BI 4.0
• Lead a team of 4 members and migrated around 400 Crystal 2008 reports to Crystal Reports 2011, tested and validated them along with the team.
• Developed many Open Order reports with sub reports using crystal reports 2011
• Changed the drivers of crystal reports from BW Driver to MDX Driver as they are not supported in CR 2011
• Used Upgrade Management tool (UMT)for migration and LCM to migrate reports within 3 environments
• Resolved the issues in migrating repository objects, client tools connection and post-upgrade testing etc.,
• Solved the inconsistency of the Open Orders and Sales Analysis reports and re-developed complex crystal reports with multiple groupings, calculations etc.,
• Worked on OLAP Analysis and Explorer tools for the end-user requirements
• Developed OLAP connections and Relational universes using Information Design tool (IDT) for explorer
• Worked on a demo using publishing in BO and published the reports using “Publication” to BO inbox and to shared locations using Profiles
• Resolved issues in crystal scheduling due to unstable load balancing in SAP BW servers
• Worked on supporting the system for security of the users in BO system
• Used Monitoring tool in BI 4.0 for monitoring the system
• Developed documentations on the activities happened during the upgrade of BW and BO systems

Environment: SAP BI 4.0, SAP BI 7.1, ECC 6.0

Confidential, San Diego

BI/BO Consultant

Responsibilities:

• Worked in FI, RE(Real Estate) and PM(Plant Maintenance) modules in assessing the existing system and presented TO-BE design in order to meet the requirements
• Managed to get long text into BO reports using ABAP programs
• Developed the assessment reports by studying existing system
• Designed FI and RE dashboards using Xcelsius by gathering requirements from business users.
• Worked on the Plant Maintenance dashboard in order to showcase the KPI's like Total work order planned vs. actual costs, Time taken to answer maintenance calls, Percent of Work Orders completed on schedule, Preventive Maintenance schedule compliance, Backlog labor hours, Critical Equipment with open orders against them etc.,
• Designed and developed 2 WEBI variance reports
• Worked on Cost Center and Profit Center Accounting reporting.

Environment: SAP BO Edge, SAP BI 7.0, ECC 6.0

Confidential, Wilmington, DE

Sr.BI/BO Consultant

Responsibilities:

• Worked in PBF module in SAP BI ETL and reporting areas
• Developed the technical specifications based on functional Specs.
• Understood the Confidential AS-IS process followed for budget formulation.
• Involved in the data loads of master data(attributes, texts and hierarchies) and resolved the issues faced during that phase
• Worked on the real time budget cube, forecast cube and standard cube for actuals and loaded the data from FI, CO.
• Loaded flat file uploads for Actuals and forecast.
• Source of the data for the info providers is majorly from the Forms and which used to be real time through planning functions
• Worked on the enhancement of the WBS hierarchy generic extractor ZZIVPR HIER in CMOD.
• Worked as ABAP developer for reporting requirements
• Gathered the requirements for the reporting needs of Confidential from the business
• Worked on the custom function modules 'ZPBFBI REPORTING TEXT' which is used to get long text and form elements from forms
• Created a web services and linked the long text/form elements at the BO report level using BO Federator
• Interacted with end users in getting the reporting requirements
• Worked on Bex queries for Capital, Operating, Budget Monitoring and Budget Book reports including Customer exits, RKF's, CKF's, formula variables etc.,
• Worked on around 20 critical reports for Budget Formulation according to business requirements and validated them
• Used many variables, alerts and properties/setting in WEBI during the process of development.
• Handled hierarchies in the WEBI reports
• Worked on universes development following the best practices
• Customized the OLAP universes for the reporting requirements
• Used the Bex queries as source and created Universes and BO reports using WEBI
• Worked on Capital/Operating dashboards requirement gathering and developed them in Xcelsius
• Used Combination, Stacked bar charts and line charts for P&L charts and to get the Actual/Forecast/Authorized values based on the drop down selections for Cost Center, Profit Center and Cost Element
• Worked on complex requirements of getting the hierarchy prompts in the dashboards
• Documented all the developments

Environment: SAP BO XI 3.1, SAP BI 7.0, ECC 6.0

Confidential, Phoenix, AZ

Sr.BW/BO Consultant/Architect

Responsibilities:

• Working as an acting PM managing and leading/supporting the team in all aspects
• Involved in SD, FI, CO- PA, SCM modules end-end developments/enhancements.
• Worked on the functional and technical specifications development.
• Worked in Support Pack up gradation of BW System from 700-SP14 to 701-SP08.
• Analyzed the requirement with respective to the Operating Concern and implemented it end-end by coordinating with Functional Consultants
• Created and enhanced CO extractor 1 CO PA 100 ISO1 using EBW0 based on the Confidential Operating Concern CE1ISO1 and the BW objects till multi-providers in order to perform profitability analysis.
• Made the automated adjustments to match FI and GL figures in COPA.
• Developed around 30 reports under COPA including Gross Margin Report, COPA Sales Data Extract, Sales Breakdown by Site, COPA- GM data extract for Billings and many other key reports.
• Monitored and supported the BI system during month and year end.
• Worked on enhancements of the multiple reports in WAD and query designer
• Implemented the broadcasting of reports over mails.
• Resolved complex issues during support of BW System like resource error, locks, data issues etc.,
• Analyzed new BW report requirements and developed reports like Customer report, Orders related etc.,
• Worked on the calendar DSO in order to adopt the reports using fiscal calendar.
• Worked on Info sets and Write optimized DSO’s for APD’s
• Developed many complex reports including Top 10 Orders, Customers Report, Daily Sales report, Sales Forecast reports etc., using most of features like cell definition, conditions, exceptions, exceptional aggregation etc.,
• Created a custom interface using ABAP coding for glass batch ID which fetches data from MCH1 and YYY BATCH DATA tables in ECC and developed Info spokes for the user access
• Used ABAP Coding in different scenarios like for getting material text in German language, in start routines to read a DSO and populate a Sales Key Figure etc.,
• Developed Complex BW Queries according to the BO report requirements
• Worked on BO Sizing and set up the BO System from scratch with all the installations and integrated with BW System
• Exposed completely to administration and Security tasks in BO
• Well versed in using the CMC,CCM and Info View tools for administration purpose
• According to the requirement of the BO reports reused the existing or developed new cubes/queries from scratch depending on the requirement
• Involved in creating Universes using Universe Designer from SAP and non-SAP sources (ORACLE) following the best practices.
• Worked on complex Sales Dashboards, Visualizations, COQ dashboards in XCelsius, WEBI reports and Widgets
• Used Drilldown, Accordion Menu, Dynamic visibility, and Tab set, Gauge, calendars and many more features for the development of Xcelsius dashboards.
• Worked on Monthly and Weekly Summary/Detail Scorecards which gives metric wise data
• Developed complex Balance sheet and Income Statement reports using Crystal reports.
• Involved in troubleshoot of many problems faced while developing the reports like mdx statement issues, security related etc.,
• Worked in creating the tables for Corrective Measures in BW and creating Corrective Measure Webi reports with direct connectivity to Oracle tables
• Developed many reports using QAAWS and Live Office in XCelsius
• Developed Live Office OPS-Pack and Infringed Product Sales PPT’s
• BO transports using Life Cycle Manager
• Used the Import Wizard for creating the BIAR files for backup.
• Successfully integrated BO with Portal
• Worked on the authorizations in BW and BO
• Upgraded BO System to SP3

Environment: SAP BO, SAP BW 7.0, ECC 6.0,Oracle DB

Confidential, Akron, OH

BW Consultant/Lead

Responsibilities:

• Managed and implemented the technical application components by ensuring that the technical solution solves the business problems and played a role as an architect
• Full cycle implementations in SAP BI from blueprint, design, configuration, and testing, to go-live and production support
• Acted as a Mentor to a team of 3
• Experience with developing custom extractors
• Independently handled FI - GL, COPA and SPL modules
• Automation of Balance Carry Forward in GL.
• Lead the design and development of General Ledger/SPL module and rollout of many business critical reports under General modules which address the Compliance requirements as well as Management Reporting Needs like Key Indicator’s Report, Cash and Cash Equivalent - Standalone/Consolidated reports, Segment Reporting - Vertical/Geographic and Service Offering, Trail Balance Reports etc.
• Implemented tax allocation model which is a high business value model completely custom development using Generic extractors. Designed and developed complex Reporting which served the reporting needs and SOX compliance for the purpose of International Tax computation
• Enable faster closure of International Tax computation at Month/Qtr end by providing item wise net margin report. Reduce the cycle time by 15 days during quarter end and better analysis of the exception.
• Interacted with the business in analyzing the KPI’s and explored business content to implement delivered objects
• Installation and activation of standard business contents and customizing it
• Automation of Balance Carry Forward in GL.
• Worked on the new GL Extractors 0FI GL 14 and 0FI GL 20 and the SPL Totals Extractors
• Appended additional fields in the extractor and had a logic in CMOD to populate those fields using ABAP Coding
• Analyzed cost based controlling and profitability of an operating concern IS01.
• Designed and developed custom DSO’s, Cubes, Multiproviders, InfoObjects
• Used Custom DSO’s and Info Cubes ZFIGL C40, ZFIGL C20 and staging DSO’s
• Worked closely with the end users in gathering requirements and developed complex SPL reports which were used for Taxation purpose
• Worked on the Daily Balance Reports, GL Reconciliation and Income Statements reports
• Worked on ECC Custom extractors, Business Contents, BW backend objects, APD’s, Aggregates, Process Chains, query, RRI’s, query views and WAD developments
• Involved in BW upgradation phase from BW 3.5 to 7.0 including Pre-Upgrade and Post-Upgrade Activities.
• Worked on COPA related back-end enhancements, validation of data to match with Sales /Billing and reporting area.
• Resolved many issues faced during upgrade by troubleshooting and using OSS Notes.
• ECC and BW Transports
• Broadcasting of reports
• Handled the System Copy from PRD ECC to TEST ECC reworks efficiently
• Handled post production support of the system and also Month, Year and Quarter end special supports.
• Responsibilities also include monitoring the SAP system, performing enhancements, tune and improve performance of the system
• Worked on the issues in user authorizations on the reports faced due to object level authorization.
• Preparation of Technical Specifications
• Conducted end-user documents and Trainings

Environment: ECC 6.0, SAP BW 7.0

Confidential, Houston, Texas

BW Consultant

Responsibilities:

• Worked in Interfaces(Inbound and Outbound) module
• Created functional requirements as an input to application design
• Developed and tested detailed functional designs for business solution components and prototypes
• Worked on Generic pseudo delta using Function Module using ABAP and LIS extractors, BW Backend objects and InfoSpokes
• Installation of Business Content
• Worked on the generic extractors ZLIPSO2, ZKNVP and standard LIS extractors 2lis 13 vdkon and 2lis 13 vditm
• Worked on Master data extractors related to 0CUSTOMER, 0DOC TYPE, 0BILL TYPE, 0ITEM CATEG, 0MATERIAL
• Worked on the custom objects ZSDCMD01, ZSDCMD03, ZMMIMO17, ZSDCOO01, ZSDBLO01, ZSDORO02 etc.,
• Developed the Infospokes on all the DSO’s and master data objects like ZSDORO02 TABL TRAN, ZSDBLO01 TABL TRAN,ZMMIMO17 TABL ATTR,Z0BILL TYPE TABL TEXT, Z0ITEM CATEG TABL TEXT etc.,
• Tailored transfer rules and update rules using routines to meet requirements at optimum performance
• Worked on development of custom built hierarchies using flat file and SAP as well
• Extensively worked with flat file loading for attributes and texts
• Managed data loading using both full and delta management
• Done Object transports
• Worked on the documentation of the developments
• Scheduled data loads using Process Chains and monitored
• Resolved many data load issues during the phase of support like DSO Activation failure due to partitions, handled erroneous records using error DTP’s etc.,

Environment: SAP BW 3.5, R/3

Confidential, Milpitas, CA

BW Developer

Responsibilities:

• Duties includes analyzing business requirements, carrying out fit-gap analysis, process design
• Worked on SD and SCM modules
• Involved in the ETL tasks including Infoobjects, DSO’s, Cubes, infosets as per the requirement
• Involved in development, enhancements and support of SAP BW System backend
• Worked on the 2lis 11 vaitm, 2lis 12 vcitm, 2lis 13 vditm, 2lis 03 bf, ZBW INVENTORY extractors and on the standard master data extractors.
• Analysed the performance issues in BW System using EWA report and resolved
• Worked in developing complex WAD’s, query’s like booking, billing and backlog report, Stock VS Consumption report, Sales Pace reports, Book to Bill Report and many sales and inventory reports according to the requirement.
• Worked on the migration of the objects
• Worked on end-end development in SCM module and data was flowed from standard and customized data sources like 2LIS 03 BF, 2LIS 03 UM, Z MM STOCK, Z INV, Z BATCHDATE
• The source data used to flow till the multi providers ZGC0 M006, ZGC0 M010, ZGC0 M008 with many complex translations in intermediate data mart layers.
• Extensively worked in customizations and abap coding in start and end routines according to the user requirements in scenario’s where shipping value is calculated using the values from sales order etc.,
• Developed new tables, views, function modules in R/3 as well as in BW
• Have worked on the non-sap datasources like PRISM and flatfile etc.,
• Created complex RKF’s,CKF’s,Formula Variables,CMOD Variables,alerts,conditions etc.,
• Report to report interface and BEx broadcasting pre-calculation
• Experience in developing custom extractors using tables, views, function modules.
• Worked on the Macros generated report and sent the reports to users every Monday
• Demolished the manual effort of generating reports using macros and developed the portal interface model from scratch to the end and it went live successfully
• Created Meta ProcessChains and scheduled and monitored them
• Provided BW support based on the ticketing system for all the new enhancements, data issues and change requests etc.,
• Trained the end users and prepared user manuals
• Developed the documents like FS, TS, Bluprint documents
• Prepared a Naming Convention document, report templates and used it across the project
• ECC and BW transports in between different landscapes

Environment: SAP BW 3.5, R/3