SUMMARY

• Over 8+ years of extensive experience as Business Process Analyst/Business System Analyst in Utility / Energy, Oil, Gas, Retail and Banking Industry.
• Experience in Software Validation and business process re - engineering wif proven ability to articulate business values.
• Experience working in all phases of SDLC from analysis, design, development and testing along wif in depth understanding of the Waterfall, Agile and Rational unified process methodologies.
• Assisted Project Manager in Budgeting, Planning, managing teams, creating and assigning tasks, monitoring and controlling multiple projects, scheduling and coordinating project tasks, project timelines, and maintaining project documentation and issue logs.
• Adept at facilitating Scrum Processes and conducting ceremonies (Backlog Grooming, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective).
• Proficiency in using issue tracking and agile management tools such as JIRA, VersionOne and Rally (CA Agile Central) to document user stories, conduct sprint planning, track sprint progress and monitor the team's statistics.
• Experienced in working wif product backlogs, sprint backlogs along wif creating user stories and prioritizing user stories and keeping track of burn down charts.
• Strong Analysis skills in Project Definition Document (PDD) and Requests for Proposal (RFP).
• Highly experienced in capturing requirements through interviews, workshops, JAD sessions, GAP analysis and existing systems documentation thus formulating the business requirements document.
• Expert in Root Cause Analysis, Feasibility studies and Risk Assessment studies.
• Strong writing skills in preparing Business Requirement Documents (BRD), System Requirement Specifications (SRS), Software Requirement Specifications (SRS), Use Case Specifications, Functional Specifications (FSD), Requirement Traceability Matrix (RTM) and Technical Design Document (TDD).
• Expertise on Business Process Mapping, UML forBusiness Process Modeling, Wireframes, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams and document them using Microsoft Visio. Experience wif Business Process Management.
• Proficient in Requirement management tools such as JIRA, HPALM, TFS, Azure Devops, RALLY and experience in creating UI Mock-up screens, Wireframes and prototypes by using AXURE RP and Balsamic tools.
• Extensive experience in working wif a plethora of BI reporting tools like Power BI, Tableau, Microstrategy and Cognos for the visualization of data reports generated using SSRS.
• Proficient in using databases & SQL queries and Used Tableau extensively for reporting and data analysis.
• Good knowledge and extensively used RDBMS, Oracle, SQL, and PL/SQL along wif MS SQL administration, SQL Enterprise Manager, Data analysis and reporting.
• Performed planning and development of Test Plans, Test Strategies, Test Scripts and executing tests to meet product’s business requirement.
• Proficient in bug tracking/test management tools like ALM/Quality Center, Azure Devops, TFS, Clear Quest, JIRA and Confluence.
• Experience working in mobile application development along wif API front/backend testing.
• Expertise in conducting backend Tests and Manual Tests.
• Experience in Preparation and Execution of appropriate business test scenarios based on Functional & Technical Requirements.
• Experience in providing UAT and postproduction support for web-service applications.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Experience wif Microsoft SharePoint to manage project related documents.
• Personal skills include Excellent Communication, strong sense of Organization, Effective Time Management and have the ability to work in a team as well as independently.

TECHNICAL SKILLS

Project Methodologies: Rational Unified Process (RUP), Waterfall, Agile, Spiral, Scrum

Business Modeling Tools: Rational Rose, MS Visio, Axure

Requirement Management Tools: Rational Rose, Requisite Pro, Clear Quest, Clear Case, Serena Team Track and MS Visio, MS Project, JIRA, Azure DevOps

Project Management Tools: MS Project

Defect Tracking Tools: Rational Clear Quest, Quick Test Professional, Quality Center, Jira

Databases: Oracle, MS SQL Server, IBM DB2

Languages: Visual Basic, Java, XML, SQL, .NET

Front - End Tools: MS Office Suite (Word, Access, Excel, Outlook, PowerPoint, SharePoint)

Version Control Systems: Rational Clear Case

Operating System: Windows, MAC OS, UNIX/Linux

ETL/BI Tools: Informatica Power Center, SSIS, Power BI, COGNOS, Query studio, Report studio, Tableau, Alteryx, SSRS, SAS, Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, The Woodlands, TX

Senior Business Analyst/Business Process Analyst

Responsibilities:

