Prashanth Ellandula Email & Phone Number

● About 4 years of professional experience in Statistical Data Analysis, Data modeling, Data Engineering, and Data Science using R and Python on Microsoft Azure, and overall 9+ years of experience in IT ● Experienced in retrieving various data from different Data servers on Azure Data Lake and Cosmos DB and validating, and manipulating data using SQL, VBA Macros, and Excel ● Excellent analytical, problem-solving, and Tableau, Power BI, and SQL debugging skills ● Data Engineer with demonstrated ability in designing and building scalable Azure Data Pipelines and Synapse to solve complex business problems involving large-scale data warehousing, real-data analytics, and reporting● Proficient knowledge in R and Python programming, Azure Data Factory, Exploratory Data Analysis, Structured Machine Learning algorithms, and Power BI Visualization ● 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, Logic Apps, and Azure Data Bricks and then stored in Azure SQL DB and Aurora DB● Superior skill in Advanced Excel on conditional formatting, count, data validation, index, match, sum, pivot table, VLOOKUP, and data table ● Experienced in creating pipeline jobs, scheduling triggers, Mapping data flows using Azure Data Factory(V2), and using Azure Key Vaults to store credentials● Proficient knowledge of statistics and analytics with an excellent understanding of business operations for effective analysis of data● Quick learner to Identify relevant trends, do a quick research and do follow-up analysis, and prepare visualizations in the form of charts, graphs, and tables● Excellent in Ingestion of Large Datasets using Python, writing Python codes to automate the interaction, and downloading of data as per the data frequency from REST 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 using analytical techniques on large data sets for delivering ad hoc analysis and development of business intelligence