Sql Server Service

STANLEY MWANGI Portfolio:

http://www.smwangiportfolio.com

PHONE: 617-***-**** . EMAIL: ****@****************.*** . HOME: Worcester, MA 01604

Objective A highly experienced software engineer/developer with expertise in

Web & Windows application development and user interface engineering.

Background includes architecting applications in challenging,

fast-paced consulting environments. Demonstrated ability to acquire

technical knowledge and skills rapidly. Innovative problem solver,

able to see the business and technical sides of a problem.

Qualifications Web Development . 10 + years of Dynamic SQL & Stored

. 12+ years of HTML, CSS, DOM

. 1+ years of Twitter Procedure

Bootstrap Plug-in . 7+ years of XML and Web Service

. 1+ years of Font Awesome . 3 + years of WCF RESTFUL Services

Plug-in Desktop and Application Services

. 8+ years of JavaScript & Development

jQuery . 6+ years of Windows Forms

. 2+ years of jQuery UI & . 3+ years of WPF Forms

Mobile . 8+ years of Win Host Batch plus

. 6+ years of AJAX, JSON .Net Console Integrated

. 6 + years of ASP.NET MVC Apps.

Forms & Razor . 4 + years of WCF Services.

. 9+ years of ASP.NET Web Form Project Development

. Worked on 14+ web projects

. 10 + years of Object (enterprise)

Oriented . Worked on 3+ desktop/console

Programming using C# projects

. 7+ years of VB.Net . Worked on 2+ Mobile Tablet

. 4+ years of LINQ, Lambda projects

Expressions . 7+ years of analyzing, problem

. 10 + years of Microsoft SQL solving, troubleshooting

(Transact-SQL) . 3+ years of consulting (users,

. 6+ years of MySQL & Oracle clients, stakeholders)

. 10 + years of Log4Net(Apps . 4+ years of training, mentoring,

Logging service) coaching team members

. 4+ years of ELMA(Apps . 6+ years of enforcing best

Logging Service) practices & coding conventions

. 3 + years of Claim-Based

Apps Security With

WIF(Windows Identity

Foundation

Security)

Experiences Worcester Envelope, Auburn, MA. Feb 2013 - Present

Senior .Net Application Developer

Please visit

portfolio for Using MVC3 & MVC4 Razor architectural design, developed and

pictures, implemented a Mobile Tablet Shipping Management System for Packed

videos, and Bale for Recycle. The Bale shipping process is critical not only in

source codes: scheduling and loading but managing weight loaded per truck load. By

www.smwangiPor Using the system, Operators Are able to: (i) Login to the system

tfolio.com using their security badges.(ii) Create/Edit/Destroy Barcoded label

Tags (iii)Track the status of a Tag(iv)Create/Edit/Destroy a Shipping

Request.(v)Using the system, manage Shipping Requests. (vi)Track

Loaded weight to meet the standard. (vii)Completing shipment process.

Environment:

The application is designed following the current proposed industry

architecture, The Onion Architecture. Pushing the dependencies to be

from outer layer to core and not in reverse direction.

The Application Service layer Exposes Interfaces to the UI. That

means from data security point of view, UI have no direct access to

the domain layer.

The Domain model data service layer uses Entity Framework 5.0 & SQL

SERVER 2008 & it's only exposed to the Application Service layer.

The User Account Service Layer Handle's all the Security services

and it's only exposed to the Application Services.

The Views are Razor Render designed using MVC4 Utilizing Twitter

Bootstrap plug-in & bootstrap Responsive Library To help with The

Mobile tablets Screen fitting. The Master Layouts Utilizes Font

Awesome Plug-in.

AutoMapper - object-mapper(OOM) was used for Mapping domain &

presentation models.

Autofac was used for Dependency Injection(DI).

Using Log4Net - Developed a generic Application logging system that

was used in the whole application for runtime activities logging.

jQuery 1.7 & jQuery UI 1.8 & Bootstrap & MVC WebGrid was used for

client scripting, validation and design controls.

Environment:Microsoft .Net framework 4.0, C#,ASP.Net MVC4 RAZOR,

EF5.0 ORM, Autofac IoC, WCF REST Methodology,Visual Studio 2012,,

