SUMMARY

• Over 8 years of experience as a Business Analyst with the ability to understand and analyze complex business requirements.
• Have a detailed and thorough understanding of various domains like Finance, Banking, Pharmacy and Healthcare.
• Expertise in Software development methodologies like Agile, waterfall and Rational unified Process (RUP) methodologies.
• Experienced in various documents including the System Requirement Specifications (SRS), Business requirements document (BRD), Use Cases, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• Experienced Professional in creating detailed Use - Case Models, Data Flow Diagrams, Sequence Diagrams, Collaboration diagrams and Activity Diagrams.
• Expert at creating, tracking and quarrying defects / activities to create reports in Quality Center, Test Director and Rational Clear Quest.
• Facilitated project meetings, reviews, walkthroughs, and customer interviews to gather requirements and relevant information for Business analysis.
• Generated Requirement Traceability Matrices to ensure that all the requirements were met in each phase of the Software Development Life Cycle.
• Exceptional Problem Solving and Sound Decision Making capabilities, along with the ability to resolve difficult situations.
• Creative and aggressive self-starter with integrative thinking skills and capable of communicating creative ideas through Graphical Modeling.
• Knowledge of foreign exchange rates, currencies, and other trading markets.
• Expertise in Software Development Life Cycle such as Project Analysis, Requirements, Business System Design, System/Integration testing, UAT & Implementation.
• Expertise in writing Test Plans, Test Strategies, Test Data requirements, Business Assurance Strategy, Defect Management process, Test Execution and Test ID Strategies.
• Expertise in communicating with Clients/Users periodically to review the requirements, goals and their expectations and provide test results and project status.
• Excellent experience in Quality Center Management such as RTM, Execution Results Tracking, Defect Management and Reporting.
• Excellent experience in completing the projects in agile methodology with sprints and exposure on automation tools.
• Excellent problem solving skills with strong technical background and database skills and ability to meet tight deadlines.

TECHNICAL SKILLS

Methodologies: SDLC, RUP, AGILE, Waterfall.

Modeling Tools: Use Cases, UML, UAT Test plans & cases, Ignite XML

Office Tools: Microsoft Office (MS Excel, MS Word, MS Power Point, MS Project, MS Outlook), MS SharePoint

Languages: XML, MySQL

Reporting Tools: Crystal Reports

DBMS: MS Access, SQL Server 2000/2005, MySQL

Operating Systems: Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr. Business Analyst

Responsibilities:

• Research, Feasibility Studies, Data Analysis, System Analysis, Gap Analysis, Conducted UAT to confirm that all services were performing as planned during each sprint cycle.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives, resolve issues and reach agreements necessary.
• Responsible for creating documents to transfer servicing notes from HSBC application to TSYS System.
• UML Business Use Cases from requirements, including Use Cases Diagrams, Class Diagrams, State Diagrams, Entity-Relationship diagrams.
• Conducted user interviews, gathered Sequence diagrams using MS Visio
• Analysed business requirements and created WSDL and WADL files to reflect changes in the new framework.
• Develop standard operating procedures, business workflow processes, and manuals.
• Assisted in the production of Change Management deliverables (testing documentation, documents and business process flows).
• Helped in writing manuals, scheduled and trained junior BA’s using PowerPoint got it reviewed and approved by the project team and clients.
• Acted as a liaison between the technical group and business users (PM, PMA and trader) throughout the project cycle.
• Created API’s and coordinated with data modelling team over use of existing elements and presented justification in the case of creating new elements.
• Also presented changes to design review board for approval of API pages.
• Assisted offshore team in understanding requirements through daily scrum calls as per customers’ needs.
• Arranged modules for new process development and implementation.
• Built the foundation for process implementation in MS-SQL, data integrity procedures and quality control reports using SQL and UNIX Sync.
• Migrated Data from MS Excel to SQL Server Reporting Service using Sort.
• Conducted workflow, process diagram and DTDs and SQL loader utilities.
• GAP analysis by identifying existing technologies, documenting the enhancements
• Used MS Visio to develop Use Cases to meet the end state requirements
• Wrote system requirements specification (SRS), Data transformation Document (DTD) as per the Business requirements and process.
• Communicate and document system changes to business flow.
• Performed SQL Queries and PL/SQL stored procedures on the models.
• Acting as the interface and a single point of database to extract data.
• Contact with the customer for his security related, technical issues and for the entire documentations and the; written as well as the verbal correspondence
• Involved in UAT, test plans, documentation of test reports etc

