SUMMARY

• A Master’s degree in Computer Sciences with 12 years of IT experience
• 8 years of extensive experience in SAP Business Intelligence
• 2 years of experience in Business Objects XI 3.1
• 1 years of experience in Business Intelligence 4.0
• 1 year of experience in Business Objects Data Services
• 4 years of experience on IBM mainframe technologies
• Was part of 2 full cycles of SAP BI implementations
• Good knowledge on ASAP methodologies
• Extensively worked on data modeling using BW extended star schema models
• Good working knowledge on exploring Business contents
• Expertise with content activation, custom enhancements, custom development of various info provides like Info cubes, DSO’s, Multi Providers, Infosets, Virtual cubes, master data bearing info objects
• Proficient in ETL mechanism involving Data source, Info source, Communication structure, Transfer Structures, Extract structures, Transfer Rules, Update Rules, Transformations and Routines
• Proficient in ABAP required to develop Custom Extractors, Transfer Rules, Update Rules, Transformations and Routines, Bex customer Exits
• Designed, created and implemented Data Integrator scripts, work flows, and data flows in SAP BO Data Services XI 3.2 (ETL).
• Exposure to Customer Specific generic extractors like CO - PA and LO Cockpit
• Worked on creating generic extractors using Views and Function modules with ABAB/4 customer exits
• Working knowledge on Full & Confidential loads, Info packages, DTP’s, Process chains, Load failures, Error Handling
• Proficient in uploading master data and transactional data both from flat files and SAP R/3 Systems.
• Proficient in providing BW data to 3rd party systems using Open Hub
• Knowledgeable on Data Archiving in SAP BW
• Proficient in APD’s
• Expertise with BW reporting using Advance Analysis, Bex Analyzer, Bex Explorer, Web Application Designer, and implementing Bex Queries, Calculated and Restricted Key figures, conditions and exceptions, Filters, Restricted Characteristics and various types of variables and their processing types.
• Performance tuning techniques like BW statistics, DB statistics, BI Accelerators, Indexes, Aggregates, Rollups, Compression, Reconstruction, Archiving, Partitioning
• Experience in creating and managing OLAP Universes based on SAP BW Data sources (Cubes and Queries).Also knowledgeable on Relational Universes
• Experience in creating Web Intelligence Reports
• Created Dash Board reports using Xcelsius for Sales Forecasting and AP data.
• Used Live Office connections to get the real time data to users.
• Extremely proficient in preparing Functional and Technical Specifications, End User Manuals, Test Cases and Scripts.
• Worked on OLAP Connections using IDT in BI4.0

TECHNICAL SKILLS

Business Intelligence: SAP BI 7.0, BW 3.5/3.1C/3.0B

Business Objects: BOXI3.1, OLAP & Relational Universe, Data Services, BI4.0

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

Reporting: Bex Query Builder, Report Designer, WAD, Advance Analysis, Bex Analyzer, Bex Web Analyzer, DESKI, WEBI, BO Xcelsius 2008 and Crystal Reports, QAAWS, Live Office, Dashboards in BI4.0

Databases: Oracle, MS-Access, DB2

Cross Applications: BAPI, ALE, RFC, EDI, IDOC

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

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

Others: MS-Office, HP ALM

PROFESSIONAL EXPERIENCE

Confidential, IL

SAP BI/BO Consultant

Environment: SAP BI 7.3 on Hana, ECC 6.0, Data Services 4.0

Responsibilities:

• Worked in Space Productivity project & POSDM data to Kronos interface Project
• This project is all about to bring in the Planogram data from Oracle based JDA application into BW and marry that information with Sales data which is already residing in BW.
• I was the only 1 consultant assigned to this project and had to provide the end to end solution for their requirement
• Responsibilities I have were
• Meeting the Business users to gather the reporting requirements
• Understanding the data
• Come up with the solution for data extraction from JDA, Data modelling in BW and reporting in Bex
• Consider the Space constraints
• Develop Security for the data in reports
• Used BO Data Services 4.0 to extract data from JDA.
• Built Work / Job flows with various transformations like Case, Table Comparison, Query
• This is the first time at the client place, I used the BW 7.0 data flow when extracting data form JDA into BW through BODS. Till then they were using 3.x data flow.
• Built a Master Object and a DSO to load the master and transaction Planogram Data in BW
• Used 0RECORDMODE info object to handle deltas in BW
• Developed Transformations, DTP to load data from PSA into the target objects
• Info packages were automatically created and triggered from BODS to put data into PSA from JDA
• Created Infoset with inner join between Planogram data DSO and Sales / Inventory Cube
• Built a Multi provider with the DSO that I had created for holding Planogram data from JDA, Infoset for Sales and Inventory
• Built 3 Bex reports using CKF’s, RKF’s and Contents selection
• Developed Bex customer exits with ABAP to populate the Planogram data from Planogram master object, Populate few customer exit variables like Previous week, previous 5 weeks
• Worked with the Security team to develop a new security role to publish these reports
• Performed Unit and QA testing.
• Worked with the end users to close out the defects in user acceptance testing using ALM tool form HP
• Conducted user training
• Worked with BODS admin / SAP Basis to create RFC communication between SAP BW and BODS for Open Hub ( READ )
• Also developed APD’s to read data from Bex queries and populate the DSO’s.
• Developed Open Hub interfaces to extract data from POS DM info providers DSO’s
• These interfaces will be accessed/Read in BODS to provide the formatted data to KRONOS

Confidential, IL

SAP BI/BO Consultant

Environment: SAP BI 7.3, ECC 6.0, BO XI 3.1, BI4.0

Responsibilities:

• Worked in Global Expense Management project.
• This project is all about to bring the corporate wide expense data under one roof to enable global comprehensive expense management reporting.
• Developed Standard DSO’s, Write Optimized DSO’s, Info Cubes, DTP’s and Info Packages to load Data into SAP BW from Flat Files
• Developed Start Routines and End Routines for Data Validations and Data Lookups
• Developed work flows, and data flows in SAP BO Data Services for loading data from different interfaces into SAP BW
• Creating a data acquisition model to marry expense and payment data onto a single info cube.
• First data will be loaded onto a DSO. Later through Confidential Load ( After Image ), data is loaded onto Info cube.
• Developed the automation process for Error Stack Analysis
• Extensively worked with BA’s on gathering the reporting requirements
• Converted their Functional Designs into Technical Documents
• Closely worked with Architect on filling up the gaps between reporting needs and underlining data models.
• Developed BADI’s to restrict F4 List of Values.
• Extensively worked on Bex user exit for populating Bex Prompts.
• Introduced SAP Best Practices in the way Bex user exits have been developed in Chase.
• I STEP was not being used incorrectly. I made it to have a check for I STEP=1 first, then I STEP =2 and then last for I STEP=3.
• Introduced the concept of INCLUDE members for each project to organize the Bex user Exit
• Introduced the concept of Dummy Prompt, where the prompt is created on a dummy info object where the user can enter a free form text.
• Behind the scenes, the user entered text is manipulated accordingly.
• Developed nearly 40 Bex queries. Some where stand alone and some where source for Webi reports.
• Proficient in developing a single Bex Query which can satisfy the needs of several Webi Reports thus reducing the maintenance burden.
• Developed a Webi document that comprises of 16 different reports on an individual tab.
• Provided a prompt where user can select any report combination. The data is retrieved from BW for the selected reports in handled in the Bex Customer exit.
• Proficient in Customizing the Universes to meet Reporting needs
• Used RSRT for debugging these queries.
• Extensively worked with BW Security Admin team for implementing data level security for the Bex queries

Confidential, MO

SAP BI/BO Consultant

Environment: SAP BW 3.5/BI 7.0, ECC 6.0, BO XI 3.1

Responsibilities:

• Under ASAP methodology, was involved in Business Blueprint, Realization, Final Preparation and Go-Live Phases.
• Involved in upgrading BW 3.5 to BI 7.0.
• Developed dataflow for 0PUR C01, 0PUR C02, 0SD C01, 0SD C03, 0FI AR 03, 0PA C01 info providers which are related to MM, SD, FI and HR modules
• Implemented Profitability Analysis using CO-PA segments
• Activated LO Cockpit extract structures for Logistics
• Developed Bex reports on Sales, Marketing, Purchasing, finance, material data and developed graphical representations to understand the margin analysis requirements to cost-cut the spend on bottling, packaging, labelling and distribution strategies.
• Extensively worked on performance tuning by activating the BW statistics, creating Indexes and Aggregates, BI Accelerator
• Started using the BOXI r2/r3 as a new reporting tool for the existing data and Comparing the versatility of reports and performance than that of the BW reporting.
• Provided all of the Business Objects Functionalities like Prompts, LOV and Filters, Breaks, Ranks, Alerter, inserted Calculations, Sorts
• Created Dash Board reporting using Xcelsius, QAAWS for Notifications, Equipment data.
• Used Live Office connections to get the real time data to users.

