Deborah Bean Email & Phone Number

Rowlett, Tx, Us

• Manage corporate accounting, including reconciliations, income taxes (1120S and K1s), A/P, A/R, State franchise Tax, and other documentation.• Observe in-progress operations to identify important steps for technical instructions for ISO 9001 documentation, providing crucial system information as well as accounting assistance.• Provide accounting assistance to clients in Quickbooks and QBO.• Expert in MS Office, including Word, PowerPoint, Excel, and Snagit. Skilled in Adobe Acrobat, Go Visually, SharePoint, Google Docs, and other editing and shared-spaces writing software via the cloud.• Collaborate with authors to edit narratives for publication using CMS, AP, APA, or other style guides. Projects included encyclopedia-style books to sound scientific but read at a high school level and procedural boardgame rules documents.• Interpret and convert ESL or translated material by non-native English writers and edit to American vernacular. Change reading comprehension level to desired audience.• Write essays and short fiction. Submit to publications and contests for publication and awards. 3D Powder Coating—Assisted with ISO 9001 documentation. Provide accounting software support.Petersen Games—Edit procedural manuals (rulebooks), novels and short fiction, and reference guides. Edited ESL writers’ text to American vernacular.Expert in MS Office, including Word, PowerPoint, Excel, and Snagit. Skilled in Adobe Acrobat, Go Visually, SharePoint, Google Docs, and other editing and shared-spaces writing software via the cloud.

Charlotte, Nc, Us

Facilitate daily scrum meetings, reviews, and retrospectives for the Closing Services Datamart/Reporting team. Work with the line of business and the product owner to create user stories and document requirements so that the stories can be refined and then assigned to sprints. Facilitate meetings with vendors and customers to analyze user needs and implement solutions through Agile development. Assist in the QA and Release processes. Assist in the requirements for Tableau reports and dashboards for multiple groups.For the Closing Services Manual Valuations team, create discovery and requirements documents for the development team in a multi-year initiative to bring on additional appraisal vendors online to decrease valuations costs. Create XML schemas to be used by vendors to return valuation data. Research issues for other teams and coordinate activities in the development and QA processes.

Herndon, Va, Us

Support Development, Data Warehouse, and Conversion teams by creating Source-to-Target and Technical Requirements documents to be used in the conversion of data from XO Communications system to Verizon. Decipher existing code modules, workflows, and mappings of current systems in Informatica, DataStage, and Oracle that move and transform data across multiple platforms and into multiple repositories that support business functions across the entire enterprise. Functions analyzed include: Commissioning - calculating bonuses and accounting for salespeople; Connecting - importing Dun and Bradstreet Marketing data for ETL; Trafficking - processing transactions occurring across company data lines in a complex ETL workflow; Telco Accruals - extraction of rate data by country, city, and dial codes on a monthly basis along with cost records with transactional and summarized data for accruals across multiple categories. Tools included Excel 2016, Visio 2016, Informatica PowerCenter 8.0 and 9.1, IBM InfoSphere DataStage 9.1, TOAD for Oracle 12.0, SharePoint.

Chicago, Il, Us

Create a system to track reporting data elements for the Loan Management System conversion from Daybreak 2.0 to Oracle OFSLL system. Analyze over 400 reports to determine report data sources for fields, calculations, and aggregations in each report and capture those details in a spreadsheet that will be used to track the intermediate placeholders of data through the conversion to the new target databases. Reports currently run from multiple databases, such as Production, Month-End, Snapshot, and Data Warehouses, through multiple systems including Oracle Reports, SAS, Business Objects, and SQL extracts. Information analysis will allow developers to reduce most of the reporting from Production and other databases to the data warehouse only, with few exceptions. Project will replace all Oracle Reports with new reports using Business Objects.

Us

Design, develop, and maintain databases using MS Access and VBA to support Compliance, Internal Audit, and Model Risk Management groups within the bank, in order to support requirements by the Federal Reserve, FHFA, and other regulatory bodies. Support and train users in MS Access as well as document the Access databases. Provide reporting support for Tableau reporting. For the EDM project, document data flows and user requirements at a high level for management in order to support the data strategy leading to a data warehouse. Tools included MS Access 2013, Tableau, Visio, and Excel.

Dallas, Texas, Us

