Illinois Secretary of State

• Implemented the pivotal inclusion of ’X’ gender in ILSOS’s S&FR programs, modernizing data systems to reflect diverse gender identities and establishing Illinois as a leader in demographic data inclusivity.
• Demonstrated expertise in data management and analytics skills by leading the digital integration of SR22/26 files using OpenText with Illinois insurers. This enhanced data accuracy and efficiency in S&FR applications.
• Leveraged my proficiency in diagnosing and resolving complex technical issues, expertly analyzing, debugging, and testing enhancements prior to QA team handoff.
• Collaborated closely with managers and analysts to translate business needs into technical solutions, ensuring software projects were aligned with strategic goals.
• Led a high-impact data purging initiative, leveraging advanced SQL Queries to optimize and process millions of driving license records. Resulted in substantial enhancements in database performance within just two months.
• Designed and executed data analytics reports in PowerBI, extracting key insights from driving test data to inform strategic decisions and policy development.
• I'm a Contrator for ILSOS , Employer : VistalTech INC:

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