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, EvernoteNew 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 SupportLineData 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 SupportVitamin 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 SupportGMAC/HomeConnects (2004)
Horsham, Pennsylvania Industry: Financial services | Roles: Database application developer Visual dBase and Visual Basic Analysis, Design, Development, Deployment and SupportGeneral 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 SupportPrinceton 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 ApplicationsGlobe 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 SupportCitibank (1994 - 1996)
New York, New York Industry: Banking | Roles: Project manager; Database application architect and developer New Application Analysis, Design, Development, Deployment and SupportHomeLife Insurance Company (1991 - 1992)
Piscataway, New Jersey Industry: Insurance | Roles: Application manager. Application Management and Development; Application Support for Preexisting ApplicationsCitibank, 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 ConnectionSoftware
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 & DodgeEDUCATION and CERTIFICATIONS
Project Management Institute
(PMI.ORG)
Project Management Professional (PMP) certificationProud member of the Microsoft Partner Network.
Middlesex Community College
Edison, New Jersey
Certificate in project managementRutgers University
New Brunswick, New Jersey
Attended the MBA in Information System Management programNew York University
New York, New York
Certificates in computer programming and DEC minicomputersFordham University
Bronx, New York
BS in Marketing-Management; Minor in Information Technology Graduated with Cum Laude honors
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
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
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
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, EvernoteNew 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 SupportLineData 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 SupportVitamin 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 SupportGMAC/HomeConnects (2004)
Horsham, Pennsylvania Industry: Financial services | Roles: Database application developer Visual dBase and Visual Basic Analysis, Design, Development, Deployment and SupportGeneral 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 SupportPrinceton 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 ApplicationsGlobe 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 SupportCitibank (1994 - 1996)
New York, New York Industry: Banking | Roles: Project manager; Database application architect and developer New Application Analysis, Design, Development, Deployment and SupportHomeLife Insurance Company (1991 - 1992)
Piscataway, New Jersey Industry: Insurance | Roles: Application manager. Application Management and Development; Application Support for Preexisting ApplicationsCitibank, 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 ConnectionSoftware
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 & DodgeEDUCATION and CERTIFICATIONS
Project Management Institute
(PMI.ORG)
Project Management Professional (PMP) certificationProud member of the Microsoft Partner Network.
Middlesex Community College
Edison, New Jersey
Certificate in project managementRutgers University
New Brunswick, New Jersey
Attended the MBA in Information System Management programNew York University
New York, New York
Certificates in computer programming and DEC minicomputersFordham 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
© 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
Microsoft Visual FoxPro
IT Software Project Management (PMP)
