SUMMARY

• Business analyst with 8+ years of experience in Finance and banking services with a prime focus on, regulatory reporting and other financial services applications, Mortgage Loan Servicing, leading in the development, documentation, and delivery of business goals.
• Extensive experience in all aspects of consumer and real estate loan origination System LOS, underwriting and collections.
• Worked in Banking and Financial Services Industry in diverseCapital Markets domains in areas such as Fixed Income, Financial reporting usingBusinessObjects and Spreadsheets.
• Experience working on Automated Financial Systems platform (AFS) in fully integrated commercial lending system designed to process multiple types of loans on a single, real - time, multibank, multilingual, multicurrency system.
• Experienced with Mortgage Servicing, Loan Monitoring, LOS and Assets Management.
• In depth knowledge of Trade Settlements process between Loan IQ and IHSMarkit Trade Settlement platforms (ClearPar & Loan Settlement Manager) as well as the communication methods between these applications (Webservices & Message Director)
• Extensive experience in working with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS, Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Servicing, Loan Ordination, CMBS, Secondary Mortgage Market.
• Experience in Scrum Agile and SAFe Methodology Framework with the Acceptance Test Driven Development.
• Experience inCommercial Lending Systems like Loan IQ. Familiarity with Consumer Lending Processes.
• Worked on Black Knights Empower LOS for Retail, Wholesale, and Commercial Loans.
• Experience in working on requirements related to different account types (Checking, Saving, Time Deposits, Managed, Self-Directed, Loans,Escrows, Security Deposits) and corresponding fields required to be displayed to the Clients.
• Expertise in User Interface documents, Test Plans, Test Scenarios, Test Cases and Functional Specifications.
• Experience with Mortgage loan servicing, Loan Origination, Student Loan Origination
• Excellent knowledge of Software Development Life Cycle(SDLC), iterative Software Development Life Cycle Process. (Agile, Kanban, Waterfall and RUP)
• Extensive skills in Unified Modeling Language (UML)Diagramslike Class,Activity/ State, Sequence, ERdiagramsusing Rational Rose and Microsoft Visio. Developing Use Casediagrams, Sequencediagramsand Class diagrams,activity diagram, swim-lanediagram, development diagram, integrationdiagram, Using QC, MySQL, MS Project and prototyping tools.
• Proficient in using Agile Scrum methodologies, performed roles of Product Owner, Scrum Master following sprint/standup sessions and used JIRA & Version One extensively to write Epics, User stories, analyzed the Iteration Burn Down charts and reviewed defects.
• Worked with creating databases and structuring of Big Data on servers SQL and Sybase and in applications, using data generated from live and static feeds in a variety of formats
• Extensive Knowledge in Capital Markets, Corporate Finance, Risk Management, Investment Banking, Mortgage, Financial Statement Analysis, Equity, Fixed Income, Alternative Investments, Derivatives, M&A, IPO etc.
• Mortgage experience includes Consumer Mortgage Lending, Wholesale Mortgage Lending, Warehouse Mortgage Lending and Commercial Mortgage Lending.
• Extensive experience working with XML, Schema Designing and XML data.
• Extensively used Test Management Tool HP Quality Center/ALM to Develop and execute Test Cases/test scripts.
• Expertise in diverse retail banking sectors including lending, deposits, payments, cards, trade finance, treasury, regulatory reporting (BI), KYC, AML, payment system.
• Domain knowledge in the field ofBankingandMortgagewith understanding of various risks and compliances likeBasel Accord, SOX and FINRA.
• Skilled in preparingbusinessrequirementsdocument (BRD), functional andtechnicalspecifications, systems design andrequirementsspecifications.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Experience in Data transformation, Data Mapping from source to target database schemas, Data Cleansing procedures
• Proficient in creating Risk Analysis documents, Risk Management Plan, User Requirement Specification, Functional Requirement Specification and Business Process Flows.
• Excellent understanding of Database management system, Data warehousing concepts, BusinessIntelligence technologies and Data mining.
• Experience in Software Development Life Cycle (SDLC) process, Software Testing Life Cycle (STLC) and Product Development life cycle including Waterfall, Scrum/Agile, and QA methodologies.
• Highly skilled in creating, writing, and executing Test Cases, Test Scripts from Business User Requirement documents and Functional Design Documents.
• Skilled in converting legacy reports to more contemporary programs such as Crystal Reports, Business Objects, MS Excel, MS Access, and SQL, and condensing number of reports to simplify processes

