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 with proven ability to articulate business values.
• Experience working in all phases of SDLC from analysis, design, development and testing along with in depth understanding of teh 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 teh team's statistics.
• Experienced in working with product backlogs, sprint backlogs along with 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 teh 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 with 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 with a plethora of BI reporting tools like Power BI, Tableau, Microstrategy and Cognos for teh visualization of data reports generated using SSRS.
• Proficient in using databases & SQL queries and Used Tableau extensively for reporting and data analysis.
• Good noledge and extensively used RDBMS, Oracle, SQL, and PL/SQL along with 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 with 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 with Microsoft SharePoint to manage project related documents.
• Personal skills include Excellent Communication, strong sense of Organization, TEMPEffective Time Management and has teh 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, Teh Woodlands, TX

Senior Business Analyst/Business Process Analyst

Responsibilities:

• Facilitated teh Meetings with SMEs and Business user to gather teh requirements.
• Closely coordinated with teh PMO team to create milestones and timelines for deliverables on a weekly basis and detect and report Risks and Issues.
• Managed teh Project plan and actively engage and collaborate with 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 with teh users, stakeholders, document analysis, user interviews, and documented those requirements in teh BRD.
• JAD sessions with Product Owner and Project Manager in gathering and analyzing teh 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 teh technical system owners.
• Wrote teh business requirements in Jira Agile Epics and user stories format and uploaded and assigned teh user stories in Jira for both Agile (sprints) methodology.
• Created teh list of backlog items and prioritized teh product backlog in Jira during teh 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 teh web-based UI using JavaScript, HTML and DHTML.
• Client Side validations were done using JavaScript.
• Tested and recorded UI interactions and API interactions between teh application and teh 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 teh weekly projects-status meetings to provide feedback and stay updated with other projects.
• Designed and developed Use cases, Activity diagrams, Process flow diagrams, UML diagram using MS VISIO.
• Extensively used SQL statements to query teh 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 with teh Data analyst in defining data sources and required data content for teh 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 with business user and stake holders and performed UAT.
• Worked with teh customer to identify teh checklist for UAT Testing.
• Tracked bugs and prepared teh bug reports using teh Azure Devops and interacted with teh developer team to discuss technical issues.
• Assisted in preparing UAT plan/scripts and assured project manager has taken steps for alignment of Operational Quality Checklist.
• Worked with teh clients on teh final signing process in teh User Acceptance stages.
• Developed recommendations and designed solutions for process improvements.

Confidential, Union, NJ

Senior Business Analyst/ Business Process Analyst

Responsibilities:

• Interacted with teh 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 teh 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 within teh specified time frame.
• Worked on Agile, Scrum methodology to ensure delivery of high-quality work with monthly iteration.
• Facilitated Sprint Planning, Backlog Grooming and Retrospective meetings.
• Update Jira (agile tracking) system to ensure transparency.
• Utilized JIRA to manage teh project's user stories, Rally to manage teh Project Task.
• Conducted Joint Application Development (JAD) sessions to expedite and streamline teh requirement gathering process.
• Engaged with 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 teh new upgrades seamlessly using MS Visio, Lucidcharts, JIRA and WebEx.
• Conducted multiple elicitations with end-users and team members to further enhance accuracy in formulating, writing and editing Functional requirements in teh 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 teh requirements and business needs.
• Performing usability testing and organizing focus groups to discuss and ensure TEMPeffective adoption of feedback to improve teh usability of teh 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 teh Complex SQL queries with Joins, Stored procedure, Views, Trigger to implementing teh 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) with teh QA team.
• Executed test cases and reported any bugs.
• Involved with writing teh test cases, updating teh test cases, executing test cases and Logging Defects in HP ALM/QC.
• Reviewed progress and completion reports, which were tan submitted to project management on a weekly basis.

Confidential - Evansville, IN

Senior Business Process Analyst/Business System Analyst

Responsibilities:

• Established TEMPeffective communication channels with stakeholders and met quality assurance objectives, budget goals and demanding deadlines. Translated technical terms into user-friendly language.
• Involved and worked with Project Manager in planning, scheduling, and controlling projects based on schedules and requirements outlined by thebusiness.
• Worked with teh 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 with 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 with 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 teh 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 teh Azure DevOps practice, to cross functionally apply across projects.
• Assisted in development of java webservices to be implemented in teh application.
• Involved in website design usingJavatechnology,HTMLandCSS.
• Assisted teh Development team to create API rules for teh application.
• Established internal "Wiki" style website for department resources; coding in HTML and JavaScript.
• Created user flow diagrams, wire frames for developing teh prototype of Web and mobile phone application.
• Involved in testing application on different mobile Platform such as iOS and Android devices.
• Prepared scope of teh project and developed new business process along with process mapping and user task analysis. me also evaluated documentation analysis and business process analysis to identify teh problem with existing system and find out new and advance way to develop business process, which was able to make teh process more accurate.
• Prepared Business Context Diagram,Use Case diagramsand corresponding Activity Diagrams using MS Visio to depict teh workflows to be incorporated into teh 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 teh GAP analysis to find teh Root Cause of teh issues.
• Analyzed “AS IS” and “TO BE” scenarios, designed new process flows and documented teh business process and various business scenarios.
• TEMPEffectively managed geospatial data collection, processing and maintenance functions utilizing resource/mapping and survey grade GIS solutions.
• Analyzed products using ESRI software tools in combination with other finishing software applications.
• Supported and Analyzed teh Application integration within teh organization such as GIS, ESRI to meet teh 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 teh data in Tableau and performed adhoc data analysis to create reports in tableau.
• Used SQL Queries in Oracle to pull out data from teh databases for teh 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 teh UAT issues and assign teh task to developers for fixing teh 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 teh SIT (System Integration Testing), Defect tracking & closure.
• Responsible for conducting ALM/QC (Quality Center) training sessions for teh Business Users. To give them a walk through over teh 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 teh 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 teh essentialbusinesselements and detailed definitions.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stores workshop.
• Practiced in full facingAGILEmethodology with SCRUM Meeting,SprintPlanning Meeting,SprintReview Meeting, and Retrospective Meeting etc.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified teh Key Changes and participated in Stakeholder Management to communicate TEMPeffectively with them.
• Co-authoredbusinessrequirements document with 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 with 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 teh Change Management, Problem Management and other relevant teams to discuss teh impact of teh 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 with 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 teh existing data warehouse and changed teh 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 teh backend databases for producing mapping documentation and transformation rules for developers.
• Helped with Data Mapping between teh data mart and teh 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 with SQLto create Tables, Views, and triggers and stored Procedures.
• Involved in writing and implementation of teh 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.