Lakshya Rathore

Contributor Insights – Donor Analytics at Civix Designed and built Contributor Insights, an AWS-powered data pipeline that tracks millions of political contributions from individuals and corporations. Tech Stack: AWS Glue, Entity Resolution (ML), Step Functions, S3, Crawlers, Data Catalogs. Impact: Enabled deep donor analytics, anomaly detection, and simplified data handling for hundreds of thousands of donors. Visualization: Built dynamic QuickSight & Power BI dashboards for tracking contributions by party, cause, and anomalies. Data Optimization & ETL Migration – OnRamp Project Optimized 100+ tables across multiple databases with 200M+ voter records, improving query efficiency and system performance. ETL Migration: Led the transition to PostgreSQL (pgAdmin) via AWS Glue, ensuring seamless data integration from legacy databases. Impact: Enhanced data integrity, query performance, and accessibility across development and QA environments. ETL Pipeline for Structured Data Transformation in AWS Developed an end-to-end ETL pipeline for transforming fixed-width Oracle data into structured formats for analysis and reporting. Tech Stack: AWS Glue (crawlers, workflows), PySpark, PostgreSQL, Step Functions, Lambda. Traceability: Built a custom audit system to track transformations and history. Impact: Streamlined data processing for two major states, significantly improving data accessibility and reporting.

Leveraged machine learning and analytical skills to tackle fraud detection, developed a Common Data Format for Election Data, and visualized data effectively. • Applied machine learning and analytical skills to tackle anomalous data for fraud detection. • Developed a Common Data Format (CDF) for Election Data to simplify data exchange between voting systems. • Utilized Python and R libraries to visualize data effectively.

-Successfully tutored a class of over 200 students in "Introduction to Security," enhancing their understanding of the subject matter. -Provided valuable assistance to Professor McAlpin in various Computer Science subjects, contributing to the overall learning experience of the students. -Developed and refined my presentation, leadership, and teaching skills through this tutoring role. -Demonstrated a strong commitment to facilitating student success and fostering a positive learning environment.

-Successfully developed projects such as Bengaluru House Price Prediction, Image Classification, Telegram bot, and more, utilizing Machine Learning, Deep Learning, SQL, Python, R, MongoDB, HTML, CSS, and other relevant technologies. -Applied my expertise in Machine Learning and Deep Learning to create accurate and efficient solutions for real-world problems. -Leveraged my skills in SQL, Python, R, MongoDB, HTML, and CSS to handle data manipulation, web development, and database management aspects of the projects. -Developed and honed valuable skills like event organizing, teamwork, and communication in a professional work environment. -Proven ability to deliver high-quality projects while collaborating effectively with colleagues and stakeholders. -Demonstrated a passion for learning and staying up-to-date with emerging technologies and trends in the field.

-Obtained professional experience in the telecommunication sector, focusing on projects involving 3G and 4G technologies, data encryption, decryption, and secure data transfer. -Developed expertise in telecommunications protocols and technologies, ensuring smooth and secure communication channels. -Contributed to projects involving data transfer and encryption, prioritizing the integrity and confidentiality of sensitive information. -Demonstrated a proactive approach to learning and adapting to advancements in telecommunications technology.

-Played a pivotal role in serving the underprivileged section of society by providing essential services such as free education, medical facilities, and raising awareness on critical issues. -Assumed a leadership position within a non-profit organization, leading a team of eight individuals responsible for managing and implementing various initiatives. -Successfully coordinated efforts to deliver impactful programs and initiatives that positively impacted the lives of those in need. -Demonstrated a strong commitment to social responsibility and making a difference in the community. -Developed and refined leadership, team management, and organizational skills through this role. -Actively contributed to creating a positive and sustainable impact on the lives of individuals and the community as a whole.