jyoti Saraswat

Designed and developed dynamic tables, views, and stored procedures in Snowflake to structure and optimize the data for reporting.
Utilized Snowflake SQL for effective data manipulation and analysis.
Managed and processed JSON data stored in Snowflake, ensuring data integrity and optimizing storage.
Created comprehensive Power BI reports and dashboards by leveraging Snowflake tables and views to visualize ADO and AHA integration data, providing actionable insights to the team.
Worked closely with the ADO platform to ensure data hygiene, monitoring and maintaining the integrity of project data, and streamlining workflows for the Leap Dev team.
Created and maintained detailed reports and dashboards in Azure DevOps (ADO) to track ADO health and project progress, enabling Agile Coaches to have clear visibility into their activities and task statuses.
Utilized GitHub for version control, ensuring proper tracking of all development work, including Pull Requests (PRs) for collaboration and code reviews.
Worked within the ADO Board to create and manage tickets, ensuring efficient project management and prioritization.
Wrote complex SQL queries and logical queries for data extraction, transformation, and analysis.
Developed DAX formulas within Power BI for advanced calculations and analytical insights into project and team health metrics.
Applied best practices in data modelling and query optimization to improve performance and reliability of reports.

Designed and developed dynamic tables, views, and stored procedures in Snowflake to structure and optimize the data for reporting, Utilized Snowflake SQL for effective data manipulation and analysis, Managed and processed JSON data stored in Snowflake, ensuring data integrity and optimizing storage, Created comprehensive Power BI reports and dashboards by leveraging Snowflake tables and views to visualize ADO and AHA integration data, providing actionable insights to the team, Worked closely with the ADO platform to ensure data hygiene, monitoring and maintaining the integrity of project data, and streamlining workflows for the Leap Dev team, Created and maintained detailed reports and dashboards in Azure DevOps (ADO) to track ADO health and project progress, enabling Agile Coaches to have clear visibility into their activities and task statuses, Utilized GitHub for version control, ensuring proper tracking of all development work, including Pull Requests (PRs) for collaboration and code reviews, Worked within the ADO Board to create and manage tickets, ensuring efficient project management and prioritization, Wrote complex SQL queries and logical queries for data extraction, transformation, and analysis, Developed DAX formulas within Power BI for advanced calculations and analytical insights into project and team health metrics, Applied best practices in data modelling and query optimization to improve performance and reliability of reports

Migrated institutional financial data from SQL Server to Salesforce CRM using Salesforce Data Loader, ensuring data integrity and consistency.
Extracted and manipulated data from various data objects using SQL Query, Window Function to load in salesforce and performed Duplicate Analysis using Fuzzy Match to maintain the data accuracy.
Executed data mapping by matching tables and attributes using Excel VLOOKUP functions, ensuring high data integrity and consistency across the dataset.
Worked closely with the engineering and business team using scrum/agile methodology.
Identified and evaluated custom objects in the system to optimize data storage and system performance, assisting in the removal of redundant custom objects.
Developed Dashboards like "Search and Authentication," facilitating manual customer searches and verification processes for Customer Support Agents.
Built reports and dashboards incorporating KPIs such as Unique Customer Manual Search, Unique Manual Search, Ratio of Manual and IVR Search, and Search Authentication Type.

Migrated institutional financial data from SQL Server to Salesforce CRM using Salesforce Data Loader, ensuring data integrity and consistency, Extracted and manipulated data from various data objects using SQL Query, Window Function to load in salesforce and performed Duplicate Analysis using Fuzzy Match to maintain the data accuracy, Executed data mapping by matching tables and attributes using Excel VLOOKUP functions, ensuring high data integrity and consistency across the dataset, Worked closely with the engineering and business team using scrum/agile methodology, Identified and evaluated custom objects in the system to optimize data storage and system performance, assisting in the removal of redundant custom objects, Developed Dashboards like 'Search and Authentication,' facilitating manual customer searches and verification processes for Customer Support Agents, Built reports and dashboards incorporating KPIs such as Unique Customer Manual Search, Unique Manual Search, Ratio of Manual and IVR Search, and Search Authentication Type

Developed optimized SQL queries using Joins and Subqueries to extract and compile data from multiple models, ensuring comprehensive data retrieval for analytical tasks.
Analysed Mobile Tariff Plan Change (Crossal) data to identify cross-selling opportunities and improve customer experience.
Conducted data validation and Gap Analysis, identifying discrepancies to ensure data accuracy, and prepared insightful reports and Dashboards using Tableau.
Analyzed large datasets with techniques such as Quantitative analysis, Advanced analytics, and Statistical modeling to uncover actionable insights and trends.
Created dynamic and interactive visualizations using Tableau and Power BI, enabling stakeholders to explore data insights and track key performance indicators.
Utilized MySQL server to transform raw data into structured formats, extracting and preparing data for accurate and analytical reporting purposes.

Developed optimized SQL queries using Joins and Subqueries to extract and compile data from multiple models, ensuring comprehensive data retrieval for analytical tasks, Analysed Mobile Tariff Plan Change (Crossal) data to identify cross-selling opportunities and improve customer experience, Conducted data validation and Gap Analysis, identifying discrepancies to ensure data accuracy, and prepared insightful reports and Dashboards using Tableau, Analyzed large datasets with techniques such as Quantitative analysis, Advanced analytics, and Statistical modeling to uncover actionable insights and trends, Created dynamic and interactive visualizations using Tableau and Power BI, enabling stakeholders to explore data insights and track key performance indicators, Utilized MySQL server to transform raw data into structured formats, extracting and preparing data for accurate and analytical reporting purposes

Developed and implemented effective dashboard solutions for the metrics by coordinating with the business stakeholders.
Developed SQL scripts involving multiple data warehouses and schemas to analyze and automate the existing manual Data Loss Prevention Metrics.
Build the dashboard to monitor the performance of various models and effectively communicate with stakeholders to retain the models.
Analyze data and develop unique tables, charts, and other data displays for inclusion in reports to various clients and as data support for research/consulting staff using Power BI.
Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps and bullet charts demonstrating key information for decision making.

Developed and implemented effective dashboard solutions for the metrics by coordinating with the business stakeholders, Developed SQL scripts involving multiple data warehouses and schemas to analyze and automate the existing manual Data Loss Prevention Metrics, Build the dashboard to monitor the performance of various models and effectively communicate with stakeholders to retain the models, Analyze data and develop unique tables, charts, and other data displays for inclusion in reports to various clients and as data support for research/consulting staff using Power BI, Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps and bullet charts demonstrating key information for decision making

Developed and implemented effective dashboard solutions for the metrics by coordinating with the business stakeholders.
Developed SQL scripts involving multiple data warehouses and schemas to analyze and automate the existing manual Data Loss Prevention Metrics.
Build the dashboard to monitor the performance of various models and effectively communicate with stakeholders to retain the models.
Analyze data and develop unique tables, charts, and other data displays for inclusion in reports to various clients and as data support for research/consulting staff using Power BI.
Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps and bullet charts demonstrating key information for decision making.

Developed and implemented effective dashboard solutions for the metrics by coordinating with the business stakeholders, Developed SQL scripts involving multiple data warehouses and schemas to analyze and automate the existing manual Data Loss Prevention Metrics, Build the dashboard to monitor the performance of various models and effectively communicate with stakeholders to retain the models, Analyze data and develop unique tables, charts, and other data displays for inclusion in reports to various clients and as data support for research/consulting staff using Power BI, Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps and bullet charts demonstrating key information for decision making