Summary
Overview
Work History
Education
Skills
Timeline
Generic

Venkatakishore Sunkara

Herndon

Summary

Senior Business Analyst with extensive experience at Freddie Mac, Sunstream Business Services, specializing in requirements management, and stakeholder engagement. Proficient in SQL data validation, achieved a 15% cost reduction through process streamlining. Skilled in Agile methodologies, promotes collaboration and delivers solutions aligned with business goals. Detail-oriented Business Analyst with 13 years of experience conducting analysis and research to come up with solutions to common business problems. Polished in formulating business improvement strategies and overseeing new technology and system implementation. Commercially-aware professional with in-depth knowledge of computing systems and project management techniques.

Overview

16
16
years of professional experience

Work History

Senior Service Now Business Analyst

Sunstream Business Services
03.2024 - Current
  • Company Overview: Sunstream Business Services provides the common DNA application for the associations that facilitate loans for farming.
  • Engaged with the Loan Arrangers team for the in-plant project.
  • Bridged IT business needs with ServiceNow platform by negotiating with stakeholders across FDIC Divisions to gather requirements and ensure successful implementation of HR and Workplace Service Delivery solutions.
  • Facilitated workshops and meetings to gather insights, acting as a liaison between business teams and technical staff to ensure clear communication and effective solution implementation.
  • I received appreciation for decision-making and problem-solving by analyzing complex data using SQL queries and multiple discovery sessions.
  • Ability to bring a healthy, aggressive, yet responsible approach to business by conducting the breakout sessions and helping the tech team to be on the same page.
  • Negotiated and secured contracts with key suppliers by analyzing the data, resulting in a 15% reduction in material costs, and improved supplier performance.
  • Conducted the reviews on pricing models for farming equipment.
  • Statistical model building enhances the Fiserve DNA to make better predictions with the available data and analyzes it with limited resources from the client to provide inputs.
  • Created the Power BI dashboard, which supported the sourcing teams, like Fiserv and loan originating systems.
  • Worked on the LGD (Loss Given Default) model, farm credit lease, and marginal cost of debt features.
  • Responsible for creating user stories and updating features in ADO with the latest updates.
  • Used Fiserv DNA to originate the loan via LOS (Loan Origination System). Converting the legacy loans into a new cloud server app.
  • Fiserve DNA accelerated the digital transformation by managing the complex relationships that exist between people, businesses, and accounts.
  • Fiserve DNA holds all the loan information, along with metadata and transactions, up until GL updates. Worked on creating the flow charts for incorporating wholesale fees on wholesale loans.
  • Collect the information from integrating systems, align the requirements, interpret, and collaborate with the stakeholders.
  • Created the business flows in Lucid/Visio and provided the architectural overview to the stakeholders.
  • Utilized ADO (Azure DevOps) for user story updates and tracking purposes in following the Agile methodology.
  • Using IBM DB2, I wrote complex SQL queries to analyze the data and also to prepare reports.
  • Used Co-pilot for tracking the meeting takeaways, action items, and meeting notes.
  • Participate in Agile ceremonies like estimation of points for user stories, brainstorming sessions with developers and the testing team, issue tracking, documentation of the reports, and Sprint retrospective meetings.
  • Streamlined the current BA processes to increase efficiency and deliver the product.
  • I wrote detailed user stories based on the requirements, and I also helped the team with breakout sessions in cases where comprehension was needed to understand the user story.
  • Responsible for product backlog grooming, sprint planning, sprint review, and demo process, along with business stakeholders.
  • Sunstream Business Services provides the common DNA application for the associations that facilitate loans for farming.
  • Analyzed existing workflows and recommended process improvements, aligning ServiceNow capabilities with industry best practices to optimize operations and enhance business value.

Senior Business Analyst

