Data Analyst, Data Engineer,ETLdeveloper, SQL developer, MSBI Developer, PowerBi Develope

Summary

5+ years of experience in Data Modeling, Database Design, Programming, Development, and Implementation
of Client-Server Applications & Database systems using SQL Server 2008/2008R2/2012/2014/ 2016/2019.
Implemented Azure Application Insights to store user activities and error logging.
Hands on experience with BI stack tools like SQL Server Integration Services, SQL Server Analysis Services
and SQL Server Reporting Services and Power BI.
Conversant with all phases of the Software Development Life Cycle (SDLC) especially Agile, Scrum, involving
business process analysis, requirements gathering and analysis, detailed design, development, testing and
post implementation support.
Excellent understanding of PL-SQL/T-SQL (DDL and DML), SQL Server Integration Services(SSIS), SQL Server
Analysis Services(SSAS), SQL Server Reporting Services(SSRS).
Experienced in Extract, Transform and Load (ETL) processes using MS-SSIS, DTS application tools.
The project also involved enhancing data quality checks, designing schema for data storage, and optimizing
data processing performance by leveraging tools such as Apache Spark and parallel processing capabilities of
Python.
Experience in generating Drill Down and Drill through reports with Drop down menu option, Sorting the
data, defining Subtotals in SSRS.
Experienced in data migrating between different homogeneous/heterogeneous systems and SQL Server as a
part of Data Migration and Data Maintenance.
Experience in creating custom specific and efficient SQL server Reports using SSRS 2012/2008R2.
Experienced in creating and using Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins
for complex queries involving multiple tables and Exception Handlers.
Proficient in performing database activities like Data Modeling, Data Staging, Data cleansing etc.
Experienced in designing Dashboards with various data Visualizationstools like Microsoft Power BI.
Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, Star
Schema modeling foreign key concepts and referential integrity.
Experience in Power BI Designer with Power Pivot for Excel, Power View for data visualization and used DAX
for use in calculated columnsfor reports and analysis purposes.
Experience in Extracting, loading data to and from sources like OLEDB, Excel, Flat files etc. using SSIS.
Created SSIS packages with Error handling, notifications, and Package configurations.
Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a
part of Data Migration and Data Maintenance.
Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports and
distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Businessintelligence
development studio (BIDS).
Working experience of designing Ad-hoc reports for higher managers using report model, providing them
flexibility to create reports using drag and drop functionality.
Developed Cubes using SQL server Analysis Services (SSAS) and Experience in Developing and Extending
OLAP Cubes, Dimensions, and data source views.
Good experience in creating OLAP cubes using SQL Server analysis services (SSAS)