[Send email using form at bottom]
100 Montgomery St. # 15 F, Jersey City, NJ 07302
DANIEL HOLODEK
Objective To obtain a position as Senior Applications Developer /Analyst
Programming Tools VISUAL BASIC (3.0- 6.0, .NET), Visual Studio 2005/2008 (C#,
SSIS, .NET), VBA (Excel, Access), Macros, API, VBScript, TRANSACT–SQL, DTS,
PL/SQL, MDX, .ASP, HTML, COBOL
Database Tools SQL SERVER (6.5, 7.0, 2000, 2005), ORACLE (8.0/8i), ACCESS (2.0 –
2002); DAO, ADO, Analysis Services
Operating Systems Windows XP, NT, 2000, 98, 95, 3.11; Citrix Terminal Server,
MS-DOS, CP/M
Other tools Microsoft Office (Access, Project, Excel, PowerPoint), Visual
SourceSafe, VISIO, Crystal Reports, UML, XML.
Work Experience 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 modifies new and legacy apps 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.
• 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
Programmer / Analyst - 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 Team Lead Developer / 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
|
