OBJECTIVE

• To work in a fast paced environment, working on challenging projects while sharing over thirty - six years of experience with other software developers.
• Looking for a position as a Project Manager, Business Analyst or Data Modeler in the downtown, South or Western suburbs of Chicago or remote.

SUMMARY

• Thirty-six years’ experience in software development.
• Solid IT manager with over thirty years experience managing IT projects and developers.
• Over thirty years’ experience as a Business Analyst on large and medium sized projects.
• Twenty-six years of software architect experience on various platforms.
• Over thirty years experience modeling relational database schemas, using all of the major RDBMS.
• Extensive experience managing development teams of 6 to 85 resources and budgets up to 12 million.
• Software development experience on many different platforms: Mainframe, Distributed, Client\Server and Web.
• Extensive experience managing customer relationships from pre-sales to post-implementation support.
• Over ten years of experience managing off-shore development teams.

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst - Data Modeler

Responsibilities:

• Redesigned the Polling the Nations SQL Server database to be more relational and functional while supporting new requirements.
• The database grew from 3 to 29 tables.
• Wrote a comprehensive set of data clean-up and data standardization tools designed to quickly modify the unstructured data.
• Worked with the founders of Megalodon to design a new Captive Insurance Management Application.
• Designed and created the data model for this new Captive Insurance management company using SQL Server.
• Over 120 tables, 70 Views and 150 triggers.
• Worked with the Megalodon SMEs to identify requirements, design and document the user interface including over 100+ wireframes, 30 process definitions and 100+ user cases.
• Major Features include:
• Fully integrated Content Management
• Includes database tags, templates, documents and document packages.
• Role Based Security Model.
• Fully Integrated Email Client that integrates Email messages with enterprise data.
• Interfaces directly to MS Word, MS Excel, PDF, Email and Skype.
• Rich set of configurable Business options to drive Billing, Receivables and Renewal Processes.
• Task based workflows.
• Full Featured User Centric Dashboard.
• Ability to Assign User to Accounts, Captives, Pools and Policies.
• Full audit trail functionally.
• Worked with the Amphion Management team to identify, design and implement a series of system enhancements required to manage an anticipated large growth in business services.
• Designed the transcription archive system and database, this project includes a data warehouse, creating an XML version of the transactional database, data encryption and SQL Server FileStream functions.
• Designed and documented an automated system to import transcription and coding data from Amphion customers into the billing and payroll systems.
• Responsible for SOW development, project scope, project planning, functional and technical requirements and high-level system design.
• Created a large inventory system to manage the database objects for a conversion project from Oracle to SQL Server.

Technologies: Agile Methodology, MS Office, MS Visio, MS Project, Oracle, SQL Server Management Studio, Visual Studio 2013, SSRS, SSIS and Atlassian Confluence.

Confidential

Sr. Project Manager - Business Analyst - Contractor

Responsibilities:

• Performed as Project Manager and Business Analyst for the DaVita Falcon EHR Nephrology Lab application rewrite project.
• Responsible for Project management, project planning, staffing, acceptance process, issue resolution, risk identification and mitigation, release scheduling, change management, status reporting and management of the analysis, development and testing teams.
• Performed business analysis, designed and documented over 100 web pages.
• Managed a team of over 60 resources (domestic and off-shore).
• For the State of Georgia, I was asked to help fix major issues with their GABasics project that were preventing them from going to production.
• Technologies: Agile Methodology, MS Office, MS Visio, MS Project, Oracle, MVC, SQL Server, Visual Studio 2013, SSRS, SSIS and SharePoint.

Confidential

UI Designer - Data Modeler - Business Analyst - Contractor

Responsibilities:

• Confidential is a startup firm seeking to establish a software site to assist the restaurant industry with staffing and HR functionality.
• Worked with the founders of Confidential to design and build its initial Website and Database application.
• Designed, coded and built the Confidential SQL Server database.
• Designed over 30 of the Web sites initial pages.

Technologies: Agile Methodology, MS Office, MS Visio, MS Project, SQL Server, Visual Studio 2013 and MVC.

Confidential