• Facilitated the Meetings wif SMEs and Business user to gather the requirements.
• Closely coordinated wif the PMO team to create milestones and timelines for deliverables on a weekly basis and detect and report Risks and Issues.
• Managed the Project plan and actively engage and collaborate wif Development Lead, QA Lead and other stakeholders.
• Developed and monitored project schedules using Microsoft Project.
• Worked on and attended all PMO projects meetings to create various presentations using power point and Microsoft office.
• Performed requirement analysis by gathering both functional and nonfunctional requirements based on interactions wif the users, stakeholders, document analysis, user interviews, and documented those requirements in the BRD.
• JAD sessions wif Product Owner and Project Manager in gathering and analyzing the requirements.
• Participated in and lead SCRUM ceremonies: Release Planning, Sprint Planning, Daily Standup, Backlog Refinement, Scrum of Scrums, Sprint Review/Demos, and Retrospectives.
• Prepared Business Requirement document to detail how Azure DevOps items maps to project Plan items for the technical system owners.
• Wrote the business requirements in Jira Agile Epics and user stories format and uploaded and assigned the user stories in Jira for both Agile (sprints) methodology.
• Created the list of backlog items and prioritized the product backlog in Jira during the sprint planning meetings.
• SharePoint was used to maintain project documents such as project plans, project scope, and status reports and to assign tasks.
• Produced Business Requirements Document (BRD), Functional Requirements Documents (FRD), Impact Analysis Document and Requirements Traceability Matrix (RTM).
• Performed business process re-engineering and business modelling.
• Performed Business Process modeling (BPM) by using UML Activity diagramming and BPMN notation.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Involved in Design and development of the web-based UI using JavaScript, HTML and DHTML.
• Client Side validations were done using JavaScript.
• Tested and recorded UI interactions and API interactions between the application and the database.
• Involved inAPIdocumentation forREST/SOAP using Swagger tools and documented XML request and responses.
• Worked extensively on performing 'AS IS' and 'To BE' Process analysis, GAP analysis and drafted Project Analysis documentations.
• Participated in the weekly projects-status meetings to provide feedback and stay updated wif other projects.
• Designed and developed Use cases, Activity diagrams, Process flow diagrams, UML diagram using MS VISIO.
• Extensively used SQL statements to query the Oracle Database for data modeling, data migration, data analysis, data Validation and data Integrity.
• Extensively wrote standard and complex SQL queries to perform data validation to make sure test results matched.
• Participated in Data Analysis and Design wif the Data analyst in defining data sources and required data content for the data warehouse component.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Provide quick reports in excel using pivot tables and vlookups.
• Involved wif business user and stake holders and performed UAT.
• Worked wif the customer to identify the checklist for UAT Testing.
• Tracked bugs and prepared the bug reports using the Azure Devops and interacted wif the developer team to discuss technical issues.
• Assisted in preparing UAT plan/scripts and assured project manager TEMPhas taken steps for alignment of Operational Quality Checklist.
• Worked wif the clients on the final signing process in the User Acceptance stages.
• Developed recommendations and designed solutions for process improvements.

Confidential, Union, NJ

Senior Business Analyst/ Business Process Analyst

Responsibilities:

• Interacted wif the users and used various elicitation techniques like interviewing them, and also by preparing questionnaires and Interviewed clients and application owners from different business lines to gather information, define system scope and objectives, understand the users’ needs, define business and technical requirements, and develop specifications.
• Agile SDLC methodology was used in this project as Sprint Reviews, start-up meetings and backlog grooming was conducted wifin the specified time frame.
• Worked on Agile, Scrum methodology to ensure delivery of high-quality work wif monthly iteration.
• Facilitated Sprint Planning, Backlog Grooming and Retrospective meetings.
• Update Jira (agile tracking) system to ensure transparency.
• Utilized JIRA to manage the project's user stories, Rally to manage the Project Task.
• Conducted Joint Application Development (JAD) sessions to expedite and streamline the requirement gathering process.
• Engaged wif Tech leads/Specific team members, using requirement gathering techniques/methods like Brainstorming, Document Analysis, Focus Group, Interface Analysis, Interview, Shadowing/Observation, Prototyping, Requirements Workshop and Reverse Engineering to define, plan, coordinate and obtain accurate requirements - both Functional and non-functional, to support and integrate the new upgrades seamlessly using MS Visio, Lucidcharts, JIRA and WebEx.
• Conducted multiple elicitations wif end-users and team members to further enhance accuracy in formulating, writing and editing Functional requirements in the FRD, using Skype Business and WebEx.
• Prepared Business Process Models (BPM) and UML diagrams like workflow diagrams, activity diagrams, sequence diagrams, use case diagrams, by using MS Visio, for visual representation to explain various steps involved in business.
• Ensured final UI/UX met the requirements and business needs.
• Performing usability testing and organizing focus groups to discuss and ensure effective adoption of feedback to improve the usability of the mobile applications and web based applications.
• Implemented of an Ecommerce product, Commerce Catalog Organization, Navigation & Search, Pricing & Promotions, Shopping Cart, Purchase Process and Order Processing etc., Merchandizing UI, Fulfilment / Payment Engines etc.
• Worked on creative Assets, Point of Sale (POS) Systems, Ecommerce and Supply chain systems.
• Extensively worked on manufacturing system and Supply Chain Management modules including OM, Shipping and Execution, Pricing and Inventory.
• Elicited business requirements for front end POS and EMV chip enabled cards through personal SME interviews, focus group interviews, workshop and Joint Application Design (JAD) Session.
• Used proper documentation techniques for GAP analysis, Impact Analysis, Process flow diagrams, Activity diagrams, Use cases, UAT test Scenarios, etc. and upload to JIRA.
• Used SQL queries to retrieve data from tables.
• Based on business requirement, developed the Complex SQL queries wif Joins, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Wrote SQL Queries for data analysis and manipulation.
• Manually performed Backend Testing using SQL Queries to test Oracle Database.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to manipulate and validate data.
• Conducted User Acceptance Testing (UAT) wif the QA team.
• Executed test cases and reported any bugs.
• Involved wif writing the test cases, updating the test cases, executing test cases and Logging Defects in HP ALM/QC.
• Reviewed progress and completion reports, which were then submitted to project management on a weekly basis.

Confidential - Evansville, IN

Senior Business Process Analyst/Business System Analyst

Responsibilities:

• Established effective communication channels wif stakeholders and met quality assurance objectives, budget goals and demanding deadlines. Translated technical terms into user-friendly language.
• Involved and worked wif Project Manager in planning, scheduling, and controlling projects based on schedules and requirements outlined by thebusiness.
• Worked wif the PMO team on several project initiatives by tracking and analyzing project actual work effort on a weekly basis, including timesheet creation, timesheet completion compliance, and timesheet approval compliance, if applicable. Also, maintains project resource calendar, including internal and external resources.
• Project Management - Project Managed from inception to implementation through Product Launch.
• Used MS Project to manage schedules, meet deadlines and plan resources. Followed up wif weekly Project Status and organized Task Review meetings.
• Obtained, updated, and maintained functional and nonfunctional requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, and Business Process flow development.
• Arranged JAD sessions for business and IT requirements wif business and SMEs to understand various in house system and develop strategies for system integration.
• Developed and implemented business specifications and solutions for large, complex integrations.
• Facilitated Agile ceremonies, sprint planning meeting, scrum daily meeting, review and retrospective meetings and ensure the project is on track.
• Defined epic, features, product backlog and tasks on Azure DevOps following agile principals.
• Used Azure Devops to maintain product backlog and sprint backlog and to create and track user stories, Sprint planning, tracking and managing sprints, created status reports and burn down charts.
• Participated in streamlining the Azure DevOps practice, to cross functionally apply across projects.
• Assisted in development of java webservices to be implemented in the application.
• Involved in website design usingJavatechnology,HTMLandCSS.
• Assisted the Development team to create API rules for the application.
• Established internal "Wiki" style website for department resources; coding in HTML and JavaScript.
• Created user flow diagrams, wire frames for developing the prototype of Web and mobile phone application.
• Involved in testing application on different mobile Platform such as iOS and Android devices.
• Prepared scope of the project and developed new business process along wif process mapping and user task analysis. I also evaluated documentation analysis and business process analysis to identify the problem wif existing system and find out new and advance way to develop business process, which was able to make the process more accurate.
• Prepared Business Context Diagram,Use Case diagramsand corresponding Activity Diagrams using MS Visio to depict the workflows to be incorporated into the development ofBusiness Process Management (BPM).
• Analyzed and redesigned workflows in order to optimize end to end process by using BPR (Business Process Reengineering).
• Participated in identifying opportunities and parameters forBusiness process improvements.
• Performed the GAP analysis to find the Root Cause of the issues.
• Analyzed “AS IS” and “TO BE” scenarios, designed new process flows and documented the business process and various business scenarios.
• Effectively managed geospatial data collection, processing and maintenance functions utilizing resource/mapping and survey grade GIS solutions.
• Analyzed products using ESRI software tools in combination wif other finishing software applications.
• Supported and Analyzed the Application integration wifin the organization such as GIS, ESRI to meet the Business Requirements and Business needs.
• Directed all phases of technical projects from proposal preparation to final implementation of GIS applications and data base enhancements.
• Managed multiple phases of a major gas transmission companies GIS, including new construction projects, processing as-built work orders.
• Utilized GIS to locate addresses, latitude/longitude coordinates, and Town or Territory Codes for premise and billing information.
• Worked in utilitybusinessprocesses and operations, systems, such as Customer Contact,Meter-to-Cash, Usage & Billing, Payment, etc.
• Validated Invoicing reports for data such as Amount Paid, Handling Cost, Billing Account, Billing Schedule, Currency etc.
• Extensively used SQL queries using query Analyzer for data analytics, data mapping, verification and validation.
• Developed user interactive sheets and reports as business needs and for writing SQL scripts to load the data in Tableau and performed adhoc data analysis to create reports in tableau.
• Used SQL Queries in Oracle to pull out data from the databases for the data validation and routine report generation.
• Extensively worked on SQL queries and on data transformation and data mapping from source to target database schema.
• Monitored, tracked and analyzed the UAT issues and assign the task to developers for fixing the issues.
• Resolve geological and geophysical related issues by evaluating all dependent data sources.
• Installation, Configuration, Upgrade, patching of OracleRDBMSin development, test and production environments.
• Responsible for planning the SIT (System Integration Testing), Defect tracking & closure.
• Responsible for conducting ALM/QC (Quality Center) training sessions for the Business Users. To give them a walk through over the tool. And to show them how to write test case, logging defects etc.
• Managed and tracked Defects using ALM/Quality Center.
• Responsible for planning, conducting and coordinating the User Acceptance Testing (UAT).

