Sql Server Sales

MARK E. HARDIMAN

** ********* *****

Eastampton, New Jersey 08060

Home: 609-***-****

Cell: 609-***-****

************@*******.***

LinkedIn Profile: https://www.linkedin.com/pub/mark-hardiman/b/aa2/362

Summary of Qualifications

Over 33 years of software development experience

12 years PM experience including 9 years of Administration of staffs up to 10 developers

.NET 4.5, MVC 4, C#, Azure Service Bus, WCF Services, LINQ, Entity Framework 6.0, HTML, Razor, jQuery

Telerik Kendo UI & Reporting Controls for MVC Web Applications

Infragistics Controls for Win Forms

Visual Studio 2015, 2013, 2008, 2005 Development Environment Experience

Visual Studio Online Development Environment Experience

SQL Server 2012 & 2005 programming experience

SQL Server 2005 Reporting Services (SSRS) & Integration Services (SSIS) Experience

ASPEN Canopy ERP Integration Experience (Food Industry)

CarePoint ERP Integration Experience (Retail Pharmacy Industry)

Experience

Philidor Rx Services, Hatboro, PA May 2015 – November 2015

Senior Software Developer

Philidor Company Shutdown Planned for January 2016

Developed a Microsoft Azure based C# MVC website for a retail pharmacy that takes patient refill orders and enters them into the on premise CarePoint pharmacy ERP system.

Developed an on premise service oriented architecture that provided the integration between the website and CarePoint. This SOA was implemented using C# WCF Services that provided numerous on premise services such as order queueing, order fulfillment, co-pay pricing, address validation, credit card payment processing. The on premise WCF Services interfaced with the website through the Azure Service Bus Relay. The order queueing was implemented using the Azure Service Bus Queueing services.

Developed a C# Windows Service that used the Task Parallel Library to read orders off of the Azure Order Queue and create tasks to process individual orders in parallel in order to maximize order throughput. Integration into CarePoint ERP was achieved by reverse engineering how native application interfaced with its database using SQL Profiler. LINQ and Entity Framework were used for database interaction of this Windows Service.

Rastelli Foods Group – Global Division, Swedesboro, NJ October 2009 – May 2015

Programmer Analyst

Developed an MVC 4 C# Intranet Web Site that provides Time Study data and analysis for a variety of manual tasks performed by Warehouse personnel for measuring actual labor costs. The web site uses Telerik Kendo UI controls in all of the View components. AJAX is used to provide a superior user interface experience. Telerik Reporting controls were also used for task time and cost analysis. Entity Framework 6.0 is used for all access to the existing SQL Server 2005 database.

Developed a C# Web Form application that permitted external customers to place their orders online. This application interfaced directly with the ASPEN Canopy ERP system’s database to create a sales order identical to one created by the Aspen ERP user interface. SQL Profiler was used to reverse engineer how native Canopy application interacted with the database. A variety of internal business rules and supplier minimum ordering quantity requirements were enforced during the generation of new sales orders. This application employed a workflow transaction concept to support the state of the customer ordering process: tracking the back & forth nature of price requests, any minimum ordering requirements, automatic notification via e-mail of relevant events, ability to monitor and track status of customer’s shopping carts. Additional transactional steps were required for the customer to approve their order and for internal sales personnel to accept the order. The application also computed the shipping container utilization and related fees so the customer knew how many containers were needed for shipment. This allowed the procurement of food products to occur without any customer cancellations or any perceived miscommunications about order content. This application runs on a SharePoint 2007 portal.

Mentored a web site software developer on the non user-interface components of the retail web site. I helped increase his skills in the server’s business tier C# code, SQL server stored procedure coding, and SQL Server table design.

Developed a C# WinForms application that allows the Accounting department to customize how commissions are to be paid to outside brokers. The customization is based on the broker, what customers the broker services, and the relevant products (food and non-food). The application also allows for Accounting to specify the type of calculation (ex: flat rate, markup, margin) as well as what price component (ex: Sell Price, Gross Profit).

Developed a C# WinForms application that calculates a product’s selling price based on one or more user defined price components. The calculation method is also user defined thus allowing sales to keep the desired profit margins for products as the vendor’s cost of these products change over time.

