Contact No: +1-631-***-****.

Email: adbamx@r.postjobfree.com

Summary

I have more than 12 years of experience in Software development including 9 years’ experience as SAP BW worked as SAP BI Consultant/ Team Lead/ Technical Lead/ Solution Architect/ SME/ Resource Manager for Business Intelligence Projects.

Have supported clients in developing business models, digital analytical process, strategy and roadmap.

Professional Experience

Organization: Accenture Services Pvt Ltd. July 2010 – January 2018

Project/Client-Accenture Internal Project-offshore-India July 2016–January 2018.

Job Title : Team Leader

Location : India .

Summary—Conducted Trainings for SAP BW on HANA and worked on HANA 1.0 Studio and created prototypes.

Ensured that business capabilities and data were adequately addressed after corporate move to SAP.

Established user community to track issues, enhancements, and newly identified requirements.

Wrote business cases, requirements, mock-ups, test plans, and documentation for new reports in SAP to cover gaps between initially delivered SAP functionality and business needs.

Evaluated business processes, anticipated requirements, and developing and implementing solutions.

Leading ongoing reviews of business processes and developing optimization strategies.

Staying up-to-date on the latest process and IT advancements to automate and modernize systems.

Conducting meetings and presentations to share ideas and findings.

Performing requirements analysis.

Imparted Training on Business Objects- Universe Designer, Xcelcius, Crystal Reports, Webi Reports and Deski Reports.

Awareness on DXC & Sybase replication process flows for Data-Provisioning to SAP HANA

Good understanding of various components of SAP HANA.

Worked on creating Attribute Views, Analytic Views & Calculation Views.

Project/Client-Amtrak December 2013 – June 2016.

Job Title: Onsite Co Ordinator for SAP Business Intelligence and Business Analyst.

Location : Delaware -United States of America.

Summary – Worked as an Onsite Leader and I have been working directly with functional analysts and business users to translate functional requirements into technical specifications, which are further utilized to facilitate the full

implementation life cycle of requirements. Worked as the SAP Business Intelligence and as a Business Analyst.

Worked on maintenance of Purchase Requisitions and Services and analyzed the data by extracting Data from Purchasing, Service master and Plant maintenance Tables and prepared the Reports using ABAP Query Report tools.

Analyze information concerning markets, competition and past marketing initiatives to understand how well the marketing campaigns and programs are performing and to influence the success of future marketing initiatives and campaigns during planning.

Worked on Material Master, Purchasing Info records, Equipment master, Plant Maintenance Master data, Task lists and PM orders.

Worked on Vendor Diversity Reports.

MM Stock aging analysis and Slow moving and Non-Moving report.

MM Department wise consumption report

Logistics report

Applied Material Analysis report (Plant wise, Category Wise, ABC Indicator wise, Functional Area Wise)

Material Consumption Analysis report.

Manufacturing plant wise Dashboard which consist of Comparison of Goods Issue date and Reservation Need Date.

Inventory By plant report.

In addition to the above reports worked on System Forecast Accuracy; Inventory Dollars,Inventory Turns, No of Not in Stocks and Purchase Requisitions

Planning, delegating and executing Cutover Activities for Kernel Upgrades, Support Pack application and Linux Server Upgrades.

Provided solutions well within the specified Service Level Agreement (SLA) time limits.

Established user community to track issues, enhancements, and newly identified requirements.

Wrote business cases, requirements, mock-ups, test plans, and documentation for new reports in SAP to cover gaps between initially delivered SAP functionality and business needs.

Worked with various types of programmers to perform solution validation and facilitate testing.

Trained new users and performed remedial training to existing users, including creating training and reference documents.

Evaluated business processes, anticipated requirements, and developing and implementing solutions.

Leading ongoing reviews of business processes and developing optimization strategies.

Project/Client: United Nations Jun 2012 – Dec 2013.

Location : India.

Summary --- Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects connected to SAP BI. Technical Lead for SAP Business Intelligence

Job Title : Offshore Project Lead for SAP Business Intelligence.

Responsible for designing the Data Architecture for All the modules (SRM, MM, Real estate, Finance general ledger) implemented.

Involved in the Requirements gathering, Development, UAT, and Production support phases of SAP BI,BOBJ and HANA development.

Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for SAP BI, HANA and SAP Business Objects.

Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects connected to SAP BI.

Worked on the following reports.

FMT 2 - Status of Expenditure by Commitment Item by month

FMT 2- Status of Expenditure by Commitment Item (Object Class & Code) & Fund

FM Budget Consumption Summary

FM Budget Consumption Detail

Vendor Evaluation report

Procurement of Goods and Services

Commitment Line Item in Funds Management

FI Line Items in Funds Management

