Abhinav Rawat

Worked in backend API development using Django REST API for multiple modules like dynamic segmentation creation, publishing generated suggestion, connector and connection creator, and activity log with download functionality for CustomerIQ product. Created and implemented data ingestion design for upload, schedule and on demand functionality for the product. Involved in creating data models across different modules, reviewing project specifications, and devising solutions. Hands-on experience includes Amazon S3, AWS glue tables, Athena Connect, Boto4, PostgreSQL, Jenkins, Github, Bitbucket, and JIRA. Led daily Scrum stand-ups and Agile development sprint planning meetings for multiple concurrent projects.

Worked over 20+ ETL projects across multiple domains (Covid, Sports, Finance, Cryptocurrency, Autos, etc) using Python and SQL technologies. Managed a team of 40 team members with effective resource utilization. Actively worked in an agile software development environment utilizing the Scrum process. Collaborated with Google Engg. and infrastructure team to build scalable automated ETL pipelines using SQL, Python, and in-house developed ETL tools. Involved in project scoping and decision making for project feasibility and implementation guide.

Designed and implemented complex ETL system to ingest data in Knowledge Graph to serve data in Google Search. Hands-on experience in SQL, Python, and other in-house developed Google tools used for data ingestion and automation. Worked on creation of dashboards for data distribution and visualization using SQL. Worked on data crawling and scraping using Python. Developed a Time sheet reporting tool in Django Framework. Day-to-day interaction with Google clients to understand project requirements and worked closely with the Google Engg team to create data development pipeline from scratch.

Part of the data curation team, responsible for research and analyzing data to enhance correctness of Google Data. Hands-on experience in data curation jobs like Data Recon, Data Split, and Data Merge. Proficient in data curation, review, and audit processes. Trained new members to help understand the process better.

Responsible for understanding and analyzing requirements in SQL Server, constructing tables, and using Normalization/De-normalization techniques. Expertise includes writing T-SQL Queries, Dynamic-queries, sub-queries, and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views, and Cursors. Experienced in using recursive CTEs, CTE, temp tables, and effective DDL/DML Triggers. Developed report design using MS Access, development, and testing.

Selected for the post of Graduate Engineer Trainee. Trained for 6 months on Sql Server, T-SQL, and Visual Basic. Analyzed Code, Designed, Developed, Troubleshot, and Debugged software programs using SQL Server Technologies. Demonstrated ability to handle multiple tasks, initiative, adaptability, and strong problem-solving skills.

Selected for the world's largest campaign 'Badh Chala Bihar' under the supervision of the Government of Bihar. Worked for 1 month under the GPS Monitoring and Troubleshooting Team. Gained hands-on experience with GPS Vehicle Tracking and Troubleshooting Systems. Received Certificate of Appreciation for Internship work.