SUMMARY

• Highly motivated Business Systems Analyst with 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 with 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 with technical teams to identify and document Non-Functional Requirements (NFR).
• Skilled in providing comprehensive walkthroughs with teh 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 teh end users.
• Proven active involvement in Post Production Validation and Production Support.
• Confident, quick learner, adaptable and flexible to teh 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, Scrum, Data warehousing tools

PROFESSIONAL EXPERIENCE:

Confidential

Technical Business Analyst

Responsibilities:

• Conducted extensive brainstorming sessions with end users to gather their requirements and perspectives.
• Prepared detailed Business Requirement Documents (BRDs) and Functional Requirement Documents (FRDs) to capture teh essential functionalities for teh proposed system.
• Developed teh Use Cases and Data Flow Diagrams (DFD) to understand and communicate teh process to be employed under teh new system to teh entire development and testing team.
• Closely interacted with database designers and architects to understand teh existing database structure needed to support teh new system.
• Organized and moderated Joint Application Development (JAD) sessions with teh end users, business users, developers and testers teams whenever necessary, as a conflict resolving tool.
• Performed walkthroughs of business requirements and functional requirements with teh 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 teh results of teh analysis to teh Change Control Board (CCB).
• Responsible for documenting Meeting Minutes of teh weekly meetings and distributing to PM and other team members.
• Designed wireframes of teh web interfaces that would be used by teh 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 that teh system being built is resilient
• Monitored bugs in teh system using tools like JIRA to ensure that teh quality of teh system meets teh industry standards and business user’s requirements.
• Tracked open issues and documented progress reports on weekly basis.
• Coordinated and Monitored User Acceptance Testing (UAT) with teh business user and interfaced with teh development and test team with 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 with Business Users, Customers and Subject Matter Experts (SMEs) to understand teh existing system and teh 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 teh business users to communicate teh requirements to development and testing teams.
• Consulted teh 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 teh potentials of teh improved system.
• Involved in creating Questionnaire to understand teh needs of teh end users in order to make teh system user-friendly.
• Created detailed Functional Requirements Document, consisting of teh functional as well as non-functional requirements.
• Provided detailed User Interface Document to teh development and testing team for clear understanding of teh system.
• Conducted requirement walkthroughs with teh development and test teams before teh development and testing phases respectively, to ensure that teh requirements are accurately understood.
• Created and maintained Requirements Traceability Matrix (RTM) to trace technical requirements to their business requirements and teh test case requirements to their functional requirements.
• Worked closely with teh QA Team to create test plan and test scripts and review test cases.
• Validated and regularly monitored all teh filed defects and their progress.
• Performed thorough User Acceptance Testing (UAT).
• Actively participated in Post Production Validation (PPV) and handled issues appropriately.
• Assisted teh 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 then executed by teh 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, New York

Business Systems Analyst

Responsibilities:

• Interviewed SMEs and business users to consult on domain knowledge.
• Conducted interviews with teh business users to create detailed BRDs and FRDs.
• Involved in system analysis and design phase to identify teh 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 teh system comprehensive to teh development and testing team.
• Heavily involved with teh QA team in developing teh Test Plan.
• Closely monitored teh defects/issues on regular basis.
• Executed complex SQL queries to verify and validate teh data in teh database and to test teh billing module.
• Performed Regression Testing, Progression Testing, Functional Testing and UAT.
• Involved in creating teh User Manual Document for teh 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 with 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 - NewYork

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 that 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 teh developed module/units.
• Created, tested & modification of forms (FMB's) according to teh 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.