SUMMARY:

• Having 5+ years of IT experience as Microsoft SQL Server developer implementing SSIS and SSRS using Microsoft Business Intelligence development studio (MSBI), SQL Server data tools (SSDT) and Power BI, Tableau.
• Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server, customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Extensive hands - on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All.
• Experience in Creating packages, Jobs, Sending Alerts using SQL Mail.
• Expertise in enhancing and deploying the SSIS Packages from development server to production server, Error handling, Debugging and logging for production support in SSIS, performed day to day DBA operations , managed users and security , Performance Tuning, Query Optimization
• Strong Knowledge in dimensional Star Schema and Snowflakes Schema.
• Expertise in creating cubes with dimensions and facts tables in Warehouse using SQL Server Analysis Services (SSAS).
• Created partitions in SSAS cube to process the measures incrementally.
• Deployed SSAS cube on to analysis services server and scheduled it to process from SSIS packages.
• Extensive experience in developing reports and deploying reports in SSRS using Report Wizard, Report Builder and Report Manager.
• Experience in designing report with rich UI including Tabular forms, Matrix (Cross /tab Report) form, Drill down, Parameter, Cascading parameters, Charts and Sub Reports.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
• Having Expertise knowledge in Teradata and has good exposure on other databases like SQL Server, DB2.
• Involved in Unit Testing the data and worked with QA team to resolve the defects.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Used almost all the visualizations like Charts, Line charts, Pie charts, Maps, Slicers, Tiles, Cards, Images, Tables, Power View, Power Maps, Multiples Visualizations, Bubble and scatter charts, Key performance indicators (KPIs)
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2014/2016, Azure SQL DB

Operating Systems: Windows 7 & 10

Languages: T SQL, SQL, C# Business

Intelligence Tools: SQL Server Integration Services (SSIS), Azure Data Factory (ADF), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Power BI Desktop, Tableau Desktop

WEB Design: HTML with CSS

PROFESSIONAL EXPERIENCE:

SQL BI/Power BI/Tableau Developer

Confidential, Herndon, Virginia

Responsibilities:

• Imported data from SQL Server DB, Azure SQL DB to Power BI/Tableau to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Developed complex queries using Microsoft SQL server 2008, 2012, 2017.
• Developed and deployed SQL stored procedures, SSIS packages, and scripts to work with data
• Designed, developed and tested various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• Used almost all the visualizations like Charts, Line charts, Pie charts, Maps, Slicers, Tiles, Cards, Images, Tables, Power View, Power Maps, Multiples Visualizations, Bubble and scatter charts, Key performance indicators (KPIs)
• As a Power BI and Tableau SME responsible for the design, development and production support of interactive data visualizations used across the company.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Hierarchies, sets, combined sets and Groups in Tableau.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.
• Worked on creating few Tableau dashboard reports, Heat map charts and supported numerous dashboards, pie charts and heat map charts that were built on Teradata database.
• Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
• Involved in defining referenced relationships with the measure groups and fact tables.
• Created SSAS cubes using different types of facts and dimensions.
• Extensively used star schema for SSAS Cube development.
• Handled SSAS Cube security by creating roles and Perspectives to restrict the access to the content.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS).
• Created Azure Blob Storage for Import/Export data to/from .CSV File.
• Worked on Azure Data Factory to move data from SQL Server DB to Azure SQL DB.
• Involved in development of Azure Data Factory Pipelines, linked services, data sets, deploy and monitor them also Scheduled jobs and alerts using ADF Triggers.
• Created an ADF pipeline to pull data from various sources to Azure Blob Storage, Scheduling/enabling triggers for the ADF Pipelines developed.
• Azure Storage development and design utilizing Blobs, Tables, Queues, Files.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures.
• Shared dashboards to end users through office 365, content packs and workspaces.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI.

Environment: MS SQL Server 2016, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2016, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT), Power BI, Teradata SQL Assistant, Tableau Desktop 9.x.

SQL/SSIS/BI Developer

