Data Analyst Resume
0/5 (Submit Your Rating)
TECHNICAL SKILLS
Programming languages: Python, R, PHP, SQL, PL/SQL, HTML, CSS, JavaScript, Java
Software Tools: Microsoft - Advanced Excel (VBA), MS Office, MS SQL Management Server, MS PowerBI, MS SharePoint; Tableau; RStudio; Oracle; Google BigQuery, Cloud Platform; Jira, Wrike
Experience in: paired programming, Agile development environment, Database development, Data analysis and Visualization, web development, Web Scrapping
PROFESSIONAL EXPERIENCE
Data Analyst
Confidential
Responsibilities:
- Collect data from internal and external applications for GB enrolment team
- Determine the requirements of the clients to further clean and analyse data, using MS Excel
- Utilize JIRA to communicate with teams, create XML files of analysed data
- Analyse project data using MS Power BI (DAX queries), create ad-hoc reports to provide valuable insight
- Automate data analysis, create dashboards for the management (VBA Programming)
Analyst
Confidential
Responsibilities:
- Extract data of support tickets, work on data cleaning; analyse results using statistical techniques with Advanced MS Excel (Pivot table, VLOOKUP) as well as MS Power BI (DAX queries)
- Utilize Google Analytics methodology along with statistical tools, draw valuable insights for the business task
- Site Admin on SharePoint for the organization to update sites and pages
Data Analyst
Confidential
Responsibilities:
- Using automated tools to extract data from primary and secondary sources
- Analyse sales data, build reports and provide recommendations to improve the sales process
- In charge of coding the website using HTML, CSS, JavaScript
- Created an Excel automated sales order form using VBA, Macros to extract data from database which reduced paperwork by 30%
Developer
Confidential
Responsibilities:
- Developed a functional web application; worked on weekly sprints; followed agile methodology; brought the paperwork down by 20%
- Designed database structure and tables on Microsoft SQL Server
- Improved data architectures to minimize duplication of data as well as maximize data consistency
- Coded backend of the application with PHP, T-SQL; developed UI of the application with HTML, CSS, and Bootstrap
- Built complex SQL/T-SQL queries to import and export data
Data Analyst
Confidential
Responsibilities:
- Determine the requirement for marketing, operational teams; collect data from various sources
- Coded Python scripts to scrape data from Google news, Google Search, several articles and more
- Responsible to organise and standardise the data collected to further perform analysis
- Clean data and analyse to identify trends; create dashboards and reports for the teams, management