SUMMARY:

• Over 20 years in industry programming throughout software development lifecycle (SDLC): Requirements, Analysis, Design, Development, Testing (UAT), Implementation, Maintenance, Security, and Support
• Technical writing and publications within the areas of Computer Science, Mathematics, and Software Engineering including Master thesis publication
• Background experience in Aerospace, Healthcare Insurance, Property & Casualty, Workers Compensation, Reinsurance, Asset Recovery, Accounting, Policy and Claims Administration
• Background experienced in Change Management, VSS (Visual Source Safe), TFS (Team Foundation Server), Conversion, Migration, Integration, Automation, Extractions, Database Architecture, Reuse, Modeling, Encryption, Reporting, Customizations, Data Analysis, API/COM Integration, Object - Oriented Programming, and USPS Integration, Web Development Tools for Rapid Application Development (RAD), EDI, UDS
• Background experience in problem solving, statistical analysis, graphical representation, auditing solutions, object-oriented security model and implementation, data staging and transformations, performance tuning
• Knowledge of formal representation used during SDLC such as VDM, Z, and UML, Data Warehouse

TECHNICAL SKILLS:

LANGUAGES: Visual C++, Basic, FoxPro, Visual FoxPro, Access Basic, Visual Basic, VBA, Pascal, FORTRAN, ASSEMBLY, Design Patterns, XML, Analysis Patterns, VBScript, TSQL, SQL Script, MSQuery, C #

DBMS (database):SQL Server 2000, SQL Server 2005, SQL Server 2008, FoxPro, MS Access, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017

OPERATING SYSTEM: Windows 95, Windows 98, Windows NT, Unix, Windows 2000, Windows XPWindows 7, Windows 8, Windows 10

REPORTING: MS Access Reporting, SQL Server Reporting Services (SSRS), Crystal ReportingVisual FoxPro Reporting

ETL: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Data Junction

SOFTWARE: Microsoft Visual Studio Suite, Visio, Easy-ER, Crystal Reports, XML Script Editors, SQL Query Analyzer, Microsoft Dynamics, Microsoft Great Plains, HRS Pro, SharePoint, 1099Pro, WordPress, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft OneNote, Microsoft Access, Bulk Mailer, Smart Mailer, Bright Work, Web Development Tools, FileNet, Hare Point, MM Net

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, Florida

SQL Developer Consultant

Responsibilities:

• Developed and Maintained Stored Procedures, Views, User Defined Functions to support Front-End Applications and Data Warehouses
• Developed and Maintained SSIS Packages in support of Data Export tasks in SQL Server Databases.
• Developed and Maintained SSRS reports with data sources based on stored procedures and SQL Queries in support Front End Application Reporting.
• Performed Data Analysis, Data Transformations/Validations from various system databases
• Performed Ad-hoc and On-Demand Data Requests
• Performed Impact Point Analysis for data changes and application changes
• Developed TSQL scripts to make updates to the data in database(s)
• Write complex queries in support of SSRS reports and Excel Data Exports
• Use of GIT to manage source code changes
• Use of JIRA to produce Test Cases in support of User Acceptance Testing (QA/UAT)
• Use of Crucible FishEye to perform Code Reviews for Development Team
• Use of Confluence to collaborate on requirement specifications
• Use of Footprints as a help desk ticketing system

Environment: SQL Server, MS Visual Studio, TSQL, SSRS, SSIS, Data Transformations and Validations, Extracts, ETL

Confidential, Tallahassee, Florida

Senior Database Analyst

Responsibilities:

• Developed and Maintained Relational SQL Databases and Relational MS Access Databases for Front End Applications
• Developed and Maintained Stored Procedures, Views, User Defined Functions to support Front-End Applications
• Developed and Maintained SQL Agent Jobs in support of nightly processes and database synchronization tasks.
• Developed and Maintained SSIS Packages in support of Data Import and Export tasks in SQL Server Databases.
• Developed and Maintained SSRS reports with data sources based on stored procedures and SQL Queries in support Front End Application Reporting.
• Developed and Maintained SQL Server Based Migration Processes in support of ability to migrate data from various data sources into SQL Database(s).
• Performed Database Migrations from SQL Server 2000 to SQL Server 2008; SQL Server 2008 to SQL Server 2014
• Developed EDI-type files to defined specifications in compliance to electronic transmissions to external entities.
• Performed Data Analysis, Data Mappings and Developed Processes for data handling across various insurance entity types (HealthCare, Workers Compensation, Property & Casualty, Auto)
• Performed Data Conversion/Transformations from various system into internal systems
• Developed and Maintained SQL Server Based Integration with Third Party Mailing System for capturing updated USPS Addresses, USPS Forwards, USPS Returns.
• Managed Data Changes within Production Environments
• Served as the Visual Source Safe Administrator for managing application changes from development to test to production environments
• Performed Ad-hoc and On-Demand Data Requests
• Used ETL tools like SQL Server Import Wizard and Data Junction to transfer data into SQL Server Database(s)
• Performed Impact Point Analysis for data changes and application changes
• Recommended Solutions and/or Improvements to various business scenarios within internal business processes, practice, and procedures.
• Developed TSQL scripts to make updates to the data in database(s)
• Developed Microsoft Access Applications including VBA, SQL Queries, Macros, and Functions
• Performed Diagram modeling using Microsoft Visio
• Use of VSS/TFS to manage source code changes
• Produced data deliverables in support of User Acceptance Testing (UAT) in form of Excel Spreadsheets and/or linked MS Access tables
• Developed and Maintained Staging System for staging data and loading data into internal applications and Third Party applications
• Performed Peer Code Reviews for Development Team

Environment: SQL Server, MS Visual Studio, Crystal Reporting, TSQL, SSRS, SSIS, Share Point, Accounting, Web-based Development and Legacy System Integration, Database Migration, Data Transformations and Conversions, Extracts, UDS, ETL

Confidential, Tallahassee, Florida

Application Developer

Responsibilities:

• Developed and Maintained Insurance Related Visual FoxPro Applications Based on Object-Oriented Programming, COM Objects, API
• Developed and Maintained Crystal Reports in support of Front-End Applications using Crystal Reports 8.5/9/0 using Crystal Objects and Stored Procedures/SQL Queries
• Developed Microsoft Access Applications including VBA, SQL Queries, Macros, and Functions
• Performed data migrations from Visual FoxPro Data Tables to SQL Server Database/Tables using SQL Server 2000/2005
• Performed System Integrations into Third Party Applications via Data Imports and Exports and ETL tasks using Data Transformation Services (DTS)
• Design and Implemented SQL Databases for Front End Applications
• Developed Stored Procedures, Views, User Defined Functions to support Front-End Applications
• Developed TSQL scripts to make updates to the data in database(s)
• Performed Application Migrations from development to test to production environments
• Developed and Maintained Build Manager Application responsible for performing builds and deploying builds to development, test, and production environments
• Developed Application Install Configuration Program for installing and setting up applications for use
• Served as the Visual Source Safe Administrator for managing application changes from development to test to production environments

Environment: SQL Server, MS Visual Studio, Crystal Reporting, VSS, TSQL, DTS, Accounting, Legacy System Integration, Database Migration, Data Transformations and Conversions, Extracts, UDS, ETL