Prudential
05.2023 - 02.2024
  • Responsible for Business Analysis activities, including requirements gathering for the current and future scope, UAT and also integrating with Business Ops to identify any issue at the time of Release deployments.
  • Support marketing efforts for select products, and strategic intent for products distributed through various channels.
  • Jira for story updates and tracking purposes in agile project management.
  • Claim origination, first payment date, planned sunset durations till claim closure.
  • Disability claims Veterans Affairs, Requirements, Separation dates, Physical and mental disabilities, Flow charts on the application process and their integrating systems.
  • Credit cards payment files transferred via SFTP and verifying the Autosys scheduled jobs those process the payments and generated bill to the recipient.
  • Created requirement for the credit card payment processing following PCI Data standards.
  • Written user-stories based on the requirements and also help team to have the breakout sessions in case of any comprehension required regarding the user-story.
  • Monitor the successful completion of the quality initiatives at every step of the Software Development Life Cycle (SDLC).
  • Confluence for storing the artifacts and project documentation and help team collaborate on the content.
  • Has experience in technical writing & business systems analysis.
  • Supported the development and modification of Tableau views in Tableau Desktop 10, while preparing documentation and training users from respective units.
  • Prepare, review, revise, and maintain technical documents, including software and systems engineering, system operations, testing, and user documentation. Gather and analyze technical and product information from various sources to document new or changing product functionality.
  • Involved and driven the Product grooming, Product backlog grooming, Sprint planning, Sprint Review and demo process along with Stakeholders.

Senior Business Analyst

PNC
Pittsburgh
02.2022 - 04.2023
  • Company Overview: Pittsburgh.
  • Responsible for gathering the information from BRD’s and following SEPA (Single Europe Payment Area) guidelines creating the Payment engine which works for European base. Streamlining the process of BA and gathering the requirements which will facilitate the data migration process in step by step, smooth and efficient manner. New payment model which deals with the Instant payment, Secure Credit card payments from Originator SCP and Beneficiary SCP, validations and rules set as per the SEPA rulebook.
  • Involved in Analysis Business Requirements Document and Technical Specification Document.
  • Conducting the meetings with Client on gathering the requirements and creating the process flows.
  • Streamlining BA processes to increase efficiency and deliver the product.
  • Worked with Euro, Master card and Visa chip cards (EMV) to prevent the duplicate cards in case of theft or any fraud.
  • Azure dev ops for creating stories and conducting Business Analyst reviews in Agile methodology.
  • Converted BRD’s into high level and low-level design.
  • Jira for story updates and tracking purposes in agile project management.
  • Written user-stories based on the requirements and also help team to have the breakout sessions in case of any comprehension required regarding the user-story.
  • Using Rapid SQL, written complex SQL queries to analyze the data and also to prepare reports.
  • Generated advanced Tableau dashboards with quick/context/global filters.
  • Monitoring and tracking the server logs in UNIX for validation of request and response of Electronic Data Service and various implemented business rules and logic.
  • Validating the Greater purchase certainty web services (GPC) via SOAP UI.
  • Involved and driven the Product grooming, Product backlog grooming, Sprint planning, Sprint Review and demo process along with Stakeholders.
  • Pittsburgh.

Senior Business Analyst

