2012Sheridan College Brampton, ON
Diploma in Computer System Technician - Software Engineering
2010H.L. Institute of Comp. Ahmedabad, India
Bachelor in Computer Application
Microsoft Certified: Azure Fundamentals
Apr 2020Udemy Inc
AWS Certified Data Analytics Specialty 2020 (ex Big Data)
Mar 2020Udemy Inc
Informatica Cloud - Data Integration
Oct 2019Udemy Inc
Analyzing and Visualizing Data with Microsoft Power BI
May 2020 - PresentCI Financial
• Building and designing enterprise level Data Lake on AWS S3 • Designing and building technical architecture documents which helps developers and tester to develop and test data pipelines. • Working in agile environment and following best DevOps practices. • Using Jira board to track tasks and Bitbucket for code repository. Migration of Portfolio Statements Process to Cloud • Current project is to migrate monthly, quarterly, semi-annually and annually customer’s statement process to cloud. Existing process is taking months to generate and deliver statements to customer. Objective of this project is to process statement process much smoother and faster over the AWS cloud. • Converting existing stored procedure and SSIS jobs into PySpark scripts and utilizing spark’s big data features to run huge amount of data faster. • Storing data in parquet file format to compress huge data. • Writing ELTs and ETLs big data pipelines through Talend to automate data ingestion from different platform to Data Lake. • Writing AWS CloudFormation to build AWS architecture • Building transient EMR cluster on AWS and storing data in Hive with metadata on Glue Catalog and storage location in S3 • Integrating test SQL scripts in data pipelines to automate testing. • Developing scripts for QA to do cell by cell comparison to find any discrepancies in target system.
Sep 2019 - Apr 2020Great Canadian Gaming Corporation
Reporting Analytic Platform (IBM Cognos Analytic Services) Development • Managing and designing enterprise level Data Lake and Data Warehouse • Writing ETLs through Informatica to load data into Data Lake and then Data Warehouse. • Performing Data cleansing, transformation for better visualization. • Source system – MSSQL Server 2014 and Oracle 12c • Target System – SQL Server 2017 Enterprise Edition Operations Services • Writing ETLs through SSIS to automate daily routine tasks • Writing Python scripts for Data Analytics and visualization projects. • Identifying, designing and implementing process improvements including automating manual processes, optimizing data delivery and re-designing infrastructure for greater scalability • Developing and creating Power BI dashboards. • Assembling and manipulating large datasets
Jun 2018 - Sep 2019Advanced Utility System
ETL Data Conversion Specialist
At my current position as ETL Data Conversion Specialist at Advanced Utility System, once of my major responsibilities includes converting North American government client’s legacy data to AUS utility system.
Apr 2017 - May 2018Juice Worldwide
Data migration and Data conversion • Created and managed scripts for mapping legacy data from legacy database to new database • Wrote scripts to migrate and convert data from legacy system to new system • Wrote triggers and automated scripts to sync data between legacy and new system • Created legacy mapping DB to easily sync legacy and new system’s database. Database Administrator and analyst tasks (AWS RDS, Dynamo DB, MySQL, MSSQL) • Deployed MYSQL databases on Amazon RDS. • Managed multiple MySQL databases on Amazon RDS and MSSQL database. • Developed and maintained MYSQL (Application Database), MSSQL (SSRS Reporting Database), and MYSQL (SSRS Reporting Database). • Managed NoSQL data on Amazon Dynamo DB. • Setup backup, group policy and security on Amazon RDS account • Created development, staging and live database server • Created Stored Procedures, Triggers and Functions via Code Repositories (GitHub with Source tree). • Indexing database tables and improving performance of database.
Jun 2013 - Aug 2016Hipstreet
I had served as Database Administrator/Analyst for Kobian Canada Inc. from 2013 to 2016, where I was repeatedly recognized for developing innovative solutions, globally deployed software and systems. I was responsible for complete development life cycle including gathering requirements, analysis, designing, coding, deployment and maintenance. I was also conducting installation, configuration, upgrade and migration of data, as well as backup and recovery, database security, storage and monitoring the database server.
Feb 2013 - Apr 2013Jeds Construction
Web Developer and IT Support
Web development – www.jeds.ca • Designed, coded and modified website, from layout to function and according to requirements. • Regular maintenance of the website to ensure that information and linkages remain timely and accurate including the archiving of obsolete information and inputting of new/updated information. Migrated company infrastructure to MS windows server 2008 R2 • Migrated company infrastructure from windows 7 professional server to MS windows 2008 R2 server. • Installed, configured and setup server 2008 R2 with DNS. • Setup DHCP and company forest. Network Drive setup and permission for each users and groups • Migrated each work station to new server from old server • Daily on going IT support and Backup server installation