Resume

Sign in

Software Engineer Sql Server

Location:
Evesham Township, New Jersey, United States
Posted:
January 06, 2018

Contact this candidate

Joyce Wolf

** ****** **** *****: ***. ***.****

Marlton, NJ 08053

Email: ac3xlp@r.postjobfree.com

Skills Summary

Sr. Software Engineer/Architect with nearly 20 years’ experience in analysis, design, development and re-engineering business, web and e-commerce applications using C#, VB.Net, JavaScript, Jquery, Oracle, SQL Server, DTS, SSIS, SSRS, ASP, ASP.Net, Crystal Reports, IIS.

Technical Profile

Languages: C#, Visual Basic 4/5/6/.Net, ASP using VBScript, ASP.NET, Basic, Visual FoxPro 3/5/6, C/C++,COBOL, Pascal, D-Base, RPG, Lotus 123, HTML, DHTML, XML, Java Script, JQuery

Databases: Oracle with PLSQL & SQL+, Microsoft SQL Server, Informix, FoxPro, Access, DB2

Other: Crystal Reports, Adobe Photoshop, Visual Source Safe, Team Foundation Server, Visual InterDev, Visio

Experience

2/2016 – Present Gift Of Life

Philadelphia, PA

Senior Software Engineer

Brought on as the only programmer, I have been tasked with maintaining and reengineering old, existing systems written in Fox Pro, Visual Fox Pro, VB Script and some classic ASP with ASP.net using C#, Sql Server, JavaScript and JQuery. Along with the reengineering I have also written several new applications including a web app that, with use of a bar code scanner, scan drivers’ licenses and register the driver to be an organ donor in the appropriate state and developed web services to allow outside vendor’s app to do the same, an application that sends culture reports to the appropriate doctor and hospital when positive culture reports come in for any organs/tissue being transplanted.

3/2013 – 12/2015 Global Industries

Marlton, NJ

Senior Software Engineer

Reengineer existing web applications in ASP.Net 2012 to remove inline queries and implement parameterized queries. Write stored procedures, triggers and functions to replace repetitive data related code in various web applications. Performance tuning of SQL queries. Write SSIS packages when necessary for importing data from customers, updating data in CRM, create report data and mirror data from AS400. Created several public facing web applications including various e-commerce 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 Microsoft Dynamics CRM solutions with java scripting behind the CRM forms to meet the unique needs of our business.

2/2011 – 6/2012 Educational Testing Services

Princeton, NJ

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.

2/2011 – 2/2012 Harte Hanks

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.

7/2009- 9/2010 Disc Makers

Pennsauken NJ

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.

8/2008- 5/2009 Premier Prizm Solutions

Marlton NJ

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

8/2007- 5/2008 AmeriFlex

MT. Laurel, NJ

Manage IT and MIS teams.

Maintain and upgrade servers and Comdial Phone system

Set up and maintain server and desktops

Install and maintain Active directory and Exchange servers

Install and maintain firewall and anti-virus software

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.

5/2006 – 8/2007 Village Home Mortgage

MT. Laurel, NJ

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.

8/01 – 5/2006 ARI

Mapleshade, NJ

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.

12/00 – 8/01 Miles Technologies

Marlton, NJ

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.

1/99 - 12/2000 SSTi

MT. Laurel, NJ

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.

4/98 - 12/98 Palumbo Consulting Inc.

Vincentown, NJ

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.

7/97 - 4/98 Pennco Tech.

Blackwood, NJ

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.

Education

12/1996 Pennco Tech School, Bristol, PA

Associate Degree in Specialized Business/ Computer Programming

Honors and Awards: Achieved Honor Roll Status every term.

Burlington County College, Pemberton, NJ

Courses: Business Administration, Data Processing, Accounting, English, Electronics I & II, Electrical Drafting (Manual & CAD), Algebra I & II

Awards and Recognition

Named Employee of the year for 2004 in recognition of a project I designed and developed that reduced cost by reducing paperwork, postage fees, head count and eliminating programming request.

During my first month at ARI, I was given an award for the work I did solving the problems the MIS department had deploying applications throughout the organization. I received a second award a few months later for the assistance I had given to the other developers in the MIS department.



Contact this candidate