Systems Analyst Resume

Title
Systems Analyst

Primary Skills
SDLC, SAP, VAX/VMS

Location
US-PA-Quakertown

Posted
Jan-25-09

SUMMARY

Information Technology Professional with over fifteen years experience in the full Software Development Life Cycle, client application support, Systems Analysis, Business Analysis, Quality Assurance and Programming. Provided support to diverse clients in the pharmaceutical, manufacturing and automotive industries. Experience working in an FDA regulated environment including validated systems. Extensive knowledge of financial systems combined with demonstrated cost savings accomplishments. Recognized for strong skills in organization, analysis, communication, customer satisfaction, troubleshooting and collaboration with cross-functional teams.

TECHNICAL SKILLS

* SAP Procurement 4.6
* AutoSys
* TPU, EDT, LSE
* VAX/VMS & Utilities
* SAP B2B Procurement 4.6
* Oracle 8i/Oracle 9i
* LaTeX, DECwrite
* VAXnotes
* SAP Plant Maintenance 4.6
* P/L SQL Developer
* MS Office XP/97/00/03
* Rdb/VMS & Utilities
* SAP Finance 4.6
* SQL, SQL*Plus
* WebEx, Shadow
* CMS, MMS
* SAP Workflow 4.6
* P/L SQL, NetMeeting
* Windows XP/2000/NT
* DataTrieve, SmartStar
* SAP EDI 4.6
* HTML, XML, ASP
* PC Anywhere
* COBOL, GEMBASE
* ABAP, SAP OSS Notes
* FTP, XCOM
* vi editor, GroupWise
* Crystal Reports
* Vantive, Clientele
* ODBC, VisData, QD
* Carbon Copy
* Promix, MS Outlook
* Service Center
* EVE, WPS, WPS Plus
* Citrix, Dameware
* SQL Server 2000

PROFESSIONAL EXPERIENCE

PEAK TECHNICAL SERVICES, INC., Pittsburgh, PA 2006 to 2009
VOLVO 3P/MACK TRUCKS, Allentown, PA.
Business Systems Analyst / Developer
Provided services to design and develop a Tool Register application using MS Access for a manufacturing tooling database containing over $100 million in tooling assets for Volvo 3P North America. Assisted in the audit process on a team of seven and then became one of two auditors on a team of three.
* Created Functional Requirements Specification and System Design Specification.
* Redesigned and developed tables, forms, queries, macros and VBA code for SOX compliancy.
* Extensive use of MS Excel for data analysis and cleansing, importing to and exporting from the database.
* Provided implementation, support and documentation on troubleshooting and data conversion.
* Used SQL in Access to extract tool asset data from the Tool Register for 75 suppliers in 2006, 95 suppliers in 2007 and 118 suppliers in 2008.
* Used VLookup, If Then Else, macros, filters, data validation and protection in Excel to develop the tool audit forms for suppliers to use during the inventory/audit of Volvo 3P's tooling assets.
* Streamlined and improved the process for the tooling audit to allow auditing additional suppliers.
* One of two auditors on the team to research, analyze and confirm tool audit returns from suppliers.
* Approved as a qualified auditor for final sign off on tooling dispositions for write downs in 2008.
* Developed rapport with suppliers with direct communication to resolve any issues with the audit returns.
* Provided database administration support for both live and development Tool Register databases and maintained synchronization.

CARPARTS TECHNOLOGIES, INC., Allentown, PA 2004 to 2005
Systems Analyst / Technical Support Analyst
Provided third level customer and technical support in a team environment for a Point of Sale ERP proprietary system for the automotive aftermarket supply chain. Major emphasis was on general ledger transactions and troubleshooting. Provided support to approximately 3,500 stores in Canada and the USA.
* Remotely installed and upgraded software on customer sites. Tested and modified installation/upgrade documentation for customer use.
* Researched, tested and reported software bugs to development team.
* Developed and distributed customer documentation.
* Designed and developed functional specifications for modifications and/or additions to the VAST software.
* Designed, developed and posted clear, detailed and concise documentation for the Support Team web site on problem resolutions for use by the entire enterprise.
* Designed and developed documentation for VAST Product error codes: definition, root cause and resolution.

