Abby Shuler Email & Phone Number

Charlotte, North Carolina Area

* Learned applicable FCC regulations and CBBD remediation processes, proposed customers with no accounts and other unique populations have processing reflective of their lower KYC requirements* During Short Staff event led KYC Manual update project from June til October 2018* Wrote macros to automate manual parts of reporting procedures where possible, alerted management to unusual trends in data flow (stale data, stop/starts in data flow), compiled ad hoc reports* Multiple reports concurrent through week used inside CBBD FCC as well as external to CBBD FCC* Quality checked unresolved KYC flags for further remediation work and followed back up with original case worker to go over findings if remediable, leading to an increased in percent remediated.* Tracked Mortgage products for later outreach, which became a larger project of tracking customers with only one product that is non CBBD for possible BL reassignment.

Wellsfargo

* Elicited requirements for a multi stage and multi pipe data transformation project, built spreadsheet using excel formulas and an xml export sheet.* Ran 3 weekly reports calculating employee and contractor hours worked

Charlotte, North Carolina Area

Fielded SQL report requests from LoB representatives, tech partners, VPS, and CIO; took business requirements and designed and wrote SQL queries joined across multiple tables using advanced structures such as listagg, firstrow, concatenate, case/when, and filters based on attributes as well as metrics, over 500 unique queries written last year, over 1000 total reports written for year. Audited SQL exports matched business requirements; if gap existed, analyzed and resolved any discrepancy.Independently translated over SQL queries from old Oracle database to new Oracle database using 'describe' function and rebuilding joins. Ran 50 ongoing monthly, weekly, and quarterly queries in addition to managing all ad hoc query requests, for a total of 500+ unique SQL queries a year. Analyzed individual fields within CMDB for data quality for use in data sourcing, designed and built ServiceNow and Tableau reports for both Data Quality Metrics across CMDB fields, as well as Server Scanning Metrics. Advised internal clients of database changes that may be useful to them in their reporting requirements, field changes, and responded promptly to questions regarding reports. Guide users in step by step process of self service items for updating application and server information. Quickly learn new programs and new programming languages as presented.

Charlotte

Improved tracking of unlocated & at-risk assets, met and doubled year end goal.Strong time management skills and the demonstrated ability to perform tasks and meet deadlines with minimal supervisionRolled out nationwide initiative to 41 GCs in market, to track equipment released from warehouse, served as model for subsequent markets.Harvested Vendors and Field Engineers knowledge to improve processes.Worked with Equipment Engineers and Vendors to keep Equipment waiting for collection from Dock under age limit, since August 2014 aged material at $0.Created several daily high level reports consolidating large data sets from multiple sources with pivot tables to drive team and track progress towards goals. Compiled reports with VBA.

Charlotte, North Carolina Area

Assist with site acquisition for Property. Update necessary tracking system(s) to ensure that project and/or program status is maintained with complete accuracy.Provide data migration to support management ensuring accurate tracking of budget through vlookupsDevelop and maintain accurate and complete files for projects and programs; continues to monitor for integrity and completeness.Provide ad hoc reports as requested.

Charlotte, North Carolina Area

Auditing closeouts, quality control, processing work orders, scheduling, PO matching

* Only PC to support 3 divisions, or to handle both Oracle and database, used VBA to automate a report that took 2 hours to compile, running it in 10 minutes.* Accurate and timely purchase orders in Oracle, highest production rate of company.* Data transformation from MS Excel to SQL jobs. * Produced & upload required reporting documentation through AT&T contracted data management software: NORAD, CASPR, Siterra.

Accurate recordkeeping and file management in high turnover environment.Implemented Quickbooks Point of Sale software.Data Mapping and migration from Excel table into Quickbooks Point of Sale of both accounting database and customer database.Trained employees on use of QuickBooks Point of Sale. Data hygiene practices grew and resolved errors in database, reducing bounced emails by 99.04%. Resolved issues regarding financial transactions, purchase history, commission rate changes, and inventory movement. Compiled records for each artist’s monthly sales. Designed sales flyers, imported addresses from MS Excel into MS Word, Constant Contact.

Archaeological survey and site mitigation for earth moving projects such as pipelines, highways, and work sites.Document research in State government offices in order to build archaeological site database in Access, and create a statistical model using Excel.