AVC Fields Look Up

Budget Line Items (BCS)

FMT (IMIS) Legacy Datasource

FMT (IMIS) Legacy Data DSO

Budget Line Items (BCS)

Commitment/Actual and Budget in Funds Management (BCS)

Shopping Cart Report

Contracts and Rfx reports.

Business Objects

Crystal reports.

Field mapping between databases, Repository for component reuse, Custom Templates, OLAP reports.

Cross-tab objects,Subreport objects, Text objects, User-defined tool tips for tools and report objects, Running totals expert,Top N, bottom N,sorting N Value, for Top N Style, Reports Custom (named) grouping Hierarchical Grouping.

Developed Crystal reports with statutory requirement connecting SAP BI.

Webi reports.

Customized Webi Front end.

Webi Reports have been created deployed through Info View.

Exported the Business objects Reports to be webi so that all users can view on the intranet

Generated several Templates in Webi.

Created rules, events, Webi reports making use of several Queries(union, minus).

Developed several Complex reports depending up on the metrics and customized several reports into excel, pdf, .csv.

SAP HANA

Hands on experience on SAP HANA Studio 1.0

Complete understanding of SAP HANA Appliance Architecture.

Developed & designed Attribute views, Analytic views, and Calculation views.

Export & Import of Packages

Mass Validation, Activation, Mass copy, Migrate, Auto-documentation, Manage preferences & Generate Time data.

Security & Authorization objects (Analytic privilege, System privilege, SQL privilege & Package privilege)

Worked on SLT, BODS process flows for Data-Provisioning to SAP HANA

Awareness on DXC & Sybase replication process flows for Data-Provisioning to SAP HANA

Good understanding of various components of SAP HANA.

Worked on creating Attribute Views, Analytic Views & Calculation Views.

Performed UNION & INTERSECTION between views to represent business cases.

Expert in understanding of the complete Architecture (Database, Data loading, Data modeling & Administration)

Good working knowledge of SAP BO Data services & SLT replication methods.

Lead internal teams to develop management reports defining problem, evaluation and solution

Develop yearly strategic projects development plans recommendations and spearhead development of Scope of Work,

Administered highway planning, construction, and maintenance, and reviewed and recommended and approved contracts and cost estimates

Excellent analytical, problem solving, decision-making and presentation skills

Arranged with the Enterprise Project Management Organization to define the project scope, funding approvals, and align

Project /Client : Unilever Asia Pacific July 2010 to June 2012

Location : India.

Summary:- Team Leader for Business Intelligence – Integrated Planning .Lead for Change Requests for BI-IP Reports and assisted for smooth running of Planning Cycles for more than 10 countries)Japan,ANZ,Turkey,South Africa etc)

Job Title:Team Leader (6 people reporting)

Understanding User Concerns and Give Appropriate Resolutions for the same.

To Ensure Smooth Process of the Users Planning Cycles.

Analyze and customize client planning processes (requirements analysis)

Concept and development of reporting application using BW 3.5 and BI 7.0

Development of planning sub-processes.

Planning Process.

Extraction of Material Forecast(Demand Planning and SNP Data) from APO to SAP BW System.

Extraction of Plan and Assessment Cycles for Plant and Sales Offices.

Allocate Material through Top Down Distribution to the manufacturing plants.

CCA Planning-Cost Centre Cost Allocation Reports.

Maintain List Price for Material.

Gross Sales Value Calculation.

Fixed and Variable TTS.

Ensure SLA Compliance for the customer.

Maintained Characteristic relationship to derive company code, profit center while planning in planning applications by planners

Worked with reporting agent in creating and scheduling packets for background exception reporting and printing jobs.

Involved in installing business content for standard info objects, info sources, info cubes

Involved in the performance tuning of info cubes, BW statistics and Bex query reporting.

Worked extensively on standard and custom defined LIS, LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery-billing information.

Utilized the Analysis Process Designer (APD) to populate summary cubes using complex queries on other cubes.

Developed process chains to automate the initialization and delta updating of all data.

Published iViews to the Enterprise Portal to be used by external business partners to access BI data.

Created over BEX queries and assigned them to roles by department.

Siemens Informations Systems Ltd. May 2007- July 2010

Project/Client – Paradeep Phosphates Ltd (Paradeep) September 2009 – June 2010

Summary : Worked as a Project lead for SAP Business Warehouse, Business Objects and ABAP reports.

Job Title :- Project Lead.

Location : Bhubaneswar and Paradeep Orissa India.

Prepared entire Proposal and estimation for 150 Reports required by the User for Finance, Human Resource Management, Sales & Distribution, Materials Management, and Inventory.

Scope of Solutions: Focus Areas – FI MM and SD.

