PROFESSIONAL SUMMARY:

• Experienced IT Professional with over 8 years of experience across entire aspects of general information technology industry and its applications in e - commerce, retail and supply chain domain by constantly creating value for various businesses and clients by delivering quality software systems and enhancing the business process so as to suit organizational needs.
• Actively solicited vital information from business users, having the ability to meet strict and challenging deadlines.
• Excellent analytical, communication, organizational, interpersonal, critical-thinking and problem-solving skills that is talented with conflict management and change management.
• Knowledgeable and experienced in Software Development Life Cycle (SDLC) involving traditional methodology like Waterfall and Agile methodologies like Scrum, Safe, Scrumban, Water Scrum Fall & RUP
• Professionally collaborated with Business Owners , Business Users, third party vendors and stakeholders
• Well experienced in performing various analysis as Gap analysis, Impact analysis, risk analysis, SWOT analysis, feasibility analysis, cost benefit analysis, benchmarking or market analysis and MOST analysis
• Elicited requirements using various techniques like Joint Application Development ( JAD ) sessions , Interview sessions , Document analysis, Focus Groups, Requirement workshops and Questionnaire over the years
• Collaborated with Project Managers in developing Concept Proposal, Project Scope Statement, Project Management Plan , Project Charter , Risk Management Plan and Work Breakdown Structure (WBS)
• Experience in writing Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirement Specification (SRS), Requirement Traceability Matrix (RTM) as per the requirement
• Extensively used JIRA for managing Epics, User stories and contributed in Scrum Ceremonies like Release Planning, Backlog grooming, Sprint Planning, Daily stand ups, Sprint Reviews and Retrospective
• Extensive experience in assisting Product owner in choosing prioritizing techniques like Moscow, KANO and estimating techniques like Agile Planning Poker, T-shirt Sizing, Bucket sizing and Relative Mass Valuation
• Experienced in both capacity-based and velocity-based sprint planning based on the level of team’s maturity
• Expertise in creating UML diagrams like Use Cases, Activity & Sequence diagrams using Lucid Chart, Visio
• W orked on both High Fidelity and Low Fidelity Mockup Screens and Wireframes using Balsamiq
• Hands on experience in retrieving data and data validation using SQL queries like Joins , views, Sub queries and Aggregate functions like max, min, sum and average with good understanding of Procedures, Functions and Triggers. Also used Informatica Transformations (Filter, Source, Aggregate, Joiner etc.,) for Modifications
• In-depth knowledge on Databases, Data Table Structures, Data marts, Data Analysis, Data Integration, Data Modelling, Schemas, Architecture and OLAP operations viz . Slice, Dice, Pivot, Roll-up, Drill-down
• Good understanding on the integration process of SAP ERP with Inventory and warehouse management system using Magic XPI integration platform and integrating SAP ERP with Salceforce.com using MuleSoft
• Widespread knowledge on different types of extraction process of data from source system , transformation of the extracted data and loading the data into target system ( ETL ) for a Data Warehouse using ( Informatica, MuleSoft and Magic XPI ) and gave necessary technical support in the use of Informatica tool for testing
• Expert in creating Data Modeling, E-R Model in the form of entities and relationships and Dimensional Modeling in the form of facts & dimensions to capture the user requirements properly in the underlying database
• Good understanding of Business Intelligence tools and experienced in creating interactive dashboards with heat maps, bar graphs, pie charts, line graphs, bubble charts and pivot tables using Tableau and Excel for reports
• Strong and concrete understanding of web service concepts like HTTP, REST, SOAP, JSON, XML, Parsers under various architectures like Three-Tier & n-Tier Architecture and Service Orient (SOA) Architectures
• Assisted in API testing using POSTMAN to check if the API's are returning the data in JSON or XML format as defined in the API documentation using SWAGGER Tool and as required by process workflow
• Good knowledge in Continuous Integration and Continuous Deployment (CICD) using Jenkins and Bamboo
• Experienced in defect tracking, defect analysis & ability to organize , document & track changes using Jira
• Experience of working in different phases of Software Test Life Cycle (STLC) and involved in designing Test plans, Test strategies and Test Cases for User Acceptance Testing, Black-box Testing, Functional Testing, various System Testing, Integration Testing, Regression Testing, Security Testing, Load Testing Stress Testing, and Performance Testing in both manual testing and automation testing environment
• Well versed in creation of Test plans, Test strategies, Test cases and Test scenarios for validating it against business requirements document and worked on HP Quality Center/ Application Lifecycle Management
• Adopted various engineering practiced like Test Driven Development (TDD), Behavioral Driven Development (BDD), Acceptance Test Driven Development (ATDD), Pair Programming (PP) for performance & efficiency

