SUMMARY

• 5 years of experience as Business Analyst and Data Analyst with strong knowledge and background in IT, Information Security and Accounting domains as a Business Analyst
• Proficient with Software Development Life Cycle (SDLC) models including Waterfall and Agile like Scrum and Rapid Application Development (RAD)
• Experience in Business analysis, Stakeholder analysis, Requirement elicitation and Gathering, and conducting brainstorming sessions, JAD sessions and Interviews
• Transformed business requirements into functional requirements and non - functional requirements and prepared User story, Business Requirements Document (BRD), and Functional Requirements Documents(FRD)
• Skilled in Data analysis and Gap analysis to detect problems and drive project forward towards the final goal
• Experience of doing root cause analysis, assumption analysis, SWOT analysis, ROI analysis and impact analysis requirements
• Documented the As-is and To-be processes using UML diagrams including Use Case, Activity, Class, and Sequence Diagrams in MS Visio
• Cooperated with Back-end developers with Relational Database Design (RDBMS) and prepared ER Diagram, Data Schema, and Data Dictionary
• Cooperated with Front-end developers on UI/UX design and facilitated with Wireframes, Mockups, and Prototypes for both Websites and Mobile
• Experienced in Testing Stages and techniques including Unit Test, Integration Test, System Test, Performance Test
• Conducted and facilitated testing phase with User Acceptance Test (UAT)/Beta Testing, Usability Test, and Security Tests (System & Information Security)
• Prepared Test Plans, Test Design, and experienced in writing Test Cases and Test Reports (User Guide/Manual)
• Proficient in Data querying/analysis/manipulation/visualization/reporting using Access, Excel, and SQL
• Demonstrated ability in hosting and facilitating various types of meetings in Agile such as daily stand-up, daily planning and daily review meetings.
• Developed training materials and trained users on newly developed and existing applications.
• Experienced in requirements management through Requirement Traceability Matrix (RTM), by using JIRA and SharePoint.
• Strong team player with great verbal, written communication and interpersonal skills.
• Demonstrated ability to manage multiple tasks and projects simultaneously with outstanding time management skills.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile, Scrum

Project Management Tool: Jira, SharePoint, MS Project, Dropbox, GoogleDrive, GitHub, Citrix

Analysis Skills: Stakeholder Analysis, Business Analysis, Gap Analysis, Data Analysis

Requirement Management Tool: Microsoft Word, Excel, PowerPoint, Rational Requisite Pro

Unified Modeling Languages (UML): Use case, Activity, Class, Sequence Diagrams, ER Diagram

Business Modeling Tool: MS Visio, Astah, Gliffy, Axure RP, Rational Rose, BPMN, Balsamiq

Relational Database (RDBMS): Database Design, MySQL, Oracle SQL Developer, Microsoft Dynamic

Analytical/Reporting Tools: MySQL, ACL, Microsoft Access, Microsoft Excel

Programming Languages: Java, JavaFX, JavaScript, HTML, Ruby, C#, SQL, Python

Operating Systems: Windows, Mac OS, Unix

Testing Techniques: Unit Test, Integration Testing, System Testing, Performance Testing, User Acceptance Test (UAT)

PROFESSIONAL EXPERIENCE

Confidential, IA

Business Analyst

Responsibilities:

• Conducted a project Kick-off session at the beginning of the project to meet with stakeholders
• Developed a Project Charter with project overview, sources, scopes, and a list of key stakeholders
• Applied root cause analysis, assumption analysis, SWOT analysis to understand the business’s strength and weakness, discover opportunities for process improvement and recognize challenges the business could face
• Used ACL, SQL and other data techniques to analyze and test the completeness and accuracy of financial data for estimation and documentation of “as-is” process
• Performed impact analysis and ROI analysis to predicted the “to-be” system and estimate business value
• Understood the business procedure and Company Objectives to assure requirements align with the goals
• Transformed business requirements into functional and non-functional requirements as well as preparing BRD FRD and SRS Document
• Conducted JAD session, brainstorming, and face-face interviews to gather and elicit requirements
• Documented the “to-be” business procedures with an Agile Diagram
• Collaborated with both external and internal audit to ensure User Story is followed with GAAP and SOX rules
• Demonstrated the interactions between external users and the system with Use Case Diagram
• Demonstrated the business logic of the developed system with an Activity Diagram
• Conducted and facilitated Planning Meetings, Daily Scrum meetings and Code Review sessions
• Requested access to internal database from IT department and did Data Integration
• Prepared Sprint backlog refinement at the end of each iteration to keep track of Changes in requirements and requested for further feedbacks
• Performed data Preprocessing & Normalization, and handed in the cleaned data for further analysis
• Performed audits over the design, implementation, and operating effectiveness of IT controls intended to ensure the completeness and accuracy of SOX-material data during its use, storage, and transit
• Tested Finance and Controlling integration with Maintenance and Materials Management processes.
• Worked on Materials Management processes involving Purchase Requisitions, Purchase Orders, and Pricing. 
• Detected Finance and Control processes involving Cost Center accounting, G/L accounts, Bills receivable.
• Created new digital records for debit memos that were able to track which invoices were paid by debit memos to more efficiently respond to vendor and internal inquiries.
• Create and track aging reports to be used for check, ACH, and wire payments. 
• Focused primarily on controls relating to access security, change management, interface integrity, and security
• Performed tests of Information Technology systems and business process controls to ensure compliance with established risk control frameworks and regulatory requirements
• Prepared Test plan and Test case to facilitated with UAT and get positive feedbacks from stakeholders

