SUMMARY:

• Over 12 years of experience in designing, development, and implementation of Information Technology Systems in SAP BW/BI and R/3 it includes 5 Implementations and development.
• Hands on experience in leading all stages of system development efforts, including requirements definition, design, architecture, testing and project based efforts while managing, motivating, and guiding team.
• Led 5 SAP Applications and worked on 5 Implementation projects, for CRM, FICO, SCM, APO, MM, SD and SCEM. Functional and technical expert CRM and FI/CO.
• Led/Architect multiple BW/BO project works and developed technical design specifications for Development.
• Worked with Business Stakeholders, IT Infrastructure teams, and Development Teams to ensure that business requirements were properly configured within SAP and that all Development objects perform as designed.
• Strong team leadership skills including team player and ability to deliver large scale/complex Projects.
• Planned and coordinated/managed Go Live Projects (Data Migration and Pre - Migration Tasks) using Microsoft Project.
• Followed SAP ASAP implementation methodology and strong systems development life cycle
• Experiences, from project analysis, requirements gathering, process design, wrote blue print phase
• Documentation, completed configuration during realization phase, prototype, and data loads, cut-over
• Plan, Unit testing, integration testing, user acceptance testing (UAT), power user training, and production/Go- Live supports.
• Resolved the Problems, Incidents, Change and Request Management issues using Peregrine Service
• Center and complied ITIL (IT Infrastructure Library) Service Management.
• Data Modeling, ETL, Loading, extractor, Function Module extractor and created Customs tables.
• Hands-on Experience in the design and development of Info Cubes, Virtual Cubes, MultiProviders, ODS Objects, Hierarchies, Info Objects, PSA and ODS, writing Update routines, Transfer routines. Data Sources, CMOD, BADI, Accelerator.
• Transfer of Business Content to active version with all its dependent objects like Queries, workbooks, updated rules, Info Sources, Transfer Rules etc.
• Using a lot of transactions such as ST03, RSRT and RSRV, checked and tuned system performance
• Extracted from SAP R/3 FICO/PS/HR/SD/MM/ IN/APO/POS/SCEM/XRPM/CRM) using extract structures such as General Legher (FIGL, CO, PS, LO-Cockpit, Generic Extractors).
• Experience in enhancing data source as per user requirements using User Exits.
• Worked extensively with BEx Query Designer, BEx Analyzer and Web Application designer.
• Worked in ETL to move and transform data from several businesses into corporate Oracle data warehouse. Data sources included Oracle, flat files, and SAP BW. Strong expertise in Data Modeling, Data Cleansing, Data Governance and Data Quality Using BW ETL techniques.
• Expert in identifying the ways the end users want to analyze data and design data access solutions (BW reports) to satisfy the business requirements.
• Performed performance tuning both back-end and front-end sides.
• Involved in the design and development of Info Cubes. Responsibilities include development of new Info Cubes & Enhancements to the existing functionality as per the user requirements.
• Extensively used process chains to automate the process of loading data into data targets.
• Training end users in query development-using BEx.

SAP HANA EXPERTISE:

• SAP HANA business requirements Proof of Concept (POC) architecture on SAP & non-SAP source systems including SAP BW on HANA, SAP BOBJ in large and complex environments.
• SAP ECC tables data modeling in CRM, Finance, and Controlling etc.
• SAP HANAprogramming including SQL, SQL Script and CEScript.
• Data provisioning landscaping methods such as SAP Landscape Transformation (SLT), SAP Data Services, or Direct Extractor Connection (DXC) for replication/ extraction of data from SAP/ non-SAP source systems.
• RDBMS modeling of Classic Star schema Infocubes (Transactional &Master data tables) into SAP HANA Optimized Info cubes; Modeling of SAP HANA objects such as: Attribute Views, Analytic Views & Calculation Views with various join conditions
• Complex Calculation Views using SQL Scripts and Procedures.

TECHNICAL SKILLS:

BW Versions: 3.0B, 3.1, 3.5 and BI 7.0, 7.3

SAP R3 Versions: 4.6C, 4.7 and SAP ERP (ECC 6.0)

ABAP/4: Data Dictionary, Routines, Function modules, AWB, User Exits (CMOD, SMOD), SAP Query, Info Sets, OLTP Reports, Classical and Interactive reports

