Analyst
no image
Analyst

Manisha Nayar ------------
MN------------
------------/in/manishanayar90
------------/@mnayar90
Experience Summary
Highly motivated Data Analyst to support business decisions with an emphasis on project management. Well versed with an array of analytical tools like Python, MS Excel, My SQL, Tableau, and Project Management tool MS project.
Professional experience
Trainee Data Analyst | Presentation Convent School
Lead team of five, and responsible for digitalizing the library Jan ‘14-Apr ‘14
• The project aimed at digitalizing a library to easily locate books and other materials such as newspapers, magazines, and research articles.
• Responsible for adding records for25,000 books in LYBSYS (library management software)
• Trained the school staff to work on the software that increases the efficiency of issuing books
• Created dashboards to analyze the health of the organization
Data Analyst Associate | Lotus Pharmaceutical
Responsible for making dashboards and providing insight to the executives Jun ‘12-Jan ‘14
• The project was to create dashboards for business decision making in Excel
• Responsible for targeting customers for various discount coupons offered by the company and evaluated the performance based on the acceptance/usage of the coupons and performed data mining
• Created dashboards monthly and presented insights about the performance of the leadership that derived many strategic decisions
Academic projects
UCI Breast Cancer Prediction Model
The project is to predict cancer in the patient by using different classification models Sept ‘18-till
• Extracted, cleaned and prepared data in Python and featured engineered the data
• Created a model to predict breast cancer in patients, using 11 attributes and data for 699 patients, with an accuracy of 97% by using KNN, Naïve Bayes, Decision Tree, and Random forest models.
Project Tableau | Vertex Pharmaceuticals
Lead the team of five, and responsible for creating dashboards and elicitation Feb ‘18-Mar18
• Worked on SQL queries in accessing data from database and loading data
• Created a rich interactive dashboard using desktop tableau and prepared user stories to create a compelling dashboard to deliver actionable insights.
• Responsible for interaction with business for requirement gathering
• Created visualization for company’s audit process and department analysis
Project Manager | SpotMini Project
Lead of a team of four, and responsible for end-to-end execution including planning, scoping and delivery Feb ‘18-Mar ‘18
• Facilitated the requirement collection phase to ensure business needs alignment
• Worked with a cross-functional project team to develop the project scope statement such as development, QA, BA, and Business
• Utilized Microsoft Project to manage the project schedule and budget
• Created the Gantt Chart for visualization of timelines of the project
• Utilized earned value management (EVM) to monitor and control the project scope, schedule & budget
Project SQL | Individual Project Jan ‘17-Apr ‘17
Utilized MySQL to write queries using joins, grouping, nested queries and aggregations
• Performed analysis and presented results using MySQL
• Imported, exported and manipulated large data sets in the multi-million-row database under tight deadlines
• Wrote stored procedures, functions, and joins
Education & Certifications
SQL, Tableau
Master of Professional Studies in Informatics Expected Graduation March 2019
Bachelors and Master of Arts
Analytical tools MS Excel, SQL, MS Access, Python, Tableau