Developed a C# WinForms application that matched up customer sales orders with outstanding inventory and purchase orders to automatically generate new purchase orders for the appropriate products and respective quantities and to deliver the purchase order to various food suppliers. This application interfaced with the ASPEN ERP system to determine inventory, sales orders, and creation of a new purchase order within the ERP identical to the one created by the ERP user interface. A variety of internal business rules and supplier minimum ordering quantity requirements were enforced during the generation of new purchase orders.

Developed a C# Windows Service that imported pricing data from an Excel spreadsheet (dropped by a user in a network folder) for Reinhart Food Service, converted to Reinhart’s internal format, and uploaded via FTP to Reinhart Food Service.

Developed a C# WinForms application that provided an interface for receiving products between the warehouse staff and the ASPEN ERP system. This application enforced company specific business rules such as minimum shelf life requirements & prevention of over-receiving products against purchase orders thus ensuring ASPEN’s inventory only contained products that met company & customer requirements.

Developed a C# WinForms application that provided the means for Customer Service personnel to customize the various fees that are included on Pro Forma Invoices.

Developed a C# WinForms application to handle all delivery appointments.

Developed a large variety of SSRS reports to meet various internal & external requests. Some of these reports dealt with Customer Profitability, Vendor Performance, and Sales History. These reports were hosted on our SharePoint portal for internal & external use.

Omicron Consulting LLC Bala Cynwyd, PA August 2008 – September 2009

Senior Developer

Developed C# software for a .NET 2.0 intranet web application (Agency Information Management - AIM) that allowed agency personnel to manage all aspects of matching volunteers with children. C# software was developed for all parts of the web site including the user interface (server side and Java Script), server side objects to provide business logic, e-mail support and database access. Developed and maintained SQL Server 2005 stored procedures and triggers to support various features of the system.

Developed a C# .NET 2.0 internet application that allows volunteers to enter enrollment information online that was later used by Agency personnel in the AIM web application.

Developed numerous SQL Server 2005 Integration Services packages to perform extract, transform, and load operations to exchange data between the BBBSA data warehouse and the AIM intranet web application database.

Developed C# Web Parts that replaced several classic ASP budget related web pages for use in an internal SharePoint 2007 portal.

Assignment: Big Brothers Big Sisters of America, Philadelphia, PA

Computer Sciences Corporation Berwyn, PA June 2006 – August 2008

Consulting Group

Senior Consultant

Assignment: American Water, Voorhees, NJ

Assignment role was as the Application Architect for a customer Self Service Web Site. I was responsible for the design of the front end web site including the user interface, business tier, and data access tier. This web site is using a service oriented architecture (web services, message queues) to interface to American Water back end systems for submitting customer service orders, account balance data, and online bill payment. I developed a working prototype in .NET 2.0 written in C# using SQL Server 2005 Express to demonstrate how the various screens would work.

Assignment: Con Edison, New York, NY

Developed software in VB.NET for a .NET 2.0 internet web site that allowed customers & contractors to register for and request gas or electric energy services from Con Edison to a new or existing commercial or residential location. Wrote software for all parts of the web site including the user interface (server side and Java Script), server side objects to provide business logic, e-mail support and database access. I also developed a web service used by this site and an IVR system that provided authentication and authorization of users.

Developed the data model using SQL Server 2005 for this application. Developed SQL Server 2005 stored procedures and triggers to support various features of the system.

This project was developed in the Visual Studio 2005 Team Foundation Server environment. I was also responsible for writing the Unit Tests that were run against my software whenever the solution was built by TFS prior to deployment.

Developed software in VB.NET for .NET 1.1 intranet web site that tracked the inspection status of all the assets in the utility's electric distribution system. The software was developed to provide users the ability to create custom inspection forms without the need for any coding change. Wrote software for all parts of the web site including the user interface (server side and Java Script), server side objects to provide business logic and database access.

Developed the data model using SQL Server 2000 for this application. Developed SQL Server 2000 database stored procedures and triggers to support various features of the system. The Microsoft Enterprise Library Application Data Blocks were used for interfacing with the SQL Server 2000 database.

Merrill Lynch Hopewell, NJ November 2005 – June 2006

