SUMMARY:

• 16 years of Total Experience in the IT industry, Experience in SAP BI/BW, ABAP/4 Configuration, Implementation, Support, and Upgrade.
• Implemented 2 full life cycle implementations on SAP BI/BW following ASAP Methodologies which involves Blue Printing, Realization, Data extraction, Data modeling, data loading, System stabilization and Maintenance, Testing, Documentation, Requirement analysis, End User documentation and Reporting.
• Experienced in dimensional and relational data modeling: star schemas, extended star schemas, normalization, de - normalization, Physical database design, relational models, key performance indicators and other OLAP considerations.
• Technical and functional migration from SAP BW 3.x to 7.0, 7.3 and 7.4
• Experienced in SAP BW Net Weaver 2004S/ BI 7.X/3.5/3.1. Expertise in Upgrading to BI 7.0
• Extensive experience in Data architecture, Data Modelling, Data flows and back end and front end design and development. Multi-Dimensional Data Modeling Extended Star-Schema, Data Flow Strategy.
• Full cycle development experience includes in DW Workbench: Extractors, Info Objects, Data sources, Info Sources, ODS objects, Basic Info Cubes, Transactional Info Cubes, Remote Cubes DTPs, Multi Providers, Open hub destination etc.
• Experienced in OLTP extractions using LO cockpit and building Generic Extractors, using FI-CO, SD, MM, QM, FI-GL, PP, CRM functions. Experience in loading data using Flat Files and DB connect.
• Designed data extraction from SAP & non-SAP systems. Sophisticated skills to work on Flat File Extraction, Generic Data Sources, BI Content Data Sources, Full and Delta Extraction Management.
• Extensively worked on SAP POS DM module to store, process the retail data.
• Worked on Data extraction from SAP POS DM to SAP BW and SAP APO.
• Expertise in BEx Analyzer, Query Designer, Web Application Designer, Info-Set queries. Experience with Front-end Business Warehouse Components, which involved constructing custom queries.
• Worked on various kinds of Performance Tuning techniques such as Aggregates, Rollups, Indexes, Partitions and Info-Cube Compression techniques.
• Solid understanding of HANA functional architecture/infrastructure.
• Sound knowledge in SAP HANA native modelling and mix modelling with SAP BW 7.4.
• Extensively worked on HANA Studio-Schemas, Packages, Attribute View, Analytical View, and Calculation view, Analytic Privileges, Stored Procedures and CE Functions.
• Experienced in SAP BW 7.4 on HANA and having sound knowledge on optimized BW models on HANA.
• SQL Scripting for Procedures in HANA database.
• Good knowledge on ETL tool like BODS and SLT.
• Having expertise in delivering HANA projects like BW on HANA Implementations
• Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.
• Developed data flows and work flows using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Good Knowledge in SAP HANA data modeling using Attribute View, Analytic View and Calculation View 
• Excellent analytical skills for understanding business requirements, system requirements, data related requirements, business rules/processes, and detailed design of the application
• Expertise in software development life cycle (SDLC), requirement gathering, business analysis, system analysis, data analysis, risk analysis, feasibility analysis, impact analysis, gap analysis and process improvements, data modeling and mapping

PROJECT EXPERIENCE:

Sr. Consultant SAP Analytics & HANA

Responsibilities/Deliverables:

• SAP Releases BW 3.5, 7.3, 7.4 and BODS 4.2, BO 4.1, SLT, Oracle, ECC 6.0, SAP CRM 7.0
• Established the best modeling and recommended strategies for SAP HANA and BW data modelling.
• Created technical specifications and standard modeling documents for BW powered by HANA and native HANA data modelling.
• Strong experience in carrying functional, integration, latency, performance, reliability testing for various enterprise analytical products.
• Build SD and FI Information Models for user consumption (Attribute View, Analytical View, and Calculation View). 
• Worked on SQL script based Calculation Views.
• Extensively used Business Objects Data services to generate files from different sources SAP and Non SAP and transfer the files to downstream systems like SCOPSBI, TDFADS, ASSURANT.
• Generated Sales equipment files through Business Objects Data Services to Assurant system to track the APPLE CARE coverages.
• Created Variables, Input Parameters and Calculated/Restricted Columns on Calculation Views.
• Imported BW targets from BW application layer into HANA to leverage mix modelling capabilities.
• Connected to Non SAP Systems like OMNI, EIP, OER, SAMSON, SIEBEL for reporting for various business requirements.
• Build various reports to reconcile the data between ECC-BW, EIP-BW, SAMSON-BW
• Created Asset reports and reconciled them with ECC reports for Finance teams for audit purpose.
• Converted DSOs and Cubes into HANA optimized.
• Responsible for gathering the Requirements from the users and writing Functional Specifications and Technical Specifications.
• Configured new reason codes, Sales item types, tender types.
• Enhanced POS workbench with new fields
• Created master data extractors from SAP ECC to SAP POS DM
• Involved in Point of Sales (POS DM) development and PIPE enhancements for the retail data.
• Implemented custom enhancements (BADI’s and Function modules) to enhance the PIPE and to perform custom FULL loads.
• Enhanced PUTAB IDOC to send additional transaction header and Item data fields to ECC.
• Created data flows in POS DM to load retail data into info providers i.e. DSO’s and Cubes.
• Created open hubs to provide data to downstream applications
• Created data flows to extract data from POS DM to SAP APO and SAP BW for reporting purpose.
• Developed the Unit Test scripts and deployed them in to the document repository.
• Consumed HANA models into BW application layer and created BEx queries.
• Implemented new BW targets to support LO and FI requirements.
• Involved in HANA deployment and production cutover activities. Transported objects by creating delivery units between SAP landscapes.
• Involved in executive and analytics dashboards design using Design Studio and Dashboards.
• Defined OLAP connections to extract data from SAP BW sources and developed critical reports like IC Sales Revenue using WebI.
• Used BW/BI best practices and standards to maintain stable Business Information environment

Confidential

SAP BI Senior Consultant

Responsibilities/Deliverables:

• SAP Releases BW 7.0, 3.5 and ECC 6.0
• Identified opportunities to exploit new BI Solutions to support client requirements.
• Experienced in onshore-offshore business model and exposure to CMM, Six Sigma and SOX
• Verified the functional aspect as per the business process and validated the interfaces with other systems.
• Analyzed data management systems and sub-system applications studied data elements/information flows and data import strategies to meet end user requirements.
• Conducted User Acceptance Testing (UAT) sessions with release management team and business user
• Upgraded SAP APO system from SCM 5.0 to SCM 7.0. New version needed in order to enable new/enhanced functionality requested by the business (such as Shelf Life Planning) in the future.
• Extensively used SAP Solution Manager (SOLMAN) in maintaining BPD’s, TF’s and UTS and ITS scripts.
• Handled project planning, unit testing, functional testing and user acceptance testing (UAT).
• Configuring Metadata in the Administration Workbench for replication and Updating of Data Source from the source system.
• Configured use of restricted key figures, variables, exceptions and calculated key figures in queries. Created aggregates to improve the query response.
• Dimensional modeling and extended star schema modeling.
• Worked extensively on standard and custom defined LO and LIS extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery billing information.
• BEx Browser, BEx Analyzer, info objects, info cube, loading business content for BW, Loading data via Flat files, developing data extractors.
• BEx Query Reporting, using Business Content, Generic extraction. Designed Three Info cubes with daily and Monthly Granularity, extraction from PSA.
• Performed Query Performance Tuning by analyzing and applying, aggregates, line item dimensions, data compression, Query read Mode, Bit Map Index, Partitioned parallel query option.
• Developed Global Product Supply Plan Report.
• Developed Order based and Delivery Based 3 Month Summary Forecast Accuracy reports(Constrained and Unconstrained)
• Developed reports for PPSA(The Physician Payments Sunshine Act) which is a legal requirement from CMS(Center for Medicare and Medicaid Services).

Confidential

BI Consultant

Responsibilities/Deliverables:

• SAP Releases BW 7.0, 3.5 and ECC 6.0
• System stabilization and Maintenance for SONY BW application.
• Migrated the 3.x Workbooks to BI 7, to enable users to use new functionalities
• As part of BI 7 Functional Upgrade, upgraded CP (Commitment Planning) load process to BI 7, which includes Migration of data source, created complex transformations, DTP’s and scheduling.
• Thorough understanding of the Functional specifications and outstanding issues related to specifications. Frequent meeting with the functional team to resolve the outstanding issues and regular updating of functional specifications.
• Responsible for developing High level Data flow and revising the Gap Analysis.
• Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying Extended Star Schema modeling principles in Data Design, and used expert knowledge of data warehousing concepts.
• Extensively involved in setting up of procedures for extracting data from SAP R/3 by using generic extraction.
• Developed Info sources and Written several routines in Update and transfer rules.
• Designed and developed process chains (RSPC) for master data loads and transactional data loads with the help of info packages. And these process chains are scheduled for periodically.
• Extensively worked on setting up authorization objects, roles, transporting them, and involved in testing reports based on various roles.
• Created reporting authorizations and user profile maintenance.
• Involved in developing front-end queries using BEx Query Designer and Web Application Designer and publishing results on the web
• Expertise in Reports Generation using BEx Analyzer, building Queries and saving Workbooks (Excel Work Sheets), creation of Custom Queries using conditions, exceptions, variables & structures and created aggregates for frequently used queries.
• Involved in correcting, revising, and improving functional programs to make operating refinements, reduce operating time, and improve present techniques and procedures.
• Conducted training for end-users. Created business process documentation.

SAP BI Consultant

Responsibilities/Deliverables :

• SAP Releases BW 3.5, BI 7.0 and ECC6.0
• Upgraded from BW 3.5 to BI 7.0 Technical Upgrade and Dash Board implementation.
• Interacted with the management and business Decision-makers to identify business requirements. Documented reporting needs of the Business Service and Support Organization and disseminated those requirements into a data warehouse strategy resulting in both operational and analytical reporting. 
• Successfully executed the BI Upgrade strategy from BW 3.5 to BI 7.0 including Pre-Upgrade and Post Upgrade tasks (collecting system objects, Security). 
• Involved in the Pre Upgrade Activities (3.5 to BI 2004s).
• Running of Reports for activation of all the Objects, Running RSRV for the Consistency Check for Master and Transactional Data, Running the Report RSUPGRCHECK Report for Checking the Consistency Check and Alpha Conversion Check.
• Involved in the post Upgrade activities (BI 2004s).
• Migrated Library Items, Web Templates from 3.5 and from 3.5 to 7.0
• Involved in the Pre Upgrade & Post Upgrade Activities for BI Plug-In Upgrade on the R/3 from 2003.1 SP 10 to 200 4.1 SP 12
• Emptying the Queues (SM13 & LBWQ) by running the V3 Jobs. 
• Deleting the Data from the Set Up Tables 
• Running the Process Chains to fetch Data and Emptying the RSA7.
• Resolved many issues around the Upgrade. Created OSS messages for Upgrade issue.
• Conducted the User Training on the New BEx Features. Installed and configured the BI Admin Cockpit. Successfully deployed the New Analysis Authorization.
• Extensively worked in developing Executive Dash Board for presenting reports to the High-level managers, utilized J2EE, Java Script, and VB script technologies for customizing web reports and present the dashboard reports.
• Extensively involved in creating Info Cubes in PS module.
• Performed tuning at data loading, reporting before Go-Live. Analyzed performance statistics and recommended improvements.

Confidential

NetWeaver Consultant

Responsibilities:

• As part of the Wartsila E-Tools Release 1 project Developed custom BAPI's.
• Developed BAPI's for Customer, Installation and Product Modules.
• Developed BAPI for the Advance search of the customer, Installation and Product Modules.
• Prepared Test cases and Test Documents and Unit Test plans. Done Peer Review and helped in integrating all the modules with Enterprise Portal.
• As part of Net Weaver Competency Group developed some POC’s on SSO(Single Sign-On) through Enterprise Portal.
• Worked on CAF (Composite Application frame work) and developed some applications on Approval Process.
• As part of CAF worked on in building a project through web based procurement tool that is designed to facilitate, integrate and streamline the procurement process from consumer to supplier and back. This is a xApp product to build on Net Weaver Platform.
• This product is architected as a scalable solution that will help companies to replace best-of-breed applications and to align with ESA roadmap

Confidential

SAP ABAP Consultant

