Mona Gogineni

Mona Gogineni

Data Analyst
India
Full-time On-site

About Me

Data Analyst and SQL Developer with 1+ year of experience in SQL querying, MySQL database operations, Python-based ETL, data validation, and reporting. Experienced in supporting 3 clients and processing 100,000+ asset re…

Experience

Junior Data Analyst

DigitoWork · Hyderabad , Telangana , India
May 2025 - Present · 1 year 6 months

<p>Manage asset data workflows for 3 clients, covering asset, location, purchase order, invoice, and related records.</p><p> Process 100,000+ asset records in batches of approximately 1,000, validating completeness, consistency, and business rules.</p><p> Develop Python ETL scripts using Pandas and NumPy to clean CSV data, transform fields, and prepare validated records for MySQL loading.</p><p> Connect Python workflows to MySQL using SQLAlchemy and PyMySQL for database operations and data loading.</p><p> Write SQL queries using joins, CTEs, subqueries, aggregations, and window functions to analyze asset data by category and location.</p><p> Perform duplicate detection, source-to-target reconciliation, post-load validation, and Excel-based exception reporting.</p><p> Develop Python scripts to retrieve MySQL data and generate reports and visualizations for business requirements.</p>

UI Developer

Scintillate Informatics Pvt Ltd · Hyderabad , Telangana , India
Nov 2024 - Jan 2025 · 2 months

<p>Developed responsive web components using HTML5 and CSS3 on the Duda platform.</p><p> Implemented responsive layouts and supported cross-browser compatibility.</p>

Skills

MySQL Joins CTEs Subqueries Aggregations GROUP BY HAVING CASE Statements Window Functions Python 3 Pandas NumPy CSV Processing Data Extraction Transformation Loading SQLAlchemy PyMySQL Advanced Excel PivotTables VLOOKUP Data Validation Exception Reporting Data Visualization Data Profiling Data Cleansing Duplicate Detection Business Rule Validation Reconciliation Data Integrity Checks GCP BigQuery HTML5 CSS3 Duda
Report this Profile?