PROFESSIONAL SUMMARY:

• Over 15 years of professional experience in Information Technology. Includes 11 years of SAP BI experience. Implemented 3 full life cycle Projects in SAP BI involving both front end and back end development.
• Extensive hands on experience in BI backend development - Info Objects, Info Cubes, DSO, Multi-providers, Info Set, DTP, Transformation, Transfer Rule, Update Rule, Info Package.
• Experience in BI front end development - BEx Analyzer, BEx web Analyzer, Views, Workbook.
• Involved in all aspects of the ASAP methodology phases - Business Blue Print, Realization, User Training, Preparation and Go live/Support.
• Experienced in SAP HANA implementation, SAP System Landscape transformation
• SAP HANA data modeling using Attribute View, Analytic View and Calculation Views,
• Expertise in data modeling, design, configuration, implementation of Data Warehousing solutions
• Hands-on configuration knowledge of SAP CRM Marketing, Sales and Service Including SAP’s call centre solution Customer Interaction Center (CIC).
• Working knowledge in both BI7.0,BI 3.5 & BO 4.0
• Expertise in Process Chain, Scheduling, Monitoring data loads and Background jobs.
• Worked extensively with LO Cockpit, Logistics and FI extractors, process chain.
• Proven ability in defining goals, coordinating teams and achieving results.
• Experience in SD Business Processes.
• Created Webi Reports on top of Bex Queries and SAP HANA Database
• Analyzed and evaluated user’s requirements, created technical documentation, assisted users, coordinated procedures, reviewed functional specifications with the Subject Matter Expert.
• Served as coach mentor to the department staff regarding how to deploy and execute a test plan. designed test plans to ensure software functions as designed.

TECHNICAL SKILLS:

ERP: SAP ECC5.0, ECC 6.0

BW: BI 7.0, BW 3.5 BO 4.0

Function Modules: SD, MM, HANA, FI/CO

Reporting Tool: BEx Analyzer, Web application Designer, BEx Web Analyzer

Operating Systems: UNIX, Linux, MVS, OS/390, z/OS, Windows.

Packages: MS-Office, VISIO

Databases: DB2, Oracle10 PL/SQL, SYBASE

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

SAP BI/BPC Solution Consultant

Environment: SAP BI,BPC, SAP ERP ECC.6, BEx, Analyzer

Responsibilities:

• As a Techno functional consultant preparing the functional design documents from the requirements.
• BI/BPC Consultant responsible for Preparation of Data flows, functional feasibility analysis, Post go live support, activity execution, Quality Assurance to improve performance of the system.
• Create Appsets, Dimensions, Applications, Conversions, Transformations
• Created universes, classes, objects, based on SAP HANA data models like Calculation Views and Analytical Views and defining the necessary connections.
• Configuration of web reporting with customized web templates using Web Application
• Building Dashboards using visual composer in producer portal PS3 (Enterprise Portal).
• Customized and maintained Data sources such as Billing Item (2LIS 13 VDITM) and
• Performed Data loads for Transaction and Master Data from SAP R/3 using Process Chains
• Worked extensively with the Sales Order and Billing items Data Sources, Custom InfoCubes and Custom DSO(Data store Objects) for staging the billing and Sales order item data
• The Solution in BPC integrated with SAP ECC, BW and BusinessObjects
• Developed Xcelsius dashboards for Weekly and Monthly Business Objects usage trends.
• Activated the Business Content performed the Data Source Migrations. Created different test scenarios to reconcile new reports to old reports
• Designed Xcelsius Dashboards using Excel and QaaWS.
• Performed data modeling in SAP HANA studio and developed Analytical views for the transactional data, Attribute views for the master data, and Calculation views for reporting.
• Created transport proposals.
• Provided assistance and created training curriculum, guides, checklists and courses.
• Created test plans, scripts and scenarios for Unit Testing and User Acceptance Testing.
• Coordinated and managed User Acceptance Testing.
• Supported end users for the existing applications as well.
• User Training of navigation and utility of BPC reporting
• Direct interaction with the business users.

