PROFESSIONAL SUMMARY:

• 8 years of intensifying experience in multiple roles as Business Systems Analyst/SCRUM Master in the Ecommerce, Retail and Supply Chain Management with thorough knowledge of Software Development Life cycle (SDLC).
• Enthusiastic, Self - Motivated learner with a background in Project Management and Project coordination
• Excellent understanding of software development life cycle (SDLC) methodologies such as Waterfall, SCRUM-Agile, Hybrid Waterfall-SCRUM framework, SCRUMban, XP(extreme programming) and Scaled Agile Framework (SAFe).
• Extensive experience in working on Point-of-Sale (POS), Retail, EDW apps and systems connected in vast network.
• Well acquainted with various e-commerce platforms such as Magento and Shopify and Exposure to Marketing and Web Analytics for e-commerce website using Google Analytics, Search engine optimization, AdWordsand Adobe Analytics for intelligent data collection and analysis.Hands on experience working upon Click through rates, Conversion rate, Content management system, order fulfillment, Replenishment, Shopping Cart, Process Improvement, merchandising, Customer profiling, categories, payment gateway compliance.
• Strong interpersonal and communication skills including verbal, listening, written documentation, influencing, facilitation, presentation skills for Technical or business audiences across the board.
• Data mapping, logical data modeling, created class diagrams, ER diagrams and used SQL queries to filter data.
• Great domain knowledge including Anchor store, brick and click, CRM, Cross Merchandising, Upselling, Markdowns, Inventory, Warehouse management system, BOPIS, Drop, shipping, Keystone Pricing, Point of Sale, Margins
• Adept in eliciting business requirements with various techniques such as Joint Application development (JAD), Focus groups, Requirements Workshops, Brainstorming, Document analysis, Pilot Projects and Interviews.
• Experience working with a large workload and tight Deadlines .
• Excellent business writing skills in creating artifacts such as Business requirements document (BRD), Functional Requirement Document (FRD), Systems Requirements Specification (SRS), andUse Case Specifications.
• Excellent in performing Impact Assessment, Feasibility Analysis, Cost-Benefit Analysis and Gap Analysis to check the compatibility of the existing system and infrastructure with new Business Requirements.
• Create and Process documentation for project team using Confluence.
• Driving the Application Development Lifecycle in Scrum Team, working with business partners to analyze and design system solutions to business problems and needs using Agile method.
• Experience in Database Applications with Oracle, SQL Server, MS Access and very efficient in tuning the SQL queries and using several tools and utilities.
• Assisted Project Managers in preparing Project Plans, Project Schedules, establishing Milestones, Work Breakdown Structure (WBS), maintained RACI chart to manage overall project risks and mitigation plans.
• Proficient with User Stories, writing Acceptance criteria and handling the Requirements Churn .
• Able to efficiently and effectively minimize the number of manual hours through Process Improvement .
• Strong communication skills and the ability to effectively lead multiple teams, through sprint cycles.
• Well acquainted with workflows and Unified Modeling Language (UML) diagrams with Use Cases, Activity, Sequence and Data Flow Diagrams and ER Diagrams via Rational Rose and MS-Visio.
• Leveraged Business knowledge and client services expertise in resolving conflicts
• Research and resolve issues in regard with Scrum/Kanban methodologies / Process Improvement .
• Proven success in Eliciting Requirements, Impact Analysis, Cause and Effect, GAP Analysis, As-Is and To-Be Analysis, Cost Benefit Analysis, Risk, ROI Analysis and SWOT Analysis.
• Worked upon SQL queries for QA testing and report / data validation.
• Hands on experience with Data Migration techniques using Informatica power center tool.
• Great knowledge working upon Master Data management for decision making Process and special campaigns.
• Extensive knowledge of Data Warehousing architecture, implementation approaches, schemas, and dimensional modeling. Expertise in creating Data Models- Conceptualdata model, Physical data modeland logical data model in the form of entitiesand relationships to capture the user requirements in the underlying Database.
• Cultivated experience in working with different web services such as HTML, WSDL, SOAP, UDDI, REST, JSON under various architectures like Three-Tier Architecture and Service Oriented Architecture (SOA).
• Adept at supervising Black-box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, Security Testing, Load/Stress Testing, andPerformance Testing.
• Collaborated and monitored various testing’s’ such as Black-Box testing, Smoke Testing, Regression Testing, an d User Acceptance Testing (UAT) for verifying and validating the product
• Proficient in Microsoft Office tools like MS Access, MS Visio, MS Excel, MS Word, MS PowerPoint and MS Project.

