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.
Data Integration and Transformation:
Adept in crafting and executing ETL workflows using SSIS, facilitating smooth data flow between various sources. Notable for enhancing process efficiencies through refined data transformation methods.
Advanced SQL Capabilities:
Experienced in developing intricate SQL queries and stored procedures for robust data handling, reporting, and analysis. Specialized in query optimization for improved performance.
Business Intelligence and Data Reporting:
Capable of constructing detailed and actionable reports using SSRS, equipping decision-makers with critical data insights.
Engaging Data Visualizations:
Skilled in designing compelling, interactive dashboards with Tableau, aiding in the interpretation of trends and informing strategic decisions.
DAX Mastery:
Proficient in utilizing DAX for crafting calculated columns, measures, and complex calculations in Power BI, enabling comprehensive data examination.
Data Accuracy and Evaluation:
Meticulous in data inspection, cleaning, and verification processes, ensuring the precision and trustworthiness of analytical results.
Team Collaboration and Communication:
Effective in liaising between technical and non-technical stakeholders, aligning data projects with overarching business goals through clear communication and collaboration.
Agile Framework Experience:
Well-versed in Agile practices, contributing to agile teams and ensuring prompt delivery of client-centric projects.
Analytical Problem Solving:
Proven ability in dissecting and resolving intricate business issues through data-centric solutions, offering practical insights for business expansion.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data Analyst/Power BI Developer
HSBC Bank
01.2023 - 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.
- Increased productivity by 10%
- 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.2020 - 12.2022
- 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.
- Increased productivity by 10%
Data Analytics/SQL/Power BI Developer
Home Depot
01.2017 - 12.2019
- 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.
- Report Creation: 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.
- Increased productivity by 10%
- 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
Certification
- Certified Power BI Developer
Timeline
Data Analyst/Power BI Developer
HSBC Bank
01.2023 - Current
Data Analytics/SQL/Power BI Developer
Citizens Bank
01.2020 - 12.2022
Data Analytics/SQL/Power BI Developer
Home Depot
01.2017 - 12.2019