Business Analyst Software Development
Resume:
Rashmi Kekuda Tenkanadiur
****.***@*****.***
Professional Summary
Have diversified Professional IT experience in Banking and Insurance domain.
Worked as Lead Business Analyst, Product management, Onshore Coordinator and involved in requirement gathering, Data analysis, and estimation of the projects.
Worked in Retail Banking Mortgage & Loans, Insurance clients.
Expertise in Software Development Life Cycle (SDLC) and Agile Methodology
Experienced in all areas of project life cycle in a highly structured change management environment using Agile technique.
Worked extensively with the team to meet business requirement, create prototypes, and analyze workflow.
Complete understanding of Object-Oriented Design and Development of web-based and client/server systems on multiple platforms in a Distributed Environment.
Experienced in creating data flow diagrams, use cases, BRD, user acceptance document.
Skilled in performing Gap analysis and Impact Analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements
Have experience in database design, fact dimension model and their relationship.
Good knowledge of Database Warehousing, ETL--Extraction/Transformation/Loading, Data Visualization, mapping of source systems and preparation of source to target mapping document.
Having good knowledge of SQL
Ability to absorb and utilize new technologies and methodologies as needed.
Hands on Experience on software development methodologies like, Agile, Scrum and Waterfall and Kanban.
Expertise in Data Analysis, Business Analysis, Data Extraction, Data Marts
Having good exposure of data modeling and data relationship activities
Having good exposure of Tableau reporting tool
Excellent communicative, interpersonal, intuitive, analysis and leadership skills
Education Background
Degree
GPA or Percentage
University
Period
Bachelor of Engineering in Computer Science
74%
Anna University, India
2009- 2013
Masters in Engineering Management
3.96
St. Cloud State University, Minnesota
2020 – 2022
Technical Skills
Testing Tools
QualityCenter-9.2, Application life cycle Management (ALM), Quick Test Professional, Win Runner.
OS & Environment
Windows, Win 2k Server, UNIX, Linux.
Languages
C, C++, Visual Basic, VBScript, HTML, SQL, PL/SQL
Databases
Oracle Toad, MySQL, DB2, SQL Server, Advanced Query Tool, Oracle SQL Developer
Other Tools
ETL-Informatica, Win SQL, SQL Tool, Control M, JIRA, Share Point, Visio.
Web/App Servers
Oracle/BEA WebLogic, IBM Web Sphere
Professional Experience
M&T Bank – Buffalo, NY
Senior Business Analyst Mar2023- Present
M&T Bank Corporation is an American bank which has its headquarters at Buffalo, New York. The bank operates more than 1000 branches in 12 states across the Eastern United States. There has been a lot of acquisitions in the past. In April 2022 M&T acquired People’s United Bank which is the most recent one.
Project Description:
Lockbox is receivables service offered by the Commercial Bank in which mailed payments and remittance made payable to a Bank customer or internal departments are directed to a post office box that Bank has access to. The Bank collects, processes, and deposits these payments on behalf of its customers while providing customer defined reporting and values added services associated with the processing.
Treasury Center services lockbox department is a high-volume and high dollar area which involves numerous audits and reviews. Lockbox application is an image-based processing system and services are designed to create efficiencies for customers’ receivables reconciliation process.
Responsibilities:
Understanding Business Requirements - Understand the new business requirements and the changes identified, coming up with effort and prioritization of requirement.
Working as Product Owner for requirement finalization and prioritization.
Design Documents – Creation of Functional and Technical Design.
Involved in coordination of multiple teams, schedule and facilitate meetings between various teams for enabling successful project initiation, execution, and completion.
Daily stand-ups call for Agile environment and worked as Product Owner as well.
Online Lockbox set up for Treasury Center portal and Receivable 360 application.
Work as analyst for Bank Administration Institute (BAI) file implementation.
End to End process for Direct Deposit and customer billing files and reports.
Collaborate with stakeholders to prepare reports and payments processing system for ACH.
Involved in multiple document preparation for the team.
Involved in migration of 3rd Party vendor tools like Hyland Onbase to R360 in the organization.
Worked in enhancements of tools like CFTU (Customer File Transfer Utility)- internal tool.
Involved in Test strategy planning, Test Execution and UAT testing.
Worked closely with the Business and Product owners to identify and Change Control Process.
Worked with Scrum master for day-to-day task completion, Ceremonies, Refinement meeting.
Involved in various kind of audits, SOX requirement and Compliance team for requirement as per the federal.
Tools Used: Receivable 360, Hyland Onbase, Windows Server 2019, .Net 4.6 framework, SQL Server 2019, CFTU (Customer File Transfer Utility Tool), JIRA, ServiceNow.
Business Analyst
Client- CNA Insurance, Chicago May 2022- March 2023
CNA Insurance is one of the largest U.S commercial property and casualty insurance companies. Backed by more than 120 years of experience, CNA provides a broad range of standard and specialized insurance products and services for businesses in the U.S., Canada and Europe.
Project Description:
CNA has Premium and Claim applications which update the core financial applications. When there are business changes, all the financial systems get impacted which needs to be tested in a particular environment. This is done in A pre-production environment called as Downstream system. As part of Downstream testing, CNA identifies all impacted systems and this is tested end to end, to see that the applications flow through correctly and then deployed in the production.
Responsibilities:
Reviewing the test plan for all the projects in that release.
Preparing the TSP document and walkthrough the same with IT development team.
Preparing the functional specifications and workflow to understand the system with the Business.
Reviewing the test cases, both standard and also impacted for each cycle and review them with the QA team.
Responsible for preparing mapping document and design specifications based on the business requirements from various teams and the business teams.
Involved in the report generation for the projects based on the Business requirements.
Execution of the jobs in Informatica and analyzing and fixing them for any failure.
Schedule jobs in Control M and make sure the jobs run successfully.
Analyzing issues and working with development team to walkthrough of defects.
Attending daily status call, defect triage calls, sprint demo and kick off meetings.
Tools Used: Oracle SQL developer, Informatica PowerCenter, Secure CRT, Control M.
St. Cloud State University,Plymouth MN Jan 2022-May 2022
Graduate Assistant
Grading of students work related to the subject and updating it in the tool with their scores.
Processing of Student forms and other immigration process forms with accuracy in Excel.
Assisting Lectures in teaching and other grading related works.
Involved in helping the lectures to assist in writing white papers.
Involved in creating Internal applications and managing the system for the university.
Retail lending business intelligence Mar 15 – Feb 16
Client: TCF Bank -Minnesota
Business Analyst
TCF Bank is the wholly owned banking subsidiary of TCF Financial Corporation, a bank holding company headquartered in Wayzata, Minnesota. As of August, 2015, TCF Bank had nearly 380 branches in Minnesota, Illinois, Michigan, Colorado, Wisconsin, Indiana, Arizona and South Dakota.
Project Description:
TCF bank has been developing Data warehouse for Retail business intelligence.
Daily transitional data will be loaded to integrated Data warehouse transitional FACT tables.
Data model supports for Intersystem data and External Systems Data.
Daily Transactional Data come from different systems:
Shaw system – Mainframe
LTV & Laser Pro - SQL Server
Responsibilities:
Involved in the preparation business use case for Data Warehousing projects after liaising with stakeholders.
Involved in project planning, coordination and project execution tasks.
Daily and Weekly status reports shared to clients and higher management.
Peer Review of the scripts and made recommendation for update if any.
Prepared project metrics on sprint compliance and velocity and shared to higher management and client.
Collecting several metrics and came up with corrective measure to be presented to senior management.
Participated in User Acceptance testing (UAT) review and involved in UA test cases review.
Extensively interacted with Data modelers, Developers, to make them understand RLBI project business requirements and ETL design document specifications.
Developed JAD sessions/Data design documents and Source to Target mapping (Table mappings and Field Mapping)
Developed SQL queries for querying data against different data bases for data verification process
Responsible for preparing mapping document and reviewing of ETL test cases and transformation specifications based on the business requirements from various teams and the business teams.
Worked closely with the Business and Product owners to identify and Change Control Process.
Worked with Scrum Master for day-to-day task completion, Ceremonies, Refinement meeting and Program Increment
Responsible for validation of Target data in Data Warehouse and Data Marts which are transformed and Loaded using Informatica Power Center.
Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
Worked closely with the Business and Product owners to identify and Change Control Process.
Worked with Scrum Master for day-to-day task completion, Ceremonies, Refinement meeting and Program Increment
Validated Cognos reports (Report layout validation and Data Validations)
Prepared daily status reports with details of executed, passed, and failed test cases and defect status
Created Data Mockup Files and Mockup data in Flat Files, CSV file, Data base Tables, XML file, Mainframe Data sets.
Coordinating with various stakeholders and understanding end to end business needs for DWH projects.
Environment:
Tools used - Toad for Oracle, Toad for SQL server, Informatica, Cognos, ALM Oracle, SQL server and Mainframe
Online Digital Banking Project May 14-Mar 15
Client: TCF Bank-Minnesota
Software Test Engineer
Project Description:
Software Test Engineer in Online digital banking. Performing steps to test the batch files for TCF online vendor using ETL process. There were batch files generated from different core systems like Deposit, Teller, Cards and Customer. Further ETL process would consume these files and update the DB. As part of this project the format of records in files were tested. Once the ETL process was completed the records were cross checked in DB to make sure records from files are transferred correctly. Any issues was tracked as defect and retested for sign off for production deployments.
Responsibilities:
Followed AGILE Methodology to promote iterations, collaboration, and process adaptability and participated in SCRUM Meetings throughout the life cycle of project
Excellent Quality control and Quality Assurance experience in this project.
Experience of working for the Agile methodology with Scrum process
Active participation in scrum meetings and In-sprint verification (Test environment)
Writing/Reviewing & execution of Test cases
Bug Reporting and helping development team to close the issues.
Excellent Quality control and Quality Assurance experience of financial applications projects.
Expertise in Sanity Testing, Regression testing, and System Testing of Financial Applications
Extensive skills in managing complete software QA cycle (SDLC) with all its deliverables
Various proprietary backend applications for end-to-end Integration testing
Coordinating and participating in test support for weekly production releases.
Responsible for creating test scenario folder structure(s) and documenting test cases targeted for UAT testing.
Involve in review meetings with the Clients to get test cases approved before the test execution is initiated.
Involved in daily status meeting to update the progress and areas of concerns or issues.
Execute approved test cases and log defects as needed in HP Quality Centre.
Web based testing and Manual Testing April 13 – May 14
Client: Air Control Equipment & Systems
Test Engineer
Web based testing and manual testing of the Software:
Involved in the preparation of Test Plan, Test approach, Testing Strategies for web-based testing projects.
Involved in project planning, coordination and implementing QA methodology
Daily and Weekly status reports shared to clients and higher management.
Prepared Test Scenarios, Test data and execute them as well.
Peer Review of the scripts and made recommendation for updates if any.
Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation Testing for all web-based application.
Certifications:
Six Sigma Green Belt certification from Minnesota West Community & Technical College.
Certified Scrum Master by Scrum Alliance
Member of American Society of Engineering Management (ASEM)
Diploma in Interior Designing from New York Institute of Art & Design.
Nominated for Excellence in Leadership Award 2022 by the University of St. Cloud.
Contact this candidate