We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

Greensboro, NC

SUMMARY:

  • An accomplished IT professional with 8 years of experience in delivering solutions in Salesforce, Oracle ATG Commerce, Oracle J.D. Edwards, Data Warehouse, Warehouse Management Systems, Order management Systems in the Supply Chain Domain as a Business Systems Analyst
  • Expertise in working through different phases of systems development life cycle and project life cycle in the industry using SDLC methodologies like Waterfall, Agile - Scrum, Kanban, Waterfall-Scrum Hybrid, Spiral and XP.
  • Specialization in executing Information Technology and business strategies for Stock Keeping Units Rationalization (SKU), Demand Forecasting and supply chain optimization processes, and vendor analysis, Order management System (OMS), Inventory management System (IMS) and Customer Relationship Management
  • Good knowledge and experience on E-commerce, ERP, Distribution Management Systems (DMS), Warehouse Management Systems (WMS), Order Management Systems (OMS) for Omni-Channel Retailers.
  • In depth knowledge and hands on experience on Supply chain optimization
  • Collaborated with Project Manager in developing/assessing Project Management Plan, Project Charter, and WBS
  • Experienced in requirement elicitation techniques such as Brainstorming, Joint Application Development (JAD) sessions, Job shadowing, one-on-one interviews, prototyping, and requirements/document analysis
  • Knowledge and experience in performing GAP Analysis, Cost-Benefit Analysis, Feasibility Study, Root Cause Analysis, Pareto Analysis, SWOT Analysis and Impact Analysis for planning and execution of business decisions
  • Good Business writing skills in creating High-Level Documents and Low-Level documents such as Business Requirement Document (BRD), FRD/FSD, SRS, Use Case Specification and Requirement Traceability Matrix (RTM)
  • Efficiently collaborated with Business Owners, Business Users, third party vendors and senior stakeholders
  • Experience in working with cross functional teams to understand the growth of team in the organization
  • Participated in various Scrum ceremonies- Sprint Planning, Sprint Review, Sprint Retrospective, Daily Scrum, and Backlog Grooming to improve the team’s performance while focusing towards a Sprint Goal
  • Assisted the Product Owner in prioritizing User stories based on Moscow, KANO, and have knowledge on estimating User stories using hours and story point estimation techniques such as T-Shirt sizing, Planning poker.
  • Encouraged the development team to follow -Naming Conventions, version control, better exceptions handling, unit testing, error/exception logging and comment writing and other best practices in the development environment
  • Designed High fidelity and Low fidelity Mockup’s/Wireframe using POP (Prototyping on paper), Adobe Photoshop, Microsoft Visio, Lucid chart, and Balsamiq for the requirements to get a visual understanding of the application under development, provided Functional/Technical Consulting for the application with a holistic view
  • Well acquainted with Unified Modeling Language (UML) diagrams like Use Case, Sequence and Activity diagrams.
  • Knowledge of extraction of data from source systems, transformation and load process ( ETL ) for a Data Warehouse using ETL tools like Informatica, MuleSoft and gave technical support in the use of Informatica for testing.
  • Knowledge of Database concepts including Data Warehousing, Dimensional modeling, Relational Database Management System (RDBMS), Data Marts, OLAP operations: Drill-Down, Roll-Up, Slicing and Dicing.
  • Experienced in creating data modeling diagrams such as Conceptual and Logical Entity Relationship Diagrams.
  • Used SQL queries & Stored Procedures using joins, unions, group by/order by and aggregate functions to extract data from different data sources for timely reporting, Validation of data and Verification of data standards.
  • Cultivated experience in working with web services using SOAP, REST, JSON under various architectures - Three-Tier Architecture, Service Oriented Architecture (SOA) with knowledge of Micro-services.
  • Experienced in documenting Web-services/API’s manually in MS Application and using markdown language/editors
  • Participated extensively in User Acceptance Testing (UAT), Black-Box testing, Smoke testing, Sanity testing, Load/Stress testing, Unit testing, Regression testing, End-to-End testing, and Integration testing.
  • Experience with working in Test Driven Development (TDD), Acceptance-Test-Driven Development (ATDD) and Behavior Driven Development (BDD) environments, knowledge of Continuous integration and continuous deployment (CICD) using GIT, Jenkins and Bamboo.
  • Expertise in change control, error handling, deployment & release management, and production support.
  • Experience in creating interactive, analytical reports and dashboards using Tableau, Einstein Analytics through understanding of Business Intelligence. Good understanding of Google Analytics.

