Aiswarya Venkadachalam

Data Analyst at Michigan Department of Education
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Lansing, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Government Administration
    • 100 - 200 Employee
    • Data Analyst
      • Apr 2021 - Present

      • Supported project activities in data analysis and reporting for large-scale studies in education staffing data or student records data. • Identified and investigated data anomalies using logic and reasoning and provided technical support to education institutions. • Developed practical and creative solutions to address key issues, and took ownership of multiple special projects. • Profound experience in writing advance programs in SAS, R and STATA.

    • United States
    • Financial Services
    • 700 & Above Employee
    • Operations Business Process Analyst
      • Aug 2019 - Dec 2020

      • Evaluated and analyzed processes, workflows and tasks and identified opportunities for operational efficiencies. • Identified data requirements, complied and validated data to facilitate process improvement. • Developed SAS and R programs to perform advanced statistical calculations and provided recommendation for multiple product lines. • Assisted in developing highly complex Merit-Bonus (MB) model and collected information to process modifications suggested by senior leadership… Show more • Evaluated and analyzed processes, workflows and tasks and identified opportunities for operational efficiencies. • Identified data requirements, complied and validated data to facilitate process improvement. • Developed SAS and R programs to perform advanced statistical calculations and provided recommendation for multiple product lines. • Assisted in developing highly complex Merit-Bonus (MB) model and collected information to process modifications suggested by senior leadership team across Operations. • Translated MB model to SAS coding and performed detailed analysis to calculate associates yearly Merit and Bonus amount. • Responsible for Ad Hoc analysis to support MB activity and provided account balances by department. • Assisted in creating and testing MB Approval Tool for Department Heads and Directors review and approval. • Compiled summaries, reports, and maintained documentation files to support MB process. • Executed various cost analysis and provided guidance to enhance cost performance for related functions. • Provided forecasted volumes and expenses for multiple functions within Operations. • Investigated skill gap analysis and recommended management to shift resources between departments based on forecasted volumes and staffing availability. • Identified key characteristics and verified calculations for existing or acquired products. • Designed, developed and maintained dashboards using Tableau for Executive updates. • Identified and resolved issues in existing SAS codes and converted complex codes from R to SAS. • Provided on-call support for morning reporting issues related to Command-Center functions. • Manipulated and implemented object-oriented programming models.

    • Strategic Support Analyst
      • Jun 2018 - Aug 2019

      • Identified and analyzed data on resource trends and recommended areas of process improvements. • Developed Python and R programs for data study and presented data to identify trends. • Worked with Managers in development of Operational procedures and updating Budget Plan. • Estimated, compiled and provided forecasted volumes to Department Heads to decide on Budget allocations. • Collected information to process Budget modifications and Budget allocations. • Developed and… Show more • Identified and analyzed data on resource trends and recommended areas of process improvements. • Developed Python and R programs for data study and presented data to identify trends. • Worked with Managers in development of Operational procedures and updating Budget Plan. • Estimated, compiled and provided forecasted volumes to Department Heads to decide on Budget allocations. • Collected information to process Budget modifications and Budget allocations. • Developed and maintained Budget Tool using MS Excel for Department Heads review and approval. • Responsible for Ad Hoc and regression analysis, as assigned, to support Budget process. • Compiled yearly Budget reports, expense spreadsheets and maintained documentation files to support Budget activity. • Supported in design and implemented improvement plans to address key gaps in business execution. • Analyzed data to perform root cause analysis and resolved issues. • Processed support requests for technical assistance on wide range of issues related to Python and R. • Prepared summary tables and reports based on customer requirements. • Created process documentation for programs describing their functions and outputs.

    • United States
    • Higher Education
    • 700 & Above Employee
    • Research Assistant
      • Dec 2012 - Aug 2014

      • Proposed design optimization for joint structures to the Department of Defense, US. • Developed multi-scale finite element model and determined joint strength for different loading conditions. • Predicted joint efficiency by evaluating damage initiation and failure modes of composites using ABAQUS. • Determined effects of joints on structural capability. • Participate in research gathering discussion with project members along with other technical staff's in the team and set… Show more • Proposed design optimization for joint structures to the Department of Defense, US. • Developed multi-scale finite element model and determined joint strength for different loading conditions. • Predicted joint efficiency by evaluating damage initiation and failure modes of composites using ABAQUS. • Determined effects of joints on structural capability. • Participate in research gathering discussion with project members along with other technical staff's in the team and set priorities for the requirements. • Used Python to preprocess data and attempt to find insights. • Create high level design document (logical-physical interface) and detailed Technical specification document for Settlement & Reconciliation process. • Involved in unit testing task and integration testing process; Created unit test plan & results. • Analyze the existing system and identify the improvement areas for performance and integrity with other applications.

    • Teaching Assistant
      • Aug 2012 - May 2013

      • Fluid Mechanics Lab Assistant instructor, grader and project mentor for undergraduate students. • Help students with their lab requirements and update the staff with future requirements as needed. • Organized, checked and submitted all related paperwork.

    • Design Engineer
      • Jun 2008 - May 2009

      Client: BOEING • Performed fatigue and damage tolerance assessment of repairs on Boeing 747 aircrafts. • Examined crack growth analysis and computed inspection threshold using Boeing in-house software (DTANAL, JOLT and IDTAS). • Generated finite element model and determined structural capability of aircraft structures. • Ensured continued airworthiness to aircraft modifications and repairs. Client: MJET • Performed stress analysis for aircraft modifications and provided… Show more Client: BOEING • Performed fatigue and damage tolerance assessment of repairs on Boeing 747 aircrafts. • Examined crack growth analysis and computed inspection threshold using Boeing in-house software (DTANAL, JOLT and IDTAS). • Generated finite element model and determined structural capability of aircraft structures. • Ensured continued airworthiness to aircraft modifications and repairs. Client: MJET • Performed stress analysis for aircraft modifications and provided design support. • Predicted possible structural instabilities by determining load paths and regions of stress concentrations resulting from applied and induced loads in structural members. • Investigated failure mechanisms of aircraft structural members. Show less

Education

  • Michigan State University
    Master's Degree, Engineering Mechanics
    2012 - 2014
  • Anna University
    Bachelor of Engineering (B.E.), Aeronautical Engineering
    2004 - 2008

Community

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