PROFESSIONAL SUMMARY.

• Sr. SAP BW/BOBJ/HANA Consultant with hands on experience on various full life cycle (FLC) implementations of SAP BI projects and has 8+yrs of strong working experience in SAP BW 3.5/3.0 /7.0/7.3 in different functional areas like Sales and distribution (S&D), CRM, Material management, Global Trade Management, Finance and Controlling, Human Resources.
• Extensive experience in implementation and configuration of SAP FI/CO module - General ledger, Accounts Payable and Accounts Receivable, Controlling and Profitability analysis (COPA) SAP SD: Sales order, Delivery and Billing SAP GTM: Trading Contract item data, SAP CRM: Business partner information SAP MM: Initial stock, Historical transactions (deltas) and Valuations, SAP HCM/HR: Payroll (PY), Personnel Actions (PA), Organizational Management (OM), Actual and Labor Times.
• Extensive experience in Requirement Gathering, technical integration and development across various SAP modules, unit/system testing ofbusinessprocesses, performing data loads, preparing Cut over, Plans to move the objects to live.
• Extensive experience in loading huge volume of data into BW. Developed load plans for huge volumes using Company Codes, GL Accounts, Fiscal Year, sales order of R/3 and ECC logistics data.
• Involved in developing SAP ABAP (BI) objects like stat routines, End routine, Expert routine, field routine, Function Modules for Data source enhancements and for designing generic extractors as per business logic with functional modules in SD, MM, FI, CO, GTM and CRM.
• Involved in two Migration projects from BW 3.1c to BI 7.0 (NW 2004s) and from BW 7.0 to BI 7.3.
• OLTP Extraction from SAP R/3 into BW using different extraction structures such as LO, CO-PA, and Generic Extractors along with flatfileextractions of Data from application server and carried out transports to Quality and production environments.
• Installation of Business Content for in SD, MM, FI, CO, GTM, CRM and BI.
• Designed and Customized Info Objects, Info Sources, Created transfer structures, transfer rules, update rules, DTP, and Transformations, Rule groups, DSO, Info Cubes.
• Worked on Project Specific tools like TP Tool, Wrapper tool and Rev Track.
• Carried out Transport to QA and production environments, data transfer using Open Hub Services (OHD)/RSCRM reports.
• Involved in the production support, Scheduling Start Process and Process Chains of Events, fixing errors and daily ETL Data load (Full/Deltaup-load) Monitoring of the BWjobsand designed Process chains for Daily, Weekly, Monthly data loads.
• Good Knowledge on ticketing tools like HP Quality Center (HPQC), HP Service Manager (HPSM), CRIMS CR, CRIMS SR and process chain monitoring using Autosys.
• Configuration and administration of Open hub destinations for external DW Systems.
• Expertise in Report Generation as per user requirements using BEX/WAD.
• Developed flexible queries using filters, navigational attributes, and variables, Cell restrictions, CKF, RKF, conditions, structures, exceptions and RRIs in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detail level of information.
• Expertise in BW Performance Tuning: Performed tuning measures of Queries by maintaining Aggregates, Roll up, Compression, partitions, line item dimensions, indexing of info cubes and use of statistics for the same.
• Worked on creating roles, users, Authorization objects, capture objects releasing objects, providing Missing authorizations and unlocking the users, expertise on troubleshooting the transport logs.
• Experience in designing the Functional specs with respect to BOBJ and uploading them to SOLMON,
• Experience in using Information design tool (IDT), to create universes using multiple Data Sources.
• Created connections to BEX queries and BW Info providers using Business Intelligence Consumer Services (BICS).
• Experience in Designing/Developing Universes/Data-Model, Developing Canned/Ad-hoc Reports, Scheduling and processing of reports.
• Excellent skills to develop reports using Web Intelligence Rich Client 4.0.
• Performance tuning has been done for WEB Intelligence Reports and Crystal Reports.
• Involved in translating requirements from the business related to management reporting into specifications for the technical BW team.
• Experience in SAP BI Testing Across Various Modules.
• Solid Experience in development of Test Plan & Test Cases, Defect Reporting, Test Result & Test Summary Publishing.
• Involved in Preparation of Documentation, End UserTraining& Support.

TECHNICAL SKILLS

Database: Oracle, My SQL, HANA.

