Technical and Business Analyst
Resume:
Yoomi L Verlinden
Suwanee GA 30024
Technical Summary
Sr. Data Analyst, Technical Analyst with 15 years of experience
Expertise in Data Sourcing, Data Extraction, Data Analysis, Data Quality Validation, Data Mapping, Proof of Concept, Data Validation and Reconciliation
Expert skills in SQL and SAS
Technical Skills
Green Belt Certified.
Classes, Languages and software
SQL, SAS, Teradata, DB2, Oracle, Cobol, Easytrieve, Caliber, .Net, ETL, SSIS, Crystal Reports, JCL, C, C++, Visio, MS Project, Visual Basic, HTML, Impromptu, Excel, Powerpoint and Word.
Experience
1/2014 – 6/2015 Bank of America- Contractor
Card Products Fulfillment and Analytics
Produce fulfillment file for customers-consumer & Small business
Perform analytics to validate BRD to ensure accuracy and completeness of BRD and business objectivity.
Perform analytics on card campaign performances during and after fulfillment
Create SAS codes utilizing SQL and SAS proc per BRD utilizing DB2 and Teradata tables to create files/report and to perform analytics.
BACARDI to TSYS Data Conversion and analysis.
6/2012-9/2013 Bank of America
Consumer Credit Card Data Analyst III
Produce monthly reports via SAS.
Create or Modify reports per policy and compliance changes and requests.
Perform research and analytics.
Update and create SAS codes and SQL on BACARDI/Teradata database for ad-hoc reports
8/2010-6/2012 Bank of America
Data Analyst AML Specialist
Create and maintain various reports and out of Alerts - control reports by +- 3 standard deviations.
Develop complex SQL queries to extract raw data and summarize the data
Perform extensive, in-depth data sourcing and mapped data from multiple sources and identify source for AML, identified errors and reconciled
Develop Report Documentation for audit and historical purposes.
Perform SharePoint maintenance and updates.
Perform Conversion code updates and test data for validation.
Research and trouble shoot and fix reports.
Create and developed complex SAS programs for MIS use.
Data Discovery – SME contacts, data usage, data sourcing, data quality check and validation for scenario/filter development,
Perform analysis and proof of concept.
2009–8/2010 Bank of America
Data Analyst Solicitation History Project -
Wrote SQL and SAS queries and extract data and test data
Perform analysis and present findings to help with marketing strategy.
Mapped data, perform Data quality checks and mapped data to source
Assist with database design, and develop new codes to turn data into information.
Create ad-hoc reports for monthly marketing analysis and analysis of credit card data.
Test new repository for data validation, performance, usability and data quality.
Establish a new extract/cube by creating a batch process with business partners to reduce redundant processes by multiple associates and teams for process improvement workflow.
Research and source new elements from “W” to enhance card customer analysis
Work with business partners to incorporate the element into an existing monthly file.
Create documentation and reports and present findings to senior leaders, their direct reports and team members.
Analyze and append deposit accounts (BofA) along with segmentation and personix data for consumer credit customers.
Perform extensive Bank of America Card data mining and analysis of BACARDI data.
Create SQL and SAS queries for PC and UNIX.
2008–Feb 2009 Bank of America
Q&P Engineer
Work on a Black Belt Project to reduce Deposit accounts’ early closure rates.
Create and improve process, to reduce waste and increase productivity
Create SQL queries to measure on boarding account process, score cards, and measure performances.
Perform extensive deposit account data mining, data mapping and analysis-retail DDAs and Savings
2006-2008 Bank of America Risk Check Filter
Risk Analyst
Perform risk analysis and recommend changes to check filters, add, remove or changes processes.
Perform Process improvements on check review process to reduce loss and improve processing time by utilizing data.
Wrote complex queries to extract data and verify data from source to target
Map data from various sources into the Data Warehouse and various other databases
Perform data analysis on Risk tables and implement changes to improve performance and data usage.
Automate performance charts via SAS.
2005–2006 Bank of America
Senior Financial Analyst
Perform financial analysis from CLPR tables and "W" tables via SQL/ SAS.
Assist CLPR data users with queries.
Create ad-hoc reports by specs from CLPR and W data.
Perform data mapping and verify data
Research and assist with projects: research data, development and analysis.
Design customer value metric code.
2004–2005 Bank of America
Data Quality Analyst Business-System Integration
Assist business partners, enterprise wide, with data quality analysis.
Perform data mapping from various sources to the data warehouse
Write SQL queries to extract data and Identify data source
Test DQM software -validate and QA. Test documentation and software analysis.
Work with business partners to analyze data, identify what to measure and how to measure to end product-CTQs (critical to data quality).
Perform Data analysis-Query tables for CTQ analysis to report creation.
Create user guide/CBT. Conduct training for DQM tool (Data Quality Metric Tool) demo/DQM overview to Business partners.
2002–2004 Bank of America
Analyst II Data Mining Warehouse
Create Ad-hoc spend reports from POWER database to support Finance Sourcing Managers to look for savings opportunities and to manage bank's spends for Supply Chain.
Wrote SQL queries for data mining, data validation and data analytics
Create automated reports in Visual Basic for monthly/quarterly reports.
Assists clients with Excel, Access and data analysis.
Assists clients with data selection through business partnering and data expertise.
Perform data analysis, research via SQL and VB. Maintain Help- Desk Database, and create quarterly report for senior managements.
Support major and minor projects and initiatives with research, data verification and analysis.
2001 - 2002 Bank of America
Senior Technical Analyst
Perform data integrity and requirements validation by utilizing queries (SQL statements) against the Oracle database. Test new Oracle codes/procedures and verify results.
Collaborate with business analysts and developers for analysis, research, and data requirements.
Perform data mapping for system conversions
Create test plans, scripts and incident reports and perform data analysis.
Perform as a Lead for Bank Card (TS1-TS2) Data Conversion project.
Extensive research experience utilizing SQL and other tools.
1998 - 2001 Bank of America
Senior Technical Analyst
Create and maintain Main Frame COBOL & EASYTRIEVE Programs and JCL's. Experienced in loans (ALS, SHAW and AFS), credit cards (TS1 & TS2 and Bicardi (MBNA Card System) and Ace Advantage) and DDA systems.
Create query statements (SQL DB2) to unload data and to perform research and analysis (CDW and EDW).
Perform parallel testing: data integrity/Quality Assurance for conversion/ new releases.
Create/update technical documents for processes.
Assist clients with issues, changes and testing. Make recommendations for improvements.
1982 - 1998 Bank of America
Various Duties as a Bank Associate
Work with Data Base team for wire transfer system.
Review documents and setup customers. Assist internal and external customers via telephone with issues and questions.
Balance and settle bank wire transfers: bank totals to Federal Reserve totals.
Research exceptions and rejects. Assist other teams incoming calls and research
Teller and customer service duties; Balance, settlement, G/L entries and cross sell bank products
Education 1991-1995 Virginia Commonwealth University
BS Science, in Mathematics and Environmental Studies: GPA 3.75
Magna Cum Laude, Phi Kappa Phi, Golden Key National Honor society
Bank of America Academy; a maps program for technical team.
Contact this candidate