SUMMARY:

• Senior Programmer/Analyst and project leader with a strong background in Windows application development in software development lifecycle environment using MS SQL Server, SSMS, SSRS,SSIS, Oracle, MS Access
• Transact - SQL, Stored Procedures, Triggers, Views, Visual Basic, VBA, C#, C, C++, Reports, Unix, MQ. Analytical and creative, developed applications on time with excellent quality for logistics, insurance, financial, Sarbanes-Oxley, aerospace, retail, healthcare and non-profit.
• Works well in team or as an individual contributor.

TECHNICAL SKILLS

Databases: Oracle, PL/SQL, MS SQL Server, Sybase, Stored Procedures, Triggers, SSIS, SSRS, Pivot and Crosstab Queries, Informix, MS Access 2010, 2007, 2003, 2000, 97, DB2, CICS Client, Data Mapping, SQL Anywhere, ODBC, RDO, ADO, DAO, Rapid SQL

Architecture: 2 - Tier and 3-Tier Applications

Languages: Transact-SQL, VBA, Net, C#, Visual Basic, C, C++, Visual C++, Unix Shell, Realia COBOL, MicroFocus COBOL, PC Assembler, Pascal

Tools: Visual Studio, Eclipse, Crystal Reports 10, MS-Office, MS-Project, MS-PowerPoint, Visio, Outlook, MFC, Visual SourceSafe, PVCS, Version Control SVN, Installshield, FarPoint Upsizing Wizards, Mercury Quality Center (Test Director), Turbo Pascal

Misc: Excel, Excel Macros, Pivot Tables, Vlookup, ActiveX, MQ, COM, CICS Client, SourceSafe, Software Configuration Management, Documentation, Metrics, UML, Use Case, Entity Relationship Diagrams, MARC Record Processing, DOS Batch Files

O/S, Network: Windows 3.1/95/98/NT/2000/XP/Vista/7, Unix, MS-DOS, OS/2

PROFESSIONAL EXPERIENCE

Confidential, Stratford, CT

Programmer/Analyst

Responsibilities:

• SSRS Reports created, developed and published that uses data warehouse SAP data.
• In depth sales reports created with SSRS to support spare parts division.
• Created and altered stored procedures using Transact-SQL, SSMS, MS SQL Server 2012.
• Responsible for multiple SQL Server databases.
• MS SQL Server queries created for ad-hoc reports to aid in transition from legacy MRP system to SAP.
• Modified MS SQL Server and Access databases used to produce IMS quality checks and scorecard reports.
• Created graphical reports based on Excel pivot tables.

Confidential, Wallingford, CT

Programmer/Analyst

Responsibilities:

• Designed and created report for clients to use that calculated premium increases.
• Report output written programmatically to an Excel spreadsheet for each client viewable via the web.
• Worked closely with business analysts to work out design solutions.
• Worked on production support problems, identified problems and determined fixes.

Confidential, Stratford, CT

Programmer/Analyst

Responsibilities:

• Responsible for the design, programming, and reports of SQL Server 2008 databases used to track program management processes for the new Marine heavy-lift and new Presidential helicopter. Two-tier design using Access as front-end the SQL Server the back-end.
• Multiple MS SQL Server 2008 databases
• VBA programming used in Access databases.
• SSMS used for stored-procedures, views created and altered.
• Transact-SQL programming.
• Reports created and modified using Access, Excel with macros.
• Specialized weekly project management reports produced for the Defense Department.

Confidential, Wallingford, CT

Programmer/Analyst

Responsibilities:

• Tables designed for materials, inventory, purchasing, sales orders, and bill-of-materials.
• Forms designed for materials management, purchasing, sales order entry, product creation processing.
• Bill-of-materials creation and editing.
• VBA coding for reading and writing to tables. Parameterized queries used for optimization.
• Finished products interactive form and VBA code to maximize created substances to finished products.

Confidential, Naugatuck, CT

Programmer/Analyst

Responsibilities:

• Redesign of MS Access based commission system into an Oracle database system. Produced functional requirement specification. Held workshop meetings to cover gap analysis, data mapping and enhancements. Initiated Phase II of the project to recode macros and SQL queries into stored-procedures in an Oracle database.
• Re-design of MS Access based commission system to an Oracle based system.
• Analysis of current and projected needs and produced a functional requirements document.
• Analysis of existing commission system and produced business requirements document.
• Project plan created and presentenced to business owner.
• Conversion and enhancement of MS Access SQL to Oracle PL/SQL and stored-procedures.
• Normalized data field names.
• Created and programmed multiple Excel spreadsheets using VBA and Macros for reports Data connections made to Oracle Database.
• Used version control SVN to manage changes.
• Add enhancement to the system to increase productivity.
• Travel to company offices for project meetings in Canada and Jersey City.

