SUMMARY:

• Sr. .Net Developer adept at application development, testing and optimization. Excels at .NET application development, both Windows and Web Development, including coordinating ground - up planning, programming and implementation of core modules.
• Interface design, functional development, and implementation. Steven has experience in all aspects of the developmental life-cycle including design, development, testing, and deployment.
• Proficient with both Win Forms and Web Forms.
• Proficient in Microsoft .NET environments and architectures (up to and including .Net 4.6) using VB.Net, WPF, ADO.Net, WCF, ASP.Net, AJAX, T-SQL, MSSQL, SSIS/ETL, ORM, SSRS, JavaScript, and CSS/HTML.
• MS-SQL and T-SQL expert and database design including SSIS (extract, transform, and loading of data from one system to another) and SSRS (reporting services, both as web service and as functionality within an application).
• Web Services using XML, WCF, and Microsoft Dynamix Great Plains.
• Experience in using cloud/Azure systems.
• UI WPF experience.
• Have experience in using WCF for consuming web services.
• DLL Library design
• Innovator and team leader.
• Active Directory knowledge
• Microsoft Dynamics Great Plains experience.
• SharePoint experience.
• Lead Sr. .NET Developer for major upgrades to ERP systems including check files for AP, transfer of invoices from rental system to ERP, WIP reports, and General Ledger reports.
• Lead Sr. .NET Developer for enhancement to Fixed Asset System.
• Development of new functionality as well as solutions for existing functionality shortcomings for business systems.
• Updated and Re-Designed several internal tools to current software standards which automated mundane tasks for accounting department.
• Managed access and development of multiple financial reports in MS-SQL Reporting Services.
• Managed and reported security access to ERP systems for SOX compliance.
• Integrated systems between multiple international locales.
• Web-based multi-tier inventory and invoicing system.
• Major migration project of company data and budgeting system from MS Access/Excel to MSSQL and ASP.Net based system.

PROFESSIONAL EXPERIENCE:

Sr. .NET Developer

Confidential, Houston, TX

• CSAT is the lead provider of warranty-covered repairs for Apple/Macintosh, Dell, Lenovo, Motorola and other smaller entities.
• Steven’s primary responsibility was lead programmer for major enhancements and maintenance of the CSAT Apple Repair and Workflow system (“GP Web”). Programming was done primarily with VB.Net and ASP.Net and included a primary backend database of MS-SQL. Connectivity and CRUD functionality was accomplished using ADO.Net.
• Web-based application/system using HTML/CSS and javascript.
• Development of new functionality as well as solutions for existing functionality shortcomings for business systems. Resolve issues with Microsoft Dynamics Great Plains web services.
• The existing system is an ASP.Net/Javascript web application using VS 2017, Apple FileMaker 15, and MS-SQLServer 2012/2016.
• Development was done using databases located in Azure. The process of moving all production databases to Azure was begun.
• Initial planning involving the use of MVC as object relational mapping (ORM) platform.

Sr. .NET Developer

Confidential, Houston, TX

• Sr. .NET Developer for major enhancements to CRM systems including jobs, budgets, proformas, and invoicing.
• This involved maintenance and enhancements to an existing system which is an ASP.Net/Javascript web application using VS2008, HTML/CSS, javascript, SharePoint 2010, and SQLServer 2008R2.
• The primary development language was VB.Net.
• It also involved designing and development for implementation of a new system using VS2015 (ASP.NET, MVC, VB.NET, JavaScript) web development, interfacing with SharePoint 2016 and SQLServer 2012.
• Included a re-design plan to overcome ORM shortcomings.
• Managed Team Foundation Services 2015.
• Designed system to be used for tracking Change Requests (CR):
• System was designed for tracking CR, bug fixes, and enhancements using a winform desktop application in VB.NET 2015 and MS-SQL 2012 database.
• System was designed to track requests, documentation, what system/module was impacted, what forms and back code (JavaScript and VB.NET) were impacted, what tables, views, triggers, and stored procedures for which database were impacted.
• C ompleted codifying current and past CRs.

Sr. .NET Developer

Confidential, Houston, TX

