Sr. Business System Analyst Resume
Buffalo, NY
SUMMARY
- Seasoned IT professional with 8+ years of global experience as a Business Systems Analyst with proven ability in leading cross functional and self - organizing teams. Certified Scrum Master with a proven track record of working with self-organizing and cross-functional teams.
- Comprehensive knowledge, expertise in various phases of Software Development Life Cycle (SDLC) processes such as Waterfall and Agile methodologies such as Scrum-Waterfall (Hybrid), and Scrum.
- Successful in conducting GAP analysis (as-is and to-be analysis) and bridging the gap between client and the technical team.
- Proficient in working with individuals at distinct levels while organizing, conducting and facilitating various elicitation techniques like Surveys/Questionnaire, Interviews, focus groups, Requirements workshops, document Analysis and JAD sessions.
- Excellent writing and documentation skills in creating, modifying and analyzing Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirements Specification (SRS).
- Experience in handling change request management, effectively implemented change by performing both Business Impact Analysis and Technical Impact Analysis of the change on the scope of the project.
- Detailed understanding of preparation of Requirement Traceability Matrix (RTM) throughout the process to verify adherence.
- Proficient in Requirement Management, Sprint Planning, Issue Tracking, Impediment Management and Work Allocation using tools like JIRA and HP ALM.
- Well acquainted with workflows and UML Modeling like Activity Diagrams, Sequence Diagrams, and Use Case Diagrams using Rational Rose, Lucid Charts and MS Visio.
- Experienced in creating Prototypes, Wireframes and Mock-Up Screens to visualize Graphical User Interface (GUI) using tools like Balsamiq and Mockup Screens.
- Facilitated Scrum Ceremonies including Daily Scrum, Sprint Planning, Sprint Review, Sprint Retrospective and Backlog Refinement meeting for Agile Philosophy as a Scrum Master.
- Experienced in leading Agile Coaching Workshops and User Story Writing workshops to acquaint stakeholders with Scrum process skeleton and concept.
- Well versed with backlog prioritization techniques such as MOSCOW, Kano model, 100 points, and Paired Comparison.
- Experienced in estimation techniques such as planning poker, t-shirt size, relative mass valuation, bucket method, dot voting to help product owner in picking Product Backlog Items (PBIs) to commit to in the iterations (Sprints).
- Implementation of various retrospective techniques such as Sail boat, Silent writing, happy metrics, star fish, lean coffee, 4L’s, and many more
- Experienced in assisting in INVEST (independent, negotiable, valuable, estimable, small, testable) user stories and SMART (specific, measurable, achievable, reliable, time constrained) tasks.
- Assisted team to remove impediments whether it be team owned impediments, scrum master owned impediments or organizational impediments
- Incorporated efficient Release Planning approaches such as Feature driven and Date driven approach for efficient delivery of PSPI to the stakeholders.
- Worked closely with Product Owner for efficient Backlog grooming and story estimation.
- Provided Agile Coaching to the teams and organizations, which are new to Agile Methodologies and Principles.
- Strong leadership skills and experience in managing multiple teams along with excellent individual contributions.
- Managed requirements and tracked defects, to ensure the code is deployed in production without any Technical Debt.
- Proven expertise in developing Test Cases, Test Strategies, Test Plans, Test Reports, Procedures and Traceability Matrix and documenting defects using HP QC and HP ALM. Collaborated and monitored Black-Box Testing, Smoke Testing, User Acceptance Testing (UAT) and Regression Testing.
- Good Knowledge of creating SQL Queries to create Data Mapping and Data Warehousing. Worthy knowledge of Entity Relationships.
- Extensive knowledge of Databases, Data Table structures, Schemas, Data Marts and OLAP operations such as Roll-up, Drill-down, slice, and dice and pivot.
- Experience working in Three-Tier architecture, Ajax, Web Services (SOAP, WSDL), Client-Side Validation, and Server-Side Validation.
- Involved in scripting business logic in the web methods of Web Services and documenting the Web Service Level Agreement (WSLA) document through XML.
- Excellent analytical, problem solving, communication and documentation skills. Dedicated & Self- motivated, proven leadership capabilities and time management skills.
TECHNICAL SKILLS
Application Packages: MS Office (Word, Excel, PowerPoint, SharePoint 2013, Project, Visio, Access)
Methodologies & Framework: Experienced in Waterfall, RUP methodologies, Scrum framework, Scrum Hybrid
Business Analysis: Crystal Reports, Rational Rose, UML
Modeling Tools: MS Visio, Mock-Up Screens, Rational Rose, Rational Requisite Pro
Databases: MySQL, MS SQL, MS Access, Oracle 9i,10G, DB2
Modeling and Designing Tools: Rational Rose, MS Visio, Rational Requisite Pro, Mock up screens
Testing Tools: HP ALM 11.5, HP QC, HP Service Center, Bugzilla
ETL Tools: Informatica Power Center, SQL Server Integration Services (SSIS)
Reporting Tools: IBM Cognos, Tableau, SQL Server Reporting Services (SSRS), Power BI
Team Management Tools: JIRA, Version one, TFS
PROFESSIONAL EXPERIENCE
Confidential, Buffalo, NY
Sr. Business System Analyst
Responsibilities:
- Conducted multiple Interviews, Brainstorming, Requirements Workshop and JAD sessions with business owners, development teams, SAS analysts, DB admins, financial analysts, and Subject matter experts to elicit requirements regarding scenarios, business rules, compliance & regulations, and reporting requirements.
- Generated OLAP strategy to understand nature of the Business and Its Impact.
- Involved in business process reengineering (BPR) by conducting Process modelling, SWOT analysis, Document analysis, and GAP analysis to analyze As-Is business process and the To-Be system.
- Learned more about the regulations involved such as Financial Crimes Enforcement Network (FinCEN), Know Your Customer (KYC), Bank Secrecy Act (BSA), and Anti-Money Laundering (AML) compliance procedures.
- Created Business Requirement document (BRD) to in corporate high-level business requirements, and Software Requirements Specification (SRS) for functional, non-functional, Data, and GUI requirements.
- Created UML diagrams like use cases, activity, sequence, data flow diagrams using MS VISIO.
- Designed wireframes, prototypes and Mock ups using Balsamiq to communicate what the software solution will look like to the business users.
- Responsible for identifying data sources from internal systems, external systems, silos on legacy systems, third party systems, social media, clickstream for the Enterprise Data Hub (EDH) using Cloudera.
- Acted as a liaison between Hadoop administrators, developers and business users.
- Responsible to transfer data from Oracle 11g to HDFS using Sqoop module.
- Gathered requirements on the different frequencies of data ingest (Batch/streamed real-time/part-time) to be loaded on the EDH using Spark, Flume, Sqoop, Pig (Hadoop services).
- Identified and defined Data sources and conducted Data profiling, Data cleansing, and Data enrichment
- Performed root cause analysis to identify data quality problems, and historical trends.
- Modelled various use cases, Sequence Diagrams, Activity Diagrams.
- Responsible for creation of ER diagrams like Conceptual and Logical diagrams and Collaborated with database developer in developing physical diagram for Knowledge Center that stores Alerts.
- Elicited and documented Risk Scenarios for Alerts and Risk factors for each Alert with the SMEs and Users.
- Recommended to use Kafka instead of JMS for the messenger service.
- Elicited requirements and assisted in the development of alerts-score based triage criterions, case packaging, and the requirements for UI & report elements of the Investigation Manager module.
- Elicited and documented requirements for data optimization and packaged data management schema for the consumption of SAS Analytics engine.
- Made a Report Visualization checklist required by the SAS Financial Crime Suite.
- Assisted in configuring dash boards and reports in SAS Visualization. Involved in creation of User Acceptance Test cases and plans, defect tracking using JIRA and validated reports and dashboards.
- Facilitated and time-boxed Scrum ceremonies like Sprint Planning, Daily Scrum, Sprint Review and Retrospective meetings.
- Helped negotiating commitments and assured parallel understanding of requirements and deliverables amongst all stakeholders in Sprint Planning Meetings.
- Created User Stories and led the Planning Poker game to estimate them in Sprint Planning and Backlog Grooming meetings.
- Reviewed Sprint Burn down and Release Burn down Charts to maintain team’s velocity.
- Timely assured development team had necessary resources to perform up to potential, tracked and removed impediments.
- Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increment (PSPI) and help decide which features met the definition of Done, DoD using the acceptance criteria.
- Helped resolved team and organizational level impediments.
- At the end of each sprint conducted Sprint Retrospective meetings such as Silent Writing, Star Fish techniques so each stakeholder can freely express their opinions and suggest improvement measures.
- Helped the Product Owner to Prioritize the Product Backlog items using MOSCOW technique for developing Sprint tasks by taking suggestions from team.
- Used JIRA for drafting user stories, allotting tasks, backlog management, issue tracking, user story maps and generating reports.
- Maintained the Task Board that was referred to during the daily stand-ups that helped the team track the stories To Do, Work in Progress, Done and Accepted.
Environment: Waterfall Scrum Hybrid, JIRA, Confluence, SAS Financial Crime Suite, SAS Base & Data Loader, Cloudera Manager 5.6, Cloudera Navigator, YARN, Sqoop, Flume, MapReduce, Hive, Spark, Impala, Solr, Apache Mahout, Hadoop Distributed File Systems (HDFS), Spark Streaming, XML, XSD, JSON, Oracle 11g, OBIEE suite, Teradata, MS Project, MS Visio, Lucid Chart, SOAP, REST, AJAX.
Confidential, LA
Sr. Business Analyst
Responsibilities:
- Conducted Gap Analysis to understand the ‘As Is’ and ‘To Be’ system by coordinating with the Data Analyst to understand the legacy systems
- Facilitated JAD sessions, Focus Groups for gathering requirements. Conducted interviews to recognize the ‘to be’ model with the Business users, SME’s.
- Analyzed and handled change requests and made sure it went through a systematic impact analysis in coordination with Project manager.
- Documented requirements in BRD, SRS by coordinating with technical team and stakeholders.
- Updated the weekly progress report. Assisted the project manager in updating project documents such as Project plan, WBS and project charter.
- Worked with GUI development team to assist them in creating the initial UI wireframes and mockups using Balsamiq.
- Created activity diagrams, use case to represent the current business process, content flow diagrams to identify the interfaces and the data flow of the system using MS Visio.
- Extensively used MS Share Point for team collaboration.
- Constructed RTM (Requirement Traceability Matrix) to determine the source of requirement, ensure all requirements are met and locate affected system components when there is a requirement change.
- Collaborated with QA team in performing User Acceptance Test (UAT) alongside composing Test Plans and Test Cases utilizing HPQC.
- Effective knowledge of Client side and Server Side Validation and helped with composing verbiage for Client Side Validation using Java Script and Ajax. Used a bootstrap framework to for preparing the UI
Environment: Waterfall, HPQC v10, Microsoft SQL, Microsoft Business Intelligence Development Studio (SSIS, SSRS), MS Visio, .Net, HTML, XML, C#, MVC, SQL DB, ADO.NET.
Confidential, Warren, NJ
Sr. Business Analyst/Scrum master
Responsibilities:
- Conducted Gap Analysis to understand the ‘As Is’ and ‘To Be’ system by coordinating with the Data Analyst to understand the legacy systems.
- Facilitated JAD sessions for gathering requirements. Conducted interviews to recognize the ‘to be’ model with the Data Analysts.
- Analyzed and handled change requests in coordination with Project manager. Documented requirements in BRD, DRD (Data requirement document) by coordinating with technical team and data analysts. Documented Post-migration report
- Worked with stakeholders across the business and acted as a liaison and advocate between the stakeholders and the end users of the data warehouse.
- Assisted translating business requirements into detailed system requirements and technical design specifications with the help of technical team.
- Responsible for Investigating, modelling, defining and documenting required business processes, including business process that improve data collection and quality.
- Worked closely with the users to understand the current state of information availability in the enterprise to identify the future needs based on the analysis of business requirements, current state environments.
- Identified the source systems and data required in the data warehouse environment to meet the users current and potentially future needs.
- Performed gap analysis between the current state and future data warehouse environment identifying data gaps and quality issues and recommended potential solutions.
- Worked closely with the data warehouse development team to ensure user requirements and issues are being addressed while controlling scope.
- Gained a thorough understanding ETL processing methods, underlying data warehouse data models, security, and capabilities of the front-end delivery products.
- Assist data analyst in mapping task.
- Assisted the ETL analysts in preparing the ETL specification document.
- Reviewed models to ascertain that requirements are met.
- Created User stories, Use Cases, Use case diagrams, Workflow Diagrams, and Sequence Diagrams
- Facilitated all Scrum Ceremonies - Backlog grooming, Daily Scum, Sprint Planning, Review, and Retrospective.
- Used Relative Mass Evaluation for estimation, and MoSCoW for prioritization of user stories.
- As a Scrum master, tracked team velocity and Sprint progress using Sprint Burn down Chart and Product Burn down Chart, facilitated time boxed daily scrum meeting. Supported the scrum development team by resolving impediments, maintaining an impediment list, and making that list visible for all teams in the organization.
- Worked with Scrum masters of other team to reduce inter team dependencies.
- Encouraged team members to participate in the code reviews of other teams.
- Responsible for overall coordination of user acceptance testing.
Environment: Waterfall Scrum- Hybrid, Version One, MS Office 2010 (MS Word, MS Excel, MS PowerPoint), Mockup Screens, HP QC, SQL, ASP.NET, Visual Studio 2010, Informatica, Tableau.
Confidential
Business Analyst
Responsibilities:
- Conducted Gap Analysis to understand the ‘As Is’ and ‘To Be’ system by coordinating with the Data Analyst to understand the legacy systems.
- Facilitated JAD sessions for gathering requirements. Conducted interviews to recognize the ‘to be’ model with the Data Analysts.
- Analyzed and handled change requests in coordination with Project manager.
- Documented requirements in BRD, DRD (Data requirement document) by coordinating with technical team and data analysts. Documented Post-migration report.
- Created logical diagrams, star schema diagrams using ERWIN.
- Updated the weekly progress report. Assisted the project manager in updating project documents such as Project plan and project charter.
- Conducted root cause analysis to understand the problem of distributed systems to explain the team about the change.
- Assisted data analyst in data modelling and data mapping for high level requirements using informatica.
- Performed In-depth analysis of ERD and validated it against the system design.
- Utilized Business objects to investigate complex historical data to look for trends, outliners and platforms.
- Created reports using combined queries, slice, dice and drill down.
- Acted as liaison between stakeholders of the project and the ETL team.
- Recommended changes by analyzing legacy data and documented data quality issues.
- Analyzed and confirmed source and target data in database using Oracle Developer
- Assisted the team in the batch migration of the implementation.
- Worked with data analysts to identify areas that need data cleansing and ensured that the needs of the stakeholders were met.
- Created hierarchies for drilling down the data from highest the granularity to the lowest granularity.
- Assisted in testing the database administrators to checkfield size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
Environment: Waterfall SDLC, Version One, MS Office 2010 (MS Word, MS Excel, MS PowerPoint), Mockup Screens, HP QC, SQL, ASP.NET, Visual Studio 2010, Informatica, Tableau.
Confidential
Business Analyst
Responsibilities:
- Assisted PM in creating work breakdown structure and project charter using MS Project.
- 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 product owner to plan how 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.
- Analyzed feasibility of business requirements and defined scope, found out dependencies by interacting with Management Business Analysts, other Subject Matter Experts, Product Owner, Project Manager and Technical Lead.
- Created User Stories and led the Planning Poker game to estimate them in Sprint Planning and Backlog Grooming meetings. Also, helped PO to prioritize user stories based on business value.
- Helped product owner in prioritization of Product Backlog Items (PBIs) including the process of breaking down EPICS into user stories using INVEST criteria.
- Performed extensive prototyping using Mock-Up Screens.
- Handled requirement churn during the project by performing Impact Analysis.
- Checking the feasibility of Change in Requirement and maintaining the triple constraint.
- At the end of each sprint conducted Sprint Retrospective meetings creating the environment for each stakeholder to freely express their opinions and suggest improvement measures.
- Used JIRA for allotting tasks, user story writing, backlog management, issue tracking, user story management and forward and backward requirement traceability.
- Acceptance Criteria for User Stories to perform User Acceptance Testing. Designed Test Cases, Test Plans and Test Scenarios to perform Functional Testing, Smoke Testing and Regression Testing and logged down defects and systematically managed them in JIRA 5.2.
- Created environment for self-organization and organized team engagement activities.
- Created training curriculum and wrote training scripts.
Environment: Waterfall, MS Visio, Mock-Up Screens, AJAX, HTML, CSS, Java MVC, Confidential API carts, MySql5.
Confidential
Business Analyst/QA
Responsibilities:
- Worked closely with the project manager in creating the project proposal and work breakdown structure.
- Facilitated JAD, Brainstorming, interviews to gather smart requirements from business users and SME’S.
- Documented BRD, SRS by making sure all the requirements have been met and base lined those documents.
- Generated UML diagrams like use case, activity and sequence to communicate with the development team.
- Designed mock ups and prototypes using Balsamiq to give the business users an overview on the application being developed.
- Collaborate with and coordinate multiple engineering teams to resolve defects in the system and drive features/alerts to avoid repeats of these incidents.
- Respond and analyze complex inquiries of technical and functional nature not in routine and require deviation from standard procedures.
- Update and manage current working knowledge of Confidential products and technology.
Environment: Waterfall, HTML, CSS, JSP. JAVA MVC, Sriracha Feedback tool, Chromium, Confidential Docs, Neutron feedback tool, Buganizer.