SUMMARY

• Business Systems Analyst professional with over 8+ years of extensive experience in requirements gathering, Analysis and Communication, business process analysis, Solution Assessment and Validation, documenting various project artifacts and Testing/Maintenance operations.
• Excellent domain knowledge and experience in Finance (Mortgage, Loan, Insurance), Investment Banking, internet banking/web applications.CRMSales .
• Experience in analyzing the business requirements for Enterprise Resource Planning (ERP) software and coordinating with the ERP development team.
• Proficient in leading Requirements Gathering process via different elicitation techniques such as client interviewing, requirements workshops, Interface Analysis, Prototyping, Survey/Questionnaire, Focus groups, job shadowing, document analysis.
• Experience conducting Joint Application Development (JAD) sessions for deriving functional/non - functional requirements.
• Extensive experience in Business Process Modeling using Visual modeling tools.
• Experience in conducting GAP, Impact, SWOT, SIPOC, Cause & effect, Root cause, Cost benefit, Feasibility, Risk, ROI analysis tools and techniques.
• Extensive experience in UML Modeling like Activity Diagrams, Sequence Diagrams, Use case Diagrams, Process work Flow Diagrams, Interaction overview Diagrams, Timing Diagrams and Class Diagrams.
• Expertise in creating project artifacts such as Business Requirements Document (BRD), Use Case Documentation, Requirements Traceability Matrix (RTM)
• Business Rules Spreadsheet (BRS), Functional Requirements Document (FRD), Data Mapping Document, Systems Requirements Specification (SRS) and GUI Mockup Screens.
• Extensive experience in understanding the business process functionality and to translate them to System Requirement Specifications
• Professional experience of all phases and methodologies of System Development Life Cycle (SDLC) including Waterfall, Agile/ Scrum, RUP.
• Extensive implementation Knowledge of Data Warehousing, OLAP operations like rollup, drill down, slicing/dicing, pivoting using BI tools.
• Business Intelligence reporting using SQL Server services like SSRS, SSIS, SSAS.
• Expertise in generating DDL, DML and DRL queries in SQL.
• Excellent skills in analysis, design, development, and implementation of ETL and reporting components.
• Involvement in Data /dimensional Modeling, Data Extraction/ Transformation/ Loading (ETL) and Business Intelligence Reporting using Tableau.
• Coordinated with architects in various architectural designs like conceptual design and logical design.
• Extensively interacted with the designers, developers to ensure functional implementation of business requirements and QA Team in executing Test Plans &, Test Case scenarios.
• Excellent communication, problem-solving, critical thinking, conflict resolution, facilitation, and documentation skills
• Proven track record in producing high quality work under tight deadlines and in multi-tasking to meet business goals

TECHNICAL SKILLS

Modeling Tools: Rational RequisitePro, HPALM, UML, MS Visio, BPMN, Rational Rose, Rational Clear Case

Methodologies / Frameworks: RUP, Agile/Scrum, SDLC, Waterfall.

Database: MS SQL Server 2012/2008/2005, MS Access.

BI Reporting Tools: Tableau, Microstrategy, Crystal Reports, Cognos 10 (report & Query studio), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microstrategy reporting system.

ETL Tools: Data stage, Informatica, IBM Cognos.

QA Testing Tools: HP QC, JIRA, Load Runner, MS Test Manager 2013

Documentation Tools: MS Office Suite, SharePoint 2010/2013

Data Warehousing: Data Marts, OLTP, OLAP, ROLAP, DOLAP, MOLAP, HOLAP, Query/Reporting, Multidimensional Analysis, Data Mining, Slicing/dicing, Drill Down/Roll Up,MDM

Finance: Fixed Income, Pension & retirement, Securities, Mortgage Loans, Mortgage Backed Securities (MBS), Derivatives, Bonds, Mutual Funds, Equities, Sweeps, Swaps, Pricing, Brokerage, Stocks, Bloomberg Data

Project Management Tools: MS Project professional, MS Project Server

PROFESSIONAL EXPERIENCE

Confidential, Hopewell, NJ

Sr. Business Systems Analyst

Responsibilities:

• Worked on 401K plans portfolio determinant criteria and other asset management procedures.
• Acted as a liaison between management and DW development team.
• Extensively interacted with data analysts during the ETL operations in identifying the source files/databases from OLTP systems and implementing the transformation logic for achieving data uniformity in operational data store (ODS)
• Involved in data staging design & development, application specification/development.
• Used various SQL commands like Create, Delete, Update, and Inner, Outer, Left, and Right Joins to update the database and retrieve data for data analysis and validation.
• Coordinated with the DW architects and developers to identify appropriate dimensional modelling (identifying dimensions/facts/referential integrity), measures (additive/semi-additive/non additive), and sizing (in terms of number of columns, records per dimension and fact table).
• Facilitated JAD sessions with focus groups, requirements workshop, Interface analysis, Prototyping and formal meetings to effectively understand the analytical reports needed by the internal clients.
• Used Mockup screens to convey the look and feel of the GUI screens for the end users to developers.
• Conducted SWOT, SIPOC analysis to identify the areas of improvement and Gap analysis, to understand the current business process flow and target business process flow and identifying the potential solutions to bridge the gap
• Business Requirements Documents (BRD), System requirements specifications (SRS).
• Successfully identified the functional/non-functional requirements of the data warehouse for generating BI reports and communicated the same to architects and developers.
• Involved in identifying and suggesting the different dimensions (slowly changing dimensions/rapidly changing dimensions) required for generating the reports.
• Established OLAP cubes to facilitate the multi-dimensional view of the data to generate slicing/dicing, roll-up/drill-down reports
• Involved in identifyingthe ADHOC scenarios.
• Extensively interacted with BI application developers for generating and testing the dashboards
• Documented Test Plans, Test Scripts, Log Defects, and Requirements and uploaded to HP Quality Center for future follow up and bug fixing purposes.
• Coordinated the execution of Unit Testing, System Integration Testing (SIT), Performance & Service level testing and User Acceptance Testing (UAT).
• Contributed to project plans as requested by Project manager.
• Used MS Project to create/update WBS, project schedule, deadline, milestones. Used Gantt chart to track and communicate the progress of the project to sales management.
• Coordinated with Project manager, established project priorities by tracking the schedule performance index (SPI), identifying project milestones, Time bound deliverables using Gantt chart, Project plan.
• As part of BA job duties, documented operational/business needs of the end users from a functional area and communicated the business requirements with ERP development team for functional configuration and maintenance of ERP software.
• Established the ERP operational objectives, functional requirements belonging to a functional area and coordinated during development/test/ production environments.
• Successfully established Key performance indicators (KPI) for the ERP application performance measurement in a specific functional area of the organization.

Software/Hardware: RUP/Scrum, Windows 98/XP/7/Vista/8, MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project, Visio, UML, SharePoint 2013, SQL Server Services, Tableau, Cognos, Informatica, Mockup Screens.

Confidential, St. Louis, MO

Sr. Business Systems Analyst

Responsibilities:

• Involved in identifying the problem definition as part of continuous process improvement using Define, Measure, Analyze and Improve to support the business continuity of the organization.
• Gathered business requirements using appropriate elicitation techniques like user observation, brainstorming, client interviewing and document analysis. Conducted JAD Sessions with various stakeholders and project team.
• Established Requirements Traceability Matrix (RTM) using Rational Requisite Pro to trace the completeness of requirements
• Developed high-level and low-level documents like Business requirements documents (BRD), Functional requirements documents (FRD) and System requirements specification (SRS).
• Conducted Business workflow analysis, process analysis, SWOT analysis, cost-benefit analysis and Gap analysis to know the condition of the current system in use.
• Used Unified Modeling Language (UML) to prepare Use Cases diagrams, process flow diagrams, sequence diagrams from the gathered requirements and created diagrams using MS Visio.
• Followed Agile/ scrum methodology.
• As a scrum master coordinated with the Product owner in prioritizing the user stories in the product backlog, facilitated the daily scrum meeting, sprint plan & review meetings at the beginning and end of each sprint cycle.
• Generated Burn down chart and tracked the status of the each sprint cycle for that release.
• Coordinated with Project Manager to create WBS, manage schedules, deadlines, resources and the project tasks using MS Project.
• Involved in Project Management activities like defining / managing project scope, schedule management,
• Creating project plans, tracking and communicating project status, deliverables, and milestones using
• Gantt chart.
• Contributed towards defining Level Of Effort (LOE) and critical path analysis (CPA) using PERT Chart
• Maintained Data Requirement Artifact to identify the characteristic of data type that is entered into the GUI interface
• Coordinated with architects to create test plan & Test cases for system testing.
• Developed the training schedules, user manuals and trained the business/end users.

