Surya Somisetty
Nellore
Summary
Data Analyst with 4+ years of experience in designing and developing analytical reports and dashboards that transform complex data into actionable insights using SQL, Power BI, Report Builder, and Power Automate. A collaborative team player, and a highly motivated professional, eager to learn and apply new technologies and techniques in data analysis.
Overview
5
5
years of professional experience
Work History
Senior Analyst- Power BI Developer
Deloitte
Hyderabad
03.2024 - 06.2025
Project Title: AXAXL Insurance & Re-insurance
Role: Application developer
Description:
AXAXL is the P&C and specialty risk division of AXA, known for solving even the most complex risks. For mid-sized companies to the world's largest multinationals, we offer traditional and innovative insurance solutions and services in over 200 countries and territories.
Power BI Roles:
we are creating reports and providing RLS in Desktop and publishing to Power BI Service, and providing the link to end users
Programmer Analyst - Power BI Developer
Cognizant
Chennai
09.2020 - 06.2023
Project Title: Deutsche Bank Financial Reporting.
Role: Application developer
Description:
Deutsche Bank is a leading global investment bank with a strong and profitable private client's franchise. This project deals with the Report development for the four countries i.e. Singapore, Hong Kong, Korea and Indonesia. The Reports are developed based on the data extracted in form of BEX queries from SAP database. Cell based Transactional and Adhoc reports are handled in this project.
Power BI Roles:
In Power BI service using dataflows extracting data from Azure SQL database and transforming data in the Power Query editor and storing data in data flow. In Power BI desktop creating dashboards and publishing in Power BI service Implementing row level security at the organization level.
Education
B tech - Computer Science
JNTU Anantapur
Anantapur03-2019
Skills
- SQL
- Power BI
- Power Query
- Report Builder
- Power Automate
- Microsoft Excel
- SSIS
- Power Apps
Roles & Responsibilities
- Imported and integrated data from multiple sources including SQL Server and Excel, creating relationships, calculated columns, and measures using DAX.
- Designed and developed interactive Power BI dashboards and reports based on business requirements for analytics and decision-making.
- Built optimized data models using Star Schema and Snowflake Schema with multiple fact and dimension tables.
- Extensively used Power Query (M) for data cleaning, transformation, merge, append, and column creation using examples.
- Implemented advanced DAX calculations including YTD, MTD, QTD, growth analysis, and complex business metrics.
- Created rich visualizations using charts, gauges, funnels, scorecards, hierarchies, drill-down, and drill-through features.
- Implemented Row-Level Security (RLS) and managed workspaces, publishing, data source settings, and report deployment in Power BI Service.
- Scheduled and managed dataset refreshes using On-Premises Data Gateway, including hourly and on-demand refreshes.
- Developed ad-hoc and periodic reports using Power BI and Excel Power Pivot, exporting reports to PDF and PowerPoint and embedding dashboards.
- Strong experience in SQL including joins, subqueries, CTEs, ranking functions, stored procedures, views, indexes, and performance optimization.
Core Compitency
- Data Modelling
- ETL Development
- Data Cleansing
- Process Monitoring
- Cloud Migration
- Data Visualization
- Troubleshooting and debugging
Databases: Microsoft SQL Server, Netezza, Oracle, DB2
Timeline
Senior Analyst- Power BI Developer
Deloitte
03.2024 - 06.2025
Programmer Analyst - Power BI Developer
Cognizant
09.2020 - 06.2023
B tech - Computer Science
JNTU Anantapur