SUMMARY

• Over 8+ years of Experience as Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Business Process flow, Business Process Modeling, Data Analysis, Data Mapping, Translating Requirements into Specifications, Application Design and Business Analysis.
• Experience as Business Analyst with strong domain knowledge of Logistics / ecommerce Industry.
• Extensive experience working with vendor e - commerce tools like Microsoft commerce as well as helping construct and integrate in-house ecommerce applications.
• Worked eCommerce Business Analyst on website rebuild/redesign on the hybris e-commerce platform.
• Extensive experience in modeling the AS IS and TO BE ecommerce solutions.
• Expert knowledge in key concepts of Supply chain Process, transportation, and inventory management.
• Proficient in Ware-House Management System (WMS) and Supply Chain Technology System (SCTS).
• The Supply Chain scope includes the entire supply chain from production order to shipping & delivery and order management.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Created Artifacts likeBusinessRequirement Documents (BRD), Functional Requirement Documents (FRD), Non-Functional Requirement Documents (N-FRD), Use Case, UML Diagram, Workflow Diagram and Wireframes.
• Excellent business writing skills in writing Preliminary Investigation Report, System Requirements document, Systems Design Specification and System Requirement Change Request.
• Demonstrated experience in conducting User Acceptance Testing (UAT) and documenting test cases in both personal commercial line of property and casualty insurance.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Extensive experience in creating Functional Specifications, UI specifications and UI prototypes.
• Work closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.
• Involved in creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Worked with other development teams to teach them the correct usage of Agile, SCRUM, Waterfall and created document templates that acted as the baseline for other projects.
• In Depth understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
• Having good knowledge with SQL, ETL (Informatica, DB2), SQL Server while handling various Mat lab applications in multiple projects.
• Strong SQL Skills related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.
• Experience using database query tools for Oracle and SQL.
• Proficiency in preparing ETL Mappings (Source-Stage, Stage-Integration, ISD), Requirements gathering, Data Reporting, Data visualization, Advanced business dashboard and presenting in front of clients.
• Assisted in creating mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta - data definitions.
• Assisted QA team in performing Unit testing, System Integration Testing (SIT), End to End testing (E2E) and User Acceptance Testing (UAT).
• Extensive experience in Testing, Manual and Automated using tools Win Runner, Load Runner, Quick Test Pro, Test Director, Rational Robot or Web and Client/Server Applications & Mainframes.
• Expertise in Agile, RAD, RUP, SCRUM, Waterfall SDLC (Software Development Methodologies).
• Experience in B2B, B2C and Ecommerce portals web application developments.
• Experience working on various eCommerce initiatives, including front end features and custom application development on eBay's eCommerce platform.
• Proven experience with end-to-end business process mapping, business and technical requirements analysis, business planning, modeling, verification and methodology and product development.
• Conducted functional and technical requirement gathering sessions with Stakeholders, Underwriting Managers and Operations Analysts for the Policy, Claims and Point-of-sale related modules.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Business Analyst

Responsibilities:

• Interviewed Business users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Analyze the current Supply Chain Management from receiving an order in OMS (Order Management System), WMOS (Warehouse Management Open System) and complete processing till final delivery to customer and suggest best remedial methods.
• Responsible for Reverse Logistics, Inbound/outbound Supply Chain product solutions.
• Focus on major components areas such as Post Order, OMS (Order Management System), WMS, content and online.
• Used JIRA to create requirement stories, task tickets and bug tickets to manage and track project releases.
• Implemented and customized customer relationship management (CRM) for Marketing, Sales and Case Management also implemented sales cloud and service cloud to improve customer retention and service delivery process improvement.
• Work directly with Product Managers and Engineers to understand the Technical and Functions system requirements. Escalate issues to Scrum Team, Business stakeholders, and UAT management teams.
• Provide regular UAT progress statistics/reporting to project stakeholders.
• Create user stories in JIRA to fix the defect.
• Provide and support implementation of business solutions, systems, policies, procedures by building relationships and partnerships with key stakeholders IT, Account Managers, Supply Chain, monitoring.
• Support Supply Chain Optimization Team with analytical and quantitative methods to better understand, predict and enhance supply chain applications, systems, and processes.
• Facilitated workshops between business stakeholders and offshore developers to modify Merchant CRM platform to conform to Best Practices and to improve performance.
• Build SQL queries based on source to target mapping documents and executed these queries using SQL Developer.
• Wrote several complex SQL queries for data verification, data validation, data quality checks.
• Extensive querying using SQL Developer to run SQL queries and monitor quality & integrity of data.
• Created, maintained, and enhanced data management and process controls utilizing MS Excel based reports, MS Access databases and SQL Databases.
• Perform UAT for each user stories ticket created in JIRA during each sprint release.
• Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Analyzed and managed Supply Chain reports, dashboards, and performance metrics.
• Facilitate and Lead the Requirement review call, UAT kickoff Meetings, status meetings for SME's and LOB partners.
• Utilize MS Excel to interpret and analyze business related data effectively.
• Created UAT documentation and managed in UAT process.
• Responsible for gathering requirements for WMS inbound and outbound data interfaces and data conversions.
• Performed extensive requirement analysis including Data analysis and Gap analysis.
• Administer the tax management software for the order management system with zero discrepancies.
• Developed business process models in RUP to document existing and future business processes.
• Supported SMEs to identify risks and to develop mitigation strategies.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Designed and developed project document templates based on SDLC methodology.
• Developed Sequence Diagrams, OOD using UML.
• First point of contact supporting WMS application issues in QA/UAT/ Production.
• Hands on Creating and executing delivery of Release Notes, Quick Guides, training materials and UAT test plans.
• Conducted JAD sessions with management, SME, vendors, users, and other stakeholders for open and pending issues.
• Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
• Ensuring Warehouse Management System (WMS) can reciprocate to the requirements.
• Work with the Business/Functional Architect and other planners to assess current capabilities and identify high-level requirements.
• Build test cases and scenarios in TFS for upcoming UAT sessions.
• Created PowerPoint presentations incorporating MS Office Suite, Excel, Word, and Access.
• Planned, documented, executed, and supported the User Acceptance Testing (UAT) efforts relative to all projects by collaborating with the business.
• Assisted in defining project plans, including scoping, scheduling, and implementation.
• Maintained track of bugs and project issues on JIRA.
• Shared knowledge/experience with IT staff to promote a team environment.
• Prepared the business flow models for better understanding of requirements for technical team.

