Tejaswini Challagundla

ad10ql@r.postjobfree.com

PROFESSIONAL SUMMARY

• Around 3 Years of experience in Database Development, MSBI (SSIS & SSAS), Power BI, Azure Databricks and Data visualization.

• Experience in installation. Configuration of MS SQL server 2005, 2008, and 2012.

• Knowledge of Relational Database Management systems.

• Experience in creating and using Stored Procedures, Triggers, Views, User defined functions, Sub- Queries, and Joins for complex queries involving multiple tables.

• Proficient in SQL Server and T-SQL (DDL and DML) in constructing tables, Normalization/Denormalization techniques on database tables.

• Experience in creating and updating Clustered and Non-Clustered indexes to keep up the SQL server performance.

• Designed staging tables, basic dimensions, and fact tables for the dataset provided during MFRP.

• Worked on loading data into stage and dimension tables from DB2 Source.

• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity.

• Have experience in developing SSIS packages.

• Taken care of package deployment in the SSISDB (Integration Catalog).

• Good Hand in resolving complex issues and error handling in SSIS.

• Experience in Dimensional Data Modelling, Cube development, and manipulations in SQL Server Analysis Services (SSAS).

• Good knowledge of working with Facts, Dimensions, and Multi-dimensional Cubes.

• Extensive Data Warehouse Modeling with SQL Server Analysis Services (SSAS).

• Experience in developing and extending OLAP Cubes, Dimensions, and data source view.

• Developed and implemented reporting, analytics, and Data Visualization solutions with Power BI.

• Creating Row Level Security with Power BI Desktop and integration with Power BI Service portal.

• Developed Power Bi reports and dashboards from SQL Server Analysis Service database and Azure blob storage data sources.

• Developed MDX scripts to create datasets to perform reporting and included interactive drill down, drill through reports, reports models, and dashboard reports.

• Developed Power Bi reports and dashboards from SQL Server Analysis Service database and Azure blob storage data sources.

• Worked on On-premises Database Report Visualizations.

• Experienced in developing tabular and multidimensional SSAS cubes, Aggregation, KPIs, Measures, partitioning cubes, deploying, and processing SSAS objects.

• Processed the SSAS cube on a daily and monthly basis.

• Ability to work in groups as well as independently with minimal supervision.

• Good written and verbal communication skills, strong organizational skills, and a hard-working team player well-practiced in attending phone calls and answering business team queries. TECHNICAL SKILLS

Operating Systems: Windows, LINUX

Languages: SQL, Py spark, Python

Web Services: C#

Databases: Microsoft SQL Server, MySQL, PostgreSQL, DTS, DB2. Reporting: Microsoft Power BI Desktop

DBA Tools: SQL Server, TOAD, PL/SQL, T-SQL, HUE, Visual Studio TRAINING & CERTIFICATIONS

• Developing Microsoft Azure and Web Services

• Taken training on CCNA Routing and Switching.

• DP203 - Data Engineering on Microsoft Azure.

WORK EXPERIENCE

Cognizant Technologies

Associate 19-Nov 22

Client Industry: Molina Healthcare

Role - BI and Azure Databricks

Developer

Responsibilities:

• Created and managed various database objects like tables, views, stored procedures, and DDL/DML Triggers.

• Used Joins and Sub-queries for complex queries involving multiple tables from different databases.

• Designed and implemented stored procedures, views.

• Improved the performance of long-running views and stored procedures.

• Identified Slow performing views, stored procedures, and queries using SQL profiler, by running simultaneously while browsing the application.

• Implemented complex business logic with user-defined functions, and indexed views, and created user-defined data type, clustered & non-clustered indexes.

• Performed loading operation of historical data using full load and incremental load into the enterprise data warehouse.

• Performed data analysis and data profiling using SQL on various systems including SQL Server 2008

• Maintained SQL scripts indexes and complex queries for analysis and extraction.

• Hands-on experience in developing SQL scripts for automation.

• Created packages in SSIS with error handling.

