Sign in

Manager Sql Server

Ronkonkoma, New York, United States
April 21, 2017

Contact this candidate

Resume of

James M. Reilly

516-***-**** (Cell)

Summary of Experience

Many years of development experience including management, design, analysis, programming, testing, documentation, support and user education of various web and desktop applications (full project life cycle - Waterfall development methodology). Concentration in .NET business systems.


PC / Compatibles (Windows 7 / 2003 / 2000 / XP / NT / 9x / 3x)

Sun servers (Solaris)

VAX / Alpha (VMS, Open VMS, standalone/ clustered)

Database Systems

SQL Server 2012 / 2008 / 2005 / 2000 / 7.0 / 6.5

Access (2003 / 2002 / 2000 / 97 / 95)





Languages / Software

Visual Studio.NET 2012/2010/2008/2005/2003/6.0

.NET Framework 4.0 / 3.5 / 2.0 / 1.1


Team Foundation Server (TFS)

Infragistics Controls

Telerik Controls

Crystal Reports 8, 9,10, 11 / Enterprise


WebForms / Web Services

Transact-SQL / PL-SQL / MySQL


OPICS Architecture Toolkit


Visual SourceSafe (VSS)

ComponentOne Controls



WinForms / Windows Services

HTML / CSS / ASP.NET / JavaScript

UNIX / Korn Shell / Shell Script

Putty (Web Farm load balancing)

Detailed Business Experience

Intersite Technologies (Consulting F/T & P/T) Manager/Programmer [1/2006 - Present]

Design, coding and support of a web-based compliance questionnaire system for a leading brokerage fir. The personnel working on the individual trading desks were given special login accounts on the corporate intranet, in order to automate the filling-out of questionnaires that are required by regulatory agencies. Provided compliance management with a rich set of functions to setup new web users, maintain question libraries, assemble questionnaires, schedule the completion of the questionnaires, and various methods of monitoring and inquiring on questionnaires and their statuses. Designed and implemented a nightly scheduler to notify the compliance system users (via e-mail) of all outstanding questionnaires. Additionally responsible for enhancements to an options trading system, and re-designed the application modules to integrate an more object-oriented architecture, and make the components re-useable to other applications. The enhancements allowed the core modules (containing the business rules, and utility methods) to be readily accessible, so that the common functionalities could be easily accessed, without the need to re-code the standard methods used by all applications.

C#, VB.Net, Visual Studio.NET 2008/2005/2003, ASP.NET, WinForms, WebForms, Active Reports, Infragistics controls, Component One controls, AJAX controls, Crystal Reports, Web Services, SQL Server 2008/2005/2000, SSRS/SSIS, NET Framework 1.1 / 2.0 / 3.5 / 4.0

PetCareRx, Inc. (Perm F/T) Programmer/Analyst [2/2012 - 3/2014]

Design, coding and support of several web/desktop e-commerce related applications for a leading pet care supplies and pharmaceuticals firm. The company maintained a public-facing e-commerce website, as well as an internal (intranet) website, both with the capability to enter customer orders for pet-care supplies and pharmaceuticals. The ordering on the internal website was performed by agents manning an 800-exchange telephone call center. Programmed enhancements to the internal website, which were deployed to a staging server for QA testing, then deployed the accepted changes to a load-balanced Production web farm. Also programmed enhancements for many of the in-house desktop applications that control and monitor pharmaceutical workflows, remote vendor (suppliers), inventory and warehousing. Designed and implemented a security/role schema to control which internal personnel (by user or group) could access each of the functions in all internal applications. Designed and implemented a new inventory control application, while re-designing the company's warehouse to provide more efficient use of the available space in order to fulfill a greater number of customer orders in a shorter period of time.

C#, Visual Studio.NET 2012/2010/2008/2005, Team Foundation Server, ASP.NET, WinForms, WebForms, WCF, AJAX controls, Telerik Controls, Crystal Reports, SSRS, SSIS, .NET Framework 3.5/4.0/4.5, SQL Server 2012/2008, Putty

Bimbo Bakeries (Consulting F/T) Manager/Programmer [1/2009 - 9/2010]

Conversion of a nationwide sales-shortage reporting system, for a major baked goods manufacturing conglomerate, from using an un-normalized MySQL database, to a normalized SQL Server database. Redesigned and implemented new procedures for loading 500,000 UPC-scanned items from various supermarket/sales chains, on a weekly basis, as well as implementing a new company sales hierarchy within the reporting database. Implemented controls to alert management (and support), via e-mail, of any violations of referential integrity within the SQL Server database, during the weekly loading of files sent via EDI. Interfaced with the EDI group to resolve feed issues. Converted the Crystal reports to use ODBC connections, new report groupings, and SQL Server database interfaces, instead of MySQL interfaces. Responsible for the design, implementation and testing of a web-based inquiry interface to allow management to determine the report utilizations by sales-shortage analysis, with the capability for detailed drill-downs. Many different bakery companies were supported in this effort, including Entenmann's, Stroehmann's, Thomas's, Arnold, Boboli, etc., with multi-billion dollar sales nationwide. Upgraded all ASP.NET-based reporting interfaces to use .NET Framework 2.0 / Visual Studio 2005, from Framework 1.1/Visual Studio 2003.

