SUMMARY:

• Extensive and successful managerial experience in: computer information systems, full life - cycle development, object-oriented class design, project management, system installations, sales, production and inventory control, warehousing, shipping, purchasing, manufacturing, capital budget planning and business finance.

TECHNICAL SKILLS:

OS: MS Windows XP/Vista/Win 7/Win 10 Desktop, MS Windows 2003/2012 Server.

Languages: Visual Basic 6.0, VB.NET 2012/2010/2008/2005/2003, ASP.NET 2.0/3.0/4.0/4.5, ADO.NET, VB Script, JavaScript, XML, HTML.

Databases: MS SQL Server 2000/2005/2008 R2/2012, MS Access 2003 and DBF.

Development Environments/Applications: Visual Studio 6.0, Visual Studio .NET 2003-2012, SQL Server 2000-2012, DTS/SSIS, SQL Server Reporting Services (SSRS), SQL Server Data Analysis, Visual SourceSafe, Team Foundation Server, IIS Server, Microsoft Office Suite, Photoshop.

PROFESSIONAL EXPERIENCE:

Confidential,Sherwood, Arkansas

Chief Software Architect/SQL Developer

• I am currently re-writing and updating an order/billing application for a truss brokerage company client using VB.NET 2012, ASP.NET 4.6, SQL Server 2012, SSIS and SSRS for proposal management; order processing, billing, reports and geospatial information. The application uses SSIS to import data from a FoxPro dbf file and from text based output data of an engineering drafting program.

Confidential,Little Rock, Arkansas

SQL Server Data Analyst/Reports Developer

• I performed required analysis and creation of SSIS packages for conversion of multi-sourced data from existing data systems into SQL Server 2008R2 database tables. The task required my ability to create SQL procedures, triggers and functions to interface with Microsoft Great Plains Accounting (MS Dynamics) software and existing external state’s government accounting system. Created specialized SSRS reports from 1000+ tables within GP Dynamics databases as required by client for daily reporting and agency management.

Confidential

SQL Server Database Administrator

• I provided extended support on the Mainframe Shuttle Decommission Project at Kennedy Space Center. Task required ETL functions and interpreting legacy mainframe report code (ADABAS/Natural) into complex T-SQL scripts, UDF’s and Stored Procedures with the objective of rendering comparable reports using a SQL Server 2008R2 database. I developed specially designed SSRS reports to mimic the mainframe output style and look as required by the NASA client within the projects deadlines.

Confidential

SQL Server Data Analyst/SSRS Reports Developer

• This position required analysis and SSIS package conversion of multi-sourced data from legacy data systems into SQL Server 2008R2 database tables. I developed SSIS packages to automate the data collection processes and to perform data validation. My task required my ability to create and modify existing SQL procedures, triggers and functions to interface with GP Dynamics Accounting software and existing external government accounting systems.

Confidential

SQL Server Reports Developer

• This position requires my experience and skills using Visual Studio 2005, SQL Server 2005 and SQL Server Reporting Services. This project involves the development and implementation of enterprise wide reports for the Mississippi Emergency Management Agency (MEMA). My duties include writing SQL stored procedures for special data retrieval, user-defined SQL functions and the development of complex Reporting Services forms and reports to comply with the client’s web-based reporting requirements. I was responsible for maintaining continued data integrity for the project and to create and manage databases and tables for any special projects and as needed for the primary project. Other task includes creating front-end interfaces for special projects using C#, VB.NET and MS-Access.

Confidential, Tampa, Florida

Application Developer

• This position required my experience and skills using Visual Studio 2005, VB.NET 2005, SQL Server 2005, SQL Server Reporting Services and Visual SourceSafe. The project was the development of an enterprise wide application for a major New York mortgage investment firm. My duties included development of user interface screens using VB.NET, writing SQL stored procedures for data storage and retrieval, user-defined SQL functions and the development of complex Reporting Services reports to comply with the client’s reporting requirements.
• I worked very closely on a daily bases with Quality Assurance Analyst and the mortgage investment firm’s staff to ensure the application met their strictest requirements. I provided immediate action and recommendations on any testing issues and gave support as necessary.

Confidential,Florida

SQL Server Database Developer

• Responsible for writing highly complex SQL Server 2005 Stored Procedures to pull information from a large data warehouse (30+ Terabytes) to be used with SQL Server Reporting Services. I assisted in the creation and the moving of data into a Dimensional Data Warehouse. Created reports to meet client’s exact report formatting requirement using the Visual Studio 2005 Report Designer and XML interface.
• I created SQL Views that were used to aggregate result tables that fed into Reporting Services reports. These views were designed to simplify extraction of information and improve execution speed and improve security of report rendering through the report server. I performed data validation and code quality checks using T-SQL scripts and VB.NET to insure accuracy of results through Test Case Scenario analysis. Responsible for writing Technical Design Specification documentation for reports based on the business rules that were provided from the Project Specifications.

Confidential,Florida

SQL Server Database Developer

• Imported data from many variant formats from client data sources and transform with DTS/SSIS to SQL Server 2000 database tables. Perform ETL techniques to ready data warehouse for high data volume and high volume laser printing system. Created SQL reports and data audits using T-SQL scripts, stored procedures and VB.NET.