FreddieMac
McLean
02.2014 - 10.2022
  • Company Overview: McLean, VA
  • Responsible for streamlining BA processes to increase efficiency and deliver well before release deadlines with zero high severity defects for Freddie Mac's Loan Coverage Advisor Application which is a flexible web-based single platform solution used by both internal and external users to view the projected and actual selling representation and warranty relief dates for loans sold to Freddie Mac with the added capability of a variety of report options, advanced loan-level search capabilities to track loan event history throughout loan lifecycle and access to other critical information associated with a loan including transfer of servicing transactions, mortgage insurance, and other credit enhancement(s).
  • Responsible for Business Analysis activities, including requirements gathering for the current and future scope, UAT and also integrating with Business Ops to identify any issue at the time of Release deployments.
  • Jira for story updates and tracking purposes in agile project management.
  • Written user-stories based on the requirements and also help team to have the breakout sessions in case of any comprehension required regarding the user-story.
  • Statistical model building which helped in getting the Loan Coverage Insight (LCI) to predict the loss and percentage of loans going to default in case any disaster hit area.
  • Confluence for storing the artifacts and project documentation and help team collaborate on the content.
  • Has experience in technical writing & business systems analysis.
  • Marginal Lending experience on process, calculations like Loan to Value and Underwriting.
  • Analyzing drivers of credit performance, risk models and underwriting policies.
  • Loan origination, first payment date, planned sunset durations till Loan closure.
  • ETL Working with business users for requirements gathering and business analysis.
  • Converted business requirement into high level and low-level design.
  • Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
  • XML mapping using J-developer and Mismo tools and validated the data elements in the xml as per the Business rules.
  • With the help of Informatica tool, Data is staged and gathered the requirement to extract data from CDW Corporate Data Warehouse.
  • Using Rapid SQL, written complex SQL queries to analyze the data and also to prepare reports.
  • Generated advanced Tableau dashboards with quick/context/global filters, parameters and calculated fields that allowed to track and improve customer units KPI considerably within a month.
  • Supported the development and modification of Tableau views in Tableau Desktop 10, while preparing documentation and training users from respective units.
  • Prepare, review, revise, and maintain technical documents, including software and systems engineering, system operations, testing, and user documentation. Gather and analyze technical and product information from various sources to document new or changing product functionality.
  • Involved and driven the Product grooming, Product backlog grooming, Sprint planning, Sprint Review and demo process along with Stakeholders.
  • Monitoring and tracking the server logs in UNIX for validation of request and response of Electronic Data Service and various implemented business rules and logic.
  • Validating the Greater purchase certainty web services (GPC) via SOAP UI.
  • Working on various models like Data Delivery, Web services and Transaction /Operational Reports.
  • Querying, analyzing, reconciling and testing large volume of complex relational data.
  • Responsible for creation, documentation, and maintenance of the test data for sub-modules.
  • Developing software testing policies, best practices, and guidelines and coordinating with product development teams and software engineers to recommend solutions to maximize performance and efficiency.
  • Maintaining database with product defects, user reviews, and functional improvements.
  • Provide test estimates, project high-level scenarios and Level of Effort for various phases of the project and release.
  • Involved in pre-deployment, post deployment, smoke test in dry run/production environments.
  • Functional responsibilities include Business process flow, End to End Testing, System Testing, Integration Testing, Unit testing and Regression Testing on application.
  • Monitor the successful completion of the quality initiatives at every step of the Software Development Life Cycle (SDLC).
  • McLean, VA

Business Analyst

United Health Group
Silver Spring
02.2011 - 01.2014
  • Company Overview: Silver Spring, MD.
  • Involved in Analysis Business Requirements Document and Technical Specification Document.
  • Has experience in technical writing & business systems analysis.
  • Performed smoke testing, functional testing, System testing, integration testing and regression testing.
  • Developed automation test scripts using the data driven automation framework from scratch using VB script for the purpose of regression tests using HP QTP.
  • Responsible for creating the folder structure in ALM for scripts based on the functionality.
  • SQL queries analysis and fetching data needed as and when required using rapid Sal.
  • Worked in agile space with team of 18 and coordinated well with strong communication skills.
  • Participated in QA bug review meeting and also deeper root cause analysis meetings.
  • Presented the test scenarios and application walk through to the client.
  • Silver Spring, MD.

Business Analyst

Bank of America
Charlotte
01.2010 - 01.2011
  • Company Overview: Charlotte NC
  • Analyzed system requirements, business requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0.
  • Written Test Plan, Test Strategy, Test Script, Test Cases, reported bugs and tracked defects using Quality Center 8.2.
  • Worked with Decision Table Test Design Technique for various test actions.
  • Developed Test Cases for testing the mapping designs before going to the production phase.
  • Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2005.
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Worked on Execution Tracker, Test Design Tracker & Defect Metrics.
  • Did complex data validation using SQL queries.
  • Tested Cognos Reportnet reports into Cognos 8BI.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
  • Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
  • Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
  • Charlotte NC

Sr. ETL QA/SQL Analyst

