Experience

Karna, LLC

• Business Consulting and Services
• 1 - 100 Employee

• Statistical Programmer Analyst III

  • Jun 2022 - Present



Children's Hospital of Philadelphia

• United States
• Hospitals and Health Care
• 700 & Above Employee

• Data Analyst Il

  • Apr 2020 - Nov 2021

• Research Data Analyst

  • Apr 2019 - Apr 2020



University of Pennsylvania School of Medicine

• Higher Education
• 700 & Above Employee

• SAS Application Developer

  • Nov 2007 - Nov 2018

  Provides statistical programming services using SAS/Proc SQL on biomedical research studies. Collaborates closely with Principal Investigators, Faculty/Non Faculty Biostatisticians and or Research Coordinators to provide programming support. Services provided are but are not limited to the following:* data cleaning* merging relational data and or providing queries* import/export data in format desired (xlsx, csv, spss, stata etc.)* advance macros/arrays * metric conversion* interpolate values* converting variables to proper type (numeric, date, date time, time etc.)* create derived variables* generate scale/sub scale/total scores* weighed averages* data mapping variables* summary stats/histograms/graphs/scatterplots/boxplots* generate tables/reports using proc report* create detailed code books* annotates sas program as well as create and maintains an organize project directory so that pertinent information can be located very easy.

• Office System Coordinator (SQL/Crystal Reports)

  • Jul 2005 - Oct 2007

  * Served as a FAPD administrator which included duties such as assigning and revoking user rights to FAPD’s web application and pertinent documents.* Routinely wrote SQL code to generate new and or ad hoc reports as requested by internal and external clients.* Generated / disseminated monthly reports that were reviewed by internal and external clients.* Ensured data integrity by monitoring database for errors and keeping the database clean by performing detailed review of all information on a weekly basis.* Facilitated one-on-one or group trainings on FAPD’s web based applications to minimize data entry errors.* Collaborated with department coordinators to resolve data discrepancies.* Worked with clients to better serve their data and reporting needs.* Represented the office of Faculty Affairs in a professional and courteous manner to internal/external clients.



Philadelphia Workforce Development Corporation

• Non-profit Organizations
• 1 - 100 Employee

• Database Coordinator

  • Nov 2003 - Dec 2004

  * Created and maintained MS Access databases; ensured data integrity and data accuracy for reporting.* Proposed solutions to keep data accurately entered into the databases.* Proposed and implemented electronic forms created in Microsoft Word so that offsite departments had the capability to submit forms via email instead of using mail carrier.

• Database Information Technician

  • Oct 2002 - Oct 2003

  * Performed routine maintenance on job seeker data to ensure data integrity.* Worked with department managers to resolve data discrepancies.* Coordinated department information necessary to produce monthly reports and or Ad Hoc reports.* Assisted manager in developing policies and procedures for all data entry and data retrieval using the Employer Services database containing thousands of entries.

• Marketing Operations Assistant

  • Sep 2000 - Sep 2002

  * Accurately expedited the data entry of job-seeker data of ~100 applicants on a daily basis into internal databases as well as the CareerLink web-based application.* Monitored and tracked information entered into the Employer Services database.* Processed requests for workforce-related research information.