• Updated and converted multiple applications which bridged three systems: E2 (manufacturing and accounting), RTMS (rentals), and MACOLA (fixed assets). This involved updating old applications designed with VB.NET 2008 to VB.NET 2015. The primary programming language was VB.Net, using winforms, vb class development, and ADO.Net for CRUD functionality.
• Lead IT Software Manager for a major upgrade to the ERP system (E2 v7 to v8.1). This involved:
• Validation of table structures and data definitions, migration of data from SQLServer 2008R2 to SQLServer 2012.
• Review and synchronization of ORM between data objects and code objects.
• Re-design of interfacing programs, including check files transfer application for Accounts Payable, transfer of invoices from rental system to E2, WIP reports, and General Ledger reports. This involved redesign using VS2015 including VB.NET, some C#, ADO.NET, and SQLServer 2012 databases and Reporting Services (SSRS).
• Lead project manager for enhancements to Fixed Asset System.
• Updated and Re-Designed several internal tools from VB.NET 2008 to VB.NET 2015 bringing current software standards which facilitated automation of mundane tasks for accounting department.
• Managed access and development of multiple financial reports in MS-SQL Reporting Services 2012. These reports were utilized free-standing as a web application from MS-SQLServer, and as a control used in WinForms from the main application used by Amega-West.
• Initiated research of using SharePoint as a reporting and presentation platform.
• Managed and reported security access to ERP systems for SOX compliance.
• Led project to integrate systems between multiple international locales (US, Canada, and Singapore).
• Outlook add-in to transfer e-mails and attachments to a 3rd party database platform. (Contract thru Robert Half Technologies) (WinForms, Excel, ORM)
• Inventory and shipping system utilizing bar code scanners and wireless system with SQLServer/VB platforms. (Contract thru Robert Half Technologies) (WinForms, WPF)
• Web-based enrollment and invoicing system for natural gas retailer using MS C# and MS SQLServer 2005. (Contract) (T-SQL, WinForms)
• Web-based, multi-tier inventory-tracking, and invoicing system using Microsoft Visual Studio (VB/ASP.Net) and MS SQLServer 2005. (Contract) (HTML/CSS, javascript, T-SQL, SSRS, ORM)
• Multiple small company websites. (Self-Contractor) (HTM/CSS, asp.net, vb.net)

Sr. .NET Developer

Confidential,Houston, TX

• Design/Development/Administration of various intranet, winform, and .NET web applications. Original version was developed with VB Classic and then converted to VB.Net. This required CSS/HTML, javascript, vbscript, SSIS/ETL. Backend development used MSSQL Server and Oracle. Applications included:
• System that gathers sales, payroll, and customer information from 61 stores and condenses data into a summary warehouse and reporting to individual store managers. (ETL, ORM, T-SQL, Crystal Reports)
• System that has portals for input from individual store and corporate personnel, gathers, analyzes, and calculates data for an annual budget with $1.5 billion in revenue and quarterly updates. (SSIS/ETL, ORM, T-SQL, Oracle, javascript, ORM, asp.net, vb.net, Crystal Reports)
• Development of high-volume point-of-sale transaction transfers from store Courtesy Booths to American Payment Systems and Western Union. Daily volume averages over 12,000 transactions per day. Utilizes multi-threading and an early-warning system to identify failure of transaction transfers on store-to-store basis. (SSIS/ETL, T-SQL)
• On-line system for various departments to track surveys, store checklists, and employee evaluations for scorecards. (CSS/HTML, javascript, T-SQL, SSRS, Oracle, ORM, asp.net, vb.net, Crystal Reports.)
• On-line system for stores to report to the central scanning department discrepancies of UPC codes and pricing for deliveries by vendors to stores and warehouses. (CSS/HTML, javascript, T-SQL, Oracle, ORM, asp.net, vb.net)
• On-line system for Fiesta Bakery Commissary, Fiesta Stores with a Bakery, and Fiesta Stores without a Bakery to interact and order bakery product for customer purchase. Details include ordering, delivery schedules, truck routing, production requirements, invoicing, accounting, and shrinkage reports. (CSS/HTML, javascript, T-SQL, SSRS, ORM, asp.net, vb.net)

Project Leader/Developer

Confidential,Houston, TX

• Design, development, and maintenance of Campaign Information Management System (CIM): CRM for the benefit of account managers of annual $60 million fund-raising campaign. (Developed with VB6, T-SQL, and WinForms.)
• Program expanded to include a reporting system, schedule management, and summary data management modules. (SSRS and Crystal Reports)

Accounting System Consultant

Confidential,Houston, TX

• Part-time consultant for the development of customized reporting tools using Visual Basic and MS Access as interfaces to MAS-90 and Great Plains Business Works accounting products for customers of IFS. (Crystal Reports)

Software Engineer

Confidential,Houston, TX

• Primary development tools included Visual Basic classic, various 3rd party components, MSSQL, and Crystal Reports. (VB6, T-SQL, WinForms, Crystal Reports).
• Lead programmer for intra-system financial accounting, general ledger reports, and retail billing modules.
• Major areas of development included Gas Accounting, Financial Accounting (AP AR), GISB, General Ledger Reports. Check Writer, and Retail Billing.
• Served as a consultant for design and support of custom File Transfer interfaces for Altra customers.
• Utilized SQLServer, Oracle, and Sybase as data back ends.