Summary
Overview
Work History
Education
Skills
Languages
Certification
Timeline
Generic

Hinal Jani

San Diego,CA

Summary

Enthusiastic SQL Developer (Structured Query Language) and Data Scientist with over three and half years of experience in database administration, code generation, analytics, reporting, business intelligence, strong foundation in Python programming. keen to leverage knowledge in advanced analytical skills, domain expertise, database management systems, data modeling and cluster computing.

eager to secure SQL developer position. Passionate about continuous learning and emerging technology trends. Ready to help team achieve company goals.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Data Scientist

Imaginations Softech Solutions Pvt. Ltd.
, Gujarat, India
09.2021 - 02.2023
  • Performed exploratory analysis on large datasets using SQL and Python libraries such as Pandas, NumPy, Scikit-Learn, and Matplotlib.
  • Created graphs and charts detailing data analysis results.
  • Cleaned and manipulated raw data.
  • Developed predictive models using machine learning, natural language and statistical analysis methods.
  • Utilized Pandas and Python for data manipulation, resulting in a 2-hour reduction in data cleaning time.
  • Created interactive dashboards using Matplotlib to communicate insights effectively.
  • Designed MySQL databases to efficiently handle large-scale datasets, lowering query response time by 58%.
  • Optimized joint development between 3 teams through appropriate database and project design.
  • Worked with few stakeholder throughout the organization to identify opportunities for leveraging data.
  • Automatd data extraction and transformation processes via SQL, reducing data processing time by 30%.

SQL Developer

Imaginations Softech Solutions Pvt. Ltd.
, Gujarat, India
10.2019 - 08.2021
  • Developed various stored procedures, functions, triggers, Indexes, views and adding/changing tables for data load, transformation and extraction.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of Databases.
  • Wrote standard and complex T-SQL Querier to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
  • Used Packages by testing and cleaning the Standardized Data by using tools in Data.
  • Data flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing and new packages.
  • Created reports to retrieve data using Stored Procedures that accept parameters.
  • Scheduled the daily/weekly/monthly reports to run automatically onto the Dashboard.
  • Optimized existing queries for better performance using SQL query tuning techniques.
  • Performed backup and recovery of databases on a regular basis.
  • Resolved customer service requests related to database errors or performance issues quickly and efficiently.

Education

Master of Science - Data Science And Artificial Intelligence

Mithibai College
08-2019

Bachelors in Business With Accounts And Statistics - Accounting And Business Management

Bharath University
09-2017

Skills

  • Relational databases
  • Structured query language (SQL)
  • Data Modeling
  • Data Validation
  • Normalization techniques
  • Database Design
  • Business Intelligence
  • Data Mining
  • Statistical Analysis
  • Business Forecasting
  • Python Programming
  • Data Exports
  • Data screening
  • Database Programming
  • Data Mapping
  • Deep learning
  • Machine Learning
  • Data Visualization and Presentations
  • Problem-Solving
  • Decision-Making
  • Adaptability and Flexibility
  • Attention to Detail
  • Microsoft Office Suite

Languages

English
Full Professional
Hindi
Full Professional
Gujarati
Native/ Bilingual

Certification

  • Certified SAP FICO Developer - (Systems, applications & Products in Data processing in Financial Accounting and Controlling)

Timeline

Data Scientist

Imaginations Softech Solutions Pvt. Ltd.
09.2021 - 02.2023

SQL Developer

Imaginations Softech Solutions Pvt. Ltd.
10.2019 - 08.2021

Master of Science - Data Science And Artificial Intelligence

Mithibai College

Bachelors in Business With Accounts And Statistics - Accounting And Business Management

Bharath University
Hinal Jani