AKHILA CIRIGA

Environment: MS SQL Server 2024/2014/2012/2008, ,T-SQL, Python, Powershell, JSON, NRQL, Jmeter, RedShift, Microsoft Azure DBS, AWS RDS

Responsibilities:

• Responsible for overall performance of Trimble application.
• Identified slow performing pages and Optimized around 3000+ SQL queries to run them under 2.2 seconds
• Worked on SQL Standardization Project, which standardizing Indexes , Database Objects, Collations, server and database settings across 12 Prod and 25 Non prod environments
• Worked on SQL Jobs Project that ensured every job exists on all nodes and runs only as needed
• Identified Log tables over 400 GB, analyzed and compressed it to 11 GB using scripts.
• Worked on Account migration/Export projects between US/Canada Environments that involved creating test scripts and merge scripts.
• Migrated 4 SQL Server databases to Azure SQL Database using Azure Database Migration Service.
• Developed and automated ETL processes using Azure Data Factory and Azure data Studio to transform and load data from the legacy SQL Server environment into the new Azure SQL Database.
• Performed In-depth analysis before Lift and shift migration and supported Post -Migration with Azure Auto -tuning and Manual clean up for optimal performance and storage efficiency.
• Monitored, Analyzed New relic and DPA to look at slow transactions and Optimized them.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and networking)
• Created appropriate indexes by analyzing the execution plans to optimize any slow running Queries, by rebuilding or updating statics based on analysis.
• Rewritten SQL Queries for better performance
• Worked on removing Deadlocks for cost transaction which caused critical issue on import process
• Designed and created schema objects such as Tables, Views, Indexes, Functions and maintained Referential Integrity through FK's and PK's
• Created and automated SQL scripts to generate Usage report on a monthly basis based on certain criteria using SQL Agent.
• Worked on advanced T-SQL coding like CTE's, Pivots, Subqueries, Transactions (handling deadlocks), Materialized Views, Dynamic SQL etc
• Performance tuning of SQL queries using SQL Profiler, Estimated Query Plan and Index Tuning Wizard
• Worked on Full text search for text columns by creating full text indices and manipulating noise words
• Worked on Docker and container to test SQL changes.
• Worked on call support to resolve issues whenever needed
• Worked on Kanban Methodology

Environment:
MS SQL Server 2014/2012/2008, SSDT, Visual Studio 2010/2008, T-SQL, Data Warehouse (OLAP), MDX, SSAS, Informatica, Windows NT/XP, MS Office 2003

Responsibilities:

• Designed and architected scalable database structures to support the Texas State Agency’s Employee retirement systems, integrating data across departments and platforms.
• Worked extensively with HIPAA and non-HIPAA data, ensuring secure architecture for compliance and reporting accuracy.
• Integrated employee demographic and insurance claims data, designing robust schemas to ensure referential integrity and optimal data retrieval.
• Led database design initiatives by analyzing source data and implementing normalization techniques to ensure efficiency and scalability.
• Developed mappings and sessions using Informatica PowerCenter 8.6 to support enterprise ETL flows, structured to fit the architectural data models.
• Applied architectural best practices in transformation logic using Filter, Expression, Lookup, Aggregate, Update Strategy, and other Informatica components.
• Wrote high-performance SQL logic using advanced joins, hints, and subqueries to support reporting and downstream system requirements.
• Designed and implemented stored procedures and data flows from Oracle to SQL Server, ensuring schema compatibility and integrity.
• Used SQL Server Profiler and Database Tuning Advisor (DTA) to guide architectural tuning decisions for T-SQL and MDX performance improvements.
• Created constraints, indexes, and views to enforce business rules and enhance system maintainability.
• Designed source-to-target data mappings across source (Oracle), staging, data warehouse, and multidimensional cubes to support consistent enterprise data architecture.
• Generated and automated reports for legislative districts, architecting data flows that ensured reporting reliability and accuracy.
• Authored and executed test cases to validate historical aggregations, ensuring integrity across all data layers using SQL and MDX.
• Deployed SSRS reports on SQL Server 2012 Report Server, verifying data accuracy and ensuring conformance with dimensional models.
• Documented architectural artifacts including user manuals and technical support guides to support system use and maintenance.
• Built dimensional models (Star and Snowflake schemas), defining facts, dimensions, measures, and granularity to support SSAS cubes.
• Designed and manipulated multidimensional cube data using MDX scripting to support executive-level analytics.
• Published SSRS reports to Microsoft Office SharePoint Server 2007 (MOSS), integrating with the broader BI architecture.
• Architected the transition of systems from SQL Server 2012 to 2014, including full rebuild and optimization of schema and data migration strategies.
• Pulled and structured data from multiple sources (Excel, flat files, Oracle) into SQL Server, ensuring alignment with overall data architecture using OLE DB.
• Configured automated alerts for success/failure of data processes, embedding reliability into architectural design.
• Created stored procedures for XML integration, transforming SQL data into XML format using Open XML, FOR XML, and XML PATH.
• Participated in redesign and development of backend SQL Server databases for performance and scalability improvements.
• Allocated and reorganized database objects across appropriate filegroups to optimize data access and ease future maintenance.
• Managed version control using SVN Tortoise and TFS, tracking changes to architectural objects and deployment scripts.

