Tony H. Email & Phone Number

Chapel Hill, NC, US

Northbrook, IL, US

• Engaging with internal stakeholders to identify areas for improvement within the company, focusing on process optimization and automation. Analyzing data and creating dashboards to prove and quantify opportunities.
• Leading coaching sessions for all analysts in the Digital Transformation Office to spread subject matter expertise and increase internal knowledge of SQL, data modeling, dashboard design, and governance best practices.
• Advising the data engineering team on proper SQL query construction and optimization, ensuring ETL processes are as efficient and fault-tolerant as possible.
• Heading the technical implementation of the department’s transition towards Object Centric Process Mining.
• Collaborating with internal stakeholders and third party vendors to connect disparate data sources, successfully identifying a significant annual opportunity from document processing.
• Creating optimized snowflake schema data models, blending multiple source systems, to efficiently identify end to end business processes and customer journeys through various data domains.

New York City, New York, US

• Implemented process mining solutions such as interactive dashboards and automation for multiple Fortune 100 companies to gain insights from data and optimize processes.
• Developed data models, views, and KPIs using business logic gathered from requirements sessions and performed iterative validation to ensure accuracy.
• Established subject matter expertise with SQL, advising consultants of various industries across the globe on best practice methodologies such as performance optimization and data modeling.
• Integrated a client’s Oracle EBS and OTM databases to identify opportunities to consolidate shipments, saving them $3,200,000 in transportation costs within the first six months of implementation.
• Created a solution for a client to identify violations of their accounts payable process across their SAP ECC and S/4HANA environments, revealing $10,000,000 worth of unapproved invoices.
• Performed root cause analysis on a client’s manufacturing process to reveal bottlenecks in their workflow, identifying the potential to mitigate $1,700,000 worth of waste per year.

Niagara Falls, NY, US

• Supported state and district education departments with their usage of eScholar's product suite while adhering to FERPA laws.
• Collaborated with developers and clients of varying levels of expertise to troubleshoot a variety of issues, periodically using tools such as complex SQL queries and CTEs to uncover potential data anomalies.
• Led training sessions with clients and interns on how to optimally use and troubleshoot our product suite, going over topics such as ETL processes, SQL queries, and data warehouse schemas.
• Created a Python script to decompile, edit, and recompile report packages to seamlessly load into the Cognos environment, eliminating the need to edit multiple parameters on the front end.
• Automated the extraction and transformation of Microsoft Access files using Python, reducing the manual processing time from two weeks to five minutes.
• Generated complete data statistics for a multitude of uploaded file batches using SQL, replacing the need to spot check for errors on the front end.

• Provided database support for all staff and faculty.
• Stewarded projects to implement new functionality to optimize the Veracross Student Information System, maximize the return on investment, and progress the school’s technological initiatives.
• Communicated with account managers at Veracross to guide the direction of the SIS in order to enhance its capabilities for our usage, championing the inclusion of and/or clauses and table joins in their proprietary.
• Presented an internal portal for parents and teachers to share information regarding their students, driven by the Veracross database in real time.
• Initiated training sessions for incoming staff, faculty, and new parents on how best to use the Veracross platform.
• Regularly created self-updating reports within Veracross to provide insightful aggregate data to inform business decisions, allow for users to mass update thousands of records quickly, and check for potential data.

• Provided instruction in the public school system, ranging from kindergarten to 12th grade.
• Managed classrooms of up to 30 students while following lesson plans and implementing behavioral management strategies.
• Collaborated with special education teachers and paraeducators to provide meaningful lessons to students with learning disabilities.

New Haven, CT, US

• Customized Salesforce platform to optimize data storage and amplify user experience by developing custom objects, object relationships, fields, and page layouts.
• Generated reports and dashboards using query logic to present proper information clearly.
• Managed Salesforce users’ access and user profile settings to promote database security and maintain information privacy.
• Conducted training sessions to educate Salesforce users and ensure optimal adoption, appropriate usage, and quality storage of information.
• Sustained data quality through mass import and deletion of records when necessary.

• Analyzed test scores in Excel spreadsheets to determine and mitigate weaknesses in student math performance.
• Identified core concepts in algebra by observing repeating patterns on exams in order to assist teachers in recognizing key topics for instruction.
• Created lessons and led small group tutoring sessions in order to remediate common misconceptions.

Storrs, CT, US

• Coordinated with the Center for Students with Disabilities to provide clear, detailed, and organized class notes for others with consistent punctuality.
• Efficiently kept up with the pace of the instructor with excellent accuracy.

• Designed a private social networking website where high school students connect with adults in the workforce to help the students realize and achieve their career goals.
• Managed workshops with high school students with the objective of sharing experiences as an undergraduate to aid them in preparing for higher education.

Master’S Degree, Curriculum And Instruction

Bachelor’S Degree, Mathematics