SUMMARY

• IT professional with a global experience in techno - functional roles across various domains such as Energy and Utilities, Oil & Gas, Manufacturing & Chemical, with proven ability leading cross-functional and self-organizing teams in various capacities as a Sr. Business Systems Analyst, Scrum Master and Application Developer
• Extensive knowledge of different phases of various Software Development Life Cycles (SDLCs), namely, Traditional Waterfall, Spiral, and Agile Methodologies - Extreme Programming (XP), SCRUM, KANBAN and Scaled Agile Framework (SAFe 3.0) along with Hybrid models such as Waterfall-Scrum
• Experience in eliciting Business Requirements with various techniques, Joint Application Development (JAD), Interviews, Focus Groups, Document Analysis, Job Shadowing, GAP Analysis, and Survey/Questionnaire
• Proficient in preparing wide range of documents including, High Level and Low Level documents (HLD/LLD), such as Business requirements document (BRD), Systems Requirements Specification (SRS), Use case Specification, Configuration document, and RACI matrix (Responsible, Accountable, Consulted and Informed)
• Collaborated on creating Work Breakdown Structure (WBS) using MS Project, tracking schedules and milestones
• Significant experience gained by extensive client interactions in highly cohesive and loosely coupled Service Oriented Architecture (SOA) and 3-tier architecture with strong and in-depth understanding of XML, Web Services, ERP, CRM (Salesforce, Oracle Siebel), CIS, WMS, GIS and SQL across heterogeneous IT environments
• Knowledge of group of inter related web development technologies like HTML, CSS, JavaScript, AJAX, JSON, JBoss and JDBC. Possess good knowledge of validation scripting like JavaScript, JQuery, and Angular JS
• Scripted business logic in the web methods of Web Services and documenting the Web Service Level Agreement (WSLA) document through the use XML. Knowledgeable about different web servers such as Microsoft IIS, and Apache Tomcat. Wrote business logic rules in the Code-Behind pages to perform client and server-side validation
• Extremely skilled as Scrum Master in facilitating scrum events (Backlog grooming, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective) to improve team’s performance and handling team dynamics
• Strategic handling of Requirements Churn in Scrum efficiently by using Prioritizing and Estimating techniques like Planning poker, T-shirt sizing, Relative Mass Valuation, MoSCoW, Walking Skeletal, Validated Learning
• Assisted project manager and product owner to track and improve efficiency and Team Velocity using Burn-Down Charts, Work Breakdown Structure, Process Management Plans, Milestones List and Gantt chart
• Well acquainted with workflows and Unified Modeling Language (UML) diagrams including Use Cases, Activity Charts, Class Diagrams, Sequence Diagrams, Data Flow Diagrams, Data Mapping and ER Diagrams
• Adept at supervising Black-box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, Security Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing
• Strong knowledge of implementing Databases, Data Table Structures, Data marts, Data Analysis, Data Integration, Schemas and OLAP operations viz. Slice, Dice, Pivot, Roll-up and Drill-down
• Skillful at designing and implementing SQL queries using joins (inner joins, outer joins), unions, select within select, order by, group by and aggregate functions to extract data from different data sources
• Acquainted with Relational Database Management systems (RDBMS), programmed SQL Queries, Functions, business logic Stored Procedures and exposure to various databases such as Oracle and Microsoft SQL Server
• Expertize in business process design and workflows using BPM tools such as IBM Blue Works and PEGA
• Thorough understanding of Business Intelligence (BI) and experience in creating interactive, analytical dashboards using Tableau and IBM Cognos for decision making. Reported KPIs using Spotfire and Qlikview
• Ability to work independently and in teams to meet business deliverables with a result-oriented approach
• Excellent communication skills, fast learner along with an ability to adapt quickly to any domain and environment
• Self-motivated, Dependable, Organized, Competent Leadership and Time-management skills

TECHNICAL SKILLS

SDLC Methodologies: Traditional - Waterfall, Agile - SCRUM, Kanban, Scaled Agile (SAFe 3.0)Hybrid - Scrum-Waterfall

Business Skills: Change Management, Problem & Incident Management, Impact Analysis, JAD Sessions, SWOT Analysis, Project Planning, Project Scheduling, Project Budgeting, Risk Management, Conflict Management, Excellent Communication, Competent leadership & managerial skills, Goal & Time oriented, Great Business Acumen

Business Intelligence tools: Tableau, IBM Cognos, MS Excel 2007/10/13

Business Modeling tools: MS Visio, Mockup Screens, Balsamiq, IBM BPM (Blue Works)

Project management tools: MS Project, MS SharePoint 2007/10/13, HP-PPM 9.2

