Abel Reddi
Denver,CO
Summary
Committed and effective Data Analyst/SQL/Power BI Developer with a six-year upward trajectory in the field, specializing in the creation, refinement, and enhancement of data systems. Demonstrates proficiency in using SQL, SSIS, SSRS, DAX, and Tableau to manage, process, interpret, and present complex data sets. Successfully converts complex business needs into tangible insights, aiding in smarter business choices. Known for working synergistically with diverse teams to develop impactful data solutions that bolster data-centric strategies.
Overview
7
7
years of professional experience
Work History
Data Analyst/Power BI Developer
HSBC Bank
01.2024 - Current
- Crafted and refined essential database components (such as views and indexes) aligning with logical design models, specific user needs, and physical limitations
- Engaged in creation, upkeep, and management of sophisticated reporting systems, data cleansing activities, report structuring, analytics, and additional BI tools including Tableau
- Authored and executed T-SQL (DDL and DML) scripts, procedures, and packages, managing slowly changing dimensions to preserve historical data integrity
- Constructed comprehensive GSHS Reports in Power BI from ground up
- Executed tasks involving dimensions, measures, and MDX query formulation
- Created a variety of visual representations including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, and Scatter Plots in Power BI for diverse view-driven dashboards
- Employed Power BI and Pivot/View for designing multiple dashboards and scorecards, catering to various departmental and executive management needs
- Developed data marts and designed multi-dimensional structures like Star and Snowflake schemas
- Applied various DAX functions to perform complex fact calculations, enhancing Power BI data visualizations
- Engineered intricate Power BI reports incorporating advanced graphical elements like gauges and funnels for in-depth business analysis
- Focused on converting data into accessible visualizations in Power BI to provide business users with comprehensive insights
- Integrated data into Power BI from various sources, including SQL Server and Oracle
- Participated in setup of the Power BI Report Server
- Produced Power BI reports by merging data from multiple tables and databases through complex SQL queries
- Formulated a Power BI data model incorporating several fact tables and dimensions to meet specific business needs
Data Analytics/SQL/Power BI Developer
Citizens Bank
01.2021 - 12.2023
- Worked in tandem with the data engineering team to conceptualize and refine data models for analytics, utilizing SQL Server Analysis Services (SSAS)
- Crafted complex DAX (Data Analysis Expressions) measures within Power BI for precise computation of business metrics and Key Performance Indicators (KPIs)
- Designed interactive Power BI dashboards with detailed drill-down capabilities, facilitating in-depth data analysis for business users
- Set up automated, data-driven report distribution in SQL Server Reporting Services (SSRS), streamlining report sharing with relevant stakeholders
- Performed thorough data profiling and quality checks, detecting and addressing data discrepancies and irregularities
- Played a key role in shaping and building the data warehouse architecture, focusing on aspects of scalability and maintaining data integrity
- Engaged actively with users to understand and fulfill their specific reporting needs, ensuring the delivery of custom-tailored solutions
- Advanced reporting efficiency and visualization by transitioning existing SSRS reports to dynamic, interactive Power BI dashboards
- Developed tailored SSRS reports featuring sophisticated formatting and visual components to enhance data presentation
- Analyzed and optimized SQL query performance, providing recommendations for database performance enhancements
Data Analytics/SQL/Power BI Developer
Home Depot
01.2018 - 12.2020
- Engineered, refined, and upheld SSIS packages for effective ETL (Extract, Transform, Load) processes, achieving smooth data consolidation from varied sources into data warehouses and marts
- Undertook data cleaning tasks to pinpoint and amend data discrepancies, maintaining data integrity and precision throughout the ETL operations
- Developed engaging and visually appealing reports and dashboards utilizing SSRS and Power BI, aiding stakeholders in understanding key metrics and facilitating informed decision-making
- Performed comprehensive data analysis to uncover trends, patterns, and outliers, offering critical insights for business strategy enhancement and procedural optimization
- Aided in the design and execution of data models to streamline data analysis and reporting, aligning data structure with specific business needs
- Enhanced the efficiency of SQL queries, SSIS packages, and reporting queries, reducing data processing time and improving overall performance
- Worked in collaboration with various teams to define data requirements and establish effective data integration strategies, ensuring consistent data exchange across systems
- Converted intricate data sets into clear visual representations and practical reports, making it easier for stakeholders to comprehend complex information
- Kept detailed records of ETL methodologies, data models, and reporting guidelines, providing a foundation for knowledge sharing and effective team transitions
Education
Bachelor of Science - Computer Science
.
Skills
Database Technologies:
SQL Server Management Studio
2017, T-SQL, SQL Server, SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services), SSIS (SQL Server Integration Services), Transact-SQL, Azure SQL DB, Cosmos DB
Data Analysis and Visualization: Power BI, Tableau, Data Extraction, Data Analytics, Data Visualization, Data Modeling, Business Intelligence
Programming and Scripting: PowerShell, M Language for Power Query, DAX
Microsoft Office Suite: MS Office 365, MS Excel, MS Access, MS Office Suite, SharePoint
Other Tools and Technologies: Jira, Azure
Timeline
Data Analyst/Power BI Developer
HSBC Bank
01.2024 - Current
Data Analytics/SQL/Power BI Developer
Citizens Bank
01.2021 - 12.2023
Data Analytics/SQL/Power BI Developer
Home Depot
01.2018 - 12.2020
Bachelor of Science - Computer Science
.
Similar Profiles
MURALI KRISHNAN T.R.MURALI KRISHNAN T.R.
Assistant Manager at HSBC BANKAssistant Manager at HSBC BANK
Shikha VyasShikha Vyas
Universal Banker at HSBC BankUniversal Banker at HSBC Bank
SANAL VPSANAL VP
Assistant Operations Manager at HSBC BankAssistant Operations Manager at HSBC Bank