SUMMARY

• Skilled in full life - cycle implementation of various versions of SAP viz. SAP R/3, ECC6.0, SAPBI, SAP BW 4.0, WebI Rich Client, Xcelcius, SAP R/3+SAP BW, SAP BASIS, SAP Security, SAP BI and SAP Business Processes (Order to Cash, Procure to Pay and Production Planning & Control), SAP BW 4.1
• Experience in developing data models in HANA 1.0 SP2
• Hands on experience on PL SQL
• Strong understanding of OLAP, In-memory methodology
• Expertise in the front end business warehouse components like BEX analyzer, Query designer, Universe,Web Application Designer, Web Reports, WEBI, XCelsius (Dash Boards)
• Extensively used Business Objects reporting functionalities such as MasterDetail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks
• Sound understanding of full SAP BW / BI Solution Design & Development from business requirements analysis stage to architecture design including development, assessment of existing SAP BW / BI implementations, and providing advice on structural improvements in the areas of performance, usability, architecture, processes and organization.
• Proficient in working on SAP BW/BI components and ETL Process like creating Info Cubes, Multi Providers, Remote Cubes, Transactional Cubes, Data Marts, Info Source, Info Package, Data Source, Info Objects, ODS (DSO), Update Rules, Routines, Transfer Rules, Process Chains and Event Management for Automation Process, Transformations in BI 2004s
• Knowledge in BW Accelerators, Star Schema, Extended star schema, Dimensional and Fact tables.
• Experience in the OLTP extraction of data of SAP LO-Cockpit, MM,generic extractions, Enhancements and extraction from flat files, non-SAP systems and DB connect.
• Expertise in the front end business warehouse components like BEX analyzer, Query designer, Universe,Web Application Designer, Web Reports, WEBI, XCelsius (Dash Boards), Analysis for Office.
• Good Knowledge in SAP HANA data modeling using Attribute View, Analytic View and Calculation View.
• Good knowledge in Direct Extractor Connections.
• Exposure to Data Lake concept(Big Data)
• Exposure to SAP BW Integrated Planning(IP) and fox programming in IP
• Strong experience in the integration ofBODSwithSAP modulesandNon-SAP data sources.
• Strong experience in usingBODSas an external system for ETL betweenECCandBI
• Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.
• Experience in HANA Side Car approach.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Have good hands on experience in ETL and Data Cleansing applications using Infomatica Power Center, Oracle Warehouse Builder, Data services/ BODI, and PL/SQL
• Experience with SDI/SDA and ETL process using Data Services
• Ability to work directly with business analysts to translate functional design into technical specifications. Excellent client interface skills as a trusted advisor while leading an implementation team through all the phases of project delivery and maintaining constant alignment of the solution to changing business needs
• Strong leader and a team player with strong analytical, problem solving, interpersonal skills resulting in on-time and on - budget delivery.
• Exposure to BPS on BW
• Involved in data extraction and conversion between BPC and non-ERP systems with extractors and ETL tools.
• Developed custom Process chains to support master data and transaction data loads from BI to BPC.
• Created Package links to bundle more than one packages and to run sequentially.
• Used Modeling functions such as Spread, Trend and weight to distribute the allocation to base members.

AREAS OF EXPERTISE

• Queries, Calculation & Restriction of Key Figures, Structures, Variables, Exceptions, Conditions, Crystal Reports, Authorizations, User Profile Maintenance, BEx Analyzer, Info Set Query, RRI, Web Reporting and Workbooks
• Extracting Data from SAP R3/ECC, non-SAP systems and flat files
• OLAP reporting in BW and implementation of BEx Analyzer
• Development of reports, analysis and Web reporting using BEx Query Designer & BEx Analyzer
• SAP Installation, SAP Web Dispatcher, SAP Router Configuration, Transport Management System Configuration
• SAP Implementation, SAP SD, SAP MM, SAP PP Integration for Business Processes
• Mapping of As Is-To Be system requirements for SAP MM up gradation from SAP R/3 4.7 to ECC 6.0
• End to end functions on SAP R/3 systems for e.g. role building, configurations, role maintenance, security for new production releases, user creation and troubleshooting
• Working with external interfaces e.g. Legacy System Migration, etc.
• Central User Administration and SAP Net Weaver for User Management
• Use of Linux platform for troubleshooting to enhance the efficiency of the client pipeline and ensured end-to-end connectivity of the data packets
• Creation of Aggregation Levels, Planning Filters, Planning functions, Planning Sequences, Data Slices, Characteristic Relationships using Integrated Planning
• Planning Functions using Fox programming to process plan/Actual data based on the requirements
• Debugging Data load errors, Delta Queue Monitoring, and Extractor Checker by simulating BW asking for data and Customer Exits, Master/Transaction Data Testing
• Extracting data from SAP R3/ECC, non-SAP systems, and flat files
• OLAP reporting in BW and implementation of BEx Analyzer (Worked with BEx Query Designer, BEx Analyzer for developing reports, analysis, and Web reporting).
• Experience in OLAP functionalities like Scope of Analysis, Drill Analysis and Slice & Dice
• Experienced in Business Objects Universe Designing, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view, CMC and Business Objects Enterprise and Xcelcius Internships

