Provide Analytic and Data support for the compensation of Wealth Advisors and Financial Advisors. Understanding the demanding changes to requirements and performing corrections to prior agreements. In this role, I expanded my MS SQL programming skills to master the subtle differences with Oracle PL SQL.

Responsible for collection, consolidation, and distribution of trade data that is captured by systems of record for the various traded products across multiple divisions.* Provided reports for lines of business, senior management and regulatory agencies.* Perform complex analysis with risk data and create and analyze reports that present data in an easy understandable format.

Decisioned approval or denial for Enterprise Architecture purchasing requests.* Facilitated decisions with a broad scope of engineers, architects and subject matter experts.* Partnered closely with other decisioning Program Management Groups to make collective decisions.* Recommended existing products within the bank versus purchasing new tools that perform the same or similar functions.* Maintained a SharePoint site to track progress of requests

Served as a SQL Technical and Reporting subject matter expert for the Independent Foreclosure Review Project. * Analyzed Independent Foreclosure Review data for special request reporting.* Documented data lineage (source mapping, transformations, and reporting)* Verified User Acceptance Testing (UAT) test results with back end data queries.* Analyzed data anomalies and provided recommendations for corrective actions in both UAT and Production.* Prevented Production outages with proactive changes to Release Process.* Provided direct support to Development, UAT, and Production Support Teams

Source Midrange Server Data to incorporate bank wide Server data across all legacy systems to help create a single source of record. * Sourced Midrange Data into Master Data Hub including Enterprise Architecture Roadmapping and Classification, Runbook, RFID, Nlyte, Application Inventory Tool (AIT), and Corporate Directory.* Performed Data Source Mapping across large relational databases (Oracle, DB2, and Teradata).* Provided full source documentation, creation of transparent views and data loads. Documented data transformations and normalizations so that all disparate systems were uniform.* Worked with a Waterfall Project Plan with aspects of Agile Stories.

Championed the development and implementation of Infrastructure Metric Scorecard for Business Partner and Metrics Analysis; worked through all stages of Data Solutions Life-Cycle.* Worked directly with Infrastructure Simplification Program to provide key utilization metrics in order to assist reducing underutilized Infrastructure Technology.* Lead Technical Consultant on the corporate initiative to incorporate financial data from legacy Merrill Lynch and Countrywide Midrange data into the Bank of America Maximo Inventory System.* Incorporated data standards into Maximo for physical models and operating systems. Worked directly with EARC to develop standards and add new models.* Sourced multiple Midrange Server SORs including EARC, AIT, Tivoli Inventory, Utracker and Enventory.* Project Designed as Waterfall but implemented as Agile/RAD. Served as Agile Coach, and Solution Provider.* Mentored analysts in best practices to document, analyze, design, test, and implement a single source for Midrange Data.

Infrastructure Technology liaison to various business units, providing technical expertise regarding business improvement needs and impact on the overall environment. * Created Physical Inventory Process. Led Asset Inventory Greenbelt which identified “Retired” servers that were still racked and running power. Initial savings of 250K during the first quarter.* Analyzed business needs and proposed long term strategic integrated cost effective solutions. * Formulated business needs into full cost and benefit analysis for implementation and on-going support.

Managed Server and Desktop Software Delivery for Global Technology Infrastructure (GTI).* Created a scheduled software distribution for both Desktops and Servers. Logged daily reports of success and failures. Decreased the distribution failure rate from twenty percent to less than one percent.* Green Belt project for reclaiming unused MAS accounts. The first year savings were over two million dollars. This project was nominated as one of the best Six Sigma projects for 2005.* Created a web based Storage request system for all GTI SAN and NAS storage request.

Architected and developed a data warehouse for GTI Operations. GTI Info and became the operational system of record with a SQL database and ASP.NET web interface.* Supported Midrange Servers as they related to multiple operational fields as well as Contacts, Facilities, trouble tickets, Total Cost of Ownership, and Autosys batch jobs.* Created the data model including relational table structure, views, security model, indexes, triggers, stored procedures, data transformation packages, linked database sources, scheduled jobs, and email alerts.* Created extensive SQL scripts to support ASP.NET database queries and updates.* Developed a PDA interface.* Created Greenbelt Decommission process.* Set Standards for Asset Management to be implemented into MAXIMO.* Greenbelt Data SME for multiple projects. One project saved Bank of America Network Operations over ten million dollars.

Managed Trader Workstation, Software Delivery, and NT Desktop build for MarketNet and Montgomery Securities associates.* Designed, implemented, and managed custom software delivery system.* Packaged all Trader desktop software applications. Managed delivery for over two years without a single software delivery failure.* Designed a common desktop for Mortgage Backed Security Traders in multiple locations. The build took less than ten minutes to complete and allowed traders to move freely between workstations with full access to their applications and personal files.* Designed Trader and Back Office Desktop prior to 9/11 which was used for the Contingency site during the disaster/recover failover. Due to efficiencies in the design, the site was operational in under forty-eight hours with no errors or issues.

Progressed through the following roles: Analyst, Team Leader, and Manager. Supported corporate associates in Real Estate, Loan Syndications, Specialized Products, and Corporate Credit Services. Provided premier support by answering 100% of our customer’s questions concerning functionality of all bank applications.* Designated Financial help desk Consultant (Specialties in Balance Sheet and Cash Flow Forecasting)* Managed Team Leaders and 20+ associates* Developed Training Program* Managed onsite support for Barnet and Boatman’s Systems Integration* Built Command Center for tracking problem escalation and resolution

* Designed custom plans for Partnership Buyouts, Estate Planning, and Pension Planning through utilizing Life Insurance Funding.* Performed analysis for individual clients seeking permanent or term insurance base on policy cost and company strength.* Provided Annual Statements and Cash Flow Projections.* Licensed North Carolina Life and Casualty Insurance Agent. * Designed and Maintained the Company Payroll System based on Commission Payout.