SUMMARY:

• Experienced IT Professional with over 8+ years of experience distributed 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 business processes in order to suit organizational needs
• Experience of working with different Software Development Life Cycle (SDLC) involving both traditional methodology such as Waterfall and Agile methodologies such as Scrum, Scrumban and Scrum-SAFe
• Efficiently collaborated with Business Owners, Business Users, third party vendors and senior stakeholders
• Specialization in developing and executing IT and business strategies for Lean manufacturing, Value chain streamlining, SKU Rationalization, Demand Forecasting and supply chain optimization processes like warehouse-slotting, route planning and vendor analysis ,OMS,IMS and Customer Relationship Management
• Elicited requirements using various techniques such as Joint Application Development (JAD) sessions, Interview sessions, Document analysis, Focus Groups, Requirement workshops and Questionnaire over the years
• Collaborated with Project Manager in developing/assessing Project Management Plan, Project Charter and WBS
• Familiarity in writing Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirement Specification (SRS), Requirement Traceability Matrix (RTM) as per company requirement
• Extensively used JIRA for managing User stories and contributed in Scrum Ceremonies like Release Planning, Backlog grooming, Sprint Planning, Sprint Review and Retrospective also assisted in choosing prioritizing techniques like Moscow, KANO and estimating techniques like Agile Poker, T-shirt Sizing and RMV
• Expertise in creating UML diagrams like Use Cases, Activity, Sequence, and Class diagrams using MS Visio and worked on both High Fidelity and Low Fidelity Mockup Screens and wireframes using Lucid Chart and Balsamiq
• Extensive experience in performing Feasibility Study, SWOT analysis, Cost Benefit analysis and Gap Analysis (As Is, To Be) in various projects
• Assisted the development team by converting process information, client wish lists and Salesforce functionality into a Requirements Traceability Matrix (RTM) so that the requirements can be traced during test phase
• 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 Data Modification
• In-depth knowledge of implementing Databases, Data Table Structures, Data marts, Data Analysis, Data Integration, Data Modeling, Schemas and OLAP operations viz. Slice, Dice, Pivot, Roll-up , and Drill-down and Mulesoft for integrating SAP ERP and Salesforce CRM system as well as incorporating the existing legacy systems
• Widespread knowledge of extraction of data from source systems, transformation and load process (ETL) for a Data Warehouse using ( Informatica, Mulesoft) and gave technical support in the use of Informatica for testing
• Proficient in creating Data Modeling, E-R Model, and Dimensional Model in the form of entities and relationships to capture the user requirements properly in the underlying database
• Understanding of Business Intelligence tools(SQL2005,Einstein analytics) and experienced in creating interactive dashboards with heat maps, bar graphs, pie charts and pivot tables using Tableau and Excel for reports
• Skilled in working with different web services such as RESTful Web Services and SOAP Web Services
• Strong and concrete understanding of web service concepts like HTML, CSS, WSDL, WADL, SOAP, UDDI, REST, JSON, Parsers - SAX, DOM under various architectures like Three-Tier Architecture, Service Orient Architecture (SOA), Micro Services Architecture (MSA)
• Involved in scripting business logic in the web methods of the web services and documenting the Web Service Level Agreement (WSLA) document using Extensible Markup Language (XML) to serve as a contract between the front-end & the back-end team for efficient building of application, resolving ambiguities & speedup design
• Assisted in API testing using Postman to check if the API's are returning the data in JSON, XML format as defined in the API documentation (Using Swagger Tool) and as required by workflow
• Extensive knowledge of Continuous Integration and Continuous Deployment (CICD) using Jenkins and Bamboo
• Experienced in defect tracking, defect analysis & ability to organize, document & track changes using Jira
• Assisted the QA team to design Test plans and Test Cases for User Acceptance Testing, Black-box Testing, Functional Testing, various System Testing, Integration Testing, Regression Testing, Security Testing, Load/Stress Testing, and Performance Testing in both manual and automation testing environment and creation of Test plans, Test cases and Test scenarios for validating it against business requirements document

