Summary
Overview
Work History
Education
Skills
Certification
Custom
Timeline
Generic

B Kavitha

Summary

Having 8 years of experience in the field of Information technology with database development Microsoft SQL server (MS SQL Server), Analytical tool Alteryx and ETL tool Integration Services (SSIS). Having 1 years of experience in Azure data factory (ADF cloud) Certified on Alteryx Foundational Micro Credentials and Core certifications, Microsoft Azure Fundamentals (AZ-900), Test solutions to validate whether requirements have been met; develop test plans, test scripts, and test conditions based on the business and system requirements To be responsible for providing technical guidance / solutions and Provide estimates for development Giving application demos to customer and other teams at every sprint end and Unit testing, fixing bugs Experience in Taxation, Retail and insurance domains Worked with water fall and Agile in scrum methodology for application development Involving in analysis, implementation, development, and production

Overview

1
1
Certification
9
9
years of professional experience

Work History

Sr Consultant

KPMG Global Services
04.2022 - Current
  • Analytics – Alteryx – 3 years exp
  • Creating the Workflows to Extract transform and Load the data using existing tools to Analyze the data.
  • Created List, Cross Tab reports with quick filters, summarized filters.
  • Experience with multi row formula, Regex, Dynamic tools, data cleansing.
  • Generated the outputs using relative paths.
  • Experience with aggregation tools.
  • Experience to create macros and interfaces.
  • Developed data workflows to enhance analysis efficiency. Optimized and automated data workflows in Alteryx, reducing manual data processing time by 30%.
  • Built repeatable and scalable ETL Processes to prepare data for analytics and reporting purposes.
  • Collaborated with Business users and data teams to understand data requirements and deliver clean, actionable datasets.
  • Performed data validation and quality checks within Alteryx workflows to ensure accuracy of analytics outputs.
  • Assisted in designing Alteryx workflows to automate data blending and cleansing tasks.
  • Participated in knowledge – sharing sessions to enhance team capabilities in Alteryx.
  • Automated the analytical apps using Alteryx with more interface tools for the internal and onshore team purposes.

Consultant

Evry India Pvt Ltd
08.2019 - 03.2022
  • HMS helps to capture healthcare related data and the processing of the applications and its report services will be maintained through the Azure MS SQL Server and Azure Data Factory (ADF).
  • Basically, it is a migration project from old web portal to new web portal for which we are migrating the on-premise data from db2 to Azure database.
  • Migration of data from DB2 to MS SQL Server doing from both ADF and SSIS.
  • HMS (Healthcare Management System) is a Service based healthcare company.

Software Engineer

3i Infotech
11.2018 - 07.2019
  • Alshaya currently operates more than 4,000 stores in seven segments – Fashion & Footwear, Health & Beauty, Optics, Pharmacy, Home Furnishings, Leisure & Entertainment and Food – and operates around 43 international brands.
  • Manthan is offering tried and tested Advance Analytics product powered by AI helps in optimal data-driven actions across all key merchandising and in-store functions.
  • M.H. Alshaya Co. (Alshaya) is a multinational retail franchise operator headquartered in Kuwait.

Associative Engineer

Harman Connected Services
05.2017 - 10.2018
  • We will take the tobacco products from the litmus dictionary process.
  • In litmus dictionary process. Litmus is providing sales files for convenience retailers where IRI do not currently have the sales.
  • Files will feed into the existing common format process.
  • British American Tobacco plc (BAT) is a British multinational tobacco company headquartered in London, United Kingdom.

Education

Master of Computer Science -

JNTUA university
01-2015

Skills

  • MS SQL server
  • Alteryx
  • SSIS
  • Azure Data Factory
  • Windows server
  • SQL
  • T-SQL
  • SQL Agent
  • Agile
  • Waterfall
  • GitHub
  • TFS
  • Release team
  • Taxation
  • Retail
  • Insurance

Certification

  • Microsoft Azure Fundamentals
  • Alteryx Foundational Micro Credentials
  • Alteryx Core certifications

Custom

  • Business Tax Engine (BTE), KPMG Global Services, Business Tax Engine (BTE) is Tax management system used to companies to calculate, validate, and manage business tax-related data and reporting processes. Federal tax return having forms on which the data extraction will be pdf to excel using Alteryx workflows. Also processing large volume of data Excel files, CSV files, and SQL databases using Alteryx to generate accurate tax data reports and identify data mismatches or exceptions.
  • Health Care management System (HMS), Evry India Pvt Ltd, HMS (Healthcare Management System) is a Service based healthcare company. HMS helps to capture healthcare related data and the processing of the applications and its report services will be maintained through the Azure MS SQL Server and Azure Data Factory (ADF). Basically, it is a migration project from old web portal to new web portal for which we are migrating the on-premise data from db2 to Azure database. Migration of data from DB2 to MS SQL Server doing from both ADF and SSIS. Depends on Clients migration activity held either ADF or SSIS. HMS Application using Azure MS SQL server to populate data to end users.
  • Alshaya – Non Food(Fashion), 3i Infotech, M.H. Alshaya Co. (Alshaya) is a multinational retail franchise operator headquartered in Kuwait and operates more than 90 multinational retail brands across Middle East and North Africa, Russia, Turkey and Europe. Alshaya currently operates more than 4,000 stores in seven segments – Fashion & Footwear, Health & Beauty, Optics, Pharmacy, Home Furnishings, Leisure & Entertainment and Food – and operates around 43 international brands. Manthan is offering tried and tested Advance Analytics product powered by AI helps in optimal data-driven actions across all key merchandising and in-store functions.
  • British American Tobacco plc (BAT), Harman, British American Tobacco plc (BAT) is a British multinational tobacco company headquartered in London, United Kingdom. It is one of the world’s five largest tobacco companies. We will take the tobacco products from the litmus dictionary process. In litmus dictionary process. Litmus is providing sales files for convenience retailers where IRI do not currently have the sales. Files will feed into the existing common format process. Alongside this for SI custom deliveries using the SQL store level database we are creating a dictionary database for all of the Litmus coding of attributes. This is to be used for any custom deliveries that need to utilize the Litmus attribute coding. Dictionary will contain all attributes and product details for defined categories received from Litmus for custom SI solutions.

Timeline

Sr Consultant

KPMG Global Services
04.2022 - Current

Consultant

Evry India Pvt Ltd
08.2019 - 03.2022

Software Engineer

3i Infotech
11.2018 - 07.2019

Associative Engineer

Harman Connected Services
05.2017 - 10.2018

Master of Computer Science -

JNTUA university
B Kavitha