SUMMARY

• Around Sixteen years of IT experience which includes thirteen years of SAP BI/BW & ABAP experience.
• Expert knowledge of SAP BW architecture and an ongoing awareness of SAP's BI technology direction.
• Highly experienced in Implementation, design, development and utilization of various applications in SAP.
• Experience in designing, developing Infoproviders for SAP Procurement, FI, MM, SD, PP, QM, HCM/HR, PS & SPM Areas.
• Involved in all phases of BW project including full lifecycle implementation of 7 BI/BW projects.
• Good hands - on experience in User Business Process Engineering, Configuration, User Training and Programming to provide successful solutions in the integration of SAP within a business and in the integration of the SAP modules with each other.
• Extensive working knowledge in installation, configuration and creation of standard and custom InfoCubes (Basiccube, Multicube and Remotecube), DSO’s, Infosources and InfoObjects.
• Good understanding of star schema and extended star schema and data warehouse data modeling.
• Extensive hands-on experience in data modeling, OLAP, and knowledge of SAP BW components and end-to-end cube development
• Proficient in creating and deploying Business packages in Visual Composer. My development work includes creation of Dashboards using Visual Composer Wizard to create reports with charts, tables and forms and also deployed to enterprise portals.
• Experienced in multiple migration projects from SAP BW 2.0B to 3.0B and 3.5 to 2004s. Strong Knowledge in BW Upgrades to BI 7.0/2004s and BI 7.3.
• Experience in upgrading the SAP SPM analytical toll from 2.1 to SPM 3.0.
• Extensive experience in the R/3 extraction process including Logistics extraction cockpit (LO) extractors.
• Good experience in developing data models in HANA 1.0 SP2
• Did extensive ABAP Program design, development (coding), testing, and implementation for on-line and batch applications. Created user exits, update/transfer rules, start & end routines, enhanced datasources and worked in Data Mining.
• Experience in Open Hub data distribution using InfoSpokes, DBConnect, infoset queries, process chains, transactional ODS, multi-providers etc.
• Possess excellent knowledge on designing/deploying composite applications, Business packages using Visual Composer. My Development work includes creation of Dashboards using Visual Composer and BO Xcelsius, deploy them to enterprise portals.
• Have more than 10 years’ experience working with SAP’s BEx Query Designer, WEB Application Designer and Enterprise Portal 6.0.
• Worked on Queries, Workbooks, Dashboards, Web Report publishing using Web Application Designer and Visual Composer. Used tools such as Open hubs, APDs, Information Broadcasting, Spend Performance Management etc.
• Experienced in performance and tuning of queries and data loads using BW tools.
• Experience in the integration ofBODSwithSAP modulesandNon-SAP data sources.
• Experience with ETL tools like Informatica 6.0 & SQL Server DTS and scripting languages like VBScript, also have experience with non-sap applications like Java, Oracle and C.
• Worked with reporting tools like BEx, Business Objects, Web Templates, and Crystal Reports.
• Have extensive tickets/Incidents handling knowledge with Service Now.
• Exceptional interpersonal, problem-solving and analytical skills that assist in quick and smooth task completion.

TECHNICAL SKILLS

Operating systems: UNIX, Windows 98/2000/NT4.0

Languages: Visual Basic 6.0/5.0, Java, C, SQL, ABAP/4

Databases: Oracle 7.x/8.x, SQL Server, MS-Access, DB2

Web Tools: Active Server Pages, HTML, Java Scripts, VB scripts, MS Front Page

Packages & Utilities: FTP, MS-Office, MS-Outlook, MS-Word, and MS-Excel, Power Point, Lotus 123.

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

SAP BW/BI Technical Architect

Responsibilities:

