Sql Server Software Engineer
Resume:
Camp Hill, PA *****
***.*******@*****.***
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