PROFESSIONAL SUMMARY:

• 6+ years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Business Process Mapping Evaluating Data Sources, Data Mapping, Translating Requirements into Specifications, Application Design.
• Experience in the Fund Transfer Operations and Technology field. Accomplished in providing excellent customer support in a real time environment requiring immediate resolution for money movement and critical reporting.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Implemented an AGILE solution for Brokerage applications which resulted in enhanced trading efficiency and reduced IT support time by 30%.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOAD).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Strong experience with SQL queries and database objects.
• Strong Experience with data migration (ETL development), document data manipulation processes and scripts
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL

Operating Systems: UNIX, Windows 95/98/NT/2000/XP, Linux.

Databases: MS - Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic.

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisiteProDocumentum, Caliber RM, DOORS, SharePoint

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS )

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunnerNiku Project WorkBench

PROFESSIONAL EXPERIENCE:

Confidential, New York

Sr. Business Analyst

Responsibilities:

• Followed Software Development Life Cycle using Agile (SCRUM) Methodology which is based on iterative and incremental development.
• Provide user support and assistance to the bank on all aspects of the bank's core banking system and its integrated systems, including testing/implementations, resolving systems issues, and supporting routine.
• Created business rules to ensure that the inflows and outflows of cash are matched off in the Advanced Commercial Banking System (ACBS) automatically.
• Conducted JAD sessions with management, SME, brokers, users and other stakeholders for gathering requirements and to discuss open and pending issues.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Conducted GAP Analysis and risk assessment during the project, and maintained traceability.
• Worked in Data Analysis, Data Reconciliation and Data Mapping for ETL process
• Actively preparing mapping documents for the ETL processes.
• Creating Transformation Logics for the ETL processes.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
• Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories and Created teas cases in ALM for test execution, defect tracking & reporting.
• Created business process descriptions, use cases, scenarios, source to target mappings, and workflow analysis.
• Providing recommendations and helping in resolving errors and reconciling daily bank control of payment centers and treasury services.
• Experienced in client communication, relationship building, eliciting business requirements, conducting CIW session, gap analysis, User Acceptance Testing (UAT), functional walk through, data analysis, mapping and validation.
• Gathered requirements, organized team meetings requirements from business users such as insurance policy
• Managers, generated business process models, & use-case models, and created business requirements document (BRD) & functional requirements document (FRD).
• Utilize the Bank's core banking system and other integrated products extensively, and act as a super user for the Core and related systems: adding/deleting/modifying user privileges, testing new features and enhancements, and identifying / resolving a variety of system and software problems.
• Expertise in creating UI Mockups, wireframes, ER diagrams, Use Case Models and creating coherent user interfaces to realize business requirements.
• Reviewed counterparty credit risk & assigned credit risk ratings for transactions for credit limit applications.
• Conducted business and data analysis and developed the activity diagrams, sequence diagrams, and created use cases using UML and AGILE methodology.
• Conducted Joint Application Development (JAD) sessions to allow different stakeholders to communicate with each other, resolve problems at an early stage.
• Conducted interviews with key business users to collect requirement and business process information for the loan process including set-up Account Information, New Loan set-up, the Appraisal, Credit, income and Title functionalities
• Designed, developed, implemented and executed test plans, test cases and test processes manually and also with XML messages and UI Web Services.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.

Environment: Agile, Scrum, MS Suite (Excel, Word, PowerPoint, Project, Access, UI, Publisher, Outlook), MS Visio, UML, SQL, ETL, HP Quality Center, Rational, MS Project Server, MS SharePoint, Main Frame

Confidential, New York

Sr. Business Analyst

Responsibilities:

• Extensively involved in every phase of the RUP process starting from Inception to Transition.
• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Excellent understanding of EFT system (such as ACH, Fed Wire, BACS, CHIPS, FIX, SMAC, Automated Cash management and Prime Brokerage).Knowledge of Online Banking and the whole Fund Transfer process
• This involves Analysis & testing the actual structure of SWIFT message to ensure that it complies with SWIFT standards.
• Message Routing, validation ON both message transmission and response to the SWIFT message.
• Message Format, Validation of field formats and field content within SWIFT messages to ensure compliance with SWIFT standards.
• Application was developed for Online Banking accessing personal accounts, checking balances, payment of recurring bills, such as mortgages and loan payments, transfer of funds between accounts of its customers.
• Perform the operation deposit, withdrawal, fund transfer, FD or RD creation or apply for Loan, along with text to speech facility.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Developed & executed several Optimized queries in SQL on this data.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Prepared graphical depictions of Use Cases, Business process diagrams, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio .
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Analysed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Used Informatica to extract and transform data from various DB2 database to the data warehouse.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, EVPN, RUP, VBScript, Dreamweaver, SharePoint, Unix, Adobe Photoshop, Caliber RM MIS-IP, C#. NET, ASP.NET, ETL, Business Objects, TestDirector, LoadRunner.

Confidential, NY

Business Analyst

Responsibilities:

• Conducted one to one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
• Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Created and scheduled Sessions based on demand, run on time and run only once using Informatica Server Manager.
• Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
• Designed and developed Project document templates based on SDLC methodology.
• Developed Business Requirement Document as well as High-Level Project Plan.
• Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
• Defined the test criteria and project schedules, and baseline the Test Plan with the help of project meetings, walkthroughs.
• Documented the entire testing process, test cases and test results.
• Developed Functional Specification Document and Supplementary Specification (non-functional) Document.
• Participated in the Logical and Physical Design sessions and developed Design Documents.
• Worked with developers to make sure that they understood the Use Cases.
• Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Develop User Manuals, and Training Manuals as per Project Specifications and timelines.

Environment: Microsoft Office Suite, MS Visio, Windows XP, DreamWeaver, SQL, PLSQL, XML, VB, ASP, Crystal Reports, Adobe Photoshop, Mercury TestDirector, WinRunner, LoadRunner

Confidential, Murrysville, PA

Business Analyst

Responsibilities:

• Collaborated in building a business analysis process model using Rational Rose, Requisite Pro, and Visio and provided key initiatives in working with users in defining project and system requirements.
• Worked on various Online Banking projects like set up Check Payment, Browser variations, Keep the Change, Online Banking mail communication with live customers, Authentication flow, Alert mails to Customers etc.
• Worked with Siebel users and co-ordinate with the teams involved in testing the user interface and backend testing.
• Worked with the ETL,QA and the BI team to help them understand the data model and helped them in preparation of Data Element Mapping (Source to Target Mapping)
• Gathered user and business requirements through surveys, prototyping and observing from portfolio managers and UI (User Interface) and extensively used HP ALM/Quality Centre for Test Planning, Bug tracking and reporting the defects.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Identified, researched, investigated, analysed, defined and documented business processes and Use Case Scenarios. Analysed business requirements and developed Use Cases, Use Case Diagrams, Sequence Diagrams, Activity Diagrams, site map and wire frames.
• Successfully used Agile/Scrum Method for gathering requirements. Documented User Stories and facilitated Story Point discussions to analyse the level of effort on project specifications.
• Documented and supported the requirements to develop the platform which enables the user to monitor his/her accounts, provides at-a-glance balances and positions, order status, account reporting, grouping accounts, real-time margin balances and real-time profit & loss.
• Captured and managed change requests throughout the lifecycle - as well as provided effort estimations to internal and external development teams.
• Documented business workflow textually as well as in UML diagrams according to agile for the stakeholder review.
• Worked extensively with SME's including heads in areas of derivatives, swaps and futures in understanding, extracting, refining and documenting the User and Business Requirement Specifications in the BRDs.
• Involved in defining the source to target data analysis, data mappings, and business rules and data definitions.
• Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Developed Test Plans and Test Cases according to Business Requirements and Followed agile methodology and maintained user stories.
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on a daily basis.

Environment: Microsoft Office Suite, MS Visio, Java, C, Windows NT, JavaScript, UNIX, HTML, ETL, Oracle, SQL, Mercury Test Director, Mercury Load Runner