SUMMARY

• Highly motivated Business Systems Analyst wif 10+ years of experience in Information technology and investment banking Domain.
• Excellent understanding of various Software Development Life Cycle (SDLC) methodologies like Agile, RUP and Waterfall.
• Good understanding of Capital Market, Market Risk, Credit Risk and Basel regulatory requirement.
• Awareness and adherence of ITIL process (Problem, Incident and change management)
• Proven expertise in successful Requirements gathering using suitable elicitation techniques.
• Experience in conducting successful brainstorming sessions, and preparing surveys and questionnaires.
• Experience in conducting Joint Application Development (JAD) sessions wif end users, Tech Leads, developments and testing teams for conflict resolution.
• Skilled in performing GAP analysis to identify system restrictions and potentials, and to create AS - IS and TO-BE documents and to create Process Maps.
• Excellent knowledge and hands-on experience in Oracle SQL, Pl/SQL.
• Extensive experience in creating detailed Business Requirements Document (BRD), Functional Requirements Document (FRD), and User Interface Document (UID).
• Experience in working wif technical teams to identify and document Non-Functional Requirements (NFR).
• Skilled in providing comprehensive walkthroughs wif the aid of Data Flow Diagrams and UML diagrams (Activity, Sequence, Use Case).
• Proven experience in handling changes efficiently by conducting Impact Analysis and holding Change Control Board (CCB) meetings.
• Quality Assurance experience in creating test plans and test scripts, reviewing test cases, and validating and monitoring defects using various defect tracking tools.
• Strong testing experience in performing Functional Testing, Smoke Testing, Regression Testing, Progression Testing and User Acceptance Testing (UAT).
• Expert in creating, managing and tracking Requirements Traceability Matrix (RTM).
• Strong knowledge and hands-on experience in SQL and Relational Databases. Experience in complex querying of databases for Data Analysis and testing.
• Experience in creating ‘User Manual’ and providing training to the end users.
• Proven active involvement in Post Production Validation and Production Support.
• Confident, quick learner, adaptable and flexible to the ever-changing technology.
• Excellent track record of managing global BSA groups (Onsite and Offshore model).
• Excellent communication skills and leadership qualities.

TECHNICAL SKILLS

Requirements Management Tools: JIRA, Rational Rose

User Interface Design Tools: MS Visio,Visual Paradigm, Just in Mind, MS Paint, Share point

Languages: SQL, PL/SQL, C, Slang

Project Management Tools: MS Project, MS Office (Word, Excel, PowerPoint, Access)

Defect Management Tools: JIRA

Databases: Oracle, Sybase, SecDB

Operating Systems: Windows 7/Vista/XP/95, Unix

Other tools: Toad, Data Studio, Autosys

PROFESSIONAL EXPERIENCE

Confidential

Technical Business Analyst

Responsibilities:

• Conducted extensive brainstorming sessions wif end users to gather their requirements and perspectives.
• Prepared detailed Business Requirement Documents (BRDs) and Functional Requirement Documents (FRDs) to capture the essential functionalities for the proposed system.
• Developed the Use Cases and Data Flow Diagrams (DFD) to understand and communicate the process to be employed under the new system to the entire development and testing team.
• Closely interacted wif database designers and architects to understand the existing database structure needed to support the new system.
• Organized and moderated Joint Application Development (JAD) sessions wif the end users, business users, developers and testers teams whenever necessary, as a conflict resolving tool.
• Performed walkthroughs of business requirements and functional requirements wif the development and test teams.
• Created and maintained Requirements Traceability Matrix (RTM) to manage requirements and performed Impact Analysis when request for change (RFC) arrived. Escalated the results of the analysis to the Change Control Board (CCB).
• Responsible for documenting Meeting Minutes of the weekly meetings and distributing to PM and other team members.
• Designed wireframes of the web interfaces dat would be used by the internal and external users to load, handle and examine claims respectively, using tools like Microsoft Visio
• Assisted testers in developing a variety of possible test scenarios and cases to ensure dat the system being built is resilient
• Monitored bugs in the system using tools like JIRA to ensure dat the quality of the system meets the industry standards and business user’s requirements.
• Tracked open issues and documented progress reports on weekly basis.
• Coordinated and Monitored User Acceptance Testing (UAT) wif the business user and interfaced wif the development and test team wif regards to defect status and fixes on a regular basis.
• Facilitated Post Production Validation and actively participated in production call support whenever necessary.
• Helped in preparing user-friendly documents like user manuals and system guides; provided training to user community as and when necessary.

Environment: Agile methodology, Microsoft Office Suite, Microsoft Visio, JIRA, Microsoft Project, Oracle DB, SQL

Confidential

Market risk Business Analyst/Project Lead

