Kym R. Email & Phone Number

* Managed financial variance, trend, and ad-hoc analysis for Servicing Project Portfolio financials including oversight on Cost Benefits Analysis (CBAs)* Partnered with Finance to build expense and forecasts for projects, driving monthly, quarterly, annual expense views as well as hits and misses on benefits* Performed data discovery, modeling, and defined business rule transformations using advanced T-SQL in partnership with the management team, both operational and corporate* Packaged presentations and drove conversations with senior leaders in Servicing, Finance, and IT to provide value-added insight around portfolio performance* Critical thought architect for evaluating future expense opportunities and risk* 4/18 to 02/20 Team Lead for offshore BI development and maintenance of 50+ SSRS and Tableau reports

* Scrum Master for onshore and offshore combined team* Lead feasibility and requirements meetings to obtain business and functional requirements for IT system enhancements that align business goals, IT Initiatives, and technology considerations* Oversaw use case development, requirement drafting, test plan definition and execution, defect tracking, and release management using Jira* Created and maintained complex Visio business process models and technology flow charts* Technology Level II support for r.e.Cascade℠, a comprehensive end-to-end software solution for management and disposition of client real estate assets

* Provided professional expertise and best practices using Velocity methodology to perform rigorous analysis on data, systems and business processes to mitigate risks and define data quality strategy to support each client’s unique data quality needs* Effectively installed, configured and deployed Informatica Data Quality (IDQ) architecture, software, and web service across client enterprise* Defined data quality business rules and built data quality scorecards during initial data analysis to classify and prioritize areas of concern, display key quality characteristics of client data and track improvements over time using identified relevant data sources* Applied data quality processes such as Cleansing and Standardization, Grouping and Matching, Exception Management, Human Task and Workflow, and Address Verification and Validation to augmented maturity of clients’ data quality system to* Trained client business and IT personnel on Informatica’s data quality methodology and best practices for analyzing, cleansing, standardizing, matching/duplication resolution, troubleshooting, tuning, and building reference tables* Documented business and data quality “next steps”, final code and project artifacts

Lewisville, Tx

* Deliver framework for data quality (DQ) rule capabilities, including guidelines and procedures currently used to define, execute, measure, report and monitor data conformance to acceptable error thresholds within the Chase Consumer Banking (CCB), Mortgage Banking (MB) line of business* Engage Data Stewards and Informatica DQ (IDQ) team throughout the Systems Development Life Cycle to translate database object characteristics, business metadata and complex SQL code into productionalized data quality rules * Validate IDQ rule syntax and Cognos rule report content against Informatica Analyst profiling results, metadata repository detail, and Teradata or Oracle test scripts* Partner with Data Quality Intake and Analysis team to establish process and controls for the assignment and remediation of data quality defects* Maintain team queue of work, SDLC date estimates and deliverables, rule status tracking, summary reporting, and DQ Data Confidence Index metrics* Promote Data Profiling and DQ Rule writing services through ongoing group and individualized training

Coppell, Tx

* Manage MIS Reporting and Analytics team ensuring timely delivery of the Home Savers Solution Network (HSSN) daily data extract and related adhoc requests * Exhaustive review of operational requirements against existing reporting processes for the identification of outdated, redundant, erroneous, and inefficient code, documentation deficiencies, and database modeling needs* Initiated and assisted in the implementation of database changes using an agile approach, advocated use of PL/SQL best practices, execution plan hints, and version control * Advise senior management by assembling, interpreting, and summarizing reconciled internal to external portfolio performance data into reports or presentations of findings, analyses and recommendations using advanced PL/SQL coding and MS Office skills* 2013 transition to the rating agency reporting team for the purpose of quality analysis, process improvement, and optimization of procedures and outputAccomplishments:* Through strategic database and process changes realized an 80% reduction in daily HSSN and monthly Moody’s runtimes, with improved data quality and resource availability* Brought real value and Enterprise success through increased project participation, collaboration, and operational support during the requirements and implementation phases of a large HSSN initiative during a time in which multiple transitions in project management and business team members lead to a drop in knowledge sharing and project regression* Initiated relationships with key representatives to gain access/exposure to resources such as LPSD, DWS, AD, Goldworks, external investor and internal reference documentation for successful and constructive validation, analysis, and reconciliation efforts (i.e. Star, ACD, T6DX, T3FN, T-Deal, BF code, Investor adhoc, and payment transactions)* 2012 Site Liaison and active member in the Women’s Interactive Network, Veteran, and Global Diversity Business Resources Groups

