221 Stanhope Drive, Willowbrook, IL 60527

JOHN A. MAHADY

312-560-8072

Core Qualifications

Full project life cycle Implementation Consultant
Business Analyst with strong technical skills
Previously an application and database Developer
Advanced in SQL Server stored procedures, analytical tools: Tableau and Power BI
Strong Presentation and Training Skills
PMP: Classwork complete, planning to take certification for exam

Technical Skills

Databases: MS SQL Server, Oracle, MySQL, SQLite, MS Access, OpenOffice Base, JSON, XML, CSV

Languages: DAX, SQL, C#, Pascal/Delphi, PHP, jQuery Desktop/Mobile, AJAX, JavaScript, CSS3, Python

Development: Eclipse, Notepad++, Visual Studio, MS SSMS, SSRS, SSIS, Talend, Oracle SQL Developer

Office: MS Office, Excel, PowerPoint, Outlook, Skype, WebEx

Project: MS Project, Visio, Jira, UMLet

Frameworks:ASP.NET MVC, Active Directory Domain Services, Yii

Web Servers:Apache Server, IIS

Utilities:PowerShell 3.0, Photoshop, ODBC, MySQL Workbench, Acrobat

O/S: Windows Server, Linux (Ubuntu), Android

Testing:Selenium, xampp, FireBug, DOM Inspector, FireQuery

Analytics:Power BI, Tableau Desktop and Server, Tabular Model, R, DAX

VMs: Microsoft Virtual PC, Oracle VirtualBox, VMware, Citrix XenApp & Receiver

Others: Accounting, SOAP, Web Services, FileZilla Server, Open Broadcasting Software, Avidemux

Public Speaking Toastmasters Club member, Software Trainer and Meetup.com technical presenter

Professional Experience

Implementation Consultant Jan 2017 to Current Andrew RE Group Willowbrook, IL

Manage the selection and financing of rental properties for family business.
Negotiate commercial and conventional loans with bankers and private lenders.
Process Accounts Receivables and have automated Accounts Payable processing on-line.
Advertise and acquire renters for residential properties. Perform credit checks, renew leases.
Manage projects: vendors, material purchases, repairs and upgrades of units.
Dynamic Reports for ongoing business.

Tools: MS Excel, Power BI, SQL.

Business Intelligence Consultant June 2016 to Nov 2016 Advocate Health Care Downer Grove, IL

Designed and implemented Project Management template for EDW and BI teams to formalize project documentation.
Built BI dashboards in Power BI for Nursing metrics and Safety and Quality metrics. Presented to Executive committee.
Wrote SQL and built Pivot Tables for numerous analytic reports.
Mentored BA team on new analytical tool, Microsoft's Power BI, and coding in DAX.

Tools: SQL Server 2014, T-SQL, Power BI, DAX, Tabular Model, Excel Pivot Tables.

Client Projects as a consultant, doing business as “Andrew Information Services” for 15 years

Implementation Consultant/Business Analyst Sep 2014 to Feb 2016 Infogix, Inc. Naperville, IL

Implemented requirements, wrote code in Infogix Assure software for Affordable Care Act CSR and APTC analysis.
Enabled clients to comply with mandated CMS laws and match cost share plans with base plans to reconcile subsidies.
Team member on Cost Sharing Reduction projects for major national Healthcare Insurance providers
Wrote code to capture raw data from EDI, XML and CSV data files into either SQL Server or Oracle tables.
Met with client Subject Matter Experts to gather requirements and design solution processes.
Designed and wrote the code to implement client pricing model and project requirements within project time line.
Specialized in designing processes of Pharmaceutical / RX claim for CMS requirements
Wrote project Design documents and Visio charts of process logic.
Wrote shell scripts for automated dynamic data file delivery and activation of controls in the core application.
Mentored and trained both client developers and off-shore junior developers to use Infogix Assure software.
Projects: HighMark, HealthNet, Blue Cross/Blue Shield N. Carolina, Independence Blue Cross, WellPoint

Tools: Infogix Assure 8.4, SQL, Excel, XML, EDI, Affordable Care Act compliance, in-house BI software, shell scripts, PowerShell.

Technical Lead / Business AnalystDec 2013 to Sep 2014 LECIP, Inc. Des Plaines, IL

Designed a virtual network/machine environment for developing and testing transit agency project environments.
Implemented an in-house Demo/Test Lab composed of the server application, data collection devices and web portal.
Responsible for evaluating the application framework, source code and databases of the core server application.
Wrote requirement documentation and Unit Test Cases.
Built numerous virtual MS Windows 2008 servers with ASP.NET, Active Directory and IIS architecture.
Performed evaluations and QA Testing of software designs, C# code/databases for specific project configurations.
Managed sub-contractors time-line commitments, scope definitions and other project contractual agreements.
Member of team of Project Managers creating proposal response documents to RFPs.
Provided technical definition/documentation for implementations, acceptance testing and change requests.
Represented the technical interests of the client in project meetings with clients, subcontractors and vendors.
Designed and made numerous short videos for support, problem resolution and training.

