Having 4+ years of experience in IT working as Database Engineer, ETL Developer and Report Developer• Experienced in resource planning, coding, debugging, testing, deployment, support and maintenance of business applications using MS SQL Server 2012/2014/2016/2019, SQL Server Integrated System, SQL Server Analysis Services and SQL Server Reporting Services.• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.• Expertise in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using MS SQL Server 2016/2019/2012/2014.• Have rich experience in creating Indexes in observing Business Rules and creating Effective Functions.• Experience in data profiling and generating Database ER Diagrams.• Rich experience in Microsoft Azure Cloud Computing• Expertise in T-SQL Scripts to Create Schemas, Tables and Views for the Centralized Data Warehouse. • Worked on designing Tables, SSIS Packages, Stored Procedures, Functions and Views to deliver snapshots of Report data every once in month to the respective Business user's team. • Experienced in resource planning, coding, debugging, testing, deployment, support and maintenance of business applications using MS SQL Server 2012/2014/2016/2019, SQL Server Integrated System, SQL- Server Analysis Services and SQL Server Reporting Services.• Using Import/Export Wizard to generate SSIS packages that migrates data from various sources to a Staging database. • Very proficient in working with large Databases -Oracle, and Azure Synapse• Implement 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).• Extensive knowledge in Agile Scrum and Agile Kanban.• Generated Power BI Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Power BI reports. Created reports in Power BI preview portal.
-
Data Warehousing And Reporting / Bi Etl DeveloperDeloitte Mar 2021 - Mar 2023Canada~Involved in Analysis, Planning and Defining data based on business requirements and provided documentation.~Developed ETL Packages using SQL Server 2014 Integration services to populate data from different sources like flat files/CSV Files to the staging databases.~The packages created included a variety of transformations like Look up, Aggregate, Derived column, Conditional split, Multicast, Execute SQL Task, Term Extraction, Data Conversion etc.~Designed and normalized the databases, have written T-SQL Queries and created different objects like Tables, Views, Stored Procedures, User defined functions and Indexes.~Experience in executing an Azure Data Factory pipeline by manually and by using a trigger~Created Azure Data Storage accounts within the ADF (Azure Data Factory) for storing the big data inside the cloud~Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports~Developed Custom calculated measures using DAX in Power BI to satisfy business needs~Preparing SSIS Package Models to extract data from the source systems and load it into the new Data warehouse~Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.~Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for generating reports using Tableau. -
Sql Bi Developer (Sql, Ssis, Ssrs, Ssas, Power Bi)Cvent India Pvt Limited Jan 2019 - Mar 2021India~Involved in the requirements analysis, design and development phase of Waterfall SDLC model.~Migrated data from Heterogeneous Data Sources (Access, Excel) to centralized SQL Server database using SQL Server Integration Services to overcome transformation constraints.~Migrated packages from development server to production server using package configuration.~Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.~Created dynamic reports using SSRS for the Windows category managers and rest of the customer base to view the reports at various desired levels, generated report models using report builder for the end users.~Create packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing primarily Excel data sources~Developed User Defined Functions, indexes to generate the distinct data based on the type of the region, release and version of the data released
Nikhil S Education Details
-
Sri Indu Institute Of Engineering & TechnologyComputer Science
Frequently Asked Questions about Nikhil S
What is Nikhil S's role at the current company?
Nikhil S's current role is MSBI Developer | Data Engineer | SQL Developer | ETL Developer | Data Warehouse Analyst.
What schools did Nikhil S attend?
Nikhil S attended Sri Indu Institute Of Engineering & Technology.
Not the Nikhil S you were looking for?
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