Merrill Lynch Investment Managers (MLIM)

Vice President Middle Office Trading Systems

MLIM sold to Black Rock, New York

Responsible for managing a team of five onshore developers and offshore software developers for MLIM’s Middle Office Trading System and Portfolio Administration. For the Middle Office Trading System, I managed completion of the project to outsource the Middle Office Trading System to Brown Brothers Harriman. I also managed the ongoing “Business As Usual” and “Lights On” enhancements to the business for Portfolio Administration which was provided by Sungard. Both projects involved heavy interaction with the internal business users as well as outside vendors.

I was responsible for writing the HR Development plans for each of the developers on my staff. This was the criteria for which their year-end evaluation, salary increase, and bonus would be based.

I was responsible for managing an $850k budget that included providing monthly forecasts and monthly performance of actual vs. forecasted expenditures.

Checkpoint Systems Thorofare, NJ June 2004 – November 2005

Software Project Lead Architect

Checkpoint’s Access Control Group was sold to a startup firm called Sielox, Inc.

Project Manager for the software development and quality assurance of the RFID based Pinnacle Access Control product. I was responsible for developing and maintaining the project plans for new and sustaining software development; also responsible for maintaining the quality assurance test plan. I also was involved with interviewing candidates for several software positions.

Implemented the use of Project 2003, Project Server 2003 and Project Web Access for creating and monitoring the project plans for the software engineering and QA groups.

Used SharePoint 2003 to implement and internal web site that was used for inter-department documentation repository, communication and coordination of events.

Responsible for studying the existing architecture and implementation of the RFID based Pinnacle Access Control product in order to make recommendations for product improvement as well as for development of the product’s next generation; a .NET implementation. Worked with sales & marketing, on the design for new features. Worked with technical support on designing product improvements.

Part of a team of seven engineers that wrote the C++, VB, SQL Server 2000 software for the next major release of the RFID based Pinnacle Access Control product. Tasks included implementing new features and fixing bugs deferred from prior releases. Provided production support by implementing several service packs and hot fixes for the existing Pinnacle access Control product.

Provided engineering support for product trade shows.

Merrill Lynch Hopewell, NJ April 2000 – June 2004

Merrill Lynch Global Private Client (GPC)

Project Manager/Technical Leader

Led a team of Web developers (size ranged from six to ten) on the Benefits OnLine 401(k) product. The product areas I was responsible for included Account Balance, Fund Transfers, Contribution Rate, Enrollment, Investment Direction, Content Management, and interface with 3rd party investment advice provider Financial Engines Inc. Product development involved using COM and C++ for the business objects. ASP, HTML, and JavaScript were used for presentation. XML was used for interfacing with Financial Engines.

The Software development followed the Rational Unified Process model. Rational’s RequisitePro and Rational Rose were the principal tools used for our areas of responsibility.

Management responsibilities included working with the Business on requirements, supporting the Testing process, scheduling & monitoring projects for developers, interviewing, employee performance reviews, and production support.

Developed a production problem tracking and reporting internal web site for software development using VB.NET 1.1 and SQL Server 2000.

Developed a software development bug tracking and reporting internal web site for software development using VB.NET 1.1 and SQL Server 2000.

Opex Corporation Moorestown, NJ April 1998 – April 2000

Lead Software Engineer

Lead a team of four programmers that designed and developed a Windows NT multi-user client/server system used to configure, run, and monitor a high speed Outgoing Mail Sorter (United States Postal Service MASS Certified). COM Automation was used to transfer data between the client and server. A Microsoft Access database stored all performance statistics and configuration data. This provided an industry standard means of interfacing the Sorter to a customer’s accounting systems without developing any custom code. Seagate’s Crystal Reports software was used for creating a variety of reports. The server was also responsible for communicating with a Motorola 68000 based system that controlled the Sorter. I developed C++ classes to provide an interface between the application and 3rd party software packages and to support communication with the Sorter. In addition to Microsoft MFC classes, I used Stingray Toolkit Pro and Objective Grid classes to provide a modern, industry standard user interface. This included the use of grids, bar charts, and pie charts.

