Business Systems Analyst Resume
New Haven, CT
SUMMARY
- 6 years of extensive experience as a Business Analyst in business and functional requirements elicitation, analyzing requirements, statistical data analysis, data mapping, object - oriented designing, Design of Experiments, Regression and Response Surface analysis, Unified Modeling Language (UML), SDLC methodology (Agile, SCRUM, XP, Waterfall).
- Hands - on experience in implementation of various IT processes on ServiceNow such as Incident and Problem Management, Change Management, HR Catalog, Service Catalog, PPM and other ServiceNow modules.
- Proficient in facilitating Joint Application Development (JAD), Rapid Application Development (RAD), and Accelerated Requirement Methodology (ARM) sessions comprising of Enterprise Analysis, Requirements Gathering and Documenting requirements.
- Experience designing and creating User Records in ServiceNow for new users.
- Experience in ServiceNow JIRA integration
- Good knowledge on differentRelational databases like Teradata, Oracle and SQL Server.
- Very efficient at performing GAP analysis to check the compatibility of the existing system infrastructure with the new Business requirements and Best Practices, SWOT analysis, Business Rules Analysis, Impact Analysis (Business, Technical), Risk Analysis and Cost Benefit analysis.
- Knowledge in understanding the data and designing/Implementing the enterprise platforms like Hadoop Data lake and Huge Data warehouses.
- Utilized MS Project and variance analysis to manage schedules, meet deadlines and plan resources in line with triple constraints. Followed up with weekly project status, organized task review meetings, conducted status meetings, managed deadlines, and facilitated prioritization discussions.
- Working knowledge of implementing Service Oriented Architecture involving Web services, Web methods, MT servers and Data mapping.
- Ability to produce high qualityrequirement specifications to support ERP functional design development.
- Efficient at conducting UAT (user acceptance testing), Functionality testing, Unit testing, Integration testing, System testing, Operation Readiness testing and Regression testing.
- Proficient in producing documents like Business Requirements Document (BRD), Functional Requirement Specifications (FRS), Software Requirement Specifications (SRS), Request for Proposals (RFP), and Requirements Traceability Matrix (RTM).
- Adept in creating Use Case diagrams, Activity diagrams, Sequence diagrams, Flowcharts, Key Performance Indicators (KPIs) using MS Visio and experienced in change management.
TECHNICAL SKILLS
Business Tools: MS Project, Lucid chart, MS Visio, MS Excel, MS Word, MS PowerPoint, MS Access, Swim lane chart, JIRA, ServiceNow.
Databases/RDBMS: MS-SQL Server 2008/2005/2000 , Oracle 9i/8i/10i, MS Access, Mainframe, DB2.
Modeling/Requirements Management Tools: UML, Rational Software Architect, Ms Visio.
Operating Systems: Windows 2003/2000/ XP, Solaris 8.0, LINUX 7.3, 8
Languages: C, C++, JAVA, SQL, HTML, CSS, XML, UML
Methodologies / Frameworks: Agile, SDLC / Waterfall, Scrum.
Content Management Tools: SharePoint, Confluence, BOX.
QA Testing / Defect Tracking Tools: HP ALM, HP QC, Zephyr.
PROFESSIONAL EXPERIENCE
Confidential, New Haven, CT
Business Systems Analyst
Responsibilities:
- Interacted with stakeholders and gathered requirements as per the business needs.
- Provided primary liaisons between business/operations/core processing technology team and external development team.
- Utilized Agile Scrum methodology and conducted Daily stand up meeting, Sprint Planning meeting, Sprint Review meeting, and Sprint Retrospective meeting.
- Lead an Agile/Scrum team as Scrum Master for successful development of internal e-service portal on Service Now platform.
- Worked as Product Owner to define product features and write epic user stories on monitor and track business value delivery. Met with business and IT stakeholders to solicit requirements and create user stories.
- Conducted GAP analysis by understanding the AS-IS system and the TO-BE system requirements by having discussions with the SME’s.
- Supported IT PMO in the roll-out of new project management processes and upgrade of the project management tool (Quick base and Kronos).
- Utilized UML for process modeling and created Use Cases, Activity diagrams and Sequence diagrams using MS Visio.
- Experience with creating documentation, data\process analysis, and requirements gathering for IT Service Management (ITSM) processes and corresponding toolsets and functions (e.g. Incident, Problem, Config, Change, Service Level Management)
- Responsible for validation of Position/Job, Compensation, Organizational, and other data elements in Workday Tenants.
- Analyzed and Developed bi-directional integration between Service Now and JIRA using Workato.
- Gathered UI requirements to build service now forms. Created Mock-up screens using Axure.
- Performed Admin responsibilities for JIRA and Confluence. Responsible for upgrading to new versions of JIRA.
- Responsible for understanding and analyzing PMO requirements, developing improved business processes and supporting documentation, maintaining schedules as well as risks and issue management for Confidential Course Search project.
- Responsible for creating Disaster Recovery Plans for over 80 applications handled by the team.
- Performed UAT and performance testing for application submission process at Confidential school of Medicine.
- Responsible for collecting evidences for Banner Auditing from SVN, Kintana, ServiceNow.
- Monitored project status to ensure progress towards completion, required procedural steps are completed fully and timely, participants are informed of progress.
- Responsible for Risk Analysis to detect the risks associated with the development of the new system. Additionally, formulated a Mitigation Plan to remove or reduce risks of high severity and one that would have major financial impacts.
- Worked on Service Now and JIRA ticketing Tools.
- Involved in ensuring the quality of the product by working with QA to develop use cases, review test cases, generate and validate SLA\'s, end-user testing and other success metrics/function.
- Developed Test Plan and Test cases based on the Use cases and Functional specifications.
- Recorded all the test scripts and test results in Zephyr testing which is an add-on for JIRA.
- Conducted meetings/calls and classified the bugs as functional or technical (low, medium, high).
- Collaborated with DBAs to perform data mapping using MS Excel and executed complex SQL queries to filter data from the MS SQL database
- Provided live support and training for the end users.
Environment: AGILE SCRUM Methodology, HTML, SVN, Kintana, JIRA, BPMN, SharePoint 2013, Confluence, Oracle, SQL Server, MS Access, MS Excel and MS Project, Test Director, Confluence, Zephyr Testing.
Confidential
Business Systems Analyst
Responsibilities:
- Interacted with client groups to determine user requirements and goals through interviews, surveys and questionnaires.
- Created Project Charter and Work Breakdown Structure.
- Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications forBusiness Objects Universes and Reports.
- Research current system and document business functionality and articulate epic level user stories and disaggregate into appropriate size for iteration planning.
- Performed Risk Analysis and Impact Analysis in order to be prepared for potential business and technical risks to the system.
- Assisted Process & Service Owners in continuous process improvements and enhancements by encouraging continuous automation of incident, change & problem management process on ServiceNow platform.
- Re-mediate issues on applications and make sure updates are done in ServiceNow. Troubleshoot and perform corrective action on the IT Service Management software HP Service Manager and ServiceNow.
- Prepared corresponding artifacts: FRD (Functional Requirements Document), BRD (Business Requirements Document) and SRS (System Requirements Specification).
- Created affiliate artifacts: Use Cases, Activity diagrams, Sequence diagrams and Interaction diagrams using MS Visio.
- Utilized web services and web methods by understanding the data input and flow of information through various web pages.
- Conduct requirements gathering sessions and document complex requirements, processes, features, and business needs specifically focused on web content management and portal applications
- Utilized Agile Scrum methodology and conducted Daily stand up meeting, Sprint Planning meeting, Sprint Review meeting, and Sprint Retrospective meeting.
- Worked as Product Owner to define product features and write epic user stories on monitor and track business value delivery. Met with business and IT stakeholders to solicit requirements and create user stories.
- Determined the velocity of each sprint and created the Sprint burn down chart, storyboards and Product Backlog and managed Requirements churn.
- Hands on expertise in migrations from MS SQL Server 2000 to MS SQL Server 2005 to MS SQL Server 2008
- Developed user specifications, use case statements and diagrams and documents to produce a statement of work. All data modeling and user interfaces were prototyped using Microsoft Visio.
- Implemented the Incremental methodology of software development with its various workflows, artifacts and activities.
- Identified candidate business processes which leverage SharePoint tools to enhance day-to-day office functions using workflows, Info Path forms.
- Facilitated code review sessions by preparing minutes of the meeting and collecting feedback to prepare the code review document.
- Created QA Test plans, Test Cases for Functional, Integration Testing
- Prepare comparison of expense to budget reports for executives on demandand on weekly, monthly and quarterly basis
- Designed and created Data Quality baseline flow diagram, which includes error handing and test plan flow data.
Environment: AGILE SCRUM Methodology, JIRA, BPMN, SharePoint 2013, Oracle, SQL Server, MS Access, MS Excel and MS Project, Test Director.
Confidential
Business Systems Analyst
Responsibilities:
- Performed requirements gathering from the stakeholders while adhering to SDLC industry best practices.
- Used MS Project to create the project plan, allocate budget, resources and set milestones.
- Used MS Excel to create a field-to-field data map from source to stage and stage to target mapping indicating the source tables, data types, column names and transformations required.
- Prepare comparison of expense to budget reports for executives on demandand on weekly, monthly and quarterly basis
- Created relevant artifacts: Interface Design Document, Detailed Design Document, Supplemental Document and Solution Specification Document.
- Expert in generating and analyzing custom reports and dashboard for management and various business unit personnel to provide detail information on key performance indicators
- Coordinated data migration from old to new system during Teradata system capacity expansion
- Developing a formal strategy for driving the efficiency and effectiveness of the ITIL process in complex business environment.
- Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
- Defined security models with row level data security, role based security etc in Business Objects Universes
- Performed Gap analysis and conducted business modeling by reviewing the existing business artifacts.
- Authored the Functional Requirements Specification (FRS) and Business Requirements Document (BRD) and System Requirements Specification (SRS) for the project.
- Utilized UML for process modeling and created Use Cases, Activity diagrams and Sequence diagrams using Rational Rose and MS Visio.
- Maintained project documents to be used for collaboration with developers, QA, project manager, etc. on SharePoint.
- Implemented Agile Scrum methodology of application development and set the velocity for each sprint cycle.
- Conducted UAT; facilitated discussion between business team and QA team on determine the test requirements and pass/fail criteria; documented and reported user feedbacks to management team.
- Conducted daily Scrum meeting, planning meeting, review meeting, retrospect meeting and created the Product backlog.
- Provided data modeling and migration data and developed user interface mocks using Microsoft Visio.
- Collaborated with DBAs to perform data mapping using MS Excel and executed complex SQL queries to filter data from the MS SQL database.
- Used HP Quality Center for loading the test scripts and logging defects.
- Collaborated with the production team by facilitating the implementation of the application, prepared production certification scripts and performed production certification.
Environment: AGILE Scrum methodology, JIRA, HP-QC, BPMN, SharePoint 2010, Oracle, SQL Server, MS Access, MS Excel, MS Project, and Test Director.
Confidential
Business Systems Analyst
Responsibilities:
- Identified and analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements.
- Contributed to the definition of scope, performed extensive requirement analysis and defined functional specifications.
- Facilitated daily scrum and ensure the integrity of the agile process capturing velocity and removing obstacles to drive success and grooming.
- Promoted Funds and Fixed Income Products internally and externally, increasing awareness of offerings to sales team while also utilizing industry associates and media outlets to promote product awareness.
- Involved in requirement scoping and identifying high priority requirements for implementation.
- Partnered with the business stakeholders, process owners, users to identify their requirements, produced detailed specifications, planned the project deliverables with the software development team.
- Developed Use Case diagrams by analyzing the business process to describe system interaction and functional requirements of the system.
- Effectively conducted user acceptance, unit, integration, usability, and regression testing between the Oracle application and Salesforce as well generate and grant support to SRs all the way through issue resolution
- Created wire frames and developed a prototype of the graphical user interface (GUI) and demonstrated to the stakeholders and business users and took feedback from them.
- Coordinated and conducted joint application development (JAD) and walk through sessions involving business unit stakeholders, technical analyst, project managers thereby utilizing strong interpersonal, oral and written communication skills.
- Worked closely with Developers to review user requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications.
- Tracked defects in Quality Center and worked with QA team to resolve defects.
- Assigned problems to appropriate software development team for fixes.
- Prepared UAT test cases created a list of UAT users and conducted UAT along with them.
- Provided live support and training for the end users.
Environment: MS Office Suite (Word, PowerPoint, Access, Excel, Outlook), MS Project, MS SharePoint, Agile, MS Visio, MS SQL, Business Objects, Quality Center.
Confidential
Business Systems Analyst
Responsibilities:
- Identified and analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements.
- Contributed to the definition of scope, performed extensive requirement analysis and defined functional specifications.
- Authored the Functional Requirements Specification (FRS) and Business Requirements Document (BRD) and System Requirements Specification (SRS) for the project.
- Utilized UML for process modeling and created Use Cases, Activity diagrams and Sequence diagrams using Rational Rose and MS Visio.
- Conducted UAT; facilitated discussion between business team and QA team on determine the test requirements and pass/fail criteria; documented and reported user feedbacks to management team.