Aiswarya Venkadachalam
Data Analyst at Michigan Department of Education- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Michigan Department of Education
-
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.
-
-
-
Jackson
-
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.
-
-
-
Michigan State University
-
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.
-
-
-
Infotech Enterprises IT Services Pvt Ltd ( Infotech IT )
-
Software Development
-
300 - 400 Employee
-
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 -
Anna University
Bachelor of Engineering (B.E.), Aeronautical Engineering