Data Analyst Social Media

Tejanshu Salaria

Hoboken New Jersey ***** 346-***-**** ********.*******@*****.*** https://www.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, Database Systems, Knowledge Discovery in Databases, Financial Management, Database Engineering, Social Media Analytics Nirma University, Ahmedabad, India Aug’12 – May’16

• Bachelor’s in Electronics and Communications

SKILLS & CERTIFICATIONS

Database and analytics: Python, R, Tableau, SAS, MYSQL, SQL, Postgre SQL, Brio, Google Analytics Other: C, Microsoft Office, Linux/Unix, Windows, Microsoft Project, Jira, Cognos, Salesforce Certifications: Applied Data Science using R(Udemy), Tableau Desktop Qualified Associate(Tableau), SQL

(Stanford School),Scrum Fundamentals Certified(PMI), Google Analytics(Google) PROFESSIONAL EXPERIENCE

Avis Budget Group, USA: Business Analyst, Intern May’17- Present

• Analyzed franchise agreements and support master database to ensure key terms within agreements and Data are accurately reflected in Salesforce

• Assisted Regional Directors to increase revenue by 4% in analyzing various markets using by developing live dashboards using Tableau and Excel for analyzing KPI and other key statistics

• Designed financial model for a successful acquisition of one of the license by analyzing various scenarios related to financial aspects, revenue & calculating EBIDTA and other operational assumptions

• Adopted agile methodology to implement program management, effective planning, project milestones, implementation, testing and design and ensuring to deliver project on-time with high standards

• Collaborated with Software team to design Database structure, Data Flow diagram for mobile Application

• 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

• Designed Tableau Dashboards for department by using Tableau and R to improve the business strategies for increasing revenue of licensees by 3% and our team by 6% Madhav builders, Ahmedabad, IN: Data Analyst Jan‘14 – Dec’14

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

• 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 using ETL methodology and developing CART algorithm in R

• Verified the method by data analysis of testing data also to achieve 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. Designing Database Structure for Hospital management System Aug’17- Dec’16

• Fashioned Database system for Hospital using MYSQL queries and tables which included features like Patient records, Payment record, Doctor and nurse records, Pharmacy and insurance details

• Shaped Database by developing schema in most efficient and normalized way which can be implemented for the backend design of Hospital Management System

LEADERSHIP EXPERIENCE

President, Indian Society for Technical Education, Nirma University June’14 – June’15 Convener, World Youth Model United Nations Oct’15 – Feb’16 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