Sql Server Power Bi

Sr SQL BI Developer

Deekshith R

****************@*****.***

513-***-****

Over 6 years of IT experience in Capital Markets Banking / Financials/ Mortgages, Medical and Retail sectors as a SQL server Developer that includes Database Design and Development of SQL Server 2008/2005/2000.

Involved in Database Design, Data architecture, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2000/2005/2008.

Worked in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS), Pipeline Pilot.

Expert in providing Enterprise Reporting solutions using SSRS 2000/2005, Crystal Reports, Performance Point Server, ProClarity and SharePoint Services.

Strong Experience in Data Migration from RDBMS to Snowflake cloud data warehouse.

Experience on Migrating SQL database to Azure Data Lake, Azure data lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and controlling and granting database access and Migrating On premise databases to Azure Data.

Provided Alteryx workflow development training sessions to 20+ users.

Extensive experience in developing ETL mappings, scripts, and data integration using Informatica

Power Center.

Worked with Business Owners and Stakeholders to gather requirements for the report and implement those in Power BI and build visuals which shows meaning full insights to the Business.

Worked on Microsoft Power *(Power Pivot, Power View, Power Query, Power Maps, POWER BI)

Build re-usable artifacts within Power BI to support self service data modelling and self service reporting.

Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.

Expertise in developing application using.NET, C#, SQL Server.

RDBMS: MS SQL Server 2000/2005/2008, MS Access, Oracle 9i/10g, Sybase.

Programming Languages: T-SQL, PL/SQL, C#, Java (J2EE), VB scripts, Oracle and UNIX Shell Script, Perl Script.

ETL Tools: Informatica Power Center 9.x/8.x/10.x (Power Center Repository, Informatica Designer, Workflow manager, Workflow monitor, Source Analyzer, Mapping Designer, Mapplet, Transformations, Worklets).

Tools & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, Visual Source Safe(VSS)6.0, Business Objects XIR2/XIR1/6.X/5.X, Informatica, Visual Studio .NET, Sungard iworks Procede 8.6.

Operating Systems: Windows Vista/XP/2003/2000, Windows Server 2000/2003/2008.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Power BI Service, Power BI Desktop, Power BI Report Builder, Informatica 8, ProClarity OLAP tools, Performance Point Server 2007, MS Visio, Erwin, Crystal Reports 9.0/XI.

Web Technologies: XML, XPath, HTML, XSL, JavaScript, IIS.

Data Modeling: Visio 2007 and Erwin 4.1.

Application Packages: MS Office Suite, MS Outlook, Microsoft Office SharePoint Server (MOSS).

Version Control: Rational ClearCase, Rational ClearQuest

Providence Health Care, Portland, OR Sep’22 to Till Date

SQL SSIS/SSRS Developer with Power BI

Responsibilities/ Roles:

Created ETL process using SSIS to transfer data from heterogeneous data sources.

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check points and Expressions for SSIS Packages.

Developed reporting solutions using SQL Server Reporting Services (SSRS) and Power BI for clinical and financial insights.

Migrated Crystal reports to SSRS 2019 by considering some factors such as report complexity, customization and data combability.

Developed ETL mapping for extracting data from different sources like flat files and different databases using Informatica Power Center.

Created shell scripts to fine tune the ETL flow of the Informatica workflows.

Worked extensively with Dimensional modelling, Data migration, Data cleansing, ETL Processes for data warehouses.

Utilized SSRS Report Builder and SQL Server Data Tools to recreate Crystal Reports' layouts and functionalities within SSRS.

Successfully integrated SQL Server Reporting Services (SSRS) with Power BI, leveraging the strengths of both platforms for enhanced reporting capabilities.

Developed dynamic and interactive SSRS reports embedded within Power BI, providing users with real-time access to critical information.

Created custom visualizations in Power BI to extend reporting capabilities, integrating them seamlessly into SSRS reports for a richer presentation of data.

Worked on the EDI 834 inbound and 834 outbound data movement with our trading partners.

Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports using RDL.

Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.

Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.

Created Efficient Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL scripts.

Translated business logic into DAX expressions to deliver accurate KPIs and performance metrics.

Developed and maintained healthcare interfaces using Qvera Interface Engine (QIE) to facilitate real-time data exchange between EHRs, labs, and billing systems.

Diagnosed and resolved interface errors using QIE logs, error queues, and SQL query tracing.

