SUMMARY

• Experienced IT Professional wif 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 wif different Software Development Life Cycle (SDLC) involving both traditional methodology such as Waterfall and Agile methodologies such as Scrum, kanban, Scrumban and waterscrumfall
• Efficiently collaborated wif 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 teh years
• Collaborated wif 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 while assisting Product owner 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
• Designed & deployed custom dynamic workflows, validation rules, Approval Processes & Auto-Response Rules for automating business logic wif Sales & marketing cloud on salesforce.com
• Experience working wif Salesforce Classic and Lightning UI for custom theming, branding Wave and Einstein Analytics for account & opportunity insights, recommendations, prediction builder & predictive sorting
• 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 wif good understanding of Procedures, Functions and Triggers, also used Informatica Transformations (Filter, Source, Aggregate, Joiner etc.) for Data Modification
• In-depth noledge 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
• Widespread noledge of extraction of data from source systems, transformation and load process (ETL) for a Data Warehouse using Informatica and gave technical support in teh use of Informatica for testing
• Proficient in creating Data Modeling, E-R Model, and Dimensional Model in teh form of entities and relationships to capture teh user requirements properly in teh underlying database
• Understanding of Business Intelligence tools(SQL2005,Einstein analytics) and experienced in creating interactive dashboards wif heat maps, bar graphs, pie charts and pivot tables using Tableau and Excel for reports
• Skilled in working wif 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 teh web methods of teh web services and documenting teh Web Service Level Agreement (WSLA) document using Extensible Markup Language (XML) to serve as a contract between teh front-end & teh back-end team for efficient building of application, resolving ambiguities & speedup design
• Assisted in API testing using Postman to check if teh API's are returning teh data in JSON, XML format as defined in teh API documentation (Using Swagger Tool) and as required by workflow
• Extensive noledge 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 teh 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

Database & Data Analysis tools: Tableau, MS SQL server, Oracle 8/9/10, DB2, MS Access, Informatica Power Center 9.6.1, Data Mining, 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, Waterfall, XP, Kanban, Scrumban, Water Scrum Fall

Web Services API: AJAX, SOAP, REST, B-PIPE, XML, FIX, STML

PROFESSIONAL EXPERIENCE

Confidential, Blue ash, OH

Sr. Business Systems Analyst

Responsibilities:

• Interviewed Subject Matter Experts and performed extensive Document Reviews to develop a thorough understanding of business processes & analyzed teh supply chain to aid Business Process Improvements
• Performed Document Analysis and created process flow diagrams to understand teh AS-IS process and collaborated wif teh team to design teh TO-BE process based on teh gatheird requirements
• Participated in Scrum ceremonies, extensively used Jira for converting requirements to User stories, assisted teh Product Owner in writing acceptance criteria and framing Definition Of Done(DOD) for teh PSPI
• Worked closely wif teh technical team to convert teh functional requirements into technical specifications like Prototypes, Graphical User Interface (GUI) and User Interface (UI) mock-ups using Balsamiq
• Created Users, Roles, Public Groups & implemented role hierarchies & record level permissions to manage sharing access among different users on marketing cloud of SFDC
• 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
• Facilitated meetings wif Salesforce Admin, Developers and Architect to determine teh data dat should be integrated into Salesforce platform, as it was used for powerful data integration of OMS and IMS
• Leverage noledge of Batch Integration process by making REST’s Bulk API calls from teh application to teh API to upload teh data and Lightning Bolt to fetch teh data from Salesforce
• Created API documentation using Swagger and communicated it wif teh developers to serve as a POC
• Assisted creation of Test Cases, Test Plans, Test Scenarios, and updated Requirements Traceability Matrix
• Used MuleSoft’s Anypoint template for Salesforce integration to simplify teh process of merging data, updating Salesforce wif ERP data in real time, ensuring data consistency across Salesforce instances & creating and integrating APIs dat pulled data from multiple systems
• Conducted User Acceptance Testing (UAT) and actively participated and facilitated testing of teh system during Smoke Testing, Integration Testing, Black Box Testing and Regression Testing wif teh halp of QA
• Assisted testing team in UI testing using Selenium and documented teh defects in teh Jira

