SUMMARY:

• 7+ years of industry experience as a Business/Data Analyst in banking and insurance companies, and possess excellent communication, analytical, and presentation skills. Experience working with the business users as well as the senior management for web based environment, and client server applications.
• Proficient with methodologies like Software Development Life Cycle (SDLC), Project Management Methodology (PMM), iterative Rational Unified Process (RUP), and Rational Tools used in different projects.
• Experience in conducting joint application development (JAD) sessions for requirements gathering, analysis, design, and effectively conducting meetings, and brainstorming sessions.
• Conducted JAD sessions for communicating with the Project directors and stakeholders.
• Excellent analytical skills to understand the business process requirements, and translate them to system requirement specifications (SRS).Expertise in using Microsoft Visual Studio Team System for requirement management and work item tracking
• Extensive experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document (BRD), Functional Requirement Document (FRD),Software Requirement Specification (SRS) across the deliverables of a project.
• Proficient in developing use - cases, workflow diagrams, sequence diagrams, and activity diagrams through the use of MS Visio, and Rational Rose.
• Experience in conducting Gap analysis, cost benefit analysis, and risk analysis.
• Performed software testing involved Quality Assurance (QA) testing, development of test cases & test scripts, and user acceptance testing (UAT).
• Highly proficient in working with users to gather requirements, analyze them and subsequently use the Rational project and design tools to model the requirements.
• Good knowledge of relational database management system.
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Store 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.
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server 2000.
• Expertise in process modeling using UML, (Use Cases, Sequence Diagrams, Activity Diagrams, Class Diagrams and Data Modeling).
• Good knowledge of Web Services, SOAP programming, WSDL, XML technologies DTD, SAX and XSLT
• Experience testing implemented systems and system changes including liaising with QA teams to develop test cases, test plans, test scenarios, and generating test data; and conducting manual testing (regression, end-to-end, functional)
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development
• Excellent skills, facilitation, power point presentations, maintaining performance metrics, devising documentation & communicating to users.
• Experience managing, tracking and reporting test status; report metrics.

AREAS OF EXPERTISE:

Operating Systems: Windows 95/98/2000/XP,UNIX

Business Modeling Tools: MS Office Suite (Office, Excel, PowerPoint, Access, Project), MS Communicator, MS Groove, MS Visio, Rational Rose, Rational RequisitePro, IBM Websphere portal

Testing Tools: Win Runner, Load Runner, Test Director

Languages: SQL, UML, C, ASP.Net, VB.Net

Databases: MS Access, MS SQL Server, Lotus Notes

Methodologies: Unified Modeling Language (UML), Rational Unified Processes (RUP), Rapid Application Development (RAD), Project Management Methodology (PMM)

SUMMARY OF EXPERIENCE:

Confidential, Salem, OR

Sr. Business Analyst

Responsibilities:

• Conducted business analysis, acted as a liaison between project manager, business users’, & IT team, and used MS Office for the documentation.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc
• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.
• Prepared documents for business requirements document (BRD), systems requirements specification (SRS), high level design documents (HLDD), and traceability mapping / matrix with the assistance from the business group, and the IT team members.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• 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.
• Created workflow diagrams, and flowcharts using MS Visio, which were used to diagrammatically represent the process of placing a request and getting approved or rejected.
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Analyzed the requirements of data marts. Worked with business users to understand their reporting requirements, worked with Reporting team to develop report prototypes, demonstrated report prototypes to the business users, came up with FRDs for the data
• Designed and developed Use Cases using UML and Business Process Modelling.
• Extensively involved in the automation of Regression Test Cases by scripting.
• Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams and Sequence Diagrams in Rational Rose.
• Created business use case, user requirement document (URS), functional (FRS) and technical documents for trading system.
• Responsible for identifying and documenting business rules and creating detailed Use Case.
• Created test cases to test the liability,comprehensive,collision coverages.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets

Environment: IBM Lotus Notes database, IBM Lotus Notes email client, Oracle, IBM Websphere, IBM NetConnect, Cisco WebEx, AT&T dialer, Visual Studio, SQL, Windows XP, MS Office 2003, MS Visio, MS Communicator, Functional Point Analysis, ASP.Net, HTML, XML.

Confidential, Peoria, IL

Business Analyst

Responsibilities:

• 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).
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models
• Facilitated joint application development (JAD) sessions acting as a facilitator between various teams.
• Implemented requirement gathering & management using Rational RequisitePro, and business intelligence tools.
• 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.
• Helped IT developers design the service-oriented architecture (SOA) for the application based on the available resources, and the business requirements.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Develop, build and manage Reporting Services (SSRS) reports using both SSAS cube and relational database sources including distribution of reports using subscription services
• Performed manual testing, including validation interface messages on each new build before delivering to quality assurance team
• Created workflow diagrams, flowcharts, activity diagrams, and use-case diagrams using MS Visio.
• Substantial report development experience utilizing SQL Server Reporting Services (SSRS), Cognos Impromptu, and Microsoft Excel
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Analyzed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Implemented change management requests within the RUP environment.
• Assisted in developing test scenarios, test scripts and test data to support unit and system integration testing.
• Involved in testing of the system to check it satisfies functional specifications.