Reporting Tool: Business Explorer (BEX), BOBJ /BO 3.x and 4.x (WEBI, Crystal Reports, Xcelcius (Dash board designer), CMC (Promotion Management), Info view.

BI Tools: SAP BI 3.5, 7.0 and 7.3 with HANA, SAP Securities, BW-Integrated Planning, BODS 4.0

Functional Areas: SD, MM(Inventory and Purchasing), FI(GL, AR and AP), GTM(Trading Contract information), CO(Controlling and Profitability analysis), HR(Payroll, Organizational Management, Personnel Actions and Time Mgmt), CRM(Customer Vendor information).

Ticketing Tools: HP Quality Center, HP Service Manager, CRIMS CR and CRIMS SR, Service now, Remedy.

Methodologies: ASAP.

Microsoft Packages: MS Office, MS Access.

Languages: C and SAP BI ABAP.

Platforms: Windows, Unix.

PROFESSIONAL EXPERIENCE

Sr. SAP BW/BOBJ Architect.

Confidential, Montvale, NJ.

Environment: SAP BW 7.3 with HANA, Native HANA, ECC 6.0 and SAP BO 4.1 (WEBI)BODS 4.1.

Responsibilities:

• Segregated the reports and decided where these reports should fell on.
• Requirement gathering has been done for the SD, MM and COPA Modules as a part of Prism Phase 1.
• Gap Analysis has been done and designed the Report Design Documents (RDD).
• Created Attribute views, Analytical views for storing the master, transaction data.
• Created calculated views from multiple analytical and Attribute views.
• Used the performance optimization techniques in sap HANA Modeler.
• Imported the historical data in to SAP HANA tables and used them for further analysis using BODS.
• Used Level based and parent child hierarchies for the reporting purposes.
• Created calculated measures, restricted measures and Calculated attributes.
• Used Web I as a reporting tool for Adhoc reporting on HANA.
• Transferred the data using SLT for real time reporting from COPA and MM to HANA DB.
• Transferred the SD related data using Business objects Data Services (BODS).
• Designed the reports on top of Report Painter for reports related to FI.
• Designed the data flows and build the structures like cubes, DSO, SPO, Transformations, Start Routines, End Routines and Field routines for the use in BPC.
• Designed the Technical Specification Document for the data flow objects.
• Had done the Business content Installation to activate the objects from M version to A version.
• Worked on LO and Business content data sources to extract the data from ECC to BI.
• Created Data store, Background job, data flow, Work flow and used BODS to extract the data from ECC to BI using Query Transformation.
• Designed the BEX reports using the features like Filters, Calculated Key figures, Restricted Key figures, structures, hierarchies, RRI, Variables and Formulas.
• Created WEBI reports on top of BEX using BICS.
• Created custom Hierarchies, cascading of LOVs.
• Extensively used Business Objects Report formatting functionalities such as Drilling Methodology, Filters, Sorts, Ranking, Sections, Graphs, Query Prompts and Breaks.
• Done the UAT, SIT and BAT in the respective systems and documented it and uploaded them in a common shared folder.

Sr. SAP BW/BOBJ Consultant.

Confidential: Maumee, OHIO, (U.S.A).

Environment: SAP BI 7.0, SAP BW 7.3 with HANA, ECC 6.0 and SAP BO 4.0 (WEBI, Crystal Reports), BODS 4.0.

Responsibilities:

• Requirement gathering has been done for the OTC (SD), GTM, FI, CRM and MM (Purchasing) Modules.
• Analyze the RDD's sent by the functional team and do the Gap Analysis.
• Identifying the Fields for the Data sources (2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 12 VCHDR, 2LIS 12 VCITM, 2LIS 13 VDITM, 2LIS 13 VDHDR, 2LIS 46 ITM, 0FI AR 30, 0FI AP 30, 0FI GL 40, ZBIW GTM FTAF, ZBIW RISKDATA, 0BPARTNER ATTR, 2LIS 02 ITM) as per the RDD and extracting the data from the data sources using the Generic and LO extractions.
• Perform the Business Content installation as per the objects dat are necessary.
• Object migration has been done from lower version to the higher version dat is from BI 7.0 to 7.3.
• Designed the flows as per the functional requirement and created the HANA Optimized Cubes and DSOs, SPOs, Transformations, DTP's, Multi providers etc.
• Created and modified APDs and extracted data from BEX query to direct updated DSO for further analysis of Open order data.
• Created Attribute, Analytic and Calculated views and used them in Composite providers for reporting.
• Data Provisioning has been done from SAP and Non SAP systems using BODS and imported the data from flat files(CSV) to HANA column store tables.
• Created Data store and imported the Meta data from tables in the respective functional areas.
• Created projects, Back ground jobs, work flow, data flows and triggered the jobs manually.
• Using BODS we had fetched the data from SAP and Non SAP to HANA for the respective tables.
• Maintained the version Management for the objects to trace the changes.
• Design the Reports as per the RDD's dat were designed and stored in Solution Manager.
• Capture the transports as per the flow and provide them to the release manager for the release.
• Performance tuning has been done to the DSO by partitioning them to make them more effective for reporting.
• Work on the Documentation like RDD, TDD's and User manuals at the time of hand over.
• Provided the End user Training and guiding them in executing the BI Reports.
• Experience in designing the Functional specs with respect to BOBJ and uploading them to SOLMON.
• Created WEBI reports on top of BEX using BICS.
• Created custom Hierarchies, cascading of LOVs at Universe level.
• Extensively used Business Objects Report formatting functionalities such as Drilling Methodology, Filters, Sorts, Ranking, Sections, Graphs, Query Prompts and Breaks.
• Performance tuning has been done to the WEBI reports using different techniques like Query stripping, reducing the no of sub reports and Grouping, Performing most of the calculations on Backend, scheduling the reports to provide it to the user on time, removing the hierarchies if they are not used in BEX, setting the properties like use structure elements in RSRT, Setting the size of adaptive server with the help of the Admin tc..
• Write the start routines, end routines, expert routines and field routines as per the business logic.
• Has done the Data source enhancements for the Business content extractors 0FI AP 30, 2LIS 46 ITM, 0FI AR 30 ...
• Customer/User exit codes have been written for variables in EXIT SAPLRRSO 001.
• File automation and data selection codes has been written for simulating the delta for flat file extraction for Risk Data.
• Written Function modules for extracting the FTAF Data using the tables VTBFHA, VTBFHAPO, and VTIDERI.
• Debugged the codes when and where ever necessary using the Codes RSRT, RSA3, SE37, SE38.

Sr. SAP BW/BOBJ consultant.

Confidential, New Britain

Environment: SAP BI 7.0 and BW 7.3, BW-Integrated Planning (IP)) ECC 6.0 and SAP BOBJ 4.0(WEBI and crystal).