TECHNICAL SKILLS

Domain expertise: Mortgage loan servicing, Mortgage-Backed Securities (MBS), Stocks, Options, Commercial lending, Wealth Management, Capital markets, Fixed income, Equities, Risk management, FX, Asset management, Derivatives, Bonds, Hedge fund, Credit risk, Market risk, Loan orientation, Loan processing, SOX, ETL, Data warehouse, EMIR, BASEL

Defect Tracking Tools: Bugzilla, JIRA, Mantis, HP ALM/Quality Center, Rational ClearQuest

Testing Tools: - Selenium, QuickTestPro, Windmill, Watir

Software IT Tools: Rational Rose, Rational SoDA, Rational Clear Case, Requisite Pro

Methodologies: SDLC, Agile, Waterfall, Scrum, RUP, UML, Spiral, Six Sigma

Data Warehouse tools: Informatica, IBM - Websphere DataStage, AB Initio

Business tools: MS Visio, MS Project, MS Access, MS Office Suite, idashboard, SharePoint, Cognos, Lucid Chart, Intellect BPM, KissFlow, Tableau, Salesforce, NCino, Metacenter

Databases: Oracle, IBM DB2, MS SQL Server, Teradata, MySQL

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. Business Analyst

Responsibilities:

• Worked in accordance with theSafe Agile/Scrummethodology for various phases of the business and created business vision, business architecture documents and mock reports.
• Designed ETL mapping documents, various mappings with Transformation rules and complex mappings including Slowly Changing Dimensions.
• Implemented new file creation using for state using Reverse Mortgage Application
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, with high volume data
• Analyze business requirements and segregated them into Use Cases and activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Gathered requirements from various users, teams and designers to design the business Requirements document, and walk through the whole SDLC following the Waterfall and Agile/SCRUM methodologies.
• Create test data required for a release which involved modifying xml files that contain appraisal data.
• Produce competitive product pricing through the study of industry standards and pricing structures of competitors
• Provide detaileddata mappingbetween Loan IQ and other core applications.
• Involved in requirements and functional solution for building of Segregated Collateral System to comply withDodd-Frankand EMIR requirements of holding pledged collaterals in a segregated account.
• Created and maintained Requirements Traceability Matrix (RTM) to trace technical requirements to theirbusinessrequirements and the test case requirements to their functional requirements.
• Extracted the business requirements for the end users keeping in mind their need for the application and developed the BRDs
• Analyzed business processes and created Business Requirement Definitions for new Loan IQ functionality to accommodate specific regulatory and business requirements.
• Designed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created and maintained Data Governance Confluence site that provided valuable information to the business by supplying data lineage, business glossary, data flows,
• Involved in full project lifecycle and coordinated with all project teams to implementTableau projects using Agile/Scrum development methodology
• Execute developer requests to create new database and database objects in Sybase, Oracle and SQL Server.
• Engaged in proactive dialogue with the LOS (Loan Origination system) and LSS (Loan Servicing Systems) front end users to seek opportunities for efficiency.
• Collaborate with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs.
• Worked with Subject Matter Experts in Fixed Income Annuities, Equities,Swaps, Finance, Trading Cycle, Portfolio Analysis & Management, Asset Management, Bonds and Bond Trading Cycle, Pricing.
• Capture of Functional Requirements and delivery of Functional Requirements Specification.
• Capture of User Interface Requirements and delivery of User Interface Requirements Document.
• Used Quality Center/Test Director for requirement management, test planning, scheduling, executing test cases, managing and tracking defects.
• Effectively used tools like SQL developer, putty for UNIX, and Clear case for version management, HP Quality Center for requirements, test planning and defect tracking.
• Develop Test Plans, Test Cases and Traceability Matrices from functional requirements (FRDs or User Stories).
• Have developedbusinessprocessmodelsfrom interviews with end-users further Created Flow Charts andProcessFlow diagrams, Use Case Diagrams, Class Diagrams, Activity Diagrams / State Chart Diagrams usingBPMN, Microsoft Visio and Rational Rose according to UML methodology thus defining the DataProcessModels.
• Identify integration needs and drive integration design to assure that contact center technologies have access to required data
• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Documented Requirements for Activitymanagement, Fixed Income, AssetManagement Services, Clientportfoliomanagement, Ordermanagementsystem, Performance, Equities, Reconciliation, Transaction capture/Execution and reporting requirements for the user interface.
• Analyzed, Modeled and Programmed of the structured Financebusiness(or other derivatives) line such as asset-backed securities andmortgage-backed securities deals.
• Co-operated with Data Base Administrators (DBA) in Data Base Testing using SQL
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase.
• Used HP Quality Center & JIRA for requirements management, planning, scheduling, running tests defect tracking and managing the defects.
• Extensively worked withRisk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS.
• PreparedTest PlanandTest Casesbased on the business and functional specifications.
• Capture of Business Features and delivery of Business Requirements Document.
• Capture of Reporting Requirements and delivery of Reporting Requirements Document.
• Capture and Formulation of Business Rules and delivery of Business Rules Templates
• Met with client groups to determine project scope, requirements and plan. Utilized Rational Unified Process (RUP) to configure and develop process, and create BRDs.
• Created test scripts for all the test cases in PL/SQL.
• Analyze business requirements and segregated them into high level and low level Use Cases, Activity and Sequence using Rational Rose according to UML methodology.
• Derived Functional Requirement Specifications based on User Requirement Specification. Understand and articulate business requirements from user interviews and then convert requirements into technical specifications.

