Hari Krishna Paladugu

• Collaborated on Enterprise Data Hub(EDH) Migration from AWS Redshift to Databricks.
• Built a pipeline to transfer the data from Redshift to Databricks
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Created DDL for AWS Redshift database and transferred data to Databricks Delta Tables.
• Created Python and PySpark automation scripts.
• Collaborated with team on data validation using SCD-1.
• Extended support to other teams for report design best practices using PowerBI, Incorta and Tableau
• Developed polished visualizations to share results of data analyses using PowerBI.

Tools: AWS Redshift, DBVisualizer, Databricks Notebooks, Databricks SQL, PowerBI, PySpark, Prophecy.io and Snaplogic.

• Worked on data visualizations, and model building to determine building damage after earthquake
• Using this model can classify a building, based on its level of damage with accuracy of 90
• Identified issues, analyzed information and provided solutions to problems.
• Built API based automation python scripts which improved the efficiency by 25%
• Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets.
• Using PowerBI, reduced column variables to less than 25, which made model building faster
• Integrated machine learning techniques into workflows, improving efficiency by 15%
• Developed and implemented a streamlined code review process, improving the team’s productivity by 10%

Tools: Juypter Notebook, Python, SQL, PowerBI, Pandas, Numpy and Anaconda, Teradata.

• Integrated data from ERP, CRM, and Excel using Incorta's Direct Data Mapping, resulting in a unified data view.
• Created logical schemas and defined key metrics, such as total sales, growth, and average deal size.
• Built interactive dashboards for overall sales, regional performance, product line analysis, and sales rep performance.
• Enabled real-time data refresh and ad-hoc query capabilities, achieving faster insights and quicker decision-making.
• Utilized SQL to join and filter data from multiple sources, ensuring accurate and relevant information is displayed in dashboards
• Integrated Incorta data with Power BI for advanced visualization, enabling more detailed and customizable reporting options.

Tools: Incorta, SQL, PowerBI, Python, Numpy, Pandas

• Worked on building model for IT Operations (ITOPs) Proof of Concept(POC)
• Contributed insights into data using tools available in Amazon Web Services(AWS)
• Repurposed existing data sets to incorporate new features and analytics, expanding use of analytics across organization.
• Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets.
• Researched and implemented analytics methods to provide better metrics of employee performance.
• Developed automated scripts, improving system deployment time by 20%
• Enabled insightful trend analysis by designing historical views of critical KPIs in regular reports and dashboards.
• Contributed to the design of new systems by recommending improvements in terms of ease of use as well as addressing specific business requirements regarding robustness against human error.

Tools: AWS S3, AWS Sagemaker, AWS Quicksight, AWS IAM, Python, Pandas, Numpy, Tableau and SQL.