• Handling the overall BI development team to develop reports for Supply and Demand Planning group.
• Designed and developed the data model to store SAP, NON-SAP data pertaining to sales demand actuals and forecast information.
• Responsible in gathering requirements through workshops, prepare and finalize the functional requirements from the business and converting these functional requirements into technical designs.
• Implemented the various Supply chain related by conducting the design, code and validation plan reviews.
• Responsible in analyzing the project plan, conducting meeting to collect project status and communicate to business leadership group.
• In control to manage successful test plans that way the functional Specifications and Technical testing can successfully be delivered.
• Responsible in preparing the design and create the Composite providers to accommodate both SAP and NON-SAP data in BW on HANA system.

Confidential, Milwaukee WI

SAP BW/BI SPM Deployment Lead

Responsibilities:

• Responsible in handling the onsite and off shore SPM team to support procure to pay application.
• Responsible in preparing and finalizing the functional requirements from the business users and converting these functional requirements into technical designs.
• Successfully implemented various finance & procurement (Spend) reports and conducted design, specification, code and test plan reviews.
• Responsible in creating test scripts in HP ALM.
• Responsible for overall SAP SPM 3.0 upgrade project in SAP BW 7.4 platform.
• Review, Analyze project plan, project status, and communicate to sap project teams and senior management.
• Managing successful test plans so that the functional Specifications and Technical testing can successfully be delivered.
• Gathered and analyzed the requirement to replicate the ECC content in HANA usingdata provisioning.
• Created Technical specifications and standard modeling documents for HANA.
• Supported the SAP SPM tool by addressing the Incidents/tickets opened in service now.

Confidential, Princeton NJ

SAP BW/BI Delivery Lead/Manager

Responsibilities:

• Responsible in handling the onsite and off shore BW teams to support Global procurement application.
• Responsible in preparing and finalizing the functional requirements from the business users and converting these functional requirements into technical designs.
• Successfully implemented various internal finance & procurement (Spend) related projects and conducted design, specification, code and test plan reviews.
• Responsible for overall project management for the SAP Spend Performance Management (SPM 2.1) Project implementation. Review, Analyze project plan, project status, and communicate to sap project teams and senior management. Managing successful test plans so that the functional Specifications and Technical testing can successfully be delivered.
• Responsible for overall project management for SAP SPM 3.0 upgrade project. Review, Analyze project plans, project status, and communicate to senior management.
• Performed the daily support of the application by handling the Incidents in Servicenow.
• Supported other BW application team leads on critical issues for functional/technical levels.
• Managed the workload for the overseas developers & offsite developers. Worked on providing solutions for the technical deliverables such as timelines, scope, and quality for the sap project.
• Supervised the daily activities of the support teams in support, design, coding and testing while providing development utilizing BW & BI functionalities for Finance & Global Procurement Areas.
• Guided and mentored developers while resolving technical issues and conducting analysis. Monitored the team’s project development progress while providing hands-on development.
• Delivered critical support to business users of SAP BW Finance & Global Procurement applications through design, coding, testing, and implementation of several full life cycle implementations.
• Provided BW/BI expertise and execution in vital systems implementations.
• Accelerated development and design time to enhance productivity. Utilized BEx Broadcaster to publish the validation status reports to Finance Business users.
• Experience in creating the various application related test scripts in HP quality center for multiple projects.
• Designed and created workbooks, BEx reports, web reports, BO & Crystal reports for various application areas of Finance and Procurement modules.

Environment: SAP BW 3.5, 7.0, 7.SAP SPM2.1, 3.0, SAP ECC, BO 4.0, BEx, Crystal Reports.

Confidential, CA

SAP BI Principal Consultant

Responsibilities:

• Involved in the analysis of client requirements in Development for BW systems, Testing, Performance Tuning in the SCM Area.
• Created Dataproviders and Infoproviders for real time data acquisitions for Orders, Billing and Delivery
• Enhanced supply chain management data models.
• Designed and Created workbooks and reports like Order life cycle, Order Water fall, Delivery Water fall, Billed Detailed, Billed Direct Client analysis reports.

Confidential, KS

SAP BI Principal Consultant

Responsibilities:

• Performed & Completed Technical Assessment.
• Carried out discussions with business users, ERP consultants and gathered requirements.
• Prepared SOW and business blueprint to transform their requirements to technical designs.
• Presented a power point presentation explaining the requirements, solution approach, and time-lines required for project implementation.

Confidential, PA

SAP BI Principal Consultant

Responsibilities:

• Designed and developed a Headcount Planning custom Cube to extraction the third party data into the SAP BW system.
• Fixing the outstanding & long term open issues in Personal Administration.
• Created reports for displaying the Diversity Summary, Summary of Plan Actual and Recruiting by cost center, THC Actual Vs THC Plan, Headcount Actual and Plan Summary etc.
• Enhanced the standard Master data Datasources for example 0Employee, 0Ethnic region etc...
• Deployed role based reports example like Headcount drilldown by employee, by cost center and reports to executive in portal using Web Application Designer.

Confidential, MD

SAP BI Technical Lead Consultant

Responsibilities:

• Implemented SAP content objects in SD, MM, HCM and FI Areas.
• Solid understanding and knowledge of end to end business process in SAP R/3 in the Finance, Logistics and HCM Areas.
• Designed Custom Datasources and Infoproviders to display the Purchase Order’s Price & Quantity Variances, Spend Data at item/Commodity Level (KPI’s) in the Reports.
• Designed and Developed Custom Datasources, Dataproviders and Multiproviders in applications like Human Resources and Finance & Controlling for example to display the various Medical Cost expenses of the company on the active employees and retirees. Displaying Participating and Eligible employees for various Medical and Dental plans and their contributions.
• Activated Standard HR Master Data objects and enhanced some the objects such as Plan types, Plan Category, First & Second Program grouping etc...
• Delivered different reporting solutions in BW and in planning areas as per business needs.
• Published various reports like Amount sold with the cost of the sales, Incoming order analysis etc. in portal using WAD/dashboards
• Designed Hierarchies for Infoobjects such as Organizational Plan, Plant, and Cost center.
• Designed various BI reports using BEx Query Designer and Web Application Designer.
• Designed Dashboards to display various Inventory reports (MM) like PO Aging, Actual Weeks of Supply, Inventory Daily, monthly Summary, Variances & Variance %’s, Medical Benefits, Company contribution (HCM) reports, Income Statements, Balance Sheet (FI) reports using BO Xcelsius.
• Worked with Basis, to Install BO desktop tools and BOBJ integration kit for SAP.
• Designed and created various BO universes to display the required outputs.
• Requirement gathering session with users to understand the KPIs to be used for dashboards.
• Used Query as a web service to connect BO with SAP BI
• Involved in Integration testing and performance tuning related issues.

Confidential, IL

SAP BI Lead Analyst

Responsibilities:

• Designed, created the custom Dataproviders, Multiproviders and Data extraction from SAP R3 and from flat files into the SAP BI system.
• Designed and developed various Master data infoobjects and Hierarchies.
• Created various reports using BEx & Web Application Designer.
• Helped setting up of data governance body to ensure smooth flow of quality of data from legacy source systems into SAP.
• Extensively Involved in Integration testing and performance tuning related issues.
• Worked extensively on administration workbench. Activated the Business Content Infocubes, DSO’s, Infoobjects, and Datasources.
• Responsible for collecting and transporting BW objects to QA and Production environment through CTS.
• Customized business content datasources like adding more fields to it, including developing ABAP code for functional enhancement for Master and Transactional Data in BI.

Confidential, CA

SAP BI Analyst

Responsibilities:

• Involved in Creating, Modifying the custom Dataproviders, Multiproviders and Data extraction from ECC 6.0 and from flat files into the SAP BI system.
• Worked on Maestro Scheduler to automate the Process Chains & jobs.
• Implemented a Dashboard Report for IP team - Summary reports and Detail reports and published on the Portal.
• Used Visual Composer to create the Business application components.
• Created the BI reports using BEX Designer and published those reports in the Portal using the standard web templates.
• Involved in Integration testing and performance tuning related issues.
• Worked extensively on administration workbench. Activated the Business Content InfoCubes, DSO’s, InfoObjects, and Datasources.
• Responsible for collecting and transporting BW objects to QA and Production environment through CTS.
• Customized business content datasources like including developing ABAP code for functional enhancement for Master and Transactional Data in BI.
• Modified Custom HR Cubes for headcount planning and reporting, Salary information, Employee Status and tracking.