Confidential, Jasper, IN

Sr. SAP BI/BPC Consultant

Responsibilities:

• Part of the implementation team in implementing a BI Solution data and legacy application, responsible for doing front end and back end development work
• Hands on development work, creating or changing Info Objects, ODS, Info Cubes, Multi Provider, Transfer Rule, Update Rule, Info Packages.
• Responsible for Designing and Architecting the Planning solution for Liquidity Planning (in BPC NW 10), while Legal Consolidation to stay in Hyperion. Responsible for Architecting the BPC Planning solution in a heterogeneous landscape, with multiple SAP instances and heterogeneous legacy systems.
• Design of Planning models and development of Planning Areas, Multi-planning areas, Planning Levels and Packages for Sales Planning and Cost center Planning
• Defining Planning Functions and creating and maintaining Planning Layouts for Manual Planning
• Implemented full/delta loads, standard, generic extractors, process chain and set up in conjunction with the 3rd party scheduler software for nightly data load.
• Performed Data Extraction for master data and transactional data from ECC system to SAP BW.
• Creation of Web interface using BSP pages for planning, and making the planning layouts available to the users using Enterprise Portals
• Involved in the Upgrading of BW 35 to BI 70
• Implemented many BI reports using BEx.
• Developed many BI queries, Views and workbooks on Sales and financials data.
• Develop BI objects in both BI 7.0 and 3.5 versions.
• Extensive experience SAP HANA/BW with ability to synthesize the technical needs to the business requirements for a new engagement
• Developed and scheduled Business Content data extraction from SAP R/3 Source System and data load procedures.
• Worked extensively on LO Cockpit and SD extractors
• Responsible for Logistics Cockpit configuration and customization for sales order overview.
• Responsible for extending standard extract structures and user exit on SAP R/3 side.
• Created process chains for nightly data loads for master data, transaction data.
• Created training materials for end users and conducted many End user trainings.

Confidential, Reedsburg, WI

BW Consultant (BI Architect)

Responsibilities:

• Worked closely with SME’s, functional specialists and process owners to gather detailed business requirements and translated the requirements into robust reporting solutions.
• Developed data models, data flow diagrams, functional design and technical design documents for BI Solutions
• Conducted meeting and interacted with third party vendor to get needed clarifications.
• Designed Star Schema
• Developed model to Load data from third party through Oracle 9i as the intermediate tool.
• Built info objects, master data objects, DSO and info cube
• Mapped the third party data to SAP data though ABAP routines to look up the mapped data.
• Built required transformations on production data and used ABAP routines to fetch matching plant and material.
• Built cubes and multi provider on sales data and production data.
• Tested, Validated loaded data from ECC to HANA, troubleshoot and analyze varies issues related to data load.
• Developed 7 reports with BEx tools as per the client’s requirements
• Used ABAP user exit to get the previous year same month data in 4 reports.
• Tested for data integrity, Data load, and performance
• Identified data discrepancies and data quality issues, and worked to ensure data consistency and integrity
• Tuned the objects and processes for Performance
• Participated and supported 2 UAT sessions with super users
• Involved in Moving the objects and related processes through 5 landscapes
• Documented the complete processes and presented to the approval committee.

Confidential, Winchester, VA

Sr. SAP BI /BO Consultant

Responsibilities:

• Contribution-Interacted with the management, conducted workshops and personal interviews to collect the requirements during initial stages of projects/task for understanding business process and end-users reporting requirements.
• Fielding questions concerning the data content, definition and structure.
• Worked closely with the process team to design Functional Specifications document and created Technical Specifications for the same.
• Support the Procurement Business with the provision of functional specifications and technical specifications for systems, ensuring compliance with guidelines.
• Involved in design of Planning for business planning applications.
• Activated Sales Cubes 0SD C01, 0SD C02, 0SD C03, 0SD C05 from Business Content and customized to meet the requirements.
• Involved SAP HANA-BW on HANA use cases study, solution proposal and implementation
• Worked extensively on Standard Datasources with LO Customizing Cockpit for extracting Sales, Delivery, Billing, Purchase and Customer.
• Activated Operational Data Store Objects and Cubes by the extraction of data from R/3 using 2LIS 11 VAITM, 2LIS 12 VCITM and 2LIS 13 VDITM extractors.
• Worked on reports of Costs of raw materials, operating supplies, Wage costs and External services.
• Worked on creating Aggregates and providing fixed values for Info objects as per requirement, Data Marts, Info cube Compression.
• Created Multi provider on sales and delivery cubes to assist reporting on sales and delivery together.
• Created reports on incoming order data for specific customers, Quotation Success Rate per Sales Area, Delivery Service Analysis, Service Level analysis by quantity and item level.
• Request creation and maintenance for object transportation.