Confidential - Portland, OR

Business Analyst

Responsibilities:

• Worked closely with project stakeholders, Subject Matter Experts (SMEs) to understand business requirements and analyse specifications for new applications, and to modify existing applications.
• Worked on the impact of changing requirements on the mainframe application during change management procedure.
• Established a business analysis methodology around the RUP (Rational Unified Process). Helped develop use cases, project plans, and manage scope.
• Provide analysis/reports to cross functional teams within Supply Chain as requested.
• Reviewed current CRM processes and functionality testing to identify and help standardize areas for improvement.
• Supported warehouse and business operation teams through WMS applications and implementation and support applications and implementations.
• Servers that were validated as being used, was updated in the inventory management system. Ensured that the record was correct.
• Defined user stories in JIRA by creating tickets and elaborated stories to offsite development and QA teams.
• Performed all the setups for Order Management including defining of the OM Workflows, Transaction Types, Line Transaction flows, RMA Process, Setting up Pricing in Advance Pricing (Modifiers, Qualifiers, Pricing Formulas), Shipping Networks, Shipping Parameters, etc.
• Participated in supply chain meetings and communicated relevant product and lead time information back to the sales team.
• Responsible for arranging and coordinating meetings between account executives and subject matter experts.
• Analysing, documenting, and mapping existing Supply Chain related processes and offering optimized process solutions.
• Involved in developing SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from SQL Server MS, Excel, and Flat files.
• Involved in developing strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products, and process and revenue streams.
• Involved in developing SQL Server Agent Jobs to schedule the ETL Packages on daily basis.
• Support for a major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Assist other departments with data mapping for the order management system.
• Provided strategic support to project manager in area including engineering, quality, supply chain, and manufacturing support for sales / marketing.
• Partnered with the technical areas in the research and resolution of system and process problems.
• Analysed research on operational procedures and methods and recommend changes for improvement - with an emphasis on automation and efficiency.
• Performed SQL queries on databases for data collection, augmentation and selecting the data variables in the process of analysis.
• Created and implemented Data Wrangling scripts for each data science tasks to pull the data from different databases like SQL Server, PostgreSQL.
• Planned, documented, executed, and supported the User Acceptance Testing (UAT) efforts relative to all projects by collaborating with the business.
• Assisted in defining project plans, including scoping, scheduling, and implementation.
• Maintained track of bugs and project issues on JIRA.
• Shared knowledge/experience with IT staff to promote a team environment.
• Prepared the business flow models for better understanding of requirements for technical team.

Confidential - Minneapolis, MN

Business Analyst

Responsibilities:

• Maintained KPI dashboards or reporting for merchandising and partner with ecommerce leadership to help identify improvement opportunities. Analysis to support potential new business initiatives. Develop and maintain reporting to assist with monitoring order flow.
• Assisted PM in creating Wire Frames to complete visual representation of the functional capability of the business need and implemented applications in B2C ecommerce, ERP, CRM, etc.
• Created workflows and process flow diagrams to communicate cross product dependencies and documenting dependencies in detailed documents and SME on various CRM based business processes and documented processes via use case diagrams and activity diagrams.
• Involved in creating various artifacts like BRD, functional specifications, Use Cases, User Stories, UML diagrams, data mapping documentation, pre and post RTM for the implementation of CMS.
• Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Responsible for developing annual and mid-year operating budgets by underwriting departments and on a consolidated basis for review by reinsurance group senior management.
• Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with ATGs eCommerce suite
• Proactively monitored the integrity and accuracy of data coming out of Adobe Analytics and work with product and technical teams to resolve any issues.
• Written use cases to build the site on the eCommerce platform Magento.
• Worked on many projects to convert data from one database structure to SQL server (Converting Fox pro DB into SQL server etc.).
• Migrated company's Salesforce data into company's SQL server DB so that the company could access this data using the company's application (Asset Enterprise).
• Participated in the analysis design and implementation and enhancement of hybris ecommerce Platform.
• Extensively worked on the ETL mappings, analysis, and documentation of OLAP reports requirements.
• Partnering with web development executing Adobe Analytics and Google Analytics tagging, QA testing.
• Extensive use of Adobe Web Analyst/Omniture Site-Catalyst for web-site analysis.
• Created GIVEN WHEN THEN (Agile Stories) statements using JIRA to dissect and distinguish the outcome of projects.
• Created and documented Test Scripts in JIRA for QA to execute.
• Executed weekly backlog grooming sessions in JIRA for cross-functional teams.
• Managed scrum team's workload and efficiency using JIRA Burndown chart.
• Focused on enhancing the user experience; worked closely with the technical and programming team to prepare Screen Mockups, User Interface designs using wireframe prototype for this E-commerce mobile/web redesign.
• Analyzed and interpreted trends in customer perception, preferences, and behaviors across the e-Commerce/website channel through full shopping cart life cycle and conversion funnels using Google Analytics.
• Involved in ecommerce Testing, Hybris Testing, Mobile Testing and User Acceptance Testing.
• Collaborated with members of the Ecommerce team as well as Merchandising, Creative, and Brand Marketing teams to provide analytic support to measure performance of efforts. Assisted end-users in identifying key performance indicators for their areas and proactively share knowledge and learning's.
• Centralized Project Management and Business Analysis capabilities into one team to ensure consistency of IT processes and SDLC deliverables across all IT Solution Delivery teams.
• Gathered and analyzed requirements, development of detailed functional designs and test cases in support of proposed projects and system enhancement requests.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).

Confidential - Atlanta, GA

Business Analyst

Responsibilities:

• Worked with Project Manager for the Implementation of a Retail Inventory Management.
• Used Jira for writing Epic, user stories with acceptance criteria or user stories with use cases, used confluence for upload documents.
• Gathered and wrote functional/business requirements used by engineers and programmers on multiple ecommerce applications as well as collaborate with User Experience/Interface designers to develop wireframes/schematics that support such requirements.
• Coordinated workflow across ecommerce, IT, UI, retail and UAT teams.
• Performed analysis of several websites to identify competitive advantages and value addition to Walmart.
• Worked with key Business Stakeholders, engineering development, and PMO on developing system enhancements.
• Gathered Software requirements through Customer interface, requirement workshops, task and workflow analysis, interviews, and brainstorming.
• Gathered user and business requirements through open-ended discussions, brainstorming sessions, and role-playing.
• Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
• Participated in joint application development (JAD) sessions with stakeholders in order to capture business rules, business processes, and system requirements.
• Worked on the execution of both eCommerce exclusive and omni-channel promotions.
• Used Agile methodology and utilized Software Development Life Cycle (SDLC) to configure and develop process, standards procedures.
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Produced metrics which provide management insight into the requirements process, to include, status, size, volatility, quality, effort, etc.- Visio, Rational Tools, Traceability Matrixes.
• Created and executed SQL queries to find clues on what may be causing the opportunity.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Involved in E-Commerce POS testing Product Search, Payment System, Online transaction processing.
• Participated and provided signoff based on User Acceptance Testing results.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Involved in developing strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.

Confidential, Oakland, CA

Business Analyst

Responsibilities:

• Involved in developing and instituting new procedures and protocolsfor proper chain of commandcommunications between all users of the NSBretail system and NSB. This resulted in fostering a more efficient processto ensurequeriesweretimely addressed and resulting inKellwood benefiting and utilizing all contracted benefits from NSB.
• Interacted with the SMEs and stakeholders to get a better understanding of client business processes and gather business requirements.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Performed Gap analysis and implemented updates for the Data Warehousing Application.
• Modeling the As-Is system and doing the complete Gap Analysis for the existing system in order to map it to the To-Be system.
• Used Balance Scorecard approach for developing program strategy in order to manage the grants program and development of metrics for monitoring success of program.
• Used MicroStrategy dashboards for data analysis and custom reports.
• Managed SOA/Process Integration Prepared High Level Logical Data Models and BRD’s (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 requirements.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Created business process workflow diagrams (Activity diagrams) in Rational Rose.
• Involved in designing, developing, and maintaining various Business unit reports by using Teradata, SQL, and MS Excel.
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Integrated Requisite Pro with Clear Quest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests.
• Managed all the requirements in Requisite, making requirements available to all team members.
• Created requirements analysis and design phase artifacts using Requisite, Rational Rose, and Smart Draw to create DFDs, ER diagrams, Use cases, Activity/ State chart, Sequence, Collaboration and Deployment Diagrams.
• Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.
• Used the Unified Change Management from Rational to track changes to multiple artifacts by versioning artifacts, associating requirements to specific change request/defects to streamline the defect/change tracking process.
• Performed Feasibility Analysis, Risk Analysis and Gap Analysis on vendor/third party tools.
• Followed the UML based methods using Rational Rose/MS Visio to create: Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.