Data Specialist Accounts Payable

ROSALIND M. TRIGGS

*** *. **** ****** – **th FL, New York, NY 10120

Phone: 212-***-****

Email: ********.******@***********.***

REMOTE DATA SPECIALIST DATA MIGRATION

REPORTING & ANALYTICS

PROFILE

Experienced Data Specialist with 20+ years of expertise in cleansing, migrating, and analyzing enterprise data sets across CRMs, financial systems, and legacy applications. Skilled in SQL, Excel, and CRM platforms with proven success delivering remote data projects for Fortune 500s, nonprofits, and government agencies. Strengths include improving data quality, streamlining workflows, and creating reporting solutions that drive decision-making. Areas of Expertise Include:

Data Cleansing & Migration

SQL Python

Excel (Advanced)

Power BI/Tableau

CRM (Salesforce, DonorPerfect)

ETL Documentation

Workflow Automation

Cloud Data Storage (AWS S3)

Business Process Improvement

Reporting & Visualization

Remote Team Collaboration

(Teams, Zoom)

RECENT ENAGEMENT EXPERIENCE

Jennifer Temps Inc. (7/18 –Present)

Remote Data/Operational Specialist

Drove process improvements to reduce costs and increase productivity across staffing operations.

Coordinated cross-functional teams to identify workflow inefficiencies and implement better solutions.

Conducted UAT for Oasis HR system, ensuring 100% adoption and eliminating processing errors. Tri-State Office Products (7/04 – Present)

Remote Data Reporting Analyst

Transformed legacy system text files into cost center, PO, and requisition data for accounts payable billing reports.

Automated usage reports by product/location in Excel and PowerPoint with trend/spike analysis.

Designed ad hoc Access/Excel queries to validate data accuracy and provide real-time insights.

Supported RFP responses with pricing comparisons against manufacturer retail rates. Twin Rivers Community (5/25 – 9/25)

Remote Software Consultant – HOA Inspection Tracking System Modernization

Redeveloped a homegrown inspection tracking system into a secure, web-based platform with responsive UI/UX.

Designed role-based authentication and CRUD functionality for address and owner records.

Built dynamic reporting tools enabling bulk PDF/CSV exports with filters (date range, owner, status).

Implemented AWS S3 for secure image storage and delivered full system documentation.

Delivered end-to-end

Riverstone Senior Life Services (3/25 – 6/25)

Remote Data Consultant – CRM Migration and Optimization

Cleansed and migrated 3,000+ donor records from Salesforce to DonorPerfect, improving CRM data accuracy by 40%.

Standardized donor data fields to enable segmentation and personalized communication.

Redesigned fundraising workflows to include automation of acknowledgments and recurring donations.

Authored SOPs ensuring long-term usability for staff and leadership. NYC Administration for Children’s Services (ACS) (3/23-4/24) Remote System Designer / Implementation Lead

Led implementation of a cloud-based service-of-process tracking system, digitizing workflows and eliminating paper processes.

Designed user-specific dashboards with real-time status, affidavit generation, and invoice reconciliation.

Ensured compliance with NYC procurement standards while streamlining vendor-side job assignment and tracking.

ROSALIND M. TRIGGS PAGE 2

NYC Commission on Human Rights (5/18 – 7/18)

Information Technology

Retained as a Data Integrity Analyst responsible for cleansing and analyzing data from both our Case Tracking System and Matter Management System utilizing knowledge of data management and manipulation in Microsoft Excel and Access. Working with various business stakeholders to identify their information needs. Identify and highlight problems in legacy data as well as how to process/transform the data for import into Matter Management System. Go through data to reconcile a variety of inconsistencies across numerous data sets. Research organizational details to verify correct spelling, address information and other account details. Track the completion of data conversion for each record. Anderson Kill & Olick (10/17 –2/17)

Retained as a Process Improvement Analyst/MS Access Developer translating business requirements from Excel spreadsheets into MS Access utilizing MS Access 2013, Visual Basic 6, and SQL.

Reviewed requirements, specifications, user documentation, designed screen layouts and UAT cases including options for future enhancements and ease of maintenance. Debevoise & Plimpton LLP (10/16 – 9/17)

Retained as a Business/Conversion Analyst/Web Developer to convert RMT Legal Document Production Tracking (MS Access front-end with SQL backend) to a web-based front end.

Gathering business requirements and translating them into approved functional requirements.

Designing screen layouts and UAT cases including options for future enhancements and ease of maintenance.

Interviewing users and management to document requirements at all levels.

Providing traceability between business and functional requirements.

Documenting the related business concepts, process flows, data element definitions, calculations, reports and screen layouts.

Preparing comprehensive functional requirements for development based on business requirements, priorities and scope.

Mediating between the various interested parties to interpret/clarify requirements and help resolve any differences that might arise as a result.

MUFG Union Bank, N.A. (4/16 – 8/16)

Risk Assessment Compliance

Retained as a Senior MS Access/MS Excel/VBA SQL Developer enhance functionality of the existing MS Access based tool to a MS Access front-end with SQL back-end.

Provide innovative design solutions for systems initiatives base on the BRD requirements to support the bank- wide risk assessment team. The tool will meet complex business needs, where multiple users will access multiple data points through a configurable, roles based workflow and user interface.

