SAP LEAD CONSULTANT (MM/SD), ERP DEVELOPER

AVALON PHARMA
* Successfully managed a team of SAP consultants, negotiated SLA,
Scope of Work, user licenses (FUE) with SAP.
* Successfully upgraded patch SP02 to S4 HANA 1610 in DEV,QAS &
PRD Systems.
* Successfully completed CSV (Computer system validation ) project.
* Configuration of S/4HANA/MM/ SD/PP/WM Organizational unit and
assignment to overall structure.
* SAP configuration of P2P Cycle like Purchase Requisition, Purchase
order, STO, good receipts and Logistics Invoice verification,
Purchase info record with release procedures.
* Strong knowledge and integration expertise with cross functional
modules like Sales and Distribution (SD), Production Planning, Project
Systems (PS), Plant Maintenance (PM),Warehouse
Management(WM) and Finance & Controlling(FICO).
* Helped in preparing the Business Blue Prints, BPML , FSD and User
Training manuals.
* Uploading of Master Data by LSMW (Material Master & Vendor
master), LTMC and cut-over activities in PRD system.




* Coordination with other functional and developers team to
produce satisfactory output of all custom-developed reports and
programs.
* Analyze business requirements (e.g., functional and technical
requirements, information need, business processes) by conducting
information-gathering sessions with clients, analyzing the information
and being able to document an accurate understanding of their
business.
* Identify the delta points, carefully review the RICEFW and perform fit
gap analysis.
* Extracted master data from legacy system and converted it into
desired formats fitting in templates to upload in SAP, saving
tremendous amount of time in the process.
* Extracted GL, Customer, Vendor, Bank, Loan Balances and
uploaded in SAP on solid cutover strategies.
* Conducted several workshops and trainings periodically during
different phases of project implementation.

AVALON PHARMA
* Providing support to all the users working on ERP from basic trouble
shooting to critical financial and technical issues.
* Interact with ERP team and user's community to gather and
document business requirements.
* Create technical specifications and detailed software design
documentation based on business requirements.
* Regular updates on all modules which includes Accounting, Sales,
Purchasing, HR, Time Attendance, Inventory, Operation Costing
(Manufacturing System).
* Designed and integrated several custom reports using Business
Intelligence tools on user requirements helping the Management,
board and the Users to ease their work on data Analysis and critical
Business decisions.
* Consulting with internal users (e.g., Marketing, Logistics,
Procurement) to develop analyses that lead to actionable insights
that accelerate profitable growth.
* Wrangling data from multiple sources including sales, inventory,
product, and customer databases to create integrated views that
can be used to drive decision making.
* Created several functions, stored procedures , scalar and table
valued functions, views and triggers using SQL Server
2005,2008,2014 .
* Responsible for SQL server logical and physical database design,
implementation, maintenance.
* Extensively used SQL native tools like Index tuning wizard, Database
tuning advisor (DTA), SQL profiler, Performance monitor, Activity
monitor, dynamic management views and dynamic management
functions for monitoring, performance tuning/troubleshooting.
* Automate maintenance plan jobs in SQL Server agent and task
scheduler: such as shrinking database, backup database, index

rebuilding, creating filtered indexes, index reorganizing, cleaning
up, and updating statistics.