Update and maintain the custom AMS system designed in MS Access 2007 with MS SQL Server back-end. Create and maintain stored procedures, functions, triggers, views, and queries in SQL Server 2008. Write VBA/ADO/DAO/SQL code within the Access front-end. Program consists of three platforms with over a dozen databases in each platform and almost half a million lines of code in VBA and SQL for the globally integrated asset management company that performs due diligence and analysis, asset management, foreclosure, and pledged asset recovery processes, and other support services for Lone Star Funds, a leading private equity firm that invests globally in over 700K distressed assets valued at over $95B.Write and maintain documents in the Knowledge Base to provide information to other developers and testing personnel. Tools included SQL Server 2008, MS Access 2007, Visio, and Excel.

Charlotte, Nc, Us

In a short-term project working on the new Consumer Finance Protection Bureau initiatives mandated by the U.S. Federal Government concerning loss mitigation and loans in default. From 32 vertical projects, the horizontal Reporting and Data Management project addresses the data needs and impacts to various departments and numerous databases. Verified that all requirements for the ODS are documented in HLDs (High level documentation) and LLDs (low level documentation) and followed up on by various units within the loss mitigation process using a traceability matrix. Update the Data Impacts documentation for the issues and changes affecting the project.

Supervise creation of documents used to supply MTD Summaries, Monthly Accruals, and Monthly Invoices data for various clients and categories of billing programs to Finance and upper management. Design and maintain code that tracks changes in loans for management reporting.Oversee loading of loans into the enterprise system of record (Prospector) from Client systems (Salesforce.com, Equator, etc) and/or spreadsheets. Create systems to provide a link between client and company data; tracking multiple iterations of received loans and calculating loan types, statuses, and other information required for the processing of loans through the Deed in Lieu, Deed for Lease, and Short Sale Proactive and Reactive actions.Design, develop, and maintain Salesforce.com reports and dashboards for the Call Center, Listing, and Asset Management departments, as well as upper management. Work with the Bank of America Salesforce.com team, providing insight into the requirements, during the conversion from a shared data object to a custom data object specifically designed for REDC. Oversee the transfer of active and historical data from Prospector to the new Salesforce object.Provide mentoring and training to other analysts in the use of SQL Server 2008, MS Access, and Salesforce.com.Tools include SQL Server 2008, SSIS, MS Access and MS Excel 2007, Salesforce.com, Visio, Prospector, and Equator.

Basking Ridge, Nj, Us

Create and write training guides for the CPM Dashboards project. Systems covered include OBIEE, VSII, and Oracle BAM. Learn associated systems to be able to understand functions, screens, and tools so that training manuals cover the subjects well enough to answer most questions. Become a subject matter expert in the use of these systems.Provide feedback to testing group when functions do not work as designed or when errors encountered.

Plano, Tx, Us

Convert documents created in previous version of customized software, Complete Closing Enterprise, to new, completely redesigned, web-enabled version. Documents are written in customized document creator inside the program to build standard mortgage and title documents, such as the new HUD forms, Warranty Deeds, Purchaser Statements, and many others.Created and maintained Document Mapping spreadsheet to match old data objects to those in new database and object model. New software has updated database to allow multi-HUD tables and columns along with many other database changes.Identify database gaps and missing document fields and issues in new software as elements of the documents are tested and data is input into the records to act as testing records of the new documents.

Addison, Texas, Us

Create, write, and edit a 400-plus page user manual for WebChart, an electronic health records solution program from MIE which has been customized and enhanced for Concentra clinics. Perform extensive research on the program to learn its usage in Concentra clinics. Capture and modify over 1,000 images inserted into manual as screen shots. Become SME on program for new trainers.Design and write WebChart training workbooks used in training classes for new clinics. Modify training materials for specific clients. Create 1-page quick reference guides for use by personnel at wellness events across the country. Create process flow diagrams for various modules of the WebChart program.Create and write a training guide and quick reference guides for ZeOmega's Maya System, a physician review program used to make determinations on patient care, which required learning the program.Create quick reference guides, forms, and process flow diagrams to aid medical personnel in conducting wellness events and deployment health assessments. Tools include MS Word, Sharepoint, Visio, MIE WebChart, ZeOmega's Maya System, Lotus Notes