Environment: Scrum, MS Visio, MS SQL server 2012,Salesforce,Amazon S3, JIRA 6.4.14, Tableau 10.3, Web Services, SOA, Bulk API, REST, MS Office Suite (MS word, MS Excel, PowerPoint), Selenium, Mulesoft

Confidential, Richfield, MN

Sr. Business Systems Analyst

Responsibilities:

• Conducted requirement walkthroughs to understand teh benefits of teh new system being implemented and also served as liaison between business & technology department to enhance communication
• Performed GAP analysis by creating AS-IS & TO-BE documents to identify existing system, current business process, methods to identify deficiencies, areas for improvement & enhancements
• Analyzed teh changes performed in CRM application for marketing, sales etc., translated them to business & functional requirements for Service Cloud in SFDC
• Responsible for creating & documenting user stories, business rules, workflow diagrams & business process modeling (BPM) for teh proposed functionality
• Designed & deployed dynamic workflows, validation rules, Approval Processes & Auto-Response Rules for automating business logic wif Sales & marketing cloud on salesforce.com
• Added new custom objects, assigned fields, designed page layouts, custom tabs & custom reports
• Integrated Web Services for extracting teh data from external systems to display in Salesforce
• Captured user requirements in teh form of User stories and defined Acceptance criteria for each of them
• Participated in scrum ceremonies like sprint planning, backlog grooming & sprint reviews
• 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 wif Tableau & Power BI to assist managers to better utilize Salesforce cloud as a Sales Cloud, Marketing Cloud, Service Cloud & Analytics Cloud
• 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 sales operations and execute sales strategies

Environment: - Agile-Scrum, Salesforce Lightning UI, Einstein analytics, Selenium, MS Project, Balsamiq, MS Excel, SAP Jira4.14,Tableau 10.5, MS Visio, Web Services, SOA, Bulk API, REST, Optymyze, Informatica Power Center 9.6.x

Confidential, Menomonee Falls, WI

Sr. Business Analyst

Responsibilities:

• Performed Gap Analysis to identify teh deficiencies of teh current business systems and to identify teh Just in Time requirements for conduct Change Management TEMPeffectively
• Assisted Project Manager in creating Project Charter, Work Breakdown Structure (WBS) and Scope statements and maintained them on MS Project
• Facilitated reverse engineering and conducted focus groups and document analysis to elicit requirements wif stakeholders, business users and SME’s for understanding requirements
• Played key role in developing and driving KAIZEN and lean initiatives in SCM functions
• Drafted Business Requirement Document (BRD) for teh specific business requirements and Functional Requirements Document (FSD) capture teh functional and Non functional requirement’s
• Worked wif development team for handling Spikes of order cart management, payment gateways and accounts management
• Actively involved in creating and monitoring new tasks on teh Kanban board in order to gain a better visualization of workflow as well as breaking those tasks into user stories
• Used JIRA extensively for issue tracking, user story management (writing user stories, owning user stories, acceptance criteria and definition of done) and requirement traceability
• Responsible for creating UML diagrams specifically activity diagrams & use case diagrams for reports
• Documented and tested REST APIs and SOAP web services wif teh XML format and other formats using Swagger and used plugins for integrating it wif Java-based Application as well as .net using Visual Studio
• Assisted teh testing team in developing teh Test Plan, Test Conditions, and Test Cases based on business requirements and technical specifications in UAT wif assistance in Requirement Traceability Matrix

Environment: - Kanban, UML, Java, XML, REST, SOAP, SharePoint, MS Visio, MS Project, JIRA 6.6.51, Swagger, Informatica Power Center9.5.X,Tableau V8.0

Confidential

Sr. Business Systems Analyst

Responsibilities:

• Interviewed clients, SMEs & business users to understand their Business & Functional Requirements, gathering their future needs & transforming them to Functional Specifications
• Converted teh Business Requirements Documents into Functional Requirements document
• Conducted one-to-one meetings & web-Conferences as well as JAD sessions wif different stakeholders; analyzed & came up wif suggestions providing consistent process for teh communication & resolution
• Performed GAP Analysis between teh "As-Is" model of teh legacy system & teh "To-Be" model to identify teh gaps logged issues relating to teh identified gaps & worked wif teh SME to get clarifications
• Extensively involved in data mapping, logical data modeling, creating class diagrams, ER diagrams & used SQL queries to filter data wifin teh Oracle, SQL Server
• Assisted in creating User Interface Document to express UI component design & navigation & created wireframes & mock-ups using Balsamiq
• Created Use Case Templates & Process Flow diagrams using Microsoft Visio for all System Functionalities
• Prepared & maintained Requirements Traceability Matrix to keep a trace of all teh requirements
• Tracked and documented change requests & monitored workload & schedule
• Involved in unit, functional, regression & system Testing, Facilitated User Acceptance testing (UAT)