SKILL:

Operating Systems: Windows 7,8,10,XP/Vista/Mac OS X

Modeling Tools: Rational Rose, MS Visio, Axure, Lucid Chart

SDLC Methodologies: Waterfall, Agile-SCRUM, Waterfall-SCRUM Hybrid, SCRUMban, SAFe

Web Service: SOAP, REST, AJAX, XML, JSON, WSDL, WADL, XSD, DOM.

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Drill Up/ Drill Down, Pivot, Informatica Power Center,CA Platinum Repository

Requirement Management: MS Office, JIRA, TFS, Version One, HP-ALM

Project Management Tools: MS Project, MS SharePoint Server, Confluence

Testing Tools: HP QC/ALM v11.5, Bugzilla, Selenium, Load Runner, Cucumber

ETL Tools: Informatica PowerCenter Server Data Tools

Reporting Tools: Tableau Desktop, IBM Cognos, MS Office Suite, MicroStrategy, Google Analytics, SSRS

Languages: HTML, SQL, JavaScript, Java, C, Python

IDE: MS Visual Studio, Eclipse

Databases: MySQL, Oracle, MS Access, HBase, Dynamo DB

PROFESSIONAL WORK EXPERIENCE:

Confidential, Bridgewater, NJ

Kanban Flow Manager/Business Analyst

Responsibilities:

• Emphasis on Elicitation of requirements through Research , formal-informal sessions , JAD sessions with SMEs (subject matter experts), Teams, Stakeholders and end users to identify the Business rules, requirements and then documented them in a format that can be reviewed and understood by both Business people and Technical folks
• Facilitate Process Improvement projects, developing Process Documentation such as process maps on all levels and maintain current documents for cross functional teams.
• Research . identify, and specify solutions to problems within the Process.
• Document requirements specifications using requirements traceability matrixes ; and writing SQL scripts as needed.
• Liaison between stakeholders, system users, clients and managers, software development team and the QA team to gather requirements changes to business processes, policies and information systems.
• Lead teams to meet Deadlines , take initiative to complete the task at hand.
• Involve with data ingestion and data consumption teams on intake activities and procedures for timely ingestion of data into grid
• Worked with Database team, involved in writing SQL queries, extracting data, creating modifying tables, functions procedures
• Studied and analyzed competitor's applications and brainstormed to gather effective requirements .
• Designed and Documented requirement artifacts utilizing industry standard diagram techniques to enhance the clarity of definition, including: process flows, context diagrams, use cases, wire frames , etc.
• Assist with cutover plan across the teams so that the projects can go into production which is followed by two weeks of hyper care for the business go live. Worked in an Agile / Scrum frame work with two weeks sprint cycle with a release every five weeks.
• Facilitate story boarding, backlog grooming, prioritizing, daily stand ups and retrospective meetings.
• Experience working with multiple development approaches for internal and externally developed applications as well as packaged applications including incremental, waterfall, and Agile Scrum, or Kanban .
• Conduct release planning, release review, release retrospective and daily stand up meetings.
• Identified and communicate team velocity/resource capacity to match the current scope to leadership
• Prioritized the Product Backlog with the Product Owner and managed the changes in scope.
• Managing requirements traceability matrix and change control for different modules.
• Working with different teams involving Subject matter experts, QA and Technical teams
• Deploy task and Issue Tracking, User Story Management and create reporting dashboards and data visualizations (Excel, Business Objects) to help users visualize their reporting needs using Jira and Leankit.
• Involved in weekly walkthroughs , demo's and assessment meetings to verify the status of the project.
• Participated in industry and other professional networks to ensure awareness of industry standards, trends and best practice to strengthen organizational and Technical knowledge.

