SUMMARY:

• Overall 7+ years of industry experience working as a Business Systems Analyst in various domains like Banking, Finance, Healthcare, Insurance and retail.
• Strong knowledge & understanding of industry standard methodologies including Software Development Life Cycle (SDLC) and Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP) and Agile Methodology.
• Subject matter expertise in Risk Management (Market and Credit), Fixed Income and Derivatives, Emerging Market, Equity Market, Fixed Income Market and Money Market
• Expertise in gathering, analyzing, defining and documenting end user business requirements and system requirement specifications.
• Expertise in planning and development of Test Plans, Test Cases and Test Scenario to meet product’s business requirements.
• Strong Knowledge on MS Office, MS Visio, MS Project, and MS Access
• Designed Use Cases, Activity Diagrams, Sequence Diagrams, Class Diagrams.
• Expertise in working with Business Processes, Business Process Models, Business Flow Diagrams and Business Requirement Documents.
• Extensive knowledgebase of market Risk and credit Risk and reference data including client and securities/instrument data, product, and pricing
• Strong expertise in business process mapping tools and techniques.
• Extensive experience with modeling tools and techniques like Unified Modeling Language (UML), use case diagrams, sequence diagrams, activity diagrams, class diagrams, As - Is and To-be diagrams etc.
• Assisted with training and procedure modification.
• Thorough proficiency in using the tools like Business Modeler, MS Visio, MS Office, Rational Suite including Rational Rose, Requisite Pro, Rational Software Modeler, etc.
• Strong knowledge in using Microsoft Office products such as MS Visio, MS Word, MS PowerPoint, MS Excel.
• Profound knowledge of creating SQL Queries used for database administration
• Experience in generating and maintaining data security policies and procedures.
• Masters in Software Engineering with experience in the development, implementation and integration of strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills.
• Thorough proficiency in Customer Relationship Management (CRM) in order to meet customer expectations.
• Efficient in translating Business Requirements into Functional and Non Functional requirements.
• Expertise in Creating and maintaining the requirement documentation like system use cases, supplementary specification documentation, and business glossary as per the industry standards.
• An effective team player recognized for having excellent communication and presentation skills.

TECHNICAL SKILLS:

Tools: Microsoft Office Suite (Word, Excel, Power Point, Project, Access), Outlook, Microsoft SharePoint, MS Exchange, IBM Lotus Notes

Analysis Tools, Techniques: RUP, UML, Object Oriented Analysis, Rational Rose, Visio, Rational Requisite Pro, Data Analysis, Data Modeling, ETL Analysis, Dashboard Design, BRM

Testing Tools: Quality Center, Test director

Reporting Tools: Cognos, Crystal Reports, Business Objects

Database: SQL Server, Oracle, Teradata, MS-Access

Data Access Technologies: PL/SQL, Toad, MQ Series, Stored Procedures

Operating Systems: Windows XP, Advanced Server, Windows 2x, Windows NT, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Sr. Business Analyst

Responsibilities:

• Gathered and manipulated data from multiple data sources such as from, external vendors, MS Access databases, Mainframe to create Excel-based reports.
• Understand and articulate business requirements from user interviews and then translate requirements into functional and technical specifications.
• Interacted with SME's ((Subject Matter Experts) of different divisions (Information Technology, Risk and Operations) and established a business analysis and design methodology around the Agile (Scrum) methodology.
• Analyzed the existing system and process gaps in context of new business changes.
• Conducted JAD sessions with management, SME's, Business users and other stakeholders for open and pending issues to develop specifications.
• Collaborated with team members on all documents and kept a central task location for assigning tasks to team members using SharePoint.
• Develop custom macros, queries and user interfaces to create MS Access databases.
• Created Documentation - Analysis reporting, architectural presentations, infrastructure specifications, strategy planning, market Risk analysis, contingency plans for company executives.
• Designed Use Case diagrams, UML diagrams, Sequence diagrams in MS Access.
• Responsible for the completion of projects within specified time and budget dealing with financials, project work flow, change management and dealing with vendor relationships.
• Use below line in Summary "Expert level skills in MS Office products like MS Word, MS Excel, MS PowerPoint, MS Access, MS Excel and MS Project.
• Documented and tracked all product defects with use of SQL (reporting).
• Writing Complex SQL queries and optimizing SQL Queries
• Collaborated with the Project Manager to organize training material and write user manuals
• Conducted Joint Application Development (JAD) sessions with IT groups. Responsible for updating changes in functional specification documents and on-boarding document of each application.
• 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. Tested various sprints using Agile methodology
• Assigned tokens to internal users of applications depending on their roles.
• Developed tables, Views, Stored Procedures and Triggers using SQL Scripting
• Created Impact traceability matrix to depict what has changed in the application and its impacts on various other related applications.
• Carried out queries from customer data base using SQL
• Responsible for providing analytical support in the Design, Development and Implementation of Project.

