SUMMARY

• 9 years of implementing SAP BI modules of Finance, CommOps and TechOps with integration of other SAP modules this includes 2 years of HANA modelling.
• Breadth of Experience Starting from Blueprint Phase, Conduct workshops, Realization (Configuration, Preparation of FS, Guide Technical Team), Testing, Cutover activity, Training, Go Live & Post go - Live support and Project management.
• Experience in the FCRS reporting used for NAM ( Confidential Accounting Manual) tool and COPA development. Also in System Optimization of BI 7.0 and 7.30 and experienced in the Extraction Transformation Loading and reporting process.
• Creating custom extractors based on view/tables/Function Modules etc. and knowledge on setup tables for Logistics.
• Working knowledge on security and authorization areas.
• Worked on various kinds of Performance Tuning techniques such as compression, aggregates and rollup, BWA.
• Expertise in creating process chains, Meta chains, Scheduling Start Process, monitoring process chains etc.
• Expertise in SAP ABAP which is used in BW and has used it extensively to optimize the codes. Has been part of the code review and transport manager team.
• Experience on Native HANA and SAP BW powdered by HANA
• Experience on SAP HANA Data Provisioning (LT, DS), Data Replication, Modelling and Reporting
• Have a good knowledge on SAP HANA Architecture & Landscape
• Involved in designing Dataflow from SAP ECC 6.0 to SAP HANA Database
• Experience in User Management and Analytical privileges
• Involved in Transporting HANA Views from Dev to Pro using Delivery Units
• Have hands on experience on modelling in creating Attribute, Analytic and Calculation Views
• Worked on all kinds of Join Types in SAP HANA
• Experience in creating Stored Procedures, Triggers, Decision Tables, Temporary Tables and History Tables.
• Worked on mixed scenarios between BW and HANA
• Experience in Designing the BW models specific to HANA
• Worked on Composite Providers, Transient Providers and Analytical Index
• Worked on Open ODS and Advance DSO

TECHNICAL SKILLS

SAP BW: Underwent an extensive Training in BI. Familiar and confident in planning and development of data model and reports . Specialized in COPA development and reporting.

SAP ABAP: Underwent training in SAP ABAP. Experienced with ABAP required in SAP BW

SAP HANA: Extensive Techno Functional experience in HANA

System Optimization and Tuning: Instrumental in optimizing the SAP BI system in terms of its performance using ABAP code and remodeling

General: Good knowledge in systems Architecture, Clients, Instances and Technical Objects. Very Good knowledge & experience in setting up Logistics Enterprise Structure, Preparation of Blue-prints, Adapting and rolling out the solution globally across countries in different Time-zones.

DLM: Experience in managing process chains and providing refreshed data to 2000+users across the globe

SAP ECC 6.0: Good knowledge & experience in creating BI data sources or extractors in ECC with its different types.

Common Processes: Understanding of common processes like Goods Receipts (Inbound Delivery, Purchase Order, Process Order, Return Deliveries etc.) / Goods Issues (Process Orders, Cost Centre, Outbound Delivery, Scrap)/ Stock Transfers (Plant and Storage Location in 1 and 2 Steps) & Transfer Postings (Stock Type) Financial process from Accounting to COPA and Accounts receivable

SAP BO Dashboard: Fair understanding on Webi reports and good knowledge on Dashboard 4.0

Non SAP Skill: QlikView Fair understanding on QlikView reporting and dashboard

PROFESSIONAL EXPERIENCE

Confidential, Texas

Team Lead and HANA Developer

Responsibilities:

• Responsible for managing team at offshore and managing their works. Team comprises BW and BOBJ developers at offshore.
• Responsible in gathering requirements from business and planning the design and model of reports. Aligning toll gate review with business and ensuring the testing is done appropriately and timely by business.
• Involved in designing the functional and technical specs for the ECC 6.0 and HANA Models.
• Involved in SLT for replicating the data from ECC 6.0 to HANA.
• Involved in Provisioning of Data from BODS into HANA
• Have created and generated the Documentation form HANA into PDF format
• Experience in SAP HANA data provisioning using SAP LT Replication Server (SLT) and data services and Flat files.
• Worked on BW powered by Hana.
• Designed and developed custom Hana optimized DSO objects, and activated Transformations for these data targets and evaluates data.
• Involved in DB migration from BW to HANA Data base using DXE
• Experience in SAP HANA security including user management, roles and privileges
• Worked on inventory info cubes for HANA Database.
• Created In memory optimized info cubes and DSOs.
• Created Information spaces for Hana optimized info cubes.
• Modelling HANA views for BW 7.4master data and transaction data.
• Created Advance DSO and Open ODS
• Involved in hybrid concept between BW powered by HANA and HANA enterprise.
• Created Transient Providers and Analytical Index to import HANA Models into BW using T-Code RSDD HM PUBLISH.
• Composite Provider in HANA eclipse.

Confidential, New Jersey

SAP BW and Hana Consultant

Responsibilities:

• Responsible for design, development and extraction from R/3 source system and Flat file to BW. Extracted the data using LO Cockpit Extraction from the Data Sources to populate the Custom Info Cubes that evaluates quantities and values for sales orders, deliveries and returns, and invoices.
• Activated Logistic cockpit extractors for sales, billings and purchasing modules and enhanced them to capture the additional information not part of the extractor.
• Involved in functional team meetings to discuss end user requirements.
• Worked on Business Content for, CRM, Sales and Financial Info Cubes to meet with user requirements.Responsible for loading Plan/Actual Master data (Texts, Attributes and Hierarchies)/Transaction data from ECC Data Sources and from Flat Files.
• Worked on Time dependent Master data. Worked on FI-COPA Cubes to store the information for the next level usage. The Important cubes used were: Published Key figures, CRM marketing, Consumer Products industry. Extensively worked on several kinds of COPA structures: Net sales, Contribution Margin, Operating profit.Worked on different levels of reporting required for SD Order intake reports and FI Cash flow reports.
• Involved in designing the functional and technical specs for the ECC 6.0 and HANA Models.
• Involved in SLT for replicating the data from ECC 6.0 to HANA. Involved in Provisioning of Data from BODS into HANA. Have created and generated the Documentation form HANA into PDF format. Experience in SAP HANA data provisioning using SAP LT Replication Server (SLT) and data services and Flat files. Worked on BW powered by Hana.
• Designed and developed custom Hana optimized DSO objects, and activated Transformations for these data targets and evaluates data.

Confidential, New Jersey

Project management and Hana Consultant

Responsibilities:

• Responsible of handling and delivering the project. The project involved the BI/BW, QlikView and Finance/BPA team.
• Responsible in gathering requirements from business. Ensuring in creating project ids and the documents for the kick-off of the project. Conducting weekly meetings with the team members taking status updates from team members and ensuring smooth flow of the project.
• Aligning toll gate review with business and ensuring the testing is done appropriately and timely by business.
• Involved in Data Modeling activities.
• Experience in SAP HANA data modeling using Attribute View, Analytical view and Calculation view.
• Involved in information design tool - creation of data foundation, universe for Hana reporting.

Confidential

BW lead and consultant

Responsibilities:

• Developed sales in and sales out report which was previously used in COGNOS in combination with Confidential Pharma. More than 22 Finance reports were rolled out during this phase.
• Finance reports included FCRS reports like GX reports, Balance sheet and Income statement reports which are supposed to submit reports to NAM.
• BI academy training was conducted by me for the business user to give an understanding about the usage of BI reports and to create their own reports. Also helped the business for successful month end closing.
• I was the lone BI resource handling the roll out and implementation of complex requirement for sales in and out report. BI team was the only team with status green after the end of testing and final review.
• Ensured correct roles and authorization is given to business by checking the roles and analysis authorization component used in the roles.
• Responsible in delivering different projects like A/R dashboard reporting for Confidential USA, Order Evolution process for USA, Capital expenditure reporting for Confidential India and OTC US. COPA development and Financial KPI cockpit to view the invoice verification related reports for different sites.
• Overview of the projects covered:
• A/R Dashboard reporting for Confidential US: A/R reporting gives the details like the Overdue invoices, Gross DSO, Net DSO, Gross A/R, Net A/R, Disputed deductions, Total deductions, Value of deductions, Volume of deductions.
• Capital expenditure report for Confidential India: The CAPEX also known as capital expenditure is expenditures creating future benefits. It is incurred when a business spends money either to buy fixed assets or to add the value of an existing fixed asset with a useful life extending beyond the taxable year. This gives information on project level for the amount budgeted for the year and the amount spent.
• It would give the information like the Budget, Capitalization, Spending and commitments.
• Financial KPI cockpit: This gives information on the requisition to Pay. The objective of this report is
• To be able to benchmark the total process cost within Confidential as well as with other companies within the same industry.
• To reduce the number of invoices which stay in a Parked or Blocked status longer than 60 days (and to identify and eliminate the root cause of these failures)
• Allows for review of average payment days (by value) and for comparison to the Average Weighted PO Terms to identify “early payments” and to identify working capital improvement opportunities
• Measures adherence to R2P & Procurement policy and productivity of process
• Measures the quality of AP payments according to agreed payment terms and to maximize this % by increasing the number of invoices paid on time. to minimize the number of GR/IR aged items
• FCRS: Financial reporting tool which adheres with international accounting standards. Responsible in creating the GX3A reports and managing the other FCRS reports and supporting North America and Europe during month end closing.

Confidential 

DLM Lead 

Responsibilities:

• Optimizing the BI system and enhancing the speed of different process.
• Identifying the BI jobs which consumes huge amount of time and ensuring that the performance is improved using optimizing the ABAP codes or by remodeling the BI data model.
• Played a key role in ensuring the data load runtime reduces by 3 hours (9hour to 6hour runtime).
• Ensuring data refresh on time so as to provide data to 2000+ users on time. I was responsible in managing and leading the DLM team in Asia pacific region.
• Responsible to close the aging open change documents for audit purpose by aligning with business sand change request owner.

Confidential

SAP-ABAP and BW consultant

Responsibilities:

• Optimizing the BI system by enhancing the ABAP code in BI environment.
• Ensuring data refresh on time.

Confidential 

SAP BW consultant - DLM Team member

Responsibilities:

• Ensuring data refresh on time.
• Checking on the data load error and fixing them