Josh D. Email and Phone Number

Built data delivery solutions for research, medical, and operational staff. Developed familiarity with almost every aspect of MSK operations and data sources including finance, patient care, and research.• Developed a python-based SQL generation application to automate report building and patient cohort management. Designed serverless processes in AWS to integrate into front-end system using Lambda functions.• Created and managed reporting views for COVID vaccine administration and tracking, and developed Tableau dashboards for high-level analytics as well as day to day operations. Developed automated reports to help maintain compliance with state agencies.• Utilized python to create ETL processes for reporting on a new health consumer platform. Worked closely with business owners and product engineers in an Agile environment to design analytics solutions. Combined data from SQL and MongoDB data sources to integrate demographic and clinical data with platform activity measures for Tableau reporting.

Worked with doctors, nurses, and researchers to understand specific requirements, document those requirements, and translate that logic into code. Wrote the SQL or python to join and clean data for delivery. Managed Tableau dashboard projects.

Provided financial statement analysis to management, worked with departments to understand data, and wrote custom SQL queries to extract relevant data. I also created Tableau reports and provided analysis for annual reporting and forecasting.• Designed and built a Tableau financial statement analysis tool using finance data feeds. Created SQL procedure to combine various data sources• Worked with the accounting department to automate reporting around key metrics • Created a Cognos report to automate a reporting process, saving users hours of repetitive work. Collaborated with Information Systems to create an ETL process that makes the data accessible in SQL and Cognos.

• Led implementation of new general ledger and its integration with database environment• Co-led implementation of royalty management system, including integration with general ledger• Created data visualization dashboards for top clients using Cognos Active Reports• Wrote SQL queries for data mining and to provide meaningful data to management and clients• Developed a cash tracking application using MS Access, Python, and MS SQL Server that significantly reduced transaction processing time and improved accuracy• Wrote an application using Python and SQL to automate monthly upload of financial data into corporate system, and the reconciliation between GL and reporting database.

• Led the monthly close including closing entries, analysis, balance sheet reconciliations, bank statement reconciliations, and submissions of financial statements to parent company for US, UK, and Hong Kong offices• Created reports in Cognos Report Studio and Query Studio to provide better analysis to management and to assist in reconciliations• Prepared and analyzed annual budgets and reforecasts• Ensured compliance with Sarbanes-Oxley, performed quarterly testing of internal controls• Gained familiarity with UK VAT regulations, submitted quarterly VAT returns and payments, and ensured VAT compliance for UK transactions• Reviewed client representation agreements to ensure accurate payment of royalties