Silverlight, jQuery, JavaScript, AJAX,CSS, DHTML, XHTML, DevExpress.

SQL Server 2008 R2.

Web Developer Freelancing August 2012 - Feb 2013

Using Photoshop CS6 & MVC4 RAZOR architectural pattern designed

developed and Implemented an enterprise accounting firm web portal

application for BesoCPA Firm Accounting . The Application contain

the Brand Logo designed using Photoshop Cs6 . The web portal contain

BesoCPA business Services as well as marketing theme of the company

history relationship with it's clients.

The following technical and methodologies were used in developing &

Implementing the BesoCPA Firm Accounting Application :

Environment:

Using Photoshop CS6 & custom Fonts Designed the Web Layout &

Typeface Graphics controls Design.

The application is designed following the current proposed industry

architecture, The Onion Architecture. Pushing the dependencies to be

from outer layer to core and not in reverse direction.

The Application Service layer Exposes Interfaces to the UI. That

means from data security point of view, UI have no direct access to

the domain layer.

The Domain model data service layer uses Entity Framework 5.0 & SQL

SERVER 2008 & it's only exposed to the Application Service layer.

The User Account Service Layer Handle's all the Security services

and it's only exposed to the Application Services.

The Views are Razor Render designed using MVC4 Utilizing Twitter

Bootstrap plug-in & bootstrap Responsive Library To help with The

Mobile tablets Screen fitting. The Master Layouts Utilizes Font

Awesome Plug-in.

AutoMapper - object-mapper(OOM) was used for Mapping domain &

presentation models.

Autofac was used for Dependency Injection(DI).

Using Log4Net - Developed a generic Application logging system that

was used in the whole application for runtime activities logging.

Environment:Microsoft .Net framework 4.0, C#,ASP.Net MVC4 RAZOR,

EF5.0 ORM, Autofac IoC,WCF, Log4Net, Visual Studio 2012,,

Silverlight, jQuery, JavaScript, AJAX,CSS, DHTML, XHTML, DevExpress.

SQL Server 2008 R2.

NASDAQ OMX,Marlboro, MA. Jan 2012 - July 2012

Senior .Net Application Developer

Using MVC3 RAZOR architectural pattern developed and Implemented

GlobalNewsWire Reporting System as a part of News Release &

Distributions Project In NASDAQ OMX..Reporting Services not only is a

critical check & balances on the distribution by the news wire but

also as a key determinate of ROI for the OMX customers. The key

delivery measures of GNW reporting project was: (i) Distribution-

Where the release was sent. (ii)Placement- Where Release was posted.

(iii) Views & Traffic - Who saw the release. (iv) Engagement- who

responded to the release.(v) Sentiment & Media monitoring - What are

people saying about the release and the Client Company.(vi)Business

Impact-Impact in key business meters such as stock prices.

The following technical and methodologies were used in developing &

Implementing the Global News Wire Reporting Systems :

By Using Service Oriented Architecture (SOA)WCF REST API was used as

the wrapper to the Business Model & Database Repository.

By Using ORM Framework NHibernate, The Business model & Database was

integrated and serviced by NHibernate Entity Framework.

Mapping domain entities to presentation models by Using

object-mapper(OOM),AutoMapper.

By Using Dependency Injection(DI) or Inversion Of Control (IoC)

Framework Castle Windsor Was Used to promote separation of Concerns

within all the projects.

By Using MVC3 RAZOR Architecture the easily modeled in mocking WCF

REST Service calls in the UI Controllers, while RAZOR View rendering

terminology was used.

GNW Reporting system Uses extensive charting & Visualizations quick

visual analysis by the OMX clients. MScharts, FusionCharts, Dundas

Charts were used While DevExpress was used for data Grid Controls.

MVC business models utilizing Controllers, LINQ to SQL & Entity

Framework 4.

Dynamic virtual filling Cabinets Selection service to the user based

on departments or clients business that is maintained through SQL

2008 Server.

On Client side Scripting Extensive use of JQUERY, MVC AJAX, &

JavaScript to process drill down charting mechanism.

Application logging for User Activities, Runtime Exceptions & Custom

Business Errors using ELMAH & Log4Net services to SQL Server 2008.

Environment:Microsoft .Net framework 4.0, C#,.Net MVC3 RAZOR,