Environment: Agile (KANBAN), Spring XD, Informatica, GemFire, RESTful Web Service, TC server, Kafka, Spark, XML, JIRA, LeanKit, SharePoint, MS Office, MS Visio, REST, Tableau.

Confidential, Greensboro, NC

Sr. Business Systems Analyst

Responsibilities:

• Analyzed the Business Process along with the prior project documentation for complete understanding of the project. Also, interviewed SME’s and CROin order to better understand the business Process.
• Serve as liaison between users and Technical groups to resolve issues.
• Plan, design, and author all Process Documentation materials, and user guides for the deployment of major software deliverables.
• Created and modified SQL queries to extract data from the insurance database.
• Collaborated with sales teams, content management team and digital marketing team to provide the customer with seamless customer experience through all channels mobile, website and in store.
• Created Mock-up Screens and Wireframes using UI Components such as Radio Buttons, Drop-down and Check boxes, and demonstrated it to stakeholders.
• Document all interface requirements for functional department and analyze and recommend strategies to enhance projects and coordinate with social media team and analyze all projects from conceptualization to implementation.
• Worked with complex data transformation and helped the ETL developers to understand it.
• Performed Technical analysis related to advanced data analysis, data mining, and source to target mapping.
• Worked on service-oriented architecture (SOA), RESTful API’s generating JSON, BSON, XML responses using PL/SQL and JDBC drivers to establish connections with Databases.
• Assisted in developing extensive SQL Queries and Procedures, utilized to perform Database integrity testing, ensuring various data table entries, data validity, and data integrity
• Performed logical data modeling and created ER diagrams and used SQL queries for manipulating data.
• Assisted in Scheduling MDM Informatica ETL tasks to transfer data from mainframe to distributed systems with extensive unit and integration testing. Primary data was integrated into Master Data Management hub and used for Special campaigns and allows easy analysis and reduced overall cost involved.
• Captioned meetings to gather the API Requirements for both the source and target system and documented the REST API requests and responses in XML format.
• Actively involved in reading data from varied file types created standard and ad-hoc reports using MS Excel.
• Prepared UAT test document and developed Test Scenarios for validating the Business requirements and Uploaded Test scenarios, mapped Business requirements to Test scenarios and updated defects and defect tracking in Quality Center. Assisted testing team in UI testing using selenium and documented the defects in the JIRA.
• Conducted User Acceptance Test (UAT) by setting up UAT environment utilizing HPALM.
• Generated insights from the reports the team received from the Business Intelligence team and presented recommendations to the Product Owner and the management for strategy and decision making.

Environment: - Agile-Scrum, Java, HTML/CSS, AngularJS, Bootstrap, jQuery, SQL, Erwin Data modeler, Informatica Power Center, MDM, Web Services, SOA, API, REST, MS Office, MS Visio, Share Point, JIRA, HP QC, Tableau, Oracle Data Miner

Confidential, Framingham, MA

Sr. Business SystemsAnalyst

Responsibilities:

