Stephen McCready

Senior BI & Data Analyst with 20+ years’ experience delivering data-driven insights, reporting platforms, and business intelligence solutions for complex organisations. Expert in SQL, Power BI, reporting automation and database design, with a strong track record of rapid delivery, data quality assurance, and commercial impact. Proven ability to parachute into engagements, define scope, and deliver stakeholder-ready analytics quickly.

Core Skills & Strengths

Business Intelligence & Analytics

• BI Reporting & Dashboarding (Power BI, SSRS).
• KPI design, executive dashboards, interactive reporting.
• Data storytelling for commercial decision-making.

Data Engineering & Modelling

• SQL development (MS SQL & Oracle).
• Data modelling, ETL logic, automated reporting pipelines.
• Data reconciliation, quality checks, anomaly resolution.

Delivery & Stakeholder Engagement

• Contract & consulting delivery: fixed scope, rapid turnarounds.
• Requirements gathering, user acceptance testing (UAT), documentation.
• Cross-functional collaboration with business, finance, and tech teams.

Technical Tools

• SQL (T-SQL, Oracle, MySQL), Power BI, SSRS, Python, XML, JSON, PowerShell, SFTP.

Senior Analyst / Elevance Health, New York

October 2020 - Current

Data Analysis, System migration and Operations

• Health provider contract analysis.
• Regulatory and Compliance reporting support.
• Insurance claim system migration.
• Implemented new claim clearing house vendor.
• File transfer software implementation and support.
• Interoperability FHIR (Fast Healthcare Interoperability Resources) solution installed.
• IT and business vendor management.
• Developed a telephone system KPI dashboard.

Key achievements:

• Clearing house vendor implementation completed in 4 days.
• Insurance claim system migration - 1 month ahead of schedule.
• Automated reconciliation logic for the NY market that was adopted nationwide.

Senior Data Reporting Analyst / Centers Plan, New York

December 2018 - October 2020

Data analysis and reconciliation expertise

• Designed dashboards that allow stakeholders to identify KPIs and drill down so that actionable insights can be made immediately instead of waiting days or weeks for detailed reporting.
• Built automated processes to reconcile data warehouse data sets so that anomalies can be identified and rectified expeditiously.
• Developed processes to project growth to enable finance staff to estimate future income and expenditur.e.

Key achievements:

• Reduced reporting turnaround from days/weeks to near-real-time deliverables for finance and operations.

Senior Software Engineer (Freelance), Singapore and Shanghai

March 2016 - November 2018

Providing technical expertise in a variety of development projects.

• Developed and implemented ETL processes for a US-based healthcare information solution provider, DocEnable. Project was completed ahead of schedule and under budget.
• Built Mandarin flashcard app, enabling students to learn Chinese characters, pinyin, pronunciation, meaning and stroke order.
• Oversee the transition of IT responsibilities for AlphaCare (Magellan Health), providing guidance to former colleagues on project statuses, next steps, operational issues, and assisted with on-going development.

Director, Information Technology / Alphacare of NY (Magellan Health)

April 2013 - March 2016

IT support during the start-up phase

• Created and implemented cloud applications for AlphaCare, enabling field staff to spend more time with patients and less time on administration.
• Forged the development of a data warehouse that enabled actuaries and accountants to rapidly project future costs based on patient utilization, membership roster and claim cost rates.
• Set up an AWS environment to host multiple applications.
• Developed custom ETL processes.
• Designed dashboards, summaries, detail and reconciliation reports, maps and charts for management and staff of the Finance, Marketing, Claims, Enrollment and Provider Network departments; built utilizing SSRS, Crystal Reports and HTML/CSS/PHP/JavaScript/jQuery.

Key achievements:

• Delivered technology support for the successful launch of four health insurance products within a five-month period.
• Purchased, configured and installed network and desktop hardware in a new office to cater for 100+ employees.

Vice President of IT / US Imaging Network, New York

January 2009 - April 2013

IT support during the start-up phase

• Set up ETL processes and 3rd party applications ensuring readiness for the first client implementation.
• Developed an application allowing Customer Service Representatives to update information from four different systems within a single browser window; built using jQuery, Google APIs, MS-SQL and MySQL databases along with a myriad of other tools.
• Directed the development of an application that automatically calculates commission payments, improving tasks which previously took days into a process that now takes minutes.
• Recruited, trained, and mentored a team of developers, experienced programmers, recent college graduates, and interns.

Key achievements:

• Led the development of a browser-based financial modeler, reducing the turnaround time of proposals from weeks to days.
• Developed a customer support portal enabling staff to access member data from disparate systems in one browser window.

IT Manager / Royal Health Care, New York

October 2007 - January 2009

IT management and hands-on data warehouse support

• Managed the day-to-day operations of six devops staff.
• Streamlined the client tracking reports from the companies data warehouse.
• Developed a browser-based task assignment system that kept stakeholders informed of the status of their IT requests.

Key achievements:

• Re-designed the data warehouse refresh process to deliver up to date information.

Additional Experience

• Affinity Health Plan, Bronx, New York
• Quest Diagnostics, West Norriton, Pennsylvania
• Ochsner Health Plan, New Orleans, Louisiana
• Olde Towne Consulting, Milwaukee, Wisconsin
• Centene Corporation, St. Louis, Missouri
• Britannia Life, Glasgow, Scotland
• Clydesdale Bank, Glasgow, Scotland