Summary
Overview
Work History
Education
Skills
Timeline
Generic

Niharika Modugu

Denton,TX

Summary

With Over 3 years of experience as a data analyst, proven expertise using sophisticated analytical tools and methodologies to support data-driven decision-making and business insights in a variety of industries, including financial services and logistics. Proficient in prominent Business Intelligence tools like Tableau and Power BI for data visualizations that obtain deep insights into large datasets. Skilled in creating and putting into practice data-driven solutions, such as multithreaded crawlers and SEO optimization tools, to boost search engine rankings and operational effectiveness. Skilled in creating dashboards and visualizations that convey important metrics to stakeholders, as well as collecting and cleaning huge datasets. Expertise in Database projects and applications working with Microsoft SQL Server and writing SQL statements. Strong cooperation and communication abilities, as well as experience presenting complex data insights to both technical and non-technical audiences in order to impact strategic choices. Experienced in designing and conducting A/B tests to assess strategy effectiveness. Extensive IT background in data analysis, ETL development, data modeling, and project management.

Overview

3
3
years of professional experience

Work History

Data Analyst

Verizon
01.2023 - Current
  • Converted Visual Basic Application to Python, MSQL
  • Employed advanced campaign management techniques and centralized dashboards to analyze key digital marketing and user engagement metrics across multiple banking websites
  • Led conversion optimization initiatives for major clients like Citi and Amex, resulting in significant improvements in checkout funnel flow and submission rates
  • Utilized predictive analytics to identify common user journeys leading to purchases and implemented website restructuring strategies to increase overall conversion rates
  • Developed a sophisticated multithreaded crawler to extract text from thousands of web pages for the ALPS data model, which predicts Google's organic search performance using regression models
  • Orchestrated end-to-end conversion optimization activities, including planning A/B tests, and analyzing results, resulting in a notable 20% improvement in website page performance
  • Achieved a remarkable 30% increase in conversion rates for the Amex travel insurance product through strategic website flow modifications guided by predictive analytics
  • Successfully resolved a traffic allocation issue, leading to a significant revenue increase of over $400K for the company
  • Collaborated on the development of an SEO Optimization tool, ALPS, aimed at predicting Google's search algorithm and improving search engine rankings for stakeholders
  • Leveraged tools such as Adobe Analytics, Google Analytics, Tableau, and Google AdWords to gather insights and optimize digital marketing campaigns
  • Contributed to the creation and enhancement of a robust SEO Optimization tool, ALPS, as part of a dedicated team effort
  • Utilized Visual Website Optimizer and SEM Campaign Manager to refine marketing strategies and enhance online visibility for clients

Data Analyst

Unique Infotech
01.2022 - 12.2022
  • Understanding and analysing the Logistics data
  • Performed data analysis on large relational datasets using optimized diverse SQL queries, such as DML and DDL statements including various joins, group functions, string functions, and ranking functions
  • Summarize, aggregate, and share data in easy‐to‐consume formats for internal or external audiences, to aid data quality improvements, product and process improvements, and measurement of data quality goals
  • Data collection and extraction from multiple sources, performed data cleansing, filtration, and calculation in Microsoft Excel, formulated data analysis of 1M+ rows of datasets
  • Involved in the development of deliverables and roadmaps to advance the migration of on-premises Traditional Database systems into Snowflake cloud Data warehouse in Azure cloud environment
  • Performed Functional and test analysis for real estate data
  • Build the high-level prod DQ metrics dashboard in Tableau for checking the consistency and accuracy of data based on a few metrics
  • Involved in requirement gathering, technical design, development, and testing
  • Involved in analyzing the new business requirements requested by the client, developing, and integrating into an application
  • Gather client requirements using JIRA and solely responsible for completing the same in the given time
  • Expertise in the oral and visual communication of data and business insights to technical and non‐technical users
  • Responsible for ETL (Extract, Transform, and Load) processes to bring data from multiple sources into a single warehouse environment
  • Created the analytics dashboard showing buy/sell statistics meant for compass leadership using Power BI analytics and Tableau
  • Produced monthly reports using advanced Excel spreadsheet functions.

Education

Master of Science - Computer Science

University of North Texas
Denton, TX
05.2024

Skills

  • Redhat Linux
  • Ubuntu
  • Windows
  • TCP/IP
  • DNS
  • DHCP
  • HPC
  • Model Development
  • Optimization
  • Deployment
  • Python
  • Java
  • NumPy
  • Pandas
  • Matplotlib
  • Tableau
  • Power BI
  • HTML
  • CSS
  • Amazon Web Services (AWS)
  • Microsoft Azure
  • MySQL
  • MongoDB
  • Microsoft SQL Server
  • Role-Based Access Control
  • Disaster Recovery Planning
  • ServiceNow
  • SharePoint
  • REST APIs
  • Power Apps
  • Power Automate
  • Power Virtual Agents
  • Version Control (Git)
  • Version Control (GitHub)
  • Big Data (Hadoop)
  • Big Data (Apache Spark)
  • Scripting (Bash)
  • Scripting (PowerShell)
  • Scripting (Shell scripting)
  • Workflow Automation
  • Linux
  • REST APIs
  • Power Apps
  • Power Automate
  • Power Virtual Agents
  • Version Control (Git)
  • Version Control (GitHub)
  • Big Data (Hadoop)
  • Big Data (Apache Spark)
  • Scripting (Bash)
  • Scripting (PowerShell)
  • Scripting (Shell scripting)
  • Workflow Automation
  • Linux
  • REST APIs
  • Power Apps
  • Power Automate
  • Power Virtual Agents
  • Version Control (Git)
  • Version Control (GitHub)
  • Big Data (Hadoop)
  • Big Data (Apache Spark)
  • Scripting (Bash)
  • Scripting (PowerShell)
  • Scripting (Shell scripting)
  • Workflow Automation
  • Linux
  • REST APIs
  • Power Apps
  • Power Automate
  • Power Virtual Agents
  • Version Control (Git)
  • Version Control (GitHub)
  • Big Data (Hadoop)
  • Big Data (Apache Spark)
  • Scripting (Bash)
  • Scripting (PowerShell)
  • Scripting (Shell scripting)
  • Workflow Automation
  • Linux

Timeline

Data Analyst

Verizon
01.2023 - Current

Data Analyst

Unique Infotech
01.2022 - 12.2022

Master of Science - Computer Science

University of North Texas
Niharika Modugu