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