SUMMARY

• Extensive working knowledge of all the phases of Software Development Life Cycle (SDLC) and have hands on experience working in waterfall; agile methodologies Scrum, Kanban & Scaled Agile Framework (SAFe 4.0); hybrid methodologies Water - scrum-fall, Scrumban. Knowledge of Extreme programming (XP), Spiral methodologies.
• Highly skilled in structured planning methods for project evaluation like GAP Analysis, SWOT Analysis, Cost-benefit Analysis, Feasibility Analysis, Risk Analysis, various Root cause analysis techniques (5 why’s, Ishikawa diagram) to assist Project Manager in Release Planning & Product Owner in setting good stakeholder expectations.
• Skilled in conducting and facilitating Requirement Gathering Activities to gather SMART (Specific, Measurable, Attainable, Realistic and Timely) requirements using diverse elicitation techniques including, but not limited to Interviews, Requirement Workshops, Prototyping, Survey/Questionnaire, JAD Sessions and Brainstorming.
• Excellent Business writing skills in drafting High Level Document (HLD) like Business Requirements Document (BRD), Functional Requirement Document (FRD); and Low-Level Documents (LLD) like Functional Specifications, Systems Requirements Specification (SRS), Data Specification Document, Workflows, and User Story.
• Adept in performing both Quantitative and Qualitative Risk Analysis using techniques such as Delphi technique, Root cause analysis and Monte Carlo Simulation analysis.
• Assisted PM in preparing Project Schedules, establishing Milestones & creating Work Breakdown Structure (WBS).
• Assisted Product owner in backlog grooming activity by utilizing prioritization techniques like MoSCoW, Business Value, Kano, Technical Risk and estimation techniques, assisted in picking Product Backlog Items (PBIs) to commit
• Detailed understanding of RACI chart to manage overall project risks & mitigation plans, prepared Requirement Traceability Matrix (RTM) to map requirement with its origin throughout the process to verify adherence.
• Assisted Product Owner in defining minimum viable product (MVP) features of the application under development.
• Excellent knowledge of Unified Modeling Language (UML) diagrams including Activity Chart, Use Case Diagram, and Sequence Diagram to support business process flow around entities and in identifying primary actors.
• Experienced in creating Wireframes and Mock-Up Screens to visualize Graphical User Interface (GUI) as to understand the layout of the interface using tools like Balsamiq, Moqups and Axure and get them validated. Well versed with ASP.NET, JQuery, Ajax, HTML5 and CSS3, Telerik controls for User Interface prototype creation.
• Strong experience in Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services. Utilized different ETL tools like Informatica power center, SSIS. Designedand implementedSQLqueries, stored procedures; utilized joins,unions,group byandaggregatefunctions to extract data.
• Assisted Data Architect in creating Data Models like Conceptual data model and logical data model in the form of entities and relationships to capture the user requirements properly in the underlying database.
• Practical knowledge of Data Warehousing architecture, implementation approaches, dimensional modeling and translating the business requirements into various types of dimensions like snowflake schema, starflake schema and galaxy schema, and performed source to target mapping and created Data Mapping Specification Document.
• Experience in implementing Service Oriented Architecture (SOA) using Web Services (SOAP, REST, XML, JSON)
• Documented requirements for API development i.e. was responsible for technical writing of both XML and JSON utilizing Api. Used SOAP UI and Postman for API testing. Used Swagger tool for API documentation.
• Adept at supervising Manual Testing, Automation testing, Black-box Testing, Sandbox testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, Security Testing, Load/Stress Testing and Performance Testing along with User Acceptance Testing (UAT) and helped in designing and developing test plans
• Exposure to Web Analytics for e-commerce website using Google Analytics and Adobe Analytics for intelligent data collection and analysis.
• Comprehensive experience and knowledge in using Data Modeling and Business Intelligence tools OBIEE, IBM Cognos, SAS 9.2, TABLEAU, Microsoft SSIS, IBM Infosphere MDM.
• Performed Rollup, Drill down, Pivot, Slice and Dice operation on OLAP cubes to provide timely, accurate insights.

TECHNICAL SKILLS

