SUMMARY:

• Experience concentrating on Business Analysis, Requirements Management, Use Case Modeling using UML, Project Management, Change Management, Data Quality (including ETL), Technical Training, SDLC, and both Waterfall and Agile methodology.
• Experience with projects in Banking, Healthcare, LMS and Mortgage domains and experience working with Agile, Iterative and Waterfall SDLC methodologies.
• Experience working in an Agile environment and exposure across multiple disciplines including development, requirements analysis and Scrum is a plus.
• Involved in Data Analysis, Data Mapping and Data Modeling and Performed data integrity, Data Portability testing by executing SQL statements.
• Expertise and Vast knowledge of Enterprise Data Warehousing including Data Modeling, Data Architecture, Data Integration (ETL/ELT) and Business Intelligence.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta - data definitions.
• Excellent understanding of Business Requirements gathering/elicitation, translating requirements into specifications and application design. Adept at creating wireframes, BPMN illustrations using Axure Pro, MS Visio.
• Worked extensively on the Gap analysis, Impact Analysis, SWOT analysis, Risk Analysis, Cost benefit analysis.
• Well versed in project management, budgeting, resource allocation, creating project charters, project plan, communication plan, test plan and carrying out risk assessments.
• Exposure to Scrum based Agile project development using JIRA, TFS, RRC, RTC and Rally tools.
• Strong knowledge of Business Process Modelling assessing “As Is” & “To Be” scenarios, business automation and improvement research, implementation methodologies, diagramming data & process mapping, applying Unified Modeling Language (UML) and worked in projects based on iOS, Android and web-based platforms.
• Worked extensively with Erwin, Visio and ER Studio, Power Designer for Relational Dimensional Modeling and Data Migration projects.
• Good knowledge in SQL, practical experience in MS SQL and Oracle databases and SharePoint.
• Experience in conducting Joint Application Development (JAD) sessions with IT Groups and excellent skills in creating BRDs, Use Cases, User Stories, NFRs, Traceability Matrix.
• Expert in tracking and managing the requirements using Requirement Traceability Matrix (RTM) that controls numerous artefacts produced by the teams across the deliverables for a project.
• Experience in writing Use cases and producing Use Case Model, Analysis model, Behavioral diagrams (Sequence diagrams, Collaboration diagrams) and Class diagrams based on UML Methodology & Business process flow diagrams using MS Visio.
• Worked with the On-site and Off-shore Quality Assurance groups by assisting the QA team in developing Test Plans, Test Preparation, Test Execution and Issue Resolution, and report generation to assure that all aspects of a project follow the Business Requirements.
• Experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.
• Proficient in handling multiple projects simultaneously and delivering within timelines. Ensure Requirement traceability from the project initiative to the Test scripts.
• Excellent collaboration skills and ability to influence cross functional teams and facilitate conversation that lead to agreed direction.
• Hands on experience providing requirement walkthroughs and KT sessions and excellent presentations skills and flexibility to deliver in different work environments.
• Proven talent in maintaining client relationships and meeting business objectives.

TECHNICAL SKILLS:

Operating Systems: Windows95/98/2000/XP/NT/Vista/07/08/10 and Mac OS.

Databases: MySQL, SQL Server, Big Data Oracle, Excel, Access and SAP

Methodologies: SDLC, Agile, Waterfall, Cost/ Benefit Analysis, RUP.

Test Automation Tools: Quick Test Professional (QTP), Selenium, HP QC.

Defect Reporting & Test Management: Quality Center (QC), JIRA, Rally, Rational Clear Quest, RTC.

Wireframing Tools: Figma, Adobe Illustrator, Axure Pro, Visio, Balsamiq, Fluid UI, XCode, Snagit.

Web Languages: HTML, XML, JavaScript, CSS and MS FrontPage

Requirement Management Tool: Rational Requirements Composer, MS office, Requirement Traceability Tool, Enterprise Architect, Rational Team Concert, Rational Test Manager, JIRA.

Project Environments iOS, Android, ASP .NET, SharePoint, Java, SSIS, SSRS, Informatica, Stash, SQL Server, Oracle, MySQL, MS Dynamics CRM.

Microsoft Technologies: MS Project, Excel, Word, Access, Visio, PowerPoint, Outlook, Adobe Photoshop, CRM.

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria, VA

Business/Data Analyst

Responsibilities:

• Gathered business requirements using Joint Requirement Planning (JRP), Joint Application Deployment (JAD) sessions and brainstorming ideas.
• Coordinated with the stakeholders and project key personnel to gather functional and non-functional requirements during Design Sprint sessions.
• Studied the existing business process and created AS-IS workflow to illustrate the existing system.
• Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and end users for Requirement gathering in Definition Stage.
• Work as a liaison between the Business team and IT team to translate business requirements and set project expectations.
• Work with the Scrum master in Iteration planning and backlog grooming activities to manage project priorities and deliverables. Help in deciding the MVP (most viable product) for the release.
• Involved in Data flow analysis, Data modeling, Physical database design, forms design and development, data conversion, performance analysis and tuning.
• Assisted the database development team in data modeling, data structure and data table layouts required for consolidation of incongruent databases.
• Wrote multiple SQL queries for modifying records (insert, update & delete) in the backend database, performed JOINS on multiple-tables for data extraction.
• Worked in all areas of computer technology skill sets that are required for an LMS admin (with skills in system administrations, database administrations, web page design and HTML queries, specific network and communications techniques).
• Hands on experience with Microsoft Dynamics Enterprise Resource Planning system.
• Worked with Project team to collect and analyze company's business rules and processes, built flowchart of the business process workflow, and create architecture and implementation plan of Dynamics CRM customization.
• Experience in interacting with MS CRM database through CRM web service or SQL query.
• Utilized Agile, Scrum methodology for product development and project Product Backlog documentation, wrote User Stories and documented the Sprint Backlog.
• Created flowcharts, wireframes and mockups during design phase for Graphic User Interface (GUI) of the product, used Figma for creating prototype designs to test the new UI with end users.
• Participated in Daily Scrum Meetings as well as other Scrum ceremonies like Sprint Planning and Sprint Review Meeting.
• Updated use cases and user stories in JIRA for task progress and completion. Maintained product backlog and assisted Product Owner in putting acceptance criteria in JIRA.
• Coordinated and participated in estimation meetings to provide high-level estimates (story points) for Backlog stories.
• Identified and documented Use Cases, Use Case diagrams, User Stories, and leveraged use cases to create UAT test scripts.
• Worked on User Acceptance Testing (UAT) and Manual testing (Functionality Testing) of UI and Web Applications.
• Extensively worked in creating Test Procedures, Test plans, Test cases and reviewing them for quality assurance.
• Participated in defect triage meetings for assigning severity and priority to the defects logged during testing phase.

Environment: SQL, Oracle, Figma, MS Office Tools, HTML, JavaScript, CSS, SharePoint, JIRA, Confluence, ALM, Microsoft Dynamics CRM, Agile, UML, RUP, Visio, IBM IDA, Toad, Service Now.

Confidential, Columbus, OH

Requirements/Data Analyst

Responsibilities:

• Collected and analyzed business requirements. Collaborated with Business Owners, User Experience Designers, and IT teams to translate Business Requirements into Functional Requirements.
• Create data flow documentation, data mapping and data transformation specifications.
• Analyze, Understand & document complex business requirements in existing data ware house logics, and complete data profiling and data quality assessments based on the rule.
• Experience in SQL Stored Procedures, Triggers, Indexes, Views, Data Transformation Services and Reporting services.
• Coding of Database objects like Triggers, Procedures, Functions and Views.
• Strong Experience in T-SQL (DDL and DML).
• Creating and maintaining Tables, Indexes, Stored Procedures, and Views.
• Created requirement artifacts in the form of System Reference Documents, Process Models, Use Case Documents, User Stories (Gherkin format), Functional and Non-Functional Requirement Documents.
• Validated moderately complex requirements, including functional validation and traceability and consensus building.
• System exposes all the data/content through a Windows Communication Foundation (WCF).
• Experience in Sybase Power Designer, Toad Data Modeler.
• Strong understanding of the principles of Normalization, Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Document ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Managed and Created test plans, test scripts, functional specs, and business requirements.
• Involved in work efforts at all scales ranging from minor defect fixes and enhancements to development of new applications.
• Coordinated and facilitated with development team for change requests and defect fixes.
• Managed changes to use cases, and functional design, and business requirements.
• Mapping and diagramming complex batch flow diagrams.
• Participated in Workday Transformation with RTC data as a RTC SME.
• Utilized the following software: IBM notes, RRC, RTC, Quality Center, Logical Viewer, and Rational Application Developer.
• Led prioritization and sequencing efforts across the program to identify milestones and cross-project dependencies.
• Lead and assist in story card estimation, sprint planning, and project prioritization with Business Application Owners.
• Created Sprint Backlog and managed User stories.
• Led daily stand-up meetings.
• Liaise between Service Now application users and I.T in the analysis, design, testing for application development to ensure optional operational performance that meet business needs.
• Work with client to document future state processes for Incident Management, Change Management, Knowledge Management and Service Request Management.
• Provided updates to Project Management team for status and any issues requiring risk mitigation or escalation.
• Proficient in testing web services using SOAPUI tool and well versed with the entire test management using HP Quality Center.
• Coordinating all testing activities independently: estimating, prioritizing of story cards, scheduling and assigning work.
• Supporting release management. Responsible for the go/no-go decisions based on the system test exit criteria.
• Executed moderately complex tests per established plans and scripts, documents and communicates results. Collaborates with developers and/or end users to determine appropriate solutions. Retests corrections to ensure problems are resolved.
• Develops, implements and maintains test data files with valid and invalid records to thoroughly test program logic and verify system flow.
• Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues.

