Data Analyst,SQL, Python, Power Bi, Tableau

Gayathri Dendi

Data Analyst

469-***-**** ***************@*****.*** Arlington, TX

Professional Summary

Experienced and detail-oriented Data Analyst with over 4 years and 6 months of experience in deriving actionable insights from large and complex data sets across banking, healthcare and SaaS industries. Adept at end-to-end data lifecycle management from extraction and transformation to visualization and strategic reporting by leveraging a comprehensive toolset including SQL, Python (Pandas, NumPy), Excel, Power BI, Tableau and Shell Scripting. Proficient in designing, automating and managing robust ETL pipelines using modern data platforms such as AWS Glue, Redshift, Athena and Azure Data Factory, Azure SQL, Synapse Analytics. Experienced in orchestrating workflows with Apache Airflow, building and deploying integrations with Talend, Informatica and SSIS, while ensuring data accuracy, integrity and compliance through rigorous QA testing and data validation practices. Hands-on experience in cloud-native data architecture with both AWS and Azure environments, supporting scalable analytics for enterprise-scale reporting. Technical Skills

- Programming & Scripting:

Python (Pandas, NumPy, Matplotlib, Seaborn), Shell Scripting, SQL (MySQL, SQL Server, PostgreSQL, Hive, Spark SQL), PL/SQL, R (Basics)

- Data Processing & ETL Pipelines:

Apache Airflow, Talend, Informatica, SSIS, AWS Glue, Azure Data Factory, Apache Spark (Basics), Flink (Basics), Data Modeling, Data Warehousing (Star/Snowflake Schema)

- Data Analysis & Visualization:

Excel (Advanced formulas, Pivot Tables, VBA optional), Tableau, Power BI, Looker, Google Data Studio

- Cloud Platforms:

AWS (S3, Glue, Redshift, Athena, Lambda), Azure (Data Factory, Synapse Analytics, SQL Database), Aliyun

(Basic familiarity), Tencent Cloud (Basic familiarity)

- Database Systems:

MySQL, MS SQL Server, PostgreSQL, Oracle, MongoDB, Snowflake, Azure SQL

- Big Data & Tools:

PySpark (Basics), Hadoop (Basics), Spark SQL, Athena

- DevOps & Version Control:

Git, GitHub, GitLab, Docker, CI/CD (Basics)

- Project Management & Communication:

JIRA, Confluence, Agile/Scrum, Microsoft Teams, Slack, ServiceNow

- Other Tools & Utilities:

SSRS, Alteryx, REST APIs, JSON, XML, Google Sheets (Functions, Scripts) Work Experience

Data Analyst Mar 2024 – Present

M&T Bank Buffalo, NY

• Conducting detailed analysis on transactional and customer data to ensure accuracy, integrity and consistency. Generated weekly/monthly reports using SQL and Excel, empowering stakeholders with data-driven insights.

• Developing Power BI dashboards to visualize customer behavior, operational performance and KPIs for senior leadership. Collaborated with business units to generate actionable insights using Tableau and Excel.

• Integrating data sources and applied ETL processes using AWS Glue, Talend and Apache Airflow to clean, transform, and load data into reporting systems for easy access.

• Working closely with business and technical teams to define report requirements and tested new tools for decision- making using JIRA and Confluence.

• Applying statistical methods and machine learning models using Python and Pandas for predictive analytics on financial and customer data, improving customer experience and operational efficiency.

• Optimizing SQL queries for extracting and analyzing large datasets from AWS Redshift and AWS Athena, ensuring efficiency in data retrieval and storage.

• Designing and managing data warehousing solutions with AWS Redshift, AWS Glue and Informatica, enabling faster data retrieval and reporting.

• Conducting data quality assessments and implemented validation procedures, ensuring accurate, consistent and error- free analytics for reliable decision-making.

• Leveraging Docker for containerization and Git for version control, automating data processes and reporting with Python, Shell Scripting and SSIS to reduce manual effort.

• Automating ETL pipelines using AWS Glue, Apache Airflow and Talend, ensuring real-time data synchronization between systems and reporting databases, improving data delivery efficiency. Data Analyst Jul 2021 – Nov 2022

Fresh Works India

• Analyzed customer behavior and product usage data to provide actionable insights that helped improve customer retention strategies, leveraging SQL and Power BI for reporting.

• Developed and maintained Power BI dashboards and reports for the product management team, visualizing key metrics like user engagement, feature adoption and churn rates, improving decision-making.

• Conducted data validation and quality checks using SQL to ensure the accuracy and reliability of data, identifying discrepancies in user data across platforms and working with engineering to resolve them.

• Collaborated with cross-functional teams including product, sales and customer success, to gather requirements and deliver customized reports and analytical insights to enhance business performance.

• Led the integration of multiple data sources, including user interaction data and CRM systems, into a unified data warehouse, using Talend and AWS Redshift to ensure efficient data storage and retrieval.

• Utilized Python, Pandas and NumPy to conduct exploratory data analysis (EDA) and statistical analysis, identifying key trends and correlations to provide insights for product enhancements and customer experience improvements.

• Created and optimized complex SQL queries for extracting and transforming data from relational databases, ensuring data accuracy and efficiency in reporting processes.

• Worked with AWS Redshift and AWS Athena for data warehousing and ad-hoc querying, enabling scalable data storage and faster data retrieval for reporting and analysis.

• Automated data extraction, transformation, and loading (ETL) processes using Apache Airflow and Talend, reducing manual effort and improving the speed of data pipelines.

• Employed Git for version control, JIRA for project management and Confluence for documentation, ensuring smooth collaboration within the team and on-time delivery of insights. Data Analyst Jun 2019 – Jun 2021

Healthians India

• Assisted in the collection, cleaning, and analysis of health-related data from patient interactions and service reports, ensuring data accuracy and consistency for effective reporting.

• Created basic Excel reports and dashboards to track key health service metrics, such as patient satisfaction, service delivery times and operational efficiency, supporting operational decision-making.

• Worked with the data team to maintain and update the internal data repository, performing data entry and cleaning tasks to ensure data was accurate and up-to-date for analysis.

• Supported senior analysts in generating ad-hoc reports for the management team, assisting with data visualization in Excel, Power BI and Azure for easy consumption by non-technical stakeholders.

• Collaborated with the quality assurance team to conduct basic data quality checks, identifying and reporting discrepancies in health service data to maintain integrity and consistency.

• Leveraged SQL on Azure SQL Database for data extraction, performing basic queries to retrieve and analyze data from relational databases, ensuring accuracy and efficiency in reporting processes.

• Utilized Python and Pandas on Azure Databricks for basic data analysis tasks, including cleaning and transforming raw data into structured formats for further analysis and automating simple tasks for reporting.

• Assisted in the creation and optimization of ETL workflows on Azure Data Factory, ensuring smooth data extraction, transformation and loading processes to provide clean data for analysis and reporting.

• Collaborated with business teams to understand data requirements and deliver reports, ensuring all reports met organizational standards for consistency & accuracy, leveraging Power BI & Azure for easy sharing and collaboration.

• Gained experience with data visualization tools such as Tableau, Power BI and Azure Synapse Analytics to create simple dashboards and reports that presented actionable insights for business stakeholders. Education:

Master of Science in Computer Science from University of Texas at Arlington, TX, USA. Bachelor of Engineering in Computer Science from Dayananda Sagar College of Engineering, India.

Contact this candidate