Vijval V.

About Vijval V.

Passionate about data science and driven by a hunger for challenges, I am a dedicated…

Experience

1. Database Analyst

   Technogen, Inc.

   Jan 2025 — Present · VA, US

   Collect, clean, and preprocess large datasets from diverse sources (e.g, relational databases, AWS S3, or APIs) using Python, SQL, and PySpark.· Optimize complex SQL queries for large-scale datasets, improving query execution time and enhancing report generation efficiency for business stakeholders.· Manage SQL Server databases through multiple product lifecycles. From development to production on schedule timelines.· Assist in enforcing data governance policies by standardizing data formats and documenting database schemas, ensuring compliance with organizational data quality standards.· Develop procedures to increase security in database via SQL-Injection countering technigues.· Create interactive, user-friendly dashboards using BI tools like Tableau, Power BI, visualizing KPIs and metrics (e.g, sales trends, customer retention) to enable stakeholders to monitor performance in real-time.· Collaborate with business stakeholders to identify key metrics and reporting needs, translating requirements into technical specifications for dashboards that align with organizational goals.· Perform statistical analysis and EDA using SQL and python to uncover trends, patterns, and anomalies, delivering insights that improve business, as demonstrated in prior data science workflows.· Optimize features from raw datasets to enhance ML model performance in downstream, applying statistical techniques to improve predictive accuracy.· Utilize Python, SQL scripting to extract, transform, and load (ETL) data from various sources, including relational databases (MySQL, PostgreSQL) and flat files, enhancing the data preparation process for efficient reporting.· Automate ETL scripts to schedule and deliver recurring reports, enabling stakeholders to access timely insights with minimal manual intervention.