SUMMARY

• 8 years of experience in SAP BW/BI
• 4 years of experience in Business Objects XI 3.1
• 1.5 years of experience in SAP HANA 1.0 SP6
• Good knowledge on ASAP methodologies
• Worked extensively on Administrator Workbench (AWB), BEx Analyzer
• Expertise in creating and maintaining Info Cubes, Data Store Objects, Info Objects, Info Areas, Multi providers, Info Sources, Data Sources, Virtual cubes and Infosets
• Proficient in ETL mechanism involving Datasource, Infosource, Communication structure, Transfer Structures, Extract Structures, Transfer Rules, Update Rules, Transformations and Routines
• Data loading was monitored and failed data packets were analyzed and if possible manually edited in PSA and reloaded to Data targets
• Data Extracting from the Source system using LO Cockpit and Generic Extractions for all the logistics data
• Experience in Info Cube maintenance i.e., Compression, Roll - up for Aggregates
• Complete automation of all BI Daily, Weekly and monthly loads (Info package Scheduling) using Process Chain
• Providing daily Production Support for both Offshore and Onshore projects
• Involved in monitoring of process chains
• Worked on Data Provisioning tools for SAP HANA like BODS
• Good experience in SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views
• Expertise in Report Generation - Extensively worked in BEx Analyzer in building Queries and saving in Workbooks (Excel work sheets) and created Custom Queries using Conditions, Exceptions, Variables & Structures and created aggregates for frequently used queries
• Created aggregates to improve the query performance
• Experience in creating and managing OLAP Universes based on SAP BW Data sources (Cubes and Queries). Knowledgeable on Relational Universes
• Experience in creating Web Intelligence Reports
• Experience in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau
• Created Dash Board reports using Xcelsius for Sales Forecasting and AP data
• Lead a team of 12 through development, quality and production phase.
• Knowledge of Informatica Power Center
• Maintain list of all the activities for all the tickets until it is closed down
• Excellent interpersonal & Communication skills to work cross functionally with other Enterprise team members and ensure all applications & reporting solutions are clearly integrated and synchronized

TECHNICAL SKILLS

Business Warehouse: SAP BI 7.3,7.0, 3.5, 3.1C, 3.0B

Business Objects: BOXI3.1/4.0

SAP HANA: SAP HANA 1.0 SP6, BODS (Data Services), SAP HANA Studio

ERP: ECC 6.0, SAP R/3 4.7/4.6C/4.6B/4.0B

Reporting: Bex Query Builder, Advance Analysis, BEx Analyzer, BEx Web Analyser, DESKI, WEBI, Xcelsius 2008, Lumira and Crystal Reports

Databases: Oracle, MS-Access, DB2

Languages: PL/SQL, ABAP/4, C++, C

Operating Systems: Unix, Windows 95/98/NT/200

Others: MS-Office

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto, CA

Sr. SAP BI Consultant

Environment: SAP BI 7.3, ECC 6, BO 4.0

Responsibilities:

• Being a Senior BI Consultant, responsible for the development, support & maintenance of SAP BI/BW version 7.3 connected to ECC 6.0 system with SAP SD and MM Module
• Responsible for analysis, design and development of SAP BW backend components and front end reports and dashboards
• Worked as BI/BO Consultant and gathered requirements and deliverables for report requirements along with functional end users in the business areas
• Build and enhance BI objects such as Info objects, Info cubes, Info sources/Data sources, Master Data, Transformations and Update Rules, ODS, Extractors, Info sets, Aggregates, Process Chains, User Exits
• Developed Info sources and written several routines in Update and transfer rules
• Designed and developed process chains (RSPC) for master data loads and transactional data loads with the help of info packages and scheduling process chains periodically
• Interact with business to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/training for BW Reporting and applications
• Created several Calculated Key figures, Restricted Key Figures, structures, variables to enhance the reporting features.
• Implemented conditions and restrictions in the reports based on the requirements. Used Hierarchies in the reporting to provide drill down features
• Designed Tableau reports and Dashboards design
• Worked on Crystal Reports designer to develop formatted reports and web reports
• Involved in developing front-end queries using Query Designer and Web Application Designer and publishing results on the web
• Develop and drive the implementation of BW best practices and standards for the team
• Support the on boarding and training of BW Power Users
• Conducted Workshops with General Managers and SME’s for requirement gathering
• Used SAP BO Data Services to fetch the data into SAP HANA DB
• Implemented SAP HANA Artifacts (Analytic and Calculation View) for the project
• Developed SAP BO Dashboard and WebI report as per the user requirements

Confidential

SAP BI Business Analyst/Consultant

Environment: SAP BI 7.0, SAP BW 3.5, ECC 6

Responsibilities:

• As a Business Analyst performed gap analysis on business requirements, design documents, based on release and functional requirements
• Extensively worked in Production support by monitoring Daily/Weekly/Monthly data loads into the BI system from different source systems
• Implemented and automated quoting and pricing procedures eliminating manual pricing and reducing pricing disputes
• Organized, directed and executed pricing agreement validated program. Created queries and test scenarios to expedite agreement validating of pricing agreement through various management levels
• Developed WebI and Dashboard reports as per the user (Product Managers, State Managers & Area Managers) requirements
• Modified existing Crystal reports and created new reports with cross tabs and sub reports based on the client requirements using Crystal Reports 2008
• Developed End User and Super User training manuals, job aids and presentations
• Managed Project timeline and milestones for the team and ensured workflow efficiencies. Never missed a project deadline