• Worked on Data conversion and Data Migration using SSIS service across different databases like MS Access, and Flat files.

• Used Various SSIS tasks such as Conditional Spilt, Multicast, Fuzzy Lookup, etc., which did data scrubbing, including data validation checks during staging, before loading the data into the Data warehouse.

• Created and Maintained data flow diagrams for existing and future ETL Processes.

• Transformed data from one server to another server using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS), and SQL Server Integration Services (SSIS).

• Used For each loop container, sequence container, Script task, Expressions, Execute SQL task, send mail task, and package execution task to achieve business needs.

• Worked on performance tuning on existing stored procedures and existing power bi reports for the faster processing reports

• Design and create innovative and valuable visualizations to identify patterns, trends, and exceptions which enable the business executives and senior leaders to make data-driven decisions.

• Worked on visualization dashboards using Power BI, Pivot tables, Charts, and DAX commands.

• Created tabular, matrix, chart, drill-down reports, parametric, cascaded reports, and dashboards according to business requirements.

• Involved in analyzing, designing, building & testing OLAP Cubes with SSAS 2007/2012 and in adding calculations using MDX

• Built MDX queries and data mining expression (DMX) queries for analysis services cubes.

• Created calculated members, named set, and advanced KPIs for the SSAS cubes.

• Used performance monitor and SQL Profiler to optimize queries and enhance the performance

• Developed Power Bi reports and dashboards from SQL Server Analysis Service database

• Collaborated with business users, collected requests, and updated the set of existing BI reports to accommodate business needs.

• Extract Transform and Load data from source systems to Azure data storage services using a combination of Azure Data Factory, and Spark SQL.

• Created Notebooks and Data Pipelines.

• Data Ingestion to one or more Azure services like Azure Data Lake Azure DW, and Azure Storage and processing the data in Azure Databricks.

• Expertise in various phases of project life cycles (Design, Analysis, Implementation, and testing).

• Involved in Loading and transforming large sets of structured and unstructured data.

• Participated in business requirements gathering and documentation.

• Developed and collaborated with others to develop, database solutions within a distributed team

Environment: SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Analysis Services

(SSAS), Power BI, Microsoft Visual Studio 2010/2012/2017, Hue, Azure services (ADLS, ADW, ADF) Client Industry: Anthem Healthcare

Role - SQL Developer

Responsibilities:

• Analyzing the data model and identification of heterogeneous data sources

• Built SQL scripts that include complex queries for large databases with a complex authentication process.

• Created DDL scripts to design database schema and database objects.

• Created transformations using the SQL script to modify the data before loading it into tables.

• Performed database defragmentation and optimized SQL queries, improving database performance and loading speed by 70%.

• Developed SQL queries to fetch complex data from different tables in remote databases using joins, and database links and formatted the results into reports and kept logs. Worked on T-SQL statements and implemented various codes and functions.

• Used Joins and Sub-Queries to simplify complex queries involving multiple tables while optimizing procedures and triggers to be used in the application.

• Performed SQL, PL/SQL, and application tuning using multiple tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, and AUTOTRACE.

• Wrote SQL Queries to obtain data from multiple tables to spool into CSV format and provide extracts to businesses and users.

• Develop an ETL database model to carry out new procedures and create various database warehouse dimensions to accept ETL outputs.

• Developed SSIS Packages for different tasks like data cleansing and standardizing, sorting, conditional split, and backup.

• Successfully extracted transformed and loaded data into a data warehouse.

• Involved in data validation by writing several complex SQL queries and involved in back-end testing.

• To communicate effectively with teammates, customers, and management, and provide daily reports to Team Leader.

Environment: SQL Server Management studio (SSMS), HUE, TOAD, SSIS, Microsoft Visual Studio EDUCATION

• PG-Diploma in IT Infrastructure Systems & Security (ITISS) From C-DAC (7 GPA)

• Bachelor of Technology in Electronics and Communication Engineering from Jawaharlal Nehru Technological University Kakinada (75%)

Contact this candidate