Analyst

Ronak Sandeep Talati

Mobile:469-***-**** Email:***********.**@*****.*** LinkedIn: https://in.linkedin.com/in/ronaktalati

EDUCATION

M.S., Management Information System GPA 3.33

The University of Texas at Dallas, TX May 2017

B.E., Computer Science GPA 3.50

University of Pune, MH, India May 2015

TECHNICAL SKILLS

Technologies: C, C++,Java/ J2EE, JSP & Servlets, HTML5, CSS, JavaScript, PL/SQL, Python, D3, R, SAS

Data Base: Oracle 10g, MySQL, Microsoft SQL Server, MongoDB

Tools/ Eclipse, Netbeans, Dreamweaver, Visio, Excel, Word, Powerpoint, R Studio, Tableau, TIBCO Spotfire, QlikView,

Methodologies: Gephi, SAP Lumira, SAS Enterprise Miner, Base SAS, SSIS, SSRS, Weka, Google Analytics, Data Warehousing, Data Visualization, System Analysis, SDLC, RAD, Agile Project Methodology

Certifications: Google Analytics, SAS Institute Certificate in Business Intelligence and Data Mining

EXPERIENCE

Data Analyst

Molabs Media, Dallas, TX Dec 2015 – May 2016

•Worked with client data sets to generate insights on new business initiatives and marketing strategies

•Identified and extracted relevant data from large data sets using data reduction and mining techniques

•Performed statistical modeling and data analysis using MS Excel to understand customer characteristics

•Trend analysis on retail metrics, especially relating to driving sales revenue, customer retention and sale person productivity

•Analyzed the customer activities for 10 clients and proposed marketing strategies to mitigate any adverse impact of loss

Responsibilities:

•Use of PIVOT TABLES, PIVOT CHART, VLOOKUP and other Excel functions to reform the data in a useful format for clients

•Gather information from various sources that might help better understand data and then study the information to find a solution

•Perform different types of analysis, Identify and interpret patterns and trends, assess data quality and eliminate irrelevant data

•Generate comprehensive reports to communicate the result of analysis to decision makers and those affected by the result

•JOIN tables in Tableau, study different marketing strategies based on various constraints and create meaningful dashboards

Business Analyst Intern

HCL Infosystems Ltd., Pune, MH, India Aug 2013 - Jul 2014

•Gathered business and technical requirements and acted as a liaison between the business user group and the technical team

•Created Use Cases, Sequence Diagrams, Activity Diagrams and Workflow Process Diagrams using MS Visio

•Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and documented them in a format that can be reviewed and best suit the needs of both business and technical team

•Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements

•Provided support in conducting UAT, developed test strategies, test cases, test plans, defect reports, Traceability Matrices and test environments and managed the testing process, bug reporting and analysis of test results

Responsibilities:

•Act as liaison between the client and technical team, define project requirements by identifying project milestones and phases

•Gather requirements in various ways like One-to-One Interviews, JAD sessions, Group meetings, Emails and also Calls

•Creating, analyzing, and validating detailed functional requirement specifications, Design Use Cases and UML diagrams

•Ensure that the implementation team has all of the details they need to build or implement the solution for the client

•Provide support throughout the Implementation process and also participate in various phases of testing including UAT

PROJECTS

Mortality Analysis with SAS EM and Tableau, Web Analytics Jan 2016 - Mar 2016

•URL: https://public.tableau.com/profile/ronak.talati#!/vizhome/DeathAnalysisinUS/DeathAnalysis

Predictive Stock Trading using SAS, Data Visualization Aug 2015 - Nov 2015

•Implemented PCA and Regression Analysis in SAS to analyze historical stock prices of three companies over 10 years

Flight Delay Analysis with Business Intelligence solution, Business Data Warehousing Aug 2015 - Nov 2015

•Consolidated data from diverse sources in a uniform SQL Server 2005 database, ETL capabilities of SSIS were implemented

ORGANIZATION

Intelligence Analytics Society, UT Dallas, Auditor and Treasurer Nov 2015 – May 2016

•Database monitoring in MS Excel, Organized SQL, QlikView and Tableau Workshops, Motivated and Encouraged new students to contribute their skills. Enhanced my leadership and communication skills and gained technical knowledge in various domains

Contact this candidate