Data Analyst Power Bi
Resume:
Satish Reddy
************@*****.***
www.linkedin.com/in/s-reddy-32a537305
Professional Summary:
Data Analyst with over 5 years of experience in analyzing and optimizing data-driven processes for diverse industries. Expertise in designing and implementing ELT/ETL pipelines, data modeling, and advanced analytics, with a strong focus on cloud technologies and automation frameworks. Proven track record in using tools such as SQL, Snowflake, Kafka, Apache Airflow, and Tableau to transform complex data into actionable insights. Adept at working with cross-functional teams to identify business needs and drive data-driven decision-making. Known for creating efficient data architectures, automating processes, and building monitoring frameworks to improve operational efficiency and reduce costs. A proactive problem-solver with exceptional communication skills and the ability to mentor teams while delivering high-quality results.
Technical Skills:
Data Analysis & Management: SQL, R, Python, Tableau, Google Analytics
Cloud Technologies: Azure, Snowflake, Kubernetes, Apache Kafka, Flyway
ETL/ELT Tools: Apache Airflow, DBT, Kafka Streams
Data Integration & Orchestration: Snowflake, Azure Data Factory, Flyway Migration, Kafka, Apache Airflow, DBT
Data Modeling & Architecture: ERWIN, Dimensional Modeling, Data Warehousing, Logical/Physical Data Models, Snowflake Architecture
Programming & Scripting: Python, SQL, Java
Database Management & Optimization: Snowflake, Oracle, SQL Server, Data Migration, Data Profiling, Data Validation
CI/CD & Automation: Azure DevOps, Git, Jenkins, Kubernetes, Flyway, Python Automation Scripts
Data Visualization: Tableau, Power BI, Google Analytics, SQL-based Dashboards
Version Control: Git, SVN
Big Data Technologies: Hadoop, Kafka Streams
Testing & Quality Assurance: Regression Testing, DBT, Python-based Testing Frameworks
Work Experience:
Client: Elevance Health - Atlanta, GA Sep 2023 - Present
Role: Senior Data Analyst
Responsibilities:
Engaged in ELT oriented Use-Cases by using Kafka streams, Java-based consumer and producer applications to ingest data into Snowflake, created and reviewed functional specification document with technical team.
Designed and implemented streaming ingestion patterns, including moving data from on-premises to the cloud in Azure, using incremental loads, full loads, and batch design patterns and pipelines.
Integrated Tableau with Azure data pipelines to automate reporting on real-time ingestion and transformation processes.
Designed custom Tableau reports for business stakeholders, allowing self-service data exploration.
Utilized SQL to perform data aggregations, joins, subqueries, and create views for efficient data retrieval.
Managed end-to-end data flow journey and architecture design, as well as the CI/CD process on Azure cloud platforms.
Developed and deployed container-based applications using Kubernetes pods, effectively running multiple images in the production environment.
Developed Power BI dashboards for tracking data flow and CI/CD deployments, enabling real-time insights.
Connected Power BI to Snowflake, leveraging direct queries and scheduled refreshes for dynamic reporting.
Created and managed streaming pipelines with robust monitoring and data reconciliation mechanisms in place to ensure the accuracy of the source-to-target data journey.
Constructed a framework to monitor Snowflake tasks, counts, pipes, and send email alerts, significantly reducing manual monitoring efforts.
Implemented a Python-based framework for automating database regression testing and alerting.
Built a Snowflake Metadata driven Framework to enhance efficiency and consistency in data processing.
Designed a low code - no code orchestration framework specifically tailored for Snowflake jobs.
Used Flyway Migration in CI/CD processes to automate SQL scripts and facilitate seamless deployment.
Utilized Apache Airflow pipelines to address various business use cases and employ DBT for modularized business logic transformations, testing, and documentation.
Environment: Kafka, Java, Snowflake, Azure, Tableau, Power BI, Kubernetes, Python, Flyway, Apache Airflow, DBT, SQL, CI/CD, Cloud Data Pipelines, Snowflake Metadata Framework, Git, Jenkins
Client: Adisa Farms - India Aug 2020 - Aug 2022
Role: Data Analyst
Responsibilities:
Designed and assigned delivery routes for delivery which led to an increase in efficiency by 25% for timely delivery of milk to consumers and 10% decrease in operational costs.
Created a detailed financial analysis and refined budget forecasts increasing company profits by 5%.
Performed daily inspection and quality of the products and packaging.
Established friendly relationships with regular customers leading to 100% customer satisfaction.
Performed descriptive analytics to analyse the product’s assembly time and collaborated with the production team to maximize the output.
Implemented Tableau forecasting techniques to predict milk demand, reducing surplus by 20%.
Built Tableau dashboards for product quality assessment, visualizing real-time inspection data.
Summarize the bi-monthly findings from data analysis to help the executive management team to make business decisions.
Created inventory model using extrapolation methods and predictive analysis techniques using R to forecast the demand and reduce the dead inventory by 20%.
Automated Power BI reports using scheduled data refresh to track daily milk sales.
Integrated Google Analytics with Power BI for customer behavior insights on the e-commerce platform.
Formulated digital marketing strategies using SEO and SEM tools for the promotion of the organization which improved the online visibility of the organization.
Implemented funnel analysis on the E-commerce platform using Google Analytics, lowering the cart-abandonment rate, and increasing the conversion rate by 8%.
Increased the sales of milk from 10 liters to 80 liters in 3 months by adopting new marketing strategies.
Queried and processed relevant data from SQL, and sale patterns using Tableau to strategize the marketing campaigns.
Environment: R, SQL, Tableau, Google Analytics, Excel, Tableau, Power BI, Predictive Analysis, Digital Marketing Tools (SEO, SEM), Inventory Forecasting Models
Client: Pennant Technologies - India Jan 2019 - July 2020
Role: Data Analyst
Responsibilities:
Worked with end users to gain an understanding of information and core data concepts behind their business.
Worked with Data Warehouse team in developing Dimensional Model and analyzing the ER-Diagrams
Identified and analyzed stakeholders and subject areas.
Developed Tableau reports on data profiling results, enabling decision-makers to assess data health.
Participated in Business Analysis, talking to business Users and determining the entities and attributes for Data Model.
Identified and determined physical attributes and their relationships through cross-analysis of functional areas.
Identified and analyzed source data coming from Oracle, SQL server and flat files.
Created Power BI models for Dimensional Data Analysis, enabling ad-hoc reporting.
Used Power BI’s row-level security (RLS) to control data access for different user groups.
Extensively used ERWIN to design and restructure Logical and Physical Data Models.
Evaluated and enhanced current data model as per the requirements
Performed forward and reverse engineering, applying DDLs to database in restructuring the existing data Model using ERWIN
Designed ETL specification documents to load the data in target using various transformations according to the business requirements.
Performed Data profiling, Validation and Integration.
Created materialized views to improve performance and tuned the database design.
Involved in Data migration and Data distribution testing.
Performed testing, knowledge transfer and mentored other team members.
Environment: ERWIN, SQL Server, Tableau, Power BI, Oracle, DB2, ER-Diagrams, Data Warehouse, Dimensional Modeling, Data Profiling, Data Migration, ETL, DDL, Data Validation, Data Integration, Materialized Views
Education:
Bachelor of Science in Food Technology and Management from Osmania University, Hyderabad, India
Master of Science in Business Analytics from University of New Haven, West Haven, CT
Contact this candidate