PROFESSIONAL SUMMARY:

• 8+ years of Industry experience as a Business Systems Analyst in Banking and Finance industry.
• Solid understanding of Business Requirements Gathering, Data warehousing, Data Modeling, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Strong noledge in various functions such as Internal Audit, Compliance, Financial analysis, financial reporting, Regulatory reporting and Management reporting (MI).
• Diverse experience in Banking, Financial Services and Mortgage.
• Experience in working on Loan Originating, Loan Servicing, Loan Modification, Commercial Lending.
• Knowledge of Commercial Lending Systems like Loan IQ. Familiarity with Consumer Lending Processes.
• Detailed understanding of teh front office, middle office and back - office operations of Core Banking activities, Clearing and settlement Process and Funds Transfers.
• Strong experience in accounting such as Profit & Loss, Balance Sheet, and Cash Flow Statements.
• Experience of Investment Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments
• Having excellent understanding of Financial Accounting. Comprehensive noledge of balance sheets, G/L ledger, trial balance, income statement.
• Strong noledge in migrating teh Commercial Lending Process from existing AFS Application to teh new application platform Loan IQ, mainly focusing on teh Commercial Lending Servicing process.
• Experience in database technologies and has successfully implemented database centric solutions using SQL and PL/SQL in banking domain.
• Excellent PL/SQL programming skills using PL/SQL Packages, stored procedures, functions, triggers, cursors, views, indexes for processing data.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Strong experience in accounting, finance and systems background with experience in auditing, financial reporting, bank regulatory reporting and financial systems implementation.
• In depth noledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D)
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Experience in working with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams, navigational flows, story boards, UI specifications and Sequence Diagrams.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Experience with SOX, Regulatory Compliance and Controls.
• Knowledge in teh ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Experience in creating business requirement documents (BRD), System requirement specification (SRS), use cases, functional requirement documents (FRD), test cases, test reports and other documents requires in software development life cycle (SDLC) and software testing life cycle (STLC).
• Experience in project management and defect Management with JIRA, confluence.
• Experienced in writing Test Plan and Test Cases and aggressively involved in Regression Testing and Performance Testing using automation tools like Win Runner, LoadRunner, Test Director, Quick Test Pro, Silk Test and Oracle table manipulation using SQL.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.

TECHNICAL SKILLS:

• Rational Rose Enterprise Suite
• Rational Requisite Pro
• MS Visio
• Test Director
• Test Manager
• Rational Clear Quest
• PVCS Tracker
• MS Office
• MS Project
• MS Publisher
• MSRS
• Rational Robot
• Performance Studio
• Mercury Win Runner
• Load Runner
• Korn Shell Script
• C/C++
• Java
• Teradata
• SQL
• PL/SQL
• Rally
• VB
• Shell Script
• Cognos
• Business Objects
• SAS
• Html
• Crystal Reports
• Micro strategy
• Visual Basic
• Access
• Excel
• MS-SQL Server
• Oracle
• Agile/Scrum
• Waterfall
• Sybase
• SQL* Plus
• UNIX (Solaris/Linux)
• MS-DOS
• Windows
• MS FrontPage
• Dream weaver
• Empower
• Encompass
• JIRA
• Blueprint.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Business Systems Analyst

Responsibilities:

• Facilitated brainstorming session, JAD session,conducted all day Working session, requirement gathering session.
• Worked with consultant to turn on Translation for General Ledger (GL). Work included creating and executing GL allocations to re-state ledger balances as needed for teh process, updating ledger configuration, performing UAT, researching and correcting issues, and implementing in Production.
• Developed BRD, FRD, Activity flow,Businessprocess flow and Use cases.
• Teh project heads towards enhancing teh existingonlinebankingapplication by improving its GUI, making it user-friendlier.
• Application was developed forOnlineBankingaccessing personal accounts, checking balances, payment of recurring bills, such as mortgages and loan payments, transfer of funds between accounts of its customers.
• Performed extensive Vendor Management. For example, manageOracleEBSFinancialsand relationships with third partyOraclepartners.
• Facilitated all aspects of teh Scaled Agile Framework (SAFe), sprint planning sessions, backlog grooming sessions, daily scrums, product demos, sprint reviews and sprint retrospectives.
• Facilitated requirement walk through session involving Clients, developers andbusinesssupport group.
• Engaged with UBS Bank’s auditors on annual reviews ofOraclecontrols and transactional system reconciliations to teh general ledger.
• UtilizedOracleBI (OBIEE) toolset and teh Data Warehouse to retrieve data for forecasting and monthly analysis for plan variances.
• Assisted TPM in organizing team meetings, avoiding conflicts and maintaining teh project schedule by requesting teh forecasted timeline from all team members each month.
• Documented teh Current and Future State Accounting Work flow as part ofOnlinePayments.
• Created Action Item, Issue Log, Risk Log, Decision Log and documented risks and issues with its priority and assigned them to right person
• Analyzed Inventory of requirements and prioritize Gap/Fit matrix with oracle applications. Mapping requirements with Oracle standard features.
• Coordinated comprehensive analysis and resolution of payments, invoices and expense reports, working with financial officers to analyze and report data stored in R12 Oracle Finance modules and HR system.
• Daily communication with clients, Vendor and SMEs to get teh status of action items, response to risks and issues, update teh log and provide teh updates by EOB.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Tested several ACH transmissions to various banks. Added logic to consolidate several accounts with a single bank into one transmission, to reduce processing time, bank fees, and amount of technical support required.
• Involved in researching solutions for Customer to review ACH payments for automated cycle, prior to submission of teh file.
• Developed teh Wire Frames, User Interfaces, AS-IS and TO-BE flows and teh Use Cases to encapsulate teh information with ease.
• Tested migration data in a test instance ofOraclein teh development schema (Test Plans, Project Guidelines) for a migration conversion of two instances ofOracleinto one instance ofOracleto ensure teh data migrated correctly.
• Wrote Test case, and test Scripts.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
• Worked on Client/Server tools like SQL Server Management Studio to administer SQL Server.
• Converted various SQL statements into stored procedures theirby reducing teh Number of database accesses (since Stored Procedures passes teh whole block at one time.)
• Filled teh Role of Test manager by creating Test case, reviewing it and getting approval from clients, developers, and SME's.
• Conducted daily SIT testing status update meeting, logged identified defects in HP Quality center, Assigned teh defects to right resources, updates progress status and severity status.
• Assisted Clients in documenting UAT test scripts

Confidential, Brooklyn, NY

Business Systems Analyst

Responsibilities:

• Collectedbusinessrequirements frombusinessusers, which provided appropriate project scope for teh technical team to develop prototype and teh overall system.
• Created a development plan for teh overall project, including teh coarse-gained project plan, showing iterations and evaluation criteria for each iteration.
• Responsible for Freight tracking, documentation, MIS analysis and resolution of issues of teh customer satisfaction.
• Helped customers in increasing teh shareholder value and broadening lending and deposit base.
• Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement
• Enabled Barclays to operate on one data processing system by converting checking, savings and money market accounts off of theMetavantesystem and on to teh FIS Systematics' application, IM.
• Conducted intensive data analysis over in scope databases and created various coverage documents to support teh project initiation Phase.
• Created BRD, FRD using JAD sessions and used UML forBusinessProcess Modeling, Use Cases, Activity Diagrams, Wireframe prototypes and documenting them using Microsoft Visio.
• Responsible for conducting assessment of data quality of teh data leveraged by compliance processes like Trade Surveillance, AMLetc.
• Used Oracle TOAD and SQL to pull data in order to determine input for user reports
• Used Business Objects to develop and maintain a BO Universe for Financial Reporting as well as create and maintained Crystal Reports within teh BO Tool.
• Coordinate user acceptance and regression testing for Oracle patching initiative, directly supporting 20 SME business users
• Documented testing objectives for surveillance alert generation and assisted in identifying gaps, emerging needs, and redundancies.
• Implemented methodologies for digital projects to ensure projects are delivered on-time, within budget, adhere to high quality standards and meet or exceed customer expectations.
• Involved in various aspects of teh scrum framework, including sprint planning meetings, daily scrum meetings, sprint review and retrospective meetings.
• Documented functional specifications for OFAC (Office of Foreign Assets Control) andAML(Anti-Money Laundering) requirements under BSA (Bank Secrecy Act).
• Participated in internal banking audit OFAC compliance initiatives gathering and verifying data stream flows end to end through FIS/Metavante, ACH, Lock-box application platforms.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from teh database.
• Ran and tested required queries and reports before publishing.
• Created data mapping document for teh application after finalizing teh attributes and tables with businessusers.
• Prepared sequence diagrams, data flow diagrams andbusinessprocess models that depict how teh payment instruction would apply to teh UI, backend services layer and General Ledger application.
• Ensured teh compatibility of teh newbusinessrequirements with teh existing system infrastructure and developed testing scenarios to check how teh system would work under different scenarios and developed acceptance criteria.
• Facilitated User Acceptance Testing (UAT) along with teh Subject Matter Experts (SME) and assisted in functional testing, integration testing, and system testing processes.

Confidential, - Newark, DE

Business Systems Analyst

Responsibilities:

• Defined teh scope andbusinessrules of teh project, gatheringbusinessrequirements, and document them textually and using models
• Gatheird requirements using interviews, document analysis, requirements workshops,business process descriptions, business analysis and workflow analysis.
• Involved in project review meetings, gathering System Requirement Documents (SRD) and Data Mapping Sessions.
• Setting up loan templates from various commercial lending deals from CRE, ABL into teh ACBS system. Building customers records, facilities and loans in pipeline and servicing for teh prototype testing for thebusinessusers
• Maintaining and keeping track of teh fields and preparing a proposed file layout (Field Name, datatype, Details) that needs to find a house or transferred in ACBS and documenting it.
• Making Process flows in Microsoft Visio of teh ACBS processes in different BRDs to make thebusinessUsers better understanding of teh new system.
• Making test scripts and test scenarios to be input in ACBS for prototype testing and for conversion scoping.
• Maintaining and managing meeting minutes of various interfaces meetings and uploading on SharePoint on regular basis.
• Being a part of Conversion scoping sessions with teh FIS andbusinessusers to discuss and keep a track of fields that are required to be converted in teh new system.
• Keeping track and maintaining User defined tables, translation tables and purpose codes tables during teh discussions.
• ReviewBusinessRequirement Documents (BRDs). Facilitate meetings with teh appropriate subject matter experts for CRE, ABL, C&I & Trade Finance. Ensure that high-levelbusinessrequirements (sections, sublimit) have been decomposed properly into useable functional requirements for ACBS.
• Performed data analysis and cleansing guided by thebusinessrules and source data.
• Meeting with decision makers, system owners and end users to define and document requirements and goals.
• Drafted training manuals and user documentations forbusinessusers.
• Conducted various JAD sessions with differentbusinessusers for requirements elicitation and for discussing various business lifecycles of commercial lending.
• Created AS-IS and TO-BEbusinessprocess flow diagrams, integrate process flow diagrams to show end-to-end business model andbusinessprocess mapping exercise including swim lanes.
• Created and maintained Product and Sprint backlogs and monitored to ensure regular updates of activities/tasks.
• Arranged daily Scrums, Sprint Planning Meetings and Sprint Reviews and Retrospectives.
• Clarified and prioritized requirements by conducting brainstorming sessions with teh stakeholders and SMEs.
• Managed product backlog within JIRA, and project information and artifacts using Confluence.
• Collaborated with teh QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured appropriate documentation is in place.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
• Have a strong noledge of writing SQL scripts for Store Procedures & T-SQL statements.
• Prepared BRDs and Use Cases.
• Prepared teh Technical specifications based onbusinessrequirements.
• Updated teh Change Requests in requirements documents
• Performed Unit Testing, identified teh defects and retested teh defects fixed by teh developers.
• Prepared Dash board for viewing teh test cases results.
• Performed Causal analysis on teh defects and created teh mitigation plan.
• Acted as Team coordinator between teh development team andbusinessusers.

Confidential, Providence, RI

Business Systems Analyst

Responsibilities:

• Involved in teh analysis of teh existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Performed Gap Analysis to check teh compatibility of teh existing system infrastructure with teh new business requirements.
• Followed solely RUP methodologies during teh course of teh project.
• Accumulated system requirements from various departments through surveys and interviews.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Involved in Software Development Life Cycle (SDLC) documentation, such as a Business Process Description (BPD) and Functional Requirements Document (FRD) and Software Requirements Specifications (SRS).
• Created separate Business Requirement Documents, use cases and conducted walkthrough with teh business owners and took sign-off on both Web Application and Mobile Apps (iOS and Android)
• Involved in testing websites for desktop and responsive behaviors on all browsers and devices and thorough Knowledge of mobile UI/UX best practices as laid out by iOS and Android platforms
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using teh UML (Unified Modeling Language) methodologies.
• Worked on Data Mapping documents of various HTML field onto XML tags and then further onto tables stored in database.
• Involved in creating data visualization models for B2B and EDI operations system using Tableau.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Worked on Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Provided daily/ monthly departmental processing metrics to management for monthly dashboard reporting
• Worked on Ad hoc processes including but not limited to import duty payments, invoice payment cancellation, check handling, invoicing contract language reviews
• Worked on JIRA for tracking teh issues and defects during teh process of Implementation.
• Responsible for gathering requirements from users in operations group and performing data mapping for teh application, confirm and vacillating teh requirement at time of BA testing
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
• Actively participated in conducting review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.

Confidential, Oklahoma City, OK

Business Analyst

Responsibilities:

• Interacted with Business Users to conduct thorough Requirements Analysis.
• Reviewed and analysed teh business environment and identified process improvements.
• Involved in interactions with teh Subject Matter Expert, Project Manager, Developers, and teh End-Users.
• Coordinated activities with project manager and various other teams using MS Project.
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Involved in developing Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
• Worked on SDLC, Business analysis, GAP analysis and Quality Assurance of application software in Agile framework.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is TEMPeffective, efficient, standardized, coordinated, and integrated.
• Assisted teh Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Developed Test Plans and Test Cases according to Business Requirements.
• Involved in generation and execution of SQL queries.
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with teh development team regarding defect status and fixes on a daily basis.