Senior Programmer / Database Developer Resume
OBJECTIVE:
Developer with over 15 years of experience working a broad range of technologies and projects with excellent problem solving skills. Interested in a position that is challenging with longevity where these skills can be applied.
TECHNICAL SKILLS:
- C#
- ASP.NET MVC
- ASP.NET Web Forms
- Bootstrap
- Windows Forms
- Microsoft Entity Framework
- Visual Basic
- FoxPro
- Perl
- TSQL
- ASP
- ASP.NET
- VB Script
- Ajax
- JavaScript
- SQL Server
- MySQL
- MS Access
- COM+
- IIS
- .NET Remoting
PROFESSIONAL EXPERIENCE:
Confidential
Senior Programmer / Database Developer
Responsibilities:
- Daily activity at BBSI will require moving between one project to another. A project might use new technology, but you may find yourself working on a legacy application. The position requires you to where many hats and have the ability to jump in head first.
- Technologies: C#, Microsoft Entity Framework, WCF Services, Windows Services, Microsoft SQL Server, TSQL, ASP.NET MVC, Web Forms, Windows Forms, JQuery, Ajax, AngularJS, Bootstrap, SSIS, SSRS and Dell Boomi.
- Development of the Policy Application. The Policy Application would manage the company’s work comp policies using .NET C#, SQL Server, AngularJS and Bootstrap.
- Development of the Quarterly Tax Application. The Quarterly Tax Application is a .NET C# Windows Form application that produces reports for paying taxes and estimated taxes. The application will produce files for uploading tax payments to state and local governments.
- Development and maintenance of a wide scope of SSRS reports that have just as wide of a range of data marts and complexity.
- Development of the Corvel TPA Merge. The Corvel TPA Merge uses Dell Boomi to process Corvel’s files. The data in the files processed through applications to calculate required reserves the company must maintain in order to be self insured.
- BBSI moves a lot of data between departments for many different applications. These ETL’s must be maintained using various technologies such as Dell Boomi, SSIS, Windows Services and Web Services.
- All the data and software changes completed in the company must be SOX compliant. I have completed many projects that have passed a change action board. I have also completed them to a degree that I can hand the changes to another department for deployment.
Confidential
Senior Programmer / Database Developer
Responsibilities:
- Development of a product called Confidential, software that generates analytics for optometrists by extracting patient data from a client’s practice management system and then pushing the data to a main server. The metrics allow a practice to find missed treatments and identify potential revenue while remaining compliant with insurance coverage.
- Development used the following C#, Microsoft Entity Framework, WCF Services, Windows Services, Microsoft SQL Server, TSQL, ASP.NET MVC, JQuery, Ajax and Bootstrap.
- Database expertise spanned three different database servers Microsoft SQL Server, SAP Advantage Data Server and MySQL Server.
- Integration with four practice management systems including Compulink, Crystal PMS, Office Mate and MyVisionExpress. Each PMS had its own proprietary database architecture to study and extract data from.
- A Windows Service was developed to install in the client’s server. The Windows Service would run all the processes that extract data from the database server and then push the data back to Confidential . The service included an installer.
- A WCF Web Service was developed to transfer file data between the client’s practice and the main server at Confidential . Files are sent via a secure connection, compressed and password protected.
- A complete API or model was created. The MVC web application contained no business logic making the software completely portable to another platform such as a mobile application.
Confidential
Senior Programmer / Database Developer
Responsibilities:
- Lead developer of a CRM called NexGenCrm. The software had over 30 companies. The CRM takes in generic data and then custom programming would be provided for each industry. Debt settlement and energy sales were the two main industries. The CRM had complete user administration using Roles and Rights and could be used at a control level.
- CRM Development used C#, ASP.NET Web Forms, Microsoft SQL Server, TSQL, Telerik Web Controls, JQuery, Ajax, Windows Services and WCF Web Services.
- Development of an API, for complex contract generation and payment schedules.
- Created a document generation process to produce just about any document needed from the CRM data. The process would substitute data then transform the document into a PDF.
- Integration with Echosign, an electronic signature company.
- The CRM used configurable workflows that generally ran off status changes. The workflows would send alerts, create documents and send work to another office or user.
- Development of an email client. The email client would allow a company to control user email and also trigger workflows.
- Development of a product called LensJet. LensJet was created using ASP.NET Web Forms, C#, Microsoft SQL Server, Entity Framework, JQuery and Ajax. LensJet imports a product catalog from a lens libratory such as VSP Labs. By answering a few questions and using an algorithm a practice’s entire lens inventory could be priced accurately.
Confidential
Senior Programmer / Database Developer
Responsibilities:
- Developer for government debt collection software called Revenue Results.
- Software was developed using C#, Windows Forms, .NET Remoting and Microsoft SQL Server.
- Responsible for the development of the following modules:
- Victim Restitution - The module uses an algorithm to divide up collections to victims based on business rules.
- Tax Intercept - Debt collectors can intercept tax returns by following a defined set of rules from the government.
- LexisNexis - Integrated with the LexisNexis API to that completes people searches. The system allows for quick updates and improves debt contacts.
- Responsible for automatic generation of correspondence. The system would store any Microsoft Word document and automatically fill in data. Scheduling and printer time were a massive challenge. Each job could possibly run for an hour or more depending on what was printed and printer speed. Processing speed was greatly increased using newer methods.
Confidential
Senior Programmer / Database Development
Responsibilities:
- Web application and windows service development for debt management software used by DebtXS to maintain and process their client database. Software was developed using C#, Visual Basic, SQL Server, MySQL, COM+, ASP 3.0, JavaScript, IIS and TSQL. Primary roles are developing email applications, workflow management, calendar applications and contract generation.
- Creation of services that automatically download email, maintain inboxes, send newsletters, manage email campaigns, track non-delivery receipts and download large attachments. The services would log errors and alert the administrators.
- Architected and maintained the email database using SQL Server. The database adheres to at least the 3rd normal form complete with primary keys, indexes and constraints. The database is the backend for the web based email software used by the company sales staff, customer relations, administrators and windows services.
- Responsible for data migration between systems. All the data from the old system created using MySQL had to be migrated to the new system using SQL server. The task involved creating many stored procedures to accurately transfer from a database not normalized to the new normalized database using SQL Server. Also responsible for loading the tables and scrubbing the data.
- Developed a web based task application complete with pre-defined tasks, groups and roles that managed work flows. This application would alert users to new tasks, past due tasks and changes in status through a client application receiving alerts through a web service.
- Developed E-Signature application for contract processing using DocuSign’s web service API. The application allows for quick signings enables the sales staff to secure clients on the spot.
Confidential
Senior Programmer / Database Development
Responsibilities:
- Application development for calling scripts and processing of data using Visual Basic, TSQL, FoxPro and ASP.
- Created and maintained the documentation for the processing applications, calling scripts and campaign setup for the vendors.
- Responsible for maintaining a fast pace during political campaigns and data processing. Developed applications at a moments notice while remaining flexible to the needs of the client.
- Commissioning, installing and Trouble-shooting T1 lines.
- Trouble-Shooting SER call processor issues. A system with very little affordable and readily available support.
- Network administration for a Windows 2000 network
- Hardware and software support for two call centers with over 200 employees in each center.
- Application development using Visual FoxPro, Visual Basic and SQL Server
- Intranet development using VB script, JavaScript, COM and SQL Server for maintaining quality assurance information and processing call statistics
Confidential
Programmer / Database Development
Responsibilities:
- Responsible for the development of a web based waste management system used to support a microburst wireless data product developed by Fibres. The system was created using SQL Server, VB Script, Visual Basic and JavaScript.
- Lead programmer through the completion of two projects
- Responsible for design and development of various databases and reporting functions. All databases conform to at least the 3rd normal form fully implemented with primary keys, foreign keys, indexes, defaults and constraints. Implementation was done using SQL Server.
- Responsible for creating stored procedures for web projects with difficulty ranging from the simple to the complex.
- Experienced in training or teaching other staff members VB Script, JavaScript and SQL Server.
- Experienced providing support for Epicor, a commercially available enterprise level accounting system based around SQL Server.