Programmer Analyst / Database Developer

PROGRAMMER ANALYST / CUSTOMER SERVICE SPECIALIST/ DATABASE DEVELOPER

Information Technology Professional with extensive experience in systems analysis and system conversions, program design and testing, team leadership, customer service, and professional development who possesses excellent problem solving and interpersonal, skills, with proven ability to manage all aspects of client relations. Recognized for success in diagnosing problems and collaborating with others to develop positive, cost effective solutions that effective met the needs of the clients. Flexible, proactive and always willing to take on whatever responsibilities are required to complete a project.

PROFESSIONAL EXPERIENCE

RESEARCH DIETS INC, North Brunswick, NJ 2008 - Present

Data Base Consultant

* Converted an Application that used Microsoft Access 2003 as its Front End and Microsoft SQL Server 2005 as its Back End to run using ASP.Net and VB.Net.

* Converted Access Reports to Crystal Reports

* Converted MS Access Forms and VBA Code to ASP.Net Forms and VB.Net Code.

* Converted SQL Queries to run in VB.Net.

* Participated in implementation of the Google Search Appliance.

* Completed Training classes on the implementation and use of the Appliance.

* Created Appliance queries that allowed users to view available documents using their Google Desktop application.

* Converted an Application that used Microsoft Access 2003 as its Front End and Microsoft Access 2003 as its Back End, to an application that used Microsoft Access 2003 as its Front End and Microsoft SQL Server 2005 as its Back End.

* Converted Program code to run on SQL Server using Views, T-SQL Procedures and Pass–Through queries. Streamlined additional code, allowing the system to perform up to 500% faster with less competition for the Database resources.

* Modified Table and Column structures to comply with SQL Server Standards.

* Arranged and supervised QA and Installation of the new system.

KELLY SERVICES, Cranbury, NJ 2007

Temporary Staffing Services

* Member of a team of data entry and event support specialists serving a specialized hiring fair held by Johnson and Johnson in Orlando Florida.

* Arranged initial schedules of applicants and hiring managers to make sure that the desired interviews would be held, taking into account any schedules for travel and meetings that might interfere)

* Fielded requests to change schedules at the hiring event if the circumstances required doing so.

* Assisted with other event management support issues as required.

* Member of a team of customer service specialists in the College Testing Division that assisted Education Professionals and students with issues related to AP Examination and SAT/PSAT Examinations for students with disabilities.

* Fielded requests regarding students requiring special accommodations for taking examinations. Assisted students in registration for examinations once approvals were obtained. Requests often required processing credit card payments.

* Fielded requests from students regarding having student transcripts sent to colleges and universities, and regarding obtaining the results of tests that they had taken. Requests often required processing credit card payments.

* Supported Education Professionals with online exam ordering, administration, reporting, returning, and online support issues.

STANDARD & POORS, NYC, NY 1989 - 2007

Senior Systems Analyst

Provided support for day-to-day and year-end processing for Securities Processing applications, including development, modification, and training support. Provided support for internal operations and help desk personnel external customers, and vendors as well as coordinating system platform conversions for existing applications. Support of applications required knowledge of Oracle 9i Oracle 10g, and PRO-C for VMS, along with Unix C. Knowledge of VMS and Unix Shell Scripting, as well as VMS and Unix Programming tools was also required.

* Worked with the business units as liaison to the Systems and Engineering groups to help to determine the programming requirements for projects

o Design of client and internal user reports and other user defined output.

o Program design for coding changes

o Testing and validation procedures

* Coordinated a team of Systems Analysts that upgraded the Electronic Press Release System

o Upgraded the built in parser to properly identify stories that were being missed, making 40% more stories available to the automated systems.

o Changed transmission of Press Releases to FTP delivery, creating a more secure delivery environment.

* Coordinated a team of Systems Analysts that included external consultants in a project to migrate applications off the Alpha Based VMS System, to a Solaris Based UNIX System

o Electronic Press Release System was converted and put into production.

o Securities Processing and Reporting System was converted and put into production.

o Index Directories Publication System was converted and waiting to be put into production.

o Alpha VMS Systems were no longer used for production with the applications.

* Member of team performing Y2K related modifications to application systems

o Project was completed on schedule and applications ran without issues after January 1, 2000.

* Member of team performing a VAX VMS to Alpha VMS System Conversion

o Project was completed on schedule and applications ran without issues in the new environment.

o VAX VMS Systems were no longer used for production with the applications.

* Led a team upgrading the Stock Market News System

o Automated production of content coming from external and internal data sources, eliminating the need for editorial staff to copy the information.

o Automated the reproduction of content into multiple formats

o Increased speed and efficiency of the production and delivery processes.

o Enabled production of European and Canadian versions of the Stock Market News System.

o Created a database of historical Stock Market News Stories for use by internal personnel.

o Created an End-of-Day Archive Process for the Electronic Distribution System so that the System could be recovered and restored in the event of any unusual issues in production or transmission.

Member of a team of Systems Analysts that created and supported Applications.

* Led a team upgrading the Electronic Distribution System

o Electronic Distribution System allowed for delivery of non text-based products such as Stock Reports, as well as the news.

o Developed detailed documentation, which was provided to new clients of the new service.

o Collaborated with client technical support groups to migrate from using other communications protocols to using TCP/IP.

o Increased speed and efficiency of data delivery and Data Transmission Security built into TCP/IP.

* Electronic Press Release System

o News Wire Service Press Releases, which were previously printed, copied and distributed, were collected and stored in a database.

o The system printed documents to over 40 print devices.

o The system allowed for transmission of the Press Releases to clients.

o The Traffic Cop/Action Editor System was a new system that allowed access to the data stored in the Electronic Press Release Database from user Workstations and eliminated the need to print documents.

* PDP-11 to VAX System Conversion

o Migrated the Stock Market News System from a PDP-11 Based RSTS System, to a VAX Based VMS System.

o Migrated Electronic Distribution of products for over 20 clients from a PDP-11 Based RSTS System, to a VAX Based VMS System, creating faster and more secure delivery of the data.

o Collaborated with programmers, engineers and technicians to get new clients connected and receiving the data

o PDP-11 Systems were no longer used for production

COMPUTER HORIZONS CORPORATION, Parsippany, NJ - Consultant 1988 - 1989

APPLIED SYSTEMS INSTITUTE, Washington, DC - Programmer 1987 - 1988

ITT AVIONICS, Nutley, NJ - Software Engineer 1985 - 1986

DOW JONES & COMPANY, South Brunswick, NJ - Programmer/Analyst 1982 - 1984

BASE TEN SYSTEMS, Hamilton, NJ - Software Engineer 1980 - 1982

EDUCATION

B.A., Mathematics, Newberry College, Newberry, SC

TECHNICAL SKILLS

Conversion of data files (contents and structure)

Writing and updating program/system documentation.

Writing and updating QA acceptance test plans.

ASP.Net Programming using VB.Net.

MS Access and Excel Programming using VBA and Macros.

Microsoft Office Tools including Word, Excel, Access, and PowerPoint.

Microsoft SQL Server, T-SQL, Macro and Procedure writing.

C with Korn Shell Scripts along with awk/nawk scripting for Unix.

Oracle 8i, 9i, and related tools for VMS.

BASIC, C, Pro-C, and job scripting for VMS;

BASIC Plus, BASIC+2, FORTRAN and job scripting for the PDP-11

Contact this candidate