Mike Zokir

Genesis Healthcare, Inc. (“Genesis”) is a holding company with subsidiaries that, on a combined basis, comprise one of the nation's largest post-acute care providers with nearly 250 skilled nursing centers and senior living communities in 22 states nationwide. Genesis subsidiaries also supply rehabilitation therapy to approximately 1,100 locations in 43 states and District of Columbia. Genesis' subsidiaries employ approximately 40,000 people, each one dedicated to delivery of high-quality, personalized health care to all patients and residents.

• Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks.
• Developed T-SQL Scripts to validate data after loading process. Modified and tested T-SQL stored procedures
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for application.
• Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
• Used Temporary tables, table variables in Stored procedures to simply complex queries
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL codes and SQL joins for SSIS packages and SSRS reports
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Developed data warehouse process models, including sourcing, loading, transformation, and extraction of source data
• Developed intelligence-sharing dashboards, providing company-wide access to collected data.
• Assessed platform statistics to create customized, data-intensive BI analytics
• Wrote and optimized SQL statements to assist business intelligence practices
• Created optimal technical solutions to user needs with in-depth system analysis
• Improved data collection methods by designing surveys, polls and other instruments.
• Developed polished visualizations to share results of data analyses.
• Identified and described relationships between data fields in enterprise databases.
• Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.
• Created proofs of concept for innovative new solutions.
• Created, updated and maintained Azure Data Factory loads and scripts to manage, distribute and secure company data.

Sedgwick is a leading global provider of technology-enabled risk, benefits and integrated business solutions. The company provides broad range of resources tailored to clients' specific needs in casualty, property, marine, benefits and other lines.

• Implemented various tasks and transformations for data cleansing and performance enhancement of SSIS packages
• Supervised performance tuning of SQL queries and stored procedures using Index Tuning Wizard and SQL Profiler
• Utilized SSIS and extract transform loading (ETL) tool of SQL Server to populate data from different data sources, making packages for various data loading tasks for application, enhancing existing ETLs and creating some new ETL procedures
• Designed and implemented TSQL queries for reporting and complex solution development.
• Designed Data warehouse and did mappings from Source to Target tables
• Identified dimension, fact tables and designed Data-Mart using Star schema
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler
• Created Stored Procedure, functions, indexes (Clustered, Non-Clustered), tables, semantic views and SQL joins utilizing latest DML and DDL syntax
• Developed, implemented and optimized stored procedures and functions using T-SQL.
• Assisted in developing of 10+ database projects for numerous customers, completing projects on time and 10 % under budget
• Coordinated with management teams to plan, develop, align and execute strategies that would meet client's vision, mission and purpose.
• Created optimal technical solutions to user needs with in-depth system analysis
• Implemented system enhancements to design and develop solutions to address problem reports
• Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations
• Wrote and optimized in-application SQL statements

Concentra, a division of Select Medical, is a leading health care company focused on improving health of America's workforce, one patient at a time. More than 11,000 Concentra colleagues provide occupational medicine, urgent care, physical therapy, and wellness services from more than 500 medical centers and 130 onsite clinics nationwide.

• Maintained T-SQL queries, views and stored procedures in multi-database environment with little supervision.
• Produced high-standard database solutions to meet stability, reliability and performance metrics.
• Developed custom database objects, stored procedures and delivered application support.
• Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
• Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Assist in Preparing performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL and Excel and gives PPT presentation near client for this on daily basis.
• Assist in Developing and deploying SSIS packages, configuration files, and schedules job to run packages to generate data in CSV files
• Developed, monitored and deployed SSIS packages. Developer in creating complex Stored Procedures, Triggers and Functions.
• Implemented various tasks and transformations for data cleansing and performance tuning of SSIS packages.
• Run SQL Server SSIS packages to load and transform to SQL Server data warehouse.
• Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment
• Analyzed existing SQL queries to identify opportunities for improvements