Swetha Karna

Email: ad30te@r.postjobfree.com

Phone: 913-***-****

SQL BI Developer

Professional Summary:

Around 4+ years of experience in IT as Microsoft Business Intelligence Developer working in various domains such as Finance, Banking and Insurance using MS SQL Server 2017/2016/2014/2012/2008R2/2008, SQL Server Integration and SQL Server Reporting Services.

Conversant with all phases of Software Development Life Cycle (SDLC) involving System Requirements, Analysis, Design, Development, Implementation, Integration, Testing, Deployment and Maintenance.

Expert in presenting multi-platform Power BI data visualization like pie/bar/graph charts.

Experience with row-level security, DAX measures, calculated columns and altering data on both Tabular Models and Power BI reports.

Expert on making various sorts of Power BI Reports and Dashboards.

Expertise in creating advanced calculated columns and measures with DAX using Power BI.

Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export Wizard.

Experienced in ETL processes and Data warehousing methodologies. concepts including Star schemas, Snowflake schemas, Dimensional modeling, Reporting tools, Operations Data Store Concepts, Data Marts and OLAP technologies.

Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Copy Program (BCP)

Experience in Conceptual, logical, physical, and dimensional data modeling, data mapping, and data Normalization, well verse in ERWIN.

Highly Skillful in Microsoft Business Intelligence tools like SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Expertise in Designing, Implementation of SSIS packages to perform ETL tasks on data retrieved from heterogeneous sources.

Strong Experience in providing Logging, Error handling by using Event Handler, Break Points, Checkpoints and Custom Logging for SSIS Packages.

Experience in Scheduling jobs, alerts, SQL mail agent, and schedules for SSIS Packages in SQL Server Agent.

Very good at the development of Reports using SQL Server Reporting Services (SSRS) and Power BI like different types of Tabular Reports, Matrix Reports, drilldown reports and drill through.

Developed complex Stored Procedures and views to generate various Drill-through, Drill through reports, parameterized reports and linked reports using SSRS and Power BI.

Experienced in writing Parameterized queries for generating Tabular reports, Formatting report layout, sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS. Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.

Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.

Experience in Querying a Tabular Model in Excel, Power View and used various DAX Functions. Loading Data inside Tabular, Monitoring Security, Automating Deployment to Production Server.

Extensively involved in the SSAS storage and partitions, Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Best coding programmer in writing complex T-SQL queries for Joins, views, Stored Procedures & parameters, Triggers, User functions, Tables.

Experience working with Agile and Waterfall methodologies in SDLC.

Able to work collaboratively, quickly understanding the system architect and business needs towards achieving goals.

Excellent communication and management skills. Quick learner and excellent team player, ability to complete the task on time.

Supported the system 24/7 working beyond regular hours and carrying primary and secondary support roles during weekends and holidays.

Strong ability to analyze user requirements, Business requirements, and specifications.

Education:

• Masters in Computer Science - University of Central Missouri.

Technical Skills:

Databases

SQL Server 2017/2016/2014/2012.

Operating Systems

Windows 10/8/7, LINUX OS

Language

C, C++, SQL, T-SQL, UNIX, PL/SQL

Database Tool

SQL Profiler, SSMS, Database Engine Tuning Advisor

Data Modeling Tools

Erwin, Red gate, Lite Speed

Design Methodologies

Logical and Physical Database Design, UML (Unified Modeling Language), Database Design and Normalization, Data Modeling.

BI Suit

SSIS, SSRS, SSAS

ETL Tools

DTS, SSIS,

Reporting Tools

SSRS, Crystal Reports, Dashboard Reports, Power BI

Other Tools

Erwin, Visio, Visual SourceSafe, MS Office Suite

Architecture

Relational DBMS, Client-Server Architecture, OLAP, OLTP, Star & Snowflake schema

Professional Experience:

Client: Elevance Health, Indianapolis, IN June 2023 – Till date

Role: Power BI/SQL Developer

Responsibilities:

Developed DAX measures and calculated columns using Power BI desktop.

Created drill-through pages to give detailed information and implemented bookmarks and button functionality on portfolio reports.

Scheduled Power BI Reports to run on a daily and weekly basis in Report Manager and emailed to the directors and analysts to review in an Excel sheet. Designed a Power BI Data model with multiple Facts and Dimension Tables based on the requirement.

Designed and Implemented analytics solutions using Power BI Dashboard and Reports.

Worked with admin on Power BI gateway creation, configuration, and failures.

Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, slicers, cards, line charts, pie, bar, donut charts, and density charts.

Worked with different levels of filters – report level, page level and visual level in Power Bi desktop.

Created efficient data models using fact and dimension tables in the Power BI desktop to get better report performance.

Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.

Created Power BI reports by using joins in multiple tables from multiple databases using complex SQL queries.

Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.

