Career Overview

I am a software developer and a database developer with over twenty five years' experience as a software / programming and database professional, working with a variety of applications and packages in the Insurance, Financial and Aerospace and Hospital Human Resource Industries. Having the ability to prioritize and meet operational deadlines in a demanding environment with strong communication, organizational, technical and problem solving skills.

Qualifications:

Visual Source Safe, MS-DOS, Oracle 8i - Oracle 9i, Gupta, SQL Server developer, Microsoft Fax Software, Toad, Microsoft Mail Service Pack 6A, Oracle Enterprise Manager, Norton Utilities, PL SQL Developer 6.05, Lotus Notes, Power Builder 9.0 11, Focus, Office 97 - 2010 Products, Visio 5.0, Windows 3.1 Windows 8.1, Quest, Visual Basic 3.0 - V.B 6.0, SQL Wintalk, Windows NT 4.0, Quick Basic, VISIO Professional 2000, COBOL, ALC,C, Fortran, Microsoft C , Centura SQL, Smart Draw version 6.11, Data Junction, Micrografix Flow Charter 7, SQL Talk, Erwin, Microsoft Project 97, SAS, PC-DOS, OS/2, Perl, Sybase, Embarcadero, Novell Group wise, Smart Stream 7.0 8.0, Rapid SQL, One Shield dragon, Quest Software SQL Navigator, Oracle 10g, Citrix, VPN Client Cisco Systems, People Soft.

Technical Skills:

• Skills Experience Total Years Last Used
• SQL 2008 Expert 20 2013
• Oracle 11 Expert 5 2006
• Microsoft Excel 2010 Expert 25 2013
• Microsoft Word 2010 Expert 25 2013
• Microsoft Access 2010 Expert 25 2013
• C Intermediate 5 1997
• Visual Basic 6.0 Intermediate 5 2002
• .Net Intermediate 1 2005
• Perl Intermediate 1 2013
• Sybase Intermediate 2 2014
• Rapid SQL Expert 2 2014
• Embarcadero Intermediate 2 2014
• People Soft Intermediate 2 2014

Accomplishments:

• Completed 2 courses in PeopleSoft for the PeopleSoft tools and PeopleSoft query system.
• Created queries in the PeopleSoft query application to check payroll information.
• Re-started the legacy system and replenishments jobs at night when the legacy system stalled.
• Application Design
• Used One Shield Dragon to create new applications for a project I was assigned to.
• Finished the One Shield Project in the appropriate time that was allotted for the project
• Used object-oriented design/programming to design new stand-alone application.
• Created and changed Access databases for Hartford Hospital.
• Quality Assurance
• Streamlined QA process to increase efficiency and reduce new product roll out time by one week.
• Network Security
• Updated network systems to support confidential company operations and eliminate hacking.
• Programming
• Increased revenues by 12 by developing codes for accounting tasks including cost estimation and revenue generation.
• Analysis and Development
• Resolved core issues through the redesign of the broker data model, data house -holding processes and daily round-trip database synchronization.
• Set new standards for virtually 100 code coverage, while piloting Oracle Designer.
• Resolved issues with the legacy system when the system and jobs stalled.
• Product Development
• Worked on scalability and optimization of production environment.

Work Experience:

Confidential

Database Developer

• Converted and Human resources Access databases from 2000 2003 to 2010.
• Created a new Access database using the Sybase 8.0 system for human resources.
• Converted Purchasing's Access 2000-2003 databases to 2010.
• Create stored procedures to run the Perl programs that capture data.
• Created Perl programs to capture data and send them to the clients through an FTP System.
• Used Smart Stream 7.0 - 8.0 to connect to the Oracle database to capture data and create reports in Access 2010.
• Used Rapid SQL 7.6.4 to create other stored procedures to capture data and send to the Access programs.
• Testing the new PeopleSoft Web application to make sure accruals and payroll data is calculating the correct information. When doing this I found that there were problems in the calculations and reported the problem.
• Creating queries using the new PeopleSoft query manager to test inputted data from the developers. This is to make sure that the data for the payroll system is pulling information correctly.
• Checking the legacy system to make sure the manufacture reports are running from the stored procedures and smart stream correctly. When the reports do not run, the system needs to be restarted I restart the polls that the stored procedures run from.
• Helped with the new product help desk. Helping customers with their login problems and navigation problems.

Confidential

Database Developer for Allied World

• Developed in One Shield Dragon a few applications for a new project. I finished the project before I left with minimal help and used my experience in SQL and in application development to master One Shield Dragon.
• Using SQL Navigator 5.5 created stored procedures to fill data into the applications as a back end.

