Skills Summary

Software Engineer/Project manager with over 15 years experience in design, development and re-engineering business applications using Visual Basic, VB.Net, C , Oracle, SQL Server, DTS, SSIS, SSRS, ASP, ASP.Net, Crystal Reports, IIS.

Technical Profile

• Languages: Visual Basic 4/5/6/.Net, ASP using VBScript, ASP.NET, Basic, Visual FoxPro 3/5/6, C/C , C , COBOL, Pascal, D-Base, RPG, Lotus 123, HTML, XML, Java Script
• Platforms: DOS, Windows, Win95, Win98, Windows ME, NT, Windows 2000, Windows XP
• Databases: Oracle with PLSQL SQL , Microsoft SQL Server, Informix, FoxPro, Access
• Other: Crystal Reports, Adobe Photoshop, Visual Source Safe, Visual InterDev, Visio

Experience

Confidential

Senior Software Engineer

• Reengineer existing web applications in ASP.Net 2012 to remove inline queries and implement parameterized queries. Write stored procedures to replace repetitive data related code in various web applications.
• Created several public facing web applications including various ordering systems that allow our customers to upload their documents and drawings and submit their orders and change request online. Implemented JavaScript, JQuery and CSS in our ASP.Net web applications to make them more dynamic and adjust to users devices.
• Created custom CRM solutions with javascripting behind the CRM forms to meet the unique needs of our business.

Confidential

Senior Software Engineer

• Design and develop SSIS ETL solutions, SQL Server stored procedures, Triggers, Functions, Views and VB.net User Interface. Designed and wrote an SSIS package to extract data including blob, clob and xml fields from Oracle database, transform and load into SQL Server database and incorporate a third party DLL to extract text from varbinary field containing PDF documents.
• Wrote triggers to create audit records and perform calculations when data in tables changed.
• Designed views for reporting and UI. Designed and developed User Interface to query database, provide views and perform side-by-side comparisons of PDF, Word and XML documents in Visual Studio 2010. Wrote defect tracking system in ASP.net using Visual Basic.net. Designed optimized queries for increased performance one of which decreased the time to load data from 13 minutes to less than 2 seconds.

Confidential

Senior Software Engineer

• Design and development of complex SSIS ETL solutions to sync and maintain large vehicle database of nearly 5 million vehicles and customer database of 11.3 million customers for a major auto manufacturer.
• Design and develop VB.net and SSIS solutions to manage dealer customizable print and email advertising campaigns.
• Design and develop SSRS reports.

Confidential

• Designed and developed a complex system to transfer digital media and directly load data into our sister companies Dynamics ERM system using SSIS, SQL Server Sorted procedures and triggers, VB.net, and Web Services.
• Designed and developed a variety of EDI solutions to facilitate transferring to and from our distribution partners including Amazon.com, ITunes, Sound Scan and several other online media retailers.

Confidential

• Develop ETL solutions using SQL Server DTS and SSIS
• Develop Reports using Excel VBA and SQL Server
• Develop SQL Server stored procedures, functions, views and triggers
• Develop new applications in .Net 2008 with a SQL Server 2005 backend.
• Train and mentor developers

Confidential

Manage IT and MIS teams.

• Install and maintain firewall and anti virus software
• Install and maintain Active directory and Exchange servers
• Set up and maintain server and desktops
• Maintain and upgrade servers and Comdial Phone system
• Desktop support
• SQL Server Administration and programming stored procedures and functions.
• Exchange Server Administration
• Design, build and maintain company intranet
• Maintain FTP site
• Assist clients EDI to import data to internal system
• Configure and support 3rd party software
• Design and develop SQL Database to support custom software solutions.
• Design, build and maintain corporate web site
• Develop DTS scripts to import data from various sources into a SQL database.
• Design and develop custom reporting solutions
• Design and develop custom web applications in asp.net using SQL server.
• Migrate existing applications from Foxpro, VB Script and classic ASP to appropriate .Net applications.

Confidential

• Design and develop SQL Database to support custom software solutions.
• Develop DTS scripts to import data from various sources into a SQL database.
• Design and develop custom reporting solutions linking various software packages via API call and developed DTS scripts.
• Design, develop, a custom ASP.net loan origination system importing data from a dialer system, presenting loan officers with data entry screens and linking with the Ellie Mae Ecnompass Loan system to create loans as required.

Confidential

MIS Sr. Software Engineer / Sr. Web Developer/Project Lead

• Promoted to Project Leader after 1.5 years. Analyze, design and lead a group of five developers in re-engineering and developing new applications in .Net environment.
• Design, develop, re-engineer ARI's business applications. Using Visual Basic, VB.Net, C , Javascript, Oracle, SQL Server, ASP, ASP.Net, Crystal Reports.
• Developed enterprise level vehicle management system that tracks and manages national and international state compliance for all licensing and fees for over 265,000 vehicles world wide. Integrates with accounting system and produces checks for paying fees and charging clients.
• Developed algorithm that was added to ARI's ordering system to determine and pre-select a dealer for our customers to pick-up the vehicles they lease from us resulted in an average decrease in the distance our customers have to travel to get their vehicle of 75 .
• Developed vehicle delivery tracking system including all forms and driver instructions.
• Developed Active X controls, custom web controls and edited Microsoft's validation scripts to provide custom interfaces for internal users in our ASP applications.
• Developed and maintain a set of coding standards for our ASP applications.
• Train and mentor developers.
• Responsible for yearly performance reviews and evaluations of development team.
• Supervise and manage work assignments under strict project timelines.

Confidential

Sr. Software Engineer / Sr. Web Developer

Design, code, test, deploy a variety of projects based on client needs including accounting systems, e-commerce sites, production control systems using Visual Basic, Visual Fox Pro, ASP, HTML, JavaScript, Flash, Adobe. Set up and administered Microsoft SQL7 and IIS.

Confidential

Software Engineer / Sr. Web Developer

• Design and code web applications including POS, Database Management, E-commerce, Configuration Management, Company Timecard application using ASP, Visual Basic, JavaScript, HTML, DHTML, and PERL.
• Developed several components in Visual Basic for use in ASP pages including a binary file creator, a specialized FTP component, and a component to launch executable files on the web server with command line perimeters, a site statistics component and a bar graph generator component.
• Design of all databases used by web applications.
• Administration of IIS. Some graphics design using Photoshop. Development of POS and database management applications in Visual FoxPro.

Confidential

Software Developer

Responsible development in Visual FoxPro. Designed systems that use ODBC drivers to import data from a wide range of databases to be used and maintained in a single, user-friendly program. Developed ActiveX controls in Visual Basic to enhance and ease the development of GUI's in Visual FoxPro.

Confidential

Computer Programming Instructor

Responsible for devising curriculum, lesson plans, lectures and lab assignments for a range of subjects including: Intro to Computers, Math, DOS, Visual Basic, C . After teaching one part time, 10 week evening term in Visual Basic, I was hired as a full time faculty member to implement the same skills and teaching methods into the day courses.