Ishani Pandya Email & Phone Number

Toronto, On, Ca

Burlington, Ontario, Canada

 Designed, developed, and implemented scalable and efficient data solutions using AWS services such as AWS Glue, AWS EMR, Amazon S3, AWS Lambda, Amazon Redshift, AWS Athena, Amazon Kinesis, Amazon DynamoDB, and Amazon RDS  Deployed and optimized Amazon EMR clusters, achieving a reduction in data processing time and lowering infrastructure costs  Extracted data from various sources, perform data transformation and cleansing using AWS Glue, Python, and SQL, and load data into target data warehouses or data lakes  Automated infrastructure provisioning using Amazon CloudFormation, reducing deployment time and minimizing configuration errors Built and maintained data pipelines for data ingestion, transformation, and integration using AWS Glue, AWS EMR, Amazon Kinesis, and other appropriate tools  Developed and maintained continuous integration and continuous deployment (CI/CD) pipelines to ensure efficient and reliable deployment of data solutions  Identified and resolved issues related to data pipelines, database performance, and data quality, ensuring high reliability and efficiency of the data solutions  Optimized data pipelines, queries, and database configurations to achieve optimal performance and cost-efficiency by collaborating closely with data scientists and analysts to understand data Collaborated closely with data scientists and analysts to understand data pipelines Implemented monitoring and alerting using Amazon CloudWatch, proactively identifying and resolving performance bottlenecks in data pipelines

India

 Automated ETL workflows using AWS Step Functions, orchestrating complex data transformations across multiple services seamlessly Migrated on-premises data solutions to AWS, leading to enhanced scalability, cost savings, and improved overall performance Managed various database instances using Amazon RDS and Amazon DynamoDB, ensuring data availability, scalability, and reliable performance  Contributed to the design and implementation of data warehousing solutions using AWS Redshift, optimizing data storage and query performance for analytical workloads Worked on real-time data processing and streaming using AWS Kinesis, processing high-velocity data streams and making them available for immediate analysis Created and maintained data models and schemas, ensuring data consistency and accuracy within data repositories, and facilitating data access for reporting and analytics Implemented and enforced data security measures, including AWS Identity and Access Management (IAM) policies, encryption, and access controls, to protect sensitive data Developed automation scripts and workflows using AWS Step Functions or AWS Lambda, reducing manual interventions and improving data pipeline reliability Established robust monitoring and alerting systems for data pipelines, proactively identifying and addressing issues to minimize downtime and maintain data integrity Continuously optimized AWS infrastructure and data pipelines for cost-effectiveness, ensuring efficient resource utilization while meeting performance requirements