Utilized PowerShell to automate installations and other server tasks.

Tools: MS SQL Server (stored procedures), Visual Studio, C#, ASP.NET MVC, SOAP, AD/IIS, Oracle VirtualBox

Implementation Consultant Oct 2012 to Aug 2013 Basware, Inc. Rosemont, IL

Responsible for implementing company P2P software solution for enterprise clients in N. America.
Contributed to projects through gathering requirements, programming client processes in our A/P invoice software, testing, documentation and integrating Change Requests.
Designed training material and delivered on-site training at client facilities.
Responsible for writing Solution and Technical documentation.
Wrote stored procedures and views for client reporting requests for both Oracle and SQL Server platforms.
Led in-house training on Tableau Analytics tool and report creation for client projects.
Worked with the ERP integration team so invoices successfully entered software and processed to ERP software.
Hands-on support during problem-solving, user testing and Go-Live phase of project.
Contributed to fellow consultants and the firm with frequent in-house presentations on various job related topics such as SaaS, stored procedures for dynamic reports, the firm's in-house analytics module based on Tableau.

Tools: MS SQL Server and Oracle databases, stored procedures, Tableau BI and in-house software.

Project Manager, lead developer Jun 2012 to Sep 2012 Hannibal Medical Clinic Hannibal, MO

I designed and built the intranet website Information Center for a medical Clinic with 350 employees

Tools: PHP, MySQL, AJAX, jQuery, CSS, Selenium , Dynamic Web Design, Linux

DB designer & Senior DeveloperDec 2011 to June 2012 American Egg Board Chicago, IL

Built an Educational Marketing Website for the Egg Industry Association

Tools: PHP, MySQL, jQuery, CSS, FPDF (for dynamic PDF files) Reference:

I.T. ManagerOct 2010 to Oct 2011 MRC Investigations (USA) Wheaton, IL

Managed Microsoft Windows server, SharePoint intranet and created sales marketing application.

Tools: MySQL, MS SQL Server, triggers/procedures, OpenOffice Base, Access, MS SharePoint, MailChimp

Project ManagerJan 2010 to Sep 2010Structural Engineering Certification Board Chicago, IL

Managed 3 developers creating a Drupal based membership and certification website.

Tools: Drupal, PHP, CSS, MySQL

Project Manager, lead developer-Oct to Dec 2009Creative Group IncChicago, IL

Dynamic PDF marketing brochure maker website

Tools: PHP, Javascript, FPDF (for dynamic PDF files)

Project Manager, Business Analyst-18 monthsYMCA of the USA Chicago, IL

Unified and normalized all internal departments' data and applications into one compiled Windows based application.

Tools: MS SQL Server, Delphi (Object oriented Pascal), integrated MS Access for SQL Server report, ODBC drivers.

Senior Developer- 7 monthsSpencer StuartChicago, IL

Executive Search Candidate application running at worldwide offices.

Tools: Delphi and MS SQL Server stored procedures

Project Manager, Business Analyst- 2.5 years Rexam PLCOak Brook. IL

Departmental projects: R&D New Products Experiments Tracker and Marketing Prospect Tracker.

Tools: Pascal, SQL

Project Manager/Lead Developer- 6 monthsACCO BrandsWheeling, IL

VPN based Product Line Sales ETL dynamic reporting application for nationwide remote salesmen and distribution partners.

Tools: MS SQL Server, Pascal

Project Manager- 5 months. Hoffman Estates Medical Clinic Hoffman Estates, IL

Software to track patients in the Emergency Room to enable managers to allocate staff based on traffic and resources.

9 month data study with menu generated reports for managers.

Tools: Pascal, SQL

SQL programmer- 6 monthsEdwards HospitalNaperville, IL

Wrote the SQL statements for importing and normalizing data from 10+ departments for generating aggregated expense reports. Data came from different sources and structures so intensive normalizing/data cleansing required.

Tools: SQL code, Pascal

Education and Interests

B.A. Economics Wheaton College, Wheaton, IL (Included most courses in an MBA program including Accounting)

Former career: Financial Markets Analyst & Currency Trader

Continual self-study of new tools and trends in technology e.g. Talend, R, Scrum Master, Python, U-SQL

Completed qualified class for PMP certification exam

Toastmasters International club # 4724415

Real Estate investing and Board member of three Condominium Associations

Married