Francis A. DeLessio
Baltimore, MD 21231
********@*****.*** or 443-***-****
EDUCATION
BS in Business Management, with a minor in Personnel and Human Relations
Management from SAINT FRANCIS UNIVERSITY, Loretto, Pennsylvania. May 1990.
Currently enrolled in the Master's Degree Program in Applied Information
Technology at TOWSON UNIVERSITY, Towson, MD. (Projected completion is June
2010.)
Seagate Crystal Reports 8.0, 9.0 and 10 certified developer and designer.
COMPUTER SKILLS
Microsoft Reporting Services, Crystal Reports 7, 8.5, 9 & 10, XML, ASP,
HTML, SQL Server 2000. Experienced Database Administrator with a strong
knowledge of MS SQL, database design and development, advanced stored
procedures and report development.
IT EXPERIENCE:
Manager of Operational Reporting - XLHealth, Baltimore, MD - 9/2009 -
present.
Management Responsibilities:
. Manage a team of 10 report developers and data analysts.
. Responsible for monthly report development and ad-hoc requests as well
as management request monitoring.
. Responsible for monitoring the data warehouse and its effectiveness
for report development
. Proven organizational skills, the ability to multi task, in a hectic
environment.
Report Development:
. Custom report development using Business Objects/Crystal Reports 8 and
10 and MS SSRS.
. Developed complex queries and stored procedures in MS SQL Server 2005.
. Work closely with end users for the development of reporting
requirements, user testing and support.
. Report off of CMS data for Medicare and Medicaid enrollment, claims
and member information needs.
Director of IT Services/Database Developer - National Capital Contracting,
Arlington, VA - 6/2006 - 9/2009.
Management Responsibilities:
. Administer, schedule and deploy ScheduALL software upgrade and new
reports.
. Follow SDLC procedures for database development and reporting
projects.
. Work collaboratively with Team Leads, Project Managers, and
Application Developers.
. Enforce SQL programming standards and best practices through
instruction and example.
Database Administration:
. Manager/Lead roll in report development and database administration.
. Create database schemas based on logical model.
. Code/test and optimize SQL stored procedures and ad hoc queries as per
requirements.
. Perform performance and tuning of assigned database systems, reports
and quires.
. Recommend enhancements to production database systems.
Report Development:
. Custom report development using Business Objects/Crystal Reports 8 and
10.
. Developed complex queries and stored procedures in MS SQL Server 2000.
Database Manager - Immune Deficiency Foundation, Towson, MD - 10/2005 -
6/2006
Database Administration:
. Project Manager for European Report Registry with the University of
Freiberg Germany.
. Lead developer on the international data warehouse and report
development project.
. Development of advanced stored procedures and reporting formulas for
specific medical report criteria to be used with either Reporting
Services or Crystal Reports.
. Development and implementation of back up and disaster recovery plans.
Francis A. DeLessio
********@*****.*** or 443-***-****
page 2
Jr. DBA/Reports Developer - Visicu, Baltimore, MD - 5/2001 - 10/2005
Database Administration:
. Database Administration and design of reporting warehouse, reference
tables and table modifications.
. Developed ETL processes and queries for building and accessing an
Enterprise Data Warehouse.
. Development and use of advanced stored procedures and reporting
formulas for complex medical reporting, to be used with either
Reporting Services or Crystal Reports.
. Design and modify scripts, tables, indexes and stored procedures, to
store and retrieve data.
. Database knowledge of relational database concepts, logical and
physical design.
Report Development:
. Design complex custom medical/clinical reports, drug lists and patient
sensitive information.
. Hands on custom report development with architecture and design
experience.
. Strong verbal and written communication skills as well as time
management.
Applications Developer - Active Computer Engineering, Annapolis, MD -
5/2000 - 4/2001
. Designed ASP web application for member verification and validation.
. Design and development of custom Crystal Reports for use independently
and over the web.
. Data importation, conversions and migrations from various sources into
SQL Server 7.
Programmer/Analyst - Compuware Corporation, Baltimore, MD - 3/1998 - 5/2000
. HTML, Access and VB development and training.
. Designed HTML and ASP web pages as a part of an in-house training
course.
. Database conversion from Access Database to SQL Server 7.0.
SALES EXPERIENCE:
Territory Manager - United Technologies, Otis Elevator Company, Alexandria,
VA. 6/95 - 2/98.
Territory Management: Responsible for the management of the Washington DC
territory a total of 423 accounts, and seven mechanics. Total annual
revenue of 3.25 million dollars in maintenance billing, monthly repair
sales and the modernization sales.
Account Manager - United Technologies, Otis Elevator Company, Buffalo, NY.
11/94 - 6/95.
New Equipment Sales: Actively network, make presentations and sell to
building owners and architects, as well as project management on all
construction jobs sold. Responsible for all new business in the Western New
York Region.
Service and Modernization Sales: Account manager for a customer base of 150
accounts, with annual revenue of approximately $500,000. Responsible for
all sales, repair scheduling, and all customer issues and product upgrades
and complete modernization.
Account Representative - United Technologies, Otis Elevator Co.,
Poughkeepsie, NY. 8/91-11/94.
New Equipment and Service Sales: Responsible for the development and
expansion of an existing sales territory, as well as acting as a problem
solver and consultant to customers.
Account Representative - United Technologies, Otis Elevator Company,
Norwalk, CT. 7/90 - 8/91.
SPECIAL HONORS
Member of Upsilon Pi Epsilon, Towson University's Honor Society for
Computing and Information disciplines - 2005.
President of Tau Kappa Epsilon - Saint Francis University, Delta Phi
Chapter, Loretto, PA. 1988 - 1990.
College: Scholarship Recipient - Division I Soccer 1986 - 1990, and Co-
captain 1988 - 1990.
Community: Eagle Scout Award, 1984.