Summary
Overview
Work History
Education
Skills
Timeline
Generic

Venkata Sudhakar Makam

Summary

  • 8+ years of industry experience of as a Business Analyst identifying business needs and determining solutions to business problems for Lending and finance domains.
  • Knowledge in Developing and designing visualizations for management and clients covering a variety of performance indicators using Tableau or Excel.
  • Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions.
  • Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
  • Have good understanding on activities like Analysis of requirements, Data profiling/Analysis, Data Mapping document preparation for ETL and Reporting layers, high level technical document preparation.
  • In-depth knowledge of Rational Unified Process (RUP) risk engineering; data modelling and mapping; and design using UML, Rational Rose, Visio and other related tools.
  • Proficient in designing techniques like Entity-Relationship diagrams, Star schema, fact and dimension tables, logical and physical modeling.
  • Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, MySQL.
  • Skilled in building real-time communication features using SignalR for WebSocket-based communication between clients and the server.
  • Vast experience in performing SDLC tasks - Requirement gathering, Analysis and Feasibility, Creating Business Requirement Document (BRD), Transforming BRD to Functional Specification Documents (FSD), High Level and Low-Level Design documents etc.
  • Experience in conducting Gap analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and ROI analysis.

Overview

9
9
years of professional experience

Work History

Scrum Master

Capital One
03.2023 - Current
  • Defined and documented clear and complete detailed business requirements and functional specifications using SDLC methodology from Business team.
  • Worked as an interface between users and different development teams involved in application development for better understanding of business and IT process.
  • Conducted Impact and GAP analysis on business requirement, Joint Application Development (JAD) sessions with stakeholders and developed creative solutions for workflow enhancements.
  • Created workflow for suspending and un-suspending DDA numbers directly from customer care advisor screen to facilitate credit card payments.
  • Reviewed loan applications and analyzed data required to process loan documents and performed validation to ensure loan documents are transmitted to appropriate departments.
  • Involved in creating Rich dashboards using Tableau Dashboard and prepared Epics, Features, User stories to create compelling dashboards to deliver actionable insights.
  • Creating Business Requirement document (BRD) and Functional document (FSD) for all credit risk initiatives for retail and commercial business like Home Loan, Deposits, Auto, Credit Cards.
  • Worked with Database team to assist in implementing all stages of development processes including extraction, transformation, and loading (ETL) data from various sources into Data warehouse and Data Marts using Informatica Power Center Designer.
  • Extensively used Excel, SQL programming and Tableau for data mining, predictive & quantitative analysis, designing, reporting and visualization.
  • Involved in various types of data conditioning to verify if Loan IQ sent valid data to different interfaces such as ACH, Web OD .
  • Expertly conducted requirement review sessions and managed project changes using JIRA, ensuring seamless tracking, documentation, and approval processes to maintain project alignment and stakeholder satisfaction.

Business Analyst Intern

TechNumen Inc
08.2022 - 02.2023
  • Utilized Jira tools for maintaining the user stories and acceptance criteria and tracking down the progress and project milestones.
  • Conducted detailed statistical analysis and evaluations of business operations and performance, completing weekly reports and presenting findings to managers.
  • Involved in designing and developing Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML and Business Process Modeling.
  • I have conducted Sprint planning meetings with product owners, and involved in scrum meetings and initiated daily stand up meetings.
  • Involved in created various Tableau visualization using Tableau Desktop applying best practices of report design.
  • Used a range of Tableau features such as: Bullet Charts, Maps, Filters, Actions, Data Blending, Parameters etc.
  • Ensured data accuracy by comparing data checks at source data, database and on the reports.
  • Developed test cases to be used in UAT testing based on business requirements, technical specifications and/or product knowledge.
  • Provided detailed User Interface Document to the development and testing team for clear understanding of system.
  • Reviewed test scenarios and test data created for system, integration testing and regression testing.

Business Analyst

