Highlights:

Skills:Python, SQL, Machine Learning, Data analysis, Tableau, ETL

Data Analyst 02/2024 - current
Robotics Technologies, Duncanville, Texas United States
Developed and maintained SSIS packages for ETL processes using custom SQL stored procedures and Visual Studio Foundation Server. Conducted PostgreSQL database tuning to enhance query performance and managed ETL audit controls to ensure data quality. Improved data integration efficiency through complex SQL queries and SSIS package development. Contributed to an open-source project by implementing ETL solutions and optimizing data processes to meet project goals.
? Developed and maintained SSIS packages for ETL processes by creating custom SQL stored procedures, and managed SSIS projects using Visual Studio Foundation Server. ? Conducted PostgreSQL database tuning and optimization to improve query performance, designed and managed ETL audit control and scheduling processes, ensuring data quality and integrity. ? Enhanced data integration efficiency and supported data integration and analysis requirements through complex SQL queries and ETL process development using SSIS packages. ? Contributed expertise to an open-source project for a client, implementing ETL solutions and optimizing data processes to meet project objectives.--
Data Risk Analyst 01/2021 - 01/2022
Infosys - Client DTCC, Pune, Maharashtra India
Led 20+ projects to enhance risk reporting and data accuracy in the Fixed Income domain using SQL and advanced Excel, ensuring validation for senior management and risk committees. Conducted data analysis on margining methodologies and liquidity patterns with SQL, Oracle, and Snowflake, achieving 100% accuracy in pattern matching reports. Improved liquidity resource reporting accuracy and compliance by 20% through Tableau and Excel. Collaborated with cross-functional teams to implement new margin methodologies and enhance risk processes, utilizing JIRA for project management.
? Enhanced risk reporting and backtesting process by leading 20+ projects to enhance data coverage and accuracy in Fixed Income domain using SQL and advanced Excel, ensuring validation of key risk metrics reports for senior management and risk committees. ? Performed data analysis and generated insights into margining methodologies and liquidity usage patterns with SQL, Oracle, and SnowFlake, improving accuracy of pattern matching reporting to 100%. ? Leveraged reports on liquidity resources, ensuring accuracy and compliance requirements by 20% through streamlined data visualization and analysis with Tableau and Excel. ? Collaborated with 4+ cross-functional teams to implement new margin methodologies and enhance risk processes, utilizing JIRA for project management.--
Data Analyst 12/2019 - 01/2021
Infosys - Client DTCC, Pune, Maharashtra India
Analyzed revenue cycle management processes with SQL, identifying inefficiencies that reduced claim processing times by 20%. Developed and deployed analytical models to predict claim denials and optimize reimbursement rates, enhancing revenue recovery by 15%.
? Analyzed revenue cycle management processes using SQL to identify inefficiencies, resulting in a 20% reduction in claim processing times. ? Developed and deployed analytical models using SQL for predicting claim denials and optimizing reimbursement rates, enhancing revenue recovery by 15%.--

University 08/2015 - 05/2019
, , United States
Degree: Bachelor's Degree
Major:Computer Science
Software Engineering concepts.

Login to view resume: Pratik_Jagad_Resume_OPA -
Pratik_Jagad_Resume