We provide IT Staff Augmentation Services!

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

We'd love your feedback!