SUMMARY

• Around 7 years of software industry experience with an excellent understanding of the Finance domain.
• In - depth knowledge of the business process and software development life cycle including Requirement gathering, Analysis, and requirement artifacts creation.
• Excellent Analytical skills to understand the business process and Functionality, Requirements and to translate them to system requirement specifications. Developing functional specifications for business process refinement and automation, data modeling, System Architecture, conducting feasibility studies, and scope.
• Thorough knowledge of credit card processing authorization, clearing, and settlement.
• Proficient in conducting and leading JAD sessions and deriving the requirements.
• Conducted GAP analysis using AS-IS and TO-BE Business processes, SWOT analysis, Cost Benefit analysis, and ROI analysis.
• Expert knowledge in with various capital market instruments and securities including Equities, Fixed Income Instruments, and Risk Management (Credit and Market Risk).
• Adept at Business Requirements Gathering and expertise in the documentation of Business Requirement Documents, Use Case Specifications, Business Process Workflows, Data analysis Cost/Benefit analysis
• Proficient in design and execution of Test Strategy, Test plans, Test Scenarios, and Test Cases based on the requirements for the applications
• Experienced in SOX (Sarbanes Oxley) Compliance. Have expertise in SOX risk and control assessments.
• Experienced in analyzing the existing Risk Management platforms, Financial Services, Portfolio Management, Fixed Income Securities, Mortgage-Backed Securities & Securitization
• Extensive working Experience in using testing methods like Functional, Regression, Integration, System, Security, Initialization, Usability, Database, Smoke/Sanity, End to End, and User Acceptance Testing (UAT).
• Expertise in User Acceptance Testing (UAT)
• Experienced in back-end testing using SQL queries, generating reports to ensure Data Integrity and validate business rules.
• Excellent Experience in Defects Tracking in the Application, Incident reporting, and Process Improvement.
• Extensive experience in Banking Industry groups including Credit, Risk, Investment, and Operational Risk Banking that involve knowledge in CCAR, Basel II, Basel III, Dodd-Frank, and Charles River.
• Thorough understanding of various SDLC models and their execution fundamentals, Worked in Agile and Waterfall models.

TECHNICAL SKILLS

Business Modeling Tools: SharePoint, Microsoft Office, MS Visio, UML, Requisite Pro, Rational Rose

Operating System: Windows, MAC, Unix

Databases: SQL Server, MS Access, MySQL, Postgre SQL

BI/Reporting Tools: Business Objects, Tableau, PowerBI, MS Suite, Qlik

Project Management Tools: MS Outlook, MS Visio, MS Word, MS Excel, MS Access, MS PowerPoint, MS SharePoint

Project Methodologies: Agile, Scrum, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, West Springfield, MA

Business Analyst

Responsibilities:

• Gathered business requirements, creating Business Requirement Documents (BRD), Project Plans, Timelines, Workbooks, and other project design requirements.
• Documented as-is and to-be process flows.
• Approved mortgage loans by examining the application and supporting documentation; estimating credit worthiness; calculating repayment risk.
• Assisted with client onboarding and client roll-out, including Trade Operations and Reconciliation, NAV calculations, and Investor Services. Coordinator of team efforts in Agile environment and Production.
• Implementing FATCA methodology for Capital Markets business (Equities, Fixed Income, Derivatives) - Understand implications of FATCA and Conduct current state analysis.
• Managed User Acceptance Testing (UAT) and defect remediation through Quality Center (HPQC), ensuring that approved code is implemented and validated on schedule.
• Reviewed loans according to RESPA, GSE, FHA, and VA guidelines.
• Researched and summarized new rules and regulations and document applicable controls and potential gaps, specifically related to regulatory reform including liquidity and capital rules and various SOX, Dodd-Frank Act, Basel III, RESPA, and HMDA requirements, as well as new Finance business initiatives.
• Documented the elicited software requirements into enhanced Business Requirement Documents (BRDs) for BASEL III and its Addendum.
• Resource planning built and managed relationships with internal teams, cross-functionality teams, business partners, etc. Agile & related skill set-ability to write stories, support release/sprint planning.
• Conducted Scrum Meetings, Prepared User Stories, conducted Review Meetings, Retrospective Meetings, and demos.
• Maintained artifacts such as Sprint burn down, Product burn down chart, and defect logs, which in turn assisted in velocity and capacity calculation for superior planning of upcoming sprints.
• Handled and worked with a Mortgage Loan officer for increasing mortgage loan portfolio by developing business contacts, attracting mortgage customers, completing mortgage loan processing and closing, and supervising staff.
• Competed for mortgage loans by monitoring collection, verification, and preparation of mortgage loan documentation; scheduling and completing mortgage loan closing.
• Identified and documented trade process’ steps that results in an electronic record to support SOX compliance
• Meet mortgage loan financial standards by providing annual budget information; monitoring expenditures; identifying variances; implementing corrective actions.
• Scheduled SSIS packages to run at different intervals to load data into SQL Server. Designed screen mock-ups for changes in system functionality.
• Dealt with Society for Worldwide Interbank Financial Telecommunication (SWIFT) in creating criteria for auditing of TQR and Q-Gate review processes.
• Prepare/Review KYC profiles in accordance for sign-off in accordance with Group Policy, KYC ID Matrix, local regulatory requirements and Sign Off Authority.
• Interacting with the business users to gather requirements based on the CCAR Regulation for Financial Statements, Interest Rate, Credit Ratings, FRY9C, and Investment Securities.
• Attracted new mortgage loan applications by developing relationships within the community, specifically with real estate community; making sales calls to prospective customers.

Environment: SQL, Agile, MS Office, Rational Rose, Rational Requisite Pro, ClearCase, UML, Rational Suite, MS Visio, MS Project

Confidential, Boston MA

Business Analyst

Responsibilities:

• Served as liaison between IT and business users including reporting requirements and system information.
• Gathered User and Business Level Requirements for Stakeholders from various departments like Accounting /Finance and Information Systems and designed the business requirement collection approach based on the project scope using AGILE methodology.
• Conducted JAD sessions, and analyzed and documented the business requirements of various teams and stakeholders.
• Performed financial research and analysis as necessary and respond to data requests and additional projects and responsibilities as assigned.
• Created and maintained project tasks in Jira, providing daily status reports to project and senior level management.
• Successfully implemented Jira as the project and task management tool of choice for IT, Marketing, and other business units.
• Performed Business Process Mapping and performed AS IS and TO BE analysis.
• Involved in requirement gathering with the SMEs to get the maximum information about the workstream including Mortgage Servicing, Loan Monitoring, and Asset Management.
• Used SQL to query the database and performed data analysis.
• Used SQL queries and data mining to provide summary reports and data feeds to analytics. Manage ETL defects, enhancement, and new functionality requests to meet changes in business needs.
• Created and implemented a process for Incident and Change management utilizing Jira and Jira Service Desk.
• Conducted Scrum Meetings, Prepared User Stories, conducted Review Meetings, Retrospective Meetings, and demos.
• Maintained artifacts such as Sprint burn down, Product burn down chart, and defect logs, which in turn assisted in velocity and capacity calculation for superior planning of upcoming sprints.
• Prepared Analysis documents, process flow diagrams, converted Epic into user stories, Product Backlogs Grooming, and sprint planning
• Developed UML diagrams like Use Cases Diagram, Activity Diagram, and Process Flow Diagram using MS VISIO.
• Meet mortgage loan operational standards by contributing mortgage loan information to strategic plans and reviews, implementing production, productivity, quality, and customer-service standards, resolving problems, and identifying mortgage loan system improvements.
• Analyzed business requirements and create business rules for client-side validations.
• Facilitated the process of orchestration by providing a process flow diagram in order to automate the business process. Made sure that the new regulation is followed for the Traditional and Roth IRAs.
• Identified the limitations users currently experience in the operational reports obtained from current systems and recommended solutions to overcome these limitations.
• Suggested measures and fine-tune queries to improve the performance of each Interface and the quality of the output files.
• Researched, wrote, and reviewed Suspicious Activity Reports on a daily basis while ensuring compliance with federal regulations.

Environment: MS Visio, SQL, VSTS, MS Office, Rational Rose, Rational Requisite Pro, ClearCase, UML, Rational Suite