Software/Hardware: Waterfall/Agile/scrum, Windows (98/XP/7/Vista/8), MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project 2010, Visio, UML, SharePoint 2010, SQL, HTML, XML, Mockup Screen, HPALM, HPQC,SQL server services.

Confidential, Columbus, OH

Business System Analyst

Responsibilities:

• Gained insight about the structure, Business model, and current process workflow of the organization from existing artifacts.
• Performed requirements gathering using both formal and informal sessions through interviews, NetMeeting, questionnaire, video conferencing, JAD sessions and conference calls.
• Analyzed, defined, documented and communicated business requirements to technical architects, developers by interacting with the end customers to meet business partner’s needs.
• Participated in various meetings/discussions, with Product Manager, SME, Lead Business Analyst, and Project Manager, to discuss and consolidate the business requirements.
• Involved in identifying the problem definition as part of continuous process improvement using Define, Measure, Analyze and Improve to support the business continuity of the organization.
• Implemented Unified Modeling Language (UML) to prepare Use Cases diagrams, process flow diagrams, sequence diagrams from the gathered requirements and created diagrams using MS Visio.
• Facilitated creation of “as-is” and “to-be” business Process Flow using Rational rose/MS Visio.
• Created business requirement document (BRD), Systems requirement document (SRD).
• Successfully documented functional/ non-functional requirements.
• Created use cases, user stories, product documentation, user manuals and developed mockup screens to communicate GUI design with web app developers
• As a scrum master coordinated with the Product owner in prioritizing the user stories in the product backlog.
• Tracked the performance and progress of each sprint cycle with burn down chart identified burn down velocity
• Facilitated the daily scrum meeting, sprint plan & retrospective meetings at the beginning and end of each sprint cycle.
• Lead the daily scrum meetings and identified the impediments faced by team members and updated competed tasks on a day to day basis.
• Communicated the feedback by other stakeholders from scrum framework meetings to the scrum team.
• Coordinated with Project Manager to create Work break down structure (WBS), manage schedules, deadlines, resources and the project tasks using MS Project.
• Participated in solution design sessions with the leads, designers and developers.
• Involved in defining project specifications and implementation plan.
• Involved in user acceptance and functional testing.
• Responsible for identifying issues and recommending changes in the application.
• Created consolidated status reports for the client and demonstrated the changes made.

Software/Hardware: waterfall/Agile/scrum, Windows 98/XP/7/Vista/8, MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project, Visio, UML, SharePoint 2010, Mockup Screens, HPQC, Rational RequisitePro, SQL/ SQL Server Services.

Confidential

Jr. Business Analyst

Responsibilities:

• Gathered Requirements Via formal meetings, brainstorming, interviewing and conducting JAD sessions with business users and subject matter experts (SME’s) in focus groups.
• Analyzed and documented the “as-is” business process work flow and “to be” business process work flow using MS Visio.
• Conducted Gap analysis of the current state of the system and future state of the system, SWOT analysis to identify the areas of improvement and feasibility analysis of the proposed solution.
• Performed Requirements modeling using UML diagrams like sequence diagrams, state diagrams, use case diagrams, Activity diagrams, flow charts
• Generated Mockup screens of Graphical user interface to capture the front end system requirements to communicate with the web application designers
• Documented various project artifacts, Business Requirements document (BRD), Systems requirements specifications (SRS) including Functional and non-functional requirements, Use case document
• Developed system specifications as needed to support reporting, policy and claims systems.
• Actively involved in Process Management to enable the activities of planning and monitoring the performances of a process.
• Coordinated with database administrators/ SQL developers in improving backend performance by participating in conceptual re-design and logical redesign of the database.
• Involved with database designers in facilitating creation of ER Diagrams, Data modeler diagrams
• Involved in preparing test cases and test scenarios and coordinated with other QA’s in executing the test plans.
• Involved in Project management planning activities of this project Scope management, creating work break down structure, schedule management, stakeholder management using MS Project professional tool
• Communicated directly with Clients to understand their business needs and to resolve business issues.
• This application was developed using Visual Studio.NET, VB.NET and ASP.NET.
• Conducted User Acceptance testing (UAT), beta testing and involved in code review sessions to ensure the functionality of system aligns with the business requirements
• Worked with SQL queries to extract application data to perform application validations.

