PROFESSIONAL SUMMARY:

• A Business System Analyst with admirable analytical and logical skills, possessing experience in the Property and Casualty Insurance, Banking and E - Commerce industry whilst emphasizing on Business Analysis, Business Process Analysis & Modeling, Data Analysis, Data Modeling and End User Documentation, in Waterfall and Agile-Scrum application development projects. Analytical and astute problem solver with commendable comprehension skills that have expedited adaptation to new environments.
• An overall experience of around 8 years as Business Analyst and a Business System Analyst in the IT industry.
• Extensive knowledge, expertise and involvement in various phases of Software Development Life Cycle (SDLC) in Waterfall, Scrum, Agile (Extreme Programming, Test-Driven Development).
• Experience in working in regulatory driven projects under National Association of Insurance Commissioners (NAIC), Fair Access to Insurance Requirements (FAIR), Department of Insurance (DOI) and Joint Underwriting Association (JUA).
• Involved in projects that are complaint with the Fair Credit Reporting Act (FCRA), Check 21 Act and also Fair Debt and Collection Practices Act (FDCPA).
• Skilled in conducting and facilitating Requirement Gathering Activities to gather SMART (Specific, Measurable, Attainable, Realistic and Timely) requirements using diverse elicitation techniques including but not limited to, Interview, Requirement workshops, Prototyping, Survey/Questionnaire, JAD sessions and Brainstorming.
• Proven success in Eliciting Requirements, Impact Analysis, Cause and Effect, GAP Analysis, As-Is and To-Be Analysis, Risk Assessment, ROI Analysis and SWOT Analysis.
• Exceptional writing and documentation skills in creating, modifying and analyzing Business Requirement Document (BRD), Functional Requirement Document (FRD), Systems Requirements Specification (SRS), Use-Case Specification, High Level and Low-Level Documents.
• Detailed understanding of preparation of RACI Matrix (Responsible, Accountable, Consulted and Informed) and Requirement Traceability Matrix (RTM) throughout the process to verify adherence.
• Proactively participated in Scrum Ceremonies including Daily Scrum, Sprint Planning, Sprint Review, Sprint Retrospective and Backlog Refinement meeting.
• Experienced in conducting Scrum Training Workshops and User Story Writing workshops to familiarize stakeholders with Scrum process skeleton and concept.
• Well versed with backlog prioritization techniques (MoSCoW, Business Value, Kano, And Technical Risk) and estimation techniques (Planning Poker) to help Product Owner in picking Product Backlog Items (PBIs).
• Thorough understanding of preparation and use of Unified Modeling Language (UML) diagrams including Progress Diagram, Activity Chart, Use Case Diagram, Sequence Diagram, Data Flow Diagram and ER Diagram using MS Visio and Rational Rose to support the system design.
• Well versed with writing SQL queries to integrate and extract data for analysis and reporting. Worthy knowledge of Data mapping and Data Warehousing, also worked on Data Migration techniques using Informatica power center.
• Experience in working with Data Warehousing architecture, implementation approaches, schemas and dimensional modeling. Performed ETL using Informatica to load data into the data warehouse from disparate sources. Admirable knowledge of the OLAP cube and performing operations such as Roll-up, Drill-down, Slice, Dice and Pivot and designing and deploying reports via Tableau and IBM Cognos.
• Assisted the Architects with Data Modeling and also the developers with creating Conceptual and Logical Models.
• Involved in extensive client interactions and converting business functionalities into Service Oriented Architecture (SOA) models across heterogeneous IT environments.
• Experienced in working with Three-Tier Architecture, Client-Side Verification and Server-side Verification, Ajax, Web Services for improved understanding of the business functionality.
• Proactive involvement in scripting the business logic for methods in web services, and also documenting the Web Service Level Agreement (WSLA) by utilizing XML.
• Write and enhance user developer guides, tutorials for APIs, database documentation and other technical deliverables.
• Proficient in design and execution of Test Strategy, Test Plan, Test Scenarios and Test Cases based on the requirements for the applications. Collaborated and monitored Black-Box testing, Smoke Testing, Regression Testing and User Acceptance Testing for verifying and validating the product by using Selenium.
• Thorough understanding of the Graphical User Interface, Wireframes and UI mock-ups using MS Visio.
• Provide structure and support for developers by writing technical documentation, champion good documentation habits and help people focus on the most important things in the document by utilizing MS Visio.
• Thorough understanding of Business Intelligence (BI) and experience in creating interactive, analytical dashboards using Tableau and IBM Cognos for decision making.
• Proficient in Requirement Management, Sprint Planning, Issue Tracking using tools like JIRA, RALLY and HP ALM.
• Proficient in Microsoft office tools like MS Access, MS Excel, MS Word, MS PowerPoint and MS Project.