Stored temporary or aggregated results in cache tables with refresh triggers to improve SP performance for frequent queries.

Created custom telemetry using SQL for slow query logging, wait statistics, deadlock tracking.

Designed and optimized Azure SQL Databases for healthcare applications, ensuring high availability and scalability.

Knowledgeable about industry-standard data formats, protocols, and schemas, such as JSON, XML, and CSV.

Successfully designed and implemented Azure DevOps Continuous Integration (CI) and Continuous Deployment (CD) pipelines for deploying SSRS reports, automating the deployment process.

Configured deployment environments within Azure DevOps, ensuring consistency and reliability in promoting SSRS reports from development through testing and production stages.

Integrated security measures into the CI/CD pipeline, ensuring secure deployment of SSRS reports by validating access controls and permissions during the deployment process.

Utilized specialized conversion tools or scripts to efficiently transform Crystal Reports definitions (RPT) into the RDL format, ensuring compatibility with SSRS.

Cygnitech IT, India Jun’18 to Aug’21

SQL Server Developer/DBA

Responsibilities/ Roles:

Involved in the support the specific needs of hedge funds, fund-of-funds and private equity funds and registered investment products.

Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.

Provided SQL Server Database Administration and Development at Wells Fargo in support of a financial distributed and replicated storage system with a multi terabyte data store, installation of Oracle Financial accounting package, and evaluation of SQL Server 2000.

Involved in design, development and implementation of SSIS, SSRS and SSAS.

Developed SQL SSIS Packages to extract data from various data sources such as Excel and flat files into SQL server 2005 using different transformations like derived column, sort, and aggregate transformations.

Designed and implemented database architectures to support applications.

Developed normalized and denormalized database schemas to optimize performance and scalability.

Designed and maintained SSRS reports to visualize financial metrics, including revenue, expenses, and profitability trends, providing actionable insights to senior management for strategic decision-making.

Collaborated with finance teams to identify reporting requirements and translated them into technical specifications for SSRS report development, ensuring alignment with business objectives.

Designed and implemented scalable data models and pipelines in Snowflake to support enterprise-level reporting and analytics.

Worked on the Reinsurance vendor product Sungard iworks Procede 8.5.6 for creating the Reinsurance contracts.

Integrated Database Maintenance jobs to perform Full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler.

Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitor the size of the transaction log.

Tuned the performance of SQL queries and Stored procedures using SQL Profiler. Involved in database and log backups & restoration, backup strategies, scheduling.

Worked on upgrading/changing all the database objects from 2000 to make them compatible to the schema changes in 2005.

Created SQL scripts to load the custom data into Development, Test and production Instances using

Import/Export. Created scripts to create custom Tables and Views.

Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.

Used SQL profiler to view indexes performance to mostly eliminate table scan.

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.

Data migration from on premise databases to AWS cloud Data lake.

Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.

Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Created various DTS packages for data transfer and migration.

Develop Alteryx designer workflows and analytical apps to automate teh process of Fannie Mae mortgage balance verification.

Support Alteryx users in teh team to build workflow by guiding them on teh best practices.

Support and simplify existing Alteryx workflows to test and deploy in production.

Analyze and improve poorly performing SQL queries using execution plans.

Automated ETL workflows with Snowflake Tasks, Streams, and Procedures for real-time data processing.

Hands-on experience with Azure SQL Managed Instance and Azure SQL Database.

Managing various mortgage processes across different reports and provided primary Admin and

production support for these reports.

Developed SQL mortgage reports using SSRS. Developed optimal stored procedures and

queries to create data sets for reports. Designed Drill through Ad-hoc Reports.

Developed Ad-hoc reports using Crystal Reports.

Developed Star schema using SSAS cubes.

Created parallel period, filter, ancestors and cross join MDX queries.

Developed Aggregations, partitions and calculated members for cube as per business requirements.

Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.

Automated routine database tasks using SQL Agent jobs, PowerShell, or scripting tools.

Configured replication servers and transactional replication between production and standby server for disaster recovery.

Responsible for testing to optimize the procedures and triggers to be used in production. Involved in

project planning also schedule for database module with project managers.

Environment: Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), C#, XML, Sungard iworks Procede 8.6, SSMS, MS Excel, Windows 97/2000/XP, Oracle, Toad.

Master’s in Computer science, University of Dayton, USA 2022

Professional Summary

Technical Skills

PROFESSIONAL EXPERIENCE

Contact this candidate