Confidential, New Haven, CT

Programmer/Analyst

Responsibilities:

• Performed analysis and programming for implementation of a vendor web based solution to work with SQL Server 2008 data warehouse.
• SSIS data transformation planning and development to work with XML from vendor web based solution.
• Data conversation and cleanup of legacy data using Access 2007, ADO, XML and VBA.
• Production support for Access queries and forms.
• Exception reports created in Excel.

Confidential, Woodbridge, CT

Programmer/Analyst

Responsibilities:

• Responsible for enhancements to the application that validates and transfers of XML and image files. Front end uses VB and the backend is in Access 2003. Performed and tested several databases of Access 97 upgraded to 2003 for two-tier systems.
• Major enhancements to the XML and image processing application.
• Developed MARC application for record processing.
• Upgraded and tested Access 97 to 2003 in a two-tier system.

Confidential, New Haven, CT

Programmer/Analyst

Responsibilities:

• Major enhancements for the Engineering Grants database. Database tracks projects, funding and uses metrics for reporting purposes.
• Added security to Access databases and provided installation on client’s servers.
• Developed view-only database for use by help desk.
• Developed, enhanced and optimized SQL Server Stored Procedures.
• Transact-SQL enhancements to HR database.

Confidential, Norwalk, CT

Programmer/Analyst

Responsibilities:

• SAP extracts imported into Access 2000 for transformation and data conversion.
• Data mapping of inventory from North American to UK SAP Instance.
• Data object transformation and data conversion performed with Access 2000 using SQL queries, VBA and Excel. Utilized VLookup function for data conversion. Worked with business analysts to develop data conversion rules.
• VBA coding for data exchange between Excel and Access.
• Worked with business users for data pre-load verification of Excel spreadsheet data.
• Access, Excel, and extensive VBA coding used as main project tools.
• Defects tracked and corrected with Mercury Quality Center (Test Director).

Confidential, New Haven, CT

Programmer/Analyst

Responsibilities:

• Responsible for upsizing an Access 2003 application used by the drama school to SQL Server 2005. Project Plan created in MS Project Plan. Multiple tables upsized and Access forms and reports re-worked to work with SQL Server.
• Enhancements included new stored procedures and triggers added to SQL Server. Access application used by Yale Medical School modified and upgraded. SQL views, Transact-SQL (TSQL), stored procedures and triggers developed. Performed data conversion to clean up obsolete tables and data fields.

Confidential, New Haven, CT

Programmer/Analyst

Responsibilities:

• Responsible for the software system used by the client to track and maintain status on 300 foster children and their foster families for internal reporting and governmental compliance. Major program enhancements and re-write of the organization’s administrative software system which is a two tier application that used Access 2003 and SQL Server 2005. Responsible for re-writing Access based Data Quality Tool into Transact SQL (TSQL). Made program enhancements using VBA and resolved production support issues.
• Re-wrote Data Quality Tool as a scheduled SQL Server job that uses stored procedures and functions written in Transact SQL. Data Quality Tool is a metrics based systems used to track key performance indicators to enable caseworkers to maintain their cases within critical success factors
• New features and enhancements to Access forms and underlying VBA code to accommodate business requirements
• Created Pivot Queries for reporting purposes.
• SQL Server Store Procedures optimized for performance.
• Created and modified Crystal Reports using version 10.
• Communication between business users and other IT staff in order to implement changes.

Confidential, Hartford, CT

Programmer/Analyst

Responsibilities:

• Utilized SDLC for a major upgrade to Pension/401(k) software system installed on over 200 platforms. Designed and added security to a field agent’s enrollment application installed on agent’s personal laptop computers for SOX compliance. Security re-design of an in-house benefit enrollments system. Extensive work with 3-tier application using C++, ActiveX DLL, VB 6, Sybase, FTP, 2-tier application uses VB 6, Sybase, MQ, and Crystal Reports. Enhancements to multiple stored procedures.
• Security layers designed and added to field agent’s benefits enrollment application. Data modeling for new tables and SQL added to SQL Anywhere database. Security enhancements made to VB code. Encryption routines added and password reset capability from home office added. Application made Sarbanes Oxley compliant.
• Analysis and design for in-house benefit enrollments to bring it in compliance with SOX rules. VB application and DLL changes.
• Transformed high-level business specifications into project technical document, test-plan. Created plans for testing, installation and rollback. Coordinated installation with DBA and was onsite for the full day rollout process for the Defined Contribution application/
• Analysis and design for major product upgrade to Defined Contribution application software installed on over 200 platforms. Worked with and directed junior business analysts. Major 2-tier VB application, Sybase enhancements and Crystal Reports developed. Data Mapping of Sybase to Mainframe. MQ used for communications. Technical project document created along with install and roll-back plan. Visually SourceSafe used for SCM.
• Major enhancements to 3-tier application with an ActiveX DLL developed in C++, GUI developed in VB6 and Sybase backend.
• Modifications to store procedures to handle new financial products.
• Created and modified Crystal Reports using version 10.
• Data modeling of server database tables to handle new products and features.

