Professional Summary:

• 10 years of experience in Business Analysis, Requirement Gathering and documentation of Buy-Side, Sell-Side, Commodities Trading, Wealth Investment Management and Reporting applications.
• Extensive knowledge in business process reengineering of Fixed Income, Investment Banking, Foreign Exchange FX , Settlement, Accounting and Clearing of Securities.
• Performed Enterprise data management activities such as integration of multiple reference data sources for data management and defining controls and attributes for the data.
• Created requirement for various data-warehousing and Business Intelligence BI projects.
• Excellent Business knowledge of OTC settlement and accounting module with SAP FICO.
• Hands on expertise in using FIX protocol for order management, indication of interest messages IOI and advertisement of equities.
• Implemented Segregation of Duties controls and policies in RBS organization by enhancing RBAC and user entitlement review applications.
• Conducted extensive GAP analysis to reinforce FFIEC framework. Investigated interim controls which mitigate the security risk and suggested significant solutions in threat landscape.
• Extensive knowledge of Profit and Loss P L statements, Market Risk, Financial Risk management FRM , Mark to Market MTM and Market data.
• Worked on various regulatory and compliance requirements associated with accounting and investment banking such as Segregation of Duties for SOX and regulatory compliance, FFIEC AIBE for banking, FINRA for IOI advertisement and Rule 15c3-5 for Risk Management Controls for Brokers or Dealers with Market Access.
• Hands on with SQL DML knowledge to perform data analysis by defining complex SQL queries to extract data from different databases.
• Good Understanding of financial derivative like Futures, Options, Swaps, Foreign exchange.
• Knowledge of Order management system, Brokerage, Fixed income securities and FIX Protocol.
• Acted as bridge between users and developers to communicate requirements and enhancements.
• Introduced Requirement management, test management, automation tools, BA/QA processes and workflow in IT departments.
• Created reports using SQL, Perl, and UNIX on Sybase and DB2 database for Data analysis.
• Created user acceptance testing UAT scenarios and conducted user acceptance testing.
• Extensive experience of various software development life cycles SDLC and quality assurance life cycle QALC .
• Excellent analytical, communication and interpersonal skills as a team player and capability to learn new tools and technologies quickly.
• Good knowledge of Dodd Frank, Basil and CCAR regulations.

Work Experience:

Confidential

Project Manager / Business Analyst

My role as part of Risk and Controls team is to implement Segregation of duties and Role Base Access Control Globally in RBS for regulatory risk and compliance mandated projects. Facilitate the development of all the rules, functionality and processes to support preventative and detective control via RBAM, UER and CRS management tools.

Responsibilities:

• Managed and Implemented RBAC based Segregation of duties controls in M IB to manage business risk across Front Office, Operation, International Banking and Finance.
• Documented and analyzed the business requirements for preventative controls, Detective controls, Access rejection, and exception management based on predefined rules.
• Collaborated with business control heads and application development team for documentation of various rules for access control.
• Created BRD and FRD to enhance the software and processes to be used to manage access control so that role based access is implemented in the organization based on the rule engine.
• Acted as a bridge between various development groups to facilitate intra group development and project planning.
• Remediated applications by collaborating with 32 application business teams and streamlining business process to remove toxic roles and user present in various applications.
• Managed and mentored team in SoD rules and processes to effectively implement SoD Control for all the audit requirements.
• Documented and enhanced the rule set to implement Function vs. Function and Function vs. Organization toxic access controls.
• Enhanced the RBAM access control model to implement various processes to help prevent user get unwanted access in the organization.
• Participate in identification and selection of solutions for remediation of Toxic access within the application and cross application.

Environment: Excel, Power Point, MS Visio, SQL Server, T-SQL, SharePoint, Sparx Enterprise Architect, MS project.

Business Analyst

My role is to assess client facing applications in M IB for compliance with FFIEC AIBE Guidelines and to create a detailed workflow for various business applications which come under RBSM. Identify security risk if any and suggest solutions for long term security risk remediation.

Responsibilities:

• Joined backlogged FFIEC compliance project and aggressively delivered on expected cutoff.
• Created a detailed workflow for 31 business applications which deals in FX, Vanilla options, DCD and money market deposits.
• Assessment of client-facing applications to determine in-scope/out-of-scope status.
• Documented current processes for all risky transactions for in-scope applications.
• Created list of compliance gaps, risk-rated and prioritized them.
• Responsible for identifying and providing approval for both interim and long-term solutions for remediation of gaps.
• Assist the project manager in selecting appropriate artifacts for articulating the deliverables of the project.
• Collaborated with RBS fraud detection and compliance team in assessment of applications.

Environment: Excel, SQL Server, T-SQL, Business process testing, SharePoint, Agile Methodology, Sparx Enterprise Architect, MS project.

