DALESANDRO.NET

John Dalesandro

Address Withheld

Telephone Withheld
web@dalesandro.net

06/2007 – Present
Sr. Systems Analyst

Software Quality Assurance and Testing

• Responsible for the development, planning and tracking of monthly, annual and long-range finances for $28M under directorship of the shared service.
• Authored departmental operating procedures and defined associated tools in support of financial forecasting and overall service management.
• Led the virtualization of physical test lab assets across four facilities using VMware and Surgient VQMS solutions.
• Led the integration of HP Quality Center and Surgient VQMS to support test automation initiatives.
• Planned and coordinated proof-of-concept examinations of HP Service Test and ITKO LISA for system integration testing.
• Provided analysis for consolidations of divisional staff and assets into the shared service center.
• Authored business cases to successfully acquire $2M in strategic capital investments.
• Mentored new managers and staff on Merck fiscal compliance and instilled financial confidence in the shared service environment.
• Coordinated vendor relationships with strategic partners and specialty suppliers.

12/2003 – 05/2007
Systems Analyst

03/2002 – 11/2003
Systems Associate

02/2001 – 02/2002
Systems Specialist

Patient Data Acquisition, Management & Reporting

• Assumed internal ownership of Phase Forward Central Coding for InForm as part of the enterprise adoption of clinical electronic data capture.
• Coordinated product deployment process for three Central Coding release cycles. Each version delivered increased business capability while providing the appropriate documentation in accordance with the Merck SLC.
• Led the requirements gathering and design sessions for an integration of IVRS and Phase Forward InForm using TIBCO to optimize the clinical drug supply management process.
• Modeled the business process and data flow between IVRS and InForm.
• Analyzed and managed enhancement requests and defects while effectively communicating with the Change Control Board.

Clinical Endpoint Adjudication

• Assumed ownership of the Clinical Data Adjudication System and led a three person team supporting a data migration effort to achieve cycle-time reduction and to provide improved analytic capability.
• Managed the outsourced development of 40+ Cognos reports.
• Designed and implemented a custom workflow engine to support the adjudication process while eliminating licensing costs of BEA WLI.
• Fostered relationships with business areas to produce higher quality communications while effectively managing stakeholder expectations.

Clinical Supplies Management & Enterprise Resource Planning

• Led a three person team through four enhancement releases to better align the product with business processes. Each version was delivered on schedule and within budget while meeting systems development life cycle documentation requirements.
• Managed development, IT and UAT cycles to ensure regulatory compliance.
• Responsible for estimating resources and developing full project plans.
• Facilitated cross-departmental requirements gathering sessions.
• Identified and leveraged several open-source components, shared services, and reference data repositories available within the Merck architecture.
• Effectively managed stakeholder expectations and communicated product changes to a 1,600+ user community.
• Coordinated with an outsourced vendor to introduce a re-targeted version (from SilverStream to WebLogic) into the Merck infrastructure.
• Modeled and designed integration points with JDE ERP system in support of divisional objectives to increase the efficiency of drug supply management.

MRL Automated Account Approval System

• Led a two person team to successfully deliver the product and all associated SLC documentation.
• Modeled and designed all system components including a custom workflow engine to automate account approvals based on a user risk scorecard.
• Introduced open-source components to minimize construction effort.
• Performed gap analysis of commercially available solutions.

Application Engineering Program Management Office

• Supported management consultants in defining processes for portfolio management and compliance with Merck financial policies.
• Designed and led the creation of an executive dashboard to manage a $15M budget and provide status communications to business partners.
• Modeled the data flow and attributes for the development of a resource and demand management tool.

Work & Cost Management System / Protocol Tracking System

• Evaluated alternative commercial solutions and provided gap analysis to support the identification of a replacement system.
• Designed and implemented a reporting framework enabling ad-hoc analysis of planned vs. actual trial milestones through Microsoft Excel.
• Organized and conducted training sessions for several new business areas.

New Jersey Institute of Technology (NJIT); Newark, New Jersey
M.S. Computer Science: Software Engineering [December, 2003]

New Jersey Institute of Technology (NJIT); Newark, New Jersey
B.S. Computer Science; Minor: Applied Mathematics [December, 2000]
Magna Cum Laude; Dean’s List: Fall 1997 – Fall 2000
Cumulative GPA: 3.82, GPA Within Major: 3.9
Member of the Albert Dorman Honors College