Tony H. Email & Phone Number

Chapel Hill, Nc, Us

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, working with other business units to develop solutions to realize value.• 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.• Mentored a team of associate consultants, overseeing proper development of technical skills such as SQL, Python, and proprietary technologies, while ensuring adherence to general best practices and professional service ideologies.

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.• Developed a PowerShell solution to streamline data extraction processes, reducing the need to manually edit 30 files down to changing a single parameter.• Streamlined the routine transformation and matching of assessment data to internal student records using Alteryx macros, reducing workload by 30 hours per month. Further augmented the macros to use custom defined matching parameters for cases where the original algorithm could not produce a definitive match, reportedly saving the client 10 hours of processing time monthly.• Created a process in Alteryx that generates and executes SQL update statements from periodically downloaded files to keep crosswalk tables up to date.• Validated large data sets using Alteryx using lookup tables in the SQL database for valid values. Additionally fixed incorrect formats where appropriate, eliminating the risk of inserting erroneous data, which could potentially cause many hours of cleanup for the development team.

• 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 search system.• 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 integrity issues.• Created documentation for internal reference and establishing standard operating procedures on processes run by the IT department.

• 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