Requirement Management: Atlassian-JIRA, CA Agile, HP-ALM, iRise and VersionOne

Project Management Tools: Microsoft Office: Excel, Word, Lotus, VISIO, MS Project, PowerPoint, Web conferencing.

Business Modeling tools: Oracle Enterprise Report Builder, Crystal Reports, COGNOS BI, Informatica Power Center 8.x/9.x, SSIS, SAS

Modeling Tools: MS Visio, Draw.io, Google Drawings, iRise

Testing Tools: HP Quality center, Selenium, Load Runner, Cucumber, Swagger, SoapUI

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

Reporting Tools: Tableau, MicroStrategy, MS office suite, Google Analytics, Oracle BI

Languages: JAVA, C, C#, SQL, CSS, XML, HTML5, SQL, JAVAScipt.

Databases: MySQL Server, DB2, Oracle Developer, PL/SQL, SAP HANA DB, Oracle 12g, SQL Server 2000.

Business Skills: Conflict Management, Project Planning, Impact Analysis, Root Cause Analysis, Gap Analysis, SWOT Analysis, Fit/Gap Analysis, Delta Design Workshops

Other: FTP, SFTP, Use Case Diagrams, Sequence Diagram, UML, Scrum, Agile Methodologies, MDM

PROFESSIONAL EXPERIENCE:

Sr. Business System Analyst

Confidential, Ada, MI

Responsibilities:

• Performed AS-IS & TO-BE business process GAP analysis, created business process model and notation (BPMN).
• Documented the Functional and Technical Specifications requirements based on the business flow for Material Managment, Human Resource, Inventory Managment, CO, SD modules and POS in the existing Legacy systems.
• Conducted several workshops with the business team to understand and document the business purpose and data owners of all the attributes and developed business rules for data migration in the system to be developed.
• Identified business requirements for Source to pay and mapped them to the Oracle application functionality.
• Actively assisted the product owner in prioritizing the product backlog as per the maximum business value, grooming User Stories in planning activities using INVEST criteria 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
• Impediments list, tasks, defects, and issue tracking using customized Jira Query Language in JIRA issue tracking tool.
• Worked with other Process Modelers in creating Target Process Model TPM by understanding the Standard Operating Procedures (SOP) and developed current and target state Process Flow Diagrams.
• Assisted system architect to configure Oracle Applications to meet client requirements & documented set-ups.
• Worked with master data management (MDM) include data collection, data transformation, normalization, data consolidation, data storage, data distribution, data classification as per and Online Analytical processing (OLAP)
• Followed ORACLE Best Practice Solution Builder for building, configuration and integration for the RESTful services.
• Did Data extraction and Integration in to Data marts by using Informatica Power center from the legacy systems.
• Extensively used Informatica power center for extraction, transformation and loading process. Implemented manual automated test scripts for Risk Warehouse decision support system using HP Quality Center.
• Prepared testing schedules and coordinated testing activities and worked closely with internal business groups and third-party vendors to ensure the successful implementation of new modules.
• Managed the testing process of the application with the client and vendor resources. Documenting positive and negative test scripts/cases, tracking & managing resolution issues, executing test scripts and documenting results.
• Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result. Performed SQL validation to verify the data extracts and record counts in the database.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status. Extensively worked with backend activities for testing several reports developed by BI tools. Wrote several complex SQL queries for querying data from respective databases.
• Involved in systems integration testing, web services API testing using SOAP UI and Postman API testing tools. Assisted in development of end-user documentation with user manual.
• Learnt and Understood OracleSOA Suite 12ctechnology and application adapters(Business Events, XML Gateway, and APIs), SMTP, and FTP Adapter, Database Adapter, EBS Adapter for integration and development of custom business processes using ESB/Orchestrator.

Environment: Scrum, Oracle Procurement cloud r12, Demantra applications, Oracle SOA Suite 12c, Joomla 3.8 content management, Oracle WebCenter Portal, Tableau 10.4, Oracle 12g, SQL Server 2008, Star/Snow Flake dimensional designing, JIRA, UML, MS Visio, MS Project, PowerPoint and Excel, HP Quality Center 11.5.

Sr. Business System Analyst

