Demudu Naidu Gompa

Data/BI Architect

Mobile: 385-***-****;

PROFESSIONAL SUMMARY:

Having 12+ years of IT industry experience with Microsoft SQL Server All versions, SSIS/SSRS/SSAS.

Having 2+ years of experience in Microsoft Power BI reporting tools various areas like Power Query, Power BI Data model, DAX and designing and development of Power BI Reports.

Having 2 years of experience in Azure cloud Azure SQL, Blob storage, Azure Data Lake, Azure Synapse Analytics (Azure DW), Azure Databricks and Azure Data Factory.

Worked on to load data from ADLS to Azure synapse Analytics thru poly base by using external tables (Master Key, Storage Credential, External Data Source, External File Format, External Table).

Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure Data Lake, Azure Synapse Analytics (Azure DW) and Azure Databricks.

Worked on to load data from ADLS to Azure synapse Analytics thru Azure data bricks for transformation.

Plan and Develop roadmaps and deliverables to advance the migration of existing solutions on-premise systems/applications to Azure cloud.

Architect and implement ETL and data movement solutions using Azure Data Factory (ADF), SSIS.

Worked on Azure suite: Azure SQL Database, Azure Blob Storage, Azure Data Lake (ADLS), Azure Data Factory (ADF) V2, Azure Databricks and Azure Synapse Analytics (Azure DW).

Deploying Azure Resource Manager JSON Templates from PowerShell.

Created an Azure Stream Analytics job that will input the data from a blob storage.

Worked on Dynamic Data masking on Default, Credit card, custom and Email related columns.

Worked on recovering any blob data from an Azure Storage account up to 30 days after the data is deleted.

Worked on to replicate data from one SQL database data to new SQL database.

Configured email notifications for suspicious login to an Azure SQL database is detected.

Implemented logging mechanism for the data stored in ADLS Gen1 using Azure data lake storage diagnostics to store logs and metrics in a storage account.

Experience in extracting data from Cloud systems like Sales force, Callidus, Oracle Eloqua and Adobe site catalyst into SQL Server using SSIS packages and C# code.

Experience in extracting data from various source systems using Microsoft power Query and design data model using Microsoft Power Pivot.

Design and develop interactive reports using Microsoft Power view.

Excellent analytical skills designing complex data model.

Excellent Performance tuning techniques to run queries faster with huge volume of data.

Extensive experience in using Microsoft BI studio products like SSIS, SSRS,SSAS, Power Query, Power Pivot and power view for implementation of ETL methodology in data extraction, transformation and loading.

Experience in executing SSRS reports using SSIS Packages.

Create dynamic SSIS packages on the fly run time.

Experience in creating SSIS Packages for integrating data from heterogeneous sources.

Proven track record being proactive and taking the initiative to drive forward technical solutions.

The ability to adapt to fast-moving emerging cloud technologies.

Worked to establish best practice and methodology in the area of architecture, design and development.

Experience in Migrating SSIS packages from 2005 version to 2008 version, 2008 to 2012 and 2012 to 2016 version.

Expert in creating new custom exports with better resolution. Ex: New TIFF format with 300 DPI.

Expert in creating dynamic graphs in SSRS and can do anything attitude in ETL/data modeling/SSRS/Data factory.

Data Warehouses and Data Marts, Cleaning and Standardizing Data.

Data modeling experience using Erwin and SQL Developer.

Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.

Experience in establishing methods and procedures for tracking data sources, data lineage, data quality, completeness, redundancy vs. replication, data dictionary, data models and metadata.

Involved to Migrate SQL server database to Azure SQL using Azure Data Migration Assistant (ADMA) too check compatibilities issues and worked on Azure database Migration Services (ADMS) is for fully-managed service for seamless services.

TECHNICAL SKILLS:

Operating Systems

Microsoft Windows server 2003 to Windows 7, Windows server 2012 and VM

Databases

MS-SQL Server 2000/2005/2008/2008R2/2012/2016, Azure SQL Database, Azure Blob Storage, Azure Data Lake (ADLS), Azure Databricks and Azure Synapse Analytics (Azure DW)

Tools

SQL Server Management Studio, SQL Server Integration Services (SSIS), DevOps, DPA (Database performance analyzer)

ETL Tools

Experienced working with SSDT/BIDS, SQL Server Integration Services (SSIS), SSAS (SQL Server Analysis Services), Power Query, Power Pivot, Azure SQL & Azure Data Factory

