Business Analyst, Intern Resume

TECHNICAL 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, Jira, IBM Cognos, Salesforce

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst, Intern

Responsibilities:

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 using R and developing dashboards using Tableau for analyzing KPM and KPI
Developed automated Dashboard on Tableau and Excel which updates with change in data source
Designed requirements, budget, constraints, risks and dependency for one of the projects of licensee which was to develop a mini lease mobile application
Designed Database structure, Customer and Admin Flow diagram which met the client requirements
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 financial model for M&A between Corporate and one of the Licensee location
Designed Tableau Dashboards for licensee relations department by using BI and data visualization techniques to improve the business strategies for increasing revenue of licensees and our team

Confidential

Data Operations, Intern

Responsibilities:

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