Profile

• SAP BI consultant with 7 years of IT experience which includes around 4.9 yrs in BI 7.0 and 2.1 yrs in SAP ABAP.
• Involved in life cycle implementations that includes Data modeling, Data extraction and Reporting.
• Have good functional knowledge of SAP R/3 application areas like SD, MM.

Professional Summary

• Involved in full life cycle design, development and implementation of SAP BI applications.
• Experience in creation and maintenance of BI objects: Info Objects, Info Cubes, Data store Objects, Multi Providers and Transformations.
• Expertise in OLTP extractions from SAP R/3 using LO Cockpit and Generic Extractions. Also extracted data from the flat files.
• Involved in creation and maintenance of Info Packages, DTPs and Process chains.
• Good knowledge in improving the query performance as well as loading data to the data targets by using Indexes, compression, Aggregates, partitioning in BI.
• Worked on BEx Analyzer, Workbooks, and Report-to-Report interface and experience in Web reporting.
• Developed 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.
• Experience in creating queries using Calculated & Restricted Key-figures, Variables, Conditions and Exceptions.
• Experience of Open Hub to transfer data from Info providers to flat files and database tables.
• Expertise in ABAP includes ALV and interactive Reports, BDC, Scripts, Module pool programs, LSMW, Smart forms and Enhancements.

• Worked with Confidential, from September 2010 to July 27th 2011.
• Worked in Confidential, from May 2005 to September 2010.
• Worked in Confidential, from May 2004 to April 2005.

Computing Experience

Data Warehouse

SAP-BI 7.0

ERP

SAP R/3(ALE, BAPI, EDI, BDC)

Reporting Tools

SAP BEx, Web Reporting

EAI Tools

SAP-XI

Programming Languages

ABAP/4,Java, C, C++ and SQL

Web Technologies

JSP, Servlets, JavaScript, XML, HTML

RDBMS

Oracle8/8I

Operating Systems

Unix, Windows2000/NT

MCA (70%)

Underwent extensive training program

• SAP BI 7.0.
• SAP-XI3.0
• Advanced PI7.0

Achievements:
Received TXU Best Performer Award for Excellent performance

Project : BP ADAM
Client : Confidential
Role : SAP BI Consultant
Environment : SAP BW 3.5, ECC 6.0.

Description:

Confidential, is one of the world\'s largest energy companies, providing its customers with fuel for transportation, energy for heat and light, retail services and petrochemicals products for everyday items.

Responsibilities:
Member of Production support and Support pack upgrade team.

Project : DCC
Client : Confidential
Role : SAP BI Consultant
Environment : SAP BI 7.0, ECC 6.0.

Description:

Confidential, has launched the Core Systems Project, an initiative to migrate its Finance, HR and Procurement business activities from the present mainframe and other legacy systems to SAP ECC and SAP SRM.

DCC has chosen SAP Business Warehouse as the analytical tool of choice for management and strategic reporting across the SAP landscape. It is to be utilized in the medium to long term as an open Enterprise data warehouse solution but initially will be used as a compliment to SAP operational reporting, and not its direct replacement.

Responsibilities:

• Extensive hands-on experience in Data Extraction from SAP R/3 LO Extraction
• Extensive hands-on experience with R/3 and flat file loading for transactional data, master data attribute and text.
• Extended 0employee_attr to include the employees reports to manager, Address, Weekly hours, Weeks per year, teacher reference number, pension membership, salary protection code, pay method, CRB cleared status, continuous service date
• Worked extensively on BEx Query Designer. Developed flexible queries using filters, Navigational attributes in BEx Query Designer to facilitate data analysis in a drilldown Way to give detailed level of information.
• Worked on Generic Extraction based on client's requirement. Created generic data sources.
• Involved in Unit testing and created process chains to automate the work.
• Extensively worked on process chains to automate the Deleting indexes in Info cubes, Process of info packages, Creating indexes, DSO activation, further updating, PSA request deletion and Attribute change run so on.
• Extensively worked on performance tuning to fine tune the Query performance and Data load performance.

Project : Cornerstone
Client : Confidential
Role : SAP BI Consultant
Environment : SAP BI 7.0, ECC 6.0.