Confidential, Bentonville, AR

Business System Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models dat containBusinessRequirement Documents and supporting documents dat contain the essentialbusinesselements and detailed definitions.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stores workshop.
• Practiced in full facingAGILEmethodology wif SCRUM Meeting,SprintPlanning Meeting,SprintReview Meeting, and Retrospective Meeting etc.
• Conducted Joint Application Development (JAD) sessions wif IT groups. Identified the Key Changes and participated in Stakeholder Management to communicate effectively wif them.
• Co-authoredbusinessrequirements document wif project teams. Extracted, discussed, and refinedbusinessrequirements frombusinessusers and team members.
• Created relationships in Requirement Traceability Matrix linkingBusinessRequirements to Functional requirements and Functional Requirements to Systems Requirements.
• AnalyzedBusinessRequirements and segregated them into high level and low-level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining theBusinessProcess Models (BPM).
• Used MS Visio for Process modelling, Process mapping andBusinessProcess flow diagrams.
• Worked wif UI/UX team and designed Wireframes for User Interface (UI) components for individual features, Screen mockups using Balsamiq.
• Developed GUI screens using CSS.
• Facilitated meetings among the Change Management, Problem Management and other relevant teams to discuss the impact of the changes, problem tickets and prepare project milestone plans.
• Created and maintained product requirement documents and use flow diagrams for modules like IMS (Inventory Management Systems), WMS (Warehouse Management Systems) and SMS (Supply Chain Management).
• Partnered wif ecommerce teams to perform and recommend improvements tosite performanceand prepare various ad hoc reports for multiple brands and analyze performance.
• Prepared documents for all ecommerce business procedure and analyzed all site traffic to recommend efficient marketing plans and administer all email programs and search marketing activities.
• Created SQL queries using SQL Server tools to produce Ad-Hoc reports for data quality validation.
• Designed source to target documentation, metadata documentation and data flow model.
• Performed data analysis for the existing data warehouse and changed the internal schema for performance.
• Used MS Visio for Process modeling, Process mapping andBusinessProcess flow diagrams.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Conducted Data analysis using SQL on the backend databases for producing mapping documentation and transformation rules for developers.
• Helped wif Data Mapping between the data mart and the Source Systems.
• Designed and implemented SQL queries for QA Testing and Report / Data Validation.
• Created SQL queries using SQL Server tools to produce Ad-Hoc reports for data quality validation.
• Worked wif SQLto create Tables, Views, and triggers and stored Procedures.
• Involved in writing and implementation of the test plan, and various test cases for UAT.
• Defect Tracking and Bug Reporting was performed using Quality Center.
• Developed Test Matrix to give a better view of testing effort.