Business Analyst 

Responsibilities:

• Developed a Project Charter with defined project objectives, duration, budget, resource, and scope
• Delivered a detailed Work Plan with milestones, key deliverables, timeline, and Gantt Chart in MS Project
• Travelled a lot to meet with clients in person to gather requirements and discuss current designs
• Frequently conducted teleconference and videoconference with clients to report weekly progress
• Conducted JAD sessions and Brainstorming and used stickers in these meetings to gather requirements
• Developed a Product Backlog with prioritized key features
• Broke down the product backlog into several Phases and allocated tasked in several Sprints
• Conducted and facilitated Daily Planning Meetings, Daily Scrum meetings and Code Review sessions
• Developed numerous of User Stories to demonstrate functional requirements from users’ perspective
• Mapped out Use Cases for each of the user stories to help developers further understand functionalities
• Documented As-is and to-be process using UML diagrams (Activity, Use Case, and Sequence Diagram)
• Actively participated in weekly Code Review Sessions and tested on Integration of code modules
• Designed the mobile and web-based application UI in both Android and iOS using Axure RP
• Developed Prototypes to give stakeholders a clear showcase of system design and functions
• Cooperated with front-end developers on testing the Ease of Use and determine the perceived usefulness
• Finalized the Evaluation Criteria and Test Scripts and documented the test results in test reports
• Reported to stakeholders with presentations and weekly Status Report that contains weekly progresses

Business Analyst

Responsibilities:

• Conducted kickoff session with Product Owner to estimate budget plan, timeline, and resources plan
• Performed as a scrum master to facilitate sprint reviews and spring planning sessions and encourage collaboration between Product Owner and the Scrum team
• Understood the business procedure and Company Objectives to assure requirements align with the goals
• Prepared Product Backlog with High level requirements and Work Breakdown Structure
• Structured “as-is” process of the company’s current business flow and information flow to identify key performance indicators (KPI) of the business by SWOT Analysis
• Manage projects and interdepartmental teams tasked with identifying processes within the company to be streamlined. 
• Map all workflow/document business processes across multiple internal departments
• Mapped “to-be” process with Workflow Diagrams
• Demonstrated the interactions between external users and the system with Use Case Diagram
• Demonstrated the business logic of the developed system with an Activity Diagram
• Conducted JAD session, brainstorming, and face-face interviews to gather and elicit requirements
• Conducted and facilitated Sprint Planning Meetings, Daily Scrum meetings and Code Review sessions
• Defined and listed authorization levels, and documented the operations and operators’ information
• Managed and introduced paperless processes and documentation for the accounting department and HR department
• Coordinated the relationship between transportation department and manufacturing department based on distribution
• Prepared multiple cost benefit analysis statement s for proof of concept and work in preparation
• Assisted back-end developers with planning phase on Information System Design and Structure
• Defined the entity names, entity types, attributes, cardinalities, and relationships among them using ER Diagram
• Defined the Primary Key, Foreign Key, and Constraints at table level, and defined data type for attributes
• Designed the structure of the back-end relational database and normalized tables to avoid redundancy
• Created complex stored procedures which trigger cursors in SQL Server. 
• Inserted and came up with values into database for testing and demo purposes
• Prepared Test Plan and Test Case with QA to facilitate UAT
• Conducted Spring Retrospective session to gather feedbacks and refine product backlog to prepare the following sprint