Environment: Rational Requirements Composer, Rational Team Concert, Service Now, SOAPUI, Microsoft Project, MS Excel, MS Word, Power Point, Toad Data point, IBM rational Clear Quest, Putty, Toad, Informatica Power Centre 6.0, SDLC, SnagIt, Beyond Compare, Oracle CRM, Quality Center, Windows.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Responsible for capturing and managing business requirements for the release along with business process, and developing the functional requirements specifications document.
• Arranging and attending meetings with Business Owners, Project Sponsor and other Stakeholders.
• Responsible for defining scope, creating work breakdown structure (WBS).
• Conducted JAD & JAR sessions with management, SME, vendors and other stakeholders for open and pending issues.
• Organized regular meetings with Offshore development team, Capture Meetings / documentation and sharing of MOM (Minutes of Meeting) with the team.
• Prepared workflow use-case diagrams and analyzed AS IS and TO BE scenarios, designed new process flows and documented the business process and various business scenarios.
• Collaborate with cross-functional teams to gather business requirements related to ongoing development using Agile Estimating and Applied User Stories.
• Gather complete and clear requirements through JIRA Cards for Epics and User Stories.
• Grooming sessions with scrum team to improve user-story quality based on feedback and participate in daily Scrum meetings to provide functional clarifications to developers.
• Worked on SharePoint2007 for managing artifacts, version changes, and Capture Meeting minutes, Flowcharts, Activity Diagrams and Use Case Diagrams.
• Used Command Line tools for writing Complex SQL Queries.
• Worked closely with teams, project stakeholders, SME to map the expectations to the delivery capabilities and maintain the traceability matrix to track the progress.
• Carrying out the impact analysis of change requests on budget and schedule, updating the BRD to document the suggested changes and getting them incorporated in prototype.
• Assisted QA team in assembling, evaluating, and reviewing testing strategies and test plans.
• Analyzed business requirement document and created use cases, use case diagrams, and activity diagrams using Visio. Involved with developing of Project Status Matrix for weekly evaluation of project status.
• Assisting Project Manager in developing project schedule/scope and creating various status reports and keeping him apprised of status of activities.

Environment: JIRA, Confluence, MS Project, Microsoft Visio, MS Word, SQL, Big Data, Windows 7, Agile, SharePoint, Scrum, JAD & JAR Sessions, UAT.

Confidential, Jacksonville, FL

Business/System Analyst

Responsibilities:

• Leading and facilitating the process of capturing and documenting the business/systems requirements including functional and non-functional requirements, use case definitions, business process redesign as needed for new/updated/enhanced technologies.
• Translating high-level business requirements into functional specifications for the technical teams and managing changes to such specifications.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio. Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Scheduled meetings with developers and testers to collaborate resource allocation and project completion using MS Project.
• Gather complete and clear requirements through JIRA Cards for Epics and User Stories.
• Experience with filed order management and integration to metering systems.
• Participate in daily Scrum meetings to provide functional clarifications to developers.
• Using Visual Modeling Platform - Enterprise Architect to customize requirements documentation, linking requirements to the design and implementation details, and providing Requirements Traceability through the design, construction and implementation phases.
• Reviewing the system testing plan/results from requirements perspective and provide UAT support.
• Working with technical design team to clarify/refine/elaborate requirements as the technical implementation progresses and serve as a coordinator between business/customer and technical teams.
• Assisting Project Manager in developing project schedule/scope and creating various status reports.
• Writing, testing and executing SQL queries to access data from database.
• Analyzed and accurately identified business risk, baseline acceptance criteria and deliverables.