BI: DSO,DTP, Transformation, BI Accelerator.

Modeling: Multi-dimensional Modeling (MDM), ERWIN, Oracle Designer, SAS.

Reporting: BEx Analyzer, BEx Query Designer, WAD, Visual Composer, Enterprise Portals integration, iView s, and Crystal reports, Xcelsius, SAP Portals, Business Objects WebiNet weaver 2004s/BI 7.0.

Database: Oracle 8i/9i, SQL Server 2000

Applications: Microsoft Office - Word, Excel (Macros), and PowerPoint.

Web Technologies: Java, HTML, Java Script. Knowledge SEM, SEM, CPM, MDM, HANA, HANA Studio

EXPERIENCE:

Confidential, Columbus, OH

SAP BI/BW/HANA Development Lead/Architect

Responsibilities:

• Involved in requirement phase of London project which includes migrating ledgers and Sub Ledger from ECC to SAP BW. In order to extract used Financial extractors 3FI SL XX SI (SPL Summary), 0EC PCA 3 (Profit Center Accounting), 0FI AP 4 (A/P) and logic for custom field to meet the needs.
• Designed and extracted expenses and Payment data from ECC and generated the reports in BO.
• Involved in HANA DB migration project and coordinated with Basis and SAP team.
• Carried out the house-keeping before moving the BW to BW on HANA
• Involved in maintenance project of improving the performance of Load.
• Working in BPC project for Line of business consolidation.
• Monitoring, investigation & optimization of data models and reporting performances on SAP HANA.
• Modeling of Classic Star schema Info cubes (Transactional &Master data tables) into SAP HANA Optimized Infocubes.
• Redesigned the process chains based on the new functionality, by adding the DTPs and by removing the create and delete indexes and aggregates in BW-on-HANA.
• Migrated and tested the master data object, transaction data and the routines from 3x to 7.3
• Worked on the testing strategy for pre upgrade, post upgrade and data validations. Tested the Dual Delta extraction process and validated the data BW-on-HANA.
• Worked extensively on various batch jobs, Data flows and configuration of data stores in Data Services.

Environment: BW 7.3, HANA1.0, BO 4.0, SAP ECC, SAP BPC, Project Management.

Confidential, Noblesville, IN

SAP BI/BODS/BO Lead Consultant

Responsibilities:

• Working as BI/BO Consultant on Financial transformation project which involved SAP and Non SAP financial data for Planning and Consolidation reporting.
• Coordinated BI Blue print reporting meeting with Financial Customer and Department and gather Current and Future requirements.
• Working as Lead Consultant and coordinated BI development work with Offshore.
• Identified the Financial extractors 3FI SL XX SI (SPL Summary), 0EC PCA 3(Profit Center Accounting), 0FI AR 4(A/R) and logic for custom field to meet the needs.
• Designed and documented data model design for COPA - Account and Cost based COPA, Special Ledger and Profit Center accounting / Costing Accounting and reported using Business Object Month end reporting.
• Using BW extractor and extracted the data via BODS and uploaded to Hyperion for financial reporting.
• Transported and Migrated extractors and BODS Jobs/Objects.

Environment: BI 7.2, BO 4.0, SAP ECC, Business Object Data Services 4.0, Migration, Project Management.

Confidential, Columbus, OH

SAP BI/BW/BO Lead Consultant

Responsibilities:

• Development activities include Blueprint, Workshop, Design and Backend and front end development.
• Interact with UC Executives, IT teams/ Development teams to ensure that Business requirements were properly setup and designed in order to satisfy the Customer requirement
• Marketing reporting development the following extractors are involved-0CRM SALES ORDER I, 0CRM OPPT H, 0CRM SALES ACT 1, CRM LEAD H, 0CRM QUOTA ORDER I.
• Used Service Base and Service Contract and Service Request. Extractor being used 0CRM SALES CONTR I, 0CRM SRV PROCESS I and 0CRM SRV REQ INCI H for Service request and Service Contract reporting.
• Developed a Dashboard Lead-to-quote (unlinked) it generates Lead, Quotes and Opportunities Sales and Billing number of activities by Sales organization. Extractor involved 2LIS 11 VAITM, 2LIS 11 VASTI, 2LIS 13 VDITM.
• Modeled multi providers, info providers, info cubes and DSOs on SAP HANA from ECC to BW 7.3.
• Created BO reports on top if BEX query through BICS connection.
• Implemented Lead to Quote Linked, Lead to quote unlinked and Service Dashboard using BEX query and BOBJ WEBI.
• Migrated/Promoted WEBI reports from DEV to Pre prod and Pre-prod to Production.

