Sachin Kumar Email & Phone Number

Toronto, Ontario, Canada

• Work on AWS Data pipeline to configure data loads from S3 to into Redshift.• Create Tables, Stored Procedures, and extracted data using T-SQL for business users whenever required.• Perform data analysis and design, and creates and maintains large, complex logical and physical data models, and metadata repositories using ERWIN and MB MDR• Use AWS Redshift, extracted, transformed and loaded data from various heterogeneous data sources and destinations.• Assist service developers in finding relevant content in the existing reference models.• Use Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by AWS Data Pipeline.• Design and Develop ETL Processes in AWS Glue to migrate Campaign data from external sources like S3, ORC/Parquet/Text Files into AWS Redshift.• Designed and built Spark/PySpark based ETL pipelines for migration of credit card transactions, account, and customer data into enterprise Hadoop Data Lake. Developed strategies in handling large datasets using partitions, Spark SQL, broadcast joins and performance tuning.• Utilize Spark SQL API in PySpark to extract and load data and perform SQL queries.• Work on developing PySpark script to encrypting the raw data by using hashing algorithms concepts on client specified columns.• Involve in design, development, and testing of the database and Developed Stored Procedures, Views, and Triggers.• Develop Python-based API (RESTful Web Service) to track revenue and perform revenue analysis.• Compile and validate data from all departments and Presenting to Director Operation.• Use KPI calculator Sheet and maintain that sheet within SharePoint.

Burlington, Ontario, Canada

• Created Tableau reports with complex calculations and worked on Ad-hoc reporting using PowerBI.• Created data model that correlates all the metrics and gives a valuable output.• Worked on the tuning of SQL Queries to bring down run time by working on Indexes and Execution Plan.• Performed ETL testing activities like running the Jobs, Extracting the data using necessary queries from database transform, and upload into the Data warehouse servers.• Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics.• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities• Involved in Data Migration using SQL, SQL Azure, Azure Storage, and Azure Data Factory, SSIS, PowerShell.• Architected & implemented medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks, NoSQL DB).• Migrated of on-premise data (Oracle/ SQL Server/ DB2/ MongoDB) to Azure Data Lake and Stored (ADLS) using Azure Data Factory (ADF V1/V2).• Developed a detailed project plan and helped manage the data conversion migration from the legacy system to the target snowflake database.• Involved in Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.• Designed, developed, and tested dimensional data models using Star and Snowflake schema methodologies under the Kimball method.