Email: ac8d16@r.postjobfree.com

470-***-****

Atlanta, GA

Specializes In

Lead ERP Data Model Developer – SAP ECC/S4 Hana, SAP HANA, SAP Data Services, ALE, EDI and Workflow

Aravind possesses diverse Lead developer with senior hands-on solid Leadership, Architectural, Delivery and development experience in SAP ERP, SAP HANA Data Modelling, Data Profiling, Data Archiving, Business Workflows, EDI, and ABAP. He has strong Functional, technical implementation and upgrade process experience throughout complete cycle of the project in design, analysis, development, testing, cutover tasks, QAS, and production support .

He has 21 years of experience in designing end-to-end best practices around ERP, RDBMS, Internet applications, Web Services, o-Data services, and ETL tools in many business processes and functional areas specialized in manufacturing, service, pharmaceutical, Food and public sectors.

During in his extensive experience in technical areas he has developed excellent functional area experience in OTC, Production Planning, RAR, Financials, sales and distribution, logistics, EH&S and human resources along with good proven leadership skills managing the technical development team.

Good exposure and knowledge of SAP Master Data Governance (MDG). Partly involved in workshops designing customer data or material data as central master data where data is needed in multiple systems. Tasks performed such as activating MDG, activate portal UI (nwbc), create master data, staging tables, and workflows triggered to sent to the next stage for approval in UWL.

Summarized Experience

Years of SAP Experience:

21

Industry Experience:

Manufacturing, Process, Distribution, Food, Retail, Electronics, Public Sectors, and Information Technology

SAP Solutions Experience:

SAP ERP, SAP HANA, SPA HANA Studio, Eclipse, Web-based Development Workbench

SAP Area Experience:

SD, MM, PM, PS, QM, FI, CO, PP, WM, HR, HCM, RM, SRM, BW, EDI, IDocs, BAPI, BADI, ABAP, XI/PI, ALV, ABAP-OO, oData Services, Web Services, Data Dictionary, SMARTFORMS, Business Workflows, NetWeaver and WebDynpro

Education

Masters in Computer Applications: Kakatiya University, India 1997

Bachelor of Arts in Economics: Osmania University, India 1993

PG Diploma In Computers: Itegra Computers, India 1994

Professional SAP Highlights

AG Corp, Atlanta, GA ( May 2018 – Present)

SAP HANA Data modeling, Data Profiling, Data Anallytics, SAP ERP, SAP Data Services

Responsible analyzing the current data modeling in place to design an efficient data integration, data migration, data modeling, and data connectivity between multiple SAP systems and Non-SAP systems. Used SAP HANA, SQL Server, SAP s/4 Hana, Data Services 4.2, Data Services Designer, Job Server, Management Console, Eclipse, Hana Studio, Data Views, oData REST services, ABAP, IDocs, and ABAP Web Services.

The project is related to bring the Agco machinery/product data, customer data, services data, machine upgrades to be integrated together for data modeling, analytical and reporting purposes.

Proposed best practices in architectural and development objects.

Created required database and table in HANA then using Data Services, Integrator, data quality, the machine and PO data is migrated to HANA.

Designed Data modeling, created views and O-data services for accessing/updating HANA over API’s from third-party systems.

Sabre Airlines Solutions ( Aug 2016 – Mar 2018)

Sr SAP Hana Data Modeling Architect and Developer

Understanding, analyzing the existing material, product and sales data versus current ETL requirement. Designing efficient solutions following best practices. Responsible writing functional, technical specs, development, unit and functional testing in related Data modelling requirements in MM, FI, SD and PS areas in ECC6 on HANA/4 platform and SAP S/4.

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Developed complex calculation view using SQL and CE-Function and Developed data models for the operations, PP, MM, Quality management tables in HANA.

Extended and enhanced Standard OData services (Added fields / removing fields). Creates CDS views and modified CDS Views.

Create OData service for consuming external system SAP HANA.

Deigned, Implemented, and deployed SAP Data management solutions, Profiled, Extracted, Transformed, Cleansed, Interface, and Converted data and information for end-to-end data management including Business Objects Data Services and Data Conversions.

