Gajendra Chauhan Email and Phone Number

Dashboard for Assess development:• This project includes the source team dumping the data into a s3 bucket and providing us with the transformations I need to perform on the data.• The sample data is read in the databricks and logic is tested and transformations are done and the dataframe is ready to be written to landing location.• Now the new feature branch is made in the bitbucket and cloned to the intellij and all the changes are brought here from databricks, jsons and change lists is also made as per the requirement.• Now the push request is created for manager to approve the request for code merge.• Build (Jules Build) is run to deploy the code, the job is triggered and monitored in the airflow, in case of any issues, we check the EMR logs by getting Cluster and Step Id for the job from airflow.• After the job is successful, the unit testing is done by running different queries in the Athena and checking source and target count and schema for different dates. • Once the unit testing is done, the code is pushed to production bitbucket repo and job is scheduled in the control M, and runbook is prepared for the other team to follow from here.

Working on ETL - Extracting, Transforming & loading the data to/from different databases/MSCRMs/Accounting Software, etc. This role not only required knowledge of Java/python and SOQL/SQL but also domain knowledge of the different businesses and operations. This gave me insight and the ability to handle the data and also inspired me for Data Science and hence learning Machine Learning and Deep Learning. Project:Aim: To Increase the of opportunity closure by 15% by presales:15 years of sales data were tracked & analyzed, the resolution for common recurring cases was listed down, and the most frequent use cases were automated. This along with taking care of other factors resulted in an increase in opportunity closure to ~30%. Also designed a dashboard for the company to show quarter and yearly performances.

Engaged in working on the ETL. Have business meetings/requirements gatherings with the client, depending upon the requirements customizing the tool by adding new workflows, new mappings/rules. Requirements also involve Extracting the data (from various CRMs, ERPs, Accounting Softwares, different Databases, and other Websites), Transforming it according to the business requirements, and then loading/migrating it to the target systems.

Teach technical training programs that educate people and help develop their technical skills: like - Devise technical training programs according to the requirements- Determine course content for Data Structures and Java according to objectives and projects - Prepare training material (assignments and mock interviews)- Execute training sessions, webinars, workshops, etc. in groups or sometimes individually- Observe and evaluate results of training programs