Confidential, Irving, Texas

Responsibilities:

• Designed and created databases, DB Objects based on the business requirements.
• Involved in creation of new database, planning the location of data, index and transaction log files on the disks.
• Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Involve in create table-valued functions.
• Used joins and sub queries to simplify complex queries involving multiple tables.
• Provided technical support to move databases from development to test and production for multiple applications.
• Migrated SQL Server 2012 to SQL Server 2016
• Backed up databases using Full, Differential and Transactional log backup methods
• Populating Fast Load and Multi Load tables using different data load and unload utilities of Teradata.
• Created tables, views in Teradata, according to the requirements.
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Created SSIS packages to transfer XML file data into SQL server database.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view
• Improved performance of SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Worked with SQL server profiler to generate traces.
• Writing the stored procedures, checking the code for efficiency, Routine backups and restoration.
• Used SQL server business Intelligence Development Studio to designs SSIS packages to transfer data between servers and deploy the data. Scheduled the job to do this task periodically.
• Performed day to day DBA operations , managed users and security , worked on performance & tunings as well as capacity planning activities.
• Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Designed ETL packages dealing with different data sources (SQL Server and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Deploying and scheduling reports using SSRS to generate all daily, weekly, and monthly and Quarterly Reports including status.
• Involved in creating report datasets and using stored procedure parameters in SSRS.

Environment: MS SQL Server 2012, SSIS/SSAS/SSRS, T-SQL, SQL DBA, Visual Studio 2010, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT).

SQL Developer/SSIS Developer

Confidential

Responsibilities:

• Involved in performing server installation and configuration of SQL Server 2012.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Performed maintenance of Stored Procedures to improve Performance of different front-end applications.
• Installed, Configured, and Administered SQL Server 2016/2012/2008.
• Involved Migration includes side by side to MS SQL Server 2008/R2/2012/2014 and SQL Server 2008/R2 to SQL 2012/2014.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Produced Metrics for reporting to Senior Management. Used Extract, Transform, Load, (ETL) Concepts to Transform Data into MS Access database to produce reports in MS Excel.
• Developed numerous reports off OLTP Servers using Reporting Services by writing T-SQL queries, stored Procedures with parameters, charts and multiple datasets.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Created reports with different features like drill through capabilities, jump to another report, use of pie-charts and bar-charts, usage of Tablix, use of filtering conditions.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and email them to director and analysts to review in Excel Sheet, also prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2012 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2008 to SQL server 2012 and implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Created MDX queries, processed facts, dimensions and populated data through Analysis Services (SSAS) for the front-end users.
• Designed new Aggregations by creating Hierarchies and then pre- calculating the Aggregations using Aggregation Wizard in SSAS.
• Created calculated measures in a cube by using MDX scripting and worked on slowly changing dimensions.
• Experienced in performed partitioning of cubes as well as cube optimization to increase the performance of cubes in SSAS.

Environment: MS SQL Server 2012, SQL Server Management Studio, SQL Server Query Analyzer, T-SQL, MS-Access, SSAS, SSIS, SSRS, OLAP, OLTP, MDX, ETL, Erwin, MS Visual Source Safe.

SQL Developer/SSIS Developer

Confidential

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2012, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Designed and implemented the Logical and Physical model of the database using Erwin.
• Planed, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Installed and maintained MS SQL Server 2008R2 and monitored performance and optimized SQL queries for maximum efficiency.
• Created Custom ETL packages using SSIS and develops and unit test SSIS load processes for performance check.
• Created and scheduled SQL jobs to run SSIS packages daily also involved in usage of various SSIS components and features like For loop, For Each loop, Lookup Transformation, Variables, Error Handling and Package Configurations.
• Developed Query for generating drill down reports in SSRS.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports also performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Maintained the consistency of the client’s Database using DBCC.

Environment: MS SQL Server 2012, MS Access, Query Analyzer, DTS, SQL ProfilerImport & Export Data, Windows 2000 Server.