David Young

Database Developer: SQL / Oracle / ETL / SSRS / Crystal Reports, BI, SSMS, TOAD, DBA duties

Applications Developer: .NET, SharePoint, Desktop and Web

(VB.Net, C#.Net, Ajax, API, Web Services, Telerik, Bamboo)

Business Analyst: Certified SCRUM Master / TFS / MS Project, JIRA, Visio

Colorado adayu8@r.postjobfree.com 225-***-****

Work Experience

Applications Programmer (Level III) Applications Systems Analyst / Programmer)

Client: DODMERB Department of Defense Medical Examination Review Board

Onsite Site Location: Colorado Springs, CO ~ Air force Academy

June 2019 to October 2019

SharePoint 2013 Development utilizing Agile SCRUM methodology

Development, Bug fixes, Documentation related to Custom Application

Technologies scope: SharePoint 2013, C#, .NET, SQL, API, Web Services

Follow Security policies pertaining to updates of: Server OS, Critical Updates

Participate and contribute with authorities of designated departments

Obtaining requirements from PMO, providing Technical documentation, Performing the task and maintaining code by means of TFS

SQL Server Developer (Lead)

ISC Constructors, LLC - Baton Rouge, La

November 2014 to June 2019

SQL Server debase

oETL: Migration from legacy system and stand alone Access databases into core ERP system

oSSIS used to create workflows, automate processes and various ETL tasks

oOptimization: Create Triggers, monitor workloads, eliminate deadlocks

oDaily tools in order of precedence: Crystal Reports, SSRS, Excel, Access

oADHOC and Standardized Reporting (Crystal / SSRS)

Invoices, AP, AR, Project Management and Executive assignments

Present additional areas where data may be of interest

Customize SQL Driven ERP System

oImplementation of new business process

oGather specifications and present possibilities in streamlining workflows

oPerform data review related to bug fixes or any data related anomaly

Implemented the SSRS reporting system by mapping Domain roles through SQL for security as well as performing the proper architecture related to data and security of the individual reports

Developed a number of desktop applications by means of VB.NET such as traversing all Crystal reports to build an excel spreadsheet consisting of tabs for: Tables, Queries, Parameters, Views, Procedures which was used when any updates were preformed to the ERP system or and data changes were made.

oThis produced a filterable list of reports that would need to be touched.

Routine Crystal Reports, SSRS development and maintenance with limited Power BI

Consult with Administration, Directors, on a number of other various SME topics, as related to development efforts and SWOT type conversations

SharePoint Developer used to create Sites, Document Libraries and Data Connections Libraries

Intermediate Programmer / Developer

Continental Motors, Inc. (AREO) - Mobile, AL

October 2013 to November 2014

VB.NET [3.5] to update existing Production applications and implement new applications

Crystal Reports XI

oImplemented a server based Crystal Reports (one license) application used for inventory

Integrated bar code readers, printers and bar code hand held scanners

Additionally produced a related SQL list of item to image relation which was used to assure the inventory processes such as checking in and out the proper tool

Requirements rely on centralized DLL repository rather than manual or administrative installs of the Crystal Runtime

Louisiana Department of Development and Transportation

LA. D.O.T.D – Baton Rouge, La

June 2010 to October 2013

IT App. Programmer

Utilized ASP.NET and AJAX on multiple projects for front end UI

SSIS used on occasion for ETL tasks such as Importing Excel data into databases

Active Reports 6 used in report generation (VB.NET) code o PL/SQL - OleDb Queries written against an Oracle 10.2g / 11 database

