Dennis Orita
Fairfax,VA
Summary
Dynamic data and analytics professional with a proven track record, skilled in SQL and data visualization. Adept at enhancing reporting systems and automating processes, I excel in delivering high-quality results under tight deadlines while fostering collaboration and effective communication across teams.
Overview
15
15
years of professional experience
Work History
Bookkeeper
Associa Community Management Corporation
Chantilly, Virginia
12.2025 - Current
- Post covenant violation charges to homeowner accounts, ensuring accurate billing and compliance.
- Review master and sub-association accounts to identify and correct misapplied payments.
- Research and correct misapplied payments across accounts, enhancing financial accuracy.
- Process and document all refund write-ups related to resale and customer service transactions.
- Apply late fee waivers, covenant violation waivers, and small balance write-offs in accordance with policy.
- Manag online bill pay returns and send friendly reminder notices, improving payment follow-up.
- Process non-sufficient funds (NSF) transactions to maintain updated account balances for customers.
- Prepare and process lead sheets with accuracy and attention to detail.
Email Production and Administrative Specialist
Self-employed
Fairfax, Virginia
11.2015 - 12.2025
- Delivered exceptional customer service and high-quality project deliverables under tight deadlines.
- Entered leads into HubSpot, ensuring accurate contact information and scheduling email marketing sequences.
- Researched and secured hard-to-find email addresses using online tools and keyword searches.
- Developed technical manuals and standardized data entry procedures for staff training.
- Tested and documented software issues while conducting venue research for travel and tourism content.
- Provided proofreading and editing services for various creative writing projects to enhance clarity.
Data and Analytics Manager
Amnesty International USA
Washington, District of Columbia
11.2014 - 11.2015
- Coded and maintained ETL process on Amazon Web Services servers to extract data from Engaging Networks API, enhancing data access and reporting on constituent behavior in online fundraising and activism.
- Developed datamart/reporting systems to streamline data reporting for critical fundraising and advocacy campaigns, including September membership drive and human rights events.
- Developed and deployed a business intelligence system, Pentaho CE, to enhance reporting capabilities to include email statistics and report automation.
- Audited data synchronization and system functionality of member records, identifying and resolving critical data issues.
- Coordinated data uploads from external sources into online and direct marketing databases including credit card pledges and overlay data.
Senior Development Database Manager
People For the American Way
Washington, District of Columbia
04.2012 - 11.2014
- Installed local instances of Oracle and MySQL to warehouse data for ETL, analysis, and manipulation; established database link to vendor's database to enhance data usability.
- Developed applications to automate data synchronization between CRM systems Convio and WinFunds, enhancing accuracy of donor giving histories and improving matching algorithms for donors and activists.
- Streamlined Excel and Access reports with VBA, enhancing usability and accuracy of data, automating report execution and distribution, and incorporating interactive capabilities with pivot tables for detailed analysis.
- Collaborated with the GSC and Convio account managers to test updates and submit job requests.
- Created informational maps to visualize donor giving and geographic locations using ArcGIS, facilitating data-driven presentations to board of directors.
- Designed invitations for major donor fundraising and networking events with GIMP.
Database Manager
Human Rights Campaign
Washington, District of Columbia
08.2011 - 04.2012
- Managed data requirements for direct marketing initiatives; defined data specifications and extracted data for telemarketing, mail, and web campaign analyses to support strategic decision-making.
- Coded, executed, tested, and documented complex queries and SQL scripts for data extraction and analyses on an Oracle database.
- Maintained Excel and Access reporting systems; streamlined code and commands in VBA and batch file programming to enhance report generation and automation efficiency.
- Enabled direct marketing team to exceed budget goals by providing timely and accurate data for major campaigns.
- Generated comprehensive reports for troubleshooting and budget presentations; aggregated data with functions and pivot tables to facilitate informed analysis and insights.
- Served as the primary liaison between the ROI Solutions account managers and HRC staff submitting job requests and troubleshooting system functionality.
Education
Bachelor of Art - Art and Art History
The College of William And Mary
Williamsburg, VirginiaMaster of Art - Visual Arts Studio
Ball State University
Muncie, IndianaSkills
- Microsoft Office Suite
- Oracle and MySQL databases
- SQL and PL/SQL programming
- VBA and Python development
- Windows and macOS
- CRM platforms
- HTML and XML markup
- Joomla! and WordPress CMS
- Pentaho BI tools
- Java development
- ArcGIS tools
- Appian BPM tools
- Graphic design software
- Inkscape design tools
Timeline
Bookkeeper
Associa Community Management Corporation
12.2025 - Current
Email Production and Administrative Specialist
Self-employed
11.2015 - 12.2025
Data and Analytics Manager
Amnesty International USA
11.2014 - 11.2015
Senior Development Database Manager
People For the American Way
04.2012 - 11.2014
Database Manager
Human Rights Campaign
08.2011 - 04.2012
Bachelor of Art - Art and Art History
The College of William And Mary
Master of Art - Visual Arts Studio
Ball State University