Hi, I’m
Lakshya Pant
Gurugram
Summary
Detail-oriented Data Analyst with over 2 years of experience in financial data analysis and business intelligence. Proficient in using Alteryx for data preparation and analysis, with additional expertise in Python, SQL, and PowerShell. Proven track record in regulatory reporting projects for branches, leveraging analytical skills to drive insights and support decision-making processes.
Overview
3
years of professional experience
1
Certification
Work History
Ai-On Tech Solutions Pvt. Ltd.
BI and Automation Engineer
04.2023 - Current
Job overview
- Launched 15+ automation projects using Alteryx, SQL, and Python, resulting in a total savings of 300 + man-days and enhancing operational efficiency.
- Developed and implemented automated workflows that streamlined existing reporting processes, reducing manual effort and minimizing errors.
- Created a proof of concept utilizing Python scripting to automate network credential changes via the Alteryx server API, improving security and operational workflows.
- Optimized SQL queries for faster data retrieval and enhanced reporting capabilities, contributing to overall productivity improvements.
- Led the automation of Regulatory ratio generation for the Singapore Branch, significantly enhancing compliance efficiency.
- Implemented auto-upload functionalities to seamlessly integrate generated reports into designated regulatory systems, achieving a total of 95 MD’s/Year.
- Contributed to the first phase of regulatory reporting project for Japan, streamlining data collection and analysis projects.
- Achieved savings of 30 MDs through automation, facilitating quicker turnaround times for regulatory reporting.
- MOSAIC Automation: Developed a transversal flow for the APAC region, facilitating comprehensive revenue and expenditure reporting, achieving a total time savings of 120 MD’s/Year.
- Maintained, debugged and optimized automation programs.
Ai-On Tech Solutions Private Limited
Internship
11.2022 - 03.2023
Job overview
- Developed advanced Excel skills, enhancing data analysis and reporting capabilities.
- Gained proficiency in Tableau, completing the Tableau Desktop Specialist Certification in January 2023.
- Acquired expertise in Alteryx, earning multiple certifications, including Alteryx Designer Micro Credentials and Alteryx Designer Core.
- Completed the Alteryx Designer Machine Learning Fundamentals certification, demonstrating a solid foundation in data-driven decision-making.
Education
University of Petroleum and Energy Studies (UPES)
B.Tech (Hons.) from Computer Science, Artificial Intelligence and Machine Learning
University Overview
GPA: 7.95 CGPA
Delhi Public School (Ghaziabad Society)
Intermediate from PCM
University Overview
GPA: 88.2%
Skills
- Strong verbal and non-verbal communication
- Collaborative teamwork
- Problem Solving
- Logical Reasoning
- Python (Intermediate)
- Alteryx (Proficient)
- SQL (Intermediate)
- PowerShell (Beginner)
- Machine Learning (Intermediate)
- Process improvement
Languages Known
English
Hindi
Certification
Alteryx Designer Core
Alteryx Machine Learning Fundamentals
Tableau Desktop Certification
Timeline
BI and Automation Engineer
Ai-On Tech Solutions Pvt. Ltd.
04.2023 - Current
Internship
Ai-On Tech Solutions Private Limited
11.2022 - 03.2023
Delhi Public School (Ghaziabad Society)
Intermediate from PCM
University of Petroleum and Energy Studies (UPES)
B.Tech (Hons.) from Computer Science, Artificial Intelligence and Machine Learning
Similar Profiles
MANIKANDAN KALIAPPANMANIKANDAN KALIAPPAN
NA at AI LEXICON TECH DEVICES Pvt .LtdNA at AI LEXICON TECH DEVICES Pvt .Ltd
Praveen MohanPraveen Mohan
Data Science Research Associate at Geeklurn AI Software Solutions Pvt. Ltd.Data Science Research Associate at Geeklurn AI Software Solutions Pvt. Ltd.
VANI TUMMALAVANI TUMMALA
Associate Data Analyst intern at SOCIALTEK AI & ML BUSINESS SOLUTIONS PVT LTDAssociate Data Analyst intern at SOCIALTEK AI & ML BUSINESS SOLUTIONS PVT LTD
ANAM KHANANAM KHAN
Advocate at Khan and AssociatesAdvocate at Khan and Associates
Amit MishraAmit Mishra
Chief Portfolio Manager-Herbicides at Dhanuka Agritech LimitedChief Portfolio Manager-Herbicides at Dhanuka Agritech Limited