Confidential, Northbrook, IL

SAP BI/BO Consultant

Environment: SAP BI 7.0, SAP BW 3.5, SAP R/3 4.6/7

Responsibilities:

• Improved query performance by creating Aggregates, secondary Index, Partition Info cube
• Worked on Data modeling, Extraction from R/3 Data sources, flat file
• Worked on the Process Chain to automate the Info package scheduling for Master data, Text, Hierarchy & Transaction Data
• Modified existing universes and implemented new universes according to the reporting needs by detecting cardinalities, resolving traps and using contexts and also developed hierarchies and derived tables
• Developed complex webi reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement
• Extensively worked BEx Analyze, Query Designer, BEx Browser and WAD
• Resolved Query Performance issues using transactions such as RSRT and RSRTRACE
• Used Structures, Calculated key figures, Restricted key figures, selection, Formula, exception and conditions
• Involved in tickets logging regarding extractions, Performance Issues and also load failures
• Support post-production maintenance functions and documentation

Confidential, Chicago, IL

SAP BW/BI Consultant

Environment: SAP BI 7.0, R/3 ECC 6.0

Responsibilities:

• Responsible for Interacting with the Customer, Understanding Customer business requirements, analysis, technical design, development and testing of various global templates
• Prepared the documentation on data flow design from two Legacy system, restriction and filter of data, Data Modeling, Unit Testing, User Training and Report Designing objects
• Created custom Data Sources/Info cubes/Info objects for accommodating the global data available across the organization
• Used LO Cockpit, Flat file and Generic extractions to retrieve SAP and Non-SAPA data for reporting in SD, MM, FI and PP modules and company’s legacy systems
• Extensively worked on Enhancements for populating the records to the newly added components in the Data Sources
• Involved in solving the issues raised by the End-users
• Performed filling up the aggregates to fill the summarized data from cubes to the aggregates, roll ups to fill the aggregates with the changed records and attribute change runs to realign the aggregates
• Developed custom delta extractor for Order Number
• Worked with Web Application Designer to create different templates
• Created Query for Technical Project Overview on Info cube
• Conducted study to build universe’s classes and objects involving everyday terms that supports users. Object properties defining measure, dimension and details were created
• Implemented universes by detecting cardinalities, resolving loops, Chasm Traps and Fan Traps using Contexts and Aliases etc and also developed Hierarchies to support users with the option to drill down on reports
• Involved in creation of Reports, formatting reports, generation of charts, bars etc as per user requirements using Webi, Xcelsius 2008
• Used Report Designer to publish the reports in portal

Confidential, Englewood Cliffs, NJ

SAP BW Consultant

Environment: SAP BW 3.5/BI 7.0, SAP 4.6, BEx Analyzer

Responsibilities:

• Analyzed data requirements and translated these requirements into dimensional data models using star-schema and extended star-schema data modeling techniques
• Responsible for design, development and extraction of data from ECC source system into BI from SD and MM using LO Cockpit extraction methods
• Extracted data from data sources like 2LIS 02 ITM, 2LIS 02 SCL and 2LIS 03 S194 and populated into the procurement info cubes 0PUR C07, 0PUR C08 and 0PUR C09 to evaluate service levels
• Performed LO Cockpit extraction to pull data from ECC SD modules into BI system extracting Header and Line item data from the Sales and Distribution (SD) module
• Created reports like confirmed quantity and item purchased orders as requested, complete purchase order quantities delivered and purchase order values
• Worked on BEx Analyzer, Browser and wad (Web Application Designer) tools to generate reports related to SD and MM

Confidential, St. Louis, MO

SAP BW Developer

Environment: SAP BW 3.5/BI 7.0, SAP 4.6

Responsibilities:

• Developed the dataflows based on the design documents
• Actively and regularly involved in Load monitoring of daily, weekly and monthly data loads using process chains and fixing the failures to complete loads in given time
• Actively involved in rectification of load failure errors like master data loads, transaction loads
• Customized and activation the Purchasing Data, Purchasing Groups and Inventory Management Info Cube
• Data Extractions using LIS extraction and OLTP/Generic data extraction for 2LIS 02 ITM and 2LIS 02 SCL
• Extraction using LIS, LO Execution Cockpit and V3 updates
• Used the variables in BEx Analyzer and published the reports and created web reports through report template in WAD (Web Application Designer)
• Created new queries with Variables, calculated Key Figures and Restricted Key Figures, exceptions, conditional formatting and modified existing BEx reports to improve performance
• Trained Client personnel for maintenance of above jobs

Confidential

SAP BW Developer

Environment: SAP BW 3.5, SAP 4.6

Responsibilities:

• Involved in data model designing
• Extracted data using LO Cockpit data sources related to SD and data loading from flat files
• Activation and Enhancement of Info objects, Info cubes, Data Store Objects (DSO), Transformations, DTP and Info packages based on the requirement documents
• Creation, Scheduling and maintenance of Process Chains
• Worked on the Report Generation, extensively in BEx Analyzer, Query Designer
• Created custom queries using Conditions, Variables, Structures and Calculated Key Figures

Confidential

SAP BW Developer

Environment: SAP BW 3.1, SAP 4.6

Responsibilities:

• Designing of data model as per the requirement
• Activation and enhancement of standard data sources for SD and MM
• Creation of Data Source for data loading from Flat files
• Activation and enhancement of DSO and Cubes
• Query designing using BEx Query Designer
• Transporting Query objects to production environment