SUMMARY:

• 5+ years of extensive experience as a Business Analyst and QA, with strong experience in Healthcare, Automotive, Finance and Telecom industries with a solid understanding of Business Process Flows, Case Tools, and Business Analysis.
• Extensive experience in gathering Business and Functional Requirements, developing use cases, conducting gap analysis and preparing training manuals.
• Commanding knowledge of various development methodologies like Waterfall, Rational Unified Process, Agile and Scrum and its implementation through ETL and modeling tools such as JIRA, Altassian and Microsoft TFS.
• Proficient in soliciting client Requirements through interviews, workshops, existing system documentation and organizing JAD sessions.
• Strong experience in working with Oracle tools and databases such as OFSAA and other test services in ODS and its manipulation using Toad for Oracle.
• Excellent Business writing skills in creating Business Requirement Document (BRD), Use Case Specifications, Functional Specifications, Requirement Traceability Matrix (RTM) and System Requirements Specifications (SRS).
• Experience in developing UML use case diagrams, Work Flow Diagrams using tools like Rational Rose and MS Visio.
• Experience in working with QA testing teams, while interacting with business users and gathering user’s requirements to develop necessary Test plans, Test Cases and Test script.
• Experience in Data Modeling with expertise in creating Star & Snow - flake Schemas, FACT and Dimensions Tables, Logical Data Modeling using Erwin.
• Expertise in documentation, maintenance and modification of Policy and ACORD forms through Campaign Management
• Proficient in Developing and executing Test Plans, performing functional, usability testing and ensuring that the software meets the system requirement.
• Strong Knowledge in Insurance, Core banking CRM and SAP ERP applications.
• Extensive knowledge on MYSQL and SQL Queries.
• Expertise in designing relational database models in Microsoft SQL Server and developed Stored Procedures, Views, Triggers using T-SQL.
• Excellent team player work in conjunction with testing, development and other teams in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects.
• Knowledge in documentation project related information like test execution procedures, backup plans, new tester training documents, maintaining test logs, release notes etc.

TECHNICAL SKILLS:

Modeling Tools: MS Visio, Rational rose, Enterprise Architect, HPQC and JIRA.

Methodology: RUP, Agile, Waterfall.

Testing: Quality Center, Test Director, win runner.

Programming Languages: C, SQL, Java and J2EE.

Platforms: Windows NT Vista/Windows 7/8/10, Mac OS X.

Applications: MS word, Excel, MS Access, Power point, MS Outlook, Adobe Photoshop.

Other Softwares: SAS, SPSS.

WORK EXPERIENCE:

Data Analyst/ Scrum Master

Confidential, Birmingham, AL

Responsibilities:

• As a Scrum Master, ran the daily stand up meetings, sprint reviews, sprint demos and sprint retrospectives
• Played a major role in refinement of Product Backlog along with the stakeholders of the project before delivering expectations to the development team
• Headed the Program Increment Planning to create a roadmap for each quarter and its deliverables
• Coordinated and facilitated extensive user interviews and workshops to gather and analyze requirements.
• Developed crucial functional requirement specification FRS, creating detailed use cases and process flow diagrams to support functional specifications.
• Performed data analysis, sourcing and mapping of new systems in the regulatory reporting
• Conducted data sourcing and accepted complete ownership of several schedules in the bank’s ethos, including, Trust, Mortgage, Lease Unfunded and FDIC Uninsured
• Acted as a liaison between technical team and business clients to accomplish application enhancement and production.
• Created Conversion Matrix for document conversion and Policy conversion.
• Became a Subject Matter Experts SME to explain to the team about the work flow and business process of FDIC Uninsured and Trust schedules
• Created Use cases for better understanding of the sales process for the Campaign Management Module.
• Created Test plans, Test documents for Campaign Management and Document work station Modules.
• Extensively used SQL queries for data retrieval in testing phases.
• Worked on a daily basis with Toad for Oracle to analyze each regulatory report and ensure it was in sync with the automation process
• Intensively worked with Project managers to create Field mapping and data mapping procedures for data conversion.
• Worked extensively through Agile development methodology by dividing the application into iterations
• Developed the product backlog along with product owners and Project managers.
• Participated in Sprint planning, daily standup meetings, Retrospectives and sprint reviews.
• Participated in creating user manuals.
• Coordinated with the QA team to check the weekly status and report the same to the Project Manager.
• Performed System Integration testing and Regression Testing to ensure all the functional requirements are met and valid.
• Conducted User Acceptance Testing with users and Stakeholders for the validation and got approvals by conducting UAT sessions.

Environment: : MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), SQL Server, JIRA, Visual Studio 2015, Management Studio, Toad for Oracle.

Business Analyst/ Scrum Master

Confidential, Birmingham, AL

Responsibilities:

• Coordinated and facilitated extensive user interviews and workshops to gather and analyze requirements.
• Developed crucial functional requirement specification FRS, creating detailed use cases and process flow diagrams to support functional specifications.
• Performed requirement gathering and accepted complete ownership of several interfaces in RWP, including, WealthNet, Trust Security Review, 5500C and CloselyHeld Securities.
• Acted as a liaison between technical team and business clients to accomplish application enhancement and production.
• Created Conversion Matrix for document conversion and Policy conversion.
• Worked closely with Business users and Subject Matter Experts SME to understand the work flow and business process
• Created Use cases for better understanding of the sales process for the Campaign Management Module.
• Created Test plans, Test documents for Campaign Management and Document work station Modules.
• Extensively used SQL queries for data retrieval in testing phases.
• Performed daily Batch Jobs using Cisco Tidal Enterprise scheduler.
• Intensively worked with Project managers to create Field mapping and data mapping procedures for data conversion.
• Worked extensively through Agile development methodology by dividing the application into iterations
• Developed the product backlog along with product owners and Project managers.
• Participated in Sprint planning, daily standup meetings, Retrospectives and sprint reviews.
• Participated in creating user manuals.
• Coordinated with the QA team to check the weekly status and report the same to the Project Manager.
• Performed System Integration testing and Regression Testing to ensure all the functional requirements are met and valid.
• Conducted User Acceptance Testing with users and Stakeholders for the validation and got approvals by conducting UAT sessions.

Environment: : MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), SQL Server, TFS, Visual Studio 2015, Management Studio, e-Room

Business Analyst

Confidential, Lansing, MI

Responsibilities:

• Coordinated and facilitated extensive user interviews and workshops to gather and analyze requirements.
• Developed crucial functional requirement specification FRS, creating detailed use cases and process flow diagrams to support functional specifications.
• Performed requirement gathering and accepted complete ownership of the DWS Module in NOVA.
• Acted as a liaison between technical team and business clients to accomplish application enhancement and production.
• Created Conversion Matrix for document conversion and Policy conversion.
• Mined data for the application team and design team to assist with creation of the application.
• Conducted data reverse mapping using TOAD, Siebel( SQL, PL/SQL Server) got Oracle systems.
• Worked closely with Business users and Subject Matter Experts SME to understand the work flow and business process.
• Created Use cases for better understanding of the sales process for the Campaign Management Module.
• Created Test plans, Test documents for Campaign Management and Document work station Modules.
• Extensively used SQL queries for data retrieval in testing phases.
• Performed daily Batch Jobs using Cisco Tidal Enterprise scheduler.
• Intensively worked with Project managers to create Field mapping and data mapping procedures for data conversion.
• Worked extensively through Agile development methodology by dividing the application into iterations
• Developed the product backlog along with product owners and Project managers.
• Participated in Sprint planning, daily standup meetings, Retrospectives and sprint reviews.
• Participated in creating user manuals.
• Coordinated with the QA team to check the weekly status and report the same to the Project Manager.
• Performed System Integration testing and Regression Testing to ensure all the functional requirements are met and valid.
• Conducted User Acceptance Testing with users and Stakeholders for the validation and got approvals by conducting UAT sessions.

Environment: : MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), SQL Server, Oracle Toad, On time, Cisco Jabber, Cisco Tidal Enterprise Scheduler.

Business Analyst - Data Anlaysis

Confidential, Winston Salem, NC

Responsibilities:

• Defined project goals, objectives and success criteria.
• Developed supporting plans such as scope, cost, risk, schedule, quality, resource, security deliverables, procurement and change management plans.
• Formulated relationship between dividend payout and future earnings, contribution margin and daily active users as the metrics to success.
• Participated in Business Modeling by understanding the needs of the business, and also documented Business Use Cases as well as System Use Cases using MS Visio.
• Facilitated Joint Application Development (JAD) sessions with the Management, Mainframe and Product Owners.
• Initiated periodic testing with ACORD for insurance and reinsurance claims.
• Designed advertising campaign using XML tags through an offline portal.
• Automated the existing HRMS reports which accounted for reduced requirement by 50% by using SQL stored procedures and Crystal Reports.
• Created and Updated the Data Dictionary Mapping from Database to User Interface for the Internal Portal Team.
• Accomplished experience through whole SDLC from requirement analysis till deployment, using highly efficient RUP process of Software development.
• Worked closely with the host (Main frames support person) and helped him understanding the process and in the creation of the match, input and the delete files.
• Created and Maintained the Requirement Traceability Matrix (RTM) using JIRA to ensure end to end detection from requirements to defects and tasks.
• Initiated Test Plans, developed and executed test cases and scenarios, worked with users to develop specific acceptance criteria and prepare test exhibits.
• Conducted User Acceptance Testing (UAT) sessions with business users and prepared document for enhancements and bug fixes.
• Used Test Director and Mercury Quality Center to report any bugs found and communicate to the developers and product support team.
• Analyzed and evaluated User Interface Designs, Technical Design Documents and Quality Assurance Test condition the performance of the application from various dimensions.
• Helped create the ‘Business Glossary’ to facilitate efficient understanding of the Business process amongst the other teams.

