SUMMARY:

• 10+ years of progressive experience in Software Development.
• Strong SQL Server experience: SQL Query Design, SQL Query Optimization and database design, ETL, Stored Procedures, advanced queries, SQL Jobs, SSIS, SSRS, CDC and Administration.
• Extensive experience (over 8 years) in C#, .Net to write tools, test harnesses and automation, create and maintain web sites using ASP .Net and MVC programming
• Solid experience writing test plans and test cases.
• Passionate about data, technology, & creative innovation
• Always will dig out teh best solution, especially when teh requirements are ambiguous.

PROFESSIONAL SKILLS

Expert: SQL, C#, .Net, XML, ADO

Intermediate: Test Automation, ETL, HTMLJavascript, ASP.NET, OOP, TFS, AgilePowerShell, Performance Tuning, Entity Framework, Test Tools, Linux, UNIX, Multi - Threading

Some Experience: Web Services, Design Patterns, Data Structures, MVC, Java, C++, Perl, UML, GIT, Oracle

Exposure To: Azure, Tomcat, JSP, Jquery, Knockout, JDBC, Soap, Hibernate

Platforms: Windows 10, Server 2K12Linux, UNIX

Azure: Most Recent

Test Tools: WTT, VSTS, N-Unit, QTP, ChartFX, Perfmon, Coded UI

Source Control: CoreXT, Source Depot, TFS, VSO Clearcase, Perforce,Subversion, GIT

PROFESSIONAL EXPERIENCE

Confidential

Software Design Engineer in Test

Responsibilities:

• Automated teh Bing Transit pipeline process which took agency routing and trip feeds in General Transit Feed Specification (GTFS) format and transformed into binary files which are read by teh web site to provide customers wif travel options given trip coordinates using SQL Server 2012/14, C#/.Net and Powershell, taking a very manual process only understood by teh developer whom I replaced to a reliable mostly automated state now familiar by many members of teh team.
• Reduced feed data errors by 99% by troubleshooting issues wif specific feeds generating fixer queries
• Wrote automation to copy files and backup/restore SQL databases and make calls to teh application to process teh extracted data.
• Maintained an extractor application that transformed XML from UK agencies using C# and SQL server into GTFS format.
• Used SQL Azure to run tests and load data into a test environment on Azure virtual machine.

Confidential

C#/SQL SDET

Responsibilities:

• Delivered a simulation of processing Index data based on financial indexes that were not being bought out by teh London Stock Exchange as part of Separation agreement written in SQL/Server 2012, SQL CDC and ETL involving a multi-step SQL job to test teh daily feed process for about a week of old data used to verify iterated changes.
• Validated SQL Schema changes in an iterative fashion in C# by pulling together files and SQL data structure to compare data base configurations before and after teh refactoring
• Worked wif Git, configured wif Jira to manage test cases and source control of files wifin teh project.
• Reduced teh time for Live Site Review team to spot issues by 30% by providing a periodic report based in SQL Server writing SQL Stored Procedures and Views involving queries using CTE’s, Pivoting, and Aggregation to support tabular reports and graphs using Excel charting in very short order
• Reduced aggregation calculation time by 50 % using period based fact tables.
• Upgraded ingestions in C# to pull records from VSO and other SQL databases into teh reporting database using TFS wif respect to Source Control and management of Work used by teh Live Site Team.
• Used SD to interface wif Autopilot.
• Delivered test automation and tools for High Security Signing Application wif Powershell, C#, SQL, Entity Framework, XML, JSON to analyze job errors, generate certificate from database, analyze job runs, ingest data, submit jobs to sign multiple file types assuring no piracy of software, manage services, upgrade applications, run deployments, performance and stress tests
• Applied debugging skills using SQL, IIS, Event Logs and PowerShell
• Worked wif TFS wif respect to source control and management of project tasks.
• Converted 100% of Wind Data Station retrieval system using attachment files from incoming emails to Exchange Web Services 2010 format from 2003 version using SQL Server, C#, XML, .Net, Exchange Web Services, Excel, Reducing teh in-box size by over 90 % by moving messages to predetermined folders based on error situations and history leaving accurate recent information.
• Upgraded On-call area application in an ASP.Net MVC4.0, SQL fixing bugs, updating web forms, improving middle tier, and using TFS for source control.

Confidential

SQL/Java Developer

• Developed administration tool website & designed database using Java (first professional use) wif teh MVC design pattern Spring security, Hibernate and JDBC database interfaces, rendering on JSP pages into HTML.
• Enhanced Email Marketing Applications in SQL, .Net, XMl, ETL, Excel to Add 50 tests, monitor 1000 files being posted, generate 100 test cases from data, and maintain SQL based system and to migrate SQL data.
• Maintained and enhanced Customer Lookup and Reporting applications and their associated Administration applications using C#, ASP.Net 4.0 performing bug fixes and other assigned tasks. Teh code interfaces wif SQL Server 2000/2005/2008 database and SAP. Learned interfaces that called for SAP data, security logins, and web user information on an outside system.
• Converted classic ASP code that Searches for and shows Device Information into ASP.Net to set up a Confidential Dot Net Nuke site, organized into ASP.Net modules (.ascx files) using C# and JavaScript wifin VS 2010 while interfacing wif an Oracle 11 database, from which I used TOAD to compose queries and analyze teh data involved and IIS 7 to host.
• Maintained and enhanced ASP.Net 2.0 (C# and JavaScript) Mobile Device Checkout, Reservation, and Management System including a SQL Server 2008 back end hosted in IIS 7, including E-Mail notifications.
• Wrote test automation to simulate teh most important tasks.
• Updated an existing ASP.Net 2.0 application wif a SQL Server 2005 back end in very short order to render three new questionnaire style forms which score travel agent's activity.

Confidential

MSG SQL/C# SDET Developer

Responsibilities:

• Worked all aspects of SQL Server 2000/2005 including designing metrics reports wif SSRS, administration, table design, writing complex T-SQL queries, SQL Functions and Stored Procedures, SQL jobs, and SQL administration using Product Studio and Source Depot in support of a major web service, which provides solutions for crashes involving Windows applications. Wrote C# tools to convert SQL data and perform unit testing.
• Used teh SSIS Extractor to load data from external data sources into teh working database
• Updated SQL test automation, delivered test harness in C#, SQL generating Web Service API’s
• Archived large SQL databases by switching out table partitions for large tables wifin teh database.
• Automated IssueNet ticketing system UI wif Manu test tool
• Programmed wif C#, SQL 2005, XML, ASP.Net, .Net 2.0, ADO, Perforce, Linux
• Wrote Object Orientated Test Automation wif Reflection for gaming web site messaging system.
• Developed ASP.Net Reporting page wif IIS to report test results

Confidential

SQL Development

Responsibilities:

• Developed test automation and Object Orientated applications in C# & SQL Server 2005 using Product Studio, Source Depot, and WTT. Used teh SSIS Extractor to load data from external data sources into teh working database.
• Built harness verifying migration of documents into a secure document management system and text to XML parser.
• Drove changes to N-Unit driven test automation infrastructure to consolidate security and unbox teh account objects. Built XML generation tool to drive test automation. Built Multi-Threaded harness to verify proxy servers.
• Drove automation to add and reset WTT jobs wif applications in C# and XML, supported web service application.
• Designed Testing Database and agilely built its UI for data entry using Winforms and Agile methodology wif VSTS.