EDUCATION

TEXAS A&M UNIVERSITY, COMMERCE

M.S. IN

BUSINESS ANALYTICS December 2019

TECHNICAL SKILLS

Analytics:

Tableau, Power BI, Hadoop, SAP, BO, SAP HANA, MS Excel

Programming:

JAVA, Python

Database:

Oracle, SQL, MySQL, MS Access, MS SQL Server

Applications/Software:

SAP Visual Intelligence, SAP ERP System, IBM Unica

SOCIALS

Click buttons to learn more

CONTACT DETAILS

Cell: 972-***-****

Email: adg18e@r.postjobfree.com

Home: Garland, TX

WORK EXPERIENCE

AWESOME TECHNOLOGIES INC.

DALLAS AUGUST 2020 - PRESENT

Data Analyst Intern

Responsible for building customized interactive reports and dashboards using Power BI. This work has helped the company highlight KPI trends for mortgage-based companies

Utilize advanced understanding of multiple data structures to create solutions which may include data visualization, ETL, SQL Server and Power BI

Improved the existing Sales and Processing dashboards and defined new KPIs to improve its efficiency.

Retrieved SQL stored procedures for the extraction and retrieval of the data using SSMS and Power BI.

Professionally present data collections for projects in front of the executives. Perform data analysis, DAX measures, modeling, and visualization of cross-functional actionable, predictive, and prescriptive business insight deliverables

Optimized the already existing stored procedures to enhance the performance of the ETL processes by 20% and create new ones for Ad-Hoc reporting with Power BI dashboards using SQL Server database

Created PowerPoint decks to produce clear concise and professional presentations quickly for management and other analysts

Extensive Excel work using pivot tables and complex formulas to manipulate large data structures.

Academic Experience Jan 2018 - Dec 2019

Database and Datawarehouse

Applied the principles related to data organization: tables, queries, aggregations, keys and joins

Created, supported, and maintained metrics/dashboards built on Power BI platform

Gathered data mappings for ETL & reporting development

Data Analysis and Programming

Utilized anaconda to manage packages and environments for use with Python JUPYTER NOTEBOOKS

Build a linear regression model to understand the relationship between independent and dependent variables

Analyze data, trends and made suggestions based on the result from the analysis

Perform the entire data analysis process on a dataset and used NumPy and Pandas to wrangle, explore, analyze, visualize data and document the report

Customer Analytics using Excel

Market share analysis of other competitors and study how demographics and store-promotions affect brand choice

Figured out most profitable and highly frequent buyers using RFM method and understand demographics of customer

Provide recommendations from the insights gain what type of customer to target market

Contact this candidate