Experienced .NET / PHP / SQL Programmer

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

*** ********** **. # ** *, Jersey City, NJ 07302

(646) 543 4DBH

DANIEL B. HOLODEK

Summary Experienced Developer, utilizing both PHP / MySQL / LAMP and MS: .NET / MS-SQL / Visual Studio toolsets.

Programming Tools PHP / LAMP, Visual Studio 2005/2008/2010 (C#, ASP.NET, JavaScript, SSIS), VISUAL BASIC (3.0- 6.0 .NET), VBA (Excel, Access), Macros, API, VBScript, TRANSACT–SQL, DTS, PL/SQL, .ASP, HTML, COBOL, CSP, Caché Object Script, InterSystems Zen, Yii framework

Database Tools SQL SERVER (6.5, 7.0, 2000, 2005, 2008, 2010), ORACLE (8.0/8i), ACCESS (2.0 – 2010); DAO, ADO, InterSystems Caché, MySQL, TOAD

Integration Tools InterSystems Ensemble, InterSystems HealthShare, MSM Queue, Iguana

Operating Systems Linux, Windows; MS-DOS

Other tools Microsoft Office (Access, Project, Excel, PowerPoint), Visual SourceSafe, VISIO, Crystal Reports, UML, XML, Dreamweaver 4.0, 5.0, FoxPro, DBase I / II, PHPStorm

Work Experience Senior Consultant (2016- present)– Henry Elliot & Co.

•Designed Web-based dashboard system for Hospital ER / Lab Depts.

•Programming: C#, ASP.NET, SQL Server stored procedures

•Connected to InterSystems Cache’ DB via ODBC to extract data from Cache’ view.

•Creates custom web sites for each Department

•Remote work

•Extensive MS-SQL programming

Freelance Consultant (2011- present)– Holodek Consulting, Jersey City

•Definition of project requirements in cooperation with clients.

•DB Design and Development

•Programming: C#, ASP.NET, SQL Server // PHP, MySQL

•Front-end programming in Javascript / JQuery, HTML

•Creates custom web sites

•Creates web-based Invoicing Systems using LAMP tools

•Creates DB-Driven ASP.NET and PHP/MySQL custom Intranet applications

•MVC framework design / programming in both MS (.NET VMC) and PHP (Yii)

•Development of MS-Access applications

•Remote and on-site work

12/2011 – 11/2013 Ready Computing – (NYC)

Sr. Solutions Consultant

.

•Modeling of DB Schemas in Caché.

•Localization of CSP applications (English/Portuguese/Spanish).

•Creation of XML data for localization of applications.

•Programming in Caché Server Pages (CSP) and ObjectScript.

•Programming in C#, T-SQL, (SQL Server) and HTML/Javascript.

03/2011 – 12/2011 NYC FISA (Financial Services Agency)

Consultant / Developer

•Worked on DMS (Debt Management System)

•Reporting in SQL Server / Excel Automation

•Extensive T-SQL Server Programming

•Enhancements and changes to Desktop DMS application in VB 6.0

•Designed prototype for upgrade of DMS to .NET

4/2009 – 03/2011 NYC HHC – (NYC Health & Hospitals Corporation)

Consultant / Developer

•Design and development of C#/ASP.NET/JavaScript/SQL Server applications:

•Designed and coded Web Services to provide XML data for applications.

•Designed and programmed tiered applications using VS 2005/2008, running under IIS and SQL Server 2005.

•Converted legacy fixed-reporting apps developed in MS Access 2003/Excel VBA to Intranet-based thin-client parameterized applications using ASP.NET / JavaScript / C# / SQL Server.

•Used XML to create server-generated custom-formatted Excel spreadsheets for report output.

•Conversion of VBA legacy code to ASP.NET

•Designed and programmed server-side components: DBs, tables and T-SQL Scripts (stored procedures, views, functions) for calls from front-end applications.

•Management of Ensemble – Caché Integration Engine

•Programming in Caché ObjectScript

2/2006 – 8/2008 HFG (Healthcare Finance Group), NYC www.hfgusa.com

Senior Systems Engineer / Lead Developer / Analyst

•Designs, develops and maintains CMS (Client Management System) – a company-wide data-sharing and –mining platform. CMS is a VB 6.0 app designed to connect to the HFG Databases and OLAP Data Warehouse (originally in SQL Server 2000, upgraded to 2005). The app’s flexible design allows users to view information in list and detail forms, and to display related information items with great ease. The app reads the DB structures and constructs the data form accordingly. CMS also links to the Active Directory groups to display and assign users wherever this is required in the data tables.

•The scope of CMS includes tracking of Clients from the Prospect stage (Marketing), through the active stages: (AR Tracking and monthly roll-forwards), and closing.

•Designs, programs and maintains the HFG Intranet – an ASP / SQL Server Intranet app, running under IIS.

•Authors and maintains the CMS HTML Help Files.

•Develops and administers the CMS (OLTP) and CMS Data Warehouse (OLAP) databases. Designs and processes the data cubes. Develops MDX queries to the cubes for use in CMS and the HFG Intranet.

•Develops C# code in Visual Studio 2005 to parse client data files.

•Develops reports in SQL Reporting Services.

•Develops DTS and SSIS packages to preprocess (parse) raw client data, converting the data for use in CMS.

•Develops and maintains new and legacy apps, financial spreadsheets (Excel / VBA) as needed.

12/2005 – 2/2006 Financial Focus Group, AXA Advisors, NYC

Systems Engineer / Consultant

Worked independently to develop a Client Management System / DB for the advisors’ group.

•Designed and programmed entirely in Access 2000 / VBA.

•This application tracks the group’s financial clients through the financial consultation: gathering of financial and personal information, short- and long-term financial goals, and presentation of financial plan.

•Automatic calculation of the clients’ net worth based on income and liability information.

•Implemented as a “split” DB system, with the linked back-end DB residing on a PC designated as a DB Server. The front end was compiled into a shared .mde file.

7/2005 – 12/2005 NYHHC – Bellevue Hospital Center New York City, NY

Systems Engineer / Consultant

Designed, Programmed and Implemented 4 VB / SQL Server / ASP applications:

•“Project Manager”: an n-tier VB / SQL Server 2000 application for the management, tracking, assignment and auditing of IS development projects, issues and enhancements.

•“Project Alerts”: an app running as a DTS-scheduled job that informs IS personnel of new tasks assigned via the Project Manager application. The alerts are sent via email, using GroupWise e-mail automation in VB 6.0

•“Training Scheduler”: an n-tier VB / SQL Server 2000 application for the scheduling of Resident and Attending Physician training classes in the various hospital IS systems.

•“Training Sign-up”: an ASP application that allows Residents and Attending Physicians to sign up for training classes on-line through the NYHHC Intranet.

Main tools: VB 6.0; Microsoft SQL Server 2000 Enterprise Manager, Query Analyzer, DTS, Transact-SQL, Stored Procedures, Triggers; ASP/HTML, VBScript, Visual SourceSafe.

7/2004-7/2005 ABN-AMRO / EDS Jersey City, NJ

Data Conversion Programming Team Lead / Project Manager

•Led the design of the Global Conversion Process DB (MS/SQL 7.0)

•Developed 6 of the 10 software tools necessary for the Data Conversion Process. (VB, VBA, VBScript, Transact/SQL).

•Managed a team of 5 developers/analysts in the US and Latin America as part of the global migration of ABN-AMRO from Windows 98/NT to Window XP.

•Worked to convert traders’ Excel spreadsheets with Market data feeds (Bloomberg, Reuters.)

•Worked in conjunction with the hardware & packaging teams to schedule rollouts.

•Assigned tasks, supervised development, managed the group and provided Managements Reports (in both English and Spanish).

•Successfully rolled out 1,202 users in the US and Latin America.

11/2003 – 6/2004 The Americas Society, 680 Park Ave., NYC

Database Consultant / Programmer

Development of AS Composer’s Database prototype:

•Prepared and Presented Project Presentation in MS PowerPoint.

•Designed RDBS back-end tables.

•Built VBA Code in Access 2000 to migrate existing Excel data into new table structures.

•Designed new DB query pages in accordance with existing www.americas-society.org corporate site style.

•Coded the Web Page in ASP / VBScript.

•Designed and developed front-end data entry tool using VBA (Access).

Technologies: (Access 2000 – w/eventual upgrade to MS/SQL Server). VB, .ASP, VB Script, DHTML, VBA, Macros, Windows XP, NT

4/2001 – 11/2003 Banco Columbia, Buenos Aires, Argentina

Senior Programmer / Analyst

Design, Development and Maintenance of n-tier Financial applications (VB 6.0, .ASP and PL/SQL):

•Maintained Client Management app used for Client input & Loans processing according to changing loan parameters as defined by the Commercial Area.

•In charge of the full life cycle: design, coding, testing, and implementation of n-tier app used by the Legal department to process defaulted loans. This project included extensive development and re-engineering in VB and PL-SQL: all necessary RDBS back-end table scripts, trigger and stored procedures.

•Was instrumental during the conversion of Columbia from Financial Co. to Bank.

•Developed additional functionality in Client app to handle new Banking products: Checking Accounts, Debit & Credit Cards, ATM tie-ins.

•Worked on the Intranet-based Client Accounting Module. This module showed the Clients’ transactions, including currency exchange (the very popular type of “investment” product in Latin America), as well as Portfolio Accounting (calculating Net Capital G&L, Ending Cash Balances, etc.) for the Clients’ investment portfolio. This module was fed by a variety of SQL Stored procedures and COBOL programs which provided the accounting data.

•Maintained and Developed new functionality for Administrator, an app that handled the input, maintenance and transmission of the core business entity tables (i.e.: branches, commercial and geographic regions and various global parameters between the Home office and remote branch DB servers nationwide)

•Reported, demonstrated, documented, and presented work using Microsoft Office Products (Excel, Project, Word).

•Design, coding, testing and implementation of currency conversion tables and major reprogramming of all apps during Argentina’s 2002 economic crisis.

•Maintained and developed additional functionality for Intranet Management Module (an ASP/ VBScript Intranet app used by Bank Management to oversee all Columbia operations). This tool included modules for the query, extraction and export of data into Excel.

•Maintained Communications Services and other .DLL used on Servers in offices nationwide to transfer loan application and other critical data.

•Acted as main liaison between the COBOL and New technology (VB/ASP) programming teams.

•Converted many Accounting apps and encryption routines from COBOL to a combination of VB & PL/SQL.

Main Technologies and tools used: VB 6.0, VBA & Macros, ADO, SQL Navigator / Plus / Worksheet, Oracle 8.0, 8i BE, Citrix, Microfocus COBOL, Windows XP, NT, Windows 2K, IIS, VBScript, ASP, HTML, Citrix Terminal Server, PC Anywhere.

2/2001 – 4/2001 Banco Galicia, Buenos Aires, Argentina

Consultant / Developer

•Developed “ConsultaVeraz” a VB 6.0 desktop app used by Banco Galicia nationwide for the request and reception of Credit Information from the Veraz National Credit Bureau mainframes.

•Worked in conjunction with Banco Galicia’s COBOL programmers to develop the TSs necessary for PC-to-Mainframe communication.

11/2000 - 2/2001 Pfizer Pharmaceuticals, NYC

Consultant / Microsoft Access specialist

•Redesigned and updated a Candidate Tracking System from Access 97 to Access 2000 for Pfizer’s Human Resources department.

•Normalized data, Reconfigured Reports and redesigned Data Entry forms.

6/2000 –10/2000 Coolfire Interactive, New York City

Applications Developer / Consultant

•Developed 'Ford Dealers & Incentives' --a front-end data input tool in VB 6.0 for Ford Motor Company management of Prices and Incentives for Ford dealers on a nationwide basis.

Tools used: VB 6.0, Data Classes, Access 2000 automation, SQL Server 7.0

6/1999- 6/2000 TNT USA, Inc. Garden City, NY

Senior Developer / Programmer/Analyst / Project Manager

TNT is the world’s largest privately-owned mail company (www.tnt.com).

•Lead the TNT Mail programming team of 4 members, assigning tasks and managing projects.

•Developed new tracking system for mass mailings, based on import and statistical analysis of flatfile data transmitted from remote mail processing centers worldwide.

•Designed and implemented various reporting tool for Operations Management in Access 97/VBA and VB 6.0.

•Modified and upgraded various custom mail management apps for TNT Clients, including Victoria's Secret, Publisher’s Clearing House, and AMEX.

•Language skills were crucial for work both in the U.S. and in Canada.

•Maintained and rebuilt TNT’s pricing spreadsheet apps (VBA & Macros).

•Developed call tracking system/app for the TNT Customer Service Call Center.

•Enhanced TOMAS: an Access 97 DB application implemented via Citrix.

Main tools: VB 6.0, Microsoft SQL Server 7.0 (including DTS), Excel VBA, Access 97, Citrix Terminal Server.

1998- 5/1999 McElroy Consulting Associates New York City

Programming Team Leader

Clients included Seiko Corp., UNESCO and Morgan/Stanley

•Led a team of 3 programmers, managing projects for UNESCO and other clients.

•Maintenance of Morgan/Stanley’s Real Estate DB app, written in ARCHIBUS

•Assisted in the design and coding of a comprehensive management app for Seiko Corp.’s largest U.S. distributor.

Main tools: ACCESS 97, Microsoft SQL Server 6.5, VISUAL BASIC 5, ARCHIBUS.

1993-2000 Rennert Bilingual Institute, New York City

Programmer / Database Manager

•Design, coding, implementation, documentation and support of RDBS School Management Program in ACCESS (2.0- 97), with VBA and Macros.

•Importing and Normalization of data from old flatfile (CLIPPER/dBASE) system.

•Application Functionality encompasses all aspects of school management, including Enrollment, Class Lists, Invoicing, Student, Teacher and Agent data, and varied Statistical Analysis reporting functions.

Main Tools: Access 2.0 – 97 VBA, Macros, Microsoft Jet DAO.

1987 US Catholic Conference New York City

Junior Programmer / Paralegal / Office Assistant

•Assisted Immigration Officer in preparing and electronically filing cases for refugees and legal immigrants in various languages.

•Duties included simultaneous interpretation and translation of affidavits and other documentation, immigrant counseling and interviewing, data entry.

•Coded in Dbase.

Education Electronics Engineering –completed 1 year Buenos Aires University, Argentina

Systems Analyst I Programmer (La Plata Sistemas, La Plata, Argentina)

Master Course in Microcomputers and Microprocessors (NRI Schools) Graduated with a 90.3 average.

Publications Spanish AII the Way™ II- Crown/Random House Publishers. Intermediate / Advanced Spanish textbook for speakers of English. Includes sections on Business protocol and customs in Spanish-speaking countries. Features CD / tape companion study guides.

Translated and Edited Tango y Vida / Tango & Life – Bilingual (Spanish/English) book on history of Argentine tango. Published by The Americas Society.

“A conversation with Mario Lavista and Alejandro Escuer: Literature and Arts of the Americas”, November 2004, vol. 37, no. 2, pp. 270-276(7).

Languages Spanish, English, French, Portuguese, Italian, Russian, Ukrainian, ASL, Esperanto

Contact this candidate