Rachit Garg Email & Phone Number

Pune, Maharashtra, India

Pune, Maharashtra, India

Pune, Maharashtra, India

Organize and manage the technical DATA team of data modelers, engineers, and provide leadership, guidance, and mentoring.Define Overall Data Architecture, Models, Design, and Strategy.Drive Data Analysis Effort for Data Movement and building ETL Designs.Overseeing the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality.Review and analyze databases against business requirements.Prepare exclusive management reports and… Show more Organize and manage the technical DATA team of data modelers, engineers, and provide leadership, guidance, and mentoring.Define Overall Data Architecture, Models, Design, and Strategy.Drive Data Analysis Effort for Data Movement and building ETL Designs.Overseeing the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality.Review and analyze databases against business requirements.Prepare exclusive management reports and discuss the progress plan with Team about account changes, suggestions, working plans, etc Show less

Pune Area, India

o Worked with Product Managers to frame a problem, both mathematically and within the business context.o Used Python and Libraries (Pandas, NumPy, Seaborn) to clean, analyze and visualize large raw data sets.o Performed exploratory data analysis and discovered notable relationships.o Created Machine Learning models with Python using scikit-learn and Neural Networks to predict product demand taking into consideration all real-time factors.o Improved the model's prediction… Show more o Worked with Product Managers to frame a problem, both mathematically and within the business context.o Used Python and Libraries (Pandas, NumPy, Seaborn) to clean, analyze and visualize large raw data sets.o Performed exploratory data analysis and discovered notable relationships.o Created Machine Learning models with Python using scikit-learn and Neural Networks to predict product demand taking into consideration all real-time factors.o Improved the model's prediction accuracy to 90%o Coordinate with different functional teams to implement models and monitor outcomes.o Used PL/SQL and PostgreSQL to create Packages, Functions, Triggers, and Procedure.o Tuning of the SQL queries, which takes a long time to process the request using Explain Plan, Hints to reduce the response time (performance tuning).o Analyzed data from different data sources for storing it in Data warehouse.o Created SQL Scripts to move data from staging tables to Data warehouse tables.o Tested and corrected errors and refined changes to the database.o Performed Database configuration, backup, optimization, and monitoring.o Used Python Scripting for Data Wrangling and Data Pre-Processing.o Involved in Sprint planning and scrums. Show less

India

o Designing database solutions to satisfy application (business and technical) requirements.o Developing database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.o Maintaining database performance by identifying and resolving production and application development problems.o Provide first level operational support for development and production database systems.o Used PL/SQL… Show more o Designing database solutions to satisfy application (business and technical) requirements.o Developing database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.o Maintaining database performance by identifying and resolving production and application development problems.o Provide first level operational support for development and production database systems.o Used PL/SQL to create Packages, Functions, Triggers, and Procedure.o Used SQL*Plus and SQL*Loader for Database operations and error capturing into log tables. Show less

Pune Area, India

Role: Database Developer -o Extensive use of Unix Shell Scripts, AutoSys Jobs to automate process and sending scheduled e-mails.o Used PL/SQL to create Packages, Functions, Triggers and Procedure.o Used SQL*Plus and SQL*Loader for Database operations and error capturing into log tables.o Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time (performance tuning).o Created various utilities and processes… Show more Role: Database Developer -o Extensive use of Unix Shell Scripts, AutoSys Jobs to automate process and sending scheduled e-mails.o Used PL/SQL to create Packages, Functions, Triggers and Procedure.o Used SQL*Plus and SQL*Loader for Database operations and error capturing into log tables.o Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time (performance tuning).o Created various utilities and processes to automate tasks.o Tested and corrected errors and refined changes to database.o Worked on many Change requests raised by the application user and have all relevant information about the project.o Involved in Sprint planning and scrums.o Involved in all phases of development, from needs assessment to QA, design, and support. Show less

Bachelor’S Degree, Electronics And Communications Engineering

Activities and Societies: Team Leader and Manager of Quest Nature Club (College Club) for session 2012-2014. Social Media and Promotion.

Aissce, Physics, Chemistry And Mathematics

Activities and Societies: Guitarist - School Band

Aisse

Activities and Societies: Stand Up Comedy, Drama/Play, Event Management, Debate Received certificate of Merit by CBSE for being amongst.