SUMMARY:

• 15 years of total IT experience with 13 years of SAP Consulting providing technical design, development & support for SAP projects. Experience with SAP implementation, Upgrade & support projects for various industries. Proven ability to gather client requirements and create applications to meet specifications. Recognized as a creative and effective technical planner, troubleshooter, and problem solver. Strong communication and coordination skills in fast - paced information technology situations.
• SAP HANA modelling & development, SQL Scripting, Data provisioning, BW HANA
• Advanced ABAP (including RICEFW, OOPs), NW Gateway (OData) & Web Services
• SAP Certified in CRM 7.0 technical
• BOBJ Analyis & reporting (IDT) Web Intelligence, MS Excel
• BODS data services(ETL)
• Forms - Smartforms, Adobe forms
• Techno-Functional Exp in SAP ISU Utiltites & ECC modules

PROFESSIONAL EXPERIENCE:

Confidential -NJ

SAP HANA with BOBJCDS development

Responsibilities:

• Closely worked with PMO and provide necessary support on all phases of project.
• Played key role in providing HANA modelling & development(CDS) with technical design, development & testing.
• Enhanced the custom reports with Material Grid values in Monitor Reports
• Developed enhancement for Stock emblems and ME emblems after conversion of the emblems from legacy using LSW
• Developed custom objects based on OO concepts design principles. Created custom utility classes & methods that can be reused in programs.
• Created various HANA views in HANA studio- Attribute, Analytical & Calculation views as needed. Filtered the views using variables & input parameters as required.
• Developed attribute views & calculation views for device category (MM) and plant storage data(LGORT)
• Created stored procedures(SQL Scripting) for calculating the size measure values & variable price values.
• Created analytic privileges to grant access to some portion of equipment views as part of security measure
• Leveraged HANA Core Data Services (CDS) to create tables (entities) various objects types, Create an SQL views & its association with entities,user-defined structured type
• Used SAP BODS (Business Objects Data Services), SLT technique and DXC to retrieve data from different source systems & load into HANA
• Created & scheduled batch jobs in data service designer for data load process from various types of sources to targets HANA tables.
• Efficiently used the tools involved in data designer - data flow,abapflow,workflow, query transformation & mapping,validation checks, table templates, abap flows.
• Developed data load interfaces to load data from ECC into HANA through SAP Data services(BODS).
• Familiar with BODS integration with BAPI’s & Idocs.
• Performed joining multiple data sources (webi, isu tables, flat files,etc) in Excel & MS Access for creating new reports
• Fine tune HANA SQL script queries and implemented corrective action using explain & visualize plan
• Performed HANA view optimization & visualization tool meant for optimization, used CE functions as alternate to SQL queries

Confidential

SAP ISU Billing & Device Mgmt, CCS

Responsibilities:

• Assisted the project team with technical implementation & delivery of ABAP (RICEFW) & HANA objects with design, development & testing.
• Interfaces Developed SAP-TIBCO workflow interfaces for CIQ product ( Confidential s) for Smart hours enrollments for all smart meter customers.
• Extensively worked on BOR Objects, certain R/3 entities such as Equipment, device category (Material Master)
• Experienced with the ISU billing exception process (EMMA), Billing integration to DM, CCS/CR&B & exception handling process using BPEM
• Obtain the actual & estimated billing determinants data from 3rd party system (Energy ICT) via web services and update the open MR orders in SAP
• Developing variants program for billing schema, outsorts, custom rates assignment, operands & controls, Installation fact updates.
• Familiar with Meter-to-Cash Cycle; Device Life cycle(Meter); Meter Read Upload & Download processes; Meter Read Validation, Estimation and Correction.
• Configured the Meter reads for multiple reasons for final billing, Meter Reading Orders, related processes, Disconnection/Reconnections etc
• Created Device Master Data, Device related processes i.e. Device Installation, Removal, Replacement, Reversal, Device Modification, Device Allocation, Device Grouping etc,
• Device installation & removal, extending the device validity for a period, perform billing related Installations, rates.
• Extensively worked on BOR Objects, certain R/3 entities such as Equipment, device category (Material Master)
• Registers - Register Modifications, Register Group Modifications, On Peak Off peak Register types

Confidential - Dallas TX

