• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 14th Dec 2021

3DE Schools–Dataanalyst Jul2021-present

• CreatedPowerBIdashboardsfor 3DENetworkprofileswhichgivesstatisticsondifferentlevelslikeMarket,School,District.

• CreatedStudentperformancedashboardthatshowcasesKPI’slikechronicabsenteeism,on-tracktograduation,etc.

• DevelopedanautomatedsystemusingPythontoclean,formatandstoretheExcelfilesthatcomein fromschoolsona weeklybasis.

• Workedonmigratingdatafrom SharepointtodatabaseusingSQLscripts andSSMS.

Ahold Delhaize-Datascienceintern Jun 2019–Dec2019

• Automatedtheclassificationof60000+customercommentsintoemotionsanddepartmentsusingNLPinPythonandAzureLuistext classification model with~80%accuracy.

• Created PowerBI dashboards for customer feedback to identify the areas of negative customer experience, which improvedcustomersatisfactionby 20%.

• Monitored the impact of Wine pairing kiosk on wine sales using custom Excel functions and developed interactivedashboards to indicate KPIs and the trends in sales using PowerBI and MicroStrategy. Presented the business team withusefulinsights fromthesalespatterns.

• Standardizedandstreamlinedweeklydatasetsfromcustomersupportteamtoextractcustomerfeedback.

• PerformedQualityassuranceofHadoopclusterfilesysteminAzurebyusingHivequeriesin ApacheAmbari

Socialight-Dataanalyst Jan 2017–Jun2018

• Developed Tableau dashboards for customer’s ROI from different marketing platforms and helped identify the mosteffectiveones.

• Analyzedcustomerdatabasedonproductusageandcampaigntypes tosegmentcustomersfortargetedemailcampaigns.Thisincreased paidcustomer conversions by30%.

• Monitoredandtrackedwebsitetraffic forclientsusingGoogleAnalyticsandprovidedweeklyreportstoindicateKPI’swithTableau.Analysishelpedremodeluserinterfaceofwebsite,increasingcustomerusability andretentionfortheclients.

• ConductedtrendevaluationandforecastingusingPython.

EDUCATION

• NortheasternUniversity,Boston,MA-MasterofScienceinInformationSystems Dec2020

• JNTUH,TG,India-BachelorofTechnologyinComputerScienceandEngineering Jun2018

ACADEMICPROJECTS

Covid-19Datapipeline

Tools&languages: AzureDataFactory

• Built production ready data pipeline for Covid-19 data. Integrated data from HTTP clients and Blob storage to Datalakeusinglinked services.

• TransformedthedatausingHDInsightandDatabricksandcreateddependencytoorchestratethedataflow.

DataWarehouseforRetailStore

Tools&languages:SQLServer,TalendStudio,PowerBI,Tableau

• DevisedDatawarehousemodelandintegratedretaildatafromvarioussourceslikeSQLscripts,XMLfilesandCSVfiles

• Cutexecutiontimeinthemasterjobby25%byusingserializationandparallelizationtomaximizejobperformance.

• Executeddataprofilingonsourcedataandperformeddatacleaningtohandlenullvaluesforrejecttableanalysis.

• Analyzeddataconsistingabout15Mrows toexamineKPIsbycreatingdashboardsusingTableau andPowerBI

Retailstoremanagementsystem

Tools&languages:MySQL,SQLServer

• CreatedE-Rdiagramstodesignadatabasesystemthatsupervisestheexpandingdatainaretailstore

• CreatedSQLDDL,DMLscriptstoconstruct,maintainandmanipulatethedatawithemphasisonJoins,TriggersandViews.

CERTIFICATIONS

MicrosoftCertified DataAnalystAssociate Jan2021

TECHNICALSKILLS

Databases: MySQL,MicrosoftSQLServer

Programminglanguages: Python,R,SQL,PySpark,SparkSQL

Reporting&AnalyticalTools: Tableau, PowerBI, Microstrategy, MS Excel, Google analyticsBigdataandCloud: Alteryx, Talend, Azure (Data lake, Databricks, HDInsight)Othertools: Git, JIRA