SUMMARY

• Results - driven, passionate, detail-oriented and well qualified Business Analyst with 9+ years of industry experience in Business Development Process with solid understanding of Business Requirement gathering, Business Process Flows, Business Process Modeling, Case Tools, and Business Analysis.
• Created Business Requirements documents (BRD), Use-Case Specifications and System Requirements Specifications (SRS) accompanied by active participation in discovery sessions, interviews, document-reviews with customers.
• Identify and assess new and existing risk and elevate any concerns to Capital Markets Senior Management to mitigate bank exposure or potential loss.
• Expertise in Software Development Life Cycle (SDLC) methodologies like Agile (Scrum, Test Driven Development, Kanban), Waterfall, Scrum-Waterfall Hybrid in domains like Banking & Finance.
• Conducted GAP, Impact, SWOT, Cost benefit analysis, Root cause, Interface Analysis, Feasibility study, ROI Analysis, Impact analysis, Risk Analysis, and As-Is and To-Be business analysis.
• Support the facilitation and completion of structured transactions and securitizations for Multifamily Capital Markets.
• Extensively used reporting tools like Tableau to create visual representation of Data Analytics using Dimensions and Measures. Used MS Excel and IBM Cognos for BI analytics and reporting.
• Collaborate with IT and the business to design and implement services on Service Now platform
• Designed the Test Cases in SOAPUI for API testing, Test Plans for documentation of all processes using Confluence.
• Lead various process improvement projects within Capital Markets and ensure timely and accurate results of all project deliverables.
• Knowledge of Financial and Management Reporting, Business Process Reengineering, Forecasting and Capital Budgeting reporting, Ad Hoc reports, Dashboards creation and maintenance using Tableau, Micro Strategy and Power BI for the business.
• Good Understanding of Project Management activities, proficient with Project Management Tools, testing tools and defect reporting tools.
• Document user stories during and after the workshop on various ITSM processes in ServiceNow
• Elicited requirements using techniques likeInterviews, Brainstorming, Focus Group, Document Analysis, JAD sessions, Survey/Questionnaires and documented Business Requirements Documents (BRD), System Requirements Specifications (SRS), and Functional Specification Document (FSD).
• Strong experience in tracing requirements throughout development life cycle by creating Requirement Traceability Matrix (RTM) using MS Excel & tools like JIRA and HPALM. Handled Change Requests by taking upon the role of Change Owner, Interacted with Change representatives to review Impact Analysis and documented Change Request Form.
• Excelled in working with various salesforce.com standard objects like Accounts, Contacts, Opportunities, Products, Cases, Leads, Campaigns, Forecasts, Reports and Dashboards.
• Continuously improve the customer experience by connecting the value and benefit of the ServiceNow platform to client needs and objectives through building requirements with stakeholders
• Excellent Analytical, Problem solving, Communication and Documentation skills. Dedicated & Self- motivated, Proven leadership capabilities and Time management skills. Communicated effectively across company contacts and clients, internal team about the project requirements, schedules and launches.
• Acquainted with workflows and Unified Modeling Language (UML) diagrams including Use Cases, Activity Charts, Sequence Diagrams, Data Flow Diagrams, and ER Diagrams using MS Visio.
• Decomposed Functional requirements to User Stories to meet INVEST criteria and then helped in prioritizing user stories using various prioritization techniques like MoSCoW and Kano Model. Assisted Product Owner in creating Acceptance Criteria and Definition of done for requirements. Used Planning Poker for estimation of user stories.
• Experience leading the implementation of new functionality in ServiceNow ISTM Module, specifically with Incident, Problem, and Change Management
• Extensive implementation knowledge of Databases, Data Table structures, Schemas (Star, Snowflake, Galaxy), Data Marts and OLAP operations such as Roll-up, Drill-down, slice and dice and pivot.
• Working knowledge of Informatica MDM multi domain addition and ETL tools like Informatica Power center for Data Normalization &Data Mapping. Proficient in creating Entity Relationship (ER) models and dimensional models. Assisted in data profiling, data cleansing and data validation in Data Warehouse projects.
• Experienced in Black-box Testing, System Testing, Regression Testing, Load/Stress Testing, and Performance Testing.
• Worked with QA team to design Test plans, Test strategies, Test scenarios, Test Cases, Test scripts for User Acceptance Testing (UAT) using HP Quality center/ HP ALM. Also created Requirement Traceability Matrix (RTM).
• Experience in developing Test Plans based on the user Requirement Documents, design requirement document and System Requirement documents for the Functional, Regression, Load, Performance, User Acceptance Testing.
• Decent exposure with Administration, configuration, Implementation, and Data Loading process, Application Integration in Salesforce CRM, SOQL and SOSL querying and Application development with Apex and visual force.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile-Scrum, Waterfall-Scrum Hybrid, Extreme Programming (XP), SAFe, Kanban, Scrum-ban, Rational Unified Process (RUP).

