SUMMARY

• Experienced Business Intelligence / ERP Business Systems Analyst with a drive for data.
• Over 8 years of experience creating and implementing complex designs and development lifecycles both as a Business Analyst and as a Business Systems Analyst with a particular focus on data - driven business processes and with a significant amount of experience in creating Data Marts and Data Warehouses (both design and ETL) to support business decisions.
• Business Intelligence experience with a focus on Tableau Report Design and Development.
• Strong knowledge of SDLC methodologies including Waterfall, Scrum and Agile Project Management.
• Experience with Transactional Softwares, Enterprise Resource Planning and Human Resources
• Created UML Diagrams including Use Cases, Activity Charts, Sequence diagrams, Data Flow Diagrams and ER Diagrams using Rational Rose and MS Visio to define the Business Process Model and preparing complex functional requirement documents.
• Experienced in the elicitation of requirements through shadowing, repository lookups, interviews and Joint Application Development (JAD) sessions.
• Excellent Business writing skills with a significant experience in researching, eliciting and creating Business Requirement Documents, System Requirement Specifications, Functional Requirement Documents, Use Cases and User Stories.
• Solid business, communication and presentation skills. Conducted, documented and presented SWOT, MOST, CATWOE, PESTLE, Enterprise Analysis and GAP Analyses for a wide array of stakeholders, business users and senior management.
• Experienced Business Intelligence BSA with particular experience with Oracle SQL Developer, Informatica and Tableau Desktop/Server.
• Good knowledge of creating SQL Queries for Data Modeling, Data Validation, Data Integration and Data Warehouse Testing.
• Accomplished at UAT (user acceptance testing), Functionality Testing, Unit testing, System Testing, Integration Testing and Regression Testing.

TECHNICAL SKILLS

SDLC: Agile, Waterfall, Scrum, RUP

Languages: PL/SQL, SQL, HTML, XML

PM Tools: Lean Management, MS Project, JIRA, Trello, Google Drive/Docs

Modeling Tools: MS Visio, UML - diagrams

Reporting Tools: SQL Server Reporting Services (SSRS), TABLEAU, TABLEAU DESKTOP 8.2, MS Project, Jira

ETL Tools: Informatica, SQL Server Integration Services (SSIS)

Supporting Tools: MS Office, MS Visio, Rational Rose, Rational Requisite Pro, Clear Case, Clear Quest

Quality Management: HP Quality Center, HP ALM, Load Runner.

PROFESSIONAL EXPERIENCE

Confidential, ANN ARBOR, MICHIGAN

Sr ERP BUSINESS SYSTEMS ANALYST / SCRUM MASTER / TABLEAU DEVELOPER

Responsibilities:

• Conducted requirement gathering meetings with functional managers, change managers and data owners to
• Clarify pre-defined Key Performance Indicators
• Outline necessary process improvements to improve the quality of available data, and to enable the automatic performance measuring
• Defining the necessary data points and aggregations/slicers that would have to be visualized in the final Reporting Layer
• Conducted meetings with the Project Manager, the Data Owner, the DI-Developers and the Data Modeling team to:
• Create an appropriate Dimensional Model that would be more efficient and allow for more functionalities than the existing Relational Database Structure
• Define possible bottlenecks with regards to performance, data quality and data integrity
• Create a Bridge Table to connect the ServiceLink data with the Financial Datawarehouse of the University within one Data Model
• Created the Mapping Document, outlining the Source-to-Target mapping for both Dimension and Fact Tables and the specific transformation logic specific to every single data element
• Continuously validated Modeling and Design documents with the stakeholders
• Worked closely with the DI Development team in terms of clarifying transformation logics, solving Informatica issues caused by inconsistent and bad data and organizing the development work according to two week iterations.
• Wrote extensive SQL Queries in Oracle SQL Developer to better understand the ServiceLink Source Data, test the Transformation Logic and test the validity of the data in the Data Mart
• Developed and Designed the Tableau Reporting for the Shared Services Center
• Conducted requirement gathering sessions with the SSC Governance Council, the Executive Director, the Service Quality Managers and the Data Owners to better understand what matters to their customers
• Designed, tested and improved reporting dashboards through an iterative process

Confidential, GREENSBORO, NORTH CAROLINA

SENIOR BUSINESS ANALYST/ SCRUM MASTER

Responsibilities:

• Analyzed the business needs of clients and stakeholders to help identify business problems and propose solutions.
• Acted as a Scrum Master by creating sprint backlogs, organizing and conducting sprint planning meetings, daily scrum meetings, Sprint Review meetings, Sprint Retrospective.
• Created sprint burn down charts and release backlogs for effective Project Management.
• Created workshops to understand requirements for Data Warehouse design. Conducted client side validation to study ETL operations on database.
• Used Tableau to create dashboards for a managerial overview with drill up and drill down capabilities.
• Performed Gap Analysis, Operational Risk Analysis and analyzed AS IS and TO BE conditions
• Created Workflow scenarios, designed new process flows, documented the Business Process of the business from the conceptual to procedural level using MS Visio.
• Conducted interview workshops, focus groups, JAD sessions with SME, BO, Sr. Developers, Architects to further breakdown the requirements.
• Worked closely with the SME’s to create the regulatory framework that would regulate the information system including but not limited to: Dodd Frank, Know Your Customer, Bank Secrecy Act.
• Conducted Feasibility Analysis and Product backlog planning with the Project Manager.
• Created WBS using MS Project.
• Expressed the requirements through user stories, use cases, business rules, future state mapping and process flow diagrams.
• Supported the Product Owner in creating the Product backlog with help of user stories collected through requirements gathering and gap analysis.
• Utilized SharePoint 2010 as an administrator for document management, version control and creating team dashboards on the team site.
• Helped in creating test cases, test plans and User Acceptance Testing (UAT) for the system.
• Develop and Implement test cases on the GUI interfaces to ensure that requirements were met.
• Worked with SQL queries to extract application data to perform application validations.
• Developed and maintained Requirement Traceability Matrix in order to ensure every Requirement outlined in the Requirement documentation was implemented and has been tested.
• Logged and tracked the defects using HP Quality Center. Created an error repository and managed the testing process with the QA team.
• Assisted and documented code review and unit testing.

Confidential, CHARLOTTE, NORTH CAROLINA

SENIOR BUSINESS ANALYST/SCRUM MASTER

Responsibilities:

• Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans related to residential mortgage lending.
• Worked extensively with SMEs in understanding and documenting their requirements. Worked with all levels of client staff in the process of solution definition.
• Assisted with product evaluation, product customization and system integration. Conducted GAP analysis around the identification of business rules, business and system process flows, user administration, requirements and assumptions.
• Analyzed user problems, including automated and manual business processes, and identified, researched, investigated, defined and documented business processes.
• Designed and developed Use Cases, Use Case Diagrams and Activity Diagrams using UML.
• Acted as a SCRUM Master, creating sprint backlogs, organizing and conducting sprint planning meetings and daily scrum meetings. Created sprint burndown charts and released backlogs for effective Project Management.
• Authored business requirements documents with the business users. Extracted, discussed, and refined business requirements from business users and team members.
• Assisted the project managers with the development of project schedules.
• Involved in documentation during various phases of development life cycle.
• Coordinated activities between business users and technical staff, developed new methods, policies, and procedures to meet the business needs, as well as acted as primary trainer in educating the business users, related to business applications.
• Performed UAT on business requirements, technical specifications and product knowledge.
• Collaborated with the department to provide users with on the enhanced functionality and newly built tools.
• Created visual models using Tableau and presented analytical data to business owners helping them identify new opportunities and bottlenecks faced by the business at present.
• Attending and documented defect triage meetings
• Supported testing, Test Cases in HP Quality center that would test various Test scenarios.
• Developed and maintained Requirement Traceability Matrix in order to ensure every Requirement outlined in the Requirement documentation was implemented and has been tested.

Confidential, RALEIGH, NORTH CAROLINA.

SENIOR BUSINESS ANALYST

Responsibilities:

• Acquired and studied repository artifacts of the existing system to gain an understanding of their current Customer Relations Management application, including its current shortcomings.
• Conducting user interviews at both in-house and client locations, gathering and analyzing to understand both the AS-IS state and gather the requirements to create the potential TO-BE state using RequisitePro - RUP.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Identify, research, Realize, investigate, analyze, define and document business processes and Use Case Scenarios.
• Perform Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Conduct workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Utilized RUP Methodology to develop the web application to satisfy the warranted periodic functionality releases.
• Assist with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place
• Responsible for identifying and documenting business rules and creating detailed Use Case
• Worked with development and testing teams to accomplish timely release objectives.
• Using detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications
• Act as a resource in understanding how IS carry out business functions and assists in ensuring the timely and effective implementation
• Developed timelines for project delivery, and managed projects and resources to successful completion
• Liaison for projects with other corporate departments, including Executive, Legal and Information Services as well as vendor relationships.
• Responsible for all project documentations
• Extensively worked with Excel, Word, PowerPoint, SQL, and MS Project.

