Cheryl V. McGarrigle Tel: 757-***-**** Email: ac021a@r.postjobfree.com
Education
Tidewater Community College, Database Specialist Certification Completed 2011-2014
Old Dominion University, minor credits 2001-2002
Bachelor of Arts-Liceo de Cagayan University, Philippines-Graduated 1986-1990
School and Personal Experience
-Create SQL basic and complicated query statements
-Used SQL command types such as DML/DDL/DCL statements
-Created Function and familiar with PLS/SQL block structures
-Build conceptual, physical and data models
-Knows how to create table/tablespace/constraint/data type
-Installed Oracle 10g. Navigate and work with Oracle Enterprise Manager
-Knowledge in Backup and Recovery, Export/Import Utilities, RMAN
-Design Entity Relationship Model. Design HR Health enrollment process using Oracle Forms
-Familiar with Performance tuning and other enhance feature within Oracle 10g, OEM
-Reviewing for Oracle 10g, Associate Certification
Professional Experience
LoanCare, LLC Virginia Beach, VA
Letter Librarian (6/12-4/2016)
-Owned and manage letter migration project to new vendor which includes data mapping, creating business requirements, testing, quality control all the way to releasing to production. --Defines data requirements, gathers and validates information, applying judgement and data transmission tests. Work closely with IT department for assigning index type for transmitting images back FileonQ document system. Create documentation and procedure for all letters migrated to new printing vendor. Build Image letter on MSP system using Online Letter Writer. Create Microsoft Word Mail Merge for in-house production letters. Gather business requirements and field code from system navigator to build new letter. Build Passport query and validate output for data necessary for new letter. Work closely with Compliance and business owners for State and Federal letter regulations. Point of contact for letter issues. Build supplemental file using Monarch for data element letter type. Test new letter types for sample image and transmission validation. Responsible for reviewing new letter sample for accuracy of variable data. Create Monarch Project for state specific regulated breach letters. Research and resolve Footprint ticket letter issue. Prepare monthly vendor invoices to corporate accounting for payment. Run daily/weekly/monthly management reports as back up. Maintain digital copies for letter library. Work with minimal supervision, to deliver on schedule, and to coordinate and prioritize multiple job requests. Perform all other duties as assigned
Bank of America Norfolk, VA
Operations Analyst (03/03-10/07)
Business Recovery Plan coordinator responsible for maintaining, testing and participating to Regional Exercises. Compliance Auditor for Management Control Review Program. Involved in User Acceptance test for IMAGE and Total Systems. Involved in testing effort for system conversion of Fleet Bank and Bank of America Transition 2005. Created associate's Job Aid for Bank's system TSYS production letters
Bank of America Norfolk, VA
Administrative Assistant (09/99- 03/03)
Provided administrative support to the department managers and its direct. Spearheaded the resolution of all facilities issues. Maintained toner for 14 printers, 3 faxes and 200 boxes of paper supply on time. Updated organizational chart and distribute to management team. Administered newcomer kit such as id badge, parking decal & systems sign-ons. Administered security of access and updates to associates personnel files. Open troubleshoot ticket for major contract office equipment such as XEROX machines and HP fax/printers. Arranged hotel and flights for traveling departments manager. Reserved conference/function rooms for departmental or Hall meetings. Bankcard Data Security Liaison responsible to create/add/delete User accounts
Adecco Staffing Agency, Client-CH2M Hill Chesapeake, VA
Administrative Assistant (01/98-01/99)
Created album, filed and type description of photos taken at the construction site for record. Made appointment to contractors for onsite work. Answered phones and greet clients warmly. Performed basic bookkeeping duties. Compiled financial records. Rerouted calls appropriate people. Help organized office activities. Make copies for meetings. Operated office machines, such as photocopiers and scanners, facsimile machines, voice mail systems and personal computers. Take and deliver messages. Received Manual and Operating procedure from vendors. Create colored filing system for the City and the main office. Sorted distribute incoming mail. Fixed/and or open ticket at 1-800 support for malfunction equipment. Schedule meetings and conference rooms. Call IT for computer assistance. Performed data entry. Restock supply closet with printing paper, ink, clips, staples and other desk office supplies. Create, file and type documentation for the photos taken at the construction site. Back up weekly files every Friday.
Pegasus Travel State of Bahrain
Administrative Assistant (06/93- 06/94)
Provided customers with travel suggestions and information such as guides, directories, brochures, and maps. Answered phones and greet clients warmly. Contacted motel, hotel, resort, and travel operators by mail or telephone to obtain advertising literature. Made travel air, train, or car travel and hotel or other housing accommodations. Create and maintained active files. Initiated purchase requisitions. Ordered office supplies and equipment. Performed basic bookkeeping activities. Created and maintained database records. Managed front office operations. Managed department manager's calendar.
Activities/Organizations
Board Member-Norfolk Sister City Association-Non-Profit Organization
Chair, Philippine Committee, Norfolk Sister City
Participated in International Medical Mission
Professional Development
Proficient in MS Office Word, Excel, PowerPoint, Outlook, Access
Experience in MSP (Mortgage Servicing Platform).
Experience in PASSPORT--a query tool to MSP.
Experience in MONARCH strip data tool application.