Requirement Management Tools: JIRA, Confluence, Rally, TFS, Version ONE, MS Project, Rational Requisite Pro, HP QC, HP ALM

Reporting Tools: IBM Cognos BI, Micro Strategy, Business Objects, Tableau, SQL Server Reporting Service.

Graphical & Modeling Tools: MS Visio, Balsamic, Rational Rose, UML, Mockup Screens.

Databases: MS Access, MYSQL, Microsoft SQL (T-SQL), Oracle 9i & 10g (PL/SQL).

ETL/ CRM Tools: SQL Server Integration Services, Oracle Warehouse Builder, IBM Cognos Data Manager, Informatica Power Center, Oracle Data Integrator and Salesforce

Testing Tools: HP QTP, LoadRunner, Bugzilla, SOAP UI, Oracle Application Testing Suite (OATS)

Microsoft Tools: MS Office Tools (Word, PowerPoint, Excel) MS Access, MS SharePoint, Outlook 365

Languages: SQL, PL/SQL, T-SQL, HTML, XML

Operating Systems: Windows XP, 7, 8, 10, Linux, Mac OS

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Senior Business Analyst

Responsibilities:

• Working with the team responsible for developing global technology solutions and serving as a Sr. Business Analyst within an Agile software development life-cycle, utilizing an on-shore / off-shore model and multiple world-class vendors.
• Led cross-functional teams to analyze and understand the operational impacts and opportunities of technology changes.
• Draft daily hedge strategy reports detailing market analysis, adjusted portfolio coverage and executed trades during the day to brief the Director of Capital Markets and COO/CAO of the organization.
• Deep understanding and experience of Investment Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments.
• Provided Capital Markets subject matter expertise to the IT team throughout the project. Reviewed development and test deliverables as needed
• Capital Markets trading OTC derivatives and listed markets, options trading strategies, order management systems OMS, exchange systems, electronic trading platforms, trade life cycle.
• Reviewed existing IT processes in ServiceNow to identify areas of improvements & enhancements.
• Created and maintained the Requirements Traceability Matrix (RTM).
• Developed Integration Test Plans, and Test Schedules to assist in the execution of functional, System Testing, Regression Testing, Integration Testing and User Acceptance testing.
• Conducted JAD sessions with clients, 3rd party vendors, end users, developers and other team members to distinguish presented user requests from the underlying true needs, and distinguished solution ideas from requirements.
• Developed metrics to detect levels of teams' capacity and velocity, accurately estimate projects and to continuously help improve the team's performance from iteration to iteration.
• Practiced and promoted Agile/Scrum delivery methodology including managing budget and schedules for assigned programs/projects.
• Established project plan and timelines and did resource allocation in JIRA and Confluence.
• Experience in performing UAT Testing, managing and coordinating with the Test Team and UAT team
• Experience in documentation of the testing strategy for Test Scenarios, Test Cases, Test Steps and Logging Bugs.
• Critically evaluated the information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a more general understanding.
• Utilized TFS tool and followed agile methodology for Backlog Grooming - gathering and analyzing user requirements for the Client External Application.
• Perform requirements gathering, write and manage highly complex requirements for large application development projects on ServiceNow.
• Interact with project stakeholders to elicit and document Functional Requirement Document, Business Requirement Document.
• Experience in analyzing organization processes, converting business workflows into Salesforce.com workflows and configuring Salesforce.com to meet business requirements.
• Design, Integrate and implement controls to prevent operating exposures and increase business improvements in Capital Markets area.
• Experience in migrating the changes across various environments inServiceNowusing Update Sets.
• Hands on experience ServiceNowto End-to-End Development and Customization - Incident/Problem, Knowledge, Change management, CMDB, Asset Management, Product/Software Catalog- per ITIL processes and policies.
• Involved in conducting backlog grooming, stakeholders’ interviews, facilitating team’s weekly meeting, story acceptance and daily Scrum meeting.
• Documented process flows and developed requirements for functional improvements and enhancements using the UML (Unified Modeling Language) methodologies.
• Interviewing skills, work with customers about their needs and ask the right questions to surface essential requirement information and document project functional specification.
• Partner with project stakeholders to manage requirement change requests throughout the project and update the Change Requirement Document.
• Coached team members on agile processes and facilitated planning meetings and retrospectives. Maintained task board and produced daily burn down charts.
• Involved in business modeling using swim lane diagrams in MS Visio, drawing layouts to explain process flows to the developers.
• Tested the application for specific End User testing on its compatibility on various web browsers like Google Chrome and Internet Explorer.
• Used Microsoft SharePoint to share data files, organize data files, and search files.

