EXPERIENCE SUMMARY:

• 15 years experience in Business Analysis, with excellent knowledge and experience of Data Analytics, Software QA & Project Management.
• Worked on variety of Business & Financial applications including Insurance (P&C), Digital Asset Management, Banking (Retail & Commercial), BI & Data Warehouse, Brokerage, Mutual Funds, Asset & Wealth Management, Telecom, e - commerce and OLTP applications.
• Extensively worked on integration and implementation projects of third party vendor applications including Guidewire, SharePoint, SAP, AEM, Salesforce.com, Amdocs Ensemble and Infrastructure upgrade projects.
• Extensive experience of Requirement gathering, and writing Business Proposals, Project Charters, Project Plans, Business Requirement, Functional Requirement, Use Cases, User Story Cards, Epics, Product Backlog, Sprint Backlog, Process Flows, Data Flow Diagrams, Activity Diagrams, Sequence Diagrams, Flow Charts, User Guides, Wireframes, UI Mock ups, Change Requests, Test Plans, Test Cases, and Summary Reports.
• Vast experience of various techniques to gather requirement including, Brainstorming Sessions, SME’s and Users Interviews, Survey Questionnaires, Examining Problem Reports, Requirement Workshops, Document Analysis, Reverse Engineering, and Prototyping.
• Extensive experience of working with Business partners, Project Stakeholders and Organizing, Facilitating and Moderating Requirement Review sessions, JAD sessions, Project Planning and provide Communication support to Project Stakeholders.
• Strong experience and ability to define and develop Business Rules, Data Conversion Process, Data Integration Process, Business Process Models, Workflows, Impact Analysis, Risk Analysis, Data Analysis, Gap Analysis, Change Control, ETL Mapping, and conducting Business and Technical presentations to project stakeholders.
• Vast experience of Business Analysis and Acceptance Testing of Web-based, Client-Server, Mobile and Mainframe Applications.
• Solid experience of various type of testing including Functional, Integration, Data Integration, Data Conversion, System, Exploratory, Regression, and User Acceptance Testing (UAT).
• Extensive working knowledge and experience of UML/RUP for modeling views in Rational Rose, and Microsoft Visio.
• Strong knowledge and working experience of Waterfall, Agile/Scrum, DevOps, RUP methodologies; System Development Life Cycle (SDLC), Project Management Life Cycle (PMLC), and Defect Management.
• Strong skills on Database Analysis, PL/SQL Programming (Stored Procedures, Triggers, Packages) and writing complex SQL queries on Oracle, Teradata, PostgreSQL, Sybase, SQL Server and DB2 Databases.
• Excellent Scripting & Troubleshooting experience on Linux, Unix, AS400 and Windows environment.
• Excellent knowledge of standard CMMI and ISO processes required for Software Development and Process Improvement.
• Excellent analytical and problem solving skills, self-motivated, adaptable and detail-oriented.
• Strong team player with excellent interpersonal, communication and team building skills.

TECHNICAL SKILLS:

Projects Design Methodologies:  Unified Modeling Language, Use Case Development

Business Modelling Tools:  BPMN, MS Visio, Axure, Power point

Requirement Management Tools:  Rational Requisite Pro, Lotus Notes, Clear Case, Clear Quest, TestLink, Rational DOORS

Defect Management & Monitoring Tools:  Quality Center ALM, Rational ClearQuest, Team Track, Trac, HTTP Watch, App Watch

Operating Systems:  OS/400, OS/390, Unix (Solaris 8,9,10), HP-UX, Windows Server 2003/2007, Windows NT4.0/XP, Vista & Linux 5,6,7,8,9

Hardware:  Sun, HP, HP Integrity VM, AS/400, RS6000, IBM mainframe S/390 and Pentium-based Micro Computers from IBM and Compatibles

Databases:  ORACLE 8, 8i, 9i, 10g, 11g, Teradata, PostgreSQL, Sybase, SQL Server, DB2, MS Access

Packages/Tools/Utilities:  MS-Office including MS-Word, MS-Excel (Pivot tables, Macros & VLOOKUPS), PowerPoint, MS-Project, MS Visio, MS Outlook, Tableau, MSBI, PVCS Version Manager, TOAD 7.6, SQL Navigator 4.5, Visual Basic, Adobe Acrobat, FoxPro, Client Access, Lotus Notes/Domino, ODBC etc.

PROFESSIONAL EXPERIENCE:

Sr. Business Analyst

Confidential, Bloomington, IL

Responsibilities:

• Worked with business partners, Subject Matter Experts (SME’s) and third party vendors to review and gather requirement, wrote Business requirement, Business Rules using GOSU code, User Stories, Epics, User Guides, Process Flows, Wireframes, UI mock ups, Functional requirement, Data Mapping, Requirement Change Notifications (RCN’s), Use Cases for Web-based and mobile Applications of State Farm.
• Worked on Confidential, Enterprise Claims Services (ECS), Auto Quote & Purchase (AQP-C), (AQP-SA Salesforce Integration), P&C Rating Engine, and SharePoint 2010 migration projects and performed Business Analysis and Project Coordination activities including Requirement gathering, and writing Business Proposals, Project Charters, Project Plan, Business Requirement, Functional Requirement, Gap Analysis, Change Control, Data Mapping, ETL Mapping, Use Cases, Epics, User Story Cards, Backlog Refinement, Product Backlog, Sprint Backlog, Process Flows, UI Mockups, UAT Test Plans, UAT Test Cases and Data Conversion Test Cases.
• Validated requirements and design by reanalyzing the scenarios with business sme’s (P&C underwriters and agent representatives) and stake holders. Routed Business documents to all the Stakeholders for Review, Authorization and Sign-off.
• Worked as a liaison between business partners and technical teams for Product Modeling and opening Risk, Issues and Dependencies.
• Facilitated and moderated Daily Scrum meeting, Project Sync up meetings, Design review meetings, Sprint planning sessions, Showcase sessions, Defect triage meetings, Projects Backlog Sessions, CMRB meetings, Go/No Go meetings, Lesson learn meetings for various ongoing projects.
• Analyzed and updated Requirement Changes, Created Business Process Models, Use Cases, User Acceptance Test Cases, Data Conversion Test Cases, Requirement Traceability Metrics, Status and Summary Reports.
• Created and updated Business related document and Project Deliverables on Lotus Notes and SharePoint Project Repositories.
• Worked with Testers, Developers, End-users and performed various type of testing including Data Integration testing, Data Conversion, User acceptance testing, Exploratory testing, Regression testing, and Telematics testing (DSS products In-Drive, OnStar, Self-Report).
• Created Repositories on TestLink and performed Requirement Management activities on TestLink.
• Worked with Trac Management team, created Trac instances for various projects, and Monitored Defect Management activities on Trac.
• Coordinated with Offshore team, reviewed work completed by Offshore, resolved issues and queries raised by Offshore and updated Offshore Communications Logs.
• Facilitated “Coordinated onsite System testing activities” including Web Analytics, XML, SFPP, Common Payment System (CPS), CWF, Activity/Pro+, and NECHO Streaming.
• Worked on Data Analytics, Data Visualization, and Dashboard Maintenance to Analyze States-wide KPI’s and Business trends.
• Performed PL/SQL Code Analysis, and wrote complex SQL queries on Oracle, DB2, Teradata, IMS, SQL Server and PostgreSQL databases to validate database integrity, Test data extract and Data Analysis.
• Worked on special assignments (e.g., work with Business Partners on framing-out a new business concept for the company).
• Resolved production issues (tickets and incidents) by reproducing the incidents locally and resolving them using HP Service Manager.
• Conducted reviews and Inspections and ensured that project activities allow Applications to meet business requirement and system goals, fulfill end-user requirements, and identified existing or potential issues.
• Communicated progress, results, and other project related information to all the project stakeholders.
• Worked with Process Improvement team to implement industry’s best Business, QA, and Development practices in State Farm.

Environment: J2EE, DB2, PostgreSQL, Teradata SQL Assistant, TOAD, Sybase Central 6, Salesforce, BPMN, Tableau, SQL, MSBI, T-SQL, Clear Quest, Clear Case, ReqPro, Selenium, HP-Unix, HP QC/ALM, Office 365, Jenkins, Windows Server 2007, Citrix, GOSU, AS/400, JCL, SAS, DataStage 9.1, Cognos 9.5, Primavera P6, Splunk, Power Point, MS Visio, MS Project, Windows XP/7, Lotus Notes, C#, HTML, XML, Java Script, TestLink 1.9.3, Trac, SharePoint, WebSphere MQ, HTTP Watch, App Watch

Business System Analyst

Confidential

Responsibilities:

• Gathered, defined and organized business and functional requirement, documented the functional requirement using agile scrum project methodology (i.e. Epics, User Stories and Prioritizing the Product Backlog, Sprint Backlog)
• Worked with internal business stakeholders, provided them subject matter expertise and business solutions that satisfy business sponsors and stakeholder needs.
• Worked on configuration capability (Screen/UI, application settings or parameters, and Business Rules) using Confidential .
• Extensively worked with Guidewire technical integration team to define high level design (HLD), low level design (LLD), end-to-end functionality, and flow of Auto and Home insurance applications of Aviva Canada.
• Developed interface specification documents using signed-off requirement including application requirement, process flow, data and interfaces.
• Facilitated and organized Requirement review, Design review, Data mapping, Test cases review and Defect triage sessions.
• Collaborated with Test leads and Testers to review Test plan, Test Strategy, Functional Test cases, UAT Test Cases and Defect reports.
• Worked on Estimates, Business impact analysis, and Risk analysis on all the phases of Confidential Integration and Change control process.
• Executed the Business acceptance test cases ensuring the full coverage of the requirement as per Functional specification document, and Change request.
• Executed SQL queries to retrieve data from data files to ensure data mapping.
• Performed all the Requirement Management, Test management, and Defect management activities on HP Quality Center.
• Analyzed System and Acceptance test results prepared Summary reports, Defect reports and Status reports.

Environment: J2EE, SQL Server 2005, Oracle 10/11g, DB2, Unix AIX, Solaris, MS Visio, MS Project, Windows Server 2003, Citrix, Windows XP/Vista, VB.Net, C#, VB6, HTML, XML, VB Script, SharePoint, HP Quality Center, Rational Clearcase Loadrunner 9.0, Quality Center 9.0, QTP 9.2