TECHNICAL SKILLS

SAP BW Versions: 7.3/7.0/3.5/3.0/2.1 C.

SAP R/3 Versions: ECC 6.0, 4.6; SAP CRM Versions 6.0. ; SAP SRM Versions 6.0.

SAP Business Objects: Business Objects Web Intelligence 4.0, Dashboards 4.0/ Xcelsius. BI 4.1

BW reporting: BEX Analyzer (3.x, 7.0, 7.3), Query Designer (3.x, 7.0, 7.3), WAD (3.x and 7.0) and SAP Portal.

ERP Packages: SAP SD, MM, PP, QM, PM FI/CO, HR and CRM and SRM modules

Operating Systems: Windows 7.0/Vista/XP,UNIX. Databases Oracle 9.i/8.i.

PROFESSIONAL EXPERIENCE

Confidential - Gastonia, NC

Responsibilities:

• Data migration using SAP BW.
• Converting tables from BAAN into ECC usable sap format tables using BW 7.5 on HANA
• Used advanced DSO’s and open DSO as infoproviders.
• Experience with DB Connect to BAAN and data extraction from BAAN into PSA of BW.
• Experience with using Generic data extraction(RS02) from ECC and loading data in BW.
• Data extraction from .csv and .XLS files and loading into data store objects.

Confidential - Manchester, Michigan

SAP BI Analyst

Responsibilities:

• Designing, configuring, implementing & supporting complex SAP’s BW solutions, front-end to back-end; designing, implementing & supporting complex extraction, transformation and loading of SAP BW Data. Designing and developing reports using BW.
• SAP BI 7.0 & 7.3 Data Extraction: Experienced in Data Extraction from SAP R/3 using LO-Cockpit extraction structures and other extraction structure.
• Creation of Generic Datasource using Tables/Views, Functional modules and customizing the Business content Datasource through User Exit in SAP R/3 and ECC6.0.
• Data provisioning using SAP BODS to load data into HANA from a Confidential server environment
• Extended the Business Content Data sources using Enhancements and populated the appended fields using User Exits. Created custom Info Source/Data Source, ODS, and Info Cubes for Data extraction, transformation and loading from SAP R/3 system to SAP BW
• Designed customized data sources in ECC based upon the user inputs.
• Creating BO Webi reports, BOBJ universes on top of HANA views using IDT
• Creating reports using Analysis for office.
• Configuring universes using IDT for salesforce based queries
• Maintaining and ensuring process chains run smoothly.
• Strong understanding of data integration mainly with SAP HANA area and data provisioning using SDI/SDQ
• HANA modelling using analytical and attribute views.

Confidential - Boston, MA

Responsibilities:

• Designing, configuring, implementing & supporting complex SAP’s BW solutions, front-end to back-end; designing, implementing & supporting complex extraction, transformation and loading of SAP BW Data. Designing and developing reports using BW 7.4 with HANA as database
• Developed analytical, attribute and calculation views using SAP HANA.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Enhancement of existing reports, report testing and validation.
• Creating BO Webi reports, BOBJ universes on top of HANA views using IDT
• Creating reports using Analysis for office.
• Developed analytical, attribute and calculation views using SAP HANA
• Developed financial, order to cash and inventory based reports in HANA and created the universe and webi reports on top.
• Data provisioning into HANA importing tables using SLT replication and importing BW cubes as analytical views using the import mechanism.
• Designed a SQL script procedure to calculate variance for the balance sheet report.
• Translating business requirements into technical design documents and assisting the functional team in designing functional documents.
• Designing user manuals assisting the business users to do HANA view enhancement as per Confidential (client) process guidelines

Confidential

Freelance SAP BW/BO Consultant

Responsibilities:

• Designing, configuring, implementing & supporting complex SAP’s BW solutions, front-end to back-end; designing, implementing & supporting complex extraction, transformation and loading of SAP BW Data. Designing and developing reports using BW 3.5 and 7.0 with HANA as database
• Developed analytical, attribute and calculation views using SAP HANA.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Loading data via BODS

Confidential

Senior SAP BW/BO Consultant

Responsibilities:

• Working with Senior Management and Business Users to define goals, scope and deliverables resulting in an approved project plan. Regular client communication of progress and risk.
• Leading all phases of the project life cycle including analysis, design, development, testing, deployment and post-production support/maintenance. Track deliverables and manage project risk.
• Developing technical architecture and high level design for development projects; creating and managing technical documentation including unit, integration & acceptance test plans, support documentation and end user documentation; ensuring adherence to and enforce day-to-day support policies and service level expectations.
• Designing, configuring, implementing & supporting complex SAP’s BW solutions, front-end to back-end; designing, implementing & supporting complex extraction, transformation and loading of SAP BW Data. Designing and developing reports using BW.
• Implementing objects as per the front-end and back-end design documents, data loading and building queries based on various InfoProvider using filters, restricted key figures, exceptions, variables & structures and RRI
• Installation and deployment of Business content objects, LO extraction, Generic extraction and customization and enhancement of the extract structure to support business needs
• Managing technical implementation of SAP systems entailing mapping of business requirements (As-Is & To-Be Analysis) and track and manage changes
• Handling all Support Issues, Transport Requests, Defects, and Release Management; participating in client meetings, conference calls and discussions; chairing/leading multiple client level meetings; updating and maintaining the Project Schedules and deliverables.
• Planning, scheduling, reviewing and implementing changes on remedy adhering to Change Management Process; administering User Creation, Deletion, Locking/Unlocking and Authentication; checking the missing authorizations, roles and maintaining profile