Software/hardware: Agile/Scrum, Windows (98/XP/7/Vista/8), .Net Framework (VB.NET, ASP.NET), MS Visio, Rational Requisitepro, HPQC, SQL / SQL Server, MSOffice suite, MS Project Professional, Mockup screens, HTML, XML.

Confidential

Business Analyst

Responsibilities:

• Executed SDLC cycle from inception to deployment with regards to testing (Requirement Analysis, Test Planning, Test Cases, Script Development, Test Execution, Test Reporting, Test Result Analysis and Defect Retesting)
• Developed complex SQL scripts to validate data integrity in the application, using various DML and DDL commands.
• Used JIRA to track and follow-up on defects with the QA and developers in different builds.
• Participated in Requirement Review Meeting with Business, Development Team Manager and SMEs. Worked closely with the end users and technical team to ensure best practices in testing methodologies.
• Assisted Sr. QA Manager in conducting informal sessions with testing team to resolve open incidents and issues.
• Create Test Cases to conduct White Box Testing, Positive and Negative Testing of the application.
• Conducted analysis for change requests and requirement walkthroughs and advised concerned Project Managers and Business System Analysts on the impacts of the changes.
• Wrote detailed Test cases detailing the step by step navigation, data input, and expected results, for Load Testing.
• Logged system defects in Rational Clear Quest and tracked the issues identified during Functional Testing.
• Assisted Lead Business Analyst in the creation of Use Case Diagrams, Process Plow Diagrams and GUI designs.
• Gathered functional requirements and created vision, scope, and other artifacts during the inception phase.
• Participated in Business Requirement Definition (BRD) workshops along with clients and Subject Matter Experts.
• Participated in brainstorming sessions on Quality Analysis, Manual and Automated Testing and defect tracking tools.

Software/Hardware: SDLC, SQL, UML, MS Visio, XML, HTML, Windows (98/XP/7/Vista/8), MS Office, MS Project, Rational Clear Case/ Clear Quest,, JIRA .

Confidential

Business Analyst

Responsibilities:

• Created Use Case Diagrams, Class Diagrams and Interaction Diagrams using MS Visio and Rational Rose.
• Prepared Process Flow Diagrams, Mockups and conducted Gap Analysis to compare the current and proposed functionalities of the system
• Designed Meeting Work Plan and facilitated virtual project meetings to validate requirements with the concerned Subject Matter Experts (SMEs) and IT Team during the entire project.
• Extensively used MS Excel (Vlookup, Macros, Pivot Tables, etc.) for data validation and creation of Mock-up reports
• Reviewed test results and prepared Test Scenarios and Scripts for Performance, Usability, and Regression Testing.
• Conducted JAD, RAD and Interview sessions with the management and users to gather and communicate business requirements and understand the problems and challenges.
• Developed Business Case Document highlighting the need for a new system and its impact on the project scope.
• Conducted requirements gathering sessions with the business user to collect Business Requirements, Data Requirements, and User Interface Requirements.
• Managed UAT Testing and developed and reviewed QA Test Strategies and Test Plans for appropriate test coverage.
• Incorporated Rational Unified Process (RUP) to create Business Requirement Specifications using MS Visio.
• Analyzed and mapped the As-Is business processes, compared them to the To-Be state to define the Gap, and then created new Process Flow Diagrams.

Software/Hardware: MS SharePoint 2007, MS Visio, MS Project, Rational Rose, Rational Requisite Pro, Windows 2000/XP, MS Visual Studio 2008, MS SQL Server R2, UML, Agile, RUP, Oracle 10g, LoadRunner 9.10, Siebel Web 8.0.