Confidential, Denver, CO

Sr. SAP BI/BO Lead/ Consultant

Responsibilities:

• Part of the implementation team in implementing a BI Solution for CRM,SD data and legacy application, responsible for doing front end and back end development work
• Hands on development work, creating or changing Info Objects, ODS, Info Cubes, Multi Provider, Transfer Rule, Update Rule, Info Packages.
• Implemented full/delta loads, standard, generic extractors, process chain and set up in conjunction with the 3rd party scheduler software for nightly data load.
• Implemented Information Broadcasting to send large reports to broad user base through email for the Field Sales Team.
• Configured CIC to enable Call Center Representative to create service Orders for repairs.
• Developed Integrated Billing cube (to include Billing item, Billing conditions, legacy Billing information)
• Co-ordinate security and transport activities with the security and Basis team respectively.
• Implemented many BI reports using BEx.
• Involved in SAP HANA Attribute, Analytical, Calculation view data modeling optimization, tuning, applied SAP best practices and troubleshooting
• Developed many BI queries, Views and workbooks on Sales and financials data.
• Develop BI objects in both BI 7.0 and 3.5 versions.
• Responsible for Logistics Cockpit configuration and customization for sales order overview.
• Responsible for extending standard extract structures and user exit on SAP R/3 side.
• Developed and scheduled Business Content data extraction from SAP R/3 Source System and data load procedures.
• Extracted Data from R/3, Creating Info Packages, Event Scheduling, and Monitor settings.
• Worked extensively on LO Cockpit and SD extractors
• Created process chains for nightly data loads for master data, transaction data.
• Created training materials for end users and conducted many End user trainings.

Confidential, Meridian, MS

SAP BI/CRM Consultant

Responsibilities:

• Created approx 50 reports and 300 views and 60 workbooks in this project, Used SAP BW 3.5, ECC 5, CRM,SD, BEx Analyzer, AWB
• Deriving technical specifications from high-level functional specifications for the BI front end development work.
• Involved in design, development, unit testing, and integration testing of new BI front end development as well as enhancing the existing objects.
• Created technical design document, unit test scenarios and integration scenarios for the project.
• Enhanced pre-configured InfoCube and related objects to meet the business requirements.
• One working screen (IC profile) for each interaction centre scenario
• Simulation of incoming phone calls and phone call processing (inbound and outbound)
• Created aggregates for the InfoCube for the better performance of the queries.
• Defined new info objects and modified the User Exit for transactional data / master data to accommodate the business need as per the client requirements.
• Extensively used Variables, Restricted, Calculated Key Figures & Query Jump targets (RRI), text variable, exceptions, Conditions, Filters, Global Filters.
• Configured and scheduled Information Broadcasting for the sales force and upper management on their daily BI reports.
• Configured CIC to enable Call Center Representative to create service Orders for repairs.
• Created Webi Reports on top of Bex Queries and SAP HANA Database
• Handled all user inquires related to production support and giving them resolution.
• Extending production support and resolving the production issues on daily basis.
• Created user training manuals for all the new BI queries, workbook and views
• Conducted training for the end users on their reports.

Confidential, Chicago, IL

SAP BI/ BW Consultant

Responsibilities:

• SAP BI 7.0 RTP (Request to Pay) SRM - EBP and PS implementation at Confidential
• Installed and activated SAP business content according to initial design of RTP (Request to pay)
• Developed InfoCubes and ODS’s (Data store objects) for Purchase Order, Confirmation, Invoice, Shopping Cart, Bidding Engine and Global Spend
• Created ODS (Data Store objects) for data staging before loading the ODS contents to the InfoCube
• Automatic Number Identification (ANI) for incoming telephone calls
• Performed data extraction from SRM DataSources for Purchase Order, Confirmation, Invoice, Shopping Cart and Bidding Engine and extended the structures using user exits to support the business needs
• Interacted with Business leaders, Owners, Users, Call center Agents to Understand the Business processes, functional requirements and did the Gap analysis.
• Created Master data and Transaction data process chains to automate loading process
• Developed flexible queries using navigational attributes, variables, calculated key figures, restricted key figures in Query Designer to facilitate data analysis in a detailed drill down or summarized levels
• Created Variable Exits for global variables Fiscal year variant, controlling Area and Chart of Accounts as per the requirement
• Given role based access to queries in Enterprise Portal
• Written a Global Include program which reads values from TVARVC table for fiscal Year variant as it is client dependent
• Implemented SAP Notes

Confidential, Rosemont, IL

SAP BW /CRM Consultant

Responsibilities:

• Responsible for integration testing all the BI front end back end development. Used SAP BW 3.5, ABAP/4, ECC 5 (CRM and SD modules), BEx Analyzer, BEx Web Analyzer
• Created integrated test scenarios for testing queries, views and work books.
• Reviewed functional and technical design documents for completeness.
• Extensively tested BI queries, restricted key figures, and calculated key figures.
• Analyzed, indentified issues and recommended resolutions.
• Responsible for working with SAP HANA security including user management, Roles and Privileges.
• Tested all the BI key figures with ECC (sources of truth) by running SE16, standard TCodes, SQVI, Custom ABAP programs.
• Investigated the BI back end objects (cube, ODS) to make sure that the data is populated as expected.
• Reviewed and tested all the BI nightly data loads for master data and transaction data.
• Scheduled the data loads in Test environment and making sure that there are no failures.
• Updated issue log with discrepancies and possible resolution in the issue log.

Confidential, Irvine, CA

SAP BW Functional Consultant

Responsibilities:

• Involved in designing MDM for various business scenarios and creating custom InfoCubes supporting Quality Management and Materials Management of consumer products.
• Installed Business Content and activated the SAP delivered Standard InfoCubes and InfoSources.
• Worked on Generic Data Extraction tool (RSO2) to create DataSources for transaction and master data.
• Created Views in the non-SAP database systems and generated Data Source for the tables/views.
• Extensively worked on CO-PA, FI-SL, and Logistics Cockpit extractions.
• Maintained customized InfoCubes, Operational Data Sources, and MultiCubes for the business requirements.
• Updated data from several ODS objects into InfoCubes.
• Defined update and transfer routines in transformation rules.
• Performed Delta request using Time Stamps.
• Dealt with the creation of InfoPackages for transaction data as well as master data.
• Worked on Process Chains to load InfoCube, ODS, aggregate roll up etc.
• Created InfoSpoke for carrying out extractions from BW InfoProviders.
• Extensively used BEX Analyzer to build queries, queries with maps and charts and worksheets to access data from BW data targets.
• Used ODS Reporting to give details of delivery items.

Confidential, Atlanta, GA

Test Analyst

Responsibilities:

• Prepared Test Plans, Test cases Test Scenarios and Test Data for all requirements.
• Automate the GUI of Web application by Selenium Webdriver.
• Reviewed the Test Cases prepared by other team members.
• Published Test Summary Reports on the basis of testing result.
• Involved in build and Release processes.
• Conducted Review Meetings with Business analyst and within the Team.
• Responsible for coordination between development team and testing team.
• Reported bug using the bug tracking tool.
• Involved in testing the Production Releases.
• Prepared the release notes for the known limitation of the project delivered.
• Worked on Source control, data collection, reporting and project tracking using TFS.