Connie Smith Email & Phone Number

• Lead the design, development, and ongoing support of clinical and financial integrated data models and reports used by provider and payer management in decision-making. This includes but is not limited to determining appropriate data transformations and governance strategies needed to provide trusted data sets for NCQA HEDIS & CMS STARs reporting and analytics.• Responsible for designing new data structures, mapping data from client source data to our data models, writing SQL/SQL like scripts to load and transfer the data to databases and performing data analysis with ETL.• Leads ideation sessions using lean principles to develop, document and analyze present state process maps and develop future state models.• Conduct, assess and profile data mappings to adhere to specific data structures, ensuring data quality is clearly defined to meet requested business use cases.• Design, create and maintain accurate and efficient data models.

Remote

Performed various analyses and quality assurance on multiple platforms including UDWUSP, UDWEXCH, UDW, Galaxy, SMART, SMART-IFP, COSMOS, CIRRUS, CQDB, Oxford, MCD, and MCR. • Analyze, review, and trend complex healthcare data.• Effectively communicate analysis to business partners.• Support operational / strategic business activity analysis.• Develop recommended business solutions with research and analysis. • Identify solutions to non-standard requests and problems.• Transition needs into completed projects.• Solve complex problems and conduct complex analyses.• Mix of business and technical skills.• Medicaid, Medicare and Commercial sectors.• Annual HEDIS reporting and analytics. • Annual CAHPS data review to ensure compliance.• Utilize tools: SQL, ETL processes, BI tools, SSIS, Azure, Toad, DBeaver, Hive, AWS, Snowflake, Scrum & Advanced Excel.

Midland, Michigan

(Hired by Dow Chemical then Corteva purchased Business)Manage the utility costs of 1400+ meters in an Access Database and work closely with all production leaders and site managers to ensure all meters are working properly. Create various reports to illustrate usage trends:• Maintain and support billing/accounting quality data to ensure timely and accurate recharge requirements related to utilities generation and distribution for the Industrial Park.• Support billing/accounting processes and related reporting mechanisms in order to maintain accuracy of departmental reporting.• Review monthly invoices and interface with contacts at companies/organizations providing utilities to the Industrial Park. • Review/Approve payment of invoices and interface with Accounts Payable (A/Pay) to ensure timely and accurate payment of utility invoices.• Interface with cost accounting monthly – to ensure accurate charge of utilities and follow up with cost accounting to correct any errors.• Analyze utilities data and develop technical solutions, system changes, procedure developments to close any identified gaps.• Participate on teams formed to improve quality processes and procedures.• Develop and initiate data, reports & processes at the request of businesses resources, site resources, and management.• Specify, develop, and follow standards to ensure billing quality data and accuracy by working closely with production leaders and electrical engineers.• Implement strategies to reduce data problems and manage Access databases and various Excel spreadsheets (macros, pivots, VLOOKUP’s, etc.)• Perform month-end close accounting activities for Energy & Utilities using the Access database reporting system. • Manage various Excel data pulls, pivot tables, charts, and dashboards• Conduct focused project work to standardize Energy & Utilities physical and electronic practices• Logistics administrator for chemicals: verify specifications and ensure proper protocol.

Hospital Consumer Assessment of Healthcare Providers and Systems Data Analysis: complete monthly and quarterly reporting to the Board of Directors; manage and input data for NDNQI, MHA and our system wide patient satisfaction survey database.• Responsible for maintenance and coordination of system-wide use of the clinical applications within an integrated decision support system which encompasses six hospitals. • Assists clinical processes and outcomes by developing, managing and analyzing clinical pathways, quality indicators, case cost effectiveness and product line profitability. • Perform complex collection, storage, retrieval, and dissemination of integrated data within EPIC.• Establish quality control procedures, assisting in conducting acceptance tests in conjunction with software vendors and information resources staff when necessary. • Work with outside vendors and internal information resources systems staff to ensure that existing extracts adhere to established specifications, enhance existing extracts as reporting requirements expand, and develop new extracts for additional feeder systems.• Maintain and update master file structures, work closely with Information Resources Department, financial services and/or vendor representatives as required as changes occur, test programming changes and updates to the system. • Primary contact for Case Management staff, clinical pathway project leaders or service line managers when technical issues arise. And troubleshoot to determine if related to software or hardware and coordinates resolution of problems.• Patient Quality/Safety module database administrator for the health system. Trouble shooting and database maintenance for all users. Provides ongoing software support and education for users and ongoing support to medical and administrative leaders on their use of the system, and participates in appropriate committees ensuring software meets needs of the health system.

Bay City, Mi

(Left this additional career of teaching to allow others the opportunity)Provide quality instructions to help students develop skills and knowledge they can use to pursue career opportunities in a variety of fields. • Teach Microsoft Applications and Internet classes in the evening• Create class materials, presentations and course instructions• Advanced Excel, Access, Power Point, Windows, Word, MS Office, SQL, Visual Basic, C++, HTML and Java• Develop creative ways to get student participation and involvement

(Position eliminated during Dow Chemical acquisition / merger)Strong communication skills combined with a tenacious, hard-working stance are what I attribute to my success. This role requires a broad knowledge of analytical and organizational skills, as well as strong oral and written communication skills. • Coordinate IT support for entire Procurement department• Manage the execution of all Procurement (buy) contracts and created quality documentation to be utilized globally• Interview Contract Candidates for professional services within our Contracts Management team• Develop and maintain various monthly financial Excel databases for Leadership• Created and managed database for analyzing our global energy usages and costs• Knowledge of Ariba, SAP, SharePoint, Clarity, Concur and all Microsoft Applications• SharePoint Team room development, permissions and maintenance• Manage co-ops, Procurement interns and mentor the Contracts Management team• Complete monthly financial scorecards for our CFO• Complete confidential high level ad hoc projects for Leadership• Maintain day-to-day management of managers such as schedule, travel, expenses, report and record management• Notary Public

Midland, Mi

(Left contractor position for direct hire position at Dow Corning Corporation)Ensured strategic objectives by managing and coordinating information and operational support. • Create and manage various Web Pages • Security/Permissions Administrator• Maintain monthly reporting and ad hoc data requests for the IT Architecture Director and Leadership Team • Safety Warden/Notary Public/ Building Focal Contact Person• Create and maintain various work processes / document flow chart processes and procedures

Saginaw, Mi

(Position eliminated due to significant decreases of State funding)Built a framework for population health analytics; analyze and made inferences fromhealthcare data; efficient infrastructure architectures for claims, data cleansing, data transformation, and data integration.• Responsible for Business Warehouse data integrity and the process flow documentation on multiple databases• Submit quarterly patient and demographic data to the State of Michigan• Utilize SQL Query Analyzer, Enterprise Manager & Business Intelligence Reporting• Technical writing for process flow charts and documentation

Bachelor Of Science In Management Information Systems | Business Administration, Dual Major, Magna Cum Laude

Activities and Societies: Alpha Chi Omega

Associate In Business Management, Business/Office Automation/Technology/Data Entry

Activities and Societies: Phi Theta Kappa

Associate In Computer Science & Information Technology/Programming, Computer Science

Activities and Societies: Phi Theta Kappa