Developed SAP R/3s Microsoft SQL Server database monitor tools
Designed and implemented complete ABAP applications
Maintain SAP Script for FI and SD modules, BDCs
Used Remote Function Calls, SAP Web Server, and Graphics
Utilized ABAP Objects, UI controls, and ALV
Created, imported and exported SAP transports
Performed remote analysis of customer SAP R/3 systems
Wrote Transact SQL code for Microsoft SQL Server
Worked extensively with SQL Server. Tasks have included installation, configuration, performance turning, and administration.
SAP Developer, Atmel ••••• Present
Implemented batch jobs for SAP Sales and Distribution and Material Management modules. Activities included coding to automate the entry of customer and material data, jurisdiction codes, and foreign trade.
Programmed the import and export of SAP EDI data from companys sales distributors and mapped this data into material and customer data tables in R/3 using custom tables and transactions. Created POS, shipping and debit, customer return, inventory tracking, and sales commissions splits reports. Designed and developed Sales Commission process interface. Created a custom interface to allow users to correct input errors during monthly mass import runs and allowed for the automatic EDI distribution of uncorrectable data notifications back to distributors.
Maintained SAP Forms for SD and FI modules, it includes quotations, invoices, purchase orders, packing slips, and customer statements using SAP Script.
Performance turning for custom MM, PP, and FI reports. Worked closely with functional people identify new requirements and production support.
Sr. Developer, SAP America, Inc.•••••••••• - •••••
Developed the user interface for all R/3 SQL Server specific monitoring transactions. Modernized the whole interface to use newer SAP technologies like ABAP Objects and controls, ALV lists, tree controls, text controls, splitters etc.
Developed a remote monitoring server for the CRM Mobile Client using C, SAP RFC and ODBC for SQL Server. The server collects data from the Mobile Client database and sends them back to the SAP R/3 system.
Developed database monitoring tools using the SAP Web Server and SAP graphics.
Established trace tools to analyze problematic SQL statements in the SAP R/3 environment.
Created functions for automatic download from SQL Server & CRM. This process collects the performance data from customer sites to SAPs database.
Beta evaluated and documented a Solution Database for CRM using Legacy System Monitor Workbench and a Data Transfer Workbench. Imported Legacy data into CRM via BAPI, for symptoms and solutions analysis.
Participating in development support, working on customer issues. Create SAP Notes for bug fixing and back porting. Created, imported, and exported transport customized add-ons.
Administered R/3 systems in the development landscape.
Sr. Technical Consultant, SAP America, Inc.•••••••••• •••••
Implemented proactive SAP R/3 database monitoring tools in ABAP. These tools collect statistical data of database performance and are stored in the R/3 database for the remote consulting. This work consisted of creating ABAP reports, user interfaces, batch jobs, and creating tables, data elements in data dictionary.
Created online consulting guide web site for the remote consultants.
Participating in the development of SAP with SQL Server Database Administration training course.
Technical Consultant, SAP America, Inc.•••••••••• - •••••
Increased SAP R/3s efficiency by providing basis remote consulting for customers in operating system, R/3 Application tier, and database.
Remotely traced problematic transactions and analyzed collected data for application developers for further performance improvements.
Database Administrator, Telogy Inc.•••••••••• - •••••
Administered Sybase production database. Responsible for resource allocation, performance tuning, data integrity, database access control, and updates. Managed application source code control.
Created utilities to automatically monitor database activities, and consistency checking. Wrote Unix tools to terminate runaway processes on the network, and graphical reports to track Unix server performance.
Staff Engineer, NEC America Inc.•••••••••• - •••••
Created Sybase database tools, such as in-house bug tracking system, and inventory.
Developed and maintained user interface tools in SQR, APT, DWB, and DB-library applications.
Developed CM metrics, statistical analysis, documentation control, and release management tools.
Responsible for build, release projects, and source code control. Create generic software distribution installation scripts for customers.
System Administrator, NEC America Inc.•••••••••• - •••••
Administrator for Unix system, Sun, DEC, HP. Upgrade OS, install new workstations, system configuration, and maintenance of NIS database.
Supported Suns software UUCP, X•••••, NSE. Install, administer various application software, particularly Interleaf, Frame, Cadre, Sybase.
System Administrator, National Semiconductor Corp.•••••••••• - •••••
Install Sun workstations and servers for various architectures.
Designed and developed system administration toolkit in Shell for supporting other groups. It has the function of add/delete user, and backup the entire network every ••••• hours automatically.
Quality Assurance, National Semiconductor Corp.•••••••••• - •••••
Performed quality assurance of all CADs in-house software release. The QA includes implementing procedures for re-generating binaries, checking I/Os, writing QA reports, and contacting developers for enhancement.
Developed in-house software installation tools for other groups and tools for QA procedures. Modify security software for eliminate unauthorized users to access the software.
Languages•••••ABAP, HTML, C, Basic, C•••••, APT, Basic, Assembler, Shell
Operating systems Windows •••••, Windows NT, UNIX, Sun Solaris
Education•••••B.S. in Computer Science San Francisco State University, CA