Over 5 years of experience designing, developing and maintaining Relational Databases in Microsoft SQL Server. Designed and implemented business intelligence solutions. Expert understanding of Azure Data Lake Storage, Azure Data Factory, Azure Data Bricks, Synapse analytics, PowerBI and other related Microsoft Tools including the newly developed Microsoft Fabric umbrella of tools. Extensive experience in programming tasks like Stored procedures, functions and triggers, adhoc querying from the cloud database, TSQL batches, PL/SQL packages and procedures, PowerShell scripts. Experienced in using on-prem solutions like SSMS and Microsoft Power BI products like SSIS, SSAS, SSRS and the implementation of ETL(Extract Transform Load) methodology. Extensive experience in implementing copy activity, dataflow, Triggers in Azure Data Factory pipeline for cloud ETL processing. Experienced in designing and developing ETL processes for data from external sources like Azure Blob Storage, Azure Data Lake Gen 2 and file formats including CSV, JSON, Parquet, ORC files into Azure Data Warehouse and Lakehouse architectures, further analyzing them with Synapse analytics. Experienced in Database development, modeling, data warehousing, design and technical management.Proficient in MSBI ( Microsoft Business Intelligence, ETL Data Warehouse, OLTP and OLAP using SQL Server Integration services and analysis services. Experienced in database operations like normalization, stored procedures, constraints, querying, joins for data collections, indexing, triggers and cursors etc. Experienced in data migration using tools like Bulk Insert and DTEXEC. Proficient in creating SSIS procedures for ETL and Business Intelligence process for Data Integration and Migration services.Successfully supported day-to-day operations and conducted thorough auditing of databases for user transactions, database actions and the removal of inactive users. Crafted SSIS solutions for ETL and Business Intelligence processes, adhering to the Ralph Kimball Methodologies for efficient ETL processing.
-
Sql DeveloperArtis Fs Ltd Sep 2017 - Sep 2019London Area, United Kingdom•Worked primarily on SQL server development and the creation of normalized databases, their optimization, and the automation of SQL server processes using Jobs.•Used SSIS and SSRS extensively and created scripts in SSIS to transport data. Worked on SQL Server Integration Services (SSIS) to integrate data from several types of homogenous and heterogenous information sources in multiple formats such as CSV, Excel, Oracle DB and SQL.•Created documentation for Self-service deployment and execution of SSIS packages. Experienced in creating SSIS packages with error handling using control flow and data flow elements.•Worked on SSIS packages to extract, transform and load data using different transformations such as Lookup, condition split, aggregate, pivot transformation, derived columns, slowly changing dimension, merge join and union all.•Migrated DTS packages from SQL Server 2005 to SQL Server 2012 as SSIS packages. Developed custom logging to notify when new rows are inserted using a custom logging table.•Worked closely with the Business Analysts to understand the functional requirements of the project, and converted business requirements into technical specifications.•Used T-SQL to create and modify various stored procedures used in the application.•Designed and developed dynamic advanced T-SQL, PL/SQL, DAX query, stored procedures, XML, user defined functions, parameters, tables, views, triggers, indexes, constraints, SSIS packages, SSAS cubes, SQL server agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications.•Took care of the maintenance activities on a regular basis using SQL Server Agent in SSMS.•Environment used: SQL Server 2012/2016, Windows Server, SSIS, SSRS, SSAS and TFS.
Prem Kumar Education Details
Frequently Asked Questions about Prem Kumar
What is Prem Kumar's role at the current company?
Prem Kumar's current role is Data Engineer.
What schools did Prem Kumar attend?
Prem Kumar attended Centennial College.
Not the Prem Kumar you were looking for?
-
Prem Kumar
Seasoned Sales And Customer Service Professional With An In-Depth Understanding Of Sales Cycle ProcessBrampton, On -
Prem Kumar
Toronto, On -
-
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial