Sr. Programmer Analyst Resume Example Johns Hopkins University

SR. PROGRAMMER ANALYST

Summary

Full life-cycle software developer with over 17 years of experience developing and supporting large-scale software applications and implementing vendor-provided solutions. Over 9 years of experience with student information systems; thorough knowledge of JHU IT tools, policies and procedures. Extensive experience in database and reports development. Excellent analytical and communication skills. Recognized for ability to provide quality technical solutions based on business objectives.

Highlights

Microsoft Visual Studio 6/2003/2005/2008/2010, Visual Basic 4/5/6/.NET, C#, Visual FoxPro 6/7,

ASP.NET, XML, HTML, SQL Server 7/2000/2005/2008/2012, SQL Server Reporting Services; Seagate Crystal Reports 4.6/7/8.5/9/10/2008, T -SQL;

TortoiseSubversion/SVN, Confluence; JIRA, ServiceDesk; InstallShield, Wise, TestTrack Pro, TeamTrack 7.0, Heat, Visual Source Safe, Microsoft Project, Visio 2000, MS Office

Experience

Sr. Programmer Analyst
November 2005 to CurrentJohns Hopkins University － Baltimore, MD

Heavily involved in systems analysis, programming and frequent and detailed dialogues with functional users, in initiatives associated with Peabody's implementation of the Integrated Student Information System (ISIS) and related systems.
Provide technical solutions to address the business needs of the Peabody Admissions, Registrar, Business, Student Affairs offices and Preparatory.
Provide support by troubleshooting and resolving problems with ISIS, ISIS for Students and Faculty ASTRA as well as ISIS interfaces to iHopkins, Pyramed and others.
Duties are highly diversified and require independent decision-making and multitasking.
Participates in research and fact-finding to develop (program/code), maintain, test or modify new or existing solutions; performs unit, system and integrated testing.
Utilizes expert SQL skills to create different SQL objects ("rules", SQL tables, views, and stored procedures, UDFs) to support and enhance ISIS functionality.
Enabled and supports custom functionalities in form of Web Inquiry, Prospect Students Entry (replaced with Online Registration) and Audition Scheduling and Rating screens for Admissions using ASP.NET to interface with SQL Server objects.
Performs support, develops and implements enhancement releases of Peabody Online Registration application.
Application is written in C# with SQL Server as a back-end.
Participated in all phases of ISIS implementation for Peabody non-degree division, Preparatory.
Was sole performer of data migration from old Prelude system to ISIS database utilizing Generic Import functionality.
Developed multiple Crystal reports and completed conversion to SRS reports.
Creates new, modifies existing SRS reports as well as provides ad-hock reporting upon users' request.
Provides guidance and training to less-experienced junior staff and functional users.

Intermediate Programmer
February 2003 to November 2005Educate, Inc － Baltimore, MD

As a member of Sylvan Technology Team participated in development, enhancements and support of multiple in-house software projects.
Performed requirements analysis, systems design, extensive programming, implementation and support for SUMS (Sylvan Unified Management System) project as a member of Sylvan Technology Team.
SUMS is a Visual FoxPro 7/ SQL Server 2000 application for scheduling, automated billing, reporting, and Labor Management in Corporate Sylvan Learning Centers across the USA and Canada.
Developed multiple applications to accommodate business needs.
Accomplishments: Created 4 SUMS functional areas as complex VB ActiveX Controls imbedded into FoxPro forms.
Led team effort for Sylvan Online project.
Created Project plan and FS; developed code utilizing VB, VFP and T-SQL.
Project has passed UAT with 100% satisfaction.
Participated in SUMS maintenance releases: VB, VFP and SQL coding, Crystal/VFP Reports.
Tested and reviewed peer programmers code.
Provided Level 3 Production support to Help Desk with record result of 50 resolved issues per day.
Participated in 3rd Party Call Center and SymSync Projects development.
Designed/coded applications to transfer data from FTP site; to extract data from FoxPro free tables into SQL Server database.
Created Installation Packages for SUMS US and SUMS Canada using InstallShield.
Worked with Corporate Accounting on Monthly End Close process involving heavy data analysis.

Systems Programmer
July 1999 to February 2003TransCore, Inc － Harrisburg, PA

Worked as a member of the Toll Host project software development team, a major part of a multiphase development effort of Automated Fare Collection System for Pennsylvania Turnpike Commission (PTC).
Toll Host is a large-scale client-server application (Visual Basic 6, MS SQL 7.0, Crystal Reports 8, ODBC, FTP).
Accomplishments: Participated in requirement gathering and analysis, systems design meetings and writing Detailed Design Document.
Designed, developed, implemented, supported and documented multiple client-server applications.
Was recognized for development of E-Z Pass Reporting System providing 30 Crystal reports with User Interface in VB and SQL stored procedures as data sources.
SQL Server Administrator responsibilities: server maintenance, job definition, scheduling, database backup and recovery plans, DB restoration.
Performed software packaging, installations and verification.

Education

SQL Server 2000 Administration Learning Tree International, Inc., Reston, VA Windows NT Administration Computer Learning Network, Harrisburg, PA Visual Basic 6.0; ADO Computer Learning Network : Computer Science, 2000Learning Tree International, Inc SIT Group, Inc Kiev State University － Reston Harrisburg Baltimore Kiev, VA PA MD, UkraineCrystal Reports 2008 Intellisource, Columbia, MD ASP.NET Programming Learning Tree International, Inc., Baltimore SQL Server 2005 Reporting Services Learning Tree International, Inc., Baltimore T-SQL for SQL Server VB4, Crystal Reports 4.6, SQL Server 6.5, MS Access, Oracle Computer Science 60 credits

M.S : LinguisticsKiev State University － Kiev, UkraineLinguistics

Skills

.NET, ASP.NET, Accounting, ActiveX, ADO, ad, backup, billing, Call Center, client-server, conversion, Crystal, Seagate Crystal Reports 4.6, Crystal Reports 8, Crystal Reports 4.6, Crystal Reports, data analysis, data migration, database, decision-making, forms, FoxPro, FTP, functional, Help Desk, HTML, InstallShield, ISIS, meetings, MS Access, C#, MS Office, Microsoft Project, MS SQL 7.0, SQL Server 6.5, Visual Basic 4/5, multitasking, Network, ODBC, Oracle, DB, packaging, coding, Programming, reporting, requirement, requirements analysis, research, Scheduling, software development, Visual Source Safe, SQL Server, SQL, SQL Server 2000, SQL Server 7/2000, systems design, systems analysis, tables, T -SQL, T-SQL, troubleshooting, User Interface, Visio 2000, VB, VB4, Visual Basic 6.0, Visual Basic 6, Visual FoxPro 6, Visual FoxPro 7, Microsoft Visual Studio 6, Windows NT Administration, Wise, written, XML

Resume Overview

Companies Worked For:

Johns Hopkins University
Educate, Inc
TransCore, Inc

School Attended

Learning Tree International, Inc SIT Group, Inc Kiev State University
Kiev State University

Job Titles Held:

Sr. Programmer Analyst
Intermediate Programmer
Systems Programmer

Degrees

SQL Server 2000 Administration Learning Tree International, Inc., Reston, VA Windows NT Administration Computer Learning Network, Harrisburg, PA Visual Basic 6.0; ADO Computer Learning Network : Computer Science , 2000
M.S : Linguistics

Sr. Programmer Analyst Resume Example

Resume Score: 100%

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes