Summary

• Extensive experience for 7 Years as Business Analyst with solid understanding of Business Requirement Gathering, Business Process Flow, Business Process Modeling.
• 3 Years of Financial domain expertise. 2 Years of Health care domain expertise, 2 Years of Insurance domain expertise.
• Excellent exposure and experience with Sarbanes-Oxley, Basel II, Basel III compliance requirements.
• Experience on Logical Data Requirements and Physical Data Mapping.
• Experience in Asset Liability Management Module, Financial Reporting and Inventory Management.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, FSD.
• Strong knowledge of UML based methodologies and applications including, Rational Suite, Rational Rose, and Requisite Pro etc.
• Experience in Quality Analysis and documenting test-cases and test-scenarios, interacting with QA / development teams in fixing errors and User Acceptance Testing (UAT).
• Exceptional Documentation Skills for writing Use Cases, Functional Requirement Documents (FRD) and Business Requirement Documents (BRD) as well as for creating Use Case diagrams, Activity diagrams, State diagrams based on UML Methodology, creating traceability matrix and business process flow diagrams using MS Visio/Rational Rose/Rational Requisite pro.
• Proficient in creating Use Cases, Use Case Diagrams, Class Diagrams, Sequence Diagrams, Activity Diagrams etc.
• Solid understanding of Business Process Flows, Case Tools, Business Analysis and Performance Analysis.
• Extensive knowledge of Traceability Matrices and Data Mapping between customer requirements and test case.
• Excellent communication skills, presentation skills, Business writing skills and a team player.
• Development of Test plans, work allocation sheets based on modular and system design and preparation of release documents at completion of testing efforts.
• Strongknowledge of SDLC methodologies particularly RUP, AGILE-SCRUM, Waterfall.
• Expertise in soliciting client requirements through interviews, JAD sessions, workshops, and existing systems documentation and procedures.
• Excellent Client relationship management, analytical, problem solving, written andoral communication, and presentation skills.
• Excellent understanding of Data Warehousing Concepts and ETL Processes.
• Solid experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Expertise in working on diverse aspects in project development with outstanding problem solving and analysis skills.
• Expertise in Software development Life cycle SDLC and Software test life cycle.
• Experience in preparing the training manual, check lists for scripting best practices, report generation and presentations.
• Experience in working in PL/SQL, Oracle and Mainframes environment.

Educational Credentials

• Bachelor in Computer Science, India.
• Generic Skills

• Automation Tools: Mercury LoadRunner 8.0, Mercury Interactive Topaz 5.1 - SP1 (Business Availability Centre), Quick Test Professional (QTP) 6.5 and 9.2.
• Server side Operating system: Windows 2003/2000/NT
• Client side Operating system: Windows XP, Unix.
• Programming Language: C/C++, Java, C# .Net
• Requirement Tools: Rational Requisite Pro, Agile, SDLC
• MS Office: Excel, Word, Visio, Power Point.
• Databases: My SQL, SQL Server, Oracle and MS Access
• Application / Web servers: WebSphere, WebLogic and IIS

Domain and testing Skills:

• Complete working knowledge of SDLC and STLC.
• Performance, Load, Stress or Volume Testing of different type of applications.
• Experience in testing various legacy systems, client server and Citrix application.
• Experience working in Health Care/Insurance, Telecom and Service industry
• Functional, Regression, Sanity and User Acceptance Testing.
• Performance monitoring of various applications after going to production for SLA and availability reports.

Confidential, North Richland Hills, TX
Business System Analyst June 10- Apr 12

Company Profile: Banking

RBC is Canada’s largest financial service institution. In order to follow the US Patriot Act, its US branch wanted to update its anti-money laundering (AML) system. RBC was working on moving one of their core applications from mainframes to a rich web-based application. The project involved Wealth Management Application which included many complicated processes from Account opening to Credit Check with many compliance related requirements. SoX compliance implementations took place during this project.

• Developed various use cases and Documented BTRD to come up with the front end application design.
• Gathered requirements during inception phase, documented and delivered functional specification documents, and assisted architecture analysis and design using UML and Visio.
• Creating and updating the test plan.
• Performed business analyst functions including: developed business logic, test matrices, gathered business requirements via JAD and JAR sessions with clients, managed project plans, resources, assisting developers with problems, documentation specialist and other users on new processes resulting from BASEL II mandates.
• Flag the manual test cases, for which creation of automation scripts was required, to be added to the functional or regression test suite.
• Assigned tasks among development team monitored and tracked progress of project following Agile methodology.
• Worked in Agile using Rational Requisite Pro
• Assisted with users during User Acceptance Testing (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place
• Creating test plans which were mapped to respective Business requirements using test management tools like Mercury Test Director and Quality Center.
• Conducted JAD sessions for communicating with the Project directors and stakeholders.
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration in to the CI System Knowledge Data Base in MS Share Point.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Worked with ODS and OLAP system. Worked with Data Extraction, Transformation and Loading. Metadata architecture was also provided, for the purposes of query enhancement and clarification of data relationships. Also built the foundation for process implementation in MS-SQL.
• Logging and tracking any defects in the application using defect management tools like Rational Clear Quest and Mercury Test Director.
• Conducted training and support to the users and other stakeholders.
• Analyzed production tickets and responded with appropriate action.
• Facilitated SME interviews and assisted in identifying and analyzing the possible technical solutions.
• Assist DW data analyst in analyzing existing reports and identifying iteration metrics;
• Performed requirement analysis, went through use cases according to the flow of customer data and rules of security sharing.
• Participate in business systems planning for integrated analytic needs; participate in defining approaches and priorities for satisfying needs.
• Assisted in data mart design and prototyping
• Assisted in mapping the requirements to the source systems, the DW and applicable data marts.
• Assisted in designing and validating source target mappings and transformation logical data model required to support information requirements.
• Performed GAP analysis to identify problems and inconsistencies with business requirements specification and the existing system and reported and escalated key issues requiring approval to the appropriate authorities.
• Documented testing assumptions and analyzed a proposed approach to a given problem.
• Wrote Supplemental specifications, business rules, operations specifications and interface specifications using DOORS.

Confidential Minneapolis, MN
Sr. Systems Analyst Aug 08- June 10

Company Profile: HealthCare, Pharmaceutical, Pharmacy Benefit Management.

Confidential market forces to make prescription drugs more affordable. The Company develops formularies, negotiates discounts from retail pharmacies and drug manufacturers, encourages the use of lower-cost brand and generic drugs and consults with clients on benefit design. For this project ESI had decided to add a new profile in the database by name MED (Medical eligibility data).

• Worked on Logical Data Requirements and Physical Data Mapping for processing of Medical eligibility file from client BCBS MA and provide the MED through web services.
• Involved in gap analysis and implementation of MED (Medical Eligibility Data) and Claim Validations.
• Analyzing Pharmacy Benefit Management (PBM) gaps and impacts across all transactions, system interfaces, applications and business processes.
• Preparing UML artifacts viz. Use Cases, Activity Diagrams, recommended by Agile for Requirements.
• Assisted with users during User Acceptance Testing (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place
• Creating test plans which were mapped to respective Business requirements using test management tools like Mercury Test Director and Quality Center.
• Prepare effort estimation plan for each execution cycle and script creation incorporated with addition or modification of any functionality.
• Coordination of the Load/performance scenario using Mercury LoadRunner.
• Analyzing the graphs generated using LoadRunner Analysis component and publishing reports highlighting bottlenecks in the application.
• Validated the documents and prototype with the business users.
• Evaluated systems requirements effect on business maxims and possible enhancements to the requirements during the development process.
• Created the Process Flow Diagram, Data flow diagrams, Requirements specification, Use case specification, Test Plan and Test Strategy Plans in co-ordination with the Business area, development and Quality assurance team, prioritized and distributed the tasks to the team for effective execution.
• Managed and lead the migration of the project from an off shore third party vendor to the newly developed off shore development center.
• Performed Gap Analysis between existing system and desired system.
• Prepared project reports for management.
• Assisted project managers in the development status reports,
• User training using the process flows, policies and procedures.
• Implementation tasks and checklist handled and made sure all exit criteria are met.

Confidential
Systems Analyst/Business Analyst Nov 06 - Aug 08

Company Profile: Banking/Investment

Uboc The new system will have the ability to monitor every single transaction, discover various types of unusual behaviors and alert officials to activities that represent true risk to the enterprise. The project involves developing a Data Mart using enterprise data warehouse and watch list as sourcing systems, and an alert reporting system. The new system gives a single view of the customer’s profile incorporating the affiliations and financial relationships that the account has, thus enabling the behavior detection system to identify high risk clients and provide corresponding information for AML analyst.

Technology: Rational Rose, Requisite, Rational Clear Case, Visual Studio, RUP, MS Office Suite, C#.NET, SQL Server, Unix, Windows XP, Test Director, Load Runner, QTP.
Roles: Systems Analyst

• Collaborated with project manager to define project scope, feasibilities and risks based on Scope/Vision documents and developed high level project plan.
• Facilitated discussions involving key stakeholders from both business side and IT side to elicit high level requirements.
• Worked with AML analysts, SMEs and high level regulatory managers to identify data elements and report types.
• Reviewed and assessed information gathered, defined key facts and dimensions, identified potential problems and facilitated problem resolution.
• Documented reporting system requirements and developed technical specifications.
• Used the Data Warehousing Life Cycle to identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Extensively used Data Stage for transformation and mapping in ETL process.
• Performed Gap Analysis between existing system and desired system.
• Prepared project reports for management and others, assisted project managers in the development of weekly and monthly status reports, documented process flows, policies and procedures.
• Handled the internal audits held on a monthly basis with the internal audit team in coordination.
• Co-ordinate with team members, both off shore and onsite to prepare a daily status report to keep a track of the testing efforts put in by the team.
• Prepared the task allocation sheet and the test matrix on a weekly basis.

Confidential, Tampa, FL
Systems Analyst Oct 05 - Nov 06

Company Profile: Financial

Fidelity is one of the largest financial service providers in the country. The project was involved with the automated money transfer feature, balance alerts, investment alerts, etc.

Technology: Rational Rose, Requisite, Rational Clear Case, Visual Studio, RUP, MS Office Suite, Java Web, C#.Net, Java. Windows XP.
Roles: Systems Analyst

• Designed and authored Business Requirement Documents, Functional Specifications and Technical maps
• Requirement gathering for each application developed in various protocols.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements
• Identification of various transactions that need to be monitored in every application
• Developed and implemented processes and tools for requirements gathering, analyzing, planning, tracking and delivery using Rational Rose requisite.
• Conducted initial JAD session with business users, managers, system architects, data administrators, requirement auditors, production planners, and trainers for creating high-level process model of business.
• Involved in Testing by using SQL and work with QA together to develop test Scenarios and test cases.
• Developed Use Case diagrams, Activity Diagrams and Sequence Diagrams
• Designed and developed project document templates based on SDLC methodology.
• Analyzed and discussed the business and functional requirements for the application under construction
• Monitoring of scripts for error handling and application ’s performance bottlenecks for the end user as per locations from which the application is supposed to run.
• Preparing Release Documentation for delivery to the client i.e. a report for moving a script from test to production environment.
• Responsible for implementation of the roll out and configuration.
• Invloved in UAT, test plans, documentation of test reports etc
• Providing support and modification of scripts if changes in application behavior.

Confidential, IN
Business Analyst Jan 05 - Oct 05

Company Profile: Insurance/Finance

Lafayette Insurance Services, based in Indiana, provides people insurance policies, mutual funds, and credit cards. The goal of the project was to improve the customer experience by not requiring individual entry of all insurance policy and Mutual Funds account numbers, by providing access to new Mutual Funds and insurance products on an ongoing basis, and by providing access to all of their products once a product has been enabled. As a result, it would reduce current customer complaints about having to request each policy and account individually.

Technology: Rational Rose, Requisite, Rational Clear Case, Visual Studio, RUP, MS Office Suite, Mercury, Load Runner.
Roles: Business Analyst

• Created the performance test plan in accordance with meetings with developers, Business Analysts and the network IT teams.
• Prepared interview questionnaires for the users and gathered requirements.
• Used UML and RUP methodology to analyze and translate business requirements into system specifications.
• Developed use case scenarios, sequence diagrams, and class diagrams.
• Documented project plans, process flow, timelines and other requirements.
• Conducted communication results and milestone achievements for every iteration.
• Managed all the requirements in Rational RequisitePro, making requirements available to all team members
• Documented timely reports using Test Manger, Rational Clear Quest.
• Created test cases to check the functionality of application.
• Involved in UAT to confirm that the system under test meets the users’ needs and provides confidence in its use
• Gained knowledge in mutual funds