Sid Dar Email & Phone Number

Pembroke, Hamilton, BM

• Involved in developing and designing Dashboards using Power BI to show KPI in the project.
• According to client requirements, generated reports like Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Developed and rendered monthly, weekly and Daily reports as per the requirement and gaveRoles, user access with respect to security in report manager.
• Created OLAP cubes, facts and dimensions for the analysis of sales in different locations andProcess data from data mart using SSAS.
• Involved in building the dimensions, cubes with star schema and snow flake schema using SSAS.
• Developed Tabular Model infrastructure in SSAS for various Lines of Business and createdOver different interactive Dashboards using various visualizations in Power BI Desktop.

• Defined source data columns and its respective mapping with target based in consultation with data modeler and application developers.
• Identified data quality and data cleansing tasks based on review of data and data model.
• Created stored procedures, views and user defined functions using T-SQL to insert data in target databases.
• Designed SSIS flow to pull source data into staging to perform data quality and cleansing before pushing into target database using SSIS 2012.
• Created SSIS packages for loading and transferring data using Sequence Containers, Execute SQL Task with T-SQL Stored Procedures and Data flow task in Control flow.
• Applied various transformations in data flow tasks like Conditional split, Lookup, Row count, Merge, Merge join, Union, Audit etc. and performed unit testing.

Raleigh, North Carolina, US

• Analyzed the specifications provided by the client and gathered the requirements for design and development Designed, developed and deployed Business Intelligence solutions using SSIS and SSRS
• Wrote complex SQL queries using Joins and Sub queries and Functions to retrieve data from data sources.
• Extracted data from internal data warehouse system to SSRS Designed and configured SSIS packages to migrate the important data from Oracle, legacy System using various transformations.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Created packages with different Control Flow options and Data Flow Transformations such as Conditional Split, Multicast, Pivot, Union All etc.
• Scheduled and monitored the SQL Server Agent jobs to run the SSIS packages and stored procedures.

• Analyzed & designed the business rules for data cleansing that are required by the OLAP and OLTP databases. Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, flat file, Text Format Data.
• Designed High-level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports of each quarter onto the Report Server to access it through a browser.
• Created various geographical and time dimension reports for the fiscal year, quarter month, week and daily reports for all domains and published through Report Server.

IN

• Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL code in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.
• Worked with DDL, DML, and DQL in T-SQL using CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, FROM, WHERE, ORDER BY, and GROUP BY.
• Responsible for the quick response of SQL statement and connectivity from front application to the database servers.
• Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data.
• Created SSIS packages to populate data from various data sources.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.