Mukesh Sharma

*** *********** ****** *** **, San Ramon, CA- 94583

925-***-****(M)

Email: jilef2@r.postjobfree.com

Experience Summary:

• Nearly 5+ years of experience, this includes 5+ Years of SAP BW & BI Presently working for Infosys Technologies Limited involved in Two Implementation Projects and Support Project with proven track record of company and client satisfaction.

• SAP Certified Business Intelligence Solution Consultant.

• Experienced across different phases in Software Development Life Cycle – Software Development, Quality Assurance and Requirements.

• Performed Release Management and Change Management activities in a large IT organization for various enterprise applications.

• Experience in status tracking and monitoring, preparing and reporting test metrics, effort estimation and implementing quality assurance practices to reduce defects and improve the software product quality.

• Excellent knowledge and implementation skills of the complete Software Development Life Cycle (SDLC) best practices.

• Comprehensive knowledge using SAP ASAP methodology in Business Information warehouse database design, development, configuration and performance, Experienced in the analysis of business needs to build single best practice solution.

• Involved in developing different type of objects like Basic cube, Real time cube, DSO, Multiprovider, Info set, DTP of type standard, Direct Access, Error DTP RDA DTP and Info Packages.

• Current focus is on Implementing HR,SCM, Production support & Maintenance Projects, Enhancement Projects.

• Involved in designing the Graphical star Schema View by following the necessary standards to deploy optimized Info cube Data Model both at the Database level and Reporting Level.

• As part of Information Consumer Layer designed BEx Reports providing insight of Business Intelligence for Business Analyst for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value, Replacement Path and Customer Exit.

• Involved in changing the Existing data model of an Info Cube by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources from SAP R/3.

• Involved in creating Generic Extractors using Function Module and view.

• Extensively Involved in Activating the Business Content Data Sources, Maintaining the Extract Structure, Generating the Data Source, Activating the Data Source, Enhancing the Data Source and Using the Enhancement RSAP0001 to fill the data into the enhanced Fields.

• Extensively worked in Business Information Warehouse Info Cubes, ODS Objects, Info sources, Info objects, Transfer rules, update rules, Extractors, Info sources, Info packages, Info objects Catalogs, Data sources, Data Extraction, Business Content, Data Marts, Process Chains.

• As part of Quality management standards to deliver the objects in quality performed Unit testing and recorded the test results in unit test cases documents.

• Designed and developed process chains (RSPC) for master data loads and transaction data loads with the help of Info Packages. And these Process chains are scheduled for periodic loads.

• Performance tuning using Aggregates, Rollups, Cube Compression, Index Maintenance and Partitioning to achieve best possible performance.

• Involved in Real Time Data acquisition (RDA) implementation for e-performance module.

• Involved in SEM Balanced Scorecard.

• Involved in Integrated Planning Implementation.

• Having Good Exposure in developing Xcelsius Dashboards on SAP as Source Systems, Administration of Crystal Reports, Live Office, and Web Intelligence Reports.

Professional Accomplishments

• Received SPOT award (award for outstanding performance) thrice.

• Received KM (Knowledge Management) Award and certificate from Infosys for my knowledge sharing activities for the company.

• Published an Article in SAP SDN.

• Published Weblogs in SAP SDN under Business Intelligence Forum.

• Received excellent Client satisfaction feedback by consistently exceeding defined quality objectives.

• Received appreciation from the client Business Manager for my role as Application Developer.

Education and Certifications:

• Bachelor of Engineering ( B.E.) from Rajasthan University, Rajasthan, India

• SAP Solution Consultant Certification SAP Net Weaver 2004s –Business Intelligence.

• Infosys P150 Packages on SAP Human Capital Management certification.

• Infosys Enterprise Functions

• Infosys ES-FND-SE Foundation Program Certificate

• Infosys EQ1: ES Quality Foundation Certification

• Infosys ES-P100-Overview of ES Technologies

• Infosys ES-P200-SAP-NETWEAVER