Uploaded master and transactional data from files and SAP as the OLTP source. Worked extensively on AWB. Customized info objects, info sources and info cubes.

Used APD technology to display four months of AR details in “61days past overdue” report.

Created Process Chains to automate the data load and data target administration and monitored the processes.

Maintained different hierarchies with accounts relevant for CCA, PCA applications similar to Account group in R/3 in order to send data from Trail balance to corresponding applications.

Developed Start routine in order to load accounts relevant to B/S to Balance sheet cube based on ‘B/S flag’ maintained in master data.

Developed Monthly, Yearly and YTD P&L, Balance Sheet reports and created text, characteristic, formula variables with customer exit processing type.

Documented functional and technical specifications for production support and project enhancements

Customized in HR reports using Variables such as User Exit, Replacement Path, Text Variables, and Formula Variables

Customized standard report templates to meet client requirements. Worked with Template Objects / Web Items (tables, charts, Role menu, Query view Selection, etc).

Part of the First Level Production Support Contact Team for BI 7.0 system.

Transported the installed objects to development system, testing and then to production.

Developed Consolidated P&L, Balance Sheet trend reports, monthly, Yearly and Year to date showing with Actual vs Budget, Actual vs. Forecast data and integrated them into several financial reporting workbooks.

SAP BI-CRM Analytics.

Comparison opportunities and sales orders in sales.

Overview of sales-relevant activities.

Overview of service order lead times.

Overview of all the personalized mails (for any communication channel) sent in a campaign.

Business Analyst

Ensured that business capabilities and data were adequately addressed after corporate move to SAP.

Established user community to track issues, enhancements, and newly identified requirements.

Wrote business cases, requirements, mock-ups, test plans, and documentation for new reports in SAP to cover gaps between initially delivered SAP functionality and business needs.

Worked with various types of programmers to perform solution validation and facilitate testing.

Trained new users and performed remedial training to existing users, including creating training and reference documents.

Evaluated business processes, anticipated requirements, and developing and implementing solutions.

Leading ongoing reviews of business processes and developing optimization strategies.

Staying up-to-date on the latest process and IT advancements to automate and modernize systems.

Conducting meetings and presentations to share ideas and findings.

Performing requirements analysis.

Documenting and communicating the results of your efforts.

Project/Client---MRF Tires Jan 2009 to Aug 2009

Summary : System Analyst and Team Leader for Finland Cluster of Companies’ ordinating, Communicating with End Users and ensure SLA Compliance and completion of Change requests .

Job Title : - Team Lead .

Location : Chennai -Tamil Nadu India.

SAP BI

Ensure SLA Compliance for the customer.

The role includes organizing the team, assigning tasks; arrange meetings and preparing estimations for new requirements.

Activating, Designing and Changing Cubes for New Requirements.

BI-IP

Collecting and Understanding Business Requirements and design Web Templates, Planning Functions and Planning Sequences.

Design and development of SAP BI planning and reporting applications including all aspects (from extraction to data model and reporting/planning front-ends)

Design and development of SAP BI-IP applications (BI 7.0 with NW 2004s)

Integration of reporting and planning applications using SAP BI 7.0(BW and IP)

Analyze and customize client planning processes (requirements analysis)

Concept and development of reporting application using BW 3.5 and BI 7.0

Development of planning sub-processes.

Developed Balance Sheet Transaction Cube to maintain Balance sheet plan data.

Project/Client---Finland Customers

(Metso Oy,Outokumpu,Mlyykoski,Stora Enso,Outotec) August 2007 to April 2008

Summary : System Analyst and Team Leader for Finland Cluster of Companies’ ordinating, Communicating with End Users and ensure SLA Compliance and completion of Change requests .

Job Title : - Team Lead .

Location : Espoo -Finland.

Worked as an Onsite Consultant in Finland for 8 months after which was given the responsibility of an Offshore Coordinator in India.

The role includes organizing the team, assigning tasks; arrange meetings with the overseas clients in Finland.

Ensure SLA Compliance for the customer.

Train the Consultants on the customer business processes and delivery processes.

Worked on BW Admin Workbench, BEX, Web Reporting, R/3 plug-ins for BW, Logistics Cockpit.

Onsite Assignment (Finland) (8 Months).

Project: Implementation

Activities.

Requirement collection and frequent client interaction, technical specification design, frequent interaction with offshore people.

Performed analysis, design, development and implementation of standard & customized Info Cubes and ODS Objects, APD, Query design, handling Transport Objects management, and authorizations object creation.

Data extraction from R/3 and Flat file, integration with legacy system, Business Content installation.

Working extensively on BEx analyzer, Web reporting. 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.

