TECHNICAL SKILLS:

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

WORK 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 / MS Access/VBA/SQL(QBE) developer (temporary assignment)

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 (temporary assignment)

Responsibilities:

• G/L accounts reconciliation and preparation of reports (using MS Excel)
• G/L accounts reconciliation (clearing) in SAP

Confidential

MS Access/VBA/SQL(QBE) developer, MS Excel consultant, QuickBooks ProAdvisor - owner

Responsibilities:

• Small business IT solutions development, installation, setup,
• 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,

Confidential

The Office of the Vice President

Responsibilities:

• Auditing and final reporting of federal and non-federal sponsors
• Preparation of computer and manual invoices on a monthly, quarterly and annual basis
• Preparation of internal cost audits on terminated grants and contracts
• Maintaining and updating of all information concerning active and terminated grants and contracts.
• Participation in running and reviewing various SAP billing systems.

Confidential

MS Access/VBA/SQL(QBE) developer

Responsibilities:

• MS Access/ VBA / SQL(QBE) database development
• MS Excel consulting (Vlookup, Pivot Table, Chart, Graph)
• Installation and setup of computer hardware and software
• QuickBooks ProAdvisor services- Consulting, Sales, Installation, Setup,

Confidential

MS Access/ VBA / SQL(QBE) developer

Responsibilities:

• Development of EVS (Eligibility Verification System) Database for billing department, which:
• Checks information about client’s health insurances
• Highlights even minor changes in information
• Fixing, updating and improving of quality management databases
• Needs Assessment Database
• Consumer Satisfaction Database
• Human Rights Database
• Incidents Database

Confidential

Data Analyst, MS Access/VBA/SQL(QBE) developer, MS Excel consultant

Responsibilities:

• Checking and fixing of errors in budgeting tool in MS Excel
• Development of MS Access database for budgeting and monitoring

Confidential

MS Access/ SQL(QBE) developer

Responsibilities:

• MS Access /SQL(QBE) database development
• MS Excel consulting (Vlookup, Pivot Table, Chart, Graph)
• On site computer services

Confidential

MS Access/VBA/SQL(QBE) developer - owner

Responsibilities:

• MS Access/SQL(QBE) database development, installation, setup and
• Computer technician services
• Executive and financial management of the company

Confidential

Assistant of CFO

Responsibilities:

• Systemization of correspondence and documents registration system
• PowerPoint presentations of management reports
• MS Excel worksheets for data analysis
• Financial accounting information processing and representation to CFO

Confidential

MS Access/VBA/SQL(QBE) developer

Responsibilities:

• Development of MS Access database for restaurant management program
• Organization of the team
• Coordination and project management
• Purchase, installation and setup of hardware, software and network
• Programming, testing, installation and setup
• User and day-to-day operations management and control
• Database, system and network administration
• Regular and ad-hoc reporting (including analysis and statistics)

Confidential

Chief accountant

Responsibilities:

• Grant funded programs’ budgeting, monitoring and reporting
• Full charge bookkeeping
• Tax and statistic reporting (payroll taxes, sales taxes, local and public taxes)
• Financial and managerial accounting and reporting (to funders, management and board)
• Including Balance Sheet, Income Statement, Statement of Cash Flows, Statement of Owner's Equity