Arpita Sharan
[pic]
[pic] [pic]
Professional Summary:
. 10+ years of experience in SAP with Professional Certification from
SAP for Implementation, Production Support, Enhancement and Upgrade
Projects.
> Extensive experience in requirement analysis, gap analysis,
technical design, performance tuning and code reviews,
release management, risk management, system readiness,
creating test scripts, facilitating UATs, project status
reporting, cutover management and project rollouts, etc.
> Extensive experience in cross-application B2B integration
between SAP and external systems like Apttus, SalesForce.com,
ARENA, Concur, MDF, Cloud Applications, Vertex and PR
Application System.
> Extensive experience as a SAP ABAP Development Lead in the
area of SAP-MM, SAP-SD, SAP-FI with BAPIs, BADIs, Customer
Enhancements, SAP WebDynpro, SAP Web-services, RICEFW
objects, ALEs and IDOCs, Workflows, BTEs, SAP-CRM 7.0,
Business Object Repository.
> Proficient in SAP GRC 10.0 for user provisioning, reporting,
access management etc.
> Extensive experience working with SAP Notes/ Upgrade
Activities (SPAU /SPDD) etc.
> Proficient in SAP BASIS for Transport Management, Role
Management, User access, etc.
> Introduced several process improvement experience within SAP
> Development Lead for SAP 6.0 EHP7 technical upgrade.
> In-depth Knowledge of Revenue Recognition, Quote-to-Cash,
Procure-to-pay cycles.
> Extensive experience working with SOAP services, Web Services
Security, SOAMANAGER
> Working knowledge of HANA data modelling.
> Developed the Revenue recognition program for Aruba
. Led a team of 5-8 developers for in-house projects.
> Managed schedules and assignments for the team
> Involved in LOE and budget estimations, scoping and risk
management for projects
> Extensive experience working with onsite-offshore teams.
> Extensive experience communicating with all levels of
individuals, including peers and executives
> Managed several development projects concurrently adhering to
tight schedules and budgets
> Involved in all stages of project management for in-house
projects
. In-depth experience in Data Analysis and Reporting.
. Extensive experience working with the Audit and SOX compliance team
(internal and external)
. Quote-to-Cash Certified Powered by APTTUS
. Completed 3 full life cycle implementations projects in different
roles ranging from technical reviews, and module consultant to
expert guidance in ABAP development
. Proficient in SAP CRM 7.0
. Experience in System Analysis, Design, Development, Testing and
Implementation using EDI translators like Liaison Soft share Delta
. Won several awards and recognitions during tenure at Aruba Networks
and Tata Steel
. Sun Certified JAVA programmer
. Domain Knowledge:
o Proficient in ABAP Programming for forms, reports, enhancements
and exits.
o Proficient in BDC, eCATT & LSMW data migration tools.
o Proficient in cross-application integration through SAP Web-
services, BORs, BAPI and BADIs.
o Proficient in Database Programming - PL/SQL, MS-SQL Server, DB/T-
SQL.
. Extensive experience in working through full project life cycle.
. Experience in BS7799 standard for Information Security and Six Sigma
Methodology for project management.
. Excellent communication and interpersonal skills; worked with people
from diverse professional and national backgrounds.
. A self-starter and a quick learner, with strong analytical skills.
EMPLOYMENT HISTORY
. Aruba Neworks, Inc. Sunnyvale, SAP Development Lead (02/2011 -
Present)
. IBM - SAP ABAP Consultant (08/2010 - 01/2011)
. Aruba Networks, Sunnyvale - SAP ABAP Consultant
(07/2008 - 07/2010)
. MS Engineering (09/2005 - 06/2007)
. TATA Steel, Jamshedpur, India SAP ABAP Developer (04/2003 -
08/2005)
PROFESSIONAL CERTIFICATIONS
. Development Consultant SAP NetWeaver '04 - Application Development Focus
ABAP (Certification ID#: 000*******) - April 2008
. Quote-to-Cash Certified - Powered by APTTUS - August 2014
. Sun Certified Programmer for the Java 2 Platform 1.4 (Certification ID#:
SUN324964) - May 2007
TECHNICAL SKILLS
. Programming Language: ABAP, Java, C, C++.
. ERP: SAP (SD, FI, MM, PS, CRM), SAP NetWeaver, SAP ECC 6.4 EHP7, HANA
. Database: SQL Server, PL/SQL
. Tools: Liaison Delta 5.0, BIRST
. Operating System: Windows, Linux, Unix, Sun Solaris 5.8
. Application Software: MS Office 2003 (Word, Power Point, Excel, Front
Page).
. Processor: Intel 32 bit and 64 bit Processors, MIPS
. Project Management Tools: MS Projects
. Compliance/Quality Standards: SOX, ISO9000, BS7799, Malcom-Baldridge,
Six Sigma(DMAIC)
EDUCATION
. 2005-2007: MS in Engineering, Santa Clara University
GPA: 3.75/4
. 1998-2002: BS(Engineering), BITS, MESRA, India GPA:
3.84/4
References
. Available upon request
Note: For more information about projects please refer the additional
pages.
WORK/PROJECT EXPERIENCE
Organization : Aruba Networks Inc. (FEB'11 to Present)
Environnent : SAP R/3
Module : SD, MM, FI/CO, BASIS, GRC10.0
Role : SAP ABAP Development Lead (Full-time)
NATURE OF WORK:
. Design, Development and Implementation of Cross Application Initiatives
for integration with SAP
. Managed and led a team of 5-8 developers for all in-house projects.
. Requirement Analysis and System Design for all major in-house projects
. Worked on several FI reports for the organization like Org Balance Sheets
. Interface design for integration between several external applications to
SAP - Apttus, Salesforce.com, Cloud Application, Concur, MDF, PR Apps.
. Techno-functional analyst for in-house SD projects.
. Basis Backup for the organization - managed Basis alone for long periods
between transitions
. Strong experience in working with IDOCs - 850, 860, 855, 856, 810s, etc.
. Strong working knowledge of SD processes and integrations with MM, FI
modules
MY RESPONSIBILITIES:
. Designing complex system processes for projects in-house
. Interaction with End Users, Business Process Owners and SAP R/3
functional consultants for finalization of functional specifications and
report formats.
. Design of Technical specification and UTP & Code development and
optimization.
. Code Review and migration for all development objects
. User provisioning, Super-user Privilege management using SAP GRC 10.0
REPORTS/INTERFACES:
. Design and Development Lead for Quote-to-Cash interface with
Apttus/SalesForce.com
. Design and Development Lead for integration with Salesforce.com for
Service Contracts and Entitlements
. Design and Development Lead for integration with Trade Compliance
System(Amber Road), Expense Management System(Concur), HRM
System(Workday), Tax System(Vertex), etc
. Developed the organization Balance Sheet reports (Consolidating, Press
Release & 8-Quarter) in ECC
. Developed the Revenue Recognition Program for Aruba Finance.
. Design and Development Lead for integration with Aruba Cloud Applications
. Design and Development Lead for integration with Salesforce.com for
Customer Returns and ADVs
. Design and Development Lead for integration with a new third-party
shipping plant
. Developed several smart forms for Deliveries - pack/pick lists, invoices,
order confirmations, welcome letters etc.
. Worked on end-to-end SD/MM process including master data management,
order management, invoicing, etc.
. Configured MATMAS05 for new materials creation in SAP.
. In-depth knowledge on ORDERS, INVOIC, BOMMAT, DEBMAS, COND_A,
ORDRSP,ORDCHG, SHPORD IDoc types
. In-depth knowledge of SOAMANAGER
. Worked on several process improvements and integration projects with
reporting tool BIRST and other in-house apps.
. Worked on Aging Report in FI module to change the aging logic for
payments.
. Developed an email generation program to notify users whenever a set of
SKUs are booked in any order.
. Worked on Expense report in FI module to include error handling whenever
a data fails to upload.
. Developed a new report which showed the On-time delivery schedule.
. Created web-service to retrieve SAP Sales order information once the
PGI has been done.
. Created a CATT script for mass reversal of documents using FBRA.
. Enhancement changes to standard report KSB1.
. Automatic Pricing Conditions update for POs using worklists
. Interface program development for incoming orders from SFDC.
. Creating & Maintaining mappings for incoming and outgoing IDocs using
Laision Softshare Delta and Softshare ECS.
. Custom program development for Inventory Extracts based on MB52.
. Worked on creating and maintaining Phycisal Inventory documents.
. Creating extract programs for bookings, shipments and invoices
generated between a given set of dates.
. Creating WSDLs for getting SO details and Partner details related to
the Sales order.
. Custom program to update GRN in outgoing DELVRY05 and INVOIC02 IDocs.
. Day-to-day SD activities of processing IDocs / Orders/ Deliveries.
. Created BDCs and LSMWs to extend Vendors Customers and Materials in a
new company code.
. Created several BDCs programs to create sales orders and contracts in
SAP.
End-Client : KLA-Tencor (Nov '10 to Jan'11)
Environnent : SAP R/3
Module : PP
Role : ABAP Technical Consultant
Location : Milpitas, California.
Project: As part of the implementation of the Custom MRP - Inventory
Reduction project MRP in divisions needs to be modified dynamically to
consider GSS as an alternate source of supply if GSS has excess stock.
NATURE OF WORK:
. Developed custom program to record GSS available excess inventory in SAP
- As part of the implementation of the Custom MRP - Inventory Reduction
project GSS will provide available excess inventory data periodically.
This data needs to be stored in a custom table in SAP so that it is
accessible for other programs to read and update.
. Developed Custom program to create source-lists in divisions for the
parts on the excess inventory list - As part of the implementation of the
Custom MRP - Inventory Reduction project GSS will provide available
excess inventory data periodically. This data will be stored in a custom
table. To ensure transition of inventory from 1801 to mfg. divisions
these materials would need to have source lists in the mfg. divisions
with plant 1801 as the source.
. Implemented a BADI to read the excess inventory data from the custom
table whenever MRP runs and check for inventory in the GSS plant before
procurement - As part of the implementation of the Custom MRP - Inventory
Reduction project, the system should first check the custom table with
GSS excess information in SAP and then determine whether to create a
Purchase Requisition to procure from the external vendor or to procure
from GSS. At the end of the MRP run, the quantity in the table must be
reset to the original value.
. Created a custom table in SAP to store the data coming from the
Tactics/SPO system.
End-Client : KLA-Tencor (Aug '10 to Oct'10)
Environnent : SAP CRM 7.0, Web Dynpro.
Module : CRM
Role : ABAP Technical Consultant
Location : Milpitas, California.
Project: This enhancement to the current Sales-CRM system was to introduce
an ability to categorize forecasts for direct vs. indirect sales and the
ability to determine through search /reporting of those Forecasts with a
Second Shared BU.
NATURE OF WORK:
. Introduced custom fields using AET in CRM 7.0 to capture the Second
Shared BU.
. Two new fields based on PARTNER type data were added to introduce a
Sales type field and Sales rep details
. Enhancements were done to existing reports in Web Dynpro to include
these custom fields.
MY RESPONSIBILITIES:
. Understanding of the flow of the requirement from the Functional
specification
. Interaction with End Users, Business Process Owners and SAP R/3
functional consultants for finalization of functional specifications
and report formats.
. Design of Technical specifications.
. Code development and optimization and Unit Testing.
. Configuring the CRM middleware for the data transfer to and from R/3
systems.
BSP WD Components:
. Developed code snippets to provide an F4 help box for a business
object attribute displayed on a view on the CRM Web Client UI.
. Developed code snippets for the custom fields to be editable
conditionally.
. Developed code snippets to display values from database based on
selections.(server roundtrip)
. Worked on code snippets to generate Drop down list box for one of the
fields introduced.
. Integrated object components (Customer views) into the Account
Identification page of the Interaction Center WebClient UI.
. Worked on CL_CRM_BOL_QUERY_SERVICE to select business objects, Used
CL_CRM_BOL_ENTITY for implementing business objects, Used
IF_BOL_TRANSACTION_CONTEXT to control transaction behavior & Used
IF_BOL_BO_COL to provide collections to hold business objects.
. Developed the multi-edit program tool for Caerus users to update
multiple forecasts records simultaneously using CRM 7.0 and webDynpro.
. Configured the CRM middleware for the data transfer to and from R/3
systems.
Web Dynpro:
. Changed the custom ALV reports using Web Dynpro to include these
custom fields.
. Changed log generation reports to include the new fields.
. Modified a program for mass-editing to sales forecasts having the
new fields.
Organization : Aruba Networks Inc. (Jul'08 to Jul'10)
Environnent : SAP R/3
Module : SD, MM, FI/CO & CRM
Role : SAP ABAP Developer
Location : Sunnyvale, California.
NATURE OF WORK:
. Developed reports (ALV) and interfaces in SD, FI and MM module .
. Worked on designing ALE/IDOC interfaces for various systems to facilitate
data transfer.
. Worked on several BAPIs and other custom-developed function modules to
create web-services for integration between several applications external
to SAP.
MY RESPONSIBILITIES:
. Understanding of the flow from the Functional specification
. Interaction with End Users, Business Process Owners and SAP R/3
functional consultants for finalization of functional specifications
and report formats.
. Design of Technical specification and UTP & Code development and
optimization.
REPORTS/INTERFACES:
. Developed a report program automatically to create the GR for open POs
which is stored in the custom table.
. Developed a report program for getting a scheduled dump of the
customers and their payment-terms.
. Developed a report program to show all the control payments and listed
which are all deposits to the bank either in cash or in checks.
. Developed a interface program to loading of the Chart of Accounts
(general data and company code level data) into SAP from a local file.
. Developed many interactive ALV Grid Reports including various sales
orders and reconciliation.
. Developed an interactive report to display sales orders for particular
customer, items for particular order.
. Developed FI Shipment backlog report to get list of dollar value of
sales orders booked but not shipped in the given period of time.
. Developed an interface to upload corrected inbound invoices in XML
formats into SAP R/3 using standard SAP function modules
. Configured the pricing procedure at delivery with the required
condition type to determine freight.
ALE/IDOCS:
. Developed a custom program in Inbound IDOC user exit to send out
emails to specified list of users whenever there was an error in
processing the sales order IDOC.
. Developed an Interface to replicate the work orders from Legacy system
into SAP.
INTERFACES:
. Developed an RFC enabled custom function module to automate the
creating and updating of Purchase Orders from external Systems and
Applications used in the organization.
. Developed an RFC enabled function module to automatically generate an
XML output of the vendor master data on a real time basis - the
updated and new vendor data and/ or full dump of master data on-
demand.
. Created Web Interfaces for Create and Change Purchase Orders, Real-
time Vendor Master Data Extract for successful handshake between
various applications handling Purchase Requisitions.
ENHANCEMENTS/BADI:
. Implemented a BADI - ZBADIMP_MIRO_WT to add withholding tax info from
a Purchase order and make it editable by the user. The business
requirement was to have the visibility of 1441 Withholding Tax
information in Purchase Orders for US and to deduct Withholding Tax
amount at the time of Invoicing.
. Implemented an Enhancement to auto-confirm the date and time of vendor
master data updates.
. Developing enhancements using BADI and user exits that
created/changed/deleted Sales orders and Stock Transport Orders,
created/changed/deleted Deliveries, assigned/unassigned deliveries to
Shipments, changed Shipments, Posted Goods Issue and reversals, and
updating conditions on Sales Orders--depending on scenario
requirements.
. User exits to populate PO item #; an exit to move freight conditions
into an Idoc transportable field; an inbound Delivery user exit that
updated a custom table with vendor contact number.
. Sales Order user exits to check valid Ship-to partners; and an
outbound Idoc user exit that added an Idoc segment with pricing info
and Order Entry date.
DATABASE:
. Worked on the consolidation of Customer Master data by using stored
procedures in SQL Server 2008. This stored procedure consolidates the
different sites under organization heads and maps it with the customer
master DB. Using this approach we witnessed a 55% reduction of data.
. Worked as Data Analyst for Sales data on the Customer Master System
taking inputs from SalesForce.com, SAP, POS, Expandable and SalesLogix
Systems.
* 07/2006 - 8/2007: Research and Teaching Assistant, Santa Clara
University.
* 08/2005 - 06/2006 - Masters Student at Santa Clara University.
Organization : TATA STEEL (Apr '03 to Aug '05)
Environnent : SAP R/3
Module : PS, SD, MM and FI/CO
Role : SAP ABAP Developer
Location : Jamshedpur, India.
Nature of Work: Developed Reports (ALV, Classical, Interactive), Involved
in the development of interfaces (file, IDOC), Worked on User Exits, BAPI,
SAP Scripts, and Smart forms
KEY RESPONSIBILTIES:
. Writing technical specifications against functional specifications.
. Developing the technical specification into ABAP code
. Interacting with on site coordinator for clarification & suggestions.
DETAILS:
. Developed a bad debt report program which would list of receivable
amount in various aging buckets and risk category for each customer.
. Developed a RFC function module fetch sales details for the serial
number passed.
. Developed a report program to identify any open purchase orders
(STO's, Drop Ship, Standard, etc.) that are open and should be closed.
The purchase orders should be marked "delivery complete" and "final
invoice" (where applicable) if the criteria defined are met.
. Developed a report will be used to search for Quotations & Sales
Orders in SAP. The purpose was to see what Sales Documents are
available with a given set of characteristics - hence also which are
missing.
. Developed a BDC program to Create purchasing Info Records from legacy
system through ME11.
. Developed a report program for extracting the Bill of Materials from
R/3 to legacy system.
. Created commission report for the sales department sorted by sales
representative. The data is extracted from VBAK, VBAP, KONV, and MARA
tables.
. Created an Interactive Report for displaying vendor information. Based
on the selection made the corresponding Vendor Bank Details are listed
such that the line selected in the basic list was visible along with
the secondary list.
. Designed and coded a BDC program for Sales Orders that updated records
in the sales order screen or will create new sales orders depending on
the source data file from external systems using VA01 and VA02
transactions.
. Created reports in SD module such as sales order report, which covers
all organization levels, delivery status, invoice status, shipping
details and partner function details. The data was extracted from
VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, LIPS, VBRP, MARA, VBEP and KONV
tables.
. Created report lists for the gross sales, credit returns, gross weight
for the customer for the current year and comparing the same with that
of the previous year for the same period. The data is selected from
KNVV, BKPF, BSEG and MARA.
. Implementation of BS7799 standard for Information Security at Tata
Steel:
. My responsibility included defining the process to be followed at ITS,
auditing various areas/domains for compliance to BS7799 standard and
conducting training covered under the scope of BS7799. Also
contributed to Business Continuity Planning process for ITS and IT
enabled services.
1245 Kelley Way
Santa Clara, CA 95054
Email: ************@*****.***
Cell: 408-***-****