**** ******** **

Camp Hill, PA *****

ac3mqr@r.postjobfree.com

717-***-****

Guy Tanguay

Environments

Database: Microsoft SQL Server 2012/2008/2005/2000/7, SSIS, SSRS, SSAS, Oracle 11g/10g/9i, HANA, IDT, BODS, Microsoft Access 2002/2000/97/2.0 and Pivotal

Languages: T-SQL, ASP .Net, Visual Basic .Net, JAVA, Visual Basic 6, MDX, VBA, Pick Basic, UNIDATA, UNIBASIC and Prime

Operating Systems: Windows 95/982000/XP, Windows NT, UNIX and Pick Open Architecture 2.0

Other: Tableau, SAP HANA Studio, Information Design Tool 4.2, BODS 14.2, Microsoft Project Online, Microsoft Office 2016, ITIL, Qlikview, Toad, Crystal Reports 11/10/8, Business Objects, MS Visual Source Safe, Infragistics, CA ERWin, SharePoint

Experience

TE Connectivity, Harrisburg, PA

Business Systems Analyst, IT, July 2007 - Present

Develop and maintain analytical views within SQL and HANA Design Studio

Develop and maintain Tableau and Qlikview Analytical views

Develop and maintain reports within SSRS

Develop and maintain Oracle tables, procedures, views and packages

Develop and maintain ETL jobs within SSIS and BODS

Write SQL Server views and stored procedures for data request, which are needed throughout the system

Develop and maintain Visual Basic .NET applications with back-end database of MS SQL Server

Develop and maintain JAVA applications for the Tax Portal with back-end database of Oracle 10g

Write Business Objects reports viewed by the Tax Department within InfoView

Rite Aid Corp, Etters, PA

Software Engineer II, IT, October 2006 – July 2007

Develop new Multi Dimensional Database (Cube) thru SQL 2005 Analysis Services

Convert SQL 2000 cubes to SQL 2005

Develop new and maintain existing SQL 2005 Integrated Services packages

Convert ASP.Net applications from 1.0 Framework to 2.0

Develop and maintain MDX queries

Peak Solutions, Camp Hill, PA

Software Engineer, IT, March 2005 – October 2006

Contract with Transcore, Inc, Harrisburg, PA

Introduce, develop and maintain DTS Packages for MS SQL Server 2000/2005

Development and implementation of VB, VB.NET and MS SQL Server database enhancements for extension of the data structures and to improve overall system performance

Write SQL Server views and stored procedures for complex data request, which are needed throughout the system

Develop and maintain Visual Basic 6 applications with back-end databases of MS SQL Server

Develop new Visual Basic .NET applications with back-end database of MS SQL Server

Develop new and maintain end-user reports written in Crystal 8, 10 and 11

Establish and maintain link-servers

BenefitVision, Inc., Harrisburg, PA

Sr. Developer, IT, August 2004 – March 2005

Served as technical lead for project team

Developed application development and database design standards for the project

Oversee the development and implementation of all VB and MS SQL Server enhancements

Write SQL Server views and stored procedures for complex data request, which are needed throughout the system

Develop and maintain Visual Basic 6 and .NET applications with back-end databases of SQL

Develop and maintain DTS Packages and Replication

Maintain and monitor production databases for quality and performance including imports/exports, quality monitoring and database optimization

Assisted with project management activities

Keystone Health Plan Central, Harrisburg, PA

Programmer Analyst III, MIS, 2001 - 2004

Technical lead on several projects

Write SQL Server views and stored procedures for complex data request, which are needed throughout the system

Develop and maintain Visual Basic 6 applications with back-end databases of SQL and Microsoft Access

Develop and maintain various reports using Crystal Reports

Customize 3rd Party software Pivotal using Agents, Queries and Forms

Develop and maintain databases within Microsoft Access

Maintain production databases including monthly EDI imports/exports and quality monitoring

Supervisor Provider Data Systems, Provider Relations, 1998 - 2001

Designed and developed time entry and tracking system for Provider Relations staff within Microsoft Access and VBA

Coordinated the updates of all computer systems which utilize provider information

Coordinated the development of new and modified physician network programs, and the resolution of related problems which included documentation and training of pertinent staff

Oversaw the activities of 5 subordinates – 3 Report Analysts, Data Entry Specialist and Information Specialist

Special Program Coordinator, 1996 - 1998

Designed and developed time entry and tracking system for Provider Relations staff within Microsoft Access and VBA

Coordinated the analysis, testing and implementation of Provider Relations Online Database developed within Microsoft Access and VBA

Coordinated the update of all computer systems which utilize provider information

Coordinated the development of new and modified physician network programs, and the resolution of related problems which includes documentation and training of pertinent staff

KHP Services, Camp Hill, PA

Senior Programmer, 1993 – 1996

Developed applications within Pick Open Architecture Operating System Version 2.0, FORGE screen generator: Claims reporting; Authorization and Encounter Entry, Update and Query; Generic Archive and Purge; conversion processes, File Transfers in and out

Trained staff on system tools and user applications

Performed up-front analysis of system modifications

Developed technical specifications used by programming staff and management

Worked with customer department to define business needs, and maintained direct contact with users through each phase of System Development Life Cycle

United States Swimming Coach, 1990 – current

EPAC, Harrisburg, PA 2014 - Present

West Shore YMCA, Camp Hill, PA, 2000 – 2014

Mechanicsburg Swim Club, Mechanicsburg, PA, 1995 – 99

Central Pennsylvania Aquatic Club, Harrisburg, PA, 1995 – 96

Education / Training

1987 –1992 B.A., Computer Science, Rhode Island College, Providence, RI

1994: Advanced Microsoft Access Programming, Highmark Inc

2001: Introduction to VB Programming, Highmark Inc

2001: Pivotal Fundamentals, Pivotal Inc

2002: VB Fundamentals, Productivity Point

2002: 7 Internet VB courses, Mind Leaders

2006: Oracle 9i Database Administration Fundamentals

2010: Qlikview Developer and Designer

2011: Advanced SQL for Oracle 10g

Contact this candidate