Contract Data Analyst supporting Anti-Money Laundering (AML) within the Global Financial Crimes Technology group. Working within and Agile team using a JIRA Kanban board to manage tasks. Analyzing data on multiple database platforms including: Teradata, Hadoop and Oracle. Create metadata documentation capturing business element code values, data lineage and transformation logic that may be present at different sourcing levels.

Performed as a contract hybrid data analyst and business analyst within supply chain management. Worked within and Agile team using a JIRA Kanban board to manage tasks. I utilized SQL within a SQL Server environment with SSRS reporting for business partners. Collected business requirements from partners regarding data sourcing or data reporting. Modified or built SSRS Reports for business partners to utilize inventory data for planning purposes.

Worked in a Wholesale regulatory reporting data group supporting 14Q and IFRS-9 reporting. Collaborated with regulatory reporting stakeholders to understand their requirements to remediate data gaps for 14Q and IFRS-9 reporting. I utilized my SQL skills daily to analyze data available in approved data sources.

Business Analyst supporting the LUCAS wholesale loan servicing platform utilizing SQL Server for data management.

Contract Data Analyst within the Balance Sheet and Capital Management Technology group. Worked within an Agile methodology team to convert a regulatory reporting database from Teradata to Netezza utilizing Informatica for ETL. Utilized SQL and Informatica skills to perform analysis and reverse engineer existing ETL and reporting SQL to create requirements for new data warehouse.

Worked as a contract Business Analyst within the Mortgage Technology group. Analyzed business requirements for configuring a vendor based loan origination system to meet TRID requirements.

Customer Web Technology - Retail Programs• Worked with business partners to prioritize their requirements for enhancements to the public and authenticated areas of Duke-Energy.com.• Authored business requirements to be used by the development team for estimates and technical designs.• Supported product development for residential energy efficiency programs by developing business cases to show financial viability.• Created Requests for Proposal (RFP) to inform prospective vendors about the business and technical needs of a new or existing program.• Managed vendor development of tools to be used in the public website.• Worked with the sourcing team for pricing and contract negotiations with new vendors.• Created process workflow diagrams using Visio to provide visual confirmation of a process to business partners, the development team and testing team.

Enterprise Credit Risk Technology (ECRIS/BASEL) – Hadoop and Teradata Warehouses• Managed two Agile SDLC Scrum Masters that led the development efforts for the conversion of the existing Teradata warehouse to the new Hadoop data warehouse. • Managed two Waterfall SDLC Project Managers who led the development efforts for the existing Teradata warehouse.• Worked with the Credit Risk business partners to prioritize funded initiatives and changing regulatory requirements for the consumer credit risk data warehouse.• Provided weekly status report presentations to executive management and business partners.• Utilized JIRA for story management and burn down reporting.

Corporate Investment Technology – Corporate Investment Data Warehouse (CIDW) – Oracle• Created detailed Business Requirement Documents and JIRA Stories for new requests.• Worked directly with the developers to create data mapping and lineage spreadsheets for the Extract/Transform/Load (ETL) logic in Informatica Power Designer.• Assisted with the writing and execution of test scripts utilizing Oracle SQL scripts for Quality Assurance testing in the Systems Integration Testing (SIT) and production environments.• Tracked and reported development and testing status to management, business users and other impacted teams.• Coordinated User Acceptance Testing (UAT) and provide SQL scripts and test data for business users to review data quickly and provide signoff.• Established controls for data quality and file load validations that are reported daily.

Corporate Investment Technology – Mortgage Data Mart (MDM) - Oracle• Worked with business partners to write the Business Requirements Document (BRD) and High Level Design (HLD) document for building a new Mortgage Data Mart after the Countrywide acquisition to replace the data mart I helped to build in 2007.• Created the Low Level Design (LLD) document to capture source to target mapping, transformation logic and business descriptions for 135 target tables and over 6,000 fields to be built in the new data mart. This included multiple sources of data from various platforms and types of input files.• Worked directly with the developers to create data mapping and lineage spreadsheets for the Extract/Transform/Load (ETL) logic in Informatica Power Designer.• Tracked and reported development and testing status to management, business users and other impacted teams.• Assisted with the writing and execution of test scripts utilizing Oracle SQL scripts for Quality Assurance testing in the Systems Integration Testing and production environments.• Coordinated User Acceptance Testing and training for the new data mart.• Provided “business as usual” support via Agile Software Development Life Cycle to meet changing business requirements through weekly software releases.• Maintained a data dictionary weekly in Oracle to store metadata about each field in the database and its sources and transformation logic.

Enterprise Credit Risk Information System (ECRIS/BASEL) - Teradata• Led the Software Development Life Cycle for monthly system releases on a Teradata database to insure requirements, development, testing and Change Advisory Board approval was completed on time. This included coordinating the efforts of 10 Business Analysts and over 30 Developers located on-shore and off-shore to complete funded projects, defect resolution and new requests from business partners.• Managed numerous data sources within the ECRIS platform supporting Retail BASEL reporting. This included Mortgage loans and Home Equity Lines of Credit, Commercial Loans, International and Domestic Credit Cards, Student Loans, Auto Loans, and Military Banking.• Utilized HP Quality Center to lead the defect management process to correct over 400 defects in 12 months to prepare for BASEL parallel testing.

Corporate Investment Technology – Mortgage Data Mart (MDM) - Oracle• Authored the Business Requirements Document and High Level Design document for the Mortgage Data Mart (MDM) database.• Created the Low-Level Design document to capture source to target mapping, transformation logic, and business descriptions for over 800 fields to be built in the new data mart.• Worked directly with the developers to create Extract/Transform/Load (ETL) logic in Informatica PowerCenter Designer.• Used SQL query tools to perform research and compare data from the Mortgage Servicing Platform (MSP), SBO application, the “W” and WLM data warehouses.• Reported development and testing status to management, users and other teams.• Wrote test scripts utilizing SQL for Quality Assurance testing in the Systems Integration Testing (SIT) environment.• Utilized Business Objects to re-create management reports including a Trader Summary.

• Managed enhancement projects and maintenance releases for the HSBC Mortgage Services web site.• Employed Risk Based Project Management tools to communicate business and functional requirements to the technology services and web design group.• Utilized Mercury Test Director to manage test scripts and report defects during website Quality Assurance testing.• Performed User Acceptance Testing (UAT) for system upgrades to the vendor provided mortgage servicing platform, Mortgage Serv.• Collaborated with Product Managers and Directors from other lines of business to enhance the external customer experience and reduce the cost to service.

• Managed projects and daily operations of the Bank of America mortgage servicing website. The site was hosted by a vendor and serviced over 600,000 retail mortgage customers. • Worked with the cross sales and retention team to promote the site and retain current mortgage customers.• Created monthly site usage reports for business stakeholders. • Managed enhancements and daily operation for MSP Passport and Scorecard, two web-based mortgage servicing reporting tools. Provided support and training coordination for 150 internal Passport and Scorecard users.• Utilized Microsoft Access, Microsoft Excel, Oracle Discoverer, Visual Basic, SQL and Fidelity Information Services Passport to generate monthly and ad-hoc reports for financial analysts in Consumer Real Estate.• Accomplishments: Updated the servicing website site to be in compliance with the Americans with Disabilities Act (ADA) for website accessibility; implemented a new user interface; provided a duplicate tax form 1098 via the web; auto draft payment enrollment; worked with the multicultural team to implement a Spanish version of the site.