Punita Dharod Email & Phone Number

• Cleaned data using Python and developed data models using Toad Modeler to store data based on well-defined business rules.
• Restructured the existing data pipelines to reduce the query response time by 13%.
• Designed and developed statistical models using operational data aimed and evaluating and improving performance by 20%.
• Collaborated with cross-functional business teams to identify performance metrics by conducting exploratory analysis in Tableau, consolidated 6 ad-hoc reports to reduce response time by 11 hours per week.
• Created scope statements, procedures and data flow statements to develop and maintain customer database.

• Guided security across all residence halls at the university and coordinated emergency response to ensure safety and security for all students which resulted in 10% higher student satisfaction.
• Analyzed employee feedback forms using R to identify problem areas and collaborated with executives to develop solutions and training models reducing employee errors by 7%.

• Enforcing Residential Life Rules and Protocols of controlled access to ensure a safe environment for students at their residence halls.
• Provide assistance and guidance to students in case with respect to campus directions, laundry services, facilities issues, lockouts, lost property, etc.
• Coordinate with the RSO Supervisors, NUPD, resident and/or RA in case of emergency.

• Developed macros in Excel to reduce the time required to develop trade worksheets per day by 18%.
• Implemented stored procedures in Netezza to detect recurring patterns and to identify the P/L of each trade.
• Analyzed time required to book each trade and identified factors causing delays and increased efficiency by 5%
• Automated weekly trade analysis reports using Tableau and reduced reporting time by 12%.
• Participated in Bloomberg terminal training sessions and SSU training sessions to learn about asset classes.

Mumbai Area, India

• Developed and redesigned dynamic, cross-browser compliant websites for 10 clients
• Appreciated for meeting the deadlines and attention to detail
• Features: Shopping cart, live streaming of videos/news, customized email and file sharing, 3D animations
• Technologies: JavaScript, JQuery, HTML5, CSS3, PHP, AJAX, XML, Spring MVC, Hibernate

• Analyzed real time data collected from various websites using Apache Hadoop, Hive and Flume
• Conducted sentimental analysis to parse through user reviews of the products and services and provide customer feedback to management that helped in increasing their profit by 15%
• Features: Visual statistics, email notifications, logs for all negative reviews and suggestions
• Technologies: Lexicon, Java, HDFS, Hive, Flume, MS Excel

Master'S Degree, Analytics

Master'S Degree, Management Information Systems, General

Bachelor'S Degree, Information Technology

Activities and Societies: Event head of IEEE Chapter