Paul Villafuerte
New York,NY
Summary
Extensive experience in information technology management, systems integration, application and database design, development and deployment, and programming. Excellent communication skills. Adept at creating effective and efficient solutions to meet business needs, providing useful suggestions while maintaining the quality of solutions delivered. Team player with an ability to contribute independently; natural inclination and aptitude for learning new technologies and skills.
Professional programmer with deep expertise in software development, adept in multiple programming languages, and skilled in problem-solving. Strong emphasis on team collaboration and delivering results, adaptable to changing project requirements with ease. Proficient in designing and implementing efficient code, ensuring high performance and reliability. Known for excellent communication skills and commitment to fostering productive work environment.
Overview
14
14
years of professional experience
Work History
Senior Programmer/Systems Analyst
MEMORIAL SLOAN KETTERING CANCER CENTER
10.2007 - 07.2017
- Company Overview: Memorial Sloan-Kettering Cancer Center (MSKCC) raises over $280 million each year through Fred’s Team (ING New York City Marathon Team), Cycle for Survival as well as through principal, major and other individual gifts
- Responsible for the design, implementation and support of technical solutions for the Development department
- Providing reports and Tableau dashboards to support fundraising
- Regularly meeting with fundraisers and technical staff to determine how best to use technology to achieve the Development department's goals with a focus on new projects leveraging innovative technology solutions not previously used
- Establishing SQL Server Reporting Services (SSRS) for Development staff use
- Including analysis of the benefits of the SSRS product to Development department, analysis of user's business needs, analysis of reporting requirements, development of initial reports, and oversight over training to technical staff
- Implemented functions previously unavailable to Development staff, such as automated email delivery and web-based reporting
- Training members of the technical team in general programming, SQL programming and reporting, and other new technologies
- Developing interface between MSKCC’s Institutional Database (IDB) and MSKCC’s fundraising database (Enterprise) to identify potential patients that may have an inclination to donate
- Appropriately applying HIPAA compliance rules in conjunction with MSKCC compliance officers
- Creating interface between online donation vendor (Blackbaud/Convio) and MSKCC’s fundraising database (Enterprise) to track and report on online donations received
- At its height, this interface acquired 75,000 individual gifts per month, totaling $10 million per month at peak giving-periods
- Memorial Sloan-Kettering Cancer Center (MSKCC) raises over $280 million each year through Fred’s Team (ING New York City Marathon Team), Cycle for Survival as well as through principal, major and other individual gifts
- Designed new product elements such as image recognition, hand writing recognition, audio, video and device-to-device communication.
- Successfully migrated legacy systems to modern platforms while maintaining full compatibility with existing workflows.
- Provided technical guidance to junior programmers, fostering a collaborative learning environment and enhancing overall team productivity.
Senior Systems Analyst/Programmer
COLUMBIA UNIVERSITY IN THE CITY OF NEW YORK
04.2005 - 09.2007
- Responsible for technical and analytic support for various projects, reports, and interfaces related to Columbia’s campaign efforts via the Advance fundraising application
- Worked with fundraising staff to assess ongoing business needs and find appropriate solutions
- Worked closely with senior managers to develop comprehensive system for prospect and solicitation management, and developed a suite of reports and data warehouse that provided point-in-time indicators of fundraiser performance
- Collaborated with Gift Systems to ensure that gift entry and receipting proceeds in a timely and accurate manner
- Analyzed complex gift-crediting issues and IRS regulation compliance
- Provided structured eight-week training to Reporting Services staff and power users in SQL and PL/SQL
- Streamlined business processes by automating manual tasks, increasing productivity and reducing errors.
Acting Director, Administrative Databases
THE COOPER UNION FOR THE ADVANCEMENT OF SCIENCE AND ART
10.2003 - 04.2005
- Oversaw the introduction and implementation of database systems to the college's administrative infrastructure
- Leading teams of programmers
- Assessing user business requirements and proposing and implementing solutions
- Analyzing and designing code scheme
- Migrating data
- Programming customized features and enhancements
- Documenting system policies and procedures
- Training end-users
- Assessing and providing reporting requirements
- Developed CUADS (Cooper Union Admissions System) using Sybase ASE and PowerBuilder, which keeps track of the Union's 3000 applicants
- Designed user interface, database design and metrics tool set
Education
Master of Public Health - Epidemiology and Biostatistics
CUNY GRADUATE SCHOOL OF PUBLIC HEALTH AND HEALTH POLICY
12.2023
Bachelor of Arts - East Asian Studies, Japan
COLUMBIA COLLEGE OF COLUMBIA UNIVERSITY
05.1992
Skills
- Oracle
- SQL Server
- SSMS
- Stored Procedures
- Functions
- Triggers
- R
- T-SQL
- PL/SQL
- XML
- Visual Basic
- VBA
- VBNET
- SOAP
- REST
- JSON
- PL/SQL Developer
- SSIS
- SAS
- ArcGIS
- Dedoose
- SSRS
- Tableau
- Crystal Reports
- Blackbaud CRM
- Ellucian Advance
- Strong communication skills
- Efficient project management
Publications
- Adolescent student bullying victimization: Differences across presidential administrations, Paul Villafuerte, 06/13-16/23, Society for Epidemiological Research Annual Meeting, Portland, OR,
- Adolescent student bullying victimization: Differences across presidential administrations, Paul Villafuerte, 06/24-27/23, AcademyHealth's 2023 Annual Research Meeting, Seattle, WA
Qualification Highlights
- Experienced database developer with over 18 years working in higher education, health care, and nonprofit fundraising
- Expertise in Object-Oriented Analysis/Design, skilled in progressing from problem statement to well-documented design
- Solid leadership skills: demonstrated proficiency in leading, motivating, and mentoring individuals to maximize levels of productivity while forming collaborative team environments
- Extensive knowledge of fundraising in both nonprofits and institutes of higher education
- Implementation of third-party systems including gap analysis and interfacing with legacy systems
- Experience in developing ETL solutions for complex, multi-step data integration, manipulating and merging
Languages
Japanese
Limited Working
French
Limited Working
Timeline
Senior Programmer/Systems Analyst
MEMORIAL SLOAN KETTERING CANCER CENTER
10.2007 - 07.2017
Senior Systems Analyst/Programmer
COLUMBIA UNIVERSITY IN THE CITY OF NEW YORK
04.2005 - 09.2007
Acting Director, Administrative Databases
THE COOPER UNION FOR THE ADVANCEMENT OF SCIENCE AND ART
10.2003 - 04.2005
Master of Public Health - Epidemiology and Biostatistics
CUNY GRADUATE SCHOOL OF PUBLIC HEALTH AND HEALTH POLICY
Bachelor of Arts - East Asian Studies, Japan
COLUMBIA COLLEGE OF COLUMBIA UNIVERSITY
Similar Profiles
Yohannes Abere AmbawYohannes Abere Ambaw
POSTDOCTORAL RESEARCH ASSOCIATE at Memorial Sloan Kettering Cancer Center, Sloan Kettering Institute, Cell Biology DepartmentPOSTDOCTORAL RESEARCH ASSOCIATE at Memorial Sloan Kettering Cancer Center, Sloan Kettering Institute, Cell Biology Department
NICOLE ALLARDNICOLE ALLARD
Site Supervisor at New York Cancer & Blood Specialist (Affiliated with Memorial Sloan Kettering Cancer Center)Site Supervisor at New York Cancer & Blood Specialist (Affiliated with Memorial Sloan Kettering Cancer Center)
Nelson DejesusNelson Dejesus
Guest Service Representative/Concierge at Memorial Sloan Kettering Cancer Center Josie Robertson Surgery CenterGuest Service Representative/Concierge at Memorial Sloan Kettering Cancer Center Josie Robertson Surgery Center
Hrisula DervishiHrisula Dervishi
TEAM LEAD, Outpatient & Hospital Operations at Memorial Sloan Kettering Cancer Center – Evelyn H. Lauder Breast CenterTEAM LEAD, Outpatient & Hospital Operations at Memorial Sloan Kettering Cancer Center – Evelyn H. Lauder Breast Center
Norman Trotter IVNorman Trotter IV
Administrator, Participations and Special Projects at Warner Bros. Discovery: Finance, Contract, Reporting & Administration (FCRA)Administrator, Participations and Special Projects at Warner Bros. Discovery: Finance, Contract, Reporting & Administration (FCRA)