Environment: Agile, MS project, Salesforce.com, Servicenow, MS office Tools (Word, Excel, PowerPoint and Visio), Salesforce, MS SQL 2008, Informatica power center, JIRA, Postman, Sharepoint, Informatica, Tableau, HPQC, MS Azure.

Confidential, Jersey City, NJ

Senior Business Analyst

Responsibilities:

• Wrote and reviewed business and non-functional requirement specification in the form of user stories, use cases and UML in Agile methodology.
• Performed GAP analysis between existing and the new application. Conducted Kick off meetings for multiple projects with the stakeholders.
• Worked extensively with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS
• Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Servicing, Loan Origination, MBS, CMBS, and Secondary Mortgage Market
• Documented and shared the requirements with other Salesforce.com consultants for further implementation.
• Ensuring the Data quality by checking the completeness, consistency and accuracy of risk data for regulations of BASEL III and Comprehensive capital analysis and review (CCAR).
• Developed and maintained Credit and analyzed data to give insights and optimize credit decision like accept, decline, Pricing and Credit line and build optimize existing customer management.
• Document client needs into actionable requirements and translate them into user stories within ServiceNow agile development module
• Involved in Salesforce.com Application Setup activities and customized the apps to match the functional needs of the organization.
• Customized existing Visual force to align with Salesforce new Lightning UI experience.
• Provided alternatives and recommendations for business customer and IT leadership. Used SharePoint effectively for collaboration and to create discussion lists, wiki pages, custom lists for requirements, change requests and defects, and document libraries for documents
• Performs accurate internal operational tasks such as time tracking, expense reporting and knowledge sharing around ServiceNow Platform
• Develop use cases, process diagrams and requirements documentation using stories and scrum tasks in ServiceNow
• Built the foundation for the development effort by capturing the business context - problem, current state, desired future state, objectives, business needs and impacted user groups
• Assisted the Manager with implementing Scrum, played the role of a Scrum Master and hosted the daily Scrum meetings.
• Directed teams performing market entry research covering wealth and asset management, custody, alternative investments, and capital markets. Work included market research, business case development, strategy analysis, resource planning, partnering discussions, and go to market plans.
• Extensive knowledge of financial statements, accounting principles, derivatives, capital market, portfolio analysis, amortization, cash, deposits, risk management, credit risk, market risk.
• Provided credit fixed income support to corporate clients and to the Global Syndicated Finance, Loan Trading, and Debt Capital Markets desks.
• Utilized knowledge of Equity Capital Markets and developed an understanding of clients' needs to identify business opportunities.
• Provided customer with data dump for analysis from running SQL queries in Oracle Managed the requirements through the project lifecycle by establishing and maintaining agreements between the customer and the project team.
• Attended requirements review meeting with the internal project team, incorporated feedback and obtained customer sign off on requirements.
• Ensured that quality business analysis standards are met as prescribed by IT Services through the effective implementation or use of approved processes, methodologies and deliverables and within the project deadline.
• Used SQL*Loaders to load bulk data from various FlatFiles used SQL for DDL commands utilized SQL to createRiskssignals and Extract large subsets of data.
• Established process for Business Analyst peer reviews and internal team reviews. Helped to prepare Change Control documentation for the Project Manager for changes in Project's scope, schedule or cost.
• Extensively created wire frames using Mockingbird for page, layout, data entry forms and page widgets. Created Requirements Traceability Matrix to make sure all requirements were met and application was thoroughly tested.
• Attended defect review meetings, clarified requirements to the testing team if there was any ambiguity. Created mock ups using Microsoft Paint, Visio and Snipping Tool like Snag It.
• Used Visio to create workflow diagrams and process flow diagram. Performed user acceptance testing and helped with triage and clarification of issues uncovered in user acceptance testing for the application development teams.
• Supported the project manager role in identifying, documenting and tracking of issues and risks on projects. Ensure issues and risks are reported on and resolved/mitigated in a timely manner.
• Validated that all functions perform according to the relevant specifications. Plan and coordinate User Acceptance Testing (UAT). Helped testing team (QA) with the creation of test plans and test cases. Received recognitions for teamwork and overall project success.

