Sql Server Business Intelligence

Dhana Laxmi

BI Developer

Email: *****.********@*****.***

Ph #: 908-***-****

PROFESSIONAL SUMMARY:

6+ years of experience in IT with Database applications and Business Intelligence Design & development, and Data Analysis in Production, Development, Testing and Staging Environments.

Expertise in MS SQL Server 2016/2014, MSBI products like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

Experience in building the pipelines to copy the data from source to destination in Azure Data Factory (ADF)

Experience in creating the Linked Services on the source and as well for the destination servers.

Experience in creating Data Factories in Azure Data Factory (ADF)

Experience on creating reports using GoogleBigquery

Experience developing reports (interactive or paginated) and dashboards in Power BI.

Experience with Microsoft Power Platform (Power BI, Power Apps, Power Automate)

Experience in Data Extraction, Transforming and Loading (ETL) from multiple sources like Excel, MS Access, XML, Oracle and DB2 to MS SQL Server using SQL Server Integration Services (SSIS).

Experience in designing, developing, deploying and scheduling ETL solutions using SQL Server SSIS packages involving various control flow items like Loops, Bulk Inserts, Incremental Loads, FTP and Emails Alerts.

Experience in providing Logging, Error handling by using Event Handler.

Good experience with SSRS through deploying reports, creating report schedules and subscriptions, managing and securing reports.

Good knowledge of Python for scripting, data handling, and basic automation tasks.

Basic hands-on knowledge of AI/ML frameworks such as PyTorch, TensorFlow, and Huggingface Transformers.

Familiarity with transformer models, vector embeddings, and concepts like Retrieval-Augmented Generation (RAG).

Experience in PowerApps applications & BI development using the Microsoft power platform.

Experience in developing application using PowerApps, canvas, model driven app, SharePoint online.

Familiar with data modeling, data preparation, and data visualization.

Skilled in SQL Server Reporting Services (SSRS 2014/2012) in generating complex reports in cascaded reports, parameterized reports and Ad-Hoc reports.

Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions (UDF’s), Cursors and Indexes using T-SQL.

Expertise in creating/modifying Tables, Views, Stored Procedures, User Defined Functions (UDFs), Joins, Indexes, Triggers and Cursors scripting in T-SQL.

Expertise in creating, scheduling, monitoring, maintaining old and new SQL jobs, using SQL Server Job Agent.

Expertise in defining the business process flow and gathering business requirements.

Experience working in Agile and Waterfall methodologies in SDLC

Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2016/2012.

Good team player and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

Databases

MS SQL server 2016/2012/2008, My SQL

Programming Languages

SQL, T-SQL

BI Tools

MSBI

ETL Tools

BIDS/SSDT, SSIS, SSAS, SSRS.

OLAP/Reporting Tools

MS SQL Server Reporting Services 2016/2012/2008, SSRS, MS Excel, Tableau, Power BI.

SQL Server Tools

SSMS, Query Analyzer, SQL server profiler, SQL Server Agent.

Data Modeling Tools

Visual Studio 2010, Microsoft Visio, Business Intelligence Development Studio (BIDS).

Other Tools

MS Office, MS Excel, MS Project, MS PowerPoint and MS Visio

Operating Systems

Windows 10/8/7/XP/Vista, MS-DOS, UNIX, LINUX.

Web Development

HTML, XML, Microsoft.NET framework, Visual Studio.

Education:

Masters of Business Administration (MBA)

PROFESSIONAL EXPERIENCE:

Client: OEC, Richfield, OH Nov 2020 – Till date

Role: BI Developer

Responsibilities:

Met with business users, gathered business requirements and prepared the documentation for requirement analysis.

Develop and deploy dashboards, visualizations and autonomous and dynamic reports using various technologies.

Provided training to the business users on how to use new data warehouse, browsing cubes from Excel and assisted them in rewriting their existing queries to point to the new warehouse.

Created centralized data warehouse (ODS) and developed de-normalized structures based on the requirements and to improve the query performance for end users.

Developed reports (interactive or paginated) and dashboards in Power BI.