Create and maintain OOD data dictionary of over 10,000 objects for web-based software which provides mortgage analysis for clients holding loans with a high risk probability of default. Analyze data needs and determine formulas for complex derived fields. Work with developers and business experts to assign data types and structure, and domains, subjects, and topics of objects. Interface with third-party vendors to determine transfer requirements, including encryption.Design and develop module prototypes for Property Valuations, Limited Fraud Review, and Alternative Claims Recovery business segments. Property Valuations tracks and displays third-party reports to determine and set current value and other metrics for properties. The results and other client and industry data are used to determine the best strategies and tactics alternatives available to clients to reduce the probability of default using modeling software. The Limited Fraud Review program collects data from loan origination and third-party information to determine if there was material misrepresentation in the loan origination process. System includes basic doc management of client and third-party images, work-flow tasking, and loan and reviewer histories. In addition, a summary creation process allows reviewers to select from pre-calculated scripts that include uploaded data. Created paragraphs are inserted programmatically into a Word template using bookmarks, not mail-merge. Automatic Acrobat PDF manipulation within MS Access is also included in the system.The Alternative Claims Recovery program creates information that allows clients to force loan originators to buy back loans that show origination fraud. Loaded data can be viewed on forms that mimic actual loan documents. Analysis of that data, along with third-party reports, is performed on multiple aspects of the loan portfolio. Workload controlled by a tasking system loans which tracks in each stage of the process.

Short-term assignment to develop an internal reporting system for the Consumer Relations Group for contacts received from customers and consumers via the 1-800-DrPepper and other product phone numbers. Data downloaded from 3rd party vendor with new and changed contact records on a daily basis into new Oracle business intelligence system. Wrote business requirements and functional spec documents. Designed table structure and scripts for daily processing. Created test plans to verify accuracy of download and processing procedures. Designed reports containing summaries, charts, graphs, parameters, filters, and formulized groupings with suppression and drill-down logic incorporated to provide detailed information down to the detail level. Adobe SWF (Shockwave Flash) dashboard components added using Flash variables to allow updated Crystal data to be reflected in the dashboard component. Implemented report distribution using SAP Business Objects, Crystal Reports Server, and Infoview.Supervised DBA, systems developer, and data architect to create required objects used to hold and process 3rd party vendor data.Designed and developed reusable management report and dashboard components for insertion into documents, presentations, and web-based reporting using Crystal Xcelcius 2008. Use of Xcelsius components reduced quarterly management reporting creation time by 50%. Wrote training documents and trained users in Crystal Reports and Crystal Xcelsius development. Tools used included Crystal Reports / Crystal Reports Server 2008, Crystal Xcelsius 2008, Access 2003.

Us

Design, develop, and maintain legal documents for Oracle-based custom software using Crystal Reports Professional 10.0 that controls record and document processing for mortgage company clients in the housing foreclosure market. Reports mimic actual documents and forms required by state and local courts, HUD, and federal bankruptcy courts. Crystal functions include parameters, sub-reports, suppression and formatting logic, and Oracle back-end. Create, maintain, and modify code of proprietary NDTS.NET software using SQL written in Toad Oracle 9.0. Created views, packages, and functions to provide report datasources and to process records with events, updates, and document generation tasks. Other tools used include Visual SourceSafe 8.0, Seapine TestTrack Pro 6.0, PL/SQL, and ReportMiner 3.0.

Designed and developed custom reports for the TCL (Fair Isaac) software system using Crystal Reports. Crystal functions implemented included parameters, sub-reports, charts and cross-tabs. Validated data to correctly reflect the actual values of the mortgage portfolio across all reports. Updated TCL menus to reflect changes and added new reports. Crystal Reports Professional 10.0., TCL–The Construction Lender 8.10.Created SQL views and stored procedures using SQL Query Analyzer and Transact-SQL as data source for Crystal Reports. Code included user-defined functions (UDFs), temp tables, update functions, and nested queries. SQL Enterprise Manager 8.0. Documented change requests using Remedy One Support Console. Maintained Test Director 8.0 files to track QA defects and their resolution. Tracked report and code versioning with Visual SourceSafe 6.0.

Provided consulting services as Subject Matter Expert, Business Analyst, and Developer to develop customized software, upgrade networks, and maintain existing systems. Projects included:Wings Data Solutions – Designed textbook tracking system for school districts. Created ordering function with infinite number of custom-designed steps. Initiated test plans. Microsoft Access 97 and 2000 with SQL backend. PGA of North Texas – Designed enhancements to the Jr Golf tournament scheduling website and database. Microsoft Access and HTML.Christian Single Adults – Re-wrote and re-designed dating service software originally created in Access 98 and converted to Access 2000 and SQL with web functionality. Directed JAD sessions. Multiple Clients – Provided technical support of existing networks and Peachtree software for problems such as database corruption, security, and network drops. Multiple clients – Set-up contact management systems in Act! 3.0 – 6.0 including client-server setup.

Certificate, Creative Writing

Management Information Systems

Associates, Data Processing