Confidential

Business Analyst for SAP BW

Responsibilities:

• Worked closely with stakeholders to analyze business requirements, and define target SAP BI/BW solution architecture and associated technical specifications & implementation plan.
• Designed analytical and attribute views on monsoon data in HANA Modeler to enable MCGM to forecast monsoon patterns and develop contingency plans.
• Assisted SAP Basis in data provisioning into HANA system using SLT server.
• Performed analysis and design; wrote technical specifications; configuration and programming in the SAP/BI environment, including testing and implementation.
• Built and enhanced BI objects such as Info Objects, Info Cubes, Info Sources/Data Sources, Master Data, Transformations, DSO,, Process Chains
• Delivered data models to extract data from SAP ECC and development of ABAP objects with SAP BW.
• Responsible for programming, testing, debugging, and documenting highly complex ETL applications using SAP BW and ABAP routines/transformations.
• Understood business requirements, determined implementation strategy and translated into reports that conform to reporting best practices and standards.
• Developed unit, integration, and performance test plans.
• Worked on user management, security roles and user profile management.
• Effectively presented information in the form of formal presentations and regular status to management and business partners.
• Organized training sessions with the stakeholders.
• Responsible for performing many phases of the software development lifecycle including technical research, requirements analysis, high level and technical design, unit testing and deployment using Business Objects, Crystal Report in Window/Oracle Database environment.

Confidential

SAP Business Objects Developer

Responsibilities:

• Designed universes against the different database, defining the necessary connections and Exported them to specified universe domains
• Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documents them textually or within model.
• Created standard and Ad hoc reports using Business Objects functionality's like Slice and Dice, Templates, Drill Down, @Functions, Cross Tab, Master Detail and Formula's, Breaks and Custom Sorts in reporting
• Created dashboards using Xcelcius
• Responsible for creating the reports (On demand, Ad-hoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab, graphical, etc) on Web Intelligence tool

Confidential

SAP BW Developer

Responsibilities:

• Collaborate proactively with various stakeholders to gather requirements in order to recommend and develop solutions.
• Responsible for programming, testing, debugging, and documenting highly complex ETL applications using SAP BW and ABAP routines/transformations.
• Data modeling on SAP BW 7.x LIS Extractors - SD, PP, MM, PM, COPA Extractors.
• Delivered data models using BW data modeling tools and developed Info cubes, DSOs, Multiproviders, Info sets.
• Experience on IP
• Responsible for designing, leading and implementing metrics and KPI dashboard solutions using WEBI/XCELCIUS.
• Understand business requirements, determine implementation strategy and translate into reports that conform to reporting best practices and standards.
• Worked on SAP Business Objects 4.0 (Universe Designer/IDT, Dashboard designer, QAAWS, BIWS, WEBI Rich Client, Import Wizard, CMC, Info view etc.) and SAP BW Environments.

Confidential

SAP BW Developer

Responsibilities:

• Responsible for designing, leading and implementing Reporting solutions.
• Responsible for BW architecture and data modelling, i.e designed data models for BI Info Cubes, DSO objects, and Multiproviders. Designed custom Data sources, Info Sources and Data targets.
• Implementation of SAP BW LO modules - LIS Extractors using ETL process.
• Implementation of SAP BW Financial Accounting, COPA - AP, AR, GL and SL
• Collaborate proactively with various stakeholders and brand managers to gather requirements in order to recommend and develop solutions.
• Implemented and delivered enhancements to extractors using the ETL routines. Configured SAP Business Warehouse to best support business requirements
• Studied the Processes, Data flow, Work flow, Control Procedures, and reporting aspects of the existing systems in order to do Business Process Reengineering.
• Drilldown Analysis Requirements and Dash Board analysis of BW reports, publishing of the Web reports Defining Data Sources for Generic Data Extraction creation and designing Business and Technical specifications.
• Executed and integrated system unit testing to validate that the business requirements are met by the SAP system; documents unit testing results
• 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.
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing. Tuned queries using Partitioning, Aggregates and Multiproviders.

Confidential

Assistant Manager

Responsibilities:

• Assisted in Purchasing for Global Purchasing and supply chain department with Confidential
• Acted as Client facing contact for SAP BW 7.0 Implementation with the implementation vendor.
• Interaction with the end users during the requirement gathering phase and preparation of test cases for report testing and development scenarios.
• Extensively worked on Query Designer and Web application designer to create Queries to forecast accounts payables, supply chain and Materials management using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.

Confidential

Intern

Responsibilities:

• Worked on Oracle UPK, to document the business processes.
• Got exposure to Oracle apps procure to pay as well as order to cash business processes.