Requirement management tools: JIRA6.3, MS Office, HP ALM 11.5, Version One, Rational Clear Quest, Rally

Reporting tools: Tableau Desktop, IBM Cognos, MS Office Suite, TIBCO Spotfire, Qlikview

Architecture/Framework: Service Oriented Architecture (SOA), 3-Tier Architecture, N Tier ArchitectureCloud Platform (SaaS & IaaS), Apache Web Server

Testing tools: JIRA 6.3, HP-QC 9.2, HP ALM 11.5, Rational Clear Quest, Load Runner 12.02

Databases: MS SQL Server, Oracle 10g/11g, IBM DB2, MS Access

Data warehousing: Data Marts, Data Modeling, OLAP, OLTP, Data Mining, ETL, Slicing/Dicing, Drill Down/ Roll up, Pivot, Star and Snowflake Schema, Altova Map Force

Languages: HTML-5, CSS-3, XML, C/C++, PL/SQL, ASP, Java/J2EE, JavaScript, JSON, SOAP, RESTful, Matlab

Operating Systems: Windows XP/Vista/8/10, Red Hat Enterprise Linux (RHEL), Unix, Ubuntu

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Systems Analyst / Scrum Master

Responsibilities:

• Assisted in transition from traditional waterfall to Agile methodology by conducting Agile Workshops to educate everyone about Agile Principles and Manifestos, Velocity, Product Backlog, Technical Debt, Sprint Planning, daily Stand-ups, Sprint Review, Backlog Refinement, Sprint Retrospectives and so forth
• Identified and analyzed needs for various functionalities of the portal by using various techniques such as JAD, Document Analysis, SWOT Analysis, Requirements Workshops, and Interviews with Subject Matter Experts (SMEs) and project stakeholders
• Prioritized the development of missing tools and content in the existing framework by performing the GAP Analysis. Documented the gap between the existing system and desired system
• Developed a high level Business Requirements Document (BRD) and Functional Requirements Specification (FSD) document and had them base-lined from the business owner
• Wrote correspondence, reports, implementation requirements, project status reports, oral presentations and email, to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts. Also, analyzed the ROI to measure the efficiency and recommended cost cutting techniques
• Worked extensively with GUI development team to create the initial UI wireframes, and mockups using Adobe Dreamweaver. Developed Mockup screens for the learner’s home page requirements document
• Constructed Requirements traceability matrix to determine the source of the requirement, to ensure all requirements are met and to locate affected system components when there is a requirements change. Maintained the traceability matrix until business requirements were signed off
• Created project plans, work breakdown structures (WBS) and identified & managed risks using MS Project
• Prepared UMLDiagrams, Process Flow Diagrams, Business Process and Data Process Model using MS Visio
• Assisted Lead Architect in creating Dimensional Model to ensure that the historical data is properly stored in the dedicated data marts, and the requirements are properly captured by the data marts
• Coordinated with the other business analysts and assisted in Data modeling, Data mapping and Data extraction & Integration in the data mart by using the Informatica Power center from the legacy systems
• Used Tableau to model, implement, execute, monitor and optimize processes by using Business Process Re-engineering (BPR) concepts
• Analyzed Business Requirements from Black Box testing perspective. Reviewed Test Strategy and Test Plans to ensure that test cases reflect user needs for the functional, UI, Performance, Usability and Security requirements

Environment: Waterfall/SAFE, ASP.NET, UML, Tableau, SOA, MS SharePoint 2010, MS Project, MS Visio, MS Access, MS Word, MS Excel, JIRA, iRise, DB2, SQL Server Management Studio, SSRS, Informatica, HTML 5, CSS 3, JavaScript

Confidential

Sr. Business Systems Analyst / Scrum Master

Responsibilities:

• Elicited business requirements by conductingJAD sessions,Interviews,Interface Analysiswith stakeholders and business owners. Also, collaborated withSubject Matter Experts(SMEs) forPre-Analysisof the system
• Captained GAP Analysis by understanding the AS-IS and TO-BE business processes
• Decomposed the scope from the BRD into user stories by conducting a story writing session with the Product owner and then the acceptance criteria for the PSPI (Potentially Shippable Product Increment)
• Used IBM Blue Works BPM tool to achieve dramatic improvements in productivity, cycle times and quality. Focused on data-analysis and interpretation, system interfaces, design of workflows, table assessment, workflows table management and business rules development
• Presented reliable and auditable infrastructure to implement transaction sets in message-oriented or session-oriented integration environment. Ensured that the requests are processed from web-clients using RESTful web services in XML format and interfaced to Gateway/Application webserver tier
• Overlooked the configuration of WMS’s back-end web-based module that has a J2EE platform. Handled the integration of WMS and GIS so that continuous communication via ArcGIS API was possible
• Designed front-end UI using HTML5, CSS3, Bootstrap and JQuery to simplify client-side scripting of HTML so that portal can be accessed on mobile platforms as well
• Utilized JavaScript skills to display a map that can capture the location of outage via BingMaps JavaScript API
• Involved in data profiling of existing sources to measure validity, uniqueness, completeness of data and checked the data integrity using Informatica Quality Center with CRUD (Create, Read, Update, Delete) these are related to HTTP operation by SQL queries such as Insert, Update, Select and Delete
• Facilitated time-boxed SCRUM ceremonies that included Daily Standups, Sprint Planning Meeting, Sprint Review Meeting, Sprint Retrospective Meeting, and Grooming Sessions with Product Owner
• Helped the team to maintain velocity and worked on completing story points in each sprint
• Facilitated the Pre UAT (User Acceptance Testing) and UAT; assisted in testing and maintaining quality procedures such as Black box and Regression testing; created all the relevant documents for appropriate users
• Involved in Integration Test Planning, Test Preparation, Test Execution and Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements
• Prepared Requirement Traceability Matrix in order to track test cases and test plans. Involved in security testing of API integration using RESTful UI. Tested JSON files to check the vulnerability of the system for security attacks. Ensured that there is no leak of sensitive information such as stack traces, server versions etc.
• Recorded requirements in JIRA application; extensively used this tool for User Stories, Tasks and Issue tracking
• Worked withTableauto createdashboards, identify theKey Performance Indicators to better analyze their data and measure the service level compliance of all automated & human controlled processes
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams
• Coached Executives and a team into adopting agile practices on a pilot initiative. Educated members of the Dev team on the fundamentals of Scrum, subtleties and alternate agile practices
• Collaborated with the Data Architect for performing ETL process (Extract, Transform and Load) to reduce/ extract data from larger, more complex databases. In several cases executed ad-hoc SQL Queries to perform feature based extraction & also generated internal reports to analyze the planned interfaces

Environment: Waterfall - Scrum Hybrid (SAFe4.0), JIRA 6.3, HP-ALP 11.5, JavaScript, SOA, RESTful, JSON, Altova XML Spy, Informatica 9.1, Siebel CRM, Oracle Database 10g, IBM Blue Works, MS Office tools (MS Word, MS Excel, MS PowerPoint), MySQL Workbench, Tableau 8.3, Confluence 5.7.4

Confidential, TX

Sr. Business Systems Analyst / Scrum Master

Responsibilities:

• Analyzed feasibility of business requirements for ERP execution, performed cost-benefit analysis for building a Confidential data platform and defined scope, found out dependencies by interacting with Management Business Analysts, other Subject Matter Experts, Product Owner, Project Manager and Technical Lead
• Met with every department’s stakeholders to elicit requirements using techniques such as Business Rule Analysis, Structured Interviews, Job Shadowing, Process modeling and Document Analysis
• Created a Macro Document incorporating components of Business Requirement Document (BRD) and System Requirement Specification (SRS) incorporating business, functional, non-functional, data and GUI requirements which would in turn serve as the centerpiece of the project
• Maintained detailed project documentation including meeting minutes, action items, issues list, feasibility analysis, cost benefit analysis and risk management plans
• Lead a story writing session with an aim of decomposing the scope into epics and user stories using INVEST criteria. Also, worked on the acceptance criteria for the above developed user stories
• Helped the Product Owner to Prioritize the Product Backlog items for developing Sprint tasks by taking technical suggestions from the cross-functional development team
• Involved heavily in Sprint Planning, Issue Tracking and Impediment Management using Rally tool
• Facilitated DA in Creating Staging Area, Source, Target Databases for ETL and data mapping using Informatica
• Developed a Data Governance Strategy and created Data-mapping template to map elements/files with tables and columns in database by constantly interacting with the developers
• Created ER diagram using enterprise architecture, identifying constraints and relationships such as Association, Composition, Aggregation, Generalization and Specialization
• Helped in designing Data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks, slicing and dicing of data marts for analytical decision making support
• Followed a systematic approach to make organization's workflow more effective, more efficient and more capable of adapting to an ever-changing environment using PEGA BPM tool
• Logged and tracked the defects using HP ALM and created an error repository and managed the testing process with the QA team
• Created training scripts, training module, training curriculum and operating manual

