SUMMARY

• Seasoned IT professional with 8+ years of global experience in techno - functional roles across various domains including Financial Services, Retail Banking, Confidential -commerce etc.
• Served as a Developer, Systems Analyst, Business Systems Analyst and Scrum Master Roles and proven ability leading cross-functional and self-organizing teams in various business settings.
• Extremely skilled as Scrum Master in facilitating scrum process and events (Backlog grooming, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective) to improve team’s performance and handling team dynamics.
• Extensive experience in working and implementing various Software Development methodologies (Waterfall, Iterative, Agile/Scrum).
• Expertise in eliciting & gathering Business requirements, Business Process Re-engineering (BPR), Business Process Modelling (BPM),Data Analysis, System analysis and work-flow analysis.
• Experience in gathering SMART (Specific, Measurable, Attainable, Realistic, Timely) requirements and translating them into functional specifications.
• Proficient in writing User Stories and managing Requirements Churn in Scrum efficient in performing, prioritizing effectively leveraging analyzing techniques like Planning poker, MoSCoW, T-shirt sizing.
• Experience in managing projects using exceptionally strong organizational skills, analytical, problem solving, decision-making, leadership skills and Project Management skills.
• Well versed in authoring/reviewing Business Requirements Document (BRD), Functional Specification Document (FSD), Software Requirement Specifications (SRS), Use Case documentation and Data mapping document.
• Proficient in balancing business and functional requirements to be inline with operations and technical feasibility and translate requirements into system concepts.
• Highly collaborative team player with extensive customer relationship skills, also possess excellent facilitation and mentoring skills and ability to prioritize tasks according to business needs.
• Expertise in Requirements Management, Release Management, Scope Management, Steady-state transition and ITIL/ITSM best practices (Incident Management, Problem Management, Change Management) and industry standards.
• Experienced with extensive client interactions and converting business functionalities to Service Oriented Architecture (SOA) models across IT environment. Also worked in Three-tier architecture, AJAX, API’s/Web Services (SOAP, WSDL), Client-side and Server-side validations.
• Experience in applying business analysis tools like GAP Analysis, SWOT, PESTEL, Impact Analysis, Root-case identification, Cost-Benefit analysis, Feasibility study, Risk Analysis.
• Expertise in preparing Test Plan, Test Scenarios, Test Documentation, Test Scripts and Test Cases; coordinating User Acceptance Testing (UAT), and various need based testing.
• Experienced in Data Modelling to create Conceptual and Logical model to capture the user requirements.
• Proficient in extracting/generating reports using SQL Server/SSRS/Google Analytics; can construct complex queries for data extraction and formulate meaningful insights and conclusion from the same.
• Understanding of concepts like Data Warehousing, data structures, Schemas, Data Marts, data migration from OLTP is to OLAP using ETL, Proficient in XML technologies like XML, DTD, XSL, XSLT, SOAP, and WSDL.
• Experience using Google Analytics for deriving key metrics to create actionable insights.
• Worthy understanding of concepts like Data warehousing, data mapping, ETL processes, data modelling.
• Experience handling teams in Offshore/Onside model and communications to ensure seamless service delivery.

TECHNICAL SKILLS

Project Management Tools/Methodology: Object Oriented Analysis and Design. (OOAD) using Unified Modeling Language (UML), MS-Project, MS Share Point, BPMN, Rally, JIRA, Agile-Scrum, Waterfall-Scrum, Waterfall, SmartSheet, Clarizen, Merlin 2.0/3.0

Requirement Management: MS Office, JIRA, VersionOne, RALLY, Confluence, HP ALM 11.5 and Rational Rose

Reporting Tools: SSRS, IBM Cognos, Informatica, MS office Suite, Spotfire

Databases: MS-Access, MySQL, SQL Server 2005/2008/2012 , Oracle 9i/10g

Office Tools: MS Word, MS Excel, MS PowerPoint, MS SharePoint 2013, MS Project, MS Visio