Key Stack Technologies Pvt.Ltd
06.2016 - 07.2021
  • Maintaining a Requirement Traceability Matrix (RTM) to ensure that all Functional Requirements are addressed at the Use Case Level and matched with the Business Requirements.
  • Worked on managing bugs using Defect Tracking Tool JIRA, reviewed each defect and assigned development team to resolve problems.
  • Worked on Preparing the SDD (Story Definition Document) for the Loan Origination System. Analyzed business requirements for testing phase during execution of loan origination system (LOS).
  • Worked on gathering requirements through user's interviews, teleconferences, document analyses, use case analyses and UML diagrams for BRD and user stories creation.
  • Involved in conducting several Joint Application Development (JAD) sessions for gaining detailed requirements and finalizing Business Requirement Document (BRD).
  • Participated in project reviews, proposals, Business development meeting for continuous project improvement and actions.
  • Created functional prototypes based on user requirements and presenting those wire frames to the development and test team for their understanding during the review meetings.
  • Analyzed relational data with SQL to quickly understand existing data stores and to validate source/target mappings and transformation logic.
  • Involved in conducting JAD sessions for communicating with Stakeholders and Project directors..
  • Coordinated User Acceptance Testing (UAT) , developed and maintained quality procedures and ensured that appropriate documentation was in place.
  • Extensively used MS Project to develop work breakdown structure (WBS) and Gantt Charts. Tracked User stories in JIRA and updated Technical documentation in Confluence.
  • Specified data interchange formats (XML, SOAP, FIX protocols) and data transformation for compatibility of messages between source systems and target systems.

Business Analyst Intern

Key Stack Technologies Pvt.Ltd
05.2015 - 05.2016
  • Involved in designing and developing Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML and Business Process Modeling.
  • Gathering requirements for a data collection and reporting system Researching various topics, scheduling meetings and documenting meeting minutes.
  • Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters, sets, groups, calculated fields, parameters, bins, sorting etc. and Dashboard prompts.
  • Good knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions.
  • Have good understanding on activities like Analysis of requirements, Data profiling/Analysis, Data Mapping document preparation for ETL and Reporting layers, high level technical document preparation.
  • Extensively used MS Project to develop work breakdown structure (WBS) and Gantt Charts. Tracked User stories in JIRA and updated Technical documentation in Confluence.
  • Demonstrated a sense of urgency and responsiveness to complete the work and solve problems, with a strong drive to persevere when faced with ambiguity.
  • Created XML Schema Definition (XSD) document to enable developers to verify fields/attributes in XML document.
  • Used SQL queries such as Inner Joins, Left Joins, Right Join, Union, Union All, to extract the reports in SQL Developer and analyze the data for source to target data mapping.
  • Collaborated with the QA testing team to develop the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.

Education

Master of Science - Computer Science

Auburn University At Montgomery
Montgomery, Alabama, USA
12.2022

Bachelor of Science - Computer Science And Engineering

Jawaharlal Nehru Technological University
Anantapur, Andhra Pradesh, India
05.2016

Skills

  • Operating System - Windows XP, Windows 7, Windows 10
  • Methodologies - UML, Use Case Diagram & Narratives, Sequence Diagrams, Interaction Diagrams, JAD/JAR Sessions
  • Languages - SQL, UML
  • Testing & Bug Tracking Tools - Load Runner, JIRA, TFS
  • Databases - MySQL, SQL Server 2000, DB2, MS Access
  • Browser - IE, Mozilla Firefox, Google Chrome
  • Reporting Tools - Tableau
  • Project Management - MS Project 2010, Project Planning, Sprint Planning, Work Breakdown Structure, Burn Down Chart, Risk Planning, Tracking, and Reporting
  • Analysis - Requirements Gathering, Functional Matrix, Gap Analysis, Impact Analysis, BRD, FSD, PowerPoint

Timeline

Scrum Master

Capital One
03.2023 - Current

Business Analyst Intern

TechNumen Inc
08.2022 - 02.2023

Business Analyst

Key Stack Technologies Pvt.Ltd
06.2016 - 07.2021

Business Analyst Intern

Key Stack Technologies Pvt.Ltd
05.2015 - 05.2016

Master of Science - Computer Science

Auburn University At Montgomery

Bachelor of Science - Computer Science And Engineering

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE
Venkata Sudhakar Makam