SUMMARY

• Over 12 years’ experience in SAP BW/BI, BO, ECC, APO, SCM, CRM, SQL and HANA. Expert in estimation, design, development, testing, troubleshooting, deployment, upgrades, migrations, documentation, user training and on - time project delivery. Match compliance of enterprise applications for multiple industries across different business units.
• Proactive, works closely with business users and project team members during requirement gathering, blue print, realization, implementation and user training.
• Experienced in full cycle project planning and implementation.
• Extensive knowledge in data warehouse technologies which includes modeling, data extraction and reporting.
• Extensive Experience in Design and Development of MultiProviders, Infocubes, InfoObjects, Data Store Objects ( DSO ), ODS Objects, Infosets, DTPs, InfoPackages, InfoSources, Datasources, Transformations, Transfer Rules, Update Rules with consistent and efficient Multi-Dimensional Data Modeling techniques.
• Wrote complex ABAP programs for custom Extractors, Routines, Loading, User Exits and Advance Calculations
• Involved with lot of break fix, new requests, enhancements, production support and performance optimization tasks.
• Experience in Use of Aggregates to Improve Performance, Logical Partitioning, InfoCube Compression, Indexes, Process Chains, InfoCube analysis using RSRV.
• Knowledge of different delta mechanism such as V3 updates delta queue, direct delta, queued delta etc.
• Experience with Open Hub Services (InfoSpoke).
• Experienced with Creation of BEx Queries, use of formulas, calculated key figures, restricted key figures, structures, exception and conditions. Also have the experience of report-to-report interface (RRI).
• Experienced with creating Roles, Profiles, and Authorization Objects for BW Security.
• Proficiency in Business Objects Enterprise (BOE) architecture and data services/federator with Reporting Strategy and design options utilizing the Front End BOBJ tools. Experience with SAP BI integration with Crystal Reports, Xcelsius Dashboards, DeskI, WebI, Live Office, InfoView, Analysis, Explorer, Query as a Web Service and BODS for non-SAP data sources.
• Familiar with HANA Studio including setup direct extractor connection (DXC), replication using data services, monitor loads and creation of analytical/attribute/calculation views using SQL scripts.

TECHNICAL SKILLS

SAP Packages: SAPR3 4.6C/4.7, ECC 5.0/6.0, mySAP Business Suite, BW 3.5 and BI 7.x (NW 2004s)

SAP Modules: FI(AR,AP,GL) CO, SD (OTC, MTC) MM, PP, PS, HR, BI-BW, BPC, APO,SCM and CRM

Reporting Tools: BEx Analyzer/Query Designer, WAD, APD

Business Object: BOE XIR3.x,Universes,Xcelsius,Dashboard,WebI,DeskI,InfoView and Crystal Reports

Web Technologies: HTML, XML, CSS, JavaScript, SharePoint and multiple web servers

Languages: ABAP, Java, VBA and SQL

RDBMS: Access, SQL Server, MySql, DB2, Oracle, Sybase and HANA

Other Tools: MS Project/Office, Visio, Remedy, Tidal and Quality Center

SAP Enhancements: User Exits, BADI

SAP Interfaces: ALE/EDI/IDOC/BAPI/BDC

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

SAP BW/ABAP Consultant

ENVIRONMENT: SAP BI 7.1/7.3, SAP R/3 ECC 6.0, BPC

RESPONSIBILITIES:

• Worked closely with the business to understand the BRD and created functional specs, technical design document and Query design template.
• Worked on the FI G/L, AR, AP, SL extractors and data sources for extracting G/L, AR and AP line item details and summary data into SAP BI.
• Worked extensively in ABAP and BW for Implementing New General Ledger implementation. Enhanced 0FI GL 14 data source for 3 regions (AMS, APJ, EMEA) and modified existing reports according for the parallel ledgers(0L, Z1 & Z2).
• Worked extensively in ABAP for Enhancing the SAP function modules to support the minute based extraction for the ZFI* data sources. (BWFIT RESET TIMESTAMPS, BWFIT UPDATE TIMESTAMPS, BWFIT GET TIMESTAMPS) in Velocity R/3 system
• Enhanced the AR, AP Extractor and written the code in the user exit to get the additional data into the extract structure
• Created the BEx user exit (CMOD) variables to support the analysis across the different time dimensions and periods using the complex ABAP code.
• Designed the info cubes to support and meet the business requirements for the FI reports.
• Created BEx and Webi reports to support the fixed format and ad-hoc analysis.
• Utilized TVARVC variants and ABAP coding in start routine and routines to make the data model flexible to in corporate anticipated changes in the future.
• Extensively used Transport Connection to Transport objects from Development to Testing and Production.
• Worked on the currency translation for the Russia Reports and written the code in User Exits for the RRI report
• Extensively worked on Process Chains.
• Using BEx created and published report to BI7 portal for Treasury and Finance teams.
• Created Reports RRI functionality incorporating Formula Variables, Calculated Key Figures, Restricted Key Figures in structures, and authorization variables. Published the reports to security roles and portal by creation of iViews.
• Created ABAP SE38 programs to create flat files for loading the BPC dimensions.( Functional Area, Organization, MRU and SUB MRU)

Confidential, Cupertino

SAP BW Consultant

ENVIRONMENT: SAP BI 7.0/BW 3.5, SAP R/3 ECC 6.0, 4.6C, BOBJ, WEBI, COPA, BExgui 710, Oracle 10g and Windows Vista/XP

