Karishma Gajjala

Data Analyst professional with 5.5 years’ experience in designing, coding, testing and supporting next-generation database solutions in Database warehousing, Business Intelligence, performance optimization, query, objective environment, and PL/SQL Server environments. I have a passion for learning and implementing new technologies and techniques, which has helped me stay updated with the latest trends in the industry. Proficient in writing complex SQL queries using joins, sub queries, and correlated sub queries to retrieve data. Have experience at using Triggers to carry out various tasks from the database. My focus on performance tuning of T-SQL queries, including index tuning, query optimization, and partitioning, has enabled me to optimize the efficiency of database solutions. I have extensive experience in designing and developing SSIS Packages for loading data from text files and CSV files to SQL Server databases using SSIS. Proficient in migrating data between different heterogeneous sources such as Flat file and Excel 2005, and in using different control flow elements like Data Flow Task, Execute SQL Task, Script Task, and Send Mail Task. Experienced in using different data flow elements like Flat File, OLEDB, Excel Sources and Destinations, and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column, etc. Configured Backups, Optimization jobs and involved in Restoring database to point in time in case of issues. Have experienced in enhancing and deploying the SSIS Packages from development server to production server. Experienced with working on reporting tools like Crystal Report, SSRS and Report Builder 3.0. Created Database Objects like tables, views, functions and developing procedures for implementing application functionality at the database side for performance improvement. Extract, Transform, and Load (ETL) data from source systems to AWS data storage services using a combination of AWS Glue, Amazon Athena (for SQL-based querying), Apache Spark (via AWS Glue or Amazon EMR), and custom Python/SQL scripts. Data ingestion is performed into one or more AWS services – (Amazon S3, Amazon RDS, Amazon Redshift, AWS Data Lake Formation) and the data is processed using Amazon EMR or AWS Glue with Apache Spark for scalable transformation and analytics. Expert in creating multiple kinds of Power BI Reports, Dashboards and Visualizations Created a basic table report using MSSQL, SSRS and SSDT. Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.

• PNC, India, Data Analyst, Collaborated closely with end-users to write functional specifications based on business requirements., Analyzed source data and worked with the Data Warehouse team to develop Relational Models., Implemented and managed ETL solutions, focusing on automating operational processes and ensuring high data quality., Wrote complex SQL queries using joins, subqueries, and correlated subqueries to retrieve data, and created Triggers to perform various tasks within the database., Focused on performance tuning of index tuning, query optimization, and partitioning., Deployed SSIS packages in Development and Testing environments, creating ETL packages to validate, extract, transform, and load data into the data warehouse and data mart databases., Designed and developed SSIS packages for loading data from text files, CSV files, and other sources to SQL Server databases., Scheduled SSIS jobs using SQL Server Agent for daily, weekly, and monthly loads., Migrated data between different heterogeneous sources, including Flat files and Excel, using SSIS., Experience in Error handling, Debugging, error logging for production support in SSIS., Used various control flow elements, such as Data Flow Task, Execute SQL Task, Script Task, and Send Mail Task, and data flow elements, such as Flat File, Excel Sources and Destinations, and Data Flow Transformations like Data Conversion, Conditional Split, and Derived Column., Created Schema Database diagrams, Table structures, and maintained relationships with constraints and indexes as per business logic., Created Stored Procedures, User Defined Functions (UDF), Views, Joins, and System Defined Functions, as well as Temp Tables and Table Variables., Wrote complex T-SQL queries using joins, subqueries, and correlated subqueries to retrieve data and used Triggers to perform various tasks within the database., Created DAX Queries to generate computed column in Power BI., Expert knowledge in SDLC (Software Development Life Cycle) and was involved in all phases in projects.
• Barclay’s India, Data Analyst, Installation and configuration of MS SQL Server 2008/12/14 on window 2007/8 OS., Created Database and Database objects like Views, Indexes, Trigger and Stored Procedures using T-SQL., Hand on experience in analyzing, design, and build modern data solutions using Azure PaaS service support., Visualization of data., Extract/transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics., Done Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks., Troubleshooted and resolved SQL Server connectivity issues., Created SQL statements, extracted and transformed data using SSIS., Used SQL Server Profiler to monitor the server Database Tuning, Application Tuning, performance monitoring, debug T-SQL and slow running scripts and maintained documentation., Created a basic table report using MSSQL, SSRS and SSDT., Simplifying complex queries using minimum joins and sub-queries involving multiple tables., Maintain database security with up-to-date patches, created and maintained users and roles, assign privileges., Performed and planned database backup, restore and recovery when necessary., Experience in troubleshoot issues with ETL load (SSIS and Stored Procedures) and Cube processing., Created SSRS dashboards using charts, gauges, indicators and data bars., Deployed SSRS reports in native and share point mode., Based on the requirement for different executive dashboards, analysis and model flows from various sources to integrate into Tableau Dashboard., Used Power BI, Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize Report., Used Power BI Gateway and Scheduled Automatic Refresh to keep the Reports and Dashboards up to date.