SUMMARY:

• Methodologies - worked in various environments like waterfall, extreme programming, RUP, agile- scrum, Kanban, waterfall-agile hybrid model and System Development Life Cycle (SDLC).
• Scrum Ceremonies- facilitated various scrum meeting like sprint planning, daily standup, sprint review, sprint retrospective, release planning, sprint grooming and performing pair programming and conducting agile book camps and noledge transfer sessions.
• Prioritization and Estimation Techniques- participated in various prioritization techniques such as MoSCoW, KaNo, Value Stream Mapping, Business Value, Technical Risk and elicitation techniques like planning poker, T-shirt sizing, bucket system, relative mass valuation and conducted various retrospective techniques such as happiness histogram, silent writing, ORID, the wheel, guess who, sail boating.
• Scrum Artifacts- assisted product owner in prioritizing product backlog, sprint backlog and preparing sprint burndown and burnup charts, release burndown charts, impediment log and defining acceptance criteria and Definition of Done for the Potentially Shippable Product Increment (PSPI).
• Analysis- performed risk analysis, impact analysis, data analysis, gap analysis, SWOT analysis.
• Elicitation Techniques- conducted interviews, JAD, brain storming, focus groups to elicit the requirements.
• Documentations- documented various requirements in FRD, BRD, SRS, risk register, requirement traceability matrix (RTM), AS-IS, TO-BE, change request, Disaster recovery plan, user manual, API documentation, XML documentation, test plans, test cases, test scenarios, test objective.
• Testing- performed unit testing, functional testing, regression testing, UAT and API testing by checking the response of the given request in XML and JSON format and performed TDD, ATDD, BDD testing.
• Data Modelling- created UML diagrams like use case, activity, sequence diagram, BPMN for process flow.
• Data Warehousing- performed data mapping, data cleansing, data analytics, data visualization, data validation and reporting in data warehousing.
• Data Base- wrote various SQL DDL, DML, DCL queries, stored procedures, views, joins, triggers.
• Schemas- designed various schemas, dimensional tables, fact tables, using ER diagrams like conceptual, logical, physical diagrams and schemas like snow-flake and star schema, Excel pivot tables and macros.
• Programming- experience in writing java code for database connectivity, unit testing and designing the front-end application which is user friendly.
• Designing- designed various prototypes, mockup screens, wireframes for the front-end applications.
• Regulation and Compliance- noledge in various regulations and compliance such as Anti Money Laundering (AML), Automated Clearing House (ACH), Know Your Customer (KYC), CDD, FTS, Basel Accords, Bank Secrecy Act (BSA), Dodd-Frank Act, SOX, PEP, OFAC, SWIFT, PCI-DSS, credit risk.
• Experience in helping the lead user adoption and change management activities during inception, UAT and post implementation phases. Excellent verbal and written communication skills, and comfortable interacting with employees ranging from entry-level to senior vice presidents. Ability to explain complicated or technical information in a simple way to non-technical audiences by using various system metaphors.

TECHNICAL SKILLS:

Finance Domain: Automated Clearing House, Anti Money Laundering (AML), Fund Transfer System, SWIFT, FileAct, InterAct, Know Your Costumer (KYC), Customer Due Diligence, OFAC, Basel Accords, Dodd-Frank Act.

Database/ Cloud: MS Access, SQL Server, Oracle, Hive, Hadoop, HBase, HDFS, Teradata, Bigdata, Excel pivot tables and Macros.

Tools: Rational Rose, Clear Case, Clear Quest, Jira, HPALM

Defect Tracking Tools: JIRA, Version one, HP ALM (Application Lifecycle Management), HP QC.

Project Management Tools Methodologies: Software Development Life Cycle, Waterfall, Agile, Hybrid model, RUP, XP, UML, MS Project, MS Share point, BPMN, JIRA, Kanban.

Testing Tools: Load Runner, Selenium, SOAPUI, Swagger, Postman, Cucumber, HP QC.

