Photo courtesy of Kesh Sorensen, PhotoSolutions.com
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
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

Technology Services

J.C.N. Associates, L.L.C.

More

Alex E. Luyando, PMP - Resume

From a Recent Engagement
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
J.C.N. Associates, L.L.C.

Microsoft Visual FoxPro

IT Software Project Management (PMP)

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

Alex E. Luyando, PMP - Online resume

© J.C.N. Associates, L.L.C.  1991 - 2017
Voice: 646/583.2989 | Fax: 732/595.9125
Microsoft Visual FoxPro IT Software Project Management
J.C.N. Associates, L.L.C.
Photo courtesy of Kesh Sorensen, PhotoSolutions.com
J.C.N. Associates, L.L.C.  Microsoft Visual FoxPro IT Software Project Management
From a Recent Engagement
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
© J.C.N. Associates, L.L.C.  1991 - 2017
Voice: 646/583.2989 | Fax: 732/595.9125 | info@jcn-associates.com 
Delivering IT Software Project Management and Visual FoxPro expertise since 1991
J.C.N. Associates, L.L.C.

Printer-friendly

Download

Resumes Links

View