Environment: MS Visual Studio 2003, MS Visual Source Safe, Business intelligence, Visual Studio, Crystal Reports, Windows XP, UNIX, SOA, SQL Server 2003, SQL LOADER/CONRTOL FILE, Oracle, ASP.Net, VB.Net, HTML, CSS, XML.

Confidential, Overland Park, KS

Business Analyst

Responsibilities:

• Conducted detailed and comprehensive business analysis by working with end users, and other stake holders to identify the system, operational requirements, and proposed enhancements.
• 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.
• Configured the Data mapping between Oracle and SQL Server 2005.
• Gathered business requirements from business users such as insurance policy managers, and drafted business requirement specification (BRS).
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Identified all necessary Business and System Narrative Use Cases from requirements, created UML diagrams including Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using Microsoft Visio.
• 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.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Performed initial manual testing of the application as part of sanity testing
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Developed reports including line and pie charts, trend analysis and sub-reports using SQL Server Reporting Services (SSRS).
• Assisted in developing test scenarios, test scripts, and test data to support unit and system integration testing.
• Involved in testing of the system to check it satisfies functional specifications.

Environment: Rational Rose, Requisite, Rational Clear Case, Visual Studio, Oracle, Feasibility Analysis, Risk Analysis and Gap Analysis, RUP, Business intelligence or BI, UML, SQL, UNIX, MS-Office, MS Project, MS Visio, ASP.Net, VB.Net, HTML, CSS, XML

Confidential, Cincinnati, OH

Business Analyst

Responsibilities:

• Conducted user interviews; gathered, and analyzed operational requirements in consultation with traders, developers, and end users using Requisite Pro, and the business requirements were in compliance with Sarbanes Oxley Act (SOX).
• Supported feasibility analysis study in terms of technical, and economical feasibility.
• The project requirements for cash management practices adhered to accounting principles or GAAP.
• Worked with risk management tools for mortgage loan servicing, commercial & residential mortgage, and risk analytics for MBS.
• 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).
• Identified different risks such as credit risk (default risk), prepayment risk, inflation risk, and market risk.
• Developed & executed several Optimized queries in SQL on this data.
• Tested Performance & Accuracy related queries under SQL Server.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Assisted the IT team to develop service-oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis.
• Worked closely with system developers & architects and assisted them in understanding the various functional and process hierarchies.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• Determined the functional requirements through conducting user interviews and created the business requirement document (BRD) and traceability matrix, and thus develop the standardization of processes.
• Worked as a liaison between the developers and the QA team in creating the Test Plan and Test Cases using Rational Test Manager. Generated test data, and assisted QA team with manual testing whenever possible
• Created class diagram, sequence diagram, and collaboration diagram using MS Visio.
• Supported development team in unit testing by providing the testing data during the User Acceptance Testing (UAT) phase.
• Tracked, and managed the requirement changes using Requisite Pro.

Environment: Rational Requisite Pro, Rational Rose, Business intelligence (BI), MS Visio, MS Excel, RUP, service oriented architecture (SOA), data mining, ASP.Net, VB.Net, HTML, Visual Studio, CSS, XML MS SQL, data warehouse, ETL, Informatica, Cognos, MS SQL server 2000, Oracle Financials.

­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­ Confidential, Biloxi, MS

Business Analyst

Responsibilities:

• Worked with project manager, traders, and other stakeholders to define project scope, plan, and requirements.
• Conducted user interviews; gathered, and analyzed operational requirements in consultation with traders, developers, and end users using Requisite Pro.
• Captured requirements with the use of Bloomberg, Charles River trading system, and Compustat to analyze market data, and fundamental data.
• Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
• Moreover, I also authored functional requirements documents FRD by interacting with development team for improving client’s legacy system.
• Identified risks involved for the desire project such as market risk, inflation risk, credit risk, and default risk. Supported SOA, data warehousing, data mining, and Enterprise Service model standards in designs, and developed standardization of processes like configuration management.
• Cash management practices were implemented in the project for automated clearing house, sweep accounts, and balance reporting services.
• Involved in setting up different configuration environment for compatibility testing and manual testing.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Involved in decision making of converting manual test cases into automated test scripts and analyzing their life time and time required to update the scripts.
• Developed timelines for project delivery, and managed projects and resources to successful completion.
• Worked with IT team to map sources and targets, populating the data warehouse, extracts and loads, monitoring the timing of loads, validating and testing the loaded data using ETL process.
• Generated SQL queries to develop risk reports.
• Performed gap analysis by identifying existing technologies, and subsequently, documented the enhancements to meet the end state requirements.
• Tracked changes through change management, and bugs tracking using Rational ClearQuest.
• Assisted with users’ testing of systems (UAT), and developed & maintained quality procedures.

Environment: MS Access, MS Excel, MS Word, MS PowerPoint, Cognos, Calypso fixed income solution, data warehouse, Oracle, Visual Studio, MS SQL, SQL LOADER, UNIX,RUP, Requisite Pro, Web Sphere, Java, J2EE.