Responsibilities:

• Worked wif Business Users, Customers and Subject Matter Experts (SMEs) to understand the existing system and the current business process and methods to identify deficiencies and areas for improvement and enhancement.
• Requirements were gathered via Job shadowing MRA activities for firmwide/ GSAM reporting and also other users such as Front office IT and modellers
• Created and maintained by interviewing the business users to communicate the requirements to development and testing teams.
• Consulted the business users and SMEs to create Product Backlogs to prioritize features and subsequently created Sprint Backlogs.
• Performed GAP analysis by creating AS-IS and TO-BE documents to identify the potentials of the improved system.
• Involved in creating Questionnaire to understand the needs of the end users in order to make the system user-friendly.
• Created detailed Functional Requirements Document, consisting of the functional as well as non-functional requirements.
• Provided detailed User Interface Document to the development and testing team for clear understanding of the system.
• Conducted requirement walkthroughs wif the development and test teams before the development and testing phases respectively, to ensure dat the requirements are accurately understood.
• Created and maintained Requirements Traceability Matrix (RTM) to trace technical requirements to their business requirements and the test case requirements to their functional requirements.
• Worked closely wif the QA Team to create test plan and test scripts and review test cases.
• Validated and regularly monitored all the filed defects and their progress.
• Performed thorough User Acceptance Testing (UAT).
• Actively participated in Post Production Validation (PPV) and handled issues appropriately.
• Assisted the Project Manager in setting project deliverables and timelines.
• As part of adhoc run, requirements were gathered from MRA for London holiday processing and developed procedures after feasibility analysis and were reviewed, agreed by users and IT risk managers. Signed off procedures were tan executed by the offshore system analysts to sustain BAU.
• Participated in Basel 2.5, 3 runs and setting up scenarios for CCAR reporting.

Environment: Agile & Waterfall Methodology, Microsoft Office Suite, Microsoft Visio, Sybase DB, SecDB, Sybase, JIRA, SQL

Confidential, NY

Business Systems Analyst

Responsibilities:

• Interviewed SMEs and business users to consult on domain knowledge.
• Conducted interviews wif the business users to create detailed BRDs and FRDs.
• Involved in system analysis and design phase to identify the Non-Functional Requirements. Analysis and investigation of incorrect risk measures (VAR, Stress Test, Default scenarios, Greeks) for various market traded products.
• Used MS Visio to create Activity Diagrams, Sequence Diagrams, Flow Diagrams to make the system comprehensive to the development and testing team.
• Heavily involved wif the QA team in developing the Test Plan.
• Closely monitored the defects/issues on regular basis.
• Executed complex SQL queries to verify and validate the data in the database and to test the billing module.
• Performed Regression Testing, Progression Testing, Functional Testing and UAT.
• Involved in creating the User Manual Document for the end users.
• Verifying/analyzing data used for risk calculation from various trading desks for Broker Dealer/GSAM Businesses.
• Timely availability of simulation results from overnight risk calculation processes
• Analysis of issues related to asset data used for risk factor generations and product category wise risk exposures.
• Daily interaction wif financial modelers/Front office IT as part of resolving incorrect risk exposures identified.
• Monitoring of various End of day report runs required for risk analysts for ASIA, Europe & USA

Environment: Agile & Waterfall Methodology, Microsoft Office Suite, Microsoft Visio, Sybase DB, SecDB, Sybase, JIRA, SQL

Confidential

Oracle DBA

Responsibilities:

• Create and maintain large Oracle databases on SUN Solaris & AIX platforms.
• Provided recommendations and solutions on database performance, integrity, and security.
• Performed database administration activities including monitoring, schema management, space management, performance tuning, SQL tuning, database backup and recovery, disaster recovery, data replication and database refresh.
• Provided 12x7 database support and ensure dat all critical database problems are resolved in a timely manner.
• Performed RDBMS software maintenance including upgrades and applying quarterly security patches.
• Proficient in writing UNIX shell scripts.
• Procedures and triggers were created in SQL environment to achieve client requirement.

Environment: UML, MS Visio, MS Office, Microsoft Outlook, Oracle 9i (version 9.2.0.5), TOAD, SQL *PLUS, Precise/Symantec I3.

Confidential

Oracle Developer

Responsibilities:

• Developed Technical specification document TSD
• Developed Unit test specification document, which includes writing test cases to each functionality and running them against the developed module/units.
• Created, tested & modification of forms (FMB's) according to the functionalities required.
• Created reports as per client specifications/requirements
• End-user interactions for support and problem resolutions
• Identify, test and fix application specific bugs

Environment: Oracle 11i (version 11.5.0), oracle 6i forms and reports, TOAD, SQL tool 1.4, workflow builder.