Responsibilities:

• Requirement gathering and GAP analysis has been done for the functional modules SD and HR.
• RDDs has been build with the help of the functional team and distributed the task between the team members.
• Created a custom info object by copying the fields of the standard info object ‘0EMPLOYEE’ and adding some more fields from other info objects. For doing dis installed the data sources ‘0EMPLOYEE ATTR’, ‘0EMPLOYEE ATTR CE’ and ‘0EMPLOYEE ID ATTR’.
• Extracted the data for 0PERSON in to BI from the data source 0PERSON ATTR and maintained the text and hierarchy data for other info objects dat need to be displayed in report.
• Activated the Business content data sources like 0HR PY 01, 0HR PA 1, 0HR PA OS 1, 0HR PT 2 in RSA5 and enabled the properties of the extract structures.
• Replicated the data sources on to BI Side and build the objects like info areas, info object catalogs, cubes, DSO, Multi providers, info sets etc depending on the properties of the data sources.
• Business content installation is done for the objects dat are necessary as per the descriptions in the source in RSOR.
• Designed and Developed a DSO from scratch to load (Delta) for the info types 08: Basic pay, 14 recurring payments and 15 additional payments the data source used in ECC side for dis load is ‘0HR PY 01’ Pay roll.
• Designed and Developed a DSO from scratch to load (Full) for the info types 0000Actionsor 0302Additional Actions the data source used in ECC side for dis load is ‘0HR PA 01’ Personnel Actions.
• Designed and Developed a DSO from scratch to load (Full) for the info types Absences (2001) Attendances (2002) Employee Remuneration Information (2010) the data source used in ECC side for dis load is ‘0HR PT 2’ Actual and Labor Times.
• Extracted the data for the info types 0022, 0027 and 0105 etc... from the corresponding flat tables into SAP BI using generic extraction.
• Created Real time cubes for HR- Head count and Sales revenue information for planning purpose.
• Involved in creation of aggregation level, Filters, Planning functions (like Copy, Revaluation, Distribution, delete, distribution), planning sequences in Planning Modeler (RSPLAN).
• Created planning templates in query designer by enabling the necessary options for the specific key figures.
• Embedded the planning related process types for loading planning not allowed, Planning Loading not allowed.
• Created the V type reporting on for comparing the actual Vs planned data whether they desired team reached the targets as per the plans dat are build.
• Loaded the test data and involved in UAT, SIT and BAT for testing the quality of data in DEV, QA and PROD.
• Written Start routine, End routine to filter the data records and to look up the data from source table and field routine for simple business logics i.e. for merging CRM data with GTM in the data flow.
• Involved in Writing the customer/User Exit codes in the FM EXIT SAPLRRSO 001 fortime characteristics.
• Reports have been designed like Wage type, action type and time overview reports in Query designer using variables, restrictions, Exceptions, Exception Aggregations, Conditions, RKF and CKFs.
• Performance tuning has been done in the BI System using Aggregates, Compression, Pre calculated Web templates, partitioning in Cube and DSO and fine tuned the ABAP codes.
• Developed complex Web Intelligence reports usingcombined queries, merging dimensions, complex functionsat the report level andcomplex filtersto satisfy the end user requirement.
• Created parameterized Crystal Reports and customize existing reports for presentations using Cross-Tab reports sub-reports, Running Totals, used Crystal syntax to create formulas for the reports.
• Developed Crystal Reports and formatted the same with respect to the requirements. Added parameters, special fields, formulae and used multiple data sources to create the reports.
• Created Reports using Crystal reports using the functionalities like format editor, highlight expert, chart expert, Cross tab expert, percentages, formulas, Grouping, Parameters to handle the end user requests from Tables.
• Involved in Performance tuning of the crystal reports using various standard procedures.
• Moved the developed Web Intelligence and Universes between development, QA and production environments with the help of BO Admin usingPromotion Management.
• Was involved in training the end users over the newly developed crystal and Web Intelligence reports.

