SUMMARY:

• Senior SAP BW HANA Consultant over 11 years of experience in SAP BI/BW with ABAP, HANA with SQL scripting and SAP BOBJ has Full Life Cycle Implementation experience. Excellent team player and can thrive in challenging situations. Able to think critically, multitask and work under tight deadlines and rapidly changing priorities.
• Strong experience in both back end data modeling (SAP BI/BW) and front end reporting (BOBJ 4.0/BEx)
• Experience in working in BW upgrade project from BI 7.0 to 7.3 and resolving post upgrade issues.
• Experience in collecting business requirement and converting them into Functional specifications and Technical specifications.
• Experience with migrating BW solutions into SAP HANA Modeling solutions
• Strong experience in migration of SAP BEx (BW 3.x/7.x) reports into BOBJ 4.0 with no impact to user reports.
• Expert in creating Data models on SAP BW info providers as well as BO Universes for end user reporting.
• Worked on a large data migration (more than 1.5 billion sales records) into SAP BW from legacy system. Independently handled resolving migration issues/challenges, documentation, testing and co - ordination with various teams.
• Experience in extracting data from both SAP source system and Non SAP source systems (Ex: Flat Files, BODS)
• Worked extensively in Manufacturing and Retail domains.
• Strong interpersonal and communication skills. Ability to work independently and as a team. Very comfortable interacting with customers and technical teams. Strong analytical & problem solving skills.
• Involved in Project Kick-off, Release Management & Status meetings to discuss testing status, configuration management, deadlines and all QA related aspects
• Strong Experience in Production Support Model like working closely with the Business and resolving the issues based on user’s priority and adding Enhancements into the existing system by analyzing the business requirements.

AREAS OF EXPERTISE:

SAP BW/BI Technical Skills:

• Experience in creation and enhancing BW Data modelling objects info objects, DSO’s, Data sources, Transformations, APD’s, Open Hub Destinations.
• Working experience in creation of ABAP Workbench objects i.e. Tables, views, Function Modules/Groups, Programs, cloned extractors and table maintenance activities.
• Experience in writing ABAP routines for BW transformations in Start Routines, End Routines and Expert Routines.
• Strong experience in working with process chains and automation of data loading activities from SAP and Non SAP source system and scheduling and availability of data as per business reporting SLA’s.
• Experience in creation of master data objects with Attributes, Texts and Hierarchies and extraction of data from various sources systems.
• Worked on conversion/migration of BW 3.x objects (Data Sources, Info Sources, Transfer Rules and Update Rules) into 7.x objects
• Experience in creation of new/enhance the function modules, programs, customer-exits and data sources using ABAP. Debug the ABAP routines to find out the root cause and fix the issues.
• BI Reporting & Analysis - Ad-hoc Queries, Query Designer, Bex Analyzer and built Data Models using Multi-Dimensional Modeling (MDM)
• Information/BEx Broadcaster: Saved Queries and workbooks broadcasted to users in scheduled/adhoc basis. Also broadcasted using intelligently by automating through BATCH in Excel/Portal into Emails daily.
• Strong Experience with BEx Query designer and WAD tools -- creation of Confidential ’s, Confidential ’s, variables and customer exits.
• BW Operations - Data load management, Job scheduling, Loading (Full /Delta Up-Load), Process Chain Monitoring, Data Reconciliation, APD & Open Hub Destination Services.
• Used various performance improvement operations and options in SAP BW to monitor daily statistics of the data loads and implement corrections in objects by using t-codes RSRV, RSRTRACE, DB02, ST22, SM12 and ST04.
• Strong experience with creation of HR module BW modelling using standard SAP business content and customization.
• Strong experience with Sales and Distribution module in SAP into BW. End-to-End SD implementation and enhancement and production support experience (Sales Order, Billing and Delivery - Headers, Lines and Conditions).
• Reconciliation of data between Source systems to BW data and within BW info areas regularly to resolve data mismatch issues.
• Very good experience with SCM (Supply Chain Management) extractors in 02, 03, 08, 11, 13 and data extraction steps during cutover.
• Strong Experience with - SAP FI modules such as Funds Management, AP, AR and GL. Data extractions from ECC. Create Generic Extractors based on FI module base Tables, Views & Function Modules.
• Involved in developing objects, info providers and data flows for SRM module in SAP BI 7.0/7.3
• Experience with controlling (CO) extractors such as Product Cost, General Cost and Actual Cost. Experience in creation of new data modeling objects, reports and enhancing the existing objects as per business needs.
• Performance Tuning - Data load and Query performance by maintaining Aggregates, Compression, Partition, Indexing of Infocubes, Number Range Buffering, OLAP Cache Monitoring and use of BW Statistics.
• Experience in building complex Bex queries and user exit variables.
• Strong experience in SAP Production support and Enhancements, coordinating business requirements and offshore team leading capabilities.
• Strong experience in Process chain monitoring and database sizing activities PSA, Change log maintenance activities.
• Experience with Month close activities with business users.
• BW Transports - Transport strategy, Object Collection & Transports Movements across Landscapes
• BW Security - Security Role Matrix Requirement Gathering & Analysis, User Profile Maintenance & Testing
• Followed & Implemented ASAP methodology, creating Functional, Technical specifications.
• Involved in POC and COE activities at Infosys for SAP BOBJ 4.0 BOBJ Data services (BODS).

