SUMMARY

• 12 years of SAP experience SAP BW/BI, HANA, BO and ABAP/4 with various Modules like DFPS, HR, MM, SD, FICO, PM, PP, CRM, SRM, LO - Cockpit, FI-SL and Generic Extractors with the SAP practice of Big 4 consulting company.
• Over 8 years of SAP & QA experience with knowledge in development, manual and automated testing used tools like HP-QC, ALM/QTP, TAO & Solution Manager.
• Over 2 years of develop and delivered SAP HANA, S/4 HANA, SucessFactors, Ariba, Hybris, SFDC, Mobility, Cloud applications and Analytics through a client tailored assessment and deployment framework.
• Expert in ASAP, SDLC, Object Oriented Analysis, Design, Agile Methodology .Gathering business process procedures (BPP) documentation, preparing Test Plan, Test cases and Scripts.
• Experience includes 4 end-to-end full life cycle implementations, extracting data from SAP and non-SAP systems with SAP-BW while designing ETL, data-model and reporting layer.
• Comprehensive functional knowledge in HCM, SD, MM,PM,FICO,DFPS and general business process of SAP ECC
• Extensively worked with Basic Infocubes, DSOs, Multi Providers, Infosets, Data validation and error- handling, Start routines, update rules, transfer rules, APD and Open hub.
• Expertise in Business Explorer Suite - BEx Query Designer, BEx Analyzer and BEx Web Analyzer.
• Revamped dozens of data models for better performance, accuracy and compliance to Federal standards.
• Expertise in BOBJ 4. 0 WEBI, Crystal, Dash boards, Analysis for OLAP, explorer, Design Studio, Fiori, Lumira, and information space in creating reports for FI, CO, DFPS.MM, HCM and CO modules.
• Experience in Data Modeling, Data Provisioning including Attribute Views, Analytical Views, Calculation Views, SQL Scripting, CE Functions and Analytical Privileges
• Reporting, Security and Authorization aspects of SAP HANA ETLs Techniques (BODS, SLT) HANA Modeling
• Strong Experience in Enhanced the Extract structures using User Exits, BADI based on the user requirement as needed.
• Created Universes on top of HANA Analytical, calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• Developed Test Cases, Test plans, Test Scenarios as per company Methodology.
• Worked in workbench tools like SQL Trace, Runtime Analysis and ABAP Query.

TECHNICAL SKILLS

