Divya Nethi
Summary
Data Analyst with 4+ years of experience in Structured and Unstructured Data Processing, Data Acquisition, Data Validation, Data Cleansing, Predictive Modeling, and Data Visualization. Employed all phases of the Software Development Life Cycle (SDLC) using methodologies like Waterfall and Agile. Expert in execution of Data Flows, Data Interpretation, Data Architecture, Data Profiling and Data Integration by using Databases like MySQL and MS SQL Server. Exhibited proficiency in working with various Python IDE like PyCharm and Visual Studio Code with statistical programming skills in Python and R. Good knowledge of Pandas, NumPy, Matplotlib, and SciPy along with data analytics, data wrangling, and Excel data extracts. Proficient in generating on-demand and scheduled reports for management decisions using Tableau. Performed extracting of data from multiple sources to Power BI for Data Preparation. Created functions and assigned roles in AWS to run python scripts and perform event driven processing. Good problem-solving skills and have a quick learning curve and committed team player and capable of working on tight project delivery schedules and deadlines.
Overview
5
5
years of professional experience
Work History
Data Analyst
01.2023 - Current
- Utilized SQL queries on data staging tables and data warehouse tables to validate the data results
- Creating various planning reports using Python and R packages like NumPy, Pandas, Matplotlib, SciPy, and ggplot
- Designed Data mapping and filtering, cleaning, Integration, and customization of the data mart
- Performed troubleshooting, fixed and deployed Python bug fixes, and wrote scripts to load the data in the database
- Implemented and parameterized Graphic visualizations with Drill Down and Drop-down menu options using Tableau
- Expertise in explicit writing SQL queries for various RDBMS such as SQL Server and MySQL
- Developed a Python Script to load the CSV files and create AWS S3 buckets and performed folder management in each bucket, managed logs and objects within each bucket
- Skilled in creating reports, dashboards and interactive data visualizations using Power BI.
Data Analyst
Macro Software Solutions
, India
01.2019 - 12.2021
- Waterfall Methodology to document existing and future business processes resulting in 17% increase in overall product quality
- Worked with collections in Python for looping through different user-defined objects and imported the claims data using Pandas libraries to perform various data analysis
- Skilled in creating and manipulating spreadsheets and databases to track analyse various types of data in Microsoft Excel
- Created reports using SQL to extract the data and use Excel to format the data for analysis, manipulation, and dissemination to business users with increase of purchase potential by 23%
- Proficient in data visualization using Tableau, including creating dashboards, charts, graphs to communicate insights from data by using its data blending features
- Performed data collection, data cleaning, data wrangling, data analysis, and building machine learning models on the data sets using Data Dictionaries in both R and Python
- Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports
- Managing complex relationships between data tables using Power BI’s data connectors and ETL tools
- Using Git for version control and Pull Requests
- Automated the process of email notification system to notify stakeholders in case of any failure using optimized SQL queries, leading to its improvement and reducing workflow time by 30%
- Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server, and Flat files
- Setting up Azure infrastructure like storage accounts, integration runtime, service principal id, app registrations to enable scalablility of business user requirements in Azure
- Responsible for developing data pipelines with Amazon AWS to extract the data from S3 buckets used for data fetching and model testing.
Data Analyst
Kalp Technolab
, India
01.2018 - 12.2019
- Used the Waterfall methodology to build the different phases of the Software development life cycle
- Wrote informative SQL queries for data extraction, such as parameterized stored procedures, indexes, and triggers
- Used Python multiple data science packages like Pandas, NumPy, matplotlib, and SciPy
- Proficient in Microsoft Excel, including creating charts, graphs, pivot tables and experienced with formulas, macros and data analysis tools
- Collaborated with teams to design and develop reports and dashboards in Tableau for data identification and predictive modeling
- Effectively created various types of data visualizations using R and Python
- Created SQL tables with referential integrity and developed advanced queries using stored procedures and functions using SQL server management studio
- Documented and improved the ETL (Extract, Transformation, and load) strategy to populate Data Warehouse
- Top of Form
Education
Master - Computer Science
University of Alabama at Birmingham
Bachelor of Technology -
The Sreenidhi Institute of Science and Technology (SNIST)
Skills
- Methodologies:
- SDLC, Agile, Waterfall
- Language:
- Python, R, SQL
- IDEs:
- Visual Studio Code, PyCharm, Jupter Notebook
- Packages:
- NumPy, Pandas, Matplotlib, SciPy, ggplot2
- Visualization Tools:
- Tableau, Power BI, Microsoft Excel
- Database:
- MySQL, SQL Server
- Operating System:
- Windows, Linux
- Cloud Platforms
- Azure, AWS, GCP
Timeline
Data Analyst
01.2023 - Current
Data Analyst
Macro Software Solutions
01.2019 - 12.2021
Data Analyst
Kalp Technolab
01.2018 - 12.2019
Master - Computer Science
University of Alabama at Birmingham
Bachelor of Technology -
The Sreenidhi Institute of Science and Technology (SNIST)