Sai Aakash Madhamanchi Email & Phone Number

Des Moines, Iowa, United States

I have extensively utilized AWS components like EMR and EC2, integrating them with Big Data frameworks such as Hadoop YARN, MapReduce, Spark, and Hive. My expertise includes leveraging AWS Athena for data ingestion from S3 into RedShift, and developing Lambda functions using Python for deployment and public-facing websites. I’ve also implemented various serverless Lambda functions and API Gateways for efficient data submission and processing.In addition to my AWS skills, I have… Show more I have extensively utilized AWS components like EMR and EC2, integrating them with Big Data frameworks such as Hadoop YARN, MapReduce, Spark, and Hive. My expertise includes leveraging AWS Athena for data ingestion from S3 into RedShift, and developing Lambda functions using Python for deployment and public-facing websites. I’ve also implemented various serverless Lambda functions and API Gateways for efficient data submission and processing.In addition to my AWS skills, I have developed and maintained ETL processes using Informatica PowerCenter, including managing data masking with Informatica Persistent Data Masking. My experience extends to creating on-demand tables using AWS Glue and PySpark, and optimizing Spark applications for performance tuning. I’ve worked with Python, JSON, and Groovy scripts for deploying StreamSets pipelines and handling XML document parsing.Furthermore, I have expertise in designing and optimizing SQL queries, managing NoSQL databases like MongoDB and Cassandra, and handling MySQL and PostgreSQL databases. I am proficient in tools such as Apache Airflow for orchestrating data workflows, and have developed Tableau and Power BI reports for effective data visualization. My experience with version control tools like Git and JIRA has ensured effective project management and timely issue resolution. Show less

San Francisco, California, United States

Over the course of my career, I have extensively utilized various Azure Big Data technologies including Azure Data Lake Analytics, Azure Data Lake Store, and Azure Data Factory to move data from flat files and SQL Server through U-SQL jobs. I managed data ingestion into multiple Azure services, processed it in Azure Databricks, and worked with several Azure PaaS components like Azure Logic Apps and Application Insights. I implemented cost-effective solutions by creating trigger-based mechanisms… Show more Over the course of my career, I have extensively utilized various Azure Big Data technologies including Azure Data Lake Analytics, Azure Data Lake Store, and Azure Data Factory to move data from flat files and SQL Server through U-SQL jobs. I managed data ingestion into multiple Azure services, processed it in Azure Databricks, and worked with several Azure PaaS components like Azure Logic Apps and Application Insights. I implemented cost-effective solutions by creating trigger-based mechanisms and managing resources such as Web Jobs and Data Factories efficiently.In addition to my Azure experience, I have utilized Informatica Power Centre and Python to build and test ETL processes, loading data into Oracle Exadata and performing data extraction, transformation, and loading from diverse data sources using Azure Data Factory. My work included creating on-demand tables from Azure Blob Storage using Azure Functions and Python, as well as utilizing PySpark for data processing and optimization in Spark and Hadoop environments. I have also developed Spark APIs and engaged in performance tuning of Spark Applications and SQL queries to enhance data processing and efficiency.I have hands-on experience with NoSQL databases like MongoDB and Cassandra, and have managed data migration between MySQL and PostgreSQL databases. My expertise extends to designing Snowflake schemas in Snowflake, supporting Tableau development for data visualization, and configuring GIT repositories and JIRA workflows for project management. Overall, my skills in data engineering and big data technologies have enabled me to efficiently handle and process large datasets, implement robust data pipelines, and optimize database performance for diverse business needs. Show less

New Delhi, Delhi, India

I have significant experience managing data movement between HDFS and AWS S3, including configuring EMR clusters for Hadoop jobs and utilizing Spark Streaming for near-real-time data processing. My work involves developing and maintaining various data pipelines and performing transformations and aggregations to support efficient data handling. I’ve also created AWS Glue jobs for archiving data from Redshift to S3, and managed data layers and databases, including Redshift and Postgres.In… Show more I have significant experience managing data movement between HDFS and AWS S3, including configuring EMR clusters for Hadoop jobs and utilizing Spark Streaming for near-real-time data processing. My work involves developing and maintaining various data pipelines and performing transformations and aggregations to support efficient data handling. I’ve also created AWS Glue jobs for archiving data from Redshift to S3, and managed data layers and databases, including Redshift and Postgres.In my role, I’ve extensively used Hive for ETL tasks and Airflow for scheduling data pipelines, leveraging Python Operators to streamline business processes. I’ve developed Python scripts for S3 bucket management, including data loading and log management, and written Spark applications for data validation, cleansing, and custom aggregations. My expertise also extends to converting Hive/SQL queries into Spark transformations and optimizing batch processing jobs for increased speed.Additionally, I’ve worked with various big data analytic tools, including HBase and Sqoop, and optimized SQL queries for better performance. My experience includes developing NoSQL database schemas, migrating data between MySQL and NoSQL systems, and working with interactive dashboards in Power BI and Tableau. I use Git for version control and JIRA for project management, ensuring effective collaboration and timely project delivery. Show less

Mumbai, Maharashtra, India

I leveraged Python and R to develop complex data queries, perform statistical analyses, and create predictive models, which enhanced decision-making and insights. Using Apache Hadoop, Pandas, and NumPy, I optimized data transformation and cleaning workflows, facilitating efficient raw data processing and integration. Additionally, I developed interactive dashboards and visualizations with Tableau and Google Analytics to support data-driven business decisions.For data management and… Show more I leveraged Python and R to develop complex data queries, perform statistical analyses, and create predictive models, which enhanced decision-making and insights. Using Apache Hadoop, Pandas, and NumPy, I optimized data transformation and cleaning workflows, facilitating efficient raw data processing and integration. Additionally, I developed interactive dashboards and visualizations with Tableau and Google Analytics to support data-driven business decisions.For data management and analysis, I employed tools like IBM SPSS for advanced statistical modeling, SQL for efficient data retrieval, and MySQL for structured data manipulation. I created ER diagrams for database schema design and utilized Azure Data Factory and Python to manage data pipelines and ETL processes, ensuring seamless integration and transformation of data from diverse sources, including electronic health records.To track website performance and enhance marketing strategies, I used Google Analytics and Azure Application Insights. I applied the Elbow method for optimal K-means clustering, and automated report generation in multiple formats using Python, Tableau, and Azure Synapse Analytics. My work also included detailed healthcare claims analysis and feature engineering with Python, aimed at improving data quality and preparing datasets for machine learning applications. Show less