Senior Programmer Analyst Resume
CAREER SUMMARY
An information technology professional with over 17 years of diverse application design, development and support experience. Established record of analysis and design, system bridging, software implementation, technical documentation and creative problem resolution. Demonstrated adaptability to a broad range of software and hardware system platforms.
TECHNICAL SKILLS Software:
HTML | CSS | ASP| .NET 3.5
Visual C# | VB.NET | Visual Studio 2010
Javascript | Management Studio | 2008 SQL Server
Ajax | jQuery | DTS packages Unix Scripting Microfocus | COBOL MVS COBOL/CICS
FTP Visio | Oracle Forms/Reports
MS Project Animator | SQL*Loader
Fast Unload | File Aid | Exceed
SQL | Platinum | Endeavor
Xpediter | Unicenter | TSO/ISPF
Appworx | Microsoft Office Suite | PVCS
Databases:
Microsoft SQL Server 2008 Oracle 8i to 11i DB2
Hardware:
IBM SP2 IBM pSeries IBM POS 4690
Operating Systems:
AIX Version 4.3 - 5.3 Windows Linux
AS/400 MVS Mainframe OS/390 through z/OS1.7
EXPERIENCE
11/91 - 08/09 Confidential, Green Bay, Wisconsin
A leading retailer with over 142 stores, 15,000 employees and consolidated annual revenues in excess of $2.2 billion. An affiliate of Confidential.
Senior Programmer Analyst/Application Architect (04/99 - 08/09)
Reporting to the Project Manager. Responsible for designing, delivering and resolving systems technology issues. Maintains effective internal control of Systems involving implementation, tuning, optimization and integrity of environment. Adheres to all aspects of Shopko Information Services Development Methodology (SISDM) for projects and problem/change management.
- Served as one of four lead analysts on POS Pricing Enhancements Project. Created high-level design for sales capture, system data flows and detail design specs, system test plans, cost and DASD estimation and project plan development, including completing 360° performance evaluations for project team members.
- Redesigned and upgraded Resource Management Visual Labor Management to use over 500 labor criteria drivers at store level which increased accuracy of store labor schedules and decreased costs.
- Upgraded extract and data feed from SQL server for Loss Prevention Management System conversion, increasing theft and civil recovery dollar amounts.
- Created Oracle loyalty item driver table using database trigger and Win refund interface for customer market basket analysis.
- Designed and system-tested processes for New E-commerce Online Store which ensured inventory accuracy.
- Designed and installed data feeds to Gallagher Bassett for all company worker's compensation and general liability cases using SQL Server database, AWK and DTS packages.
- Researched and resolved long-standing In-Store Processer menuing problem which eliminated 1,800 incidents per year, significantly reducing help desk call volume.
- Analyzed requirement and created Unix script for store signing, automating a manual process and improving communication between business partners and vendors.
- Created Unix script for weekly payroll commit verification containing an e-mail and pager notification process.
- Upgraded Gentran EDI translator software from Sterling commerce to a Y2K-compliant release for Y2K readiness.
Programmer/Analyst (11/94 - 04/99)
Reporting to the Project Manager. Responsible for creating and implementing small- to medium-sized system technology solutions for support issues and new project development.
- Served as one of two main architects on the design and implementation of Three-Way Automatch Project for purchase orders, receivings and invoices, resulting in an immediate accurate match rate of 98%, reducing costs and increasing productivity.
- Led In-Store Processor Team for annual system health check that identified inefficiencies, reduced batch run times, optimized SQL statements and reduced storage requirements.
- Successfully bridged financial system and the EDI system to implement Electronic Funds Transfer via EDI (820).
Programmer (11/92 - 11/94)
Reporting to the Project Manager. Responsible for providing system support, coding and implementation of changes.
- Successfully interfaced Walker with EDI (810) for invoicing including suspend file reprocessing and automatic selection of best payment terms.
- Assisted with install of Walker Financial System by loading all open invoices from parent company, SuperValu which enabled the initial IPO stock offering of Shopko on NY stock exchange.
EDUCATION
Bachelor of Business Administration - Administrative Management and Management Information Systems.
Web Application Developer Certification.