Environment: Environment: waterscrumfall-agile, SOAP, XML, DB2, SAP, SQL Server, MS Visio, SOAP UI, HP Quality Center, Informatica Power Center 9.5.x, Blasmiq

Confidential

Sr. Business Systems Analyst

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 teh As-Is system, developed teh To-Be system and prepared teh System Process Maps
• Elicited requirements by conducting Brainstorming and JAD sessions. Interviewed business owner’s and SME’s by asking both open ended and close ended questions to refine teh requirements
• Created requirements documents- BRD & FRD. Converted these requirements into user stories along wif teh team and product owner. Assisted PO in defining acceptance criteria and prioritization of requirements.
• Coordinated requirements using incident tracking tool- JIRA
• Created Use Case diagram, Data Flow diagram, Activity diagram showing teh workflow Using lucid charts
• Created and updated teh Gantt chart to trace teh project planning in detail
• Facilitated and managed meeting sessions wif PM, BO, committee of SME’s and ensured dat their requirements are implemented as specified in teh business and functional requirements
• Used DDL, DML and DQL SQL queries to perform data analysis, data validation and data manipulation
• Involved in API technical writing and documented XML and JSON request and responses
• Created Test Plans and Test Cases for functional testing by analyzing teh Business requirements specification document
• Reviewed test scripts to ensure dat all teh functional requirements were tested
• 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 and business intelligence (BI)

Environment: Waterfall-scrum Hybrid, SOA, MS Office 365, HTML, JIRA5.6.1, Selenium, Tableau V8.0, Oracle 11g, SOAP UI, Lucid charts, MySQL 5.5, Informatica Power Center 9.5.X

Confidential

Business Systems Analyst

Responsibilities:

• Elicited requirements using JAD sessions, Surveys/Questionnaire, Interview sessions, Requirement Workshops, Focus Groups, Interface Analysis and conducted GAP Analysis to derive requirements
• Conducted Cost Benefit analysis, Feasibility check, Impact analysis, Cost analysis, and evaluated Porter’s Five Forces
• Helped teh Product Owner Prioritize teh Product Backlog for developing Sprint tasks supported by cross-functional team. Used JIRA for issue tracking, user story management and requirement traceability
• Created Mock-Up Screens and Wireframes using Visio for User Interface components for client verification
• Developed Conceptual and Logical data models for Customer and Collateral tables
• Generated ad hoc SQL queries using joins, sub queries and aggregate functions, database connections and transformation rules to fetch data from teh SQL Serverdatabase systems
• Supported ETL developers in creating workflows and scheduling batch processes based on Data Mapping
• Oversaw teh Database teams and DBAs while implementing teh Enterprise Data Warehouse
• Assisted in UAT, developing and maintaining quality procedures, and ensure dat proper documentation is in place. Assisted in Smoke and Regression testing
• Used Tableau for data reporting, studying teh trends, data patterns, data forecasting and visualization.

Environment: Waterfall - Agile Methodology, MS SQL 5.5, MS Office 365 (SharePoint, Project, PowerPoint, Visio), Jira 5.10.5, Informatica Power Center 9.5.X, Tableau V 7.0

Confidential

Java developer/Business analyst

Responsibilities:

• Assisted in teh development of business enterprise websites using Struts frame work
• Gatheird 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 teh Project initiation document (PID),Project charters and project planning document
• Was responsible for Cost benefit analysis, Risk assessment, and SWOT analysis
• Conducted GAP Analyses by understanding teh 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 teh shipping services to teh existing system wif SOAP API
• Conducted Unit tests, Smoke test, Regression test and User acceptance test

Environment: Waterfall, Oracle, Java, XML, Java Script, Oracle Warehouse Builder, Jira5.6.1, MS Access, MS EXCEL, MS Word, MS Visio