Julian J. Cummings 736 Cedar LaneNorristown, Pennsylvania 19401201-400-0982

SUMMARY: Investigated and communicated opportunities to business and IT to improve efficiencies with the system

improvement process. Process document creation for SDLC. Participate in defining all Full Treasury and Trust operations system requirements. Identification of data relationships as part of data lineage analysis. Participate in the Project Deliverables, Project Factors and Workshops. Working with sensitive data, data masking, data cleansing and data identification. Consolidation of multiple databases into a single data base and identifying redundant columns of data for

consolidation or elimination. Recommend solutions to ensure accurate transaction processing in General Ledger mainframe. Data testing for system’s conversion and application enhancements and system integration. Develop workflow diagrams for producing transaction reports. Identified trends and contributing factors

relating to processing issues. Analyze and test data to help the daily and future state of business.

TECHNICAL SKILLS:JSystem, ALM/QC, BPM, Sharepoint, SAP, Quality Center, IRFE, OMNI, Wholesale Data Capture, Global Data Capture, TSS, Trust 3000, Imagestation, Lotus Notes, RFX. Extremely knowledgeable of all Microsoft products: Word, Excel, PowerPoint, Visio, and Access (Formulas, SQL, Queries, Data extraction).

EXPERIENCE: 06/14 to WELLS FARGO, Philadelphia, PA Present Business Analyst/QA Analyst

Process development for back office bank transactions (International.) Quality Control Officer for in house daily transactions operations - deposits; withdrawals; ACH; SWIFT. Preparing reports for upper management (International). Manage and review and completing FSD/BRD for Test Scripting. Analyze and compile reports for QA Recon for international and domestic account data. Compiled and analyzed transaction information in order to create and improve interdepartmental business flow

processes/System upgrades and installation. Testing system enhancements and applications that interface with the mainframe.

06/13 to WILMINGTON TRUST, Wilmington, DE 11/14 Business Systems Analyst

Workflow Creation /Unit Testing/ Functionality Testing / End to End Testing Plan Matrix Preparation. Process Management/Compliance Officer UAT Test Plan coordinator / UAT Test Script preparation lead User Acceptance Testing activities through all

phases of the SDLC process into to code implementation phases. Created UAT description – Test priority, test title, test description, test design. Executing UAT test scripts for static and financial data migrations within Back and Middle and Front Office

Operations (Defined benefits, loans, mortgages, personal banking). System Development - JAD Sessions, Process development, Multiple System Integration. Maintain and test applications that uphold daily operational business workflow. Documenting all test results and reporting to upper management. Working liaison between upper management and the IT Support team. Database Management Planning and System Integration(ERP).

Remediation Coordinator and SME Consultant through remediation. Consultant for future State.

02/12 to GMAC, Ft. Washington, PA 06/13 Business Systems Analyst

Developed workflow diagrams for producing transaction reports. Gather business requirements and technical requirements for review and system enhancements. Writing and developed test strategies for the batch reconciliation process. Created UAT description – Test priority, test title, test description, test design. Executing UAT test scripts for static and financial data migrations within Back and Middle Front Office

Operations(Defined benefits, loans, mortgages, personal banking) Leading user acceptance testing activities through all phases of the SDLC process into to code implementation

phases. Worked extensively with partners in the Back and Middle Office Operations to define requirements to support

day to day business activities and to make the current state process more seamless and efficient. Perform analysis of IT systems and execute appropriate solutions. Application and program downloads installation and upload with FTP servers. Perform data clean ups and data migrations.

12/10 to WELLS FARGO, Philadelphia, PA 01/12 Business Analyst

