• Streamlined 20+ ETL processes with Pentaho Data Integration to deliver client resources promptly• Produced reports and analytics for end users to analyze data using Pentaho Report Designer• Developed advanced SQL and JavaScript scripts with DbVisualizer and Pentaho to provide valuable insights and analytics for Nasdaq's exchange businesses• Collaborated with stakeholders to design and develop new data products, ensuring the technical architecture of product deliverables aligned with client’s business requirements• Managed Nasdaq's internal web-app to maintain automation of ETL flows, leveraging core market systems for maximum efficiency.

• Developed Apache Spark applications in Python (PySpark) on distributed environment to convert ORC files to parquet format and loaded to Redshift cluster for building reports and dashboards used for insights by the business analytics team• Automated ETL workflows to process millions of rows of data from external databases to AWS S3 buckets using Apache Nifi• Constructed SQL queries for data ingestion into AWS Redshift consisting of millions of rows utilized by business users to create dashboards for business insights• Improved efficiency of Amazon Redshift database by building and deploying DDL scripts to create and alter existing database objects• Maintained data integrity by implementing suitable constraints to ensure accurate and consistent data in the database.