Used SQL Server Package Configuration technique to make Dynamic configurations.

Used Text Files/ SQL Server Logging for all SSIS packages.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.

Deployed and configured the reports in the Report Server.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Used Power BI, Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.

Worked with various SSIS packages which involve Transactions, Restorability and roll back techniques.

Configured SQL mail agent for sending automatic emails when SSIS packages fail or succeed.

Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.

Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.

Schedule the packages to keep extracting the data from OLTP at specific time intervals.

Responsible for rebuilding the indexes and tables as part of performance tuning.

Monitored performance and optimized SQL queries for maximum efficiency.

Used SQL Server Agent for scheduling jobs and alerts.

Deployed the packages to production using XML package configuration.

Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Verified business requirements and functional specifications.

Environment: SQL Server 2017/2016/2014/2012, SQL Server Integration Services, Power BI, DAX, SharePoint, MS Excel 2016, MS Access 2016, Management Studio, Oracle 9i, SQL Profiler and SSRS.

Client: Easy Pay Finance, Carlsbad, CA Jan 2023 – May 2023

Role: SQL BI Developer

Responsibilities:

Worked in Creating DAX Expressions and implement Partitions in Tabular models.

Extensively involved in designing and developing the power BI Data model using multiple DAX expressions to build calculated columns and calculated measures.

Designed and developed SSIS packages, Stored Procedures, Configuration Files, Tables, Views, Functions, and implemented best Practices to maintain optimal performance.

Developed different kinds of Power BI reports such as Sub Reports, Charts, Matrix reports, Linked reports.

Involved with Query Optimization to increase the performance of the report.

Worked with PerformancePoint Power BI dashboard designer to rollout dashboards.

Worked on Data validations and Data mapping.

Developed Power BI reports for business end users using Report Builder with Updating Statistics.

Participated in gathering User Requirements and System Specifications.

Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.

Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.

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

Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.

Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.

Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

Created multiple reports (SSRS) in Drill mode using tables, financial tables, cross tabs, and chart.

Design, deployment, and maintenance of various SSRS Reports in SQL Server.

Designed and implemented Parameterized and cascading parameterized reports using SSRS.

Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code and T-SQL code from developers.

Backing up, restoring system & other databases as per requirements, and scheduled those backups.

Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Developed a comprehensive reporting environment utilizing data from multiple sources and creating analysis using SQL Server Reporting Services (SSRS).

Involved in complete SSIS life cycle in creating SSIS package, building, Deploying, and executing the package in both the environments (Development and Production).

Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.

Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.

Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

Created and maintained Users, Security Permissions and Migration of the database objects from one server to another server.

Environment: MS SQL Server, SQL Integration Services (SSIS), SSRS, SSAS, Data Transformation Services, Power BI, DAX, Business Intelligence Development Studio (BIDS), T-SQL, Microsoft Visual Studio.

Client: ECIL, India Jun 2018 – Nov 2021

Role: SQL Developer

Responsibilities:

Involved in the requirements analysis, design, and development phase of Water Fall SDLC model.

Created reports by extracting data from the data set using SQL server reporting services SSRS.

Designed and deployed reports with Drill Down, Drill Through and drop-down menu option and parameterized and linked Power BI Reports.

Developed custom reports and deployed them on server using Power BI.

Expertise in DAX Queries to build Power BI calculated measures and Calculated columns.

Created Power BI reports by using joins in multiple tables from multiple databases using complex SQL queries.

Created Sub-Report, Matrix Report Tablix Report Drill Down Report and Charts using SSRS.

Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.

Deployed and subscribed to Reports using SSRS to generate all daily, weekly, and monthly reports.

Actively Involved in gathering and analyzing business requirements, work with technology team to recommend and implement best approaches to deliver business solutions.

Designed and developed SSIS packages to load the data from various kinds of sources like MS Excel files, XML, Flat Files and Database Tables to SQL Server Database.

Extremely used complicated Data Flow Transformations like Lookup, Conditional Split, Derived Column, Merge, Merge Join, Multi cast, Data Conversion and Union all etc.,

Worked on package configurations, logging, scheduling, error handling and variables while creating the different packages.

Scheduling SQL Server jobs on SSIS Packages to automate the execution of the packages at a particular time depending on requirements.

Developed package configurations for Integration, Test and production environments and execution of packages automatically.

Wrote complex Queries like Stored Procedure’s, Triggers, Functions, Views and Indexes and SQL joins for applications.

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.

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.

Rebuilding/monitoring the indexes at regular time intervals for better performance.

Expertise in solving real time issues with index fragmentation, DBCC checks, Query Tuning, and Event Handling

Created databases objects like stored procedures, tables, views, Triggers, and user defined Functions.

Environments: MS SQL Server 2014/2012, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Power BI, T-SQL, SQL Profiler, Query Analyzer, Visual Studio, MS Access and TFS.

Contact this candidate