TECHNICAL SKILLS:

TOOLS: Database & Data Analysis tools

Tableau, MS SQL server, Oracle 8/9/10, DB2, MS Access, Informatica Power Center 9.6.1, Data Mining, Mulesoft, Slicing, MS SSRS

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

Requirements, Test & Defect Management: JIRA, Quality Center, HP ALM, Confluence, Selenium, Cucumber, Load Runner, IBM, Rational Requisite Pro

Modeling Designing: MS Visio, Smart Draw, Process Model, Blasmiq

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

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

SDLC Methodologies: Agile/Scrum, SAFe, XP, Kanban, Scrumban, Waterfall

AJAX, SOAP, REST, B: PIPE, XML, FIX, STML

PROFESSIONAL EXPERIENCE:

Business Analyst

Confidential - Stevens Point, WI

Responsibilities:

• Performed Gap Analysis to identify the deficiencies of the current business systems and to identify the impact
• Assisted Project Manager in creating Project Charter and Task Breakdown Document (TBD) using MS Project
• Facilitated reverse engineering and conducted focus groups and document analysis to elicit requirements with stakeholders, business users and SME’s and analyze them to create technical specifications
• Created rules for the regular data transfer from Data Source (SAP) to Data Target (REDSHIFT Server)
• Created data mapping documentation for various types of data loads using Informatica by creating templates
• Performed Data mapping using SQL to filter data and assisted in Creation of Hash tables referencing the Surrogate Key tables for efficient lookup to Dimensions and helps detect changes during ETL process
• Responsible for mapping and modeling the Conceptual, Logical and Physical models specific to AWS Redshift
• Capture data from database Streams via kinesis with aggregations in EC2 instance simplifying development
• Perform Data investigation as part of UAT and completed Data Quality Processes like Data Profiling, Cleansing
• Linked Tableau and Salesforce with adaptors to give insight into the reporting of the employee dashboards.
• Prioritized the API function call for testers, categorized the API based on System, Performance & experience.
• Documented and tested REST APIs and SOAP web services with the XML format and other formats using Swagger and used plugins for integrating it with Java-based Application as well as .net using Visual Studio
• Assisted the testing team in developing the Test Plan, Test Conditions, and Test Cases based on business requirements and technical specifications in UAT with assistance in Requirement Traceability Matrix

Environment: - Scrumban, UML, Java, XML, REST, SAP erp, SOAP, SharePoint, MS Visio, MS Project, JIRA 7.0.9, Swagger, Informatica Power Center9.5.X, Tableau 9.2.2

Business Systems Analyst

Confidential - Chicago, IL

Responsibilities:

• Interviewed clients, SMEs & business users to understand their Business & Functional Requirements, gathering their future needs & transforming them to Functional Specifications for the benefit of the team
• Administered JAD sessions and interviewed end-users to elicit business requirements; Categorized and documented these requirements and prioritiz000ed them in the product backlog along with the product owner
• Conducted one-to-one meetings & web-Conferences as well as JAD sessions with different stakeholders; analyzed and assisted in creating a Business Analysis Process Model using Rational Rose and MS Visio
• Managed the team responsible for Master Data and its creation, maintenance and verification in SAP systems
• Extensively involved in data mapping, logical data modeling, creating class diagrams and ER diagrams
• Used SQL queries to filter data within the Oracle and SQL Server and used it to upload data into SQL tables
• Created wireframes & mock-ups for the omni-channel project of customer information and catalogue pages
• Analyzed and organized data into appropriate story to support business initiatives and regulatory compliance
• Conducted WAN and LAN offline testing to test the POS’s behavior, document the time taken for each payment transaction and analyzed the purchasing trends of the customers to enable future improvements
• Involved in unit, functional, regression & system Testing, Facilitated User Acceptance testing (UAT)

Environment: Environment: scrum-agile, Office 365, SOAP, XML, DB2, SAP, SQL Server, MS Visio, SOAP UI, HP Quality Center, Informatica Power Center 9.5.x, Balsamiq