Environment: Rational Unified Process (RUP), MS Office Suite, TSYS, XML, MS Visio, MS Excel, Windows XP/NT, Rational Rose, Clear quest, SQL Server

Confidential, Austin, TX

Sr.Business Analyst

Responsibilities:

• Created functional and non-functional requirement documents and technical specification documents and delivered within project timelines by conducting user interviews for requirements gathering, analysis, and design.
• Wrote SQL query to extract data from the tables to validate data flow.
• Provided business analysis for fixed-income security, risk ledger, market risk and credit risk, commodity and financial risk management including complex structured transactions. modeling and analysis for trading strategies and patterns monitoring
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.
• Facilitate meetings with front office /middle office desk supervisors, Market Risk managers and subject matter experts to breakdown source data analysis associated to the KRIs (key risk indicators).
• Worked on end-to-end ETL process including data Extraction, Transformation and Loading from source systems using Informatica.
• Perform credit risk and Market risk assessments of new customers.
• Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them.
• Used SQL queries to transfer data from the server to the web page. Conducted presentations on the progress of the project after ever phase of SDLC based on RUP methodology.
• Skilled at performing GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and ROI analysis.
• Met with client groups to determine User Requirements and Goals, thus converting User Requirements and Business Requirements into Functional Requirement Specifications.
• Assisted with Manual and User acceptance testing of the systems (UAT), developing and maintaining quality procedures and ensuring that appropriate document is in place.
• Implemented SQL standards in writing stored procedures, Triggers, Views, SQL functions and locking issues.
• Worked on ETL processes using Informatica tool to load data from Oracle 9i, DB2 into the target Oracle 9i Datawarehouse.
• Created test data for validation of code using XML.
• Identifying and measuring risk ledger faced and calculating credit risk, making decision on the applications and preventing loss by evaluating credit risk.
• Facilitated UAT and test strategies with developers and testers and performed manual front-end testing to check all the functionalities incorporated with the different modules. Involved in UAT session to test the system with stakeholders.

Environment: RUP, Rational Rose, Rational Clear Case, XML, ETL, Oracle, Windows 2000, SQL server, MS Office Suite, UAT,UML

Confidential, NY

Sr.Business Analyst

Responsibilities:

• Gathered requirements, defined specifications by interviewing the business user group. Agile software methodology was implemented on this assignment.
• Created business use case, functional (FRS) and technical specifications for trading system.
• Analyzed the Capital Market businesses to understand the architecture of the various processes and participated in a strategic decision making process about what applications needs to be decommissioned to reduce the cost.
• Performed in software testing which involved development of test cases and test scripts and User Acceptance Testing (UAT).
• Created XML block additions and modifications based on business rules and workflow modifications to capture and manage client policy and underwriting data required to issue policy for a prospective insured.
• Collaborated with the offshore Equity swaps team to refine the future sate vision for equity swap processing and translate business objectives in to building the system
• Experience working on Liquidity Deposit, Analysis and/or Loan Systems required.
• Manage daily cash books, bank account transfers, Liquidity deposits, reimbursements, reconciliations and fraud controls.
• Worked on mainly market risk, risk ledger and some credit Bank- wide credit risk done in a separate database aggregating various systems output.
• Wrote test scripts for unit and integration testing and coordinated internal and external user acceptance testing (UAT)
• Interacted with the fixed income investment broker officers and understood their need in fixed income trading on behalf of the clients.
• Performed on ETL processes using Informatica tool to load data from Oracle DB2 into the DataWarehouse requirements.
• Responsible for Gathering Requirements from the Compliance Consultants, Quantitative Risk Analysts and Portfolio Managers to produce Business and Functional Requirements for Finance Risk Management Application.
• Worked with various Liquidity providers to calculate the round trip latency by analyzing FIX tags and Trace route /Ping test.
• Wrote test scripts for unit and integration testing and coordinated internal and external user acceptance testing (UAT)
• Worked with Treasury Division for reporting and monitoring Liquidity risks on a daily basis to Stakeholders according to prescribed Market Risk Policies.
• Analyze credit data and financial statements to determine the degree of risk involved in extending credit risk or lending money..
• Worked with Treasury Division for reporting and monitoring Liquidity risks on a daily basis to Stakeholders according to prescribed Market Risk Policies.
• Besides routine responsibilities of credit analysis, measuring risk factors, validating customer’s financials. I also worked on various projects relating to red flag reports.
• Collaborated with analysts to decide the ETL methods and overall data flow architecture.
• Wrote test cases and test scripts for the User Acceptance Testing. Also, performed some parts of testing.