Sr. Project Manager - Business Analyst - Data Modeler - Contractor

Responsibilities:

• Designed and led the development of SymphonyCare, a Health Care Population Management Application.
• My duties were to work with SME’s to determine the functional requirements, design and create the database (over 200 tables), complete the high level design (over 160 web pages), create wireframes for each page and lead the off-shore development and testing teams for this leading-edge product.
• The system was interfaced to the clients Claims and EHR systems to consolidate patient information for reporting.
• This groundbreaking application was designed to group patients with a common health issues and determine group level and patient level Care Plans based on standards of care, health history and lifestyle variables.
• Included extensive reporting capabilities to support HEDIS, PQRI and Custom Reporting Measurements required by Accountable Care Organization (ACO).
• Designed UI and database components to support the Johns Hopkins Adjusted Clinical Groups (ACG) Software.
• This SymphonyCare was sold to Influence Health (formerly MedSeek) and added to its suite of Health Care Software Tools.
• For Amphion Medical Services, I conducted a current state analysis and provided future state recommendations to manage a 50% increase in business growth.

Technologies: Agile Methodology, MS Office, MS Visio, MS Project, MS Access, SQL Server Management Studio, Visual Studio 2013, SSRS, SSIS, SharePoint and Atlassian Confluence.

Confidential

Sr. Project Manager

Responsibilities:

• Performed analysis on the current state functionality of the Claim Adjudication processing system.
• This system had over 8,000 COBOL modules, interfaced with over 40 other HCSC systems and has over 10.5 million lines of COBOL code.

Technologies: Agile Methodology, MS Office, MS Visio, MS Access, Analysis of COBOL, JCL, VSAM, DB2.

Confidential

Sr. Project Manager - Data Modeler - Consultant

Responsibilities:

• Analyzed and redesigned the three systems used by the Air Management Program into a single Program wide application. The new application will reduce data entry, improve data integrity and vastly improve the Air Programs ability to serve Wisconsin’s business and citizens’ needs.
• Designed and developed the new program-wide Oracle database, combining data from 8 different existing large databases into a single consolidated database.
• Designed and developed the database and User Interface for the Wisconsin DNR’s Guidance knowledge base. The project involved creating an application that would allow DNR staff (500) and business users (5,000) to search for, view and create Guidance documents. The project included an extensive workflow process that managed the creation, approval and publishing processes for Guidance documents.
• Designed an Enterprise level system for the management of Facility and Contact information. Prior to this project, information about the 5,000 regulated businesses was stored in 19 different department databases.
• Redesigned the DNR’s Hazardous Waste Consolidated Reporting System (CRS) this annual reporting system collects information from over 2,000 Wisconsin Firms about the hazardous waste they generated, shipped or received.
• Performed the analysis for a redesign of the DNR Air Management Division Internet and Intranet sites. Designed and developed tools for the on-going management for these sites that had over 50,000 files and over 12,000 HTML static pages.
• Following the completion of these projects the public perception of the Wisconsin’s DNR Air Program went from last to a leader in the eyes of the business community.

Technologies: MS Office, MS Visio, MS Access, MS Project, Visual Studio .NET 2005 with an Oracle RDMS.

Confidential

Director of Information Technology

Responsibilities:

• Managed a team of ten postscript and Internet developers.
• Developed procedures, standards and adopted best practices into the RGC processes.
• Designed Internet based database driven marketing solutions for RGC Customers that created print and WEB deliverables.

Technologies: MS Office, MS Visio, MS Access, MS Project, Visual Studio .NET 2005 and SQL Server.

Confidential

Sr. Project Manager - Business Analyst - Data Modeler

Responsibilities:

• Conducted an analysis of the current state of Air Permit, Emission and Compliance systems. Deliverables included a merged and improved data model, requirements document, high-level design for the new combined Air Management system and a document describing the next steps.
• This project was the basis for a four-year software development project geared towards developing an enterprise-wide software strategy for the DNR Air Management division.

Technologies: MS Office, MS Visio, MS Access, MS Project, Visual Studio .NET 2005 and Oracle