Illinois Secretary of State

• Spearheaded the enhancement of the SFR application for ILSOS as the sole developer, improving system functionality and streamlining processes.
• Enhanced compliance and efficiency by refining electronic SR22/26 files for high-risk insurance (File transfers from Insurance companies) ; ensured accurate FTP transfers and regulatory adherence using UNIX and mainframe systems.
• Developed and implemented a nightly batch program to comply with FMCSA’s Drug and Alcohol Clearinghouse mandate, while also creating backend functionality for the driver’s facility application.
• Automated data refresh processes using stored procedures, reducing manual effort by hours and increasing efficiency.
• Designed and executed data analytics reports using SSRS and Power BI, extracting key insights from driving test data to inform strategic decisions and policy development.
• Led a data purging initiative using advanced SQL and Azure Databricks to process millions of driving license records, en-hancing database performance and data processing capabilities within 3 months and enabling advanced analytics.
• Contrator for ILSOS , Employers : VistalTech Inc (Sept 2023 - May 2024), MSR Technology Group LLC (June 2024 - Current)

Community Dreams Foundation

• Spearhead a data research analyst team, conducting comprehensive assessments and analyses of energy-related data.
• Employ advanced statistical models and visualization techniques to uncover trends, patterns, and insights within extensive datasets, encompassing energy consumption, renewable sources, and environmental impact.
• Collaborate extensively with energy experts, policymakers, and community stakeholders, translating data insights into actionable recommendations for optimizing energy efficiency and fostering sustainable practices.
Tools: Python, SQL, Excel, Selenium, Node.JS, Data visualization, Databases

University at Buffalo

• Collaborated with professor in developing assessments and projects, while providing ongoing guidance and support to 150+ students throughout the coursework (Fundamentals of Computational Science), resulting in enhanced learning outcomes and academic success.
• Facilitated Weekly Office Hours to address student inquiries and clarify any doubts in solving Assessment’s (Python) and Projects.
• Professor: Dr. Han Daozhi , UB Mathematics Dept, Course: CDA 511, Fundamentals of Computational Sciences

Tata Consultancy Services

• Conducted data analysis using BigQuery, performing complex SQL queries and advanced analytical functions on datasets of up to 100 million records, uncovering actionable insights for business decisions.
• Developed data pipelines and ETL processes using GCP services such as Dataflow and Cloud Storage, automating data ingestion, transformation, and loading into BigQuery, resulting in a 50% reduction in data processing time.
• Collaborated with cross-functional teams to understand business requirements, delivering data models and analytical solutions that improved operational efficiency and drove a 15% increase in revenue.
• Developed custom data visualizations and dashboards using Data Studio (Looker),Python libraries (such as Matplotlib, Seaborn, or Plotly) and tools like Data Studio, presenting complex data analysis results to 50+ stakeholders in actionable manner.
• Designed and optimized data models in BigQuery, implementing schema design, partitioning, and clustering strategies, resulting in a 30% improvement in query performance and a 20% reduction in storage costs.
• Documented data analysis methodologies, processes, and findings creating 20+ comprehensive reports for stakeholders .
• Tools: GCP, BigQuery, Python, SQL, Excel, ServiceNow, Data visualization, Databases

Chegg

• Demonstrated expertise in Caculus by providing accurate and comprehensive solutions to student questions on the Chegg platform.
• Maintained a high customer satisfaction rating by delivering prompt and insightful responses to student inquiries, fostering a positive learning experience.
• Subject: Engineering Mathematics (calculus)

Adroit IT Solutions

• Analyzed clients data sets using Python libraries, SQL queries, and Tableau to create interactive dashboards.
• Developed and implemented machine learning models to solve complex business problems.
• Conducted exploratory data analysis on large datasets to identify patterns and trends.
• Implemented data validation checks, reducing data entry errors by 30% and enhancing overall data quality.
Tools: Python (Pandas, Numpy,Matplotlib, Seaborn), SQL, Tableau, Statistics

Bharat Dynamics Limited

• Leveraged advanced programming skills in CNC (Computer Numerical Control) to develop and optimize precise machining instructions for a critical component in the Akash missile using a turn mill center.
• Applied data analysis techniques to evaluate and refine machining parameters, ensuring optimal efficiency, accuracy, and quality in the production process.
• Utilized statistical methods and process control techniques to identify and address potential sources of variation, minimizing defects and enhancing overall product performance and reliability.
• Documented programming methodologies, process parameters, and best practices, creating a knowledge repository to support future production and maintenance activities.
• Tools: CNC programming (G, M codes), ANOVA, Taguchi DOE, Excel

Languages and Databases

Python

R

Java

MySQL

PostgreSQL

Shell Scripting

MATLAB

Libraries

NumPy

Pandas

OpenCV

scikit-learn

matplotlib

Seaborn

Pydeck

ImageIO

GeoPy

Folium

Frameworks

AirFlow

Kafka

Spark

Keras

TensorFlow

PyTorch

Other

Git

AWS

Heroku

Databricks

Tableau