Environment: SAP ECC 5.0, BI 2004s.

Confidential, GA

SAP BW/BI Technical Consultant

Responsibilities:

• Analysis of data requirements and translation of these requirements into dimensional data models using star-schema and extended star-schema data modeling techniques.
• Designed and developed reports for SDR/SSDR/IDDR using Web Application Designer and published them on portal.
• Delivered different reporting solutions in BW and in planning areas per business needs.
• Coordinated with different business groups and cross technical teams to ensure successful cutovers.
• As a key member of core enterprise data management team, helped establishing common data definitions, global mapping applications for building Corporate Information Model.
• Delivered accurate information/reports in timely manner by gathering necessary data while providing production support for supply chain management.
• Involved in creating/modifying the required custom Dataproviders, Multiproviders and Data extraction from SAP R/3 and from flat files into the SAP BW.
• Used Operational Data Store (ODS) to stage the data before transferring the ODS contents to the Infocubes and enhanced the custom Infocubes.
• Created Virtual Cubes to archive the Sales, Purchasing, and MRP related Historical data.
• Provided assistance in setting up of the data governance body to ensure smooth flow of quality of data.
• Worked with custom ODS objects, Infocubes, and Datasources to pull the sales and purchasing data into the BW system.
• Designed and Developed the Web Templates using the Web Application Developer to display the daily, weekly, monthly company reports in the Portal.
• Developed reports in support of the Supply Chain Management team.
• Involved in the Upgrade of the BW 3.5 system to 2004s.
• Involved in the analysis of client requirements in Development for BW systems, Testing, Performance Tuning.
• Responsible for collecting and transporting BW objects to Test system and into Production environment through CTS.

Environment: SAP R/3 4.6C & ECC 5.0, BW 3.5 & 2004s, BEx Browser and BEx Analyzer.

Confidential, PA

SAP BW Analyst

Responsibilities:

• Involved in creating the Business Content Activation and Data extraction for from SAP R/3 and from flat files into the SAP BW.
• Used Operational Data Store (ODS) to stage the data before transferring the ODS contents to the Infocubes and enhanced the custom Infocubes.
• Created Virtual/Remote Cubes to pull the Sales Detail history data into the custom created Openhub tables.
• Worked on Maestro Scheduler to automate the Process Chains & jobs to load the daily Sales, Delivery & Billing Data.
• Designed/Created custom ODS objects, Infocubes, Datasources and Infospokes to pull the purchasing data from the Cognos system into the BW system using Informatica as data extraction mode and store the data in openhub tables.
• Used open hub service functionality to send the data to Cognos.
• Created custom Infoobject Catalogues for custom Characteristics and Key Figures for Infoarea.
• Analysis of data requirements and translation of these requirements into dimensional data models using star-schema and extended star-schema data modeling techniques.
• Created Process chains and Infopackage groups for data loading.
• Query development using the BEX analyzer/browser functionality of BW.
• Worked with the Queries Purchase order Queries for example - Purchase order Values, Purchase order Quantities, Purchase orders & Orders Delivered Complete etc…
• Involved in unit testing and performance related issues.
• Worked extensively on administration workbench. Customized InfoCubes, InfoObjects, InfoSources and Data sources.
• Involved in the analysis of client requirements in Development for BW systems, Testing, Performance Tuning, Transport (CTS) to Test and Production environment.
• Responsible for collecting and transporting BW objects to QA/Production environment through CTS.
• Customized Data sources including developing ABAP code for functional enhancement for Master and Transactional Data in BW.

