Kathy Winn

Current position is a one-year contract position for Akkodis out of San Diego, CA. The responsibilities of my position are to develop the Interoperability process for health care data using the USCDI data exchange and HL7/FHIR mandates.

• Develop mapping and data specifications for EMR output using required data schemas.
• Develop and maintain SQL tables, stored procedures, views, functions, and agent jobs that automate and move data daily.
• Responsible for monitoring and attending to any issues for incoming and outgoing data from 3rd party vendors and in-house entities.
• Create SSRS reports and dashboards for in house users for specific EMR data abnormalities.
• Develop scripts in Python that are designed to run SQL code and build JSON output files for 3rd party vendors.
• Work with various team members to maintain documentation on SharePoint for team sharing.
• Collaborate with end users on specifications for ad-hoc requests.

• Currently working as a Data Analyst for MSSIC CQI which is a statewide quality improvement collaborative of Neurosurgeons that measure surgery quality
• The position was responsible for full cycle SQL database development, ETL development, report development, and Power BI development
• I am also responsible for data analysis, CQI registry support and helping customers automate their individual data processes
• Develop SQL Server databases for staging, development, and production environments for both transactional and warehouse implementations
• Develop complex SSIS packages to import data from several different sources, set up SQL Server agent automation and monitor pass/fail results
• Extensive experience in developing Stored Procedures, triggers, functions and auto moving data from Staging to transactional production and warehouse environments
• Develop, secure and automate SSRS reports for end users
• These report notifications helped end users with keeping notified of data changes for what is monitored
• SSRS developed in SSMS or SSRS report manager
• Develop Power BI reports and dashboards for individual teams and management
• This involves consulting with business owners on what KPIs they need and from what data sources they need the output to use
• Responsible for all development documentation and training of any new processes developed
• Work with business owners to understand their current processes and develop a plan to automate anything we can using the database tools available
• These tools include using Excel to SQL with refresh options or, using Power BI dashboards to pull the fields specific for their business need
• Responsible for any ad-hoc reporting requests.

• Worked as part of the Business Intelligence team which was responsible for gathering and reporting on the highest level of KPI’s for management in the data warehouse at the closest to real time as possible
• Development and Implementation of SSIS ETL processes to pull data from several sources
• Develop and maintain QA scripts and processes to continuously monitor new data for issues
• Development and automation of large sets of SSRS reports for end users using SSMS or SSRS report manager
• Write raw and efficient T-SQL code without the use of tools
• Load SSAS cubes for Power BI data resource
• Participate in requirements and design review meetings to create plans and test strategies
• Capable of understanding the difference between a data warehouse and a relational database and the difference in table structure such as fact tables, dimension tables and relational tables.

• Lochbridge was the new name for the Compuware consultant team that was purchased in 2015
• I originally was hired by Compuware
• My assigned project was for BCBSM as a SQL Developer
• Responsible for following project plans to update tables, move data, and automate processes on production servers for a variety of healthcare data
• Developed DTS and/or SSIS applications to move large datasets between test and production servers
• Create test plans, project scopes and work with DBA’s to properly manage production tasks and communicate project status with business users
• Develop and support reporting for BCBSM business users
• This includes creating stored procedures, views, functions, and scheduling processes
• Responsible for the successful completion of daily/weekly and monthly automated SQL jobs
• Team Lead for a SQL Developer Team of four.

• HSS is a supplier of GM parts for various GM plants
• Responsible for normalization of data and successful data migration into various data warehouses
• Develop SSRS report for all departments
• This includes using SQL ETL tools, build SQL Functions, Views and Stored Procedures and automate exports and report updates
• Develop monthly and quarterly reports for managing partners and the General Motors Finance teams
• Responsible for managing contracts for General Motors and Federal contracts with GSA.

• Create complex Finance reports for Sr
• Management using various database tools such as SQL, DTS, Visual Basic, Pivot tables, etc
• Responsible for around the clock maintenance of PMFA software maintenance such as scheduled imports/exports
• Repair immediate issues so normal operational functions will run as scheduled and not hold up the daily processes
• WealthLine web administration
• Responsible for daily uploads of complex financial reports, system maintenance and client support.