SudeshAmarnath Gaddam

• Design and develop data pipelines from various Real estate data sources to EDP (i.e Enterprise Data platform). Created data pipelines as micro services.
• Implementation of complex MDM rules using SQL and Python to create master dataset for each parent entity and child entities.
• Developed PySpark applications to process and analyze large-scale datasets, using techniques such as data cleansing, feature engineering, and machine learning.
• Maintained documentation of PySpark applications, ETL pipelines, and system configurations to ensure that they are repeatable and scalable.
• Experienced in Amazon Web Services (AWS), and cloud services such as EMR, EC2, S3, and IAM entities, roles, and users.
• Proficient in writing complex SQL Queries, Stored procedures, functions, packages, tables, views, triggers using relational database like PostgreSQL, SnowFlake
• Design and development of market research reports using OpenAI LLMs chat completion and embeddings.
• Development and maintenance of ML - OLS/ logistic regression models for lease type rate normalization and availability conversion classification problems.
• Development of data pipeline from EDP - RDS to SnowFlake using Snaplogic.
• Development of Data marts,procedures with RBACs in SnowFlake.
• Used Airflow orchestrations and Kubernetes cluster for a scalable and maintainable solution.

· Design and develop data pipelines using Python, AWS, SQL and Airflow for Sales, Marketing and Finance data marts in Redshift.

· Meet with the business and engineering teams on a regular basis to understand the requirements and delivery plan.

· Created Source to Target Mappings for the required tables by understanding the business requirements for the reports.

· Generated various dashboards in Tableau for campaign performance with interactive views, drill downs along with user level security.

· Developed Jupyter notebooks for Churn analysis.

· Used Jira as an agile tool to keep track of the stories that were worked on using the Agile methodology

Qualcomm Market Research project :

• I was responsible for interacting with business stakeholders, gathering requirements, and managing the delivery of an ETL solution using Python and Informatica PowerCenter.
• Developed Python scripts to parse JSON files and load data into an Oracle Database, as well as created shell scripts for data validation.
• We used Tableau and Excel to create visualizations and automated processes for pulling attachments from external vendors.

Survey Builder - People Data Analytics :

• Requirements gathering, developed Tableau workbooks and complex QlikView reports, and used QVDs for performance optimization.
• Developed a sentiment analysis solution using NLTK and machine learning algorithms.

Qualcomm Social Media Integration project:

• Developed python scripts to extract data from Google, Facebook, and Twitter, developed Informatica ETL mappings to load the data into IBM Netezza DWH.
• Designed and supported QlikView dashboards.
• Used Control-M scheduler for process flow automation.

GHUB - Payroll/Accounting:

• Worked closely with Payroll and accounting departments, to gather requirements for ETL using Python, Shell scripting and Oracle Stored Procs.
• Developed Tableau reports

• Member of warehouse design team assisted in creating fact and dimension tables based on specifications provided by Business users.
• Worked with architects to prepare data mapping specs form legacy system to new system.
• Load operational data from Oracle and flat files as per new database design in new billing system.
• Worked on billing system reference data modeling.
• Written shell scripts to validate the new reference data in the new billing system to old one.
• Written PL SQL packages for Data Migration Reconciliations.

• Developed PL SQL procedure for content billing summary generation.
• Automation of daily/monthly reports using Shell scripting.
• Created scripts to reconcile CDR counts in upstream and downstream.
• Handling client’s adhoc requests and giving handover to operation team.
• Involved in building the data warehouse for billing data.
• Implemented shell scripts and procedures model the data for data warehouse.

• Implemented IUC (Interconnect Usage Charges) for the years 2008,2009
• Rating Logic maintenance & Change Management.
• Application Support and enhancements to Mediation. Changes in the current system configuration as per the new change requests.
• Developed Shell Scripts to automate the file flow from Billing system to data warehouse.
• Developed ETL process using PLSQL and Unix Shell scripting.
• Scheduled ETL jobs as Cron tasks in Solaris host.