Sql Server Data
Resume:
Bill L. Jones
Sherwood, AR 72120
acv8fr@r.postjobfree.com
QUALIFICATIONS Extensive and successful 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.
EDUCATION Arkansas State University, Jonesboro, Arkansas.
Bachelor of Science Degree in Management. MBA studies in Systems Analysis. Additional studies: MRP, stores management, physical inventory and cycle counting.
TECHNICAL SKILLS
OS: MS Windows XP/Vista/Win 7/Win 10 Desktop, MS Windows 2003/2012 Server.
Languages VB.NET 2012/2010/2008/2005/2003, ASP.NET 2.0/3.0/4.0/4.5, C#.NET, ADO.NET, Visual Basic 6.0, VB Script, JavaScript, XML, HTML: FW 1.0-4.7.
Databases: MS SQL Server 2000/2005/2008R2/2012, MS Access and DBF.
Development Environments/Applications: Visual Studio .NET 2003-2015, Visual Studio 6.0, SQL Server 2000-2012, DTS/SSIS, SQL Server Reporting Services (SSRS), SQL Server Reports RDL and RDLC, SQL Server Data Analysis, Visual SourceSafe, Team Foundation Server, IIS Server, Microsoft Office Suite, Photoshop.
EXPERIENCE
May 2017 – Sep 2017 Dessault Falcon Jet, Little Rock, Arkansas.
SQL Server Reports Developer. Contract. I created complex reports containing table forms and graphs based on requirement documents provided by the Business section at Dessault. Reports required data analysis and discovery from various data tables
Jul 2015 - Present SOFTEC, Sherwood, Arkansas.
Chief Software Architect/SQL Developer/Owner. I am currently re-writing and updating an order/billing application for a truss brokerage company client using C#.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 files and from text based output data of an engineering drafting program. All data is stored and maintained in SQL Server 2012 tables.
May 2014 – Jun 2015 Zycron Inc., Little Rock, Arkansas. Arkansas Department of Workforce Services.
*Dec 2011 – Oct 2013 SQL Server Data Analyst/Reports Developer. Contract. (Multiple Contract Funding Dates)
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 DFA Enterprise System (AASIS), the external state’s government accounting system. Created specialized SSRS RDL reports from 1000+ tables within GP Dynamics databases as required by client for daily reporting and agency management.
June 2011 – Dec 2011 NASA / APEX Systems, Kennedy Space Center.
SQL Server Database Administrator/SSRS Reports Developer. Contract.
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 and complex SSRS RDL reports to mimic the mainframe output style and look as required by the NASA client within the projects deadlines.
Feb 2011 – Mar 2011 CIBER, Little Rock, Arkansas. Arkansas Department of Workforce Services.
SQL Server Data Analyst/SSRS Reports Developer. Contract.
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 process from DFA Enterprise System (AASIS) 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.
June 2008 – Feb 2011 CIBER, Biloxi, Mississippi.
SQL Server Reports Developer. Contract.
This position required my experience and skills using Visual Studio 2005, SQL Server 2005 and SQL Server Reporting Services. This project involved the development and implementation of enterprise wide reports for the Mississippi Emergency Management Agency (MEMA). My duties included writing SQL stored procedures for special data retrieval, user-defined SQL functions and the development of complex SQL Server Reports RDLC 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 included creating front-end interfaces for special projects using C#, VB.NET, Excel and MS-Access.
Jul 2007 – June 2008 Fervent Technologies, Tampa, Florida.
Application Developer. Contract.
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 Goldman-Sachs Mortgage Investment Group. My duties included development of user interface screens and dashboards using VB.NET; writing SQL stored procedures for data storage and retrieval; user-defined SQL functions; and the development of complex Reporting Services RDLC format 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.
Sep 2006 – Jul 2007 TopCoder, Inc. Tampa, Florida.
SQL Server Database Developer. Contract.
I was 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 in RDL format. 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. I was responsible for writing Technical Design Specification documentation for reports based on the business rules that were provided from the Project Specifications.
Additional project assignments required my skills using ASP.NET, VB.NET and SQL Server 2005.
Jul 2006 – Sep 2006 DME Inc., Daytona Beach, 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 methods 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.
Mar 2005 – Jul 2006 Arkansas Department of Health and Human Services. Little Rock, Arkansas.
Lead Programmer/Analyst. I was responsible for the analysis, design, development and implementation of Web-Aware application projects as assigned within the Division of Health. The projects required expertise in application development using ASP.NET, VB.NET, ADO.NET, JavaScript, SQL Stored Procedures, T-SQL scripting for SQL-Server, SQL-Server DTS/SSIS and ETL methods. I received training and certification to meet all HIPAA requirements and regulations for handling data security within a health provider agency.
May 2001 – Mar 2005 SOFTEC, Sherwood, Arkansas.
Chief Software Architect/Database Developer/Owner. I used the latest Microsoft development technologies being released and incorporated that technology for clients such as Environmental Services, Inc. and Custom Building Concepts, Inc. I designed, developed and implemented Windows based database applications using Client-Server and n-Tier technology for these business clients. Important points of my experience are as follows:
Proficiency with: Visual Basic 6.0 Enterprise, Visual Studio.NET 2003, VB.NET 2003, MS-SQL Server 2000, MS-SourceSafe 6.0, MS-Office, MS-FrontPage, Infragistics and ComponentOne Components for VB.
Visual FoxPro 6.0 development and application modifications with AccountMate Accounting System product.
Complete life cycle application development for accounting, health care, legal, service and manufacturing.
ADO data access to SQL Server, Oracle, Excel, Access and ODBC compliant data.
Creating DTS packages within SQL Server, integrating DTS scripts into VB coded applications. Perform ETL methods to pull from various data sources.
Creation and use of SQL stored procedures, user-defined functions and triggers. Coding VB with SQL Server’s DDL, DML and SQL-DMO language structures.
Using XML within VB to persist data or to import data from the web to SQL Server.
Object-Oriented VB Class design methods.
Using Crystal Reports Version 9 and Version 10 Developer.
Responsibility for DBA task on SQL Server database including design, security, data integrity and performance tuning of the databases.
Repair of PC systems, custom building desktop/server computers, installation and configuration of Microsoft 2000/2003 servers and MS-SQL Server 2000/2005.
Installation and use of backup and security management software for servers and workstations
MILITARY U.S. Navy, Radioman
Top 20 Graduate of Radio Class A School.
Held Top Secret Clearance.
Supervisor and Leading Petty Officer.
Training and Publications Petty Officer.
War Veteran.
Honorable Discharge.
HONORS AND Certificate of Merit, The Small Business Institute
ORGANIZATIONS Charter Member, Great River Chapter, American Production and Inventory Control Society.
Contact this candidate