SUMMARY:

• Seasoned IT professional with 9+ years of global experience in techno - functional roles across various domains.
• Served in roles such as Manual Test Engineer, Automation Test Engineer, Business Analyst, Business System Analyst, and Scrum Masterwith proven ability in leading cross-functional and self-organizing teams in various business settings
• Extensive experience in Software Development Life Cycle (SDLC) methodologies such as Traditional Waterfall approach,Agile - Scrum, Hybrid (Water-Scrum-Fall), Kanban, Extreme programming (XP),Rational Unified Process (RUP).
• Expert in Requirements Elicitation & Gathering, Analysis, Design & Development and change management.
• Proficient in developing Conceptual, Logical Data Models, and Physical ER diagrams and using UML diagrams such as Activity diagrams, Sequence diagrams, Use case diagrams, flowcharts.
• Expert in creating and maintaining artifacts such as Business Requirement Document (BRD), Functional Specifications Document (FSD), System Requirements Specification (SRS), Statement of Work (SOW), Use-Case, Data Mapping document (Source to target mapping), Requirement Traceability Matrix (RTM), and RACI matrix.
• Extensive Agile-Scrum experience, utilizing JIRA/Confluence or TFS/SharePoint to document and manage sprints. Experienced with User Stories, TDD, ATDD, BDD, User Acceptance Testing (UAT), Kanban, and bug management.
• Facilitated all Sprint ceremonies for each sprint in Agile Scrum Methodology as Scrum Master.
• Adept in team management, conflict management & resolution.
• Experienced in prioritization techniques such as MoSCoW, Kano, Walking Skeleton, Business Value.Estimation techniques such as Planning poker, Bucket system, Relative Mass Valuation, T-shirt sizing.Retrospectivetechniques such as ORID, Happiness Histogram, Silent Writing, Star Fish, Glad Sad Mad.
• Experienced in Data Integration & Migration, Data Integrity, Data Quality, Data Profiling, Data Mining, Data Governance, and Master Data Management.
• Strong knowledge of Data Warehouse architectures - Hub and spoke, federated, independent, centralized, along with ETL process, Data Marts, Star/Snowflake Schema, Facts, Dimensions, OLAP, MOLAP, ROLAP, HOLAP.
• Experienced in supervising Black-box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing.

BUSINESS SKILLS:

• Strong organizational skills and solid ability to meet deadlines
• Effective public speaker with strong persuasive skills
• Demonstrated leadership skills in a variety of settings
• Ability to perform under pressure and competitive drive to exceed expectations

TECHNICAL SKILLS:

Business Skills: Business Process Analysis, Business Process Improvement, Use Case Modeling, BPMN, JAD Sessions, Risk Analysis, Requirements Workshops, GAP Analysis, SWOT Analysis, Document Analysis, Impact Analysis, Data Analysis.

SDLC Methodologies: Waterfall, Agile Scrum, Waterfall-Scrum Hybrid, SAFe, XP, Kanban, Scrum ban

Documentation Tool: Microsoft Word, Microsoft Excel, Mind Maps.

Collaboration Tool: Microsoft SharePoint, Confluence

Designing Tool: MS Visio,Mock- up screens, Rational Rose

Requirement Management: JIRA, HP ALM, Rally, Version One, TFS

ETL tools: Informatica Power Center

Testing Tools: HP QC, HP ALM, Selenium, Load Runner, SOAP UI, TOSCA Test Suite

Databases: MySQL, Oracle, DB2, MS Access

Data Warehousing: ER Modeling, Dimension Modelling, Data Vault Modelling, Data Marts, OLTP, OLAP, Data Profiling, Data Mapping, Data Mining, Data Validation, Star schema, Snowflake Schema

Reporting Tools: Tableau, IBM Cognos, Power BI, SSRS

Languages: C, JavaScript, HTML5, CSS, XML, JSON, PL/SQL

Operating Systems: Windows, Mac OS, Linux

Cloud Tools: Microsoft Azure

PROFESSIONAL EXPERIENCE:

Confidential, Estero, FL

Sr. Agile Business System Analyst

Responsibilities:

• Involved in defining the Source to Target Data Mappings, Business Rules, Business and Data definitions.
• Own, managed and created data mapping documentation for various types of data loads (using informatica & Mule Soft) like DB to DB, DB to web services, Cobol Copy book to Webservices etc., for the Confidential Location Data in bound & outbound to MDM.
• Created Architectural and Process diagrams for various types of data integrations.
• Interact with computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.
• Involved in evaluating Data Profiling, Cleansing, Integration and extraction tool (Informatica).
• Involved in creating Data Governance and Privacy Policies.
• Led development and documentation of data governance policy and procedures as well as Stewardship inventory and control set up processes for MDM project.
• Developed Data Dictionaryand Data Sets using Excel.
• Provide inputs to development team in performing extraction, transformation and load.
• Worked with the Data Analysts to resolveduplicates, standardizing data (Mass Maintaining), and incorporating rules to eliminate incorrect data and filter data as per requirements.
• Conducted Gap Analysis to derive data requirements to build MDM. Reviewed and made input to Business Requirement Document (BRD) from policy owners.
• Supported the assigned project manager with creating detailed project plans and assisting in developing, scheduling and tracking project timelines.
• Worked with SQL to extract validation of data.
• Worked on Change Management requirement with the stake holders and development team to deliver the application.
• Involved in Requirements Gathering from user groups and analyzed workflows.
• Worked with Informatica for ETL processes to perform Data integrations from Legacy Systems to MDM and worked with MuleSoft for Real time and Near Real time Data integrations using API’s and Webservices from MDM to Future Systems.
• Drafted detailed Functional User Stories and utilized JIRA to Manage User Stories and used ALM to Manage Defects/Bugs and Test Cases.

Environment: Ebx 5.8, Azure SQL Database, IBM DB2, Informatica Power Exchange, Agile, Jira, HTML, XSD, XML,JSON, MDM, Office 365, MS Word, MS Excel, MS PowerPoint, Lucid Charts, X-Mind Maps, MS Azure, MS-Project, Team Works,Micro Soft Power BI.

Confidential, Columbus, OH

Sr. Business System Analyst

Responsibilities:

• Interfaced with business to gather requirements and define and materialize project scope.
• Conducted meetings for Effort Estimation and work scoping of sprints.
• Worked with DBA team to deploy the code changes into Test, Integration and later into Production environments.
• Created data migration plans to transfer data to target systems by defining data transformations to be undertaken for successful data migration.
• Conducted Gap analysis and maintained a Requirement Traceability Matrix to track the progress of each requirement through the various stages of development.
• Gathered business requirements by conducting user interviews, focused group sessions, understanding existing system and conducting JAD sessions.
• Authored functional specification documents and created wireframes and UX Mockups.
• Created work flows and user-system interaction flows to identify issues and optimize user interactions to improve user experience.
• Facilitated sprint planning, sprint grooming meeting, daily Scrum Meetings to review the status of Sprint Backlogs.
• Conducted post mortem meetings after each sprint to identify problem areas and ideate solutions and improvements.
• Performed root cause analysis on process issues and defects.
• Coordinated with members from various geographies including onshore and offshore teams to ensure nothing is dropped out.
• Created application workflows and process flow diagrams in Visio.
• Created project work items including features, user stories, defects and dependencies in work item management suite (Visual Studio) and assigned them to appropriate persons.
• Conducted daily standup meetings with team members to track execution and resolve any functional issues.

Environment: Windows 8, Windows Server, SQL Server, Microsoft visual studio, Microsoft Azure DB, Microsoft Test Manager, Document DB, HP ALM.

Confidential, Trenton, NJ

Business System Analyst

Responsibilities:

• Interacted with users and stakeholders to Identify business needs, evaluated solutions for business problems.
• Gathered business requirements by participating in JAD sessions, interviewing business users and stakeholders, conducting one to one session and consulting existing systems documents.
• The methodology used for the project was Waterfall and had a deep understanding about the requirement gathering. Provided clear and consistent information about project status both internally, IT team and stakeholders.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams. Understood the AS-IS system, developed the TO- BE system concepts and also prepared the System Process Maps.
• Prepared Business Requirement Document (BRD/HLD) and Drafted Systems Requirement Specification (SRS). Analyzed, modified and validated these documents.
• Developed Conceptual and Logical ER diagrams for the database. Created Data Dictionary for the data models.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Identified Source systems for Financial data profiling of Billing and Budget processes.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data,
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Used Data Center for Integrating Legacy systems and supporting in decision making.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity.
• Designed and developed all Use Cases and UML models using MS Visio.
• Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes.
• Establish Incident Reporting and Change Control procedures.

Environment: SDLC, Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, MS SQL 2008, SSIS, SSRS, SSAS, MS Sharepoint.

Confidential, Buffalo, NY

Sr. Business System Analyst

Responsibilities:

• Communicated Project Requirements, Business Issues, Solution and made recommendation functionalrequirement, business rules & complex security requirements.
• Acted as a liaison between departmental end-users, technical analysts, information technology analysts,consultants and other governmental organizations in the analysis, design, configuration, Case Tracking/testing and maintenance of case management systems to ensure optimal operational performance.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other,resolve any issues and come to an agreement quickly and Liaison between ECM team developers and business area to resolve development questions.
• Worked on Quality Assurance and business requirements and created Requirement Traceability Matrix (RTM) using BPMN.
• Worked with SMEs in regulatory compliance to identify gaps in the existing compliance systems, and to chart a future state of the compliance portal.
• Supported the assigned project manager with creating detailed project plans and assisting in developing, scheduling and tracking project timelines.
• Created Data Migration Checklist and Data Migration plan to transfer data to target systems by defining data transformations to be undertaken for successful data migration into Azure SQL Database.
• Worked with SQL to extract validation of data.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Worked on Change Management requirement with the stake holders and development team to deliver the application.
• Worked on ETL tools like Informatica to extract transform and load the data from legacy system to new application and assisted with the design of system screen mock-ups and wire frames.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Responsible in writing in Test Plan and Test Cases. Worked with Test Team to do Unit, Beta and Regression Testing.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other.
• Engaged with managers and subject matter experts in Business Process Re-engineering (BPR) activities. Built productive, collaborative relationships with employees, and HR business partners Support on projects and activities such as Outsourcing and off/near shoring initiatives.

Environment: Azure SQL Database, Azure Data Factory, UAT, Oracle 11g, Agile, OFSAA, Jira, Drupal, TFS, HTML, XSD, XML, JavaScript, MDM, NICE ACTIMIZE, Office 365, MS Word, MS Excel, MS PowerPoint, MS Visio, MS Azure, MS-Project, MS SharePoint, Micro Soft Power BI.

Confidential

Business System Analyst

Responsibilities:

• Interacted with the stakeholders to get a better understanding of client business processes to gather business requirements.
• Worked on Fixed income, portfolio management, investment banking, and fund accounting.
• Worked on systems integration at various levels with different teams and departments.
• Interacted with the clients and the architect for gathering the functional requirements and documented them.
• Identified Use cases from the requirements and wrote Use Case Specifications.
• Created business process workflow diagrams (Activity diagrams) in Rational Rose.
• Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement.
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Used Object Oriented Analysis and Design techniques and database techniques.
• Developed Business Requirement Documents and Functional Design Documents.
• Created test plans and test cases for user acceptance testing.
• Conducted formal and informal Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Used the Unified Change Management from Rational to track changes to multiple artifacts by versioning artifacts, associating requirements to specific change request/defects to streamline the defect/change tracking process.

Environment: Waterfall, MS Office, SQL, UAT Testing, Bugzilla, COTSS, MS Visio.

Confidential

Business System Analyst/Automation Test Engineer

Responsibilities:

• Reviewed System Requirement Specification, Technical Specification and functional design documents to achieve better understanding of the project.
• Created automated test scripts functions Tosca and performed Integration Testing, and Functional Testing.
• Prepared and executed Test Cases manually for different modules according to the Technical Specification, and Functional Design with all Use Case or User Story documents.
• Generated test scripts for Data Driven test.
• Performed manual testing to check the functionality.
• Worked with data types, variable and variable declaration, naming convention, constants and assigning values to the variables.
• Worked in Quality Center for planning, running and tracking defects while attending walkthroughs with client and the development team and Defect reporting meetings periodically.
• Performed Back-End testing by writing and using SQL queries.
• Developed and maintained Function Libraries, Object repositories and Descriptive programming techniques in automation testing using Tosca.
• Updating status report daily basis and weekly basis by conducting meetings with QA team.
• Updating the test cases document according to review comments.
• Used SharePoint to report data defect and application defect. Created Tosca Test cases for automation using Tosca.
• Used Hybrid Framework of Tosca to get data from Excel.

Environment: Windows 7, IE 7, IE 8, IE 9, Apache Server HP QC, TOSCA 8.3.0, 8.3.1 and 8.4 versions, Adobe Flash and other propriety plug-in products, Scrum, Documentum.

Confidential

QA Test Engineer/Business System Analyst

Responsibilities:

• Interacted with the Business Clients, Product Owners, Developers and QA Manager for clear exposure to trickle down the technical/functional User Requirements & Change Requests to Test Plans and Test Scenarios.
• Identified the Test Scenarios based on Functional Specifications and Business Requirements in
• Perform Functional Testing, Regression Testing, System Integration testing, and End to End Testing.
• Analysis of the Functional Requirements, Specifications and Technical Specifications.
• Coordinating, executing, and communicating test activities.
• Participating and discussing in Defect review meetings.
• Provided regular reports on test status and risk assessments on product quality and features.
• Involved in writing Test cases, Test Scenario.
• Involved in Test case execution & filing/verifying/closing of bugs.
• Involved in writing and maintaining Daily Progress Reports and Weekly Status Reports
• Developed and executed test scripts.
• Tracking defects that are raised towards resolution.
• Collaborated with the Project Managers in the development of weekly and monthly status reports and documentation of process flows, policies and procedures.
• Training new members in the team.
• Enhanced the testing lifecycle to ensure test planning, execution, and reporting is effective, efficient, standardized, coordinated and integrated.

Environment: HP QC, Oracle 11g and Windows XP & 7, Water fall.