SUMMARY

• 8 years of experience in IT with a focus on Business Analysis, Project Coordination and Quality Assurance.
• Worked in various domains such as Banking, Insurance, Telecommunications and Internet Technology
• Expertise in gathering business requirements and translating into a Requirement Specification Document, use case development, identifying business rules as well as translating requirements into functional design, test planning, and test script development.
• Knowledge of Securities such as Fixed Income Bonds , Equities, Portfolio Management, mortgage, CMO, CDO, derivatives and capital marketsas well as
• Other financial instruments including SWAPS, Futures and Forwards, Optionsthat involve trading strategies and OTC markets.
• Experience in Business ProcessManagement involving cross track effort estimation,budgeting, SIPOC process, Project Scope Definition and requirement analysis
• Experience in RUP methodology, developed artifacts related to business modeling and requirements, which are created as models to support requirements, analysis, specification, traceability, validation, verification, and requirements management.
• Proficient in conducting Joint Application Development JAD sessions for requirements gathering, analysis and design, proposed alternative tasks, next steps, future proposals etc
• Used UML in business analysis methodology IBM Rational Rose. Experience in developing process maps/diagrams for business process reengineering BPR and functionality enhancements.
• Experience in preparing GAP analysis to identify the differences between the organization's goal and existing current business processes.
• Experience in conducting and formulating RFP.
• technology infrastructure DRP .
• Experience is formulating BRD, Business continuity plan non IT related documents and IT related
• Proficient in Advanced Excel analysis, emphasis on creating pivot tables, data tables and analysis tools, statistical functions, file formats.
• Knowledge of the testing lifecycle and the various testing types such as Manual Testing, Black Box Testing, System Testing and User Acceptance Testing.
• Excellent interpersonal skills, effective communication with colleagues, clients and vendors, leadership skills and acted as a liaison between business and IT department.
• Involved in formulating requirements using Agile methodology

TOOLS AND TECHNOLOGIES

WORK EXPERIENCE

Confidential

Business Analyst

• Involved in new scope item which deals with Partner programs which includes migration and calculations of close to million discount types to an existing API.
• Worked on Data migration project- capturing AS-IS system logic and data and analysing TO BE environment
• Involved in Business Optimization dealing with high volume crititcal production issues and resolving those issues
• Involved in FSD phase and Test Case review for next release item
• Successfully worked as lead analyst for enhancement and new toold design by coordinating with both offshore and onsite resources, review and feedback, status calls, etc
• Involved in understanding, planning and executing the requirements
• Participated in the scope review and design sessions to identify X-functional impact.
• Used SIPOC diagrams as part of Project Scope Document to define high level activities
• Work in UI based commerce tools-Cisco Commerce Workspace CCW and Cisco Service Contract Centre CSCC with respect to Pricing modulesextensively to understand the functionalities.
• Analyzing the root cause of the escalations and providing exact solutions to the data setup or Solutions or IT teams.
• Prepared for GAP Analysis As-Is and To-be identified and documented improving areas to meet requirement regulations.
• Evaluate Production Escalationsand drive it till its closure.
• Prepared Functional Specification documents,UseCase and shared the information with crossfunctional teams in IT as well as business.
• Involved in understanding existing manual pricing process structures, discounting systems and developed processes for system integration and developed impact flows.
• Identifying and authoring Technical Specifications document pertaining to parameter and attribute functionality and identify the delta.
• Involved in Technical Specifications review sessions to understand the system flow and also give necessary inputs to engineering team
• Prepare different business/system Process Flows in Microsoft Visio and wireframes using Adobe Photoshop
• Participate in Adhoc testing on any run the business scopes or enhancements done on a need basis.

Environment: MS Office Suite, PL/SQL, Oracle ERP application QTP,QTC, Java, SnagIT

Confidential

Business Analyst

• Involved in documenting and mapping pricing processes for all rate plans and services.
• Understanding the IT systems involved as well as understanding the key stakeholders and teams involved, roles in the process as well as ad-hoc management of small projects
• Involved in understanding existing legacy structures, systems and processes for pricing, design and help implement future integrated pricing solutions and integration activity
• Enhanced the Charging parameters module so that similar offers transaction charging plans to various segment of customers can be combined to form a tariff plan, so that offers can be limited thereby reducing the user maintenances. This module is enhanced using in-house developed front-end tool.
• Executed test plans and scenarios to report results and defect resolution. Created and maintained documents to ensure progress reporting requirements are met.
• Analyze root cause of the issues reported during test phase and identify problem areas to reduce future errors and suggest improvements in the development process.