Environment: Waterfall-Scrum Hybrid, SharePoint 2013, Tableau, Rally, MS Office 2007 (MS Word, MS Excel, MS PowerPoint), MySQL server 2012, HP ALM 11.5, PEGA BPM, Informatica v9x, JAVA, MS Project, SOAP Web Services

Confidential

Business Systems Analyst

Responsibilities:

• Interpreted managementsystem requirements and analyzed the maturity ofbusinessoperations against those needs to enforce efficient and best OSHA practices in the work environment of HSEE department
• Promoted continuous improvement ofbusinessprocesses, standards, procedures and tools
• Compiled high level requirements by conducting focus groups and requirement workshops with the involved project stakeholders to prepare the requirements artifacts
• Understood the “AS-IS” and “TO-BE” system with proposed features while performing GAP Analysis
• Translated Business Requirements into Business Requirements Document (BRD) and translated them into Functional Specification Document (FSD) and System Requirement Specifications (SRS)
• Established Incident Reporting and Change Control procedures using ClearQuest
• Contributed to ERP Master Data Management strategy for the organization, including creating and maintenance of an ERP Data Dictionary, working heavily with the data team on SQL server for data migration purpose
• Overlooked scripting of Client Side Validation and Server Side Validation to ensure inclusion of functionalities
• Oversaw Black Box Testing based on test scenarios and test cases developed to eliminate gaps between requirements and functionality
• Helped in identifying the entities and establishing relationships between these entities based on the requirements from the business users using enterprise architecture
• Executed the test scripts that were written for unit testing, functional testing, stress/load testing, compatibility testing in three different environments and logged and tracked the defects that were identified
• Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users
• Developed timelines for project delivery, and managed projects and resources to successful completion
• Authored progress and completion reports, which were submitted to program manager on a weekly basis

Environment: SDLC - Waterfall, Rally, UML, MS Visio, MS Project, Oracle 10g, MySQL, MS Office-PowerPoint and Excel

Confidential

Sr. Business Analyst

Responsibilities:

• Developed and tested new SAP solutions to integrate with existing SAP ERP system
• Analyzed the business process along with the prior project documentation for document analysis in order to understand and prepared a configuration document to provide SAP Technical consultant for further analysis
• Conducted Brainstorming Sessions with end users and SME to understand the processes and gather requirements and facilitated one-to-one interviews with key stakeholders and SME’s for requirements gathering
• Complete comprehension of the task for materials administration module
• Performed walkthroughs and knowledge transfer of business requirements and functional requirements with the development and test teams
• Conducted corporate trainings across the nation that improved customer satisfaction to 96%
• Used SharePoint 2007 for content management and document management
• Immediate resolution to PRs according to Schedule Level Agreement (SLA)
• Developed Test Plans, Test Scripts and maintained Master Test Plan. Additionally, performed User Acceptance Test (UAT) and Systems Integration Testing (SIT)

Environment: ASAP, MS Visio, MS Office Suite, Windows XP, SAP Solutions Manager, SharePoint2007

Confidential

Business Analyst

Responsibilities:

• Served as a liaison between HR department and the project team by assisting the business in identifying, understanding the recruitment process and documenting their business needs
• Initiated JAD sessions for design and documentation of the System Design Document (SDD) and made sure that all the requirements were implemented into functionality
• Created packages, views, functions using SQL queries to get data from SQL server
• Created prototypes for the application using HTML which helped business users to give their feedback
• Involved in designing Front-End User Interface (UI) Screens using HTML, CSS, Java Script
• Responsible for implementation of tasks to build required features and user training
• Involved in unit testing, debugging, and document test cases
• Assisted with SNOW-flake schemas in the Dimensional model architects to providing business rules
• Created robust and efficient application following a Model View Controller (MVC) pattern for application development
• Worked on Stored Procedures, Database Triggers, Views and Transactions handling in SQL Server 2005

Environment: MS Office Tools (Word, Excel, PowerPoint, Visio), Visual Studio 2005/2008, HTML, CSS, SOA, SOAP

Confidential

Java Developer

Responsibilities:

• Understood the business process and assisted in developing Java Server Pages using HTML/CSS for User Interface and Java classes for business logic
• Designed the Front-end Screens using Servlets and extensively used JavaScript for client side validations
• Used AJAX and JavaScript for validations and integrating business server side components on the client side within the browser
• Coordinated with the back-end team for integration issues and participated in Code Review preparing Test Cases
• Coded Data Access Object layer to send the data retrieved from Oracle RDMS database to the controller, through business delegate layer
• Worked with servlets and used JDBC for database connectivity to MySQL

Environment: Java, JavaScript, JDBC, JSP, Servlets, Apache Tomcat, PL/SQL, RDBMS