Subhalakshmi Ramesh

Background

About Subhalakshmi Ramesh

Hi, I am Subha Ramesh, a proactive and results-oriented Data Analyst specializing in the complete Microsoft BI lifecycle. Keen observer with excellent analytical and visualization skills. Hands-on experience in SQL, ETL, Power BI, and Dashboard creation. SQL- Extensive experience in database development for OLTP and OLAP systems using MS SQL Server 2019- Proficient in creating and maintaining SQL objects like tables, stored procedures, functions, and temp tables- Strong background in client interaction, understanding business applications, data modeling, data mining, and profiling- Skilled in implementing Star and Snowflake schemas for relational databases and data warehouses- Expertise in ETL processes using SQL Server Integration Services (SSIS)- Experienced in creating SSIS packages for integrating data from various sources (Excel, CSV, flat files, XML, etc.) and transforming the data according to requirement- Use of SQL Server Reporting Services (SSRS) for report generation. Power BI and Data Visualization- Designed and implemented data models in Power BI- Created calculated columns and measures using DAX for advanced calculations- Created diverse visualizations such as tables, charts, maps, slicers and custom visuals, incorporating tooltips to provide additional context and insights when users hover over data points- Implemented drill-down and drill-up functionalities, enabling users to explore data at different levels of detail, and applied various report filters to allow for dynamic and interactive data analysis. Presentation Skills- Provide insights to stakeholders and top-level management by understanding business requirements and compiling analysis into PowerPoint presentations. Soft Skills- Well-organized, goal-oriented, and highly motivated team member.