PROFESSIONAL EXPERIENCE:

Confidential

.Net, SQL Server Developer

Responsibilities:

• Migrated web services to Azure Cloud to increase reliability of Confidential dealership display units
• Reduced latency of changes to Confidential dealer display systems from 24 hours to one hour.
• Reduced cost of Azure infrastructure from $5500+ a month to under $1500,
• Devised methodology to allocate cloud expenses to appropriate project silos and general ledger accounts.
• Debugged and Updated Confidential dealership marketing hierarchies in SQL Server and Onyx subsystems.
• Created cloud based worker roles to interact with third - party web services to build Cloud-based accessory XML database compatible with Confidential dealer systems.
• Modified onsite ERP system workflows to include scheduling, notification, and reporting of appointments to verify readiness for equipment installations
• Used analytics to report uptime, sessions, and versions of Confidential onsite marketing systems.
• Designed Service Maintenance database so Confidential could query service recommendations based on time or mileage.
• Negotiated with Microsoft to move from "Pay As You Go" model to Enetrprise agreement for cloud services.
• Architected and developed Confidential 's October Car Care Sweepstakes campaign including database modeling, web roles, and reporting

Confidential

.Net, SSIS/ETL Consultant

Responsibilities:

• Refactored ETL packages (SSIS) for populating public facing member services portal
• Created RESTful services for managing member contact information
• Refactored SQL Server 2012 database for new functionality.
• Authored stored procedures for obfuscation of sensitive data
• Created data structures to support SSO (Single Sign-On) functionality
• Created data structures to support White-Labelling of member portal.
• Debugged production issues for MVC5 based Member Portal
• Created new views, models, and controllers for MVC5 based Member Portal
• Served as Scrum Master for Member Portal team
• Modified error-logging library for the enterprise to provide more detailed information for error mitigation
• Served in both Business Intelligence and .Net development teams

Confidential

BI ETL Consultant

Responsibilities:

• Obfuscated data from Oracle database from Confidential to provide test data for Moody’s Risk management suite using SSIS
• Monitored and debugged AutoSys task management jobs
• Worked with Moody’s team to upgrade Confidential ’s Enterprise Risk Management product instance
• Modified Oracle packages, tables, and stored procedures for new Risk Management functionality

Confidential

Systems Analyst Consultant

Responsibilities:

• Served as ombudsman between Computer department technical staff that was resigning as a group and management
• Prepared transition documentation for incoming staff, locating and documenting connections, source code, and all relevant information to ease the transition
• Documented customizations to Dynamics AX for company’s ERP system

Application Developer II

Confidential

Responsibilities:

• Supported and maintained company’s existing C# and VB.Net applications
• Created and maintained intranet ASP.Net web sites for enterprise
• SharePoint 2010 Pilot Program
• Created employee information database with Restful Service interface for application integration and standardization of employee data
• Developed SharePoint site for managing contract requests for the enterprise using SharePoint 2010 State Machine workflows
• Developed ETL packages for maintaining Active Directory and synching it with Employee onboarding applications
• Created and maintained Data Marts for Census, Labor, and AR systems for clients
• SSRS Reports
• Utilized SSIS to connect to DB2, Oracle, SQL Server 2005, 2008,2010,2012, flat files, Excel, SharePoint Lists
• Optimized queries supplied by third party vendors to improve speed
• Automated provisioning for Provider Trust using SQL Server Change Data Capture
• Created corporate Taxonomy and event receivers for tagging documents with location based on corporate hierarchy so all pertinent documents for a branch, region, area, or line of business could be retrieved as a group.
• Setup of databases using Red Gate technology

Confidential

.Net Consultant

Responsibilities:

• Performed evaluations of approaches for retrieval and display of part genealogy
• Created ASP.Net 3.5 & JQuery application to securely retrieve information using VB.Net
• Performed transformation of data for Excel exports
• Application retrieved and displayed data at a fraction of the time of previous application

Confidential

ASP.Net Consultant

