Sql Server Business Intelligence
Resume:
MSBI DEVELOPER
Surapureddy Venkata Ram Kumar
Overland Park, Kansas
PROFESSIONAL SUMMARY:
Having 6+ years of professional experience in development, implementation and administration of database systems using MS-SQL Server 2019/2017/2016/2014/2012/2008R2 for both OLTP & Data Warehousing applications.
Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, azure databricks Testing, Deployment, Support and Maintenance of business applications using SQL Server 2019/2017/2016/2012/2008/2005/2000, DTS, SSIS and SSRS 2014/2016.
In-depth experience of Transact-SQL (DDL and DML) operations. Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Stored Procedures, Views, Cursors and Triggers.
Experience in complete Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
Good Knowledge of Data Warehouse/Data mart concept and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.
Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Data Transform Services (DTS), Bulk Insert.
Expertise in upgrading/migrating from DTS to SSIS packages, resolving complex issues and Error handling in SSIS.
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.
Created ADF Pipelines to load data from an on-prem to Azure SQL Server database and Azure Data Lake storage.
Move data from both on-premises and cloud source data stores (Azure data lake storage and Azure blob storage)
Strong understanding of Data warehouse and Business Intelligence concepts including hands on expertise in several ETL and BI tools such as Azure Data Factory, Microsoft SSIS & SSRS, Informatica Powercenter, TIBCO Spotfire, Power BI and Tableau.
Develop framework for converting existing PowerCenter mappings and to PySpark(Python and Spark) Jobs.
Create Pyspark frame to bring data from DB2 to Amazon S3.
Translate business requirements into maintainable software components and understand impact (Technical and Business)
Provide guidance to development team working on PySpark as ETL platform.
On-call duty with teammates 1-2 weeks per month and active involvement in Go-live activities.
Very good T-SQL Programming skills and experience in query optimization & performance tuning used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
Experience in Developing ETL solutions using Spark SQL in Azure Databricks for data extraction, transformation and aggregation from multiple file formats and data sources for analyzing & transforming the data to uncover insights into the customer usage patterns.
Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
Experienced in managing Azure Data Lake Storage (ADLS), Databricks Delta Lake and an understanding of how to integrate with other Azure Services.
Develop Spark applications using pyspark and spark SQL for data extraction, transformation, and aggregation from multiple file formats for analyzing and transforming the data uncover insight into the customer usage patterns.
Experience with Azure technologies such as Storage solutions Azure Blob storage, Azure Data Lake Storage gen2, Azure SQL Database.
Designed and developed ETL packages in SSIS and pipelines in Azure Data Factory to transform source data as per transformation logic and ingest that into CDM platform based on defined architecturesof CDM model.
Worked extensively on Azure data factory including data transformations, Integration Runtimes, Azure Key Vaults, Triggers and migrating data factory pipelines to higher environments using ARM Templates.
Thorough understanding of Kimball’s theory, KPIs and Perspective, Data mining structures.
Worked on migration of data from On-prem SQL server to Cloud databases(Azure Synapse Analytics (DW) & Azure SQL DB).
Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experienced in implementation of strong referential integrity and auditing using triggers and SQL Scripts.
Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T-SQL.
Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
Created different Power BI reports utilizing the desktop and the online service and schedule refresh.
Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development and maintenance) using Waterfall and Agile methodologies.
Expertise in creating advanced calculated columns and measures with DAX using Power BI. Hands on experience in Power BI service.
Excellent communication skills, bridging Client Interaction and Team player.
TECHNICAL SKILLS:
Operating Systems
Windows, Linux
Databases
MS SQL Server 2019/2017, Azure SQL DB, Oracle, MS Access.
Scripting/Programming
Transact SQL (T-SQL), PL/SQL, C# .NET, Python, R, HTML, XML, CSS, jQuery.
Cloud
Microsoft Azure (Azure SQL DB, Azure Synapse, Azure Data Factory).
BI/Reporting
SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Power BI, Tableau.
Database Tools
SQL Profiler, SQL Query Analyzer, Management studio Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs.
Tools and Packages
SQL Server Management Studio (SSMS), Enterprise Manager, Business Intelligence Development Studio.
ETL Tools
Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS), Power BI, Visual Studio2010, 2014.
Modeling Tools
Microsoft Visio, SQL Diagrams, ERWIN 4.1, programming T-SQL, PL/SQL, VB.Net, Python, XML, HTML, C#, C, JAVA, C++.
Other Tools
MS Visio, Visual Studio, Azure DevOps, JIRA.
EDUCATION:
Bachelor of Engineering – 7.13 CGPA – Sathyabama Institute of Science and Technology.
Masters in Science – Computer Science – 3.2 GPA - University of Central Missouri.
PROFESSIONAL EXPERIENCE:
Client: Inovalon, Bowie, MD Dec 2022 – Present
Role: SQL /Power BI Developer
Responsibilities:
Worked as a developer in creating complex stored procedures, Triggers, Functions, Indexes, Tables, Views and SQL joins for applications.
Expertise in writing complex DAX functions in Power BI and Power Pivot.
Worked on migration of data from On-prem SQL server to Cloud databases (Azure Synapse Analytics (DW) & Azure SQL DB).
Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
Experience in Developing ETL solutions using Spark SQL in Azure Databricks for data extraction, transformation and aggregation from multiple file formats and data sources for analyzing & transforming the data to uncover insights into the customer usage patterns.
Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.
Develop Spark applications using pyspark and spark SQL for data extraction, transformation, and aggregation from multiple file formats for analyzing and transforming the data uncover insight into the customer usage patterns
Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
Actively working on Azure, Azure SQL Database, Azure SQL Data Warehouse, ADFv2, Blob Storage, PolyBase and using SSIS in ADF environment on purpose of scripting calling APIs.
Experience with Azure technologies such as Storage solutions Azure Blob storage, Azure Data Lake Storage gen2, Azure SQL Database
Develop framework for converting existing PowerCenter mappings and to PySpark(Python and Spark) Jobs.
Create Pyspark frame to bring data from DB2 to Amazon S3.
Worked on migration of data from On-prem SQL server to Cloud databases(Azure Synapse Analytics (DW) & Azure SQL DB).
Translate business requirements into maintainable software components and understand impact (Technical and Business)
Provide guidance to development team working on PySpark as ETL platform
Highly experienced in working with SSRS in generating the different formats of reports and also worked on Production support for several existing reports.
Developed SSIS solution for developing a fully-fledged data warehouse solution.
Created ADF Pipelines to load data from an on-prem to Azure SQL Server database and Azure Data Lake storage.
Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
Strong understanding of Data warehouse and Business Intelligence concepts including hands on expertise in several ETL and BI tools such as Azure Data Factory, Microsoft SSIS & SSRS, Informatica Powercenter, TIBCO Spotfire, Power BI and Tableau
Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc.
Move data from both on-premises and cloud source data stores (Azure data lake storage and Azure blob storage)
Experienced in managing Azure Data Lake Storage (ADLS), Databricks Delta Lake and an understanding of how to integrate with other Azure Services.
Responsible for creating the reports based on the requirements using SSRS 2016.
Designed and developed ETL packages in SSIS and pipelines in Azure Data Factory to transform source data as per transformation logic and ingest that into CDM platform based on defined architecturesof CDM model
Worked extensively on Azure data factory including data transformations, Integration Runtimes, Azure Key Vaults, Triggers and migrating data factory pipelines to higher environments using ARM Templates
Developed Ad-hoc reports using report builder.
Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions.
Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
Created reports utilizing SSRS, Excel, Power BI and deployed them on SharePoint Server as per business requirements.
Created ETL scripts using T-SQL queries, Views, Stored procedures and functions.
Implemented the calculations to aggregate physical measures.
Involved in writing scripts for the client’s requirements for reporting purposes.
Implementing Dashboards and Score Cards using Microsoft Performance Point Server and integrated with share point.
Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
Created calculated columns and measures using DAX queries in Power BI based on report requirements.
Involved in installation of Power BI Report Server.
Developed reports to visually explore data and create an interactive report Excel and Power BI.
Using a query editor in Power BI performed certain operations like fetching data from different file.
Working with import and direct query, creating custom table in the Power BI.
Environment: SQL Server 2019/2017/2016/2014, SQL Server Integration Services SSIS (2014/2012), SSRS (2014/2012), SQL Server Analysis Services SSAS (2012/2008), Azure Synapse Analytics Visual Studio 2010/2013, MS Excel 2014, T-SQL, VB Script, Access 2013, Team Foundation Server (TFS).
Client: The Oriental Insurance, India Feb 2019 - Nov 2021
Role: SQL Server/Power BI Developer
Responsibilities:
Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2016).
Actively participate in the Design, Build, Test, and Deploy phases of Siebel UCM implementations for Oracle customers.
Configured and created SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task Package Execution task to achieve business needs.
Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
Responsible for generating different types of daily and weekly reports based on specifications and user’s requirement using SSRS.
Developed parameterized reports for generating Ad-Hoc reports as per client requirements.
According to business requirements developed Tabular reports, Matrix reports, Gauges & Chart reports, Parameters, Sub reports, Ad-hoc reports, Drill down reports, Drill Through using SSRS.
Deployed SSRS Reports into Report Manager and managed report subscriptions, delivery, generation and rendering.
Creating test cases for ETL mappings and test design documents for production support.
Wrote and modified various Stored Procedures used in the application using T-SQL.
Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent.
Responsible for creating partition function and schema for the table partitioning.
Involved in creating counter logs and trace logs for advanced performance analysis and data logging over a period.
Created SSIS 2016 Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
Created various jobs using SQL Server Agent.
Used SQL Server Profiler to trace the slow running queries and the server activity.
Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.
Expertise in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis.
Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.
Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.
Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements.
Environment: Microsoft SQL Server 2014, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Report Builder, SQL Server Analysis Services (SSAS) Visual Studio 2010/2008, SQL Server Agent, Windows server 2008, Erwin 7.2, Visual Source Safe 2008, SQL Profiler.
Client: Marfic Software Solutions, Bangalore, India April 2016 to Jan 2019
Role: SQL Server Developer
Responsibilities:
Created other database objects like tables, views, Stored Procedures, User Defined Functions, Triggers and indexes.
Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
Designing and building data load procedures using MS SQL Server.
Implemented SQL Server OLAP services (SSAS) for building the data cubes.
Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
Automated Stored Procedures to load data into staging and production environments in a timely manner using SQL Server Agent.
Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
Developed complex database objects like complex stored procedures and complex UDFs
Created database objects like tables, views, indexes and triggers in MS SQL Server that support relational and dimensional database models.
Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports.
Involved in automating SSIS Packages using SQL Server Agent Jobs. Generated Parameterized reports, Sub reports, Drill down and Drill through reports using SQL Server Reporting Services (SSRS) working along with MDX queries
Involved in requirements gathering, logical and physical data modelling, developing fact and dimension tables, configuring ETL workflows to populate fact and dimension tables, and developed Cubes and reports for analysis.
Developed complex SQL queries, and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor.
Optimizing stored procedures, T-SQL, views, and functions for the best performance.
Refining and automates regular SQL processes, track issues, and document changes.
Used the Control Flow and Data Flow Tasks and Transformations in Creating SSIS (ETL) Packages.
Created Master Child package using variables and Execute package task in SSIS.
Assisted the front-end application developers with their queries.
Created Power BI reports by using Joins in multiple tables from multiples database using complex SQL queries.
Taking Database Full Backup, Transaction log backup & differential backups.
Automate monthly excel reports into Tableau Workbooks and Dashboards.
Configured Snapshot replication for reporting, user acceptance test and development servers.
Environment: SQL Server 2012, T-SQL, VB, DTS, SQL Profiler,, Microsoft Business Intelligence Development Studio (BIDS) Visual Source Safe, DTS/SSIS 2008, Import and Export Wizard, BCP, Windows Server 2003, UNIX.
Contact this candidate