Microsoft Office Data, R, Tableau, Python

Tejanshu Salaria

**A Pierce avenue Jersey City, New Jersey 07307

Contact: 346-***-****, ********@*******.***, https://in.linkedin.com/in/tejanshusalaria EDUCATION

Stevens Institute of Technology, Hoboken, New Jersey Aug’16 - May’18

Master of Science in Information Systems, GPA-3.85

Coursework: Financial Decision Management, Project Management Fundamentals, Database Systems and Supports, Knowledge Discovery in Databases, Financial Management, IT Strategy, Social Media Analytics Nirma University, Ahmedabad, India Aug’12 – May’16

Bachelor’s in Electronics and Communications, GPA-3.4 SKILLS

Database and analytics: Python, MYSQL, SQL, Excel, Tableau, Salford Cart, Rattle, R Languages: C, Java, R

Other: Microsoft Office, Linux/Unix, Windows, Microsoft Project, Quick Book, IBM Cognos, Salesforce PROFESSIONAL EXPERIENCE

Avis Budget Group, USA: Licensee Relations and Analytics, Intern May’17-August’17

Reviewed franchise agreements and support master database to ensure key terms within agreements and data are accurately reflected in Salesforce and designed dashboards on Salesforce

Assisted Regional Directors in analyzing various markets and developing dashboards with KPM and KPI

Developed automated Dashboard on Tableau and Excel which updates with change in data source

Worked within licensee team to assist in various strategic initiatives and projects that will include Contact with various business units and clients within the company Avis Budget Group, USA: Business Analytics, Mergers & Acquisitions Intern August’17- Present

Responsible for Designing Financial models for M&A between Corporate and various licensees

Designing Tableau Dashboards for licensee relations department and using BI techniques and data visualization techniques to improve the business strategies for increasing revenue of licensees Madhav builders, Ahmedabad, IN: Data Operations, Intern Jan‘14 – Dec’14

Administered the database of company which includes stock, supplies and payroll of the workers by fetching it from data warehouse by using SQL

Designed Data model and backend data connectivity for website to maintain stock inventory and payrolls PROJECTS

Analysis of crime rate in communities of USA Aug’16 - Oct’16

Utilized Dataset of different communities to analyze and investigated the crime rate by R, Microsoft excel with support of CART algorithm

Verified the method by data analysis of testing data also so can get the exact success ratio and proper analysis for precise conclusion

Financial modelling for Parker Hannifin and Clarcor Inc Jan’17-May’17

Designed financial model with assumptions of Gross Revenue, EBIDTA, world economy, synergies and Net earnings per stock

Portrayed three different scenarios (Best, worst and average) for all assumptions to design financial model. Hospital Management System Aug’16-Nov’16

Developed Database system for Hospital including features like patient records, Payment record, Doctor and nurse records, Pharmacy and insurance details

Created Database by developing schema in most efficient and normalized way LEADERSHIP EXPERIENCE

President, Indian Society for Technical Education, Nirma University June’14 – June’15 Convener, World Youth Model United Nations Oct’15 – Feb’16 President, Nirma University Annual Technical Symposium, NuTech-15 Oct’14 – Feb’15 AWARDS

Best Student from ISTE (Indian Society for Technical Education) out of fifty nominations. Oct’15 PUBLICATION

“OFDM transceiver Implementation using VHDL” in IJRSI (Volume II Issue (RETIS-15) . Oct’15

Contact this candidate