• Infosys EUS-L100-Hospitality-Basics of Hospitality Industry

Training and Conferences:

• SAP TechEd 2007 (Bangalore): An International Conference by SAP

• SAP Web template training: A SAP provided Training

• SAP BI7.0 Delta Training: An Infosys Internal Training

Technical Skills:

• ERP: SAP R/3 4.6C, 4.7

• SAP: SAP BW 3.5 and 7.0 SAP BO,SAP R/3

• Operating Systems: Windows 95/98/NT/2000, Unix

• Languages: ABAP/4,C, HTML, XML.

• Databases: MS SQL Server, Oracle8i/9i, MS Access.

• Tools & Utilities: Toad, MS Project Plan, Microsoft Visual Source Safe, CVS.

Professional SAP BW Experience:

• Working as SAP BI Technology Lead for Infosys Technologies Limited, Plano TX US since April’08 – Till date.

• Worked as SAP BW/BI Application developer for Infosys Technologies Limited, Pune India since Dec’05 to April’08.

• Worked as SAP BW/BI developer for Kirloskar Pneumatics Limited, Pune India since June’05 to Dec’05.

Project Profile:

AT&T Inc., San Ramon, CA

SAP BI Solution Consultant

Human Resource Reporting and Business Intelligence System

April 2008 - till Date

The eCORP Strategic Analysis & Reporting (eCORP STAR) team provided strategic analytical and operational reporting services to a number of key organizations within AT&T. The major areas of focus were Human Resources, Procurement and Real Estate.

Among the key Business Intelligence services provided by the eCORP STAR team were:

• Partner with key business and process owners to identify and document information requirements.

• Build necessary reporting infrastructure and associated strategic, analytical and operational recurring reports.

• Upgrade and maintain infrastructure, host reports, and provide web-based and portal access to information.

• Provide ad hoc reporting services on an on-going basis.

Responsibilities:

• Acting SAP BW HR Module lead at Onsite.

• Implemented end to end solution for client on BW Statistics and Technical Content (Business Content).

• Involved in generating and processing query definitions with both the BEx Query Designer and the BEx Web Application Designer

• Involved in designing and development of complicated Reports, including the features of RRI, Customer exits, replacement path variables.

• Involved in giving solution supported with POC (Proof of concepts) on various SAP HR modules.

• Responsible for implementation of BI7.0 Statistics (Technical Content) and Admin Cockpit using SAP Net weaver Portal.

• Responsible for designing and development complex extractors using functional modules for various HR areas.

• Involved in implementation of Real time data acquisition in SAP BI 7.0 for client.

• Involved in implementation of SAP SEM Balance Scorecard.

• Responsible for BIA support activities.

• Participate in regular status meetings with senior requirement and development team leads on the client team to review project status, potential risks and issues.

• Acted as SAP BW Release Coordinator. Responsible for managing transports and coordinate with SAP Basis, SAP Portal team and SAP Security team to smoothly implement the applications developed.

• Involved in development of Work Force Planning application using SAP BI 7.0 Integrated Planning.

• Co-ordination with offshore testing team members, onshore developers and requirement engineers.

• Working with developers to analyze defects and identify probable solutions.

• Identifying test scenarios, reviewing detailed test plans based on analysis of requirements and design documents.

• Involved in designing and development of applications for conversions to handle various company mergers into clients’ SAP R/3 and BW.

• Conducting Defect Prevention meetings with the developers so that the rate of defect injection is reduced and the quality of product is enhanced.

• Involved in creation of BO Universe.

• Involved in creation of SAP BO WebI Dashboards and reports.

AT&T Inc., Pune India

Technology Analyst

eCORP Strategic Analysis and Reporting

26th August 2006 to 10th April 2008

The eCORP Strategic Analysis & Reporting (eCORP STAR) team provided strategic analytical and operational reporting services to a number of key organizations within AT&T. The major areas of focus were Human Resources, Procurement and Real Estate.