TECHNICAL SKILLS:

MS Visio, Rational Rose, SmartDraw, Mock: Up Screens

SDLC Methodologies: Waterfall, Waterfall Scrum Hybrid, Agile (Scrum)

Business Skills: Process Modeling, GAP Analysis, Impact Analysis, Risk Analysis, JAD Sessions, SWOT Analysis.

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Data Dimensions.

Project Management Tools: MS Project, MS SharePoint Server

Requirement Management: JIRA, Rally, HP ALM, MS Office, Confluence, ClearQuest.

Testing Tools: HP QC, HP ALM, Bugzilla, Selenium

Reporting/ ETL Tools: Informatica, Tableau, IBM Cognos, MS Excel, Talend

Requirement Management Tools: JIRA, AP ALM, RALLY

Databases: MS SQL Server, Oracle, MS Access

Languages: HTML, XML, SQL, .Net, Java

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, GA

Sr. Business System Analyst

Responsibilities:

• Interviewed Subject Matter Experts and performed extensive Document Reviews to develop a thorough understanding of legacy business processes to aid Business Processes Improvement (BPI).
• Assisted the PO and PM in ROI Analysis, Cost-Benefit Analysis and SWOT Analysis in order to be prepared for potential business and technical risks to the system.
• Identified Business Rules for credit line approval by conducting extensive one to one and focus groups with SMEs.
• Strong understanding of the National Association of Insurance Commissioners (NAIC), Fair Access to Insurance Requirements (FAIR), Department of Insurance (DOI) and Joint Underwriting Association (JUA).
• Analyzed, modified and documented functional and non-functional requirements, process and data requirements which led to the creation of the Business Requirement Document (BRD), Functional Requirement Document (FRD) and helped in transforming them into a complete System Requirement Specification (SRS).
• Identified actors, paths and steps leading to an output and prepared Use Cases, Use Case Narratives and Use case diagrams in order to define interactions and steps to achieve the required functionality.
• Assisted the Technical Lead with analyzing the UML Diagrams like Process Diagrams, Sequence Diagrams and Activity Diagrams using MS Visio in order to analyze and design the structure, behavior and interactions in the system design.
• Helped in analyzing and designing meaningful and innovative mobile, web and IoT products by performing appropriate research and designing User Experience flows.
• Proactively participated in all the Scrum Ceremonies including Daily Scrum, Sprint Planning, Sprint Review, Sprint Retrospective and Backlog Refinement meeting.
• Experienced in conducting Scrum Training Workshops and User Story Writing workshops to familiarize stakeholders with Scrum process skeleton and concept.
• Created SQL queries using Joins, Group-by, Order-by and aggregating functions to join data from multiple tables and also created tables using DDL and manipulated tables using DML. Also used pre-executed SQL queries like Stored Procedures, functions and Triggers.
• Created the Data Mapping document with various transformations including the mapping of Source to Target Data.
• Involved in the design and testing of RESTful APIs to adhere to the OPEN API standards including data elements for both requests and responses. The documentation solely focused on detailing the API behavior.
• Assisted in creating the API documentation using Swagger and communicated it with the developing team.
• Logged and tracked the defects using JIRA and created an error repository to support the QA team in testing, tracking defects and systematically manage defects and bugs.
• Created Deployment Flowchart in conjunction with the development, infrastructure and network teams containing instructions for maintaining the application.
• Performed manual testing for the system, integration and User Acceptance Testing (UAT).
• Assisted in the creation of Test Cases, Test Plans, Test Scenarios and created forward and backward Traceability Matrices. Conducted User Acceptance Testing (UAT) and actively participated and facilitated testing of the system during Smoke Testing, Black Box Testing and Regression Testing. The tools used were HP QC and Selenium.
• Proficient in Requirement Management, Sprint Planning, Issue Tracking using tools like JIRA, RALLY and HP ALM.

