Mark Speer Email & Phone Number

Pittsburgh, Pa, Us

Pittsburgh, Pa, Us

•Make recommendations for optimal data extraction, manipulation, and integration methodologies based upon research and analysis. •Develop HEDIS, Custom and State Measures using SQL script and develop store procedure packages from technical specifications.•In collaboration with team member, perform ad hoc and re-curing data curation and reporting task.•Perform/develop complex data mapping and transformation analysis.•Provide advanced analytical support for business operations in all or some of the following areas claims, provider data, member data, clinical data, HEDIS, pharmacy, external reporting.•Meet deadlines and turnaround times set by supervisor. (These deadlines will, at times, require the employee to work until the project is completed, meaning extended daily work hours, extended work weeks, or both.)•Maintain up-to-date information on status and effort related to each project.•Develop and maintain working relationships with internal UPMC Health Plan departments, and external contacts as appropriate.•Developing integrated data sets to support analysis, data science, clinical operations, and decision support activities.•Provide technical consultation and act as reference point to peers, other business areas, senior leadership and external customers.•Adopt and promote best practices, tools, and methods set by team/department leadership.•Coordinate ongoing communication with other departments in order to manage information integrity and maintain cross-department processes.•Maintain policies and procedures of the team/department.

Louisville, Co, Us

• Use appropriate tools to perform data extraction, modeling, transformation, cleansing, loading, and interpretation.• Write complex SQL scripts to automate workflows• Identify, analyze, and interpret trends and patterns in large, complex data sets• Plan and Execute Data Migration of data from SQL Server to Snowflake with Azure• Architect design for implementation or deployment• Perform root cause analysis to assist business teams in solving problems at the source• Provide escalated support for production environments and debug issues• Transform, validate, analyze and load customer data into production environments• Contribute to backend and ETL development effort of shared data platform• Develop, tune, and maintain databases via SQL Server/Snowflake

Saint Louis, Mo, Us

Saint Louis, Mo, Us

• Produce reports for and interface with senior management and internal and external stakeholders• Gather and interpret business requirements and monitor data trends to proactively identify issues• Handle multiple projects and timelines effectively and communicate risks and issues to manager regularly• Create documentation to test quality of data• Create BRS documentation of business processes• Develop code to populate MicroStrategy dashboards/documents with live data for business users• Develop code for ad hoc reports and monthly state reporting• Develop Stored Procedures, Views, Sub-Queries and joins for complex queries involving multiple tables• Experience in coding and debugging for ETL processing huge volumes of data throughput • Utilized Jira for Project Management for MicroStrategy dashboard development • Continuous integration of larger scale projects • Collected structured/unstructured data in multiple databases to analyze and model for business initiatives• Work with other data analysts to improve development standards and documentation• Tested SQL scripts to improve data flow • Develop dashboards/documents to give the business side live data to work with• Create analytical graphs/charts to improve productivity and business processes• Design, develop, and test data from other databases• Exchange files with vendors/MCO’s for state reporting into our data warehouse• Design packages to refresh data in data warehouse• Developing/maintaining SSIS packages for ETL implementation• Document designs and data quality components

Hartford, Connecticut, Us

Hartford, Connecticut, Us

• Gathers information from the system, analyzes program and time requirements, and prepares documentation to change existing programs• Researches and analyzes existing systems and program requirements• Develop tests plans, procedures and data, and evaluates system, effectiveness and efficiency• Troubleshooting and assisting with database inquiries, as well as assisting the Testing Team by automating testing needs as well as building efficiencies in our current processes• Aid in testing for new product release to ensure government compliance• Verification and updating of data within the company database, within product and problem solve• Determining issues within the database and product to allow for correction before release• Creates complex queries, does technical report/programming using SQL Server• Contributes to activities such as analysis, planning, design, development, testing, installation and maintenance of support systems and workflows for business areas• Creates QA documentation of scenarios and files• Tracks defects of tickets that are open to systems• Aid in the development and enhancing the team’s process flow to meet standards• Test multiple application to make sure they run and standardize well with the systems

London, Gb

• Tasked with developing Databases using SQL and Spreadsheets for Directors and Managers.• Responsible for the processing of a high volume of protected health information and time sensitive medical management documents.