Office Tools: MS Access, MS power point, MS Word, MS Excel, MS SharePoint, MS Visio

Languages: JAVA, SQL, XML, JavaScript

ETL Tools: Informatica, Tableau, SQL Server Management Studio.

Reporting Tools: Tableau, MS office suite, SSRS (SQL Server Reporting Services)

Web Technologies: XML, HTML, CSS, JSON, JavaScript, spring MVC, Hibernate, SOAP, REST.

Operating Systems: Windows, Unix

PROFESSIONAL EXPERIENCE

Confidential, Pennington, NJ

Scrum Master/Sr. Business System Analyst

Roles and Responsibilities:

• Well versed in Scrum Ceremonies from PI planning meeting, Scrum of Scrums, Backlog refinement meeting, Planning meeting, Daily Scrum meeting, Review meeting and Sprint Retrospective meeting.
• Conducted GAP analysis by creating AS-IS and TO-BE workflow using MS VISIO and SWOT analysis to find the strengths and weakness of the new system and generated in-depth root cause analysis reports.
• Conducted JAD sessions, brain storming, interviews to gather requirements.
• Documented the requirements as FRD and BRD and worked on RACI matrix for the team.
• Created RTM to keep track of the requirements status by aligning with test cases, test scenarios.
• Conducted Story writing sessions to convert FRD into user stories determine acceptance criteria and Definition of Done for and assisted Product owner in prioritizing by MoSCoW, KaNo techniques.
• Identified actors and created use case, activity and sequence diagrams using MS Visio and created mock-up screens, wireframes using UI components such as radio buttons, drop-down, check boxes.
• Identified risks and registered in the risk register document using MS excel.
• Managed the versioning of documents using confluence and access of the team.
• Worked withtableauto createdashboards, identify theKPI to analyze their data.
• Writtenhive queriesfor data analysis to meet the business requirements, gathered requirements forhive tablesand working on them usinghive quires, moving data intoHDFSandhiveusingHADOOP, sqoop and gathered requirements for HADOOP clusterby gathering and analyzing the existing infrastructure.
• Created data mapping using Informatica to load data from DB to HDFS, involved in creatinghivetables, loading them with data, and writinghivequeries which ran internally inmap reduce.
• Performed various CRUD operations using SQL queries in MySQL work bench.
• Facilitated the pre UAT, UAT, TDD, ATDD, BDD using cucumber; assisted in testing and maintaining quality procedures such as black box and regression testing and API or XML request and response testing.
• Implemented Issues Tracking in Version One to effectively track impediments against user stories.

Environment: SCRUM-Waterfall Hybrid, Version One, MS office suite, Eclipse, SQL, HPQC, UML, JAVA8, HTML5, CSS3, SOAP, SOAP UI, Swagger, XML, JavaScript, HADOOP, Hive, HDFS, HBase, Big Data, FircoSoft Continuity, Confluence, SWIFT, Informatica, Tableau, Alliance Access, Cucumber, FircoSoft Trust.

Confidential, Boston, MA

Scrum Master/Sr. Business System Analyst

Roles and Responsibilities:

• Extensively practiced all phases of SDLC with responsibility of carrying out root cause analysis, delivery of system and business process.
• Involved in defining the scope of the project, gathered business requirements by conducting Interviews, JAD sessions, Brain Storming with stakeholders.
• Maintained documents like FRD, BRD, Work Breakdown Structure using MS Sharepoint, MS Project.
• Worked with the Scrum Team and PO to negotiate delivery of MVP and prioritizing the user stories.
• Developed metadata documentation using MS Word and Lucid Chart.
• Client-side UI written in HTML, CSS, JavaScript used HTTP to communicate over the internet.
• Assisted with star schemas in the dimensional model architecture.
• Assisted in increasing data integrity by performing data normalization and adding data verification and validity to maintain accuracy of data.
• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
• Utilize SSRS for report generation of the data to be analyzed from the data warehouses, DataMart and SSIS packages to transfer data across different platforms, validate data during transferring from different DBMS.
• Assisted in designing systems architecture based on API’s written requests in XML and JSON.
• Tracked sprint progress by burndown charts, task boards and defect matrix.
• Wrote various SQL queries for the backend using various Joins, Views, Stored Procedures and Triggers.
• Worked with QA team to design and develop Test Plan, Test Scenarios and Test Cases to perform UAT using Cucumber and keeping a track of it with the help of RTM.
• Designed and managed Jira queries, dashboards for metrics reporting for teams.