Environment: Waterfall-Scrum Hybrid, MS Visio, JIRA, MS Office (MS Word, MS Excel, MS PowerPoint), HP QC, Selenium, MySQL Server 2012, SQL, Swagger, Rally, HP ALM.

Confidential, Hartford, CT

Business System Analyst

Responsibilities:

• Elicited user and business requirements through research, formal-informal sessions, Joint Requirement Planning (JRP) sessions and Joint Application Development (JAD) sessions with SMEs, Teams and Stakeholders.
• Developed a good understanding of business domain knowledge of Personal and Commercial insurance, Policy Sales, Policy Administration and Premium Rating.
• Meticulously researched on the National Association of Insurance Commissioners (NAIC), Fair Access to Insurance Requirements (FAIR), Department of Insurance (DOI) and Joint Underwriting Association (JUA).
• Assisted the Project Manager in creating proposals and project budget allocations and worked on Project Charter and Work Breakdown structure using MS Project.
• Prepared the Business Requirement Document (BRD) and Functional Requirement Document (FRD) also assisted the Project Teams in preparing Software Requirement Specifications (SRS), Software System Design Documents (SSD), User interface Design, designing of the Application Architecture and Database Modeling.
• Expert in tracking and managing the requirements using the Requirement Traceability Matrix (RTM) that controls numerous artifacts produced by the teams and also assisted in handling the requirement churn.
• Thorough understanding of the system developed using the Spring MVC framework, Service Layer and DAOs for implementing filters for list pages as well as advanced search functionality using Hibernate criteria restrictions.
• Assisted in modifying the Mobile Application experience that leverage open technologies like react.js, node, swift2 and Springboot. And also collaborate with the technical team to create designs and test products in an iterative manner.
• Proficient in creating use cases, use case diagrams, workflow diagrams, sequence diagrams, activity diagrams, Entity relationship diagrams and class diagrams using Rational Rose and MS Visio.
• Involved in writing SQL queries in order to achieve the required functionality and generate monthly statistical reports.
• Created SQL Queries to create Data mapping and Data Warehousing. Worthy knowledge of Entity Relationships and User Administration. Also, worked on Data Migration techniques using Informatica PowerCenter
• Extensive knowledge of Data Warehousing architecture, implementation approaches, schemas, and dimensional modeling. Performed ETL using Informatica to load data into the data warehouse from various disparate sources.
• Extensive understanding of the OLAP cube and performing operations such as Roll-up, Drill-down, Slice, Dice and Pivot and designing and deploying reports via Tableau and IBM Cognos.
• Associated with API documentation using Swagger tool and testing of the APIs using Postman.
• Involved in test case preparation and execution in the system environment. Also assisted in Unit Testing, System Testing and User Acceptance Testing (UAT). Also performed Manual testing for System and Integration.
• Ability to effectively diagnose, isolate and resolve complex problems pertaining to data infrastructure.
• Experienced in defect tracking and management using HP Quality Center, Rally.

Environment: Waterfall, Java, Spring 2.5, Hibernate 3.0, JSP, JavaScript, Tiles, CSS, Web sphere 5.1,6.1,7.0, SQL, Apache, MS Office (MS Word, MS Excel, MS PowerPoint), Rational Rose, MS Visio, HP QC, Rally, Swagger, Postman.

Confidential, O’Fallon, MO.

Business System Analyst

Responsibilities:

• Assisted the PM in creating the work breakdown structure and project charter using MS Project.
• Strong understanding of with the Fair Credit Reporting Act (FCRA), Check 21 Act and also Fair Debt and Collection Practices Act (FDCPA).
• Conducted extensive GAP analysis by identifying AS-IS and To-Be process models and process flows. Where, how and how big the GAP to in turn help the Product Owner plan to bridge the gap.
• Elicited requirements involving vast set of interactions with various stakeholders using JAD sessions, Structured Interviews, Process Analysis and Business Rules Analysis.
• The feasibility and scope of the business requirements were analyzed and the dependencies were discovered by interacting with the Management Business Analysts, Subject Matter Expert, Product Owner, Project Manager and Technical Lead.
• Created a Business Requirement Document (BRD) and System Requirement Specification (SRS) by incorporating business, functional, non-functional, data and GUI requirements.
• Created user stories and was a part of the Sprint Planning and Backlog Grooming meetings. Whilst helping the PO to prioritize user stories based on business value.
• Assisted the PO in the prioritization of the Product Backlog Items (PBIs) including the process of breaking down EPICS into user stories using INVEST criteria.
• Appropriately used JIRA for allotting tasks, user story writing, backlog management, issue tracking, user story management and forward and backward requirement traceability.
• Used Oracle Workbench in writing SQL queries using Joins, Group-by, Order-by and aggregating functions to join data from multiple tables and also created tables using DDL and manipulated tables using DML. Also used pre-executed SQL queries like Stored Procedures, functions and Triggers.
• Extensive knowledge of Data Warehousing architecture, implementation approaches, schemas, and dimensional modeling. Performed ETL using Informatica to load data into the data warehouse from various disparate sources.
• Assisted in creating the API documentation using Swagger and communicated it with the developing team.
• Defined the Acceptance Criteria for user stories to perform User Acceptance Testing, Designed the Test cases, Test Plans and Test Scenarios in-order to perform Functional Testing, Smoke Testing and Regression Testing and logged down defects and systematically managed them in JIRA. Performed manual testing for the system, integration and User Acceptance Testing (UAT).
• Performed manual testing for the system, integration and User Acceptance Testing (UAT).
• Used SSIS to map the data in central data repository and created Data Marts for enhanced Data Management and SSRS for generating reports.

Environment: Waterfall-Scrum Hybrid, MS Visio, MS Office (MS Word, MS Excel, MS PowerPoint), JIRA, SSIS, SSRS, Informatica, Oracle.

Confidential, San Francisco, CA.

Business System Analyst

Responsibilities:

• Interacting with the stakeholders in order to perform document analysis and GAP analysis. Also assist the Product Owner and Project Manager in planning the transition.
• Researched on the Fair Credit Reporting Act (FCRA), Check 21 Act and also Fair Debt and Collection Practices Act (FDCPA), for better understanding of the required functionality.
• As a Moderator, facilitated the JAD sessions and conducted interviews with various SMEs, conducted process reviews and policy & procedure reviews to elicit requirements.
• Analyzed and validated the Business Requirement Document (BRD) and Software Requirement Specification (SRS).
• Assisted in analyzing and building the Use Case Diagrams, Activity and Sequence diagrams using MS Visio.
• Assisted Data Modeling process by creating Conceptual and Logical ER diagrams and designing Database Schemas to help development of an accurate Data Warehouse Structure.
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
• Proficient in writing SQL queries using Joins, Group-by, Order-by and aggregating functions to join data from multiple tables and also created tables using DDL and manipulated tables using DML. Also used pre-executed SQL queries like Stored Procedures, functions and Triggers.
• Integrated various OLTP to the OLAP by using Informatica as an ETL tool and used Tableau as a Reporting tool. Whilst maintaining the Bill Inmon and Ralph Kimball Paradigms.
• Worked on Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Performed ETL analysis, designing, developing, testing and implementing ETL process including performance tuning and query optimizing of databases.
• Created the Data Mapping document with various transformations including the mapping of Source to Target Data.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data.
• Used JIRA for allotting tasks, user story writing, backlog management, issue tracking, user story management and forward and backward requirement traceability.
• Effectively involved in using Tableau for effective reporting to provide Business Intelligence (BI) to facilitate expenditure tracking using various matrices critical to decision making.
• Performed API documentation using Swagger tool and testing of the APIs using Postman.
• Worked with the QA to design and develop the Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional testing and Regression testing by utilizing HP QC and HP ALM.
• Performed manual testing for the system, integration and User Acceptance Testing (UAT).
• Timely tracking the progress and reporting it to the Product Owner and the Project Manager was part of the key functionalities.