Environment: MS SQL Server 2012/2008, SSIS 2008/2012, SSDT, Visual Studio 2010/2008, T-SQL, Windows NT/XP, MS Office 2003

Responsibilities:

• Designed, developed, and tested advanced SSIS packages in SQL Server 2008/2012 to support robust ETL processes.
• Built dynamic SSIS solutions integrating data from flat files, Excel, Oracle, and SQL sources, applying transformations and loading into target SQL databases.
• Developed scalable ETL frameworks using configuration files, variables, and parameterized controls to ensure package reusability and maintainability.
• Implemented robust error handling, auditing, and logging mechanisms within SSIS packages to ensure data integrity and process traceability.
• Automated ETL executions using SQL Server Agent, with proactive monitoring of failures and long-running jobs.
• Migrated legacy DTS packages to SSIS 2012, improving package performance and structure using SSDT.
• Created Master SSIS packages to orchestrate multi-step data load processes using sequence containers and precedence constraints.
• Applied Slowly Changing Dimensions (SCD) techniques to manage historical data changes in data warehouse dimensions.
• Used checkpoints and event handlers to enable package recovery and manage failures gracefully.
• Coordinated with QA and DevOps for version control, deployment pipelines, and CI/CD automation of ETL processes.
• Created archival solutions for old data/files and managed metadata across all ETL components.
• Collaborated with project managers, technical leads, and SMEs to gather business and functional requirements, translating them into technical specifications.
• Designed business workflows, functional design documents, and detailed test plans for both data and reporting projects.
• Developed relational and dimensional database objects including tables, views, indexes, stored procedures, triggers, and user-defined functions.
• Tuned T-SQL queries and stored procedures for performance optimization using query hints, execution plans, and indexing strategies.
• Refactored redundant or lengthy SQL code into modular stored procedures, improving maintainability and reducing I/O overhead.
• Utilized SQL Server Profiler and DMVs to identify performance bottlenecks and optimize system behavior.
• Addressed database fragmentation through index reorganization and rebuilds, setting appropriate fill factors.
• Wrote complex SQL queries using joins and database links to retrieve and report on multi-source data.
• Conducted unit testing and implemented database deployment scripts as part of the release management process.

Environment:
SQL Server 2012/2008/2005, SQL Server Data Tools (SSDT), SSIS, SSRS, SSAS, T-SQL, Oracle, XML, Windows Server, Microsoft Excel (PivotTables, Charts), FTP/SFTP, DMV, SQL Profiler

Responsibilities:

