Ketankumar Patel Email & Phone Number

Irvin, Taxas

• Built a centralized Data Lake on AWS Cloud leveraging primary services such as S3, EMR, Redshift, and Athena to enable seamless data ingestion and processing
• Created data pipelines for different events to load the data from DynamoDB to the AWS S3bucket and then into the HDFS location, using PySpark for efficient data processing
• Developed PySpark jobs to pull data from third-party and native data sources and dump data into AWS S3 for analytics and reporting purposes, after required transformations using best compression techniques, creating.
• Loaded data into S3 buckets using AWS Glue and PySpark, filtered data stored in S3 buckets using Elasticsearch, and loaded data into Hive external tables
• Used AWS EMR to transform and move large amounts of data into and out of other AWS data stores and databases, such as Amazon S3 and DynamoDB, running Hadoop/Spark jobs on AWS EMR
• Designed and developed a Security Framework to provide fine-grained access to objects in AWS S3 using AWS Lambda and DynamoDB

Philadelphia, Pennsylvania, United States

• Created, owned, and drove an ongoing, end-to-end product roadmap by working with business areas to identify, sequence, and prioritize enhancement request. Ensured alignment of product features and stories and led UAT.
• Extensively worked with various data transformation techniques in SSIS by creating SQL scripts as well as C# scripts (Script Component Task), various data transformations and data flow tasks.
• Implemented Complex logic and used Partitioned Tables functionality for huge volumes of data.
• Wrote Complex PL SQL scripts to get data out of Oracle for Reporting purpose and load that into SQL Server Reporting Data warehouse.
• Designed dimensional model for SSAS Cube source database. Created SQL Views to implement Star schema.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Charlotte, North Carolina, United States

• Developed/Monitored ETL packages with different data sources (SQL Server, Flat Files, Excel files, etc) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Responsible for successfully deploying SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent and Scheduled Jobs to automate.
• Proficient in Data migration between homogeneous/heterogeneous systems and SQL Server using SSIS, BULK INSERT, DTS Import/Export utility, and BCP.
• Responsible for creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports, Charts using SQL Server Reporting Services.
• Created email subscriptions for data driven reports by using Report Manager.
• Responsible for migrating the DTS packages into SSIS.