Description:
Networks, our largest subsidiary, are involved in the planning, construction, operation, and maintenance of our transmission and distribution network. Launched in May 2000, Hydro One is a holding company with four operating subsidiaries. It emerged from the restructuring of Ontario Hydro as the owner and operator of the wires operations formerly provided by the provincially owned utility. The company employs approximately 4,000 full-time staff across the province. Hydro One Networks Inc. owns and operates Ontario's 28,600 km high-voltage transmission system. The system transports electricity to 67 large industrial customers, 55 local distribution companies, and its own low-voltage distribution business.

Responsibilities:

• Involved in Developing the Technical Specifications requirements and also converting the Functional specs into Technical Specs.
• Worked on loading Master data and transaction data from flat file and SAP R/3.
• Created Info Objects, DSO objects, Info Cubes, Multi Providers, Transformation and Data transfer process.
• Worked with Multi Provider to combine several Data targets (info Cube, DSO, Info Object) to generate a Consolidated Report from Multiple Data targets.
• Customized and maintained Data Sources such as Billing (2LIS_13_VDHDR), Sales Order (2LIS_11_VAHDR), and Delivery Order (2LIS_12_VCHDR) for the SD module and Purchasing Order Item (2LIS_02_ITM) for MM
• Exclusively involved in BEx Reports and WAD Reports like Analysis Reports and Operational Reports.
• Extensively worked on Unit Testing to writing test Scenarios.
• Extensively worked on performance tuning to fine tune the Query performance and Data load performance.
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing. Tuned queries using Partitioning, Aggregates and Multi providers.
• Good knowledge on necessary settings of inventory management, purchasing, process keys and moment types involved.

Project : Tedrive
Client : Confidential
Role : SAP BI Consultant
Environment : SAP BI 7.0, ECC 6.0.

Description:
Develops and produces driveshaft's, differentials and steering systems for the global automotive industry. With annual sales of €480 million and 2,600 employees at five locations, Tedrive is a flexible mid-sized automotive supplier active on a global level. Established in April 2007, the company operates under the Tedrive Holding B.V. umbrella. Its headquarters is located at Heerlen in the Netherlands.

Responsibilities:

• Developed Custom Info Objects, Basic Cubes and DSO, Transformation, queries for specific user requirements that could not be met by using Standard Business Content.
• Extensive hands-on experience in Data Extraction from SAP R/3 LO Extraction
• Extensive hands-on experience with R/3 and flat file loading for transactional data, master data attribute and text.
• Experience using the Open Hub Feature to export data from SAP BW to external Systems (Flat files / Database tables).
• Worked extensively on BEx Query Designer. Developed flexible queries using filters, Navigational attributes in BEx Query Designer to facilitate data analysis in a drilldown Way to give detailed level of information.
• Worked on Generic Extraction based on client's requirement. Created generic data sources.
• Involved in Unit testing and created process chains to automate the work.
• Extensively worked on process chains to automate the Deleting indexes in Info cubes, Process of info packages, Creating indexes, DSO activation, further updating, PSA request deletion and Attribute change run so on.
• Extensively worked on performance tuning to fine tune the Query performance and Data load performance.

Project : Cadbury 1Europe
Client : Confidential
Environment :SAP R/3 4.7 to ECC 6.0
Role : Developer

Description:

Cadbury has been synonymous with Chocolate since 1824.Cadbury is one of the world's largest chocolate producers. There is a need to improve Cadbury business model in response to the challenges presented by the changing market place. The One Europe project will deliver a new category focused business model based on the centralization of core commercial and supply chain activity at Cadbury new Regional Head Quarters in Rolle, Switzerland.Centralizing will help achieving global objective of fewer, faster, bigger and better while still maintaining market specific branding. SAP ECC 6.0 is the common flat form for 1Europe project.
1Europe Project aims to bring all European Cadbury business into Centralized process. 1Europe project approach consists of 2 sub models: i.e. LnS process and VCM model.

Responsibilities:
The primary responsibilities include Upgrading the current version, Lift and shift for
1Europe system, Preparation of technical specs for new implementations, Unit testing, Go-Live Support.
Supported the UAT and IAT and resolved major issues.
Have Lift and shifted Report writers and queries
LnS Process: LnS (Lift and Shift) Process is the special approach designed for Cadbury 1Europe project to bring the existing Legacy Applications into one common plat form i.e. ECC 6.0.
LnS Verification process:

• Verify the Program is Unicode and ECC 6.0 compatible.
• List out the Master data dependencies.
• List out the required Configuration Changes.
• Code review and testing.
• Process to send updated Light Function specification for Onsite approval.
• Check out for Performance issues and do the change requests for common 1 Europe Model.

Customer Developments:

• Interface to Calculate mark up inventory from SKU and Create an invoice, booking and report with the mark up from the finished good and semi finished good.
• Simple ALV to track the Goods in Transit Valuation.
• Modified Standard Invoice layout based on user requirements.
• Modified purchase order layout based on user requirements.
• Modified standard layout for delivery document.
• Modified existing Scripts to satisfy customer's requirements. Extensively worked on company logo, objects, text ids, header texts and item texts.
• Modified SAP standard Pick List layout and the driver Program as per the Business requirement of the Client. (RVDELNOTE).
• Interface to calculate Toll fee and create invoice document, Convert to PDF, attach to object services and send thru the mail.
• Worked on Enhancements, Implemented One Europe strategy for User-Exits and BAdi's.

Project : INSIGHT
Client : Confidential
Environment :SAP ECC 5.0
Role : Team Member

Description:

This project is SAP R/3 implementation for Limited Brands, Inc., this is a manufacturer of retail brands like Express men's and women's, Victoria's Secret Stores, Victoria's Secret Beauty, Victoria's Secret Direct, Bath & Body Works, The White barn Candle Co. and Henri Bendel. The limited brands are also comprised of various supporting business, or functions, that develop and execute strategies for the individual brands and the enterprise as a whole. The Limited Brands INSIGHT is a SAP enterprise implementation, focused on developing a global design for the entire operations of the firm.
Responsibilities:
The primary responsibilities include the preparation of technical specs, coding and unit testing.
Developed a report for creation/deletion of partner profiles for customer (partner type \'KU\'). In this case inbound and outbound parameters of a reference customer are copied to the target customers.

Developed a report for creation/deletion of partner profiles for vendor (partner type \'LI\'). In this case inbound and outbound parameters of a reference vendor are copied to the target vendors.

Developed a report for Attribute Value Testing for characteristic values of size and packaging of given set of articles.

Developed a tool for validating the Customer PO texts for given Sales order(s).

Project: : INSIGHT
Client : Confidential
Environment :SAP ECC 5.0
Role : Team Member

Contribution
The primary responsibilities include the preparation of technical specs, coding and unit testing.
Developed an ALV report to replicate the functionality of a normal standard report program with Dispute/Case Management functionality. Its major features include Custom Transaction Code, A wide selection criteria with dynamic selection capability, F4 help for all the selection criteria, An ALV report with save, export to excel and print options.

Developed an ALV report to match the Factory 856 and the Forwarder 856 transmissions on carton quantities. If the number matches the user from the report can trigger the goods receipt for the inbound delivery. In the case of a mismatch the user will either correct the problem manually or request a resending of EDI messages from the factory and/or forwarder.

Developed an ALV report to display list of all customers in a certain zip code with sales reps, partners and product line.

Developed an ALV report produce a report of customers created within a date range

Project : TXU
Client : Confidential
Role : ABAP Developer
Description:

TXU manages a portfolio of competitive and regulated energy businesses. TXU Businesses consists of TXU Energy, TXU\'s competitive retail electric provider, TXU Power, the largest manufacturer of electricity in Texas, TXU Wholesale, focusing on keeping power costs as low as possible and TXU Electric Delivery, providing power to over 2.9 million electric delivery points.

Responsibilities:

To upgrade TXU 's current SAP R/3 4.6C landscape to the latest SAP ERP 6.0 version

Project : Holden
Client : Confidential, Australia
Role : Developer
Description:

Confidential, is an automaker that operates in Australia, based in Port Melbourne, Victoria. The company was founded in 1856 as a saddlery business, but later moved into the automotive field, becoming a subsidiary of the U.S.-based General Motors (GM) in 1931. After the GM takeover, the company was named General Motors-Holden\'s Ltd, becoming Holden Ltd in 1998, with the current name adopted in 2005. The current project is a SAP enterprise implementation, focused on developing a global design for the entire operations of the firm.

Responsibilities:

• Involved in identifying to fix the defects and Change Requests raised.
• Involved in development of Reports Dialog programming