VB.Net, Visual Studio 2005/2003, ASP.NET, WebForms, SQL Server 2008/2005/2000, EDI (interfacing), MySQL, Windows Services, .NET Framework 2.0/1.1, Crystal Reports 10/Enterprise

Deutsche Bank (Consulting F/T) Manager/Programmer [1/2007 -11/2009]

Analyzed and migrated an existing GIC investment management system (portfolio management) from Visual Basic 6 to Visual Basic.Net/C#.Net, as well as an associated reporting system using the same data. All portfolios were represented in a standard hierarchical structure within a Sybase database. Re-designed the user interface to improve productivity and ease-of-use, using Infragistics controls. The systems encompassed more than 50 clients, and supported 25 users at various locations. Reporting was provided through the use of Crystal Reports 10. Implemented specialized deployment software for automated updating of the local copies of the application. After migration, provided documentation, support and additional business-related enhancements to the system. Additionally responsible for coding an application to provide real-time ledger and trade entry capabilities for Cash Desk management and control. Linked the application to the existing Charles River front-office trading system.

VB.Net, C#, Visual Studio.NET 2005/2003, VB6, Sybase, ORACLE, WinForms, WebForms, Web Services, MS Enterprise Library, Crystal Reports 10, Infragistics controls, .NET Framework 1.1

Fortis Bank (Consulting F/T) Manager/Programmer [1/2006 -11/2006]

Designed and implemented the building blocks of an object-oriented middle-office risk management system, providing unattended nightly capturing and normalizing of all trading information from the various front-office and back-office trading systems, as well as offering automated nightly reporting. Also designed and implemented the user interface that provided for reconciliation, adjustments, drill-down inquiry and generation of the required daily management accounting reports of all FX and loan processing activity. Implemented a fool-proof solution for the scheduling of all data flowing in and out of the system, by creating a 24-hour task scheduler, with a robust and flexible programming interface, driven from tables in the main database.

VB.Net, C#, Visual Studio 2005/2003, ASP.NET, WinForms, WebForms, SQL Server 2005/2000, Component One controls, Infragistics controls, .NET Framework 1.1, ACCESS 2003, EXCEL 2003

Santander Centrale Hispano Bank (Consulting F/T) Manager/Programmer [9/2002 -12/2005]

Design, maintenance, support and enhancement of an existing OPICS application, encompassing the F/X, Fixed Income and Repo product lines. Responsible for design and implementation of generalized workflow monitoring tools, and data integrity checking. Designed and implemented a trade clearing reconciliation application using daily feeds from the Euroclear clearing service. Integrated the clearing programs into OPICS using the OPICS Architecture Toolkit, enabling the Back-office users to automatically reconcile all trades sent to Euroclear daily. The software decoded the daily feeds received from Euroclear, as well as tracking all trades sent to Euroclear, and maintained a running history of the settlement of all cleared/failed trades, with full reporting capabilities. Performed analysis and coding of trading activity reports and SWIFT transaction reports for another in-house trading system, for handling OTC options. Responsible for design and implementation of a parameterized inquiry/reporting package, that allowed all of the bank’s users to have a single, consistent web interface to its ORACLE database and Crystal Reports. It provided both batch and online interfaces which replaced their costly Crystal Enterprise reporting platform, with full security tailored to the needs of the individual departments and users. Responsible for analysis and implementation of components of an in-house back-office trading system, which was intended as a replacement for OPICS. Implemented various trading instrument reconciliations for end-of-day closing.

VB.Net, VB6, OPICS, Crystal Reports, Perfect Match, SWIFT, ASP.NET, WinForms, WebForms, .NET Framework 1.1, ORACLE, PL-SQL, ACCESS 2003/2002/2000/97, EXCEL 2003/2002/2000/97

American Express (Consulting P/T) Programmer/Analyst [7/2004 -12/2004]

Analysis of an existing front-office and back-office OPICS F/X trading application, to gather current transactional statistics and future needs, to propose new hardware and software purchases to accommodate the users’ plans for expansion. Provided detailed documentation on all phases of current system activity, as well as program modifications that would be required to allow two new trading locations in other time zones. Prepared comparisons of various relational database packages to meet future requirements. Proposals were submitted for several different upgrade configurations, due to client cost constraints. All hardware and software must be made available for 24-hour trading due to the time zone differences, and nightly batches and upload/downloads were staggered for optimum system performance, with full failover capabilities.

VB.NET, VB6, WinForms, WebForms, OPICS, Perfect Match, SWIFT, SYBASE, ORACLE, .

NET Framework 1.1

Experience prior to 2002 includes:

Chase/Chemical/MHT (F/T Consulting & P/T Consulting)

VB 3,4, SQL, ACCESS-95, VAX VMS Basic

Lehman Brothers (P/T Consulting Only)

Visual FOXPro, FOXPro/DOS, Dbase, Xbase RDB

Contact this candidate