WYETH PHARMACEUTICALS (formerly Wyeth-Ayerst Laboratories), Frazer, PA 1997 - 2003
SAP Client / Technical Support Analyst (1999-2003)
Performed in a team environment to provide support, monitor and maintain the problem queue for SAP R/3 version 4.6C: Procurement, B2B Procurement, EDI, Plant Maintenance and Finance to over 1,500 clients in multiple divisions and international sites in an FDA regulated environment. Adhered to all relevant Standard Operating Procedures to ensure compliancy with security, legal, and regulatory requirements.
* Developed, tested and implemented configuration change controls for customizing and workbench modifications. Monitored and tested transports from development to quality assurance to production.
* Created, modified and tested ABAP reports using ABAP List Viewer (ALV) to retrieve purchase order information and allow clients to customize reports based on specific needs.
* Developed several test scripts and Integration Test Case Procedures for SAP modules and performed Operational Qualification and Performance Qualification testing of SAP modules in preparation for upgrades.
* Maintained and activated 700 vendors for EDI transmission of purchase orders. Partnered with mainframe EDI team to coordinate all EDI testing, troubleshooting and production processing.
* Designed, developed and tested several AutoSys scheduled job scripts and UNIX shell scripts; supported over seventy AutoSys scheduled jobs for interfaces to and from SAP.
* Developed, tested and maintained several dozen Business Process Procedures and expert Job Aides for SAP R/3 Procurement, Plant Maintenance and Inventory functions.
* Trained 150 clients on SAP Procurement, Plant Maintenance, Finance, B2B Procurement and EDI reducing client calls and improving functional efficiency.

Client Application Support Analyst (1997-1999)
Performed in a team environment to provide support, manage and maintain an issue database to over 200 clients using a validated Inventory Stock Locator System in an FDA regulated environment. Adhered to all relevant Standard Operating Procedures to ensure compliancy with security, legal, and regulatory requirements.
* Developed and submitted change control proposals to quality assurance.
* Provided documentation as required by the FDA for validated systems.
* Designed, developed, tested, implemented and maintained modifications to existing Oracle Rally Stock Locator System using Oracle/Rdb, SQL, SQLMOD's and Pascal.
* Performed Operational OQ and Performance Qualification PQ validation testing in preparation for upgrades.

MOYER PACKING COMPANY, Souderton, PA 1982 -- 1996
Sr. Systems Analyst
Experienced in the full software development life cycle. Managed, analyzed, designed, developed, tested, documented, implemented and supported financial applications for 120 clients in a VAX/VMS clustered environment.
* Designed, developed, installed and maintained a proprietary accounts payable system with multiple interfaces which enabled the organization to take advantage of $260,000 in annual discounts.
* Designed, developed and implemented an invoicing enhancement to the payable system which generated $231,000 of savings annually and reduced the number of checks created by 74% weekly.
* Designed, developed and installed customized order entry, billing and sales analysis modules which enabled the organization to save on average $130,000 in commodity market fluctuations.
* Designed, developed and installed a series of enhancements to the non-product inventory management system which generated in excess of $100,000 in savings.
* Designed, developed, implemented and maintained the following subsystem interfaces to the Ross General Ledger Package: accounts payable/receivable, operations payable, order entry and payroll to allow automatic feeds to the general ledger resulting in efficiency and time savings.
* Developed and implemented major enhancements to Ross Systems packages for accounts receivable and inventory control with a general ledger interface.

EDUCATION

B.S. Business and Computer Information Systems,
Graduated Magna cum Laude, GPA 3.75/4.0, Gwynedd-Mercy College, Gwynedd Valley, PA

TECHNICAL TRAINING

.NET Accelerated Certification Program
SAP Procurement, SAP B2B Procurement
Visio, Visual Studio .NET
SAP Plant Maintenance Planner
Rational XDE, UML, Oracle PL/SQL
SAP Process Manufacturing LO060
Oracle 9i DBA Accelerated Certification Program
SAP Logistics Information System LO930
ABAP Introduction/Intermediate
SAP Plant Maintenance Stockroom
Introduction to Web Development
SAP Plant Maintenance MIC
SAP Physical Inventory
21 CFR Part 11 Compliance Training
SAP Business Workflow Intro BC601
MS Excel, MS Access
SAP Business Workflow Program BC610
Ross Systems General Ledger, GEMBASE


Penn State University Oracle 9i Accelerated Certification Program Master Lab Project:
Developed a web-based On-Line Book Store using Oracle PL/SQL, HTML, ASP, FTP and Oracle 9i. Developed Oracle stored procedures, packages, triggers, views, functions, insert/update/delete statements, etc. Full-time student: February, 2003-->June, 2003.

Penn State University .NET Accelerated Certification Program Master Lab Project:
Developed a web-based On-Line Book Store using SQL Server 2000, MS Access, Oracle 9i, Visio, Visual Studio.NET, UML, Rational XDE, VB.NET, ASP.NET, C++.NET and ADO.NET. Part-time student: December, 2003-->May, 2004.

Certifications
Oracle 9i Accelerated Certification Program
.NET Accelerated Certification Program


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Quakertown, PA | Resumes in Pennsylvania

View other Systems Analyst resumes