Senior BW/BOBJ Consultant.

Confidentia, Chicago, U.S.A.

Environment: SAP BI 7.0, ECC 6.0, SAP BO XI 3.1(WEBI and Xcelcius dashboards).

Responsibilities:

• Gathering the requirements and coordinating with the team members for SD, Inventory, Purchase, HR like Sales order Header, Sales order item, Sales order schedule, Deliver Oder header, Delivery Order Item, Delivery Scheduler, Billing Header, Billing Item, Billing Scheduler, initial stock, Historical Movements, Payroll, Personnel Actions, Organizational Management.
• GAP Analysis has been done with functional team and discussed with them if there are any issues.
• Had created the RDD as per the requirement and created Technical specs.
• Identified the data source are 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 VASCL, 2LIS 12 VCHDR, 2LIS 122 VCITM, 2LIS 12 VCSCL, 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VDSCL, 2LIS 03 BX, 2LIS 03 BF, 0MATERIAL ATTR, 0CUSTOMER ATTR, 0VENDOR ATTR, 0HR PY 01, 0HR PA 01, 0HR PA OS 01.
• Designed the info cubes, multi providers, DSOs, transformations, rule groups according to the specifications in technical specs.
• Object migration has been done from BW3.5 to BI 7.0.
• Had done data source enhancements as per the client requirements for the SD data sources and master data sources like Sales order header and material master.
• Open Hub Destinations has been created to move the data for SAP to Non SAP targets.
• Data has been extracted from ECC and flat files using LO extraction and flat file extraction.
• Designed the BEX reports for the data reconciliation with SAP BO.
• Had done transportation with the help of REV-TRAC form DEV to QA.
• Unit testing had been done in Dev, S.I.T in QA and User acceptance testing in Production.
• Performance testing developed in all the application servers
• Backup plan for execution created for the client development and production system.
• Created cut over plan and Involved in Cut over in clearing the Queues using Process chains.
• Scheduled the reports to users using Info View periodically.
• Designed Universes for Inventory and Sales for the reports like sales analysis by Confidential, Sales Analysis by country reports.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used the formatting functionalities like dynamic filters, report filters, block filters, hierarchies, LOVs, Cascading of LOVs, alerter, formulas, variables, drill methodology in hierarchies, Hyperlinks.
• System design and data model developed in SAP BO XI 3.1 for Actual and Plan data model developed for reporting in SAP BI and SAP BO reporting
• Provided the UAT and End User documentation to the end users.
• Performance tuning is done on Web-I reports dat developed using Info View and WEB I.
• Extensively worked on SAP QAAWS for mapping data directly from Universe to Xcelcius dash boards.
• Created dash boards for Crop variance and Market share reports.
• Worked on system and user generated tickets and resolved them according to S.L.A’s.
• Monitor the data loads by means of process chains for Sales order, Deliver and Billing, Inventory, Payroll, Organizational Management and Personnel Actions.
• Involved in reconciliation to data to no whether we are getting the necessary record count as per the source or not.
• Performance tuning had been done to increase the query performance using Aggregates, compression, line item dimensions and indexes.
• Maintained work history for all the tickets for future resources.

