Experience Summary:

• I have over 10 years experience creating various Analysis and reporting systems for executive management level reporting needs. These include marketing research detailing customer trends in the casino industry, order tracking for consumer electronics manufacturing, system problem cost tracking for ERP application support and online user interest analysis for findfamilyrestroom.com.
• Databases MS Access, MySQL, DB2, DB2 Connect, Oracle 10g Express, Dbase 3
• Programming Access VBA Excel VBA, COBOLII, JCL, VB, JavaScript, Java, PHP5, HTML, SQL
• Operating Systems Windows versions 95-XP, DOS, MVS, AIX
• Software ERwin, MS Query, MS Project, Crystal Reports, Brio, R R Report Writer, HTML-Kit, SAP R/3 versions 3.1H, 4.5B 4.6D, SPF/PC, TSO, MS Office, Lotus Office, Freelance Graphics, Harvard Graphics, Pagemaker, MS Outlook, Lotus Notes, Code 1 Plus, Merge/Purge, CPMA, ManageNow, GIMP2

Work History

Confidential

• Creation of Confidential Coordination with 3rd party service providers as well as planning and development of all operational code for sites.
• Created back end database systems using MySQL
• Developed and maintained all PHP, Java, HTML and CSS elements of the site
• Tracking of site traffic using web analytics software and SEO.

Confidential

• Coordinated with client user team and development teams to create report sets developed from existing SAP reports and translated to Brio. Created a data map of a new proprietary system and developed test case scenarios for the report translation. Worked with the end user team to ensure that the product met all current business requirements and created processes to handle future upgrades.
• Development of program specifications based on end user needs
• Manual manipulation of live data system to support error resolution utilizing DB2, SQL
• Creation of end user documentation and training of end user groups
• 24x7 Level 2 support of Xcellerator PC/Server ordering system

Confidential

• Responsible for 2nd and 3rd shift operations on SAP for external load fulfillment. The operation was coordinated across several manufacturing and shipping groups in Mexico, China, Hungary and Scotland. Coordinated and performed UAT and regression testing for new code as well as recommending and testing solutions to issues encountered during new releases
• Identification and resolution of production issues
• Manual SAP IDOC creation and processing when needed
• Ad hoc database, ETL processes and report creation to support problem resolution using MS Access, DB2, SQL, and VBA.
• Coordinate with diverse business teams during new releases

Confidential

• Led a team responsible for SAP level 2 support for IBM's Personal Computer Division. Responsible for short term solution application as well as long term solution planning among several functional areas including finance, manufacturing, distribution and system security. Annual verification and updating of all customer service level agreements between support and business teams.
• Central point of contact between CDI support group and IBM Personal Computer Division
• Workflow administration, configuration and repair of stopped workflow processes.
• Creation and maintenance of Level 1 documentation, escalation and callout procedures
• Escalation of system issues and creation/processing of system change requests.
• Identification and coordination of business groups to support resolution of system issues
• Creation of a documentation website of 500 pages and documentation tracking database for all support teams using MS Access VBA and HTML
• Creation of a problem ticket tracking system to analyze costs associated to problem resolution using MS Access and SQL
• Coordinated EDI configuration and implementation on SAP R/3 system
• Coordinated knowledge transfer of support operations to offshore team
• Analysis of ABAP/4 code to trace system issues during problem resolution
• 24x7 support of multiple SAP modules including functional areas including MM, PP, SD, FI, Workflow, EDI, batch processing and interfaces to external systems.

Confidential

• Performed thorough testing of programs of varied types, including creating test data, verifying program output, verifying proper file manipulations, as well as creating test plans for each program's expected output
• Performed Y2K updates to systems
• Creation of multiple level control break reports
• Created both inline and called JCL routines and manipulation of generation data sets
• Worked with VSAM and flat files
• Created called and calling COBOL programs

Confidential

• Leadership of an in house marketing research and direct mail production team. Acted as a liaison by translating Marketing requirements into usable specifications for the MIS department to support Marketing goals. Identified and developed methods to increase productivity of in house staff. Responsible for developing new marketing segmentation strategies to increase revenue and lower marketing costs.
• Created new reporting methodologies to enable management to make more timely marketing decisions using SQL, MS Access and MS Excel
• Coordinated external research and technical service providers
• Automated routine processes improved paperwork efficiency by approximately 1000 using MS Word VBA.
• Created a new training system for production employees increasing employee retention times
• Updated older data systems to improve usability
• Created system to link direct mail production and mail room operations to give a more accurate assessment of Marketing costs associated with each direct mail campaign
• Created a process to customize text in direct mail pieces using customer information found in the master customer dataset