Profile Summary

• Over 7 years of IT experience in areas of Design, Development, Implementation and Testing of SAP BW systems up to releases 7.0, SAP R/3 experience in design and development in SD, MM & FI modules and BEx Reporting
• Involved in all phases of life cycle including Blue Printing, Realization, Design, Development, Testing, Go-Live, Production Support & Trouble shooting the issues, support in multiple engagements
• Excellent in SAP ASAP methodology, BW Modeling (InfoCubes, Info Objects, Info Sources, DSO, MultiProviders, Transformations, Extraction Process, transportation of business objects using CTS tool, Delta and Full updates, Process chains, Open Hub Destination and Performance Tuning)
• Extensive Knowledge in BW Reporting (BEx Query Designer, Web Application Designer); Performance Tuning, Authorizations/Profiles
• Experience with Front-end Business Warehouse Components, which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures
• Expertise in publishing queries to web portals through Web Analyzer
• Worked on various kinds of Performance Tuning techniques such as Aggregates, Rollups, Indexes, Partitions and Info-Cube Compression techniques
• Combination of Technical and Business skills as applied to information systems which includes translation of business requirements into technical specifications, extensive data analysis, research and reporting
• Proven experience in ability to adapt quickly and work in teams with ability to work independently and ability to take charge when necessary and drive the work to completion
• Excellent communication skills, strong analytical and reporting skills, personal organization and interpersonal skills.

Technical Skills/Tools:

SAP R/3 Versions : ECC 6, 4.6C
Functional Skills : SD, AR, FI
Reporting Tools : BEx Query Designer, Web Application Designer
Data Warehouse : SAP BI 7.0, 7.3 
Operating Systems : Windows NT/2000/98/95/XP
Utilities : MS-Office

Experience

Client: Confidential
Period: May’2011 – Present
Industry: Telecommunications
Location: New Jersey
Role: SAP BIDeveloper

As BW developer for Finance and Sales areas, my responsibilities include:

• Interaction with users and stakeholders to identify Business Requirements and drivers for Template change
• Performed GAP analysis comparing the Business Content & reporting/modeling requirements
• Converted Functional Requirements into Technical Specifications
• Activate Business content where applicable and created necessary custom Objects like InfoObjects, DSO, InfoCubes, MultiProviders, Transformations, DTP, Info Packages etc
• Created custom cubes like ZSD_C03 (Sales Cube), ZSD_C01 (Customer Cube) etc and loaded the data from flat files in BW to facilitate the reporting requirements
• Created a MultiProvider to integrate the Sales, Customer, Purchasing Cubes, Plan and Projection cubes
• Identified the Standard Business Content for the BW Reports and activated them from the BW Business Content
• Created BEx Reports Decrease in Sales, Daily Sales, Customer Analysis Report, Top 50 Customers, Top 50 Products, Aging Reports etc
• Created several Restricted & Calculated Key figures, Structures, Variables, Conditions, Exceptions
• Developing flexible queries using Filters, Free Characteristics, Navigational attributes in BEX analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels
• Broadcasting the queries to different users
• Developed web templates using Web Application Designer (WAD)
• Review system statistics and other measures to identify the need for aggregates, indexes, compression etc
• Created Aggregates, Partitioning and Compression on InfoCubes to improve Query performance
• Balance load schedule to minimize load on BW & R/3 Systems, manage master data loads to minimize duplication
• Responsible for managing unscheduled data loads and co-ordinate with functional support teams to avoid conflict with application schedules
• Project went live smoothly and currently we are dealing with minor Post go-live issues

Client: Confidential
Period: Feb’2009 – April’2011
Industry: Telecommunications
Location: New Jersey
Role: SAP BIReportDeveloper

As BW functional analyst for Finance and Sales areas, my responsibilities include:

• Involved in creating the Functional and Technical specification documents and developed the objects as per the design
• Performed Analysis, Design, Development and implementation of standard/customized InfoCubes and ODS Objects for FI and SD modules
• Extracted (ETL) data from ECC & Flat files. Validated Data for quality.
• Created the custom InfoObjects, DataStore Objects, InfoCubes, MultiCubes, and Transformations, Data Transfer Process with Full and Delta loads.
• Monitored ETL process for master data (texts and attributes)
• Involved in configuring the Order to Cash module
• Created custom cubes like ZSD_C15 (Discount for Customers Cube), ZFIAR_C01 (A/R Invoices Cube) etc and loaded the data from flat files in BW to facilitate the reporting requirements
• Created MultiProviders on ZSD_MC01 (Billing & Invoices MultiCube), ZFIAR_M01 (Invoices MultiCube) etcon which all the planning reports were based on.
• Created Performance tuning using performance improvement techniques by partitioning the InfoCube, Compression, Partitioning, creating indices and maintaining Aggregates.
• Created process chains to automate the scheduling of data load into InfoCube and MultiCubes.
• Developed reporting solutions for Order to Cash
• Created multiple BEx Reports based on user requirements in Sales, Delivery, Billing & Customer Analysis reports.
• Implemented Daily Sales Outstanding (DSO) Business Content - The DSO analyses the outstanding debts of a customer for a certain period in relation to the average daily business volume of the customer in question.
• Developing flexible queries using Filters, Free Characteristics, Navigational attributes in BEx analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels.
• Created Web templates for queries using Web Application Designer
• Worked on Help Desk tickets to resolve Data Inconsistency between SAP BI and Non –SAP Source Systems
• All the reports were developed using Web Application Designer as there were no mandatory fields in the selection screen. This posed a problem that the selection screen was not being popped-up when the queries were published under the menu role. In order to solve that, the ‘force all screens’ option was used in the web template and published on the menu role

Client: Confidential
Period: Nov’2007-Dec’2009
Industry: Apparel
Location: Maryland
Role: SAP BI Developer

As BW functional analyst for Finance and Sales areas, my responsibilities include:

• Interaction with users and stakeholders to identify Business Requirements
• Performed GAP analysis comparing the Business Content & reporting with Modeling requirements
• Installation of Business Content for Sales and Distribution and Finance areas
• Activation of standard Info Cubes, Enhancement of Business Content
• Extracted data from flat files to load into customized InfoCubes and DSO’s
• Developed Transformations, Data Transfer Process and Info Packages while loading the data from custom DataSources to InfoCubes
• Developed DSO objects to load Sales Order Data from the Data Source. Loaded Transactional Data into PSA and uploaded Data from PSA to DSO, DSO to InfoCube  and enabled Data for Reporting and Analysis.
• Improved data load and query performance by doing Compression, Rollup and creating Aggregates, Indexes and Partitioning
• Created Multiple BEx Reports on Sales Overview, Open Sales Orders, Top N Reports, Overdue Analysis
• Created Restricted and Calculated key figures to calculate average, min, max etc
• Created flexible queries using Free Characteristics, Filters, Navigational attributes in BEx analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels
• Worked on functions of new BEx Query Designer in the state-of-the-art BEx Web Application Designer (WAD), excel-based application design with the new BEx Analyzer
• Created new queries with Variables, Calculated Key figures in Query Designer
• Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx
• Created necessary documentation like functional & technical specifications, Data Flow diagrams, Modeling diagrams etc… Coordinated with the Basis & Security team from time to time during the project.
• Provided Production support after go-live and Performance Tuning
• Responsible for managing unscheduled data loads and co-ordinate with functional support teams to avoid conflict with application schedules

Client: Confidential
Period: May’2005-Oct’2007
Industry: Tax 
Location: India
Role: Senior Analyst

As BW junior functional analyst for Finance and Tax areas, my responsibilities include:

• Understands the purpose, roles and activities of the clients
• Performed Analysis, Design, Development and implementation of standard/customized InfoCubes and ODS Objects for FI modules
• Created the custom InfoObjects, DataStore Objects, InfoCubes, MultiCubes, and Transformations, Data Transfer Process with Full and Delta loads.
• Identified the Standard Business Content for the BW Reports and activated them from the BW Business Content
• Designed queries on Tax Reports like Year-End Tax Depreciation Report for Assets depending on their age (5yr, 10yr, 15yr and 20yr)
• Created billing and history, credits raised, general refund reports
• Created Web templates for queries using Web Application Designer
• Created Restricted and Calculated key figures to calculate average, min, max etc
• Created flexible queries using Free Characteristics and Filters in BEx analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels
• Created Structures for a query and customized it for several queries using the same structure
• Created Aggregates, Partitioning and Compression on InfoCubes to improve Query performance
• Data loads (daily, weekly and monthly) using dedicated Process chains
• Analyzed loading performance issues like Extraction, Staging, Loading Master Data, ODS and Info cube and other tuning aspects like Partitioning and Archiving.
• Performed Aggregates review for Queries using transaction RSRT
• Worked on Help Desk tickets to resolve Data Inconsistency between SAP BI and Non –SAP Source Systems

Education:

Diploma in Business Administration

BS in Commerce – Accounting.