Erick Johnson

Erick Johnson > Erick Johnson
email (ejohns_21@yahoo.com)
www.erickjohnson.net

WORK EXPERIENCE

HorrorAvenue.com, Minneapolis, MN - 1/03 to current

Creator/Founder/Programmer

Created all HTML pages.
Developed pages containing PHP scripting interacting with MySQL database.
Used Perl to create in internal search engine.
Developed relationship with affiliates AllPosters.com, and Amazon.com.
Designed and normalized a MySQL database to develop interactive webpages.

Pediatric Home Service (PHS), Roseville, MN - 8/01 to current

System Analyst

Responsible for maintaining and supporting Mesta software package. My tasks include:

Implementing and testing monthly patches
Troubleshooting issues/requests
Developing and maintaining Microsoft Access database that tracks issues/requests
Communicating with vendor for issue resolution
Creating business critical reports via Mesta reporting tool
Highly respected among management team and peers

Providing day to day user support
Assisting with interviewing process of new IT staff
Assisting with development of first annual IT budget
Managing and coordinating various projects
Projects-

Real-time Work Orders

Coordinating and managing resources within PHS
Working closely with Customer Service Manager to design work order layout
Communicating needs with vendor to implement work order design changes
Testing and implementing all IT changes
Increasing Customer Service effeciency by 15%

Diary Billing

Coordinated and managed resources within PHS
Tested and implemented all IT Changes
Responsible for migration to production Environment
Decreased Day Sales Outstanding by 15%

Project Update

Interviewing employees from various areas, including Customer Service, Warehouse, and Billing, to identify business processes
Flow charting all business processes, including DME and IV areas
Identifying inefficiencies in current business processes
Implementing quick fix opportunities in current environment
Communicating changes/modifications to vendor for approval
Creating business requirements for RFP

Computer Science Corporation (CSC) Consulting, Minneapolis, MN - 8/98 to 8/01

Consultant- Team Lead

Client

: AEGON USA, project location- Cedar Rapids, IA, 11/00 to 8/01
Projects- New Business Process Re-engineering Analysis Implementation

Led a team of 15 client and CSC business analysts and client/server programmers in developing and implementing a JavaScript browser-based application for data entry of annuities. The application bridged three different legacy systems, integrating logic from each system. My tasks included:

Assisting with development of Oracle database
Translating business requirements for a team of 6 programmers
Leading daily status meetings
Facilitating meetings with executive management
Resolving issues within business requirements
Developing unit and formal testing matrixes
Leading a test team of 10 through system, unit and formal testing
Developing an implementation weekend checklist
Finalizing client deliverables

Developed a strong client relationship in a very difficult client environment.
The project above is on schedule to be completed on time and within budget.

Consultant- Business Analyst

Client

AEGON USA, project location- Cedar Rapids, IA, 7/00-11/00
Projects

New Business Re-engineering Analysis

Led a team of 2 CSC junior business analysts and 25 client business users/specialists through a business process re-engineering methodology to improve processing efficiencies, automate decisions and improve processing accuracy. My tasks included:

Leading and facilitating 18 workshops for 25 plus business users and management.
Developing "as is" and "to be" business process flow diagrams
Capturing and interpreting business requirements
Developing business requirements
Developing a prioritization matrix
Developing a business process and technology dependency map
Developing a high-level implementation project plan
Developing weekly status reports for my project and account manager

The project was successfully completed on time and under budget. The client approved our project team to move forward and implement the business requirements. My project and account manager were so pleased with my work that I was asked to be a Team Lead for the implementation project mentioned above.

Consultant- Application Tester

Client

AEGON USA, project location- Cedar Rapids, IA, 10/99-7/00
Projects

VantageOne Fixed 15.0 Conversion, NBU Phase II

Member of testing team, performing system, unit, and formal testing for annuity tracking software. My tasks included:

Developing a unit and formal test matrix
Escalating issues to appropriate resource
Verifying actual results versus expected results
Performing team lead responsibilities in the absence of the team lead

Completed both projects on time and under budget. My account manager and client were so pleased with my work that I was asked to be part of the re-engineering project team identified in the project above.

Consultant- Oracle Developer

Client

City of Minneapolis, project location- Minneapolis, MN, 6/99-10/99
Projects

Office of the Assessor Conversion

Member of the conversion team. This project was to convert the city asset tracking software from a Unisys LINC Code system to a Visual Basic/Oracle Client Server system. My tasks included:

Developing Oracle tables
Translating LINC Code into requirements and PL/SQL code
Producing PL/SQL code for data manipulation and data warehouse
Running system and unit tests, verifying results, and document and resolving issues.
Using UNIX, FTP, and SQL Loader to perform data transfers, data manipulation.

Consultant- Y2k Analyst

Client

Weyerhaeuser Canada - Dryden Operations, project location- Dryden, Ontario and Weyerhaeuser, project location - Valliant, OK, 10/98- 6/99
Projects

Y2k Readiness

This project was to ensure all of the software used at this location was Y2k compliant. My tasks included:

Developing a unit and formal test matrix.
Overseeing 10 CSC and client testers in performing testing for 30 client/server applications
Verifying expected results to actual results, and documenting and resolving issues.
Coordinating with outside vendors to install necessary service packs
Responsible for developing a tracking database and escalating issues upwards
Runnning UNIX test cycles

Consultant- Associate Training

Client

CSC Consulting, project location- Chicago, IL, 8/98-10/98
Projects

CSC Associate Training Program

This was an intense eight week training program developed and presented by CSC Consulting. The training program consisted of the following:

Developing application systems using client/server and legacy technologies
Ascertaining database concepts, testing techniques, and debugging skills
Gaining experience with legacy systems and structured programming design
Completing 2 weeks of consulting skills
Completing 2 weeks of COBOL training
Completing 2 weeks of C++ training
Completing 2 weeks of Visual Basic training

TECHNICAL SKILLS

Operating Systems: DOS, Win95, Win98, WinNT 4.0, Win2000, WinXP, UNIX
Programming Languages: COBOL, C, C++, HTML, Java, Visual Basic
Scripting Languages: Javascript, Perl, PHP
Special Technologies: SQL, PL/SQL, MySQL
Mainframe Software: VantageOne, New Business Underwriting (NBU), DSS
Client/Server Software: AWD, Mesta, Oracle Databases, Microsoft Project, Microsoft Office, Qualcomm Eudora, Lotus Notes, Visio

EDUCATION

University Of Minnesota- Carlson School of Management - Minneapolis, MN
B.S. MIS, June 1998.
University Of St. Thomas- Management Center - Minneapolis, MN
Project Manager Certificate, May 2002.

REFERENCES Available upon request.