Utkarsh Sarswat Email & Phone Number

Bengaluru, Karnataka, India

Pune, Maharashtra, India

• Gathering business requirements and preparing detailed architectural specifications required to design data pipelines.
• Responsible for all activities related to the development, implementation, administration and support of the ETL process for the large-scale Snowflake cloud data warehouse.
• Debugging and performance tuning of complex SQL queries.
• Designed and developed new database objects like tables, views, stored procedures, functions etc. using SQL that included complex joins, sub queries and nested queries.
• Responsible for performing code reviews and maintaining code versioning in GitHub.
• Responsible for deploying and maintaining code in production servers.

Bengaluru, Karnataka, India

Extracting data from Docx and validating it with a template to reduce proofreading cycles.Automated the INCOSE rules to improve the quality of the requirements.

Pune Area, India

• Worked on the development of bot framework. It can help enterprise to create customizable and scalable bot. Created several AI bots with the help of this framework:Recruitment Assistance Bot:
• Worked on the use case of shortlisting relevant resumes from internal repositories and external portals like Times Job and Naukri.com and scoring the resumes on the basis of skills, experience, location, etc.
• Send bot links to the selected candidates for asking the pre-screening questions, confirming personal details and resolving queries of candidate regarding the job description, notice period, salary, etc.Employee.
• Created the use case in which employee can ask any queries regarding the job like their PF Account Number, Point of Contact (POC), No. of leaves available, Leave policies, etc.
• Extracted data from the PDFs.
• Created question answer system for the policies corpus.

Post Graduation Diploma In Big Data Analytics, Big Data Analytics

Bachelor Of Technology (B.Tech.), Computer Science, 70

Education record