TECHNICAL SKILLS:

Waterfall, Scrum, Custom Agile /Waterfall: Scrum Hybrid

AtlassianJIRA, HP: ALM, MS Project, MS SharePoint Server

Testing, Modelling and Web services: HPQC, Load Runner, Cucumber, Postman, POP, Lucidchart, Google Drawings, SOAP, REST, XML, JSON, Salesforce CRM

Reporting Tools: Tableau, MS office suite.

Databases/ETL: MySQL Server, Oracle, Info

Operating Systems: Windows XP, Windows 8, Windows 10, Mac OS 10

PROFESSIONAL EXPERIENCE:

Confidential, Greensboro, NC

Sr. Business Systems Analyst

Responsibilities:

  • Conducted JAD, Interview sessions, surveys and questionnaires to elicit the requirements from the clients about the functionalities of the website.
  • Created AS-IS and TO-BE business process flow by Gap analysis. Developed and maintained user stories in JIRA.
  • Designed Mockups in Balsamiq to get a visual understanding of the requirements for the E-commerce site, provided Functional Consulting and Technical Consulting for the application with a holistic view
  • Worked in creating the personas based on the previous orders for the site customization module.
  • Created the routing logic to facilitate order fulfilment from the closest, economically viable warehouse, taking into account the distance, truck load, weight-limitations and cross docking capabilities.
  • Documented user access and permissions according to the roles of the individuals in the organization.
  • Extensively used JIRA to record and maintain the artifacts such as Product backlogs, Sprint backlogs, user stories
  • Created instances for various teams in confluence and maintained effective collaboration between groups.
  • Conducted Time Studies / Process Mapping to maintain, validate and revise times standards where needed in Receiving, Stocking, Order Pulling and in Packing/Shipping areas
  • Interacted with premium buyers to understand their expectations from the E-commerce site and to get their point of view of the distribution system and worked with operations team in reducing bottlenecks.
  • Created conceptual/ logical ER-diagrams and designed Database Schemas for developing the Data Warehouse
  • Assisted the team in Identifying and Integrating various data sources like OLTP and Flat files to the OLAP using Informatica and performed Verification, validation and maintaining the accuracy and effectiveness of data
  • Documented web services interacting with the different ATG commerce modules.
  • Conducted the REST API testing using the software tool Postman and documented it with the help of Swagger.
  • Was Responsible for creating UML diagrams like use case, activity diagrams, and sequence diagrams
  • Was involved in the creating Test Plan, Test Scenario and Test Cases to provide a holistic view of the system
  • Participated extensively in Black box testing, User Acceptance Testing, alpha-testing
  • Involved in the Database Testing using SQL queries of the Application such as checking all the tables in the Database and checking whether the data is moving in their respective tables.
  • Presenting business stakeholders with periodic demos to showcase the functionalities being built.
  • Used Google AdWords and Search engine optimization to bring leads to the ecommerce site.
  • Worked with release management and various IT departments in creating release plans for the e-commerce platform.

Environment: Scrum, Oracle ATG Commerce, Oracle Endeca commerce, Balsamiq (V-15.0), JIRA (V-8.0.2), Informatica, MS Office suite (2016), Confluence (V-6.3.1), MySQL, Lucidchart, HP ALM, Postman, Swagger, Google AdWords.

Sr. Business Systems Analyst

Confidential, Michigan

