Ramayanapu Durga Prasad
Hyderabad
Summary
Diligent BI Developer with 4 years of experience performing detailed compilation and maintenance of extensive database systems to track complete BI information. Integral leader when overseeing analytics to generate critical custom business intelligence reports. Applies detail-oriented process for overseeing analytics application availability and performance, from planning through end-of-lifecycle. Crucial contributions to BI database backup, recovery, and maintenance.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Senior data analyst
Nextech Solutions
11.2023 - 2 2024
- Nextech solutions is one of the largest chains of retail and motor industry in the United Kingdom, having throughout the UK and Ireland
- The products are sent to different locations, where each location is divided into different zones
- It has a database that maintains information like sales, profits, margins, and contacts of customers
- Using this existing database, we analyze their business moment like different product sales trends, sales profits, regional sales, and top N products sales
- The resulting model gives us an idea about profit growth and prediction about increase in sales which helps the management in decision making.
Senior Data Analyst
Ernst and Young LLP
06.2022 - 09.2023
- Ernst & Young is a leading global professional services firm that offers a variety of services to its clients in the premium and luxury service lines through four integrated service lines — Assurance, Consulting, Strategy and Transactions, and Tax — and deep sector knowledge, it helps to clients to capitalize on new opportunities and assess and manage risk to deliver responsible growth
- Operating from different geographic locations and headquarters in London
- Besides its business units, it has a strong and enriched employee management system
- The strategic, tactic and predictive analytical system expects appropriate and dynamic dashboards and scorecards
- The project aims to analyze all the details for better employee management and control of resource separations in order to compete and grow in the market leadership.
Senior Data Analyst -BI Developer
R1 Rcm Global Private Limited
2 2020 - 6 2022
- Insurance is a transaction whereby a client pays a premium or contribution to an insurer to ensure coverage in the event of an insured loss (fire, accident, theft, etc.)
- All of the premiums collected by the insurer are used to settle the claims filed by its policyholders, as well as its own operating costs
- The key performance indicator in property-casualty insurance is the combined ratio, which is defined as the ratio between the amount of claims paid out and the insurer's operating costs on the one hand, and the premiums collected on the other
- The main objective of this project is to collect the data from different sources and dump into data warehouse once reach the requirements then build the dashboards as per client business logics.
Data Analyst BI Developer
Sutherland Global solutions PVT LTD
05.2017 - 01.2020
- GMAC is the largest general insurance group (based on the amount of personal and commercial insurance premiums) and one of the largest banks (Ally GMAC Bank)
- GMAC Insurance specializes in RV insurance, VEHICLE insurance, and HOME insurance and also has a leading superannuation, investment, and asset management business
- Participated in the development of a system with decision-making support solutions, giving mainstream users the ability to access, analyze, and share information in the company database
- The system generated reports to analyze referral trends, Pending activities, payroll, gross profit analysis, headcount, and financial reports on personal.
Education
B.SC Computer science -
Osmania university
Skills
Power BI Desktop & Services
Data flows
DAX
SSRS / SSIS
SQL Server
Power Query
Data Warehousing
Operations Analysis
Financial Planning
Microsoft Azure
Microsoft Fabric
ETL processes
Advanced Excel
Certification
Udemy - Microsoft Power BI
Languages
English
Hindi
Software
DAX Studio
Timeline
Senior data analyst
Nextech Solutions
11.2023 - 2 2024
Senior Data Analyst
Ernst and Young LLP
06.2022 - 09.2023
Data Analyst BI Developer
Sutherland Global solutions PVT LTD
05.2017 - 01.2020
Senior Data Analyst -BI Developer
R1 Rcm Global Private Limited
2 2020 - 6 2022
B.SC Computer science -
Osmania university