Sql Server Software Engineer

Edward Richard Walsh

*** *** ** **,

Menahga, MN 56464

Cell 585-***-****

*********@*****.***

PROFESSIONAL EXPERIENCE

Roswell Park Cancer Research Institute, New York 12/28/2016 - 05/12/2017 (as a contractor with Tek-System)

SQL Server Developer

Re-developed a 2003 MS Access application to a 2010 application for their clinical research department to track research statics for their projects.

Re-designed the application to improve the efficiency for the users.

Utilant Buffalo, New York 11/02/2016 – 12/23/2016 (as a contractor with Global Quest)

SQL Server Developer

Developed, query tuned, and made modifications to stored procedures in SQL Server 2014.

Developed TSQL using SQL Server 2014.

Developed reports with SSRS 2015 reports for their web reports.

Developed parameters based on C# controls.

Performed version control using Team foundation and Git Extensions.

Developed a package an SSIS 2015.

First Niagara Buffalo, New York 06/06/2016 – 10/14/2016 (as a contractor with Tek-System)

System Analyst:

Helped users with the development of requirements and testing.

Worked with user on the design and development of the application.

Analyzed procedures and processes for opportunities for efficiency improvements.

SQL Server Developer

Designed, and developed process based on business specifications.

Designed, and developed test, use cases, and requirements documentation for the processes.

Used SSIS to import and Export Data.

Developed and made modifications to Stored procedures.

Developed TSQL using SQL Server 2014.

Researched SQL issues using SQL Developer.

M&T Bank Buffalo, New York 07/27/2015 – 4/29/2016 (as a contractor with TXMQ)

System Analyst:

Worked with user on the design and development of their reports.

Worked with the BAs to develop of requirements and testing.

Analyzed procedures and processes for opportunities for efficiency improvements.

BI Software Engineer.

Worked on the BSA/AML (Banking Security/Anti Money Laundering) project. Here I developed SQL

code and reports for the government; to help our clients view security, status, and variance data through the reports.

Developed TSQL using SQL Server 2012.

Devolved Dimensional models for ODSs, the incremental update code, as well as the SSIS for them.

Developed reports using Crystal Reports 10 and SSRS.

Developed process to run and check update procedures using SSIS.

Chapin Batavia, New York 06/25/2015 – 07/24/2015 (as a contractor with Can-Am Consultants)

System Analyst:

Helped users with the development of requirements and testing.

Worked with user on the design and development of their reports.

Analyzed procedures and processes for opportunities for efficiency improvements.

BI Software Engineer.

Extracted SQL code from ASP web pages.

Developed TSQL using SQL Server 2008R2.

Developed new SSRS reports for their intranet reports.

Developed stored procedures using SQL Server 2008R2.

Windstream Fair Port, New York 04/07/2014 – 6/19/2015 (as a contractor with Apex)

System Analyst:

Helped users with the development of requirements and testing.

Worked with user on the design and development of their reports.

Analyzed procedures and processes for opportunities for efficiency improvements.

BI Software Engineer

Designed, and developed test cases for transformations, and reports.

Tracked changes and entered test cases using SpriaTeam.

Used Eclipse for version control.

Developed and made modifications to SSRS reports.

Developed TSQL using SQL Server 2008R2.

Modified Oracle SQL (Using SQL Developer) and reports to meet user request.

Researched SQL issues using SQL Developer and Oracle databases.

Claims Recovery Services Albion, New York 08/05/20113 – 3/3/2014

SQL Server Developer

System Analyst:

Helped users with the development of requirements and testing.

Worked with user on the design and development of their reports.

Analyzed procedures and processes for opportunities for efficiency improvements.

SQL Developer:

Modified SQL Server scripts to increase efficiency and functionality for the users.

Developed Stored Procedures for update processes for external applications in SQL Server 2008.

Monitored performance monitors to identify long running queries.

Developed Tables and their associated indexing in SQL Server 2008.

Updated Stored Procedures to meet demands for new functionality requirements.

Modified SSRS reports and their associated procedures.

Worked with users to develop requirements for their projects.

Redesigned procedures to improve efficiency.

HMS Buffalo, New York 11/26/2012 – 08/02/2013

SQL Developer

Using SQL Server 2008 developed stored procedures for use with their VB.Net programs.

Modified SQL Server scripts to increase efficiency and functionality for the users.

Modified SSIS packages to import data.

Developed Stored Procedures for update processes for external applications in SQL Server 2008.

Wrote procedures to output data to Text, and Excel SQL Server 2008.

Developed Tables and their associated indexing in SQL Server 2008.

Developed CTEs, Cursors, functions and views in SQL Server 2008.

Updated Stored Procedures to meet demands for new functionality requirements.

Ran scripts and procedures to refresh and load client data.

Analyzed data to insure accuracy of the client data loads.

Meritain Buffalo, New York 9//20/2011 – 11/16/2012

Software Engineer (Developer, System Analyst)

System Analyst:

Helped users with the development of requirements and test cases.

Organized and prioritized projects based on user needs.

Documented applications and processes.

Worked with user on the design and development of their applications.

Prepared flow charts and diagrams outlining systems capabilities and processes.

Analyzed applications and processes for opportunities for automation and efficiency improvements.

Developed Functional/Technical Specifications based on user needs.

Software Engineer:

Developed MS Access 2007 applications, queries and reports, for the finance department.

Automated manual process for users saving time and money.

Developed SQL Server 2008 stored procedures to develop reports for users.

Developed user interfaces to allow users to access and input data to the Sage Accpac ERP system.

Made code changes to ERP system macros and their interfaces.

Made ERP configuration changes.

Developed SQL queries using Access to verify, update, and insert data in tables.

Made additions and enhancements to UIs, functions, and procedures of applications.

Alstom Rochester, New York 6//21/2011 – 9/20/2011 (as a contractor with Technisource)

Software Engineer (Developer, System Analyst)

System Analyst:

Helped users with the development of requirements and test cases.

Worked with user on the design and development of their applications.

Prepared flow charts and diagrams outlining systems capabilities and processes.

Analyzed applications and processes for opportunities for automation and efficiency improvements.

Developed Functional/Technical Specifications based on user needs.

Software Engineer:

Developed MS Access applications, based on Excel processes, for the finance department.

Improved efficiency of process by automating manual Excel process and flows. One a process that took them a couple of weeks to do, down to a couple of minutes to run.

Developed SQL queries using Access to verify, update, and insert data in tables.

Made additions and enhancements UIs, functions, and procedures of applications.

Excellus Insurance Inc., Rochester, New York 9/5/06 (as a contractor) and went permanent (2/5/07) – 10/7/2010

Software Engineer (Systems Engineer, System Analyst, Dev-Lead)

Dev Lead:

Managed and identified risk factors of the project.

Worked with Developers and Analysis to insure project needs were met

Assisted in the development of Vision Scope, deployment and development plans.

Assisted project managers in technology consulting, and monitored the progress of such areas as development, testing, defects, and training.

Worked on enterprise level projects to oversee development and documentation of processes.

System Analyst:

Helped users with the development of requirements and test cases.

Worked with user on the design and development of their applications.

Prepared flow charts and diagrams outlining systems capabilities and processes.

Analyzed applications for opportunities for automation and efficiency improvements.

Developed Functional and Technical Specifications based on user needs.

Software Engineer:

Re-developed Ms Access applications apps inVB.net and connected them to SQL Server 2005 to increase efficiency for the users.

Made additions and enhancements UIs, classes, functions, and procedures of applications.

Developed applications using Lotus Note (7.0), using both Lotus script and formula language.

Using Lotus Notes I developed forms, navigators, views, pages, templates, data – dictionaries, and set the users security Access Control level for the applications.

Developed DTS Packages.

Managed version control of application using Microsoft Visual Source Safe.

Managed development and deployment for customer service application that serviced some 1600 users.

Ran Unix processes and scripts to load Oracle staging tables.

SQL Developer:

Using SQL Server 2000, 2005, and 2008 developed stored procedures for use with their VB programs.

Moved MS Access databases to SQL Server 2005 & 2008 to increase efficiency and functionality for the users.

Developed Stored Procedures for update processes for external applications in SQL Server 2005 & 2008.

Wrote procedures to output data to Text, Excel, and Xml in SQL Server 2005 & 2008.

Developed Tables and their associated indexing in SQL Server 2005 & 2008.

Developed Cursors, functions and views in SQL Server 2005 & 2008.

Developed SQL queries using Oracle developer to verify, update, and insert data in staging tables.

Updated Stored Procedures to meet demands for new functionality requirements.

Developed queries in MS Access (97- 2007) applications.

Thomson West Law, Rochester, New York 4/17/06 – 8/31/06

Developer

Acted as System Analyst, gathered and helped users develop requirements for the project, developed story boards, and gave presentations for the application.

Here I made enhancements to both their VB Taxonomy application and SQL Server stored procedures.

Responsible for developing design models for client presentation.

Made additions and enhancements UIs, classes, functions, and procedures.

Added miscellaneous functionality such as text to XML in there VB6 application.

Created an automated Excel report from SQL Server data.

Made enhancements to tree controls, and query controls.

Managed version control of application using Microsoft Visual Source Safe.

HealthNow, Insurance Inc., Buffalo, New York 11/07/05 – 12/29/05

Programmer

Helped user analyze new requirements for design enhancements to the new RTS system

Here I redesigned and coded RTS (Requirements Tracking System) application (an Access App) to connect to SQL Server.

Upgraded the Access RTS system from 97 to 2003.

Redesigned input requirements and increased functionality to application per user specifications.

Made modifications to a VB6 User document application allowing the user to enter the request to the RTS system.

Develop embedded SQL statements to move data to and from the RTS system and associated tables.

Rewrote the Access queries into Stored Procedures for the SQL Server system.

BANK of AMERICA, Amherst, New York 08/03/05 – 10/07/05

Programmer

Developed requirements for the projects

Worked with user in the design development of their projects.

Develop and maintain new databases and applications.

Develop Screen Scraping MSP VB Applications.

Responsible for design and development of new applications to automate existing systems, using VB6/VBA and database systems.

Develop queries with Access Database to check Mers Data against our Data tables.

Develop Access (2000 - 2003) applications with ADO/DAO connections to their databases.

HSBC Depew, New York 10/05/04 – 06/17/05

Consultant

Develop and maintain new and existing databases and applications.

Analyzed and unit-test reports for functionality and accuracy.

Responsible for design and development of new applications to automate existing systems, using VB6/VBA and database systems.

Developed queries with Access Database to develop reports.

Developed Access applications with ADO/DAO connections to their databases.

Worked with excel macros and VBA applications.

Accessed mainframe data using Altell Passport query system.

INGENIX Amherst, New York 07/04/03 – 01/21/04

Technical Support Analyst

Q & A client’s data during implementation of the front end application.

Warehouse maintenance and data analysis.

Preformed monthly (ETL) processes, staging, extraction, and loading, of client’s data.

Using Analysis Services built OLAP cubes/virtual cubes, calculated measures, and drill throughs of warehouse data, through ODBC connections.

Designed and built DTS packages to automate warehouse and analytic processes.

Developed data solutions using SQL Server 2000, PLSQL (for Oracle databases), stored procedures, and VB on a Windows 2000 platform.

Wrote documentation of client’s processes that we developed in implementation.

METRO COMMUNITY NEWS Buffalo, New York 01/02 – 02/12/03

Database Developer

Operation Committee member, contributing to technical decisions for the organization.

Responsible for all areas of Database administration (maintaining, updating and tuning existing databases). Develop and maintain database projects.

Responsible for analyzing current database systems to find ways to improve the systems.

Designed and develop user-friendly forms for user input (using both the VB6 model using ADO, and on the Access forms). Design reports, using MS Access and Crystal Reports (Business Objects).

Converted Access databases from 97 to 2000 and SQL Server 2000 database formats.

Ran tuning tools such as DBCCCONTIG, used profile for work load traces, Index Tuning utility, and Graphical Showplan to determine cost and join types being used.

Converted Access applications to VB apps and rewrote their queries to stored procedures.

Responsible for running, setting, and recovering of data backups throughout the organization using Veritas' Backup Exec and SQL Server tools.

STATE UNIVERSITY COLLEGE AT BUFFALO, New York 10/99 – 12/01

Database Systems Specialist / Tutor

Designed and develop databases (using MS Access 97 & 2000) for the various departments.

Designed queries to generate reports using MS Access and SQL.

Wrote Visual Basic applications to interface with Access database systems.

EDUCATION

BUFFALO STATE COLLEGE, Buffalo, NY

B.S, Computer Information Systems

Three-time recipient of the National Science Foundation CSEM Scholarship

ERIE COMMUNITY COLLEGE, Williamsville, New York

A.S., Computer Science, 6/00

SKILLS AND TECHNOLOGIES

DEVELOPMENT

Programming Languages

oAssembly

oJava

oC#

oVB.NET

Web Development

oHTML

oASP.NET

Database

oPL/SQL Oracle 11g

oSQL Server 2008R2/ 12

oIBM DB2

oMicrosoft Access

oSSIS

oInformatica ETL

Reporting

oMicrosoft SQL Server Reporting Services

oMicrosoft Access

oCrystal Reports

TOOLS

Development Tools

oEclipse

oMicrosoft Visual Studio

oToad

oOracle SQL Developer

oInformatica PowerCenter 9.5

Source Control

oEclipse CVS

oMicrosoft Visual Source Safe

Change Management & Issue Tracking

oInflectra SpiraTeam

oHP Quality Center

oJIRA

oRemedy IT Service Management

OTHER SKILLS

IT Skills

oAdvanced Systems Analysis

oData Communication and Networks

oUNIX

Other Training

oSun Microsystems Java Programming

oMicrosoft Certified Solutions Developer classes

oMicrosoft Solutions Framework

oIBM Lotus Notes Development

Contact this candidate