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.

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.

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.

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.

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.

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.

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.