Kavya

EXPERIENCE Data Engineer, Futurense Technologies JAN 2021 Project: Data Integration – Manage databases, ETL, Optimization • Responsible to manage databases hosted on Nayotab Server on SSMS.

• Data Integration using SSIS to the SSMS database tables.

• Creating databases, stored Procedures and tables on SQL Server.

• Writing SQL Scripts to extract data for validations on Production Server.

• VBA Tool Optimization related to Stored Procedures in SSMS databases. Tools: SQL Server, SSIS, VBA Project: HP Inc. Market Share & Size - Consumer & SCM POD (Agile Project Plan) JUN 2021

• Responsible to build optimal extraction, transformation, and loading of data from IDC/HIS/Flat files using SQL and AWS technologies.

• Handling data in AWS Athena and atlas servers and translate business propositions into quantitative queries.

• Processed data and moved to staging for power bi dashboard development.

• Work with stakeholders including the product, data and design teams to assist with data-related technical issues and support their data infrastructure needs. Tools: AWS Athena, SQL Server, Power Bi, Atlas Server Senior Software Engineer, AdiwebTech Solutions FEB 2020 – APRIL 2021 Project: Spotify – Churn Analysis - Directing free app users to premium subscription

• Responsible for gathering vast amounts of data and converted data into actionable insights.

• Data Preparation and Preprocessing

• Customer Segmentation based on selected features, building and optimizing clustering models to segregate users.

• Built LR for predictions and accuracy score form Confusion Matrix. Tools: Python (SkLearn, Numpy, Pandas), Machine Learning