Prerna Sehrawat

Collaborating with clients to understand business requirements and translating the requirements to functional and technical designs for internal team. Attended key agile events such as planning, review and retrospect meetings for successful delivery of projects. Understanding of technical stack such as Front-end, APIs, Databases, Back-end.

Worked on industry project MARCO using OutSystems; developed the UI/UX designing; acquired skills in agile environment and analytics that include Data Visualization tools. Wrote SQL query as and when needed for MARCO module. Linked projects module with Tableau. Self-learnt and developed apps like IMDB Movie Database and Expenses Database App suitable for web, mobile and tab view using OutSystems and DBMS; added features like filteration, restriction of edit to viewers, input validation, and modeling updated data.

Engaged in level 1 projects related to Business Analysis – taking care of DataBase, performed analytics for dashboard. Made Employee directory for intern cohort group. Wrote SQL functions as and when needed on Project Module. Underwent behavioral and technical trainings and tests; topped batch for 2 English tests conducted by British Council.

Worked on “Control Office Application” (COA) project; also participated in UTS. Analyzed complex data of COA using SQL and charted the results in MS Excel to capture train movements in real time/ near real time. Worked on large dataset and extracted meaningful data from databases. Involved in improvisation of CRM tool for handling distressed calls for the RPF Security Helpline Department; worked on Decision Support System tool to keep log of the number of complaints received, analyzed and resolved. Developed Railway Management System Project: features like train schedule display and fare calculation, created admin and user mode to display details of passengers and trains.

Worked on projects like Business Analysis, Decision Tree Algorithm, and Supervised and Unsupervised Learning. Used business intelligence tools to analyze data from internal and external sources. Designed visualization interactive dashboards to identify trends and anomalies for data set. Created linkages to enable predictive modelling and trend analysis.

Developed front-end web application using HTML, CSS, and JavaScript for the Web Development department. Redesigned and developed an existing website for the organization. Assisted content team for making the best articles upon refined researching skills. Developed Weather Application using API calling – OpenWeatherMap Key; Integrated features like temperature, humidity, wind speed, UV index and developed it in front-end Web Development Stack.