Among the key Business Intelligence services provided by the eCORP STAR team were:

• Partner with key business and process owners to identify and document information requirements.

• Build necessary reporting infrastructure and associated strategic, analytical and operational recurring reports.

• Upgrade and maintain infrastructure, host reports, and provide web-based and portal access to information.

• Provide ad hoc reporting services on an on-going basis

Responsibilities:

• Performed analysis, design, development and implementation of standard/ customized Info Cubes and ODS Objects for MM and SD modules.

• Created & maintained info Objects, data sources, info sources, communication structures, transfer structures, transfer rules, update rules, info packages and scheduling the data requests.

• Written transfer routines and update routines.

• Written ABAP program , APD routines, Function Modules to transform the data before loading in BW infrastructure.

• Worked extensively on standard and custom defined LO extractors. Installed relevant SAP business content.

• Data loading was monitored and the failed data packets were analyzed.

• Worked on Procurement reports.

• Created Multiproviders to increase the performance.

• Involved in performance tuning by creating indexes, aggregates.

• Involved in implementation of Virtual Key figures and Characteristics.

• Involved in implementation of Remodeling concept of SAP BI 7.0.

Public Service Enterprise Group; Bangalore India

Senior Software Engineer

Sales and distribution System

19th Dec 2005 – 25th Aug 2006

PSEG currently serves nearly three quarters of New Jersey's population in a service area consisting of a 2,600-square-mile (6,700 km2) diagonal corridor across the state from Bergen to Gloucester Counties. PSE&G is the largest provider of gas and electric service, servicing 1.7 million gas customers and 2.1 million electric customers in more than 300 urban, suburban and rural communities, including New Jersey 's six largest cities.

Responsibilities:

• Monitored Daily Chains, weekly Chains, and Monthly Chains.

• Handled the tickets of priority 3 and 4 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.

• Involved in system define tickets as well as user defined tickets.

• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.

• Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.

• Data loading was monitored and failed data packets were analyzed and if possible manually Maintaining Work History for all the tickets until it is closed down.

• Developed Trend Analysis Reports like Month Till Date (MTD), Year Till Date (YTD), Previous Month Till Date, Previous Year Till Date, and so on.

• Developed Ageing Reports like Stock Ageing Report, Vendor Ageing Report, Stock in Transit, Sales Register, Sales Ageing Report, Stock Transfer, and so on.

• Developed long running Z Reports in BW like Sales Return Register, Purchase Register,, Stock Movement Report, and so on.

• Developed BADI Transformation in InfoSpoke, to distribute the data for the newly added field in the target structure of InfoSpoke.

• Handled different Tickets related to data mismatch, performed Data Reconciliation.

Kirloskar Pneumatics Ltd., Pune India

Software Engineer

Manufacturing System

13th June 2005 – 8th Dec 2008

Kirloskar Pneumatics is a leading manufacturer of the compressors, oil engines and engine parts. Project is regarding the implementation of SAP in Sales and Distribution.

Responsibilities:

• Going through the Technical specification and performing GAP Analysis.

• Undergone Detailed Analysis over Business content reports such as SD, MM.

• Involved in preparing the data flow charts of each application, maintenance of documentation for each gathered requirements

• Installing and activating Business content objects According to the Requirement.

• Validating the installed Business content objects

• Creating and Modifying Info Cubes, Data store Objects, Info Objects, Data Transfer process, etc..

• Created and Developed BW Queries Using BEx Analyzer and BEx Report Designer.

• Involved in creation of Data Sources and InfoSources, for Data extraction, transformation and loading from SAP R/3 system & Flat File to SAP BI.

• Worked on enhancements of the Extract structures using user exits.

• Worked on Creation of Process chains.

• Scheduling and monitoring of Data loads.

• Testing the reports with data and Rectified the issues occurred.

• Worked with Reporting Agent, Work Book design.

• Involved in performance enhancement features such as cube partitioning, Indexing, maintaining aggregates and compression.

Contact this candidate