Environment: MS Word and MS Visio, Excel, Oracle, SQL, Agile, SDLC, Business Objects, Scrum, Avaya, PL/SQL,XML, Flat Files, Informatica, Agile, Power Point, MS Project 2003.

Confidential, Providence, RI

Business Analyst

Responsibilities:

• Interacted with Fixed Income business heads to finalize the Business Requirements for the application.
• Facilitated and managed meeting sessions with committee ofSMEsfrom various business areas includingMortgage Servicing, Loan MonitoringandAsset Management.
• Created and manageddocument templates, Use Case templates, requirement types and traceability relationships in Confluence.
• Followed Scrum and SAFE Agile Methodology for the SDLC.
• Involved in the development of market segmentation models and forecasts reflecting market evolution.
• Worked with various business areas and members of senior management to scope, define, and document data requirements for Mortgage Loan Origination projects.
• Drive various internal strategic initiatives regarding new and existingcapitalmarkets
• Identified, assessed, and documented business requirements, recommended business priorities, and advised business on options, risks, and costs.
• Interacted directly withBusinessUsers and created technicalblueprintfor the whole project.
• Created sequence/processflows, and use cases documenting functional (FRDs) and system requirements (SRDs) allowing development team to start development phase ahead of schedule
• Gathering requirements, writing stories related to mobile application and web application in Commercial Lending business
• Interacted directly with stakeholders to identify and evaluate improvement opportunities and explained issues.
• Interacted with the Subject Matter Expert (SME), Stakeholders and Elicited business requirements for product change requests, enhancements participate in requirements prioritization.
• Worked closely with Product owner and other Business Analyst to ensure integrity of the end to end solution.
• Assist Product Owner with backlog grooming, user story development and prioritization.
• Tracked and communicated user stories, bugs, issues, and tasks to the development team using JIRA.
• GeneratedBusinessRequirementdocuments(BRD), Functional Specificationdesigndocuments(FSD) and Functional RequirementDocuments(FRD).
• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Researched data issues and identify the root cause in source systems, data warehouse and data marts using various data analysis techniques, data profiling and data mining activities.
• Used HP Quality Center for creating and executing test cases, for defect tracking and for generating reports.
• Responsible for providing analysis of products and initiatives with respect to data requirements, data flows, data modeling, workflow context and design.
• Used Data Blending, Groups, combine Adobe Marketing Cloud data and other aggregated data, spotlight into compare and analyze data in different perspective.
• Created use casediagramusing UMLactivitydiagramfor online credit card transaction system.
• CreatedBusinessRequirements Documents, Functional and Software Requirements Specification.
• Involved with the Software Quality Assurance (SQA) Team to develop Test plans.
• CreatedTechnical, Functional &Businessrequirementsdocumentation Developed User Stories and Use Case documentation Organized all teams to coordinate on projectrequirements
• Responsible for the full data life cycle from gathering business requirements, upstream data feed analysis, data mapping and resolving data quality issues
• Used Visio to create business processes, business flow diagrams and work flow diagrams for Commercial Lending & Securities Lending process
• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Extensive experience in facilitatingAgile-Scrum Ceremonies like Daily Scrum/Stand Up meeting, Sprint Planning, Review, Retrospective and Backlog Grooming meeting.
• Designed Informatica Mappings and Sessions, Workflows based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Prepared the SDD (Story Definition Document) for the Loan Origination System. Analyzed business requirements for testing phase during execution of loan origination system (LOS).
• Extensively used SQL queries to retrieve data from Oracle database using PL/SQL developer and Sybase. Tested and modified PL/SQL Packages, Stored procedures and functions.
• Conducted requirement sessions withcapitalmarketgroups like(Equity, Fixed income and derivatives), portfolio managers, compliance and operational risk teams to gather requirements and articulated the same knowledge to IT team
• Utilized the knowledge of SDLC (Software Development Life Cycle) and development practices (ranging from traditional to Agile) while deploying projects.
• Involved in automate tasking, rules creations, report creation, product and pricing maintenance, dashboard collaboration, pipeline setup, maintain customer facing content, security settings, workflow updates, utility maintenance, creation of forms, document center updates, manage system updates, etc.
• Maintained LOS (Loan Origination system) and LSS (Loan Servicing Systems) systems.
• Created the XML control files to upload the data into Data warehousing system.
• Ensured requirements from all stakeholders, including Operations and IT Support, are defined.
• Translated business requirements into user stories and detailed functional requirement specifications and ensured proper coverage of the business requirements.
• Created test cases and performed Integrated and system Testing usingALM
• ConductedEnd-to-End testingfor the application using Manual Testing
• Executed test cases forsupport functionsand interfaces in order to run the reports.
• Proficient in using databases and analytics, developing macros in MS excel and VBA for data mining and visualization.
• Interacted with clients to discuss better UI features that can be provided through the application to the clients.
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
• Translated requirements documentation into UAT test plans, designed "production-like" test case coverage and test data, and performed manual system testing to validate all requirements are met.
• Conducted Integration Testing, Upgrade Testing, and Certification testing and supported the Production Releases.
• Assisted with risk assessment, mitigation and re-planning efforts when necessary.

