SUMMARY

• Over 7+ Years of Professional Experience as a Business Analyst with Project Management Skills working with Education domains.
• Experience in bug and defect tracking using tools like HP ALM/Quality Center, JIRA.
• Proficient in analyzing and creating Narrative Use Cases, User Stories, Story Boards, Use Case Diagrams, Activity diagrams, Data/Flow/Navigational flow diagrams using UML Tools like MS Visio
• Expert in coordinating implementation and upgrade of the college - wide Banner software systems for the areas that are the responsibility of the Controller's Office.
• Experience in creating, Process f low, and Sequence, Collaboration and Activity diagrams.
• Experience in supporting releases, testing, changes, and control table maintenance of HR module of Ellucian Banner ERP system.
• Extensive experience in analyzing and gathering requirements
• Exceptional working experience in GAP analysis and understanding of the AS-IS and TO-BE business processes
• Involved in maintaining Test Matrix and Traceability Matrix and performed Gap Analysis
• Performed User Acceptance Testing (UAT) manually.
• Expertise in conducting Stakeholder Analysis to define process stakeholders, and their roles & responsibilities towards the project.
• Excellent skills in facilitating Joint Application Development (JAD) for eliciting functional requirements that support the High Level business requirements
• Expertise in Class diagrams, Object diagrams, GAP Analysis, Use case diagrams, State diagrams, Sequence diagrams, Activity diagrams, and Collaboration diagrams
• Worked on multiple data analysis task to analyze data, tables and other database contents.
• Highly effective management and organizational skills with ability to prioritize
• Ability to manage (Multiple) project tasks with changing priorities and tight deadlines.
• Ability to work well in a team. Open to team related tasks, team meetings, team interaction and conference calls.

PROFESSIONAL EXPERIENCE

Confidential, Ohio

Senior Business Analyst (Banner)

Responsibility:

• Gathered requirements and conducted interviews with business users and Project Manager to understand the needs of the application
• Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
• Manage & conduct firm-wide communications, marketing materials/presentations and training sessions for FAs/CAs. Design announcement banner for all internal FA portals and prepare customized materials according to target audience.
• Worked with Ellucian’s Banner ERP system.
• Created documents like the Business Glossary, Actors Catalog and Data Dictionary. Created Use-Case Models using Rational Rose for process flow and Use-Cases in various Business Processes and identification of Basic/Alternative flows and definition of preconditions and post conditions of the Banner System.
• Reviewed Banner documentation, coordinate upgrades and create test plans for new releases
• Wrote Complex SQL queries and optimizing SQL Queries
• Worked on Ellucian’s Student Functional Review Committee responsible for soliciting, reviewing, testing and recommending enhancements to the baseline product.
• Reviews and tests the functionality of student database upgrades (Ellucian ERP Banner, and Luminus portal).
• Gathered requirements from offshore application users to customize aspects of system functionality to fit their needs. Created data models and business process models using Visio. Followed top down leveled technique for building the Business Process Models.
• Analyzed and documented current state workflow and developed future state using MS Visio, Rational Rose.
• Created Use Case Diagrams, Activity Diagrams, and Process flow diagrams in Visio.
• Advised the team members on emerging technology challenges and opportunities with respect to the Ellucian’s Banner software system and other tools to support the various functions of the Business Office.
• Managed data and files exchanged between Banner and other external systems
• Tested reports and dashboards to ensure continuity and accuracy during source system upgrade (Oracle Student System to Banner) and Cognos upgrades.
• Worked on banner ads and various other digital marketing strategies
• Implemented Agile (Scrum) methodology throughout the Branch and coordinated with Developers over ongoing implementation and upgrade of the college-wide Banner software system (Ellucian) for the areas that are the responsibility of the CFO's Office.
• Used Quality Center for test documentation management and JIRA defect tracking.
• Interacted with Business Users, Development Team and Offshore Business analyst team regarding domain, test designing and defect tracking.
• Performed Regression Testing, Functional, UAT and Ad-hoc testing.
• Used MS Visio to create business process flowcharts and workflow diagrams.
• Responsible for maintaining multiple SharePoint sites/pages and documents library
• Worked with team members to execute various functional and performance test cases
• Wrote complex SQL scripts for Backend testing and Frontend Data validations
• Conducted Joint Application Development (JAD) sessions with IT groups. Responsible for updating changes in functional specification documents and on-boarding document of each application.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge. Tested various sprints using Agile methodology
• Mentored internal BA's who work as system administrators on requirement collection and documentation.
• Involved in providing feedback opportunities with respect to the Ellucian’s Banner software system and other tools to support the various functions of the Controller's Office.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Created Process Flow Diagram, Context Diagram and Activity diagrams using UML.
• Conducted the defect report using Document Generator in JIRA
• Assigned tokens to internal users of applications depending on their roles.

