Neelam Arya

Data Analyst at Auxilior Capital Partners, Inc.
  • Claim this Profile
Contact Information
Location
Philadelphia, Pennsylvania, United States, US

Topline Score

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 1 ratings
  • (1)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

You need to have a working account to view this content. Click here to join now
Pratyancha P.

Neelam is kind, considerate, and earnest. She is always eager to help, handles challenges with a lot of patience, and gives her 100% no matter what. She's well-versed with most BI related tools and is always open to questions and receptive to feedback. I am fortunate to have worked with her and learned form her industry experience.

0

/5.0
/ Based on 0 ratings
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

No reviews to display There are currently no reviews available.
You need to have a working account to view this content. Click here to join now

Experience

    • United States
    • Financial Services
    • 1 - 100 Employee
    • Data Analyst
      • Jun 2023 - Present

      Automated data validation, null value notifications, and credit reports, enhancing data accuracy and saving valuable time. • Integrated Finance fields into Data Tape, optimized SQL queries, and developed a user-friendly Power BI dashboard, enabling better insights and informed decisions. • Simplified import file handling for DataScan using Power Automate and SFTP, improving operational efficiency and system stability. • Established GitHub for version control, expanded Data Tape functionality, and maintained comprehensive automation documentation, fostering teamwork and knowledge sharing. • Created a dedicated SQL Data Tape for Bank, implemented Python scripting for the data tape, and designed Borrower's KPI dashboard, using it, contributing to innovative solutions and improved data management. Show less

    • Graduate Teaching Assistant
      • Sep 2022 - Mar 2023

      The role includes conducting recitation sessions for undergraduate students and helping them navigate practical applications of information systems in MIS 200, under the mentorship of the course instructor, Prof. Samir Shah, and Prof. A J Raven • Taught undergrad students about how MIS can support business operations, management, decision-making, and generate value. • Assisted students with MS Excel and MS Access to develop management information systems skills. The role includes conducting recitation sessions for undergraduate students and helping them navigate practical applications of information systems in MIS 200, under the mentorship of the course instructor, Prof. Samir Shah, and Prof. A J Raven • Taught undergrad students about how MIS can support business operations, management, decision-making, and generate value. • Assisted students with MS Excel and MS Access to develop management information systems skills.

    • United States
    • Rail Transportation
    • 700 & Above Employee
    • Data Analytics Intern
      • Jun 2022 - Mar 2023

      • Used Tableau and Python to analyze rule violation data, generating predictive patterns and cause-effect relationships, resulting in a 30% reduction in repeated incidents. • Built Power BI reports that simplified complex information and KPIs for stakeholders, reducing the team's analysis time by up to 96%. • Implemented PowerApps, reducing form submission and processing time by 15%, minimizing errors, and enabling real-time data access. • Automated rule approvals using MS PowerApps and Power Automate, increasing process accuracy by 70% and reducing the time by 45%. Show less

    • Graduate Teaching Assistant
      • Mar 2022 - Jun 2022

      Role includes conducting recitation sessions for undergraduate students and help them navigate course MIS 200 (Management Information Systems) in collaboration with the course instructor, Prof. AJ Raven • Taught undergrad students about how MIS can support business operations, management, decision-making, and generate value. • Assisted students with MS Excel and MS Access to develop management information systems skills. Role includes conducting recitation sessions for undergraduate students and help them navigate course MIS 200 (Management Information Systems) in collaboration with the course instructor, Prof. AJ Raven • Taught undergrad students about how MIS can support business operations, management, decision-making, and generate value. • Assisted students with MS Excel and MS Access to develop management information systems skills.

    • India
    • Business Consulting and Services
    • 700 & Above Employee
    • Senior Technical Consultant
      • Apr 2021 - Sep 2021

      In addition to my previous responsibilities, I was entrusted with the task of leading a team of two members, providing them with training and oversight to ensure their work was of the highest quality. Furthermore, I served as a technical support consultant, managing two accounts and catering to their specific needs.During this period, I accomplished the following deliverables:• Successfully integrated a third-party .Net web application with Microsoft ERP.• Designed and developed a SQL Server database and .Net Framework-based website.• Developed multiple business reports in Microsoft ERP.• Effectively integrated e-invoicing with the ERP system using .Net framework, enabling the solution to send invoices to the government tax portal, acquire signatures, and store digital signatures and QR codes in the ERP.• Built a timesheet portal in PowerApps that interacts with two ERP systems, leveraging project and resource management modules, which saved $30000 in licensing costs through integration.• Developed an expense management application in PowerApps that facilitated employee expense claims via a web application. Show less

    • Associate Consultant
      • Jul 2019 - Mar 2021

      In addition to developing new functionalities, I was entrusted with the management of a business account, serving as the primary point of contact for all case-handlings and support requests.During this time, I accomplished the following deliverables:• Designed and developed a planning solution for a supply chain customer that predicted the planned purchase quantity of an item based on various factors such as sales forecasts and seasonality, resulting in a 20% increase in accuracy for purchase planning activity and a 40% reduction in manual intervention.• Designed and developed a cycle count solution for inventory management in a warehouse module in the ERP software. The solution generated a list of items to be counted each day based on various parameters such as frequency of sale, perishability, expiration date, etc., resulting in an 80% automated solution as opposed to the entire inventory management process being conducted in Excel.• Successfully integrated e-invoicing with the ERP system using .Net framework, allowing the solution to send invoices to the government tax portal, acquire signatures, and store digital signatures and QR codes in the ERP.• Utilized Azure cloud technology to automatically generate critical reports from the system and save them directly to the cloud. Show less

    • Software Engineer
      • Jul 2018 - Jul 2019

      In my capacity as a developer, I thoroughly examined and assessed the Functional Design document, and proceeded to implement ERP functionality in accordance with specifications, utilizing programming languages such as C/AL, AL, C#, and HTML.I also conducted comprehensive technical testing of the newly developed feature before delivering it to the functional team for business-specific testing.

    • Trainee
      • Jul 2018 - Sep 2018

      During the training period, we were taught web development in .Net Framework, we achieved the target in C#, HTML and Javascript in Visual Studio Environment. We got familiarized with Web API, ASP. Net, WCF.

    • Intern
      • Aug 2017 - Sep 2017

      Worked as a senior content development expert, I researched about certain topics in mathematics and then created content in an elaborated manner for the online audience. Worked as a senior content development expert, I researched about certain topics in mathematics and then created content in an elaborated manner for the online audience.

    • Intern
      • Jun 2017 - Jul 2017

      I worked as a content developer. I would provide solutions to mathematical problems, and also develop the solutions using a software called 'Mathtype' I worked as a content developer. I would provide solutions to mathematical problems, and also develop the solutions using a software called 'Mathtype'

Education

  • Indian Institute of Technology, Guwahati
    Master of Science, Mathematics and Computer Science
    2016 - 2018
  • Drexel University's LeBow College of Business
    Master of Science - MS, Business Analytics
    2021 - 2023
  • Miranda House University of Delhi
    Bachelor's degree, Mathematics
    2013 - 2016
  • Jawahar Navodaya Vodyalaya, Haridwar
    Senior secondary, Science stream( Mathematics, Physics, Chemistry, English and Computer science)
    2012 - 2013
  • Jawahar Navodaya Vidyalaya, Haridwar
    Secondary, Science, Maths, English, Hindi and social science
    2010 - 2011

Community

You need to have a working account to view this content. Click here to join now