Confidential, Wallingford, CT

Programmer/Analyst

Responsibilities:

• Analysis, design and development of internal business software.
• Designed, developed, and implemented automated clearinghouse payment information system that identifies and reports rejected payments. Saved the company $3,000 a month in bank fees. Application written in C# and data modeling of new Informix tables.
• Designed, developed, and implemented an automated process to close banking adjustment tickets, used VB 6 and Informix. Freed up 15% of adjusters man-hours per week.
• Designed, developed and implemented an Access based agent activity sales report.
• Unix Shell programming.
• Changed programs as needed to comply with Sarbanes Oxley (SOX)
• Interfaced with Software Control Board for software fixes and upgrades.
• Achieve maximum efficiency of resolution of production support issues through triage.
• Performed system modifications for monthly calculation and issuance of agent commission checks with a total value of more than $1,000,000. Application uses SQL Server 2000, Unix Shell, Informix and MS Access 2000.
• Identified missing company assets, corrected the company assets database.

Confidential, New Milford, CT

Programmer/Analyst

Responsibilities:

• Software development consulting agency. Used VB6, Access 2000, and Excel for development. Developed systems for capturing of metrics to be used to track against client’s critical success factors.
• Design and develop application software.
• Analysis and development for a project defect system for a major software firm. Developed specifications from client contact, writing a technical design document based on the specifications. Performed data modeling, prototyping, metric algorithms, created final work product Reports captured metrics of defects and how and length of time for fixes. Performed unit and system testing and client acceptance.
• Project measurement database created to capture project management data for statistical process control. Database captures design, code, and manpower metrics for use in statistical project control. Tasks including developing specifications from client contact, data modeling, writing a technical design document based on the specifications, created final work product, reports, unit and system testing and client acceptance.

Confidential, Hartford, CT

Programmer/Analyst

Responsibilities:

• Reversed-engineered an annuity payout calculator system. Developed technical documentation for use by the actuarial and programming department.
• Produced documentation of an existing annuity payout calculator, a DLL coded in MS Visual C++ and used by three different systems. Tasks included interviewing the maintainer of the calculator DLL, business users, analyzing source code, and stepping through the code in debug mode.
• Performed emergency production support fixes on several occasions.

Confidential, Bloomfield, CT

Programmer/Analyst

Responsibilities:

• Developer for healthcare application. Used VB 4 and upgraded application to VB 6.
• Key developer and analyst for a major Healthcare application release, (PC2CDB project, GUI phase of release 2) which included migrating to a 32-bit platform, upgrading from VB4 to VB6, as well as major enhancements to add system functionality. Crystal Reports was replaced with FarPoint spreadsheets for reporting, other technical reports were created using Excel and implemented from VB using COM.
• CICS Client used to access DB2 database.
• Performed integration testing in the healthcare production support laboratory and assisted quality assurance.
• Visual SourceSafe used for software configuration management.

Confidential, Hartford, CT

Programmer/Analyst

Responsibilities:

• Key developer in a small team performing prototyping, redesign and rewriting of a software development tool for project planning and tracking. 2-tier application developed in VB 6 and Sybase.
• Performed coding to aid in data conversion to update existing data into new tables.
• Developed management reports using Crystal Reports.
• Visual SourceSafe used for software configuration management.

Confidential, Rocky Hill, CT

Project Leader

Responsibilities:

• Project Leader for development of the next generation Claim Recovery software. Redesigned current Access-based system to handle current and future business needs as a 2-tier application that uses VB 6 and SQL Server. Redesign of cost recovery process and data modeling. Developed documents for technical design and testing. Worked with business users and top company management.
• Developed project documentation included a design, testing, UML, ERDs, use cases, table design in Visio and a complete project plan in MS Project.
• Performed data mapping and data conversion of new systems to legacy data.
• Performed emergency production support fixes on the current Access system.

Confidential, Hartford, CT

Programmer/Analyst

Responsibilities:

• Software developer for foreign exchange inter-company financial loan netting system, 2-tier application implemented in VB 6 and SQL Server and Crystal reports.
• Defined project specifications with input from foreign exchange officer.
• Created the financial application in the SDLC environment.
• Data modeling, designed and development of a financial loan netting system.
• Created management reports using Crystal Reports.
• Development with Excel spreadsheets and macros used for specific user needs.

Confidential

Programmer/Analyst

Responsibilities:

• Created management reports using Crystal Reports.
• Enhancements to Analyst Workstation and Underwriting Resource Center systems.
• Year 2000 changes in C for policy issue system