Environment: Windows, PL/SQL,JSON, SDLC, Flat Files, XML,Agile,Linux, Ubuntu, SQL Server, NET, ASP.NET, UNIX, Avaya, SQL Scripts, Visual Studio 2008 and 2012, MSSQL 2005 and 2008, MS Office Suite, MS Visio, Excel, Scrum.

Confidential, New York City, NY

Business Analyst

Responsibilities:

• Involved in all phases of software development life cycle (SDLC) in RUP framework.
• Performed and documented GAP analysis, ROI analysis and Cost benefit analysis
• Analyzed and collected business requirements, identified system interfaces and created the requirements specification document.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Analyzed business processes and related systems forAMLwhile collaborating with Risk and Legal groups to ensure product design and configuration was consistent with compliance program goals.
• Documented functional specifications to automate theloan approval process for home Mortgageonline application, workflow - for the credit department, upon approval the system routes the application to the underwriters for review
• Involved in Iteration or Sprint Planning meeting (SAFE Agile) with the team members to plan and agree on the stories and backlog items.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Interviewed Subject Matter Experts, communicated business requirements and addressed development issues to meet project deadlines.
• UsedTest Directorto store all testing results, metrics, implemented test plan document, created test cases, defect tracking and reporting.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle.
• Create input data files in XML to validate various scenarios.
• Prepared use cases to identify the key functionality and exceptions to be deployed within the contact center technology solutions.
• Created automated test scripts used for manual testing in HP Quality Center and launched those scripts in QTP.
• Created workflows using formalnotationsuch as theBusinessProcessModelingNotation(BPMN).
• Exported test cases from excel to Mercury Quality Center using the MS Excel Add in.
• Creating customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle, and performing data blending in reports.
• Analyzed Business, Technical, and Functional requirements for execution of loan origination system LOS for the Mortgage Department.
• Involved in all phases of Software development life cycle (SDLC) usingAgileScrum methodology.
• Followed Agile, methodology for project execution, and used Storyboards as one of the requirements elicitation technique.
• Assisted in batch execution using Unix Shell script and execution of SQL procedures.
• Analyzed data quality and procedures, and production support for a small ad agency. Data mapping.
• Business Requirements Document (BRD), Functional Requirements document (FRD) and System Requirements Specification (SRS)
• Construct complex pricing models and competitive pricing analysis in MS Excel and other pricing tools
• Applied Unified Modeling Language (UML) methodologies to design Communication Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
• Extensively interacted with both user group and development team.
• Completed requirements analysis for Loan Origination System (LOS) project and Compliance Engine project. Documented the same in the form of Requirements documents and Use Cases.
• Created the test plan on word document, and created the test cases in Quality Center and execute in the simulator, logging the defects in the Jira.
• Coordinated with UAT team by providing them with test cases and test data.
• Gathered technical requirements, working withbusinesscontinuity testing, assisting with technicaltesting and troubleshooting in relation software/personal computer interfacing.
• Created Business process flows and dataflows to supplement Business requirements.
• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• Incorporated the best practice methodologies as advocated by the Rational Unified Process.
• Designed and analyzed Business Process Model, Use Case model and test procedures based on RUP methodology.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stake holders and document analysis. Performed user interviews.
• Tested Complex ETL Mappings and transformations from source flat files to target tables.
• Maintained all data in Jira tool related to test cases and bug tracking.
• Designed and executed manual and automatedtest cases throughQCby integratingQTP using data-driven testing.
• Involved in writing SQL query to create Views, Triggers, in PL/SQL as per functionality.
• Wrote user requirements specification (URS) and Functional requirements specification (FRS) Documents as per the Business requirements and process flow.
• Designed project templates based on SDLC Methodology
• Developed UML Use Cases for the application and prepared the detailed Work flow diagram based on the proposed enhancement for the system.