Used SAP Data Services in extracting product and material data from SAP ERP, and migrating data into SAP ERP and loading, updating data into SAP HANA.

Development tracking, presenting status reports to management, creating standard documentation templates for functional and technical specs.

Designed data migration strategy for the data from ECC for all existing SD01, SD02, and SD03 items.

Custom logic to build relationship between source documents (Sales Orders, Scheduling Agreements, Deliveries, and Invoices) with reference id and original documentation id using data interfaces, IDocs, ALE, BAPI, and RFCs.

Mallinckrodt Pharmaceuticals, Hampton NJ ( Feb 2015 – Jun 2016)

SAP Hana Developer

Reconciled the data schemas against Hana schema to identify data type mismatches and liaise with Hana resource on required changes.

Development oData service and SAP HANA prototype to deliver proof of concept product to clients.

Created Attribute views, Analytical views and Calculation Views using database tables.

Created calculated measures, restricted measures and columns, input parameters to satisfy reporting requirements.

Involved in creation of calculated attributes, measures, restricted measures, calculated columns, filters, hierarchies, variables, in-put parameters to satisfy reporting requirements using SAP HANA studio.

Integration of Outlook with SAP CRM, CRM Entity, Contact Integration with Microsoft Outlook through SAP NetWeaver Gate (ODATA) services

Set up data integration platform - transformation/field mapping, data validations, cleansing/data quality and ensured data in integrated via flat files as well.

Leadership and mentoring on site and offshore developers, responsible for deliveries of development objects. Creating standards, and enforcing developers to follow the best practices that include coding naming conventions, code review for efficient programming, tech specs, functional specs review, daily meeting conference calls, and update the status to PMO and the team. Coordinating with functional and business team and get the clarification on the requirements to proceed with smooth development.

Fetch various fields from these different sources via web services into our Hana environment, performed extensive test scenarios to ensure the integration works seamlessly.

Setup scheduling for a monthly run of the web service call into Hana.

New PI system in place as a middleware, replaced Qlickview, JDE, and other interfaces developing them via PI include customer master, sales register, invoice journal, material master, and equipment master. The interfaces developed using IDOC method, ABAP proxy, and flat file mapping.

Built a development road map, framework design, and bridging the preferences/priorities between the development object. Assisting developers in walking thru the functional specs, helping them outlining the best way possible programming by giving them the algorithm and pseudo code.

Many of the inbound and outbound interfaces are designed using a custom procedure of flat files, XML, Excel, and finally using Idocs in SAP.

Loudoun Water, Ashburn VA (Sep 2013 – Feb 2015)

Sr SAP Technical Consultant

Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.

Data modeling (Dimensional & Relational) concepts including Star-schema modeling, Snowflakes modeling, fact and dimension tables.

Complex wokrlfow design, development, testing in ECC EHS, HR, FI, MM, PS and SRM SC, PO, CO, IV. The workflows involved both PCW, BRF-PLUS and ACW. Self-managed, independent, in terms of understanding business process, requirements, functional specs, and tech specs. N-Level workflows for dynamic agent determination in SRM workflows for PO, SC, IN, and CO workflows.

Custom Workflows developed and tested thoroughly in PS, FI, MM, and SD in ECC.

Responsibilities include but not limited to resource management, Candidate interviews, tasks assignment, Status Tracking, Status meeting, project proposals, estimations, spec reviews, development,, testing and production support.

I have enhanced the business object and written triggering code in BADI. Configured workflow system and email setup in DEV, QAS, PRD to enable automatic external email. Setup the standard iDocs for workflow error handling and notification purposes.

Itelligence Inc – (Nov 2010 – Jul 2013)

SAP Technical Consultant

Expertise in fixing production support issues related to multi-provider mapping, data inconsistency, and job failures.

Worked on the vendor master, customer master and material master IDOCS: CREMAS, DEBMAS and MATMAS.

Sound understanding of end to end Data Migration process including Extraction, Data Profiling, Transformation and Generation of Load ready data files in LSMW format.