Environment:MS Office Suite, SQL 7.0, Oracle

Confidential

IT Analyst Marketing Finance

• Conducted UAT, of Market Place and Banner Ad Management tools
• Created Functional Specifications Document pertaining to applications.
• Created presentations on Segments to Business Team
• Understanding various algorithms/ statistical tools to capture customers interest on the Cisco Websites through cookie project
• Took ownership of modeling and creating document templates to introduce rigorous standards

Environment: MS Office Suite, QualityCenter.

Confidential

Business Analyst Group Risk

Responsibilities :

• Involved in Global Workshop involving SME's, Project Sponsors, Technical team and Analyst team to understand, build additional business requirements. and provide solutions for a comprehensive alignment of existing business practices with other HSBC projects and future strategic vision.
• Involved in all the components of Pre-Workshop activities like Meeting agenda, Documentation, Questionnaire, Presentation material
• The project related to Mitigants involved all the various collateral required for mortgage banking- secured lending
• Gathered business requirements by playing the role of scribe as well as interviewer.
• Developed Use Cases using well established business and technical practices of HSBC
• Identified gaps and evaluated requirements to manage Change Requests through Change Management Delivery
• Involved in comprehensive documentation of updated requirements as well as functional requirements
• Involved in traceability of the functional requirements by preparing BRMD
• Worked on understanding business requirements of other HSBC business solutions and analyzed ways to
• align the different functionalities of suite of HSBC processes into an orchestration layer.
• Involved in collating global feedback of the Use Cases across all regions on the Use Cases to build spreadsheets that help in easy traceability, capturing feedback and responding to queries from SME's across the globe
• Used MS Visio to build business flows and activity diagrams.
• Project involved building requirements and use cases around Basel regulations, undrawn commitment to counterparties, treasury products, lending, core banking, trade facilities, indirect exposures, settlement risk, time banded limits, Uncleared limits and products specific to Brazil, Argentina, Asia- Pacific and Middle East.
• Helped in explaining all complex financial products to the design and development team.
• Involved in Agile methodology process to build a prototype on Dash Boards pertaining to KPI's and Risk factors using User Stories method to capture variable requirements and implement the solution at the earliest
• Used MS Share point to share all artifacts in the form document management system, providing feed backs, tracking across onsite and offshore teams
• Involved actively with a micro team of developers, QA, business, SME in elicitation of requirements, analysis, execution to build application/tool.

Environment: MS Office Suite, Clarity, MS SharePoint, IBM Lotus Notes, OS 390, DB2, CICS, ISDS 3270.

Confidential

Financial Business Analyst

Responsibilities :

• Gatheredbusiness requirements as well as simultaneously conducted functional feasibility studies.
• Analyze business requirements, generate business models, identify business rules and system interface, document use cases and create the requirement specification document.
• Involved in a new loan origination system project In House Project , defining requirements, and facilitating meetings with Seniors Managers, vendors and subject matter experts.
• Enhancements to the existing load application and improve the user experience and include search capability
• Participate in JAD sessions, weekly meetings and walkthroughs with the with all levels of stake holders such as Senior Management, Brokers, Loan Officers and other vendors, analysts, lead developers and testing team.
• Understanding Operations of a regular financial review process for specific customers by prioritizing the high risk sectors.
• Analyzed data using Solver, created scenarios using solver using moving average and trend charts.
• Conducted feasibility, adaptability study and risk analysis to identify critical areas for the business from user perspective.
• Wrote SQL/Oracle queries to review the returned data to ensure that the correct data was retrieved and followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and ensured that critical requirements are not missing.
• Involved in project similar to ACH, partially to facilitate the clients of WCB with their customer payments.
• Asses funds on hand, transaction adjustments and invalid bank transactions.
• Assist the testing team with testing strategy and data requirements.

Environment: Java, Windows 2003, Web sphere, Oracle 10g, XML, RUP, MS Vision, MS Access2003, MS Excel 2003, Quality Center 9.2,

Confidential

Business Analyst

Responsibilities:

• Participated in JAD sessions throughout the SDLC.
• Wrote Oracle executable statements and manipulation of data using all the available commands.
• Assisted in design review meetings making sure all the requirements are covered in the development project scope.
• Interacted with users for verifying user requirements, managing change control process, updating existing documentation
• Involved in UML, designed Use Case Diagram, Class Diagram, Sequence Diagram, and State Diagram for project documentation using Microsoft Visio.
• Interfaced with members of the installation team and user support groups, involved in vendor management under the direction of the manager.
• Transfer data from MS access to MS Excel to analyse and produce reporting data using Pivot tables
• Used MS Excess 2003for basic data validation and analysis. It involved using data tables and look up function.
• Tested the design of a data base using 'performance analyzer , understanding recommendations and optimizing the standards
• Examined tables to check for design errors like typographical errors, redundant fields etc using 'table analyser' and 'tips'
• Analyzed user statement of requirements to develop new reports
• Coordinated UAT and executed environment build plans.
• Assisted Transaction log failure and validating transactions
• Proactively used wireframe methodology to help developers to understand the business logic and data view.
• Used Adobe Photoshop to build prototypes and MS Powerpoint to show a visual of user interface to the clients

Environment: Windows 2003 Server, Java, Websphere, Oracle 10g, MS- Visio, MS Excel, MS Power Point, MS Word, Quality Center 9

Confidential

Business Analyst

Responsibilities:

• Analyzed, collected and prepared user requirements, definitions, scope and expectations for deliverable plans. Delivered system documents, processes, diagrams and test cases.
• Organized and Categorized requirements into FURPS Functional, Usability, Reliability, Performance and Supportability in Rational RequisitePro.
• Facilitated RAD sessions, conducted interviews, Q A sessions with business users to solicit business requirements relative to proposed functionality involving the client actively.
• Worked closely with the development team to clarify/understand functionality, resolve issues and provide feedback to ensure accurate business solution
• Defined business processes, identified gaps, evaluated requirements and change requests, managed scope and transferred knowledge.
• Performed feasibility, adaptability study and risk analysis to identify critical areas for the business from user perspective.
• Coordinated and attended meetings to review the requirement specifications with the Quality Assurance Manager and other team members including clients.
• Worked closely with project sponsor in writing test case, assist in development of prototypes for the web application frameworks in both server and client side scripting
• Used relationship windows Access 2003 to create, modify relationships between tables Investment module, Product type, Customer data, customer investment data etc
• Created query from Joined tables to display types of investment made by customer, dollar amount and frequency of investments Access 2003
• Used Forms to enter, edit and display data. For example Auto form or using design view, to view information from multiple tables. Created subforms to create and edit data MS Access 2003
• Maintained reports by grouping information to display data in a specific format. This is to achieve the use of formulas and creating calculated fields in a report eg, control source, expression builder etc MS access 2003
• Used Excel's financial functions and various other features like Pivot Table, PivotChart Report and Goal Seek tool for reconciling various reports
• The project also involved to work on statistical tools to understand several market oriented variables. Used regression and data tables to understand the variability of the different types of investment structures.
• Documentation using USE CASE and RFP based on the client requests.

Environment: Windows 2000, VB, Java, .NET/ASP.Net, Oracle 9i, Test Director 8.0, Requisite Pro

Confidential

Business Analyst

Responsibilities:

• Assisted management in defining requirements, possible implementations, and wrote a Request for Proposal RFP for the new system. Followed up on the Project schedule with various stages of RFP issue, written questions due, answers to questions and proposals responding to RFP's.
• Created data standards for quotes and made modifications to system linking tables. These changes reduced the number of incorrectly coded orders, thus reducing the need for manual postings within the accounting systems.
• Develop specific plans and tests to ensure that proposed systems and business processes meet those requirements, as they are being planned, developed, delivered and supported.
• Proactively approached most developers to solve technical problems and got along well with the functional testing team members.
• Reviewed Product Tutorial Notes prepared by Technical Publications - made a lot of suggestions to make it more meaningful and comprehensive tutorial.
• Extensively used Microsoft office suite of products MS Access, MS-Excel, MS-Word, MS-Power Point for documentation and data interpretation for reporting test status.
• Created validation rules using expression builder MS Access 2003 to validate data such as date, customer orders
• Created lookup wizard to find data, Used data sheet and data base toolbars to perform functions like filter by selection, filter by forms to do display specific records
• Making back up copies of customer and product type data base to work on Master edit copy, protecting database using security options and Indexed fields to avoid duplicate fields
• Used wireframes to build protypes of design modules to help stake holders understand the components of the web page. This was accomplished using MS Vision
• Detailed annotations were built to capture validation rules and dependencies

Environment: MS Access 2000, MS access 2003, Windows 2000,2003. VB, SQL Server 2000, HTML, DHTML, Java, Manual Testing,