Data Analyst

Rohith Kumar Reddy Kareddy

Email:- **********.**@*****.*** Ph: +1-203-***-****

Westport, CT

LinkedIn: www.linkedin.com/in/kareddy-rohith-dataanalyst Professional Summary:

• Over 2 years of experience in Database Design, Development, Integrations Implementation and maintenance of Business Intelligence and the related Database Platforms.

• As a Data Analyst responsible for Data Modeling, Enterprise Data Management, Data Presentation, Visualization, Optimization, Risk assessment, Predictive analysis, Advance Data Analysis, Business Research and Quantitative Analysis

• Experience in MySQL 8.0 with an emphasis on design, development, automation, tuning. optimization, Performance and Security.

• Experience in analyzing Business user requirements, analyzed data and designed software solutions in Power BI Desktop based on the requirements.

• Experience in converting Legacy Reports to Power BI dashboards connecting to MYSQL server.

• Built and published interactive reports and dashboards using Power BI Desktop and Power BI Server.

• Explore data in a variety of ways and across multiple visualizations using Power BI.

• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.

• Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps).

• Experience working on Power BI (Desktop, Server, Reader), creating various Reports and Dashboards using different functionalities.

• Experience in Power BI Desktop, Power BI for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.

• Proficient in Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, TextFormat Data).

• Handled various types of encryption and decryptions in MySQL as per client requirements to secure the data.

• Developed Python script for processing large data sets and also extract data from different files.

• Built Python Modules to deliver specific formats of data.

• A polished communicator, with good analytical and inter-personnel skills and versatile team player. Technical skills

Technical Proficiency: Excel, SQL, Python, Power BI, Tableau, MySQL, Snowflake Core Skills: Data Cleaning, Statistical Analysis, Data Visualization, Predictive Analytics, Ad Hoc Analysis Soft Skills: Problem Solving, Attention to Detail, Communication, Team Collaboration Education

• Master of Science (M.S.) – Computer and Information Sciences Sacred Heart University, Fairfield, CT Jan 2023 – Mar 2024

• Bachelor of Technology (B.Tech) – Electrical and Electronics Engineering Scient Institute of Technology, Hyderabad, India 2018 – 2021

• Diploma – Electrical and Electronics Engineering Teegala Krishna Reddy Engineering College, Hyderabad, India Jun 2015 – May 2018 Professional Experience

Client: Star Health Insurance, India

Role: Data Analyst September 2021 – October 2022

At Star Health Insurance Company, I’ve developed dynamic dashboards using the Customer Communication Management tool, implementing age and category filters, and applying display rules for individual paragraphs. Tools and Technologies used: MYSQL Server 2012, Office 365, Power BI Desktop, DAX, Jira, SharePoint, Excel, Word Responsibilities:

• Designed and implemented seamless data import/export between Excel, Flat files, and MYSQL Server, ensuring efficient data processing.

• Applied a robust understanding of data modeling in data warehouse environments, utilizing star schema.

• Proficiently conducted data analysis, querying databases, and utilizing MYSQL query tools to extract valuable insights.

• Created stored procedures, functions, indexes, and views for data processing and cleansing, ensuring data accuracy.

• Engaged in creating DAX and tabular models and incorporating diverse visualizations in Power BI based on project requirements.

• Leveraged Power BI for collaborative work with users and stakeholders on live data sources, enhancing real- time decision-making.

• Owned and supported operational and business performance dashboards, interpreting results, identifying improvement opportunities, and making recommendations.

• Generated reports in Power BI Desktop, published them to respective workspaces, apps, and automated the process for showcasing the latest data.

• Implemented various DAX functions for efficient data visualization in Power BI, optimizing fact calculations.

• Conducted training sessions with Business users on Power BI reports and dashboards, ensuring widespread understanding and usage.

• Performed user acceptance testing to ensure system integrity before the release to production.

• Leveraged SQL queries to extract and manipulate health insurance claims data from relational databases for analysis and reporting purposes.

• Applied Statistical Analysis in Python using libraries such as Pandas, Numpy and Matplotlib to identify trends, patterns and anomalies in health insurance data & eliminate duplicate entries from the database of businesses 90% accuracy.

• Fetch the data’s from Datawarehouse using Snowflake and connect into Power BI for generating reports.

• Used Power BI drill through and slicer features to enable stakeholders to analyze health insurance data at different levels of granularity.

• In DAX function, analyzed the last period of growth of the company using by Time Intelligence Function, Date Functions and Coming up with solutions to business problems using data-driven approaches.

• Implemented end-to-end data processing pipelines, reducing processing time by 30% and enhancing data accuracy.

• Published Power BI Desktop models to Power BI Service, creating informative dashboards and collaborating through workspaces and apps.

Client: Zomato, India

Role: Data Analyst November 2020- August 2021

At Zomato, I led Power BI initiatives, collaborating on project scope, implementing data processing enhancements, and designing advanced dashboards. Utilized DAX and Power Query for accurate insights, ensuring effective decision-making and streamlined reporting.

Tools and Technologies: Microsoft MYSQL Server, Jupyter Notebook, Excel, Jira, Power BI. Responsibilities:

• Collaborated with Stakeholders and Business Analysts to define project scope and discuss Power BI solutions for effective decision-making.

• Handled more than 1000 restaurants data across India.

• Analyzed this data using MySQL database and performed ETL to remove outliers, clean up bad records, normalize revenue numbers to standard format using Python (Pandas) in Jupyter notebook along with other statistical techniques.

• For more analyzing, used Excel, pivot tables, figured out best restaurants in India cuisine based on reviews.

• Used Power BI to build various BI dashboards and reports to show the growth in different restaurants based on the sales, profits and how customers preferences have changed over a period of 5 years.

• Gathered and imported daily and historical data related to sales files using MYSQL, ensuring accurate data processing.

• Communicated the migration plan, timelines, and expectations to stakeholders and users, keeping them informed throughout the process.

• Offered ongoing support and assistance to users as they adapt to the new BI platform and workflows.

• Developed paginated reports with Report Builder

• Analyzed claim requests, financial statements, and rate changes, generating summary reports, and creating financial models for forecasting.

• implemented complex DAX calculations to derive insightful metrics, enhancing the depth and accuracy of data analysis in Power BI.

• Designed and deployed advanced Power BI dashboards with interactive features, providing stakeholders with real-time access to critical business metrics.

• Optimized queries and data retrieval processes to improve report performance.

• Developed visually compelling reports using Power BI, incorporating diverse visualizations such as stacked bar charts, scatter plots, and trend lines.

• Applied DAX functions to create calculated measures, enabling dynamic and flexible data manipulation within Power BI reports.

• Designed Power BI dashboards and scoreboards for the claim processing department, providing visual insights into key performance indicators (KPIs).

Certifications

• Automation Developer Associate Training – UiPath

• Automation Developer Profesional Training – Uipath (Inprogress)

• Excel skills for Business Job Simulation – Goldman Sachs

• Data Analyst Simulation – Accenture North America

• Power BI Job Simulation – PwC Switzerland

• Data Visualisation: Empowering Business with Effective Insights Job Simulation -Tata Group

Contact this candidate