Environment: BW 7.3, BO 4.0, CRM 7.2, SAP ECC, HANA1.0, APD, Oracle, BWA Accelerator, Business Object Data services, Be queries, WEBI, Dashboard, BOBJ4.0, Migration.

Confidential, Lyndhurst, New jersey

SAP BI/BO Lead Consultant

Responsibilities:

• Coordinated BI Blue print reporting meeting with B&N Customer Services teams and Department and gather Current and Future requirements.
• Working as Lead Consultant and coordinated BI development work with Offshore.
• Workings in CRM Implementation on areas are. Interaction, Service request management, Complaints, Email responses Management, Survey management, Trade Promotional management, Territory management.
• Install business Content and Cubes are 0CRM SALES ACT 1, 0CRM SRQ INC H,0 CRM SRV PROCESS I,
• 0CRM COMPLAINTS 1, 0CRM ERMS ITEM, 0SVY DATA 1, 0CRM LINK SVY H and Created a Generic data source.
• Created BADI on Interaction record extractor (0CRM SALES ACT 1) to populate all Service Request connect to interaction and Follow up document.
• Created BADI on Generic Extractor to get ratio of MHC (Mishandled call) by Partner and how many Service request was Mishandled in a week.
• Created Generic Extractor to extract the unlimited text data from CRM STXH for each order Customer comments/issue were posted by Agent during on call with Customer.
• Designed and Developed data model design for Interaction, Service request, Mishandling call, ERMS, Survey and reported using Business Object using WEBI through Relational universes.
• Coordinated with Business Object Admin on SQL and BI relational connection to bring the long text against each transaction order.
• Experience in SAP HANA Data modeling using Attribute view, Analytical view, and calculation view.
• Modeling of SAP HANA objects such as: Attribute Views, Analytic Views & Calculation Views with various join conditions; creating Calculated Columns, Restricted Columns, Filters, Hierarchy, etc.
• Connected SAP HANA box with ECC system. Built custom tables in HANA and extracted master data and transaction data from ECC.
• Experience withSAP HANAprogramming including SQL, SQL Script, and CEScript.
• Reporting experience including handling complex scenarios using joins and SQL.
• Created various views as per the requirement. Built calculation views using scripts.
• Developed HANA Data modeling scenarios and activities such as adding a system, creating schemas, importing table definitions, adding connections setting preferences for the modeler
• Loaded data into table definitions, suspended and resumed data loads, copied contents delivered by SAP, created information objects (packages, attribute views, analytic views etc.)
• Gathered experience in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables, using system generating joins
• Experience withSAP HANAprogramming including SQL, SQL Script, and CEScript.
• Reporting experience including handling complex scenarios using joins and SQL.
• Designed ETL and extracted customer services data from using BO data services from CRM to SQL.
• Also used OLAP connection via BEX and build a WEBI report out of BEX query.

Environment: BI 7.3, BOBJ 4.0, CRM 7.0, APD, HANA 1.0, Business Object Data Services, Oracle, WEBI DASHBOARD, BO Migration.

Confidential, Cincinnati, Ohio

SAP BW FI/CO Lead Consultant

Responsibilities:

• Working as BI/BO Consultant in FICO Funds Management/General Ledger, Planning and Budgeting, Controlling- Cost Center allocation and Supporting BI application of PBF (Public Budget formulation) and HR (Personnel, TM and Payroll, Benefits) for Confidential employees.
• Working with UC Executives, IT teams/ Development teams to ensure that Business requirements were properly setup and designed in order to satisfy the Customer requirement.
• Developed reports on Funding, Spending and Planning for University departments.
• Worked in Special Legher reporting in generate the report in detail about the Cost and Actual for Various department in UC.
• Worked on FI/CO(Controlling)/Commitment items (0PU IS PS 31, 0PU IS PS 32, 0PU IS PS 33) to add new Fields via customer exit ZXRSAU01.
• Created an employee history Management reporting/Dashboard for UC
• Lead the BW enhancement pack to 702 upgrade and Support pack implementation on across all environments with data base DB2.
• Involved in performance of improving queries with Multiprovider design and reduce the runtime of queries.
• Designed and worked in Data services from Employee conversion project which are extracted from SQL into SAP.

