Post Job Free

Resume

Sign in

Sql Server .Net

Location:
London, ON, Canada
Posted:
October 31, 2014

Contact this candidate

Resume:

Michael Shields

804-***-****

acgkhv@r.postjobfree.com

Summary: Over 12 years’ experience working with various technology to solve business problems.

Proficient in the following technologies: SQL (mostly Oracle and SQL Server 2008/2012),

Visual Basic.NET/C#, and Access.

SharePoint/.Net:

ASP.NET, Web Services (REST, SOAP, JSON), created customized ASP.NET Web-parts, MVC

Versions: .Net 2.0, 3.0, 3.5, 4.0.

Skills: RDBMS: Oracle 10g, Oracle9i, Oracle Tuning, SQL Server 2000/05/08, SSIS, SSRS

Languages: JQuery, C#, C++,VB,VB script, AJAX, VB.NET, Java Script, CSS, HTML,ASP.

Microsoft SharePoint Server 2003/07/10, Microsoft SharePoint Foundation 2010, web parts,

lists, web pages, Windows Forms and back end processing solutions.

Experience:

Developer Exxon Mobil Fairfax, VA 05/13-08/14

Created sophisticated SQL Server database to responsively handle complex queries (T-

SQL, stored procedures, functions) and .NET to automate processes to migrate data.

Envisioned and built front-end for the site written in ASP.NET, MS Visual Studio .NET,

C#, VB.NET, XML, VBScript, HTML, DHTML, JavaScript.

Parse XML data to allow companies to easily submit information according to profile.

Created web pages and customized web parts per customer requirements.

Run existing reports to monitor application metrics and analyze results to ensure quality.

Analyze and compare 2008, 2012 SQL tables to confirm the side by side application

results and perform troubleshooting.

Prepare project documentation to record acceptance testing result.

Instructor ECPI University Richmond, VA 02/12-present

Inspired students to integrate technology into daily classroom activities.

Restructured student attitudes regarding purpose and use of technology in classroom.

Taught Mathematics in a classroom environment.

Developer Dept. Of Trans. (Contract) Washington, DC 09/12-05/2013

Michael Shields

804-***-****

acgkhv@r.postjobfree.com

Developed and maintained an e-commerce web site https://hazmatonline.phmsa.dot.gov/Online

Approvals/pages/welcome.aspx, where users can search and submit online approvals for Special

