Business Analyst, Business Intelligence, Tableau Developer

Sushant Sunil Jain

469-***-****; *******.********@*****.***; http://www.linkedin.com/in/sushantsjain EDUCATION

The University of Texas at Dallas May 2017

M.S., Information Technology and Management (ITM) 3.60 University of Mumbai, India August 2014

B.E., Computer Engineering 3.65

CERTIFICATIONS & TECHNICAL SKILLS

Languages: SQL, Java, Python, C++, HTML, CSS, XML, R Database: Oracle, MySQL, Teradata

Reporting/ Analytical Tools: Tableau, SAP WebI, SAS miner, Alteryx, Qlikview, Qliksense, Gephi, SSAS, SSRS Software/ Applications: SQL Server Management Studio, Clarity, SAP R/3, CA ERwin, MS Visio, Eclipse, SSIS, Powercenter MS Office including proficiency in MS Excel (Pivot, VLookup, Macros, VBA) Certification: Google Analytics Individual Qualification, Google AdWords Fundamental Exam, Oracle Database 11g- SQL Fundamental 1, Creating Interactive Dashboards in Tableau, Scrum Master Certified EXPERIENCE

Novartis Pharmaceutical Company – Fort Worth, Texas May 2016 – August 2016 Business Intelligence and Analytics Intern

• Led communications across managerial level stakeholders across the globe to gather design requirements to help improve data quality and operational effectiveness for a global consolidation of various in-house applications

• Created reports for senior management using SAP BO (BOBJ), SAP WebI, Excel and Clarity to reconcile the forecast budget data for 800+ applications and 1400+ projects

• Designed dashboards in Tableau that helped senior management monitor project flow activities within the organization

• Developed processes to ensure optimum transition and operational stability to track vendors using SharePoint Capgemini – Mumbai, India June 2014 – June 2015

Data Business Analyst for US Based Tier 1 Marketing Firm

• Developed and executed code migrations and deployment over various client’s databases and web servers to help create a larger online footprint in their marketing campaigns using SDLC Agile methodology

• Analyzed, monitored and reported on the various change management processes at each stage of the product development life cycle by performing unit testing

• Designed and developed stored procedures, queries and views necessary to support SSRS reports

• Created SSIS Packages to ETL existing data into SQL Server from different environments that helped automate the report generation process

• Developed a hosting server for the off-shore team that improved deployment time by 50% and reduced costs

• Performed data analysis on the large data sets to extract information of the campaign benefits Chhajed and Doshi – Mumbai, India January 2013 – June 2014 Reporting Analyst

• Designed ER diagrams and Star-schema based data models to aid in data collection to be used for Tableau visuals

• Interacted with firm partners, employees, clients to analyze business needs and developed technical specifications

• Developed Tableau workbooks to perform YOY, Q/Q, YTD, QTD and MTD type of analysis to keep a track of the progress

• Restricted data for users using Row level security and User filters and also presented case by case Tableau stories ACADEMIC PROJECTS

Visualizing Consumer Complaints using Tableau August 2016 – October 2016

• Analyzed and preprocessed data sets of various consumer complaints and its correlation with population census using ‘R’ that helped vendors track different consumer demographics

• Designed and built dashboards by analyzing data that helped vendors recognize customer complaints across industries Bombay Stock Exchange Predictor, Business Intelligence Software and Techniques August 2015 – December 2015

• Developed predictive models using 10 years of historical data for 15 companies to predict their “next day high”

• Analyzed data and performed statistical analysis by implementing Linear Regression and Neural Networks to draft solutions LEADERSHIP ROLES AND ACTIVITIES

Toastmasters International, USA – Area Director June 2016 – Present ITM Student Leadership Council, UT Dallas – Council Member January 2016 – June 2017

Contact this candidate