Sql Server Data Engineer

Shravani Challa

Data Engineer

*************.******@*****.*** 647-***-****

Professional Summary

Having 8+ years of experience in IT and Property Insurance Industry, which includes analysis, design, design, development, testing and implementation of applications, reports and databases (MS SQL Server, Oracle) in production environments and providing ETL/Business Intelligence solutions using Microsoft components to various clients (SSIS, SSRS, SSAS). Informatica/Talend, Power BI & Tableau creating Design, Development, Testing, Implementation and Production/Support phases of SDLC for Data Warehouse, Client/Server, RDBMS and Web Based Application.

Over 5 years of experience managing and leading mid-level professional teams, driving performance improvements through data-driven insights and effective leadership. Adept at developing and implementing performance management metrics tailored to claims organizations to improve operational efficiency, identify trends, and optimize business outcomes.

Conversant with all phases of the Software Development Life Cycle (SDLC) especially Agile, Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.

Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.

Highly experienced in whole cycle of DTS/SQL server integration services SSIS Packages Developing, Deploying, Scheduling, Troubleshooting and monitoring for performing Data transfers and ETL Purposes across different servers.

Developed various Python scripts to find vulnerabilities with SQL Queries by doing SQL injection, permission checks and performance analysis and developed scripts to migrate data from proprietary database to PostgreSQL.

Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.

Extensive experience and understanding of SSAS, OLAP cube and Architecture. Developed Multi- dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Extensive experience in different types of reports including Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports. Very good experience in writing expressions in SSRS.

Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.

Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.

Expert in designing ETL data flows using SSIS, creating mappings/workflows to extract data from SQL Server, Data Migration and Transformation from Excel using SQL Server SSIS.

Experienced in Developing the scripts which push the data from the cosmos output streams into SQL Server Databases.

Experienced in designing and building OLAP cubes, fact and dimension tables with different architecture and data sources for business intelligence and populating/maintaining data marts in SSAS.

TECHNICAL SKILLS:

Databases: SQL Server, Azure SQL, MS Access, Teradata, Oracle, DB2, PostgreSQL and MySQL.

DB Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, T- SQL, T-SQL, PL/SQL, OLAP, OLTP.

Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Informatica/Talend, Power BI, Tableau, Power Query, GitHub Copilot.

Platforms: Azure Databricks, Azure Data Factory, Azure Synapse, Power BI, GitHub, Azure DevOps

Concepts: ETL/ELT, Data Modelling, Data Warehousing, Performance Tuning, CI/CD

Languages: SQL, T-SQL, HTML.

Professional Experience:

Longview Systems, Toronto, ON Aug 2024 – till date

Data Engineer

Responsibilities:

Created SSIS packages to validate, extract, transform and load data to a centralized SQL server from the existing diversified data sources.

Cleansed master data using DQS cleansing component, fuzzy lookup and lookup transformations in SSIS packages.

Designed and implemented end-to-end data pipelines using Azure Databricks, PySpark, and Data Factory for ingestion, transformation, and loading of data into Azure Data Lake and Synapse Analytics.

Collaborated with business analysts and architects to build scalable data models supporting financial and operational reporting.

Partnered with data architects and analysts to implement data modeling standards (star/snowflake schema) and ensure alignment with enterprise data architecture.

Conducted code reviews and performance tuning, ensuring compliance with engineering standards and optimized resource utilization.

Re-engineered legacy SQL-based Power BI reports into Databricks-optimized datasets, improving report refresh times by 40%.

Migrated key workloads to Azure Databricks, introducing continuous integration practices for automated testing and deployment.

Developed CI/CD pipelines in Azure DevOps to automate deployment of data workflows and Power BI artifacts.

Utilized GitHub Copilot for faster, cleaner code development and adherence to coding best practices.

Monitored and maintained data pipeline performance, resolving bottlenecks and optimizing cluster configurations.

Conducted stakeholder workshops to enhance data literacy and train teams on Power BI and data visualization best practices.

Developed various reports and Dashboards of operational and research data of the organization using Tableau and Power BI.

Involved in Production Deployment and providing support for the solutions.

ADP India Pvt Ltd, Hyderabad, IN Apr 2019 – Nov 2022 ETL Developer

Responsibilities:

Worked in Agile methodology, participated in Sync meetings.

Developed mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse, using different transformations like Source Qualifier, Lookup, Aggregate, Update Strategy and Joiner.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Implemented complex business rules in Informatica PowerCenter by creating re-usable transformations, and robust Mapplets.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.

Expert in creating Calculations (LOD, Cube Calculations, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop.

Utilized Tableau server to publish and share reports with the business users.

Distributed Tableau reports using techniques like Packaged Workbooks and PDF to different user community.

Worked on Upgrading the Data from SQL Server 2012 and SQL Server 2014 on to SQL Server 2016

Developed complex mappings utilizing SSIS to transform and load the data from various source systems such as SQL Server2014, Oracle, Excel and Flat files into the SQL 2016 Server target staging database.

Extract the Data from Cosmos to SQL layer and Build SSAS Cubes.

Proficient in SQL Server Analysis Services (SSAS) to design and develop OLAP Cubes

MDX Queries using SQL Server Analysis Services

Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view.

Migrate existing data into the Power BI and create reports in Power BI preview portal utilizing the SSAS Tabular Editor.

Migrated On-Premises databases to Azure Cloud Database.

Migrated data from different sources (text-based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).

Implemented various SSIS tasks such as conditional split, derived column for data scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

Used various transformations like Derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.

Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML, and CSV using SQL Server 2012 Reporting Services (SSRS).

Migrated all the existing Tableau and SSRS reports to Power BI

Designed and developed mappings using Source Qualifier, Expression, connected-Lookup and unconnected-Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner & Rank transformations.

Recreated packages with the new source as stored procedure to meet the requirement.

Developed dashboard reports using Reporting services, Report model and ad-hoc reporting using Report builder.

TECHSPERTS SOFTWARE SOLUTIONS, Hyderabad, IN October 2015 – Mar 2019

SQL Developer

Responsibilities:

Created SSIS Packages using Execute SQL Task, File System Task, Send Mail Task, for each Loop container and Sequence container.

Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects

Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.

Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server.

Created SSIS Package with various Variables, Expressions and Transformations like Conditional Split, Derived Column, Data Conversion, Lookup, Merge Join, Sort and Aggregate.

Debugged SSIS Packages using Breakpoints, Data Viewers & watch windows.

Built KPIs in tabular based on the end user requirements, worked on Performance of SSAS Tabular Editor cubes.

Involved in data migration from Excel, CSV files into SQL Server using SSIS Packages.

Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.

Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis

Implementing Industry ETL standards and best practices, performance tuning during designing the

DataStage Jobs

Created/ Modified SSRS based reports based on T-SQL and Stored Procedure with Input parameters.

Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task

Worked on migrating SSIS packages from 2008 R2 to 2012

Developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).

Worked on SQL scripts PLSQL, Creating Tables, Clustered/ Non-clustered Indexes Joins, to get the desired result sets from the Oracle Database as per the requirement.

Designed cubes and built Scorecards and dashboards for various levels of management.

Involved in writing MDX queries and performance optimization of the SSAS cubes. Build the dimensions, cubes with star schema and snowflake schema using SQL Server Analysis Services.

Education:

PG Diploma in Cloud Computing at Loyalist College, Toronto, Ontario, Canada.

Bachelor’s in computer science at JNTU, India.

Contact this candidate