Ritesh Tatikonda Email & Phone Number

Kalyan, Mh, In

Powai

Mumbai, Maharashtra, India

1. Query databases using SQL to extract and analyze data from over 1 million records. Applied advanced SQLtechniques, including joins to integrate data from multiple tables, window functions for in-depth analysis,common table expressions (CTEs) for modular and readable query organization, triggers for automated datahandling, and subqueries for complex query requirements. These methods facilitated the identification of keytrends and provided actionable insights, enhancing business strategies and boosting operational efficiency.2. Employed Power Query to clean and transform datasets of over 500,000 records. Utilized functions such aspivot/unpivot columns to restructure data, split columns for better granularity, append queries to combinemultiple datasets, and aggregate functions to summarize information. These enhancements improved dataaccuracy and facilitated the creation of comprehensive visualizations, accelerating decision-making speed by30%.3. Designed and implemented custom, interactive, and user-friendly Power BI dashboards to track over 10 keymetrics. Integrated features such as filters, parameters, slicers, and bookmarks to enhance dashboardinteractivity and user experience. These dynamic elements boosted project performance visibility, ensuredalignment with organizational goals among stakeholders, and fostered enhanced collaboration.4. Developed and maintained detailed reports using Excel and Power BI, designing and implementing complexspreadsheets and interactive dashboards to summarize key findings.5. Integrated multiple data sources, applied analytical techniques, and used visualizations to effectivelycommunicate insights, trends, and performance metrics. These reports were crucial in supporting data-drivendecision-making processes by providing stakeholders with clear, actionable information and facilitating strategicplanning.