Yugandhara Email: ad31xg@r.postjobfree.com

BI/SQL Server/Power BI Developer Phone: 804-***-****

PROFESSIONAL SUMMARY:

* ***** ** ****** ********** in MS SQL Server with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T – SQL and Power BI and tableau.

Excellent in understanding Business Requirements, Functional Specifications and Technical Specifications.

Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.

Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard for monitoring and tuning MS SQL Server performance.

Knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.

Well-versed in usage of SSIS Control Flow items (Execute package/SQL tasks, Script task, For each loop, Sequence containers etc.) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Merge Join, Pivot etc.).

Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.

Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services.

Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.

Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using SSIS

Good understanding of Normalization /De-normalization, Normal Forms, and database design methodology. Skilled in design of logical and physical data modeling using Erwin data modeling tool.

Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.

Having very good Experience in Unit Testing, Integration Testing and End-to-End Functionality Testing.

Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.

Knowledge of Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.

Experience Configuring and maintaining Report Manager and Report Server for SSRS. Deployed and Scheduled the Reports in Report Manager.

Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, drill down reports using SQL Server Reporting Services (SSRS).

Experience on various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.

Experience on designing multiple scorecards and Utilized Power BI (Power Pivot/View dashboards to display information required by upper level management.

Knowledge of dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.

Knowledge and experience of Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.

Experience on Tableau reports, Implementation, Architecture design and dashboards.

Strong Experience in Power BI and data mining and cleaning and analyzing the data and create visualization report with the help of DAX function.

Experience on power bi desktop, power query, and power pivot, power view to create visualization report and data cleaning and data mining.

Experience on tableau to Analyzing data and creating report as per business requirement.

Experience on tableau to create data visualization report and dashboard, then data mining

And data cleaning.

TECHNICAL SKILLS

Operating Systems

Windows 2008, 2003, Advanced Server, Windows 95/98/2000 XP/Unix and Mac OS X.

Databases

MS SQL Server7.0/2000/2005/2008/2012/2014, Access97/2000/2003 and Oracle 11/10g/9i.

SQL Server Tools

Management Studio (SSMS), Business Intelligence Development

Studio (BIDS), Enterprise Manager, Query Analyzer, profiler,

Performance Monitor and Database Tuning Wizard.

ETL Tools

SSDT/BIDS-DTS, SQL Server Integration Services (SSIS) and SQL Server Reporting (SSRS).

Data Modeling

Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, ER Diagrams, MS Visio, Rational Rose, Erwin 4.5/4.0/3.5, Dimensional Data Modeling, Data Modeling, FACT and Dimensions Table Modeling.

Languages

T-SQL, HTML, XML, C, C++, C# and Java.

Packages

MS Office 2000/2003/2007

BI Tools

SSIS, SSAS, SSRS, Crystal Reports, Business Objects, Data Analysis Expressions (DAX) MS Excel Power Pivot, MDX, SharePoint, Performance point and Cognos.

Visual Tool

Power BI (power bi desktop, power query, power pivot, power view), Tableau,

PROFESSIONAL EXPERIENCE:

Client: J. M. Smucker, Orrville Ohio September 2022 - Current

Role: Sr.SQL Server/SSIS/SSRS/Power BI Developer

RESPONSIBILITIES:

Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.

Performed T-SQL tuning and optimization of queries that take longer execution time using MS SQL.

SQL Profiler and Database Engine Tuning Advisor.

Reverse engineered backend database to change the T-SQL scripts, create Views, Stored

Procedures, Triggers and Functions to improve performance drastically.

Experienced working in the Agile methodology.

Performed Data Modelling to know about the relationships between entities in a database.

Designed and developed SSIS packages to move data from production environment to different environments within the organization.

Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.

Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.

Extensively used SSIS for transferring data manually from DTS packages to SSIS packages using SSIS.

Developed and maintained a combined data store for reporting purposes.

Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports.

reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business

Requirements in time restricted environment using SQL Server Reporting Services (SSRS).

Created various types of performance reports from the TFS server database using SSRS.

Scheduled execution and delivery of end of the day report using SSRS.

Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.

Tested the reports and fixed bugs in the stored procedures.

Strong experience in Power BI Analyzes, map and data and create reports and dashboards as per business requirement.

Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure

Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.

Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.

Developed custom reports and deployed them on server using power BI.

Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and

Density charts.

Project Environment: Microsoft SQL Server 2014, 2017, 2019 SQL Server Azure, Visual Studio 2017, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, Business Intelligence Development Studio (BIDS), Share Point, Experian SQL server profiler, Team Foundation Server and Power BI.

Client: Abbott Point of Care, Princeton NJ May 2020 – June 2022

Role: Sr.SQL Server/SSIS/SSRS/Power BI Developer

RESPONSIBILITIES:

Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to Data ware House.

Designed and developed MS Access front end to support SQL Server backend.

Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, Data conversion etc. in SSIS for Data cleansing/ scrubbing.

Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.

Updated functional specification and technical design documents (store on SharePoint).

Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application Access.

Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.

Created SSIS package to load data from Flat/Excel Files to SQL Server 2008 R2/SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction,

Aggregate, Pivot Transformation, and Slowly Changing Dimension.

Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.

Business Intelligence package design. Created tables and performed data imports and restores for successful migration.

Developed Unit Test Plans for SSIS packages for checking the functionality of each component.

Modified the existing SSIS packages to meet the changes specified by the users/Requirement.

Scheduled Jobs for executing the stored SSIS packages which were developed to update the

database on Daily basis using SQL Server Agent.

Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including status.

Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights.

Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.

Experience in generating reports and deploying it in to the server using SSRS (SQL Server Reporting Services).

Developed and rendered monthly, weekly and Daily reports as per the requirement and gave roles, user access with respect to security in report manager.

Created simple query filters, prompted filters and complex filters to restrict data in reports.

Participated in the business requirement review discussions to understand the project scope.

Develop methodologies, system documentation as needed including user guides, flow charts, etc.

Involve in Database activities like Database Design and Data Modeling, Backup/Restore, Performance Monitoring, Tuning and Troubleshooting.

Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.

Strong Experience in Power BI and data mining and cleaning and analyzing the data and create visualization report with the help of DAX function.

Create and maintain Power BI reports and dashboards to provide insight and visualization for business users.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data source.

Project Environment: Microsoft SQL Server 2014, 2017, 2019 SQL Server Azure, Visual Studio 2017, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, Business Intelligence Development Studio (BIDS), Share Point, Experian SQL server profiler, Team Foundation Server

Client: Penn National Insurance, Harrisburg, PA Aug 2018 – April 2020

Role: SQL Server/SSIS/SSRS/Power BI Developer

RESPONSIBILITIES:

Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.

Experienced in database design process and data modeling process.

Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.

Designed SQL Server Database and Table Design with Schemas, Constraints and Views.

Extracted data from various sources like DB2, VSAM, SQL Server 2014/2012/2008 R2, .CSV,

Microsoft Excel and Text file from Client servers.

Analyzed business requirements and implemented data mart solutions for data mining and

Reporting.

Created SSIS packages which involved a variety of transformations such as Slowly Changing

Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.

Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server

2014/2012/2008 R2 Business Intelligence Development Studio.

Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.

Strong knowledge of Data Warehousing methodologies, concepts and implementation of star

Schemas, snowflakes schemas, facts & dimensions.

Developed reports with consistent drill-down functionality including Drilldown report and Summary report.

Ensured constraints and writing triggers/linked server scripts to apply the business rules.

Performance Tuning, Backing Up & Restoring User Databases.

Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

Strong Experience in Power BI and data mining and cleaning and analyzing the data and create visualization report with the help of DAX function.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data source.

Experience on Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.

Strong Experience in Power BI and data mining and cleaning and analyzing the data and create visualization report with the help of DAX function.

Project Environment: MS SQL Server 2014/2012/2008 R2, SSIS, SSRS, SSAS, SSMS, Visual Studio 2010,Import/Export tools, Power Designer tool, Power Designer Portal, T-SQL, Windows 2003 Server, MS TFS,JIRA.

Client: Fly9 Technologies Pvt. Ltd., Hyderabad, India March 2015 – July 2018

Role: Jr.SQL Server/SSIS/SSRS/Power BI Developer

RESPONSIBILITIES:

Participated in the business requirement review discussions to understand the project scope.

Involved in map out strategies for programs to support new and revised business requirements.

Worked with application developers and production teams across functional units to identify business needs and discuss solution options.

Develop methodologies, system documentation as needed including user guides, flow charts, etc.

Logically and physically designed database for projects on basis of user requirements using ERWIN.

Involved in the Data modeling, Physical and Logical Design of Database.

Creation, manipulation and supporting the SQL Server databases.

Used DDL and DML for writing triggers, stored procedures and data manipulation.

Created tables, indexes, sequences, constraints, triggers and procedures.

Involved in designing queries and store procedure, UDF and views in SQL Server management studio.

Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.

Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers (DDL & DML), Cursors and User Defined Functions (UDF).

Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.

Created documentation on the all the tables, stored procedures, views and user defined functions.

Transformed data from various data sources using OLE DB connection by creating various SSIS packages.

Created SSIS Packages for feed process to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.

Performed transformations like Conditional Split, Sorting and included data about the environment using the Audit Transformation.

Perform weekly database checkup, shrink database according to instructions, and document weekly database activities.

Generated Assessment Reports to analyze the Scope and Complexity of the migration projects.

Experience in generating reports and deploying it in to the server using SSRS (SQL Server Reporting Services).

Developed and rendered monthly, weekly and Daily reports as per the requirement and gave roles, user access with respect to security in report manager.

Created simple query filters, prompted filters and complex filters to restrict data in reports.

Assisted senior developers in creating project plans and progress reports.

Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

Experience on tableau to Analyzing data and creating report as per business requirement.

Experience on tableau to create data visualization report and dashboard, then data mining

And data cleaning.

Project Environment: MS SQL Server 2008 R2/ MS SQL Server 2012, MS Visio, Visual Studio 2010 SP1, SSRS 2008, SSIS 2008, T-SQL, VB Script, MS Access, Query Analyzer, BCP, SQL Profiler, Source Control System (TFS, VSTF), Windows 7, XML, C#.

ACADEMIC CREDENTIALS

Bachelor of engineering North Maharashtra University, India (CGPA - 7.92)

Contact this candidate