SUMMARY

• Sound understanding of Rational Unified Process, Software Development Life Cycle, Agile/Scrum and Waterfall Methodologies.
• Efficiency in preparing Business Requirement Documents, Functional Requirement Documents, Companion Guides and Requirements Traceability Matrices.
• Skilled in writing Use Cases and drawing Business Process Flow Diagrams (Activity Diagrams, Flow Charts, etc.).
• Experienced in interactions with vendors and clients, understanding business applications and business data flow.
• Adept in conducting Joint Application Development Sessions.
• Proficient in leading Requirements Gathering process via different elicitation techniques such as Client Interviewing, Requirements Workshops, Interface Analysis, Prototyping, Surveys & Questionnaires, Focus Groups, Job Shadowing, Document Analysis, etc.
• Expertise in Web and Client Server Applications through all stages of the Software Development Life Cycle.
• Interacted with designers and developers to ensure functional implementation of business requirements and QA Team in executing Test Plans & Test Case Scenarios.
• Excellence in organizing, facilitating and coordinating Weekly Meetings, Conference Calls and other regular Project Meetings.
• Proficient in design and execution of Test Strategy, Test Plan, Test Scenarios and Test Cases based on the requirements for the applications.
• Hands - on in working with relational databases and applications for data retrieval and enhancements or modifications.
• Excellent knowledge in Business Analysis, SWOT Analysis, GAP Analysis, Cost-Benefit Analysis, Risk Analysis, Testing and Project Planning.

PROFESSIONAL EXPERIENCE

Confidential, Brentwood, TN

Business Systems Analyst

Responsibilities:

• Gathered Business Requirements and translated them into High-Level and Low-level Specifications.
• Performed Data Mapping using Business Rules and Data Transformation Logic for ETL purposes.
• Created Star Schemas and Bridge Tables to control Slowly Changing Dimensions.
• Developed ER and Dimensional Models using ER/Studio Data Architect advanced features.
• Wrote User Stories to identify Business Requirements and captures User Experience.
• Created Product Backlog Items and prioritized them to help define the scope for each iteration.
• Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions.
• Presented conceptual and functional models along with cross-functional process and system dependencies.
• Participated in Daily Standups Meetings with Project Manager, Development Team, and QA Team.
• Created schema objects like Indexes, Views, and Sequences.
• Involved in dimensional modeling of Data Warehouse to design the business process.
• Designed Logical Data Model and Physical Conceptual Data Model using ER/Studio Data Architect
• Created ETL Data Mapping Documents between Source Systems and Target Data Warehouse.
• Performed GAP Analysis to check the compatibility of the existing system infrastructure with new Business Requirements.
• Coordinated in the Process Design Documentation of the Data Warehouse Dimensional upgrades.
• Conducted iteration kick-off meetings to develop a backlog to adequately meet the team's bandwidth.

Confidential, Grand Rapids, MI

Business Analyst

Responsibilities:

• Worked in an Agile/Scrum environment throughout the project life cycle.
• Acted as a liaison between Users and different teams involved in the application development for better understanding of the Business and IT Processes.
• Helped Project Manager in identifying best approach for gathering requirements and estimated project size using UCP Analysis.
• Gathered Business requirements and mapped them with Functional Requirements.
• Prepared Functional Requirements Document and analyzed data/workflows.
• Defined the financial projections and cost/benefit analysis.
• Facilitated Joint Application Development and Joint Requirements Planning sessions to gather information for Group Disability Claims.
• Designed Test Cases for System Testing and Integration Testing.
• Performed GAP Analysis to identify various EDI transaction using implementation guide to identify the changes in the segments and data elements.
• Coordinated in Load Testing and User Acceptance Testing.
• Performed Data Analysis and Data Validation by writing basic queries against the database.
• Performed reviews and audits for internal and external activities for the existing system and prepared activity/process flow using MS Visio.
• Conducted Sprint Planning with the Development and QA Team.

Confidential, Minneapolis, MN

Sr. Business Analyst

Responsibilities:

• Interacting with stakeholders to understand the requirements for accurate testing.
• Meeting with the development team to comprehend the build and correct testing.
• Serving as the primary point of contact for testing in more than 50 percent of the applications.
• Proficient in designing Test Plan, Test Cases, Test Execution Result Analysis, Test Summary Report and Traceability Matrices & managing the files in Confluence.
• Expert in executing Test cases in HP Quality Center/ALM to ensure that the application is developed as per requirement and raise defects.
• Proficient in creating UAT scripts for CMS.
• Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions.
• Conducted JAD session for brainstorming and giving an understanding of the application to the team
• Creating a detailed business analysis, outlining problems, opportunities, and solutions for a business.
• Managing projects, developing project plans, and monitoring performance.
• Managing competing resources and priorities.
• Creating stories in JIRA, linking them to epics, assigning them to the developers and raising defects while doing functional testing.
• Experienced in working in Waterfall development life cycle.
• Expert in testing in agile methodology in Sprints of 2 weeks and prioritizing the User story in Azure DevOps Module.
• Experienced in Defect Management using HP Quality Center/ ALM.
• Experienced in front end UI testing & Back-end testing ensuring data validation and data integrity testing using SQL Queries.
• Working closely with the automation team to help build the automation suite.
• Tracked the daily/weekly progress of projects to ensure releases are on schedule.

Confidential, Mahwah, NJ

Business Systems Analyst

Responsibilities:

• Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Worked closely with the Scrum team responsible for mobile app development, helped create user stories for enhanced one touch home page, store locator and print service options.
• Designed and implemented new processes for manufacturing execution system including new item categories and design for integration.
• Established and developed a partnership with POS and web firms to develop additional business.
• Assisted in drafting the Business Requirement Document (BRD) by collaborating with technical teams and stakeholders.
• Created Business Requirement Document, Functional Requirement Specification Document, User Requirement Specification and Change Request Document for system application development.
• Facilitated ceremonies to encourage collaboration, communication, and feedback within an Agile software development team; promoted a learning culture on the line and challenges the line to be innovative.
• Designed custom solutions around Order Management, Pricing, Shipping and Returns.
• Developed Use Case Diagrams for the Repository Data Management Use Cases using UML Modeling through MS Visio.
• Performed gross margin analysis for distributors to estimate product margins for certain product lines.
• Analyzed large data sets of customer accounts and purchase behavior to identify KPIs for driving net sales, gross margin, and other key metrics.
• Coached the team through adoption of the Agile Scrum process with positive and negative feedback.
• Designed and developed consistent reporting processes to provide insight on business demand forecast.
• Developed pricing strategies for territories by analyzing relevant information gathered for the regions.
• Performed Data Mapping, Logical Data Modeling and created Class Diagrams/ER Diagrams.
• Used SQL queries to filter data.
• Exclusively used SQL and T-SQL for designing, modifying and maintaining tables, views and stored procedures accordingly.
• Developed and maintained sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Produced performance reports and implemented changes for improved reporting.
• Worked as a User/Customer advocate and negotiated with user as well as the technical team and management staff to resolve any outstanding requirement conflict during the whole SDLC process.