Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sabitha Kommukuri

Business Data Analyst

Summary

  • Over 7 years of professional experience in IT industry which includes Extensive experience in Business Analysis, Database and Data Modeling. Strong experience in eliciting, analyzing, and documenting business critical artifacts.
  • Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
  • Experience with mapping, creation, designing, analysis, design implementation and support of application software based on client requirement.
  • Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
  • Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
  • Experienced in developing accurate business process requirements for Banks, Insurance and State government projects.
  • Experience writing Hive Queries for analyzing data in Hive warehouse using Hive Query Language (HQL).
  • Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
  • Good Data Warehousing concepts including Meta data and Data Marts.
  • Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.
  • Extensive experience in project management best practices, processes, & methodologies including Rational Unified Process (RUP) and SDLC.
  • In depth knowledge of Scrum methodologies, concepts, phases, and types of data driven developments and documentation results accordingly after analyzing Business Requirements Documents (BRD), Functional Requirement Specifications (FRS).
  • Well versed in Hadoop ecosystem – Spark, Sqoop, Map Reduce, Pig, Hive, HBase, Oozie and Zookeeper.
  • Analysis and review of Software and Business Requirement Documents. Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
  • Good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
  • Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
  • Detailed understanding of Software Development Life Cycle (SDLC) and strong knowledge in project implementation methodologies like Waterfall and Agile.
  • Excellent technical, communication, analytical and problem-solving skills and ability to get on well with people including cross-cultural backgrounds and trouble-shooting capabilities

Overview

6
6
years of professional experience

Work History

Business Analyst

Common Wealth Bank
07.2020 - 01.2022

The Commonwealth Bank of Australia, is an Australian multinational bank with businesses across New Zealand, Asia, the United States, and the United Kingdom. It provides a variety of financial services, including retail, business and institutional banking, funds management, superannuation, insurance, investment, and broking services.

  • Designed the business requirement collection approach based on the project scope, created Business Analysis using agile methodology
  • Involved in Requirement Elicitation and maintaining requirements from Inception through Construction phase
  • Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software
  • Conducted Business Analysis and Data Analysis
  • Developed strategic partnerships with the business units to develop a solid knowledge base of the business line; including the business plan, products, and process and revenue streams
  • Created project plans, style sheets and templates to analyze and estimate feasibility, cost, time and general guidelines for project team
  • Facilitated JAD (Joint application development) sessions with business users and development teams to drive out detailed business requirements
  • Implemented Hive Partitioning and Bucketing on the collected data in HDFS
  • Involved in Data Querying and Summarization using Hive and creation of UDF's
  • Design technical solution for real-time analytics using Kafka
  • Refined and input business requirements in HP Quality Center for traceability to test requirements
  • Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities
  • Conducted interviews with key business users to collect requirement and business process information
  • Managed requirements based on securities like Equities, Fixed Income, Mortgage Backed Securities (MBS), and Asset Backed Securities (ABS)
  • Used SQL for querying and analysis purposes on various source tables and conditions applied
  • Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly; also conducted project related presentations
  • Performed extensive data analysis using MS Excel and gap analysis
  • Conducted benchmarking activities to identify best practices
  • Stored and modified requirements in MS - Word
  • Documented business requirements with wireframes and mockups to explain in detail the business implications and impacts
  • Managed SharePoint Designer workflow creation

Data/Business Analyst

Allianz
11.2019 - 06.2020

Allianz is replacing its current ASO Billing system with a technology that would allow us to become responsive to the external environment, ensure data accuracy, and provide transparency around billing data

  • Gathered high level requirements from stake holders located and developed scope along with the PM of the project for the implementation
  • Mapped ‘administrative services only' Process using MS Visio
  • Conducted weekly meetings for deciding and reporting on the Policies and Procedures to be followed
  • Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software
  • Performed the Risk Assessment, requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro
  • Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML methodologies
  • Developed a database on MS Access for the company to keep a track on the expenses for various phases of the project
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio
  • Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues
  • Create detailed wireframes for all pages
  • Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project
  • Assisted in writing SQL Queries as a part of Backend Testing
  • Identified and clearly functional issues and supported IT development staff throughout the design, development, testing, and implementation phases of the software development life cycle
  • Created and managed project templates, use-case project templates, requirement types and traceability relationships in Requisite Pro
  • Authored progress and completion reports, which were then submitted to project management on a weekly basis
  • Allianz is replacing its current ASO Billing system with a technology that would allow us to become responsive to the external environment, ensure data accuracy, and provide transparency around billing data

Business Analyst

ICICI Bank
08.2016 - 09.2019

ICICI Bank Limited is an Indian multinational bank and financial services company. It offers a wide range of banking and financial services for corporate and retail customers through various delivery channels and specialized subsidiaries in the areas of investment banking, life, non-life insurance, venture capital and asset management

  • Responsible for creating and reviewing business requirements, functional specifications, project schedules and documentation
  • Conducted JAD (Joint application development) sessions with business users and development teams to gather the quality requirements
  • Worked extensively with SMEs in understanding and documenting their requirements pertaining to the Credit Card processes
  • Worked with all levels of client staff in the process of solution definition
  • Assisted with product evaluation, product customization and system integration
  • Conducted GAP analysis around the identification of business rules, Risks involved, business and system process flows, user administration, requirements and assumptions
  • Analyzed user problems, including automated and manual business processes, and identified, researched, investigated, defined and documented business processes
  • Designed and developed Use Cases, Use Case Diagrams and Activity Diagrams using UML
  • Created wireframes based on requirements and refined with development team
  • Co-authored business requirements documents with the business users
  • Discussed and refined business requirements from business users and team members
  • Assisted the project managers with the development of project schedules
  • Involved in Test Execution for System Involved in documentation during various phases of development life cycle
  • Tested the UI using JSP, with client-side validations using JavaScript
  • Designed class and sequence diagrams for Enhancements
  • Tested the user interface presentation screens using HTML, XML, CSS, JQuery
  • Co-ordinate with the QA leads for development of test plan, test cases, and unit test code
  • Worked on optimizing large complicated SQL statements as part of performance improvement for speedy client deliverables
  • ICICI Bank Limited is an Indian multinational bank and financial services company
  • It offers a wide range of banking and financial services for corporate and retail customers through various delivery channels and specialized subsidiaries in the areas of investment banking, life, non-life insurance, venture capital and asset management

Education

Master of Science - Information Technology

Central Queensland University
05.2001 -

Bachelor of Technology -

Jawaharlal Nehru Technological University
05.2001 -

Skills

  • Hadoop

  • Spark

  • HDFS

  • Map Reduce

  • Hive

  • HBase

  • Nifi

  • Zookeeper

  • Sqoop

  • Kafka

  • Flume

  • Oracle 11g

  • Teradata

  • DB2

  • SQL Server

  • Waterfall

  • Agile

Informatica

  • Talend

  • Ab Initio

  • Data Stage

  • SSIS

  • Tableau

  • Cognos

  • Business Objects BOXI

  • SSRS

  • SQL Navigator

  • Oracle SQL Developer

  • JAVA

  • Python

  • Hive QL

  • Rational Clear Quest

  • Control M

  • WinSCP

Timeline

Business Analyst

Common Wealth Bank
07.2020 - 01.2022

Data/Business Analyst

Allianz
11.2019 - 06.2020

Business Analyst

ICICI Bank
08.2016 - 09.2019

Master of Science - Information Technology

Central Queensland University
05.2001 -

Bachelor of Technology -

Jawaharlal Nehru Technological University
05.2001 -
Sabitha KommukuriBusiness Data Analyst