SUMMARY:

I am a proven and trusted business data analyst with experience in a wide variety of languages and systems. I have performed testing, requirements development, data mining, data analytics and SharePoint Administration.

PROFESSIONAL EXPERIENCE:

Senior DATA Analyst

Confidential, Washington, DC

Responsibilities:

• Wrote all requirements, performed UAT and wrote the user guides for all new software programs in Single Family Mortgage Business Solutions product development.
• Analyzed discrepancies to determine root causes and report on issues that have significant impact to the corporation using SQL queries for data mining.
• Perform AdHoc analysis and problem resolution for disclosure - related inquiries from securities, investors, data vendors, and internal stakeholders.
• Wrote all footnotes for technical team to ensure all data discrepancies were accounted for before released to the public.
• Responsible for analyzing business and functional requirements to determine operational and technical impacts to the business.
• Partnering with the business and project team to develop Go-to-Market plans which includes identifying and implementing training and communication plans.
• Responsible for organizing, facilitating, and conducting training for the Confidential Connect Reporting (Tableau).
• Used Tableau connector to connect Adobe Analytics and Tableau, through the web data connector in Tableau.
• Used Adobe Analytics and SQL for Basic Reporting.
• Wrote the requirements and performed all UAT for the SFCER tool which is used for CDT reporting on all pilots and the lifecycle of a pilot in all of Single-Family Mortgage Business Solutions.
• Worked with the Multi-Family internal stakeholders to identify any data discrepancies from their group.

Business DATA analyst

Confidential, Mclean, VA

Responsibilities:

• Gathered all information for requirements using one on one meetings, JAD sessions, and facilitated sessions to ensure all groups upstream and downstream were accounted for in the end solution. The entire project was done using the agile methodology due to the constant changes in requirements.
• Held session with Black Knight in both the Virginia and Texas locations to ensure Single Security Initiatives were meeting all requirements and satisfying state and federal regulations.
• Created and updated Business Requirement documents and Functional Requirements documents using DOORS and Visio.
• Helped in creating solution to allow servicers to report P&I and Freddie to accept the reporting on a daily basis. Ensured the requirements lead industry standard reporting and remittance cycle.
• Created calculations for simulation of both P&I without advancing the DDLPI for loans not successfully reported. As well as calculations to provide Schedule/Schedule as the only reporting option available going forward.
• Acted as a liaison between the servicers and Confidential to ensure appropriate solution was captured in requirements for cycle changes.
• Conducted UAT testing to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements.
• Captured and tested all modifications to proposed functional requirements. Entering all results into JIRA.
• Using Adobe Analytics created dashboards for groups (supported 3rd party to bring their data into Adobe Analytics) and for AdHoc reporting.

Confidential, Herndon, VA

Responsibilities:

• Assisted in development of a tool to create the Mortgage Loan Estimate and Closing Disclosure documents and accompanying XML dataset, conforming to the regulatory data standard. The PDF image of the form is encoded and embedded in the XML file, using Visual Basic to create the form. The purpose of the Tool is to enable users to create the Loan Estimate and Closing Disclosure documents and accompanying XML dataset, conforming to the regulatory data standard. The PDF image of the form is encoded and embedded in the XML file.
• Wrote the VB code when updates/changes were made in the tool.
• Wrote the user manual to assist all users in how to use the form in conjunction with Uniform Closing Dataset (UCD) is the dataset developed by the GSEs ( Confidential and Confidential ) for submission of data related to the Integrated Disclosure document specified by the Consumer Financial Protection Bureau (CFPB).
• Used COTS Salesforce to monitor the sales and use of UCD tool.
• Using SaaS Google Analytics maintained the usage reports for all outside users with Confidential Connect Reporting.

Business DATA analyst

Confidential, Herndon, VA

Responsibilities:

• Managed alignment of Client’s Mortgage Data Governance Program with Industry standards, data forums, etc. Identify opportunities for Client to be a leader in the Data space. Refined Data Governance Operating Framework, aligning with industry best practices.
• Identified processes and application that are non-compliant with Enterprise Data Policy & Standards.
• Identified and updated Corporate Policies and Standards as related to Data Quality.
• Coordinated the development of dashboards to measure progress and success of data governance program using several SaaS products (Docusign, DropBox and Google Analytics(
• Created a SharePoint site to hold all project review information. Used SQL server to create linked database information to follow Enterprise Data Governance reviews of all projects registered with upstream and downstream information.
• Migrated SharePoint EDG sites from . Created SharePoint InfoForms for automation of Project Inspections.

Senior DATA analyst

Confidential, HERNDON, VA

Responsibilities:

• Made informed recommendations pertaining to MS SharePoint information and site architecture, infrastructure, software implementation and web parts design, testing and deployment. conversion and development of seven sites for AFS280 in the Federal Aviation Administration.
• Used visual studio to create reports linked to SharePoint sites.
• Comprehensive knowledge of SQL stored procedures, SSIS and SSRS along with SharePoint integration.
• Created and updated current process using SDLC using both Agile and Waterfall methods.
• SharePoint Administration and development for both branches in the Confidential (AFS230 and AFS210).

Business analyst

Confidential, Reston, VA

Responsibilities:

• Worked with the Enterprise Change Management team for migration.
• Gathered and analyze information to write business requirements.
• Developed business process flows with data/financial examples and discussing with business and technology teams.
• Wrote mortgage business requirements and scope documents for specific project needs.
• Utilized Icart for change management and to track and log any issues.
• Documented and wrote training materials for all UAT in association with current project.
• Utilized Change Management software
• Utilized Remedy for release management to track the P&L releases.

Senior DATA ANALYST

Confidential, Herndon, VA

Responsibilities:

• Created complex queries using SQL to produce analytical financial information.
• Facilitate requirements sessions to define business and user needs and resolve conflicts.
• Document detailed functional requirements, system requirements and technical requirements.
• Support required technical development by acting as a liaison between the technical team and the user community.
• Provided financial analysis, research and reports using SQL and PeopleSoft software, to support new business opportunities.
• Provided support to members, internal staff, outside vendor relationships, on various projects to produce financial reports.
• Reviewed, analyzed and evaluated business systems and user needs to develop requirements documents.