Environment: Waterfall-Scrum hybrid, share point, MS project, MS Visio, Winrunner8.2, Jira6.x, MS Excel, MS SQL, SSIS, SSAS, SSRS, REST, JSON.

Confidential, Santa Clara, CA

Sr. Business System Analyst

Roles and Responsibilities:

• Acted as a Liaison between the business and IT development teams to resolve functional and technical issues.
• Performed risk assessment using methods to identify Risk, Probability, Impact and how to Mitigate those risks and maintaining all the risks identified in a Risk Register Document.
• Identify, Research, Investigate, Analyze, Define, Document business processes and Use Case Scenarios.
• Created Mock-Up Screens and Wireframes using User Interface components for client verification.
• Designed new computer programs by analyzing Requirements, constructing Workflow Charts and UML (Unified Modelling Language) Diagrams, studying System Capabilities, Writing Specifications.
• Created SQL Queries for Portfolio Drill Downs to pull necessary data from Data Sources.
• Monitors the work progress by Tracking activities, Resolving problems, Publishing Progress Reports.
• Worked on SOA, SOAP, XML, API and prepared documentation with various resources, parameters.
• Acceptance Criteria for User Stories to perform User Acceptance Testing (UAT).
• Designed Test Cases, Test Plans and Test Scenarios to perform Functional Testing, Smoke Testing and Regression Testing and logged down defects and systematically managed.
• Created and managed the API information which includes various resources, requests, response and parameters in form of API documentation.
• Created Test Automation Framework withCucumberby using Gherkin format and maintained track of it.
• Developed and modified Share point user privileges as directed and in compliance with all standard operating procedures and documented the configurations and architectures.
• Wrote User Documentation for further referral, training users and providing help desk support.

Environment: MS Office suite, Agile Scrum, Selenium, JAVA, HTML, SOAP, REST, XML, API, CSS, AJAX, Web Services, SOAPUI, SQL, XML, HP ALM.

Confidential, Cincinnati, OH

Business System Analyst

Roles and Responsibilities:

• Acted as the Primary Liaison between the business line, operations, and the technical areas throughout the Project Life Cycle by communicating the requirements using various system metaphors.
• Performed the AS-IS and TO-BEbusiness process and developed theGAP Analysis to no where we stand. Developed business process models in RUP to document existing and future business processes.
• Conducted User Interviews, Gathered and Analyzed requirements and coped changes using Rational Suite.
• Acted as the primary Intermediary between the SME, business user and technical SME’s to identify the Business Needs, Business Rules, Business Processes and documented them in BRD, FRD.
• Designed and prepared Use Cases, Activity Diagrams, Sequence Diagrams, using UML.
• Assisted the product owner in selecting Prioritization Techniques like KaNo, MoSCoW to prioritize various user stories in the product backlog.
• Participated in sprint review and sprint retrospective meeting and acted as a proxy for the scrum master.
• Created User Interface Documents (UID) of prototypes and wireframes to help designing user interface.
• Created burn-down chart to monitor the completion of work within the time-boxes.
• Assisted in writing, testing and implementation of theSQL triggers, stored procedures, functions.
• Lead UAT along with the QA team, organized KT sessions to ensure that team understands the requirements.