NHebernate ORM, Castle Windsor IoC, WCF REST Methodology,Visual

Studio 2010,XML-XSLT, Silverlight, jQuery, JavaScript, AJAX,CSS,

DHTML, XHTML, DevExpress. SQL Server 2008 R2.

Freedom Imaging Systems.,Ann Arbor, MI. May 2011 - Dec

2011

Senior .Net Application Developer

Using MVC2 architectural pattern developed and Implemented a Record

Image Retrieval ASP.Net Web Application using:

MVC business models utilizing Controllers, LINQ to SQL & Entity

Framework 4.

MVC Form Authentication Security model to handle users login &

cookies for user profile persistence through IIS 7.5 & SQL Server

2008.

Dynamic virtual filling Cabinets Selection service to the user based

on departments or clients business that is maintained through SQL

2008 Server.

MVC Image rendering service for already Scanned documents through

RICAR (Record Image Capture And Retrieval) software suite. Document

Detail reside on SQL Server 2008 & Files are maintained through

Network Storage.

Document Image parsing and Conversation to PDF, PNG & TIFF format.

Extensive use of JQUERY, MVC AJAX, & JavaScript.

Application logging for User Activities, Runtime Exceptions & Custom

Business Errors using ELMAH & Log4Net services to SQL Server 2008.

Environment: Microsoft .Net framework 4.0, C#,ASP.Net,T-SQL in

SQL Server 2008(Store Procedures, & Custom Functions), Visual Studio

2010,WCF,WPF,XML-XSLT, WPF, Silverlight, jQuery, JavaScript,

AJAX,CSS, DHTML, XHTML, DevExpress.

CONSULTING Control Point Inc., Troy, MI. December 2010 -

March 2011

Senior .Net Application Developer

Vehicle Health Management System (VHMS) for Heavy Brigade Combat Team

DSESTS Data Viewer Version 2.0 (.Net. 4.0):

Implemented a distributed computing services of the DDV that are

provided by the Windows Communications Foundation (WCF). Through

WCF, the DDV 2.0 provides a number of service Endpoints. These

endpoints provide service contracts which expose a number of

functions and capabilities callable by the service's clients. The

DDV 2.0 utilizes the WCF capabilities to expose functions such as the

ability to query the SQL Server database for test data results and to

perform analysis, sorting, and filtering of the data. In addition,

when new data becomes available, remote consumers can inject the

newly collected data into the database and perform data analysis upon

the entire collection or solely upon the newly collected data. The

injection of new DSESTS test data into the DDV 2.0 database triggers

notification and events for subscribers and consumers of this data.

Implemented a Client Windows Form to Allow users to upload DSETS Raw

Files utilizing WCF Client endpoint service via WPF application that

runs on the server as WCF Host Service to SQL Server 2008.

Environment: Microsoft .Net framework 4.0, C#,ASP.Net,T-SQL in

SQL Server 2008(Store Procedures, & Custom Functions), Visual Studio

2010,WCF,WPF,XML-XSLT, WPF, Silverlight, jQuery, JavaScript,

AJAX,CSS, DHTML, XHTML, DevExpress.

CONSULTING Thomson Reuters Inc., Southfield, MI. July 2010 -

Dec 2010

Senior .Net Application Developer

Patent Manager Project (.Net. 4.0):

Converted Patent & Trademark Rule engine System from VB6 to a .Net

4.0 utilizing SQL server 2005 and oracle 11g.

Designed & Implement a C# Dynamic Interface that is used to execute

VBScript Code or Jscript Code during the runtime.

Environment: Microsoft .Net framework 4.0, 99% C#, 1% VB.Net,ASP.Net,T-SQL in SQL Server 2005/2008(Store Procedures, & Custom

Functions), Visual Studio 2010, XML-XSLT, WPF, Silverlight, jQuery,

JavaScript, AJAX,CSS, DHTML, XHTML.

Crest Mark Bank Inc., Troy, MI.

Jan 2010 - June 2010

Senior .Net Application Design & Developer

Windows Application Clients Invoice Project (.Net. 3.5):

Created Project technical design documents which was used by project

manager as well as customers.

Designed & Implemented clients invoice aging management report for

five Crest mark interstate locations in 5 different servers utilizing

