Ponakala Sai Nandan

1. Project: Cloud Data Migration & Analysis for Dealer Data Transition.

Description:

Worked the end-to-end dealer data migration from the SHAW system to the AWS-based POTF platform, utilizing Snowflake for data warehousing and analysis. Built and automated scalable ETL processes using Python, Arrow, and AWS services to ensure seamless data ingestion. Developed advanced Tableau dashboards for visualizing migration progress and business insights. Worked closely with stakeholders to ensure technical solutions aligned with business objectives, improving data accessibility and insights.

Responsibilities:

• Designed and automated data pipelines using Python and AWS Lambda, leveraging Arrow to handle large-scale data ingestion and transformation processes for the migration to Snowflake.
• Utilized AWS services such as S3, Lambda, and EC2 for scalable data storage and processing, optimizing resource utilization to reduce operational costs.
• Executed complex SQL queries in Snowflake to compare, transform, and validate large datasets. Optimized query performance and managed cloud-based data warehouses.
• Built and maintained interactive Tableau dashboards to visualize dealer data comparisons, performance metrics, and migration health, providing real-time insights to stakeholders.
• Enhanced Python scripts to optimize ETL jobs, reduce processing times, and improve overall system efficiency.
• Deployed monitoring solutions to track the success of scheduled Arrow jobs, proactively identifying and resolving data loading issues.
• Led efforts in data validation, ensuring accuracy and consistency in the migration of dealer data across platforms.
• Acted as a key liaison between business users and development teams, translating complex business requirements into scalable technical solutions.
• Contributed to daily GitHub workflows, handling code commits, issue tracking, testing, and maintaining version control for migration scripts and ETL processes.

Technologies & Tools: Python, AWS (S3, Lambda, EC2), Snowflake, SQL, Tableau, Arrow, GitHub, ETL Pipelines, Data Warehousing, Cloud Data Migration.

2. Project: Data Migration & Report Development for Snowflake and Tableau.

Description:

Worked on Snowflake for generating Tableau reports, collaborating closely with business stakeholders to gather requirements and define functionality. Developed performance reports that offered high-level overviews with the ability to drill down into specific details. Leveraged Python and AWS cloud services to automate processes and ensure efficient data management and report generation.

Responsibilities:

• Managed the migration of data from Salesforce into Snowflake across different stages (D0 One Lake, D1 Snowflake, D2a) to prepare datasets for Tableau report generation.
• Automated data ingestion and transformation processes using Python scripts, AWS Lambda, and Snowflake for scalable and efficient data loading.
• Curated and transformed datasets using Snowflake's bulk loading and exchange tools, ensuring data integrity and performance optimization.
• Developed detailed Tableau dashboards and reports, utilizing data blending techniques and best practices for effective data visualization and insights delivery. Integrated multiple data sources in Power BI for additional reporting needs.
• Improved query performance in Snowflake by optimizing SQL queries, removing redundant columns, and implementing efficient joins and indexing strategies.
• Created dashboards, scorecards, views, and pivot tables for business intelligence, ensuring that reports were user-friendly and aligned with business requirements.
• Utilized AWS services (S3, Lambda, EC2) to manage data storage and processing, streamlining data migration and reducing operational costs.
• Worked closely with business users, project managers, and subject matter experts to gather requirements and ensure that all reports met business needs and provided actionable insights.

Environment: AWS (S3, Lambda, EC2), Python, Snowflake, Tableau, Power BI, SQL Server, MySQL, Oracle, Teradata, SSIS, Agile Methodologies, C#, JavaScript, MS Office, MS Visual Studio, SVN.

● Worked with team on developing and maintaining ETL (Extract, Transform, Load) pipelines using tools like Python, SQL to automate data extraction from various sources and load it into data storage systems.

● Worked on managing data in cloud-based data warehouses like Amazon Redshift, Snowflake ensuring the data is optimized for performance and accessibility.

● Lead meetings with business partners to define functional needs, which leads to the creation of system specifications and applications.

● Gained experience in cleaning and transforming raw data using tools like Pandas, PySpark ensuring consistency and quality across datasets.

● exposed to cloud services like AWS (S3, EC2, Lambda, RDS), Azure to set up scalable data pipelines and storage solutions in the cloud.

● Worked on creating basic data visualizations and reports using Tableau, Power BI.

● Gained Knowledge on version control systems like Git/GitHub to manage code, scripts, and pipeline configurations.

● Collaborate with cross-functional teams using tools like Jira, Confluence, and Slack to track tasks and projects, ensuring smooth communication and teamwork.

Environment: Windows 7, Linux, Tableau Desktop (10.x/2018.x/2019.x), Tableau Server (10.x/2018.x/2019.x), Microsoft SQL Server, Apache Hadoop, DB2, Informatica, Python, Java,Git, GitHub, JIRA, Agile,and Microsoft Excel.