SAP BOBJ 4.0/4.2:

• SAP Business Objects 4.1/3.1/XI R2 (UDT, IDT Designer, Info view, CMC, Web Intelligence, Designer, Universe Builder, Import Wizard, Publishing Wizard, Life Cycle Manager, Promotion Management.
• Experience in creating new universes and enhancing existing universes using Universe Design Tool (UDT) and Information Design Tool (IDT)
• Create, Modify and improve performance of Web Intelligence Reports using underlined Universe or BEx queries
• Support Business users on trouble shooting various production issues with Universes and Webi reports
• Migration of BIAR files to Production Environments by performing Developments and Collecting Test Results.

SAP HANA Technical Skills:

• Creating SAP HANA complex information models using Packages, Attribute Views, Analytic Views, and Calculation Views with graphical and script based methods, using SQL, SQL Script, and CE Functions as needed. Experience with Field Based Modeling and Join Columns.
• Best practice on LSA++ architecture with BW 7.5 on HANA and HANA Studio using Open ODS Views, Smart Data Access, Transient, Virtual, Advanced DSO’s and Composite Providers
• Working in SAP HANA Data Provisioning using SAP LT Replication Server (SLT), Smart Data Integrator (SDI)
• Awareness of SAP HANA Data Provisioning using SAP BOBJ Data Services 4.0(BODS)
• Working knowledge in develop calculated attributes, calculated measures, restricted measures, calculated columns, filters, hierarchies, variables, input parameters to meet business requirements using SAP HANA IMCE studio.
• SAP HANA Administration including managing schemas, data model objects, import/export content.
• SQL scripts for Joins, Stored Procedures and Functions
• Creating HANA models on various SAP modules FI (GL, AP, AR & CO) and Supply Chain (SD, MM & PP)
• Knowledge with SAP HANA Security including User Management, Roles and Privileges

Project Management:

• Vast experience in executing, leading Production support projects in SLA models.
• Building new SLA models and strategic meetings with business partners.
• Experience in mentoring teams at onsite and offshore.
• Experience in managing all stakeholders like upstream / downstream business partners, offshore, onsite, business and Client technology teams.
• Responsible for Resource planning, estimation and pipeline projects prioritization.
• Good knowledge and exposure to client presentations.

TECHNICAL SKILLS:

ERP: SAP R/3, ECC 5.0/6.0 with SD, MM, FI, CO, PP, HR, IS-Retail, BW, APO Modules.

HANA: HANA LIVE, SLT, Analytic views, Attribute views, Calculation views, VDM, security, SQL Scripts, Lumira, HANA XS

Net weaver: BI 7.X (LO Cockpit/ FI / IP/ BPC / Retail/CAR). XI 3.0, PI 7.0/7.1ABAP /4 Skills ALV, OOABAP, SAP Script, Smart forms, Adobe print forms, Data Dictionary,ReportsDialogue programming, Web dynpro.

SAP Interfaces: RFC, BAPI, ALE, IDOCs, EDI, BDC, LSMW and Workflow, Data stage.

Business objects: BO XI R3/R4, Crystal Reports, Web intelligence, Live Office, Xcelsius, Dashboard, and Fiori

Languages: ABAP/4, PL/SQL, C, C++, VB and JAVA.

RDBMS: Oracle 7.x/8x, MS Access.

Office Tools: MS Excel, MS Word.

Operating System: Windows NT/XX, UNIX, LINUX.

Non SAP tools: Tableau, Data stage, Informatica.

PROFESSIONAL EXPERIENCE:

Confidential, Glendale, CA

Sr. SAP BI/BW/HANA/BOBJ Technical Analyst

Responsibilities:

• Involved independently designing the requirements and handled the developments end to end
• Worked on very large data migration (more than 1.5 billion records) into SAP BW from legacy system. Independently handled resolving migration issues/challenges, documentation and co-ordination with various teams.
• Working closely with senior Architects and Business Analysts to finalize the new requirements
• Working on complete End-to-End developments in both back end (BW Data modelling and ABAP) and front end (BOBJ report design).
• Prepare design documents, Functional and technical specification documents.
• Responsible for performing unit testing, regression testing and performance testing. Prepare a document for level of testing
• Involved in creating new universes and enhance the existing using Universe Design Tool in BOBJ 3.x/4.x
• Experience in implementing/enhancing in SAP BW/BOBJ for new business adaption
• Efficiently handled resolving system performance issues (fixing ABAP routines) that were implemented and make sure system batch jobs runs smooth and achieve the daily SLA’s.
• Responsible for resolving issues during transport migration
• Responsible for performing cutover activities after migrating the development objects to production system
• Responsible for coordinating with support team for giving knowledge transfer on the new developments

Technical Involvement: SAP BW 7.3/7.5, BW on HANA, and SAP BOBJ 3.x/4.x

Confidential, Milwaukee, WI

Sr. SAP BI/BW Consultant

Responsibilities:

• Involved in gathering the business requirements and closely work with business users to finalize requirements and provide the long-term solutions.
• Involved in creating functional specifications and Technical specifications for the new requirements
• Involved in design, build, testing and documentation on the new business requirements
• Involved in critical upgrade project of BW system from SAP BI 7.0 to SAP BI 7.3 and responsible for solving all technical and functional issues during the upgrade.
• Responsible for resolving production support issues and Data load monitoring issues
• Responsible for all type of testing and fix the issues during system refresh
• Working with business on month end reports and help them on month closure activities
• Co-ordinate with operations team for any changes in existing job schedule and creation of new jobs scheduling in BI process chains
• Working with Architect team on any system refresh activities, upgrade activities and provide regular system statistics.

Confidential, Dallas, TX

Sr. SAP BI/BW Consultant

Responsibilities:

• Interacted with various internal business users & stakeholders to implement BW/BoBJ reporting projects from initial scope definition through analysis, design, implementation and On-going support
• Provided program and project management support for several BW releases
• Managing Integration issues & Features Supported/Not supported between SAP BW/Bex & SAP BOBJ 4.0
• Responsible for end-to-end Projects and support functions.
• Involved in Business Blueprinting, Gap Analysis, Solution Designing, Data Modeling, ETL, Report Designing and Development, Production Deployment/Support and End-User Training
• Analyzed, Created & Reviewed Transport strategy during Cut-over activities & communicated the same with SAP Basis Team
• Experience in working and extracting BPC data to BW and perform data reconciliation during month end.
• Experience in building/ maintaining custom extractors, user exit variables, start/end routines.
• Worked SAP Security team & Business to identify Security Matrix for Reports & LSO Self Service Environment.
• Planning for Nightly data loads for any new Module implemented and working on various performance initiatives to reduce loading time for timely data availability.
• Worked with Production Support team for performance Improvements of loads/Reports by creating Aggregates, Indexes for lookup & parallel processing of loads
• Worked on various minor and major enhancements projects for existing BW Reports across modules like HR - LSO, HR - ERC, HR - PA, HR - OM, HR- PD, HR - Benefits, HR- Payroll, FI - AP, FI - AR & FI - GL.
• Experience in improving query performance using Query Cache, RSRT debug and defining aggregates.
• Working with Confidential for Bex reporting.
• Experience in debugging issues on IDOCs and daily loads failures.
• Build Info Objects, Info Sources, Data Sources, PSA, InfoCubes (Multidimensional, BW Star schema), Multi Providers, Data Store Objects (DSO), APDs, Info Packages, Transformations (BI 7.0), DTP - Data Transfer Process, Aggregates & Open Hub Destination.

Technologies and Tools: SAP BI 7.0, SAP BOBJ 4.0, and Atos Service desk tool.

Confidential

SAP BI/BW Developer

Responsibilities:

• Developing Infoobjects, DSO, Infocubes, Multiproviders and Bex queries using Query Designer
• Creating Meta data repository for all queries by megaspores/areas and acted as a QA control.
• Experience in designing DTP’s and Transformation.
• Created several ABAP user exits for BEx reporting purposes.
• Experience in working with HR module extractors. Enhancing the standard extractors to leverage the business requirements.
• Extracted data for various data sources FI-GL, FI-AP, and FI-AR data from R/3 to BI.
• Used the extractors 0FI GL 14, 0FI GL 10, 0FI AP 4 and Custom data sources for the above DataSources.
• Extracted the GL data onto the open hub interfaces which the business uses.
• Extracted data for CB-COPA from R/3 to BI
• Responsible for Onsite/off-shore Coordination, preparation of detail design, code walkthrough, resolving technical and design issues and performing independent unit testing
• Preparation of Technical and Functional Spec documentation
• Process chains monitoring and resolving issues and developing complex Excel formulas based Bex workbooks.
• Handling Quarterly and Monthly maintenance activities and communication with business users.
• Integration and regression testing of all defects moving to production.
• Created Analytics on top of Metrics for the Performance Manager.
• Created Single Sign-On for many reports using the URL functionality to access them directly.
• Created Analytic Dashboards for upscale users on the Financial Actual Budget and Target Budget.
• Used the Broadcast Agent Server to Schedule and Monitor the Reports.
• Audit reporting system implementation on UAT and Production Environments.
• Estimation for end-to-end reporting requirements and Data Modeling.
• Participating in all the Data Modeling. and Design Discussions to proceed for the Tech Spec.
• Resolving Complex Tickets, resolving with SLA.
• Preparation of Unit test cases and Integration testing
• Handling batch Monitoring issues and resolution of Production batch issues from the report front.
• Communication with multiple stake holders, to ensure the production system functions smoothly and the system is up before the users business hours.
• Collection of stats and Daily reports to client on the performance and suggesting the batch performance improvements and supporting month /year end SAP BI activities.
• Handling all small enhancements, migration and architectural aspects of the project.
• Responsible for Version control of code and documentation
• Handling Client calls, users requirements, building Functional and Technical specs.

Technologies and Tools: SAP BI 7.0, BEx Analyzer/Query Designer and WAD.

Confidential

SAP BI/BW Developer

Responsibilities:

• Providing support to the system during Indian time zone and handle level 2 and level 3 tickets
• Ensure that all the schedule jobs runs smoothly during designated time
• Proactively fix the issues on time if any issues occurred during schedule time
• Work on bug fixes and analyze, take a corrective action and implement change in production system
• Create new data flows using process chains and schedule them
• Creation of new data modeling objects i.e. Info cubes, DSO’s, Info objects, Multiproviders and BEx queries

Technologies and Tools: SAP BI 7.0, BEx Analyzer/Query Designer and WAD.

Confidential

Associate SAP BI/BW Developer

Responsibilities:

• Provide Business Level 2 Support based on ticketing system
• Responsible for implementing system change enhancements and Bug Fixing
• Creation of new SAP BW objects and process chains.
• Creation of reports in BEx query designer and WAD.
• Publish the Reports on Share Point Portal in a centralized portal where all business users/management access on a daily basis
• Maintenance of a data warehouse, working with ETL and Analysis tools
• Debugging critical data related and report related issues
• Enhancements and Bug Fixing on the existing system
• Responsible for Design Changes that are given as part of new business requirement by client

Technologies and Tools: SAP BI 7.0, BEx Analyzer/Query Designer and WAD.

Confidential

Associate Developer

Responsibilities:

• Provide Business Level 2 Support based on ticketing system
• Responsible for implementing system change enhancements and Bug Fixing
• Creation of MS OLAP Cubes and Data flows.
• Creation of reports in Reporting services tool.
• Publish the Reports on Share Point Portal in a centralized portal where all business users/management access on a daily basis

Technologies and Tools: Microsoft SQL Server 2000 with MS Analysis Services, MS Office 2003 & VBA Macros