Ms Access/vbasql Database Developer Resume
SUMMARY:
- Please be advised, that I am in MA and I am actively pursuing job opportunities to relocate to Southern CA (preferably Irvine or LA area).
- I will relocate as soon as approved for a position and may be available for in - person interview. I will also consider temporary and/or temp-to-hire positions.
TECHNICAL SKILLS:
- Microsoft Access
- VBA
- Macros
- SQL (QBE)
- Excel (VLOOKUP, HLOOKUP, PivotTable)
- Word
- Outlook
- PowerPoint
- SAP
- BrioQuery
- COEUS
- QuickBooks
- Adobe Acrobat Professional, WordPress, Content Management Systems
PROFESSIONAL EXPERIENCE:
Confidential
MS Access/VBASQL 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
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
Confidential
MS Access/VBA/SQL(QBE) developer, MS Excel consultant
Responsibilities:
- 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
Confidential
Staff accountant
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, Training
Confidential
MS Access/ VBA / SQL(QBE) developer /data analyst
Responsibilities:
- Development of EVS (Eligibility Verification System) Database for billing department, which:
- Checks information about Confidential
- 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
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, MS Excel consultant
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
Responsibilities:
- MS Access/SQL(QBE) database development, installation , setup and training
- 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 training and day-to-day operations management and control
- Database, system and network administration
- Regular and ad-hoc reporting (including analysis and statistics)