Kevin Upson

**** ***** ** **, **. Petersburg, FL 33703

*** ***** *** **, ************, FL 32259

Home: 727-***-****, Mobile: 727-***-****, acs0i4@r.postjobfree.com

Professional Skills:

Lead development teams, designed, programmed and implemented applications. Including training developers, testers, administrators and users including client representatives

5 years experience working with Oracle and PL/SQL in the full-life cycle development and 3 years with SQL Server 2008 & 12 and SQL Server Management Studio, 12 years Access, 3 years DB2

Database experience includes designing creating data warehouses, schemas, tables, views, stored procedures, triggers and reports from multiple databases. Environments included oracle 11I, MS SQL Server, Access, DB2 .net, and windows.

Programmed enterprise level and web based applications using ASP.net,VB, C##, VB Script, Java Script, Bean Shell, DHTML, XML, HTML and SQL. PLSQL

Industries include financial/banking, health care, manufacturing, and entertainment

Analysis: Analysis of customer business requirements to create reports and applications. Development analysis includes running requirements meetings and interviews, defining business requirements and conversion to technical specifications, creation of UML and regulatory documentation. Reporting analysis includes identifying related data, trends, and exceptions. Application analysis has included business process modeling/mapping (cost benefit analysis, risk analysis, methodology development, and data modeling) and conversion of business requirements and rules to functional requirements and technical specifications

Project management: Created Project Plans defining scope, assigning resources, setting milestones, due dates and deliverables. Coordinated & directed execution of Project Plans by supervising development teams and integration of technical activities with other resources and getting signoff of clients. Reported process to management and stakeholders

Training/Presentation: Created training curriculum and taught junior developers, testers and technical writers in class room and individual settings. Demonstrated prototypes to end users and company directors for requirements analysis and project approval

Computer Skills:

Installed, configured, maintained and serviced Oracle, Sybase, Access, Microsoft SQL Server, DB2, Data Flex and Paradox databases and applications

Programmed enterprise level and web based applications including designing data warehouses, creating schemas, tables, views, stored procedures, triggers and reports from multiple sources using SQL and scripting. Environments included SQL Server 2008, oracle 11I, .net, and windows.

Used ASP.net, VBA, VB, C##, VB Script, Java Script, Bean Shell, DHTML, XML, HTML and SQL to create UI for the applications, Tools, reports, and data bases

Tools used include

SQL Server Management Studio, MS Report builder, PLSQL, Visual Studio 08, active x reports, MS Source Safe, Team Foundation Server

MS reporting Services, Active X Reports, Crystal Reports.

MS project, HP Quality Center, DOORS, Visio, MS Power Point, Word, Excel, Lotus Notes and TSO

Installed, configured and serviced MS-DOS, Windows (95, 98 and NT) UNIX, AIX, MVS, VMS operating systems and Novell networking software.

Programmed UNIX systems using c shell scripts DOS systems and Novell networks using batch files and script files.

Programmed mainframe systems using COBOL, CICS, JCL, TSO, ISPF, and SQL on a DB2 database. Including creating tables, views, stored procedures, triggers and reports from multiple sources using SQL in DB2 and embedded SQL in COBOL.

Current Position:

Humana 7/14/2013– present

Analyst

Create applications and report for health care pilot programs and client service processes

Develop and automate business/workflow process with Dashboards, Scorecards, Forms, Reports and Presentations

Used SQL, VBA code in an Oracle, Sequel Server, Access, Excel and APEX environment

Lead and Trained employees in software development regulations technology, standards and best practices

Recent Position:

Matrix Medical Network 5/1/2013– 5/1/2014

Application Developer Performance Analyst 12/16/2013 – Present

Data Warehouse design, development, implementation and project management

Used SQL, VBA code in an Sequel Server, Access, Excel and Tableau environment

Review Business Rules with Stakeholders, convert to technical specifications regarding:

Data Warehouse Architecture, dB Requirements, Table Design, Procedure, Application and Reports Code Specifications

Validate extract, transform, and load of data from multiple data sources

Develop and automate business/workflow process with Dashboards, Scorecards, Forms, Reports and Presentations

Manage Migration of processes and databases from prototypes to fully functional, scaleable solutions

Lead and Train new employees

Process Improvement Data Analysis, 5/1/2013 – 12/16/2013

Analyze business processes using appropriate models (six sigma, regression and correlation) to develop Key Performance Indicators pertaining to

Call Center Employee performance regarding career, bonus, and skill training

Call Center performance regarding, ROI, Resource Allocution, Setting Goals, Predictive Modeling and adherence to Investors Business Model.

Identify data sources and create dB procedure, queries, triggers, packages, and reports.

Previous Experience:

Aerotek (contract) Medtronic 10/22/2012– 4/13/2013

Sr. Software Quality Engineer

Reviewed SDLC to ensure compliance with U.S. and International medical device regulations & identified code issues

Used Visual Studio, MS Source Safe, MS Team Foundation Server, C# dot net 3.0 & 4.5 code

Code Review and approval

Manage requirements through UAT

Ran requirements gathering meeting

Convert user requirements to product and technical specifications

Identified usability criteria and potential risks

Perform product investigations, risk reviews, code reviews

Created and approved test protocols to meet FDA and outside of the US audits

Managed regulation documentation

Perform product investigations, risk reviews,

Modis, Inc (contract) JP Morgan Chase 5/1/2012– 9/21/2012

Developer web based Enterprise level and 3270 new and live applications

These projects use SubVersion (Tortoise), ASP.net, VB scripting, and D/XHTML.

I development and implement by:

Develop code in a database with a shared cache architecture

Managed SDLC

Manage requirements gathering through UAT

Communicating with BA and PMs in Requirements gathering meeting

Convert requirements and process flow diagrams to technical specifications

Reviewed and approved testing

Administered revision control (SubVersion) and implementation

Manage and document release management

Insight Global, Inc. (contract) Nielsen Media Research 3/28/2011– 4/4/2012

Programmer for web based Enterprise level applications, new and live applications

These projects were for a dot net environment (including some thin client MVC) using Visual Studio, MS Source Safe, MS Team Foundation Server, SQL Server 2005 & 2008 data bases, D/XHTML,VB.net,, C#.net, WCF, JSP, Jquery, AJAX, JavaScript, and CSS

Communicating with administrators and engineering teams by taking abstract business requirements and converting them to technical requirements and specifications

performing initial analysis,

creating supporting documentation (analysis and requirements documents and diagrams, project plans,),

Designing, coding and database design using development tools such as visual studio 2005, visual studio 2008, SQL server management studio, SQL server report builder 3.0 and visual studio source safe

Create SQL queries, scripts procedures, triggers, reports, views, and synonyms to analyze data to create business requirements, design data warehouses, service and control application’s processes, update data bases, unify databases and normalize data.

Coding applications using C#, Java script and dot net

diagnosing and resolving technical, code and use interface issues

SCC Softcomputer.com, 4/2/2005–4/15/2011

I lead development and implementation teams for web based Enterprise level applications

These projects

using Visual Studio, MS Source Safe, MS Team Foundation Server, Oracle 8i & 11g data bases, D/XHTML,VB.net,, C#.net, WCF, JSP, Jquery, AJAX, JavaScript, and CSS

in a dot net environment using multiple cluster databases with a shared cache architecture (including some thin client MVC)

used varying System Development Life Cycle (SDLC) paradigms including RAD and AGILE

By:

performing initial analysis, creating use cases & diagrams

Designing and coding application and database architecture using Java Script, Bean Shell, C#, SQL procedures, and development tools such as PLSQL, Visual Studio, Active X reports.

diagnosing and resolving technical, code and use interface issues

Created SQL queries, scripts procedures, triggers, reports, views, and synonyms to analyze data to create business requirements, design data warehouses, service and control application’s processes, update data bases, unify databases and normalize data.

Projects include:

POS Peripheral Ordering App including Inventory system unifying and operating across multiple databases

Contract Management System,

Requirements tracking and testing application,

System Development Life Cycle review and approval application

Web based quote and ordering application.

I direct multiple development teams and have had to develop unified development teams of up to 5 people of varying specialties and skill levels

Other duties included creating development standards and training curriculum for developers, testers and end users. I have conducted training sessions for new developers, and application users.

ManagerAssistant.com (contract) Global Technologies Group, 12/27/2004–1/14/2005ifial

Software Tester

Tested vacation accrual portion for employee benefit management application. Wrote test plans, tested (initial and regression) and verified results. Created SQL queries, scripts procedures, triggers, reports to analyze business processes, access and report data.

Aerotek (contract) Nielsen Media Research 6/1999–4/2004

SQA Analyst Tester

I supported and lead SQA analyst for multiple projects. These included data collection systems and information embedding systems for Nielsen Media Research. It involved working independently and interfacing with developers, vendors project managers and IT departments on hardware and software from concept to production. I was involved with the projects from translation of business model to project requirements to implementation.

Using:

VB, C++, SQL, c shell and TSO

Databases included Access, Sybase. Software includes lotus notes, Agile, PVCS, Peril, MS project, Word, and Excel. Hardware tools include Oscilloscopes, frequency analyzers, network snuffers

Duties included;

Programmed and maintained data collection servers.

Created queries and reports to analyze and document test results, track application issues and update reference tables

designing, administering and programming test systems, environments and scenarios

writing and reviewing hardware and software requirements for scope and completeness,

reviewing manufacturing test plans and results for vendors, evaluating first run components,

writing software test plans for other testers,

.

Strategic Staffing Solutions (contract) 1/1999–3/1999

Help Desk Consultant

This included administration, maintenance, performance monitoring, testing, and problem determination of IBM’s host web servers, routers, and communications networks. Responsible for multiple web server performance for IBM’s web hosting service. This included maintenance, performance monitoring, problem determination and verification testing of web servers, routers, and communications networks. Interfaced with customers, system administrators, vendors, service personal and client web administrators to resolve issues. Platforms included AIX, Windows NT and HP UNIX. Databases included Access, Sybase, and SQL Server. Software include lotus notes, Tivoli, C shell, and TSO,

Decision Consultants 5/1998–11/1998

Programmer/Analyst

Programming existing credit card approval system. Platforms included IBM mainframe. AS 400, Novell and Windows NT. Embedded SQL in Cobol Databases included Access, and DB2. Languages used include COBOL, SQL, and JCL

Paradigm Solutions 9/1997–2/1998

Field Engineer

Designed, installed, configured and performed verification testing of imaging systems. Platforms included Novell and Windows NT. Used SQL to diagnose, update databases issues and populate new installations. Databases included Access, and SQL server. Languages used include SQL, and DOS.

Job-related training courses:

Oracle Systems Administrator course St. Petersburg College 6/2002

Education:

Rochester Institute of Technology, Rochester, NY

BS, Computational Mathematics 1996 (Applied Mathematics major with Computer Science Minor)

Contact this candidate