Sql Server Customer Service
Resume:
Roger L. Nettler
Lake Success, NY 11020
******@********.***
Summary
Software Development IT professional with over 15 years of hands-on experience with C#/Visual Studio, SQL Server, Relational Database Design and Implementation, T-SQL/Stored Procedures, Web development, and Visual FoxPro. Specializing in the development, implementation, and support of Apparel Industry ERP Systems. Extensive experience managing development teams as well as a strong understanding of the software development life cycle. Playing a major role in designing and implementing project management tools, he has enabled developers to optimize their performance in their day-to-day routines along with expediting the development cycle from project conception to completion.
TECHNICAL SKILLS
Development Tools: C#/.Net, ASP, Visual FoxPro, JavaScript/VBA, MapInfo/MapBasic
Technologies: MS SQL Server, IBM DB2, Data Modeling, XML
Administrative: Project Management, SDLC
General Software: MS Excel, MS Word, MS Powerpoint, MS Outlook
PROFESSIONAL EXPERIENCE
NYC Department of Education April 2014 – Present
New York, NY
Application Developer
Upgrade finance expense system
Allow for reporting of data to accommodate updated contract terms.
Streamline procedure to breakout expenses into correlating categories.
Create interface to allow users to enter and pay off-line vouchers for vendor adjustments.
Upgrade student transportation routing system
Convert 16 bit routing application developed with Map Basic 2.5/Foxpro 2.6 to MapBasic 12.5/Visual FoxPro 9.0.
Simparel, Inc. January 2012 – April 2014
New York, NY
Application/Engine Developer
Development, implementation, and support of Apparel Industry ERP System
Maintain and enhance proprietary RAD framework developed in C#.
Develop interface to ConnectShip API allowing customers to integrate package shipments with UPS.
Develop interface to PayTrace credit card payment service allowing customers to integrate credit card payments seamlessly through the application.
Design and develop utility which allows unattended application upgrades and data refreshes.
Develop COGS/Inventory Valuation process allowing customers to accurately track COGS and Inventory value from period to period.
Develop application functionality using proprietary RAD framework.
Work with clients to define and develop processes to automate and improve daily tasks.
Design and develop Batch Process builder allowing clients to group multiple processes and tasks into one pre-defined process maintaining common filter criteria.
Implement three-tier software development life cycle (SDLC).
Computer Generated Solutions, Inc. April 2000 – December 2011
New York, NY
Lead Application Developer
Design, development, implementation, and support of Apparel Industry ERP System
Lead developer of a team of more than 10 VFP programmers
Strong understanding of the software development life cycle (SDLC).
Served as lead developer for implementing project management tools
Enabled developers to optimize their performance in their day-to-day routines along with expediting the development cycle from project conception to completion.
Assisted in the design and development of underlying framework architecture for distributed client/server environment.
Designed and developed Reporting Engine, allowing users to build dynamic/user-defined reports.
Designed and developed Visual FoxPro Task Server, allowing users to schedule processes and reports, including a sophisticated batching system.
Developed framework classes to allow ease of cross-platform development between Visual FoxPro, SQL Server, and DB2 databases.
Developed .dll files allowing .Net application to run VFP applications.
nbNet Systems, Inc. November 2001- Present
President
New York, NY
PROJECT EXPERIENCE
Convert DOS Payroll Processing application to Visual FoxPro/SQL Server for Jacob Javits Center
Reworked FoxPro DOS code to work in Visual FoxPro .
Allowed for data access to work in both SQL Server and Visual FoxPro using common code base.
Design/Development of Data Conversion/Import Application for Medical Collections Agency
Built framework to allow Medical Collections firm to seamlessly import data from multiple Hospital Management Systems into their third-party collections application.
Generates scripts to allow client to automate reconciliation of outstanding receivables with hospital Excel files.
Generates 270 files for Medicaid submission and reconciles 271 files returned from Medicaid.
Convert Visual FoxPro application to C#/Visual Studio.
Job Tracking System for Metal Manufacturer
Calculate material requirements/costs based on imported DXF image files.
System tracks and manages Work Orders and Estimates.
System maintains plant management schedules based on active jobs.
Web Interface for Foreign Exchange System (VFP7.0/SQL Server/JavaScript)
Developed Web Interface to existing desktop application, allowing Clients to submit trade requests on line.
System provides Real-Time quotes on currencies allowing traders up to date information.
Medical Billing System
Designed and built DOS Application to submit Medicare and Medicaid claims electronically.
Converted FoxPro DOS applications to Windows applications.
Enabled EDI functionality of application to be HIPAA compliant.
Created Web interface, allowing physicians to submit claims online and reduce paperwork.
Appointment Management System for Independent Medical Exam (IME) Firm
Responsible for re-design and development of desktop application used by an IME for the purpose of scheduling and managing Physician Appointments/Reviews for persons involved with insurance claims.
Scheduling/Billing System for Medical Training Center
Developed Framework for application that handles scheduling and billing for Non-Profit training center.
Provide System updates and maintenance as needed by Client.
Table Reservation Application – Four Seasons Restaurant
Developed application showing restaurant floor plan and allowed staff to mark tables as booked, reserved or available.
Real Estate COMPS Application
Converted File Server application to Client-Server application utilizing components for RAD Development.
Customer Support/Tracking/Billing Application for Software Development Company
Designed and developed application to maintain and track Customer subscriptions and Hardware/Software configurations.
Application generates Work Orders/Invoices based on customer subscriptions.
Application tracks payments and accounts receivables.
Application generates registration logic for new customers.
Application allows Customer Service Representatives to track Customer Support Issues
AWT Inc. May 1999 – April 2000
Senior Application Developer
New York, NY
Development of Business-to-Business Web applications using Visual Fox Pro, Active Server Pages, XML, and MS SQL Server.
Responsible for writing the underlying framework with VFP/SQL
Responsible for designing Microsoft SQL Server migration wizard installed with Visual FoxPro 5.0.
Scripting with JavaScript and VBScript.
Programmed Solutions April 1994 - May 1999
Technical Support/Application Developer
New York, NY
Conversion of Printing Industry ERP System (FoxPro 2.6 DOS/Windows) to Visual FoxPro 3.0.
Conversion of application logic and data schema to use MS SQL Server.
Provided technical support to application users.
RS Rosenbaum & Co. October 1992 – April 1994
Cost Accountant
New York, NY
Responsible for creating job estimates for financial printing firm.
Analyzed actual costs versus standard costs upon job completion to create project variance reports.
Analyzed variance reports to improve productivity and increase profitability.
Developed automation processes for calculating estimates and job costs using Microsoft Excel.
EDUCATION
Bachelor of Science, Management, Major: Accounting
Tulane University, 1987
Contact this candidate