Open to opportunities

Ananya Malhotra

@ananyamalhotra

Message

Analytical data enthusiast with expertise in SQL and Python.

India

Message

What I'm looking for

I am looking for a role that fosters growth, encourages innovation, and values collaboration within a dynamic team.

I am an analytical and curious data enthusiast with a strong foundation in open-source technologies, statistical analysis, and visualization. My experience includes building data pipelines and dashboards using SQL, Python, and various open-source libraries. I am passionate about solving real-world problems through clean, interpretable, and reproducible data solutions.

Currently, I work as an Associate Engineer at L&T Technology Services, where I have automated data migration processes and developed VBA macros for enhanced decision-making. My previous role as an Analyst at Siemens allowed me to contribute to open documentation practices and implement workflow automation, significantly reducing manual intervention. I thrive in environments that challenge my problem-solving skills and allow me to leverage my technical expertise.

Experience

Work history, roles, and key accomplishments

Current

Associate Engineer

Current

L&T Technology Services

Sep 2024 - Present (10 months)

Automated data migration processes using shell scripting and SQL-based workflows to increase efficiency. Developed and optimized VBA macros to generate graphical representations and dashboards for enhanced clarity and decision-making.

SQL Python Power BI VBA Pandas NumPy Shell Scripting Data Migration Data Visualization ETL

Analyst

Siemens

Jul 2023 - Aug 2024 (1 year 1 month)

Contributed to open documentation practices to maintain transparency in code workflows and dashboard environment. Crafted and executed SQL and Python scripts to automate data cleanup processes and reduce manual intervention.

SQL Python Data Validation Workflow Automation Backend Development Query Optimization Documentation Data Cleaning

Analyst Intern

FiftyFive.ltd

Built visualizations using Python libraries and generated reports in open formats (CSV). Supported business teams with ad hoc data analysis using Jupyter and Git version control.

Python Jupyter Git Data Extraction Data Cleaning Data Visualization Reporting Technical Support

Education

Degrees, certifications, and relevant coursework

Chitkara University

Bachelor of Engineering (BE), Computer Science

Grade: 9.77/10

Activities and societies: Volunteer: Data projects for NGOs, Silver Medal Math and Statistics Olympiad

Studied Computer Science with a focus on data analysis and open-source technologies. Gained strong foundational knowledge in statistical analysis, visualization, and building data pipelines.