Back office bank transaction support (Corporate, Domestic, International accounts Batch reconciliation of cash products for domestic and global individual and corporate accounts into the RFX G/L

system. Back office bank transaction support (Corporate, Domestic, International accounts.) Quality Control Officer for in house daily transactions operations - deposits; withdrawals; ACH; SWIFT. Preparing transactions reports for upper management (domestic and global money transfers) daily, monthly and

weekly. Foreign currency exchange for individual and corporate Wells Fargo account holders on a daily basis. Investigated and communicated opportunities to business and IT to improve efficiencies with the foreign

exchange process. Developed test strategies to improve daily batch reconciliation process. Developed workflow diagrams for producing transaction reports. Worked extensively with partners in the back and Middle Office Operations to define requirements to support day

to day business activities and to make the current state process more seamless and efficient.

11/09 to DEUTSCHE BANK, Newark, DE 09/10 Business Analyst

Liaison between upper management and the IT Support team. Understanding PL/SQL queries. Writing and executing UAT test scripts for static and financial data migrations within Back and Middle and Front

Office Operations (mortgages, loans, defined benefits). Leading user acceptance testing activities through all phases of the SDLC process into to code implementation

phases. General ledger entry administration of corporate and individual accounts on the SAP general ledger account

system. Reconciliation of time sensitive domestic and foreign exchange currency transactions. Reconciliation duties: International Bank, Domestic Bank, Corporate Accounts, Individual bank transfers to be

posted to the General Ledger. Process and reconcile the receipt of cash transfers of funds in large denominations to participating DDA, Federal

Funds and Trust accounts in the SAP G/L. Manage and review client Service Level Agreements (SLA) for customer compliance. Analyze and compile international and domestic reconciliation data. Compiled and analyzed transaction information in order to create and improve interdepartmental business flow

processes/System upgrades and installation.

Identified trends and/or contributing factors relating to processing issues and recommended solutions to ensure accurate transaction processing in SAP G/L mainframe.

Data testing, system conversions. Worked extensively with partners in the Back and Middle Office Operations to define requirements to support

day to day business activities and to make the current state process more seamless and efficient.

07/08 to JPMORGAN CHASE, Newark, DE 10/09 Business Analyst

Participate in defining all Full Treasury and Trust operations system requirements. Understanding PL/SQL queries. Writing and executing UAT test scripts for static and financial data migrations within Back and Middle Office

Operations. Leading user acceptance testing activities through all phases of the SDLC process into to code implementation

phases. Worked extensively with partners in the Back and Middle Office Operations to define requirement (JAD Sessions)

to support day to day business activities and to make the current state process more seamless and efficient. Database Management Planning and System Integration(ERP). General Ledgers: SAP, TSS, IRFE, WDC (Wholesale Data Capture), GDC (Global Data Capture) OMNI. Account set up. Client information, account information changes and enhancements on the SAP G/L Heavy reconciliation duties: International Bank, Domestic Bank, Corporate Accounts. Individual bank transfers to be posted to the SAP G/L. Generate, produce and analyze reporting features extracted from SAP G/L. Third party transactions, International Transfers, all forms of all Domestic Banking Functions. Reconciliation of wires, checks, facilitate and process SWIFT messaging. Facilitate the cash transfers of funds in large denominations to participating DDA, Federal Funds and Trust

accounts. Analyze and compile international and domestic reconciliation data in order to improve upon current and future

state. Working liaison between middle management and IT Support. Document all necessary business and functional requirements that are produced from all functional working

group discussions. Facilitate the cash transfers of funds in large incremental denominations to participating DDA, Federal Funds and

Trust accounts. Analyze and compile international and domestic reconciliation data in order to improve upon current and future

state. 06/04 to CLEARVIEW MORTGAGE, Cherry Hill, New Jersey 06/08 Mortgage Broker

Assessing borrower’s circumstances, credit history and affordability, applying for pre-approval of loan. Client education on loan origination and process Loan selection guidance: 10,15,30,40 YR FIXED, 1,3,5,7 YR ARM and 1, 3, 5, 30 YR INTEREST ONLY, HOME EQUITY

LINE, 2ND MORTGAGE. Assisting customer with guidance and needs gathering loan documentation. Loan document preparation. Ensure the prompt and accurate completion of all initial mortgage related documentation, ensuring compliance

with lending policies and administrative processes. Loan document assembly for underwriting. Uploading customer data into general ledger. Assisted with closure with outstanding questions, scheduled appointments and assisted with loan closing duties. Proactively manage own sales performance, using the established processes and procedures for reporting sales,

spotting deficiencies and implementing recovery plans to achieve target. 05/01 to ATLANTIC PACIFIC MORTGAGE CORPORATION, Mount Laurel, New Jersey 05/04 Mortgage Broker

Process assistance with mortgage approval, mortgage pre approval, loan qualification, and pre-qualification.

Duties included assessing borrower’s circumstances, credit history and affordability, applying for pre-approval of loan.

Client education on loan origination and process. Assisting customer with guidance and needs gathering loan documents. Loan selection guidance: 10, 15, 30 and 40 YR FIXED, 1, 3, 5 and 7 YR ARM and 1, 3, 5 and 30 YR INTEREST ONLY,

HOME EQUITY LINE, 2ND MORTGAGE. Filing application for loan, explaining legal procedures, and sending all pertinent information to the lenders. Work in tandem with underwriter to assist clients. Loan document preparation. Follow up with answers to questions, schedule appointments and help with necessary paper work for loan to go

into its closing.

01/00 to SEI INVESTMENTS, Oaks, PA 05/01 Business Analyst, Cash Management

General Ledger: Trust 3000 Account set up, properties, enhancements. Full Service correction of Mutual Funds, DCA’s (401k), Capital Gains, Dividends, using daily factors, mutual fund

N.A.V. Cash Management duties: Reconciliation of wires, Checks and SWIFT Messages. Compiled and analyzed transaction information in order to create and improve interdepartmental business flow

processes/ System upgrades and installation. Identified trends and/or contributing factors relating to processing issues and recommended solutions to ensure

accurate transaction processing. Defined and documented business requirements from subject matter experts. SEI Trust 3000 data testing, system conversions, fund mapping. Working liaison between upper management and the IT Support team Responsible for: QDRO’s, hardship withdrawals, rollovers, loans and loan repayments Writing and executing UAT test scripts for static and financial data migrations within Back and Middle Office

Operations Leading user acceptance testing activities through all phases of the SDLC process into to code implementation

phases Worked extensively with partners in the Back and Middle Office Operations to define requirements to support

day to day business activities and to make the current state process more seamless and efficient.

05/98 to MERRILL LYNCH, Horsham, PA 01/00 Account Representative

Senior Account Rep/ New Employee Trainer. Resolve team and client issues and concerns. Account Reconciliation and Trade Corrections. Total asset management base over 180 million. Responsible for: QDRO’s, hardship withdrawals, rollovers, loans and loan repayments Interact daily with Financial Consultants and Marketing Managers. Set up 401(k) plans; implement system enhancements and payroll processing. Maintain 401(k) plan administration. (Compliance and Payroll)

EDUCATION:Community College of Philadelphia, Philadelphia, PABusiness Administration