Environment: MS Project, MS Office Suite, Agile, Excel, RUP, UML, Clear Case 2002, HP Quality Center,XML,Rational Clear Quest 2002, MS office suite 2003, MS Visio 2003, Oracle 8x/9i, SQL,Agile, Avaya, Jira, TFS, Rally, Scrum,DOORS, PL/SQL, UNIX, Flat Files

Confidential, Tampa, FL

Business Analyst

Responsibilities:

• Facilitated various JAD sessions with development architects and business leads to develop both high-level and detailed application architecture to meet business needs
• Prepared payments and financial transactions by verifying and auditing documentation, entering account information into journal entries and requesting disbursements
• Created Vision & Scope document,BusinessRequirements Document (BRD), Functional Requirements Document (FRD), and Software Requirements Specification (SRS)by using various modeling standards/techniques including UML,BusinessProcessModelandNotation(BPMN)
• Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and store users for Requirement gathering in Definition Stage.
• PreparedBusinessRequirement document (BRD), Requirement traceability matrix (RTM).
• Facilitated Joint Requirement Planning (JRP) sessions with SME's in understanding the Requirements pertaining to Loan origination documents and calculations.
• Gathered requirements, organized team meetings requirements from business users such as insurance policy managers, generated business process models, & use-case models, and created business requirements document (BRD) & functional requirements document (FRD).
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance. Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market.
• TestedLoan IQoperationsrelated to thecommercial loan trading system
• Testing and delivery of enhancements to Loan IQ to meet business requirements
• Responsible for complete Loan IQ Business Support, including troubleshooting all issues
• Coordinated with the product owners and SMEs to create the Product Backlog for the Agile-SCRUM based application development.
• Documented and refined the product backlog using VersionOne agile tool based on the product owner's priority.
• Utilized Commercial Lending banking application and was responsible for the design and process flow of the system.
• Responsible for loading, extracting and transformation of client data from excel to MySQL
• Analyzed, documented and managed requirements and changes to requirements usingBluePrint.
• Wrote various SQL programs to run automation (PL/SQL) and reduce network traffic and challenge database performance
• Provided relationship and portfolio management support for portfolio of loans in theCommercial Lending Division.
• Update internal policies and procedures to ensure compliance with regulatory requirements
• Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software.
• Analyzed and optimized theContact Center processes, prepared Business Requirement Document (BRD) and Functional Specifications.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis.
• Conducted Data Analysis, for the Source & destination, Field level details,Businesslogic & financial Calculations for each field - Represented them into aTechnical RequirementDocument.
• Created and maintained Narrative Use Cases (BusinessUse Cases, System Use Cases) and modeled Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using MS Visio.
• Analyzed the existing process, workflowand dataflow analysis.
• Utilize JIRA and Confluence for Agile Project and Requirements Management, with Scrum and Kanban planning tools.
• Collaborate and provide business analysis support to the product owner business sponsors. SME's and testers during development.
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Responsible for gathering requirements from Business Users.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Identified Use Cases from the requirements. Created Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, and Sequence Diagrams, based on UML Methodology using Rational Rose and MS Visio.
• Assisted in the development of quality assurance artifacts including: Quality Assurance Plan, Test Plan and Test Case.
• Responsible for scheduling meetings with users, SMEs and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.

