Anusha Ayyagari

Data Analyst

MD ad0f1m@r.postjobfree.com +1-502-***-**** Linkedin: www.linkedin.com/in/anusha-ayyagari-333660271

Around 5+ years of experience in Data Analyst, Design, Modeling, Development, Implementation, and Testing of Data Warehouse applications, and around 3 years of experience in an associate position.

Proficient in Software development life cycle (SDLC) process from requirement gathering, system analysis, and design to development and testing of enterprise solutions.

Good experience in performing statistical analysis, causal inference, and statistical modeling in R and Python.

Working experience in using various packages in R and python-like NumPy, Pandas, Matplotlib, and ggplot2.

Well-Versed in Text Analytics, generating data visualizations using R, and Python and creating dashboards using tools like Tableau Power BI, and Microsoft Excel.

Good knowledge of creating functions, triggers, views, and stored procedures using MySQL.

Working experience in writing Stored-procedures, Triggers, functions, sub-queries, constraints, Indexing, views, Common Table Expressions, and Normalization using T-SQL.

Good skilled in writing stored procedures, triggers, and complex queries containing multiple joins, subqueries, and window functions to create reports and perform analysis.

Knowledge of Data extraction, Data cleaning, Data Loading, Statistical or Exploratory Data Analysis, Data Wrangling, and Predictive Modeling using R and Python.

EDUCATION

Master of Data Science University of Maryland, Baltimore, MD

Bachelor of Engineering - Electronics and Instrumentation Engineering Jawaharlal Nehru Technological University Hyderabad, Hyderabad, Telangana

EXPERIENCE

Hartford Financial Services Group, MD March 2023 - Current Data Analyst

Utilizing Python and SQL to engineer algorithms involving Linear Regression, Logistic Regression, and Random Forest models.

Utilizing data mining and statistical techniques to perform required tests and algorithms on the structured data.

Performing text mining using Natural Language Processing to Extract state name counts and from annual reports on the form.

Use Agile Methodology to implement project life cycles of reports design and development.

Work on data cleaning, data visualizing, and data mining using SQL/ Python/ R.

Generating various capacity planning reports (graphical) using Python packages like NumPy, Pandas, matplotlib, and ggplot2.

Create an executive report using advanced SQL features such as common table expression, window function, rank order, pivoting, etc.

Create action filters, and parameters and calculate sets for preparing dashboards and worksheets in Tableau.

Involving requirements gathering and source data analysis and identified business rules for data migration and for developing the data warehouse.

Perform SQL operations that included advanced filtering and data aggregation, window functions.

Writing SQL (DDL, DML, AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, functions (UDF), cursors, triggers, locking issues, common table expressions (CTEs).

Generate a variety of business reports from SQL server using excel with a pivot table and pivot chart.

Perform data collection, data cleaning, data wrangling, data analysis, and machine learning models on the data sets in both R and Python.

Data retrieval from MySQL database using pyodbc library in python.

Kalp Technolab, India Dec 2017 - Dec 2019 Full Time - Data Analyst

Used Python, R, and SQL to create Statistical algorithms involving Multivariate Regression, Linear Regression, Logistic Regression, Random Forest models, Decision trees, and Support Vector Machines for customer risk assessment.

Used Pandas, NumPy, Seaborn, SciPy, matplotlib, Scikit-learn, and NLTK in Python for developing various machine learning algorithms.

Used multiple machine learning algorithms, including random forest and boosted tree, SVM, neural network, and deep learning using TensorFlow.

Application of various algorithms and statistical modeling like decision trees, regression models, neural networks, SVM, and clustering to identify Volume using scikit-learn package in Python.

Conducted data profiling and analysis in Tableau Prep Builder to identify data inconsistencies and gaps and implemented data cleaning and standardization techniques to improve data quality.

Used data visualization tools like Tableau, Power BI, or matplotlib to present data in visually appealing and understandable formats.

Use data warehousing/business intelligence toolsets to gather, store, and provide access to data in assist management decision making.

Applied data mining algorithms to identify patterns, trends, and anomalies in data, leading to actionable recommendations.

Developed and maintained relationships with external vendors and data providers to access relevant market data and industry trends.

Managed, developed, and supported database applications to provide user-friendly interfaces that increased efficiency and improved data.

Performed exploratory data analysis (EDA) to understand data characteristics, identify outliers, and detect data inconsistencies.

Presented data-driven recommendations and insights to senior management, enabling informed business decisions and strategy formulation, knowledgeable in both qualitative and quantitative methodologies in data analytics, and building new and/or modifying existing database/data warehouse/data mart and business intelligence solutions to meet business and system requirements.

Macro Software Solutions, India Jan 2015 - Nov 2017 Full Time - Data Analyst

Implemented Logistic Regression, Random Forest classification, and Gradient boosting classification to compare performance.

Perform mathematical and numerical modeling, time series analysis, data mining, and machine learning with applications in healthcare and finance.

Developed comprehensive reports and dashboards to effectively communicate insights and trends to stakeholders.

Developed data mining models and implemented them in real-world scenarios to optimize business processes and improve decision-making.

Proven track record of delivering actionable insights and driving business growth through data-driven initiatives.

Created complex SQL queries to retrieve specific information from large databases efficiently.

SKILLS

Methodologies:

SDLC, Agile, Waterfall

Language:

Python, R, SQL

IDEs:

Visual Studio Code, PyCharm

Packages:

NumPy, Pandas, Matplotlib, SciPy, ggplot2, PySpark, PyODBC

Visualization Tools:

Tableau Prep Builder, Power BI, Microsoft Excel

Database:

MySQL, SQL Server, Oracle Pl/SQL

Other Skills:

Data Cleaning, Data Wrangling, Critical Thinking, Communication Skills, Presentation Skills,

Problem-Solving, Data-driven Decision Making, Critical Thinking, Teamwork, Business Analysis

Operating System:

Windows, Linux

SAS Tools:

SAS/BASE, SAS/SQL, And Macro Facility.

Contact this candidate