SUMMARY:

• 13 years experience in Business Analysis/Systems Analysis, COTS product implementation, Quality Assurance/Testing and Project Management in Financial Services domain including Investment Banking and Capital Markets
• Extensive Techno-Functional expertise in providing solutions for areas including Trading, Clearing and Settlement, Depository operations, Custodial services and Regulatory reporting.
• Excellent understanding of Asset Classes like Equities, OTC and Exchange Trade Derivatives products including IRD, FXD, Commodities and Fixed Income securities.
• Implemented COTS product Murex for OTC derivatives with renowned Bank in Northern Virginia.
• Strong knowledge of the Software Development Life Cycle methodologies like Agile and Waterfall models
• Managed diversified team of around 15 members located in and outside USA. Team members include Business Analyst, Developers Unix, SQL and OBIEE and QA.
• Extensive experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document BRD , Functional Requirement Document FRD ,Software Requirement Specification SRS across the deliverables of a project.
• Hands on experience in writing and review of functional test cases and Technical Design Document.
• Possess Data Analysis expertise using SQL, Excel vlookup, functions , MS Access and Business Intelligence reporting tools like Hyperion and OBIEE
• Expertise of UML in visualizing and documenting the artifacts using Use Cases, Use Case Diagrams, Activity diagrams, Class diagrams, Data Flow Diagrams, Business Flow Diagrams, Sequence Diagrams using MS Visio
• Experience in facilitating Joint Application Development JAD sessions, Rapid application development RAD sessions , conducting user interviews and acting as a liaison between the customers, development team and testing team
• Effectively used tools like HP Quality Centre for requirements and test case management and Clearcase for code control.
• Excellent hands on experience in using MS Office suite, SQL Developer, Toad, Unix
• Experience with Iterative Software Development Life Cycle Process as per Rational Unified Process RUP , involved in inception, elaboration, construction transition phases using rational tools like RequisitePro, ClearCase, ClearQuest during various phases of RUP.
• Facilitated User Acceptance Testing UAT with the stakeholders and the business users as well as trained users to use the system configured.
• Analytical, methodical and resourceful approach to problem solving, identifying root causes and corrective actions to meet short and long-term business, financial and system requirements
• Excellent verbal/written communication skills and strong analytical abilities and can perform well both independently and as a team player

SOFTWARE AND TOOLS

• Software: MS Office suite including Word, Excel, Visio, Access, Powerpoint, Frontpage, Unix, Oracle, XML, Clearcase.
• Tools: Rational Clearcase remote client, HP Quality Center, Star Team, OBIEE, Hyperion, Cognos.

PROFESSIONAL EXPERIENCE:

Confidential

Role: Lead Business Analyst

• Reviewed of Business Requirement document from different countries and come up with Data demand sheet
• Analyzed country specific regulatory reports requirements, design validation rules template, perform data analysis, map requirements to data, identify gaps in data and source data whichever is missing
• Worked with datamodellers for source to target data mapping and help in creation of logical and physical data model
• Created FRD based based on BRD and data obtained through discussion with Business users, Technology team and
• other stake holders involved.

Confidential

Role: Lead Business Analyst

• Performed Requirements Elicitation, Gap Analysis, created Requirement Specification Document for implementation of COTS product 'Murex' and its upstream/downstream interfaces within Treasury department of the Bank.
• Created Proof of Concept, Use Case document for workflows and presented the same to the stakeholers. Acted as conduit between Project Management, Business users and Development team for articulating requirements and expectation effectively.
• Developed Activity Diagrams, Sequence Diagrams using MS Visio.
• Independently performed Datamart mining and analysis using SQL/Excel and OBIEE reporting tool
• Documented functional test cases, mapped it to appropriate business requirements and performed functional test execution to ensure development is done as per the requirement. Effectively used HP Quality center to create test plan and raise defects.
• Performed UAT with business users and provided support from environment availability, execution, results analysis, defect logging and tracking it to resolution
• Assisted in batch execution using Unix Shell script and execution of SQL procedures.
• Created 'Release Planning Document' and 'Code migration document' to ensure release item is linked to appropriate change request, defect, code and its appropriate approved version for the release. Provided inputs and approval during Release planning meetings
• Reported project statuses and phases including requirement documentation, development and testing
• Designed End of Day batch schedules and monitored end of day process effectively. Involved in issue tracking and resolution within stated SLA.
• Effectively used tools like SQL developer, putty for Unix, Clearcase for version management, HP Quality Center for requirements, test planning and defect tracking.
• Created Source to Target mapping for different interfaces, Requirements Traceability Matrix, assisted in Data modeling for creation of DDL statements from Erwin data modeler.
• Designed several Business processes and modeling of different for Payment processing, VaR Economic Forecast, Volatility Skew and Bloomberg Credit Ratings upload to Murex.
• Developed Datamart reports for Trade,Payments, P L, Simulation reports, etc
• Actively involved in responding to major Request for Proposal RFP with the Bank and with other clients. Provided appropriate case studies, resource staffing, pain points with the existing process and addressed several issues ensurinig cost reduction and continuity of business to the client.
• Provided training and walk through to business users, project management team on usage of different tools for their day to day business activities and documented steps for their future reference.
• Effectively managed a team of 12 resources located onsite and offshore India . Team involved Business Analyst, Developers and QA. Team members mentored, assigned activities, done review of their work, provided feedback. Maintained healthy work environment, addressed team conflicts and recognized team member for their better work.