Analytics Tools: MS Excel, MS Access, Google Analytics, Tableau, Oracle Business Analytics, Hyperion

Testing Tools: HP Service Center, HP QC, HP ALM 11.5, Load runner and Bugzillla

ETL Tools: Informatica, SQL Server Data Tools-Business Intelligence (SSDT-BI)

Languages: HTML, XML, Visual Basic 6.0, C#. NET, C/C++, PL/SQL, T-SQL, ASP, Java, ASP.NET, ADO.NET, Salesforce

Defect Tracking tools: Rational ClearQuest

Scripting and Markup: HTML, HTML5, DHTML, Knockout JS, Java Script, AJAX, XHTML, CSS, DTD, XML Schema, XPath, XLST, JQuery

Monitoring Tools: Splunk, Microsoft Network Monitor, Wireshark, HP Sitecope

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Senior Business Systems Analyst/Scrum Master

Responsibilities:

• Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system; assisted in modeling the AS-IS and TO-BE business workflow.
• Performed document analysis to derive business rules from legacy system and validated them with stakeholders for consistency and completeness.
• Assisted in Data modelling, Data Mapping, Data Staging and Data Integration process. Helped in performing ETL from current OLTP to the target data warehouse.
• As a Scrum Master facilitated scrum events including Daily Stand-up meeting, Backlog refinement, Sprint planning, Sprint review and Sprint retrospection meetings.
• Worked closely with IT Operations to understand and document the manual activities that are being performed during commission calculation process.
• Analyzed data from Home Loan System (Lending’s) and Fund Management System to create a data mapping document to extract the data from source systems and load them into CCPS.
• Analyzed requirements wrote User Stories and managed Agile Lifecycle in Team Foundation Server (TFS) and JIRA from planning to sprint deployment. Tracked and communicated team velocity and sprint/release progress. Assisted in managing the Product Backlog and Sprint Backlog.
• Reviewed and assisted the team in functional testing of the application prior to demo in the sprint review meeting. Maintained the Sprint Burn down and Release Burn Down charts.
• Developed test scenarios/scripts, test plans, prepared user acceptance test cases (UAT), UAT issue log for tracking the defects in JIRA and collaborated with system users to conduct UAT.
• Developed use case documentation for system requirements, business process flows, and screen mockups using MS Visio.
• Removed internal and external impediments that hinder team’s productivity. Worked with the team in the grooming and prioritization of product backlog using technique such as planning poker.
• Managed other BAs and sent their status to Project Manager/Business owners on a weekly and monthly basis using MS Project. Worked on project planning, scheduling and status reporting.
• Served as liaison between the scrum team, architect and key stakeholders, earning their confidence with reliable follow-through.
• Generated ad-hoc reports writing ad-hoc SQL queries using joins and nested queries to fetch data from the Microsoft SQL Serverdatabase to see historical business performance.
• Worked closely with payments team to configure direct-deposits for advisers to make fortnightly commission payments.
• Exposure to Payments, Society for Worldwide Interbank Financial Telecommunication (SWIFT payments MX’s, MT’s) and Payment API’s.
• Instructed and modeled core agile principles of collaboration, prioritization, team accountability and visibility. Ensured consistent application of scrum methodologies across the team.
• Used SharePoint as Content Management System for maintaining documents and templates available across the organization.

Environment: Hybrid Waterfall-Scrum Methodology, SQL Server Management Studio 2012, JIRA,Team Foundation Server (TFS), Visual Studio 2010, MS Word, MS Project2010, SharePoint 2013, HP Service Manager, SOA, XML, Mock-up screens, .NET4.0, ASP.NET, LINQ, HTML, CSS, C#. Net, Ajax Control Toolkit

Confidential, Alpharetta, GA

Senior Business Systems Analyst/Scrum Master

RESPONSIBILITIES:

• As a Scrum Master facilitated scrum events including Daily Stand-up meeting, Backlog refinement, Sprint planning, Sprint review and Sprint retrospection meetings.
• Performed document analysis to derive business rules from legacy system and validated them with stakeholders for consistency and completeness.
• Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system; assisted in modeling the AS-IS and TO-BE business workflow.
• Worked with business and technical SME’s to develop thorough understanding of Applications, Systems, relational database, Business Methods and Strategies.
• Generated key statistics Confidential .g. Defect reporting by application, performance usage, tasks estimating as well as time and task reporting.
• Used IBM Cognos to generate internal reports to study and analyze the current business performance.
• Highly proficient in writing and prioritizing user stories in Product Back Log with Product Owner.
• Used various estimation tools, planning poker, MoSCoW, T-shirt sizing.
• Assisted in Data modelling, Data Mapping, Data Staging and Data Integration process. Helped in performing ETL from current OLTP to the target data warehouse.
• Designed Test Plans and Test Cases for User Acceptance testing (UAT), Regression, and Black Box and White box testing with the help of QA teams.
• Encouraged and implemented process improvements techniques and ensure that there was room for change. Introduced a checklist during story time to ask the right questions while reviewing each story.
• Highly proficient in writing User stories, creating Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams etc. Extensively used Rational Rose and MS Visio for UML.
• Constructed Requirements Traceability Matrix to determine the source of the requirement, ensure all requirements are met and locate affected system components when there is a requirements change. Maintained the traceability matrix until business requirements were signed off.

ENVIRONMENT: Agile/ Scrum Methodology, HP ALM,Informatica, IBM Cognos, Tableau, ETL, VersionOne, Oracle 10g, Java, SQL* Loader, SOA, TOAD, Java/J2EE, JSP, Apache TOMCAT, API’s/Web Services, MySQL, Eclipse 3.1, Unix, WebLogic Application Server, Spring, CVS, Hibernate.

Confidential, St.Petersburg, FL

Senior Business System Analyst

RESPONSIBILITIES:

• Involved in Business process re-engineering design including requirement refinement through Business process re-engineering sessions and conference room pilots to produce functional and design documents.
• Involved throughout the System Development Life Cycle (SDLC) of Waterfall methodology.
• Identified and analyzed business needs using techniques such as JAD, Document Analysis, Interface Analysis, Requirements Workshops and Interviews with SMEs and stakeholders.
• Performed data analysis using SQL queries and MS Excel Pivot Tables to understand current complaint metrics and provided the information to the business users during the JAD sessions as inputs.
• Assisted in Data modelling, Data Mapping, Data Staging and Data Integration process. Helped in performing ETL from current OLTP to the target data warehouse.
• Constructed Requirements Traceability Matrix to determine the source of the requirement, ensure all requirements are met and locate affected system components when there is a requirements change. Maintained the traceability matrix until business requirements were signed off.
• Created Test cases and Test scripts for System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.
• Generated reports using SQL scripts to analyze the existing production data and plan for data migration.
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data modelling, Data Validation and Data Integrity testing and used TOAD to compare various schema’s and performance tuning.
• Coordinated with development team to define the batch flow for data validation process.
• Involved in Functional Testing, Integration Testing and User Acceptance Testing (UAT) with the QA team.

ENVIRONMENT: Agile/ Scrum Methodology, MS Project, HP Quality Centre, XML, MS office Tools (Word, Excel, PowerPoint, SharePoint 2007 and Visio), SQL Loader, TOAD,SOA, Oracle 10g, Oracle Hyperion, Oracle’s Business Intelligence, Oracle Governance Risk and Compliance, Hyperion, PeopleSoft, SQL

Confidential

Business Systems Analyst

Responsibilities:

• Elicited requirements by conducting JAD sessions with key stakeholders from business units and application development teams.
• Worked with the Project Manager in defining the scope and requirements of the project.
• Provided technical assistance in identifying, evaluating, and developing systems and procedures that were cost effective and met business requirements.
• Liaised with Server support, Network operations support and monitoring team to understand system interfaces and facilitated coordination.
• Authored test cases, and test plan, requirement traceability matrix with the help of QA team as well as ensuring testability, reliability, usability, maintainability and performance of the application.
• Worked on creating prototype and mock-up screens for visual representation of the system to be developed.
• Assisted in design review meetings to ensure all the requirements are covered in the project scope.
• Assisted the project manager to construct a project plan that included Project Schedules, Milestones tracking, and Meeting minutes using MS Project.
• Assisted in the creation of deployment flow chart in conjunction with development, infrastructure, and network teams containing information for maintaining Application.
• Extensive experience in web-based page and site designs using HTML, XHTML, DHTML, CSS, JavaScript, jQuery and AJAX.
• Exposure to Payments domain, Money transfers, Society for Worldwide Interbank Financial Telecommunication (SWIFT payments MX’s, MT’s).
• Used Splunk for Pro-active monitoring, Operational visibility, analyzing machine data and generating Business Insights.

Environment: Waterfall model, MS Project, Splunk, HP Quality Centre, Wire Shark, HP Site Scope monitoring, API’s/Web Services, XML, SOA, Windows Server, Mock-up screens, MS office Tools (Word, Excel, PowerPoint, SharePoint 2007 and Visio)

Confidential

Business Systems Analyst

Responsibilities:

• Performed document analysis to derive business rules from legacy system and validated them with stakeholders for consistency and completeness.
• Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system; assisted in modeling the AS-IS and TO-BE business workflow.
• Worked with Tellers, business operations and technical SME’s to develop thorough understanding of Applications, Systems, relational database, Business Methods and Strategies.
• Generated key statistics Confidential .g. Defect reporting by application, performance usage, tasks estimating as well as time and task reporting.
• Performed Change Management by handling change requests and performing change impact analysis on business and technical side, and getting the approval from the Change Control Board (CCB), to make the appropriate changes.
• Created project plans, work breakdown structures (WBS) and identified & managed risks using MS Project.
• Designed Test Plans and Test Cases for User Acceptance testing (UAT), Regression, and Black Box and White box testing with the help of QA teams.
• Used various modeling techniques like data modeling, data flow diagrams, and UML diagrams for designing and developing the application.

Environment: Waterfall Methodology, HP Quality Center,Informatica, IBM Cognos, Tableau, ETL, Java/J2EE, JSP, Apache TOMCAT, API’s/Web Services, SOA, MySQL, Eclipse, Unix, WebLogic Application Server, Spring, Hibernate.

Confidential

Salesforce Developer

Responsibilities:

• Understanding of InlineSalesforceObject Query Language (SOQL) andSalesforceObject Search Language (SOSL)
• Integrating SOQL & SOSL along with DML in the Apex Language.
• Involved in creating S-Controls and development for the UI layer, business layer, and the data access layer with java applet, an Active-X control, an Excel file, or a custom HTML Web form
• Extensively used CASE (SQL Server), SSRS reports for data retrieval and data manipulation.
• Troubleshot issues and provided key enhancements for the systems to improve in terms of performance, efficiency and cost.
• Served roles of Defect Preventive Analyst, Disaster Recovery and Service Continuity Co-coordinator.
• Hands-on experience with ASP.NET Web Forms, API’s/ Web Services, and State Management, Caching features, AJAX, configuring optimizations and securing the web application.
• Used Apex code (a procedural on-demand language that is part of the Force.com platform) to expose a Simple Object Access Protocol (SOAP)-based Web Service from within Force.com.
• Used Visual force to consume the SOAP-based Web Service in a Force.com application.
• Used Microsoft Visual Studio 2005 to consume the SOAP-based application from an external ASP.NET Web site.
• Performed Impact assessment for key issues and provided management with details and advise for key management decisions.
• Partnered with business stakeholders to understand, analyze, refine, and communicate business needs to delivery teams for build of effective solutions.
• Captured, refined, and documented business requirements and user stories as well as prioritized backlog into sprints for delivery teams.

Environment: .NET3.0, ASP.NET, Visual Studio 2005/2008, LINQ, HTML, SOA, CSS, CASE Server, Ajax Control Toolkit, Visual Source Safe,Iterative Methodology.