Irving, Tx

* Provide data solutions between business needs and functional requirements for all departments represented in the mortgage subservicing loan life-cycle* Responsible for the ticket and project related database change request process from initiation to implementation ensuring all the required elements are appropriately understood, documented, owned, and actioned * Collaborate with development teams, application owners, and business unit subject matter experts to determine data migration complexity and information gaps or conflicts against new requirements* Perform diverse and complex data analysis by writing TSQL queries across the Operational Data Store (ODS) and Enterprise Data Warehouse (EDW)* Utilize applicable artifacts not limited to Business Requirements Document, Use Cases, Workflow, Business Rules, Software Specifications, and Source-to-Target Matrices* Point of Contact for all Morgan Stanley Trade Desk inquiries and escalations to key Saxon stakeholders; management and end users to ensure data and portfolio accuracyAccomplishments:* Interim Data Services, Data Analyst Manager from February 2010 until March 2011* Created the Resource Matrix which has been adopted department wide for capacity planning, ticket tracking, prioritizing, reporting and highlighting monthly accomplishments via pivots and graphs* Represent Data Services on the Change Control Review Board since December 2010* Transferred internally to a specialized, high visibility group supporting the Morgan Stanley NY Trade Desk, January 2011

Irving, Tx

* Responsible for the development, validation and implementation of routine production and adhoc reports used by Bankruptcy (BK) and Real Estate Owned (REO) staff, executives and external customers for operations management and data driven business decisions * Use of appropriate tools and methodologies, as well as direct consultation with management and front line staff, to assess the relevancy of existing reports and to identify business needs* Creation of high quality Cognos 8 BI reports using advanced filtering techniques, prompts, conditional formatting, custom calculations, grouping, summary-to-detail drilling and other insertable object, execution, and design features* Daily utilization of TOAD for data mining, cleansing, analysis, table development and adhocs using simple to complex PL/SQL * Construction of MS Access database solutions using SQL code, GUI interface, VBA modules, and macros for export into Excel, FTP publication and automation* Tasked with the completion of monthly, quarterly and bi-annual statistical and rating reports including Fitch, Moody, and S&P* Six months of back-end Default Collections reportingAccomplishments:* Creation of BK data cube being used as the primary foundation for initial Enterprise wide conversion* Assisted in the foundation of the REO data model and code* Played a vital role in the identification and correction of flawed data field logic, allowing for more accurate and transparent reporting in both BK and REO* Member of the JPMorgan Chase Women’s Networking Group (WIN) – Dallas Chapter

Mesquite, Tx

* Solely responsible for the research, collection, and analysis of production and timekeeping records for corporate review and Department of Homeland Security contract management and billing* When data anomalies presented, a reverse engineering method was employed to determine underlying contributors via management and employee interviews, observation, modeling (Visio) and specification until a root cause was obtained* Demonstrated propensity for translating findings into high-quality verbal, written, or visual recommendations in support of management application, using the recipient’s level of understanding and business specific dialect as guidelines, leading to the redevelopment of outdated, redundant and obsolete practices* Developed intricate Excel spreadsheets with linked automated reports to facilitate internal auditing* Installed, modified, cleaned and repaired computer and electronic time keeping hardware and software for operational continuity* Designed material and subsequently provided technical support, curriculum, and training to over 400 internal users* Supervised a rotating, four-person administrative team with the daily entry of production records and weekly entry of timekeeping records and payroll activity for over 400 employees* Hired, evaluated, and provided constructive feedback for assistants* Established administrative team policy and proceduresAccomplishments:* Instrumental in the definition, development and refinement of TimeCentre and company web-based production tracking software implemented nationally * Positively effected contract renewal with the Department of Homeland Security by being a “key component in identifying and repairing many processes…” - Ernest Rojas, Site Manager

Fort Hood, Texas

16th Signal Battalion Better Opportunities for Single Soldiers (B.O.S.S.) Representative, 3rd Signal Brigade (Secondary) B.O.S.S. Representative, 16th Signal Battalion Dining Facility Soldier Liaison, Charlie Company Physical Training Assistant Program Coordinator.