As Project Leader, I was responsible for developing and maintaining project development schedules. I interfaced with sales and marketing regarding product features and accompanied sales personnel on calls to prospective customers. I also was responsible for demonstrating the high speed Outgoing Mail Sorter at numerous industry trade shows and provide technical support to sales personnel at follow up meetings with trade show prospects.

Dow Jones Markets: Dow Jones Inc. Princeton, NJ October 1997 – April 1998

Senior Software Designer

Designed and developed the Remote History Gateway component of the Dow Jones Workstation. This DLL allowed client applications to get historical instrument data from remote history servers. C++ classes were used to abstract each remote history server. Microsoft MFC classes provided internal support for the remote history server classes.

Designed and developed a Database Conversion Program for converting a prior version of the History Database installed on a Unix platform to the most recent version that is installed on a Unix or Microsoft NT platform. ODBC, C++ and Microsoft MFC classes were used to interface between the old and new databases. Both versions of the History Database are Sybase databases.

Modified an internal utility program that was used for testing the History Component’s Sybase database interface.

Dow Jones Markets was sold in April 1998 and there weren’t any open positions within the company.

ISS, Inc. Mullica Hill, NJ April 1996 – October 1997

Senior Systems Analyst

Participated in the development of a Microsoft Windows NT client/server Access Control product. C++ classes were used to implement common and unique features of various external hardware components that form the access control network. C++ classes were also used to provide the command and communication interface between the application and the network.

Participated in the development of a Microsoft Windows NT client/server Loss Prevention System for retail stores. C++ classes were used to implement common and specific capabilities of various external hardware components: playback and record VCRs, video multiplexor, and video overlay boards.

Designed and implemented a Visual Basic application that tracked the status of a lease application from its inception to the final approval using a Microsoft Access Database.

Telenex Corporation Mt. Laurel, NJ January 1991 – April 1996

Senior Member Technical Staff

Designed and coded OS/2 client/server applications for the ESCON and Bus & Tag Mainframe Channel Switching products. C++ classes were used to implement common and unique functionality of the system’s physical elements (ports, channels), alarm information, data persistence, and for distributing information within a process and between processes. Rational Rose was used during the system design phase of all projects.

Automatic Data Processing Mt. Laurel, NJ January 1988 – October 1990

Manager of Technical Staff July 1988 – October 1990

Project Manager (five people) for a PC based Stock Market Quotation System. Responsibilities included project planning and monitoring, functional design and implementation of various quotation and news services, interface with sales, marketing, quality assurance, and documentation personnel, perform on-site troubleshooting, product demonstrations, interviewing, and personnel performance appraisal.

Project Manager (two people) for IBM Token Ring DLC/NetBios emulation software. This allowed a remote PC access a LAN PC workstation for stock market data using an SDLC link.

Developed a Microsoft Windows Stock Market Data Simulator for testing the Stock Market Quotation Terminal System.

Senior Programmer Analyst January 1988 – July 1988

Designed and coded of an Intel 80188 based Composite Video Stock Market Quotation Terminal System using an ADP developed real time multi-tasking operating system.

Base Ten Systems, Inc. Trenton, NJ March 1986 – December 1987

Software Engineer

Designed and coded elements of a Motorola 6809 based real time remote Alarm Reporting System.

Designed and coded an Intel 80188 based terminal driver that resided on a Front End Processor board within a PC. The software was used for terminal I/O in a Weapons Management System Test Set.

Designed and coded a BellCore validated IBM PC based implementation of the BX.25 that was used in a Call Record File Transfer System.

Avant-Garde Computing, Inc. Mt. Laurel, NJ September 1982 – March 1986

Project Supervisor June 1983 – March 1986

Software Engineer September 1982 – June 1983

Managed (two people) and participated in the design and development of a Zilog Z80 based IBM SNA Trunk Network monitoring product.

Managed (six people) a Zilog Z80 based product for real time monitoring of boundary networks. Responsibilities included software development, project planning and monitoring, interface with sales and quality assurance departments, perform on-site troubleshooting, product demonstrations, sales calls, interviewing and personnel performance appraisal.

Formal Education

Villanova University Villanova, Pennsylvania

Master of Science, Computer Science December 1987

Bachelor of Science, General Program May 1982

Contact this candidate