Sr. Business Systems Analyst Resume
Boston, MA
SUMMARY
- A Skilled IT Specialist Proficient, Result & Detail Oriented, Proactive, Self - Radiant and Commercially Savvy Senior Business System Analyst wif 8+ years of experience of high productivity.
- Driven by strong leadership, strong work ethics and high competence wif exceptional interpersonal, written & verbal communication skills shared wif ability to work under pressure to keep up wif teh deadlines.
- Experience working in array of industries including Banking and Retail. Ability to quickly grasp new concepts and processes while working vertically across teh organization and end users to ensure accurate and timely completion of large & small-scale projects.
- Proficient in Business Requirements elicitation, gathering, analysis and documentation.
- Excellent understanding and experience in System Development Life Cycle (SDLC) Governance and Collaboration from project Initiation to Deployment of teh project.
- Experience working wif Waterfall model, Waterfall-scrum hybrid, Spiral model, Agile-Scrum.
- Proficient in networking wif individuals at various levels while organizing, conducting and facilitating elicitation sessions such as survey/questionnaires, interviews, brainstorming, focus group, requirement workshops, interface analysis, document analysis, and JAD sessions.
- Good experience in conducting Joint Requirements Development(JRD), Joint application Modelling (JAM) and Rapid Application Development (RAD).
- Thorough and Clear documentation for business & technical complexity like Business Requirements Document (BRD), Functional Requirements Documents (FRD), Software Requirement Specifications (SRS), Meeting Minutes, Use Case documentation, High level and Low-level documents (HLD/LLD), Business Rules Spreadsheet and Requirement Traceability Matrices.
- Good understanding in preparing Responsible, Accountable, Consulted, and Informed (RACI) Matrix.
- Dedicated & Self-motivated individual wif excellent analytical and interpersonal skills wif ability to negotiate and interact wif end-users/clients, Subject Matter Experts (SME’s) and Project Stakeholders.
- Well acquainted in creating page mock-ups, wireframes and Unified Modeling Language (UML) diagrams including Use Cases, Activity charts, Sequence diagrams, Entity Relationship diagrams and Data flow diagrams (DFD’s) using MS-Visio thus assisting development team in preparing Business Process Model.
- Experience in applying business analysis techniques like GAP Analysis, SWOT, Impact Analysis, Root-case identification, Cost-Benefit analysis, Feasibility study, Technical Risk Analysis, Business Risk Analysis and As-Is and To-Be to analyze business opportunities.
- Involved in teh creating teh User Interface Specification (UI Specification) Document as per project specification wif teh halp of development team. Conducted Joint Requirements Planning (JRP) sessions as a facilitator to gather requirements from teh business area and to discuss different critical success factors of teh project like Operational Feasibility Analysis and Technical Feasibility Analysis.
- Created Training Script and conducted Training Sessions for teh end users in teh production environment.
- Possess extensive noledge in understanding different Data Warehouse Architectures like Centralized Architecture, Dependent Bus Architecture, Independent Data Marts, Hub and Spoke Architecture.
- Experience in preparing a date warehouse requirement documents, iteration matrix and business matrix.
- Possess strong noledge on concepts like data profiling, data mining, data migrating, data mapping, ETL process, data masking, top down and bottom up approach, OLTP, OLAP, MOLAP, ROLAP & HOLAP.
- Experience in using Excel for performing slicing, dicing, pivoting, Roll-up and Drill down operations.
- Strong noledge on Subject Oriented Architecture (SOA), Three-tier & N-tier Architecture, XML parsers, SAX, DOM, Web services (SOAP & REST), Client-Side Validation, Server-Side Validation.
- Certified Scrum Master wif experience working on Scrum Process, Scrum Artifacts & Scrum Ceremonies.
- Well acquainted in facilitating Sprint Ceremonies (Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective) for each sprint in Agile Scrum Methodology as a Scrum Master.
- Experienced in writing User stories and prioritizing them using prioritizing techniques like MoSCoW, KANO and Business Value Based prioritization. Efficient in handling teh Requirement Churn.
- Experienced in using Estimation techniques like Planning Poker, T-shirt sizing, Relative mass evaluation assisting teh product owner in choosing Product Backlog Items (PBIs) to commit to in teh Sprints.
- Extensive noledge on Testing Life Cycle and collaborated in preparing Test Plans, Test Cases, Test Scenarios, Test Documents, Test Scripts, defect logs and monitored User Acceptance Testing (UAT), Regression Testing, Smoke Testing, Black Box Testing and System Integration Testing (SIT).
- Understanding of Test Driven Development (TDD), Behavior Driven Development (BDD), and Acceptance Test Driven Development (ATDD) which are used in test-centric development.
- Excellent communication, analytical, problem solving, and management skills wif an eagerness to learn new technologies and team building capability.
TECHNICAL SKILLS
Methodologies: Waterfall, Agile-SCRUM, Scrum-Waterfall Hybrid, SAFe, KANBAN
Business Modelling Tools: MS VISIO, Balsamiq, Lucid Chart.
Project Management: CA Agile-Rally, JIRA, Microsoft SharePoint, Team Foundation Server, HP ALM, Confluence, MS-Project.
Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Roll Up/Drill Down, Pivot table.
Database/ ETL: MS Access, Oracle DB, SQL Server, Citrix Virtual Database, Informatica v9.1 & v9.5- Power Center and Data Quality, SSIS.
Reporting/ BI: Tableau v9, Spotfire, QlikView v10, SSRS, Jasper Soft, Microsoft Power BI.
Languages: SQL, HTML, XML, Java
Defect Tracking/ Testing Tools: HP QC, Load Runner, Bugzilla v3.2, Swagger, Soap UI v5.2
PROFESSIONAL EXPERIENCE
Confidential, Boston, MA
Sr. Business Systems Analyst
Responsibilities:
- Acted as liaison between teh IT Development team, Financial analysis team and teh Financial reporting teams.
- Recording teh requirements gathered by interacting wif teh Subject Matter Expert’s and stakeholders and documenting them to be understandable and reviewed by both business and technical people.
- Prepared RACI Matrix to identify and categorize Responsible, Accountable, Consultant and Informed stakeholders involved in teh project.
- Facilitated meetings and conducted interviews and JAD sessions wif various stakeholders and studied on new enhancement requirements for teh project.
- Handled teh triple constraints of teh project - Scope, Time & Resources and managed change requests.
- Performed impact analysis of teh change requests proposed and validated them.
- Performed feature analysis and developed Request for Proposal(RFP) document. Helped teh team to choose teh right services for implementation by doing Cost Benefit Analysis and Feasibility Analysis.
- Created Use case diagrams for teh requirements using MS Visio to be understandable to teh team.
- Involved in facilitating Daily Stand-up meetings, Sprint planning, Sprint review meetings, Backlog grooming meetings and Sprint Retrospectives as a Scrum Master.
- Collaborated wif teh development team in removing impediments and halped teh team to deliver Potentially Shippable Product Increment(PSPI) by teh end of every sprint.
- Assisted teh Product Owner in writing and prioritizing user stories in teh product Backlog.
- Helped teh development team in writing good acceptance criteria for user stories and ensured on proper decomposition of teh user stories into tasks to work on them.
- Tracked teh velocity of teh team after every sprint and showcased sprint Burnup and Burndown charts to teh team motivating them and to teh other stakeholders involved in teh project.
- Helped teh team in deploying Apache Kafka Zookeeper for building real-time streaming data pipelines and worked on migrating teh data into it and on creating topics and partitions.
- Partially performed in documenting ETL (Extract, Transform & Load) operations using Informatica.
- Performed normalization and de-normalization of data to fit OLTP and OLAP frameworks and possess good understanding on slicing and dicing of data marts for analytical decision-making support.
- Worked on APIs to get teh real time streaming data from User interface to teh application server.
- Worked on service-oriented architecture (SOA), REST, SOAP, XML, API.
- Actively involved in Data Mapping modeler operations in documenting teh data mapping requirements setting up teh Primary and Foreign key constraints.
- Assisted in System Integration and System Testing to ensure teh modules are performing optimally.
- Assisted in executing test plans and test cases and worked wif QA team for User Acceptance Testing (UAT) using HP ALM.
- For managing Application life cycle, tracking issues and for traceability of requirements, we used Jira.
- Used Jenkins for Continuous Integration and confluence integrating into Jira for team’s collaboration.
- Maintained Compliance assurance by following regulations specified by teh BASEL, CCAR and Dodd-Frank Act and developed a comprehensive understanding of Interest rate risk, Commodity risk, Equity risk and Currency risk.
Environment: Waterfall-Scrum Hybrid, JIRA v7.2, Confluence v5, MS Visio, MS Project, Apache Kafka Zookeeper v3.4, kinesis-kafka-connector licensed v2.0, Amazon Redshift v1.2 & v1.3, Informatica v9, SoapUI v5.2, Tableau v9.0, Jenkins, XML Spy, HP ALM v11.
Confidential, Pennington, NJ
Sr. Business Analyst/ Scrum Master
Responsibilities:
- Prepared and analyzed AS-IS and TO-BE documents in teh existing architecture and performed Gap Analysis.
- Worked closely wif stakeholders involved in teh project to fully understand teh project by interviews, observations and recorded all teh requirements.
- Studied and developed a good understanding of Investment Strategies, Research Affiliates calculation, Financial Instruments, Asset allocation, Stocks, Corporate Bonds.
- Ensured compliance wif various compliance regulations such as Sarbanes-Oxley and Dodd-Frank Act.
- Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, Master Data Elements (MDE), Request Change Notification (RCN) and Change Request (CR) document for system application development.
- Coordinated JAD session wif system analysts, development team, project manager for application development and Pre-validation specifications.
- Conducted Interviews wif various stakeholders for requirements elicitation and analyzed various documents related to teh project.
- Facilitated Story writing session wif teh Product Owner and worked on decomposing teh scope from Business Requirements document(BRD) into user stories.
- Worked wif teh team and teh Product Owner in writing Acceptance Criteria and Definition of Done for all teh functional and non-functional requirements.
- Helped teh product owner in writing User stories adhering to scrum TEMPprincipals - independent, negotiable, valuable, estimable, small and testable (INVEST) and estimating them in sprint planning and Backlog refinement meeting using Relative mass valuation and Planning poker game.
- Facilitated requirements prioritization meetings using MoSCoW and Business Value based techniques and halped teh team in prioritizing user stories.
- Worked closely wif teh team in resolving any impediments that teh team is facing on a daily basis and tracking teh velocity and sprint progress using Sprint burndown and Product burndown charts.
- Worked on Use Cases, use case diagrams and Sequence Diagrams using Lucid Chart application.
- Managed onshore and offshore teams working in different time zones and coordinated using project management tool Rally and meetings over Cisco WebEx communication software.
- Involved in Test Planning, Test Preparation, Test Execution and Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance wif teh Business Requirements.
- Defined Acceptance Criteria for User Stories to perform User Acceptance Testing(UAT). Designed Test Cases, Test Plans, Test Scripts, and Test Scenarios to perform Functional Testing, and Regression Testing and logged down defects.
- Used Spotfire and MS Excel (Pivot Tables, Lookups and Macros) for reporting and analyzing teh portfolio performance and fixed income analytics such as NAV, NPV, P&L, Asset Allocation, Cash Flows, Profit and Losses of hedge.
- Proven record of Team Management and Leadership Skills, conducted various team collaboration and management activities to encourage self-organization wifin teh team.
Environment: Scrum-Waterfall Hybrid, KANBAN, Microsoft office suite 2013, MS project, Lucid Chart, AJAX, JAVA EE 7, Oracle 11g, Spotfire v6, Rally, Cisco WebEx, Eclipse, Bloomberg B-Pipe, Thomson Reuters.
Confidential, Melbourne, FL
Sr. Business Systems Analyst
Responsibilities:
- Conducted JAD Sessions, Interviews and Joint Requirements Planning (JRP) sessions as a facilitator to gather requirements from teh business.
- Developed good understanding of teh various steps involved in teh data migration into Data warehousing.
- Facilitated meetings wif Data Architects, Enterprise architects and Solution advisors to understand teh problem statements and to resolve them.
- Assisted Project Manager in documenting Business case document and analyzed on different critical success factors of teh project like Operational Feasibility Analysis, Technical Feasibility Analysis, Cost Benefit Analysis.
- Reviewed various documents to understand teh AS-IS system and developed various To-Be system concepts and showcased to teh team using Business process flow diagrams.
- Created High level documents like Business Requirements Document(BRD) and drafted System requirement specification(SRS) document.
- Designed and created Use cases, Activity diagrams, Class diagrams and UML models using MS Visio.
- Assisted teh Project Manager in setting realistic project expectations, in evaluating teh impact of changes.
- Helped in maintaining teh Bill Inmon and Ralph Kimball Paradigms and integrated various OLTP to teh OLAP by using SSIS/SSAS as an ETL tool and used SSRS as reporting tool.
- Performed Data Normalization in achieving Data Integrity and to maintain data accuracy and TEMPTEMPeffectiveness, performed Data Verification and validation.
- Formulated SQL queries by performing Data Mining to find correlation and pattern in existing data.
- Point of contact during Planning, testing, and implementation of system enhancements & conversions.
- Created Data Marts wif Bus Architecture and mapped data and maintained data repository using ETL.
- Helped in creating Snow flake schemas and Dimensional model architects in providing business rules.
- Created audit trails and logs to ensure that all data TEMPhas been correctly migrated.
- Performed User Acceptance Testing (UAT), Functional Testing and Regression Testing.
- Developed timelines wifin teh team for project delivery, and managed projects and resources for successful completion.
Environment: SDLC Waterfall, MS office suite 2010 (Word, Excel, PowerPoint and Visio), MS Project, Oracle 11g, MS SQL 2008, MySQL Workbench v5.2, SQL Server Integration Services(SSIS), SQL Server Reporting Service(SSRS), SQL Server Analysis Service(SSAS), HP ALM v11, JIRA.
Confidential, Chicago, Illinois
Sr. Business System Analyst
Responsibilities:
- Developed good understanding of CCAR norms, Dodd-Frank Act stress testing (DFAST) and internal capital adequacy assessment processes.
- Analyzed teh business case for teh project to understand teh organizational needs. Captured and defined teh vision and scope of teh project in teh project planning.
- Created sample of data prototypes for approval from sponsors from business owners.
- Worked as a liaison between business and technical teams to communicate requirement prioritization and level of effort (LOE) to make sure highest value features are given higher priority.
- Communicated TEMPTEMPeffectively across company contacts and clients, internal team about teh project requirements, schedules and releases.
- Analyzed and gathered requirements for preparation of Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specification (SRS).
- Responsible for identifying and documenting business rules and creating detailed diagrams including Use Cases, Use Case diagrams, Business Flow diagram, Creating process models, Data flow diagrams.
- Prepared Business process models; used Visio to create process flow diagrams for management and mapping teh logical aspects of teh process.
- Used Informatica for Extraction, Transformation and Loading; Jasper Soft reporting tool for report generation of teh data to be analyzed from teh data warehouses and data marts and in handling data manipulation, mapping and loading teh data into teh data warehouse.
- For Server-Side Validation, made sure that teh right Data Triggers were implemented to instantiate teh UDDI Lookup at teh right time; validated and mapped teh automatically generated WSDL’s to check if they are rightly linked to teh UDDI along wif mapping Third Party Servers to Application Servers in teh form of XML.
- Used Altova MapForce to create data mapping documents mapping a wide variety of complex data to and from input fields from Web Indexes to XML Tags, XSLT Stylesheets, entities and attributes in databases, EDI files, flat files, Excel Spreadsheets, XBRL files and Web Services; used SOAP UI for xml testing to validate Request and Response XML.
- Formulated SQL Queries to generate relevant reports from teh Data Warehouse on Informatica.
- Prepared Requirement Traceability Matrix and interacted wif QA team to ensure quality of software.
- Created Mapping and Modelling process in reference to Data center for reporting.
Environment: SDLC Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, MS Visio, HTML, JAVASCRIPT, CSS, Informatica, MS SQL server 2008, JasperSoft reporting tool, Java, Altova MapForce.
Confidential
Business Analyst
Responsibilities:
- Documented Business and System Requirements Documents by interviewing teh business users.
- Worked closely wif development and testing teams to disseminate functional understanding.
- Working noledge of business process standardization and software development life cycle (SDLC) including analysis, design, development, testing and implementation of software application
- Understanding teh compliance norms published by Visa/ Master card/ Discover and Amex.
- Involved in creating business processes and mockups and wireframes using Balsamiq.
- Created Use Cases diagrams, work flow diagrams and Use Case Scenarios using Rational Rose.
- Conducted Functional Walkthroughs, coaching as well as User Acceptance Testing (UAT) sessions.
Environment: Waterfall, MS-Office Suite, Balsamiq, UML, Rational Rose, MS Project, Unix, HPQC 10, SQL, Java script, HTML, SQL server, Oracle.
Confidential
Business Analyst
Responsibilities:
- Reached to Subject Matter Experts, Project Managers and Process Analysts to understand teh business process and to identify and gather Business Requirements.
- Collaborated and negotiated wif stakeholders in defining project scope boundaries.
- Facilitated various sessions like Joint Requirements Development(JRD), Joint application Modelling (JAM) and Rapid Application Development (RAD) wif various Subject Matter Experts.
- Responsible for day-to-day activities engaging in teh technical management aspects.
- Used Bugzilla software for defects and issue tracking, and to handle teh quality assurance.
- Tracked teh tasks using MS excel in allotting them to teh team and requirement traceability.
- Produced visual models for teh application using UML MS Visio to create Use Cases, Sequence Diagrams.
Environment: Waterfall, MS Visio, MS Office Suite, MS Access, SQL version, Bugzilla, MS Outlook, Skype, MS Office.
Confidential
Network Engineer
Responsibilities:
- Worked on teh data networks including local area networks (LANs), wide area networks (WANs), intranets and extranets.
- Analyzed where teh communication channels are going to be needed and created plans for teh network.
- Conducted meeting wif teh Chief technology officer(CTO) & Senior management if there are any new plans that are to be approved.
- Handled issues/tickets raised through service now.
- Authorized for providing autantication and setting up access controls for teh employees.
- Part of a team size of 7 people in dealing wif teh issues and report generating tool.
- Outstanding interpersonal and leadership skills, motivating teh team and flourishing wif teh best results.
- Has received appreciations from teh senior management and emerged as teh best team for teh year 2010.
Environment: Wireshark Networking tool, Ping software, Service now, MS word 2007, Windows Server 98, windows XP, Dos commands, Internet protocol queries.
