Power Bi Sql Server
Resume:
Sanjay Krishna K
SQL Developer/Data Analyst
+1-214-***-**** / ********.********@*****.***
Professional summary:
Over 5+ years of extensive experience in database design, development, and administration with MS SQL Server versions 2019/2017/2016/2014/2012 using SSIS ETL.
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.
Hands on experience in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to assist efficient data manipulation and data consistency.
Hands on Experience in using tools like SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.
Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions and features.
Expertise in writing SQL Queries, Dynamics, sub-queries, and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Indexes, Views, and Cursors.
Proposes and implements technology solutions using SQL Server, SQL Server Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), Tableau and Power BI.
Expertise in designing and developing dynamic Dashboards with live tiles reporting real-time streaming data, trend based KPIs, summary and detail reports featuring actions, sorting, expressions, SVG visuals, drill down, drill through etc. in Power BI and Tableau
Highly experienced in whole cycle of DTS/SQL server integration services (SSIS, SSAS, SSRS, Power BI, QlikView, and Tableau) Packages (Developing, Deploying, Scheduling, Troubleshooting, and monitoring) for performing Data transfers and ETL Purposes across different servers Business Analysis.
Expert in Developing and Extending MSBI SQL Cubes, Dimensions and data source view MSBI SQL-Data Mining Models and Deploying and Processing MSBI SQL object.
Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SQL Server Analysis Services (SSAS).
Experience in creating MDX query in SSAS cubes for various calculated members, KPI and various actions such as drill through, reporting etc.
Experience in Migrating Data from an older version to newer version of MS SQL Server.
Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, dual charts, geographical maps, Gantt charts.
Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
Excellent knowledge & experienced in creating databases, tables, stored procedures, DDL/DML Triggers, Views, User defined datatypes, effective functions, cursors, and indexes using T-SQL.
Expert in Creating and developing Power Bi Dashboards in to rich Look.
Experience on Microsoft BI products Power Bi and reporting services.
Expertise in resolving SQL Reporting services (SSRS) and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, OLAP and Sub reports in Business Intelligence Development Studio.
Highly Skillful in working with the Microsoft Power BI Services and Microsoft Azure.
Very good T-SQL Programming skills. Experience in query optimization & performance tuning used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
Highly experienced in whole cycle of DTS/SQL server integration services (SSIS, SSAS, SSRS, Power BI, QlikView, and Tableau) Packages (Developing, Deploying, Scheduling, Troubleshooting, and monitoring) for performing Data transfers and ETL Purposes across different servers Business Analysis.
Good Experience with PowerShell scripts using Azure Cloud modules to automate the resource creation under resource group.
Worked on Azure logic Apps to integrate Power BI and pass the data into Steaming Dataset using Power BI POST API.
Experienced in creating interactive dashboards and scorecards utilizing Power BI.
Hands on experience in MS Power BI desktop and Power BI service.
Hands on Experience in Data Migration from MS SQL Server to Oracle ERP Systems.
Strong team player with great verbal, written communication, and interpersonal skills.
Technical Skills:
Data Warehousing & BI
SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS), Azure SQL.
Reporting Tools
SSRS 2019/2017/2016/2014, Excel, Tableau, Power BI.
Database
MS SQL Server 2016/2014, Oracle, MS-ACCESS.
Programming
C, C++, TSQL, DAX, MDX
IT Processes
Software Development Life Cycle (SDLC), Project Management
Productivity Applications
MS Word, MS Excel, MS Access, MS Project, Visio
Operating System
Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.
Aws Application Servers
Microsoft IIS 6.0/5.0/4.0, Apache.
Developer Tools
Informatica Power Center, Informatica IDQ, SSIS, Cognos Analytics, SSMS
Work Experience:
Client: Bryan Health, Lincoln, NE Jan 2024 – Till Date
Role: SQL Server /Power BI Developer
Responsibilities:
Created Power BI reports to provide metrics in pursuance of the supply chain data analytics implementation using the DAX, power query and SQL queries.
Expertise in writing complex DAX functions in Power BI and Power Pivot.
Work on SSIS performance tuning using counters, error handling, event handling, and re-running of failed SSIS packages using checkpoints.
Worked as application Developer for BI system based in MSBI, Tableau & Power BI technologies, which focus on client reporting needs.
Used Python for data analysis and data visualization as well as worked on different libraries like NumPy, metaplot, seaborn, pandas.
Analyze and present data to help the company make important decisions by performing DAX queries using Power BI tools.
Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
Created calculated columns and measures using DAX queries in Power BI based on report requirements.
Troubleshooting within SQL codes, SSIS Packages, and SSRS as required. Work as a collaborative team member using software development life cycles (SDLC) including analysis of business functions, design, development, testing, and documentation as required by end-users.
Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
Enhancing and deploying the SSIS packages from the development server to the production server and scheduled jobs for executing the stored SSIS packages which were developed to update the database daily/Weekly/Monthly basis.
Worked with Azure Data-bricks for ETL solutions using SQL I Extracted, Transformed, loaded humongous amount of data, and analyzed the data using data-bricks.
Used Spotfire to transform, pivot data before building Data Visualizations and Wrote back data from TIBCO Spotfire to implement security.
Performed data analysis along with building reports &, deploying into Power BI Service.
Sharing of Power BI reports and managing workspaces in Power BI service.
Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
Worked on Tableau and Power BI to create visualization reports from both relational and multi-dimensional data as source.
Increased the speed and performance of Excel reports by around 40% by restructuring Power BI.
Utilized Power BI gateway to keep dashboards and reports up to date with on-premise data sources.
Created stored procedures for generating reports using SQL Server Reporting Services (SSRS), Crystal Reports. Good command in generating on demand and scheduled reports for business Analysis and Management decisions using SSRS 2016/2014/2012/2008.
Worked on Jira tool for Process Management & People Management: Collaboration, working in an Agile team, Client management, Problem, and change management, worked as the Business analyst as well for some time in an assignment.
Environment: SQL Server 2016, ETL, SSIS, T-SQL, Power BI Gateway, Power BI Service, DAX, Python, Tableau, Excel, Microsoft Power BI, SQL, No-SQL, Server Data Tools (SSDT)
Client: Lincoln Financial · Radnor, PA July 2022 – Jan 2024
Role: ETL/SQL Developer
Responsibilities:
Responsible for the design and development of a Sales Data Warehouse project leveraging the Informatica Power Centre ETL tool, Teradata database, and Micro Strategy reporting tool.
Worked on Informatica Power Centre tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
Parsed high-level design specifications to simple ETL coding and mapping standards.
Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
Involved in multiple projects where data files upload to SharePoint, ODS loading, data mart and SSAS cubes/Tabular and then reporting using Tableau/Power BI.
Designed and customized data models for Data warehouse supporting data from multiple sources in real-time
Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
Imported various Sources of data and created Targets and Transformations using Informatica Power Centre Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
Extracted the data from the flat files and other RDBMS databases into the staging area and populated into the Data warehouse.
Involved in multiple projects where data files upload to SharePoint, ODS loading, data mart and SSAS cubes/Tabular and then reporting using Tableau/Power BI.
Developed complex mappings using corresponding Sources, Targets, and Transformations like update strategy, lookup, stored procedure, SQL, sequence generator, joiner, aggregate and expression transformations in extracting data in compliance with the business logic.
Performed data cleansing and transformation using Informatica. Design mappings to populate data from source system files to the data warehouse.
Maintained stored definitions, transformation rules, and target definitions using Informatica Repository Manager.
Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer, and scheduling of the workflow.
Involved in multiple projects where data files upload to SharePoint, ODS loading, data mart and SSAS cubes/Tabular and then reporting using Tableau/Power BI.
Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
Knowledge on Teradata Utility scripts like Fast Load, and Multiload to load data from various source systems to Teradata. Creating BTEQ (Basic Teradata Query) scripts to generate Keys.
Experience in Batch scripting on Windows.
Developed SQL mortgage reports using SSRS. Developed optimal stored procedures and queries to create data sets for reports. Designed Drill through Ad-hoc Reports.
Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from flat files, excel files and SQL server database.
Experience in creating complex SSIS packages using proper control and data flow elements.
Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2016.
Created ad-hoc reports, drill down, and drill through reports using SSRS.
Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive web-based reports.
Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Extensively used TSQL to manipulate and architect to produce results for users.
Environment: MS SQL Server 2014/2016, SSRS, T-SQL, SSIS, C#, MS Access 2010, Power BI, Tableau, DAX, SQL Server Management Studio (SSMS), SharePoint, ASG-Zena, IBM Cognos, SQL, Python.
Client: BNP Paribas, India June 2020 -Dec 2021
Role: SQL Server Developer
Responsibilities:
Created complex SQL stored procedures using Microsoft SQL Server 2014 and 2012
Developed SSIS ETL packages using data warehouse architecture model by creating fact table’s
role playing and conformed dimensions.
Developed SQL queries to fetch complex data using Inner/Outer joins, sub queries, CTE, Tally tables accommodating complex filters and database links.
Strong Data Modelling experience using dimensional data modelling, star schema modelling, snow-flake modelling using tools like Erwin.
Experience in developing reports using SSRS 2014 and SSRS 2016.
Created SSIS-ETL packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, Execute package task
Created SSIS packages to other SQL Server instances in SSIS 2014.
Performed the task of data transfer from files in remote server to folders in another server using FTP.
Experience throughout developing OLAP cubes for data mining and created reports from the OLAP cubes
Generated reports from the cubes by connecting to Analysis server from SSRS.
Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2014 to MS SQL 2014 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
Developed various reports using SSRS, which included writing complex stored procedures for datasets.
Experience in creating snapshots of static reports and configure subscription.
Experience in creating complex SSIS-ETL packages using proper control and data flow elements
Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view.
Extracting the data from the different sources (CSV files, and MS SQL 2018) and stored the data into the intermediate Staging Database using the SSISETL tool.
Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
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.
Environment: SQL Server, Business Intelligence Studio (SSIS, SSRS), SharePoint 2007, T SQL, Erwin, MDX, Oracle 10g, ERWIN, MS Excel, Tableau.
Education:
The university of Texas at Dallas, Masters of Science: Information Technology & Management
Contact this candidate