Responsibilities:

• Review functional specification & understanding business requirements
• Preparation of technical specification according to the functional specifications System Analysis design, Construction and testing.
• Peer review and knowledge transfer to assure quality of development.
• 24X7 support as the project has gone live for the countries France, Germany and Austria.
• Perform Unit testing as per the test plans and prepare unit test documents.
• Worked on MM and SD modules as part of the team responsible for developing reports using ALV and supporting for the project.
• Developed report to populate the custom table as the delivery receipt confirmation IDOC s go through the IDOC INPUT DELVRY function module.
• Created new Pricing Requirement Routines to determine the small order admin fee based on the scale value se within that condition record for the ZL2X condition types.
• Worked on USER Exit EXIT SAPMM61R 001 (Include ZXM61U04) and changes made according to the requirement.
• Created DMEE format tree ZPROMISORY NOTES which is used to create new payment medium program for payment method Promissory Note.
• Changes made to the form ZMMPUR PO LEFT(Copy of MEDRUCK) to print the Address info and some standard text information based on the Message types ZFRT,ZNEF and ZNEP

Confidential

SAP ABAP consultant

Responsibilities:

• Created tables, table maintenance views, structures, search helps and Match codes.
• Resolved short dumps involving internal table by increasing the field size.
• Created several function modules and programs to handle custom defined screens in search helps and match codes.
• Made some changes for the interface program for download and upload contract document from the client. Made changes to the BDC in transaction 'AC02'.
• Involved in the changes to the Invoice Discrepancy Report.
• Involved in the changes to the Layout set ZF150 DUNN 01
• Changes made to the report ymmr0011 picklist to indicate the error message going back to the mail Box to particular material and reservation.
• Made changes to the report ZMMX0035 by adding the radio button for displaying the output to the Spool or to the UNIX file. Added some additional selection parameters and made changes to the select statements. Using the function module “GET PRINT PARAMETERS” send the output to the Spool instead of to the report output.
• Developed report to Extract Vendor Master Records for comparison using RFC in Different Servers. Z AP VENDOR MASTER EXTRACT RFC' function is called remotely for all the systems.
• Developed report to display the Accepted/Unaccepted Service Entry details along with the Check Information.

Confidential

SAP ABAP Consultant

Responsibilities:

• Review Functional specifications and understanding the business requirement
• Peer review and knowledge transfer to assure quality of development work.
• Application server changes made to some programs to get the details of the constant values from the custom table maintained and retrieve the constant values from the function module in order to overcome the hard coding in the program.
• Module pool to convert the selected planned orders to production orders for a selected plant.
• Running MRP at the plant level.
• Selecting substitute materials for the selected planned orders if it won’t have batches
• BDC is used to convert the selected planned orders to production orders and running MRP at plant level.
• Locking the selected plant at user level.
• Application server changes made to some programs to get the details of the constant values from the custom table maintained (ZBC CONST). Retrieve the constant values using the function module in order to overcome the hard coding in the program

SAP ABAP Consultant

Responsibilities:

• Review Functional specifications and understanding the business requirement
• Developed report for sales order list which is used to prepare to pick, pack and plan the transaction. By using Sales Order List, What should be done for transportation and car assignment planning are confirmed.
• Developed report for finding out weather the availability quantity is in negative. This report shows all items for which the open sales orders quantities are greater than stock quantity
• Migration of Material Master Data Vendor Master Data Using Session and Call transaction methods
• Enhancement to add fields to PO Header in ME22 Transaction Using Enhancement MM06E005.
• Migration of goods issue information (MB1A) using BDC session method
• Custom reports, ABAP code optimization, development of interfaces to migrate legacy data - BDC
• Developed RFC function module to check existence of vendor in different servers and developed a report which will interact with the all the servers using the RFC function modules used TRFC technique

Confidential

JAVA Programmer and Web Designer

Responsibilities:

• Developed GUI for Oracle Database that looks like Windows Explorer
• GUI developed through SWINGS and JDBC performs DDL, DML and TCL operations
• Front-end divided into two windows. Left window displays the tables in a tree format through which we can navigate in a database. Right window displays the contents of a table that selected, in table format.
• User can perform the operations that are given by the DBA.