Jinal Thosani

• Identified the risks that led to security breach at Sony Pictures Entertainment by conducting SWOT Analysis.
• Researched the risk management approaches like Risk Map and Cost Benefit Analysis and suggested contingency plans
• Documented the strategies used to mitigate this low frequency risk event by studying the governance structure

- Conceptualized a database system for SU Ride Services for better transport facilities within SU
- Designed the Entity-Relationship (ER) Diagram using MS Visio and programmed it using Microsoft SQ queries
- Developed 12 User interfaces and 10 business reports using MS Access for analyzing the most frequent pickup and drop points, most frequent user and most common routes used by students

• Extracted a million records from different sources to calculate the Net Promoter Score (NPS) as 69% for Hyatt Group
• Performed linear and non-linear regression analysis on the dataset using R to derive the factors affecting the score
• Provided recommendations to the client by generating visualizations using R packages (ggplot, ggmap, arules)

• Developed a marketing campaign plan to recruit students by identifying patterns from the past 11 years of data
• Analyzed the trends and patterns to estimate cost and cities for campaigning using Pivot tables and PowerPivot
• Used Google Analytics to measure the traffic by evaluating bounce rate, geographic locations, Google AdWords.
• Applied Cost Optimization techniques to reduce the campaigning costs by 10% by strategizing utilization of resources

• Developed Data Warehouse solution for student enrollment data by forming a data model using star schema
• Implemented ETL process using SQL Server Integration services and built MOLAP cubes by following Bus Matrix
• Designed the dashboard by defining the key performance indicators (KPI’s) using Power BI to report the findings

• Collected daily expenditure datasets consisting of over 1000 entries to determine the 10 basic key areas of expenditures of 2014
• Used analytical techniques like Pivot Table and Power Pivot using MS Excel to determine the expenditures from 2010-2014
• Performed basic computational scripting using R to generate visualizations to denote expenditures of US over age groups
• Created a dashboard to represent the visualizations using Tableau based on the key performance… Show more

• Collected daily expenditure datasets consisting of over 1000 entries to determine the 10 basic key areas of expenditures of 2014
• Used analytical techniques like Pivot Table and Power Pivot using MS Excel to determine the expenditures from 2010-2014
• Performed basic computational scripting using R to generate visualizations to denote expenditures of US over age groups
• Created a dashboard to represent the visualizations using Tableau based on the key performance indicators (KPI’s)
Show less

- Analyzed a dataset of 1000 entries over the globe to determine the 10 basic key areas of expenditures of 2014
- Used analytical techniques like Pivot Table and Power Pivot using MS Excel to determine the entity with the highest expenditures gender wise as well as age wise
- Coded using R to generate visualizations to analyze expenditures of US and defined the audiences and the story
- Created a poster to represent the visualizations using Watson Analytics and Tableau by plotting… Show more

- Analyzed a dataset of 1000 entries over the globe to determine the 10 basic key areas of expenditures of 2014
- Used analytical techniques like Pivot Table and Power Pivot using MS Excel to determine the entity with the highest expenditures gender wise as well as age wise
- Coded using R to generate visualizations to analyze expenditures of US and defined the audiences and the story
- Created a poster to represent the visualizations using Watson Analytics and Tableau by plotting tree maps and alluvial graphs
Show less

- Analyzed given requirements to document the Project Charter for the Middleware system for Sun Trust Bank
- Formulated Work Breakdown Structure (WBS) to produce Gantt Charts using MS Project to determine project deliverables by following the software development lifecycle (SDLC)
- Documented the Risk Mitigation Plan by assessing the likelihood of various risks using the Risk Register
- Scheduled the entire project using MS Project thereby calculating Average % Complete, the budget and… Show more

- Analyzed given requirements to document the Project Charter for the Middleware system for Sun Trust Bank
- Formulated Work Breakdown Structure (WBS) to produce Gantt Charts using MS Project to determine project deliverables by following the software development lifecycle (SDLC)
- Documented the Risk Mitigation Plan by assessing the likelihood of various risks using the Risk Register
- Scheduled the entire project using MS Project thereby calculating Average % Complete, the budget and the time frame of the project

Show less

- Proposed business canvas and business model for Pharma Care Limited thus defining its value propositions
- Created UML (Unified Modeling) Diagrams to depict the tracking system of individual components at Pharma Care
- Defined the cost required to build an IT system for products and services at Pharma Care thereby gaining ROI of 130%
- Formulated the Candidate matrix by defining the scores of various feasibility by comparing the cost of in-house vs. outsourced project.
-… Show more

- Proposed business canvas and business model for Pharma Care Limited thus defining its value propositions
- Created UML (Unified Modeling) Diagrams to depict the tracking system of individual components at Pharma Care
- Defined the cost required to build an IT system for products and services at Pharma Care thereby gaining ROI of 130%
- Formulated the Candidate matrix by defining the scores of various feasibility by comparing the cost of in-house vs. outsourced project.
- Performed Feasibility Analysis, Data Flow Modelling and Use Case Modelling to create an efficient IT solution
- Built the system by performing business data mapping and identifying all the business intelligence requirements
- Performed Root Cause Analysis (RCA) by creating the fish bone diagram followed by a 5 Why Analysis
- Documented various risks while developing the IT system using Risk Register and Performance Matrix
- Managed tasks associated with testing by developing test plans and writing test cases thereby performing cross impact analysis
- Communicated conceptual ideas and design rationale with the team and created 25 user interface mock-ups Show less

• Researched existing systems used for credit card fraud detection and presented a detailed comparison of techniques
• Designed and coded the system using Hidden Markov Model by proposing Fraud Detection System
• Applied the data mining technique of HMM to 500 datasets justifying minimum fault cases of overall 5%