• Conducted user interviews, attended JAD (Joint Application development) sessions, created agendas and documented functional and non-functional requirements.
• Present information of Research progress and outcomes to project teams & externally to clients.
• Wrote user interface guidelines for field service mobile apps to ensure that developers were coding to a standard "look and feel" which improved developer productivity. Designed current business processes and proposed solution for business process re-engineering throughout the process mapping lifecycle.
• Created Activity Diagrams, Sequence Diagrams using UML methodologies for easy understanding using MSVISIO
• Responsible for implementing, coordinating and documenting all business processes for (Web based apps).
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Used JIRA for deploying task and Issue Tracking, User Story Management and create reporting dashboards and data visualizations (Excel, Business Objects) to help users visualize their reporting needs.
• Prepared Requirement Traceability Matrix (RTM) report to ensure that every Business requirement is adhered to achieve the expected performance and have visibility on complete test coverage w.r.t requirements elicited.
• Assisted the QA team in development of Test Strategies, creation of Test Scenarios and Test cases.
• Update sprint tracker with accurate information to identify the risk and issues proactively at the sprint level.
• Closely worked with them while performing Functional, regression, sanity, and integration testing using Selenium.
• Conducted User Acceptance Test (UAT) by setting up UAT environment utilizing HPALM.
• Monitored the timelines, budget and target at each demo of potentially shippable product increment

Environment: - SCRUM, Jira, UML, MS Visio, MS Project, SQL, Tableau, PL/SQL, MS Office, MS SQL Database, PowerPoint and Excel

Confidential, MA

Sr. Business Systems Analyst

Responsibilities:

• Employed Observation technique on the existing Process
• Elicitated requirements by interview, surveys, and prototyping with the stakeholders.
• Created data model for the Star Schema using Erwin, created DDL scripts for static dimensions and ETL Mappings using Informatica PowerCenter and Used DML, DCL and DDL SQL queries for constructing the DWH
• Created Data mapping specifications , Source to Target mapping documents including the transformation rules.
• Worked closely with Data Architects and development team to make sure requirements are understood
• Performed data analysis using SQL , data profiling and validation on the various source data systems and feeds and cleansed and standardized the data to be provided to ETL.
• Led the User Acceptance Testing ( UAT ) efforts and opened/closed defects on HP QC .

Environment: Waterfall- SCRUM Hybrid, Erwin 3.5.2, PL/ SQL , Angular JS, Oracle 9i, Informatica 7.1, BO 6.5/, Informatica PowerCenter, MS Visual studio 2013, MS Word, MS Excel, MS PowerPoint, MS Access, Tableau

Confidential

Business Analyst

Responsibilities:

• Gathered business requirements by conducting Interviews , Joint Application development ( JAD ) sessions, Focus Groups, Brainstorming sessions with the Business Users and key-Stakeholders.
• Worked with senior managers to understand operation's needs during the launch of Confidential warehouses (fulfillment centers, delivery stations, sort centers) and support the launches with system configuration
• Worked with software developers to identify gaps or problems between what the software can offer, and customer needs and wants and Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and store users for Requirement gathering in Definition Stage.
• Worded on multiple competing high-profile projects with tight Deadlines. Trained/lead other business analysts
• Worked on projects when they started from scratch, Used SQL queries to pull data from Databases to produce delivery metrics. Used solver pack, pivot tables, lookups to analyze data, Produced delivery volume forecasts

Environment: PL/SQL, Java (J2EE), Waterfall, Test Director, XML, API, FTP, Win Runner, Rational Requisite Pro, MS Office, MS Visio, MS Project, Agile/SCRUM, HTML, CSS, RUP, VOIP, UML, CobiT.

Confidential

Business Analyst

Responsibilities:

• Experienced in identifying the pain points of stakeholders and providing solutions as per Technical terms.
• Understanding the requirements of stakeholders and work along with them.
• Experienced in designing UML diagrams like USE case diagram and ACTIVITY diagram.
• Hands on experience in preparing documents like business requirement document (BRD), functional requirement document (FRD) and wrote Acceptance criteria for the user stories.
• Worked closely with tester team and derived test cases from use case diagram and worked on them with Technical team and testing team if any deviation happens from expected result.
• Coordinated in implementation of project with Technical team, Client and verifying plans executed as per design.
• Communicated with all the stakeholders and worked along with them for smooth project handling.

Environment: Waterfall, MS Visio 2010, MS Office Suite 2010(Excel, Word, PowerPoint), Windows XP, MS Project 2010, SharePoint, HPALM 11.0, HTML, CSS, Java Script, J2EE.