SUMMARY:

• Professional with 8+ years of experience in the IT Industry. Dynamic and DetailOriented Professional having proven success in conceiving, developing, and implementing creative and cutting edge IT solutions.
• IT professional with a global experience in techno - functional roles across various domains such as Energy and Utilities, Manufacturing & Chemical, with proven ability leading cross-functional and self-organizing teams in various capacitiesas 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 asWaterfall-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 clientinteractionsin highly cohesive and loosely coupled Service Oriented Architecture (SOA) and 3-tier architecture with strong and in-depth understanding of XML, Web Services (WSDL,SOAP, REST)andSQLacross 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
• Scriptedbusinesslogic 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 ApacheTomcat. Wrotebusiness 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
• Well versed in writing User Stories and Breaking down Epic user stories using INVEST method
• 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
• Expert in documenting and tracking user stories using SMART criteria to infuse agility by usingRally, which helped team to have a clear visibility and focusedapproach towards high priority Product Backlog Items (PBIs)
• Assisted project manager and product owner to track and improve efficiency and Team Velocity usingSprint Burn-Down Chart and Product Burn-Down Chart, Work Breakdown Structure, Milestones List and Gantt chart
• Well acquainted with workflows and Unified Modeling Language (UML) diagrams including Use Cases, Activity Charts, ClassDiagrams, 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, Datamarts,Data Analysis, DataIntegration,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 withRelational 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 application design for mock-up screens and wireframesusing Mock-up screens and Balsamiq
• Thorough understanding of Business Intelligence (BI) and experience in creating interactive, analyticaldashboards using Tableau and IBM Cognos for decision making. Reported KPIs using Spotfire
• 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, Unified Modeling Language (UML)

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

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

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

Architecture/Framework: Service Oriented Architecture (SOA), 3-Tier Architecture, N Tier Architecture,Cloud 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

PROFESSIONAL EXPERIENCE:

Confidential, NY

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 business process and TO-BE business process
• 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)
• Presented reliable and auditableinfrastructure to implement transaction sets in message-oriented or session-oriented integration environment. Ensured that the requests are processed from web-clients using RESTfulweb services in XMLformat and interfaced to Gateway/Application webserver tier
• Overlooked the configuration of WMS’sback-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
• Utilized JavaScript skills to display a map that can capture the location of outage via GoogleMaps JavaScript API
• Involved in data profiling of existing sources and checked the data integrity using Informatica Quality Centerwith CRUD (Create, Read, Update, Delete)these are related to HTTP operation by SQL queries such as Insert, Update, Select and Delete
• Expertize indata-analysis and interpretation, system interfaces, table assessment, workflows table management, business rules development and Product Backlog management
• Facilitated time-boxed SCRUM ceremonies that included Daily Standups, Sprint Planning Meeting, Sprint Review Meeting, SprintRetrospective Meeting, and Grooming Sessions with Product Owner
• Facilitated estimation and prioritization of the user stories by using Planning Pokerand MOSCOWandResolved impediments faced by the scrum team at the team and the organizational level
• Helped the team to maintainvelocity 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
• PreparedRequirement Traceability Matrix (RTM) in order to track test cases and test plans
• Associated with the UI development team in creatingMock-up Screens and Wireframes to define various UI Components such as Radio Buttons, Drop-down and Check boxesusing Balsamiq tool
• 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, JIRA 6.3,HP-ALP 11.5, JavaScript, SOA, RESTful, JSON, Altova XML Spy, Informatica 9.1, Oracle Database 10g, 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 requirementsfor ERP execution,performed cost-benefit analysisfor building a consolidated 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, StructuredInterviews, Job Shadowing, Process modeling and DocumentAnalysis
• Created a MacroDocument 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
• Created UseCaseDiagrams and Use Case Narratives and incorporated them in Macro Document
• Lead a story writing session with an aim of decomposing the scope into epics and user storiesusing INVEST criteria. Also, worked on the acceptancecriteria 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
• Developed, maintainedand tracked the progress of the team by the means of Sprint Burn Downchartsas well as calculated the velocity of the scrum team for improved Project Management
• Involved heavily in Sprint Planning, Issue Trackingand Impediment Management using JIRA tool
• Conducted API designs sessions and worked on developing API integration documentation
• Facilitated DA in Creating Staging Area, Source, Target Databases for ETL and data mapping using Informatica
• Developed a DataGovernance Strategy and created Data-mapping template to map elements/fileswith 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
• Logged and tracked the defects using HP ALM andcreated an error repository and managed the testing process with the QA team
• Assisted in the creation of deployment flow chart in conjunction with development, infrastructure, and network teams containing information for maintaining Application
• Created scripts, module, curriculum and operating manual

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

Confidential, TX

Sr. Business Systems Analyst / Jr. Project Manager

Responsibilities:

• Involved throughout various phases of the System Development Life Cycle (SDLC) in Waterfall methodology
• 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 levelBusiness 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, oralpresentations 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 with GUI development team to create the initial UI wireframes, and mockups. Developed Mockup screens and prototypes for the learner’s home page requirements document
• Extensively used MS SharePoint for team collaboration and version control
• Created activity diagrams to represent the current state business process, context flow diagrams to identify the interfaces and the data flow of the system, and sequence diagrams to specify the order of interactions
• 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
• Coached the team to use HP QC for requirement and defect management. Migrated all the requirements and test cases from RTM document to HP QC enabling optimal work and time management
• Managed the technical team usingMS Project to maintain schedules, deadlines, resources and the project tasks
• Created project plans, work breakdown structures (WBS) and identified & managed risks using MS Project
• Maintained detailed project documentation including meeting minutes, action items, issues list, feasibility analysis, cost benefit analysis and risk management plans
• Prepared UMLDiagrams, Process Flow Diagrams, Business Process and Data Process Model using MS Visio
• Assisted Lead Architectin 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
• 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
• Facilitated Post Production Validation and actively participated in production call support whenever necessary

Environment: Waterfall, ASP.NET, UML, Rational Rose, MS SharePoint 2010, MS Project, MS Access, MS Word, MS Excel, HP QC, Balsamiq, Oracle SQL Server

Confidential, NY

Business Systems Analyst

Responsibilities:

• Interpreted managementsystem requirements and analyzed the maturity ofbusinessoperations against those needsto enforce efficient and best OSHA practices in the work environment of HSEE department
• Promoted continuousimprovement ofbusinessprocesses, standards, procedures and tools
• Compiled high level requirements by conducting focus groups andrequirement workshops with the involvedproject stakeholders to prepare the requirementsartifacts
• 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 SystemRequirementSpecifications (SRS)
• Established Incident Reporting and Change Control procedures using ClearQuest
• Contributed to ERPMasterDataManagement strategy for the organization, including creating and maintenanceof an ERPDataDictionary, 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
• Liaised with the UI and UX team in creating GUI mockups using Mockup Screen and Wireframes using HTML, XML
• Oversaw Black Box Testing based on test scenarios and test cases developed to eliminate gaps betweenrequirements and functionality
• Extensively used Altova MapForcein thedatawarehouse to map data coming through different legacy systems/input sources to thetarget data-marts
• 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, functionaltesting, 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 projectsandresources 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 SAPTechnicalconsultant 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 s 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 JADsessions for design and documentation of the System Design Document (SDD) and madesure 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
• 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