| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address NORTHWOODS FOREST DRIVE
CHARLOTTE, NC Street Address
PHONE NUMBER AVAILABLE
EMAIL AVAILABLE
PROFESSIONAL SUMMARY:
Versatile detailed focused and results oriented IT professional with over 20 years of experience in the banking and insurance industry. Provide excellence in analysis, design
and problem solving. Proven track record in working with business clients and other project team members to provide solutions, which meet or exceed their business needs.
Experience using SQL for data mining, data exploration, analysis and investigating and understand data issues. Experience in data mapping source system to target system.
Experience analyzing data for format, content, relationships, abnormalities etc. in its raw form before being loaded into database tables.
WORK EXPERIENCE:
Wells Fargo: Apex Systems Consultant Business Systems Consultant 6 08/2016 03/2017
Provide metadata compliance tracking using Ab Initio and Collibra for Foundational Data analysis.
Use Ab Intio for graphical tracking of data
ETL report data into Collibra
Use Excel for data collection, tracking, analysis and manipulating data.
Provide support data management/data governance for Community Bank 14 A Regulatory Reporting
Bank of America: Experis Consultant Tax Compliance Metadata Analyst 08/2015 12/2015
Analyze and test Corp Tax data to help ensure data quality and verify that EDM metadata compliance standards are met.
Assess the degree to which records conform to the approved business rules
Perform data reconciliation and manipulate data/files if needed.
Validate data from the Corp Tax system into the Access Database Tool.
Stress Test Access Database Tool.
Ability to use Excel for data validation
Validates the extraction, transformation and loading of data into the databases for completeness and integrity
Bank of America: Meridian Staffing Consultant - Credit Risk Data Analyst 04/2015 06/2015
Conducted audit compliance data quality analysis for the EDM Metadata Template for Credit Retail in Agile work environment.
Applied data quality review criteria and produced data quality updates describing the criteria used to evaluate the data, problems noted, and recommended solutions for
data correction and data quality improvement.
Data to be reviewed was on Mainframe system and Hadoop.
Provided analysis on Bacardi RBA feed, Critical PDEs, 500 plus inputs for Source to Target information, Join Logic and Transformations.
Validated data lineage with extensive use of Vlookups on EDM Metadata Template.
Bank of America: Collabera Consultant -AML Business Data Analyst 04/2014 12/2014
Write and modify PC-SAS and SAS EG code to conduct fraud analysis, compliance research and run daily, weekly and monthly reports by accessing data from the W
(BofA data warehouse). FTP csv.txt files from test environment to test and production drives.
Performed Data Mining/Analysis using Teradata SQL to access the W (BofA data warehouse) for research and testing.
Bank of America: Randstad Consultant - Data Analyst: (Consultant) 08/2012 04/2013
Data mapping and analysis skills with ability to pull data from Microsoft Access and Oracle databases using SQL statements.
Use SQL through TOAD (Tool for Oracle Application Developers) to query Oracle database SB02000 for data analysis and data validation for delinquent mortgage
accounts.
Perform analysis of the given data and draw accurate inferences, in accord with the objectives of the analysis.
Used Excel to perform VLookups for data comparisons.
Gather data required to conduct analysis from several sources, compile it together in prescribed format and enter the data in several data analysis software.
Evaluate the given problem, situation and crisis; investigate for solutions using data analysis practices and prepare analysis reports.
Determine the methodologies and procedures for carrying out effective data analysis.
Perform CIT and SIT testing for validating database changes.
Wachovia: Apex System Consultant - Mainframe Data Analyst (Consultant) 02/2010 - 12/2010
Broad understanding of the overall Wachovia banking system, the internal and external processes, applications and their interfaces, and the methods by which they are
coordinated in the various testing environments.
Experience includes: Emerald, CICS, TPXT, Excel, SharePoint, ART Microsoft Office, and Microsoft Excel
Provide, maintain and condition test data for merger projects to Hogan system.
Trouble shoot why a test could be failing and not meeting the expectations of the tester.
Exposure to the multitude of WB products and services from Emerald SORs to Distributed banking applications.
Understanding WF/WB data process which legacy WB accounts and converted data requirements.
Exposure to Brokerage and Retirement Services account process.
Wachovia: Apex Systems Consultant - System Analyst 06/2008 - 10/2008
Researches problems, plans solutions, recommends software and systems, and coordinates development to meet business or other requirements for Integrated Sales and
Service Department.
Experience includes Mainframe: Emerald, TPXT, TSO CICS
Ran JAD, RAD, and DRP sessions with customers to learn requirements and then produce business requirements documents.
Wrote technical requirements from the business requirements document. Perform system testing.
Bank of America: Randstad Consultant - Business Analyst 03/2008 - 06/2008
Evaluated the impact, return, and costs presented by work process improvement opportunities.
Participates in business planning, needs analysis and business risk assessment.
Consulted with the customer on how to best support their area through the effective use of technology.
Bank of America: Programmer Analyst (Consultant) 08/2007 - 02/2008
Used ALS programming language in multi user environment to create Reverse Mortgage product. Strong analytical skills that include insight on successfully applying
technological solutions and best practices to resolve business issues, while improving overall efficiency. Seasoned professional with over 10 years experience in system
analysis and design, programming, implementation, quality assurance testing, and trouble shooting skills during integration of the new system. Good verbal and written
skills, and an excellent team player.
Experience includes: Mainframe: ALS CICS, MVS, JCL, VSAM, TSO/ISPF/SDSF, File-Aid, Easytrieve, Changeman, Xpediter, COBOL I/II. - reated new application
programs for new Reverse Mortgage Application.
Implemented new file creation using for state using Reverse Mortgage Application
Assisted offshore team with system testing and troubleshoot various programs for other bank teams.
Wachovia: Fraud/AML Data Analyst (Consultant) 04/2006 - 06/2006
Performed diligent analysis support within the Fraud/AML Systems & Operational Support team which provides business, technology and administrative/operational
support for all compliance related implementation and enhancement efforts to achieve AML compliance objectives.
Review/investigate all information acquired from pro-active suspicious activity reports.
Make sound subjective decisions to close risky relationships, place and remove restrictions..
Review checks, transactions and account changes in an analytic, forensic and investigative standpoint.
AML/KYC experience reviewing transaction activity for consumer accounts.
Wachovia: Online Banking Business Analyst (Consultant) 04/2005 - 04/2006:
Provide support for call center that supported online banking, bill pay, eStatements, and institution to institution transfers.
Assisted with online banking issues such as error messages or technical troubleshooting.
Handling CheckFree (FISERV) bill pay processing. Also processed stop payments, researched payment discrepancies, and assisted with instructions.
Verifying enrollment for transfers, suspending / un-suspending accounts, and researching failed transfers.
Assisting members with banking issues such as enrollment problems and activation codes for debit cards.
Wachovia: Mainframe Programmer/Data Analyst (Consultant) 09/1997 - 10/2002:
Hands-on new development as well as support, maintenance or enhancement of existing applications. Worked closely with client management to identify and specify
complex business requirements and processes. Researched and evaluates alternative solutions and made recommendations.
Experience includes: Mainframe COBOL, APS Batch, Expediter, DB2, VSAM, JCL, FileAid, Easytrieve Data Mapping, JCL, Expediter, ISPF development tool.
Created coding specifications from analysis of files for revolving debt/loan, credit and mortgage system,
Performed data mapping from merger banks to Wachovia systems.
Data mapping process involved taking data files from merger banks (Signet, Corestates) and doing a field by field analysis to a corresponding Wachovia VSAM Mainframe
Files. Merger bank files and Wachovia files that did not always have a one to one correspondence.
Some fields had to be reformatted in merger code program during files merging process due to length or subject matter.
Use Cobol report generator Easytrive on mainframe system to create before and after reports to ensure data integrity.
Created new custom interface programs from vendor software to Wachovia systems.
Developed merger procedures for transferring Wachovia Home Mortgage Data to Money Store Bank.
Performed Y2K systems testing for Einstein application support group.
Computer Sciences Corporation: Healthcare/Life Science Consultant 04/1997 09/1997:
Provide support for data science packaged services for healthcare (hospital) and life science organizations.
Code, test, debugged, implemented, and documented programs. Creates appropriate documentation in work assignments such as program code and technical documents.
Designs programs for projects or enhancements to existing programs.
Writes specifications for programs.
Assists support and/or project personnel in resolving program problems.
Develops test plans to verify logic of new or modified programs.
Conducts quality assurance activities such as peer reviews.
Creates appropriate documentation in work assignments such as program code, and technical documentation.
Remains abreast of industry technical trends and new development to maintain current skills and remain current with industry standards.
OTHER SKILLS, TRAINING & QUALIFICATIONS
MAINFRAME: COBOL, APS Batch, Expediter, DB2, VSAM, JCL, FileAid, Easytrieve, dBase III+, Pascal, Visual Basic, CIM, Emerald, RL, RD, Online Banking
Data Warehouse: The W WECRIS
EHR/EMR: Cerner
PC APPLICATIONS:
(HP) Mercury ALM/Quality Center
Lotus 1-2-3 , Lotus Notes
Microsoft Office Suite:
Access, PowerPoint, Word, Visio
EDUCATION
Bachelor of Science, Computer Information Systems - Belmont Abbey College
|
