SUMMARY

• Highly motivated SQL Server/BI Developer with Around 7 Years of IT Experience in Database and Business Intelligence Technologies with expertise in SQL Server Development and Reporting using SQL Server, SSRS, and SSIS.
• I have Proficiency in Confidential Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), and MS SQL Server Reporting Services (SSRS).
• Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User - defined data types and functions, Cursors, and Indexes using T-SQL.
• Extensively worked on Table Design, creating Clustered Indexes, Non-Clustered Indexes, Primary key, Foreign Key Relationships, Highly complex joins, and SQL Scripts for Views and Materialized Views.
• Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, and Snow-Flake Modeling.
• Highly proficient in packages to extract, transform, and load data (ETL) using SSIS, designed packages are utilized for tasks and transformations Data Conversion and Pivot tables.
• I have efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, cleaning bad data, validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, RecordSet Destination of the integration services (SSIS).
• Experience in debugging the SSIS packages using breakpoints and checkpoints.
• I am an Expert in generating on-demand and scheduled reports for business analysis or management decisions using SSRS, Power BI, and Tableau.
• I have Strong experience in developing parameterized, Sub Reports, Matrix Reports, Charts, Drill down, Drill Through reports, using SQL Server Reporting Services (SSRS), and Tableau.
• Excellent knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services (SSAS).
• I am skilled in Power BI and Tableau Desktop for data visualization, Reporting, Analysis, Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Proficient in Design and Development of various dashboards, reports utilizing Tableau Visualizations like bar Graphs, scatter plots, pie-charts, geographic visualization, and other making use of actions, other local and Global filters according to the end-user requirement.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration, and Disaster Recovery.

TECHNICAL SKILLS

Operating Systems: Windows 2010, 2008, 2007; Server, Windows NT, Unix.

RDBMS: MSSQL SERVER 2019/2017/2016/2014/2012/2008R2

BI TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), ETL, Tableau, Self BI with Excel, Power BI.

Languages: T-SQL, Dynamic SQL, C, C++, Java.

Database Query Tools: SQL Server Management Studio (SSMS), Visual Studio 2019/2017/2015/2013, Business Intelligence Development Studio (BIDS), SQL Profiler, Toad, DQS.

PROFESSIONAL EXPERIENCE

Confidential, South Carolina

SSRS Developer

Responsibilities:

• I Developed simple and complex reports using MS SSRS against the SQL Server database.
• Developed the reports, which further gets converted into Official Court Management documents in our .net application.
• Acted as a liaison between the customer Subject Matter Expert's (SMEs) and our functional and technical leads to gather requirements, translate them into developed code, and align them with our existing Court Management System (CMS).
• As I am working at Client Site, I must Communicate with the client, and offsite team, managing scope, schedule, and quality of SSRS reports that will run from within our .Net application of court management system.
• I Created new views, functions, and stored procedures, and modified existing ones for the client's requirements.
• I also created some parameterized MS-Word templates which can be directly get uploaded into our .net application.
• I developed and fixed bugs and deployed them into the reporting server by checking in the code into TFS and releasing the code to appropriate environments.
• Created Drilldown reports, Matrix reports by giving complicated grouping.
• I worked on fixing some complex datasets having SQL code; each report had its datasets so that I had to understand the functionality of those reports from BA.
• Developed and bug fixed parameterized stored procedures development within MS SQL Server.
• I worked on the bug fixes of some very complex SQL queries.
• Worked on the performance issues and tuned the SQL Query and the datasets, shortened some queries to meet the performance requirement.
• Worked on the timeout issues and increased the time limit.
• I worked on the other output rendering formats like Word, Excel, etc., to keep consistent output formats with the PDF version.
• Handled the production issues on reports as fast as possible to keep clients happy.

Environment: Confidential SQL Server SSRS, SSAS, SSIS 2017, Confidential Visual Studio 2017, T-SQL, MySQL, PL/SQL, MS Visio 2008, SharePoint 2010, Tableau, Power BI, Windows Server, Reports Builder, Power Map, Power Pivot, Power View, MS Office.

Confidential

SQL Server and Power BI Developer

Responsibilities:

• Developed custom reports and deployed them on the server using Power BI.
• Designed ad-hoc reports in excel power pivot and shared them using Power BI to the decision-makers for strategic planning.
• Perform Preventive maintenance activities like causal analysis, restructuring program codes, data problem resolution, and performance tuning.
• I Understood the existing ETL and relational database framework and Scheduled Packages using SQL Server Agent Jobs.
• I Migrated the given MS-Access code into SQL Code manually.
• I Created some views as per the client's requirements.
• I Created PowerShell Scripts to get updated into the appropriate tables' views with just one click.
• Using SQL tables and views as a data source, I created various Dashboards and Reports in Power BI.
• I worked with different business users to adopt the data visualization - Power BI in the Organization and get insights from the data.
• I Involved in performance tuning using SQL Server Profiler and SQL server hints.
• I worked on Identifying the slow-running MS-Access reports and came up with the performance improvements, and migrated into Power BI Dashboards and Reports.
• I have generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to the report server using Power BI.
• I created some web links internally using Power BI, which shows the up-to-date data as Dashboards and Reports in the Browser.
• Deployed and scheduled reports using Power BI to generate all daily, weekly, monthly, and quarterly reports, including status.
• Interacted with Business analysts about the product and understood the logic behind it.
• Store all source code in the Team Foundation Server (TFS) and update development status in the TFS timely.

Environment: Confidential SQL Server SSRS, SSAS, SSIS 2017, Confidential Visual Studio 2017, T-SQL, MySQL, PL/SQL, MS Visio 2008, SharePoint 2010, Tableau, Power BI, Windows Server, Reports Builder, Power Map, Power Pivot, Power View, MS Office.

Confidential

SQL MSBI Developer

Responsibilities:

• Interacted with a team of business analysts, data architects, application developers, and testers. Created SSIS packages to extract data from various sources, including SQL Server, Excel, Flat file, CSV, transformed the data and loaded it into the target data warehouse.
• I have created SSIS packages for importing the Excel layouts into the database using SSIS.
• I Used MS Visual Studio to design SSIS packages to transfer data between servers, load data into the database, and archived data files from different DBMS. I Scheduled the job to do this task periodically.
• I Loaded data from ODS to the data warehouse using SSIS packages.
• Used Tableau Desktop to design interactive reports and data visualization.
• I Developed Tableau reports and dashboards from multiple data sources using data blending.
• I Used multidimensional models such as star schemas and snowflake schema for developing cubes.
• I designed and developed Matrix, tabular and parametric reports using SSRS.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly, and quarterly reports, including status.
• I wrote new stored procedures for the new system and optimized old store procedures and functions on the production server. I improved data load performance by analyzing database design and query plans.
• I Modified and created joins to improve the database and execution speed.
• I optimized the database by creating various clustered, non-clustered indexes, and indexed views.
• I am an expert in data visualization using Tableau to create complex, intuitive, and innovative dashboards.
• I Involved in performance tuning using SQL Server Profiler and SQL server hints.
• I Created SSIS packages using SSIS Designer for exporting heterogeneous data from OLE DB Source and Excel spreadsheet to SQL Server.
• 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.
• I Created Complex ETL Packages using SSIS, which upsets data from staging table to database tables.
• Developed scenarios for Unit, Integration testing to ensure that all the components work when integrated.

Environment: Confidential SQL Server SSRS, SSAS, SSIS 2017, Confidential Visual Studio 2017, T-SQL, MySQL, PL/SQL, MS Visio 2008, SharePoint 2010, Tableau, Power BI, Windows Server, Reports Builder, Power Map, Power Pivot, Power View, MS Office.

Confidential, North America, OH

Developer

Responsibilities:

• I was involved in the complete Agile software development process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
• Interacted with a team of business analysts, data architects, application developers, and testers. Created SSIS packages to extract data from various sources, including SQL Server, Excel, Flat file, CSV, transformed the data and loaded it into the target data warehouse.
• I worked with different business users to adopt the data visualization - Tableau in the Organization and get insights from the data.
• Experience in creating SQL data models/Queries for Tableau and Ad-hoc Reports.
• I developed Tableau reports & useful dashboards after gathering and translating end-user requirements.
• Experience in writing stored procedures and functions on numerous SQL server.
• I have extensively used different transformations, i.e., looping, data formatting, checkpoints, error handling, email notification in SSIS packages.
• I designed SSIS packages to transfer the data from flat files, Access database, and excel documents to the Staging Area in SQL Server.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups, and Implemented Event Handlers and Error Handling in SSIS packages.
• I was Responsible for building reports in Tableau from Scratch.
• I was Responsible for creating and changing the visualizations in Tableau reports and Dashboards on client requests.
• I used to connect different data sources like SQL DB (SQL Query), Tabular Model (DAX Query), Web Trends to Tableau and generate reports with different visualizations.
• I have created reports by using Joins in multiple tables from multiples databases using complex SQL queries.
• Design and Develop SSAS Tabular cubes to satisfy the end-user reports by creating different reports and Dashboards in Tableau.
• I worked on Identifying the slow running ad-hoc reports and came up with the performance improvements.