Reporting Tool

SQL Server Reporting Services (SSRS) and Power BI

Languages

C/C++, C#, ASP.NET, Performance Point Services (PPS) and Share Point Services.

PROFESSIONAL WORK EXPERIENCE:

Client: CGX, Humana Mar’19-Present

Role: Data Tech Lead

Description: CGX (Clinical Guidance exchange) is Humana’s clinical management system that encompasses the areas of utilization management, case management, LTSS. It helps manage the use of medical services of policy holders. Utilization management CGX 2.0 is a responsive web design (RWD) platform. Managing authorizations for applying for applying a member’s medical policy to a health care event – medical authorization management including an operational workflow tool for nurses. Case management managing members health outcomes through gap in care insights, clinical profile and predictive model scores identification and management of member’s problems and operational workflow tool for care managers. Long term services & supports defines a specific set of services typically required of seniors and those with disabilities.

Responsibilities:

Gadhering requirements, communicating with stakeholders, end-users to better understand, analyze and validate requirements.

providing strong technical support with advanced algorithms to the problem raised by the business users and/ Customer IT stakeholders.

Converted high level business requirements into detailed level by conducting multiple sessions with client.

Involved to Migrate SQL server database to Azure SQL.

Research and propose technical solutions to challenges, as required by the business, by formally presenting the approach, advantages, and disadvantages of all proposed solutions

Excellent Performance tuning techniques to run queries faster with huge volume of data thru In memory technology.

Experience in establishing methods and procedures for tracking data sources, data lineage, data quality, completeness, redundancy vs. replication, data dictionary, data models and metadata.

Working experience in a Scrum team and Agile planning thru Azure DevOps.

Function as techno functional expert to develop/enhance and support client applications and coordination with offshore team.

Worked closely with project managers, data analysts and supervisors.

worked on converting normal tables to in memory tables.

Involved in azure SQL migration.

Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage and Azure Data Lake.

Plan and Develop roadmaps and deliverables to advance the migration of existing solutions on-premise systems/applications to Azure cloud.

Environment: Azure SQL, SQL Server 2016 and Azure Data Factory.

Client: COMET, UnitedHealth Group Dec’14- Feb’19

Role: Data/BI Architect

Description: COMET (Centralized Operational Metrics) is a web-based portal solution accessed via the intranet. It is an interactive dashboard with drill down capability. It is used for executive decision making and reports which enables focused analysis through slice and dice capabilities with data export capabilities into Excel, Power point, Email and PDF

Responsibilities:

Actively involved in business rule analysis; gathered user requirements.

Converted high level business requirements into detailed level by conducting multiple sessions with client.

Involved to create ETL data model to pull the data from various source systems like sales force, Callidus and various other cloud systems

Designed SSIS package to pull data from Sales force, Callidus, Oracle Eloqua and Adobe site catalyst.

Used Joins, correlated and Non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.

Data modeling experience using Erwin and SQL Developer.

Performance turning thru In Memory technology and Column stored indexes.

Configuration and creation of SQL server agent Job thru proxy server account

Installed SQL Server 2016 and configured SSRS Report manager to deploy all the SSRS RDL files.

Developed complex Stored Procedures/views and aggregate fact tables to generate various Drill-through reports, Parameterized reports and Linked reports using SSRS.

Build different types of chart reports using SSRS like column chart and Pie charts. Involved in creating dynamic charts stacked column charts.

Enhanced performance using optimization techniques-normalization, indexing to ensure the completeness of batch processes and scripts.

Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.

Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.

Migrated SQL Server to Azure SQL Server and SQL Data warehouse.

Created Interactive dashboards using Power BI slices and dices.

Environment: SQL Server 2008/2012, SSIS, Azure data factory, SSRS and Power BI.

Client: MedData Jan’11–Nov’14

Role: Sr. BI Developer/Architect

Description: The project is for MedData-IT Inc., building data warehouse, ETL, developing reports and maintenance for 100+ Practices. The data warehouse involves daily load and monthly load of their charge, Payments and Adjustments data with their corrections corresponding to Accounts (Patients) and Providers. It will be involved ETL (Extract Transformation and Load) transformation, designing and development of bulk number of Dashboards, PPS and cube and SQL based SSRS reports which range from physicians, hospitalists, among others the ability to login to a secure, online portal, 24/7, where they can easily access all the pathology reports for their practices.

Responsibilities:

Experienced in designing and developing Parameterized tabular and matrix SSRS reports using data from ETL Loads and SSAS Cubes.