Confidential, MI

SAP BW Consultant

Environment: SAP BI 7.0, BW 3.5, SAP R/3 4.7

Responsibilities:

• Actively conducted workshops with users in gathering requirements
• Done gap analysis and configured several Business Content data flows
• GL, AP, AR, Extractors enhanced as per custom requirements
• Worked on Special Data Retraction tools like Open Hub Services by creating Info spokes so as to extract data into flat files for external Systems
• Appended fields to standard logistics structures/Extractors/Data source like 2LIS 11 VAHDR, 2LIS 11 V SCL, 2LIS 11 VASCL, 2LIS 11 VAITM, 2LIS 11 V SSL.
• Created a custom Start Routine in Update Rules to meet the business requirement.
• Creation of Process Chains for Hourly/ Daily / Weekly Loads as and when required
• Recommended Optimizing Techniques for Data Loads, Cube Maintenance by use of Aggregates, Statistics Compression
• Worked on Bex analyzer, WAD and Bex Browser. Developed flexible and configured use of Restricted Key Figures, Exceptions, Variables, and Queries using Filters in Bex Analyzer.
• Dealing with user trainings and knowledge transfer to end-user

Confidential, SC

SAP BW Consultant

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

Responsibilities:

• Gathered business requirements, performed Gap analysis, design and modeling on purchasing and Sales
• Evaluated Business Content for Inventory Management and activated the relevant Business Content Objects
• Created Custom extractors for FI/CO General Ledger, Special Purpose Ledger in FI/CO areas
• Enhancement of the HR extractors 0HR PT 1 and 0HR PT 2.
• Developed Time dependant Master data objects to store the territory management data at a specific point in time
• Used process chains to enable scheduling and administration of periodic tasks and activities.
• Created Custom Queries in Bex Analyzer, Jump Target Queries by using RRI and Queries for WEB-Reporting
• Improved query performance by creating Aggregates, secondary Index, Partition Info cube
• Support post-production maintenance functions and documentation

Confidential, TX

SAP BW Consultant

Environment: SAP BW 3.1C, SAP 4.6C

Responsibilities:

• Analyzed data requirements and translated these requirements into dimensional data models using star-schema and extended star-schema data modeling techniques.
• Evaluated Business Content for Costing, Sales and Manufacturing and activated the relevant B.C Objects.
• Developed various data extraction procedures for master data attributes, texts, hierarchies
• Extracted the Finance and Sales data (General Ledger, Special Ledgers, Consolidation, Cost Centers, Billing, Invoice, purchase, Damage, Shipment etc) of SAP R/3 into ODS and then transformed from ODS into Info cubes after filtering the data at ODS
• Created and Scheduled Info Packages for Confidential Initialization and Confidential Loading
• Extensively worked on Query building, filtering data, Structures, Variables and conditions.
• Developed User-exits to populate characteristic variables and formula variables.

Confidential, Florida

SAP BW Developer

Environment: SAP BW 3.0B, SAP 4.6C

Responsibilities:

• Developed the dataflow based on the design documents
• Customized and activated the Purchasing Data, Purchasing Groups and Inventory Management Info Cube
• Data extraction 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
• Trained Client personnel for maintenance of above jobs

Confidential

IBM Mainframes Consultant

Environment: Assembler, COBOL, JCL, VSAM, DB2 and CICS

Responsibilities:

• Analysis of the specifications and maintenance requests and issues.
• Coding, reviewing, preparing the test plans and testing
• Conversion of Assembler program to Cobol program
• Preparing Installation plans and Installing the changed components
• Carrying 1-800 number to provide 24 hours support during Weekends and 12 hours during week days
• Peer review for Successful implementations