PROFESSIONAL SUMMARY<\/span><\/strong><\/h1>\n<\/blockquote>\nData Analyst with extensive experience in financial modeling, accounting system development, compensation analytics, advanced statistical methods, and enterprise-scale data management. Expert in SQL, Excel, Python, and VBA (Visual Basic for Applications), with a proven record of building automated reporting systems, dashboards, and audit-ready documentation. Strong background in actuarial science, including completion of three Society of Actuaries (SOA) examinations covering probability, financial mathematics, time value of money, and life contingencies. Demonstrated success supporting higher education, healthcare, and corporate environments in data-driven decision-making, compliance reporting, and system optimization.<\/span><\/p>\nCORE COMPETENCIES<\/span><\/strong><\/h1>\n\n- Advanced Data Analysis & Financial Modeling<\/span><\/li>\n
- Compensation Analytics, FMV (Fair Market Value) Evaluation<\/span><\/li>\n
- Oracle SQL \/ PL\/SQL \u2022 Python \u2022 VBA \u2022 MATLAB<\/span><\/li>\n
- Accounting System Design & Automation<\/span><\/li>\n
- Excel Dashboards \u2022 PivotTables \u2022 Data Visualization \u2022 GraphViz<\/span><\/li>\n
- Healthcare Data Migration & Compliance Reporting<\/span><\/li>\n
- Productivity Metrics & Benchmarking<\/span><\/li>\n
- Project Management & Process Optimization<\/span><\/li>\n
- Database Architecture & Data Governance<\/span><\/li>\n
- Statistical Modeling & Actuarial Computation<\/span><\/li>\n
- Stakeholder Collaboration & Executive Reporting<\/span><\/li>\n
- Learning Management Systems \u2022Blackboard \u2022Desire2Learn Brightspace \u2022MOODLE <\/span><\/li>\n<\/ul>\n
RELEVANT EXPERIENCE<\/span><\/strong><\/h1>\nInstructional Designer & SQL Analyst<\/span><\/strong><\/h2>\nNassau Community College \u2013 Office of Online Learning\/SQL Analyst<\/span><\/strong><\/p>\n2009 \u2013 Present<\/span><\/em><\/p>\n\n- Designed and analyzed complex institutional data systems, producing automated reporting tools, compliance documents, and demand reports for departments including the Registrar, National Student Clearinghouse, Student Health Services, Bursar, Student Loan administration, and the Office of Institutional Effectiveness.<\/span><\/li>\n
- Built a comprehensive <\/span>Oracle SQL\u2013based accounting and compensation analytics model<\/span><\/strong> supporting multi-entity financial activities. System components include:<\/span>\n
\n- Complete chart of accounts, journal entry engine, and posting logic<\/span><\/li>\n
- Automated closing procedures and subledger integration<\/span><\/li>\n
- Dynamic income statements, trial balances, and balance sheets<\/span><\/li>\n
- Audit-ready stored procedures, constraints, and validation rules<\/span><\/li>\n
- Financial principles, including accrual accounting, depreciation, amortization, revenue recognition, liability tracking, benchmarking, and productivity metrics<\/span><\/li>\n<\/ul>\n<\/li>\n
- Created enterprise-level dashboards and executive reports using Excel, PivotTables, conditional formatting, and Power Query techniques.<\/span><\/li>\n
- Developed custom Excel VBA analytics tools used by hundreds of learners, including:<\/span>\n
\n- NormalCDF and inverse-normal statistical functions<\/span><\/li>\n
- Sampling distribution modeling \u2022Binomial \u2022Normal\u00a0\u00a0<\/span><\/li>\n
- Regression and correlation calculators<\/span><\/li>\n
- Automated summary-report generators<\/span><\/li>\n<\/ul>\n<\/li>\n
- Received recognition from <\/span>OpenSUNY (Open State University of New York)<\/span><\/strong> for Blackboard Learn 9 migration training excellence:<\/span><\/li>\n
- \u201cHigh satisfaction levels\u2026 high-quality migration training.\u201d \u2014 Diane Hamilton, Instructional Design Associate.<\/span><\/li>\n
- Led major technology and data training initiatives for 150+ faculty members using SQL, analytics tools, and instructional design frameworks.<\/span><\/li>\n
- Chaired the <\/span>Accessibility Technology Subcommittee<\/span><\/strong>, providing governance and support for campus-wide digital accessibility practices.<\/span><\/li>\n<\/ul>\n
Healthcare Data Systems Consultant (Education Accreditation Division)<\/span><\/strong><\/h2>\nNorthwell Hospital, Manhasset, NY<\/span><\/strong><\/p>\nConsulting Role<\/span><\/em><\/p>\n\n- Collaborated with the Northwell Hospital Education Team to migrate a legacy data system to a more robust, scalable, and compliance-forward framework.<\/span><\/li>\n
- Analyzed workflow processes, redesigned data-entry structures, improved maintenance protocols, and developed enhanced reporting and compliance monitoring tools.<\/span><\/li>\n
- Strengthened data accuracy, audit readiness, and regulatory reporting capacity for accreditation and internal review processes.<\/span><\/li>\n
- Worked with healthcare leadership, educators, and IT staff to ensure system reliability, integrity, and usability across departments.<\/span><\/li>\n<\/ul>\n
Actuarial Analyst (Pension & Compensation Analytics)<\/span><\/strong><\/h2>\nAon Consulting \u2013 Midtown Manhattan<\/span><\/strong><\/p>\nEarlier Career Role<\/span><\/em><\/p>\n\n- Developed one of the first internal databases in the Northeast Division to track SERP (Supplemental Executive Retirement Plan) activity for highly compensated employees of a global French luxury brand.<\/span><\/li>\n
- Applied actuarial principles to analysis, financial projections, time-value-of-money modeling, and long-term pension liability forecasting. <\/span><\/li>\n
- Conducted productivity and compensation-related calculations using actuarial software, Excel, and SQL-based reporting tools.<\/span><\/li>\n
- Strengthened data pipelines and documentation processes to support pension audits, regulatory reviews, and executive compensation compliance.<\/span><\/li>\n<\/ul>\n
Mathematics & Analytics Instructor (30+ Semesters)<\/span><\/strong><\/h2>\nNassau Community College, Glen Cove Adult Education, Bellmore\u2013Merrick Adult Programs<\/span><\/strong><\/p>\n2006 \u2013 Present<\/span><\/em><\/p>\n\u00a0<\/p>\n
\n- Instructed courses in Probability, Statistics, Multivariable Calculus, Differential Equations, and Applied Analytics\u2014building foundational skills relevant to compensation modeling and FMV analysis.<\/span><\/li>\n
- Designed interactive statistical systems, VBA tools, and automated spreadsheets that demonstrated modeling concepts, trend analysis, and data-driven budgeting.<\/span><\/li>\n
- Delivered training in Microsoft Excel and Access, ranging from introductory instruction to advanced data analysis and automation.<\/span><\/li>\n<\/ul>\n
EDUCATION<\/span><\/strong><\/h1>\nMaster of Science \u2013 Educational Technology<\/span><\/strong><\/p>\n Stony Brook University \u2014 <\/span>GPA: 4.0\/4.0<\/span><\/em><\/p>\n\u00a0<\/p>\n
Bachelor of Science \u2013 Mathematics<\/span><\/strong><\/p>\n Stony Brook University<\/span><\/p>\n Major GPA: 3.8\/4.0<\/span><\/p>\n\u00a0<\/p>\n
CERTIFICATIONS & EXAMS<\/span><\/strong><\/h1>\nSociety of Actuaries (SOA)<\/span><\/strong> \u2014 Passed:<\/span><\/p>\n\n- Exam P \u2013 Probability<\/span><\/strong><\/li>\n
- Exam FM \u2013 Financial Mathematics<\/span><\/strong><\/li>\n
- Exam MLC \u2013 Models for Life Contingencies<\/span><\/strong><\/li>\n<\/ul>\n
\u00a0<\/p>\n
Instructional Designer Certificate Program<\/span><\/strong><\/p>\n SUNY Learning Network \u2014 Completed with Distinction<\/span><\/p>\n\u00a0<\/p>\n
TECHNICAL SKILLS<\/span><\/strong><\/h1>\nLanguages & Tools:<\/span><\/strong><\/p>\n SQL (Structured Query Language) \u2022 Oracle SQL Developer \u2022 Python \u2022 VBA \u2022 MATLAB<\/span><\/p>\n Excel (advanced functions, PivotTables, dashboards) \u2022 Access \u2022 HTML<\/span><\/p>\n Statistical Modeling Tools \u2022 Data Visualization Techniques<\/span><\/p>\nFinancial\/Analytical Skills:<\/span><\/strong><\/p>\n Compensation Modeling \u2022 FMV (Fair Market Value) Analysis<\/span><\/p>\n Productivity Metrics \u2022 Benchmarking \u2022 Cost Analysis<\/span><\/p>\n Accrual Accounting \u2022 Depreciation & Amortization Modeling<\/span><\/p>\n Audit Documentation \u2022 Data Governance & Validation<\/span><\/p>\n\n\n<\/p>\n\n\n\n
<\/p>\n\n\n\n
<\/p>\n\n\n\n
\nResume<\/h1>\n<\/blockquote>\n\n\n\n
<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
About the Instructor Welcome to my website. I am a full-time Instructional Technologist at an institution with over 20,000 students. I also teach technology workshops for various institutions and companies successfully completed several math-intensive actuarial exams taught over 340 Microsoft Excel and Access classes taught over 4,000 students of all levels from beginner to expert […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-939","page","type-page","status-publish","hentry"],"jetpack_shortlink":"https:\/\/wp.me\/P2Cll0-f9","jetpack_sharing_enabled":false,"_links":{"self":[{"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/pages\/939","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/comments?post=939"}],"version-history":[{"count":16,"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/pages\/939\/revisions"}],"predecessor-version":[{"id":3563,"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/pages\/939\/revisions\/3563"}],"wp:attachment":[{"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/media?parent=939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}