We provide IT Staff Augmentation Services!

Data Analyst Resume

4.00/5 (Submit Your Rating)

TECHNICAL SKILLS

  • Microsoft Access
  • VBA
  • Macros
  • SQL (QBE)
  • Excel (VLOOKUP, HLOOKUP, PivotTable)
  • Word
  • Outlook
  • PowerPoint
  • SAP
  • BrioQuery
  • COEUS
  • QuickBooks (Certified ProAdvisor)
  • Adobe Acrobat Professional
  • WordPress
  • Content Management Systems

PROFESSIONAL EXPERIENCE

Confidential

Data analyst

Responsibilities:

  • Payroll and HR data analysis, data cleansing and scrubbing using:
  • Advanced Excel Functions
  • Complex Formulas
  • Data Manipulation
  • Complex Lookups
  • Macros and VBA
  • MS Access and VBA
  • Participated in BRD (Business Requirements Document) review
  • Participated in creating test script and test cases/scenarios
  • Testing of Replicon (cloud time tracking application for timesheet and time off)

Confidential

MS Access/VBA/SQL Database Developer

Responsibilities:

  • Business analysis and needs assessment
  • Data normalization
  • Database design and modeling
  • MS Access, VBA and SQL development/programming (coding)
  • Data migration
  • Testing, debugging, implementation and documenting of the program
  • Creating Excel test models for analyzing data processed by the database

Confidential

MS Access/VBA Developer

Responsibilities:

  • MS Access, VBA and SQL programming (coding)
  • Development, testing, debugging, implementation and documenting of program
  • Development of new MS Access databases
  • Creating Excel templates for data loading
  • Creating Excel test models for analyzing data processed by the database
  • Performing test plans to verify logic of new or modified programs
  • Creating appropriate documentation in work assignments such as program code, and technical documentation

Confidential

Data analyst

Responsibilities:

  • Migration of data from/to different sources and software
  • Processing data using MS Excel, MS Access, VBA
  • Development of new MS Access databases
  • Automation of data processing

Confidential

Project accountant / Analyst

Responsibilities:

  • Development of new and improving existing MS Access databases
  • Migration of data from/to different sources and software
  • Downloading data from SAP system
  • Reviewing data for US Government compliance
  • Preparation of invoices for government invoicing
  • Analysis of costs before billing to the government
  • Monitoring and reporting of billing progress

Confidential

Staff accountant

Responsibilities:

  • G/L accounts reconciliation and preparation of reports (using MS Excel)
  • G/L accounts reconciliation (clearing) in SAP
  • Small business IT solutions development, installation, setup, training
  • MS Access / VBA / SQL(QBE) databases
  • MS Excel workbooks (Vlookup, Pivot table, graph, chart etc.)
  • Installation and setup of computer hardware and software
  • QuickBooks ProAdvisor services - Consulting, Sales, Installation, Setup, Training

We'd love your feedback!