Responsibilities :

  • Understood the existing system to perform GAP analysis and documented the results in as-is and to-be categories to generate the business requirements from the clients.
  • Worked on various Salesforce.com objects like Accounts, Opportunities, Leads, Campaign and Reports.
  • Assisted Salesforce admin in Design and development of Workflows rules, triggers, naming conventions, validation rules and other customizations with Salesforce and worked with the development team in case management, Lead management and campaign management.
  • Used Einstein analytics to understand different customer personas and assisted in targeted campaigns.
  • Involved in defining roles and permissions for internal user profiles.
  • Closely worked with Salesforce admin while implementing the solution needed for the organization.
  • Assisted the development team in customizing the marketing cloud console and designed the Validation Rules, Custom Tabs, Objects, Picklists, Dependent picklists, Workflows and Triggers.
  • Facilitated and led group discussions to elicit requirements in Joint Application Development (JAD) sessions by communicating with documented business requirement document working prototype and work flow diagrams.
  • Performed source analysis to identify, analyze the required data from the company’s JD Edwards ERP system and used SQL queries to retrieve the required data and identify the data formats.
  • Created UML diagrams like use case, activity diagram and sequence diagram in Lucidchart
  • Created logical and conceptual data models to show the entities, relationships and data mapping document to show the flow of data from multiple data sources to salesforce
  • Assisted with data imports, exports, updates to salesforce using data loader to gather data stored in CSV format.
  • Initiated and tracked the changes using Remedy Software, a Change Management Application
  • Worked with internal customers for bug management and bug tracking.
  • Performed API testing using Postman and documented the request and response body.
  • Analyzed data contained by the databases using Structured Query Language (SQL) and used Tableau to confirm data accuracy and integrity of various reports.
  • Performed Regression testing and created test scenarios for User Acceptance Testing (UAT) Translate the business requirements into functional specification documents for SFDC

Environment: Agile-Scrum Methodology, Salesforce Sales Cloud, Marketing cloud and service cloud, CPQ, Einstein Analytics, Remedy Software, Data loader, Jira (V-7.13.0), Confluence (V-5.8.2), Postman (V-4.11.0), MySQL, HPALM, Tableau, Lucidchart.

Confidential, Duluth, Georgia

Business Systems Analyst

Responsibilities:

  • Performed Gap-Analysis to identify the deficiencies of the current business systems and to identify the requirements for the change in the system to analyze the As-Is and To-Be to generate business requirements.
  • Facilitated JAD Sessions, Interviews sessions, Survey/Questionnaire, and Focus Groups to Elicit Requirements with various stakeholders, business users and SME’s for understanding the requirements.
  • Optimized execution of the supply chain balancing inventory, supply orders and schedule demand.
  • Managed supplier/subcontractor performance and relationship to ensure delivery, quality, financial stability, and in-service performance and Mitigated risks and issues, arised in the process.
  • Created the routing logic to facilitate order fulfilment from the closest, economically viable warehouse, taking into account the distance, truck load, weight limitations and cross docking capabilities.
  • Actively assisted the product owner in prioritizing the product backlog and breaking down them as per the maximum business value, grooming User Stories in planning activities and prepared the test cases.
  • Participated in various Scrum ceremonies like Sprint Planning Meeting, Daily Stand-up Meeting, Sprint Review Meeting, Sprint Retrospective Meeting, and Backlog Grooming and achieved towards a release goal.
  • Extensively used JIRA to record and maintain the artifacts such as Product backlogs, Sprint backlogs, user stories, data stories, Impediments list, tasks, defects, issue tracking and used Zephyr plugin for test cases.
  • Created data mapping specifications document and used Informatica to extract, combine and filter data from data sets from source system and performed the required transformations along with data analysts
  • Extensively used SQL scripts/queries for data verification at the backend as per the requirements.
  • Generated reports using Tableau for understanding the trends as well as to analyze patterns as per regions and predicting probability of occurrence for a better data visualization as per the business requirements.
  • Performed API testing using Postman and documented the request and response body.
  • Clarified QA team issues about the feature and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly
  • Maintained and created end-to-end testing strategy and enterprise wide test cases for Subject Matter Expert
  • Worked with internal users for bug management and bug tracking.
  • Conducted user acceptance testing and documented the results and relayed them to the development team.

Environment: Agile-Scrum methodology, MS Visio (V-15.0), Jira (V-7.1.8), Balsamiq (V-15.0), MySQL, Tableau (8.3), Informatica, Postman, MS Office suite, SharePoint.

