Alex E. Luyando, PMP
AREAS OF EXPERTISE
•
Database Application
Development -
Complete System
Development Life Cycle
(SDLC) including
business requirements
gathering, analysis, database
and application design and development
using Microsoft technologies (especially
Microsoft Visual FoxPro).
•
Project Management - Certified Project
Management Professional (PMP). Project
management and coordination of multi-
discipline team including business,
technical and support staff. Extensive
experience in banking, healthcare,
insurance, financial services, publishing and
more, with Agile and Waterfall experience.
Ability to successfully manage projects
from project charter to delivery.
•
Database Application Management -
Project, business and user management,
support, training, troubleshooting,
debugging, maintenance and enhancement
of existing database applications.
PROFILE STATEMENT
Accomplished IT professional with extensive
experience in database application
development, IT software project
management, business requirements
gathering, analysis, reverse engineering of
legacy database applications, technical and
project documentation, application and user
support, thought leadership and strategic
planning. Demonstrated accomplishments in
planning and directing start-up projects,
analyzing and developing complex business
applications, understanding and managing
existing production applications, and
managing and mentoring technical staff.
Extensive experience in the full System
Development Life Cycle (SDLC), Waterfall
and Agile project management. Noted for the
ability to introduce control, efficiency and
innovative solutions to solve complex and
chronic business problems.
Thrives in an environment where knowledge,
effort and determination can make a
difference. Highly-organized with exceptional
communication skills and extensive
experience in analysis and design, application
development, project management,
maintenance and support of newly-developed
and existing/legacy mission-critical
applications, and complete project
management of major IT development
projects.
Insightful developer of new applications and
skilled at understanding and enhancing
existing applications. Exceptional project
management and organizational
skills with ability to manage large,
complex projects while maintaining
control over time, cost, and quality
(aka, “triple-constraints”).
A reputation for maintaining
unrelenting focus on overall
organizational and business
objectives and ability to determine
when short-term fixes are
appropriate rather than long-term
solutions. A creative thinker in
identifying solutions to complex
business and technical challenges,
and a significant “outside-the-box”
mindset.
CAREER HIGHLIGHTS
•
Assumed technical and
management responsibility of the
New York State Medicaid
Financial Management Tracking System (MFMTS – FoxPro)
application, which handles $1.5 Billion weekly.
•
Several reverse engineering and migration projects of mission-
critical applications spanning several technologies and in varying
roles.
•
Decentralized General Ledger processing at Citibank, N.A., saving
the company over $40 million.
•
Developed the main operational database application that allowed
Mobile Diagnostic Services, Inc. to double revenue while reducing
staff size and expenses in the healthcare services industry. The
application’s object-oriented design allowed for greater scalability
and reduced maintenance costs. This application was developed to
automate 24/7 manual operations in a time- and data-critical
environment and has been functioning daily since 1992!
•
Converted a major alternative investment (hedge) fund application
from a Visual FoxPro backend database to Oracle resulting in
greater scalability, reliability and performance.
•
(Subsequent to a three year failed attempt by a third-party
consulting firm) analyzed, designed and developed a mission-
critical index review application used by a major index provider
(S&P Dow Jones Indices) to manage the composition of over
300,000 equity indices. As part of the one-and-a-half year project
managed a team of developers and was responsible for all
coordination with our business counterparts.
•
Assumed responsibility for and stabilized existing out-of-control
mission-critical applications at Westdeutsche Landesbank
Girozentrale (WestLB) and Princeton Insurance Companies,
allowing the firms to reduce development expenses and meet new
and changing business and regulatory demands.
•
Ran and participated in several key projects in banking (personal,
institutional and investment), alternative investments (hedge funds),
insurance, healthcare, medical, publishing and other industries.
PROFESSIONAL EXPERIENCE
Application Architecture and Development
•
Analysis, maintenance and enhancement of the New York State
Medicaid Financial Management Tracking System (MFMTS –
FoxPro) system, responsible for accounts receivable processing for
all Medicaid claims in the State of
New York.
•
Successfully completed the
analysis (including business
requirements gathering and user
workflow documentation),
conceptual design, project
management and program
development for new custom-
designed database applications for
a variety of organizations.
Systems developed include index
composition management, market
data (symbology), order entry,
shipping, billing and control
application, patient service
request and medical technician
dispatching, a placement agency
candidates/position matching,
database integrity checking and
repair, and several system and
end-user maintenance
applications. Most of these
applications resulted in improved
business operations and reduced
costs and required management of
multi-disciplinary project teams.
•
Demonstrated ability to
understand and assume
responsibility for existing
production applications, leading
to improved application stability
and enhancement. These
applications often were in
precarious condition without proper source code control, change
control, technical documentation, etc. Immediately introduced
various tools and procedures such as Visual SourceSafe, formal
testing and production change control procedures, peer code review
and walk-throughs, and development standards to improve
application stability and reduce maintenance costs.
•
Database schema design and implementation for mission-critical
databases running under Visual FoxPro, Microsoft SQL Server
(2000, 2005, 2008, 2012), Oracle and Sybase SQL Server.
•
Extensive application migration experience including General
Ledger decentralization and conversion of legacy FoxPro databases
and applications to Visual FoxPro (OOP), PowerBuilder/Sybase
SQL Server, Microsoft SQL Server and Oracle environments.
Experience includes departmental as well as corporate scale
databases with individual tables supporting over sixty million rows
and over 26 Gigs of data space. Total server row counts into the
billions and data space in tens of terabytes.
•
Extensive experience developing, maintaining and managing
production batch operations in both mainframe and desktop/network
environments, including the implementation and use of Seagate’s
Ashwin Job Scheduling software as well as custom-developed job
scheduling sub-systems.
•
Design and development of application programs, reusable classes,
objects and tools to reduce development cost and improve
application stability. Significant Visual Studio .NET and Visual
FoxPro OOP experience, including the use of the StrataFrame and
Visual FoxExpress OOP, n-tier application frameworks. Successful
use of Structured Analysis and UML modeling tools and techniques,
including data flow, class and sequence diagrams.
•
Webmaster responsibilities including full site redesign and database
management.
•
Extensive experience providing clear and concise application
documentation (technical and end-user), user training, application
deployment and production support experience, including off-hours
and 24/7 support.
•
Extensive management and user contact in all phases of application
development and maintenance.
Project Management and Team Leadership
•
Project Management Professional (PMP) - (PMI PMP ID
2959813)
•
Complete creation and orchestration of project plans (Microsoft
Project), including project and associated domain/schema
documentation and continuous user interfacing.
•
Tracking of major project milestones and CPI (cost performance
index) and SPI (schedule performance index) to identify and
monitor project slippage.
•
Status reporting to all levels of management and project
stakeholders; coordination with Project Management Office (PMO).
•
Full end-to-end responsibility for project success.
•
Demonstrated ability to assume responsibility for rescuing failing
projects and provide the technical, organizational and project
management skills needed to
successfully turnaround the
endeavor. This has included
mainframe, Visual FoxPro and
.NET projects, and saved one
company over $40 million.
•
Training and mentoring of junior
developers and technical staff.
This included formal classroom
training for FoxPro developers at
Dow Chemical in preparation for
a major development effort.
•
Successfully assumed
management responsibility for
support and maintenance of
critical business applications in a
variety of situations and
platforms. Improved application
stability while meeting changing
business needs and requirements.
In several cases allowed
organizations to reassign
development staff to other
projects while assuming full
development, maintenance and
production support
responsibilities for existing
mission-critical applications in the
banking, brokerage and insurance
industries.
Business Management and Entrepreneurship Experience
•
Launched J.C.N. Associates, L.L.C. to provide clients with high-
quality information technology consulting with specialization in
project management and database application design and
development. Managed all aspects of the business including
marketing, sales, staffing, analysis, design, development of
applications, and on-going support.
•
Directed and participated in the development of mission-critical
applications for various clients in industries such as banking,
finance, healthcare/health services, insurance, publishing and others.
These applications were developed using technologies such as
Microsoft FoxPro and Visual FoxPro, FoxExpress (both Visual and
2.7), Microsoft SQL Server, Oracle, Visual Studio .NET and several
others. The applications provided functionality such as accounting,
management profitability and financial reporting, profit and loss
analysis, order processing control and medical technician
dispatching and control. Organizations range from Fortune 100
companies to small- and medium-sized businesses.
•
Responsibilities at several of these organizations included analysis,
application development, and application support for preexisting
production application and project management duties for several
other consultants and employees. Extensive experience in dealing
with management and end users at all levels.
•
Prior experience as an IT and operations auditor, and as an
operations Manager in Financial Control ensures a control-
conscious approach to application development and production
support.
PROFESSIONAL HISTORY
J.C.N. Associates, L.L.C. (1991 – Present)
New York / New Jersey
Multiple industries | Roles: Project manager; Database
application architect and developer; entreprenuer
Information Technology Consulting – Database
Application Development
o
Manage all aspects of J.C.N. Associates (staffing,
client relationships, development)
o
Senior Project Manager (PMP) on all engagements,
responsible for delivery of project on-time and
within budget.
New Jersey Amateur Racquetball Association | NJAR (2014 –
Present)
New Jersey
Industry: Health and Fitness | Roles: Web developer; Project
manager; Board member (management); Sponsored by Head
PENN Racquetball
Website Redesign/Maintenance for 501(c)(3) Non-Profit
Organization
o
Project management of website redesign (2014) to
achieve organizational goals defined by the NJAR
Board of Directors.
o
Complete redesign of the website from the ground-
up using Xara Web Designer Pro and Xara
Designer Pro X
o
On-going communication with major
stakeholders/board members as needed.
o
Technologies used included: Xara Designer Pro,
Trello (Agile/SCRUM), Microsoft Project, Evernote
New York State Dept. of Health – Medicaid Financial
Management (2014 – 2017)
Albany, New York
Industry: Healthcare | Roles: Accounting Systems; Database
Application Developer; Project Manager
FoxPro Enhancement, Management and
Migration/Reverse Engineering
o
Assumed responsibility for the maintenance and
management of the mission-critical Medicaid
Financial Management Tracking System (MFMTS –
FoxPro) Accounts Receivables database application
responsible for New York State Medicaid
processing of over $2 Billion weekly.
o
Responsibility for FoxPro project management as
part of a $500+ Million migration project to a
custom Xerox HE medical claims and accounting
application (aka, NYMMIS).
o
Reverse engineering of undocumented system and
business processing logic using various tools
(Microsoft Visio, Microsoft OneNote, Evernote,
Microsoft Word) to create project artifacts for
maintenance purposes and to provide for detailed
presentation to migration project team members.
o
Enhancement of in- and out-going data feeds to
other New York State Department of Health
Medicaid and financial systems including CSC
eMedNY, The Medicaid Data Warehouse (MDW),
and the State Financial System (SFS).
o
Management of application updates and
introduction of a formal release process (including
source repository construction and control, release
notes, and fallback/backup facilities).
o
Full use of Agile project management principles,
including use of Trello for automated SCRUM
support.
o
Technologies used included: Microsoft Visual
FoxPro, Microsoft Project, Microsoft Visio, Trello
(Agile/SCRUM tool), Microsoft Office.
Mobile Diagnostic Services, Inc. (1991 – 2016)
Wayne, New Jersey
Industry: Healthcare | Roles: Database application architect
and developer; Project manager
New Application Analysis, Design, Development,
Deployment and Support
o
Design and development of a medical/healthcare
order entry, dispatching, financial and monthly
reporting system.
o
Developed the main operational database
application that allowed Mobile Diagnostic
Services, Inc. to double revenue while reducing
staff size and expenses in the healthcare services
industry. The application’s object-oriented design
allowed for greater scalability and reduced
maintenance costs. This application was developed
to automate 24/7 manual operations in a time- and
data-critical environment and has been functioning
daily since 1992!
o
Full project management of all aspects from
business requirements gathering through user
training and application deployment.
o
Complete analysis of all business requirements and
design of all database and software components.
o
Technologies used included: Microsoft Visual
Studio .NET, Microsoft Visual FoxPro, Windows
and Mac OS, Web Services, Microsoft Office
(Project, Word, Excel), and more.
MultiPlan (2013 – 2013)
New York, New York
Industry: Healthcare | Roles: Financial/accounting systems
management; Reverse engineering
Project Management, Reverse Engineering and Legacy
Application Migration
o
Project Manager for a small team responsible for
complete reverse engineering of a legacy healthcare
accounting (fee processing and billing) application;
coordination with Project Management Office
(PMO).
o
Migration project managed using full Agile
principles, including daily SCRUMs.
o
Project completed successfully under extremely
tight time constraints. Initial project rescue efforts
required 70+ hours per week for an extended
period of time in order to bring project’s SPI
(Schedule Performance Index) back in line with the
project baseline.
o
Project technologies included: Microsoft Visual
FoxPro, Oracle, Microsoft Visio, Java, Microsoft
Project, and Evernote.
o
Technical presentations to the project team (co-
located and remote) based on created reverse
engineering artifacts (e.g., Visio data flow
diagrams, UML diagrams, etc.)
o
Full documentation of the legacy application’s
processing logic for PEPM (Per Employee/Per
Month) and Capitated billing.
o
Technologies used included: Microsoft Visual
FoxPro, Microsoft Visio, Microsoft Office, Oracle,
Toad for Oracle.
Dow Jones Indexes/CME Group/S&P Indices (2007 – 2013)
South Brunswick, New Jersey
Industry: Financial services | Roles: Project manager;
Database application architect and developer
Application Architect/Technical Consultant Lead –
Database Application Design and Development;
Project Management
o
Project management of several major projects,
including migration of the Index Review process
from Visual FoxPro to Visual Studio .NET/C# and
SQL Server.
o
Project manager and team leader for several
projects involving inter-disciplinary teams.
o
Project manager for a major consolidation project to
support the Dow Jones Indexes and Standard &
Poor’s corporate merger.
o
Project methodologies used included Waterfall and
Agile models.
o
Full management responsibility for the iSource
Index Calculator, Forward Corporate Actions,
iSource Data Upload and other mission-critical
applications.
o
Documentation and maintenance of applications
responsible for index calculation, including the
Dow Jones Industrial Average and over 130,000
other indices.
o
Subsequent to a three year failed attempt by a
third-party consulting firm analyzed, designed and
developed a mission-critical index review
application used by a major index provider to
manage the composition of over 300,000 equity
indices. As part of the one and a half year project
managed a team of developers and was responsible
for all coordination with our business counterparts.
o
Database scale: Over 1 Billion rows and over 1
terabyte in used server space.
o
Responsible for code base over 100,000 LOC (lines-
of-code).
o
Technologies used included: Microsoft Visual
FoxPro, Microsoft Visual Studio, Microsoft SQL
Server, MicroFour StrataFrame and F1Tech Visual
FoxExpress (object-oriented application
development frameworks), Microsoft Visio,
Powersoft Power Designer (modeling tool),
Microsoft Office.
Delaware Valley Miata Club (2006 – 2010)
Delaware, Pennsylvania and New Jersey
Industry: Recreation | Roles: Web developer; Board member
(management)
Board Member, Webmaster and Web Database
Management and Support
LineData Services/Global Investment Systems, Ltd. (2005 –
2007)
Hackensack, New Jersey
Industry: Financial services | Roles: Hedge fund accounting
system; Application architect
Application Analysis, Design, Development,
Deployment and Support
Vitamin Retailer Magazine (1996 - 2006)
East Brunswick, New Jersey
Industry: Publishing | Roles: Project manager; Database
application architect and developer
New Application Analysis, Design, Development,
Deployment and Support
GMAC/HomeConnects (2004)
Horsham, Pennsylvania
Industry: Financial services | Roles: Database application
developer
Visual dBase and Visual Basic Analysis, Design,
Development, Deployment and Support
General Media International (1993 - 2004)
New York, New York
Industry: Publishing; Roles: Project manager; Database
application architect and developer
New Application Analysis, Design, Development,
Deployment and Support
Princeton Insurance Companies (2000 - 2004)
Princeton, New Jersey
Industry: Healthcare; Medical malpractice insurance | Roles:
Project manager and database application architect/developer
Application Management, Development and Support
(Microsoft Visual FoxPro and SQL Server)
Westdeutsche Landesbank | WestLB (1993 – 1999)
New York, New York
Industry: Banking | Roles: Project management; Database
application developer
Application Management and Development;
Application Support for Preexisting Applications
Globe Placement Services (1993 - 1998)
East Brunswick, New Jersey
Industry: Employment services | Roles: Project manager and
database application designer and developer
New Application Analysis, Design, Development,
Deployment and Support
Citibank (1994 - 1996)
New York, New York
Industry: Banking | Roles: Project manager; Database
application architect and developer
New Application Analysis, Design, Development,
Deployment and Support
HomeLife Insurance Company (1991 - 1992)
Piscataway, New Jersey
Industry: Insurance | Roles: Application manager.
Application Management and Development;
Application Support for Preexisting Applications
Citibank, N.A. (1979 - 1991)
New York, New York
Industry: Banking | Roles: Application and project
management
Vice President – Accounting and General Ledger
systems for Head Office Accounting and the
Investment Banking Divisions.
TECHNICAL SKILLS
Languages and development environments
•
Microsoft Visual Studio .NET – C#
•
Visual FoxPro – all versions through 9.0
•
MicroFour StrataFrame database application
development framework for .NET
•
F1 Technologies’ Visual FoxExpress OOP database
application development framework
•
FoxPro (2.x) and FoxBASE – DOS, Windows and Apple
Macintosh
•
Visual dBase; dBase III
•
PowerBuilder 4.0 - 7.0
•
West Wind Web Connection
Software
Application Development Frameworks
•
StrataFrame (.Net OO/n-tier/layered architecture)
•
Visual FoxExpress (OO/n-tier)
Database:
•
Microsoft SQL Server
•
Oracle
•
Sybase SQL Server
•
Microsoft SQL Server Integration Services (SSIS)
Database Tools
•
Toad for SQL Server, Toad for Oracle
•
dbArtisan
•
Sybase PowerDesigner (UML)
•
FoxFix, dSalvage
•
Data Junction
•
Sybase BCP (Bulk Copy)
•
Stonefield Database Toolkit
•
Monarch (data mining)
Development Tools
•
Visual SourceSafe, SVN, CapCon, PVCS
•
Multi-Edit
•
Office Automation
•
Query Maker (Ad-hoc Reporting Tool)
•
Crystal Reports
•
Microsoft Project
•
MS Visio
•
UML, FrontPage
•
Xara Web Designer
•
SharePoint
•
COM/ActiveX
•
Microsoft Virtual PC, Oracle VirtualBox
OSs
•
Microsoft Windows (all versions for workstations and
servers)
•
DOS
•
Macintosh OS—through 8.x
Office Suites:
•
Microsoft Office, Corel Perfect Office, LibreOffice MS
Publisher, Baler XE
Business Packages:
•
Quicken, QuickBooks Pro, Pacioli Accounting
•
Hyperion
•
Seagate Ashwin (job scheduling)
•
McCormack & Dodge
EDUCATION and CERTIFICATIONS
Project Management Institute
(PMI.ORG)
Project Management Professional (PMP) certification
Proud member of the Microsoft Partner Network.
Middlesex Community College
Edison, New Jersey
Certificate in project management
Rutgers University
New Brunswick, New Jersey
Attended the MBA in Information System Management
program
New York University
New York, New York
Certificates in computer programming and DEC
minicomputers
Fordham University
Bronx, New York
BS in Marketing-Management; Minor in Information
Technology
Graduated with Cum Laude honors
Business Stakeholder -
Fortune 500 Company
“You have been one of the
people here that I have
always respected and looked
at as a mentor...”
-Mike
Associate Director
From a Recent
Engagement
Business Stakeholder -
Major Financial
Services Company
“Alex led a project to
completely redesign and
rebuild a major piece of
software my team used. His
work was excellent - the
software was stable, the front
end user-friendly, the output
accurate. He also responded
to bug fixes and feature
requests surprisingly fast. He
easily earns my highest
recommendation.”
-Ryan
Research Analyst
Business Stakeholder -
Major Financial
Services Company
“Alex led a project to
completely redesign and
rebuild a major piece of
software my team used. His
work was excellent - the
software was stable, the front
end user-friendly, the output
accurate. He also responded
to bug fixes and feature
requests surprisingly fast. He
easily earns my highest
recommendation.”
-Ryan
Research Analyst
From a Recent
Engagement
© J.C.N. Associates, L.L.C. 1991 - 2017
Voice: 646/583.2989 | Fax: 732/595.9125
Microsoft Visual FoxPro
IT Software Project Management
Photo courtesy of Kesh Sorensen, PhotoSolutions.com
Business Stakeholder -
State Dept. of Health -
Medicaid Financial
Management
“I’m writing to thank you for
all the work you’ve done with
us over the past 2 years.
You’ve always been helpful
and thorough, and have
greatly helped to get us much
closer to where we need to
be with updating our
systems.”
-JD
Director