Simran Bansal Email & Phone Number

Columbus, Indiana, Us

- Built a Power BI report to showcase monthly cost report summary which was scaled company-wide for 50,000+ employees - Reduced hours of weekly manual work by identifying process inefficiencies and implementing Robotic Process Automation (RPA) for redundant processes in-line with business requirements- Developed and enhanced 30+ end-to-end RPA automations that are currently in production environment while ensuring seamless implementation and continuous monitoring after roll-out phase- Managing and delegating RPA projects to developers from the initial design stage to the implementation stage using Agile project management tool- Jira- Creating and maintaining documents like Solution Design Document (SDD) and technical flow chart to support automations- Developing a consolidated platform using MS Power Apps for travel request forms and approvals across all departments

West Lafayette, In, Us

• Managing CIT council to ensure smooth planning and execution of events and recruiting students for different committees

West Lafayette, In, Us

• Engaging one-on-one with students to assist with topics including computer hardware, and operating systems and environment, while working with the lead professor and other teaching assistant to ensure collaboration in helping students• Grading assignments and exams of 300+ students, and providing constructive feedback for improvement

West Lafayette, In, Us

• Collaborated independently with companies to organize and host events on campus including info sessions for IT students

West Lafayette, In, Us

• Instructed students in C# fundamental software development concepts including problem-solving and algorithm development• Graded exams and weekly assignments of 100+ students, and provided constructive feedback for improvement

West Lafayette, Indiana, Us

• Fully committed to customer service to complete tasks including professionally booking customer appointments, empathetically resolving customer conflicts, and cordially greeting walk-in customers• Preparing paperwork meticulously to document data from medical records, check-in sheet, and daily pet appointments

Columbus, Indiana, Us

• Achieved second place in Cummins IT Innovation Challenge on "How IT can be more self-service" • Successfully delivered proof of concept of a cost-effective automated system to generate cost reports for 50,000+ employees• Replaced on-premise Oracle database with Azure database using tools like SQL Server Analysis Services (SSAS) to introduce cloud-based storage for large amounts of data to decrease costs and increase efficiency • Designed user-friendly reports and dashboards in Power BI to outline cost report details of employees

• Conducted pilot study on "Seedstages" employees to find best way to perform personality categorization on application users• Improved findings drastically of personality categorization on demographic of "Seedstages" application users• Identified categories of personality traits by building data models using clustering and association techniques • Gathered personality traits data and performed personality categorization using Jupyter Notebook

Toronto, On, Ca

• Led a team of software developer interns to maintain product quality by performing tasks including manual testing on live and beta versions of "Blowout" application and providing feedback on any bug issues or feature failures • Reported research and development for improvements and ideas for new application features by conducting research on the existing top mobile applications and their techniques to attract new users

West Lafayette, In, Us

• Received publication approval for research paper on "Experiences and Perceptions of Computational Science and Engineering”• Conducted data and bibliometrics analysis with using tools like R to analyze and interpret the demographic and buildup of CSE students and their backgrounds in relation to their choice of majors at Purdue university• Concluded the research with findings such as ‘38% of Computational Science and Engineering students built their informal background in the field through internet’ and ‘42% struggled with majority of the concepts or classes’

Seattle, Wa, Us

Managed the point of sale of the store efficiently to interact and serve the customers.Multi-tasked while being on customer support by maintaining inventory, customer issues, and cleanliness around the store.

Herndon, Virginia, Us

Designed and developed a potential website for a client using .Net to showcase the services their law firm provides.Implemented an interface for viewing lawyer profiles to match them with appropriate clients.

Managed the register orderly to serve and communicate with customers better.Maintained good food quality to maintain hygienic standards.Coordinated with supervisors, managers and other team members for efficient service.

Bachelor'S Degree, Information Technology

High School Diploma, Business/Commerce, General