Permits to the Hazardous Materials Regulations (HMR) in ASP.NET (C#, VB.NET) web

application with Oracle 11g back-end.

Developed and maintained a web site

https://hazmatonline.phmsa.dot.gov/services/haz_reg_1.aspx where users can register for

transport of Pipeline and Hazardous Materials.

Created sophisticated SQL Server database to responsively handle complex queries

(PL/SQL, stored procedures, functions) and .NET data access components Oracle 11g database.

Implemented business logic as .NET Framework assemblies (C#, VB.NET).

Envisioned and built front-end for the site written in ASP.NET, MS Visual Studio .NET,

C#, VB.NET, XML, VBScript, HTML, DHTML, JavaScript.

Created a functions using XML to allow companies to easily submit information

according to profile.

Created web pages and customized web parts and SharePoint object model per customer

requirements.

Business Analyst/programmer Andrews INT Centreville, VA 09/10 –02/12

Converted legacy payroll, billing, Timesheet and PTO classic ASP application into intranet ASP.NET Web Application written

in C# and VB.NET with SQL Server 2000, 2005 and 2008 on the backend.

Wrote Oracle PL/SQL, SQL server queries, SSIS, SSRS,T-SQL stored procedures, and

functions to manipulate data and produce reports.

Created business system tools/web pages using classic ASP and C#, VB .NET so that

database can be updated with data for payroll and business data.

Created websites to migrate various applications using active directory.

Administrated user permission and develop web pages by using web parts in Share

Point.

Created several organization sites using SharePoint Portal Server 2007, 2010 as per

client requirements.

Created and built Web Parts using SharePoint object model and SharePoint Designer

2007, 2010. Installed, Configured, Maintained and Troubleshot Microsoft Office SharePoint

Server (MOSS) 2007.

Upgraded from Sharepoint 2007 to 2010.

Created and maintained customized workflow application per user and business needs.

Integrated Visual Studio to created web parts for SharePoint.

Created Business Logic Layer & Data Access Layers to implement the MVC

architecture

Created desktop windows applications and Windows Forms and then used C#, VB for

reports and server management system.

DBA Northrop Grumman Newport News, VA 09/09 –09/10

Michael Shields

804-***-****

acgkhv@r.postjobfree.com

1 year contract to create intranet web applications for engineers to access reports view budgeting and submit reports for

funding. Save the department thousands of dollars by solving problems that were previously submitted to IT department.

Created several organization sites using SharePoint Portal Server 2003 as per client

requirements.

Served as SharePoint administrator by creating user, accounts groups and resetting

passwords.

Created costumed web parts per user request.

Documented, analyzed, debugged and created new processes for all programs written in

Visual Basic

Developed web pages and desktop windows applications and Windows Forms in C#,

HTML, .NET and JavaScript on internal websites to help department employees access various

files and reports.

Developed Visual basic macros in excel and access to automate the management of man

hours for the department budget.

/

Student, Norfolk State University, Norfolk, VA 01/09 – 08/11

Currently installing and documenting requirements for ADOBE Server for Norfolk State

University.

Completed Computer Architecture, Data Communication and Computer Security I and

II to complete partial requirements for MS in Computer Science.

Researching methods of securing online medical records in a SQL server database with

ASP.NET, C# and Visual Basic.

Lead Developer/Programmer, Dynamic Research (8 month contract U.S. Army), Ft. Lee, VA

05/08 – 01/09

Wrote Oracle server stored procedures, functions and cursors to analyze data sent from

vendors for Army commissary pricing.

Documented, analyzed, debugged and created new processes for all programs written in

C/C++, Perl, shell scripts and Oracle. If

Database Developer, NABCA Alexandria, Alexandria, VA 07/06 –05/07

Developed and maintained e-commerce web sites, where users can search pricing to compare

products in different states to maintain integrity in ASP.NET (C#, VB.NET) web application with

Oracle 11g back-end.

Michael Shields

804-***-****

acgkhv@r.postjobfree.com

Created ace reports for clients to access data through Diver software.

Created UNIX shells scripts in AWK, KORN and SED to manipulate files and text.

Wrote SQL in Informix databases and PL/SQL in Oracle databases.

Created and edited UNIX scripts and programs by using KornShell, AWK, SED

Created desktop windows applications and Windows Forms and thein C-sharp VB for

reports and time management system.

Database Developer, Claritas, Arlington, VA 09/05 –02/06

Developed and maintained an e-commerce web site, where users can search trends to market

product and services in ASP.NET (C#, VB.NET) web application with Oracle 11g back-end.

Wrote SQL Server stored procedures, SSIS, SSRS, triggers, and functions to manipulate

data and produce reports.

Developed hundreds of programs in SQL server and UNIX for data maintained created

in various formats from statisticians.

Created UNIX shells scripts in AWK, KORN and SED to manipulate files and text.

Performed DBA activities such as user administration, schema creation, performance

tuning and granting permissions.

Created C#, JavaScript, HTML and ASP.NET code to manipulate and display Oracle

data on current website for marketing software.

Created desktop windows applications and Windows Forms and then C#, VB for reports

and data management system.

Data Conversion Specialist, Harris Publishing, Chesapeake, VA 02/02-05/02

Import/Export data provided by our clients in various formats into a SQL Server

database.

Migrated, normalized, and recreated tables and queries from Access to SQL Server 2000

database.

Converted Access macros, reports and VB modules code to SQL Server database.

Wrote PL/SQL and SQL Server stored procedures, queries, and functions to manipulate

data and produce reports.

Created JavaScript, HTML code to manipulate and display Oracle data on current website

for marketing software.

Education:

Hampton University, Hampton, VA Masters of Science in Applied Mathematics, August 2005

Michael Shields

804-***-****

acgkhv@r.postjobfree.com

Norfolk State University, Norfolk, VA Bachelor of Science in Mathematics, December 2001

Concentration: Computer Science



Contact this candidate