Environment: Waterfall-Scrum, MS Office (MS Word, MS Excel, MS PowerPoint), Tableau, Informatica, MS Visio, HP ALM, HP QC, My SQL Server, Swagger, Postman.

Confidential

Business System Analyst

Responsibilities:

• Used the Waterfall Methodology for regular requirements and continuous delivery of useful and working software.
• Meticulously complaint with the Fair Credit Reporting Act (FCRA), Check 21 Act and also Fair Debt and Collection Practices Act (FDCPA).
• Interviewed and conducted Joint Application Development (JAD) sessions among the key Stakeholders, SMEs and decision makers to have a successful collection of requirements.
• Responsible for documenting the Project Charter (PC), the Business Requirement Document (BRD). Also derived the Functional Requirement Specifications (FRS) based on the user requirement specifications.
• Assisted the Project Manager in preparing the Project Development Plans and identified Project Issues and Risks.
• Utilized data modeling and developed Use cases, Class Diagrams and Sequence Diagrams with the help of MS Visio.
• Interacted with the client, lead developer and team members for functional specifications and technical architecture.
• Created weekly reports with the help of SharePoint. Utilized SharePoint to track the performance of the web sites or easily integrate third party tools where ever and whenever required.
• Conducted Due diligence and Know Your Customer (KYC) research for high net worth clients as part of the business wide Anti-Money Laundering (AML) compliance remediation process.
• Analysis of accounts and client information according to prescribed internal control policies and procedures. Identification and production of information required to satisfy the Bank’s KYC due to diligence policies and processes.
• Extensive use of MS Project, MS SharePoint which was used as the library for Project Documentation and the communication of Project information.
• Participated in creating an online cloud repository using Oracle Cloud Computing services.
• Proficient in writing SQL queries using Joins, Group-by, Order-by and aggregating functions to join data from multiple tables and also created tables using DDL and manipulated tables using DML. Also used pre-executed SQL queries like Stored Procedures, functions and Triggers.
• Responsible for mapping EDI X12 data into XML and then to the FACETS system using Extreme translator.
• Designed the Test cases, Test Plans and Test Scenarios in-order to perform Functional Testing, Smoke Testing and Regression Testing and logged down defects and systematically managed them in JIRA.
• Experience in designing and implementing, reporting and visualization of unstructured and structured data sets by using Tableau.

Environment: Waterfall, XML, MS Word, MS Excel, MS Access, MS Project, Rational Rose, MS Visio, CMS (SharePoint), SaaS, PaaS (Cloud Computing), JIRA, Tableau.

Confidential

SQL Developer/Jr. Business Analyst

Responsibilities:

• Assisted the Project Manager in defining the scope and requirements of the project.
• Worked on creating the Business Requirement Document (BRD) and Functional Requirement Document (FRD) and System Requirement Specification (SRS).
• Defined the business rules pertaining to the project.
• Created the associated UML Diagrams (Structural, Behavioral and Interactive) and created Information Diagrams, Activity Diagrams and Process Flow Diagrams.
• Creating GUI mock-ups using MS Visio to understand UI and UX requirements.
• Utilized MS Project to create Work Breakdown Structure, prioritized the tasks and to track the progress of the project and improve efficiency from time to time.
• Coordinated creation of Test Plans, User Acceptance Test (UAT) scripts and Requirement Traceability Matrix (RTM).
• Involved in dealing with Change Requests by performing Impact Analysis.

Environment: Waterfall Methodology, MS Office, MS Visio, MS Project, Mock-Up Screens, MySQL Server, UML, UAT Testing.

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in requirements gathering analysis, design and development.
• Active participation in writing various stored procedures for the purpose of application development.
• Creating constraints and validated database integrity.
• Maintained client relationship by communicating the daily status and weekly status of the project.
• Installed and maintained MS SQL Server 2005.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented Triggers and Stored Procedures to achieve the required functionalities.
• Handling database objects with SQL Server Management Studio and Query Analyzer.
• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.

Environment: Waterfall, Windows server 2005, MS SQL Server 2005, DB2, SQL, SQL Query Analyzer, SSMS, MS Excel.