John Mihalko Email & Phone Number

United States

Appleton, Wi

• Upgraded (2008r2 to 2012) and performance tuned our Autoforce SSIS Data Warehouse ETL reducing run time from 3 hours to a little over an hour• Developed Datazen mobile reports• Maintained and added additional features to SSRS reports• Maintained and added additional features to SSAS multi-dimensional cubes• Maintained and added additional features to SSIS ETLs used to load our five data warehouses• Performance tuned queries for Power BI report builders, including adding and maintaining indexes• Taught self service Power BI report builders T-SQL, performance tuning, and best practices• Collaborate and work with end users to ensure that data and reports meet their business needs• Architected and developed a Price Data Warehouse with 16 fact tables and 26 dimensions, including SQL Server tables, SSIS ETL, a SSAS multi-dimensional cube, and views to support business users' self-service Power BI reports.• Performance tuned US Gain Data Warehouse SSIS ETL decreasing run-time from around 30 minutes down to 4 minutes• Took on the capacity of Business Intelligence Deployment Manager, managing and deploying SQL Server objects, SSIS, SSAS and SSRS reports for the Business Intelligence team• Created an Azure Tabular Model of the Price cube as a proof of concept, to initial discussion on cloud migration• Created an Azure Data Factory ETLs to load on-premises data warehouse tables with files stored in Azure Data Lake• Supported the IT Department, US Oil, US Gain, and US Autoforce Business Intelligence projects• Trained new team members in SSIS• Managed 2 week sprints in Azure DevOps• Worked in an Agile environment

Appleton, Wi

• Dimensional database modeling and implementation• Development of ETL (Extract, Transform, and Load) processes• Ensuring security of all developed applications• Adhering to all Company and IT policies and procedures• Carrying out other IT related duties which may be assigned from time to time• Backup SQL Server DBA.• Built a new Fuel Data Mart to track and monitor fuel consumption by pilot and automate the weekly actuals file to US Airways.• Collaborated on the FAR117 project which monitors and alerts pilot flying hours, which was successfully implemented at three other airlines generating revenue.• Responsible for the new development and support of the Maintenance Data Mart which included a process to track the times and cycles on all aircraft parts to improve better planning of heavy checks, saving millions per year.• Member of the team for upgrading the Crew application to SSIS 2012 and increased the performance from an average of 14 minutes down to 3 minutes.• Developed and maintain the Usage Inventory Data Mart which combines inventory usage data from scrap, picks, return to inventory, return to vendor and inventory adjustments.• Researched and evaluated new data warehousing technologies including but not limited to SFTP alternatives for SSIS and SSIS 2014.• Lead the project to design, development and implement the Kronos Data Mart.

Appleton, Wi

Every other Saturday, I tutored students in Mathematics.

Appleton, Wi

• Tutored students in Mathematics• Facilitated an Algebra study group.• Tutored students in XHTML, CSS, JavaScript, PHP, and Visual Basic.

Menasha, Wi

Filled in for absent teachers in emergency and for short and medium term assignments. Followed lesson plan set by regular teacher. Corrected homework assignments. Promoted positive and supportive learning environment while ensuring good behavior. Maintained attendance and achievement records according to school policy. Completed appropriate reports and performed special duties of regular teacher. Participated in general school activities.

Wrightstown, Wi

Neenah, Wisconsin

Little Chute, Wi

Appleton, Wi

• Diagnosed and repaired computer hardware and software issues• Provided hardware and software solutions for clients

Appleton, Wi

Taught three 8th and 9th grade summer school Mathematics classes. Developed well planned lessons with a focus on providing clear explanations and enthusiastic classroom presentations. Used graphic calculators for demonstration and to enhance student understanding. Effectively handled inappropriate student behaviors.

Appleton, Wi

Successfully designed and presented Integrated Mathematics and College Preparatory Mathematics. Integrated graphic calculators, Geometer’s Sketchpad and Calculator Based Laboratory Systems (CBL) into lesson plan. Acted as Freshman Home Room Advisor. Responsible for assisting students with class scheduling, developing a rapport, acting as a mentor. Supervised and assisted students in a variety of subjects during Saturday and morning detentions. Effectively coached students for ACT test and college placement tests. Member of Curriculum Development Committee responsible for ensuring curriculum and text book adherence to state standards and school philosophy. Practiced traditional based teaching strategy. • Through effective teaching enabled my students average to exceed district-wide math assessments by 7% when compared to the rest of the district.

Appleton, Wi

Conscientiously instructed Pre-Algebra, Algebra, Honors Algebra and College Transition Algebra classes. Provided clear explanations, engaging questions and involved students in problem solving. Assisted in curriculum development and standards and ensured text books abided by these standards. Taught ACT preparatory class consisting of 40 students. As Advisor for after school Photography Club, instructed students on the process, activity and art of creating pictures.

Wisconsin Rapids, Wi

Taught Connected Math Project and Core-Plus Math Project. Initiated integration of technology into curriculum - graphic calculators, geometry sketch pad, and Calculator Based Laboratory Systems. Conducted multiple faculty workshops geared at Integrating Graphic Calculators into Curriculum, Introduction to Novel GroupWise, and Connecting Math and Science. Member of Committee on establishing district policy for scientific and graphic calculator usage. Member of Technology Committee responsible for prioritizing and determining the distribution of funding for technology. Assisted staff with hardware and software issues and acted as advisor for technology integration into classroom. Coached 8th grade basketball, baseball and debate team. Tutored at-risk students, mentored special needs students and helped student assimilation by developing a rapport, provided support and demonstrated concern for students’ academic and personal well-being.

Greater Milwaukee Area

• Met with potential clients for showings• Managed maintenance request• Provided maintenance and repair• Profiled competitive properties for comparision

Green Bay, Wi And Milwaukee, Wi

• Responsible for overall operations• Handled large sums of money and responsible for its security• Trained new staff• Managed a staff of 18 employees

Associate’S Degree, It - Programmer/Analyst, 3.994

Activities and Societies: Phi Theta Kappa, Association of Information Technology Professionals (AITP) Programmer/Web Development subplan.

Master’S Degree, Education

Edbs, Secondary Education - Math 6 - 12Th Grade

High School Diploma, General