Citizen Bank
Providence
08.2009 - 12.2009
  • Company Overview: Providence, RI
  • Involved in understanding Logical and Physical Data model using Erwin Tool.
  • Written Test Plan, Test Strategy, Test Script, Test Cases, reported bugs and tracked defects using Quality Center 10.0.
  • Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
  • Worked with Decision Table Test Design Technique for various test actions.
  • Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
  • Collected requirements and tested several business reports.
  • Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
  • Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
  • This work will include loading of historical data onto the Teradata platform, as well as reference data and metadata.
  • Tested Cognos Reportnet reports into Cognos 8BI.
  • Used SDK to validate reports for Cognos Reportnet and Cognos8 SDK.
  • Created Jobs to Schedule multiple reports in Cognos Connection.
  • Personalized Cognos Connection for specified display options for testing regional options and personal information.
  • Worked in keyword view as well as expert view of Quick Test Pro.
  • Configured Quick Test Pro with Quality Centre and Maintained the project information in Quality Centre.
  • Performed Functional Testing and Back-end Testing using the database comparable results Manually.
  • Did Test coverage by adding new test actions from iteration to iteration according to the test strategy.
  • Performed Functional Testing and Back-end Testing using the database comparable results Manually.
  • Worked on Execution Tracker, Test Design Tracker & Defect Metrics.
  • Did complex data validation using SQL queries.
  • Tested the outgoing links from all the web pages from specific domain.
  • Tested all the internal links and tested links jumping on the same Web page.
  • Tested Cookies for all user machines and maintained the session for login sessions.
  • Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
  • Vigorously worked on Manual Testing by writing the Test Cases and executing the Test Scripts for various scenarios.
  • Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2005.
  • Developed Test Cases for testing the mapping designs before going to the production phase.
  • Independently designed and developed project document templates based on SDLC methodology.
  • Extensively test the reports for data accuracy and universe related errors.
  • Tested several dashboards and deployed them across the organization to monitor the performance.
  • Providence, RI

Education

Bachelors of Science - Computer Engineering

University of Vinayaka Mission
Salem, India

Skills

  • Requirements Management
  • Backend SQL Data Validation
  • Data Analysis and Profiling
  • User Acceptance Testing
  • Risk & Impact Analysis
  • Defect Tracking
  • Agile & Waterfall development process
  • Change Management & Issue Resolution
  • Business Process Redesign & Improvement
  • Platforms: Windows
  • Linux
  • UNIX
  • Domains: Health
  • Telecom
  • Ecommerce
  • Mortgage Financial Services
  • Standards: EDI ANSI X12
  • HIPAA
  • Mismo
  • ITIL
  • SOX
  • Architecture: Client/Server
  • Enterprise
  • SOA
  • Web-based applications
  • Languages: Visual Basic
  • JAVA
  • HTML
  • DHTML
  • XML
  • SQL
  • PL/SQL
  • Methodologies: Agile
  • UML
  • Waterfall
  • Network Protocols: TCP/IP
  • SSL
  • HTTP
  • SMTP
  • VoIP
  • SFTP
  • DNS
  • Techniques: Functional
  • System/Integration (SIT)
  • Acceptance (UAT)
  • Regression
  • Usability
  • Performance
  • Load
  • Stress
  • Tools: HP Quality Centre ALM
  • RFT
  • J Developer/Mismo
  • AutoSys
  • Putty
  • WINSCP
  • SOAPUI
  • Tableau
  • ETL Informatic Power center
  • Databases / Tools: Oracle (RDBMS)
  • MySQL
  • PL SQL
  • Access
  • DB2
  • Rapid SQL
  • Cosmos DB
  • Data lakehouse - DLH
  • Power BI
  • Project and management: Microsoft Project
  • Excel
  • Visio
  • SharePoint
  • Jira
  • ADO - Azure DevOps
  • ServiceNow platform
  • SQL analysis
  • Data visualization
  • Business process mapping
  • User story creation
  • Agile methodology
  • Requirements gathering
  • Stakeholder engagement
  • Product backlog management
  • Quality assurance
  • Effective communication
  • Problem solving
  • Process improvement
  • Tableau expertise
  • Data mapping
  • Data analysis

Timeline

Senior Service Now Business Analyst

Sunstream Business Services
03.2024 - Current

Senior Business Analyst

Prudential
05.2023 - 02.2024

Senior Business Analyst

PNC
02.2022 - 04.2023

Senior Business Analyst

FreddieMac
02.2014 - 10.2022

Business Analyst

United Health Group
02.2011 - 01.2014

Business Analyst

Bank of America
01.2010 - 01.2011

Sr. ETL QA/SQL Analyst

Citizen Bank
08.2009 - 12.2009

Bachelors of Science - Computer Engineering

University of Vinayaka Mission

Similar Profiles

CREATE PROFILE
Venkatakishore Sunkara