Alex E. Luyando, PMP
AREAS OF PROFICIENCY
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.
SUMMARY / 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 project management responsibility of the New York State Medicaid
Financial Management Tracking System (MFMTS – FoxPro) system ($52+ Billion annual
transaction value; more than 6 million beneficiaries).
•
Several reverse engineering and migration projects of mission-critical applications spanning
several technologies and in varying roles.
•
As Project Manager decentralized corporate General Ledger processing at Citibank, N.A.,
saving the organization 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)
Managed project that 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 lead 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
Project Management and Team Leadership
•
Project Management Professional (PMP) - (PMI PMP ID 1816575)
•
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.
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.
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: Senior 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): PM on all engagements, responsible for delivery
of projects on-time and within budget.
o
Microsoft Visual FoxPro Developer: Database application design and
development using VFP and various backend databases.
Zelis (2023 - 2024)
Boston, Massachusetts
Industry: Financial Services | Roles: Visual FoxPro Application Developer
Maintenance and enhancement of mission-critical ETL systems and
related supporting applications.
o
Conducted comprehensive review, analysis, documentation, and enhancement
of code for mission-critical applications.
o
Provided essential support to Data Ops and Production Operations, facilitating
the seamless loading of new data feeds from healthcare networks.
Technologies: Microsoft Visual FoxPro, JIRA, MS Office, draw.io
CPQi / Manulife / John Hancock (2022)
Toronto, Canada
Industry: Financial Services | Roles: Visual FoxPro Application Developer; Project
Manager
Team Lead / Application Maintenance of a Major Object-Oriented Visual
FoxPro Application
o
Analysis and maintenance of legacy FoxPro for DOS and Visual FoxPro (n-tiered, OOP)
applications related to 401(k) products.
o
Identification of and remediation of significant production performance and error-prone
code in a very complex online and batch (over 80 nodes) mission-critical system.
Technologies: Microsoft Visual FoxPro, Microsoft FoxPro for DOS, Team Foundation Server (TFS), JIRA,
Azure Dev Ops, Vizio
CoreLogic (2021 – 2022)
Irvine, California
Industry: Financial Services | Roles: Visual FoxPro Application Reverse Engineering Consultant;
Team Lead
Reverse engineering of a Legacy Capital Markets FoxBASE / FoxPro Application
o
Review, analysis, documentation and elaboration of a mission-critical Capital Markets
(Mortgage Backed Securities) FoxBASE / FoxPro application as part of a three-member
team of reverse engineering specialists.
Presentation to and support of business analyst and new development team members.
Project Name: NARMBS | Team Size: 12+ | Team Composition: Cross-functinal | Technologies: Microsoft
Visual FoxPro, Microsoft OneNote, Microsoft SharePoint.
Pioneer Drama Services (2018 – 2022)
Centennial, Colorado
Industry: Publishing | Roles: Visual FoxPro Application Developer, Project Manager
Migration of a Legacy FoxPro Accounting Application
o
Legacy (FoxBASE and FoxPro) code and data analysis and reverse engineering.
o
Design and development of a replacement Visual FoxExpress-based application with
expanded functionality.
o
Technologies: Microsoft Visual FoxPro, F1 Technologies Visual FoxExpress, VFPX Open-
Source VFP Add-ons, Trello
Project Name: Visual PDS System | Team Size: 4+ | Team Composition: Cross-functional | Role/Focus:
Visual FoxPro Development, Project Management
New York State Office of Children and Family Services (2017 - 2018)
Rensselaer, New York
Industry: Human Services | Roles: Senior Project Manager
Project Management - Libera System 7 Case Management
o
Business Solutions | Project and Portfolio Management.
o
Project Manager for the Libera Commerical Off-the-Shelf (COTS) CIS case management
system used by the New York State Office of Children and Family Services - New York
State Commission for the Blind.
o
Release management and change control.
o
Production Support and Management.
Project Name: CIS - Consumer Information System | Team Size: 15+ | Team Composition: Cross-functional |
Role/Focus: Project Management
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 $52 Billion annually.
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 / Stand-Up support.
o
Technologies used included: Microsoft Visual FoxPro, Microsoft Project, Microsoft Visio,
Trello (Agile/SCRUM/Kanban tool), Microsoft Office.
Project Names: MFMTS FoxPro Migration | Team Size: 15+ | Team Composition: Cross-functional |
Role/Focus: Visual FoxPro Development, Project Management, Lead
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
Full project management of all aspects from business requirements gathering through
user training and application deployment.
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
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.
Project Name: MDS Automation | Team Size: 6 | Team Composition: Cross-functional | Role/Focus: Project
Management, Development
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 Stand-ups.
o
Provided team leadership and supported improved team cadence given extensive
project backlog.
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.
Project Name: B&R Accounting Rewrite | Team Size: 12 | Team Composition: Technical | Role/Focus:
Project Management, Reverse Engineering
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.
Project Names: IRS, CABF | Team Size: 15 | Team Composition: Cross-functional | Role/Focus: PM, BA,
Architect
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
Project Name: Oracle Migration | Team Size: 4 | Team Composition: Technical | Role/Focus: BA, Dev.
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
Project Name: Annual Publication | Team Size: 3 | Team Composition: Cross-functional | Role/Focus: PM,
BA, Architect, Dev.
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
Project Name: IPDCS Automation | Team Size: 6 | Team Composition: Cross-functional | Role/Focus:
Project Manager, Dev.
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)
Project Name: ECHOS | Team Size: 12 | Team Composition: Technical | Role/Focus: Project Lead
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
Project Name: NRS | Team Size: 15 | Team Composition: Cross-functional | Role/Focus: PM, BA, Architect,
Dev.
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
Project Name: GPS JSA | Team Size: 2 | Team Composition: Cross-functional | Role/Focus: PM, BA, Lead,
Development
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
Project Name: CFMP, CitiScoop | Team Size: 3 | Team Composition: Technical | Role/Focus: PM, Product
Owner, Director
TECHNICAL SKILLS
Languages and Development Environments
Visual FoxPro – all versions through 9.0
F1 Technologies’ Visual FoxExpress OOP database application development framework
Microsoft Visual Studio .NET – C#
MicroFour StrataFrame database application development framework for .NET
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)
mFoundation, West Wind Internet and Client Tools
Database
Microsoft SQL Server
Oracle
Sybase SQL Server
Microsoft SQL Server Integration Services (SSIS)
Database Tools
Toad for SQL Server, Toad for Oracle
dbArtisan
FoxFix, dSalvage
Sybase PowerDesigner (UML)
Monarch, Data Junction (Data Mining)
Sybase BCP (Bulk Copy)
Stonefield Database Toolkit
Development Tools
Microsoft Project
MS Visio
Visual SourceSafe, SVN, CapCon, PVCS
Multi-Edit
Office Automation
Query Maker (Ad-hoc Reporting Tool)
Crystal Reports
UML, FrontPage
Xara Web Designer
SharePoint
COM/ActiveX
Microsoft Virtual PC, Oracle VirtualBox
Operating Systems
Microsoft Windows (all versions for workstations and servers)
DOS
Macintosh OS—through 8.x
Office Suites and Collaboration Tools
Microsoft Office, Corel Perfect Office, LibreOffice, MS Publisher, Baler XE
Microsoft SharePoint
Microsoft PowerPoint
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
PRO BONO / CHARITABLE PROJECTS
HealingStrong.ORG (2017 – 2018)
Worldwide
Industry: Healthcare | Roles: Project Manager; PowerPoint Presentation Designer; Technical
Consultant
Creation of PowerPoint Presentations for Worldwide Distribution for 501(c)(3)
Non-Profit Organization
o
Create project plan for organization spanning current project as well as future technology
projects.
o
Create PowerPoint presentations for a total of twelve “lessons” to be presented to over 70
local groups worldwide.
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
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