Michael Patrick Beahan
ATI Physical Therapy March 2019 – September 2019 Bolingbrook, IL Contract Lead BI Developer
Created SSRS Reports to service business needs. Worked with users to gather specific detailed requirement.
Created SSIS packages to consume incoming data. Changed SSIS packages to accommodate file format changes. Eliminated long backlog of Team Foundation Server user stories during my tenure.Responsible for troubleshooting over 50 daily SQL Server nightly jobs that populate the Data Warehouse. Compiled extensive documentation of all ETL processes and jobs.
Howard Brown Health Center January 2018 – January 2019 Chicago, IL Lead BI Developer
Wrote Crystal Reports based on Centricity SQL Server data for submission to the City of Chicago and the federal governmentfor the purpose of obtaining grants. Worked with users to develop report specifications and extensive documentation.Developed reports to help clinical team improve HEDIS scores. Used Power BI to present graphical representations of data to users.
Family Health Network May 2014 – December 2017 Chicago, IL Lead SQL Data Warehouse ETL Developer
Designed and built Data Warehouses for health care claims, providers, and enrollees using SSIS for flat files, CSV files, Excel spreadsheets, and XML files. Used Iguana to parse HL7 files. Prepared reports for management using SSRS. Prepared reports for CMS and the State Of Illinois using T-SQl, stored procedures, and SSIS. Set up SSAS cubes for basic data mining. Assisted the HEDIS team to provide tables to dramatically improve their scores. Assisted the NCQA team to achieve NCQA Certification.Directly Responsible for the work of 3 coworkers and indirectly for a team of 5 BI developers. Compiled extensive documentation of all ETL processes and jobs.
Fidelis Senior Care November 2012 – April 2014 Schaumburg, IL Data Warehouse ETL Developer
Created data warehouse to track healthcare patient data. Developed SSIS packages to prepare EDI and other health care files for submission to CMS. Interfaced with IT Departments from other companies to create files for prescription reimbursements. Created system to track medical assessment tests for the company’s patients. Wrote stored procedures using T-SQL to do certain bulk inserts. Converted many of the company’s Microsoft Access systems and data to SQL Server. Used SSRS to create various reports based on user needs.
Hub International November 2010 – October 2012 Chicago, IL Contract ETL Developer
Solely responsible for moving data from many different legacy systems (TAM, Sagitta, Oracle, Excel, flat files, Microsoft Access databases, CSV delimited files) into companywide CRM system. Created hundreds of SSIS packages to retrieve and manipulate data and move into CRM. Wrote stored procedures to upload data into CRM
system. Created update, delete, and insert queries as necessary to manipulate data according to customer requests. Used SSRS to create reports on converted data. Set up SSAS cubes for basic data mining. Wrote stored procedures using T-SQL to do certain bulk inserts
Condata, Inc. -May 2009 – October 2010. Glenwood, IL ETL Developer/Business Analyst.
Wrote DTS packages to move shipping data in various forms (flat files, Microsoft Access databases, Excelspreasheets, PDF files, proprietary file formats) into central database. Worked with users to develop methods of findingshipping bill overpayments. Redesigned inefficient workflow by developing Windows Services using Winforms to polldirectories for incoming files, automatically process them, and send appropriate email notifications. Wrote application to viewSQL Server data and allow user queries. Supervised office move from Glenwood to Mokenafrom an IT perspective. Wrote Crystal Report and SSRS Reports based on user requests.
Clear Lam Packaging- May 2005 - May 2009. Elk Grove Village, IL Programmer.
Sole support for Visual FoxPro ERP System Concord, which is based on SBT/ACCPAC. Responsible for maintaining the supply chain. Wrote many FoxPro Reports to report on the data. Created an ADO.Net web site using VB.NET for customer feedback using ASP.NET for front-end interface. A 24 hour manufacturing company, responsible for occasionally dialing in via VPN to solve problems on the shop floor. Supervised network admin and hardware personnel. Approved software and hardware purchases.
Integrity Payment Systems - April 2003- May 2005. Des Plaines, IL Programmer.
Developed applications for a credit card processing company that converted ASCII text files and XML files into FoxPro data that was then used in reports and displayed on the Web using ASP pages created through Visual Basic.Net. Developed residual system in Visual FoxPro 9.0 to pay commissions to sales offices. Developed automated chargeback system using FoxPro and Visual BASIC.Net.
Newgen Information Systems – February 2002 – April 2003Naperville, IL Consultant.
Supported SBT/ACCPAC at various client sites throughout Chicagoland. Implemented upgrades and many customizations through FoxPro.
Thatcher Technology Group - July 2000 - February 2002. Addison, ILProject Manager.
Project leader on Pampered Partner, a software package for consultants for the Pampered Chef’s direct selling business. Supervised development team of 4 programmers responsible for 16 bit FoxPro version and development of a parallel 32 bit Visual BASIC 6.0 version. Developed user query system using Crystal Reports. Converted from English-only version to French and English version. Developed internal programs to track company training tasks in VB.Net. Made modifications to ERP System Sage Enterprise by making code customizations, developing additional report functionality using Crystal Reports, and MS SQL Server database changes using stored procedures. Used Internet Transfer Control and XML to significantly reduce order sending process time. Served as liaison between customer base and technical support staff.
American College of Surgeons- June 1997 - June 2000. Chicago, IL Senior Programmer.
Developed for a small department that produces a commercial software product that tracks hospital trauma patients. Coordinated and staffed booth exhibit at annual Clinical Congress meeting. Served as Novell and NT network administrator, recommending hardware and software purchases for both department and client base. Trained and supervised technical support staff for a 200 plus client base. Successfully lead group of three programmers that moved product from FoxPro 2.6 to Visual BASIC 6.0. Solely responsible for converting customer data from other trauma-tracking systems using different platforms such as dBase, Clipper, and Access, and Advanced Revelations.
Information Management Group- June '93 - June '97. Chicago, IL Software Consultant
Developed major applications in FoxPro for Fortune 500 Clients. Developed Reinsurance Processing System for Kemper Insurance’s Bermuda office, a proposal writing system for Motorola’s Cellular Division, a delinquent father tracking system for Cook County’s State’s Attorney’s Office, and a 401 (k) tracking system for Chicago Title and Trust, a budgeting system for the Chicago Board Of Trade.
US Navy Worked as personnelman on board USS Merrimack (AO-179).
University of Notre Dame B.B.A., Management Information Systems