Environment: BI 7 .2, SAP ECC6.0, APD, FICO/Funds Management, Grant Management, Controlling, /PBF,HR ABAP, Net weaver 2004s/BI 7.0,Query designer, BOBJ (Webi), Xcelsius, Live office, SAP Solution Manager, Dash board, SAP Portals (EP 6.0), Info Spoke, Accelerator BWA,SAP GUI, Infoset,UNIX, APD,Windows XP,DB2.

Confidential, St Louis, Missouri

SAP BW FI/CRM Lead Consultant

Responsibilities:

• Working as a BI CRM Consultant/Lead in CRM Activities /Service Management/Marketing planning to support the Confidential customer/Dealer/Agent in order to do forecast and planning for upcoming events.
• Architect BW Implementation project works and developed technical design specifications for CIC Web Survey project for Confidential Dealer/Customer.
• Worked with Executives, IT Infrastructure teams, and Development teams to ensure that Business
• Requirements were properly setup and designed in order to satisfy the Customer requirement.
• Implemented Functionality and WEBI report in BO of Email Management System for Confidential Dealers/Partners in order to send and receive Status of product and notification from CRM to BW.
• System architect responsible for developing strategy to move existing data feeds into the Enterprise Data Warehouse (EDW) and additional target data warehouses.
• Successfully created large-scale Enterprise Data Warehouses, incorporating appropriate SAP schema designs and architecture.
• Installed the appropriate BI Content (0WS QUEST,OWS ANSWER, etc.) and CRM Data sources (0SVY DATA 1, 0CRM LINK SVY H, etc.). Extracted Target group, total response and Max Responses who responded to survey.
• Created customs cube, DSO, customs extractor and Customized Response data source to get details Overview of the Survey. Used Start and End routine on complaints and ERMS.
• Designed and Coordinate with BO team to create WEBI/Query/XCELSIUS in graphical view by number of responses/Question by Survey and Survey validity detail (Survey status, Survey Validity, Owner, Target group etc.). And customized to extract the required details from different source system in order to satisfy the reports.
• Used BO Data services push Cost center data to third party system for their reporting.
• Designed and Architect CRM Survey responses and Survey detail report to Confidential dealer in order to know about the responses and Feedbacks.
• Created reports to track Customer interaction activities and Complaints, Service order, Survey details and Dashboard etc.
• Used Solution Manager SAP to migrate the development changes to different environment and followed the Confidential governance process and BI Development process.
• Used Open Hub/APD for push data costing data to oracle for consolidation reporting for South America team.
• Worked on extracting COPA and CO Product costing details and generate a WEBI report.
• Designed and created seed business categorization of different levels of Call types which is extracted from CRM into BI.
• CO ordinate with SAP for extractor issue in CRM.

Environment: SAP ECC6.0, SCM APO,CRM(6.0 Customer Interaction center, Activity) Service Management, Order management, SD, IP, ABAP,APD, Net weaver 2004s/BI 7.0,Query designer, BOBJ (WEBI), Xcelsius, BODS- Business Object Data Services, SAP Solution Manager, BI Accelerator, Crystal, Dash board, SAP Portals (EP 6.0), ABAP, WAD /Web Template, Info Spoke, SAP GUI, Infoset,UNIX, APD,Windows XP,DB2.

Confidential, Glenview, IL

Sr. SAP BW CRM Lead Consultant

Responsibilities:

• Used Defect tracking tool for testing and identify and tracking the issues.
• Extracted the CRM data (0CRM FM FPO, 0CRM FM BPO) and BI planning data to generate a planning report for the Customers. Also extracted data through APD for Planning.
• Designed customs table and extracted from Customs hierarchy for Customer and Sales from ECC into BI
• Created Process chain for Transaction, Master data, Territory hierarchy structure and planning cubes to be loaded into consolidated cubes. Trouble the failure load during off hours.
• Extracted the CRM data (0CRM FM FPO, 0CRM FM BPO) and BI/IP planning data to generate a planning report for the Customers. Also extracted data through APD for Planning.
• Used write Optimized DSO for Hugh data extraction and further update to DSO’s in order to include a business rule and logic for reporting.
• Extracted the Billing details (Header and Item), GL accounts, A/R, Claims, dispute management for OTC (Order to Cash reports).
• Extracted the Billing, Funding, Spending and Planning, Actual, Plan balance, Live rates to generate the Customer budget plan, Trade spending and Funding, BU revenue Trade summary, Payment and deduction which also involve customer territories summary etc report.
• Troubles shoot the production issue and provided the solution. Also co coordinated with SAP for Patch/OSS notes due to version upgrade and short dump.

Environment: SAP ECC6.0, CRM(TPM), SD, IP, FI-A/R, IP, SCM APO4.1, BPC, ABAP, Net weaver 2004s/BI 7.0,Query designer, BI Accelerator, BOBJ, SAP Portals (EP 6.0), WAD /Web Template, CONTROL-M agent, Info Spoke, SAP GUI, Info set, UNIX, Windows XP.

Confidential, Columbus, OH

SAP BW FI/CO/PS Lead/Architect

Responsibilities:

• Implemented the standard functionality of GL and Cost allocations, Project systems, COPA and Statistical key figures and configured mappings to extract the balance sheet specially formatted reports like Income statement, cost accounting reports, and management P&L reports using BEx (Business Explorer) reporting tools/Workbook.
• Implemented COPA Profitability analysis reported in BI which included Sales and Margin reporting for all brands.
• Developed Cost center allocation and Internal orders to help the Management for Month end closing.
• The client is implementing the BPC 7.0 in its financial department to replace the Excel as the new budget, planning and consolidation system. By implementation of the new BPC system Confidential will make its financial consolidation and budget planning more smooth and accurate.
• Converted all Financial and Management report using BEx analyzer in order to support for Month-end close.
• Balance Sheet Lvl 1, 2.
• Income Statement Lvl 1, 2,3,4,5.
• Margin Cost statement Lvl1 1, 2.
• Cost accounting statement Lvl 1,2
• Capital Budget and Forecast details,
• Cost allocation and Freight Statement,
• Statiscal Key figures air and Ocean.
• Adhoc, Reconciliation etc.
• Configured POS/PIPE Data management to view the sales achieved in the store and details
• Extracted for the credit card settlement process.
• Extracted and loaded the SAP BW with Retail Point Of Sale data (PIPE), Material, Plant, Unit of Measure, and Articles, Plant and pushed to Retails from POS Data management.
• Extracted the Article data from R/3 tables into BW .It contains Article details, SKU Book of Business, Color, Variant, Merchandise and Product hierarchy details.
• Used the ABAP routine the status (Pushed /Pending) of Articles are calculated.
• Created Dashboard report (WAD) to display the Article in different Views (Daily and Weekly report.
• Architect BW project works and developed technical design specifications for developments.
• Configured, developed and implemented the Data modeling design in SCM APO4.1 (Demand planning/SNP) to extract the data from planning area to BW cube and push the data back to APO box for back up. Created the finished goods and raw material reports for Vendor and factory from DP/SNP planning projection by monthly bucket.
• Extracted master data (Color, Article, department, Choice, product, vendor) from R/3 .Also extracted on order goods receipts along with master data in order to FG projection.
• Formatted BO Crystal reports are: predefined report views
• Created Web templates reports for SCEM, APO and maintained centrally sing through SAP Enterprise Portal (SAP EP 6.0) using Net weaver 2004s/BI 7.0 Created Report To Report Interface (RRI) on queries.
• Designed the Customer order visibility report, Transport weight report, Transport gross weight by Purchase Orders reports for building the SAP BW and Supply Chain Event Management (SAP SCEM) objects.
• Developed State tax apportionment report and Sales reports by country by combining SAP FI, SD, and MM modules. Used CMOD for 0FI GL 2 to get PO number from VBPA (Sales document flow) in order to fill the missing PO from BSEG.
• Extensively worked in ETL, Data Modeling, Loading, extractor, Function Module
• Extractor Data Design and modeling
• Created the Dashboard with Metrics of 3 companies Finance details in one View.
• Customized the Income statement and Balance sheet based on FSV update.
• Architect BW project works and developed technical design specifications for developments.
• Designed the Customer order visibility report, Transport weight report, Transport gross weight by Purchase Orders reports for building the SAP BW and Supply Chain Event Management (SAP SCEM) objects.
• Created Web templates reports for SCEM, Finance, APO and maintained centrally sing through SAP Enterprise Portal (SAP EP 6.0) using Net weaver 2004s/BI 7.0 Created Report To Report Interface (RRI) on queries.
• Created process chain and connected to Control-m scheduling tool and trouble shoot the issues.
• Performed performance tuning both back-end and front-end sides.
• Prepared code block in order to transfer the GL data (General Legher accounts) from PeopleSoft to Enterprise Data warehouse system SAP BW using data stage interface. Also using Open hub tool to push the Profit /Cost center to Teradata to maintain Store Operating cost expenses.
• Architect BW project works and developed technical design specifications for developments.
• Activate the business content for xRPM and loaded the data for Resource Project Management (SAP xRPM) and configured, validated the xRPM reports in SAP Enterprise Portal.
• Designed and scheduled the cost element hierarchy for the Confidential to user in the Cost accounting reports. Developed the Syskoplan files to transfer the data from SAP BW server for month-end reporting. Scheduled, monitored and troubleshoot the EFS (Enterprise financial services) the Month-end financial accounting and sales loads and refresh.
• Created, configured and worked with the Control-M agent to run the SAP BW jobs using Process Chains.
• Supported and monitored the SAP BW Production live system (24X7) and resolved the technical and functional issues with SAP Functional, SAP BASIS, SAP BW Security and SAP technical teams. Assisted and prepared SAP BASIS admin activities for setting up the SAP BW landscapes for development, quality testing and production systems.
• Resolved the Problems, Incidents, risk, compliances, and Change and Request Management issues using Peregrine Service Center and complied ITIL (IT Infrastructure Library) Service Management using Governance, Risk and compliance process.
• Used Governances and compliance fixing the issues on time and help business to support on Month end Book closing.

Environment: SAP R/3 FIGL, CO, COPA, PS, MM,SD, IN, xRPM, SAP BW 3.5, ABAP, SAP SCEM 4.0, BPC, SAP Portals (EP 6.0), BPC 7.0,WAD /Web Template, OLAP, SAP PIPE, CONTROL-M agent, Info Spoke, Live link, MSi Tools, Visual Composer, SAP BEx, SAP GUI, SAP BW Workbooks, Info set UNIX, Windows XP.

Confidential, Cincinnati, OH

SAP BW consultant

Responsibilities:

• Worked in development and enhancement of HR project.
• Enhanced HR Master Data and update the HR cube and report accordingly.
• Worked with backend Security and enabled new report available to users.
• Worked in product support and educate the users.
• Worked in Confidential acquisition project for BI development.

Environment: SAPBW3.5, SAPR/3, SAP Portals, HR, BEx Analyzer, WAD /Web Template, Oracle 8.0, Windows NT, Workbooks.

Confidential, Boston, MA

Sr. SAP BW FI Consultant

Responsibilities:

• Interacting with management and the end-users to identify the business requirements and documented them.
• Worked on Inventory handling and material movement (Article) to Distribution center and Customer.
• Extracted the Purchasing details for Pre- packs from R/3 to BW.
• Extracted the A/P, A/R, GL and Controlling/COPA and build the customs reports for Stock holders and Internal Management.
• Extracted purchasing documents and inventory data from R/3 using LO cockpit, implemented Report-to-Report Interface and R/3 thrill-through for drill down analysis, and developed SAP BW reports for performing the analysis of purchasing documents and inventory management

Environment: SAP R/3 4.6C, BW 3.0B, SAP Portals, MM, FICO, BEx Analyzer, BEx Browser, WAD Web Template, ABAP Query, Oracle 8.0, Windows NT.