Sonali Gupta

Background

About Sonali Gupta

Nearly 3 years of professional experience in business intelligence, data modeling, data engineering solutions • Data Analyst with robust knowledge and experience in Data Analysis, Data Mining, Data Cleaning, Data Visualization, and building data pipelines • Creative in finding solutions to problems and determining modifications for optimal use of organizational data, using Machine Learning, Deep Learning, and BI tools like Power BI. • BI Developer with almost 2 years of experience, building ETL process from scratch, using several frameworks and platforms, with a deep knowledge of databases, transforming business needs into data modeling • Experienced in performing ETL on data on various client files and doing data cleansing and analyzing and aggregating for preparing Data Standardization Document (DSD) and Data Quality Report (DQR) to feed data correctly into the products • Data Engineer with demonstrated ability in designing and building scalable Data Pipelines with proficient knowledge in R and Python programming, Hadoop Ecosystem, Exploratory Data Analysis, Structured Machine Learning algorithms, and Power BI Visualization • Superior skills in Advanced Excel on conditional formatting, count, data validation, index, match, sum, pivot table, VLOOKUP, and data table • Proficient knowledge of statistics, mathematics, and analytics with an excellent understanding of business operations for effective analysis of data • Experienced in migrating data and databases from on-prem infrastructure to the Azure data lake. Raw data is transferred to Azure Storage and processed by Azure functions and then stored in Cosmos DB • Experienced in Ingestion of Large Datasets using Python, writing Python codes to automate the interaction, and downloading of data as per the data frequency from RESTful API, Azure Storage, FTP servers, or any client-side application which acts as a data source • Skilled in setting up Data Lake in Azure and setup Kafka messaging between Azure Data Lake and trusted third-party providers in maintaining hash tables on Oracle DB • Skilled in design and development of various dashboards, reports utilizing Tableau and Power BI Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization, and other making use of actions, other local and global filters according to the end-user requirement • Experienced in developing, maintaining, and processing large databases with complex relationships between tables. Written several advanced SQL queries for extracting relevant data for predictive analytics