Prasanna M Email and Phone Number

• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL, Tableau and POWER BI, SAS ,DBT , Snowflake. Periodic reporting is done on a daily, weekly, monthly, and quarterly basis.• Strong analytical skills; support operations through analysis of key performance indicators and trends.• Created various types of charts such as Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop, Power BI, and Excel to provide better data visualization.• Solid knowledge of Power BI and Tableau Desktop report performance optimization.• Created Excel reports, Dashboards & Performing Data validation activity using VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map, and Heat Map.• Expert on maintaining and managing Microsoft Power BI and Tableau reports, dashboards, and publishing to the end users for Executive level Business Decision.• Experienced in managing users, groups, sites, permissions, and roles on Tableau server.• Superior multi-language communication skills (French, Amharic) - market analysis on product design and segmentation.• Thrives in high-pressure environments, budget forecasting, management, and strong team player skills.• Communicated with users, other technical teams, and senior management to collect requirements and describe data modelling decisions and data visualization strategies.• Data blending implemented on databases and generated interactive dashboards.• Created ad-hoc reports to users in Tableau by connecting various data sources.• Handled Tableau admin activities granting access, managing extracts and installations.• Generated Dashboards with Quick filters, Parameters, and sets to handle views more efficiently.

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes, and views using T-SQL in the Development and Production environment.AS Metadata and ETL developer skilled in SAS DI Studio, SAS Management Console, and the SAS BI suite, securing metadata repositories and optimizing ETL processes. • Wrote complex SQL queries utilizing joins, sub-queries, and common table expressions (CTEs) to acquire business-related data.• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, and database links formatted the results into reports, and kept logs.• Created Stored Procedures to transform the Data & and worked extensively in T-SQL for various needs of the transformations while loading the data.• Participated in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.• Performed tune to optimize SQL queries using SQL Profiler and Query Analyzer.• Worked on Creating, Modifying, and updating the Views and Functions.• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.• Developed dynamic and complex worksheets and embedded into dashboards.• Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications.• Prepared dashboards using calculated fields, parameters, groups, sets, and hierarchies in Tableau.• Created different visualizations using Bars, Lines, Pie charts, Maps, Scatter plots, and Heat maps.• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.• Mentored business power users to create reports/dashboards using Tableau Desktop. Published several data sources to Tableau server.• Organized all the workbooks in Microsoft Team Foundation Server and used it as a version control system for Tableau development.

• Participated in daily scrum meetings with the team to discuss the challenges and development of the project.• Involved in requirement gathering from business users and IT teams to understand and express business processes and business logic.• Extracted data from the data warehouse server by developing complex SQL statements using stored procedures and common table expressions (CTEs) to support report building.• Created SSIS packages for ETL processes by using control flow and data flow components.• Maintained and tuned performance for slowly running SSIS packages.• Created SSIS package developments, Unit testing, and deployment in Dev and QA Environments.• Interacted with technical team and Business users to performance analysis of business requirements and transformed them into technical requirements for ETL.• Led the migration of legacy data warehouses to Snowflake, ensuring minimal downtime, data integrity, and improved performance in the new environment.• Leveraged Snowflake's capabilities for machine learning and advanced analytics by integrating with platforms like Azure ML and AWS SageMaker, driving data-driven decision-making.• Automated routine tasks and complex workflows using Snowflake Scripting, reducing manual effort and increasing operational efficiency.• Collaborate with Software engineering resources to deliver high-quality deployments that meet department and customer expectations for quality and schedule.• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)• Work with business teams to understand current business processes for onboarding acquired bulk claims data.• Evaluate legacy solutions and technology to understand the viability of leveraging these to match requirements for new applications.

• Built and automate process for revenue and sales forecasting on daily basis and visualize using R and Power BI.• Creation and execution of stored procedure in SQL for improved performance and reusability.• Responsible for migrating Tableau/Micro Strategy, Power BI reports from Oracle Database to SQL Server. • Extensively involved in profiling data and analysis for identifying and putting right the inaccurate data from the databases to track data quality required for building the reports.• Familiar with Power BI, I have a strong foundation in creating SQL Statements, Reports, Dashboards, Visualizations. I have participated in technical planning & requirements gathering phases including Design, code, testing, troubleshooting, and documenting the workflows.• Understanding of Semantic Layer in Power BI• Involved in generating provider performance reports, Slot Utilization reports and initiating risk settlements on a monthly, quarterly, and annual basis.• Identified the set of reports using same data-source to create one unified query to support all the reports using same data-source.• Created and maintained ER-Data Models and data-flow diagrams for the project. • Experience in writing SQL queries, functions in Oracle/SQL Server. Modifying existing scripts for query performance using SQL Server Management Studio and Oracle SQL developer during migration.