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)

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 special-

ists.

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

Download Resume (Microsoft Word format)

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

From a Recent Engagement

View printer-friendly resume