|
Virtual Assistant with Accounting, Web Development and Admin
Username: VIRTUALkelly
Register Now to Contact VIRTUALkelly
Already Registered, Click to Contact VIRTUALkelly
Member Since: 22, 2010
Employment History:
Accounting Professional with extensive Computer Programming background
College Graduate: BS - Accounting / BS - Computer Technology
Objective: Virtual projects in accounting software design, financial data technology, database management or financial data analysis.
SUMMARY
Information System Specialist focusing on support of business functions including financial data, accounting and payroll. Solid reputation for meeting deadlines and working with and leading teams to successful project completion. Demonstrated strength in windows-based, web-based, and Financial Software to design data schemas.
Programming Background:
More than 10 years experience in client and web-based development as well as hosting and networking services. Fluent in ASP, ASP.net, ColdFusion, JavaScript and SQL. Experienced in the use and administration of Windows 2000/2003 Server and related services, as well as SQL Server 2000/2005. Microsoft Certified Professional since 2000.
Accounting Background:
An accounting and financial professional with 10+ years of experience. Experienced in financial planning, analysis and accounting principles, budget preparation, planning and scheduling, taxation, cash management, GAAP. Proven track record with capacity to maximize business and integrate finance function. Proactive, innovative and result oriented with excellent communication skills. Open to travel.
Virtual Office Background:
More than 5 years of experience working as a virtual assistant from my home in Maryland. Capable of handling accounting, billing, customer service, legal and medical office tasks, programming, web management, clerical and data entry, administration, writing and editing, sales and much more.
ACCOMPLISHMENTS
Accounting and Financial Management
Developed and maintained accounting records for up to fifty bank accounts.
Formulated monthly and year-end financial statements and generated various payroll records, including federal and
state payroll reports, annual tax reports, W-2 and 1099 forms, etc.
Tested accuracy of account balances and prepared supporting documentation for submission during a comprehensive three-year audit of financial operations.
Formulated intricate pro-forma budgets.
Calculated and implemented depreciation/amortization schedules.
Information Systems Analysis and Problem Solving Converted manual to computerized accounting systems for two organizations.
Analyzed and successfully reprogrammed software to meet customer requirements.
Researched and corrected problems to assure effective operation of newly computerized system
Researched story ideas, wrote articles and participated in the publication of a
weekly in-house newsletter.
Assisted customers and staff members in resolving problems and balancing
accounts; trained new staff members.
Researched and developed a survey instrument, subsequently used to obtain information from customers regarding their satisfaction with products purchased.
Compiled and analyzed statistical data to identify potential target markets for future sales and marketing efforts.
Completed independent research project on the use of mathematical/statistical models as tools for solving various business problems.
Conducted quality control inspections, analyzed results and developed action plans to address areas of concern.
Managed the implementation of a major software upgrade, significantly increasing efficiency in the use of accounts payable and purchasing systems.
Converted contract and payee information from a third party system to an internal automated system, resulting in approximately $72,000 in annual revenue for the organization.
Developed a cohesive, productive work team of individuals from diverse areas of the organization, utilizing strong interpersonal and leadership skills to foster and encourage teamwork and cooperation among team members and with user areas.
Utilized TQM principles to implement several internal process improvements that have resulted in hundreds of time-saving hours annually.
Promoted into management position after only six months as a Systems Analyst.
Principle responsibility includes, maintaining relationships on behalf of the company with all the clients invited for the exhibition.
Communicate to the user about the latest updates on procedures and programmes.
Understand the requirement of the exhibitors and arrange to fulfil that.
Ensuring all the services offered to the companies invited are up to the mark and also up to the customer service standards.
To progressively enhance customer services to the exhibitors and media so the end users are satisfied and also signed contract for the next years exhibition.
Preparation of press releases for the newspapers and internal publications for public, making brochures, fliers & advertisements for each show.
Procurement of giveaways and follow the corporate guidelines for branding.
Exploit identified PR opportunities and draft press releases to ensure press coverage for Exhibition/conferences to suitable publications.
EXPERIENCE
2005-Present Freelance Virtual Assistant
Complete projects for Virtual Office Temps, Elance, RentACoder and others.
Consulting
Professional accounting, auditing, taxation and consulting. Specific areas of consulting include: SEC restatements, information systems, accounting and management accounting, computer hardware and software installations, information processing, reengineering of accounting and information systems, production systems, reengineering, and scheduling. Performed fraud and forensic auditing assignments. Consulted with Fortune 1000 Boards on Corporate Governance issues. Worked extensively from my home as a paid virtual consultant on many projects.
Account/Virtual Office Manager
Scheduling of lawn maintenance routes and landscape jobs. Organize pay roll and invoice customers for billing. Customer service and virtual telephone work.
Controller
Overall financial authority of the organization and accountable for budget preparation, audit, taxation, accounting, closing of books, reports summarizing, development of financial statements. Supervised a team of 20 virtual accounting clerks from home. Provided investment and business analysis as well as recommendations and contingency plans for Executives to make strategic, operational, capital expenditure, resource allocation and critical projects decisions.
STAFF ACCOUNTANT
Established, proposed and streamlined new business protocol for alternative risk exposure process involving areas of ordering, purchasing, shipping, receiving and payment transactions. Initiated and documented policies and procedures for the accounting and finance department for business control, preventing and avoiding risk exposure and potential auditing. Developed corrective actions to improve financial and business process controls including implementing new accounting application and networking system preparation.
COST ACCOUNTANT
Reviewed, analyzed and updated standard costs, product margins and cost variances; suggested and deployed actions to improve revenue and profits. Performed inventory control on a daily basis; recommended alternatives to avoid surplus and cost savings by improving the Purchasing Department strategy. Prepared profitability analysis and evaluated new products including pricing relative to the market as well as setting up appropriate markups.
OTHER PAID VIRTUAL PROJECTS COMPLETED:
Projects
- Equity Consultant and Specialist
- Shareholder customer support
- Investment Advisor
- College Recruiting services (student support and recruitment)
- Finance and accounting student recruitment and advising
- College marketing - designing templates for department advertising
- Research and Development for federal tax programs
- Tax advising and programming of internal database
- Researcher (tax programs and consulting)
- Home based Sales Agent for insurance services
- Insurance advising and web programming for corporate website
- Lead accountant - supervised virtual workforce
- Database specialist for accounting department
- Accounting programmer and specialist for national grocery chain
- Budget analysis for corporate executives
- Web programming and design for various clients
- Internal database SQL specialist for retail services
- E-Commerce programming for online shopping portal
2 YEAR PROJECT: ACCOUNTING DATABASE SPECIALIST
Migrated Access database to SQL Server 2000 and created a new, more flexible ASP website for internal use. Maintained and enhanced a MS Access-based accounting system. This included adding several data entry forms and reports.
Developed a MS Access database application for financial department. Administered incentive and commission program. Application significantly reduced the amount of time it took to create the reports, thereby increasing the productivity of the employee tasked with administering the plan.
VIRTUAL ASSISTANT PROJECTS COMPLETED:
Website Editor
Managed content and database. ASP.Net, SQL Server & DotNetNuke. Extensive integration with backend accounting system and support of sales force. This is an ongoing project.
Data Converter
Integrated existing database and information to new system. Worked with ASP.Net and SQL Server. Worked with financial files to insure accuracy but which required knowledge of account principles and ledgers.
Clerical Assistant
General administrative work for medical firm included document prep and executive assisting (travel, schedules, voicemail, calendar, etc)
Accounting Assistant
For major insurance firm. Handled check billing payments and created backend web management of payments for customers to access accounts and payment histories online. ASP.Net / SQL Server and made heavy use of web services to communicate with other internal systems. Delivered project 3 weeks ahead of schedule. System is still in use today by executive offices.
Customer Database Manager
Created database to manage customers/patients including confidential information requiring level 2 access and password protection. Used accounting principles to develop billing summaries for managers. Prepared reports and spreadsheets of accounts. Created auto-complete controls to lookup patient data. A conversion program was also developed to extract data from legacy system.
Bank Programmer
Architecture, database management and integration for regional bank to handle accounts and customer data.
Accounts Specialist
12 month project to handle new products and customers, track sales and price changes and manage payment processing. Created reports to show weekly, monthly and yearly data in both spreadsheet and chart/graphic form. Prepared detailed accounting reports to management.
Online Agent
2 month project working with PHP, HTML and ASP/MS Access for web hosting company. Created account management areas for customers including bill pay and history access. Handled customer service and tech support as new system came online to transition customers.
Blogger, Writer, Editor
Financial news website. Assisted in backfill of database with financial news and updates in preparation for new website launch. Wrote help guides, FAQs and articles. Researched data.
Accounting Contractor
Provided analysis, design, installation, and rollout of Oracle 11i General Ledger, Accounts Payable, and Purchasing. Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules
Accounting Tech Specialist
Developed interfaces and data conversion programs for applications and Addressed operational problems, concerns, and questions posed by users
Accounting Assistant
Directed all accounting, budgeting, financial reporting, and tax operations for engineering subsidiary of construction company, monitored all planning and budgeting parameters and internal financial reports, including allocation factors for distribution of common costs and analysis of profits by projects
Senior Accountant
Temp assignment lasting 6 months. Performed Finance and Accounting functions for several departments, Prepared budgets, reports and financial statements, Maintained account reports, and tracking spending and cost variances for reporting to senior management
Independent Consultant
Maintained State Fund claim processing database. Developed tools for cost review, technical, and management staff. Researched technologies. Perfomed as subject matter expert for PHP data warehouse project.
Financial Planning and Systems Development
Designed and developed planning and budgeting system. Performed duties typical of an internal auditor / internal controls officer. Performed general clerical duties to include report prep and data entry.
Financial Planning and Analysis
Departmental budgeting, preparing financial statements and multi-year strategic plans. Developed an MS Excel model to evaluate pricing relative to profitability for potential new business acquisitions. Prepared budgets and analyzed variances for manufacturing and support functions. Developed monthly operating and multi-year strategic financial plans.
Accounts Collections
Responsible for reducing accounts receivable collection period & strict monitoring of customer rejections & cancellation of orders. Working with the Marketing and Production departments in finding new uses for existing stocks to be liquidated. Coordination with the Marketing Director in suggesting strategies in opening new export markets. Funding requirements had also to be supervised and monitored and banking facilities were extended to support the company.
Web Application Development
Excellent working knowledge of Ruby on Rails, including plugin development
Excellent working knowledge of Ruby, including custom gem development
Countless open source contributions
Strong understanding of SEO concepts and techniques
Comprehensive knowledge of XHTML, Javascript, and CSS for designing user interfaces
Excellent working knowledge of AJAX, XML, RSS, REST architectures, and other various cross-site data exchange technologies
Working knowledge of many of those "other" languages, including Perl and PHP
System Administration
Comprehensive knowledge of the GNU/Linux operating system, with a focus on RedHat-based distributions.
A thourough understanding of the processes and tools necessary to deploy Ruby on Rails applications, using Apache/nginx, Mongrel, Capistrano, and MySQL
Extensive experience with virtualization technology, with a focus on XEN
Extensive experience with Amazon EC2
Excellent working knowledge of MySQL including advanced techniques such as database replication
Experience protyping, implementing, and benchmarking high availability load-balanced web clusters
Extensive experience with the LAMP framework
Other -
Language and framework proficiencies: ActionScript, AIR, ColdFusion, CSS, HTML, Ext JS, JavaScript, jQuery, PhoneGap, PHP, SQL, XML.
Software proficiencies: Aptana, ColdFusion Builder, Dreamweaver, Eclipse, Fireworks, Flash, Flex, Illustrator, MySQL, Photoshop, SQL Server, Subversion.
Server administration proficiencies: Apache, ColdFusion, IIS.
Ability to learn and implement new technologies, methods, and best practices quickly and easily.
Educational History:
EDUCATION
University of Maryland College Park
Double Major: Accounting and Computer Programming
PROFESSIONAL ASSOCIATIONS
Microsoft Certified Professionals
IEEE Computer Society
The Internet Society
Linux Fedora Ambassadors
Certified Virtual Assistants
National Association of Virtual Professionals
National Honor Society
PROFESSIONAL CERTIFICATIONS
Microsoft Certified Professional
- MCP
ACCOUNTING DESIGNATIONS -
CPA - Certified Public Accountant
CMA - Certified Management Accountant
CIA - Certified Internal Auditor
CISA - Certified Information Systems Auditor
CITP Certified Information Technology Professional by the American Institute of Certified Public Accountants.
SOFTWARE SKILLS
Adobe Photoshop
Illustrator
Macromedia
QuarkXPress
PageMaker
MS PowerPoint
InDesign Flash5
Macromedia Director 8 MS Word
Sales Force8
AWARDS & TRAINING
Employee of the Month, 4 time winner
Best New Start Up (web design, programming)
TOP Virtual Assistant, 2 years in a row
REFERENCES
References available upon request.
------------------------------------------------------
Education
Anne Arundel Community College, Arnold, MD. Intro to Data Processing, Programming in Basic, Intro to Sociology, Principles of Management, Topics in Philosophy: Cosmos, Digital Electronic Circuits, Electronic Fab. Skills, Communications Systems, Intro to Programming:FORTRAN, System Analysis & Design, Programming in C.
Professional and/or Technical Training
Digital Training Centers. VAX/VMS Utilities & Commands, VAX/VMS System Management I, Ultrix Utilities & Commands for VMS users, VAXCluster System Management, VAX/VMS Internals I, Pathworks System Management: VMS/Macintosh.
Entre Computer Centers. dBase III plus, WordPerfect 6.0 for DOS.
OSD Training Facility. XEROX System Administration.
ExecuTrain Centers. Administering Windows NT 4.0, Core Technologies of MS Exchange Server 5.0, Introduction to MS FrontPage 97.
Oracle Online. Oracle 8/8i database administration.
Army e-Learning. Windows 2000: Core Technologies - (Network Fundamentals, TCP/IP, Internet Fundamentals), Security Management and Operations Security Practices, Access Control and Physical Security, Cryptography and Network Security, Security Architecture and Applications Security, Business Continuity Planning Law & Ethics, Network Security Issues, SAP R/3 Release 4.6 Fundamentals, Navigating SAP R/3 Release 4.6, Using SAP R/3 Release 4.6, XML Web Services and Microsoft.NET, Building Web Services and Web-Service Clients with Microsoft.NET, Introduction to Security in Networked Environments, Encryption Technologies, Firewalls and VPNs, Securing Access to Networks, Intrusion Detection and Response in Networked Environments, Security Analysis and Auditing in Networked Environments, Operating System and File Security Issues, MS Windows 2000 Server Technologies: Designing Highly Available Web Solutions - (Highly Available Web Infrastructure Solutions in MS Windows 2000, Technologies for Highly available Solutions in a Windows 2000 Environment, Highly Available Network Services and Logical-Network Solutions in Windows 2000, Highly available Physical-Network Solutions in a Windows 2000 Environment), MS SQL Server 2000 Database Administration I - (Overview of SQL Server 2000, Installing Configuring and Upgrading SQL Server 2000), MS SQL Server 2000 Database Administration II - (SQL Server 2000 Databases, Transferring and Transforming Data in SQL Server 2000, Security in a MS SQL Server 2000 Environment, Managing SQL Server 2000 Databases), MS SQL Server 2000 Database Administration III - (Backing Up SQL Server 2000 Databases, Restoring SQL Server 2000 Databases, SQL Server 2000 Replication, Monitoring SQL Server 2000 Performance, SQL Server 2000 High Availability, SQL Server 2000, XML and the Web), MS Windows Server 2003: Introduction - (Getting Started with Windows Server 2003, Windows Server 2003 Administration and Services Support), MS SQL Server 2000 Database Implementation - (Designing and Implementing Security in SQL Server 2000, The SQL Server 2000 Logical Data Model, Using T-SQL in SQL Server 2000, SQL Server 2000 Indexes, SQL Server 2000 Programming Business Logic, SQL Server 2000 Transactions and Distributed Data, Analyzing and Optimizing SQL Server 2000 Queries), Effective Listening Skills - (The Basics of Listening, Listening for Higher Purposes, Listening for Comprehension, Enhancing Your Listening Skills, and Effective Listening Skills Simulation).
C-TREC. Programming with MS Visual Basic.NET, Developing ASP.NET Web Applications using MS Visual Studio.NET
Citect. CitectSCADA Configuration.
Federal Acquisition Institute Knowledge Center. COR Mentor Program.
Marine Corps Civilian Career Leadership Development Program. Managing A Diverse Workforce.
Navy/NKO e-Learning. The Manager as Coach and Counselor, Design Concepts for Web Sites, The Basic Features and Functionality of Frontpage 2002, Macromedia DreamWeaver 4 Web Design Tools, Advanced Technology Concepts for Web Designers, Advanced HTML Design Elements, Macromedia Flash 5, Web Design Tools, JavaScript: Language Basics, JavaScript: Scripting, VBScript - (Elements, Arrays, Procedures, and Program Flow), and VBScript - (Functions, Core Objects, and Classes).
Virtual Office Skills & Equipment:
PROGRAMMING LANGUAGES
Mastery of the following programming languages:
Visual Basic (6 and .Net)
ASP 2.0
ASP.net (VB Script, C#)
Macromedia ColdFusion (4.5, 5.0, 6.1/MX)
PHP (entry level)
Oracle (entry level)
VBA for Microsoft Access
SQL
HTML/DHTML
XML
CSS
SOFTWARE/OPERATING SYSTEMS
Mastery of the following computer operating systems and software packages:
IIS (5, 6)
IPSwitch IMail 8.2
Linux (RedHat and Fedora Core 5) limited knowledge
Linux BIND
Linux Sendmail
Macromedia Dreamweaver (MX, 8)
Microsoft DNS
Microsoft Exchange
Microsoft Office
Microsoft Project
Microsoft SQL Server
Microsoft Windows
Microsoft Windows Server (NT 4)
Microsoft Visual Studio (6, .Net)
SimpleDNS Plus
SmartMax MailMax
Winternals
Active Directory Intermediate Currently used/6 years
Active Reports Expert 3 year ago/5 years
Araxis Merge Expert Currently used/2 years
ASP Classic Expert Currently used/4 years
ASP.Net Intermediate Currently used/2 years
C# Intermediate Currently used/2 years
Cold Fusion Expert 3 years ago/4 years
COM / OOP Expert Currently used/10+ years
Crystal Reports Intermediate 4 years ago/4 years
HTML Expert Currently used/10+ years
IIS Web Server 5.0/6.0 Intermediate Currently used/8 years
Java Script (Server + Client) Expert Currently used/8 years
MS ACCESS 95 / 97 / 2000 Expert Currently used/10+ years
MS EXCEL 95 / 97 / 2000 Expert Currently used/10+ years
Reflector for .NET Expert Currently used/2 years
SQL for ACCESS Expert Currently used/10+ years
SQL Server 2000 Expert Currently used/8 years
SQL Server 2005 Expert Currently used/3 years
TSQL Intermediate Currently used/8 years
VB.Net Intermediate Currently used/2 years
VBA Expert Currently used/10+ years
Visual Basic Expert Currently used/10+ years
Visual Source Safe Expert Currently used/10+ years
----------------------------------------------------------
Technical Skills
Software:
LANGUAGES/TOOLS: Basic, Fortran, DCL, C, dBase III plus, dBase IV, EDT & EVE editors, VI editor, Smartstar/Omnibase, Oracle, WordPerfect, MS Windows, MUMPS/DSM, Reflections, DECWindows, Harvard Graphics, Norton Utilities, MS Office, MS Project, MS Access, Visual Basic, MS Internet Explorer, MS FrontPage, Netscape Communicator, MS Exchange, MS Outlook, NT System Administration Tools, Exchange Administration Tools, Polycenter Tools (VMS), SLS/ABS Tape Library, DecEvent, PCSI (Polycenter Software Installation Utility), WEBES, Java/html, InstallShield, SourceSafe, Authentor SecureACCESS, MS Internet Information Server, MS SQL Server.
Hardware:
COMMUNICATION/NAVIGATION EQUIPMENT:
AN/ARC-164 Have Quick, APX-76 air-to-air interrogator, AN/APN-155 radar altimeter, KY-532B/ASQ IFF/SIF, AN/ARN-118 Tacan, AN/ARN-127 ILS/VOR, AN/ARC-164 UHF radio, HF equipment, FM-622A FM radio, AN/ARC-186 VHF AM & FM radio, AN/ARC-109 UHF radio, LS-460A aircraft interphone, AN/ALE-40 Chaff/Flare dispenser system, AN/ALR-69 Radar Threat Warning system.
TEST EQUIPMENT:
AN/APM-229 radar altimeter test set, AN/APM-245 Mode IV IFF test set, AN/APM-378 IFF F/L test set, AN/ARM-135 Tacan test set, AN/ARM-268 APX-76 test set, AN/APM-349 F/L test set, AN/ARM-184 Tacan F/L test set, AN/ASM-85 CNI test harness (TAC), AN/ASM-86 CNI test harness (UHF), AN/ASM-84 CNI test harness (PS/ADF), 4047/APM-424(V) IFF F/L test set, AN/PSM-6 multimeter, AN/PSM-37 multimeter, AN/UPM-137 IFF test set, AN/URM-14 microphone simulator, AN/URM-95 emergency radio test set, AN/USM-339 oscilloscope, B-9 DC rectifier, DPM-3 RF wattmeter, ME-6D/U AC voltmeter, RNT-280A VOR/ILS test set, TS-505D/U VTVM, TS-585B/U audio output meter, 140A audio oscilloscope, 200CD audio oscillator, 214A pulse generator, 334A distortion analyzer, 400A thru-line wattmeter, 415B standing wave indicator, 432A RF power meter, 451 microwave pulse counter, 453 Model 703H oscilloscope, 479S-6 VOR/ILS signal generator, 536A wavemeter, 606A signal generator, 620A signal generator, 650A test oscillator, 776D dual directional coupler, 893A differential voltmeter, 1605M solid state voltmeter, 3340 RF millivoltmeter, 4301 thru-line wattmeter, 5015K DC power supply, 5328A electronic counter, 6010 DC power supply, 6013 high voltage probe, 6267B regulated DC power supply, 8614A signal generator, 8640B signal generator (UHF), 8800A/AF digital voltmeter, 92AS2 RF milli-voltmeter, PACE soldering station, break-out box.
COMPUTERS/PERIPHERALS:
Various VAXes (11/750, 11/780, 6410, 8650, MicroVax 3900, 8350, 8250, 8810, 8820, MicroVax 3500, 7610, 7620).
Various Alphas (1000 series, 2000 series, 4100 series, 8000 series, 7000 series, DS20, ES40, GS160/GS320).
Various StorageWorks Device Controllers (HSC50, HSC70, HSJ40, HSJ50, HSZ70).
Various microcomputers (IBM compatible, MACs).
Various laser printers, decservers, decstations, CIs, Sun Workstation, HP 3000/70, modems, mux's, black boxes and in-line testers.
Communications:
NETWORK PROTOCOLS: Tops, Ethernet, TCP/IP, Decnet, Multinet, TCPWare, UCX, Span, Appletalk, ProComm, ProComm Plus, Versatec, X.25, Pathworks (for VMS, DOS, Macintosh), EM4105, Crosstalk, White Knight, Decnet for DOS, Decnet for Macintosh, DHCP, WINS, DNS.
Other:
OPERATING SYSTEMS: DMS 1100, VMS/OPENVMS, MS-DOS, PC-DOS, MAC System 7, BIOS, DBS 250, Viewpoint, ULTRIX/DEC UNIX (Tru64 Unix), MPE V, HP-UNIX, System V/Solaris
|
|
|
|
Featured Virtual Assistants
Jobs & Projects At A Glance
Keep Up With the VOT Blog
|
|