Environment: UML, Use Case Analysis, MS Office - MS Word, MS Excel, MS Power Point, MS Visio, XML, Rational Rose, ETL, Rational Clear Quest, SQL, UAT.

Confidential, Saint Petersburg, FL

Business Analyst

Responsibilities:

• Implemented an integrated RUP solution with complete line of traceability for all the artifacts of web development projects.
• Involved in the development of test cases for the Informatica mappings and update processes.
• Involved in the creation and maintenance of the Workflow plans and artifacts
• Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level.
• Followed top down, leveled technique for building Business Process Models.
• Prepare test plans and test cases for User acceptance testing(UAT)
• Conducted SWOT Analysis for better market understanding and fool proof project implementation
• Familiar with Data extraction, Data Migration and Data conversion using ETL tools from application front-end with SQL databases as Source.
• Documented Requirement Traceability Matrix (RTM) for requirement elicitation and linkup to deliverables
• Worked with the individual sub-project managers to translate these into PRDs (Product Requirement Documents) for the development teams
• Examined, analyzed and model Test plans, Use Case Model cases & Test procedures based on RUP methodology
• Designed and developed Quality Assurance standard and processes to all levels of project team
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.
• Performed Gap analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements
• Performed UAT and logged test results according to the test plans using Test Director

Environment: Microsoft Office, UAT, Rational Requisite, Informatica, RUP, RUP, UML, SQL, Test Director.

Confidential, Plainsboro, NJ

Business Analyst

Responsibilities:

• Worked with internal product management teams to include this functionality in the product release cycle
• Interacted with the SMEs to prepare BPR documents for the ongoing projects and business process flows
• Developed requirements documents for Cyber lab Filter packs and requirements to in corporate certain modules of Bio analytical data from Thermo sampler LIMS and Electronic Lab Notebook to the Cyber lab in a GLP regulated environment
• Incorporated appropriate metrics at gates, and formalized roles and responsibility charting. (RACI- Responsibility, Accountable, Consulted, Informed)
• Established an enterprise-wide model to bring continuous improvement in product forecasts across different product launches/regions.
• Developed use cases, use case specs and models, work flow diagrams, process flows, Activity and sequence diagrams.
• Assisted project managers to manage scope, schedule, and cost benefit analysis for the project between various stakeholder groups and within the project team, in order to resolve conflicts.
• Coordinated project communications including status, risks, issues, escalation, etc.

Environment: SDLC, Agile, Scrum, UML, Rational Requisite Pro, Clear Case, UAT, MS Visio, XML, HTML, Microsoft Office.

Confidential

Business Analyst

Responsibilities:

• Worked with Business Analyst in translating business requirements into Functional Requirements and to Detailed Design and review all deliverables,
• Coordinated and communicate tasks with developers and ensure that development is performed as per requirements.
• Prepared Technical specification document and provided technical guidance to the team
• Performed data analysis and data mapping from source system to target systems
• Wrote complex SQL scripts to load data extract into Analytical Data Warehouse using PL/SQL packages, procedures, functions, triggers, views, dynamic SQL, and cursors.
• Preparing Requirement for Unit Testing, Functional Testing, E2E testing and Performance
• Manage Test Executions and Defect Management
• Preparing Traceability Matrix and manage throughout the project
• Responsible for production support 24/7 to fix any production issue within stipulated time frame

Environment: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Access, Rational Requisite, RUP, Oracle.