Business Analyst

Confidential - Columbus, OH

Responsibilities:

• Assisted PM in developing project scope document, concept statement, risk analysis document, mitigation plan and proposal statement. Performed feasibility study, SWOT analysis and cost benefit analysis
• Understood the As-Is system, developed the To-Be system and prepared the Business Process Plan
• Elicited requirements by conducting Interviews and JAD sessions. Interviewed business owner’s and SME’s to understand the system flow and gain knowledge about the data mapping, views and the system transition
• Converted the requirements and was responsible for creating the Business Requirements Document (BRD)
• Assisted PO in framing the Definition of Done (DOD) and creating acceptance criteria that had be communicated
• Responsible for mapping the Workday Business Requirements, Business Process Design and Integrated systems
• Facilitated and managed meeting sessions with PM, BO, committee of SME’s and team members to explain the roles, responsibilities, deliverables, timelines, assignments and status reporting for the various teams
• Created complex and efficient SQL queries for the stored procedures, the triggers, the views and the user defined functions to implement the business logic which is required for the effective data analysis and data cleansing
• Responsible for Workday HR data request of field and values mapping from Peoplesoft to Workday
• Used DDL, DML and DQL SQL queries to perform data analysis, data validation and data manipulation
• Created an interface between HR client groups and the workday team to enable Workday implementations
• Created Custom reports from the desired modules and gave it to our third-party vendors for integration purposes
• Created XML documents for embedding data into TCS tool to create placeholders
• Assisted QA team in performing Functional Testing and User Acceptance Testing (UAT)
• Developed user manuals, presentations and training manuals as per project specifications and timelines
• Used Tableau for reporting, pattern recognition, Business Intelligence (BI) and performance improvement

Environment: FACETS 5.4/5.5, Tableau 7.0.9, JIRA, SharePoint, workday, SQL Server, MS Excel, TCS tool, UAT, XML

Business System Analyst

Confidential - Whitehouse Station, NJ

Responsibilities:

• Assisted in the development of business enterprise system using SRSS dataset queries and SSIS package upgrades
• Gathered requirements using one on one interviews, document analysis and Introspection methods.
• Prepared the Business Requirements Document (BRD) for the gathered requirements and helped in prioritizing
• Conducted GAP Analysis by understanding the AS-IS business process and TO-BE business process
• Created complex T-SQL queries to develop and modify schema, objects, views and joints
• Was involved in creating the Project initiation document (PID), Project charters and project planning document
• Correlated business analysis with strong knowledge of ER Diagrams to create powerful OLTP systems
• Worked on performance tuning and query optimization using SQL Profiler to create better profiles of the data
• Write extensive Stored Procedures, Triggers, Cursors and Functions to automate complex processes
• Participated in code review and was responsible for development and integration environments for UAT purposes
• Conducted Unit tests, Smoke test, Regression test and User acceptance test and delivered the project

Environment: : - SQL, SSIS, SSRS, Visual Studio, Excel Spreadsheet Compare, TFS, Devart Code Compare.

Confidential, Jersey City, NJ

Sr Business System Analyst

Responsibilities:

• Interviewed Subject Matter Experts and to develop a thorough understanding of business processes & analyzed the supply chain to aid Business Process Improvements and analyze the process design
• Supported the assigned product owner by assisting in creating project plans, developing the project workflows, creating scope documents along with the process of scheduling and tracking project timelines
• 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 that was presented to the users
• Worked closely with the technical team to convert the functional requirements into technical specifications like Prototypes, Graphical User Interface (GUI) and User Interface (UI) mock-ups using Balsamiq
• Assisted the Mulesoft architect to create the API Design Document and validate the final process flow
• Created Use Case diagrams, Use Case Templates and process flow diagrams using MS Visio for both systems
• Performed CRUD operations on SQL & stored procedures using SELECT & JOIN for drill downs to pull data while being actively involved in reading data from varied file types, created standard and ad-hoc reports using SQL, generating delimited files and SQL script to load data into SQL tables
• Identified Source systems for the data profiling for Order-Tracking, Notifications and inventory management
• Worked with Informatica for ETL processes to perform Data integrations from Legacy Systems to MDM and worked with MuleSoft for Real time Data integrations from MDM to Future Systems using API's
• Facilitated meetings with Salesforce Admin, Developers and Architect to determine the data that should be integrated into Salesforce platform, as it was used for powerful data integration of OMS and IMS
• Maintain clear and detailed integration requirement specifications, ensuring the design is of the most efficient streamlined flow that ensures there will be no inadequacies and no redundancies for the system
• Used MuleSoft’s Anypoint template for Salesforce integration to simplify the process of merging data, updating Salesforce with ERP data in real time, ensuring data consistency across Salesforce instances & creating and integrating APIs that pulled data from multiple systems and integrate them into one platform
• Leverage knowledge of Batch Integration process by making REST’s Bulk API calls from the application to the API to upload the data and Lightning Bolt to fetch the data from Salesforce that needs to be integrated
• Created API documentation using Swagger and communicated it with the developers to serve as a POC
• Assisted creation of Test Cases, Test Plans, Test Scenarios, and updated Requirements Traceability Matrix
• Assisted testing team in UI testing and documented the defects in the ALM, conducted API testing using POSTMAN and used ALM to Manage Defects/Bugs and Test Cases that can be rectified later
• Conducted User Acceptance Testing (UAT) and actively participated and facilitated end to end testing of the system using Runtime Manager with the help of QA and the entire testing team and delivered the product
• Worked on Change Management requirement with the stake holders and development team for the project

Environment: Scrum-SAFe, MS Visio, MS SQL server, Salesforce.net,Office 365, JIRA 7.9.2, Tableau 10.5.2, Web Services, SOA, Bulk API, REST, Balsamiq, MS Office Suite (MS word, MS Excel, PowerPoint), Selenium, Mulesoft

Business System Analyst

Confidential - Columbus, OH

Responsibilities:

• Reviewed business processes with subject matter experts to develop process maps and centralization of work
• Involved in project scope meetings with the Inventory manager and the customer manager to understand the type of requests and issues handled by the inventory team and documented the high-level business requirements to the product backlog using JIRA and reshuffled the requirements according to the priority
• Analyzed the changes performed in CRM application for inventory, sales etc. and documented those changes
• Translated changes to business & functional requirements for the service and marketing cloud in SFDC
• Created weekly Metrex Customer login reports in SQL Server Stored procedures for Dynamics CRM
• Facilitated Joint Application Development (JAD) for identifying existing system, current business process, methods to identify deficiencies, areas for improvement & enhancements that can be applied to the system
• Upgraded some Apps from Salesforce Classic to Lightning Experience to develop rich user interface
• Developed multiple custom database applications for data archiving, analysis, and reporting purposes
• Added new custom objects, assigned fields, designed page layouts, custom tabs & custom reports
• Integrated Web Services for extracting the data from external systems to display in Salesforce
• Collaborated with vendor to ensure inventory demand is forecasted, orders are tracked and delivered on time
• Involved in identification and documentation of Salesforce APIs like REST, SOAP, Bulk and Analytical APIs
• Reviewed Test case, Test data & Test Scenario to make sure testing should perform properly
• Created various Reports & Dashboard with Tableau & Power BI to assist managers to better utilize Salesforce cloud as a Marketing Cloud, Service Cloud & Analytics Cloud that enables them to make informed decisions
• Closely monitored & performed Smoke tests, UAT Sessions, worked on defect life cycle using JIRA
• Actively participated in Post Production Validation (PPV) & handled issues appropriately
• Used Sales performance management software Optymyze to improve service operations and sales strategies

Environment: - Salesforce.net, Einstein analytics SalesForce, Selenium, MS Project, Balsamiq, MS Excel, SAP, Jira7.3.3, Tableau 10.2.1, MS Visio, Web Services, SOA, Bulk API, REST, Optymyze, Informatica Power Center 10.2.0