Developed applications in PowerApps using Common Data Services CDS, Flow, Excel, SharePoint online.

Generated reports from Pull data from client databases using SQL scripts.

Created ETL design specifications, performed unit testing, data validations, integration testing and UAT and deployed SSIS packages to development and test environments.

Building the pipelines to copy the data from source to destination in Azure Data Factory (ADF)

Creating the Linked Services on the source and as well for the destination servers.

Creating Data Factories in Azure Data Factory (ADF)

Scheduling jobs on flows and ADF Pipelines.

Creating reports using GoogleBigquery.

Moving CSV files from Azure blob to Azure SQL Server.

Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Teradata, Excel and Oracle to SQL Server using Business Intelligence Development Studio (BIDS).

Writing various T-SQL queries, Stored Procedures and used them to build packages.

Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using Microsoft SQL Server 2008 reporting services.

Assists in creation of easy-to-use Power BI datasets and supports end users with analytical activities.

Created and maintained SSRS reports for External Reporting and Internal Activity Based Costing (ABC) for shipments tracking. Outstanding knowledge in creating drill down reports, Graphical reports, ad-hoc reports and drill through

Created dashboards and custom reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Developed several drill down and drill through reports using SSRS as needed by clients.

Used Joins, sub-queries, Stored Procedures, Indexes, and Views for involving multiple tables from different databases

to integrate the data as business requirements

Client: DSW, Columbus, OH June 2018 – Nov 2020

Role: BI Developer

Responsibilities:

Met with business users, gathered business requirements and prepared the documentation for requirement analysis.

Provided training to the business users on how to use new data warehouse, browsing cubes from Excel and assisted them in rewriting their existing queries to point to the new warehouse.

Created centralized data warehouse (ODS) and developed de-normalized structures based on the requirements and to improve the query performance for end users.

Created ETL design specifications, performed unit testing, data validations, integration testing and UAT and deployed SSIS packages to development and test environments.

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.

Used data quality services (DQS) to cleanse the data, remove duplicates and improve the quality. Created domains in DQS and exported the activity results into SQL tables.

Did debugging using break points and data viewers and performance tuning of ETL data flows.

Created various SSIS packages to populate the data from flat files, Excel and Access into ODS (SQL Server). Performed full loads for current data and incremental uploads for historical data (transaction-based data).

Created and configured SSIS package configurations using sql server table and environment variables and loaded data from XML, Flat files and SQL Server incrementally.

Designed and developed STAR schema and multidimensional (OLAP) objects. Created cubes and populated the data using SSIS packages.

Knowledge on OLAP Cubes (Star Schema) using SQL Server 2014 Analysis Services and Performance tuning MDX and dimensions design and scaling to large numbers of users.

Worked with T-SQL to create tables, stored procedures and user defined functions for complex business logic.

Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.

Environment: SQL Server 2016, SSMS, SSIS, SSRS, Power View, Power Pivot, MDX, Report Builder 4.0, Team Foundation Server, MS Visio, Outlook, T-SQL, Windows Server 2012, Windows.

Client: Tennova Healthcare, La Follette, TN March 2017 – May 2018

Role: SQL Developer/ MSBI Developer

Responsibilities:

Installed SQL Server 2014 and Management tools using SQL Server Setup Program and upgraded existing databases from SQL Server 2012.

Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to load the shipping and customer data.

Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Teradata, Excel and Oracle to SQL Server using Business Intelligence Development Studio (BIDS).

Writing various T-SQL queries, Stored Procedures and used them to build packages.

Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using Microsoft SQL Server 2008 reporting services.

Created and maintained SSRS reports for External Reporting and Internal Activity Based Costing (ABC) for shipments tracking. Outstanding knowledge in creating drill down reports, Graphical reports, ad-hoc reports and drill through reports using the ROLAP/MOLAP as sources.

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.

Worked in agile methodology, participated in daily scrum meetings.

Environment: Agile, SQL Server 2014, SSIS, SSAS, SSRS, Power BI, Oracle, MDX, MS Office 2007, T-SQL, Windows Server 2008.

Contact this candidate