Confidential

Sr Business Analyst

I was part of Electronic merchandizing and Order management system. Focusing on providing requirements for new system and validate that they are implemented correctly.

Responsibilities:

• Gather requirement and perform gap analysis of various system under construction and their legacy counterpart to support smooth operation for various sales and trading groups.
• Analyze business and system requirements and translate it into use cases/test cases.
• Managed requirement around reference data system to effectively migrate from old star reference data system to new GSOE reference data system.
• Document requirements using Test Driven Development TDD approach.
• Gathered business knowledge in Electronic merchandizing, Advertisement, order management, Regulatory compliance scope 15c3-5 Controls and regulatory compliance rule for advertisement of shares executed.
• Good knowledge of FINRA compliance associate with sending IOI and advertisement rules for Natural principle orders.
• Good understanding of legal, threshold, syndicate and Shelf rules and regulation for IOIs and trade advertisement.
• Acquired expertise in Fix Protocol Order, Indication of interest IOI , Advertisements and trading application OMA systems for Order, IOI and Advertisements.
• Understand the functionalities of the new and existing applications by gathering knowledge from Application Development team, SME and Users.
• Perform data analysis for various flows coming into the system, creating use-case to aggregate these flow for advertisement.
• Creating use case for IOI flows for order generated on various desks on the trading floor.
• Acted as a bridge between various development groups to facilitate intra group development and project planning.
• Performed UAT and deployments of application, provided training to traders on trading floor.
• Create report specification and reports for advertised volume and revenue generated due to solicitation of IOIs.
• Performed Black-box and grey box testing covering functional, GUI, system, integration, Security and database validation on the system.
• Performed Database testing to validate physical model of the application and various business rule associated with it.
• Written Complex SQL queries to perform validation of various backend tables.

Environment: Excel, MS project, Client Simulator, Autosys, Aqua data Studio, Ocean dev Assistant, QTP 10/9.5, Java, C .Net DB2, Fitnesse, DBfit, VB script, Sybase, SVN, Eclipse

Confidential

Sr Business Analyst

My main responsibilities were to review and create Business requirement documents BRDs , use cases, perform gap analysis and created automation framework for BDC application.

Responsibilities:

• Worked on BDC which substitute legacy GSCX clearing system. System was build to clear 1 million transaction worth 1.5 Trillion Fixed Asset and Funds.
• Documented and analyzed business requirement for migration of GSCX to BDC.
• Created Business requirement documents BRDs to describe business functionality for Clearing application which deals with processing of STIF message Fixed income equity settlement , counterparties and there account at BNYM.
• Reviewed use-cases for gaps between application and Business requirement for an Equity/Cash clearing application.
• Participated in scrum meetings to facilitate communication between various project teams.
• Document business requirements and process flows using MS Visio and MS Word.
• Performed change Management and build versioning in Clear Quest.
• Perform Data analysis by defining SQL queries to extract data from different databases and validate it for authentication.

• Developed technical and business requirement's knowledge base for broker dealer and Hedge fund services to create all the possible use case and test scenarios.
• Created Automation test plan and Build Automation framework using QTP, VB scripting and Quality Center from scratch.
• Created Automation framework design and implementation document to define the standard to be followed while creating automation framework.
• Understand the functionalities of the new and existing applications by attending review meetings with different groups and SMEs.
• Performed Black-box and grey box testing covering functional, GUI, system, integration, Security and database validation on the clearing system.
• Created Function libraries, object repository and various resources in Test Resource in Quality center. Maintained multiple object and function libraries to manage parallel development of scripts by various resources.
• Created utility to execute Unix Commands using Vbscript and QTP Object.

Environment: CaliberRM, MS Visio, Microsoft word, Quality Center 10/9.0, QTP 10/9.5, QTP Flex Addin, Flex, SQL Developer, Java, AIX, Solaris, Oracle, Fitnesse, DBfit, VB script, Beyond compare, Unix, Sybase, Clear Quest, SQL developer, MQ Client, Wincvs, Novell Client, Flex Builder 3.0, Lotus 8

Confidential

Business analyst

I was part of Account management and trading group working on two project which deals with Locate Held Position and Summary Level Returns. Summary level return is a data-warehouse for reporting client mandate using various benchmark set by customer.

Responsibilities:

• Developed technical and business requirements and UAT scenarios by collaborating with SME and the development team.
• Gathered requirement for market data management system to get all the Locate and Held position.
• Created Test plan for Equity Fund Automation Summary-level returns based on SRS.
• Tested Informatica mapplets, ETL, Data warehouse and data mart using T-SQL and DbFit.
• Created data comparison utilities in VB-script and beyond compare.
• Analyzed and documented business requirement for migration of excel based system to web-services.
• Review all the use-case, business requirement and SRS validating all the functionality provided by SME.
• Created fitnesse tests for comparing staging and reporting table in database which were created as a result of flat file parsing.