Environment: MS Visio, MS Project, Mac OS X, JIRA, Microsoft Office Suite, Quality center.

Business Analyst

Confidential, Charlotte, NC

Responsibilities:

• Visit intermodal terminal in Charlotte to analyze impact of $272 million CCX Project and utilize this in creating a network between manufacturer and distributor.
• Interacted with clients to gather all requirements to formulate business specifications and translate those into application.
• Researched industry reports on transportation, rail road and supply chain logistics to create an SQL database for Confidential to plan for potential changes in the industry and remain a relevant logistics partner.
• Worked at different stages of Software Development Life Cycle (SDLC) with business users, developers, and stakeholders.
• Identify emerging trends in supply chain that have largest impact on transportation networks and freight rail, highlight implications to Confidential and recommend actions to help mitigate risk and take advantage of opportunities.
• Performed GAP Analysis by identifying existing technologies, documenting the enhancements to meet the end - state requirements.
• Experienced RUP’s development cycle with four consecutive Phases - Inception, Elaboration, Construction and Transition.
• Captured existing data from ECM/PLM system and helped facilitate its transition to the global SAP platform through analysis of discrete and process sheets
• Created Requirements Traceability Matrix (RTM) from functional specifications.
• Participated actively in assembling the JAD team and in conducting the weekly sessions from requirements gathering phase to the sign-off of the application.
• Assisted the technical team in translating application functionality into application architecture and the production of a system functionality document.
• Responsible for the design and execution of test plans to ensure that business requirements and functional specifications are tested and fulfilled.
• Corrected and Updated the Requirement Traceability Matrix after completion of the UAT testing phase.
• Created a complete test bed for Users Acceptance Testing (UAT) in Test Director 8.0.
• Documented Test Plans that contains test scripts, test cases, test data and expected results for the Users Acceptance testing.

Environment: Requisite Pro, RUP, Rational Rose, MS-Office, MS-Project, MS Visio, mySQL

Business Analyst

Confidential, Greensboro, NC

Responsibilities:

• Consulted with the business to define & document the business processes, needs, current operational procedures, problems, etc.
• Segmenting product categories based on their contribution to sales/margin and working with senior management to align resources and leveraging the analysis for future price books.
• Benchmarking Volvo's revenue and gross margins with competitors to identify improvement opportunities and researching industry best practices for pricin g.
• Was a liaison between end-users, technical analysts in the analysis, design, configuration, testing and maintenance phase of the product life cycle.
• Tracked and fully documented changes for functional and business specifications; detailed procedures for use in training.
• Participated in user acceptance testing and testing of new system functionality.
• Analyzed requests or requirements for application patches or upgrades to determine impact to business and integrated systems.
• Assisted QA team in understanding the business process and in writing and executing Test Plans, Test Cases and Test Scripts.
• Had scrum calls with the development and testing teams to make sure captured requirements are developed and tested as per the requirements from the business.
• Organized JAD sessions as a proxy to the Product Owner to educate the business development team about pricing management requirements in the software solution.
• Managed the requirements as separate items, tracked the progress of each item in the TFS.
• Reviewed the test cases prepared by testers along with the business to make sure they align with the business process.
• Assisted Project Manager in the preparation of a project plan, allocating resources and deciding on the timelines of the various sprints.

Environment: Excel, MS Visio, UML, Rational Requisite Pro, SQL Server.

Java Developer and Quality Analyst

Confidential

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Designers, Developers, Project Manager, and SMEs to Designed the system with object-oriented methodology.
• Analyzed the codes for any bugs, trouble shooting issues, Application support functions.
• Participate in the whole SDLC lifecycle from the re-architecture stage to maintenance stage for this product.
• Gathered, analyzed and coded Business Requirements.
• Developed presentation layer components comprising of JSP, Servlets and JavaBeans using the struts framework.
• Designed the presentation layer using JSP, XML & XSLT.
• Implemented the complex style-sheet using XSLT to present XML data in the presentation layer.
• Developed and deployed web components on Bea Weblogic Application Server.
• Developed XML and Action classes to implement framework.
• Worked on development and validation of XML, and XSD.
• Designed and developed a highly convenient front end user interface using HTML and Java Server Pages (JSP), for customer profile setup.
• Extensively worked on SQL Queries, Stored procedures and Triggers.
• Used Struts validation framework for validations.
• Created the database tables with indexes and views in the database-using Oracle 9i.
• Responsible for Analysis, Coding and Unit Testing and Support.
• Used JDBC connections to connect to the Enterprise Information Systems.
• Deployed codes on test servers and tested for any issues and then deploying on live.

Environment: Java TextEdit, Eclipse Kepler, XMPP, XML, MS Project, MS Visio, UML, Windows and SQL Server.