Environment: Windows, .Net, MS Access, MS Office, MS Exchange, Microsoft Project, PL/SQL, UML and Data Stage, Iterative Process Methodology.

Confidential, Richmond, VA

Business System Analyst

Responsibilities:

• Prepared vision statement document, created initial data model that contained BRD, and translated business requirements to functional specifications.
• Conducted successful JAD Sessions, which helped to develop an architectural solution that met the business requirements, resolved open issues, and accommodated change requests.
• Built Business Process Models; modeled business activities from the conceptual to procedural level.
• Played a substantial role in the process definitions and business and functional requirements elicitation, in an effort to develop a practical technology solution for automating sales methodologies.
• Created Flow Charts, Use Case diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams to clearly explain the requirement and processes involved.
• Engaged with QA team to develop test plans, test cases, test scenarios and test data analysis.
• Involved in Functionality and Regression testing during the various phases of the development and conducted the final User Acceptance Test (UAT) and usability testing.
• Produced deployment document for major releases and hotfixes by understanding and eliciting the technical/business requirements and dependencies from different functional groups and successfully executed the deployment.
• Monitored client expectations through client involvement and communication throughout the lifecycle of the project; educated clients and stakeholders on the benefits and risks associated with the project.
• Evaluated the Rational Comprehensive Approach of software development, featuring seamless integration between tools, services, and best practices, and enabled the project to successfully deliver high quality software that meet or exceed the desired business benefits.
• Demonstrated an ability to understand and write web service calls at backend. Environment: HP Quality Center (HPQC), SQL, Agile/Scrum, Lucid Chart (Macintosh OS mockup), MS Visio, MS Project, MS Access, MS Outlook, Java, Oracle, Requisite PRO, HTML, DHTML Worked with MS Access for the arrangement of the customer data

Environment: Windows, Microsoft Office (MS Word, MS Excel, MS PowerPoint, MS Visio), MS Access, PL/SQL, and GAP Analysis, Quality center.

Confidential, Jacksonville, FL

Business Analyst

Responsibilities:

• Documented As-Is processes, To-Be processes and identified gaps by conducting Gap Analysis, and documenting impacts to different groups and systems.
• Used the Office Suite extensively which included MS Word, MS Excel, MS Access, MS Project, MS Visio for various documentation and analysis reports
• Developed the Requirements Management Plan and gathered user and business requirements through open-ended discussions, prototyping and guidance of the compliance department and work environment.
• Execute data processing, analyzing data, prepare reports using Excel, Access and PowerPoint and SQL. --Create dashboards, scorecards, data dimensions, canned reports to support key business tracking performance
• Conducted JAD Sessions with Infrastructure management team, SME, policy holders and stakeholders for issues which were open and pending.
• Conducted brainstorming sessions with Infrastructure/ SRMS project groups.
• Collected Business requirements through interviews with already enrolled policy holders, SMEs, surveys and observations.
• Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering)
• Created and performed automated (SQL-based) report scrubbing to improve operational efficiency to define requirements and executing to delivery.
• Documented Business Requirement Documents (BRDs).
• Wrote User Requirement Specification Document (URS) and Technical specification documents, used Rational Requisite Pro in managing requirements
• Created State Transition Matrix to describe changes in various states of each phase.
• Gathered requirements for the listed options Risk management system, specifically for index options Risk management spreadsheet. Defined requirements for product control and Risk management end of day feeds.
• Educated clients team and stakeholders on the benefits and Risks associated with the project.
• Developed and executed test cases, test scenarios and followed-up defects using Quality Center.
• Validated Requirements in Developers environment as well as production environment and documented the results.
• Worked closely with both the teams of Developers and Production to make sure the proper understanding of requirements and changes.
• Maintained project modules in Clarity which included resource schedules, project plans, status reports, and Risks/issues management
• Used SQL Server to write queries, procedures to insert, update, select and delete data from database.
• Executed manual scripts during regression testing phases.
• Performed manual front-end testing to ensure that all functionalities of enhanced application behaved as per the business process.
• Communicated with SRMS users regarding expected changes, time frame and downtime of the new Application.
• Participated in bug review meeting with developers and QA team members and updated requirements documents based on feedback from QA team members and developers.

Environment: Rational ClearQuest, Rational Unified Process (RUP), Clarity, Informatica/ Business Objects, MS Access, MS Exchange, UML, MS-Word, Access, RequisitePro, VB.Net

Confidential, Atlanta, GA

Sr.Business Analyst

Responsibilities:

• Complete study and analysis of Revenue Cycle management of the health stream respective to existing billing system, Claims processing, etc.
• Single point of contact wrt the queries of approximately all the twenty five databases that were assigned to me.Used to interact constantly with IT team Finance team and the Business Users related to the Provision Model and changes or enhancements required in the same.
• Gathered requirements from the clients and developed crosswalks for 837 P/I claims.
• Reviewed documentation of the business analyst's in order to ensure its adherence to the requirements.
• Ensured that the timelines for each database, query and enhancement were adhered to and have always met completed the same well before the deadline date.
• Performed testing for Medicare, Medicaid and X-Over claims for Medicaid Management Information System (MMIS)
• Develop MITA Maturity Model (MMM) & Business Capability Matrix (BCM) to identify the maturity level of SD Medicaid Enterprise.
• Develop Conceptual Data Model & Logical Data Model in alignment with MITA Information Architecture.
• After needs assessment, analyzed the Business Requirements Document and System Requirement Specification and documented the requirements in the Rational Requisite Pro.Performed Requirements Traceability and managed changes to requirements for this application using Rational Requisite Pro.
• Worked with developers and designers of BPM System to make sure development understands business process and detailed technical requirements.
• After Executive confirmation did Gap analysis to assess needs that could not be met by core EHR.
• Provided support for the implementation and maintenance of the Version Control tool, Rational Clear Case; and Change management tool, Rational Clear Quest.
• Developed business proposals and RFP responses and trained others in this capability.
• Involved in each phase of SDLC to ensure smooth and proper functioning of the project.
• Held regular meetings with the Development and QA teams and facilitated the team with providing solutions.
• Responsible for Scheduling and Distributing the Testing effort among different Test team members.
• Performed User Acceptance Testing.

Environment: MS Office Suite, MS Visio, Agile - Scrum, Oracle, SQL, PL/SQL, Quality Center, Windows Server 2003, Java, Java Script, Business Objects, QTP, Rational Clear Quest, Rational Clear Case

Confidential, Austin, TX

Business System Analyst

Responsibilities:

• Interviewed business area experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business people and technical people.
• Wrote business requirements, SRS and interviewed portfolio managers and traders to implement a new International Small Cap Long/Short Hedge Fund. The hedge fund seeks to take long positions in undervalued and under-followed international equities. Mapped and test data requirements for futures, options and other derivative instruments into existing trade order management system and back-office accounting.
• Analyzed and reviewed cash flow models for Credit Default Swaps, Interest Rate Swaps, Total Return Swaps, Currency Forwards, Cross-Currency Interest Rate Swaps, Equity options, Structured products, Currency Futures, Options, Exchange Traded Funds (ETFs), and indexes on commodity futures
• Interacted with the SMEs and stakeholders to get a better understanding of client's business processes.
• Identified Use Cases from the requirements and wrote Use Case Specifications document.
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and thoroughly understanding the business processes.
• Involved in designing of the system with the system architecture and the development team by translating the business requirements into a functional specification document.
• Carried out queries from customer data base using SQL
• Gathered requirements for the listed options risk management system, specifically for index options risk management spreadsheet. Defined requirements for product control and risk management end of day feeds.
• Actively involved in conducting reviews, walkthroughs and facilitating in requirement definition workshops (JAD) to confirm and playback business requirements for the project.
• Reported status to project management and project owners on a weekly basis.
• Worked on the data mapping project.
• Monitored client expectations through client involvement and communication throughout the lifecycle of the project.
• Educated clients team and stakeholders on the benefits and risks associated with the project.
• Collaborated with the Development and Testing Teams throughout the SDLC.

Environment: Environment: MS Visio, MS Office, RUP, Agile, Clear Case, Clarity, Clear Quest, UML, Oracle, PL/SQL, Test Director

Confidential, Madison, WI

Business Analyst

Responsibilities:

• Developed functional requirement for Personal Auto and Homeowners for different states.
• Implemented a structured system development methodology with emphasis on Systems Development Life Cycle (SDLC) that dramatically improved productivity and reduced errors.
• Created and documented MS Project & Excel macros usability to automate project resource report generation.
• Performed Gap Analysis for the current and future state of the portals.
• Developed test plans and coordinated with User acceptance testing efforts.
• Requirement analysis, gap analysis and requirement specification for the migrated version of policy admin system.
• Interacted with management, system analysts and technical developers for setting project goals.
• Daily interaction with various system teams, development teams, front office business managers and client service representatives.
• Managed changes using rational clear case, and maintained traceability in MS Excel.
• Participated in Triage Meetings, weekly status meetings with IT and business people.

Environment: Agile methodology, Rational Suite (Rational Requisite Pro, Rational Clear Case, Rational Clear Quest, Rational Rose), Oracle, MS Project, MS office suite, Use case, Test case, SQL Server 2000.