SKILLS / SOFTWARE FAMILIARITY:

Languages & Programming : Microsoft Visual Studio (VB 6.0, VB.NET, C#, Interdev, ASP, ASP.NET), Cordova/PhoneGap, VBScript, VBA, HTML, CSS, XML, web services, C/C++, JQuery, Complete development cycle familiarity, SSRS, Crystal Reports, DB2Connect, SSO, SAML implementation.

Databases : SQL Server 2003+, Oracle, MS Access, UniVerse/UniData, Scalable SQL, Filemaker Pro, DB2

PROFESSIONAL EXPERIENCE:

Confidential, Frederick, Maryland

Head of Software Development (VB.NET/ASP.NET/C#)

Responsibilities:

• Plan, direct, and coordinate all activities associated with creating software across multiple functional areas and products.
• Prioritize and allocate projects, products, and resources with the assistance of architects and managers.
• Participate in the strategic decisions about technology, definition, and implementation of the software products.
• Plan, direct, and coordinate activities of a multi - team or cross-functional organization.
• Complete end-to-end solution for entering, managing, and completing underground and aerial cable installation jobs for the telecommunications industry. Processes include: mobile application (android/IOS) for entering a new job with photographic attachments and GPS tagging for cable path, automatic crew assignment, and automatic generation of dig-safe tickets with the state, automatic hourly dig-safe checking for completion/clearance. Automatic workflow routing of crews to site once dig-safe ticket is clear and in-the-field job closure mobile site. Includes reporting and invoice generation. Allowed for a ten-fold increase in the number of drops performed while reducing administrative headcount by two.
• Intranet app to maintain and track the status of communications equipment across warehouses and client sites. Replaced excel spreadsheets and emails, increasing accuracy and reducing administrative man-hours. Responsible for recovering over $50,000 in erroneous equipment back charges and preventing over $500,000 lost equipment charges in the first year of operation. Dispatch Call Management: Intranet app in .NET/SQL for assigning, tracking, and reporting on dispatch calls to technicians. Replaces whiteboards and excel spreadsheets.
• Geo-location tracking and finished project tagging for in-field technicians for web, iPad/iPhone and Android mobile devices. Shows dispatchers a real-time map of all assigned tasks and technician locations for routing purposes.
• Internal application to tie fulfillment, drops and construction businesses into a centralized accounting/payroll package to pay/invoice clients, contractors, and employees. Responsible for recovering approximately $130,000 in lost accounts receivables within 2 months of implementation.
• Nationally implemented end-to-end system written for Comcast (based on internally used Drops project mentioned above), utilizing handheld applications (via PhoneGap) and back-end data portals (.Net) for technicians to electronically order and schedule a cable bury job and track its progress. Emails customers, technicians and supervisors with job progress. Ties into Comcast back-end data to retrieve scheduled jobs, post jobs to Comcast's billing systems, and complete and cancel them within those systems. Sold to comcast for approximately two million dollars.
• Many counties in Maryland require that an ADC map and grid coordinate be provided with a dig ticket number. This required manual lookup in the physical ADC Map book. Replaced with an automated program that generated map and grid values from an online lookup, requiring no manual involvement. Saves approximately 120 man-hours per week (approximately $130,000/year) and reduced error rate to zero.

Confidential, Ashburn, Virginia

Senior Developer/Consultant (VB.NET/ASP.NET/C#)

Responsibilities:

• Performed maintenance and new development for EDA, OPM's electronic document viewer, used for the viewing and editing of investigative records and reports--VB.NET, C#, Stellent, Centera, ASP.NET, Javascript, AJAX, Web Services, Oracle.
• Refactored EDA from a long-latency single-threaded model to an asynchronous web-service model for document retrieval to remove the Stellent COM component’s single-threaded-apartment bottleneck.
• Assisted in transitioning EDA from a single-server solution to a load-balanced multiple-server solution.
• Assisted in fine-tuning IIS configuration settings for improved EDA performance.
• Developed several image-manipulation routines for Electronic File Release, including TIFF stitching, pdf to tiff conversions, and pre-fill of automated government forms (C#, Neevia DocCreator, activePDF). --VB.NET, C#, Stellent, Centera, ASP.NET, Javascript, AJAX, Web Services, Oracle, IIS.
• Performed troubleshooting and code-review for OPMs Field Document Release software—VB.NET, IIS, Web services.
• Evaluated and recommended the ANTS profiler for use in code optimization efforts—ANTS, VB.NET, IIS.
• Performed code changes and driver updates necessary to move the legacy bar coding software Oliver to Windows 7—Windows 7, VB.NET, BarTender, EntireX, MS Access, ACE drivers.
• Created an eDelivery extraction tool Extraction tool to allow field agents across 21 federal agencies to automatically extract and parse electronically delivered investigative documents --VB.NET, WinZip, XML.
• Assisted in the implementation of development best practices, such as having a dedicated build server, testing procedures, and good source control.
• Created numerous standalone utilities for OPIS-OPS to streamline operations, such as a 45-day report generator (detailing cases over 45 days old). These utilities took the place of labor intensive manual processes.—VB.NET, EXCEL, Oracle

Confidential, Dallas, Texas

Senior Developer

Responsibilities:

• Back end support and new development for insurancedeopt.com, and Autoweb (internal independent agent sales and support website)--VB.NET
• Mainframe/.NET interface programming via DB2Connect
• NADA data integration--MS Access, SQL Server, DB2/DB2Connect, VB.NET
• ACE Cash Express web services maintenance, VB.NET
• LexisNexis rate evasion data integration and reporting, VB.NET, SQL Server, Web Services
• Mainframe postscript to PDF conversion--Postscript, VB.NET, iText
• DB2 to SQL synchronization and maintenance (cities maintenance, down payments synchronization)--VB.NET, SQL Server, DB2/DB2Connect

Confidential, Addison, Texas

Senior Developer/Project Management (VB.NET/ASP.NET/C#)

Responsibilities:

• Took over all maintenance and new development of the Testing Automation Portal project, written in ASP.NET 2003. This is a web-based tool used to automate QA regression and compliance testing at client sites. Used by Fidelity Information Services for testing changes to software in their credit card division.
• Implemented improvements to the portal, by transitioning from a straight .NET implementation to a .NET/Ajax implementation. This allowed us to do behind-the-scenes updates and queries with AJAX without having to perform a complete page postback. One some screens, this reduced the response time of an action from upwards of one minute to 3 seconds per action.
• Stabilized the background Portal services, written in VB.NET 2008. The Portal relied on Windows services running on the server machine, and these were unstable, necessitating reboots and service restarts. After refactoring the services from the ground up, we went from receiving three our four trouble tickets a week to receiving none in the 4-month period after going live.
• After the services were stabilized, they were re-factored to take advantage of Web services, to eliminate the need for FTP servers and drop folders to route files.
• Wrote an OCR Template Generator and Service, in VB.NET 2005 as an add-on for Confidential 's Medical Banking application. This software uses the Nuance license to automate the creation of electronic documents from medical Explanation of Benefits forms. The previous template service was complicated and technical, causing higher-salaried personnel to analyze an EOB and input target criteria by hand, a process that took between 15 to 20 minutes per template. The new version I wrote uses a simple point and click interface which allows for lower-salaried non-technical people to perform the same function in approximately 3 to 5 minutes.

Confidential, Denton, Texas

Senior Developer/Project Management (VB.NET/ASP.NET)

Responsibilities:

• Headed up the team responsible for evaluating and testing 32-bit Dossier for company-wide migration.
• Saved the company over $70,000 in my first 120 days by writing a Data Reporting tool using Report Sharpshooter and ASP.Net to provide on-demand reporting for our Dossier software database (Dossier is a vehicle fleet management tool). This saved the company $2000 per license for at least one license at every one of our 35 division locations. This ability for divisions to perform their own on-demand reporting freed up two employees in the Mechanical department to perform other functions. Sending various reports to the various divisions took up a large portion of their work day.
• Rewrote the entire PHP/PERL based intranet system to work with ASP.Net and Microsoft Share Point Services.
• Wrote a VB.Net discrepancy reporting tool that pulled data from Active Directory nightly, using LDAP and VB.Net, to find servers and machines with improper groups, permissions, and roles in AD.
• Wrote an ASP.Net application to allow for a one-stop user entry tool which added users to our Active Directory domain; Exchange mailboxes; our Billing Calculator, Customer Service, and iVantage Online applications; and set up AD permissions and login scripts based upon the division and department that the user belongs to. Most user data is pulled from our HR software, iVantage, preventing double-entry mistakes, and allowing for faster and more accurate login creation.
• Performed Data Analysis and “what if” scenarios for company-wide financials, to determine the billing impact of moving to a 10-hour day, changes to rounding rules (by the hour or by the job), etc. This involved marrying large amounts of data between two incompatible legacy systems, before analysis could be performed.
• Wrote division-specific marquee-style data displays in ASP.Net and XML, for 54” training room monitors, so that the monitors could provide a useful service while not in use for training.

Confidential

Senior Developer/Project Manager

Responsibilities:

• Responsible for adding new functionality to both business applications. Projects included: Updating the entire Client accounting database schema and GUI, adding functionality for a new company—RN Demand, allowing deletion of clients, and providers. Added automated notes to accounts whenever a recruiter makes a change to that account, allowing invoice printing and posting by geographical region, allowing for different pay periods by geographical region, among others.
• Responsible for monitoring answering software-related support email boxes, fixing software errors, and returning emails.
• Created reports for production and accounting in Crystal Reports.
• Responsible for moving inline VB SQL from the MHACS application to SQL Server stored procedures.

Confidential, Irving, Texas

Lead Analyst

Responsibilities:

• Debugged, analyzed, and developed new code for customer service software (named UCSS) deployed on several thousand workstations in the US and India. Developed on VB6 and Oracle.
• On-Call emergency pager rotation, responsible for analyzing and repairing global-wide problems with UCSS
• On the core development team responsible for the UCSS implementation of Thank You rewards
• On the core development team responsible for converting UCCS to be compatible with the legacy Sears PEGA system, when Citi took over the Sears cards business.

Confidential, Houston, Texas

Senior Developer/Project Management

Responsibilities:

• Authored the CECA Supply & Services SMS (Sales Management Solution), a complete data entry, reporting, and workflow solution to automate the day-to-day data entry and tracking for a multi-national supply company. Written in VB 6.0, Microsoft SQL Server and Crystal Reports 8.5.
• Re-factor the software used to enter, view, and print the required material test reports for all valves the company produces. Technologies used: ASP, VB Script, Java Script, Cascading Style Sheets (CSS), XML, ADO & MS SQL Server, Transact SQL (T-SQL), Stored Procedures, Views, and creating and scheduling Data Transformation Services (DTS) packages. This is a migration from a single-user tool which used Dbase IV to a multiuser ASP web-based tool.
• Authored the PennPoint Data Viewer commercial software, which allows viewing, querying, and charting well data stored in the P3 Data model. Also has an extremely flexible exporting feature that allows the user to make export templates for a wide variety of formats. Also responsible for help files and user documentation (VB 6.0, Access).
• Data Leech—automatic web-based well header and production data capture for the states of Wyoming and Colorado, using .NET. Can grab approximately 80,000 aggregate well years of data in a single day. This represented the work previously performed by a team of data entry personnel (VB 6.0/Access/Oracle) over the course of a month. (VB 6.0, Access, .NET)
• Automated EBCDIC-ASCII conversion routines—moved Texas Railroad Commission data in EBCDIC format to the ASCII format used by desktop PCs. Prior to this software, a consultant company was considered to perform conversions on a monthly basis, at a cost of approximately $12,000 per conversion. (VB 6.0, Oracle)
• Chart2001—merges, sums, and charts well production in multiple Access databases for QA analysis (VB 6.0, Access)
• Created QA tracking tool (ASP, XML)
• Mentored junior programmer in VB and databasing routines.