Responsibilities:

• Replaced third party vendor systems for viewing operator’s guides for their products ASP.Net with Internationalization
• Database (SQL Server 2008) Modifications for Lead Management to allow for new business rules
• Architected, developed both database and .Net front end for Master Dealer Program using VS 2010, .Net 3.5 C#, SQL Server 2008, SSRS, SSIS, and JQuery.
• Integrated .Net programs with ARI and ShopATron API’s.

Confidential

.Net Consultant

Responsibilities:

• Architected prototype for Confidential Project involving auditable managed-file transfer for negotiation of rebate agreements.
• Integrated Sterling Commerce’s Managed File Solution with .Net using C#, Web Services and MSMQ
• Used JNBridge for Java and .Net interoperability
• Developed Prototype for presentation at national conference
• Lead Developer for Confidential project
• Debugged environment issues with WCF implementation and Trust relationships
• Developed data model for managing trading partner relationships
• Advised company in TFS implementation
• Developed Mapping solution for Trading Partner integration
• Developed ETL SSIS packages for brand-family pharmaceutical selection

Confidential

.Net Consultant

Responsibilities:

• Fixed problems with business reporting Crystal Reports infrastructure
• Developed solution for continuous monitoring of B2B operations involving largest nationwide retailer involving Remedy .Net API.
• Designed reporting solution against Microsoft Dynamics infrastructure

Confidential

Business Intelligence Consultant

Responsibilities:

• Served as Business Intelligence Analyst, gathering requirements performing feasibility studies.
• Constructed SSRS and ComponentOne reports for both OLTP and Data Warehouse databases.
• Provided Business Analysis and reporting support for management decision making
• Constructed and maintained SSIS packages for Data Warehouse loads
• Constructed SSIS ETL packages for EDI import including FTP transfer, Encryption and auditing capabilities
• Designed tools in C# & ASP.Net 3.5 for documenting object oriented databases.
• Designed tools for SSRS metadata discovery
• Created framework for user editable form letters to reduce IT staff involvement in document changes using Microsoft Word Automation.
• Created utility in C# for generating SSIS 834 & 835 data feed packages programmatically.
• Designing SSAS cube for Call, Issue, and Task Management and performing database refactoring to achieve that end
• Maintained Visual Studio Team Foundation Server projects and mentored staff on use.

Confidential

.Net Consultant

Responsibilities:

• Performed WCF Implementation audit and best practices recommendations for client.
• Performed classified security sensitive work

Confidential

Staff .Net Consultant

Responsibilities:

• Performed Systems analysis for the proof of concept. Gathered requirements and created UML diagrams.
• Architected solution with novel approach using Microsoft “Building Blocks” technology so solution could be contained within Microsoft Office.
• Mentored and assisted junior developer in user interface design.

Technologies Used: Microsoft Visual Studio Team System, Visual Studio 2008, C#, Visual Studio Tools for Office, OpenXML, VB, LINQ, ASP.Net 3.5, AJAX

Confidential

Responsibilities:

• Was responsible for enhancements and maintenance of the multi-tiered web application. This application is used throughout the enterprise to define, manage, and track marketing and distribution goals.
• Worked on the application in both the distributor and retail-chain marketing areas.
• Worked with Business and Systems Analysts using SCRUM project management methodology to confirm priorities of requirements and establish the backlog of work for sprints.
• Developed new functionality allowing general managers to revise budget targets for national and local promotional programs.
• Developed UML diagrams to confirm business entity and data layer designs for developing ASP.Net pages and stored procedures.
• Developed a program that replaced a manual Excel based budgeting process with a data-driven Crystal reports approach. This provided the business with increased speed in processing budgets and uniformity of reporting to management.

Confidential

Responsibilities:

• Worked remotely with field staff to gather requirements for new functionalities.
• Added functionality to provide for better estimation of overtime cost expense.
• Fixed existing bugs in the application which overwrote historical data.
• Added capabilities to store multiple price lists by modifying the data structure and associated stored procedures.
• Moved reporting out of Microsoft Access to a dynamically generated Microsoft Office Document.