runtime Linked Servers Utilizing SQL 2005 .

Designed & Implement an Interface web service between a vendor

software Factsoft and in house custom application to update client's

funds invoices changes in the factosoft application.

Environment: Microsoft .Net framework 3.5, 99% C#, 1% VB.Net, Windows

Form,ASP.Net,T-SQL in SQL Server 2005/2008(Store Procedures, &

Custom Functions), Visual Studio 2008, XML-XSLT, WPF, Silverlight,

jQuery, JavaScript, AJAX,CSS, DHTML, XHTML.

PageBeanLLC, New Baltimore, MI

Jan 2009 - Dec 2009

Senior .Net Application Design & Developer

Omacro Web Portal & ECommerce Project (.Net. 3.5):

Created Project technical design documents which was used by project

manager as well as customers.

Designed & Implemented Omacro Site Companies & Users Membership

through Representatives utilizing .Net Membership and Role

namespaces.

Designed & Implement a Newsletters function for Companies to Post

their Current general Newsletters.

Designed & Implemented User's Blog Forums function to Allowed users

to post products experiences.

Designed & Implemented Add Friends function to allow users to invite

other users.

Designed & Implement an Image Gallery Functions that's utilizes WPF

resources to Upload Images of type Audio, Video, Documents (excel,

PowerPoint Images(e.g. Jpg)

Designed & Implement a Product Promotion Functions to allow Reps to

Setup Marketing Programs either in buddle product or discounts.

Designed & Implemented Advertise function to allow Reps to Post

Banners of their Promotion Programs.

Designed & Implement Add, Close & Move RSS Widget in Drop things

format to allow users to customize their front end looks.

Designed & Implemented Messaging function to Allows users to receive

Emails of newly posted forums/Newsletters.

Designed & Implemented an Ecommerce with the following Functions:

Payment Service Provider Paypal API, AuthorizeNet API Services.

Tax Service Provider StrikenIron API Service.

Shipping Service Provider USPostal API, UPS API Services.

Download Provider through FTP Service.

Designed & Implemented a Product Rating Function to Allow Users to

Submit Polls for Product experience Ratings.

Designed and Implemented Product Detailed Attributes functions which

allow Reps to post product detail information. E.g. Category, Image,

Weight, height and so on.

Creating test cases for Unit, regression and users test cases.

Environment: Microsoft .Net framework 3.5, 99% C#, 1% VB.Net,

ASP.Net,T-SQL in SQL Server 2005/2008(Store Procedures, & Custom

Functions), Visual Studio 2008, XML-XSLT, WPF, LINQ, SUBSONIC, WPF,

Silverlight, jQuery, JavaScript, AJAX,CSS, DHTML, XHTML, Adobe

Photoshop CS3.

Allied Vaughn, MN

Jan 2008 - Dec 2008

Senior Technical Specialist

Supported Media on Demand (J2EE) DVD/CD Auto authoring and

Fulfillment system used by top-tier clients like Microsoft, Home

Depot and many others.

Developed and Implemented J2EE web service providers to accept and

respond to new XML Orders from Home Depot inc via Ariba Web portal

system.

Developed and implemented a Java Class program to create shipping

label for order shipping fulfillment.

Rapidly became debug and troubleshooting support in a short period of

time

Worked with many different technologies: JBOSS, Tomcat, Jython, SSL,

J2EE, JSP, JSF and Report Mill, DVD/CD robotics Burners, Barcode and

label printers

Used PHP, Jython, Oracle8i/10g, Java, SOAP and XML-RPC on Linux and

Windows platforms

Migrated data from Oracle8i to Oracle 10g

Designed and implemented a PHP, XML and CXML transformer programs to

receive orders from an eCommerce system Arriba and post to J2ee

system

Designed and implemented a batch Jython programs to transform

incoming XML orders, download contents and post orders in to a J2EE

system

Configured SSL on Linux environment in JBOSS 4.5

Installed and Configured Tomcat 5.0,PHP, ANT in the dev server

Successfully adapted the project to changing requirements.

Creating test cases for Unit, regression and users test cases .

Environment: JBOSS 4.5, Tomcat, Jython, SSL, J2ee, JSP, JSF, Report

Mill, PHP, Oracle8i/10g(PL/SQL Store Procedures), Java, XML, CXML,

Linux and Windows, SSL, ANT, Tomcat 5.0

Consultant at Nissan Motors Jan 2000 - Dec 2007

IT Specialist

Designed and implemented an intranet Asp.Net projects for tracking

CAD drawing, which is used by over 400 design engineers using

ASP.Net, C#,VB.Net, JavaScript & SQL2005

Designed and implemented a 2,700-hours hours intranet ASP.Net web

based cost saving proposal System, Using ASP.Net, C#,VB.Net,

JavaScript, SQL2005 & Oracle9i located in Japan.

Designed and Implemented a 2000 hours intranet web based Design &

Parts specifications

Part of Development to design and Implemented a Nissan Global

Purchasing using ASP.Net and IBM-Mainframe based System

Completed the analysis & design document, program specs, and test

plans

Worked with global resources on web based projects in design,

development & testing

Created the requirements document, assessment workbook, and component

based estimate for full assessment

Converted Parts tracking and report system from VB6 to VB.Net 2.0 win

form.

On call support & responsible for ticket queue system activities

Technical lead in setting up and configuring three intranet IBM blade

Web servers for development, quality and production environment.

Creating test cases for Unit, regression and users test cases

Environment: Microsoft .Net framework 2.0, VB.Net, ASP.Net, AJAX,

C#, T-SQL in SQL Server 2000/2005(Store Procedures, & Custom

Functions), JavaScript, VB Script, Visual Basic 6, Visual Studio

