Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Projects
Publications
Languages
Affiliations
Timeline
Generic
LOKESH VAISHNAV

LOKESH VAISHNAV

Udaipur

Summary

Data Enthusiast with expertise in requirement analysis, software development, and database management. Extensive experience in data collection, cleaning, and interpretation, leading to actionable insights. Proficient in database design, coding, testing, and support, with a strong grasp of data structures and SQL. Proven track record of enhancing system efficiency and data accuracy through effective database management strategies.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Software Engineer

Optym India Private Limited
Bengaluru
03.2023 - Current
  • Architected and implemented Azure Data Factory pipelines, reducing processing time by 30%.
  • Optimized database performance by decreasing execution time by 40% through efficient query strategies.
  • Configured IOPS and throughput settings, deploying PgBouncer to enhance connection pooling.
  • Utilized MSSQL Server tools and Azure Monitor for continuous database performance monitoring.
  • Diagnosed critical performance issues using App Insights, ensuring timely troubleshooting.
  • Engineered application features by developing robust procedures/functions for PostgreSQL and MSSQL Server.
  • Designed databases for product launches and restructured existing designs for scalability.
  • Collaborated across three product lines to provide optimized queries and functions.

Analyst - Data Science

Escalent Inc.
Noida
08.2021 - 12.2022
  • Cleaned, manipulated, and processed RAW data using R programming to meet client requirements, presenting results in R Markdown with visualizations through ggplot2.
  • Developed a central database by linking multiple datasets, extracting insights via SQL queries.
  • Derived additional columns through logical formulas in Excel to create graphs for client presentations.
  • Created an R Shiny app for predicting p-values across multiple variable combinations.
  • Automated cleansing and processing of RAW datasets using Python to reduce manual intervention.
  • Designed and developed a web application from scratch in Django, focusing on both back-end and front-end functionalities.
  • Utilized HTML, JavaScript, CSS, SQLite, Python, and ChartJS in app development while defining app structure and database flow.

Marketing - Database Associate /Senior Associate

C V E N T India
Gurugram
07.2018 - 11.2020
  • Executed extraction of marketing campaign data and sales leads across various platforms including SQL, Excel, MS Access, Python, and R.
  • Constructed data cleansing functions using Python (regex), R (regex), and SQL (wildcards) to ensure accuracy.
  • Collaborated with analysts for database performance improvements.
  • Led a project for jump server installation aimed at enhancing operations of the India server.
  • Developed a streamlined prospect database utilizing optimized algorithms for task efficiency.
  • Merged two organizational databases for better information integration and access.
  • Supported DBAs by reporting bugs for effective database management.
  • Assessed data quality by identifying gaps and providing necessary summaries.

Education

B-Tech - CSE

Galgotias University
Sector 17A, Greater Noida, Uttar Pradesh 203201
01.2018

Higher Secondary - Physics, Chemistry, Maths And Physical Education

MDS Public School
MDS-Dheekli Road, Near Old RTO Road, Pratap Nagar
01.2014

Matriculation -

ST Teresa Vidya Deep School
Sec-12, Sec-14, Savina, Udaipur, Gordhan Vilas
01.2012

Skills

  • Postgres
  • Data visualization
  • Database optimization
  • SQL querying
  • Data cleansing
  • Performance monitoring
  • Critical thinking
  • Problem solving
  • Attention to detail
  • Collaboration skills
  • Data integration
  • Business intelligence
  • Testing and deployment
  • MSSQL
  • Azure Data Factory
  • Azure Managed instance
  • Azure SQL
  • R Programming
  • Python Programming
  • Django Framework
  • HTML
  • CSS
  • JavaScript
  • Power BI
  • MS Excel
  • R Markdown
  • R Shiny
  • Chart JS

Certification

  • Machine learning to deep learning: A journey for remote sensing data classification, Indian Institute of Remote Sensing (IIRS), ISRO, b7c816395eadf958bcfa0335d6ac0317
  • SQL Essentials, LinkedIn Learning, AfHtJxJA9ngMBDng0diVMRM5gfZY
  • Learning Python, LinkedIn Learning, Aa0e7qXYu_EbCnGXxMpm8UYrt9Pr
  • Advanced Python, LinkedIn Learning, AUlnz_hNHIDq18CLhdm2ILC8jY4a
  • SQL INTERMEDIATE, HackerRank, AC900FDD766A
  • SQL BASIC, HackerRank
  • Deep Learning A-Z: Hands-On Artificial Neural Networks, Udemy, UC-243d8a80-6a28-435a-a77d80bd225d225e

Accomplishments

  • Won an award of excellence at Escalent for creating an application from scratch in a dedicated time period
  • Won multiple presentations at Cvent for showcasing the work done on a quarterly basis
  • Developed the Azure pipelines for project archival using ADF in a dedicated time period at Optym

Projects

  • Sentiment analysis of Twitter data
  • Final Year Project – Android malware behavioral analysis|R programming, SQL, Power BI
  • Research project – juvenile depression and future criminal behavior (Udaipur District)|R programming, Power BI
  • Research project – Yamuna water site analysis (temperature as dependent variable)|R programming, Power BI

Publications

  • Behavioral Analysis of Android Malware using Machine Learning, https://www.researchgate.net/publication/316994089_Behavioral_Analysis_of_Android_Malware_using_Machine_Learning
  • Indian Juvenile Depression and Future Criminal Behavioural Forensic Analysis of Udaipur District Population, https://www.researchgate.net/publication/325202613_Indian_Juvenile_Depression_And_Future_Criminal_Behavioral_Forensic_Analysis_of_Udaipur_District_Population

Languages

Hindi
First Language
English
Proficient (C2)
C2

Affiliations

  • Singing
  • Poetry
  • Hiking
  • Coding

Timeline

Software Engineer

Optym India Private Limited
03.2023 - Current

Analyst - Data Science

Escalent Inc.
08.2021 - 12.2022

Marketing - Database Associate /Senior Associate

C V E N T India
07.2018 - 11.2020

B-Tech - CSE

Galgotias University

Higher Secondary - Physics, Chemistry, Maths And Physical Education

MDS Public School

Matriculation -

ST Teresa Vidya Deep School

Similar Profiles

CREATE PROFILE
LOKESH VAISHNAV