Environment: Agile, Informatica, Salesforce, AWS, HTML5, CSS3, JavaScript, Jira, React and NodeJS, JQuery, XML/Json, SQL, Cumber, Gherkin, MS Visio, Mockup, MS office suite 2013 (Excel, word, PowerCenter, Draw.io) Waterfall methodology.

Confidential, New York, NY

Senior Business Analyst

Responsibilities:

• Participated in project management, design, requirements definition, specification, budgeting, control, and restructuring of organizations
• Prepared Use Case Models based on Business Requirement documentation (BRD) gathered through interaction with users. Studied existing business application and processes, collected end user requirements and suggested the improvised Business Process Model.
• Design and create ad hoc mutual fund performance reporting for both fund administration and fund accounting.
• Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
• Gap Analysis of client requirements generated Workflow Process, flow charts and relevant artifacts.
• Defined and documented the Vision and Scope of the project. Conducted one on one interviews with high level management team and participated in the JAD session with the SME’s.
• Designed Use Cases using UML and managed the entire Functional requirements life cycle using RUP. Utilized corporation developed Agile SDLC methodology.
• Consistently tracked the project status and reported it to all the stake holders involved.
• Negotiate with functional managers and/or organizational management to obtain adequate resources with appropriate skills to staff the project team.
• Conducted Joint Requirements Planning (JRP) and JAD (Joint Application development) Sessions as a Facilitator to gather requirements from the group.
• Involved in Business Process Management (BPM) activities like Process Design, Process Monitoring and Process Execution. Worked as a liaison between the business and technical side to convey the business needs to the system architects.
• Created and maintained the product backlog in Rally and TFS (Team foundation server).
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Provided Informatica Information Data Quality (IDQ) technical support to business unit liaisons
• Managed transition of physical Data Center to Salesforce Cloud, drastically lowering infrastructure costs while greatly increasing flexibility.
• Designed Data Stage ETLjobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Managed the development of a Business Intelligence (BI) data mart and reporting system within the corporate Oracle data warehouse.
• Worked with SQL queries using MS Access for data manipulations and also worked on exporting data using Teradata.