Confidential, NY

Business Analyst

Responsibilities:

• Assisted Project Manager (PM) as project coordinator in creating Work Breakdown Structure (WBS) and Project Charter using MS Project.
• Assisted the team with User Acceptance Testing (UAT) maintaining Quality Procedures; also, assisted QA
• Analysts in Black box testing, Integration testing, Performance, and Load testing, Functional, Regression testing
• Identified and Modified Defects, Issues, and Priorities using JIRA and captured them into a tracking log.
• Identified bugs and assisted via User Acceptance Testing (UAT) to verify if the system meets user requirements and get UAT Sign Off from the stakeholders.
• Conducted GAP Analysis and Feasibility Analysis along with Cost-Benefit Analysis to document the shortcomings of the system in place along with identifying the advantages and functionalities of the proposed system.
• Worked with SMEs in managing risk or hedging and attained experience in Foreign Exchange Trading.
• Handful experience in managing various asset types including in-depth knowledge of Fixed Income Securities (debt), equity, and derivatives.
• Facilitated and managed meeting sessions with a committee of SMEs from various business areas including Loan Monitoring, Asset Management, and Marketing.
• Attended seminars and workshops on Muni-debt and financing
• Created UML Diagrams like Use Cases, Activity, and Sequence Diagrams using MS Visio for a clear understanding of the vision document;
• Generated ad hoc reports by writing Structured Query Language (SQL) using special functions like Joins, Inner joins, Outer joins, implementing database connections to fetch data from the Serve

ENVIRONMENT: Mainframes, DB2, MS Office, Requisite Pro, VSS, Clear Quest

Confidential - Chicago, IL

Business Analyst

Responsibilities:

• Worked on documentation of Project Vision and Scope, Cost-Benefit Analysis, management of Project Budget, and making Project Schedule with the Project Manager.
• Extensive use of application TOAD to write SQL queries for data manipulations.
• Working with development and QA teams to specify the requirements. Also worked with and supported cross-functional project teams.
• Prepared and analyzed As-Is and To-Be workflow scenarios and performed Gap analysis.
• Extensive use of SharePoint to share and update documents with the team.
• Resolved issues and conflicts between different stakeholders, and found proper resolutions to make all stakeholders satisfied.
• Participated in all Agile Ceremonies with the team, formed of developers and testers, such as Sprint Grooming, Sprint Planning, Daily Stand-Ups, and Team Retrospective.
• Conducted and guided JAD and Brainstorming Sessions to gather Business Requirements from the Market Risk Group, Risk Reporting Team, and other SMEs.
• Develop and manage project plans, schedules, risks, and projections.
• Keep track of JIRA tickets and close and update them accordingly. Tracking and logging defects or bugs found during UAT.
• Liaise with the Axiom team to coordinate all aspects of testing, including planning, execution, and close out of the UAT phase with reporting team.
• Collaborate with users and the Axiom team to confirm manual data input templates which could be configured by Axiom.
• Expert in HP Quality Center (ALM) Dashboard, Requirement Module, Test Plan/Test Lab module, Defect module.
• Assisted in the calibration and validation of Mantas AML scenarios and behavior detection logic.
• Maintained audit controls for SOX compliance and GAAP accounting and business practices.
• Reviewed and updated DFAST process enhancements for presentation to examiners.
• Designed Test Cases and Test Plans, and prepared Data Mapping documents for the application after finalizing the attributes and tables with business users.
• Participated in developing detailed Axiom automation data flow documentation for senior management review to demonstrate the CCAR automation process.
• Work with Regulatory Reporting, Axiom, QA, and data sourcing team in planning, executing, controlling, and closing phases of projects and in CCAR reporting automation (FR-Y 9, FR-Y 14Q, etc.)
• Assisted the execution of CCAR stress testing framework including gathering requirements of multiple stress scenarios and defining data elements required by stress tests.

Environment: MS Office Suite (Word, Excel, Access, PowerPoint & Outlook), Microsoft Visio, Windows, Oracle, SQL, SQL Server, Jira, UML, SharePoint, HP Quality Center, HTML, AML Mantas tool, AXIOM, SOX, TOAD.