SUMMARY

• Business Systems Analyst with 8 years of experience in Business Development Process, Systems and Data Analysis. Experience with working in the Banking, Health Care, Medicaid, Retail & E - commerce domain.
• Extensive knowledge, expertise in various phases of Software Development Lifecycle (SDLC) in Waterfall methodology, Agile-Scrum and Waterfall-Scrum hybrid, SAFe environments.
• Proficient in creating Sprint backlog and Product backlog. Worked with the product owner and development team in deciding and negotiating the definition of done and acceptance criteria for PSPI.
• Proficient in networking with individuals at various levels while organizing, conducting and facilitating requirement elicitation sessions such as surveys, interviews, brainstorming, focus group, requirement workshops, document analysis, JAD sessions, Interface analysis, Observation, Reverse engineering.
• Strong experience in preparing project deliverables such as Software Project Charter, Business Requirements Documents (BRD), Functional Requirement Documents (FRD).
• Experience in IT systems including Windows Server and SQL Databases, Web Services, and file storage.
• Excellent hands on experience in conducting GAP Analysis to get a clear picture of AS- IS and TO- BE Scenario. Proficient at analyzing problems through SWOT Analysis.
• Experience in conducting Impact analysis, Cost Benefit analysis, Root Cause analysis, Feasibility study, Risk analysis and As-Is and To-Be business analysis and drafting reports.
• Expertise in preparing the defect management documents and tracking of defects in HP QC ALM.
• Build/Configuration experience in Service Catalog knowledge, Service Asset & Configuration Management, Incidents, Change and Problem Management on ServiceNow platform.
• Responsibly was able to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Thorough knowledge of object-oriented analysis and design using UML diagrams such as Use Cases, Class Diagrams, State Diagrams and Flow Chart Diagrams.
• Good knowledge of Swagger API framework and web and/or mobile software development
• Hands on experience on DTS Packages in SQL, Migration of DTS packages from SQL.
• Involved in Data/Dimensional Modeling; Data mapping, Data integration, Data migration, Data Extraction, Transformation & Loading (ETL).
• Experienced in API testing using Postman, SoapUI to check if APIs are returning the data in JSON, XML format as defined in API documentation using Swagger and required by workflow.
• Created test scripts, test scenarios and test cases with the help of BRD and FRD documents.
• Worked with QA team, involved in Test Planning , Test Preparation , Test Execution , Issue Resolution and Report Generation using HP QC/ALM to assure that all aspects of a Project adhere to Business Requirements.
• Worked on JIRA for Reporting and used for bug tracking, issue tracking, and project management.
• Participate in developing strategies to improve API development life cycle and governance processes
• Used Tableau as a BI tool for generating Analytical Reports required for the project for further analysis and experience using Splunk log management tool for searching and building dashboards
• Used SQL Server Reporting Services (SSRS) to generate the SQL reports.

TECHNICAL SKILLS

SDLC Methodologies: Agile/ Scrum, SAFe, Waterfall- Scrum Hybrid, Kanban, RUP, LeSS

Architecture/Framework: Service Oriented Architecture, 3 Tier Architecture, Apache Tomcat Web Server

Web Development Tools: HTML, Photoshop, JSP, .Net

Business Skills: Change management, Problem & Incident Management, Impact Analysis, JAD

Sessions, Risk Management, Conflict Management:

ETL/Reporting Tools: SQL Server Reporting Services, Informatica, MS Excel, Power BI, Cognos

Project Tools: MS Project, Rational Rose, MS Visio, Splunk, Tableau, JIRA, JAMA, MS SharePoint

Testing Tools: LoadRunner, Selenium, HP ALM. QTP. Cucumber

Languages: HTML, CSS, XML, SQL, JavaScript, JSON, SOAP

Office Tools: MS Word, Excel, Power point, Outlook

Databases: Microsoft SQL Server 2008R2,12,14 Oracle 9i/10g, DB2

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr. Data Business Analyst

Responsibilities:

• Elicited and documented requirements in BRD, FRD, SRS using techniques like Job Shadowing, Brainstorming, JAD Sessions, Interviewing and resolving open items to a closure.
• Prepared claim data for risk adjustment by extracting, cleaning, and merging from different tables using SQL.
• Gathered requirements for data integration, data transformation and database development projects.
• Collaborated with different teams internally and externally including business resources, software developers, architects to ensure relevant analysis and comprehensive documentation of requirements associated with data integration projects.
• Configured SSIS packages to incorporate slowly changing dimensions for tracking historical data.
• Created Data profiling stored procedures using dynamic SQL as well as generating complex scripts to schedule various maintenance tasks.
• Designed SSIS Packages to transfer data between servers, load data into database on SQL Server 2010 environment and deploy the data.
• Facilitated meetings, identified and prioritized data requirements .
• Collaborated with Data Architects and SQL developers to ensure alignment with standards enough requirement detail to allow solution developemetn with minimal additional discovery.
• Created data flow diagrams, data mapping from Source to stage, Stage to Target mapping documents indicating source tables, columns, data types, transformations required and business rules to be applied.
• Worked on API documentation using Swagger tool . Performed API Testing using Postman to check if the APIs are returning the data in JSON, XML format as defined in the API documentation and required by workflow.
• Developed process flow documentation and design using MS Visio and created data set documentation.
• Used SSRS to create versatile reports and presentations for business groups and sales associates.
• Wrote SQL queries to document and integrate data from various sources for real time collateral monitoring.

Environment: Scrum-Waterfall(Hybrid), JIRA, SSIS, SSMS, SSRS, MS Office, MS Project, XML, MS Visio, SharePoint, Swagger, HP ALM QC, Tableau.

