SQL
Patricia M. Woods
Customer Service/Business Analyst
Van Alstyne,TX
Summary
Highly experienced in customer service, data management and list circulation/campaigns using organizational skills with attention to detail. Ability to develop strong relationships with internal and external clients.
Overview
15
15
years of professional experience
Work History
Business Systems Analyst
Epsilon Data Management
01.2019 - 01.2022
- Use SQL server to query data tables,data analytics and run procedures
- Executed 34 Ad-hoc procedures for client processes using SQL and ticketing systems
- Performed Matchback using Campaign Unica
- Validate new data and migrate data feeds to database or export data to outside vendors
- Manage database production schedules to guarantee client deadlines are met
- Develop and maintain Quality Control documentation of processing steps
- Collaborate with team members to identify process enhancements or to troubleshoot issues
- Use SQL server to query data tables, do data analytics, and run procedures
- Run Ad-hoc procedures for client processes on multiple schedule timeline
- Validate new data and migrate data feeds to database or export data to outside vendors
- Manage database production schedules to guarantee client deadlines are met
- Develop and maintain Quality Control documentation of processing steps
- Collaborate with team members and customers to identify process enhancements or to troubleshoot issues.
Quality Assurance Manager
D3 Data
01.2016 - 01.2019
- QA Data integrity using spreadsheets and data management process flow
- QA campaigns using sort / filter / pivot tables / Vlookup in Excel
- Effectively identified, communicated, and escalated issues to appropriate department and made recommendations for improvement
- Collaborated with team to determine schedules and track schedule completion
- Point person for prioritizing work and to work with office coworkers for all job’s completion using JIRA
- Collected and tracked weekly update numbers to analyze trends of marketing activities, which included use of Excel formulas
- Analyzed trends for all daily and monthly production using Excel spreadsheets and relaying results to Account Managers
- Created and implemented procedural documentation for all clients.
- Monitored staff organization and suggested improvements to daily functionality
Business Systems Analyst
Epsilon Data Management
01.2013 - 01.2016
- Spoke with clients regarding database updates and helped with any issues encounter
- Received client files, ran weekly and daily updates for specific clients on their data warehouse and DataMart
- Performed Ad-hoc procedures for NCOA processing, Demographic, model score, AMF, promotion history selection and ran refresh on List Rental universe
- Executed SQL to verify updated loads were correct and watched trends in client data
- Attended client meetings, followed client schedule of procedures, and monitored client database loads
- Manipulated data if needed before any ad-hoc run using UNIX and JCS
- If database/job failure occur, contacted correct group or person
Customer Service Rep/ Business System Analyst
Epsilon Data Management
01.2007 - 01.2013
- Managed Direct Mail campaign instructions from client, set up job according to instructions to accurately fulfill brokers list requests
- Received data files from inside/outside vendors in various file format and loaded them to UNIX system for data cleansing, manipulating of files, merge/purge, presort and inkjet, and sent files to mail house
- Created and analyzed various reports ensuring quality/quantity in automated system, correcting problems while maintaining schedule time, and advised client of data trends
- Created, maintained, and adhered to mailing schedule for DM campaigns, streamlined process to shorten processing time
- Collaborated with clients to PGP and SFTP files to outside printer, process invoices
- Created and reconciled billing and invoicing to verify accuracy.
Skills
Customer Service
Flexible and Adaptable
Problem-Solving
Documentation abilities
Production support
Software
Excel
Unica
Jira
Unix
Timeline
Business Systems Analyst
Epsilon Data Management
01.2019 - 01.2022
Quality Assurance Manager
D3 Data
01.2016 - 01.2019
Business Systems Analyst
Epsilon Data Management
01.2013 - 01.2016
Customer Service Rep/ Business System Analyst
Epsilon Data Management
01.2007 - 01.2013