Providing production technical support which includes business analysis, functional enhancements where required and technical enhancement, troubleshooting, testing of RICEF (Reports, Interfaces, Conversions, Enhancement and Forms, ALV reports, smart forms, user exits and BADI, LSMW, Workflow, and ALE/EDI. Responsible for deliverables of RICEF-W, development efforts and time and estimations, Development improvements, Time management, Customer/Client calls/discussions, status meetings, ticket assignment, design, development, and testing help, offshore coordination, employee related tasks, employee performance, solution providing, workload balancing among the team.

I have reviewed the ABAP code written by other developers and suggested the changes. The part of it was checking performance, code efficiency, and naming standards. I have used code inspector, ST05, and extended program check.

Developed ABAP programs for enhancements, reports, and dialog programming MWS, and MM, area.

Sales order credit block workflow.

MM – Workflows – Purchase requisition, Contracts, and POs

Have written technical specifications and have developed ABAP programs for enhancements, reports, Workflows and dialog programming for EH&S, MWS, MM, and SD area.

Managed EDI tasks and analyzed the requirements with the EDI team then developed technical specifications, mapping specifications, and configured the EDI setup in SAP.

Individually handled all EDI related requirement functionally, technically and finally developed and tested for OTC (810, 812, 832, 850, 855, 856) and P2P ( 810, 820, 824, 850, 852, 855, 856, 867).

In quality testing, I have assisted troubleshooting, performance tuning, and testing the developments functionally and fixed several programs to meet current requirements and improve the performance of the programs in several functional areas like FI, SD and MM.

Good Year, Akron, OH – ( Feb 2009 – Oct 2010 )

SAP IDoc EDI ABAP Consultant

Design, creation, and implementation of work flows, data flows, scripts and performing simple and complex transforms in dataflow using different data integrator, platform and data quality transforms.Expert-level mastery in designing and developing complex mappings to extract data fromdiverse sources including flat files, RDBMS tables, legacy system files.

Driven the complex requirement of EDI project providing with excellent EDI solution for the FI documents coming from over 100 different systems into SAP with in different formats. Individually worked on gathering the business requirement with entire process team communications with from the stage of developer to VP. Designed the functional and technical specifications. Assisted the developer all over the programming phase, coordinating with XI/PI, business, and PMO teams and hands on development of Web services, proxies,.

• Driven the complex requirement of EDI project providing with excellent EDI solution for the FI documents coming from over 100 different systems into SAP with in different formats. Individually worked on gathering the business requirement with entire process team communications with from developer stage to VP stage. Designed the functional and technical specifications. Assisted the developer all over the programming phase, coordinating with XI/PI, business, and PMO teams.

• Accountable for defining, planning, orchestrating and delivering given strategic initiative(s). Involving multiple internal and external stakeholders and matrix partners.

• Developed custom program reading custom idoc of inbound intra company invoices and translate them into multiple standard FIDCCP02 idocs as per the business requirements. The program handles a huge complex amount of logic and validations and cross data conversions.

• Developed outbound invoice confirmation custom idocs with a custom program scheduled daily. The FI document splits onto 2 idocs and grouped by customer and vendor.

• Developed outbound netting payment custom idoc with custom program grouped by customer and vendor. Developed trading partner foreign exchange report program.

• Worked on Integration between SAP and Documentum. Responsibilities include Gathering requirements, writing technical specs, specification and code reviews, testing and assisting other developers in ABAP programs, workflows, BAPIs, BADIs and SMARTFORMS. Developed custom multi task workflow for incoming image from Documentum for PO and non-PO based invoices. Developed Purchase requisition workflow, developed invoice release workflow. Developed price and quantity block workflows. Wrote ABAP program which is being scheduled to send an email for the invoices that are blocked because of price and quantity variances.

J&J, Jacksonville, FL – ( May 2008 – Jan 2009 )

Sr ABAP Lead

Leading the ABAP development team, Development, testing, and documentation for end to end solutions – Dialog Programming, ADOBE Forms, SMARTFORMS, Workflows, interfaces, UWL, NetWeaver, Portal.

Requirement gathering, understanding the business process, Functional specification reviews, Technical Specification preparation and reviews, code review, development of the flowing workflows, testing and release.

Workflow development and admin, workflow debugging, and ABAP.

Axon Global Inc ( Jul 2007 – Apr 2008 )

SAP Tech Lead

SAP Development Lead ensured SAP development initiatives are successfully completed in line strategic initiatives and deadlines. The SAP Development Lead will oversee the internal and external team members’ activities in development related work, establish and ensure adherence to development standards, processes and procedures. The SAP Development Lead will provide strategic guidance and sign off on proposed changes to the SAP environment related to EM.

Requirement gathering, understanding the business process, Functional specification reviews, Technical Specification preparation and reviews, code review, development of the workflows, testing and release.

SAP HR Workflow - As part of the SAP ESS and MSS implementation, I have connected and configured ESS Travel & Expense to the SAP Business Workflow and enabled employees to request and book their business trips themselves and enter their on-trip expenses once returned from their trip. Developed the Workflow to send trip destination, purpose, estimated cost, and preliminary distribution of costs data to the approving manager or his portal inbox.

Fujitsu Consulting Inc, New Jersey (Oct 2004 – June 2007)

SAP Technical Manager

During my time with ConAgra I am involved in different types of developments and lead offshore team in equivalent to the level of a manager. Promoted and ensured use of appropriate techniques, methodologies and tools Plans and manages the evaluation of software processes Identifies, proposes, and initiates software process improvement activities within the organization Involved in lots of new development, Workflows, fixing several ABAP break fixes and working on Change Requests. Reports, Enhancements, and workflows in recipe management.

Engaged with technical design and project managers or Project Management Office, to ensure correct products are produced, in a timely fashion Identifies and manages the resources necessary for all stages (planning, estimation, execution) of individual systems development projects to ensure technical, financial and quality targets are met.

Conducted functional/technical specification design/review/signoff sessions. Assisted with blueprint design sessions, gathered requirement specifications and sent them to offshore, and managing them thru all over the development life cycle.

Daily status updates, approving timesheets, and make sure the quality of the code and match the deadlines.

Involved in technical and functional upgrade projects of SAP 4.6 to ECC 5 and ECC 5 to ECC 6. Personally I am involved more in technical parts in interfaces, enhancements, reports, and conversions also evolved due to the extent changes in functional aspects for modules MM, SD, PP, FI, Recipe Management – used Solution Manager as a tool for purpose.

Initially, this was a critical leadership role in the design, test and implementation of SAP, it was then evolved into a key leadership role in the support, maintenance and continuous improvement of SAP for tKE manufacturing.

Plan, manage, and co-ordinate activities to support the implementation of a large ERP program from contract /proposal initiation to final operational stage; plans, schedules, monitors, and reports progress on activities related to the program

Facilitates requirements gathering, scoping and prioritization for large or complex changes, engaging senior stakeholders as required

Responsibilities include the system strategy design, proposed technical/ functional specification document designs, proposed configuration design document, Archiving Idocs/ Work items, and system performance issues, of SAP WORKFLOW with respect to EDI process.

Outlined the capabilities, efficiencies and strong features available in SAP with respect to using Workflow for EDI Idoc processing.

Analyzed the current system and designed the document for the Idoc error categorization and the solution for the error handling via SAP Workflow.

Documented the procedures to archive the Idocs and workflow workitems in SAP to improve the system performance.

Have gone through the current SAP workflow system how it has been implemented as part of other responsibilities.

Pinnacle Talent Inc ( Aug 2002 To Oct 2004 )

Sr. EDI/ABAP Lead

Responsible for all IT systems related to maintenance and high bay warehouse, globally. Also be responsible for integration testing and user acceptance testing.

Defined and track project charters, integrated project plans, resource plans, risk plans and budgets. Prepare and present clear and well defined project status reports and issue logs to key project stakeholders and management team members.

Responsibilities include the system design, development, configuration of EDI 870, 869, 850, 856, 810 functional specifications, technical specification, mapping specification. And also developed custom ABAP programs for those transactions.

Used SAP Solution Manager through out overall project life cycle management.

Configured and wrote custom interfaces in Financial module in JDE.

Compiled the input from each team to provide accurate and complete information and requirements. Developed Design documents for each transaction and developed them.

Work closely with each team to successfully Design, Develop and Test each EDI Interface

Accommodate Business requirements and Customer requirements while maintaining standardization within the R/3 environment

Wrote ABAP EDI posting program for 870 which pulls the data from various sales related tables and creates Idocs based on customer, and changes in the orders, and status changes at schedule line item level with time constraint.

Individually, designed and developed 870 and 869 from end to end with almost customization.

Designed and Developed Z Table/Flat File/Reports for FOB Cost data, SAB Sales data for FI, Order status report, IDOC Error Status report and Cleared SAB101 report.

Developed SAP Script for Invoice/Credit/Debit Memo Sap Script Layout.

IDOC outbound interface to transfer CATS entries to Work management software (Logica). This created 2 interface files, one containing employee time information and other containing equipment time information

IDOC inbound interfaces to transfer daily crew make up data from Work management software to CATS (In order to get accurate list of employees and equipment that are to be charged to the same work order)

User exit to generate a report with sick non pays leave to be converted to sick pay leave and updation of infotype 2001 accordingly. This user exit is triggered from infotype 0080 (Modified to store report date of attending a physician)

Responsible for the integration of SAP with EMAGIA Account Receivable software, Involved in collecting the requirements from the end users and functional consultants And converting into technical design after analysing the requirements, development, Testing and production support.

The integration is done by developing BAPI/RFCs, wrote BAPIs for Customer Master, Open and Cleared Customer Line Items, Company Master, Invoice

I am involved in getting specification requirements from client ATOFINA and understanding their business workflow in FI AR module in SAP.

Modifying the ABAP/4 Code to meet the Development Change Requests (DCR), which arise as a result of functional testing and conducted Design & Code Reviews of other developers in the team.

Worked on User Exits and design guide lines for implementing batch management and adopt additional functionality for Batch Numbering system for Purchase Orders, Transfer Orders, Process Orders and Goods Movement.

Computer Consulting Pvt Ltd, Atlanta GA ( Nov 2000 To July 2002)

Project Leader, Senior ABAP Consultant

Worked for a company which has several sales operations share a common warehouse and shipping system, where MM module is maintained on one system and SD on the other system, required to transferring MM Master data using EDI/IDocs.

Interaction with Functional Manger and Client to get the right specifications, Program analysing and Modularization. Project Estimates, Proposal writing and created technical design documents.

Analyzed and solved complex business and technical queries from users and other SAP Functional Consultants, regarding the operation of SAP R/3 system & interfaces.

Responsible for project deliverables, time lines. Worked on CATS interfacing through BDCS and ALE programming for transferring data between the two SAP systems of the Upgrade from 4.0B to 4.6C.

ABAP/4 with experience in dialog programming, creating interactive screens and translating SAP GUI into dialog and the areas of special purpose ledger, report writing and maintenance, but also support other finance modules, including controlling, general ledger, asset management and accounts payable.

Developed inbound interface of sales from legacy application using ABAP & BAPI, Developed outbound interfaces in ABAP for sales and new items.

Responsible for deciding EDI related dead lines and requirements.

Wrote Inbound and outbound programs for Purchase Order and having very good knowledge in configuring ALE/EDI Interfaces.

Analysed, designed and developed customised IDocs for Purchase Order Document.

Worked on EDI Transaction 850 for a functionalised order document, duties involved: Developed mapping specification document for outbound INVOIC message in AI. Developing an IDOC, wrote an outbound program, EDI configuration.

Distributed data between SAP and NON-SAP system, Gentran is used as mapping tool. Involved in Setting up entire EDI configuration in SAP and extended IDocs according to the client requirement.

Presented excellent demos and trained co-employees on EDI total configuration and the process of working of deferent interfaces EDI/ALE/IDocs.

Asia Matsushita (E) Pte. Ltd, Singapore (From Sept 1999 To Oct 2000)

ABAP Team Leader

Enhanced the existing IDOC HRMD_A01 considerably to accommodate new info types 0005,0007,0008 2001,2002,2003,2006,2007. This was a totally non-standard enhancement, which was not supported by SAP. Function module IDOC_INBOUND_HRMD was enhanced considerably to cater to the needs of the client.

ABAP/4 program design, development, test, implementation for on-line and batch applications.

I gave technical support for the R/3 SAP system and designed and built a large number of ABAPs. I solved user problems, sometimes by just educating them better, sometimes by changing some table entries and most of the time by writing or adapting an ABAP or even by designing and implementing self-built transactions.

Assignments included Team Lead for all SAP script document requirements (FI A/P Check processing, SD Sales Order Quotations, Sales Order Acknowledgments, Invoice, Credit Memo, Debit Memo and MM Purchase Order), which included training and supervising two ABAP Programmer/Analysts.

Experienced in special ledger and reporting, as well as basic knowledge of other FI modules. Functional and technical implementation support at various SAP R/3 clients.

For the process of upgradation from 4.0B to 4.6C I have tested more than 40 user-defined transactions in all areas of PP and HR.

Suzuki Joint Venture, Hyderabad, India April 1998 To Aug 1999

SAP ABAP/4 Consultant. (HR,FI,SD)

The module handled was HR (Human Resources), FI (Financial Accounting) and SD (Sales & Distribution) in make-to-order environment and a multi plant-planning environment.

Actively involved in the successful customization of the HR module (PA/PD/TM) as a part of a five-member workgroup using the ABAP/4 workbench on SAPR/3 ver.3.1H system.

Assignments included designing, coding and testing a customized SAP script layout set used to generate the Purchase Order, Request for Quotation and Contract type documents; designed, coded and tested a customized MM SAP script layout set used to generate a Goods Receipt label encompassing bar code technology.

Analysis, design and implementation of interactive reports dialog programs in SAP/R3 system using ABAP/4 in HR for Employee Master and Payroll Data.

Accomplished a project implementation of Sales & Distribution package which was designed for maintaining customer Master data, Machine history data, processing sales documents like Inquiry, Quotation, Sales order, and Generating Sales Information Reports

Designed a drill-down report for daily cash income in General Ledger that would give details of G/L account, customer type etc. with subtotals and grand totals.

WebOffice Pte Ltd, Hyderabad, India March 1997 To March 1998

Analyst Programmer/ Web Developer. (PP,MM,SD)

During this time I was involved in different projects for Client/Server and Web Applications. I have Analyzed, Designed and developed system enhancements in various projects through out the life cycle. Integration of SAP ERP with current Intranet programs and third-party Accounting system. Developed an enterprise e-commerce portal capable of e-commerce transactions as well as connecting to the existing SAP R/3 using MS Site Server Commerce Edition, MTS and IIS.

Involved in converting legacy Asset Accounting data via SAPs data load facilities in a SAP R/3 Oracle environment utilizing ABAP/4, BAPI, Visual Basic and Excel; assignments included further "Cleansing" of the legacy data in an Excel file via an ABAP program.

Wrote scripts to implement Active Server Pages, Java Script, VB script and HTML code for major web pages.

I have written stored procedures and triggers in PL/SQL for the various database transactions and also for controlling illegal unauthorized transaction to the database.

Wrote 15 Standard EXE programs in VB, with Class modules each includes sub procedures, functions, event procedures, standard modules, and class modules, to implement the above mentioned modules. Created 4 Active-X DLLs to integrate these programs.

Used BAPIs interface technology (B2B) to design and configure ITS (WEB R/3) for Product Catalogs involving BAPIS ProductCatalog.GetList, ProductCatalog.GetLayout, ProductCatalog.Getitems, ProductCatalog.GetPrices, Material.Get Components and Sales Order.Simulate.This involved creating an online store to cater to the specific requirements of the customer. The URL services used were WW10 (Product catalog), WW20 (Online store) and WW30 (Online store for B-to-B Procurement).

Contact this candidate