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 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:

Confidential

Use Teradata SQL Assistant, PC-SAS and SAS EG to conduct research and run daily, weekly and monthly reports. FTP csv.txt files from test environment to test and production drives.

Confidential

• 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.

Confidential

• 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.

Confidential

• 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.

Confidential

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.

Confidential

• 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.

Confidential

• 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.

Confidential

• 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.

Confidential

• 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,
• 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 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.
• I used 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.

Confidential

• 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.