SUMMARY

• Around 8 years of IT experience as MS SQL Server Developer in Designing, Developing, Testing and Supporting database solutions using SQL Server 2017/2016/ 2014/2012/2008 environments.
• Experience creating Power BI reports and Dashboards using Power BI Desktop & Web Interface.
• Experience in using T - SQL for developing complex Stored Procedures, Tables, Views and User Defined Functions.
• Experience developing, analyzing and deploying Tabular Model cubes.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Experience in Migration of Data from multiple data sources like Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility.
• Extensive experience in MS SQL Server 2017/2016/ 2014/2012/2008 BI tools (SSDT) like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Experience working with BCP, DTS, SSIS packages and creating jobs for MS SQL Server.
• Experience in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experience in designing and developing number of enterprise reports (SSRS) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
• Experience in creating and deploying SSRS reports and Power View reports on the portal for user accessibility.
• Experience in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Experience in creating Cubes with dimensions and Facts Tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Experience in creating calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Good Knowledge with Data Modeling, Logical and Physical Database Design.
• Worked in all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Worked in collaborative team environment with developers, business analysts, and project management team.

TECHNICAL SKILLS

Databases: MS SQL Server 2017/2016/ 2014/2012/2008 R2/2008,2005, Oracle 10g.

Programming/Scripting Languages: T-SQL, PL/SQL, C#.NET.

Database Tools: Enterprises Manager, SQL Profiler, Performance Monitor, SQL Server Management Studio, Event Viewer, Database Engine Tuning Wizard, SQL Data Tools, BIDS 2017/2015/2012/2010/2008/2005, Management Studio, Analysis Services (SSAS), Visual Studio, Query Analyzer.

ETL Tools: MS Office Suite 2003/2007/2010, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Import/Export Wizard, Bulk Insert, BCP.

Reporting Tools: SQL Server Reporting Services (SSRS), Report Builder, Excel, Power Pivot and Power BI.

Applications: Confidential Office (Excel and PowerPivot), Team Foundation Services (TFS).

Operating System: Windows Server 2003/2008/2010.

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

MS SQL/Power BI Developer

Responsibilities:

• Involve in requirement gathering and design documents for developing the project.
• Create new database objects like tables, procedures, functions, indexes, and views using T-SQL in development and production environments.
• Work on creating mapping documents for data conversion from legacy to new model.
• Coordinate with front-end developers for implementing logic in stored procedures and functions for faster retrieval of data.
• Experience working with Azure SQL Database Import and Export Service.
• Involved in ETL (Extraction, Transformation and Loading) of data from legacy system to new model.
• Create SSIS packages to load robust data from heterogeneous data sources like Oracle, Flat files to SQL server.
• Use various SSIS transformations such as conditional split, data conversion task, derived column, Multicast, Merge join and Look Up that are used for data cleansing and validation before loading data into new tables.
• Configure and deployed SSIS packages from development, test to production environments.
• Schedule jobs to run on daily and weekly basis using SQL Server Agent.
• Develop multiple Tabular Model cubes using dimension and fact tables and creating relationship between them.
• Create measures and KPIs in tabular cubes.
• Implement row level security in tabular cubes.
• Create partitions and improve the performance of data retrieval from the cube and alongside decrease the refresh time for the cube.
• Deploy and maintain tabular cubes in production.
• Design Data Model in Power BI by importing Fact and Dimensional tables.
• Develop multiple Power BI reports using Desktop App and Tabular Cubes, SQL tables as data source.
• Responsible for creating SQL datasets forPowerBIreports.
• Refresh Power BI dashboard after every release with new data uploaded from Azure SQL DB.
• Use different visuals like Area charts, Bar & Column charts, Combo charts, doughnut charts, Funnel charts, Line Charts, Cards, Scatter and bubble charts and custom visuals in the reports to suit requirements.
• Create Dashboards on Power BI and share the same with the customers.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Work with Power BI Gateway to schedule daily job to refresh data.
• Use Team Foundation Server (TFS) for version control.

Environment: MSSQL Server 2017/2016/ 2014/2012/2008, Azure SQL DB, Power BI, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Data Tools, SQL Profiler, Windows 7, Team Foundation Server, GitHub, VS2017/2015.

Confidential, St. Louis, MO

SQL BI Developer/Data Analysis

Responsibilities:

• Gather business requirements from the users.
• Develop business and functional documents.
• Analyze utilization data to identify patterns and trends that may impact overall performance.
• Develop and implement a data quality strategy, which is focused on: analyzing core data to identify quality gaps, implementing a reporting process to track down data quality improvements over time.
• Develop and automate the data quality process between different systems.
• Set up Development, Test and Production environments.
• Perform deep data analysis - identify discrepancies in metrics, pattern & commonalities, and reporting.
• Develop monitors to compare data against different systems.
• Perform data mining activities of gathering and compiling data to make a thorough analysis and to extract relevant information.
• Create SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Use various advanced SSIS functionalities like complex joins, conditional splitting, and column conversions for better performance during package execution.
• Work closely with the PM & Development teams to create and test the mappings to load the data from heterogeneous sources to the data warehouse.
• Work with users to analyze current business processes and procedures to help identify gaps and areas for process improvement.
• Develop ETL pipelines to pull the data from different sources and stage it.
• Develop Tabular Model Cubes by identify dimensions & facts.
• Create the measures and KPIs.
• Deploy the cube to production and provide maintenance along with security.
• Design, develop and deploy reports in MS SQL server environment using SSRS.
• Generate Sub-reports, Drill-Down, Drill - Through and Parameterized reports using SSRS.
• Maintain all the source code in the GIT. Help team member while pushing their code changes using GIT.
• Create reports to retrieve data using stored procedures that accept parameters.
• Schedule the monthly/weekly/daily reports to run automatically onto the dashboard.
• Responsible for monitoring and tuning SSRS Report Performance.

Environment: MSSQL Server (SSMS) 2014, 2012, 2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), T-SQL, Query Analyzer, JIRA, GitHub, VS2015/2012.

Confidential 

MSBI Developer

Responsibilities:

• Design and develop database objects like, Tables, Views, Stored procedures and Functions.
• Work with users to analyze current business processes and procedures to help identify gaps and areas for process improvement.
• Design and develop SSIS packages to load the data form Tabular cubes into SQL databases.
• Create complex ETL packages to pull the data from source like SQL/Excel/Flat files, use transformations and load it into SQL Database.
• Optimize SSIS packages for better performance.
• Apply various data transformations like Slowly changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split and Derived column.
• Download the files from the FTP servers and import the data into databases using Import/Export wizard.
• Fine tune SQL queries for maximum efficiency and performance.
• Design and develop multiple Tabular Model Cubes by identify dimension & facts.
• Develop ETL pipeline to load the data into dimension and fact tables & schedule them as SQL jobs.
• Create measures and KPIs using DAX.
• Implement security by creating roles and adding necessary Security Groups.
• Involve in the development and maintenance of different cubes using SSAS.
• Create calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Provide documentation for all kinds of reports, DTS and SSIS packages.
• Deploy cube to production and provide maintenance.
• Create monthly score cards and send it out to higher management.
• Develop multiple SSRS reports like drill through, drill down, linked and sub reports.
• Create Power Pivot Data Models and develop Power views and host on the SharePoint.
• Schedule Daily & Weekly jobs in SQL Server Agent.

Environment: MS SQL Server 2014/2012/2008, SSRS, SSAS, SSIS, T-SQL, Windows 2012/2008 Advanced Server, TFS, BCP.