Gopal Reddy Email & Phone Number

I am Gopal Reddy aspiring Data Analyst. Passionate about uncovering insights and driving data-informed decision-making.My technical skills include the following:•Excel •Power BI •SQL •Python What can I do :- Data Cleaning and Preprocessing- Data Visualization and Dashboard Creation (Excel, Power BI)- Data modeling- Power Query for Data Transformation- SQL for Database Management and Querying- Python for Data Analysis- Strong Problem-Solving and Analytical Thinking- Excellent Communication and Collaboration AbilitiesKey Projects :P & L REPORT - AtliQ Hardware [EXCEL|DAX FUNCTION|DATA MODELING|POWER PIVOT]● Developed a customer performance report and conducted market performance comparisons (FY 21 vs 20), for strategic decisionmaking● Applied ETL methodology, Power Query, and Power Pivot to establish robust data models with DAX for analysis and ensure dataquality● Created Profit and Loss reports by (FY 19 – 21)& Months and Markets, aligning financial planning with strategic goals.● Implemented Sales and Finance Analytics Report, revealing key insights like India's highest gross margin of 51.6 million,supportinginformed decisions and strategic business growth June – Aug 2024SALES AND FINANCE REPORT - [SQL|JOINS|STORED PROCEDURES|USER DEFINED FUNCTIONS]● Queried complex Joinsto generate the reportsforsales and finance of AtliQ Hardware for(FY 17 – 22)● Designed custom SQL functions to enhance and accelerate database operations and enhancing query efficiency by 15% formoreefficient data processing and analysis● Simplified database operations by designing and implementing optimized SQL procedures, enhancing data retrieval timefrom 15 seconds to 7 seconds through strategic programming solutionsProjects Aug - Sep 2024Business 360 - Brick & mortar and e-commerce• Designed a multi-view dashboard in Power BI for 6 departments (sales, finance, supply chain, executive, marketing, and products)of AtliQ hardware to understand sales trends, facilitate data-driven decisions that scaled the business processes by 10%.• Imported 2 different data sources (MySQL, and Excel) with more than 1 million records and performed data modeling.• Optimized the report using DAX studio, which saved 30% of storage and improved performance by 10%.I am actively seeking new opportunities and am excited to contribute my skills as a data analyst to drive actionable insights and help organizations make data-driven decisions. Let's collaborate and unlock the power of data together!