Confidential

BI ANALYST/ SCRUM MASTER

Responsibilities:

• Assisted in designing and developing of project document templates based on SDLC methodology.
• Impact Analysis encompasses reviewing the initial impact decimalization will have on a broad range of issues, including programs and copybooks, screens, reports, and files.
• Reengineering Strategy and Design included analyzing the impact analysis outputs, and designing a renovation strategy for files, databases, screens, reports, and interfaces for background transactions and data migration programs.
• Involved in generating Daily/Weekly Finance trending reports using Tableau by identifying the dimensions, measures, measure values & level of details for Business Analytics & Top Executives to give an overview current Trends
• Developed and delivered a range of End User Courses covering modules.
• Created and led sign-off of functional specifications.
• Actively involved in prototyping, business needs analysis and fit/gap.
• Prepared and Presented Weekly Project reports to senior Management, using amongst others SSRS to visualize better what the solution that was under construction could achieve.
• Carried out Needs Analysis and developed and executed plans for end-user .
• Develop program/ specifications, test plans and update the Project Plan.
• Conducted user interviews, gathering requirements, using Rational Rose requisite pro - RUP.
• Worked with Technical Lead in preparing Functional Documents.
• Created Use Cases, Collaboration Diagram, Sequence Diagrams, State-Chart Diagram.
• Identify research, investigate, analyze, define and document business processes.
• Assisted Quality Assurance Manager in preparing test plan and procedure.
• Worked closely with Senior Management to create Work-Breakdown Structure, Resource-Breakdown Structure using MS Project and managed project and resources to accomplish company’s goal.
• Worked closely with the UX/UI designers in order to create a seamless online experience for the investors.

Confidential

BI BUSINESS SYSTEMS ANALYST

Responsibilities:

• Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans.
• Worked with several business users to identify and map detailed current processes, identify gaps and failure points, perform root cause analysis and develop functional requirements that supported overall strategy, goals and objectives.
• Conducted user interviews, gathered requirements and analyzed the requirements using Rational Rose Requisite Pro - RUP.
• Identified, researched, investigated, analyzed, defined and documented business processes.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Using detailed knowledge of application features and functions, assessed scope and impact of business needs throughout analysis and completion of all enhancement specifications.
• Developed timelines for project delivery, and managed projects and resources to successful completion using MS Project.
• Assisted in development of materials for new technology and process improvement.
• Was responsible for all project documentations and served as a liaison between the business team and the project team by assisting in identifying, understanding, and documenting their business needs.
• Participated in the identification, understanding and documentation of business requirements.
• Created validation rules and provided verbiage to developers for client-side validation, server-side validation and database validation.
• 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 daily Scrum meeting, planning meeting, review meeting, retrospect meeting and created the Product backlog.
• Assisted with user testing of systems, developed and maintained quality procedures and ensured that appropriate documentation was in place.
• Responsible for identifying and documenting business rules, created detailed Use Cases and conducted User Acceptance Testing with the help of SQL Analysis and HP Quality Center. Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.

Confidential

JUNIOR BUSINESS INTELLIGENCE ANALYST

Responsibilities:

• Worked with the business users to define business requirements and analyze the possible technical solutions.
• Conducted user interviews, gathered requirements, analyzed, and documented Business requirements based on the analysis of the workflow model.
• Modeled AS IS and TO BE processes using MS Visio
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Analyzed the Business and System Requirements of the application.
• Supported the creation of companywide KPI’s, specifically for the sales department and the individual hotels, in order to make calculated managerial decisions and outline the must-have functionalities of the Data Warehouse.
• Designed and developed project document templates based on SDLC methodology.
• Co-author business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members
• Assisted the testing team in developing the Test plans for quality assurance based on functional requirements.
• Performed User Acceptance Testing (UAT) for various web based and database related applications.
• The reports that were created in Business Objects were tested by running the SQL statements against the tables in the Oracle Database
• Data transformation tool (ETL) and Informatica as data mining and front-end reporting with the help of Tableau.
• Interacting with the development and testing teams to improve overall quality of the system.
• Based on the business requirements, created Test Plan, Test Cases, and Test Script documents to test the Business Objects reports.
• Developed Use case, Functional, Object diagrams using Rational Rose.
• Analyzed user problems, including automated and manual business processes and identified, researched, investigated, defined and documented business processes
• Act as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation.
• Worked under the lean software methodology, experiencing the launch of the project for a small part of the organization and then replicating best practices to the other hotels.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the database
• Assisted the PM in performing Risk Assessment, Management and Mitigation.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.