Code, test, debug, implement, and document complex programs. NYC Law Department (3/14 – 12/15)

Operations

Retained as a MS Access (2010) Developer/Business Analyst to convert RMT Legal Document Production Tracking 2003 to 2010, design and develop a new module for the Process and Courier Unit that will automate the tracking of their workflow. RMT LDPT streamline the workflow process for three units (DDPS, DFS and PCS) within the Operation department

Jazz at Lincoln Center (4/15 – 10/15)

Payroll for contractors

Retained as a MS Access (2010) Developer/Business Analyst to reverse-engineer and update a custom built MS Access database linked to Datamatics timekeeping solution converting COBOL code.

Created a GUI utilizing stored procedures with Datamarics – TC1 (SQL) database to streamline payroll processing integrating MS Excel.

Bank of Tokyo Mitsubishi UFJ (1/13 – 12/13)

Compliance Operations

Retained as a MS Access Developer to develop a custom database to replace and enhance functionality of the existing Excel based models.

Design a system to meet complex business needs, where multiple users will access multiple data points through a configurable, roles based workflow and user interface.

Code, test, debug, implement, and document moderately complex programs. ROSALIND M. TRIGGS PAGE 3

Transfer Pricing Unit

Retained as a MS Access Developer to develop a custom database application in MS Access 2010 for calculating, billing, invoicing, documenting, and maintaining various transfer pricing services.

Design, development, and maintenance of an Access database tool that will enhance the efficiency of the Transfer Pricing Unit utilizing SQL and VBA.

Create and maintain documentation of data related programs and processes for assigned tasks.

Report to management on the status of project efforts, identify issues that inhibit the attainment of project goals and implement corrective actions.

Create and run programs to load data and resolve data issues. ICAP (2/12 – 5/12)

Retained as a Data Analyst/MS Access Developer to design a GUI allocation that models an objective cost allocation methodology that provides Finance with transparency and control over the allocation of non-IT infrastructure costs.

Ascertain the required master data structure including hierarchies and entity mapping aligned with reporting dimensions which includes aligning and mapping the chart of account and cost center structures to the P&L structure.

The process is controllable, repeatable, and adjustable which improves data quality of analysis done by Finance. Blackrock (7/11 – 9/11)

Retained as a MS Access Developer to enhanced a headcount forecasting database to be used by a global finance organization on a monthly basis to reduce operating time and improve efficiency.

The database is populated by various source systems to create a consolidated view of the company's current and projected headcount at the lowest cost center level. Designed an Excel template for reporting which is populated with data from the database. Prepared required documentation, including both program-level and user-level documentation.

EARLIER CAREER HIGHLIGHTS

JPMorgan Chase – Business Data Analyst / MS Access Developer Streamlined data collection for client services by consolidating multiple data sources into a centralized CRM dashboard. Developed ETL logic, data validation routines, and real-time metrics reporting to support enterprise decision-making.

NYC School Construction Authority – Data Analyst / MS Access Developer Designed and implemented Oracle-backed Access applications to automate vendor outreach workflows, reducing reporting time and supporting supplier diversity compliance tracking.

NIKA Technologies, Inc. – Data Analyst / Developer Implemented project tracking and asset management systems, migrating over 20 Excel-based tools into relational databases. Delivered structured data models, dashboards with drill-down analytics, and Gantt-based project visibility for executives.

Citigroup – Latin American Private Banking – Process Improvement Analyst Engineered an automatic data-feed process integrating Excel models into Access with VBA and SQL, enabling general ledger balancing, revenue forecasting, and metadata repository creation for regulatory reporting.

NYC Law Department / Debevoise & Plimpton LLP – Business Systems Developer Developed and enhanced workflow tracking databases supporting document production and billing. Designed data dictionaries, process flow documentation, and role-based access for multi-unit departments.

Maritime Bureau, Inc. – Project Manager / Developer Migrated Access-based claims tracking into an ASP.NET web-based version, coordinating onshore and offshore development resources and implementing quality control for insurance reporting.

IBM / Morgan Stanley Dean Witter – Corporate Trainer / Metadata Repository Developer Designed a metadata repository with an Access front-end and DB2 back-end, mapping legacy systems to enterprise data structures (EDB). Standardized business rules, semantic definitions, and impact-analysis processes across data domains — an initiative directly relevant to MDCPS’s enterprise data stack and semantic modeling goals.

ROSALIND M. TRIGGS PAGE 4

EDUCATION AND PROFESSIONAL DEVELOPMENT

Bachelor of Arts in Business Administration Management Saint Leo University, Saint Leo, FL

MOS Certification Number: 10642917

TECHNICAL PROFICIENCIES

Software Languages Databases

Word Crystal Reporting BASIC FORTRAN MS Access DB2 AWS S3 PowerPoint Vignette 7 COBOL SQL Dataease ERWin 3.2.5 Excel (Advance) Outlook HTML VBA Model Mart 8 Oracle VISIO FatWire CICS JCL MS SQL Server

Adobe Acrobat MS Project ASP.net VBA Sybase

Sharepoint FileSite MVC framework

iManage ChangePro JavaScript Python

Laravel

Contact this candidate