Pratap Kotte Email & Phone Number

Wellesley Hills, Massachusetts, Us

• Performance tuning of dashboards and best practices for designing, building dashboard, reports in Power BI. • Created SQL Cluster/Non - Cluster Index, Unique/Check Constraints, Views, functions. . • Developed complex stored procedure, cursors according to the need. • Designed and developed SSIS Packages for regular ETL load.• Analysed the source data and handled efficiently by modifying the datatypes. Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, aggregate and Slowly Changing Dimension, Merge Join and Union all. • Created Tableau dashboards to track patient outcomes, hospital readmission rates, and other key healthcare metrics, providing valuable insights for healthcare providers.• Integrated data from electronic health records (EHR) systems, patient management software, and other healthcare databases into Tableau, ensuring accurate and comprehensive data analysis.• Developed Tableau reports to assist in regulatory compliance by tracking and visualizing metrics related to healthcare regulations, such as HIPAA and patient safety standards.• Utilized Tableau's advanced analytics features to forecast patient admission trends and resource utilization, helping healthcare facilities optimize staffing and resource allocation.•Regularly developed Power BI Reports as per the HR Department demands. Scheduled data refresh on Power BI server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately. • Designed mobile specific dashboards in Power BI.Used multiple DAX functions like Calculate, Min, Max, Average, Filter etc. for analytics and reporting. •Integrated Azure Synapse Analytics for seamless data integration and analysis, leveraging its powerful data warehousing and big data capabilities.

London, Gb

• Analyzed, developed, tested and documented data integration ETL processes using SSIS Packages. • To migrate business data from multiple legacy data sources to a single data base source. Developed enterprise dash boards that’s how the Key Performance Indicators (KPIs) and data trends. • Schedule SQL Server Agent to run the package on daily basis or schedule according to the change request. • Performed the Modification of SSIS package. Worked with several facets of SSIS - Mapping Data, Data Flow, Control Flow, transformations for better performance and exporting. • Configured the sessions using workflow manager to has multiple partitions on Source data and to improve performance. • Configured Agile boards to visualize project workflows, track user stories, and monitor sprint progress.• Streamlined the integration of financial data from diverse sources like ERP systems, CRM platforms, and databases, ensuring cohesive and accurate data representation in Tableau.• Implemented Tableau solutions to analyze investment portfolios, presenting data on asset distribution, performance metrics, and market conditions to support investment strategies.• Created bespoke Tableau reports for clients, delivering tailored financial insights and enhancing client engagement through transparent data visualization.• Employed Databricks for advanced financial analytics, including predictive modeling and machine learning on transaction data.• Configured Snowflake data warehouses for secure and scalable financial data storage, enabling efficient data sharing and collaboration.• Developed Snowflake SQL queries and procedures to support financial reporting and ad-hoc analysis. • Implemented a chatbot using Automation Anywhere to handle common customer queries, reducing response time and improving customer satisfaction.