TECHNICAL SKILLS:

SDLC Methodologies: Agile/Scrum, SAFe, Waterfall, XP, Kanban, Scrumban, Water Scrum Fall, RUP, eXtreme Programming (XP)

Programming Languages: MY SQL, C++, JAVA, HTML

Database & Data Analysis tools: SQL server, Oracle 8/9/10, MS Access, Informatica Power Center 9.6.1, Data Mining, MuleSoft, Slicing, MS SSRS (SQL Server Reporting Service), Tableau, Power BI

Modeling Designing: MS Visio, Smart Draw, Balasmiq, Lucid Chart, Rational Rose

Requirements, Test & Defect Management: JIRA, Mercury Quality Center, HP QC/ALM, Confluence, Cucumber, Load Runner, Rational Requisite Pro

Productivity tools: MS Office, MS Project, MS SharePoint, MS Word, MS PowerPoint, MS Excel

Operating Systems: Windows XP, Windows 8, Windows 10, LINUX, UNIX, IOS

Web Services API: SOAP, REST, JSON, XML, Postman, Swagger

Integration Tools: Magic XPI, MuleSoft

PROFESSIONAL EXPERIENCE:

Confidential, Fishers, IN

Sr. Business System Analyst

Responsibilities:

• Interviewed Subject Matter Experts (SME) and performed extensive Document Reviews to develop a thorough understanding of business processes & analyzed the supply chain to aid Business Process Improvements
• Performed document analysis, conducted interviews and workshops to gather requirements related to inventory, stock, suppliers, customers, etc., from SME’s, stakeholders, business users and business owners
• Requirements were based on supply chain KPI’s (Key Performance Indicators) , product information , sales data , order history , etc., and converted these requirements into user stories and stored them in JIRA
• Created UML diagrams like use case & activity diagrams and created high level ER diagrams using MS Visio
• Analyzed inventory requirements from B2B & B2C clients based on the sales and developed process to optimize the orders that has to be fulfilled based on SKU dimensions, pallet size, customer and delivery requirements
• Participated in Scrum ceremonies, extensively used JIRA for converting requirements to User stories , assisted the Product Owner in writing acceptance criteria and framing Definition of Done (DOD) for the PSPI
• Used Atlassian JIRA and Atlassian Confluence for tracking and managing the requirements and user stories
• Developed and implemented process improvements in order to maintain optimal inventories throughout the supply chain by researching and validating order management, fulfillment, & distributed inventory process
• Efficiently studied and tested Magic XPI integration process and assisted as and when required
• Studied the stand-alone product of SAP’s Inventory Management System & Warehouse management system
• Leverage knowledge of Batch Integration process by making REST’s Bulk API calls from the application (I/WMS) to the API to upload the data into the existing SAP ERP using the Magic XPI integration platform
• Created data mapping specification document and used informatica & Magic XPI’s data mapper to extract , combine and filter data sets from source and performed the required transformations along with data analyst
• Used SQL (Structured Query Language)- CRUD operations to analyze the data in the data warehouse
• Used Tableau to create custom reports and dashboards with sales, inventory, suppliers & customer trends and reported them in the management. Used Magic XPI’s Monitor to check the health of the systems integration
• Identified & documented REST API using Swagger & involved in testing of APIs using Postman
• Developed test cases to validate the requirements and documented the Requirement Traceability matrix for keeping track of all the test cases and user requirements till they are executed and updated their status accordingly
• Conducted User Acceptance Testing (UAT) and actively participated and facilitated testing of the system during Smoke Testing, Integration Testing, Black Box Testing and Regression Testing with the help of QA team
• Wrote test cases, test plan & strategies . Involved in defect tracking & life cycle management using HP ALM

Environment: Scrum, JIRA (7.x), Oracle (12c), MS Visio, MS Office, MySQL, Postman 5.2, Swagger 3.0, Tableau, Magic XPI integration platform, Magic XPI data mapper, Informatica Power Center 9.6.x, Confluence

Confidential, Louisville, KY

Business System Analyst

Responsibilities:

• Identified key stakeholders and gathered functional and non-functional requirements related to application enhancement, customer trends, market insights, etc., through interviews, document analysis and JAD sessions
• Created the As-Is business process flow and To-Be business process flow by performing the Gap analysis
• Developed user stories based on the AS () I WANT TO () SO THAT () format and stored them in JIRA
• Incorporated User Stories in different release plans of the sprints and estimated & prioritized them accordingly
• Performed source analysis to identify, analyze the required data from SAP ERP & from other on-premise databases and used SQL queries to retrieve the required data and identify the data formats
• Designed and created wireframes and mockup - screens using Balsamiq for the particular functionality and created UML diagrams like Use case , activity and sequence diagrams using MS Visio
• Efficiently studied and tested MuleSoft’s integration process and assisted based on the need
• Created logical and conceptual data model to show the entities and relationship between them
• Created data mapping specification to show the flow of data from the multiple data sources (ERP to Salesforce)
• Assisted developers in customizing service and marketing cloud console by embedding visual force markup .
• Also assisted the design team in designing page layouts, tabs, used validation rules and relationship for creating custom objects and application like business process, camping metrics, custom cases, etc.,
• Designed & Maintained profiles, users, role hierarchy and set security and permission sets for it.
• Implemented email-to-case entry and manual case entry for entering customer cases in case tabs
• Worked with the developers and assisted in case management , lead management and camping management
• Assisted in data profiling , data cleansing , setting the data connection and data integration of Salesforce and SAP-ERP system to gather the required data using MuleSoft Any point integration platform
• Assisted with data imports, exports, updates to Salesforce using data loader to gather data from CSV format
• Ensured the data being mapped was according to the field requirements and validation rules set in Salesforce
• Developed and created customized reports and dashboards in SFDC for service and marketing clouds
• Performed API testing using Postman and created API documentation for request & response using Swagger
• Prepared test data from user stories, wrote and executes those test cases in JIRA and coordinated with the business partners in conducting the User Acceptance Testing (UAT) to get the feedback from the end client
• Utilized Test Driven Development (TDD) & Behavioral Driven Development (BDD) along with the QA team
• Developed analytical lens, datasets, reports, dashboards using Tableau which helped in analyzing the current market, customer performance and in improving the omni-channel experience and customer satisfaction

Environment: Scrum, JIRA (7.x), Oracle (10g), MS Visio, MS. Office, MySQL, Postman 5.2, Swagger 3.0, Tableau, MuleSoft Any point studio, Balsamiq, Informatica Power Center 9.6.x, Salesforce developer module, Confluence

Confidential, Estero, FL

Business System Analyst

Responsibilities:

• Elicited requirements using various techniques like Interview, group workshops, job shadowing, observation
• Conducted informal sessions to propose a solution such that application met business requirements and addressed new requests and documented those requirements in JIRA
• Conducted walkthroughs and meetings with the project team and end-users to formulate the System Requirement Specifications ( SRS) document from informal business requirements .
• Participated in eliciting, analyzing, gathering and validating business requirements and translating business requirements into use cases and/or functional and system specifications and documented and analyzed business processes and application requirements. Also performed various types of analysis including the benchmarking and market analysis to get a better idea on the scalability of the bill portal system
• Facilitated budget forecasting , proposed enhancements and changes to the web site and other marketing programs through analysis , decision process facilitation , report preparation . Performed cost-benefit analysis
• Facilitated and conducted (JAD) Joint Application Design Sessions to determine business requirements by bringing the stakeholders and IT team on a common platform and created target questionnaires for both of them and documented & maintained the requested enhancements in a Traceability Matrix
• Worked in hands with QA team to perform defect tracking and maintain trailing history of bugs using JIRA & Confluence and assisted the testers and QA team in developing test plan, test strategy and test cases
• Assisted the Quality Assurance team, stakeholders & developers in identifying the test environment based on the need and assisted them in developing & creating the test data and test scripts accordingly.
• Used Tableau for data reporting, studying the trends, data patterns, data forecasting and visualization
• Worked with QA team to create and execute Unit test, System test, regression test and User Acceptance Testing and performed a vital role in the User Acceptance Testing (UAT) of the final product

Environment: Hybrid Scrum, JIRA (7.x), Confluence, MS Visio, MS Office, Tableau, Balsamiq, MySQL, HP ALM

Confidential

Business Analyst

Responsibilities:

• Interviewed clients, SMEs & business users to understand their Business & Functional Requirements and gathered their future needs & transformed them to technical requirements and technical specifications
• Collaborated with client partners to gather requirements . Designed and created user stories & acceptance criteria for all the requirements to implement customized ecommerce stores for multiple client partners
• Applied all the phases of SDLC during the project to develop and enhance the product under the B2C Application.
• Converted the Business Requirement Documents (BRD) into Functional Requirement document (FRD)
• Worked on all Scrum ceremonies like backlog refinement, release and sprint planning, standups and review
• Played a major role along with Scrum Master in retrospective meeting to inspect and adapt the teams process
• Conducted one-to-one meetings & web-Conferences as well as JAD sessions with different stakeholders; analyzed & came up with suggestions providing consistent process for the communication & resolution
• Efficiently used Atlassian’s JIRA and Confluence for better efficient in communication with the team
• Efficiently prioritized and maintained the detail functional requirements and design specifications for the website while translating the business requirement into the web development analysis
• Performed GAP analysis between the “ As-IS ” model of the legacy system & the “ To-Be ” model to identify the gaps logged issues relating to the identified gaps & worked with SME to get clarifications
• Performed benchmarking and market analysis based on the various features that are need to be refurbished
• Extensively involved in data mapping, conceptual and logical data modeling and creating ER diagram
• Used Structured Query Language to filter data within the Oracle and SQL database server
• Used all the modules of I nformatica Power center to complete the ETL process and implement the required transformations . Assisted in data profiling and data mapping based on the transformation as per the need.
• Assisted in selecting the type of extract, transform and load process and helped in implementing them
• Assisted in creating User Interface document to express UI component design and its navigation. Created wireframes & mockups using Balsamiq . Created process flow diagrams & use cases template using MS Visio
• Wrote test plans, test strategies, test cases using MS Excel and reviewed it with the business requirements for manual testing, unit testing, systems testing, smoke & sanity testing, regression and User Acceptance testing
• Prepared & maintained Requirements Traceability Matrix to keep track of all the requirements and test cases
• Tracked and documented change requests and monitored the workload along with the schedule
• Involved in unit, functional, regression and system Testing , Facilitated User Acceptance testing (UAT)

Environment: Water Scrum Fall, JIRA, Confluence, Oracle, MS Visio, MS Office, MySQL, Postman, Swagger, Tableau, Informatica Power Center 9.5.x, Balsamiq, HP Quality Center, XML, SOAP UI

Confidential

Jr. Business Analyst

Responsibilities:

• Elicited requirements using JAD sessions, Surveys/ Questionnaire, Interviews sessions, Requirement Workshops, Focus Groups, Interface analysis and conducted GAP Analysis to derive requirements
• Conducted Cost Benefit analysis, feasibility analysis, impact analysis, Risk analysis for the scope and system
• Created both high-level and low-level documents like Business Requirement document (BRD), Functional Requirement Document (FRD) and System Requirement Specification (SRS)
• Used JIRA for issue tracking, ticket management, defect management and requirement traceability
• Developed Conceptual and Logical data model for stakeholders and the team with help of architects
• Created Mock-Ups screens and Wireframes using Visio for User Interface component for client verification
• Performed data analysis and pulled up few charts based on the data using Microsoft Excel and Pivot charts
• Performed an extended research study on the current inventory & warehouse system and documented the gaps
• Generated SQL queries using joins, sub queries and aggregate functions , database connection and various transformation rules to fetch data from Microsoft SQL Server database systems
• Assisted design team & architects to develop the System Design Document and helped them to understand the solution, Assisted the developers and the development team in creating Software Development Document
• Supported ETL developers in creating workflows and scheduling batch processes based in data mapping and assisted in data cleansing and data profiling as needed. Helped in choosing the type of ETL process
• Assisted in developing and validating the data mapping specification document done by the team lead
• Handled the changes through Change Control Board (CCB) and Change Approval Board (CAB)
• Supervised the Database teams and DBAs while implementing the Enterprise Data Warehouse
• Worked closely with testing team to prepare the test plan and test strategy. Assisted in creating and executing test cases based on requirements and updated the status in Requirement Traceability matrix (RTM)
• Assisted in User Acceptance Testing, developing and maintaining quality procedures and ensure that proper documentation is in place. Assisted the testing team in Smoke and Regression testing as well
• Used Tableau for data reporting, studying the trends, data patterns, data forecasting and visualization
• Performed the performance measure against the baseline document and helped in maintaining the feedback report
• Elicited requirements using JAD sessions, Surveys/ Questionnaire, Interviews sessions, Requirement Workshops, Focus Groups, Interface analysis and conducted GAP Analysis to derive requirements

Environment: Water Fall, JIRA, MS SQL, MS Visio, MS Office, MS Excel, MS Project, Tableau, Informatica Power Center, Confluence

Confidential

Jr. QA Analyst/ Intern

Responsibilities:

• Worked with internal team to understand the business requirements gather by Business Analyst team
• Solid history of discovering errors, resolving defects & ensuring client expectation are met with quality solution
• Understood business requirements . Prepared & executed test cases for the customization and enhancements
• Updated comments in the test scope based on the changes made by test lead and prepared necessary documents.
• Assisted in developing test scope document and identification of all the dependencies and test constraints
• Attended the design meeting conducted with designers & developers for understanding the testing requirements
• Executed the test case and updated the test case status on HP Quality Center for the team to check on that
• Logged defects in JIRA and performed defect tracking and customized reporting based on the analysis need