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
Sep 2018 - PresentGreat 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 2018Advanced 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