Professional Statement:

Diversified, organized, dedicated, skilled, candidate with over 7 Years hands on application of information technology software and hardware programs, and systems with over 2 Years experience in SEM / BI-IP / BW 3.5 and 1 Year of experience in BI 7.0. Strong written and oral communication skills, combined with good interpersonal skills and ability to handle, meet deadlines for multiple assignments under high levels of pressure.

Certifications:

• SAP – SEM 4.0 Certified  (ID # 0004297588) – also attended BI-IP (BI 7.0) training in SAP Labs, India  Nov ‘07
• SAP – ABAP/4 Certified  (ID # 0004297588)
• PMI – PMP Certified (PMI # 493983)
• Oracle Certified Professional in Oracle 9i DBA
• Microsoft Certified Application Developer
• Sun Certified Java Programmer

Work Experience:

Internal Trainings:
▪ Provided Internal Training on SEM-BPS, SEM-CPM, and BI-Integrated Planning
▪ Assisted the Basis team in Setting up SEM Server
▪ Installed Business Content for BI 7.0, SEM Management Cockpit, and Measure Builder

Attended Internal Trainings:
▪ FI/CO Refresher's Training
▪ ABAP - OOPS Concepts Training
▪ BI 7.0 Training

Project: Bill Board Junction (Completed)
▪ Conducted feasibility study
▪ Designed the System Architecture
▪ Selection of Technologies
▪ Implemented the System
▪ In-house training to staff
▪ Assisted in detailed documentation

Project: CollegeChanakya (Completed)
▪ Conducted feasibility study
▪ Designed the System Architecture
▪ Selection of Technologies
▪ Implemented the System
▪ In-house training to staff
▪ Assisted in detailed documentation

Project: Enterprises Document Management System (On-Going) ▪ Conducted feasibility study
▪ Designed the System Architecture
▪ Selection of Technologies
▪ Implemented the System
▪ In-house training to staff
▪ Assisted in detailed documentation

Project: HR Toolbar (On-Going)
▪ Conducted feasibility study
▪ Designed the System Architecture
▪ Selection of Technologies
▪ Product Development
▪ In-house training to staff
▪ Assisted in detailed documentation

Lenovo is a global company with executive offices in Raleigh, North Carolina, USA, Beijing, China, and Singapore. Its principal operations are in Beijing, China, and Raleigh, North Carolina, USA, with an enterprise sales organization worldwide. The company employs more than 19,000 people worldwide.

As a global leader in the PC market, Lenovo develops manufactures and markets cutting-edge, reliable, high-quality PC products and value-added professional services that provide customers around the world with smarter ways to be productive and competitive.

Role:

• Involved in collecting the requirements from Business community working in close proximity with BT and developing the functional specifications and participate in system analysis and design – Pricing Reports for ECC and CRM
• Developed Billing and Pricing Info Objects and used Info objects to create custom DSOs and update the information into custom Info Cubes – right from design, enhancements to data sources to accommodate relevant / required information both for the S&D data sources - Billing and the CRM data sources – Opportunities item
• Developed Aggregation level, filters, packages, functions, input template, execution with trace, sequences as a trial to demonstrate to Client – aspects of IP – carried out allocations, distribution, copy, reposting, delete in Sales Planning
• Developed Customized Info Objects for flags and Pricing information and created transformation and data transfer process.
• Developed Start routines and end routines and used applied constants, subroutines in transformations.
• Developed Multi cubes which interacts with basic cubes with identification.
• Developed Logic to arrive at the pricing reports arrived at from various complex pricing procedures both in ECC S&D and CRM – Opportunities with different types involved including Sales Agreement, Sales Contract, Spot Quote, Back End Bid both price based and discount based.
• Involved in dropping the secondary indexes before loading master data and created the secondary indexes and compressing the Info Cubes.
• Involved in creating data source for custom based requirement on business needs and development of Custom DSO, Info Cube to extract the data at segment level.
• Involved in Batch scheduling of jobs for updating Info Cubes with live data and program with process chains.
• Developed queries for Open sales orders, sales orders for sales office, region, month. Applied push buttons to control the reports in BEX analyzer using BEx functionality.
• Involved in applying OSS Notes.
• Development of Queries and reports using BEx Analyzer, Query Designer.
• Created Info Set Queries to extract data.
• Development of specific Queries based on user requirements as well as utilization of Business content related queries and work Book.
• Assigned Queries to users, relevant authorizations, transports for all objects relevant including BEx reports
• Conducted UTs before SITs – worked on testing the queries on portals
• Conducted User training and How To for users for UAT – on site in Toronto, Canada
• Dealt with TIRs, CRs for changes in the reports.

Environment: SAP ECC 6.0, BI 7.0, BI - IP

• Gathered information regarding the business requirements from Management and Users to design the overall layout.
• Interacted with the Management and Business End Users to identify the reporting Requirements.
• Created monthly rolling versions and simulated P&L on rolling basis.
• Involved in implementation of SEM-BPS, including conceptualizing and building the Planning areas, Planning levels, Planning packages, planning functions and planning folders relating to Manufacturing cost planning for COGM and COGS.
• Extensively worked with Planning Areas, Multi-Planning Areas, Planning Layouts, Planning Levels, Planning packages, Manual Planning, Manual and user defined functions, Planning Profiles, Planning sequences, Planning environment and Data Slices using characteristics relationship, BPS security authorizations, Formula Extensions (FOX) and hierarchy variables.
• Worked extensively in creating both Static and Dynamic Reports as per the requirement.
• Developed front-end queries using Query Designer and Web Application Designer (WAD) and publishing results on the web.
• Distributed workbooks to the Users using the Precal Server, so that the users can receive the Reports through mails as per the scheduled date and time – BEx Broadcaster.
• Extensively worked with SEM-BPS statistics to tune BPS performance and also modeled and analyzed SAP-BW cubes for SEM-BPS.
• Responsible for thorough data validation using different unit test cases.
• Handled various production issues for the tickets raised.

BI-IP

• Performed a comparative study on the effectiveness of BPS vs. BI-IP.
• Performed a study of functional capabilities of the mySAP Business Suite CRM solution, depicting process flows across the various software components especially with BI-IP implemented.
• Worked on preparing materials for the business users in simple business English on the differences between using BPS and BI-IP.
• Aided the business users to make an expert decision on the usage of BPS/BI-IP and CRM through presentations and demonstrations of sample scenarios.
• Sound knowledge in Real Time Cube, Standard Cube, MultiProvider, InfoProvider, Planning Modeler, Aggregation level, Filter, Input Ready Query, Web Application Designer, broadcasting in Portal.
• Created Aggregation levels and Filters using Planning Modeler in the Portal.
• Created Planning Functions, used them in the Planning Sequence and assigned them as buttons in the Planning Layouts using the Web Application Designer.
• Created Input Ready Query in the Query Designer using the Filter created in the Planning Modeler.
• Assigned the Input Ready Query and the Planning Sequences in the Web Application Designer to develop the user accessible web planning layouts.
• Broadcasted the Planning Layout through Portal.

Environment: BW 3.5, SEM 4.0, SD, BEx, WAD, Reporting Agent, Report Painter, Windows NT
Prototype Environment: BI 7.0

Hill’s Pet Nutrition is a $1.5 billion, global division of Colgate-Palmolive and the maker of Science Diet® and Prescription Diet® brand pet foods – the company believes in helping enrich and lengthen the special relationship between people and their pets by providing the best, leading-edge pet nutrition technology, products and expertise to pet owners, veterinary professionals and other key pet professionals worldwide.

Role:

• Implemented and worked with the integration of SAP BW & SEM BPS in planning, reporting and simulation based on the user requirements.
• Design and use of Basic & Transactional Info-Cubes for actual / plan data comparisons.
• Extensively worked with SEM-BPS statistics to tune BPS performance and also modeled and analyzed SAP-BW cubes for SEM-BPS.
• Extensively worked with Planning Areas, Multi-Planning Areas, Planning Layouts, Planning Levels, Planning packages, Manual Planning, Manual and user defined functions, Planning Profiles, Planning sequences, Planning environment and Data Slices using characteristics relationship, BPS security authorizations, Formula Extensions (FOX) and hierarchy variables
• Interacted with the Management and Business End Users to identify the reporting Requirements.
• Worked extensively on BEx Query Designer and developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Assigned queries to different User Catalog on client specification and developed Excel workbooks for publishing views on the web using Web Application Designer. Created selection screen for the reports using filter parameters for the BW query using JavaScript.
• Manipulated web template by using JavaScript and HTML with the creation of drop-down box.
• Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting.
• Involved actively with BW Team to resolve the technical (Performance) issues, Performance tuning of Queries, roll up of aggregates, PSA issues and Data Validation.
• Created custom queries using variables, structures, calculated and restricted key figures and created web templates using web items in Web Application Designer.
• Manipulated web templates by using JavaScript to download web based Price List reports into EXCEL, CSV and PDF formats.
• Set exceptions handling, Profile Generation, Profile and Users/Roles Maintenance etc.
• Involved in checking the OSS notes and applying the same.

Environment: SAP R/3 4.7, BW 3.5, SEM-BPS 3.5, BEx, SAP WAS 6.20, EP 5.0, Oracle 8i, UNIX.

The Hershey Company is a leading snack food company and the largest North American manufacturer of quality chocolate and non-chocolate confectionery products.

Role:

• Analyzed business reporting requirements that satisfy with SAP Business Content and installed the necessary objects for Business Content Cubes.
• Extracted data from FI, SD, MM, CO-PA, PM and QM modules of SAP R/3 and from flat files into SAP BW system using Generic, LO and CO-PA Extractors.
• Created ODS for Release Cost Estimate Summary in which Cost components are summarized at material level.
• Used LO method for extracting logistics related data into BW. Extracted data from MM module and uploaded into Purchasing Data, Vendor Evaluation.
• Extracted data into COPA Info Cubes for Profitability Analysis and reported using BEx to retrieve top customers, most profitable products and best performing profitability segment.
• Setup periodic data loads from R/3 full/delta enabled and legacy system (flat files) containing certain customer information and enhancement of extract structure.
• Assigning data sources to the Info Source, defining transfer structure, configuring the extract structures for replication and updating of data source from the source system.
• Involved in creating transfer rule for cleansing the data using the Transfer rule routine and Update rule routine.
• Created Multi Cube for analyzes the data between different modules and ODS for store document level data and restricted the duplicate data.
• Involved in using performance enhancements features such as Cube Partitioning, Indexing, maintaining aggregates and compression.
• Created Info Spokes to incorporate Open Hub services to extract BW data into required logical target systems.
• Designed and optimized the queries (top customers, monthly incoming orders and revenues, product analysis, returns) and created reports using BEx Analyzer.

Environment: SAP BW 3.1C, SAP R/3 4.6C, ABAP/4, BEx Report.

▪ Assisted in preparation of the Financial Statements
▪ Performed clerical work in the finance department
▪ Assisted the IT department in maintaining the computers

Project: Organization Computerization – Project Manager

• Conducted feasibility study
• Designed the Computer Network
• Implemented the LAN
• Conducted quality assurance testing
• Provided in-house training to staff
• Prepared detailed documentation

Project: Sales and Logistics – Team Lead

• Conducted a detailed study of the organization
• Analyzed Sales and Distribution Contract
• Analyzed demand trend in the past and prepared probable future demand
• Conducted a Market research to arrive at logistics vendors
• Requested for bids from various vendors
• Submitted detailed documentation to upper management

• Assisted in preparation of the Financial Statements

• Performed clerical work in the finance department

Education:

Technical Skills:

Activities:

• Certified Yoga Teacher - Sivananda Yoga
• PMI(R) Chapter Member

 References: Available on Request