Environment: SQL Server Integration Services (SSIS), Server Reporting Services (SSRS), MS Visual Studio 2015, SSAS (Tabular), SQL Server Management Studio 2016, Tableau, MS SharePoint, GIT Hub.

Denso International, MI

SQL Server

Responsibilities:

• I worked on Extracting Transforming and Loading (ETL) data from Excel, Flat-file to MS SQL Server by using SSIS and DTS services.
• I designed, Developed, and tested packages to extract, transform, and load data using SQL Server Integration Services (SSIS).
• Developed advanced ETL import packages using SSIS, T-SQL to transform and import raw index data into database tables.
• I Developed SSIS packages to migrate data to the staging server and then to the production server.
• Processed data from flat excel files, .csv files into proprietary hierarchical data structure system through SSIS packages and custom procedures.
• I have created various reports like parameterized reports, cascading reports, ad-hoc reports, and dynamic reports using SQL Server Reporting Services (SSRS) and Tableau.
• I have generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to the report server using SSRS and Tableau.
• I Added new facts and dimensions to the data warehouse.
• Reviewed cube changes and documented according to the requirement based on product valuation and revenue opportunities.
• I have developed cubes by defining data sources and data source views and using SQL Server Analysis Services (SSAS).
• I have cooperated with other teams and business analysts to achieve efficient database access and for processing applications. Includes designing, adding, eliminating, or maintaining indexes, organizing tables, and recommending SQL scripts to application development teams.

Environment: MS Visual Studio 2012, SQL Server Management Studio, SSRS, Tableau, SSAS(Tabular), SQL Server Integration Services (SSIS), AZURE, MS SharePoint, IIS 7.5/7.0/6.0, Visual Source Safe (VSS), Team Foundation Server (TFS), GIT Hub.

Confidential

SQL Developer

Responsibilities:

• I was Involved in Planning, Defining, and Designing data based on business requirements and provided documentation.
• Perform database development that includes Schema development, Stored Procedures that could be used by different Windows Services.
• Used SSIS variables, parameters, & expressions to implement dynamicity of Master ETL Package, connection managers, tasks, containers, Send Mail, Row Count, Script tasks, etc.
• I have Created various MSBI(SSIS) packages using data transformations like Merge, Aggregate, Sort, Multicasting, Lookup, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, the transformation of XML based on XSD File Experience with designing the ETL process, including data read/write, data transformations, error handling, process design, logging, and Development.
• Creation of ETL packages to load data from files into the database by performing different kinds of transformations using SSIS
• I was involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Involved in Development & amp; Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Creating SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data, etc.
• I have experienced Data Extraction, Transforming, and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Extensive reporting skills using SQL Server Reporting (SSRS).
• I Performed unit and system testing, troubleshooting, and bug fixing in Development and QA environments.
• I worked on TFS for performing tasks.

Environment: Windows Server 2012 Operating System, MS SQL Server 2012, SQL Server Data Tools for Visual Studio 2015 (SSIS), SSRS, TFS, FTP, SharePoint, MS Visio, MS Excel 2010

Confidential

SQL Server Developer

Responsibilities:

• I was Created and maintained database objects, complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL joins, and other statements for various applications.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving—multiple tables & calculations from different databases.
• I filtered bad data from the legacy system using complex T-SQL statements and implemented various constraints and triggers for data consistency.
• I have used various SSIS tasks such as Conditional Split, Script Component Task, Derived Column, lookup used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data Warehouse.
• I have created clustered and non-clustered indexes on tables for new databases to faster retrieve data for the Reports.
• I used Bulking techniques, Table partitioning, to increase database performance.
• Consistently worked and communicated with CMS (Center for Medicare & Medicaid) to ensure data received met the company expectations.
• Wrote complex expressions and calculations for SSRS reports with Conditional Formatting.
• Responsible for the design and deployment of the report using SSRS and MS Excel.
• I have created Ad Hoc reports by building models in Report Builder using SQL 2008 Model Designer and Report Builder.

Environment: SQL Server 2008, T-SQL, BIDS, SSRS, SSIS, SSAS, Crystal Reports, MS Excel, Erwin, SharePoint.