Mike Fitzpatrick Email & Phone Number

Chicago, Il, Us

Chicago, Il, Us

Grand Rapids, Michigan, Us

● Responsible for database architecture in Amazon Aurora MySQL transactional database and Amazon Redshift data warehouse ● Work with business and development teams to support new application features ● Develop reports in Amazon QuickSight● Create and maintain ETL processes to extract data from multiple sources ● Mentor new teammates on database usage

Grand Rapids, Michigan, Us

● Responsible for database architecture in Amazon Aurora MySQL transactional database and Amazon Redshift data warehouse ● Work with business and development teams to support new application features ● Develop reports in Amazon QuickSight● Create and maintain ETL processes to extract data from multiple sources ● Mentor new teammates on database usage

Grand Rapids, Michigan, Us

● Worked with business and contractors to develop financial reporting suite in Tableau ● Developed reliable and efficient ETL processes ● Created set of reports to monitor data quality ● Worked to continuously improve the performance and quality of data systems

Traverse City, Mi, Us

● Designed, created, tested, and deployed data warehouse tables, procedures, cubes, and jobs using Microsoft SQL Server ● Developed reliable and efficient ETL processes using SQL Server Agent, stored procedures, custom functions, SSIS, PowerShell, Informatica, and Salesforce Data Loader ● Worked with information analysts to support reporting needs in Tableau, Excel, SSRS, and R ● Extracted, transformed, and loaded multiple sources including flat files, Excel files, SQL Server tables, and Salesforce objects ● Developed integrations with 3rd party vendors like Adobe Analytics ● Worked to continuously improve the performance and quality of ETL components and queries ● Assisted database administrators with upgrading SQL Server databases and tools ● Mentored other developers ● Worked with IT leaders and business users on data roadmap ● Helped investigate new tools and platforms

Traverse City, Mi, Us

● Designed, created, and maintained software applications ● Prepared project plans with time and cost estimates ● Planned, created, maintained, and enhanced relational databases ● Developed reports for end users at all levels of organization ● Trained users on in-house applications ● Created data interfaces to Lawson payroll and H.R. system ● Integrated third-party scanning tools into core business application to enable electronic storage of over 100,000 documents ● Created reminder system to dynamically show tasks based on user and job function ● Upgraded databases and development tools to new versions ● Created functions for users to email/fax/export database reports ● Migrated several legacy applications into client/server applications ● Developed custom interface to import email addresses from physician database to Microsoft Exchange

Zeeland, Michigan, Us

● Analyzed, designed, developed and implemented client/server database applications using Oracle Developer and Oracle Reports ● Created HR application to store employee information ● Created Training Management application to track employee education ● Created Attendance application to record time worked and time absent ● Created Payroll system application to pay over 1500 employees each week ● Produced over 150 forms and reports ● Implemented a reliable network installation for Oracle Forms, Reports, and Graphics ● Implemented a secure, easy to maintain front-end for multiple applications ● Met with users to determine application specifications

Cork, Ireland, Ie

● Developed client/server database applications using PowerBuilder ● Met with customers to determine application specifications ● Supported and enhanced existing applications ● Mentored IS interns ● Developed context-sensitive help systems for PowerBuilder applications

Bba, Corporate Finance

Additional Coursework, Computer Information Systems