Hitensh Kharva

MS in Computer Science

August 2021 - May 2023

Relevant Coursework

• Big Data Tools & Methods
• Algorithm Analysis and Design
• Scientific Database Technique
• Machine Learning

B.E. in Electronics and Telecommunications

August 2014 - May 2018

Relevant Coursework

• Data Structures & Algorithms
• Object Oriented Programming
• Operating Systems
• Mathematics

Data Developer, San Diego, CA

Tech Stack: Python, JavaScript, SQL, Looker, Snowflake, dbt, Github, AWS, CI/CD, Fivetran

• Seamlessly channeled SurveyMonkey & Hootsuite data via Fivetran connectors into Snowflake, and created staging, intermediate and marts dbt SQL models to culminate it in Looker, providing intuitive analysis to People’s Branding Team.
• Pioneered the integration of pre-commit hooks from dbt-checkpoint within our CI/CD framework, driving a 25% reduction in data model review time and a 30% increase in documentation accuracy, while ensuring over 90% compliance with naming conventions and enabling automated testing of critical data transformations in SQL models.
• Collaborated with the data team to integrate Autoscaling Spectacles within the dbt pipeline by setting up data testing scenarios and to establish automated data validation for LookML models.
• Implemented a CI pipeline in Python that automates the identification of changed dbt files affecting Looker tiles, retrieves queries for each dashboard tile in specific folders, and runs relevant tiles based on downstream model changes resulting in increased accuracy and decreased the risk of errors

Data Developer Intern, San Diego, CA

Tech Stack: Python , JavaScript, SQL, Looker, Snowflake, dbt, Github, AWS, CI/CD

• Designed and built data processing python models that successfully scanned, tagged, and masked PII fields in Snowflake schema, improving data privacy and security for data governance.
• ISpearheaded the implementation of an autoscaling, YAML linting in CI/CD ecosystem in dbt to optimize resource allocation and streamline development workflow, resulting in consistency and correctness in configurations for faster deployments and reducing development time by 40%.
• Scheduled and automated cron processes leveraging python scripts to report consolidated Looker dashboards, providing stakeholders with real-time insights, and enabling data-driven decisions.
• Created accurate and consistent models in dbt using SQL to build scalable and maintainable ELT pipelines.
• Developed data compare tool using Python and SQL to automate data comparison between development and production environments, improving data quality and efficiency in data management.

Backend Python Engineer, Mumbai, India

Tech Stack: Python, MySQL, Looker, PostgreSQL, RESTFul API

• Developed a data pipeline using Python and SQL to process semi-structured data from external RESTFul API, processing over 200 data points per day, and resulting in improved data management and enabling more effective analysis and reporting.
• Established meaningful metrics to qualify social media marketing value generated and created Dashboards that automatically refreshed these metrics daily, saving 2 hours per day of manual work.
• Designed and implemented scalable and secure backend systems using Python and Django on ERPNext using the open-source app-development framework Frappe.

Software Engineer, Pune, India

Tech Stack: Python, JavaScript, MySQL, MongoDb, Django, RESTFul API

• Successfully developed and delivered web and mobile banking products and services for 9 countries, meeting all project requirements through the Agile software development life cycle and exceeding client expectations.
• Automated testing & reporting processes in Python to analyze 30+ functional areas, increasing team efficiency by 20%.
• Performed thorough analysis, unit testing, and integration testing with other applications of database objects and SQL statements before deployment to production servers.
• Developed and delivered complex software applications through the Agile software development life cycle, including analyzing client requirements, planning, coding, testing, and implementation

Languages and Databases

Cloud Technologies

Tools