SUMMARY

• Over 6 (Six) years of MS SQL Server Development experience in different domains with expertise as MS SQL Server BI Developer suite of products like SSIS, SSAS, SSRS and Power BI.
• Experience in creating and developing different types of reports using SQL Server Reporting Services and Power BI and migration of Data from Excel
• Experience in developing reports on Power BI and Tableau using SQL Server (2014/2016/2017 ) and SSAS.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experienced in writing complex T - SQL queries to select data from SQL SERVER.
• Experienced in developing SSIS packages for ETL tasks and deploy SSIS package to SQL SERVER catalog. Set up sql agent jobs to run SSIS packages automatically.
• Strong knowledge of Data Warehousing Concepts and Data Modelling Techniques in Dimensional Data Modeling, including Star Schema Modeling and Snow-Flake Schema Modeling.
• Configured Azure migration and Disaster recovery in test environment.
• Extensively worked on various features of Power BI like Reports, Charts, Filters, Sub-Reports, Drilldown, and Drill-Through, Multi-valued parameters etc.
• Good understanding of Normalization /De-normalization and database design methodology.
• Experience in SQL performance tuning and optimization by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Performing Admin activities on Tableau Server. Involved in writing MDX Scripts for the OLAP CUBES.
• Creating SSAS tabular model using DAX queries.
• Interacted with business users for the conversion of Business functional requirements and development along with testing and production deployment.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Experienced in automate SSIS ETL packages jobs with Azure Data Factory
• Experienced in Azure Data Lake
• Experienced in running Pyspark with Azure Data Brick

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer/BI Developer

Responsibilities:

• Design and build stored procedures as per the business requirement documents to get data from SQL SERVER database.
• Optimize the stored procedures to improve performance by reduce running time.
• Trouble shoot stored procedures to find out the cause of defects and fix defects.
• Design and created SSRS reports using SSRS report builder and visual studio to show data generated from stored procedures and in views.
• Troubles shoot SSRS reports to find out the causes of defects and fix defects.
• Extracted, transformed and loaded data from various sources such as flat files and transactional database into dimension tables (e.g. Customer, Product, Employee) and the fact table in the dimensional data warehouse.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Optimize the database by creating various clustered and non-clustered indexes and indexed views.
• Trouble shoot database to find out mismatches between database and business files.
• Developed and rendered monthly, weekly and daily reports with the data from the dimensional database with SSRS as per the requirement and gave roles, user access with respect to security in Report Manager.
• Problem identification, troubleshooting. Developed and optimize T-SQL Statements by doing performance tuning, Data masking.
• Actively involved in Design, Build, Test and Deploy HCM reports and Inbound/Outbound Integration solutions for the Customers.
• Configured, built, deployed different reports in PDF, Excel, flat file formats according to the business requirement using SQL Server 2014 Reporting Services.
• Developed reports where the data extracted from SSAS cubes in SSRS.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications. Creating Power BI reports using different visualization to analyze trends.
• Expert in data visualization development using Tableau and Power BI to create complex, intuitive and innovative dashboards.
• Involved in performance tuning using SQL Server Profiler and SQL server hints.
• Created SSIS packages using SSIS Designer for exporting heterogeneous data from OLEDB Source, Flat files and Excel spreadsheet to SQL Server 2014.
• Designed ETL packages dealing with different data sources (SQL Server, flat files, and XMLs, etc.) and loaded the data into target data sources by performing various kinds of transformations using SSIS.
• Implemented PowerShell scripts for creation of User, contacts & for Bulk modifications in Active Directory.

Environment: Microsoft SQL Server 2014, SSRS, SSAS, SSIS, T-SQL, SSMS, SharePoint, Tableau, Power BI, MS Office, Microsoft Visual C, Power Pivot, Power View, Tableau Studio, Reports Builder. Azure

Confidential, Fairfield, CT

SQL Developer/BI Developer

Responsibilities:

• Build dimensional data warehouse including dimension tables and fact tables. Build SSIS package for ETL process and SSAS model for analysis. Build database objects following standards and specifications (e.g. Tables, Views, Stored Procedure, Triggers and Indexes)
• Extracted, transformed and loaded data from various sources such as flat files and transactional database into dimension tables (e.g. Customer, Product, Employee) and the fact table in the dimensional data warehouse.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Extensively used joins and sub - queries involving multiple tables from different tables in the dimensional warehouse such as the customer table, the product table, the employee table and the fact table.
• Optimize the database by creating various clustered and non-clustered indexes and indexed views.
• Set up SSAS tabular model and create necessary objects such as relationship, hierarchy, roles and measurements for analysis.
• Developed and rendered monthly, weekly and daily reports with the data from the dimensional database using Power BI and tableau as per the requirement and gave roles, user access with respect to security in Report Manager.
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu using SSRS.
• Problem identification, troubleshooting. Developed and optimize T-SQL Statements by doing performance tuning, Data masking.
• Actively involved in Design, Build, Test and Deploy HCM reports and Inbound/Outbound Integration solutions for the Customers.
• Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot) Reports, Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-down reports and ad-hoc reports using SSRS
• Configured, built, deployed different reports in PDF, Excel, TFI formats according to the business requirement using SQL Server 2016 Reporting Services.
• Developed reports where the data extracted from SSAS cubes in SSRS.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications. Creating Power BI reports using different visualization to analyze trends.
• Expert in data visualization development using Tableau and Power BI to create complex, intuitive and innovative dashboards.
• Involved in performance tuning using SQL Server Profiler and SQL server hints.
• Created SSIS packages using SSIS Designer for exporting heterogeneous data from OLEDB Source, Flat files and Excel spreadsheet to SQL Server 2016.
• Designed ETL packages dealing with different data sources (SQL Server, flat files, and XMLs, etc.) and loaded the data into target data sources by performing various kinds of transformations using SSIS.
• Implemented PowerShell scripts for creation of User, contacts & for Bulk modifications in Active Directory.