Confidential, Boston, MA

Business System Analyst/ Scrum Master

Responsibilities:

• Studied, analyzed and documented as-Is business process for loan approvals
• Hands on Experience with JIRA for drafting the User Stories and managing the requirements.
• Wrote and executed SQL queries using Query Analyzer to provide custom reports to marketing and sales
• Helped in enhancing the bank to fully understand KYC (Know Your Customer) and AML (Anti-Money Laundering).
• Performed Gap and Cost-Benefit analysis to establish the significance of the enhancement.
• Worked with Product Owner to review the working demo of Potentially Shippable Product Increment (PSPI) in review meeting and helped deciding which features are done and satisfies the acceptance criteria .
• Assisted UI Team to create Graphical User Interface(GUI), mockup screens and wireframes using Balsamiq tool to portray the look and feel of PfSPI (Potentially Shippable Product) establishing Definition of Done and Acceptance Criteria .
• The scope covered the broader set of Loan products.
• Worked on payments processing and SWIFT messaging standards.
• Reviewed existing stored procedures , supported developers by tuning SQL queries for better performance.
• Advanced ability to create production-ready motion graphics to suit client needs and/or demonstrate user interface interaction and functionality so that design scope is aligned with development.
• Documented REST API via JSON using documentation tools Swagger and used Plugins for integrating with JAVA.
• Generated Business Intelligence reports for senior management using the Tableau reporting tool and reports on Customer behavior pattern using Splunk tool.

Environment: Agile-Scrum, MS Office (MS Word, MS Excel, and MS PowerPoint), MS Visio, UML, JIRA, Data Manager v10.2, JAMA, SOA, Tableau, Cucumber, REST, ServiceNow, Swagger, Splunk, Balsamiq.

Confidential, Wilmington, DE

Business Systems Analyst/ Scrum Master

Responsibilities:

• Gathered requirements for improving cash flow management by enabling the ability to send payments electronically, collect payments and move money across accounts and translated the priority requirements into specific goals and deliverables at each iteration.
• Helped Product Owner break EPICS into User Stories using INVEST technique and use SMART technique to help Scrum Development Team to break User stories into Sprint Tasks .
• Co-ordinated with the offshore team that was developing the application.
• Analyzed source system’s data and validate system outputs, processes and reporting data with consolidation/elimination with efficient data mapping techniques.
• Created UML Diagrams like Use Cases, Activity and Sequence Diagrams using MS Visio .
• Performed DML (Data Manipulation Language) and SQL operations to Create, Read, Update and Delete (CRUD) the data in the database for data manipulation, data calculations and data analysis .
• Worked on API documentation using Swagger tool. Analyzed domain specific API’s while conducting the Interface analysis , to interpret the data formats in their WSDL/WADL for a thorough understanding of business and Performed extensive API testing using Postman.
• Identified bugs and assisted User Acceptance Testing (UAT) to verify if the system meets user requirements and get UAT Sign Off from the stakeholders .
• Documented User Manual Training Release Notes & Lessons Learnt documents, KT documents and moved them to SharePoint 2010.
• Provided weekly management status reports and coordinated meetings between testing team and development team to review defects and track them to closure.

Environment: Agile -Scrum, JIRA, SQL server, TM1, MSOffice, MS Project, XML, MS Visio, SharePoint, Swagger, Postman, HP ALM QC.

Confidential

SQL Analyst June

Responsibilities:

• Elicited and documented requirements in Epics, User Stories and Business Use Cases in CA Agile Central . using techniques like Brainstorming, JAD Sessions and Interviewing and resolving open items to a closure.
• Helped Product Owner break EPICS into User Stories using INVEST Technique and use SMART technique to help Scrum Development Team to break User stories into Sprint Tasks .
• Performed Document Analysis to understand the AS-IS process and collaborated with the team to design TO-BE process based on the requirements gathered and designed TO-BE process using BPM Tool .
• Responsible for creating Workflow Charts, Use Case Models, Data Flow Diagrams, Entity Relationship Diagrams using Visio and managed requirements and documentation artifacts using CA Agile Central .
• Worked on the assignment of cases into workbaskets, worklists and used skills, operators, access groups .
• Well versed with the case management workflow, routing, case status, urgency, SLA conditions .
• Developed advanced SQL queries using joins, unions, outer joins, group by, order by and aggregate functions to extract data to manipulate and calculate information to fulfill data and reporting requirements including identifying tables and columns from which data is extracted.
• Participated in preparing the defect management documents and tracking of defects in HP QC ALM .
• Used Business Process Management tool PEGA for performing the case management functionality.
• Conducted Data Accuracy Analysis , and support stakeholders for decision-making and used Tableau for report generation of the data to be analyzed for the stakeholders in accordance with the requirements.
• Exclusively used SQL designing , modifying and maintaining the SQL Server Tables, Views and Stored Procedures using MS SQL Server .
• Tracked and Reported Defects using HP ALM QC and provided defect status reports to the Management.
• Performed Backend testing using Data Verification and Data Validation concepts for Payment Gateway application which is integrated with the Portal application.
• Assisted with User Acceptance Testing (UAT) , developing and maintaining quality procedures and ensure that appropriate documentation is in place.

Environment: Scrum, N-tier Architecture, PEGA, CA Agile Central, HP QC ALM, MS office tools, MS project, MS Visio, UML, MS SQL Server, Web Services, HTML, CSS, Java Script, Postman, Tableau, Informatica Power Center, Confluence.