Created Reports for the Materials Management and Sales Distribution Modules.

Project: Technical Upgrade BW 3.1 to BI 7.0 of Metso Oy .

Played an active role in a Technical Upgrade Project.

Activities.

Meeting the timeline of the project.

Clear SPAU and SPDD lists.

Performing the Post-Upgrade Activities.

Installing the New Technical Content.

Migration to the new DTP method of extraction from 3.x.

Modeling

Quality Management

Worked on QM Reports for calculating the Number of Days between the dates in BI 7.0 with the new DTP Method.

Activities

Added the required Key figures.

Calculated the keyfigures for the difference of Dates in the Update Rules.

Activated the Logistics Data sources for Quality Management.

Reports created.

Claim Resolution Time.

Claim Created and Claim Value.

Sales

Created Cubes for Forecast and Multiproviders for Forecast V/s Sales Analysis.

Created Multiproviders to compare the Sales and The Expenses incurred on the same.

Designed the Reports for the Analysis of Sales Orders, Delivery Numbers and Billing Documents with the help of a Multiprovider and Logistics Data sources.

Finance

Installed standard business content on R/3 box for FI/CO and activate BW extractors on R/3 box. Test BW extractors on R/3 box with sample data for FI/CO R/3 modules. Install standard business content on BW box for FI. Test all installed objects including Data Targets (2 for FI-GL and FI-AR including Delta), Info Sources, Info Objects, Query Elements, Data Sources, PSA and ODS.

Materials Management

Purchase and Goods Receipt Report.

The Report shows the PO Details along with Goods Receipts and Vendor Details.

Enhanced the existing Purchasing Data Source and added two Datasources to extract the Purchase Order and its account assignments and the allocation Confirmation and Goods receipt.

Data Mining

Merged the Master Data of Network and Activity with Connectors in the APD.

Configured ABC Analysis for Materials based on the Sales Figures.

Patni Computer Systems Limited March 2007 to May 2007

Project/Client: -Symbol Technologies March 2007 to May 2007

Summary: - Merger of Symbol Technologies with Motorola.

Job Title :- SAP BW Developer.

Location : India.

Handled the entire Project independently.

Converted the data of Symbol Technologies into Motorola Reporting Format.

Changed the Date Variables according to the requirement.

Changed the Queries for the Pre-Merger and Post Merger Data.

Kansai Nerolac Paints Limited. August 2004 till February 2007

Project : SAP R3 Upgrade from 4.0 to 4.7 and BW support and enhancements.

Job Title :-SAP BW and SAP ABAP Developer

Location : India.

Roles and Responsibilities

Modeling

Sales

Creating a Customized cube for Sales. Written Update Rules for Customized Sales Cube from ODS to Cube.

Also developed various Multiproviders for the analysis of Forecast and Budget.

Master Data Maintenance for Customer Sales, Flexible update for Customer and Customer Sales.

Production

Activated The LO Extractors for Production Planning Module for Actual and Production.

Created Cube for Process Order Costing Analysis Reporting For Production Planning for Planned and Actual Process Orders. Also Created Multiproviders for the Analysis.

Materials Management

Activated The LO Extractors for Materials Management Module to extract Purchase Order Details.

Created A Generic Extraction with a Z View for MM Module for Inflation Analysis.

Customization

Enhanced the Standard Data Sources Z fields and populated the Field in the User Exit. Well Versed with Enhancements for Master and Transaction Data. Written ABAP Routines in info Package to Dynamically Set the Selections.

Enhanced Customer and Material Master with fields and populated the same in the User Exit for Master Data Exit

ABAP Skills

APO.

Snotes Applied with the help of Basis.

User Exit to view error logs. To derive Purchase Requisition No. In R/3 and throw it back in APO.

ABAP R/3.

Standard Modifications: Created a Standard Table for new functionality for FI. (EWT and TDS).

Extended withholding Tax and TDS.

Reports.

Report for Non-Operative Vendors, Customers and G/L Accounts.

Generated a Report in Material Master that outputs material vaulted stock grouped by material type & plant

Hitech Software Solutions December 2003 to August 2004

Project-Implementation of SAP system

Job Title :- SAP ABAP Developer

Project Details

As a member of team, responsible for creating and making changes to reports, BDC programs for transferring legacy system’s data to the SAP/R3 system.

Report

Generated a Report in Material Master that outputs material vaulted stock grouped by material type & plant.

Various Companies & vendors details (Region-wise, vendor wise.)

Designed and coded BDC programs

Created a BDC Program for transferring all vendors

From legacy system to SAP using FK01 the data that was being transferred.

ACADEMIC DETAILS: Graduated In Commerce from Mithibai College (Mumbai University) in the year 2003.

Contact this candidate