• SAP BW 7.3
• SAP BI 7.0
• SAP HANA 1.0
• SAP Business Objects 4.0 4.1
• (Dash Board(Xcelsius) Crystal Reports
• Web Intelligence 4.0
• SAP Design Studio 4.1
• SAP Lumira 4.1
• Analysis Office
• SAP GRC10
• BWA
• SAP ECC 6.0
• APO
• SAP CRM
• SAP SRM
• SAP BPC
• SAP BODS
• SAP BPS
• Business Explorer (BEx)
• PL/SQL
• Oracle
• IBM DB2
• XML
• UNIX
• Linux
• ABAP4
• IDOC
• BAPI
• ALE
• User exits
• Vistex
• SF
• SFDC
• Windows XP/NT/2000/98/07
• HP ALM
• QTP
• Test director
• Selenium
• LoadRunner12
• JMeter
• JIRA
• Solution Manager
• Cognos
• Adobe Flex
• WebDynpro
• Portal
• Data Integrator/Federator
• IBM Infosphere Datastage (Ascential)
• SAS
• InformaticaandAb Initio
• Project Management (PMI)
• SDLC and Six Sigma

PROFESSIONAL EXPERIENCE

Confidential, NJ

SAP BW/BO Consultant

Responsibilities:

• Created Technical specifications and standard modeling documents for SAP BW for the complexity of the process design is related to the functionality provided by the DFPS (Defense Forces Public Security) solution.
• Designed a process to facilitate supply ordering by non-government (contractor) entities outside the normal military supply channels process design is related to the functionalityprovided by the DFPS solution.
• Extensively worked on DFPS, MM, PM, OM, HR modules.
• Worked on customization and enhanced the extract structure to support business needs.
• Designed and developed various Data targets and Infoproviders like DSO (ODS), Infocubes, Infoobjects, Multiproviders and Infosets using Admn workbench (RSA1).
• Developed Transfer Rules and Update rules to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements
• Developed process chains to schedule the info packages and data transfer processes.
• Developed new DSO’s on standard Extractors like 0DF IS DFS 18 Force Element, 0DF IS DFS 56 Functional Locations, 0DF IS DFS 24 Force Element (Hierarchies, 2LIS 17 I0NOTIF Reservation Orders, 2LIS 17 I0CAUSE Notifications and 2LIS 17 I0ACTY Notifications Activities.
• Developed WEBI and Dash boards for Army KPI’s.
• Created Unit Test Plans and complete Testing of Developed Objects and Reports
• Worked closely with the client in all phases to design, build, and test and deploy SAP BW solutions.

Confidential

SAP BW/HANA/ BO Architect

Responsibilities:

• Developed DSO’s on standard Extractors like 0HR PA PD 2 for Appraisals, 0HR PA 1Persalnnel Actions, 2LIS 17 I0NOTIF for Reservation Orders, 2LIS 17 I0CAUSE Notifications and Notifications Activities 2LIS 17 I0ACTY.
• As SAP HANA BW Architect Gathered Business Requirements and Conducted Gap Analysis to Implement BW on HANA .
• Designed &Developed Technical specifications for Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA BODS, SLT and SAP BI/BW .
• Created HANA Package and Schemas.
• Created HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers.
• Performed datamodeling and developed Analytical views for the transactional data, Attribute views for the master data in HANA Studio.
• Designed HANA, BO security role/Users for each module with thorough discussion with business process owners.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Created Universes on top ofHANA Analytical views and developed the Webi reports and dashboards usingIDT(Information design tool).
• Worked on various Business Objects Applications (IDT, Design Studio, Webi, Crystal Reports and Dashboards).
• Gathered User requirements Analyzed reporting requirements and created Web Intelligence reports.
• Helped to integrate Reporting Solutions to SAP BusinessObjects 4.1 using various OLAP connections (BICS).
• Worked closely with the client in all phases to design, build, test and deploy SAP BI 4.0 solutions.
• Involved in Unit and QA testing and Created Test Plans, Test Cases and complete Testing of Developed Objects and Reports

Confidential, Philadelphia, PA

SAP BW Consultant

Responsibilities:

• As BI/BW developer as well as the BI architect role for the complete client Confidential 's BW system which includes gathering requirements, analysis, data modeling, design specification, development, data extraction, reporting,
• Redesigning the existing models as wells as the Reporting structures, Unit testing, trouble-shooting, integration and user acceptance testing, documentation, training and maintenance.
• Involved in preparing Business Requirement Documents and checked Business Content to identify necessary Business Objects.
• Designed, developed and implemented new BI model using features like Transformations, end-routines, DTP, Data acquisition etc
• Worked with various standard as well as custom BI/BW objects for FI, CO, SD, PM, CRM and MM of ECC.
• Worked on customization and enhanced the extract structure to support business needs
• Designed and developed various Datatargets and Infoproviders like DSO (ODS), Infocubes, Infoobjects, Multiproviders and Infosets using Admn workbench (EDW, RSA1)
• Developed Transfer Rules and Update rules to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements
• Developed process chains to schedule the info packages and data transfer processes.
• Performed different activities for the upgrade from BW 7.0 to BW 7.3
• Designed and developed new BW model using 7.3 features like Transformations, end-routines, DTP, Data acquisition etc.
• Gathered Business Requirements and Conducted Gap Analysis to Implement HANA.
• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources
• Migrated ECC (MS SQL) Database into SAP HANA.
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files, ECC Data into SAP HANA tables.
• Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Developed Webi reports and dashboards for different operations and finance KPI’S.
• Created Universes on top ofHANA calculation viewsand developed the Webi reports and dashboards usingIDT(Information design tool).
• Created Unit Test Plans and complete Testing of Developed Objects and Reports

Confidential, Wilmington, DE

SAP BI Consultant

Responsibilities:

• Developed ODS, Cubes for FI, HR, SD, MM using the extractors and External Systems.
• Create system designs and develop technical specifications to document these system designs.
• Developed Z Info Objects and Z Info cubes in SD,HR, PP and MM modules
• Development of data model to satisfy the various functional requirements by implementing queries and cubes using business content.
• Involved in multi-dimensional data modeling, developing InfoObjects, InfoCubes, Aggregates, ODS objects, PSA, DataSource (OLTP Source), InfoSource, Communications Structure, Transfer Structure, MultiProviders, InfoSets, and customizing standard Business Content.
• Extraction (ETL) of master data and transaction data from R/3 Data Sources.
• Participated in data transfer from multiple SAP and non-SAP Source Systems through Direct Update and Flexible Updating. .
• Created various interfaces from BW to various non-SAP systems using APD and OPEN HUB.
• Automated BPC Master and Fact data loads from BW to BPC
• Configured Reporting Agent, roles, Web reports, exceptions, variables, cells in formula, formatted reporting in Query Designer & executed queries in BEx Analyzer..
• Created Unit Test Plans and complete Testing of Developed Objects.
• Configured the Integration of SAP BI with Business Objects, Crystal Reports and Xcelsius using SAP integration kit
• Configured the Business Objects BW Publisher to publish Crystal Reports from SAP BI to BOE server
• Involved in importing SAP roles into Business Objects Enterprise, for allowing role members to log onto Business Objects Enterprise with their usual SAP credentials
• Extensively worked on writing test scripts and also on the Unit and Integration testing of the reports.

Confidential, Chicago, IL

SAP BW Lead Consultant

Responsibilities:

• Lead a team of technical/functional consultants for implementing the SAP BW solution and migration.
• Gathered requirements from functional users in HR and FI for functional analysis.
• Defined work packages and technical specifications for design, development, testing and roll-out.
• Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content. The main cubes developed are Employee (0HR PA 0), Personnel Action (0HR PA 1), Staffing (0HR PA OS 1), Actual Personnel Time (0HR PT 2) and Time from Personal work Schedule (0HR PT 1).
• Worked with functional consultant for mapping the source data (R3/non R3 ) to target
• Data Sources in BI. Defined the initial sizing requirements based on source data volume estimates.
• The team configured Custom cubes, Transfer rules, Transfer Structures, Update Rules, ODS, Cubes, Aggregates, queries and workbooks.
• Worked with the users for defining the reporting needs and helped design/develop flexible queries and pre-calculated reports using BEX reporting features like variables, exception and conditions in Sales and Purchasing areas.
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing. Tuned queries using Partitioning, Aggregates and Multiproviders.
• Extensively tested the developed objects using Test Director. Participated in change control team for defect prevention/correction and approving changed/additional requirements. Defined phases for requirements that were not critical for initial go-live.
• Developed prototype and presented the demo session for user acceptance.
• Trained users in reporting functions.

Confidential, Portland, OR

SAP BW Consultant

Responsibilities:

• Lead a team of technical/functional consultants for implementing the SAP BI solution and migration.
• Coordinated work and personnel at various locations onshore as well as offshore
• Gathering User Requirements (Legacy& SAP R3 Reports) by holding interview workshops with the users and Functional Consultants
• Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content.
• The main cubes developed are Customer (0SD C01), Sales Overview (0SD C03), Delivery Service (0SD C04), Purchasing Data (0PUR C01) and Vendor Evaluation (0PUR C02).Maintained Data Sources such as Billing (2LIS 13 VDHDR), Sales Order(2LIS 11 VAHDR), and Delivery Order (2LIS 12 VCHDR) for the SD Module and Purchasing Order Item (2LIS 02 ITM) for MM. (2LIS 17 I3OPER)Plant Maintenance Order Process (2LIS 17 I3HDR)Plant maintenance orders for PM.
• Used process chains to schedule the info packages and data transfer processes.
• Worked with users for defining reporting needs and pre-calculated reports.
• Created charts in WAD for Analysis

Confidential, MD

SAP BW Consultant

Responsibilities:

• Gathered Business Requirements and Conducted Gap Analysis to install Business Content.
• Designed &Developed custom DataSource, InfoSource, Extractor,InfoCube and ODS to fulfill user requirements.
• Developed Transfer rules, Update rules and Start routines using ABAP to in corporate Business logic and perform data manipulation.
• Enhanced master data sources 0Customer, 0Material and 0Vendor to meet custom reporting requirements.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Developed data loading strategies for master data, transactional data and delta uploads.
• Created process chains for data loading, delta uploading and periodical PSA deletion.
• Extracted and loaded data from SAP R/3 into Sales Order InfoCube using DataSources.
• Created Multiprovider on sales and delivery cubes to assist reporting on sales and delivery together.
• Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively.
• Extensively worked on Query Designer and Web application designer to create Queries to forecast sales, budget and delivery analysis using Restricted Key Figures, Calculated Key Figures, Variables, Filters and exceptions.
• Used reporting agent to create batch jobs for Report printing and Exception reporting.
• Involved in documentation and end-user training.

Confidential, Salt Lake City, UT

SAP FICO/HR Consultant

Responsibilities:

• Configured basic components for payroll like configuring payroll calendar, Payroll periods and generated payroll calendar.
• Created primary and secondary wage types required for payroll.
• Define /Determine/Maintain basic settings for PA module.
• Extensively worked on Basic Pay and Wage Type configuration changes.
• Worked on customization of info types and info type screens.
• Worked on issues related to Posting to accounting.
• Configured symbolic accounts mapped symbolic accounts to g/l accounts as well as mapped wage types to symbolic accounts.
• Worked on processing classes, cumulations, Evaluation Classes for different wage types.
• Worked on valuation of base wage types.
• Worked on Garnishments (info types 194 and 195).
• Created Info Sets and created adhoc queries for reporting purposes.
• Customized Personnel Administration Info sets by adding Info types to Info sets.
• Defined deduction frequencies, payment models, pay periods, limits on deductions and deduction base wage types.
• Maintained tax related processing classes, tax-related schemas and rules, checking tax authorities and tax types, Maintained Tax areas and defined tax models.

Confidential, Memphis, TN

SAP FICO/HR Consultant

Responsibilities:

• Worked extensively on payroll configuration and customization.
• Configured basic components for payroll like configuring payroll calendar, Payroll periods and generated payroll calendar.
• Extensively worked on Basic Pay and Wage Type configuration changes.
• Created wage types for basic pay, additional payments, and recurring payments.
• Configured wage type characteristics.
• Worked on customization of info types and info type screens.
• Configured HR GL system for several new acquisitions by creating symbolic accounts mapped symbolic accounts to g/l accounts as well as mapped wage types to symbolic accounts
• Worked on issues related to Posting to accounting.
• Customized the account assignment for cost center at department level.