Business Intelligence Software Development

Margaret Ann McLeese

PROFESSIONAL SUMMARY

Areas of Expertise

Business Intelligence & Analytics, Data Warehousing, Data Marts:

PowerBI, Cognos, Tableau, Pyramid Analytics

Tools:

Office365, Active Directory

Programming:

SQL

Languages:

SQL, HTML, DAX, PAX, XML

RDBMS:

SSMS, SSRS, SSIS

Version Control Tools:

GitHub

Performance Tuning:

Splunk, AppDynamics, Science Logic, Dynatrace, ServiceNow (CMDB, ITSM, ITOM), SolarWinds

ETL and BI Tools:

Cognos, SSMS, SSRS, SSIS

Program Management:

Software development, database migrations, system migrations/integrations, enterprise-wide implementations, automated solutions, new enterprise systems

IT Project Life Cycle:

RFP/RFI/proposals, Requirements management, business analysis, costing and budgeting – statement of work (SOW)/MSA, PWS, project scheduling, testing/QA/rollout/PMO

Value-Added Leadership:

Business Management, team building and mentoring, team training, client relations, and presentations

Consulting and Solution-Selling:

Client discovery and project documentation for enterprise hospital implementations, including preparation of pre- and post-implementation documents with change management processes, training plans, and workflow.

SKILLS SUMMARY

More than 30 years of Health Care IT experience, including clinical practice, Practice Management. software implementation, Enterprise Hospital software implementation, EHR Implementation, Mental Health EHR implementation, Health Information Exchange Implementation and Sustainment

Sixteen years of experience in all phases of software development life cycle (SDLC) including identification of business needs and constraints, collection of requirements, architecture design and standards, user interface (UI) design, Super User and End User training, implementation, testing, deployment, and maintenance.

Experience with commercial and government programs: delivered expert-level support for implementation of the Joint Health Information Exchange for the Department of Veterans Affairs in Tennessee and Kentucky. Provided business intelligence and operational metrics for contractors and government PMOs. Provided metrics and tool design portions of proposals and recompete for Joint HIE support contract.

Expert in Agile methodologies; Product Manager/Product Owner Certified with hands-on experience on Agile projects and use of Agile tools in ServiceNow and JIRA.

An effective communicator able to leverage technical, business, and financial acumen to communicate effectively with client executives (including CTO and CIO) and their respective teams.

Delivery leader with a proven track record of consistently building cross-functional teams, encouraging innovation, and delivering outstanding results to clients.

Two years of Site Reliability Engineering for the Department of Veterans Affairs, utilizing AppDynamics, SolarWinds, Splunk, ServiceNow, and other tools to provide metrics demonstrating the stability of monitored systems and the impact of monitoring on Major Incident occurrences, duration, and resolution.

Employment History

PROFESSIONAL EXPERIENCE

Softrams, LLC, Woodlawn, MD 01/2023 – Present

Role – Information Resource Management Analyst

Department of Labor

Lead/execute functional tests to ensure the EBSA systems are performing according to Government requirements. Suggest and document new or modified EFAST requirements. Review deliverables to ensure adherence to applicable standards and best practices. Support in developing independent cost estimates and reviewing proposed costs. Lead/execute data analysis and structured queries of EFAST related data. Use Altova XML Spy to create and execute test scripts for SAT. Verify database/system conformance with data element requirements. Coordinate team members in developing documentation and analysis.

Tucker-Rose Associates, New Braunfels, TX 01/2022 – 01/2023

Role - Sr. Program Analyst – Event Management.

Enterprise Command Operations

IT Operations and Services (ITOPS), Office of Information and Technology

Contractor for the US Department of Veterans Affairs

Applied a wide range of IT principles, concepts, methods, laws, regulations, and practices in support of enterprise decisions and initiatives to develop and interpret policies, procedures, and strategies governing the planning and delivery of services; utilized expert technical advice on resolving critical IT issues; applied expert knowledge of IT architecture sufficient to design, develop, and manage systems.

Tucker-Rose Associates, New Braunfels, TX 07/2021 – 01/2022

Role - Event Management Operations Specialist

Enterprise Command Operations

IT Operations and Services (ITOPS), Office of Information and Technology

Contractor for the US Department of Veterans Affairs

Applied VA Information System and Technology infrastructure knowledge and the use of modern system monitoring tools (Dynatrace, AppDynamics, SolarWinds, Aternity, LiveNX, ServiceNow, ScienceLogic, and Splunk) to improve VA enterprise reliability and improve the quality of services provided to veterans. Turned requirements into actionable alerts and ensured the Monitoring Service Registry was up to date by meticulously reviewing and approving applications for VA Authority to Operate.

Worked in an agile environment with the event management triage teams, application development teams, and operations teams to develop and implement response processes when monitoring tools alerted of interruptions of normal operations in Applications and IT Infrastructure. Promoted to Sr. Program Analyst.

Tucker-Rose Associates, New Braunfels, TX 01/2021 – 07/2021

Role - Site Reliability Engineer, Sr. Pyramid Analyst

Contractor for The US Department of Veterans Affairs

Responsible for analyzing data across multiple channels to understand behaviors and performance of enterprise applications for the OIT Operations Triage Group. Operations Triage reviews Major Incidents to determine Escalation Response, Time to Resolve, and Time to Close, as well as Root Cause Analysis, Incidents by Department, Type of Outage, and Resolution.

Mined raw, unstructured data using big data tools including Pyramid Analytics, PowerBI, SQL, and Splunk. Analyzed performance across all engagement channels to understand usage behaviors and areas to further optimize and maximize application reliability. Recommended changes in procedures and staff education opportunities that decreased down time and allowed management to see the possibilities for automated responses when systems mimic behavior known to preceded an outage. Contract Ended 07/01/2021.

Liberty IT Solutions and The Green Technology Group 08/2016 – 01/2021

Role: Sr. Business Analyst, Veterans Health Information Exchange Community Coordinator

Contractor for The US Department of Veterans Affairs

Led and coordinated the deployment of the Veterans Health Information Exchange in Tennessee and Kentucky as the main point of contact. Interfaced with stakeholders supporting The US Department of Veterans Affairs and private sector providers interested in implementing Veteran health data exchange in the specified VHIE Community. Provided business intelligence and program metrics to government and corporate teams.

Bethel University 6/2015 – 8/2016

Role: Financial Aid and Institutional Reporting Analyst

Developed complex queries for institutional, state, and federal reporting (National Student Clearinghouse, TICUA, IPEDS) using Microsoft SQL Server Management Studio. Developed Microsoft Excel Macros and Macro-enabled spreadsheet applications for use in Financial Aid.

West Tennessee Motor Coach, LLC 2/2012 – 6/2015

Role: General Manager

Responsible for all operations of a Charter Bus and Tour company. Managed over 25 staff members including sales and marketing, drivers, and maintenance shop. Complete charge of all budgeting, financial activities, contracts, human resources, purchasing, and strategic planning.

EDUCATION and CREDENTIALS

Master of Science in Management from Austin Peay State University, Clarksville, TN 12/2007

Bachelor of Science with concentration in Sociology from Excelsior University, Albany, NY 12/2005

Diploma in Surgical Technology from Tenn College of Applied Technology, Paris, TN 6/2002

Certified Surgical Technologist 2002- 2008

SAFe Certified Product Manager/Product Owner 3/2023-Current

Public Trust 2016-Current

Contact this candidate