A
Anviksha Gupta
About
Detail
Data Analyst
United States
Contact Anviksha regarding:
work
Full-time jobs
Résumé
Jobs
verified_user
0% verified
Data AnalystAllstateDec 2023 - Current (2 years 9 months)• Execute over 100 intricate SQL queries monthly to extract and manipulate investments data, ensuring precise and timely retrieval for comprehensive analysis and reporting. • Spearhead the innovative utilization of Tableau to visualize investment data, pinpointing key trends and identifying time-saving opportunities, resulting in a 15% reduction in future processing time. • Generate two detailed Tableau reports monthly that meticulously identify discrepancies in portfolio creation data.- Associate Data Solutions EngineerOracleSep 2021 - Aug 2022 (1 year)• Launched innovative data analysis initiatives on client datasets to extract valuable insights, employing advanced statistical methods and data visualization techniques, resulting in a 40% increase in data visibility. • Collaborated with three dynamic cross-functional teams to design and develop data solutions, streamline database management, and optimize ETL processes, leading to a 20% increase in data flow efficiency. • Delivered exceptional technical support to clients by resolving approximately 15 complex data-related issues weekly, facilitating seamless data implementation and maintenance on the Oracle Analytics Cloud for four clients.
- Financial Data Analyst InternBlackRockJan 2021 - Jul 2021 (7 months)• Automated Forex trading overdraft processes by engineering a sophisticated Python script, achieving an 80% reduction in processing time. • Developed and deployed a precise Python machine learning algorithm, predicting portfolio overdrafts with a remarkable 90% accuracy. • Utilized advanced SQL queries within Python scripts to efficiently filter tradable assets, enhancing data retrieval and analysis. • Gained comprehensive expertise in various financial concepts, with a strong emphasis on Forex trading and portfolio management principles.
- LData Analyst InternLarsen Toubro Infotech Ltd LTIMay 2020 - Jun 2020 (2 months)• Engineered an advanced Python script utilizing Natural Language Processing techniques to extract metadata from over 100 diverse data sources, including Excel, PowerPoint, and Word files, significantly enhancing data accessibility. • Developed a sophisticated content analysis system leveraging Python's NLTK library, effectively analyzing textual and image data, generating precise insights, and enhancing content strategy decisions. • Implemented cutting-edge machine learning models to identify significant trends and outliers in the extracted data, reducing the decision making process time by 20% .
Education
verified_user
0% verified
- Master of ScienceUniversity of Illinois ChicagoAug 2022 - Dec 2023 (1 year 5 months)
- Bachelor of TechnologyManipal Institute of TechnologyJul 2017 - Jul 2021 (4 years 1 month)
Projects (professional or personal)
verified_user
0% verified
- MMental Health Analysis• Managed a 6-member cross-functional team and coordinated with various colleagues towards the successful creation of a mobile application using the Oracle Analytics Cloud. • Utilized regression and K-nearest neighbor algorithms to generate results. • Enhanced user experience by integrating the data with Oracle Digital Assistant, creating a chatbot interface, and employed Agile methodologies to reduce development time by 20% .
- AAmerican Airlines Performance Analysis• Analyzed 5000+ flight records containing 50+ attributes to assess American Airlines' on-time performance. • Conducted competitor analysis with other airlines' performances, and crafted over 20 dashboards. • Produced Key Performance Indicators (KPIs) and customized business solutions addressing American Airlines' performance gap in comparison to other carriers.