Environment: Scrum, Microsoft Office Suite, HTML, CSS, Java script, JSP, UML, SQL Server, SSRS, SSAS, SSIS, Microsoft Project, Eclipse IDE, HP ALM, HP QC, Spring, Hibernate.

Confidential

Business Analyst

Roles and Responsibilities:

• Tracked and reported timely performance against plans and forecast analyzed GAPS and recommended corrective measures to improve productivity by conducting GAP Analysis with the help of Sr.BSA.
• Assisted and worked with Project manager in creating and assigned task through WBS using MS Project.
• Interacted with stakeholders to gather requirements and created documents such as BRD, FRD and SRS.
• Assisted with reviewing test scripts ensuring functional requirements are tested, helped in prioritizing defects.
• Involved in turning mock-ups and designs into full pages complete with CSS, HTML, and JavaScript.
• Wrote SQL queries for data manipulations and Jira for tracking the progress of the project and entering bugs.
• Worked with application developers to create optimized queries. Creating Database Triggers for automation.
• Participated in the development and preparation of the Test Plan with the testing team as well as ensuring Testability, Reliability, Usability, Maintainability and Performance of the application.
• Extensively involved in the UAT phase to ensure the requirements, functionality of the system was in accordance to the users and their feedback was incorporated.

Environment: Waterfall methodology, MS word, MS project, MS Visio, ClearQuest, MS Excel, JIRA, JAVA, SQL, SOAP, API, SOAPUI, XML, HTML, CSS, AJAX, JavaScript.

Confidential

SQL Developer

Roles and Responsibilities:

• Tracked and reported timely performance against plans and forecast analyzed GAPS and recommended corrective measures to improve productivity by conducting GAP Analysis with the help of Sr.BSA.
• Assisted and worked with Project manager in creating and assigned task through WBS using MS Project.
• Interacted with the customers and internal stakeholders to gather user requirements and their expectations from the system to created documents such as BRD, FRD and SRS and maintained using MS Share point.
• Created UML Diagrams like Use Case Diagrams, Activity Diagrams using Rational Rose.
• Maintained and shared documents FRD, Change Request, Test case documents using MS SharePoint. Created UML Diagrams like Use Case Diagrams, Activity Diagrams using Rational Rose.
• Designed and Implemented SQL queries for QA testing and Reporting Data Validation.
• Created table Indexes to improve performance, worked on Views, Stored Procedures, and Functions.
• Wrote queries used for front-end applications (websites, desktop applications, mobile applications).
• Participated in the development and preparation of the Test Plan with the testing team as well as ensuring Testability, Reliability, Usability, Maintainability and Performance of the application.

Environment: Waterfall, Rational Requisite Pro, Rational Rose, SharePoint, MS Office (MS Excel, MS Word, MS PowerPoint, MS Visio MS Project), JavaScript, Spring MVC, JSP, Hibernate, SQL.

Confidential

SQL Developer

Roles and Responsibilities:

• Analyzed different user requirements with specifications for the various database applications.
• Involved in the design phase of the development life cycle to design the database Prototypes to meet Business Requirements by using MS Access, MySQL workbench.
• Involved in developing Class Diagrams, Sequence Diagrams and Activity Diagrams using MS VISIO.
• Documented and Maintained Database System specifications, Diagrams, and Connectivity Charts.
• Monitored the performance of the SQL database and checked on the execution time.
• Identified columns for Primary Keys in all the tables at the design time.
• Wrote JAVA code for database connectivity like JDBC from the middle tier to the backend database.
• Performed SQL Queries operation such as DML and DDL commands for data extraction and manipulation.
• Created, Tested and implemented Stored Procedures, Views and Queries in MySQL server.
• Performed unit testing using Junit for each block of code and provided the feedback to the QA team.

Environment: JAVA, Eclipse, MySQL, Junit, JavaScript, MS Word, MS power point, MS Visio, MS Excel, SQL workbench, JDBC, CVS.