Environment: C , .Net, SQL Server 2005/2008, T-SQL, Quality Center 9.0, Business process testing, QTP 9.2, Fitnesse, DBfit, VB script, Beyond compare, Rtime, Cognos Report, Informatica power center 8.5, SharePoint, SVN, Agile Methodology.

Confidential

Sr. Team Lead / Process analyst

I was part of a team to build system which integrates all market and trading feeds along with their trading, reporting and financial risk management FRM systems. The integral part of system are Trading, Execution and Management System TEAMS/TMS which is an OTC order management system, FRM which deals with financial derivatives and generate swap curves and volatility surface using Fincad, Market Data Management System which stores the data from DTN Reuter MDS , Global Position System GPS and Mark to Market MTM .

Responsibilities:

• Designed QA roadmap, test strategy and testing framework from scratch using QTP, Excel, XML, QC Win32 COM objects to test various applications e.g., GUI, web services, , SAP FI/CO .
• Created and managed onsite as well as offshore automation manual testing teams to achieve high quality standards.
• Tested complex financial modules using in-depth knowledge of equity and derivative such as Futures Forward contracts, Options, Hedging, Swaption, FX Spot trading, implied external FX exposures.
• Gathered requirement for market data management system which fed into the financial system management system to get information about the market risk by creating swap curves, volatility surfaces and holding costs.
• Tested application modules such as Distribution, Tenders, Delivery order, account receivables, Settlement, Accounting and warehouse reporting.
• Designed Defect Life-cycle processes for manual automation testing and implemented it in Test Director / Quality Center using VB-script and Work-flow customization.
• Mentored team members and communicated automation goals to achieve timelines.
• Coordinated with various global offices to consolidate UAT scenarios.
• Created clean point database processes for Automation to shorten testing time.
• Worked with business users and SME to capture and document requirements.
• Performed data-driven testing and used Excel macros to test run time data calculations.
• Parsed Reuter, Sungard data feed files using VB script and Perl to compare against database.

Environment: Quality Center 8.0/9.0, CaliberRM, Quick Test pro 8.0/8.2/9.0, VB Script, TOAD, LoadRunner, J2EE/Java 2.0, EJB, JSP, Servlets, Windows 2000, Linux AS4, Websphere, Oracle 9.0/10g, Lotus Notes, Tibco ESB, Web-Focus Reports, RUP Methodology.

Confidential

Sr. Analyst

My Role as a part of team was to re-engineer, understand and document the First to File Patent Automation System.

Responsibilities:

• Studied the systems architecture and developed the knowledge base of a rule engine which governs access to various modules.
• Gathered enhancement requirements and analyzed functional requirement specification FRS , System requirement specification SRS and software design specification SDS
• Interacted with business users to understand complex functionality of the application.
• Verified and validated all the use cases and requirement for the application.
• Developed test strategies, test plans and test cases on the basis of application behavior and Use cases.

Environment: Quick test pro 6.5, VB Script, Java 2.0, EJB, JSP, Servlets, Windows 2000, Linux 7.0/9.0, Shell Scripting, Perl, Bugzilla, TestTrack Pro, Bea Web Logic, JBoss, Oracle 8.0, LAMP.

Confidential

Analyst

Responsibilities:

• Analyzed Client Requirements and prepared Test documentation such as Test plans, Test procedures and Test results using business, technical and functional requirement.
• Worked as black box tester on the software modules, documented test cases and results in the standard templates. Wrote Test Drivers for unit testing and integration testing.
• Created winrunner script for testing various web and client server application.
• Helped in writing the validation plan in accordance with the SRS
• Wrote SQL scripts to validate the data in Oracle database.

Environment: MS-office, Winrunner, VB, ASP.NET, Oracle.

Technical Skills:

• Requirement management tools: Enterprise Architect, CaliberRM, Rational Requisite Pro, JIRA
• Project Management tool: MS Project, Microsoft Visio and Microsoft Office, Microsoft Excel
• Testing Tools: Quality center 10/9.x/8.x, Test Director 7.6, QTP 10/9.x/8.x/6.5, Fitnesse, DbFit, Jira, SQL Developer, TOAD, Clear Quest
• Languages: PL SQL, T-SQL, XML
• Relational Database: DB2, Sybase, Oracle 10g/9i, SQL Server 2005-2008, MS-Access, MySQL, SQLite
• Design Methodologies: Agile Scrum , Rational Unified Process RUP , Rapid Application Development RAD , Extreme Programming XP ,
• Others Tools: Aegisoft Client Simulator, SQL Server Management Studio, Lotus Smart Suite, MS Outlook, Cygwin, and SVN.