Environment: MS Visio, Enterprise Architect, SharePoint, JIRA, MS-Office (MS Excel, MS Word, MS PowerPoint), SQL queries, UAT, System Testing, ER Diagrams, JAR sessions.

Confidential

Business /System Analyst

Responsibilities:

• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD).
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead.
• Facilitated Joint Requirement Planning and JAD sessions with SME’s in understanding the Requirements.
• Proactively participated in Agile Scrum; Planning Meeting, Daily Stand up meetings, Demo meetings, Burn Down Charts, User Story Estimation, Capacity Planning.
• Understanding the rules and effectively implementing them into the Process Flow. Participate in defining the functional requirements and developing the Product Backlog.
• Use Team Foundation Server to map the User Stories to specific sprints.
• Analyzed Business Requirements and Functional Requirements from the Product Backlog and converted the requirements into Test Cases and Test Scripts in HP Quality center.
• Interaction with the Users, Technology teams, Functional and Quality assurance reviews. Prepare and maintain the Traceability matrix to continuously track progress.
• As a BA worked closely with User Experience team to get feedback for improvements in the application
• Used Rally & HP Quality Center as repositories for requirement analysis, design test cases, execute test cases, Bug tracking and reporting.
• Single point of contact for development & testing teams during testing with regards to Requirements and knowledge transfer
• Actively Participated in UAT helping Customers on Test flows and Test Data support.
• Understanding of the HIPAA rules while creating business rules to capture and save and disclose the Protected Health Information
• Analyze the Data Model and data flows through SQL queries in the DB Visualizer tool.
• Create wireframes/mock-ups using Axure Pro and MS Visio.
• Define Testing strategies and design Test Plans to test each system Interface output and rigorously test each system Interface based on its Test Plan.
• Ensured the quality of the output for each system Interface by conducting Meetings with the respective vendors to review the output and obtain continuous feedback. Suggest measures and fine-tune queries to improve the performance of each Interface and the quality of the output files.

Environment: SOAP, Web Services, Universal Database Oracle, MS SQL Server, MS Excel, Rally, SOAP UI, Oracle, HP Quality Center, Visual Studio, MS TFS, XML, REST, MS Office, HP QC, DB Visualizer. Axure Pro, MS Visio, Rational Requisite Pro.

Confidential

Business Analyst

Responsibilities:

• Gathered & analyzed the requirements for new reports (schedules/ad-hoc reports) and dashboards for Risk/ Return analysis and portfolio management. Worked with IT team to create scheduled automated reporting for standard and frequently used reports.
• Was involved in functional requirement gathering and high level impact analysis for multiple changes in the application (e.g. field level changes and validation, verbiage changes etc.) for multiple releases in a year.
• Identified functional changes/upgrades to database and application modules to service new instruments/benchmarks. Jointly worked with the technical team to develop a library of mapping services for easy integration of data across multiple systems (internal and external).
• Facilitated JAD session, documented all the discussions, stored the requirements and tracked the changes maintaining the versions of document.
• Capture NFRs related to disability based requirements in accordance with ADA standards and participate in defining the functional requirements and developing the Product Backlog.
• Break down the functional requirements into granular technical User Stories and prepare and maintain the Traceability matrix to continuously track progress.
• Was involved in user acceptance testing for all new reports /enhancements by directly accessing various databases (using SQL) to validate the output.
• Worked with the Quality Assurance Team to ensure systems functionality meets user requirements. Assisted QA team in writing Test Plan, Test Cases. Provided input and reviewed the testing scenarios and test cases.
• Facilitated discussions, presentations and preparation of the burn out charts and estimated the schedule & effort of the requirements deliverables (FRD) & their milestones.
• Conversant with XML documents and syntax- worked with multiple xml file and system response outputs.

Environment: JIRA, UML, Rational Rose, RTM, Test Director, MS Word, MS Visio MS PowerPoint, MS Excel, SQL, Visual Basic, and Windows Vista.