SAP BW/BOBJ consultant.

Confidential: New York.

Environment: SAP BW 3.5 BI 7.0, ECC, R3 and BOBJ.

Responsibilities:

• Worked on system and user generated tickets of service type Change requests (CR), Bug Fix, Bug fix extended, Data Loading, PMRs and resolved them according to S.L.A’s.
• Monitor the data loads by means of process chains for daily sales, open orders, back orders, inquiry, quotations, sales order, delivery, billing, inventory, financial related Data, Payroll, Personnel Actions, Organizational Management.
• Involved in reconciliation to data in different functional areas like SD, MM, FI, CO, HCM/HR.
• Used to trigger manual loads as a part of daily and month end activity.
• Maintained Work history for each and every defect until it is closed down.
• Used to reconcile the row count from ECC to BI after the data load monitoring.
• Performance tuning had been done to increase the query performance by taking the Stats in to Consideration.
• Fine tuned the ABAP Codes to increase the loading performance.
• Had involved in assigning the defects to the respective group or person.
• Captured objects and releasing objects in the specific order during cutover.
• Providing Missing authorizations to the users.
• Tracking Requests and correcting them if there are any issues, when the Go live is on.
• Flushing out the queues and the row count during the transportation.
• Creating and Unlocking users in SAP system.
• Locking the T-codes in the Production system during INIT operation.

SAP BW/BOBJ consultant.

Confidential, Cincinnati, OHIO.

Environment: SAP BW 3.5 and 7.0, R3, ECC, SAP BO (WEBI), Wrapper Tool and TP Tool.

Responsibilities:

• Had involved in CREATING DESIGN DOCUMENTS for the structures related to MFGPRO, Four Shift.
• With the help of the Wrapper tool I Had automated the creation of ‘z’ info objects.
• Involved in creating and maintaining info cubes, operational data store, transfer structures and communication structures, transfer rules, update rules, routines.
• Uploaded the files into UNIX using SSH. And loading the data from application server to BW.
• Extensively worked on B.E.X analyzer, created reports using variables, restrictions, filters, calculated and restricted key figures, exceptions and conditions for the queries.
• TRANSPORTING the objects from DEV to Quality using TP TOOL. And raising an SD ticket to move the objects to production.
• Maintained BW Statistics to calculate the query response time and created Aggregates, info cube partitioning, indexing and Compression.
• Involved with performance tuning of queries by maintaining BI Index, Rollup and partition of Info Cubes and actively involved in maintenance of OLAP CACHE for specific queries in the T code RSRT.
• Used the concept of RRI and linked all the reports dat are there in the project.
• Performing Unit testing in development (U.A.T), system integration testing (S.I.T) in quality and business acceptance testing (B.A.T) in production.
• Giving support to users while B.A.T is going on.
• Extracted data using FI and CO-PA, Purchasing, Inventory, and data sources from ECC.
• Created structures like Info areas, Info object catalogs, Info objects, Cubes, DSOs, Multi providers, Info sets.
• Business content installation has been done for installing sap delivered objects.
• Worked on new data flow capabilities like DTP (Data Transfer Process), RDA (Real Time Data Acquisition) and enhanced & graphical transformation capabilities.
• Extensively worked on Extraction of Data using open Hub (Info Spokes)
• Tested the new features if BI 7.0 which includes new data flow, re-modeling, Real time Data Acquisition, enhanced features of Process Chains.
• Query and Load performance has been done in BW using BW Statistics, Aggregates, compression, rollup, Partitioning, Pre calculated web templates, Fine tuning the coding, load balancing etc..
• Testing has been done by taking the scenarios existing in the current BW 3.5 implementation and creating the same in BI 7.0
• Monitor, Support & Troubleshooting of Existing Data loads by using Process Chains
• Resolving the SAP tickets according to priority based created in the HPSM.
• Fulfilled the business objects development needs for various departments and also performed the day to day developer tasks.
• Created Universes using UDT for FI CO and MM related cubes and established the appropriate connections.
• Extensively worked on creating universe on Oracle database and establishing the connections from the database to BO.
• Created different kinds of joins manually, detecting the cardinalities and Loops.
• Resolved the loops using the techniques Short cut join Aliases and Contexts.
• Created custom hierarchies and used drill methodology, filters at different levels, derived tables, performed dynamic linking of reports using the hyper link.
• Performance tuning has been done for WEBI reports.
• Participating in the Status Meeting with the client and onshore.