Celia Markoya

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum interdum urna ultrices consectetur tincidunt. Fusce imperdiet ipsum sed bibendum pellentesque.

• Developed Tableau dashboards for executive leadership and board members. Presented monthly strategic plan reporting updates with executive leadership team and department managers to discuss trends, best practices and areas of opportunity. Worked with Chief Operations Officer to set departmental goals for consumer and patient experience.
• Owned and independently led data reporting conversion projects for the organizational transition of electronic medical record system to Epic. Obtained Epic Cogito reporting exam certification. Acted as a liaison and maintains good communication and collaboration with other departments.
• Served as project manager of the organization's 2025 Planetree certification and ensured the organization focuses on person-centered care. Served as a subject matter expert for 2025 Magnet certification and provided evidence to show quality patient care as well as nursing excellence.
• Discovered hidden insights from weekly consumer experience data exploration and checked for data integrity with data warehouse. Perform troubleshooting of existing processes and procedures.
• Provided day to day support of Tableau data visualizations for operations team using reporting dashboards to review injury trends as lagging indicators for daily business review.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum interdum urna ultrices consectetur tincidunt. Fusce imperdiet ipsum sed bibendum pellentesque.

• Led health & safety department over multiple facilities, provided weekly data analysis training to team members. Developed four (4) coordinators over two (2) years who were then promoted to specialists.
• Developed a machine learning model, selected the best model based on AUC, using Python to predict injury trends and designed a real-time alert system to prevent high-risk activities. Built logistic regression and random forest models for contributing factors to incidents.
• Used Amazon Quick Sight to connect to injury/claim metrics collected in the cloud and combine data for business review from multiple sources including AWS data, spreadsheets, etc.
• Performed exploratory data analysis on 55,000+ reported incidents in global database and preprocessed data by removing duplicates and encoding categorical features.
• Documented all incident data as per recordkeeping policies. Worked with Auditors and provided related documents from database.
• Designed, created, and maintained safety database objects to ensure database normalization by eliminating redundancy and inconsistent dependencies.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum interdum urna ultrices consectetur tincidunt. Fusce imperdiet ipsum sed bibendum pellentesque.

• Partnered with data and business analysts to refine business requirements that must be met for building and maintaining data warehouses/marts built on Microsoft SQL Server 2014.
• Designed, created and managed regular tuning of physical database objects (tables, views, indexes) in MS SQL Server 2014 to support normalized and dimensional models.
• Configured SQL Server maintenance plans to automatically back up SQL Server Databases, optimize index and update statistics.
• Worked as primary T-SQL developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Performed code reviews, analyzed execution plans, and re-factor inefficient code. Followed data standards, resolved data issues, completed unit testing, and completed system documentation for ETL processes.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, Oracle etc. to SQL Server using SSIS various features such as multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion.
• Collaborated with system teams and development teams for codes release including Microsoft SQL database changes and patches.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum interdum urna ultrices consectetur tincidunt. Fusce imperdiet ipsum sed bibendum pellentesque.

• Supported data analysis for patient satisfaction survey in 33 hospitals with a sample size of 1,439. Upgraded Patient Satisfaction Report and created Hospital Performance Improvement Plans during the development of the "Healthy City" project in Shenzhen.
• Performed source code analysis and development of ETL jobs to migrate data from a source to a target data warehouse.
• Worked closely with data architects, business users, application architects, and other developers to model, implement and improve databases used in mission-critical applications within the organization.
• Enabled/performed consistent development and maintenance of Microsoft SQL Server 2012 database designs for custom business applications in accordance with business, regulatory, and security requirements.
• Transformed business requirements into logical and physical data models by conducting data profiling/analysis. Maintained and published data mappings of data elements across systems and created and maintained relevant architecture artifacts.
• Created the automated processes for the activities such as database backup processes and SSIS Packages ran sequentially using SQL Server Agent job.
• Utilized software development lifecycle principles and experiences to develop within the full life cycle of the mission critical production application.
• Managed MSSQL data warehouse, Wrote SSIS for ETL tools, SSRS for reports. Provided data services to the support team (data scrubbing, inserting, and updating customer data).
• Performed T-SQL tuning and optimization of queries that take longer execution time using MS SQL Profiler and Indexes in MS SQL Server 2012.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum interdum urna ultrices consectetur tincidunt. Fusce imperdiet ipsum sed bibendum pellentesque.

• Monitored all activities of the server, such as: the daily SQL jobs, SQL Server error logs and Windows error logs.
• Translated user requirements into reporting solutions and customized to specific user requests.
• Enhanced system performance by optimizing queries and proper utilization of report cache and snapshot.
• Involved in performance tuning of database and T-SQL queries using Explain Plan. Created Indexes, Constraints and Rules on database objects.
• Created stored procedures and user-defined functions to support efficient data storage and manipulation. Handled database objects with Enterprise Manager.
• Provided Technical Documentation for future enhancements. Scheduled and managed daily, weekly, & monthly sales and operational reports based on the business requirements.