RESPONSIBILITIES:

• Worked closely with the business to understand the BRD and create SLAs, SIAs, functional specs, technical design document and Query design template.
• Designed the FI revenue recognition data model to handle contracts and monthly revenue recognition for iphone, Macs, mobileMe and Confidential care and iPad.
• Created datasource, transformations, DTPs, DSOs/ODSs, Cubes, Multiproviders, Infoobjects and automated data loading using process chains.
• Using ABAP coded in routines business logic to derive currency conversion from Group/Group currency(GC) to Transactional/Billing currency(BC), GC to Functional/Local currency(LC) and vice versa depending on Fiscal Period or Billing period as required. Applied logic to handle currencies without decimals.
• Created currency translation type based on the billing period which was used for currency conversion in the report.
• Utilized TVARVC variants and ABAP coding in start routine and routines to make the data model flexible to in corporate anticipated changes in the future.
• Designed Business objects semantic layers (Universes) and multiple WEBI reports on SAP BW data. Created dashboards and multiple charts with QaaWS connectivity on BEx queries to refresh Xcelsius for current data.
• Involved with SAP BW up-gradation from 7.0 to 7.3 including BI objects, batch jobs, integration testing and go live

Confidential, Newark, NJ.

SAP BW Consultant

ENVIRONMENT: SAP BI 7.0, BW 3.1, SAP ECC 6.0, SEM 3.0

RESPONSIBILITIES:

• Creating test cases for testing Infoobjects, ODS, Cubes, Queries in mercury Quality Center( Test Director ) for BW upgrade to 7.0
• Fixing the issues with Process chain, Infoobjects, Queries
• Production Support
• Monitoring the data Loads ( daily, Weekly, Monthly Loads )
• Worked with SM12 ( lock objects ), SM37( Job overview ), SM50 ( work overview )
• Enhancement of structures and User Exits for Transactional datasources and master datasources.
• Process Chain ( RSR, CPI, Foundation Loads )
• Worked with SAP change control and transport system, managing transports, analyzing failed transports
• Created BEx Queries, Workbooks using Query Designer which involves Restricted key figures, calculated key figures, Structure, cell definition, Variables (Customer Exit ) in reporting.
• Worked on SEM BPS ( created Planning Area, Planning Level, Planning Package, Planning Function, Parameter Group, FOX Formula, Layout, Web Interface )

Confidential, Houston, TX

SAP BW Consultant

ENVIRONMENT: SAP BW 3.5, SAP R/3 4.7

RESPONSIBILITIES:

• Interacting with the users for requirement gathering and created functional specs.
• Data Extraction from R/3 thru LO Extraction, COPA extraction, Generic Extraction, data loading from flat files, Master data Sources ( Attributes, Text )
• Enhancement of structures and User Exits for Transactional datasources and master datasources.
• Created Generic datasources by extracting data through Function Modules.
• Extensively involved in Activating Business Content .
• Created and Maintained Transfer Structures, Transfer Rules, Update Rules, ODS and InfoCubes
• Worked with Update Routines, Start Routine.
• Created Roles, Profiles, Authorization Objects and implementing infoobject level security.
• Data Loading ( Init, Delta, Full )
• Worked with SM12 ( lock objects ), SM37( Job overview ), SM50 ( work overview )
• Created reports using BEX Query Designer which involves Restricted key figures, calculated key figures, Structure, cell definition, Variables (Customer Exit ) in reporting.
• Worked on RRI jump target queries
• Worked on Web Templates
• Prepare concept & specification for proactive production support, solve any project related technical issues
• Part of the Production Support team and solved post production issues.
• Monitoring the data Loads ( daily, Weekly, Monthly Loads )
• Performance Tuning using Performance improvement techniques(Such as Partitioning, Compression, Secondary Index etc)

Confidential

SAP BW Consultant

ENVIRONMENT: SAP BW 3.5, SAP R/3 4.7

RESPONSIBILITIES:

• Created Functional specifications based on User requirements.
• Designed and Created Info Cube, ODS, Multi Provider and Master Data Info Objects.
• Modeling, Reporting with BEx and Web Application Reporting.
• Worked on Update Rules, Start Routine, Transfer Rules, and Transfer Routines.
• Worked on Data Source Enhancement and Worked on Master Data Extraction.
• Extracted Data using LO, FI-SL, CRM, HR, FI-AP, FI-AR, CO-PA, SAP Cross Applications with Generic data extraction And Non SAP Source Systems like ORACLE, DB2 and other Files on Application server. Worked on ETL.
• Worked with HR datasources( Payroll, Personnel Administration, Personnel Time management, Benefits ) and HR Reports
• Worked on Info Packages and Process Chain setup.
• Prepared current and proposed Reporting layouts with BEx and WAD.
• Worked on BEx Calculating Key figures and Restricting Key Figures.
• Worked on Crystal Reports.
• Worked on Aggregations, Partition and Statistics of Info Cube.
• Worked on Sales Invoice, Billing, Inventory, Purchasing, Plan/Actual Revenue, Payroll, Personal Management and Time Management, Planning Reports.

Confidential

ABAP Consultant

ENVIRONMENT: SAP R/3 4.5B

RESPONSIBILITIES:

• Worked on ABAP FRICE Objects
• Worked on BADI, User Exits, ALV, Dialog Programming, BDC