Confidential, Seattle, WA

Responsibilities:

• Project Scoping, Effort Estimation, Requirements Gathering, Design, Testing, and Support.
• Analyzed Business Process documented and captured the End-to-End flow of Transactional Systems.
• Learnt and Understood Oracle SOA Suite 11g technology and application adapters (Business Events, XML Gateway, and APIs), SMTP, and FTP Adapter, Database Adapter, EBS Adapter for integration and development of custom business processes using ESB/Orchestrator.
• Assisted in Management and Governance of master data ensure integrity of the Transactional software.
• Designed system interface using Visio to support integration between MDM, Tibco, & Oracle ESB.
• Conducted multiple JAD sessions with Business Owners from different domains (Marketing, Sales, and Operation) to identify Business Rules, Functional and Non-Functional Requirement for the system.
• Involved in Prioritizing & Estimation of User Stories, creating and finishing the sprint using JIRA.
• Responsible for Sprint Planning, Daily Stand Up, Retrospectives, Time-boxing, Backlog Grooming, Sprint Demos and generation and updating all Information Radiators of the project.
• Accountable for Development and testing activity to ensure development work meets the required Quality Standard and Aligned with the approved Statement of Work (SOW).
• Collaborate with System and Business owner to identify Events, Correlation, and Pattern-Matching.
• Implement Standardized Data Quality Processes including Data Profiling and Cleansing.
• Prepared Test Data and preformed Positive and Negative Testing used in Data Driven Testing.
• Demonstrated ability in utilizing Postman and SoapUI for testing web services (SOAP & REST API).
• Used RALLY Software Extensively in Agile Business Model with 2-Week Sprints and Coordinate with Offshore teams for Time Bound deliverables.

Environment: Oracle SOA 11g, Oracle 12c, Oracle R12, J2EE, AJAX, Tibco, Informatica, HTML, XML, SoapUI, Rally.

Business System Analyst

Confidential, Framingham, MA

Responsibilities:

• Participating in Global SAP Business Blueprinting- Creating Process Definition Document, User Requirements Specifications, Key Design Decision Description and GAP Analysis and Testing Strategy documents.
• Analyzing customer ‘AS IS’ business process and mapping ‘TO BE’ business processes.
• Prepared Business Requirement Document (BRD) from the elucidated requirements and helped the Product Owner and Development Team in making User Stories by using Three C’s and make stories to meet INVEST criteria.
• SAP Configuration of MM-IM requirements, including Plants, Storage Locations, MRP and Forecasting data. As well, the Purchasing requirements for internal sources (Stock Transfer Orders), including Purchasing Groups. Developed mock-ups and wireframes along with the screen designs to make better UI designs.
• Helped the team to split user stories into tasks meeting the SMART criteria. Values of collaboration and agile principles and explained the team how important was to operate as a self-organizing entity.
• Gathering MM, TM, FM and WM business process procedures (BPP) documentation for preparing Test Plan.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schemas like snowflake schema and galaxy schema to help development of an accurate Data Warehouse Structure.
• Assisted core team members for designing and configuration of SAP MM, WM, and SRM modules- Warehouse goods receipts and issues, cycle counting process, warehouse replenishment, WM interface to QM and configuration of master data including material master, and bins/warehouses/storage locations.
• Guided large development teams, including Backlog Refinement, Sprint Planning, Daily Stand Up, Retrospectives, Management Reporting, and presentation of Sprint results to the Client
• Actively involved in the Testing functionality of Purchase Requisitions, Shopping Carts and Purchase Orders in DEV/ QA instances before Migrating to UAT and PROD Instances.
• Working with Integration Testing Lead to developing Testing scenarios; String testing, Integration Cycle Testing and Interface Testing for Make to Deploy (QM/PP), Procure to Pay (MM/SRM), Plan to Schedule, Order to Cash (SD), Hire to Retire (HR), Record to Report (FI) and Lead to Customer (CRM) business processes (BPs).
• Used Postman to Test and Document SOAP & RESTful using GET/POST/UPDATE/DELETE methods.
• Involved in providing Production Support, User Training, and problem resolution in almost all areas of SD, MM, PP, ME, FICO Modules and Cross-Functional Applications.