Developed parameterized and drill through SSRS reports.

Deployment of SSRS Reports into share point server.

Uploading SSRS Reports (RDL Files) in Report manager and automated to execute these reports thru SSIS package.

Creation of Data Source views, Dimensions and Cubes using SSAS.

Creating hierarchies and relationships among dimensions and facts in SSAS.

Created calculated measures and members in calculations, KPIs, Partitions, and Actions.

Modifying measures and attributes

Worked on different types of Actions like Drill Through action and Report action.

Have good exposure in working with Star and Snow Flake schema.

Created Dynamic SSIS packages containing execute SQL Task, Sequence Container, Data Flow Task, Flat File Source, OLDDB Source and OLDDB Destination using C# classes (Connection manager, Execute SQL Task, Sequence, etc.)

Created SSIS package to execute weekly and monthly reports. And send Excel generated SSRS reports to clients thru emails.

Created SSIS package to RoboCopy of flat files from sources path to local path.

Created SSIS package to merge all the individual RoboCopy flat files into single file.

Worked in different control flow items such as ExecuteSQLTask, ForEachLoopContainer, ExecuteProessTask, FileSystemTask, SendMailTask, DataFlowTask and AnalysisServicesProcessingTask.

Worked in different Data flow items such as FlatFileSource, OLEDBSource, Aggregate, ConditionalSplit, DataConversion, DerivedColumn, Merge, MergeJoin, Multicast, Script Componant, Unionall, FlatFileDestination and OLEDBDestination.

Worked in Event Handlers, Error handling, CML Package Configuration, Logging, FlatFileConnection, OLDDbConnection, ADO.NET connection and SSAS Connection.

Rresponsible for developing Stored Procedures and Views.

Efficient use of Joins and sub-queries in queries that involve data from multiple tables

Fine tuning of stored procedures and queries to improve the performance.

Creating Cluster and Non-Cluster Index indexes.

Experienced in estimated execution plan, actual execution plan and "Analyze Query in Database Engine tuning advisor".

Experienced with configured of Database email.

Environment: SQL Server 2005/2008/2012, SSIS, SSAS, SSRS and performance point services (PPS).

Client: Microsoft Technologies Feb’08-Dec’10

Title: Project One

Role: MS SQL Server/SSIS/SSRS Developer

Description: This is a reporting application built for the Enterprise Services business; the goal of the system is to provide a comprehensive reporting solution for the ES business in the areas of Sales Opportunity Management, MCS and Premier. This will combine most of the applications like Services Information Repository, Services Application Advanced Metrics and Enterprise Data Warehouse.

Responsibilities:

Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, and SQL 2005).

Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail 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.

Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.

Developed yearly and quarterly company expense reports.

Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.

Requirement Analysis, designing, development, coding and code review.

Responsible for developing Stored Procedures and Views.

Efficient use of Joins and sub-queries in queries that involve data from multiple tables

Fine tuning of stored procedures and queries to improve the performance.

Creating Cluster and Non-Cluster Index indexes.

Experienced in estimated execution plan, actual execution plan and "Analyze Query in Database Engine tuning advisor".

Experienced with configured of Database email.

Environment: SQL Server Enterprise Edition, SSRS, SSIS

Client: Microsoft Technologies Aug’07–Jan’08

Title: Services Information Repository (SIR)

Role: MS SQL Developer

Description: SIR stands for Services Information Repository. SIR is a reporting solution for the Services Organization, providing information for the MCS business regarding engagements, average rates, consultant’s utilization, etc. needed for daily business control and for monthly business reviews.

Responsibilities:

Designed T-SQL scripts to identify long running queries and blocking sessions.

Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.

Error handling using Try-Catch Block.

Normalization and De-Normalization of tables.

Developed Backup and Restore scripts for SQL Server 2005.

Installed and Configured SQL Server 2005 with latest service packs.

Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.

Written T-SQL queries for the retrieval of the data.

Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.

Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.

Customized the stored procedures and database triggers to meet the changing business rules.

Implemented indexes for performance tuning.

Environment: SQL Server Enterprise Edition

Certification:

Microsoft certified azure data engineer.

Microsoft certification ID: 17034323

Certification Number: H361-5578

DP-200 Implementing an Azure Data Solution

DP-201 Designing an Azure Data Solution

EDUCATION:

Bachelor of Technology in Computer Science, 2007

Andhra University,

Visakhapatnam, India.

Contact this candidate