Environment: Microsoft Office Suite, Crystal Reports, Microsoft Visio, OBIEE, Documented, Windows, Oracle, SQL, SQL Server, Sybase, EVPN, RUP, JIRA, VBScript, Dreamweaver, SharePoint, EURC, Unix, Adobe Photoshop, Caliber RM MIS-IP, C#. NET, ASP.NET, Business Objects, Test Director, Load Runner.

Confidential, Charlotte, NC.

Senior Business Analyst

Responsibilities:

• Played key role in System Development Life Cycle (SDLC) Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
• Enhancing supporting documentation (policies, frameworks, standards, methodologies, and modeling documents) to demonstrate compliance with the Basel II Accord.
• Facilitated Joint Requirement Planning (JRP) sessions with SMEs in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Helped Capture the requirements based on Basel II Internal Ratings Based approach (IRB); allowing certain extent on estimation of credit risk.
• Worked closely with the Android and iOS development teams and acted as the go to person regarding the banking compliances.
• Oversaw the development of wireframe and live simulation prototypes of iOS iPad iPhone, Android and web applications.
• Documented user flows and defined user experience business processes.
• Help guide user interface functionality for future iOS and Android applications.
• Work collaboratively with architects, developers, analysts and stakeholders.
• Helped in breaking down the BRD into user stories by conducting workshops with the team and defined the acceptance criteria for the user stories and creation of the product backlog on issue tracking tool JIRA.
• Performed Data mapping between source systems to Target systems, logical data modeling, created class diagrams and ER diagrams.
• Planned and defined Use Cases; created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Coordinated with Data Analyst, ETL and UI interface Developers.
• Knowledge of Mortgage payment risk, Risk Analytics for MBS, Loan Servicing, Foreclosure, Loan Origination, MBS, CMBS, and Secondary Mortgage Market.

Environment: Agile-Scrum, UAT, Microsoft Office 2003 Professional (Outlook, Word, Excel, Visio, Access), UNIX, SQL, PL/SQL.

Confidential, Minneapolis, MN

Business Analyst

Responsibilities:

• Conducted walkthrough with project stakeholders to verify the accuracy of the requirements basing on Anti-Money Laundering (AML).
• Conducted GAP analysis to understand the requirements
• Conducted elicitation techniques like surveys/questionnaires, brainstorming, client interviewing and document analysis, Impact analysis and conducted JAD Sessions with various stakeholders.
• Was responsible for creating and reviewing process flows, business requirements, functional requirements, project schedules, documentation and test plans
• Created Use Case Diagrams, and Activity Diagrams using UML modeling tool.
• Worked with Development teams in creating wireframes and mock up diagrams
• Created various types of reports/sub-reports and cross tab reports with bar chart, pie chart and line-chart graph representation reports using Crystal Reports. Participated actively in the interaction of UX, RESTful APIs
• Used UDDI to identify and study relevant web services and web methods required for the application
• Organized and facilitated sprint planning, user story writing sessions, reviews, retrospectives, demos
• Facilitated the process of orchestration by providing process flow diagram in order to automate the business process. Made sure that the new regulation is followed for the Traditional and Roth IRAs
• Designed the Test Plan and Test Cases for the processes. Made sure that the ERISA act was followed
• Responsible for helping write the user manuals. Also created artifacts like BRD, FRD, and SRS
• 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
• Scripted business rules for the web service, and assisted in drafting agreements for various web methods in XML
• Worked with the product owner and development team in deciding and negotiating the definition of done and acceptance criteria for Potentially Shippable Product Increment (PSPI)
• Acted as a liaison between the technical staff and the users (staff and management). Also, was responsible for communications between Project Team and other related departments
• Conducted functional walkthroughs, User Acceptance Testing (UAT) sessions, and supervised the development of User Manuals for customers

Environment: Scrum, MS Word, MS SharePoint, MS Excel, MS Visio, Tableau, OmniGraffle, XML, HTML, UML, HP-ALM, MS Power Point, SQL, CA Agile.