Sr. Business/systems Analyst Resume
Greensboro, NC
SUMMARY
- A Business/Systems Analyst with 8+ years’ experience with an understanding of Business Process Flows, Case Tools, and Business Analysis.
- Experience in full Software Development Life Cycle (RUP, Waterfall, Spiral & other SDLC implementation).
- Extensive experience in organizing and facilitating joint application development (JAD) sessions for Requirement Gathering through interviews and workshops with user(s), subject matter experts (SME’s), and business stakeholders.
- Strong noledge of conducting GAP Analysis, SWOT Analysis, Cost Benefit Analysis, Feasibility Analysis, Impact Analysis and Data Analysis.
- Experienced in multiple Systems design and modeling methodologies such as Rational Unified Process - RUP.
- Good noledge and experience of Life, Annuity, 401K/Retirement Solution.
- Proficient in interacting with business users to identify information needs and initiating process changes and creating Use Cases, Use Case diagrams, Activity Diagrams, Class diagram, Sequence diagram based on UML methodology using tools like Rational Rose and MS Visio
- Extensive experience in organizing and facilitating joint application development (JAD) sessions through interviews and workshops with user(s), subject matter experts (SME’s), and business stakeholders.
- Generated Requirement Traceability Matrices (RTM) to ensure that all the requirements are covered by the test cases
- Creating Work Breakdown Structures (WBS), Project Schedules and Project Timelines
- Extensive noledge of Web Service, its application, related Web Methods and the functionality of Service Oriented Architecture (SOA).
- Well versed in documentation of Product Definition Document (PDD), Business Requirements Documentation and Systems Requirement Specification (SRS).
- Strong noledge of SQL and extraction/ transformation/ loading (ETL) process using SQL scripts.
- Created Data Mapping Documents and worked with business to write transformation rules.
- Experience in creating and executing test plans for functional tests, QA tests, regression tests, smoke tests and UAT
- Good analytical and communication skills and ability to work independently with minimal supervision and also a great team player.
- TEMPEffective Project Scope Change Management and Configuration Change Management skills.
- Organized weekly Project Status and Task Review meetings.
- Created PowerPoint presentations and project updates using MS Project for management review.
TECHNICAL SKILLS
Méthodologies: SDLC; Waterfall, Six Sigma (DMAIC), Spiral, Agile (SCRUM), LEAN Principals
System Platform: Windows 98/2000/XP/Vista/7, Mac OSX
Development technologies: HTML, CSS, .Net ( ASP, C#), Java, JavaScript, AJAX and PHP
Business Management Tools: GAP, SWOT, ROI, CPM, Cost-Benefit & Impact Analysis
Databases & DB Tools: MS SQL Server, Oracle, Mainframes, OLAP
Business Process Modeling Tools: MS VISIO, RUP Tools, BPMN
Test Tools: Manual Testing, User Acceptance Testing, Database Testing, GUI Testing
Documentation Tools: Share Point 2007, SharePoint 2010, MS Office (Word/Excel /Power Point/ Visio)
Other Tools: MS Project, JIRA, Rational Rose, Rational Pre Requisite Pro, Rational ClearCase, Rational ClearQuest, QC/QTP, Test Director, LoadRunner
SOA Technologies & Languages: XML, SOAP, WSDL, Altova XMLSpy
PROFESSIONAL EXPERIENCE
Confidential, Greensboro NC
Sr. Business/Systems Analyst
Responsibilities:
- Created four System Requirement Specification Documents (SRS) for the LifeComp Employer and Consumer registrations and landing pages from the Business Requirement Documents (BRD).
- Used validation tools for client side validation and server side validations.
- Created PRS documents for the Performance testing team to help them understand registration flows.
- Wrote Queries in Squirrel SQL Client and DB Visualizer to provide testing data to QA and Performance Testing Team.
- Used SOAP UI to provide validated data for QA team.
- Performed Smoke Testing to pre-test for any major defects to support the QA team.
- Used HP ALM to look up defects and issues raised by testing activities.
- Performed Defect Tracking and Change Control procedures using ALM.
- Wrote SQL queries to conduct Data Validation tests and Data Integrity tests and involved in testing through test scripts and test plans.
- Worked on registration application for different users including Life, Annuity, Retirement plan sponsor and Retirement Plan Participants.
- Worked as a Business System Analyst as well as an Assistant Project Manager to guide the team through the conversion process employing Agile Model.
- Created and maintained the process documents for the project to be used for collaboration with developers, project manager, testing team etc. on SharePoint.
- Executed daily SCRUM planning and SCRUM meeting.
- Participated in SCRUM meetings and worked closely with the Subject Matter Expert and the Scrum Master.
- Involved in various stages of code conversion in Workbench including Development, Testing and Production.
- Played a key role in the user acceptance testing (UAT), and implementation of Systems.
Environment: AGILE SCRUM Methodology, SOAP, WSDL, XML, HP ALM/QC, SharePoint 2010, Oracle, Squirrel SQL Client, MS Access, MS Excel and MS Project, OIM, OAAM.
Confidential, Jersey City NJ
Sr. Business/Systems Analyst
Responsibilities:
- Involved in various activities of the project like information gathering, analyzing the information; gatheird, documenting the Functional Requirements and Business Requirements using Rational Requisite Pro.
- Worked as a Business Analyst as well as an Assistant Project Manager to guide the team through the conversion process employing Agile Model.
- Facilitating JAD session follow-up for Project Plan updates, gained consensus for User Acceptance Testing requirements.
- Created and maintained the process documents for the project to be used for collaboration with developers, project manager, etc on SharePoint.
- Used validation tools for client side validation and server side validations.
- Participated in SCRUM meetings and worked closely with the Subject Matter Expert and the Scrum Master.
- Used MS Word, MS Excel, MS Access, MS Project, and MS Visio for documentation and analysis reports among other project management and reporting tools.
- Involved in various stages of code conversion in Workbench including Development, Testing, Stage and Production.
- Performed Defect Tracking and Change Control procedures using ALM and Rational Clear Quest.
- Data is normalized and DE normalized as needed by Data Warehouse Business Analysts.
- Used HP ALM to look up defects and issues raised by testing activities.
- Produced and managed documentation on release activities to support problem resolution.
- Wrote SQL queries to conduct Data Validation tests and Data Integrity tests and involved in testing through test scripts and test plans.
- Produced and managed documentation on release activities to support problem resolution.
Environment: AGILE SCRUM Methodology, ASP.net, C#, JAVA, OLAP, JavaScript, HTML, SOAP, WSDL, XML, HP ALM/QC, SharePoint 2010, Oracle, SQL Server, MS Access, MS Excel and MS Project, Test Director.
Confidential, Oaks PA
Sr. Business/Systems Analyst
Responsibilities:
- Involved in various activities of the project like information gathering, analyzing the information; gatheird, documenting the Functional Requirements and Business Requirements using Rational Requisite Pro.
- Worked as a Business Analyst as well as an Assistant Project Manager to guide the team through the conversion process employing Agile Model.
- Facilitating JAD session follow-up for Project Plan updates, gained consensus for User Acceptance Testing requirements.
- New Web Services with functional Web Methods were used to support the SOA of the To Be model.
- Created and maintained the process documents for the project to be used for collaboration with developers, project manager, etc on SharePoint.
- Executed daily SCRUM meeting.
- Created and maintained data mapping documents.
- Used validation tools for client side validation and server side validations.
- Participated in SCRUM meetings and worked closely with the Subject Matter Expert and the Scrum Master.
- Used MS Word, MS Excel, MS Access, MS Project, and MS Visio for documentation and analysis reports among other project management and reporting tools.
- Organized project tasks, managed team workflow and project scheduling using Team Foundation Server (TFS).
- Involved in various stages of code conversion in Workbench including Development, Testing, Stage and Production.
- Analyzed Portfolio Risk and Market risk of trading.
- Performed Defect Tracking and Change Control Procedures using Rational Clear Quest, and Configuration Management and Version Control using Rational Clear Case.
- Data is normalized and DE normalized as needed by Data Warehouse Business Analysts.
- Used Mercury Quality Center to look up defects and issues raised by testing activities.
- Produced and managed documentation on release activities to support problem resolution.
- Creating the design and technical specifications for the ETL process of the project using MS office tools.
- Provided the ETL team with the Data mapping document and assisted them to create the mappings.
- Wrote SQL queries to conduct Data Validation tests and Data Integrity tests and involved in testing through test scripts and test plans
Environment: AGILE SCRUM Methodology, ASP.net, C#, JAVA, OLAP, JavaScript, HTML, SOAP, WSDL, XML JIRA, SharePoint 2010, Oracle, SQL Server, MS Access, MS Excel and MS Project, Test Director.
Confidential
Sr. Business Systems Analyst
Responsibilities:
- Coordinated with the PM for project planning using MS-Project and to discuss project Technologies and methodologies, Cost-benefit analysis, SWOT analysis, WBS and project milestones, estimated budget allocations, scheduling, CPM, and risk analysis & mitigation.
- Conducted business modeling by analyzing the current business artifacts, many of which were based on the tightly coupled 3-tier architecture.
- Facilitated and managed meeting sessions with committee of SMEs from various business areas.
- Performed Gap Analysis to check the compatibility of the existing Systems infrastructure with the new business requirements.
- Analyzed clients Portfolio Risk based on their liquidity needs.
- Authored Business Requirements Document after conducting JAD sessions with the several stakeholders from the Business Area, Capital Markets IT group and the Application Development team.
- Analyze business requirements and segregated them into Use Cases and activity diagrams using Rational Rose.
- Maintained Requirement Traceability Matrix (RTM) throughout the project.
- Various versions of the documents generated during the project were maintained and managed using Rational ClearCase.
- Used Complex SQL queries and Data Modeling Techniques to work on the databases and to find out their dependencies.
- Developing and executing test cases, test scripts and test plans. Collaborate with SharePoint admin, SQL admin, SharePoint developer and project management teams from the design to the delivery of SharePoint applications and portals.
- Provide technical leadership, architectural assistance and hands-on development, migration and implementation support to the SharePoint Practice.
- Created GUI specifications with Page flows, wireframes, page business actions and screen mock-ups, and also created dynamic GUIs in HTML and CSS for better visualization and understanding of the software solution.
- Actively participated in daily bug triage meetings, reviews and walkthroughs and interacted with developers to ensure QA for high quality software.
- Interacting with the developers on resolving the reported bugs and various technical issues.
- Assisted with user testing of Systems (User Acceptance Testing), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
Environment: Agile Scrum,ASP.Net, C#, Java, AJAX, JavaScript, OLAP, Log Viewer, Rational ClearQuest, MS Visio, QTP, HTML, XML, SOAP, Test Manager, RUP, Rational Rose, Test Director, MS SQL Server 2000,, SharePoint 2010.
Confidential
Business/Systems Analyst
Responsibilities:
- Performed requirements gathering from the business users of the System while adhering to SDLC industry best practices. Created cash flow models for Mortgage Backed Securities, Whole Loans, Structured Securities using Bloomberg, Intex and ADCO data.
- Interacted with Software development team and Business users as a liaison in helping developers to understand the business requirements theirby ensuring the proposed applications comply with the business specifications.
- Conducted JAD sessions with the project stakeholders including tech leads of the project development and testing teams to come up with the idea and feasibility analysis of implementing the PMS application using service oriented architecture.
- Prepared project plan and defined different milestones.
- Met with different business users to determine user requirements and goals.
- Worked with QA testing team to design test methods to verify the applications functions of consumer loan, home equity, refinance and commercial loan activities
- Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
- Analyzed the System to be implemented for production to ensure that it handles complete and accurate data and performs default method of calculations for various mortgage products like Mortgage Backed Securities, Asset Backed Securities, and Megas & Tranches
- Designed and developed Use Cases Diagrams, Activity Diagrams, and Sequence Diagrams using UML.
- Discussed different functional requirements and defined high level design and Use Cases.
- Used MS Excel and MS Word to create a field-to-field data map that was used as a main specification document for the conversion program.
- Created Functional Test scenarios, Test Cases / Scripts based on the specifications manually.
- Involved in Systems Testing / Functional Testing of the application
- Wrote User Acceptance Test Plan based on business users requirements and reviewed Test Plan templates.
- Developed requirement traceability matrix (RTM) for maintaining/updating Systems requirements using MS Excel.
- Delivered and maintained extensive documentation for future extendibility of the Systems
Environment: Agile, Microsoft Office Suite, MS-Project, ASP.net, C#, HP QC, Test Director, JAVA, SQL 2005, Visio, HTML, XML, SOAP, UML, Windows, C#, Rational Rose and Requisite Pro
Confidential
Business Analyst
Responsibilities:
- Responsible for requirements gathering, analysis & design, and preparing artifacts in waterfall methodology.
- Responsible for conducting Feasibility analysis, CPA and WBS for multiple releases and upgrades that are delivered to Channel stake holders.
- Facilitated JAD sessions to identify, understand and document requirements and operated as a liaison between the technical team and the businessusers.
- Created use case diagram, use case document, activity diagram and businessprocess flows.
- Developed businessrequirements, user requirements and functional requirements, and documented the same by creating businessrequirement document, use case document and functional requirement document.
- Documented workflow and results of businessanalysis done and obtained sign-off from client on specifications.
- Conducted gap analysis and documented the gap analysis document using Excel.
- Documented all the artifacts in Microsoft SharePoint for version controlling and common point accessibility purpose.
- Resolved issues and improvised the process to ensure a stable and accurate solution.
- Use SQL noledge to create test plans, test cases, test scripts and testing traceability matrix.
- Developed test strategies for User Acceptance Testing (UAT).
- Used HP Quality center for loading the test scripts and logging the defects.
- Coordinated the QA and testing efforts during the IDE1 (PL1) & IDE2 (PL2) phases by reviewing, creating, validating and executing test plans, test cases and test scripts and also reviewing test performance results.
- Conducted application demos and functional reviews with developers and stakeholders.Retrieved and processed data by writing
- Prepared the production certification scripts and performed the production certification.
- Communicated the project status and ensured the team stays on track to satisfy the businessneeds.
Environment: Agile/Scrum, MS Visio, MS Access, XML, SQL, HP Quality Center, MS Office, Windows 2000/XP.