.net Developer Resume
Key Strengths
- 18 years Extensive Software Design and Development Experience.
- SAP , ABAP 4, SQL Server 2005, SAP ECC 6 Netweaver, BADI, Enhancements
- C ASP.NET, . Connector for SAP,, C JAVA SAP webservices
- Integration and Techno Functional SAP Experience in PM,FI,CO,MM,SD,CS Modules
- SAP IS Retail and Knowledge of AFS
- Project Management of a team of 10 engineers.
- Extensive Application Development and ERP experience.
- Unix, Windows 2008 and multi tier Client server enterprise applications.
- Passed a 6 week HANA Development course Conducted by SAP with a score of 87
Software: SAP R/3 ECC 6, OO ABAP/4, Visual Studio 2012, SQL Server VB.NET, C, MS - PROJECT, Primavera 5.0, Silverlight 4.0
Using Lightswithch 1.0, Sybase Unwired Platform.
E-Commerce ASP.NET 3.5 VB.NET C JAVA.
IVS Consulting,
Jan 2014-Current, Redmond, WA
Mobile Application Development C SAP SQL Server
Developing Mobile applications using a Visual Studio tool Xamarin to develop SAP and SQL
Server based applications using REST Services. The Architecture used is same for SAP and
Non SAP applications and is outlined in my blog on Scn.sap.com
SAP Retail ECC 6 7.20 ABAP SD,MM variant configuration and C .NET interfaces
Sports Endeavors has a few websites thru which they sell Customized Sports Apparel and
Goods. A Web User and can add name and number for the Jersey and place an order.
As part of the SD Team Developed Complex ATP RFC Function calls that are called from CRM Web Sphere Commerce to determine availability of products, ship and delivery dates. Some of
The major functions of this is for Customized Articles are BOM is explosion using
CLSC SEARCH OBJECTS, BAPI CLASS SELECT OBJECTS so that correct articles
Required in the user customized Product are selected, for each of the Components ATP is
done and correct date is determined. After this any the Time required for different MileStones in
Customizing is determined and a final ship and delivery Date based on the shipping method is
Computed. An Article can be in stock MCHB,MARD tables, on order PO tables, Drop Ship or
Out of Stock. There are other Custom rules for protected customers, Customer eligible for
Drop Ship qty, Euro Ship determination based on customer address being non US or PO Box
Address.
C .NET SAP interfaces For SEI products sold thru the website there is ImageHandler that
Renders the product image - These images are sent by a Different system this interface picks
up this file by monitoring the specified Folder File Watcher API . . If the image is a default image
then the Article URL In SAP MM42 is automatically associated with the image url using custom
ABAP REST Service this program uses SO DOCUMENT INSERT cl binary relation >read links .
Custom Batch Split Development- As orders are created over the Web and sent to
then to ECC or from CRM to ECC when a batch split occurs it is only know to ECC and can't
Be propagated back to CRM and Web and hence lead to inconsistent data To overcome this a
Custom Batch split Functionality was developed. When a Batch Split occurs a entry in ZVVBE
Stores this information while the Sale order batch is blank. Delivery time Enhancement makes
sure that these splits lines are displayed on the batch split Screen and at PGI time
Subtraction of delivered qty from ZVBBE takes Palce. To achieve this functionality a number of
Enhancements were made in WS GG CHECK COMPLETE, RV60AFZC, RV60AFZZ MV50AFZ1, MV45AFZZ, MV45AFZB .
Condition Scale Copy The Client maintains Prices and Scales based on Article pricing group
A991 Condition type ZSCL A custom Scale copy program based on dynamic tables
Determines the tables for condition type VKPO and then creates condition records for all articles
Belonging to the pricing group. This saves the user lot time by not having to maintain prices Scales for each article.
Contracts Rebates Association Business Creates Contracts in CRM and they are transferred
To ECC- in Standard SAP there is no association with Contracts VA41 and Rebate agreement
VBO1 by populating External Description with the contract number. The program looks for
Condition type ZRB1 or ZRB2 in the contract and then creates a Rebate agreement so with
Reabtes Z001 or Z002 Qty so that Rebates can be accounted for.
Back Order Rescheduling- Developed Custom rescheduling program The Delivery dates on
Sales order are based on the Delivery dates on Purchase orders If the quantity, Delivery date
Or Batch changes in the PO then the Sales order has to be rescheduled. There are two custom
Program one of TAN another for TAC item categories The TAC item categories is more
Complicated as each order line consists of BOM and each of the articles in BOM might have
Changed PO information To handle this a custom table was built that has a list of each
TAC item with all its BOM articles. The custom program first builds this table and then looks for
For all POs containing any of these articles and reschedules based on Date, Qty and Batch.
Other tasks involved modifications and/or rewrite of programs for Master data Replication to
Web Sphere commerce thru PI proxies, Logistic Information System Table data Enhancements
To achieve custom functionality as required.
ZULILY
Seattle
Aug 12 - Feb 13
SAP Retail ECC 6 7.20 AFS ABAP Banking Interfaces and Data Conversion.
As part of this new SAP implementation US Developed Banking interfaces for ACH and Credit Card processing so that files generated by SAP are converted to WellsFargo Format. In addition developed LSMW for Data Conversion for GL Master FS00, Banking Master, Vendor Master. Developed BAPI programs to post GL and Accounts Payable documents from Excel, Developed Smartform for Purchase Order and also the Driver program which is invoked for Print and Print Preview.
After US Go live in Oct, Developed WellsFargo Positive Pay interface, Developed Inventory Sync interface so that all spool output from MB5B inventory report is converted to text file which will be picked up by the main system ZUKEEPER and then difference between inventory are between the system are resolved. For UK Data Conversion - Developed Conversion and interfaces for AP including Withholding tax for US and Tax posting using BAPI for FB60 to park and post, GL BAPI for FB50 to park, Bank Master Data, Vendor Master Data LSMW .
As Web services were not used I developed a proof of Concept for Purchase order change using BAPI and then converted to web services using SOMANAGER- Developed C ASP.NET web application to List POs for Vendor and then Change Submit PO change to post to SAP. As a result of this development was approved for Web Service development for Vendor Refresh and Vendor Create. Vendor Refresh Web Service sends all SAP Vendor Master data to calling system so that the calling system can determine the differences.
Vendor Create interface was developed as REST Service using the class WMD EI API that accepts Vendor record in JSON Format JSON,ABAP Conversion were implemented . A Jquery call to the REST Service POST method.
ACSIS
Marlton NJ
June 12 Aug 12
SAP ECC 6 ABAP WM and Sybase Unwired Mobile Platform 2.1.3 .
ACSIS has developed number of SAP based WM non mobile products using middleware. They wanted to explore the Sybase Unwired Platform so that they can evaluate and decide to get into SAP WM mobile. My task was to establish this development environment and develop two transactions in WM. I installed and established SUP development environment. After that I developed ABAP RFC calls for BIN to BIN Transaction using L TO CREATE SINGLE and for
using Material document '/SPE/MATERIAL STOCK READ' to get the material list and then
BAPI GOODSMVT CREATE to post the document.
The RFC calls were used to develop two SAP WM mobile transactions using Hybrid container Model using online and offline methods provided by SUP. These were tested on Android/Windows Mobile devices. After this I developed the same transactions using the Generated code C for Windows Mobile devices using Visual Studio 2008. I have also interfaced SAP with SQL Server 2008 using DBCON and developed data transfer programs using Objected oriented ABAP for Native SQL.
Engenium Solutions Inc
Houston, June 2010 - June 1203
ABAP PM ECC6 Remote work Part time
Engenium solutions has PM package that lets Plant manage multiple plants for work orders and
Schedule PM tasks. This package has ability to export and import SAP Data into Excel and
Microsoft Project using OLE. This package is used at Conoco Phillips in 35 plants - My initial
Job was to provide support and issue resolution. After that I was involved with providing
New features and revamp some bottlenecks and this resulted in the new release 2.0 of the
Product.
IVS Consulting
Houston
May 2012
SAP HANA Training, Documentation and Proof of Concept of COPA on HAN using BODS.
IVS consulting wanted to explore this emerging technology. Initially I underwent training on SAP HANA. As an experienced trainer I learned and prepared my own training material. After the training I built from scratch COPA data model Analytic, Analytic views from ABAP tables and populated using BODS. Used SAP LT Replication to populated HANA database.
Peak Technologies
Maryland
ABAP PP WM ECC6 Remote Work Dialog Progmming
Feb 2012-April 2012
Currently working on ABAP Development for Peak Project DOW Chemicals for Film Manufacturing to be used in Plants in USA and Asia Peak is specialized in solutions for automatic identification and data collection AIDC . Has its own ABAP Object Oriented Framework for ABAP module pool programming and RF Screens. My role was development of 4 module pool transactions ie., Lost Capacity To keep track of work Center Lost Capacity, Idle Time Transactions Break down by minutes for every idle times giving reasons and by reasons, Material Maintenance for Evaluation materials, and Material Maintenance a subset of information that DOW requires to edit for materials . My work also involved ABAP issue resolutions and pre go live work in the project.
Jones Apparel Group
Bristol PA
ABAP FI SRM SD SAP ECC 5 AFS
Oct 2011-Feb 2012
The current role involved ABAP development/support as required. Pricing report based on Dynamic tables Based on the Condition types the program dynamically computes information getting the tables required based on Config and access sequence. As new A tables are added to the system due to pricing the report need not be changed and dynamically computes the information required.
Interfaces to Post MIRO using BAPI BAPI INCOMINGINVOICE POST, GL posting using BAPI BAPI ACC GL POSTING POST This interface also has extensive validate options to check using ABAP to check for mandatory fields based on Field Status variant also calls BAPI ACC GL POSTING CHECK. BADI had to implemented to populate some fields such as XREF2.
Hyperion interface optimization The current interface processes about 10 milliion records from FAGLFLEXA and additional records from FAGLFLEXT and is timing out to overcome this I changed the program so that primary key is picked up for these tables and that we use parallel processing based on number of work processes FM SPBT INITIALIZE so that we process about million records parallel using Perform function in new task.
ALV MM store/UPC maintenance Program that allows correction to data received from IDOCS based on Error-The user selected the error node on the ALV tree the program allows the corrections to be made to Stores/UPC information populates other related information uses change pointers to write custom changed documents Tcode SCDO to generate FM, Enqueue Dequeue. Other work includes work on Intercompany Incoming Goods, Royalty posting were MIRO posting uses split factor and posts the difference to a suspense account.
Colgate Palmolive
MorrisTown NJ
OO ABAP HR Compensation Reporting SAP ECC 6
June-2011 Oct 2011
The Reporting Project was to cater for the business users dealing with Shares and Restricted share allocation to employees of Coalgate Palmolive. Reporting was mainly based out HR infotypes 758, 760,761,763. All the reports had options to output in ALV or Excel. To Cater for the special formatting requirements for the Board of Directors and Task Force Preformatted Excel templates where stored in SAP using Transaction SMW0. These reports provided a faster user response as the Data from SAP to excel was passed using OLE and Excel macros were written which populate the data and do additional formatting as required.
A Class method was developed which will invoke the OLE and pass the header data and detail data to Excel.
Used SAP tools such as code inspector, runtime analysis tools such as SE30,ST12 to achieve great performance improvements A Master Data Extract report that was talking 1hr 45 minutes is now running under 15 min . Developed one Webdnpro Report used by Managers - All these reports were invoked from Enterprise Portals. This project required dealing with out of Town end users and Colgate development team in India.
First Solar
Tempe AZ
OO ABAP BPC BI BADI Developer SAP ECC 6 BPC NW 7.5
April May 2011
The project is Conversion from Microsoft BPC 7.0 to SAP NW 7.5 The project started in Oct My role has been to develop BADI's that invoked from Data manager packages and Script files. I have also written LGF script files to scope records and then invoke BADI's written by me. The BADI's have been for enhancement spots 'UJR WRITE BACK which are invoked on Save of BPC input schedule and also UJ CUSTOM LOGIC. Some of the functionality developed in BADI was in HR Employee Transfer, Bonus Calculation. In Finance the functionality involved RECLASS and Version Copy. My work also involved developing one process chain which can pass parameters from the Dynamic scripts in the data manager package to the BADI in the LGF file and process the BADI . All the ABAP was developed using Object Oriented concepts.
Phillips, Andover MA
SAP ABAP Consultant
Oct 2010 March 2011
SAP ECC 5 Customer Service Sybase Unwired Platform
Pre go live Support/Development ONEMOBILE Project
The ONEMOBILE Project has been under development for about 2 years My role has been was to resolve issues and develop any missing functionality as and when raised by System Integration testing, Volume Testing or UAT. Most of issues are ABAP fixes for the RFCs calls for Notification, Service Order, Online Search Functions, Time Confirmations, Labor Create.
The application uses extensive BTE function calls to synchronize data with SYBASE. Whenever data is changed BTE will send XML thru QRFC that will update the Sybase. The work also involved in SD Pricing for GATP check and BADI/Exit changes in SD,PM,CS modules. Involved in the creation of Master Data such as Equipment, Functional Locations.
The application has been designed and written using Object Oriented ABAP. Interfaces were developed which defined the required methods and classes using these interfaces were developed for data retrieval and sending formatted XML to the middleware.
Each of the changes were to documented by the change management processes. Conducted Knowledge Transfer sessions to off shore teams.
HCL AXON
Senior Consultant
June 2008 June 2010
SAP ECC6 .NET FI/CO/MM/SD
Post Go live support/Development for GulfMark Houston.
Provided Post go live Support/Development requirements at GulfMark. Some of the Key developments done were- Development of DOM based XML parsing of the XML files sent from the Ships in ABAP and email back to ship the processing results of PO creation. This saved considerable amount of time to the user and was major improvement from the existing system.
ZMMDASH was ALV based report is considerably used for all Purchasing analysis The critical requirement of this report was it should take less than 3 min for a month's data which was met. Closed more than 200 tickets covering mostly SAP technical issues and some functional issues. Developed a number of enhancements/Exists. All ALV programs were developed using Object oriented programing model.
COPANO Energy Houston New Implementation SAP ECC 6 FI
As part of this Project developed ABAP application for Bank Reconciliation The application allows users to reconcile SAP FI documents with those from the Bank statement. Any missing entries and adjustments can be posted from the Application itself which Posts an FB50 using BAPI's. A BADI's were used in Payment processing and invoice printing programs F-28,F-58 The Application also makes extensive use of BTE's.
The Vendor invoices and checks are scanned and stored in SAP archive application. To make it easy for the user to manage these a easy to use ASP.NET 3.5 web application was developed. A number of ABAP calls for the archive link were written which were invoked from .NET as web services. This application is used by about 50 users and is written in C ASP.NET SQL Server 20008 Uses authentication and ABAP. The scrolling for Pages in the data grid was done using Object Data source for the data coming from SAP using web services. These two applications were critical requirements for go live.
As part of data migration developed LSMW and ABAP programs for data migration for AR/AP.
This involved moving master data such as Vendor,Customer,Assets to SAP ECC 6. This involved talking to the Business users to ensure proper mapping between legacy and SAP Data is done and that duplicates are eliminated during this process and consolidation takes place were appropriate.
Port Authority of New York SAP ECC 6 PM ABAP Web Dynpro
As part of Post go live support Provided ABAP support for the PM ABAP A custom ABAP was developed for transactions such as IE01,IL01,IW31,IW32. All issues raised by the user were fixed.
There was requirement for development of data load application for Equipment/Location The unique requirement was that each user has his/her layout. The ABAP application using web dynpro was developed that allows the user to input a spreadsheet containing Equipment/Location information. The First Three rows are header info with the first column being the field name, the second row 1st col is the field is optional or not and the third row Field description. The application will parse the excel file and validate all the master data and display the errors log and when all the data is corrected will post IE01 or IL01 using BAPI's.
Developed a number of enhancements/BADIS/Exits to solve various issues.
Provided remote support as needed to the assigned clients.
Global E Procure GEP NJ Technical Lead
March 2008 May 2008
SAP Visual Studio 2008 C ASP.NET 3.5
Interface SAP Data with GEP Custom SCM package. GEP has custom SCM package and
Wanted to interface transfer to/from SAP from their software to SAP. A number
of ABAP web services were developed that were be invoked from by GEP to perform
this integration. At the present time Synchronization of Vendors, Customers and Materials
has been achieved using this architecture.
Conducted Training in SAP FI-CO and MM where in students are trained to customize
a company they designed from scratch and post the SAP transactions in the company
they customized.
C ASP.NET Web application for ecommerce with Credit card processing using DataCash API
For Validating Credit Card and posting transactions.
Intermec Inc. Everett WA
SAP .NET Consultant Technical Lead
SAP ECC6 ABAP Visual Studio 2005 SOA SM-ABAP-C .NET
July 2007 March 2008
Intermec was upgrading from SAP 4.6 C environment to ECC 6.0.The Service part to deal with warranty processing was handled by ORACLE based Matrix package.As part of the upgrade Repair and warranty processing was incorporated into SAP. This involved about 200 non SAP users having to use SAP's GUI and post Service Management transactions. Intermec's existing .NET applications were based on .NET connector. To ease the transition a easy to user interface was to be developed. The New Technology direction chosen was Service Oriented Architecture using ASP.NET 2.0 Visual Studio 2005, SQL Server 2005. The initial part of the project involved talking to the Business users and making the required specifications and Proof of concept of the technology using SAP web services in Visual Studio 2005. Service Kiosk Consists of about 100 Custom build ABAP RFC Function calls that implement business rules for Warranty processing and perform Transactions as IW51,IW52,IW31,IW32,IW41,IW42,VL01N,VL02N inbound and outbound delivery, DP90, using BAPIs. Most of the BAPIS in Service Management have been used for the development with very little BDC's where BAPI's were not available. Many Client Specific Enhancements not provided by SAP such as Customer Specific Task List in IW31, Billing Indicator at the Service Order Line Level which enables different Material consumed for the task line of the Service Order to billable or under warranty or contract. User security based on SAP Roles was .implemented that would control which options the user can use. This application is used by about 200 users and handles all aspects of the business unit. Also involved in the selection of new members to the SAP .NET integration team.
Oct 2005 June 2007
SAP .NET Development Consultant Oil Industry Houston SAP 4.6c, ABAP, VB.NET .NET Connector PM-ABAP-.NET Technical Lead
Development of a Web Application using ASP.NET VB.NET application so that the users can Create a Notification PM Transaction IW21 on SAP 4.6c . The main transaction is implemented as .NET webservice using the .NET Connector and BAPIs and QRFCs and TRFcs. The ASP.NET application Front end invokes this web service to implement IW21.
Primavera 5.0 and SAP Interface PM-ABAP-.NET Technical Lead
The SAP Primavera interface was developed. Some of the alternatives in the industry were where based on Java which is not preferred at HR. The cost of implementing java based 3rd party solution would be more than 100,000 with an additional 10,000 Euros to buy the BAPI Upgrade. The 3rd party .NET Solution was more than 200,000. The API Calls provided by Primavera were all java based or Using the older Version of Visual Studio. These were not suitable in our environment. The only option was to direct tables updates SQL Server 2000 . This involved having to work with undocumented things and do reverse engg. The SAP Interface developed is based on ABAP Function calls and stored procedures. The interface enables work orders that are created in SAP to transfer to Primavera using either the batch interface or online interface and enable the end users to work scheduling and project management in Primavera. The interface was developed using Custom RFCs and .NET Connector and transfers work orders operations and operation dependencies to Primavera activities. The interface brings in about 15-2000 operations from SAP to Primavera every day.
Profile Tool Time Sheet. PM-ABAP-.NET The TimeSheet software provided by Primavera was not suitable and hence a custom solution was developed. The Profile tools allows the supervisor to create profile linking Work Centers and Users. The Time Sheets allows the user to select activities based on profile and hence activities that the user is allowed to change the remaining hours and add comments to activities that will updated to Primavera by using stored procedures.
Integraphs INTOOLS SAP Interface PM-ABAP-.NET Technical Lead
The Instrument Equipment Master information is maintained in INTOOLS. There was a time consuming manual process that was performed to create the same information in SAP. The interface maps the entities in Intools to SAP entities and transfers the data. When the status changes in Intools the same is transferred to SAP overnight. This ensures data integrity and makes sure that Notifications cannot be created for locations and equipment that are inactive in Intools. The 3rd party solution would cost around 140,000. The interfaces uses TRfcs to create Location and Equipment information. The number of Function locations, equipment that were created or changed by the interface was more than 100000 on go live.
MI Tools Web Service using ASP.NET PM-ABAP-.NET
To Cater for the new MI Mechanical Integrity Tools application a web service was developed in .NET that makes the custom ABAP class to SAP to get the equipment and Location data based on Query dates . The Web Service is used to populate database Refinery's Mechanical Integrity
Analysis package.
P-Card Data to Post Vendor Transactions FI-ABAP-FB60
A ABAP Program was developed that reads the downloaded transactions from the Bank based on the various purchases made by the employees and Create Vendor Invoice FB60 Or FB01 using BAPI ACC DOCUMENT POST. The program has options which allow to check and correct Format and data errors and then Post the Vendor Invoices from downloaded file.
This involved talking to the Banking representatives and setting up the requirements to download the spreadsheet of transactions from the Bank website. A End user was assigned the task of downloading the spreadsheet. After downloading the file, the user will the PCARD tcode which will post the Transactions to SAP.
GR IR Discrepancy- Transaction ZCNB2 MM-ABAP-CNB2
Custom ABAP report ZSRGRIRR to report GR IR Discrepancy did not provide option to select by network and was taking days to run. To overcome this problem Report CNB2 was copied and modified so that it prints the GR IR Discrepancies. The Program outputs the reports in a few minutes in contrast to ZSRGRIRR which was taking hours. The Custom Transaction created based on this is ZCNB2.
Update SMTP Address for SAP Users
Due to takeover of the Refinery, The Email address of the SAP Users was required to be changed. A text file with names and email was sent from corporate head quarters. A ABAP program was developed that reads the text file and changes the email using Bapi User change.
The program also gives the user the option to print a report of SAP IDs and current email address.
Payroll Interface FI-ABAP-FB01 Technical Lead
Payroll data was extracted from Ceridian software, manually corrected and then passed on to Accenture so that they can place it on their servers and run a series of steps which will result in a FI posting of the payroll data. This process has been considerably simplified by the development of custom ABAP solution that processes the data, allows the user to check the data consistency and then post the data as FB01 using BAPI. This can be run by the end user themselves.
Post Capitalization Asset Values Depreciation FI-ABAP-ABNA
Due to Acquisition of the Refinery the acquisition amount was distributed over all the assets and depreciations applied. These values are given in the excel file. ABAP program was developed that reads this excel file and performs BDC for the transaction ABNA. BDC was chosen as no suitable BAPI was found that can perform this transaction in one step.
Consolidation Report FI-ABAP
Due to the take over of the Refinery a new consolidation report was required which list the GL account amounts by cost center, Cost Center Category from a Custom Special purpose Ledger for a selected period to a spread sheet so that parent company can process this information in their software. Due to urgency of this report 24 crystal reports were developed. 2 reports for each period one for balance sheet and one for income statement were created and the end user had to compute Asset income, Liability income and Earnings before passing to the parent company. This was replaced by one custom ABAP that does all the mentioned functionality.
SAP Training
I have conducted MM training in Houston where in the students were asked to come up with company structure. As part of 40 hrs I trained them how to customize the company from scratch in FI and then the MM structure after this all MM cycle transactions were completed in this new structure.
Dec 2004-Sep 2005
.Net to SAP integration using BIZZTALK 2004 Client BIZZCOM Technical Lead
Developed proof of Concept of SAP integration with .NET. This involved setting up the BIZZTALK 2004 system and developing BIZZTALK orchestrations that will take a XML file that .NET web application generates, and then using Custom BAPI and .NET connector populates a user created table in SAP. For this I had modified a .NET online quiz application that I had developed earlier for the University of Sydney to produce the XML file. Developed BAPIs that will populate a table that I created in SAP and using the .Net connector and BIZZTALK 2004 integrated the two Technologies. SQL Server CE and Pocket PC interface to SQL Server 2000.
Warehouse Pocket PC Application in C .NET SQL Server CE and Pocket PC interface to SQL Server 2000 . and SAP.
A person who monitors the Warehouse is equipped with a pocket PC which downloads transactions such as Purchase Orders and Sales Orders for that day from SAP. The person s monitors the goods receipt/goods issue quantities with pocket pc and notes the Truck Number/Driver Name on the Pocket PC. From time to time they can hook back the pocket pc and connect to computer to transmit the information at which time the SQL CE on the pocket PC updates SQL Server 2000 using RDA. This in turn invokes a BIZZTALK 2004 Orchestration which transfers the Driver Name/Truck Number as Purchase Order/Sales Order Text using BAPI.
SAP Consultant Documentation JobWorx Client Roche Pharmaceutical Dee Why Feb2005 -May 2005
Documented about 100 System Specifications and user requirements of existing SAP System and programs in SD, MM and FI-CO. The Roche SAP implementation covers 11 countries in the Asia Pacific region and the Documentation covered requirements from these countries for ABAP programs, Drill Down reports, Report Painter reports, User Exits, Includes. Sales Information System SIS Configuration and Implementation, Loading of historical and Budget data.
July 2004 Nov 2004
SAP Consultant Testing Cubic Consulting Client Woolworths, BlackTown, R2 to R3 Conversion Project
Involved in Developing Test Scripts for Functional Testing FI,CO,PA,MM, Interface Data Transfer Testing using IDOCS, Process BDC Sessions. SAP Stress test scripts using Compuware software that generates C code. The generate code was modified for stress testing the different selected transactions. Testing of PA,PCA BW reports against validity with R/3 data, writing of test scripts for BW reports and regression Testing. Worked in SAP BW integration Testing.
Feb 2004 June 2004
Lecturer for ABAP Course at the University of Western Sydney, Paramatta Campus.
The topics covered in addition ABAP are Query, BC Sets, and Computer Aided Test tools
Tutor for SAP Course at the University of Sydney. The SAP course covers modules such as FI,CO,SD,MM,AA,WorkFlow using SAP Version 4.7. Exposure to WM. Customization for FI and SD are also Covered. Also Tutor in E-Commerce and Database systems using ORACLE9.
C .Net Connector Developed Visual Studio Application in C to display Customer, Vendor information by using RFC Calls. Also developed .NET Connector introductory course material.
Nov 2003 Jan 2004 SAP ConsultantUniversity of Technology Sydney, School of Accounting
Develop Logistic Information Structures in SD and MM. Configure the Special Purpose Ledger in FI to create Ledgers with data from FI,CO,SD and develop Drill Down Reports.
Worked in BW 3.2 Created info cubes and ODS for Sales reporting. Developed Reports using Bex tool and also used the Report-Report interface. Worked on SAP BW integration - Configured the Logistic Cockpit to bring in Logistic Data from SAP. Used the CO-PA Data extractor to populate CO-PA data into BW info cube and develop Bex reports.
June 2002 Sep 2003 Holiday Planners, Chattswood Sydney Technical LeadCoordinate the development Administering of Web Sites on WINDOWS 2000 server. There are About 18 web sites that are hosted and under development and all the sites cater to different segments of the business. My work also includes marketing these web sites with different Travel agents and tour operators around the world.
Familiar with Data Warehousing using SQL Server 2000 .
University of SydneyOnline Examination System using C, ASP.Net and Sql Server 2000. The software lets the Registered students take a online test and validates, marks and records their answers. The software also emails the students the details of the test to the students. The questions are Randomly selected from the databases. The Administration Module facilitates the creation of student's information and questions to the examination Database.
Also a Part time Tutor at the University of Sydney in Computer Science.
Dec 2001 - June 2002
Parasoft.com Learning, Strathfield Sydney Technical Lead
Conducting Training courses in J2EE, Server Side Java and UNIX Solaris 8 System Admin.
Providing consultancy on J2EE, Weblogic Application Server 6.1, tomcat and SAP.
Work included JDBC 2.0, Enterprise Java Beans, JSPs including JSP with
Tag libraries, Servlets, XML and Webservices.
April 2000 - Nov 2001
GlobeSoft Corporation
Project: SAP Consultant for KONAMI USA.
Worked as Consultant May 2001 providing solutions in Sales and Distribution Pricing, Developed ABAP reports in FI-CO area. Also developed and modified reports in Sales and Distributions Pricedifference reports, shipping reports etc .
Project: B2B Integrations: Client WebMethods
Worked for a month Jan- Feb 2001 on B2B integration in SQA Team. Work involved Testing B2B integration using Active Works ATC tool using ORACLE, SAP and Java API for ATC tool. Also conducted a training session to the team in SAP.
Project: Onlineconstructor.com Client: Online constructor Inc., Houston, TXOnline Constructor Inc. is a virtual secure Project Room and a construction industry information resource. Based on the Application Service Provider model, the purpose of this site is to provide a unified web based resource for all project management functions. Project planning, scheduling, document storage, Project status and progress are some of the functions implemented. The software has been developed using servlets, JSP and ejbs on Weblogic Application server/
Role:
- Analysis and design of the database for the Site Information
- Designed and developed servlets to implement Site Information, Lease Information,
Utilities Information, Acquisition Information, Utilities Information, Property Owner Information, Leases Information etc
Keying Software for DirecPC
Modifications to Incorporate provisions for Mt Fuji Board keying sequence. The Existing
Software supports keying of Mount Pikes Boards for DirecPC. The keying software
Consists of Master Key Programmer MKP, KeyLoad software in VC and Keyservers
In VB.
My work involved Modifications for VB software so that the key server can
Handle requests for keys for both types of Boards.
Other TasksSystem's Design for Consultant management for Globesoft to be developed in India by
CSSOFT. The main aim of the design was to create website from which management of
All consultants can be done easily. The system is event driven and will use servlets and
Ejbs.
Providing Support and Administration Services on UNIX running ERP software using
ORACLE 8.2.2 and Developer 2000 Tools.
Interfacing to Legacy ERP systems using REX so that scanned data from POS units is
Transferred to ERP systems.
Setting up Globesoft Office Computers and assisting in Network setup using NT and LINUX. Assistance in configuring LINUX for virtual Hosting.
Configured WebLogic 5.1 Application Server on UNIX and NT servers with ORACLE 8
Database. Have written and deployed Entity and Session Beans on the Web Logic server.
Implemented J2EE and J2SDK on LINUX and deployed E-Commerce Application. Created
The .EAR file for the application, .WAR file consisisting of .JSPs and Servlets and JAR file
Containing Ejbs.
September 1999 March 2000 Stargate Solutions, Inc Technical LeadWeb Software Development using Net Objects Fusion 4 and Java, JDBC with Oracle Database .
- The Software caters to keep track of Sales and Support of several products featuring, tracking, and listing of statuses by Product etc. Other features include training products. Reporting provides complete listing of the pending queries from the customers, also keeps track of the time-spent on each activity.
Activities include enhancements to corporate website. Experience and Administration in setting the Java Web Server, Data Base for the application. Developed Server side software in Java Servlets and HTML on the client. Also used Enterprise Java Beans, ASP and XML.
April 1999 August 1999 Technical LeadSAP R/3 Consultant - Great Lakes Chemicals, Lafayette, Indiana.
- As an LIS/ABAP consultant developed Info structures in SIS Orders and Billing and developed reports in Report painter to meet the reporting requirements for the Sales people to manage orders and Invoices. The info structures were programmed to handle Order rejects by ABAP requirements.
- In Purchasing developed info structure S650 to meet the requirements at Good receipt. This info structure has fields such as goods receipt value and Quantity. Data elements were created for these fields and ABAP formulas populate these fields at Goods receipt time. The info structure is update on posting periods. The values are calculated based on movement types 101,102, 122 from the table EKBE for records in the period.
- In Inventory developed info structure S700 that has key figures such as unrestricted stock, Production Qty, Usage Qty, Unrestricted Consignment, Quality Inspection, Delivery Qty, Order Qty, Scrap Qty, and Stock in Transit and Blocked Stock. The characteristics are Profit Center, Plant, Storage Location and Material. In order to able to report the product hierarchy Main Group, Group and Sub Group were stored as key figures. Each of the key figures is populated by ABAP based on quantities from the communication structure MCMSEG for the period and the relevant movement types and other condition. Standard SAP uses 3 communication structures S031, S032 and S039 to give some of these values and an OSS Note specifies that these inventory calculations are quite cumbersome and will need to have these 3 types of info structures. The inventory info structure is self-contained and can cater for all inventory reports such as Profit Center Stock, Plant and Storage Location stock.
- Demand info structures S960, which will report the demand on the Plant by Material. The characteristics are Sales organization, Plant, Shipping Point, Sales Document, Material and the Key figures are Inventory Qty, Open Orders, Requested Delivery Date, Ship to Party. An ABAP formula based computes inventory qty. The info structure is updated at Sale Order time and by Batch from Stock Transport orders Document Type NL, NLCC . In the case of STO the Sales Document field in S960 stores the Purchase order No. This report shows the demand on the plant and helps the Plant managers to full fill customer Orders.
March 1999
SAP Consultant at Lehigh Portland Cements, Allentown, PA.
- As a team of 3 consultants made detailed study of the reporting requirements at Lehigh Portland Cement. The process involved talking to about 70 users in various business units and presenting a report to the management about the different options to cater for the reporting requirements. One of the main options was the use of LIS to cater for the immediate reporting requirements and later add the use of Business Warehouse.
Dec 1998 Feb 1999
CyberTech Systems Inc.
- Configured ALE to send Material Master Message types MATMAS using IDOCs, this involved use of filters. Also performed IDOC administration such as sending and receiving IDOCS etc.
- Study and Presentation of the Use of LIS to solve the reporting requirements of Solvan Valves, Chicago.
- ABAP programming in HR module. Use of the PNP logical database and HR structures to generate HR reports for Wage Computation.
June 1998 Nov 1998 Technical Lead
SAP R/3 Consultant, Briggs Stratton - IS, Milwaukee, WI
- Demonstrated the used of LIS to solve the reporting and decision making requirements of client. The initial work involved creating info structures that can be populated with an Extract from SAP data, which was being sent to Mainframe to get reports from the legacy system. Forecasted information from non-SAP was populated in the info structure for Sales. Created reports from these Info structures using report painter, standard and flexible analysis.
- Created Data elements, Database Projection views, tables and wrote ABAP programs to populate user created tables.
- Info Structure for Vision is a division of Information system of client that tracks sales of engines, which was created to meet the reporting requirement of Vision Sales. The open orders are calculated based on actual post goods issue date in the delivery header table and orders based on schedule line. The system ensures that orders are cleared on a FIFO basis based on shipments. Also set up the hierarchy to enter the forecasting information and quarterly reports and report the variance from forecasting by customer and engines for a Sales Rep. Sap tables used were VBAK, VBAP, VBEP, LIPS, LIKP and VBPA.
- Info structure in Purchasing and report variance in Purchasing and invoice for a material. The characteristic hierarchy is based on Plant/Profit Center/ Material/ Purchase order/Purchase org/Vendor/Vendor Country. Some of the key figures are Goods receipt qty value, Invoice Value, Original PO quantity MENGE and Original PO effective value EFFWR . Formulas for characteristics and key figures ensure that these values are populated at the required event s .
- Info structure for Plant Maintenance Cost Evaluation and reporting based on number of hours for a work order. Characteristics are Order type/ Functional Location/ equipment/Work order/Control Key formula and key figures of No orders create, confirmed, Total actual costs, Material costs, Internal and external wages and number of hours for the work order for all the confirmations which is calculated by formula.
- Info Structure for Scrap Reporting consists of Characteristics of Material Document/year/Plant/Material/Good recipient. The key figures are quantity and Amount, Movement type and Profit center. The system populates the info structure for movement types 551,552,201,202,701,702,911,912 and uses the tables MSEG, MKPF, MAKT, MBEW, MARA and T900b.
- Added a Customer Enhancement for MMCP20002, which handles function EXIT SAPMMCP6 002 to process a macro, which is called from the macro USER V1 in transaction MC94. The code is in the include file ZXSOPu02 and fills in fields in the vision info structure at planning time which are not displayed in the planning screen but are required for reporting.
May 1998 June 1998
SAP R/3 SD Consultant, Gruma, TX
- Supported the roll out of Plainview, TX Plant. Tasks included GAP analysis from the pilot plant and solving open issues dealing with Freight Conditions in pricing procedures, Customization for Plant to Plant Stock Transfer order, Output determination in selection of printers for different Sale offices and output types for Bill of Lading and Sales Order.
- Coordinated with team of programmers working in Monterey for form changes required for Plainview plant.
November 1997 April 1998
SAP R/3 Consultant, Hershey, PA
- Developed and modified several reports using Report Painter, and customized the reporting tree in FI/CO/PA areas. Some of the reports developed and modified were Consolidated Statement of Income, Plan/Actual Comparison, and Actual/Actual comparison. Provided drill-down facility with local currency.
- Conducted training on Report Painter for 15 participants, covering creation of libraries, reports with and without use of the model, use of variables, sets and report groups.
- Created Market Responsibility reports using the form-based PA reporting tool. Developed about 50 SIS reports using Report Painter. Some of the reports developed were daily flash to warehouse, regional sales call, highlight reports, trade class summary, monthly sales summary, ranking reports, summary of credits and charges, weekly item sales, broker commission reports, summary of samples ordered, credit reports and promotion reports.
- Created and modified Info Structures for flexible and standard analysis in SIS. Verified data validity and debugged Info Structures.
March 1997 - October 1997
SAP R/3 SD/ABAP Consultant for CyberTech International Corporation, IL
- Analyzed the existing Sales and Distribution operations and identified business areas to map the process in SAP SD module.
- Configuration and customization of global parameters and organizational settings related to Sales and Distribution. Created business areas, functional areas, Plants and Divisions, Sales Organization, Sales groups, Shipping Points, Loading points and transportation planning points.
- Configured sales document types inquiry, quotation, Standard order and established links with item category groups and item categories.
- Mapped Sales Department structures to SAP Sales Organization, Distribution Channels, Divisions, Sales Office, Sales Group and Sales persons.
- Extended the Material Master views for finished products so that relevant sales views exists with the correct information.
- Used Pricing and Conditions technique to create new country and state specific taxes. Created client specific Pricing procedures.
- Interface with FI. Developed account determination procedure so that different accounts are updated based on customers' transactions.
- Established Credit Control Areas with predefine Credit Limits based on regions and customized R3 so that a warning is issued whenever the credit limit is exceeded.
- Customized Foreign Trade requirements such as applying for necessary permits for Export from the source country and Import in the destination countries.
- Created RFD's to get Sales order information from different clients and report in yet another client. Also wrote BDC's populate sap tables from legacy systems.
- Trained end users in the Sales cycle viz., inquiry, quotation, Standard Sales order, delivery documents, billing and ABAP/4 Query to create reports and analyze data using SAP Graphics.
- Trained in: SD and ABAP/4 programming, customization of SD functional module, ABAP/4 Programming Language. Developed Interactive reports, data input using flat files, Workbench organizer and transport system. Created and maintained SAP Script layout sets for Purchase order, Sales order and Batch Data Communication for migration of data from legacy systems to SAP.
- Developed Legal Application Software for use in the State of Colorado. The Software ask the user a series of questions in a intuitive way as and fills all the forms required to Obtain a Divorce in the state of Colorado. My role was f to design the system, code and assist the other programmers in coding in and testing the system. The tools used where Java, JDBC.
- Automation of Synthesis: This tool was developed which helps Chip designers. The Java based tool lets the user build a hierarchical compile using the design hierarchy automatically by parsing verilog and VHDL designs. Each hierarchy is classified as a Node with several characteristics like compile, link etc., The system lets the user assigns Constrains and Strategies and generates information such as Area, Cell, timing, logs etc.
December 1995 - March 1996
Senior Consultant, Gulf Computers
- Developed workflow-based systems using FILENET and Power Builder 4.0 for Florida Workers Compensation and Maryland Workers Compensation.
- Reviewed workflow implementation at Maryland Workers Compensation.
November 1991 - November 1995
- Managed multiple software projects for Pennar InfoTech
- Managed the ATICS project, which automated train-ticketing machines for a Swiss company. Tasks involved Setting up a team of 10 people and manage a development project using C, SDK and Informix.
- Managed Email services. Developed software on Xenix using Foxbase.
June 1988 - November 1991
Analyst/Programmer, New Zealand
- Developed software in UNIX RM-COBOL for a meat processing company. Worked on computerization of cold storage warehouses. This involved implementing the Storage Locations mapping, picking, loadout and all Warehouse transactions. Provided interfaces with bar coding equipment.
- Developed specifications for a Benefits Payment Control system for the Social Security organization.
April 1986 - May 1988
Tutor, University of New Castle, Australia
EDUCATION
- Master's Degree in Computer Science.
- Master's Degree in Science Applied Electronics .
- Bachelor's Degree in Science.