Project Sales

SONALI GURNASINGHANI

929-***-**** New Jersey, ***06 *******************@*****.*** linkedin.com/in/sonaligurnasinghani

(Tableau Profile: tableau.com/profile/sonali7984 )

EDUCATION

Pace University, Seidenberg School of Computer Science and Information Systems New York NY

Master of Science (MS) in Information System GPA: 3.6 May 2019

University of Mumbai Mumbai, India

Post Graduate Diploma in Financial Management Percentage: 83% June 2016

University of Mumbai Mumbai, India

Master (M.com) of Commerce Minor: Management Percentage: 70% June 2015

V.E.S College of Arts Science and Commerce, University of Mumbai University of Mumbai Mumbai, India

Bachelor of Management Studies (BMS) Minor: Finance Percentage: 70% June 2013

RELATED COURSES

DBMS Database Web and Development Database Warehousing, Mining and Visualization IS Design and Development IS Project and Change Management UIUX Marketing Research Bigdata Visual Design to Technology

TECHNICAL SKILLS

Programming Skills: SQL, Java, R Programming

Statistical and Analytical Tool: Tableau, Microsoft Power BI, SPSS, Microsoft Excel, Google Analytics, QlikView

Database: MySQL, Oracle 11g, Microsoft SQL Server

Tools: JIRA, MS VISIO, Rational Rose, Microsoft Office, Confluence

Methodology: Agile, Scrum, SDLC

Certification: Fundamentals of Visualization with Tableau, Agile Scrum Training

WORK EXPERIENCE

Konark Urban Co-operative Bank Ltd. Mumbai India

Analyst Oct 2014-May 2017

Collaborated with stakeholders to gather requirements, analyzed them to deliver SDLC artifacts like Business Requirement, Functional Requirement, Business Process Models, UML diagrams Use Cases, Work Flows, Flow Charts, Sequence diagrams, Activity diagrams, Requirement Traceability Matrix, and Business Case models after accessing the scope and status of the project

Developed and maintained SQL scripts and modified database schema which increased efficiency up to 25%

Supported UAT from the functional side for suggesting solutions and workarounds for resolving time-bound production issues

Designed excel templates using advanced excel functions (Pivot table, VLOOKUP, Charts, Analysis, Power view, VBA & Macros)

Worked extensively in an agile/scrum environment for creating and grooming User Stories, Epics on JIRA Board and maintaining and prioritizing the product backlog, highlighting project risk and deadlines and tracked project milestones

Involved in Test Planning, Test Preparation, Test Execution, and Issue Resolution and Report Generation to assure that all aspects of a Project follow the Business Requirements

ACADEMIC PROJECTS

Global Super Store Analysis (Tableau Profile: tableau.com/profile/sonali7984 )

Utilized Tableau for data exploration to understand dive deeper into the data and look for patterns and created dashboard reports on how different markets affect various customer segments

Identified strong regions and products which increased sales by 30% and overall profit by $2M.

GNYIC – HR System (Microsoft Project)

Built charter using MS Project and Visio by defining goals, objectives, assumptions, and risks to improve systems

Evaluated a project plan by establishing a Work Break Down Structure to estimate budget

Black Friday Data Analysis Using R and Tableau

Performed data cleaning, imputed missing values, normalization and scaling to create a concise and clean dataset using R

Implemented K-means clustering analysis to find the optimal number of clusters. Integrated R model with Tableau and visualized which cluster ensures higher probability of survival. Achieved an accuracy of 81.9% libraries: Tidy verse, gg plot

E-Pass Mobile App (User Experience Design app)

Conducted research and created personas, user-flows, scenarios, wireframes numerous prototypes of varying fidelity for usability testing and findings

Designed and developed a mobile application for user with the help of Sketch and OmniGraffle

ACTIVITIES

Talentia V.E.S College Arts Science and Commerce, Core Committee Member, Dec 2012 Public Relationship Head, Dec 2011

Confluence V.E.S College Arts Science and Commerce, Public Relationship Head, April 2012

Contact this candidate