Environment: Scrum Hybrid, ASAP Methodology, SAP systems, SD, MM, PP, ME, FICO, components and tools: SAP ERP R/3, ERP2005 / ECC6.0, SAP Solution Manager, HP Quality Centre, Quick Test Pro, IBM Rational Functional Tester, Load Runner, Jira, Database SQL testing

Business System Analyst

Confidential, Pennington, NJ

Responsibilities:

• Interviewed Regional Plant, Banking, Supply Chain, and Finance Managers to gather System Requirements
• Assisted in Project Planning & implementation and integration Road-Maps, for bringing productive results. Completed all necessary documentation including Project Charters, Project Management Plans, Communication Management Plan, Project Cost Plan, Requirements Matrix, Project Staffing Plans and Project Budget Plans.
• Created Mock-up Screens, Wireframes using UI Components (check box etc.) and demonstrated it to stakeholders.
• Developed Business Requirement Documents, functional requirements specifications, use cases, storyboards.
• Extensively used MS Visio for Process modeling, Process mapping and Process flow diagrams creations.
• Constructed Requirements traceability matrix (RTM) to determine the source of the requirement, to ensure all requirements are met and to locate affected system components when there is a requirement change.
• Implement Standardized Data Quality Processes including Data Profiling and Cleansing on legacy database system
• Accountable for Development and Testing activity to ensure development work meets the required Quality Standard and aligned with the approved Statement of Work (SOW) .
• Collaborate with System and Business owner to identify Events, Correlation, and Pattern-Matching.
• PreparedTestData and preformed Positive and Negative Testing used in Data Driven Testing.
• Demonstrated ability in utilizingPostmanand SoapUI for testing web services (SOAP & REST API).
• Documented the REST API and SOAP API requests and responses in XML format and their respective performance
• Used RALLY Software Extensively in Agile Business Model with 2-Week Sprints and Coordinate with Offshore teams for Time Bound deliverables.

Environment: Scrum-Hybrid, SAP FICO, SAP, SAP PI, Web Services, SOA, API, REST, EDI, JSON, HTML, Swagger, XML, SQL, JavaScript, Jenkins, MS Visio, Tableau, Postman, LoadRunner.

Business Analyst/ Java Developer

Confidential

Responsibilities:

• Involved in System Requirements analysis and conceptual design.
• Experience in using VSS as source control & developed the application’s UI using Spring, Html and JavaScript, CSS.
• Experience in using JSON, JavaScript functions to get dynamic data and client-side validation.
• Experience in design and Implemented document transformation applications using XML Spy tool and XSD's.
• Experience in developing JDBC to interact with the database. Involved in developing applications for workflow using JSP's, spring MVC module, Hibernate, AJAX, JavaScript technologies using Apache Tomcat and integrated it with the actual system to improve the quality.
• Experience in initiating with 'Workflow module' of the Project which intended to automate the workflow related functions of any organization. Created and maintained documentation for supported applications.
• Coordinates with customers to resolve technical support issues. Reporting of status to project management.

Environment: Java, Servlets, JSP, JSTL, Spring, Ajax, Hibernate, Java JDK 1.6, Apache Tomcat 6.0, MySQL Query Browser, Windows XP Professional.

Jr. Java Developer

Confidential

Responsibilities:

• Involved in designing & implementing the User Interface for the General Info pages & Administrator functionality.
• Developed internal administration interface. Designed front end using JSP and business logic in Servlets.
• Used Spring Framework for the application on the MVC-II Architecture and implemented validator Framework.
• Mapping of the servlet in the Deployment Descriptor (XML). Performed unit tests and integration tests.
• Used HTML, JSP, JSP Tag Libraries, and Spring Tiles develop presentation tier. Deployed application on JBoss Application Server and also configured database connection pooling.
• Involved in writing JavaScript functions for front-end validations. Used CVS as a documentation repository and as version controlling tool.

Environment: Java, J2EE, JDBC, Servlets, EJB, JSP, Spring, HTML, CSS, Java Script, UML, JBoss Application Server 4.2, MySQL, Linux and CVS.