Confidential, Washington, D.C

Business/ Systems Analyst

Responsibilities:

• Documented Student Information System (SIS) components governing Admissions, Registration, Student Accounts, Course Catalog, and Curriculum Management.
• Coordinated with the Banner Support Team to gather the requirements present in the Forms.
• Responsible for Requirement gathering, Business Process flow, Business Process Modeling and Business Analysis with Document and Records Management for Banner Systems.
• Documented and tracked all product defects with use of SQL (reporting).
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data rules.
• Developed Banner requirements integrating Use Case diagrams and designed the testing process flows.
• Work in Agile, scrum, and sprint environment in order to change the requirements and features set.
• Gathered and document business requirements for Intranet using SharePoint
• Executed automated test cases in Quality Center and reported defects in JIRA.
• Conducted analysis, process flow documentation and verification of existing processes with the SME’s.
• Identified Use Cases from the requirements and wrote Use Case Specifications document.
• Interacted with the SMEs and stakeholders to get a better understanding of client's business processes.
• Organized and Documented Use Cases, Business Rules and Functional Requirements for all system functionalities and ensured that critical requirements are not missed.
• Involved in design and development of standard and ad-hoc reporting using SQL.
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and thoroughly understanding the business processes.
• Deliver requirements under the Agile Scrum SDLC methodology to meet a very fast release schedule.
• Analyzed the data available in Banner and retrieved the required information.
• Collaborated with the Development and Testing Teams throughout the SDLC.
• Actively involved in conducting reviews, walkthroughs and facilitating in requirement definition workshops (JAD) to confirm and playback business requirements for the project.
• Developed tables, Views, Stored Procedures and Triggers using SQL Scripting
• Performed Functional, GUI, Security, Positive and Negative Testing.
• Developed and executed test cases and test Scenarios using Quality Center and followed-up defects using JIRA.
• Created walkthroughs and validations on logical model and created physical data model using forward engineering.
• Carried out queries from customer data base using SQL.
• Prepared the Business Workflow using MS-Visio with input, output, and Pre and Post conditions.
• Created documentation and test cases, worked with users for new module enhancements and testing.

Confidential -Hill, NJ

Business System Analyst

Responsibilities:

• Involved in design and development of standard and ad-hoc reporting using SQL.
• Prepared Business Requirement Design Specification and determined in scope and out of scope aspects of the process.
• Utilized corporation developed Agile SDLC methodology. Used Microsoft Office software to perform required job functions.
• Gathered requirements and conducted interviews with business users and Project Manager to understand the needs of the application.
• Writing Complex SQL queries and optimizing SQL Queries.
• Worked on the workflow capabilities using SharePoint, including strategies and deliverables required for successful implementation and adoption.
• Studied and assessed the clients systems and business processes based on available documentation, SME interviews and performed reverse presentation.
• Preparation of Requirements Document, AGILE Story cards.
• Performed GAP Analysis, conducted walkthroughs and acted as a liaison between the business users, stakeholders and the team to perform the requirements, quality and risk analysis
• Conducted JAD sessions, analyzed and documented the business requirements from various teams and stakeholders.
• Documented and tracked all product defects with use of SQL (reporting).
• Coordinated the activities of subordinates in the Interface Team and organize weekly status Meetings.
• Performed financial research and analysis as necessary and respond to data requests and additional projects and responsibilities as assigned.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using Rational tools.
• Assisted with project planning, requirements development and completing ad hoc change management activities.
• Conducted Business Requirements, Functional and Technical meetings with Business groups.
• Served as a liaison between mortgage specialists and the project team.
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting. Interface with internal customers. Provide ad-hoc reporting and analysis from data sources including Peoplesoft (SET) and Teradata.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Designed the system, prepared UML and sequence diagrams using Rational Rose.
• Collaborated on creation of documents such as the Vision, business requirements (BR) and business systems design (BSD) documents.
• Used MS Visio for Process modeling and Business Process flow diagrams.
• Extensively involved in regression testing during various phases of the application.