Environment: SAP R/3 4.6C, BW 3.5, Informatica 7.2, Cognos, BEx browser and BEx Analyzer.

Confidential, NJ

Senior SAP BW Consultant

Responsibilities:

• Day-to-day responsibilities include analysis of data requirements and translation of these requirements into an emphasis on actual implementation in BW.
• Responsibilities include developing, maintaining, supporting, loading master data and transaction data into the warehouse via the BW Administrator Workbench, and enabling communication about master data across client project teams.
• Involved in the analysis of client requirements in Maintenance, Development and Support for BW systems for the SD, MM and FI modules, Development, Testing, Performance Tuning, Transport (CTS) to Test and Production environment.
• Worked extensively on administration workbench. Customized InfoCubes, InfoObjects, InfoSources and Data sources.
• Set up procedure for extracting R/3 data for SD using LO-cockpit and into Infocubes.
• Responsible for collecting and transporting BW objects to QA/Production environment through CTS.
• Worked extensively on Custom Inventory Data providers P1OSCIMA (Active Batch), P1OSCIMS (Batch Stock /Reservations), P1OSCIMC (BOM Components), P1OSCIMB (Material Movements).
• Worked extensively on Purchasing data Infoproviders P1OSCPUT (Manufacturing cost), P1OSCOP (Open Purchase orders), P1OSCPUS (Stock Transport orders).
• Enhanced the existing structures for Logistics namely Sales Order, Billing, Shipment and Material Pricing were maintained and activated.
• Periodic extractions are scheduled using InfoPackages by using after jobs & after events.
• Setting transfer rules, writing transfer routines, writing update start routine, and update routines.
• Did the data validation, record counts in data targets against R/3 for the same selection criteria as imposed by Info-Packages/Update rules.
• Created Reports and Queries using BEx Analyzer and Crystal Reports.
• Improved the loading performance by changing the Rules in loading carried out number range buffering, deleting secondary index, run stats on Cubes/ODS using transaction DB20.

Environment: SAP R/3 4.6C, BW 2.1C, BEx browser and BEx Analyzer, Crystal Reports.

Confidential, OK

Senior SAP BW/ABAP Consultant

Responsibilities:

• Developed flexible queries to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Developed the custom infocube ZIOMR (Integrated order management report).
• Developed the custom infocube ZHRBISYS (Payroll data).
• Extracted structures for Logistics namely Sales Order, Billing, Shipment and Material Pricing were maintained and activated.
• All the designs and their changes were documented after PM approval.
• Carried out repair request for the additional number ranges in Billing & Purchasing Initial loads after deleting the Set-Up table contents and running the new variant for the new number ranges.
• Carried out data validation, record counts in data targets against R/3 for the same selection criteria as imposed by Info-Packages/Update rules.
• Improved loading performance in loading carried out number range buffering, deleting secondary index, run stats on Cubes/ODS using transaction DB20.
• Developed performance tuning processes and strategies.
• Customized Data sources including developing ABAP code for functional enhancement for Master and Transactional Data in BW.

Environment: SAP R/3 4.6C, BW 3.1C, BEx browser and BEx Analyzer

Confidential, NJ

SAP BW/ABAP Consultant

Responsibilities:

• Customized SAP Business Information Warehouse 2.0B & 3.0B with thorough capacity including data extraction, modeling, and reporting.
• Analyzed array of Legacy Systems, carried out GAP Analysis between SAP BW Content and client requirements
• Designed optimum solution based on the GAP analysis and discussions with the client.
• Developed custom infoobjects, datasource, infosource and data providers for SD, HR and FI.
• Developed queries and workbooks to suit the client’s requirement. Used Variables, Filters, free characteristics, restricted key figures and calculated key figures in developing the queries and workbooks. Worked on Web Reporting, did the formatting of excel style sheets and graphics.
• +Created and mapped source and target structures, loaded transactional data and master data, and set up delta load using SAP Standard extractor and Generic extractor Program.
• Designed and created all BW components to load the historical data via informatica and flat files.
• Worked on the custom Infocubes ZSALESCOMP1 & ZSALESCOMP2 (HR- Compensation Management).
• Created multiple queries for Service and Compensation Reporting using Crystal reports.
• Developed performance tuning processes and strategies.
• Customized Data sources including developing ABAP code for functional enhancement for Master and Transactional Data in BW.
• Involved in all stages of the project including analysis, design, development, testing and transportation
• Designed and created all BW components to load the historical data via flat files.
• Worked extensively on Logistics Data Extraction Cockpit for the Purchase module for the DataSource 2LIS 12 VAHDR, 2LIS 12 VASCL, and 2LIS 12 VAITM in SAP BW 2.1C.
• Developed/created the custom infocube ZIOMR (Integrated order management report).
• Worked with account payables workflow.
• Involved in developing the queries to suit the client’s requirement..
• Customized Data sources including ABAP code for functional enhancement for Master and Transactional Data in BW.
• Involved in documentation and user training and provided Go-Live/ post Go-Live support.

Environment: SAP R/3 4.6C, 3.1H, BW 2.0B, 3.0B, BEx browser, BEx Analyzer, Crystal Reports.

Confidential

SAP ABAP/BW Consultant

Responsibilities:

• Worked on Business Content in Designing and Creating InfoSources and InfoCubes.
• Developed the required InfoSources, Communication structures, Transfer Structures, transfer rules, transfer routines and Update rules.
• Enhanced Data Sources for Sales & Purchasing Transaction Data.
• Created Master Data Infosources for Attributes, Texts and Hierarchies.
• Designed and created several Sales Queries using BEx Analyzer.
• Participated in Collection and Documentation of the End User Requirements.
• Worked extensively on various SD, MM and PM documents using SAPScript and Reports.
• Modified the following layout sets in SAPScript for Invoice (RVINVOICE01), Purchase order (MEDRUCK), Delivery Note (RVDELNOTE) and Scheduling Agreement (RVORDER01).
• Modified print programs and layout sets for Delivery Note (RVDELNOTE), and order Confirmation (RVORDER01) according to client’s requirements.
• Extensive work done with ABAP Workbench, Screen painter, Menu painter and ABAP Debugger.

Confidential

Responsibilities:

• Led the design/development activities for report generation for the entire organization.
• Required extensive participation in business process discussions with end users and SAP R/3 functional consultants.
• Wrote SAP Scripts for Delivery Quotation, Sales Activity, Purchase Order, and Request for Quotation.
• Wrote BDC programs, in support of the data conversion team, to migrate legacy data to the SAP system.
• Both master and transactional data was migrated to SAP
• Sales by destination report: Prints sales by destination on a quarterly basis.
• This report has the option to print by all shipping points combined by a given shipping point, and by country of destination.
• Monthly Material Usage variance report
• Ship schedule by Material Number

Confidential

Responsibilities:

• Involved in the development of a Purchase Order System for Azad Industries.
• Development of front-end user interface using Visual Basic.
• Used DAO objects to access data from the Oracle database.
• Created stored procedures for updating purchase orders into stock.
• Created and generated reports for all the modules using Crystal Reports.
• Involved in Unit and Integration testing and implemented the application at the user end.

Environment: Visual Basic (Front End), Oracle (Stored Procedures, Triggers), Crystal Reports.

Confidential

Responsibilities:

• Developed a Data Model, Database Design and Implementation, and Applications Development
• Involved in determining system requirements, capturing requirements in Data Flow.
• Diagrams (DFDs), Process Flow Diagrams (PFDs), and Entity Relational Diagrams (ERDs), logical and physical database design, and module definitions.
• Used various Designer tools.
• Generated code for the Forms and Reports. Developed procedures for restricted updates of relevant tables.
• Used dynamic SQL for creating temporary tables. Developed a Package for running Reports.

Environment: Oracle 7.1, Oracle Forms 2.5 & Reports 2.5.