Summary

Analytical and detail-oriented data specialist with a strong background in analytics engineering and data visualization. Expert in applying SQL, Python, and advanced data analytics tools like Power BI to extract meaningful insights from intricate datasets. Aimed at utilizing my deep understanding of data modeling, integration, and business intelligence to solve complex issues and enhance decision-making processes in an innovative environment. Dedicated to continuous skill enhancement and contributing positively to the data analytics community.

Experience

Afford Motors

Analytics Engineer 06/2020 - 02/2022

Streamlined real-time data integration using Fivetran for automated ingestion into our centralized data warehouse. Structured and transformed collection data with dbt, ensuring reliable data models for BI reporting and analytics. Optimized data structure through dimensional data models for efficient querying and reporting. Managed large volumes of debt collection data in Snowflake's cloud data warehouse, supporting scalable analytics. Generated dynamic BI reports and dashboards in Power BI, enhancing strategic decision-making and operational efficiency. Afford Motors

Data Visualization Analyst 06/2019 - 06/2020

Crafted dynamic, user-friendly Power BI dashboards and reports that deliver actionable insights, enabling stakeholders to make informed decisions based on real-time data analytics. Constructed sophisticated data models to support complex data analysis, ensuring accurate and efficient data processing for enhanced reporting capabilities.

Worked closely with cross-functional teams to identify business needs and translate them into technical specifications, ensuring the developed Power BI solutions align with organizational objectives. Monitored and optimized existing Power BI reports and dashboards for performance and accuracy, while also implementing updates and enhancements to meet evolving business needs. Skills

SQL, Advanced Microsoft Excel, Agile Methodology, Fivetran, dbt, snowflake, dimensional data modeling, Python, Power BI, Azure Cloud, MySQL, PostgreSQL, Hive, SQL Server, Cloud Data Management, Business Intelligence Reporting, Data Visualization, Performance Optimization, Hive, SQL Server, Oracle 11g, Real-Time Data Integration, Data Modeling Education

RDVV University

Commerce, IT/Data Analytics 06/2014

Projects

Loan Default Risk Reports: Designed and executed a Power BI report for Loan Default Risk, focusing on data modeling that aggregates loan performance, demographic, and economic data, enhancing risk assessment and supporting strategic decision-making processes.

Loan Eligibility Assessment Dashboard with Power BI: Designed and executed a Power BI report for Loan Default Risk, focusing on data modeling that aggregates loan performance, demographic, and economic data, enhancing risk assessment and supporting strategic decision-making processes.

Data Pipeline Development: Expertly crafted efficient data integration and analysis pipelines using Azure Data Factory, optimizing the flow and accessibility of data for enhanced business intelligence. Shivika Arora

Saint Paul, MN +1-952-***-****

ad4ktx@r.postjobfree.com