• Optimized performance of 100+ stored procedures and associated tables/views through indexing, query refactoring, and execution plan analysis.
• Utilized Dynamic Management Views (DMVs) and SQL Profiler to monitor database health, identify performance bottlenecks, and resolve blocking and deadlock issues.
• Designed and maintained materialized views to enhance reporting performance.
• Developed and deployed SSIS packages with control flow elements such as Conditional Split, Derived Column, Multicast, and Union All to meet complex ETL requirements.
• Built SSIS solutions for automated file transfers using FTP tasks and developed a master package to orchestrate sub-package execution.
• Created data integration workflows to migrate data from Oracle to SQL Server using Oracle providers and custom data flow transformations.
• Authored and enhanced stored procedures, views, and user-defined functions to support evolving business requirements and optimize backend logic.
• Implemented schema updates across environments in alignment with changing business logic and reporting needs.
• Managed ETL metadata, job dependencies, and data lineage for enterprise data warehousing processes.
• Designed and deployed SSRS reports using global variables, expressions, and parameters; produced hospital-specific and group-wise performance reports.
• Administered SSRS Report Manager, managing shared data sources, scheduling report execution, and configuring delivery subscriptions.
• Developed visually rich dashboards and analytical reports using charts (bar, line, pie) and pivot tables sourced from SQL databases and OLAP cubes.
• Collaborated with marketing and analytics teams to translate business requirements into actionable BI solutions.
• Used user-defined functions to encapsulate reusable business logic, enhancing code maintainability and readability.
• Managed test and production environments by synchronizing data and promoting database object changes through deployment pipelines.
• Ensured database integrity and availability through routine maintenance plans covering index rebuilds, statistics updates, and consistency checks.
• Led data conversion and migration efforts from legacy systems and diverse file formats into the data warehouse.

Environment:
SQL Server 2008/2005, Microsoft Business Intelligence Studio (BIDS), T-SQL, SSAS, SSRS, SSIS, XML, Windows NT, MS Visual SourceSafe, CSS, Crystal Reports, ASP.NET

Responsibilities:

• Installed and configured SQL Server 2008 instances across development and production environments to support enterprise applications.
• Applied service packs and critical patches to maintain compliance, performance, and security standards.
• Contributed to implementing database development standards, including naming conventions, object organization, and security best practices.
• Designed and managed schema objects such as tables, views, indexes, stored procedures, and triggers, ensuring referential integrity across the database.
• Developed SQL scripts to insert, update, and delete records in SQL Server databases, ensuring transactional consistency.
• Performed database cleanup by identifying and removing obsolete tables and columns to improve performance and maintainability.
• Created complex stored procedures and user-defined functions based on business logic and reporting needs.
• Developed database views to support UI development and implemented triggers to enforce consistent data entry and auditing.
• Authored advanced SQL queries using joins, subqueries, and correlated subqueries for dynamic data retrieval and reporting.
• Designed and deployed comprehensive SSRS reports (matrix, list, tabular, and charts) with advanced features such as drill-down, drill-through, multi-valued parameters, and security configurations.
• Scheduled and managed SQL Server Agent jobs, tasks, and alerts to automate operational processes and monitor system performance.
  Example: Configured alerts to notify sales managers when discount thresholds were not met for quarterly property renewals.
• Implemented automated database backups based on data volatility and indexing patterns to ensure data recoverability.
• Achieved over 25% improvement in query performance through index tuning, query optimization, and system resource monitoring.
• Used SQL Server Profiler and Performance Monitor to identify and resolve performance bottlenecks at the database and server levels.
• Conducted extensive debugging and code correction as part of ongoing application support and enhancement.
• Defined user roles and permissions, creating security groups and access policies to maintain database confidentiality and integrity.
• Created distributed partitioned views and debugged/troubleshot complex stored procedures to improve code maintainability and execution efficiency.
• Generated business-critical reports using SSRS on the BIDS platform, enabling decision-makers with timely and accurate insights.
• Performed ETL operations to transfer data from Oracle into SQL Server databases, ensuring seamless cross-platform integration.
• Migrated data from legacy systems including flat files, Excel spreadsheets, and MS Access databases into SQL Server using SSIS, resolving transformation constraints and improving data consistency.