SUMMARY:

• Over 8+ years of industry experience working as a Business Analyst in domains like Banking and Finance (Property & Casualty).
• Strong domain knowledge in Banking and Finance. Good understanding of basic principles of financial markets and instruments (Equity Derivatives, Cash Equities (Domestic and International), Fixed Income, FX, Derivatives (FX Options, OTC Options, Swaps, Forwards, Futures, Market Link Investments, Deposits, Repos, CDS), Mutual funds, NAV, fund accounting
• Strong knowledge & understanding of industry standard methodologies including Software Development Life Cycle (SDLC) and Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP) and Agile Methodology.
• Huge experience in Financial Industry: Capital Markets, Equities, Risk, Compliance, Fixed Income, Trading Systems, Trade Surveillance and Life Cycle, Derivatives and Banking (Retail, Private, Investment)
• Have worked on testing of financial products like fixed income and money market products, and derivatives products like Equity derivative, interest rate derivative, credit derivative etc.
• Expertise in gathering, analyzing, defining and documenting end user business requirements and system requirement specifications.
• Proficient in all phases of Software Development Life Cycle (SDLC).
• Designed Use Cases, Activity Diagrams, Sequence Diagrams, Class Diagrams.
• Expertise in working with Business Processes, Business Process Models, Business Flow Diagrams and Business Requirement Documents.
• Strong domain knowledge in Banking and Finance. Good understanding of basic principles of financial markets and instruments (Equity Derivatives, Cash Equities (Domestic and International), Fixed Income, FX, Derivatives (FX Options, OTC Options, Swaps, Forwards, Futures, Market Link Investments, Deposits, Repos, CDS), Mutual funds, NAV, fund accounting
• Extensive knowledgebase of market risk and Credit Risk and reference data including client and securities/instrument data, product, and pricing
• Oversee production support of core projects, including gathering and documenting requirements, translating functional requirements to technical requirements, and identifying options.
• Strong expertise in business process mapping tools and techniques.
• Experience in working with different modules of Quality Center such as Requirements, BPT, BPR Test Plan, User stories, Test Lab and Defects.
• Good documentation and process management skills with an ability to effectively understand the business requirements to develop a quality product.
• Good understanding of different phases of the Trade Lifecycle such as Account Set - up, Trade Order Generation, and Trade Order Execution, Order Settlement etc.
• Comprehensive understanding of fixed income instruments, credit derivatives, mergers and acquisitions.
• Excellent analytical, problem solving, presentation, and interpersonal skills.
• Good team player with the ability to lead, manage and work independently in a time sensitive environment.
• Extensive experience with modeling tools and techniques like Unified Modeling Language (UML), use case diagrams, user stories, sequence diagrams, activity diagrams, class diagrams, As-Is and To-be diagrams etc.
• Strong knowledge in using Microsoft Office products such as MS Visio, iGraphx, MS Word, MS PowerPoint, MS Excel.

TECHNICAL SKILLS:

Business Modeling: Rational Suite (Rational Rose, RSM, RSA), IBM s Web sphere, MS Visio

Methodologies: Rational Unified Process (RUP), SDLC, Waterfall, Agile

Microsoft Tools: MS Word, MS Excel, MS PowerPoint, SharePoint, MS Outlook, MS Visio.

Testing Tools: Quality Center, Test Director, MTM, TFS, ETL, SASOperating Systems: Windows, UNIX, Linux, Ubuntu, MAC

Web Tools: HTML, XML, Selenium, SOA, Ranorex Studio, MS Visio, etc.

Databases: MS Access, MS SQL Server, DB2, MySQL, Sybase, SQLite, TSQL

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling & Analysis, BRD, BPM, BPR, Regression, Test Management, mapping, modeling, etc.

PROFESSIONAL EXPERIENCE:

Confidential, Boise, ID

Sr. Business Analyst

Responsibilities:

• Gathering business requirements from clients and project stakeholders
• Organized JAD Sessions to collect requirements from system users and prepared business requirement that provided appropriate scope of work for technical team to develop prototype and overall system.
• Wrote SQL Queries in TOAD and approved the information against the information distribution center
• Performed affinity analysis, data conversion and migration and remapped the feeds from the old source PNO to the redesigned new data source IDS
• Extensive Gap analysis between Integrated Data Store and Legacy systems for specific Interfaces for the Provider data.
• Helped ETL (Extract, Transform and Load) group by giving the information mapping
• Gathered data requirements for systems and overseen ETL processes using Informatica (ETL)
• Transferred data (ETL) to Data warehouse Environment
• Understood Data Models, Data Schema, Data analysis, ETL and created extensive store procedures
• Responsible for coordinating among various teams and clients to ensure accurate migration of data by creating Data Mapping Document and created roadmap for transition from current state to future state.
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers, Identified opportunities for business process improvement and initiate efforts to make improvements.
• Prepared Data Affinity analysis between the legacy system PNO and new Source systems MDM and IDS, and also ran reports to perform data comparisons and cleansing.
• Worked extensively with MDM and IDS team in the process of data cleansing, data conversion and data migration. Also merging of provider records from various resources into one golden record in MDM.
• Created a data governance program and data governance model, and written a Master data governance document (MDGD), that contained aspects about how to maintain, what it should contain Etc.
• Helped the Testing team in analyzing application under the agile, scrum development and process.
• Worked with the Member team to document their needs.
• Used MS Visio for Process modeling and Business Process and Batch Flow diagrams.
• Worked closely with stakeholders and SME’s for requirements gathering.
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams using UML
• Developed UML Use Case model for the application using MS Visio and assigned to prepare the detailed Work Flow diagram based on the proposed enhancement for the system.
• Using MS-Visio analyzed business requirements and process through Use Cases, Class, Sequence, and Activity diagrams, and adapted UML standards to define modularized Data Process Models.
• Facilitated system maintenance and enhancement through design documents, process flow diagrams, use case diagrams etc.
• Documented and reported defects within established process and tracking systems using HP AML/Quality Center
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow diagrams
• Followed the RUP methodology for the entire SDLC.
• Interacting with other teams through walkthroughs, teleconferences, meetings, etc. to resolve various issues.
• Validated the scripts to make sure they have been executed correctly and meets the scenario description.
• Performed backend testing for data validation using SQL Queries.
• Created test files and analyzed test results using MS-Excel.
• Involved in project status meetings, QA review meeting, and System Test meeting.
• Executed business process analysis “As-Is” system & “To-Be” systems & perform gap analysis.
• Coordinated and facilitated the execution of User Acceptance testing.
• Was involved in writing SOP’s for various projects/processes.

Environment: Windows, AML/Quality Center, XML, UML, HTML, Facets, HIPAA, EDI, RUP, ROOP, INFORMATICA, ETL, Teradata, Medidata, Medidata Rave, ETL/Data ware house, UML, SQL, Rational Tools, MS Visio, MS Word, Excel, PowerPoint, Access, MDM, Etc.

Confidential, Charlotte, NC

Business System Analyst

Responsibilities:

• Worked extensively with the users and with different levels of management to identify requirements, use cases and to develop functional specifications
• Contributed in project management for Risk based systems for various Equities & Fixed Income divisions across all asset classes
• Have worked on testing of financial products like fixed income and money market products, and derivatives products like Equity derivative, interest rate derivative, credit derivative etc
• Maintained and monitored project progress and status through MS Project
• Modeled the Risks in Excel Spreadsheet and performed sensitivity analysis and shared this document with the Traders and the technical team to facilitate more efficient communication
• Created Use-Cases after accessing scope of the project and understanding the business processes
• Prepared use case documents and utilized MS Visio and iGraphx to create UML diagrams including use case, user stories, activity and class diagrams to extract business process flows and workflows, thereby assisting development and quality assurance teams in understanding the trading requirements.
• Worked for Re-engineered technology allocation chargeback methodologies to Equity revenue centers, creating a more granular level approach to assist in determining business unit profitability. Review and track gross profit with senior stakeholders on a quarterly basis.
• Worked on the functionality of Credit Risk, Operational risk and regulatory exposure that were all integrate to the accounting system to provide access to total exposure by customer for decision making, while using Loan documentation packages and performed functional testing on these.
• Closely worked with FDS (Fraud detection system) Front end and back end system to identify the credit suspicious fraud activity on debit card or check card.
• Strong domain knowledge in Banking and Finance. Good understanding of basic principles of financial markets and instruments (Equity Derivatives, Cash Equities (Domestic and International), Fixed Income, FX, Derivatives (FX Options, OTC Options, Swaps, Forwards, Futures, Market Link Investments, Deposits, Repos, CDS), Mutual funds, NAV, fund accounting
• Created a system which will trigger alert for a suspicious credit fraud activity.
• Experience in performing end-to-end User Acceptance Testing (UAT).
• Developed data flow diagrams, illustrating the flow of data from the Legacy systems into the Application database Tables, along with checkpoints for testing / verification
• Produce UAT plans and stories with relevant test scenarios for the testing team
• Comprehensive understanding of fixed income instruments, credit derivatives, mergers and acquisitions.
• Actively trained Business Users involved in User Acceptance Testing (UAT) and helped them understand UAT procedure.
• Developed SQL queries using SQL Navigator to extract data from the target tables to prove the data mapping.
• Researched, compiled and analyzed market data for Equities, Fixed Income Securities, etc.
• Conducted functional reviews with stakeholders from Wealth Management Group to display current and create future state process maps; documented business requirements to improve the existing risk control measures on Cash Equities & Corporate actions across all Fixed Income products lines.
• Wrote SQL queries to retrieve data from databases after data migration.
• Involved in creating targeted questionnaires and interviews for SME's, clients and business users to gather requirements
• Created Use cases, Activity, Sequence and Collaboration diagrams
• Crystal Reports was used to generate reports from different databases of different asset classes like equities, bonds, derivatives, and commodities, for all business needs.
• Interacting with various cross-functional teams for building business use cases
• Interacting with the developers to report and correct bugs
• Prepared detailed reports of the Bugs, Pass-Fail report, and Comparison Chart Release Management documentation

Confidential, Jersey City, NJ

Business System Analyst

Responsibilities:

• Conducted interviews, document analysis, design workshops, surveys, use cases, and workflow analysis for gathering and documenting requirements.
• Involved in creating logical and physical model of the database using iGraphx and MS Visio, MS SQL Server.
• Prepared monthly and quarterly income statement, balance sheet and project financial reporting with detailed variance explanations of actuals to budget and forecast and provided Chief Technology Officers and business heads with detailed results reviews.
• Addressed all aspects of the claim processing lifecycle, starting from identifying a claim right up to closure.
• Created and maintained Business Requirements document and System Requirements document through various financial models reviewed by the CFO, including low cost resource planning strategies in India, Singapore and Toronto.
• Initiated business re-engineering process to implement long term business objectives regarding product, price and automated decision in the existing application.
• Conduct JAD sessions with cross-functional units like Policy administration, Finance, Claims, Billing, Actuarial, Reinsurance, Stat
• Made use case to generate functional requirements.
• Extensively used Rational Rose for process flow diagram (data flow), sequence diagram and collaboration diagram.
• Performed Requirements Analysis and Design using Rational Rose, analyzed and documented the System specifications, Business requirements and detail design of the business using Requisite Pro for the trading requirement tracking and analyzing.
• Gained experience in conducting requirement gathering sessions, writing business requirements, functional specs, documenting and use cases.
• Utilized and improved the existing processes for software problem identification, escalation, and resolution. Regularly reviewed and revised project processes to ensure accurate and timely results.
• Development of SQL queries as per the request from the business team in SQL server
• Created progress and completion reports for project management on a weekly basis. Worked closely with management to keep track of the status of project and draft strategies for the near future. Used MS Project to manage schedules, deadlines, resources for the project.
• Conducted and participated in walkthroughs to generate consensus, maintaining quality and resolve issues among different stakeholders in the SDLC.
• Provided inputs to the project plan so that project plan exactly reflects the status of the project.
• Wrote complex SQL queries in TOAD to perform Back-End testing.
• Performed the GAP Analysis and Impact Analysis for all business requirements having an impact on the existing application.

Confidential, Philadelphia, PA

Sr. Business Analyst

Responsibilities:

• Gathered business requirement from Credit Risk management and analytics teams through interviews and JAD sessions
• Communicated with Line of Business and created Business Requirements Document (BRD), High Level Diagram (HLD), and part of Low level Diagram (LLD).
• Worked with business users through acceptance testing of all investment product data including all Basel-related reference data, market data, as well as related market risk and Credit Risk
• Conducted walkthrough for Line of Business, Development team, and Quality Assurance team.
• Detailed working knowledge of Rates and Credit derivatives Credit Risk modeling
• Supported internal clearing of OTC derivatives across multiple currencies, clearing houses and affirmation platforms as well as the testing of electronic trading platforms, trade lifecycle changes, affirmation platform releases and graphing feature releases.
• Proficient knowledgebase and related concepts regarding Credit Risk and Market Risk across all investment products
• Developed Credit Risk score card and Credit Rating Migration Probability Matrix
• Facilitated system maintenance and enhancement through design documents, process flow diagrams, use case diagrams etc.
• Analyzed system impacts as a result of proposed changes. It entailed interaction with other systems users and Subject Matter Experts (SMEs).
• Wrote complex sequential SQL queries and to generate statistics, and developed Excel pivot tables to report the results.
• Actively involved in quality assurance and UAT of Loan operations processing.
• Designed screen layouts for proposed solutions, user interactions. Also, created screen mock-ups.
• Tracked the project flow and acquired sign-offs from Business, System Development and Quality Analysis team.
• Determination of both Credit Risk and market risk
• Generated Usage Models (i.e., prototyping storyboards, screen mockups, User Interface designs, and User stories) based on Agile and SDLC standards.
• Expert in trading requirement gathering sessions, writing business requirements, functional specs and use cases.
• Strong understanding of trading instruments including equity derivatives, interest rate derivatives FX, options, money market, fixed income, credit derivatives, and commodities trading products Documented business requirements and conducted BRD analysis. Applied UML methodology in MS Visio and iGraphx to elaborate functional requirements like, use case analysis, use case diagrams, activity diagrams, and sequence diagrams to define work flow of the project to the IT developers.
• Provided solution for database requirements by designing controls, data fields and data formats. Worked in legacy system migration from Lotus Notes to Oracle.
• Used different in house software to track data flow, system interactions, system defects, service requests and responses.
• Created master specification for web services- their functionality, interaction with other web services, processing logic, input & output schema, and process flow with Logical Data Element.

Confidential, Dover, NH

Business Analyst

Responsibilities:

• Provided accurate and timely information to all external and internal stakeholders.
• Performed gap and impact analysis between current and desired state.
• Develops and prepares computer systems requirements and develops procedures to process data
• Responsible for Requirement gathering, Business Process flow, Business Process Modeling and Business Analysis with Document and Records Management
• Created best-practice requirements deliverables, such as use cases, system process flows and context diagrams
• Compile and run the code provided by developers in People Tools to reproduce and verify the bug fixes.
• Extensively used People Soft tools and Integration Broker for the application.
• Deliver requirements under the Agile Scrum SDLC methodology to meet a very fast release schedule.
• Analyzes functional problems and determines techniques and requirements
• Able to lead and facilitate business process mapping and use business processes as a starting point to perform GAP analysis
• Prepares definition of functional problems and makes recommendations for software to deliver solutions
• Investigating and resolving data issues across platforms and applications, including discrepancies of definition, format and function.
• Tested application under the agile, scrum and sprint development and process.
• Created wire frames, process maps, visual specification, and dataflow models to describe intended user experience.
• Ensured the requirements accurately and sufficiently describe business needs and have been translated to technically efficient and effective requirements.
• Writing Complex SQL queries and optimizing SQL Queries

Confidential, New Jersey, NJ

Financial Business Analyst

• Analyzed the existing claims process and specific business rule logic that will be applied in the model
• Assisted in ROI, ROM and GAP analysis
• Modeled AS IS and TO BE processes using MS Visio for the Mortgage origination system.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements
• Analyzed the Business and System Requirements of the application using Requisite Pro.
• Designed and developed project document templates based on SDLC methodology.
• Worked with Front-end and Back-end systems
• Liaised among client system technology teams and business unit teams in Equity, FX, Derivatives, Credit Risk, Payment Processing, Treasury, Market Risk, Regulatory Capital, Corporate View, and Fixed Income
• Performed User Acceptance Testing (UAT) for various web based and database related applications.
• Interacting with the development and testing teams to improve overall quality of the software.
• Analyzed user problems, including automated and manual business processes and identified, researched, investigated, defined and documented business processes.
• Act as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation.
• Worked under sprint Iteration model and gained expertise.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Worked extensively with Mercury quality center
• Worked extensively with the Quality Assurance team for designing Test Plan, user stories and Test Cases for the User Acceptance Testing.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.