Technology Used:C#, AJAX, SharePoint 2007, Telerik RadGrid Controls, Crystal Reports 11.5, ASP.Net 2.0, ASP.Net 3.5, HTML, CSS, JavaScript, SQL Server 2000, SQL Server 2005, SQL Server 2008, Web Services, Windows Forms, Visual Studio Unit Testing, SCRUM, XML, XSLT, SharePoint 2007, Visual Studio Tools for Office 2007, OpenXML,, Microsoft Visual Studio Team Server 2005, Sparx Enterprise Architect 7.0

Confidential

EXACTA STAFF ANALYST

Responsibilities:

• Upgraded ASP.Net . application to 2.0 with AJAX and VB.Net
• Generated new pages and Crystal Reports to according to new business requirements
• Modified data layer to use new, Net 2.0 capabilities.
• Wrote and modified SQL Server 2000 stored procedures.
• Converted DynamicPDF reports to Crystal Reports.
• Dynamically generated Microsoft Office documents using XML/XSLT.
• Implemented “Google Suggest” like controls.
• Worked with end-users to gather requirements, perform systems analysis and architect application for managing salesmen performance and forecasting.
• Converted an Access Application to ASP.Net 2.0 and VB.Net
• Converted Access reports to Crystal Reports
• Added Copy Protection capabilities to Windows .Net application
• Developed DTS packages for moving data from legacy systems to new database.

Technology Used: VB.Net, ASP.Net 2.0, HTML,AJAX,CSS, JavaScript, Crystal Reports 11, SQL Server 2000, Web Services, Windows Forms, AGILE, XML, XSLT, Visual Source Safe 2005, Infragistics, Dynamic PDF, Microsoft Ajax Control Toolkit 2.0, AutoSuggestBox

Confidential

Application Developer

Responsibilities:

• PLQuoting was a public facing online program used for insurance agents to submit quotes to General Casualty.
• Added Ajax capabilities to ASP.net application using Telerik Ajax controls
• Merged codebases to align different development branches
• Debugged Rules Engine conflicts
• The Interchange project linked the PLQuoting project to third party insurance quotation (ACS) applications.
• Created XML Transfer package to convert mainframe processed data to PLQ compatible data
• Created Unit Tests to insure program functionality maintained.
• Served in MergeMaster Role to align codebases with different development branches.
• The QTP Pilot project marked the initial implementation of automated regression testing utilizing the Mercury Quick Test Professional suite.
• Served as technical lead for Mercury Quick Test Professional pilot program
• Authored and instituted best practices for Web Regression Testing
• Trained Staff in the use of Mercury QTP
• Served on the Build and Configuration Team.
• Coordinated migration of code to test and model environments
• Constructed Virtual Build Labs to isolate different development teams
• Served on team to migrate code

Technology Used: C#, ASP.Net 1.1, HTML,AJAX,CSS, JavaScript,, Telerik, Crystal Reports, SQL Server 2000, SQL Server 2005, DB2, MSMQ, Web Services, Windows Forms, NUnit, AGILE, XML, XSLT, QTP, Rules Engines, Subversion, CruiseControl

Confidential

.Net Consultant

Responsibilities:

• Served as a consultant to the LabWorks project, a project estimating and quoting system linked through Web Services to the company’s mainframe.
• Developed middleware for transferring data from Win forms application to AS/400 application using Web Services
• Created reports using Crystal reports
• Integrated As/400 application with .Net MSMQ application
• Developed framework for notifying users of quote readiness through Web Services and MSMQ
• Added encryption to secure proprietary application for providing physical document security for government and healthcare companies

Technology Used: Visual Studio 2005, Crystal Reports, MSMQ, Web Services, SQL Server 2005, ASP.Net 2.0, Visual Source Safe, C#, VB, Classic ASP, Rijndael AES Encryption