Confidential

Database Developer

• Developing an Access 2007 database that houses Blue Cross Blue Shield of Massachusetts data from their mainframe.
• This database creates Blids which is then sent up to Benefact, the data is placed in the proper fields in the Benefact system.
• Created Modules and procedures to create the BLID output.
• Completed courses from NASCO on Testing and Certification NLC classes which are mainframe classes using COBOL and ALC.
• Completed a course for benefact training.
• Working with ALC/COBOL to dump and check flags on the mainframe system.

Confidential

Database Developer

• Developing stored procedures, triggers, new tables and SSIS packages to automatically store data for the reporting system.
• Maintaining and developing sql stored procedures for financial reports.
• Creating PowerBuilder interfaces for the customer to run and print out reports using Excel.
• Developing PowerBuilder interfaces for Claims, Marketing, Finance and risk, this was to help the customer store their information in the cloud and reporting systems.

Confidential

Database Developer

• Developing stored procedures, new tables, triggers Using SQL Server 2005 and 2008.
• Creating new tools and new technology to help the database process for achieving quality and ease of use of the application.

Confidential

Applications Developer

• Developing Access applications using VBA code to automate the client applications.
• Creating database schema using Rational Rose software.
• Single-handedly developed process to improve work flow and communication between in-house departments.

Confidential

Application Developer for the Department of Health State of Connecticut

• Having only a month to improve their system, I created automated adhoc reports and Access application database.
• Using Toad and Enterprise management, fixing Oracle views, triggers and stored procedures to have the application run more efficiently

Confidential

Database Developer

• Developed and implemented in-house source organization system, increasing efficiency by 10 .
• Fixed applications for the efficiency
• Used a wide variety of techniques and tools in the development and unit testing of software applications, including: object oriented programming languages and software tools, analysis and design techniques, data base management systems, middleware and data access and retrieval programs.

Confidential

Application Developers for One Beacon Professional Partners

• Developed submission, and claims databases to store medical information.
• Developed VB and VBA bound and unbound controls in the application using grids, combo, drop down and text boxes.
• Automated importing and exporting information between Access forms and Excel back to the Access application after data was massaged to store new information for reporting.
• Created hyperlinks to open and display reports in a web like environment.
• Created security in the application using .Net

Confidential

Application Developer

• Used a wide variety of techniques and tools in the development and unit testing of software applications, including: object oriented programming languages and software tools, analysis and design techniques, data base management systems, middleware and data access and retrieval programs.
• Developed Oracle stored procedures, triggers and views linking information from the Oracle database to the Access application.
• Developed a vendor share Access application worked with clients to analyze computing and network needs and installed appropriate solutions within each organization's budget.
• Provided daily support to ensure company staff had necessary tools to perform tasks efficiently.

Confidential

Applications Developer

• Repaired and maintained the financial database that was not calculating and reporting correct monies.
• Created new reports using new deigns and new technology using Access.

Confidential

Application Developer

• Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
• Prepared technical architecture proposals for enhancements and integration of existing third party software systems with SAP.
• Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.
• Led architectural design effort to migrate existing MS SQL OLTP dependent reporting environment to enterprise-class BI platform Business Objects XI 3.0 .
• Streamlined and enhanced the corporate accounting and operations system.

Confidential

Applications Developer

• Developed a Time Tracking application to store and retrieve information from SQL Server. Developing VB Bound and Unbound controls in the Time Tracking Program using grids, data combo boxes, drop down boxes, text boxes and Masked Edit Boxes .
• Using SQL 7.0 to connect to a Database to store and retrieve information to fill the Maintenance and Time Tracking System Programs through VB 6.0.
• Fixed and Enhanced the Access 97 STAT system

Confidential

Applications Developer

• Developed and designed a Maintenance application to store and retrieve
• Information from SQL server. Developed VB Bound and Unbound controls in the Maintenance Program using grids, data combo boxes, drop down boxes and text boxes.
• Using SQL 7.0 to connect to a Database to store and retrieve information to fill the Maintenance and Client Management System Programs.
• Client Management System CMS Enhanced and fixed the CMS system.
• Fixed Sheridan controls and problems within the Client Management System.
• Developed and designed reports in VB 6.0 within the Client Management System. Developed and designed reports using Seagate Crystal Reporting tool Version 7 for Client Management and Requisitions Systems.
• Wrote Views in SQL Server 7.0 to design reports for the Seagate Crystal reports using the Views for stand-alone / detached reports.
• Used VB 6.0 to automate the reports from the users' machine.