SUMMARY

• Goal oriented professional with 8+ years of experience in eCommerce, Retail and Banking as a Sr. Business Systems Analyst/Sr. Business Analyst and Scrum Master working in collaboration with cross functional and self - organizing teams across various business areas to deliver cost-effective, high performance technology solutions to meet challenging business demands.
• In-depth knowledge and hands-on expertise in implementation of project life cycle in various phases and stages of Software Development Life Cycle (SDLC) in Waterfall, Agile (Scrum) and Hybrid (Waterfall-Scrum) methodologies.
• Proficient in preparing documents used throughout SDLC, such as Business Requirement Document (BRD), Functional Requirement Document (FRD), Software Requirement Specification (SRS) and Requirement Traceability Matrix (RTM).
• Experienced in converting requirements into wireframes, prototypes, mock-ups for developing UI/UX components.
• Proven skills in creating Unified Modeling Language(UML) Diagrams including Sequence Diagrams, Activity Diagrams.
• Experience in using different elicitation techniques for requirement gathering such as conducting JAD sessions, Requirement Workshops, Focus Groups, Document Analysis, Brainstorming, Prototyping, Survey/Questionnaire.
• Knowledge and experience in performing GAP Analysis, Cost-Benefit Analysis, Feasibility Study, Root Cause Analysis, SWOT Analysis and Impact Analysis for planning and execution of several business decisions.
• Skilled Scrum Master with very good understanding of Scrum Process, Scrum Ceremonies and Scrum Artifacts.
• Facilitated various Scrum ceremonies such as Sprint Planning, Sprint Review, Sprint Retrospection, Daily Scrum and Backlog Grooming to improve the team’s performance and maximize value while focusing towards a Sprint Goal.
• Proficient in using Prioritization techniques (MoSCoW method, Kano method), Estimation Techniques (Planning Poker, T-Shirt sizing) in helping the Product Owner and the team to commit the Product Backlog Items (PBI) for Sprint.
• As a Certified Scrum Master, trained stakeholders and team in Scrum Methodology by conducting Scrum Workshops.
• Experience in mapping all the elements in the HTML to XML tags while working closely with developers in performing Client Side and Server Side validation for 3-tier as well as SOA Architectures, Web Services, XML, SOAP, WSDL.
• Assisted data architects in designing plans to perform ETL procedures for loading data into Enterprise Data Warehouse (EDW) from heterogeneous sources and design of Data Models. Experienced in preparing Data Mapping documents.
• Knowledge of Database concepts including Data Warehousing, Dimensional modeling, Relational Database Management System (RDBMS), Data Marts, OLAP operations such as Drill-Down, Roll-Up, Slicing, Dicing and Pivoting.
• Experienced in using SQL queries Joins, Unions, Group-by, Aggregate functions for data analysis and data validation.
• Worked with Business Intelligence (BI) team in creating custom reports and dashboards for data visualization.
• Demonstrated experience in using Microsoft Suite tools such as MS Visio, MS Excel, MS Word, MS PowerPoint.
• Participated extensively in User Acceptance Test (UAT), Black-Box testing, Smoke testing, Sanity testing, Load testing, Stress testing, Volume testing, Unit testing, Regression testing, End-to-End testing and Integration testing.
• Collaborated with QA Team in reviewing Test Procedures while creating and executing test cases, test plans and test scripts and efficiently prioritizing and managing defects using Defect Tracking Systems like JIRA, HP QC and HP ALM.
• Creative and aggressive self-starter attitude with integrative thinking skills, capable of forming and maintaining positive and productive working relationships with internal and external stakeholders.
• Successful as a team player with excellent problem solving, team building, decision making skills coupled with good communication skills to work in conjunction with DBA's, testers, developers and other team members.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile-Scrum, Waterfall-Scrum Hybrid

Management Tools: JIRA, MS Office, HP ALM, Rally, MS project, MS SharePoint

Languages: SQL/PL-SQL, HTML, CSS, XML

Business Modelling Tools: M.S Visio, Mockup Screens, Balsamiq

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, ETL, Slicing/Dicing, Drilldown/ Roll Up

RDBMS Databases: MYSQL, Oracle 9i and 10g(PL/SQL), Microsoft SQL server

Data Warehouse Tools: Tableau, QlikView, IBM Cognos, SSRS, Informatica, Data Stage, SSIS, SSAS

Testing Tools: HPQC, HP ALM, Load Runner

Business Skills: Change Management, Impact Analysis, JAD sessions, SWOT analysis, Project Planning, Scheduling and Budgeting, HLD, LLD, Business Process Modelling

Operating Systems: Windows XP, Vista, 7,8,10, Mac OS, Linux

PROFESSIONAL EXPERIENCE

Confidential, Framingham, MA

Sr. Business Systems Analyst/Scrum Master

Responsibilities:

• Facilitated JAD sessions, Interviews, brainstorming sessions between Sales teams, Service team, Marketing team, Development team, Business owners and other stakeholders to elicit the requirements.
• Conducted gap analysis for AS-IS and TO-BE of the process to identify and validate requirements during JAD Session.
• Elicited requirements through JAD sessions, Interviews, Questionnaire, Focus Group, Brainstorming and Prototyping with stakeholders.
• Analyzed/Reviewed and gathered Business Requirement Document(BRD)/ Functional Specification Document(FSD).
• Drafted Software Requirement Specification (SRS) document and Requirements Traceability Matrix(RTM) in accordance with the Business Requirement Document.
• Composed use cases for a better description of the functionality and created UML diagrams like Use Case Diagram, Activity Diagram as well as created mock-up screens.
• Facilitated scrum process including Daily Scrum Meetings, Sprint Planning Meetings and Monthly Reviews meetings. Conducted sprint retrospective and followed up on action items for continuous improvement.
• Coached team members on Agile processes. Maintained task board and produced daily burndown charts.
• Removed impediments and protected team members from interruptions and distractions to maximize productivity.
• Worked on JIRA, and Rally tools for collecting requirements, user story tracking and generating various scrum artifacts.
• Assisted Product owner in conducting Prioritization Techniques like MoSCoW, KANO and Walking Skeleton, helping teams with wireframes for UI design and Entity-Relationship (ER) Modeling.
• Effectively helped the Agile teams to determine Story Points for User Stories using Estimation Techniques like Planning Poker, T-shirt Sizing, Relative Mass Valuation and Dot Voting; helping teams achieve more with a Higher level of Satisfaction.
• Got familiarized with the different deployment models and cloud computing environments.
• Involved in implementation of cloud specific SLA's, development of cloud governance process, making business processes cloud-ready, or writing cloud-specific requirements.
• Assisted the Product owner and the team in leveraging different storage options like Amazon S3, Mongo DB.
• Assisted cloud admin in configuring the alerts by using Amazon cloud watch.
• Assisted cloud admin in providing the user access using Amazon IAM.
• Assisted system architect in identifying required gateways through Amazon API Gateway.
• Worked closely with the Product owner, development team and to assist them in creating a Release plan for migration into the cloud for each feature.
• Responsible to provide valuable insights to clarify opportunities and identify associated risks that require consideration to optimize the solution

Environment: Waterfall Scrum Hybrid, Jira, Amazon AWS, Amazon Cognito, Amazon Lambda, Amazon API Gateway, Amazon SNS, Amazon SES, Mongo DB, Amazon Kinesis Firehose, Amazon Redshift, Amazon Quicksight, Microsoft Excel 2013, Microsoft Word 2013, MS Sharepoint, HP ALM, HP QC, Jenkins, Windows 7, HTML5, CSS3, JavaScript, Objective C, Bootstrap.

Confidential, Ada, MI

Sr. Business Systems Analyst/Scrum Master

Responsibilities:

• Performed Gap Analysis to identify the deficiencies of the current business systems and to identify the requirements for the change in the system to analyze the As-Is and To-Be to generate future business requirements.
• Facilitated JAD Sessions, Interviews sessions, Survey/Questionnaire and Focus Groups to Elicit Requirements with various stakeholders, mostly business users and SME’s for understanding the business requirements.
• Collaborated with various business departments and IT through effective communication to develop business use cases associated with new project requests and associated workflows.
• Conducted requirement walk-throughs with key stakeholders using various methods like team demos, workshops during sprint planning and backlog refinement sessions.
• Drafted Business Requirement Document (BRD) for the specific business requirements and Functional Specification Document (FSD) capture the functional requirements.
• Developed and delivered work/performance plan and associated schedule as described in the schedule of deliverables
• Assisted in implementing and maintaining large and complex project schedules using MS-Project.
• Reviewed and coordinated forecasts with scheduler to facilitate timing of commitments are accurately represented in the schedule and are kept up to date.
• Involved in tracking and managing the complete working dependencies of Onsite and Offshore teams.
• Involved in Forecasting; Release Planning; developing business cases for prioritizing the product road map features; defining the User stories and User Acceptance Criteria.
• Helped the team overcome a technical barrier by creating and updating use case diagrams, Activity diagrams, Sequence diagrams, Data Flow Diagrams using MS Visio.
• Identified and analyzed the different data sources, and the different associated processes during the data discovery phase.
• Designed Conceptual model and logical data models using Enterprise Architect as an input for physical modelling.
• Actively assisted the product owner in prioritizing the product backlog as per the maximum business value, grooming User Stories in planning activities using INVEST criteria.
• Participated in various Scrum ceremonies like Sprint Planning Meeting, Daily Stand-up Meeting, Sprint Review Meeting, Sprint Retrospective Meeting, Backlog Grooming.
• Extensively used JIRA to record and maintain the artifacts such as Product backlogs, Sprint backlogs, user stories / Data stories, Impediments list, tasks, defects and issue tracking using JQL.
• Data governance and Metadata Management using SQL queries, we have used Hadoop Atlas with the help of entity ID we have ensured customer 360 degree, which ensures data quality.
• Data cleansing and transformation of the ingested data is done with the help of APACHE SPARK in Hadoop ecosystem.
• Created test plan to best understand test scenarios and structured documents with test case scenarios for developers from a system perspective for Data Warehouse ETL.
• Maintained and created end-to-end testing strategy and enterprise wide test cases for Subject Matter Expert for User Acceptance Testing (UAT), assisted in Systems Integration Testing (SIT).
• Generated reports using Tableau for understanding the trends as well as to analyze patterns as per regions and predicting probability of occurrence.

Environment: Scrum, Jira 6.3, Confluence, Java, Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Informatica, SQL Server, SQL, PL/SQL, Tableau, Enterprise Architect, Oracle 11g, MS- Visio, MS-Project, Apache Tomcat 8.

Confidential, Richfield, MN

Sr. Business Analyst/Scrum Master

Responsibilities:

• Lead the definition and documentation of business and functional requirements.
• Conducted user/stakeholder interviews and planning sessions.
• Provided best practice recommendations in the areas of Order Management System and CRM.
• Created Activity Diagrams, Sequence Diagrams using UML methodologies for easy understanding.
• Created requirement documentation; reviews with user representatives, recommended priorities and obtained user signoff.
• Analyzed present needs/recommendations and aided in preparing and presenting Return on Investments, business case proposals and Cost Benefit Analysis.
• Worked in conjunction with the team in assigning tasks with understanding of the complexity and priority of the task.
• Assisted the Product Owner in converting requirements from BRD into User Stories by conducting User Story sessions and prioritizing Product Backlog Items (PBI) using various techniques.
• Responsible for implementing, coordinating and documenting all business processes for (web based) Internet billing customers (EBPP).
• Implemented and supported Order Management System by defining and validating requirements relating to OMS and developing process flows to define functionality across the systems.
• As a Scrum Master, implemented Scrum Practices while handling team and facilitated Scrum Ceremonies like Daily Scrum, Sprint Planning Meeting, Sprint Review Meeting and Sprint Retrospective meeting.
• Tracked team’s velocity and progress during a Sprint using Sprint burn down chart and Release burn down chart.
• Helped the team in estimating the complexity of the user story by using Planning Poker and T-Shirt sizing techniques.
• Assisted Business Intelligence (BI) team in creating dashboards using Tableau as required by the end users.
• The effort involved developing extensive SQL Queries and Procedures, utilized to perform database integrity testing, ensuring various data table entries, data validity, and data integrity.
• Performed logical data modeling and created ER diagrams and used SQL queries for managing database.
• Prepared Requirement Traceability Matrix (RTM) report to ensure that every Business requirement is adhered to achieve the expected performance.
• Involved with the Software Quality Assurance (SQA) Team to develop Test plans, execution of Test Cases and logged the defects for failed test cases using HP Quality Center.
• Assisted in deletion of defects and bugs, to meet requirements and deadlines for successful execution of project.
• Played a key role in the planning and performing User Accepted Testing (UAT) along with business users

Environment: Scrum Methodology, MS SharePoint, HPQC, Tableau 6.1.6, Microsoft SQL Server 2012, Toad, Mock-Up Screens, GAP analysis, UML, UAT Testing, MS Office Visio, PowerPoint, Word, Excel, Project .

Confidential, Columbus, Ohio

Sr. Business Analyst

Responsibilities:

• Worked on a multi-system integration project that involved a major data migration from existing sources.
• Functioned as the primary liaison between the business line and technical areas throughout the project life cycle.
• Worked with the Business owners & Stakeholders and business users in identifying the business requirements.
• Involved in all phases of SDLC-Waterfall methodology in conjunction with architects, developers and testers to collaborate resource allocation and project completion using MS Project.
• Conducted JAD sessions as a facilitator to gather requirements from the business area and with IT group.
• Performed Requirement Analysis by gathering both functional and non-functional requirements based on interactions and document analysis, and represented them in Requirements Traceability Matrix (RTM).
• Used MS Visio to design Activity Diagrams, Sequence Diagrams that effectively communicates business requirements using Unified Modeling Language (UML) diagrams.
• Created data mapping document by performing data analysis and traceability mapping.
• Addressed all aspects of the loan life cycle, starting from identifying a prospective client to the loan closure
• Worked closely with developers in creating Data Models with fact and dimension tables using snow-flake schema.
• Handled several SQL queries by involving in data integrity testing and manipulating the data in Data Migration.
• Identified system interfaces and created the requirements specification document and assisted in developing test plans and test cases using HP-ALM.
• Assisted in ETL process to map source data and ingest data into target staging and target database.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Created test cases and test scripts Conducted User Acceptance Testing (UAT), Unit testing and System testing.

Environment: Waterfall, JAVA, Oracle, UML, Test Director, VB, .NET, Windows 2000, UNIX, Microsoft Office suite, MS Visio, MS Project, HP ALM, SQL server 2005.

Confidential

Business Analyst

Responsibilities:

• Interacted with stakeholders and elicited requirements by conducting user interviews and JAD Sessions.
• Analyzed and documented requirements gathered and authored Business Requirement Document (BRD), Functional Requirement Specification (FRS) for application development.
• Planned and organized requirements review and inspection sessions with SME’s, Project Managers and end users.
• Authored progress and completion reports, which were then submitted to project management on a weekly basis.
• Involved in reviewing and evaluating teams Service Level Agreement (SLA) on weekly and monthly basis.
• Assisted the team in performing testing on the data integrity, verifying table entries in data validity.
• Analyzed the requirements to understand business operational risks and create process flows.
• Had constant interaction with developers on Service Oriented Architecture (SOA), Web Services (SOAP, WSDL).
• Involved in performing Client Side validation and Server Side validations in ensuring login functionality.
• Participated in identifying sources of data for creating Geodatabases and Attribute Tables.
• Involved in developing SQL Queries and Procedures.
• Provided updates to the Project Manager regularly on the status and progress of the tasks.
• Interacted with the upper level management on status reporting, schedule control, client/project team coordination.
• Ensured requirements compliance and testing using Requirement Traceability Matrix (RTM).
• Used HP Quality Center for creating and executing test cases, for defect tracking and for generating reports.
• Documented Test Plans that contains test scripts, test cases, test data and expected results for the Integration, Functional, Performance, and User Acceptance Testing.

Environment: MS Visio, MS Office 2007, HTML/CSS, JavaScript, My SQL Server, HP QC, Waterfall, SOA, SOAP, WSDL

Confidential

Business Analyst

Responsibilities:

• Involved in all phases of SDLC, including requirement gathering, analysis, design, development, and implementation.
• Assisted the project manager/ lead in defining the vision, project plan, charter, scope and timelines.
• Facilitated JAD sessions to embrace a problem’s dimensions, possible causes, to propose alternative solutions.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interaction with the process owners & SME's.
• Created and use case documents and uploaded the documents in Knowledge Link.
• Analyzed business requirements and segregated them into high level and low level Use Cases using UML.
• Worked with designers and developers for interpreting requirements, tracking the requirement & timeline.
• Monitored client expectations through client involvement and communication throughout the lifecycle of the project.
• Organized Daily/Weekly Review Meetings with PM, Development team/SQL DBAs team for smooth migration of the Historical databases.
• Involved in UAT, test plans, documentation of test reports, etc.
• Performed Functionality, Integration, GUI, Regression, Usability and System testing.
• Created document for data flow to support the project once it implemented in production and mapped new functional and business requirements.

Environment: MS Visio, MS Office, MS Project, SQL Server 2008R2, Knowledge Link, HTML, SQL, Windows OS 2008/XP.

Confidential 

Jr. Business Analyst

Responsibilities:

• Interacted with end users to gather Requirements. Created technical, user documentation.
• Created new Database Objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in SQL Server.
• Designed and developed SQL SSIS Packages to extract data since 2005 from various data sources such as Access Database, Excel Spreadsheet, and Flat Files into SQL server for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Good experience in Installing, Updating, Configuring and Maintaining various databases for Production, Development and Testing using SQL Server with latest Service Packs.
• Using Checkpoints in packages to enable the package to run from the point of failure.
• Identified and worked with parameters for parameterized reports.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.

Environment: MS SQL Server 2005,2000, T-SQL, DTS, Microsoft Visual SourceSafe 2005, MS Access 2002, Flat files, SQL Server Integration Service, Windows 2003 Server++