Erika H. Email & Phone Number

San Antonio, Texas, Us

San Francisco, California, Us

• Project managed data issue remediation from cradle to grave.• Created Project Plan for the implementation of BCBS 239 (Basel Committee on Banking Supervision Standard 239) for the Retail Lending and Deposit Treasury Management banking domains. (Systems MSP and Hogan).• Ab Initio Data Quality Environment trained in Express>IT and EMH (Enterprise Meta Data Hub)• Worked with business and technology owners to gather data quality information for data lake ingestion such as System Interface Agreement, Onboarding documentation, Data Movement and Front-End Control requirements. Completed required documentation and obtained business and technology approvals.• Worked with data profiling team to obtain data insights for rule specification documentation.• Ensured data quality rules were written for the domains Retail Lending and Deposits Treasury Management for 4 data layers (Raw, Sanitized, Conformed and Curated) for ingestion into the data lake and obtained business and technology partner approvals.• Ensured testing of data quality rules in Ab Initio in DEV/UAT and PROD environments including Configuration verification, SQL script verification and primary key verification.• Submitted 60+ process improvement suggestions and worked with the Data Quality monitoring team through implementation utilizing JIRA.• Initiated a bi-weekly “Mastermind meeting” to help 8 new associates integrate and train each other and knowledge share on data quality processes.

Dallas, Texas, Us

Project managed the improvement of the Unified Loan Delivery Data (ULDD) to Fannie Mae and Freddie Mac.• Worked with the Capital Markets senior leadership to develop the plan to improve the data upload to ULDD. Drove complete reduction of data errors by leading a team of business stakeholder, technical analysts and developers.o Researched data deficiencies using SQL Server Management Studio, querying across 6 servers and 5 applications. Created reporting to visually track next steps, assign ownership, completion due dates as well as track implementation milestones for control purposes.o Created user stories and acceptance criteria for the fatal, warning and informational errors resulting from data delivery according to agile methodologies.o Worked with scrum master and development teams to drive change and managed projects from cradle to grave.o Provided daily and weekly executive updates verbally and in written form as to the status of projects.• Worked with Capital Markets senior leadership to obtain requirements and developed a reporting suite utilizing SQL and PowerBI for financial data such as SPIFF Reconciliation, Branch margin Changes, Best Efforts pipeline, Escrow Holdback, Investor Audits, Bond Production, Investor production, HMDA reconciliation, Purchase Advice reconciliation, Shipping and Purchase Clearing, Incentive tracking, Max Price Cap changes and many more.

Farmers Branch, Texas, Us

Lead the Product Management team to a successful implementation of JIRA as the new production issue, project- and release management software.• Managed a team of Business Analysts and Systems Administrators through the various end to end cycles of production environment. • Developed tools and processes, based on industry standards to optimize systems.• Lead team to improved efficiencies.• Developed a cross-training plan to ensure a balanced workload as well as business continuity.• Monitored daily tasks of team and communicated results to senior management.• Conducted talent management including goal setting, performance monitoring and performance reviews.

Lewisville, Tx, Us

Project managed the LoanSphere vendor invoicing process for the Title Division to mitigate issue of invoices not extracting nor loading successfully. Was able to successfully increase the invoice upload success rate to 94%.• Met with multiple stakeholders, Executive management, System admin, Database administrator, and front-line employees to research people, process, systems and data. Created project plan to drive success.• Conducted employee side by sides to understand system user interface, user input and procedures. Researched servers, tables and data that corresponded to the front-end process. Created and documented project timeline and business requirements.• Presented findings (BRD), gathered and developed and documented data scripting requirements and obtained necessary approvals. • Developed SQL script prototypes from various data sources and servers. Worked with developers to implement new data delivery processes.• Created a project plan and drove team tasks by facilitating weekly meetings and kept executives and stakeholders updated on project progress.• Worked with frontline employees to test and validate production data and process.• Created a control plan for the invoice upload validation errors. Worked with executive team and assigned review tasks accordingly to the newly developed process.

Ashburn, Virginia, Us

Traveled to client and presented solutions on behalf of DXC’s SaaS Loss Mitigation product “EarlyResolution”. Lead the project team for the software implementation and problem solved utilizing all SDLC departments including Requirements, Design, Arch, Dev and UAT while in multiple “War Room” settings.• Project managed and ensured best practices and strict timelines were being followed at all times and documented processes to ensure global optics and project handoff.• Provided projected labor costs and tracked against the actual costs and consistently delivered under budget for the client. Provided weekly executive updates to clients and internal leadership.• Interacted with stakeholders/executive management and team leaders as the SPOC Release Manager facilitating ticket prioritization, lead scrum meetings including testing statuses, environment and build updates as well a defect tracking through each assigned SDLC iteration.

Charlotte, Nc, Us

Project managed the Mortgage Default Inventory issue reduction.• Drove change to reduce at risk aged Mortgage Default inventory (multiple business units) outside of SLA by 99% (40% to 0.4%) from Feb 2013-Feb 2016.• Routinely met with key stakeholders/executives from various lines of businesses to interview and identify critical to quality (CTQ) key data points. Collaboratively worked to identify process milestone cycle times as well as ranges and tolerances to measure processes. • Created Control Plans by using SQL from various data sources and servers. Developed detailed and accurate executive reports/dashboards to track aged inventory (root cause analysis) providing issue illumination, key stakeholder identification, process ownership and remediation timelines. • Separated impediments into categories based on people, process or system issues:o For people issues, worked with stakeholder to identify resource gaps as well as knowledge/training gaps and worked together to identify next steps for remediation.o For process issues, monitored set metrics and gained insights into process versus policy/procedures. Developed Visio process flows for clarification on resource input/output details. o For system issues, created and designed technical specifications for IT/IS system and reporting change requests to mitigate system defects or changes and monitored from initial request to implementation (complete SDLC).• Produced weekly executive decks for routine business reviews and presented risks/remediation paths, business ownership and accomplishments as well as to discuss prioritization.• Hired, trained and led a team of 5 SQL script developers for 3 business units.• Six Sigma Fundamentals completed (60 hours)

Us

IT/IS Systems Analyst for Originations and Inventory Management System from origination, processing, underwriting to post closing with the responsibility for the complete SDLC including business requirements gathering, analysis, design, SQL data modeling and mapping, SQL script development, testing, system change implementation and post production validation per industry standards.• Developed Reporting from multiple servers/data sources.• Created Investor reporting including weekly, monthly and adhoc according to guidelines.• Created business unit reporting suites according to business requirement working sessions.• Analyzed business conditions and recommended technology improvements. • Assisted with the rollout of the Loan Origination system ISGN Diamond to over 200 offices/1500 employees and provided IT/IS system and data support.• Created SQL scripts and delivered executive ad-hoc reporting using data from various sources and servers.

Eqf Level 6 (Bachelors), Management Information Systems

Eqf Level 4 (Vocational Degree), Business Administration

Education record