•Created a Laboratory system of 400 plus reports that were compiled into some 40 plus reports (produced dynamically by means of User interface buttons, dropdowns (UI) which is used by some 46 states and two nations

Visio and PowerPoint: gathered application / user requirements

Oracle Virtual Box and Hyper-V for Development and Pre Production environments

Remote Desktop used in current off-site development

Used C#.NET and VB.NET [4.0] to develop and Web applications as well as the DOTD E-Store / ecommerce site

VeriSign / SSL, Web Services were written in C#.NET to complete credit card transactions, as well as a "Rooftop Address" Tax - Web Service

Used VB.NET [4.0] to develop an AASHTO / PowerBuilder / SSMS based Report application

The Intranet application was configured to run on IIS 7, hosted on a Windows 2010 Server

SharePoint 2010 Used in creation of an InfoPath 2010 request system

SharePoint Developer used to create Sites, Document Libraries and Data Connections Libraries

2010 used to create multi-view forms for State and Federal departments along with workflows to approve / deny request * Multiple workflows created:

Update forms that had been updated incorrectly

Unique workflows for Project and Operations

VB.NET / Active Reports6 - Report generation for: American Association of State Highway and Transportation Officials (AASHTO) o Required to use VB.NET (4.0) as the front end o Required to use Active Reports 6 to generate reports * Queried Project Manager: Oracle 11 Database with PL/SQL * Created three pages which generate over [300] custom reports

Collaborate, consult / advise with Project Manager over discussions including representatives from fourteen states

Other Duties Include but not limited to:

IIS 7 / Server 2010 - Intranet and Internet Web Development

Research, documentation pertaining to Development of SharePoint 2010 standards and best practices

Assist with the LaGov SAP / ERP initiative - specific to Budget - Finance - Capital Outlay

Develop and maintain a .NET C# E-Commerce website and fully adhere to State and Federal Tax,

FIPS / Use / Nexus laws - While completely securing all credit card data through a secure payment Web Service

Assist with training and Architecture of items such as building functionality within the SAP / ERP /Data Warehouse and ECC - Excel runtime environment

2010 used to create a multi-view forms

SharePoint Login Service is queried along with the use of a List Library to gather user credentials, auto-fill fields and set InfoPath rights

Bamboo Workflow conductor was acquired by IT and specified to be used to create a variety of Workflows

Project(s)

Ecommerce Development: https://www8.dotd.la.gov/estore o Duties Include: Researching Tax Laws, Communicating with Louisiana Department of Revenue, Department of Administration, Assessment of outsourced Web Services, Requirements, Architecture, Programming and Implementation

The Mapping department required assistance with the sales of maps, books and other State provided material

Research into Taxes, IRS, District, Parish, Local and National Tax laws was researched and implemented in order to create the States only Ecommerce website that processes credit cards as well as the appropriate Tax level - Pr. Rooftop addressing; Provided by the Strike Iron Web Service

Additional web service is used to process credit card information in a secure fission

A 2008 SQL Enterprise server is used as a backend along with SQL Backup Manager

Enterprise SQL Server: Used in creation of Functions, Triggers, Tables and Procedures

Crystal Reports 12 required for Financial department to reconcile the Credit Card service against the sales recorded in the DOTD database

SharePoint Specific Tasks

SharePoint 2010 Development - Project Modification Request Application

Duties Include: Architect, Developer, Gathered Requirements, Programming and Implementation o Gathered requirements through DOTD, Budget and Finance Department Heads, Management and Staff

Used Visio 2010 to generate workflows for validation of processes

Use of SharePoint Designer to create subsides, document libraries and Data connection libraries o Use of Central Administration to add security rights and enable required services o Bamboo Workflow Conductor was mandated for creation of InfoPath Workflows

I.T. Analyst

ARAMARK – Baton Rouge, La

August 2009 to January 2010

Used C#.NET, and SQL 2010 to Design and implement .NET solutions which utilize existing proprietary

ARAMARK software such as: ISIS Pro and ISIS Web Portal

Consulted and Assessed East Baton Rouge School Board - Facilities Maintenance Operations current technologies, deficiencies and implement fixes as well as moving to a Paperless System

Used existing Microsoft Backup carousel to Redesign, document and implement Disaster Recovery plan

PowerPoint 2010 utilized to present to EBR FMO Administrative Director, Larry Munson as well as

ARAMARK Administration concerning items such as efficiency and cost effective paperless solutions

Research solutions by interviewing senior administration, staff, managers, janitorial persons and Electricians

IT Analyst / Programmer

Gulf Coast Analytical Laboratories - Baton Rouge, La

August 2007 to July 2009

Create desktop and web applications with Oracle 10.2g, Visual Basic, C#.NET, VB.NET, PERL, VBA, ASP.NET

ETL - Extraction, Translation, and Loading

EDD – Electronic Data Deliverable (XSD, XML / XLS

Tools used: Oracle 10.2g, TOAD, Access, .NET 2008, .NET 2005, ACTUATE, ChemWare - Horizon LIMS,

Excel, .NET C#, .NET Visual Basic, Visual Basic for Access (VBA), PERL, XML, Remote Desktop, Visual

Source Safe, Internet Information Services 6.2

Administrate and utilize HORIZON - ChemWare LIMS (Laboratory Information Management System software)

Write functions, triggers, packages, and procedures

Write custom queries for report generation

Gather and export data to create Electronic Data Deliverable (EDD) files in specified formats: Text,

Design, develop and implement SEDD application which performs data XSD data validation then exports XML / XSD data

Translate and Transform EDD data in order to meet Federal and private specifications such as: DOD,

AFCEE, ERPIMS, DEQ, USAFCEE, TETRATEC, MACTEC, EXXON, SPECTRA

Run EDD data against electronic Data Processors to ensure against Referential Integrity, Valid Values and numerous other errors

Design, Develop and maintain intranet applications

Convert PERL applications to .NET

Perform liaison duties between federal QA management and client laboratories

Implement security such as: Logon procedures, SSL, Encryption, Event Logging

Network Security and Administration

Programmer / Q.A. Analyst

Neill Corporation and Paris Parker Salon Group - Hammond, La

February 2007 to July 2007

Tools used: FLEX (Action Script / Java Script), Visual Source Safe, Eclipse, Tomcat, Glassfish

Perform QA liaison duties with developers and end users

Manually test to Locate, document and report bugs

Create install specifications by reverse engineering developers software instillation

Create software user’s manual

Education

Southeastern Louisiana University – Hammond La (2004 to 2007)

Bachelors Degree

Skills

SCRUM, Oracle 10G (3 years), XML, HTML, JavaScript, Visual Studio (4+ years), SSRS (4+ years), ERP (5 years), SQL (6+ years), Report Writing (8+ years), Consulting (5 years), Software Development (10+ years), SharePoint Designer (3 years), SharePoint (3 years), Crystal Reports (5+ years), .NET (5+ years), Toad (2 years), C++ (2 years), Vb.Net (4+ years), Web Development (5+ years), Viewpoint Vista Construction Software / ERP (5 Years)

Certifications/Licenses

(CFM) Certified SCRUM Master : Date 11/14/2019 Link

SCRUM Fundamentals Certified :Date 11/09/2019 Link

Oracle 10g Programming PL/SQL

Oracle Database 10g

SharePoint Foundation 2010/2013

InfoPath for Power Users

MS:50354B SharePoint Designer

MS:2310D Developing Web Applications Using Microsoft Visual Studio 2008

SharePoint Designer 1

SharePoint Designer 2

.NET 2.0 Framework

ChemWare System Administrator / Laboratory (LIMS) Information Management System

Visual Basic 6.0 70-175 70-176

SharePoint 2010 .NET Development

SharePoint Designer

SharePoint 2010 – Infopath

520 520.Netware 4 Administration

Certified Novell Administrator - Netware 4

CompTIA Network+

CompTIA A+

System Administrator I Training

Issued by: Chemware Automated Laboratory Solutions Date Issued: 7 /2008

Additional Information

•Primary Languages: PLSQL, SQL, TSQL, C#.NET, VB.NET, PL/SQL, VBA, Java Script / Action Script, Visual Basic, C++

•Web Tools / Languages: Telerik, Pearl, PHP, ASP, XML, ASP.NET, Java

•SharePoint 2010:

•InfoPath, MOSS, BI, Workflows, Central Administration, Designer, Bamboo, Development, Training

•Over six years of contract - independent development and IT consulting

•Database utilization: Oracle, SQL, Access

•Web authoring software: .NET, Flash, Dreamweaver, FrontPage

•Database driven websites: ASP, PHP, SQL, Access, .NET

•Graphic Skill set includes: Adobe CS.x, 3D Studio Max

•FLASH / FLEX Macromedia Action Script web development

•Desktop / Web / Graphic design and implementation

•Network Administration of Microsoft and Novell networks

•Ability to resolve technical issues though past experience

•Tomcat, Glassfish, SQL Server, Oracle

Contact this candidate