Confidential

Business Systems Analyst

Responsibilities:

  • Documented/Contributed to GAP analysis with the Project Manager in planning the system transition
  • Conducted JAD sessions and interviews with SME’s & stakeholders to elicit the requirements for the system
  • Studied organization-project, processes, policies and procedures to get a detailed understanding of the project.
  • Collaborated with the QA team to design and develop Test Plan and Test Scenarios and Cases, involved in ETL testing process in validating the data, reviewing data dictionaries and in test data preparation
  • Involved in creating conceptual/ logical data models and designing DB Schemas for in developing the DWH.
  • Identified and Integrated various data sources like OLTP and Flat files to the OLAP using Informatica and performed Data Verification, Validity and Normalization in maintaining the accuracy and effectiveness of data
  • Generated periodic reports using Tableau for the management to make effective business decisions
  • Construct SQL Joins, Views, procedures queries to test and fetch the data from in-house OLTP DB’s
  • Used SQL queries to find correlation and patterns in existing data, used Tableau in generating effective reporting to provide Business Intelligence using various matrices critical to decision making
  • Created Use Cases and Designed UML diagrams like Use Case, Activity and Sequence using MS Visio
  • Analyzed, modified, Documented, and validated Business Requirements (BRD) and Systems Requirements (SRS)
  • Involved in the Database Testing using SQL queries of the Application such as checking all the tables in the Database and checking whether the data is moving in their respective tables.
  • Monitored, Managed and Tracked requirements using HP ALM throughout Application/Project Life-Cycle
  • Assisted the team in preparation of the training modules on tutorials to generate customized reports.

Environment: Waterfall-Scrum Hybrid, MS Office, Tableau, Informatica, MS Visio (V 7.0), MS Project, HP ALM (V12.0), Balsamiq (V 14.0), SQL Server, SharePoint, GAP Analysis, UML, UAT testing.

Confidential

Business Systems Analyst / Quality Analyst

Responsibilities:

  • Assisted in the development of business enterprise websites using Struts framework
  • Gathered requirements using one on one interviews, document analysis and Introspection methods.
  • Provided user requirements analysis and programming support for enhancement of Web applications
  • Was involved in creating the Project initiation document, Project charters and project planning document
  • Was responsible for Cost benefit analysis, Risk assessment, and SWOT analysis
  • G enerated and automated various Daily status, weekly reports, and Monthly and Quarterly reports.
  • Conducted GAP Analyses by understanding the AS-IS business process and TO-BE business process
  • Was Responsible for creating UML diagrams like use case, activity diagrams and sequence diagrams
  • Used Web Services to connect the shipping services to the existing system with SOAP API
  • Conducted Unit tests, Smoke test, Regression test and User acceptance tests.
  • Balanced multiple priorities simultaneously to adapt to the changing needs of the business while meeting deadlines.

Environment: Waterfall, Oracle, Oracle Warehouse Builder, MS Access, MS EXCEL, MS Word, MS Visio (V 15.0)

Confidential

Jr. Quality Assurance Analyst

Responsibilities:

  • Worked with the Quality lead and Business analyst to develop testing strategy.
  • Identified resource requirements, defined deliverables and reporting structures
  • Assisted with the Functional Requirement specifications and Processes
  • Created queries for testing of report enhancements
  • Prepared test cases and test data for report testing
  • Developed and maintained Manual and Automation test scripts through Quality center/ALM.
  • Collaborated with a team of developers to understand the reporting system functionality and capability
  • Involved in GUI Testing, Unit Testing, System Testing, Integration Testing, Regression Testing.
  • Involved in the Preparation and execution of Test Plans, Test cases, Writing Test scripts using Test Director
  • Conducted functional walkthroughs, User Acceptance Testing (UAT) sessions, and supervised the development of User Manuals for customers
  • Performed software Bug identification, tracking and reporting using managed Version control, and build processes for the Test Environment.
  • Documentation of Business Rules and creation of Data Model

Environment: Waterfall, HP (QC, Win Runner, Load runner, Test director, Quick test Pro), MS SQL Server, SharePoint, Tableau, MS office (2010).

Hire Now