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.
• Created Tableau dashboards to track patient outcomes, hospital readmission rates, and other key healthcare metrics, providing valuable insights for healthcare providers.

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.