Environment: MS Visio, XML, Excel, SDLC,PL/SQL, Nuance, Flat Files, Avaya ASA, Windows XP/2000, Dream Weaver, Scrum, CRM, HP Quality Center,SQL, PLSQL, XML, VB, ASP, Crystal Reports, Rational Suite, SQL, Agile, MS Office Suite.

Confidential, Troy, MI

Business Analyst

Responsibilities:

• Responsible for Leading the Business Process Reengineering effort and for the SRS (Software Requirements specifications) documentation of the build out of the FWA dashboard and for client reporting.
• Designed Use Case Diagrams,ActivityDiagrams, SequenceDiagrams, Class Diagramsand web page mock-ups using MS Visio.
• Reviewed and interpreted Legal Loan Documentation for terms essential to the deal booking in the Loan IQ system.
• Collaborate with various partners including economic, finance, risk, loan servicing, and business strategy team members to gain understanding of business processes, build trust, and attain insight into in the impact to home mortgage default servicing forecast.
• Key Business Analyst and Subject Matter Expert (SME) for the Portal and Regulatory Reporting projects.
• Conducted weekly meetings to decide the Policies and Procedures to be followed while constructing new sites. Tested Loan IQ operations related to the commercial loan trading system.
• Involved in planning, identification, creation and execution of detailed Test Plans, Test cases and Test Suites for Functional Testing using MS-Word and MS Excel.
• Communicated with Project Managers, Technical Lead, Business Team, Product Owner and SMEs for requirements gathering and maintained strong communication between teams.
• Analyzed business needs, created new centralized back office system for specific area including mortgage and commercial lending system.
• Analyzed data from the retail mortgage lending channel, structure and presented change proposals to management.
• Involved in categorizing Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Origination, Loan Servicing, MBS, CMBS, Secondary Mortgage Market, Non-Escrow Loans Collateral Inspection and Monitoring, Property Inspection, Income and Expense Statement Review, and Inspection Report
• Gathered primary input/output requirements and modeled the processes in wire frame using MS Visio in web redesign process incapitalmarketfor international payment in security and user access control.
• Improved consistency and accuracy of financial reporting by analyzing variances in the P&L statements and cash flow statements for the company
• Gathered and analyzed data and came up with business use cases, proposed projects, and systems requirements for mortgage loan origination system using RUP standards.
• Gathered Business Requirements, through constant interaction with the Users, Developers, Project Manager and SMEs to get a better understanding of theContact Center Business Processes.
• Designed Use Case diagrams,Blueprints, Activity diagrams, and Process flows
• Extensively involved in System testing, User Acceptance Testing
• Kept all testing requirements, test cases in Test Director and executed all test cases from Test Director.
• Documented the entire testing process, test cases and test results.
• UsedJIRAfor documenting the Features, User stories, Tasks; Monitoring tasks usingKanban boards; and Reporting. IntegratedConfluenceto create acollaborative workspacefor the scrum development team.
• Retested Defects usingManual Testing, and update the defects usingJIRA.
• Collaborated with theCapitalMarketbusinessclients to clarify and prioritize their current and future needs.
• Executed requirements, use cases and iterative/incremental project and requirements management to their projects in the context of the SDLC.
• Worked extensively on tools like Ms Excel, QC and JIRA to track issues in projects and circulate reports.
• Conducted JAD sessions, workshops and brainstorming with SMEs andagileteam for project updates & involved in the weekly meetings to discuss the status of the current project.
• Involved inContact Center incident and problem ticketsreported by end user.
• Created/maintained project schedule using MS Project showing all of the deliverables' target dates.
• Wrote Automation Scripts in Java for functional and Regression testing.
• This included process analysis and data analysis using SQL and Excel involving the product attributes of Broker Dealer products like Delayed Delivery,
• Defined data requirements and elements used in XML transactions.
• Used SSIS to automate ETL processes for manipulation of large volumes of data between SQL and Sybase
• Created Business Requirement documents (BRD's), such as SRS & FRS and integrated the requirements and underlying platform functionality.
• Led requirements gathering and functional designFacilitated major requirement gathering sessions using JAD/JAR and Use Cases,
• Responsible for requirements elicitation, analysis, detailed process flow design, user acceptance testing and rollout of new & modified feature functionality deployed for contact center solutions.
• Designed and modified SQL Queries, Stored Procedures, Triggers, etc., to extract data from SQL/Sybase database directly into Excel reports
• Created different types of diagrams (using MS-Visio) & project artifacts such as Scope Document, Gap Analysis Documents, Functional Requirements Documents (FRD) and Technical Requirements Documents.
• Performed troubleshooting the technical aspects of issues by analyzing SQL stored procedures.
• Interacted extensively with SME's including heads in areas of equities, fixed income, derivatives, options, futures and risk managers, asset managers to understand corporate actions, extracting requirements from discussions, and refining and documenting them into Business requirements.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Evaluate existing processes to understand problems and collect data to perform root cause analysis create processflow-charts and diagrams using Microsoft Visio software.
• Used Agile Method for daily scrum to discuss the project related information.
• Data mapping, logical Real time data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Responsible for creating Use Cases, Business Process Modeling and Work Flow Diagrams using MS Visio and MS Excel Performed the requirement analysis and documented the requirements.
• Configured the Data mapping between Oracle and SQL Server 2005.
• Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• Created use case scenarios and documented work flow and business process using Rational Rose

Environment: Documentum, Windows NT/XP, PL/SQL, Flat Files, XML,Oracle, SQL, SQL Server, RUP,VBScript, CRM, SharePoint, SDLC, Black Knight Financial Services, Loan Sphere Invoicing,JIRA Scrum,Unix, Excel, DB2, Avaya, Adobe Photoshop, UNIX, JSON, Agile, HP Quality Center, agile, Business Objects, TestDirector, LoadRunner.