Confidential

Role: Senior Business Analyst

Description: 'OPTIMA' is the centralized Datawarehouse for sourcing of Institutional contract and trade related data for Regualatory and Management reporting.

Responsibilities

• Gathered requirements and created Source to Target mapping document for all the interfaces dealing with Cash, Derivatives and Loan products within the Bank
• Involved in Data modeling and creation of Logical and Physical data model for sourcing of data from different upstream systems.
• Effectively gathered different business rules and transformation logic to ensure data consistency and uniform reporting is done.
• Worked with ETL developers to incorporate the extraction and transformation logic.
• Worked with Cognos reporting developers to ensure required data is reported accurately. Assisted in applying filters and conditions to generate meaningful data for reconciliation purpose.
• Validated data in the data mart using SQL/Excel, performed Gap Analysis. Accordingly worked with source system or internal developers to rectify the issues.
• Performed reconciliation of data acquired from source system with data from General Ledger. Reported reconciliation report to senior management and provided explanation for breaks in reconciliation.
• Worked with different stakeholders to get their inputs and approvals by rigorous follow-up and coordination.
• Extensively used SQL, Hyperion, Cognos and Excel for Data extraction, analysis and reporting purpose
• Developed Proof of concepts from sourced data before providing developing solution for specific reporting needs
• Used HP Quality Center, MS Visio, Unix and SQL queries for day to day activities.

Confidential

Role: Business Analyst/Functional QA

Description: Global Cash and Collateral Management GCCM is a global liquidity and cash management system that uses inhouse bank structure to centralize and automate cash flows.

Responsibilities

• Lead QA team of functional and automation testers.
• Worked with BSA and Developers for understanding the requirements and prepared functional test plans
• Participated in requirements analysis, review and sign-off. Provided valuable inputs from business, technical and testing perspective.
• Participated in Technical design document review and provided approval.
• Prepared System, regression test cases and articulated effectively to automation team for creation of automation suite.
• Prepared management report for test planning and execution and reported at regular intervals.
• Excellent understanding of swift messages for customer and financial institution transfers i.e, category MT1xx and MT2xx

Confidential

Role: Business Analyst

Description: Clearing and Settlement C S system is a back office system of renowned Commodity Exchange, Multi Commodity Exchange of India MCX and Dubai Gold and Commodity Exchange DGCX . All the clearing and settlement activities involving collateral and margin maintenance is automated in C S system

Responsibilities

• Proficient in all aspects of commodity trading, collateral management, marginig, accounting, fund management, Settlement both physical and electronic and Delivery process of underlying commodity.
• Exposure to Equity and Commodity derivatives. Excellent understanding of Future and Option derivatives instruments.
• Gathered requirements by interviewing commodity exchange users, created Business Requirements Document. Presentation done to the stakeholders on requirements and obtained approval
• Effectively created System requirements specifications translating business requirement to system specifications, created use case documents, sequence and activity diagrams using viso, created screen or User interfaces design using MS Frontpage.
• Effectively articulated requirements to development and testing team. Involved in review and approval of Unit test cases and system test cases
• Performed functional testing once development was complete
• Created Requirement traceability matrix and tracked requirements to functional test cases
• Effectively created release planning document and ensured approved requirements and functionalites are being released. Supported release along with release management team. Post implementation necessary validations were performed.
• Involved in UAT test planning and execution.
• Effectively used Star team for document management, SQL/Unix for data analysis and execution

Confidential

Role: Business Analyst

Description: Central Depository Accounting system CDAS is the system for providing dematerialization services for Exchange, Clearing houses, Custodians, Brokers and Banks.

Responsibilities

• Effectively gathered and documented requirements for all areas of depository operations including account opening, dematerialization, corporate actions, Initial Public offering, Inter-depository and Off-market transaction and Settlements
• Performed requirements and gap analysis and created business requirement document
• Effectively used sequence and activity diagrams to present the flow in holistic manner
• Performed data analysis and functional testing using SQL queries and Excel
• Presentation provided to both IT and Operations team on navigation and use of end system
• Created release planning documented and performed post validation