Senior Business System Analyst / Scrum Master Resume
Plymouth Meeting, PA
PROFESSIONAL SUMMARY
- Over 8+ years of experience as a Senior Business Analyst / Scrum Master with extensive and diversified IT experience in Banking, Insurance, Ecommerce & Finance domains.
- Extensive experience to analyze and document business requirements and system functional specifications including Business Requirement Documents, Functional Specification Documents, Requirement Traceability Matrices.
- Knowledge of Business Process Modeling, UML diagrams such as Use Cases, Sequence Diagrams, Activity Diagrams and Entity Relationship(ER) diagrams using MS Visio, Rational Rose.
- Expertise in prototyping, wireframes, and mock - up screens using Balsamiq Mock-up and MS Visio.
- Expertise in conducting GAP analysis, Impact analysis, Risk analysis, SWOT analysis, Cost Benefit analysis, Feasibility Analysis.
- Thorough knowledge in creating and maintaining Test Plans, Test Scenarios, Test cases using HP QC/ALM, Jira.
- Expertise in executing User Acceptance Testing, Usability Testing, Beta Testing and Regression Testing.
- Extensive knowledge in creating project plan, management and status reports using MS-Project, JIRA and document management tool such as SharePoint.
- As a certified Scrum Master has intensive experience in coaching/mentoring team members in agile- scrum practices.
- Knowledge of Sprint Backlog Prioritization Techniques using MoSCoW, Kano, Relative Mass Valuation, User Story Estimation Techniques using Planning Poker, T-Shirt Sizing, and Backlog grooming tools.
- Strong skills in Data Analysis, Data Requirement Analysis, Data Modeling and Data Mapping, Data Migration, knowledge of transition rules and Data Validation pertaining to ETL process.
- Extensive Experience in Agile, Waterfall and Scrum-Waterfall Hybrid models of Software Development Life Cycle (SDLC) and project life cycle.
- Expertise in database queries on various RDBMS like My SQL, Oracle, SQL Server, MS Access, Online Analytical Processing (OLAP) and data cube technology.
- Extensive experience in all phases of Software Testing Life Cycle (STLC) and Defect Life Cycle.
- Wide exposure to Data Warehousing Architecture, implementation approaches, schemas, dimensional modeling and translating business requirements into various dimensions.
- I have knowledge in web services, WSDL, SOAP, UDDI, REST under Three-Tier Architecture and Service Oriented Architecture (SOA).
- Sound knowledge in writing SQL queries and proficient in working in Java and .NET platforms.
TECHNICAL SKILLS
Designer Tools: Rational Rose, MS Visio, Balsamiq Mock Up, SharePoint, Adobe CQ
Test Management Tools: HP QC, ALM, Jira, Black Box testing, UAT, Usability Testing, Black BoxTesting, Regression Testing
SDLC Methodologies: Waterfall, Agile, Scrum-Waterfall Hybrid
Project Management Tools: MS Project, Jira, MS SharePoint
Relational Databases: SQL Server, Oracle 11g/10g, MySQL, Teradata, DB2, Sybase
Languages: SQL, PL/SQL, .NET, Java, XML, HTML, JavaScript
ETL/BI Tools: Data Stage 8.0.1, Informatica, Cognos, Tableau, SPSS
Operating Systems: Windows 2008/XP, Vista
Web Analytics Tools: Adobe Analytics, Google Analytics
DBMS Tools: TOAD 8.x/9.x/10.x, SQL Developer
PROFESSIONAL EXPERIENCE
Confidential, Plymouth Meeting, PA
Senior Business System Analyst / Scrum Master
Responsibilities:
- Developed knowledge on insurance industry concepts such as insurance lifecycle, limits, premiums and deductibles, types of insurance such as liability coverage, comprehensive coverage in order to have a better understanding of gathering requirements.
- Identified, analyzed, researched, defined and documented the business processes by conducting various requirement workshops with key stakeholders.
- Designed and developed UML diagrams using MS Visio, facilitated designing prototypes, wireframes & mockup screens for illustration of various reporting modules, architecture and dashboard of the PCI environment.
- Conducted Joint Application Development sessions with relevant Subject Matter Experts such as Data Warehouse Database Analysts, Developers, Architect and Sales & marketing managers to assess and document the business rules, requirements and functionalities of the TO-BE system.
- Did Gap Analysis between the current state and future data warehouse environment identifying data gaps, quality issues, pertinent data mapping & transformation rules.
- Identified data sources, entity names, attributes, primary and foreign keys.
- Worked closely with the data warehouse development team to ensure user requirements and issues are being addressed, while controlling scope.
- Helped identify potential sources of behavioral, interaction, descriptive data for the data warehouse and assisted DW data analysts in mapping tasks.
- Did data profiling, monitoring data quality & performance based on Acceptance Criteria.
- Wrote SQL queries for backend validation testing.
- Was responsible for overall coordination of User Acceptance Testing (UAT) and training.
- Created high level requirement artifacts such as Business Requirement Document & Functional Specification Document.
- As a Scrum Master facilitated all scrum ceremonies.
- Helped Product Owner in creation and maintenance of Product Backlog by applying MoSCoW prioritization and INVEST criteria.
- Assisted scrum development team in breaking down epics into user stories, estimation of user stories using the Planning Poker technique, integrating business & technical spikes whenever necessary and forming sprint tasks from the estimated user stories.
- Resolved impediments and facilitated team in preparing scrum artifacts such as sprint burndown and release Burndown charts.
Application Environment: Scrum-Waterfall Hybrid, .NET, DB2 Enterprise Server Edition, SPSS Modeler, IBM Cognos, HP ALM, IBM Data Stage 8.0.1, Data Generator, Apache Tomcat 5.
Confidential, Framingham, MA
Scrum Master
Responsibilities:
- Developed thorough knowledge on web content management using tools such as Adobe CQ, B2C electronic commerce, Association Rule Learning in Data Mining and content management products such as SharePoint.
- Demonstrated logical, rigorous and analytical breaking down of complex requirements, processes, features and business needs specifically focused on web content management, portal applications and e-commerce solutions to form high level user stories.
- Facilitated scrum team in estimation of user stories using T shirt Sizing technique.
- Enabled improvement in team delivery commitments and capacity planning for sprints by identifying & tracking hidden tasks.
- Coached team members in Agile framework, mediating through conflicts, fostering self-organization of the team and assisting the scrum team in making decisions.
- Assisted the Product Owner in prioritizing the Product Backlog Items using MoSCoW technique and facilitated all scrum ceremonies.
- Always mediated the general conflict of goals between development team and product owner.
- Facilitated scrum development team in creating traceability matrix, mapping requirements to test cases using JIRA.
Application Environment: Agile, Java, MS Visio, MS BizTalk Server, SharePoint 2013 V 15.0, Balsamiq Mock up, Oracle Endeca Server, JIRA, Adobe CQ.
Confidential, New York
Senior Business Systems Analyst
Responsibilities:
- Charted the Project Scope & Business Process Flow
- Used several elicitation techniques such as face to face interviews, focus groups & prototyping to understand business goals clearly.
- Did Gap Analysis to estimate the current status of project & the future goals that needs to be achieved.
- Prepared artifacts such as Business Requirement Document (BRD) & Software Requirement Specification (SRS).
- Created detailed use case diagrams by specifying actors, normal flows, alternate & exceptional flows using Rational Rose.
- Extensively facilitated ETL process, ETL strategy consisting of data extraction from Big district databases, deciding on transformation rules, data staging, sourcing and mapping.
- Facilitated Entity Relationship (ER) modeling to normalize the data collected from heterogeneous sources by reducing redundancy.
- Also was an extensive part of dimensional modeling consisting of dimensions, fact tables and star schemas.
- Extensively used OLAP tools like drill down, roll up, slicing dicing, on data cubes.
- Created test suites, test plans and executed test cases in HP QC
- Was involved in User Acceptance Testing (UAT) and usability testing of the web page. Also facilitated Regression Testing.
Application Environment: Waterfall, Java, z/OS IBM mainframes, IBM DB2 V9.7, Cognos Reporting Application Environment, HP QC, Rational Rose, Informatica.
Confidential, Pennington, NJ
Senior Business System Analyst
Responsibilities:
- Captured requirements by conducting interviews with stakeholders, brainstorming sessions with stakeholders and created the Business Requirement Document (BRD).
- Coordinated with Tech Lead to create Functional Specification Document (FSD) and had it base-lined.
- Was extensively involved in pre-migration planning and pre-migration Impact Assessment.
- Shadowed Lead Data Migration Analyst in creating exact copy of Sybase DB in Oracle and copying all the data; later copying the data from the temporary Oracle DB to the target data repository, by writing SQL queries.
- Was extensively involved in creating detailed data dictionary, developed high level source to target mapping specification to identify high level objects and relationships that will be linked during the migration.
- Documented Requirements Traceability Matrix in HP ALM after documenting the requirements against the associated test cases along with their status.
- As a Senior Business System Analyst facilitated the data migration process from Sybase to Oracle database by identifying data sources, data profiling & cleaning, created conceptual model and logical models.
- Developed transformations and rules used to map the legacy and target environments accurately.
- Was involved in writing test cases, test plans and test scenarios along with the testing team; User Acceptance Testing (UAT) issue log for tracking the defects in HP ALM and collaborated with system users to conduct UAT.
Application Environment: Waterfall, Java, Oracle, Sybase, MS Visio, HP ALM, MS Project, Tableau, MS Office Suite (Word, Excel, PowerPoint, Access).
Confidential
Senior Business Analyst
Responsibilities:
- Conducted requirement gathering sessions in the form of questionnaires and face to face interviews with key stakeholders.
- Analyzed and documented business requirements and meeting minutes.
- Developed screen mock-ups and wireframes using Mockups and use cases using MS Visio.
- Gathered requirements for web content management to increase the website efficiency.
- Associated Finance Manager in studying, analyzing and documenting Cost Benefit Analysis.
- Responsible for testing the web application with Manual and Automated strategies.
- Performed user acceptance testing (UAT) to validate user requirements.
- Developed training curriculum, conducted formal training sessions covering assigned systems module and provided technical assistance in training, mentoring, and coaching Junior Business Analysts.
Confidential
Business Analyst
Responsibilities:
- Acted as a liaison between the end users, business team and the technical team, effectively communicated business needs and requirements of end users to the technical team.
- Elicited requirements using interviews, document analysis, requirements workshops, surveys, workflow analysis.
- Critically evaluated information gathered from multiple sources in association with the Business Owner & Project Manager, reconciled conflicts and drilled down high-level information to create detailed use cases using MS Visio.
- Coordinated with technical leads & developers to transform and develop new requirements into website design and implementation.
- Interfaced with vendor partners and designed optimal solutions for integration with web services portal.
- Created and maintained workflows, approval processes, and validation rules based on internal stakeholder requirements.
- Assisted Project Manager in tracking the status of the project using MS Project.
- Created training materials and documentation for web portal users, trained new end users on related applications and was actively involved in the User Acceptance Test (UAT).
Application Environment: Waterfall, ASP.NET Ajax, Windows 2008, MS Visio, HP ALM, MS Office Suite (Word, PowerPoint, Excel, Access).
Confidential
Junior Business Analyst
Responsibilities:
- Shadowed Senior Business Analysts and Subject Matter Experts in designing the business requirement elicitation approach based on the project scope and Waterfall SDLC methodology.
- Assisted Senior Business Analysts in face to face interviews with key business users to gather prime requirements and business process information.
- Assisted Facilities Manager in Business development and performed Critical Path Analysis.
- Developed artifacts such as Business Process Flow, Business Requirement Document, were also involved in developing the Functional Specification Document.
- Assisted Senior Analysts in performing extensive Document Reviews and GAP Analysis to develop a thorough understanding of AS-IS business process model and TO-BE business process model.
- Worked with GUI development, requirements creation/design to create the initial UI wireframes, and mockups using Visio.
- Shadowed Senior Business Analysts in User Acceptance Testing (UAT).
- Developed requirement reports for day-to-day demat account banking needs for opening account & online banking activities using Visio.
Application Environment: Waterfall, Visio, .NET, HP ALM, MS Office Suite (Word, Excel, PowerPoint, Access), MS Project.