Environment: Power BI, Microsoft SQL Server SSRS, SSAS, SSIS, T-SQL, MySQL, PL/SQL, MS Visio, SharePoint, Tableau, Power BI, MS Office, Microsoft Visual C#, Windows Server, Power Map, Power Pivot, Power View, Tableau Studio, Reports Builder. Azure

Confidential, Philadelphia, PA

BI Developer/Data Analyst

Responsibilities:

• Created complex ETL packages to load the data from transactional database to destination tables in dimensional data warehouse using transformation like Execute SQL Task, For Each Loop, Variables, Derived Column, Expressions, File System Task, Look Up, and Data Profiling Task and so on.
• Created ETL packages to load the data from various sources into the dimensional data warehouse and notify users on success and log errors on failure and send the message to the users for failure using visual studio and SSMS.
• Created automatic jobs using SQL Serve Job Agent to automatically execute the ETL package to load the data from the latest source every day, have a script task to loop through different folder within the latest folder, transform them, assign the batch number and loads them to the final table
• Report Creation and configuration changes using PowerShell for Online and on premise
• Developed multiple SQL Server stored procedures as per the requirement and provided for UI.
• Created SSIS packages for importing the Excel layouts and flat files such as text files and csv files into the database using SSIS.
• Executing PowerShell reports as per the user’s requirement
• Created Interactive Dashboards and Scheduling Extracts, Workbooks and Data sources on Tableau Server and Power BI server.
• Involved in creating azure app service and publishing the project to app service
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Developed Power BI reports and dashboards from multiple data sources using data blending.
• Involved in combining all the data sources into one and build Tableau dashboards based on the requirements from the users.
• Used SSIS script tasks, look up transformations and data flow tasks using T-SQL, C# and Visual Basic scripts.
• Created views and Stored Procedures for generating report.
• Responsible for creating the reports based on the requirements using SSRS.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using Power BI.
• Install, support and customize licensed SQL Server software and related tools.
• Provide technical recommendations involving the SQL Server environments and tools upon request.
• Designed and developed matrix, tabular and parametric reports using SSRS 2012.
• Designed and developed drill down and drill through reports with drop down menu option using SSRS.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Build new SQL Server subsystem environments or relocate existing SQL Server subsystem environments upon request.
• Data Analysis from Upstream and converting into Hyperion Model

Environment: Microsoft SQL Server SSRS, Azure, AWS, SSAS, SSIS, T-SQL, MS Visio, SharePoint, Tableau, Power BI, C#, Windows, Power Map, Power Pivot, Power View, MS Office, Microsoft Visual Studio.

Confidential, Somerset NJ

SQL Server BI Developer

Responsibilities:

• Working extensively in Power BI report, creating tabular model is SSAS, creating data model for Power BI Report, Validating data quality of the report.
• Built SQL query and other database objects such as stored procedure to extra data from database to build SSAS tabular models.
• Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.
• Review reporting outputs for transparency, consistency, and accuracy.
• Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created SQL Joins, sub-queries and other SQL code to implement business rules. Experienced in PowerShell on working with Exchange servers.
• Strong experience on Deploying Resources Using Azure Resource Manager Template
• Worked with the use of Data Modeling Standards for all projects requiring a standard means of defining and analyzing data within an organization, to manage data as a resource, for the integration of information systems, for designing Databases/Data Warehouses.
• Upgrade SQL Server subsystem environments to newly released versions.
• Work with technical support teams to identify SQL Server software related problems.
• Perform daily system admin type tasks in support of the SQL Server subsystem environments
• Work closely with Operations and Automation teams in defining operational procedures involving the SQL Server subsystems.
• Data Analysis from Upstream and converting into Hyperion Model
• Provide timely resolution to SQL Server software related problems.

Environment: MS SQL Server, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL, Microsoft Office, OLAP

Confidential

SQL Server /Data Analyst

Responsibilities:

• Responsibility of looking out for timely deliverables of various project requirements. Responsible for checking out the Cleaning/tabulation and editing programs.
• Collaborating with team members to achieve the project goals. Maintaining quality and productivity standards for all the projects assigned.
• Process/check the research data (survey Weighting, data cleaning, data merging, data format conversion) using various tools and procedures.
• Confirm the types of deliverables for a particular project and deciding on the resources required for completing the same.
• Create tabulation program and produce analyzable data tables with T-SQL on the back end according the deliverables requirements.
• Generate data analysis reports using Python, SPSS and R.
• Collaborating with team members to achieve the project goals. Maintaining quality and productivity standards for all the projects assigned.
• Suggesting more better and innovative ways (tools and processes) for executing jobs.

Environment: Python, R, SPSS, MS Excel, SQL SERVER, T-SQL, Pyspark, Azure DataBrick

Confidential

SQL Server Developer / Data Analyst

Responsibilities:

• Created views, stored procedures and user-defined functions and Triggers to enforce data and referential integrity and created Check Constraints, Unique constraints, Relational key constraints and cascading deletes
• Created T-SQL scripts for tuning and scheduling and created complex T-SQL for data extraction
• Performed data conversions from flat files into a normalized database structure and configured Server for sending automatic mails to the respective people when a DTS process failure or success
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Performed development support, document reviews, test plan, integration of the system

Environment: SQL Server, Microsoft Visual Studio T-SQL,