TECHNICAL SKILLS:

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

PROFESSIONAL EXPERIENCE:

Confidential, Harrisburg, PA

Business Systems Analyst

Responsibilities:

• 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

Confidential, Etters, PA

Software Engineer II

Responsibilities:

• 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

Confidential, Camp Hill, PA

Software Engineer

Responsibilities:

• Contract with Confidential, 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

Confidential, Harrisburg, PA

Sr. Developer

Responsibilities:

• 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

Confidential, Harrisburg, PA

Programmer Analyst III

Responsibilities:

• 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

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• 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

Confidential, Camp Hill, PA

Senior Programmer

Responsibilities:

• 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