Mohan Kumar Gorripotu

About Mohan Kumar Gorripotu

Experienced Team Lead with a demonstrated history of working in the computer software industry.Skilled in Advance Excel, My SQL, Power BI, Power BI Services, Power Automate, Congos, Python, Numpy, Pandas, and Matplotlib.• Extensive experience using Data cleansing and Data Mining techniques, Excel pivot, formulas, and charts.• Develop and automate repeated tasks in Excel using VBA programming.• Solid working experience with MySQL and Snowflake. Strongly skilled in writing stored procedures, triggers, and complex queries containing multiple joins, subqueries, and window functions to create reports and perform analysis.• Develop and design interactive dashboards and reports using Power BI, catering to diverse business needs and stakeholders.• Collaborate closely with business analysts, data engineers, and end-users to gather requirements, ensuring effective BI solution delivery.• Utilize advanced techniques and DAX in Power BI to create complex calculations and KPIs, enabling in-depth data analysis.• Implement data modeling best practices in Power BI, optimizing data models for improved performance and efficiency.• Conduct data cleaning and transformation using Power Query Prep to maintain data accuracy and consistency.• Design and implement role-based security in both Power BI, ensuring data privacy and secure access to reports.• Provide comprehensive training sessions to end-users, empowering them to leverage the full potential of Power BI for data analysis and decision-making.• Good knowledge of Python libraries like Numpy, Pandas, and Matplotlib.

Experience

1. Operations Manager

   Stepout

   Sep 2024 — Present · Bengaluru, IN

Education

• Sir C R Reddy College of Engineering

  Bachelor of Technology - BTech, Electronics and Communications Engineering

• NxtWave

  Fellow at NxtWave's CCBP 4.0 Intensive

• Narayana Junior College

  Intermediate, Mathematics, Physics and Chemistry