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
- have 15+ years of experience in spreadsheet development and database design.
My experience includes using Microsoft Excel spreadsheets and Microsoft Access databases to do special projects for Fortune 500 companies specializing in asset management, data management, cost analysis, and business automation to meet business objectives. I enjoy spending time with my family and swimming at the Eisenhower Aquatic Center.
Instructional Goal
The goal of my workshops is to help you better understand spreadsheets and databases so you can save time, feel more confident, and accomplish your objectives!
Contact information
Juan Hinojosa
NYactuary@yahoo.com
I look forward to seeing you in my class!
PROFESSIONAL SUMMARY
Data 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.
CORE COMPETENCIES
- Advanced Data Analysis & Financial Modeling
- Compensation Analytics, FMV (Fair Market Value) Evaluation
- Oracle SQL / PL/SQL • Python • VBA • MATLAB
- Accounting System Design & Automation
- Excel Dashboards • PivotTables • Data Visualization • GraphViz
- Healthcare Data Migration & Compliance Reporting
- Productivity Metrics & Benchmarking
- Project Management & Process Optimization
- Database Architecture & Data Governance
- Statistical Modeling & Actuarial Computation
- Stakeholder Collaboration & Executive Reporting
- Learning Management Systems •Blackboard •Desire2Learn Brightspace •MOODLE
RELEVANT EXPERIENCE
Instructional Designer & SQL Analyst
Nassau Community College – Office of Online Learning/SQL Analyst
2009 – Present
- 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.
- Built a comprehensive Oracle SQL–based accounting and compensation analytics model supporting multi-entity financial activities. System components include:
- Complete chart of accounts, journal entry engine, and posting logic
- Automated closing procedures and subledger integration
- Dynamic income statements, trial balances, and balance sheets
- Audit-ready stored procedures, constraints, and validation rules
- Financial principles, including accrual accounting, depreciation, amortization, revenue recognition, liability tracking, benchmarking, and productivity metrics
- Created enterprise-level dashboards and executive reports using Excel, PivotTables, conditional formatting, and Power Query techniques.
- Developed custom Excel VBA analytics tools used by hundreds of learners, including:
- NormalCDF and inverse-normal statistical functions
- Sampling distribution modeling •Binomial •Normal
- Regression and correlation calculators
- Automated summary-report generators
- Received recognition from OpenSUNY (Open State University of New York) for Blackboard Learn 9 migration training excellence:
- “High satisfaction levels… high-quality migration training.” — Diane Hamilton, Instructional Design Associate.
- Led major technology and data training initiatives for 150+ faculty members using SQL, analytics tools, and instructional design frameworks.
- Chaired the Accessibility Technology Subcommittee, providing governance and support for campus-wide digital accessibility practices.
Healthcare Data Systems Consultant (Education Accreditation Division)
Northwell Hospital, Manhasset, NY
Consulting Role
- Collaborated with the Northwell Hospital Education Team to migrate a legacy data system to a more robust, scalable, and compliance-forward framework.
- Analyzed workflow processes, redesigned data-entry structures, improved maintenance protocols, and developed enhanced reporting and compliance monitoring tools.
- Strengthened data accuracy, audit readiness, and regulatory reporting capacity for accreditation and internal review processes.
- Worked with healthcare leadership, educators, and IT staff to ensure system reliability, integrity, and usability across departments.
Actuarial Analyst (Pension & Compensation Analytics)
Aon Consulting – Midtown Manhattan
Earlier Career Role
- 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.
- Applied actuarial principles to analysis, financial projections, time-value-of-money modeling, and long-term pension liability forecasting.
- Conducted productivity and compensation-related calculations using actuarial software, Excel, and SQL-based reporting tools.
- Strengthened data pipelines and documentation processes to support pension audits, regulatory reviews, and executive compensation compliance.
Mathematics & Analytics Instructor (30+ Semesters)
Nassau Community College, Glen Cove Adult Education, Bellmore–Merrick Adult Programs
2006 – Present
- Instructed courses in Probability, Statistics, Multivariable Calculus, Differential Equations, and Applied Analytics—building foundational skills relevant to compensation modeling and FMV analysis.
- Designed interactive statistical systems, VBA tools, and automated spreadsheets that demonstrated modeling concepts, trend analysis, and data-driven budgeting.
- Delivered training in Microsoft Excel and Access, ranging from introductory instruction to advanced data analysis and automation.
EDUCATION
Master of Science – Educational Technology
Stony Brook University — GPA: 4.0/4.0
Bachelor of Science – Mathematics
Stony Brook University
Major GPA: 3.8/4.0
CERTIFICATIONS & EXAMS
Society of Actuaries (SOA) — Passed:
- Exam P – Probability
- Exam FM – Financial Mathematics
- Exam MLC – Models for Life Contingencies
Instructional Designer Certificate Program
SUNY Learning Network — Completed with Distinction
TECHNICAL SKILLS
Languages & Tools:
SQL (Structured Query Language) • Oracle SQL Developer • Python • VBA • MATLAB
Excel (advanced functions, PivotTables, dashboards) • Access • HTML
Statistical Modeling Tools • Data Visualization Techniques
Financial/Analytical Skills:
Compensation Modeling • FMV (Fair Market Value) Analysis
Productivity Metrics • Benchmarking • Cost Analysis
Accrual Accounting • Depreciation & Amortization Modeling
Audit Documentation • Data Governance & Validation
Resume