2005, CSS, DHTML, XHTML, Oracle9i, JCL, VSAM, Cobol MFS, IMS, DB2

Consultant at General Motors Jan 1997 - Dec 1999

System Engineer

Implemented mainframe-based Material Scheduling system (MSS/JST),

which is used by over seventy General Motors, plants worldwide this

uses Cobol MFS, IMS and DB2

Completed the analysis & design document, program specs, and test

plans

On Call support

Environment: JCL, VSAM, Cobol MFS, IMS, DB2

Skills Proficient in Object-Oriented Programming using C#,MS-DOS(Batch

Process), VB.Net, Java, XHTML, CSS, JavaScript,jQuery, ASP.NET, SQL

( Transact-SQL), LINQ.

Server Side Development Toolbox Client Side Development & Design

. Microsoft TFS Toolbox

. Microsoft Visual SourceSafe . Microsoft Visual Studio v8 thru

. MVC1 thru MVC4 Pattern Design v2012

. NUnit (Unit Testing, TDD) . XHTML, CSS, DOM, HTML5

. Autofac(Injection Of Control IoC) . Twitter Bootstrap User

Interface

. AutoMapper(object-mapper-OOM) (JavaScript) Plug-in

. WCF Endpoint Binding Services . Font-Awesome User Interface

. Data Annotations (Server Side Plug-in

Data . jQuery (JavaScript) Plug-In

Validation ) . jQuery UI Plug-In

. Microsoft SQL Server Management . jQuery Mobile Plug-In

Studio . knockout (JavaScript) Plug-In

. SQL Server 2000 thru 2012 . SPA (Single Page Apps using

. MySQL & Oracle Breeze

. Microsoft IIS 6 thru 8 MVC4 Web API)

. TortoiseSVN (for Subversion) . AJAX (RPC using JSON or XML)

. Photoshop cs3 thru cs6,

Illustrator, Flash

. Security (Form, Domain

Authentication )

. Jquery Data Annotations client

Injection

(using jQuery/Bootstrap/Knockout

-

Validation )

. Entity Framework & NHibernate

(ORM)

. TinyMCE (JavaScript Rich Text

Editor)

. Firebug (JavaScript Debugger)

. IE Developer Tools

Education Wayne State University

Bachelor of Science Detroit, MI

Information Technology

Activities Technical web forum & Code Sharing web Portal Membership

2005-Present

. TutsPlus (A huge Library of educational content of Web

Development, Graphic Design Motion Graphics & more)

. Code project(.Net developers Code Sharing & Technical forum site)

. StackOverflow(Technical forum sites for developers to share the

technical knowledge & ask any technical problem)

. Codeplex

Stanley Mwangi Page 1

Contact this candidate