SAP ABAP,HANA Dev & Modeling

Responsibilities:

• Key role involves implementation of Technical design, development & testing the development all the RICEFW objects (ECC & CRM) involved.
• Provided assistance to functional and technical team whenever necessary in order to maintain quality delivery
• Extensively worked on the typical SD Order-to-Cash (OTC) business scenarios, Contracts, Scheduling Agreements, Sales returns, Stock Transport Orders (STO), Goods receipts and transfer postings & Pricing
• Created & used Z* classes for updating the application log for BPEM analysis (Billing messages)
• Strictly followed the Object Oriented(OO) abap concepts & design patterns, converted the traditional custom programs to follow OO concepts as applicable.
• HANA Development - Developed regional Sales Info calculation views & written stored procedures to calculate the net discount value
• Addressed the requirements for access control using Analytic Privileges
• Familiar with change Management process that involves transporting the changes( Deivery unit) to Production on periodic basis
• Created Decision tables graphically & also via procedures to assist business users for what if analysis
• Used SAP BODS (Business Objects Data Services), SLT technique and DXC to retrieve data from different source systems into HANA
• Developed data load interfaces to load data from ECC into HANA through SAP Data services(BODS).
• Configured the Job server(Server manager), Created data stores, data repositories as needed to house the objects developed
• Fine tune HANA SQL script queries and implemented corrective action using explain & visualize plan
• Performance Tuning - Used different SAP Tools like SLIN, SE30 (Run Time Analysis) and ST05 (SQL Trace) to identify potential problem areas in ABAP Code.

Confidential - Dallas, TX

SAP IS Utilties CR&B Ehp 6.0

Responsibilities:

• Key role involved SPDD, SPAU & Enh adjustments for all the technical objects as necessary w/o OSS notes.
• Responsible for technical upgrade activities for SAP module to Ehp 6.0 version. Implemented all phases of the SDLC methodology.
• Managed an offshore team to carry out the technical upgrade tasks - SPDD, SPAU & Enh adjustments for all the objects as necessary w/o OSS notes.
• Proficient in debugging SAP standard programs & implementing OSS notes. Provided corrections to some missing piece of code to SAP in the new program stack.
• ISU Billing - Developed a Billing Run summary Report based on the rate category & Portion that helps user to identify print documents & invocies.
• Cash desk payment receipt showing details of consumption and non-consumption payments(PWB)
• Worked on billing scenarios such as customer discounts, taxation, bills on demand, bills upon contract termination (Cancel/Rebill), budget billing..etc
• Worked on Biller Direct (UCES) interfaces, Customer billing, invoicing & payments (.
• ISU CCS- Worked on CR&B scenarios - Customer move in/move out processing, Customer data update issues, called via FOP process.
• Working knowledge on Meter to-Cash related scenarios & Bill Print issues(PWB)
• ISU FICA - Cash Desk Payments (FPCJ), disconnect/re-connect, Customer Donations Payments, Account Determination(ADID), Write-Offs / Value Adjustments
• Payment upload interface & Lock Box upload interface to validate the customer accounts to avoid misapplied payments
• Issue resolution on short dump and update termination analysis. Extensive experience on trouble shooting and performance tuning..

Confidential - Omaha, NE

Onsite Technical Lead

Responsibilities:

• Billing & DM integration - Extending the device validity period, meters submeters, vevice installation & removal,perform billing related Installations, rates.
• Bill print Issue(RDI) resolutions based on complex validations based meter types & rate categories
• Working knowledge in correspondence using FPCOPARA & Dunning print date issues with printing
• Devloped a complex interface used by customer service personnel (via CRM). Service Orders are scheduled via CRM as front end by the Call Center Personnel.
• Analyze functional and technical system design for testability and data feed processes for data quality
• CRM - Calculation of average bill and update the same in the CRM 7.0 fact sheet using BOL & GENIL components programming
• CRM - Enhancing Confidential components for CRM Confidential (front end) like enabling/disabling a field,Middleware monitoring of BDocs
• Installment forms (PWB), Customer Late Payment charges & Issue shut off notices to customer via dunning levels.
• Developed couple of file & Idoc interfaces to handle customer payments, collection agencies and pre notification files in NACHA format (FQEVENTS).
• Proficient in finding & using FQEVENTS at appropriate places to make enhancements whererver needed.
• Developed core logic for My Account interface by creating respective RFC’s and publish them as Web Services for Java(front end)

Confidential - Jackson, MI

IS Utilities - CCS, DM, FI/CA

Responsibilities:

• ISU CCS - Developed interfaces for Customer payments over net (PON), Payment Cancellation, installment plans & BB via Web based UCES
• Enhancement point(BADI) to trigger emails via UCES whenever changes are made to cust profile
• Customer call and identification via Front office(CIC0) - Change rates, Invoice details and issues with customer billing for industrial, commercial, and residential customers
• BP Contact Configuration for Contact creation, updation & usage for work order Notif or wherever necessary
• Interfaces to automate Power outages & Street light repairs(OMS) whenever a customer complaints the problem via Web(UCES Portal) & Mobile.
• ISU Device - SAP Meter Asset Unit(MAU) interface via Pi(Xi) to change old meters,upload meter history data, change the stock codes for the meters (IQ02). Also includes MM interfacing scenario to Perform Goods issue(PGI) & Goods Receipt (GR)scenarios for devices from warehouse & vice-versa using BAPI GOODSMVT CREATE
• Performed full cycle Device Installation (EG31) from PGI(MM), Device Certif & Customer Move-ins for Electric set Notifications
• Worked extensively in Service Management area for various scenarios involving creation of Service notifications(IW51) based on Customer type and divisions - Gas & Electric
• Configuration (SPRO) of Profiles for Work Order creation to be interfacing to external systems
• ISU FICA - Worked on triggering of Dunning cycles &scnearios for customer non payments
• Worked on the creation & deletion of Installment Plans(IP) payment processing & releasing to Dunning for non Payment.
• Searching for relevant FQEVENTS and making use of them at appropriate places to make an enhancement wherever needed

Confidential -NJ

ABAP/4, Catch Weight (CWM) SD, MM

Responsibilities:

• Interfaces - Developed outbound proxies to ETL via PI (Xi) interfacing for various master data extracts from SAP 4.6c to load into SAP ECC 6.0.
• Issue resolutions for problems in BAPI Pricing conditions and by passing the std SAP validations checks. Applied OSS notes wherever applicable.
• Worked on SAP Catch weight (CWT) module for creating Vendor Rebates/ Customer Rebates, Vendor Rebates & Settlements with related BADI's/BAPI's and the Info structures(S015&S074)
• Module Pool - Developed a complex program (module pool) to create a Purchase Order in a quick way. The program holds interactive & editable ALV(using OOP's)
• Made use of the SIMPLE TREE Control(OOP's) to create a Tree report.
• Enhancement - BADI's to carry out validations for PO line items & conditions as per given requirements
• Smartforms - Extensively worked on Smart forms to smartforms for Sales Order confirmations, Purchase Orders, Load sheets, Billing Ticket, Pick Tickets
• Performance Tuning - Proficient in performance tuning for optimizing source code and production support to improve run time efficiency.
• Used different SAP Tools like SLIN, SE30 (Run Time Analysis) and ST05 (SQL Trace) to identify potential problem areas in ABAP Code.

Confidential-Richmond

SAP R/3 ABAP/4 Upgrade

Responsibilities:

• Interfaces - Developed FI interface to post vendor invoices (F-43) from legacy system into ECC 6.0 and R/3 4.6c using BAPI ACC RECEIPTS AND POST via synchronous PI(Xi) calls
• Pre processor program to update the changes for delivery returns (VL02n) with a ‘Shipment End’ Milestone The process follows EDI 944 messaging
• Maxpro Upload interface application for delivery creation from Sales Orders & STO via BAPI calls using BAPI OUTB DELIVERY CREATE SLS.
• Enhancements - Worked on new Enhancement Framework to determine if the shipment is freight cost relevant and PO vendor extension to company code. If sales order is sales tax relevant a pop up is issued for Sales Tax Warning.
• Conversions - Data load using LSMW for V-12 (Customer Master Creation) & BAPI usage for association of Customer Hierarchy (VDH1N) based on the ship-to-customer.
• Cost center activity and Price uploads (KP26) using the BAPI. The same BAPI is used with different input for both purposes.
• Conversion for Sheeted & Pallet materials into MSF or ROLL units as applicable to a Sales Order & STO’s
• Module Pool: Developed a transaction that helps in inventory forecasting for all produced goods. This application is mainly based on APO module.
• Adobe Forms - Developed forms based on Adobe Print & interactive forms for Purchasing & RFQ documents and Dunning letters.
• FI Validation & Substitution routines to disable the reason codes while posting or changing the document for a customer line items (Fb02) in a company code(s)

Confidential - CT

ABAP/4 with Design, Development & Support

Responsibilities:

• Worked on EDI 820 (remittance advice), EDI 867 (consumption history data) of a given customer for the past 30 months.
• Unique identification fix for the EDI 814 enrollment response scenarios for a given customer enrollment or drop/change scenarios.
• Developed an ALV report to compare the distributor rate category ( Confidential ) for a given range of PoD’s or Contract Accounts.
• Device Meter Reads -A daily report that lists Meter Points by Read Date where invalid profile readings received equal to no. of working days
• An enhancement for full Installation (EG31) to enter service provider details and update them to ESERVICE table
• Worked with Multiple contract billing for Lightning units & small power procedures.

Confidential - New York

SAP ABAP Consultant

Responsibilities:

• Worked on scenarios in Order to cash process cycle (SD module) involving deliveries & billing interfacing FI
• Confidential online billing system - A simulation to migrate the all customer billing process being done through SAP. The scenario SAP - BW interfacing to pull the customers subscription data reports.
• Outbound Interface for Customer related data that captures creation & change events using BOR methods & workflow triggering.
• Confidential processing that parses an inbound file/statement containing invoice no, amounts and updates the underlying SAP billing and accounting documents.
• Written a couple of FI validations & substitution routines for trans OB28 to check for vendor account assignment. Validation for the invoice amount depending on the vendors.
• 56 day Dunning letters correspondence for the customers whose dunning levels reaches 3 & 5 using Smartforms.
• Developed Smart forms for purchase order, contract, scheduling agreement.
• Module Pool program for Confidential recording system. A development to calculate the no of working days an employee billing & delivery reports. The object is a resource management tool that investigates the resources actually used in a sales campaign for product marketing.
• Customer master data updation through Mobile order capture (MOC) wherein customer master data is updated thru a legacy application (Visual Basic) loaded on sales representative’s laptop.

Confidential

SAP ABAP Consultant

Responsibilities:

• Worked with Functional Team in creating technical specifications and code development activities & issues.
• Data Conversions in SD module -Order to cash to extend the given customer tother sales areas.
• Developed enhancements for Standard IDoc for Delivery. Created custom child segment for Standard Segment E1EDL21, using customer exits in the IDoc function module to post the data in custom segment.
• Created a FI stock report which represents the inventory owned and value in the in transit stock. This report is reconciled with the stock accounts in the trail balance.
• Developed custom Invoice Control Report using ALV Grid functionality. This Report was used to display all the Invoice documents which were posted but not printed.
• Member of a performance optimization team. This team was responsible for optimizing source code performance to improve run time efficiency. Used different SAP Tools like SLIN, SE30 (Run Time Analysis) and ST05 (SQL Trace) to identify potential problem areas in ABAP Code

Confidential

Senior Software Engineer (SAP ABAP/4)

Responsibilities:

• The development role involves design & builds (coding) for IS-Utilities modules - Billing & Device Management, Customer Care services.
• Created an interactive report to display manual & auto billing blocks report at various levels - Cont Acc,Contract, BP & Installation level.
• FICA Enhancement for customer bill collection activities based on dunning levels.
• SAP - SIEBEL interfacing via *egate as middleware. Processing of automatic & manual customer requests & complaints.
• Assembly testing phase which has been carried out for all the RICEFW developments at technical level.
• Exposure to Workflow processing activities - deadline monitoring of workitems & idoc inbound error handling by changing the status of work items.
• Product Testing - Execution of business level scenarios for SAP-SIEBEL interfaces in the areas of ISU- Billing & Device Mgmt, ISU-Finance, ISU-Customer Services.
• Worked on various change request (CR) cases - meter reads for a given CA and the installation time slices & Installations, Device no.