SUMMARY

• More than 9 years of extensive and diversified IT experience as Business Analyst for Various Clients in Investment Banking Sectors.
• Extremely proficient in all areas of analysis, including Requirements Analysis Management, Functional Analysis, Business Systems Analysis Project Management.
• Extensive experience with wide spectrum analysis skills, good technical knowledge and excellent people skills. Strong experience in Business System Analysis, Software Application Design in Internet, Intranet and Web based applications.
• Domain expertise in Basel Measurement Reporting BMR , FINMA Compliance Reporting, Derivatives Equities and Market Risk Reporting.
• Worked on applications which involves maintenance and trading of investment products like fixed income products Bonds, IR Swaps etc. , equities and various Derivative products like Options. Futures, CDS, Swaps etc.
• Worked in projects following Software Development Life Cycle SDLC with Agile and RUP methodologies.
• Experience in conducting Joint Application Development JAD sessions for requirements gathering, analysis, design and Rapid Application Development RAD sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project's exposure to the forces of change
• In Depth understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
• Excellent skills in Business Analysis, OO Analysis, Data Analysis, Requirement Analysis, Business Modeling and Proficient in customizing workflows, activities and deliverables of existing business practices.
• Excellent communication with strong problem solving, analytical, co-ordination skills and experience in managing projects, Configuration support produce quality work under tight deadlines.
• Hands-on management experience developed and established through a variety of cross-functional businesses team assignments.
• Proficient in streamlining Business processes by recognizing and avoiding bottlenecks, thereby reducing Cycle time and improving system efficiency and employee productivity and concurrently employing activity based costing techniques for better cost benefit analysis of the system
• Results oriented professional with proven accomplishments as a Business Analyst in the financial services industry. Ability to learn quickly and meet deadlines within required timelines.
• Experienced in onshore/offshore project execution. Recognized as a high achiever who goes above and beyond to exceed business customer expectations for solution delivery.
• Skilled at producing clear and concise documentation, eliciting requirements from diverse groups of constituents, and delivering quality system solutions

TECHNICAL SKILLS

• Methodologies/Methods: RUP, Agile, Water Fall
• Operating Systems: Windows NT/2000/XP/Vista/7, DOS, UNIX
• Tools: OBIEE, AXIOM, Microsoft Visio, Microsoft Project, Clear Quest, Quality Center, QTP, Astah UML, Version One, Business Objects BO
• Databases: Oracle 11.0, SQL Server, MS Access
• Languages: PL/SQL, HTML, Visual Basic, C and C
• Office Automation Tools: MS Office Suite, MS Visio

EXPERIENCE

Confidential

Lead Business Analyst

Basel III Basel Measurement Reporting BMR Regulatory Compliance Reporting

• Basel Measurement Reporting BMR group role is to measure, report and help manage the Bank's Swiss Regulatory Capital and Balance Sheet.
• By managing the capital position, this group enables the Bank to optimize deployment of its limited Capital adequacy and balance sheet ratio calculations across Business areas, to ensure ongoing compliance with Swiss Regulatory Capital requirements and Balance sheet leverage ratios.
• The project involves providing user-friendly Reporting environment out of Strategic Reporting tool OBIEE facilitating Basel III RWA reporting, to support Daily and Month end BMR reporting. The reporting framework is developed to provide commong BMR integrated Dashboard, automated scheduled reporting, drill-down capability and various Maintenance functionalities.
• Strategic tool AXIOM is used for to support Month end Regulatory Compliance reporting, which supports all Compliance reports Pillar I, Pillar 3 and SNB Reports. The tool provides seamless drill-down to the exposures level details with flexible Report Position Adjustments RPA framework
• Key Project initiative was to develop a Combined CDM Data Mart for both Investment Banking IB and Private Banking PB upstream systems and come up with Harmonized data mart solution to enable cost saving with Combined reporting of RWA and reduce time to market.

Responsibilities:

• Heading the workstream for MIS Basel reporting and FINMA Compliance Reporting. With focus on Credit Value Adjustment CVA , Centralized Counterparty Risk CCP , Credit Risk RWA, Market Risk VaR, Fx Risk RWA, Market Risk RWA, and Operational Risk RWA
• Documenting Business requirements via Client interviews and developing wireframes, sample reports etc. to achieve on final Business requirements for various MIS BMR reports.
• Developing Functional Requirements Specificaitons for various workstream Reporting requirements and Change Requests CR's and performing walkthroughs with BMR team as well as Design team to secure Sign-off's on the final requirements.
• Performing Functional Spec walkthroughs with Build team and FT teams to start the Development and Test estimate process.
• Collating the various estimates and prioritizing the CR's and various Defects during the life-cycle of the project.
• Developing various Mapping help files for AXIOM Pillar 1 and Pillar 3 reports to implement the standard templates as required by FINMA Regulatory Authority. Approx 145 Compliance reports implemented
• Worked with BMR team on to come up with a suite of Validation Exception V E Reporting Suite, to capture various exposure records from various upstream systems and Calculation Engine with missing essential attributes and other enrichments. Approx 24 V E exception reports implemented.
• Responsible for status reporting, client communication coordinating with the project management team for timely completion and quality maintenance of projects.
• Involved in Requirement gathering, Analysis, Design, Development, Testing and Deployment of the project.
• Interacted with the end users team in understanding the business rules and writing requirement specs and mapping documents from staging to data mart, cubes and reporting needs to the end user community
• Designed and implemented SQL queries using joins and PL/SQL for QA testing and report / data validation
• Worked with the Users, Developers on technical design, deliverables, and prioritizing the tasks.
• Conducted one on one session with the clients to assess client needs and expectations and ensure project delivery within deadline
• Played a major role in Interface testing both functional and manual and Collaborated with Quality Assurance Analyst in Automated testing
• Perform User Acceptance testing UAT and Oversee users during UAT cycles.

Environment: Oracle OBIEE, Business Objects BO , Quality Center 11.0, MS Visio, MS Excel, MS SharePoint, MS Office, Oracle 11.0, Toad.

Confidential

Sr. Business Analyst

Retail Distribution of Investment Products Investment Product Risk RDIP-IPR

• Retail Distribution of Investment Products RDIP is a global program to review and address the risks in the distribution of investment products to retail investors across Citi. The Investment Products Risk IPR portal is responsible for coordinating RDIP implementation. The IPR Product Rating service provides centralized rules-based calculations of consistent risk ratings for listed and unlisted investment products globally.
• Ratings as provided by the IPR PRRS Product Risk Rating Service are required to be used by all Citi retail investment products businesses.
• The project involves data acquisition globally to manage and monitor the implementation of RDIP policy and standards. It involves managing the investment details on all kind of investment products under various asset classes like, fixed income securities, derivative instruments like options, swaps, CDS etc.
• The Reporting requirement of the RDIP-IPR implementation can be broadly classified into the functions of surveillance and business intelligence.

Responsibilities:

• Leading a team of 8 employees for developing the Reporting portal, which implements surveillance and Business intelligence.
• Responsible for status reporting, client communication coordinating with the project management team for timely completion and quality maintenance of projects.
• Followed agile methodology in the project. Performing the task of Scrum Master during the SCRUM meetings.
• Documenting user stories and updating for every sprint during project.
• Involved in Requirement gathering, Analysis, Design, Development, Testing and Deployment of the project.
• Interacted with the end users team in understanding the business rules and writing requirement specs, technical specs and mapping documents from staging to data mart, cubes and reporting needs to the end user community
• Develop detailed ETL, cube and report specifications by coordinating with the Solutions Architects and Data Architects.
• Designed and implemented SQL queries using joins and PL/SQL for QA testing and report / data validation
• Worked with the Users, Developers on technical design, deliverables, and prioritizing the tasks.
• Conducted one on one session with the clients to assess client needs and expectations and ensure project delivery within deadline
• Played a major role in Interface testing both functional and manual and Collaborated with Quality Assurance Analyst in Automated testing
• Developed strategies with Quality Assurance group to implement Test Cases for stress testing, and document in Quality Center.
• Perform User Acceptance testing UAT and Oversee users during UAT.

Environment: Java, Quality Center 10.0, MS Visio, MS Excel, MS SharePoint, Oracle 11.0 and SQL Server

Confidential

Business Analyst

Basel II Risk Compliance

This project was initiated for the implementation of Basel II project. Project was part of the regulatory requirements for the risk measurements and disclosure reporting. Project involved the measurements and mitigation of various risks including credit risk, market risk and operational risk. It also supported the all the three pillars of the Basel II namely minimum capital requirement, supervisory review process and market discipline requirements. System got the feeds from various databases including external data, dedicated Customer Relationship Management CRM and Bank's Management Information System MIS . Credit Risk is measured based on 'Advanced Internal Rating Approach' by measuring Probability of Default PD , Loss Given at Default LGD and Exposure at Default EAD . Market risk consists of Interest rate risk, Foreign exchange risk, commodity risk and Equity risk. It is measured by Value at Risk VaR . Operational risk is measured based on 'Advanced Measurement Approach'.

Responsibilities:

• Performed the requirements analysis by facilitating the Joint Application Development JAD involving Risk Managers, Credit Analysts, Operational Managers along with the Developers Lead and QA Lead
• Conducted the GAP analysis to understand the AS-IS and TO-BE process model to evaluate the benefits
• Undertaken the detail analysis of credit risk, market risk and operational risk pertain to the banking industry
• Implemented Rational Unified Process RUP Iterative methodology in the various phases of system development life cycle
• Prepared the Business Requirements Specifications, Use Cases, Process Flow Diagrams, and Functional Specifications with the collaborative subject knowledge of business users, development team, QA team and subject matter experts in the area of risk
• Performed the data mapping and defined data source, filter and target to facilitate the ETL team to feed the data into data warehouse and create data marts
• Closely worked with system architects and development lead to prepare GUI design, database design, and system requirements of the various reports
• Provided post production support to business users as well as dealt with development issues to trace back to requirements
• Conducted User Acceptance Testing UAT , user training and prepared user manual to help the business users
• Created Use cases, Activity Diagrams, State chart diagrams, Sequence Diagrams following Unified Modeling Language UML using MS Visio
• Tracked the complete Software Development Life Cycle SDLC using MS Project
• Developed Market Risk and Credit Risk functional specification for Value at Risk VaR , Profit and Loss P Ls , and Regulatory Capital functional specification for the calculation of the Risk Weighted Assets RWA exposures using the PD, LGD, EAD, Netting, Collateral, and other measures.
• Extensively used PL/SQL query to validate the database and for joining the tables and getting the right reports
• Involved in performance testing, functional testing and integration testing and reviewed and assisted the QA team with developing test plans and test cases

Environment: Oracle, Autosys, TOAD, Java, C , XML, MS Office Suite, MS Visio, HP Quality Center 10.0

Confidential

Business System Analyst

Market Risk IT

• The project involved development and maintenance of Data Warehouse application for Market Risk measurement and disclosure reporting, for various FICC products across the globe sent from various upstream systems. Market Risk consists of o Interest rate risk, Foreign exchange risk, commodity risk and Equity risk. It is measured by Value at Risk VaR calculation.
• The front end Business Intelligent tool uses the stored data to assist traders and stakeholders for maintaining the exposures at various hierarchy levels and to help them in decision making and highlight any overrides default exposure levels.

Responsibilities:

• Lead a team of 7 peoples for developing reporting portal, implementing reporting and other Business intelligence requirements.
• Followed agile methodology to implement the ETL and reporting requirements of the project.
• Gathered requirements by having meetings with users and various stakeholders of the application.
• Studied the requirements to see how effectively it fits in the existing application. And if the proposed functionality should undergo a change.
• Identify transformation steps for SSIS data load
• Created user interface mock ups and SSRS reports layout
• Prepared sprint documents and hosted stand up meetings with Development and QA team to abreast them with the upcoming changes, and to know their concerns about it.
• Developed and Maintained User Stories
• Interacted with the SMEs and stakeholders to get a better understanding of client business processes and gather business requirements
• At the end of the development cycle, worked closely with the users to get feedback and incorporate it in the next sprint.
• As a part of the Issue Resolution team, developed documents listing and explaining Issues and actively participated in Issue Meetings in order to resolve them

Environment: SQL, MS Access, MS Project, MS Visio, MS Office Suite

Technologies involved: SQL Server 2008 With BI SSIS, SSRS , Team Foundation Server, and MS SQL Analysis Server

Confidential

Business Analyst

Derivatives and Equities Linked D EL

• The project involved development maintenance of Java and web-based GUI applications, which are used for maintaining edit/update/creation money Market Instruments Derivatives Equities or Investment Products, the trades executed on these Instruments and tracking of various volatility parameters on these Instruments.
• Development and maintenance of various UNIX based applications which were used for Batch data entry.
• Exercise and Assignments of Options Futures Instruments, Update of Options Instruments based on Corporate action on the underlying instruments, Automatic Position editing on Instruments. Maintenance of various other money market instruments which include fixed income products like Bonds, Swaps, Warrants, and Forwards.
• Development and maintenance of various UNIX based applications which were used for Batch data entry.

Responsibilities:

• Followed RUP Rational Unified Process methodology to complete the project.
• Conducting user interviews, gathering requirements, analyzing the requirements using Visio.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD Object oriented Design using UML and Visio
• Conduct workflow, process diagram and GAP analyses to derive requirements for existing systems enhancements
• Create Ad hoc reports using Report Builder
• Act as a resource in understanding how BAU systems carry out business functions and assists in ensuring the timely and effective implementation
• Designed and implemented SQL queries using joins and PL/SQL for QA testing, data validation and Data Cleansing.
• Experience creating design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion
• Communicated extensively with the clients and with different levels of management to identify requirements, use cases and to develop functional specifications
• Provide technical and practical training to the Management team
• Document process for Management to use
• Perform User Acceptance Testing UAT

Environment: Asp.Net/C , Ado.Net, SQL Server 2000, Visual SourceSafe, UNIX, MS Visio, Clear Quest, MS Excel, Quality Centre, Test Director, JavaScript