Kruti Khatiwala
Cell: 732-***-****
Email: ad8tee@r.postjobfree.com
LinkedIn: https://www.linkedin.com/in/kruti-khatiwala-18153889/
Professional Summary:
Over 10+ years of extensive IT experience in the Analysis, Development, Implementation and Support of SQL Server, T-SQL programming in OLTP environment and Data warehousing.
5+ years of experience in Analysis, Development, Testing of business applications in Healthcare Environment.
Experienced working with HCPCS, CPT, Procedure Codes, Claims, Attribution, Providers, Payor, Revenues (RVUs), COVID Health reporting, PCMH, CMS and most of the health care related terminologies.
Experience working with Cerner, Meditech and EPIC data Systems and K12 education domain.
Experienced in working with Agile environment, ITSM and JIRA, SVN, GitHub, ServiceNow.
Experienced in working with Data warehousing and data migration and SQL Agent job scheduling.
Experienced in working with different versions of SQL such as SQL Server 2012/ 2014/ 2016 /2019.
Experience in applying SQL Best practices to optimize the performance.
Experience in migrating data between different source systems using SSIS packages.
Experience working with T-SQL and PL-SQL both.
Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings / workflows to extract data from SQL Server, Flat File sources and load into various Business Entities.
Experienced in the complete life cycle of SQL Server Integration services (SSIS) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL jobs across different servers.
Experience in creating Data reconciliation reports for Source to Target data flow.
Expertise in creating Stored Procedures, views, tables and constraints for Data consistency.
Experience in writing DDL, DML & Joins statements as per the requirements.
Expertise in creating indexes to provide better performance and minimize the table scans.
Experience in creating views to facilitate restricted user interface implementation.
Expertise in rebuilding the indexes at regular intervals for better performance.
Experience with writing SQL Procedures in SNOWFLAKE
Microsoft Certified Azure Data Fundamental professional
Expertise in creating ad hoc queries to produce custom data extracts.
Expert in designing and scheduling complex SSIS Packages for transferring millions of records from multiple data sources to SQL server. Expert in Creating, Configuring and Fine-tuning ETL workflows designed in SQL Server Integration Services (SSIS).
Hands on experience with performing various SSIS data transformation tasks, Script tasks with C# and VB.Net, working with Event Handlers, Error Handlers and API Integration using Script tasks.
Experience in creating configuration files to deploy the SSIS packages across all environments.
Expert in implementing Error (event) handling and automating these processes
Experience visualizing and analyzing dashboards developed in SSRS, Tableau, Power BI
Excellent verbal/written communication skills and strong analytical abilities, and can perform well both independently and as a team player.
Ability to handle multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and total commitment to the organization goals.
Excellent ability to quickly grasp and master new concepts and technologies.
Aspiring to learn Python to contribute towards Data analytics.
Professional Certification:
Microsoft Certified: Azure Data Fundamentals (DP-900)
Issued on June 08, 2022
Credential ID 14861889
Working towards achieving Azure Data Engineer Certification (DP-203)
Education:
Bachelor of Engineering in Computer Engineering with Dharmsinh Desai University (DDU), Nadiad, Gujarat, India.
Technical Skills:
Technologies known:
Databases (SQL Server, Oracle), ETL (SSIS), Snowflake, AWS (S3, Lambda, DynamoDB, Kibana), Reporting (SSRS, Tableau), Microsoft Azure
Tools Known:
SQL Server Management Studio (SSMS), DBeaver, Visual Studio and BIDS/SSDT, JIRA, ITSM, Appian, HP-ALM, GitHub, SVN (Version Control), Microsoft Office Suite – Excel, Power Point, Word, Access
Languages
T-SQL, PL-SQL, C#, VB.net, VB Script, HTML, XML,
Job Functions:
Requirement Analysis, Design, Coding, Testing, Documentation, Maintenance and Production Support
Professional Experience:
CareFirst BCBS (Employer: Dexian/DISYS) July 2023 – Present
Role: Sr SQL ETL SSIS Developer
Responsibilities
Involved in entire SDLC starting from requirement gathering sessions, understanding the requirements, involved in discussing the solutions with solution architect, creating design document, development, unit testing and production deployment.
Understand the requirement and provide the technical solution using SQL and ETL technologies.
Write complex T-SQL and PL-SQL queries and stored procedures to build specific logic in Data warehouse.
Optimize the performance of queries with modification in T-SQL queries, eliminated redundant and inconsistent data, established joins and created indexes wherever necessary.
Work with Data warehouse, data migration between different source systems.
Work on the assigned Stories as a Developer and as a Peer Tester
Integrate and maintain code at GitHub
Development of SQL processes in Snowflake
Performance Tuning and optimization of SQL queries.
Develop SSIS package for ETL purpose, work with loading data from different database and file systems.
Visualize and analyze dashboards prepared in SSRS.
Create ad hoc queries to provide ad hoc reports based on available data as per the request received from business team.
Follow SQL best practices in the code which I develop during the project.
Create Dashboards on Tableau for Data visualization.
Communicate effectively with business users to identify current reporting procedures and clarify program objectives.
Interact with the team/business end users to discuss the status of the project, clarify the queries regarding the functionalities.
Use SSIS to create ETL packages to extract, transform and load data to data warehouse databases. Created packages using Integration Services (SSIS) for extracting data from Flat Files, Excel files, CSV files and Oracles source to SQL Server.
Implemented Event Handlers and Error Handling in SSIS packages.
Deployed the created SSIS packages in Development and Testing environments.
Implemented the Email feature for sending notifications of SSIS jobs to the concerned people/Distribution List to notify about the execution & status of packages.
Implemented and automated the Audit tracking to capture Number of records in each phase, captured the processing time for each step, implemented checkpoints to validate the Audit result.
Environment: MS SQL Server 2016/2008R2, T-SQL, MS SQL Server Integration Services (SSIS), SQL Profiler, Oracle, XML, Microsoft Office Suite, Microsoft Azure, Snowflake, GitHub
Frederick Health Mar 2019 – July 2023
Role: Sr Business Intelligence Developer
Frederick Health includes a network of providers offering primary care, family medicine and a wide range of specialty services in the form of the Frederick Health Medical Group. Our physicians and clinicians work closely together to provide the best possible treatment plan and follow up care for all our patients.
Responsibilities
Involved in entire Software Development Life Cycle.
Understand the requirement and provide the technical solution using SQL and ETL technologies.
As I was part of end-to-end business processing team, worked on data requests and delivered requested reports to throughout the teams.
Wrote complex T-SQL queries and stored procedures to build specific logic in Data warehouse.
Created role specific views to provide restricted access to different role specific profiles.
Use SQL Profiler for tracing and debugging of the T-SQL scripts & efficient report generation.
Optimize Stored Procedures and long running queries using indexing strategies and query-optimization techniques eliminated redundant and inconsistent data, established joins.
Created Dashboards on Tableau for Data visualization.
Communicated effectively with business users to identify current reporting procedures and clarify program objectives.
Interacted with the team/business end users to discuss the status of the project, clarify the queries regarding the functionalities.
Implemented complex SSIS packages to extract, transform and load data to data warehouse databases.
Environment: MS SQL Server 2016, T-SQL, MS SQL Server Integration Services (SSIS), SQL Profiler, Microsoft Office Suite, Microsoft Azure
The College Board Feb 2018 – Mar 2019
Role: SQL ETL Developer
The college board is the non-profit organization which develops and administers standardized tests used by K-12 and post-secondary education institutions to promote college-readiness and as part of the college admissions process. They manage the assessments and generates the scorecards. I am part of Scoring team and involved in developing and support of Scorecards.
Responsibilities
Gained knowledge of K-12 education data source systems.
Wrote complex T-SQL queries, stored procedures and triggers to build specific logics.
Worked on pulling data from large Data warehouse, migrated data from one source system to other as needed.
Optimized the performance of queries with modification in T-SQL queries, eliminated redundant and inconsistent data, established joins and created indexes wherever necessary.
Created analysis & design documents for implementing the client specified requirements.
Data visualization using SSRS.
Performed monitoring of Production jobs during releases to ensure smooth working of system.
Interactions with the team/business end users to discuss the status of the project, clarify the queries regarding the functionality etc.
Production Support / Incident Management / Change Management
Knowledge sharing within the team.
Environment: MS SQL Server 2016/2008R2, T-SQL, MS SQL Server Integration Services (SSIS), SQL Profiler, Oracle, AWS (S3, Lambda, DynamoDB, Kibana), Appian, JIRA, XML, Microsoft Office Suite
Intelivita, India May 2010 to Apr 2013
Role: Database Engineer
Prabhudhan, India May 2009 to April 2010
Role: Business Data Analyst