SUMMARY:

• Obtained over 10 years of experience as a Data Analyst and Business Analyst. Projects contained SQL Server, T/SQL, MySQL, BI, Oracle, Tableau, Informatica,Toad, Hadoop, and Qlikview. Worked with a data warehouse.
• Worked with data Governance. Assignments include working with business and development and updating the results with Toad and Informatica. Used source to target mapping.
• I have used Agile/Kanban, and Waterfall and other techniques such as Scrum. Deep dives are done to insure accuracy. Worked on business requirement from beginning to end on projects.
• I have used in house applications that helped to change and update procedures for reporting.
• I have discussed with developers, programmers, business and account stewards to obtain solutions.
• I have audit experience determining the processes, the risks and offsetting controls.
• I prepared reports to give to managements to show the key risk Indicators and any mitigation.
• I This experience includes working with Comprehensive Capital Analysis and Review (CCAR), Sarbanes Oxley (SOX) testing. I have supervised and coordinated with management.
• My link on SQL and CCAR
• Perform intermediate and advanced SQL
• Obtain information from data stewards and Subject Matter Experts to prepare reports for users
• Used MS SQL Server 2012 to combine, validate, and prepare complex data queries.
• Performed data mining to check data and update it.
• Attended scrum and agile meetings to prepare and present reports
• Worked with business owners and developers for source and target requirements and to provide the SQL logic needed
• Trillions of Dollars and Hundreds of Millions of records tested using SQL for BAC
• Worked with a Risk Evaluation Team for CCAR stress tests 2016 to assess firm’s policies, procedures and methodologies to predict loan losses in the Fair Value and Held for Investment loan portfolio.
• Summary reports were used to support facts on regression testing
• Worked on projects from beginning to end
• Used SQL Server 2012 and Informatica to combine data and prepare reports
• Performed ETL on different systems and locations.
• Used Tableau to prepare reports.
• Updated Project Managers in daily meeting including Scrum using Agile, Waterfall, Kanban techniques
• Worked with Power Query, Power map, Power BI and Power View for outstanding reports
• Worked on directly and on joint ventures with CPA firms (including PWC)
• Managed Accounts Payable department Confidential (200 million dollars)
• Performed support for SOX 404 engagement at a Bank
• Instructed on one occasion a group of 50 new hires on how to operate the mortgage system software
• Reviewed the files of hundreds of mortgage companies
• Uncovered a $1.2 Million finding in a financial and operational audit. (1.2 Million dollars0
• Worked at Confidential resolving fraud by reviewing documents
• Worked on projects for 7 of the 10 largest financial institutions in the United States
• Reviewed over 1,000 mortgage files checking for fraud
• Lead financial, compliance and operational audit
• Reviewed credit reports for Fraud alerts.
• Prepared Business requirements documents

PROFESSIONAL EXPERIENCE:

Senior Data Analyst

Confidential, Charlotte, NC

Responsibilities:

• Trillions of dollars and hundreds of millions of records
• Perform data analysis, mining, integrity and quality control
• Used SQL to retrieve data from Informatica and Toad
• Used Oracle relational database to perform testing with Toad and Informatica
• Worked with Comprehensive Capital Analysis and Review (CCAR)
• For CCAR used different portfolio’s including auto, international auto, securities, commercial, international small business, credit cards
• Worked with energy and metal maturities/ maturity buckets (tenors) and municipals
• Worked with Regulatory Capital Instruments repurchases and issuances
• Worked on Regulatory Capital composition and Risk Weighted Assets
• Performed ETL on new and legacy data. Set up stories to note locations, transformation rules, types of cleansing and landing locations.
• Performed data validation including comparing to source documents.
• Worked business requirements from beginning to end on projects
• Used OLAP on line analytical processing for the business department
• Reviewed source system data to other systems in a story. Worked with Developers to finalize the story.
• Performing User Acceptance Testing (UAT) and new stories discussing with Business including gap analysis, end user guides,
• Worked with Power Query, Power map, Power BI and Power View for outstanding reports
• Applications used include Hadoop, Toad Data Point 4.0, Oracle, Tableau, MS Sequel Sever, Access, HTML and Qlikview
• Updated Project Managers in daily meeting including Scrum using Agile, Waterfall, Kanban techniques
• Prepare and test data for international metric including Wholesale credit, Investments, oil, gas, Libor, credit cards and commercial information

Senior Data Analyst

Confidential, Charlotte, NC

• Performed data cleansing of retirement information provided.
• Worked with project managers in an agile environment.
• Work with business owners to get requirements.
• Used SQL for data mining to review financial products
• Worked with developers to confirm source and target information.
• Used Tableau to prepare reports on municipal assets
• Tested internal controls for SOX project.
• Used Business Intelligence to determine test domains
• Used Access, Excel, macros, pivot tables and vlookup
• Performed testing to confirm the integrity of data
• Used Visio, Excel and Word to perform testing in the audit.
• Prepare findings to support the financial audit report.

Senior Auditor / IT Data Analyst

Confidential, Charlotte, NC

• Prepared stories to document the sourcing of data to the warehouse and to the business users.
• Used vlookup’s, macros and pivot tables for data mining
• Performed ETL when combining data from legacy system and other locations.
• Prepared document to get business requirements and transfer to technical requirements
• Set and checked business rules
• Worked on statistical model to test possible findings
• Followed requirements from beginning to finalization.
• Determined data types were standardized and dates used for dimensions and facts were correct
• Performed SQL queries for data mining.
• Managed training of 50 new hires on Enterprise system usage.
• Analyzed data in system for variances, benefits, tracking and SOX project.
• Used Data based decision making to determine the areas to test
• Managed, escalated, documented, and resolved and identified audit risks
• Designed cost improvement process
• Used Data mining to cleanse, check and update data
• Reviewed and approved credit fraud alerts
• Used Access, Excel and Visio for internal control testing

Senior Data Analyst

Confidential, Atlanta, GA

• Performed testing of source data. Prepared SQL to extract the data and load it to set locations.
• Prepare documents summarized transformation of information
• Worked with business owners to prepare a story for developers showing transformation of data.
• Worked on projects from beginning to end.
• Used regression testing for forecasting results Detailed SQL background used
• Worked with mortgage backed securities, derivatives and stocks for audit
• Performed ETL cleansing of data and determined the proper business rules needed.
• Used Visio, Excel and Access to find key risks and controls that needed to be tested
• Reviewed Control Objectives for Information and Related Technology
• Reviewed the files of hundreds of mortgage companies using vlookup and pivot tables
• Prepared a repurchase letters to banks on confirmed fraud
• Summarized reports for Management in Excel. Setup documents with macros.

Senior Data Underwriter

Confidential, Minneapolis, MN

• Performed checking of data types and data for validation testing
• Used statistical modeling to forecast future market expectations
• Underwriting of mortgage loans including reviewing for abnormalities or fraud
• Informed management of risk and control areas reviewed and the results
• Finalized project for high income underwriting approval for management

Analyst Supervisor

Confidential, Atlanta, GA

• Managed $200 Million dollar Accounts Payable department of 5 employees
• Used Tableau to assist with data review
• Performed regression analysis to support the audit report
• In charge of Purchase - Card Audit
• Used Confidential Works to detect fraud using vlookup and pivot tables

Senior Data Analyst

Confidential, Atlanta, GA

• Reviewed mortgage files for fraud including verifications of identity, incorrect social security numbers, employment, income, occupancy, type of job ownership.
• Review major mortgage backed securities
• Performed data mining to review data and look for irregularities
• Used Access and Excel to find data on Billions of dollars of assets
• Reviewed credit reports for Fraud Alerts

Senior Data Analyst

Confidential, Atlanta, GA

• Tested department transactions covering the life cycle.
• Perform statistical analysis to support summary reports
• Tested bond, stocks, mortgage backed securities and derivatives.
• Prepared work papers with macros
• Used Visio, Excel and Access to record testing in the audit