PROFESSIONAL SUMMARY:

• Enthusiastic individual with 6+ years of experience as BusinessAnalyst with solid understanding of Business Requirement gathering, Business Process Flow, Business Process Modelling and Business Analysis.
• Strong understanding and experience in Data Analysis, Data Warehouse and with a solid understanding of Business Requirement Gathering, Business Process Flow, Business Process Modeling, Business Process Re - Engineering, Data Analysis, Data Mapping, Data Modeling
• Expertise in Software Development Life Cycle (SDLC) methodologies such as RUP, Agile / Waterfall / Spiral methodologies with hands-on experience in all of them.
• Experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document (BRD), Functional Requirement Document (FRD), and Software Requirement Specification (SRS) across the deliverables of a project.
• Extensive knowledge of the E-commerce Retail Sales lifecycle and the Retail E-commerce ecosystem, OMS, WMS, Fulfilment, TMS, and Support.
• Experience working with Content Management Systems (CMS), Order Management System (OMS) Supply Chain Management and UX teams.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, expert team, development and QA team for project meetings, walkthroughs and customer interviews.
• Expertise and hands-on experience in SQL and RDBMS for Analysis, Reporting and testing purpose.
• Seasoned Business Analyst with outstanding ability to support multiple simultaneous projects in a matrix organizational structure
• Worked in close coordination with the testing team in developing test plan and test cases from functional and business requirements.
• Performed UAT and exposure to User Certification Testing (UCT) and Operational Readiness Testing (ORT)
• Expertise in understanding and supporting the client with Project Planning, Project Definition, Requirements Definition, Analysis, Design, Testing, System documentation and user training.
• Used Rational ClearQuest for tracking and prioritizing defects and for enhancements after baselining the requirements.
• Competent at performing gap analysis, root cause analysis, business process improvement and business process re-engineering projects.
• Experience in writing and executing SQL Queries for Databases such as Teradata, Oracle, and MySQL.
• Expertise in managing multiple projects while maintaining constant communication with the relevant stakeholders
• Experience in the Informatica/ ETL (Extract, Transform and Load) of data into a data warehouse/data mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence)
• Experience in performing backend testing and writing SQL Queries for testing RDBMS such as SQL Server, Oracle, and Teradata for data integrity.
• Worked experience on various Software and Customer Relationship Management (CRM) packages.
• Experience in requirement elicitation, analysis, design, and maintenance of solutions facilitating business requests.
• Experience in conducting JAD sessions with SME (subject matter experts), stakeholders, developers and end-user representatives to make sure all the stakeholders and developers are on the same page.
• Resourceful and Creative problem-solver with a proven aptitude to analyze and translate complex customer requirements and business problems.
• Expertise in translating Business needs into end-user reports with Business Intelligence Tools like Tableau.
• Proven strength in problem-solving, system analysis and strong analytical and product management.
• Tracing requirements throughout the development process and verifying adherence using the Requirements Traceability Matrix (RTM)
• Good experience in developing Test Plans, Test Strategies, Test Scenarios, Test cases by reviewing Business and Software Requirement specifications and creating Gap Analysis for test purpose

TECHNICAL SKILLS:

Business Modeling Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm, Business Object (Crystal Reports),

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling & Analysis, Business Environment and Market Research Analysis

Defect Tracking Tools: Rational Clear Quest, Quality Center

Databases: Oracle (11g/12C,10g), SQL Server, MS Access, SQL, PL/SQL

Content Management Tools: PVCS, Rational Clear Case, Documentum, SharePoint, Interwoven.

Tools: MS PROJECT, SQL, HTML, SharePoint, MS Office

Data Warehousing: Data Marts, OLTP, OLAP, ROLAP, MOLAP, Oracle, Query/Reporting, Multidimensional Analysis

BI/ETL Tools: Informatica, SSIS, OBIEE 11g, Informatica Power Centre, SQL * Loader

Operating System: Windows, Linux, Unix, Mac, Solaris.

Documents & Processes: SRS, Use Cases, UML diagrams, FRS, UAT, Test plans & cases, Business Process Modelling, Project Planning & tracking

PROFESSIONAL EXPERIENCE:

Business Analyst

Confidential, St Louis, MO

Responsibilities:

• Analysed and gathered business requirements, identified system interfaces and created the requirements specification document.
• Wrote User Requirements Specification (URS) and Functional requirements specification (FRS) Documents as per the Business requirements and process flow.
• Conducted sprint planning meeting, sprint review meeting, sprint retrospective meeting and backlog refinement meetings.
• Performed Requirement Analysis to Develop Use Cases, Activity Diagrams, and Sequence Diagrams.
• Documented conceptual design of Application in System Specification Document. controlled project scope identified and resolved key issues and risks.
• Conducted JAD sessions and meetings with developers, QAteam, and users for communicating primary requirements, also discuss different versions of requirements, queries, and clarify the issues.
• Extensively interacted with both user group and development team in coming up with structured charts, Class and sequence diagrams.
• Managed and tracked change control process of requirements and design changes using Rational Requisite Pro. Documented the changes, issues and their impact on the system design and delivery.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners &stakeholders and document analysis, represented them in the Requirements Traceability Matrix (RTM)
• Facilitated and managed meeting sessions with a committee of SMEs from various business areas including estimating resource and budget requirements.
• Designed and implemented basic SQL queries for QA testing and report, data validation.
• Managed plan and design of backup data center infrastructure build-out and participate in business continuation/disaster recovery planning.
• Created complex reports by linking data from multiple data providers, using freehand SQL, stored procedures and functionalities like Combined Queries.
• Created and execution test plans and test suites using Selenium; exploratory/ad-hoc testing; bug documentation and regression and summary writing.
• Imported data from various transactional data sources residing on SQL Server, DB2,and Flat files and loaded into the Oracledatabase.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Conducted daily scrum meetings and noted impediments and progress of tasks and transferred information to Jira.
• Played a key role in User Acceptance Testing (UAT). Developed test plan, test scenarios, test cases and implement a test plan with QA team using Mercury Quality Centre/Test Director.

Environment :MS Project, MS office suite, MS Visio, MS PowerPoint, Java, HTML, Gap Analysis, SQL, Agile, Oracle.

Business Analyst

Confidential, Peoria, IL

Responsibilities:

• Analyzed and gathered business requirements, identified system interfaces and created the requirements specification document.
• Performed Requirement Analysis to Develop Use Cases, Activity Diagrams, and Sequence Diagrams.
• Documented conceptual design of Application in System Specification Document.
• Controlled project scope identified and resolved key issues and risks.
• Extensively interacted with both user group and development team in coming up with structured charts, Class and sequence diagrams.
• Managed and tracked change control process of requirements and design changes using Rational Requisite Pro. Documented the changes, issues and their impact on the system design and delivery.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners &stakeholders and document analysis, represented them in the Requirements Traceability Matrix (RTM)
• Coordinated JAD sessions regarding the impact issues and effectively communicated resolutions to all appropriate staff.
• Facilitated and managed meeting sessions with a committee of SMEs from various business areas including estimating resource and budget requirements.
• Used Global Data Synchronization Network (GDSN) which connects suppliers and retailers, operators, providers, distributors, and other recipients to the GS1 Global Registry via selected Data Pools.
• Designed and implemented basic SQL queries for QA testing and report/data validation.
• Wrote User Requirements Specification (URS) and Functional requirements specification (FRS) Documents as per the Business requirements and process flow.
• Managed plan and design of backup data center infrastructure build-out and participate in business continuation/disaster recovery planning.
• Provided training for the key users about the new system.
• Interacted extensively with the offshore development team to make sure that the developed system matches the client requirements.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Played a key role in User Acceptance Testing (UAT). Developed test plan, test scenarios, test cases and implement a test plan with QA team using Mercury Quality Centre/Test Director.
• Developed and maintained all operational and technical flows using Visio and PowerPoint.
• Organized weekly Project Status and Task Review meetings.

Environment: Rational Rose, Agile, SQL, MS Project, MS office suite, MS Visio, Gap Analysis, GDSN, MS PowerPoint, Oracle, and Windows.

Business Analyst

Confidential, Virginia

Responsibilities:

• Gathered, analyzed and created all types of requirements documents for technical solution projects.
• Conduct all levels of testing including functional, regression, user acceptance, integration, and performance to verify client's needs are met.
• Communicate the client's business requirements by constructing easy to understand data and process models.
• Provide input into developing and modifying systems to meet client's needs and develop business specifications to support these modifications.
• Designed Data Flow Diagrams (DFD's), Entity Relationship Diagrams (ERD's), and web page mockups using Rational Rose and MS.
• Worked with Rational Clear Case and Rational Clear Quest to automate and enforce the development processes and aid with configuration management.
• Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.
• Attend client meetings and assist with the determination of project requirements.
• Effectively and accurately communicate relevant project information to the client and project team.
• Communicate ideas for improving company processes with a positive and constructive attitude.
• Effectively handling the change management process to make sure the changes are approved as per the process.
• Used detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications.
• Used Informatica and Data Stage for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML.
• Drive usage and revenue growth through up-selling&cross-selling of various value packs, services and offers; based on the need, preference & affordability of the customers
• Assisted with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Wrote SQL to verify and validate that results match the reference data is provided.
• Worked with development and testing teams to accomplish timely release objectives.
• Developed timelines for project delivery, and managed projects and resources for successful completion.

Environment: RequisitePro, MS Office Suite (MS-Word, MS-Excel, MS- PowerPoint, MS-Project), RUP, SQL, Windows

Data Analyst

Confidential, Plano, TX

Responsibilities:

• Involved in gathering requirements, identifying and preparing Use Case specification documents, creating a Trace-ability matrix and tagging it in the Rational Requisite Pro.
• Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams using Rational rose so that developers and other stakeholders can understand the business process.
• Lead requirements gathering sessions, create process flows, and produce documentation.
• Manage all business stakeholders and the project teams to desired expectations.
• Analyze requirements and specifications and identify alternatives to problems or opportunities, and then recommend a solution to allow stakeholders to select the best option.
• Identify gaps between existing and desired environment. Make multiple suggestions than justify the best solution.
• Coordinate internal resources and third parties/vendors for the flawless execution of projects.
• Effective management of stakeholder relationship at all levels of the business (Both internally and third-party suppliers)
• Responsible for conducting As-Is To-Be Gap analysis to find out the current state of the system and required the state of the system.
• Facilitate sprint planning, review, retrospective and daily scrum meetings, documented acceptance criteria, the definition of done.
• Identified and communicated risks and issues to management during project execution resulting in minimal project delay created insightful automated dashboards and data visualizations to track key Business metrics
• Organized, planned, and documented bi-weekly production defect and enhancement deployments.
• Translate the Business requirements into various functional documentation, Use Cases, interface mockups, flowcharts, and other process flows.
• Participate in the testing process by verify QA test cases and executing test cases to ensure all requirements all met before client release.
• Work closely with data architects, developers, test managers, Business stakeholders and project managers to achieve project objectives in defined time frames.
• Participate in User Acceptance Testing (UAT) of system modifications; document findings to defined scenarios; ensure that changes.
• Attended meetings with the business representatives to review the final product.

Environment :MS Office Suite (MS-Word, MS-Excel, MS- PowerPoint, MS-Project), RUP, RequisitePro, Windows. Toad, Business Objects, Crystal Reports Oracle, UAT, QA, Informatica Designer, Workflow Manager, Workflow Monitor.

Data Analyst

Confidential

Responsibilities:

• Designed, developed and established KPIs to monitor analysis and provide strategic insights to drive performance within the Supply Chain and operations teams.
• Operationalized BI solutions and conducted advanced analytics to identify scope and strengths to meet business goals.
• Designed dashboards using ServiceNow Performance analytics to bring visibility to the Global Business Services team to show the status of tasks and assigned teams/Groups.
• Coordinated with cross functionality teams for data assignments and communicated the findings as reports.
• Provided data analysis, tracking, and reporting in Supply chain visibility projects for different business areas.
• Automated dashboards and generated weekly metrics to track business trends and statistical variances.
• Visibility led to the optimization of trailer Utilization and helped the financial team to reduce transportation costs by 10%.