Data Analyst Analytics

VIDYASAGAR GALI

Professional Summary

917-***-**** • **************@*****.***

Dynamic Data Analyst with 4 years of experience in leveraging SQL, Python, Tableau, and Power BI for comprehensive data analysis. Proficient in statistical methods, predictive modeling, and data visualization, adept at transforming complex datasets into strategic insights. Committed to continuous learning and enhancing data-driven decision-making. Skills

Programming Languages: SQL, No SQL, Python, R

Software Packages: Microsoft Excel, Tableau, Power BI, Power Apps, Hadoop, Spark, Hive, DriveWorks

Database Systems: MySQL, SQL Server, PostgreSQL, AWS Redshift, Athena, Mongo DB

Methodologies: Agile

ETL Tools: Pentaho, Alteryx, AWS Glue

Operating Systems: Microsoft Windows, Linux

Others: Executive Summary, Comprehensive Report, Process Documentation

Cloud Tool: AWS, Databricks

Python Libraries: NumPy, Pandas, Matplotlib, Scikit-Learn, Tensor flow, Py Torch, Keras, NLTK, Spacy

Work History

Data Analyst, 09/2023 to Current

Dentsu

Utilizing SQL and Python programming languages, I conduct complex data queries and perform advanced analytics to uncover patterns, trends, and anomalies within the dataset.

Employing a range of software packages including Microsoft Excel, Word, and PowerPoint, as well as specialized tools such as Power BI and Tableau, I design visually compelling dashboards and presentations to communicate findings effectively to stakeholders.

Designed and managed robust SQL databases using platforms like MySQL, adeptly querying and manipulating data to extract meaningful insights, achieving a 20% reduction in query response time, resulting in a 30% increase in analyst productivity.

Proficient in database systems like MySQL and SQL Server, I ensure data integrity, optimize queries for performance, and manage large datasets efficiently.

Leveraging cloud tools such as AWS and Databricks, I deploy scalable solutions and utilize cloud computing resources to handle big data processing tasks.

Harnessing Python libraries such as NumPy, Pandas, and Matplotlib, along with machine learning frameworks like Scikit-Learn, TensorFlow, Py Torch, and Keras, I develop predictive models and algorithms to forecast future trends and behaviors.

Adhering to methodologies such as SDLC, SCRUM, and Agile, I collaborate with cross-functional teams to deliver projects on time and within scope, ensuring alignment with business objectives. Data Analyst, 11/2021 to 11/2022

COGNIZANT TECHNOLOGY SOLUTIONS PVT LTD

Led the engineering of high-performance, distributed systems using Apache Spark and Scala, enhancing backend capabilities and enabling data- driven decision-making.

Developed and optimized Scala applications for efficient real-time data loading and streaming into MongoDB and HDFS, using Databricks to enhance data analytics capabilities.

Spearheaded the deployment and scaling of SaaS-based CRM solutions, focusing on efficient data ingestion, rigorous quality assurance, and strict compliance with industry standards.

Utilized Python, along with libraries like Pandas and NumPy, to develop sophisticated machine learning algorithms aimed at fraud detection and predictive analytics.

Automated the generation of data reports using SSIS and created interactive Power BI dashboards to provide strategic insights and support business review processes.

Data Analyst, 06/2019 to 09/2021

VARKY TECHNOLOGY SOLUTIONS

Involved in designing and developing logical and physical data models using Erwin Data Modeler, enhancing data analysis and intelligence for enterprise systems including DB2, Oracle, and Teradata.

Managed comprehensive data operations, encompassing data extraction, cleansing, and manipulation across various platforms such as Netezza, Mainframe, and operational data stores. Utilized tools like TOAD, MS Access, and SQL Server to meet ad-hoc data requests and improve business processes.

Created dynamic, teams-based dashboards and complex reports using Tableau and SQL Server Reporting Services (SSRS), focusing on delivering strategic insights and supporting business reviews. Developed visualizations including waterfall and donut charts to depict business metrics like sources of profit.

Database Optimization and Troubleshooting: Used SQL Profiler for performance tuning and optimization of SQL Server environments, ensuring efficient data operations and quality assurance.

Led the design and execution of ETL processes using Informatica Power Center, enhancing data quality and accessibility. Developed complex data mappings and SSIS packages for robust data integration and workflow management.

Actively collaborated within Agile frameworks to manage requirements, workflow analysis, and data quality projects. Engaged in consultative roles to refine data strategies and support data-driven decision making.

Spearheaded the development of machine learning algorithms using Python (Pandas, NumPy) for fraud detection and predictive analytics, aligning with compliance standards and innovative business intelligence goals.

Assisted in the production of OLAP cubes and performed data validation using tools like DVO, enhancing strategic data infrastructure and supporting CRM and SaaS deployments.

Contributed to the continuous improvement of data management practices, keeping pace with industry innovations and participating in professional development to enhance skills in data science and engineering. Education

Master of Science: Data Analytics, 05/2024

Yeshiva University - New York, NY

Personal Information

Visa Status: OPT

Certifications

AWS Certified Cloud Practioner

Contact this candidate