Aditya Devanpalli
Senior Data Analyst
About
Senior Data Analyst with 4+ years of experience in SQL, Python, Databricks, PySpark, and Power BI. Expertise in data analysis, data modeling, dashboard development, and translating complex datasets into actionable business insights to support data-driven decision-making.
Skills & Expertise (15)
Work Experience
Senior Data Analyst
Segula Technologies
Jul 2024 - Present
Senior Data Analyst with 4+ years of experience in SQL, Python, Databricks, PySpark, and Power BI. Expertise in data analysis, data modeling, dashboard development, and translating complex datasets into actionable business insights to support data-driven decision-making.
Data Analyst
Indian Based Finance Company
Present - Present
Extracted and integrated data from Oracle into Azure SQL Managed Instance (MI) and Azure Delta Lake, utilizing MS SQL Server, CSV, and Excel. Developed complex data models in SQL Server, creating and managing views, tables, and stored procedures to meet BI requirements. Leveraged Azure Data Factory (ADF) to orchestrate and automate ETL processes, ensuring efficient and timely data integration. Utilized Azure Data Lake Storage (ADLS) for scalable and secure data storage, enabling efficient data retrieval and processing. Imported SQL Server data models into Power BI, designing interactive visual reports and dashboards to provide actionable business insights. Implemented dynamic Row-Level Security (RLS) in Power BI to ensure data privacy and security. Conducted root cause analysis to resolve bugs, optimized report performance, and provided detailed progress updates to management and clients.
SQL Developer
Indian Based Bank
Present - Present
As a SQL Developer, I significantly improved data management and accessibility by creating stored procedures and views, which encapsulated intricate business logic and upheld data integrity standards. Through crafting SQL queries tailored with diverse filtering conditions, I streamlined data retrieval to meet precise requirements. Employing advanced SQL features like window functions, common table expressions, and recursive queries, I facilitated efficient data manipulation and analysis. Furthermore, I implemented normalization techniques to eliminate data redundancy and deployed denormalization strategies to boost query performance, thus enhancing the overall effectiveness of the database system.
Power BI Developer
Food and Beverage Company
Present - Present
Imported data from SQL server to Power BI for generating reports. Developed several Power BI reports with multiple tabs. Reports were designed for Sales and Retail revenue Insight, having stores health tools. Created Dax Queries to generate computed columns and measures in Power BI. Created dynamic measures for automating reports based on client's requirements. Actively involved in Client discussions to fulfill every requirement of business. Created various Power BI Reports involving a variety of features like Bar Charts, Line Charts, Filters, Custom Visuals, Drill Down etc. Applied Dynamic RLS for various levels of Data security.
Associate Data Analyst
Celebal Technologies
Jun 2022 - Jul 2024
Data Analyst with experience in data analytics, business intelligence, and data transformation using SQL, Python, PySpark, Power BI, Databricks, Azure Synapse, and Azure Data Factory. Proficient in ETL processes, data modeling, dashboard development, and reporting solutions. Experienced in converting complex datasets into actionable insights to support business decision-making and operational improvements.
Education
Bachelor of Engineering (Mech) - Walchand Institute of Technology
- 2021 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Need Sponsorship
Relocation
Open to Relocation
Skills (15)
Click a skill to find developers with the same skill
