Business Intelligence & Data Analytics Specialist

Pratima Kamath

Irvine Phone: 949-***-**** Email: ***************@*****.***

Professional Summary

Business Intelligence and Data professional with strong experience supporting enterprise applications and SQL Server–based systems. Skilled in analyzing business requirements, interpreting database schemas, and mapping data across integrated enterprise environments. Experienced in supporting reporting, data validation, and reconciliation efforts to ensure accuracy and consistency across systems. Strong background in working with cross-functional stakeholders to translate business needs into technical solutions. Proven ability to support production systems, improve data processes, and contribute to system enhancements in structured and compliance-focused environments.

Technical Skills

Databases: SQL Server (2008, 2012, 2016, 2019, 2022), T-SQL, PostgreSQL

BI & Reporting Tools: Power BI, SQL Server Reporting Services (SSRS)

ETL Tools: SQL Server Integration Services (SSIS)

Data & Database Skills: SQL, T-SQL, DAX, Dimensional Modeling, schema analysis

Database Administration: Backup and recovery, indexing, performance tuning, database maintenance

Cloud: AWS (EC2)

Other Tools: JIRA, GitLab, Visual Studio, Advanced Excel

Professional Experience

IT Consultant / Team Lead / SME

Gam Solutions Inc

Client: California Housing Finance Agency (CalHFA)

August 2021 – Jan 2025

Partner with business stakeholders to gather, document, and validate system and reporting requirements.

Analyze business workflows and map requirements to SQL Server–based enterprise applications.

Interpret database schemas, table relationships, and embedded business logic to ensure accurate reporting.

Lead ETL processes using SSIS to integrate financial and operational data across systems.

Support data validation and reconciliation to maintain reporting consistency.

Contribute to system enhancements and modernization initiatives through data integration and reporting improvements.

Serve as SME for reporting and data-related functionality, mentor junior developers.

Manage database performance, backups, and tuning in AWS EC2 environments.

Key Results:

Improved query performance by 40% through optimization and tuning.

Automated 90% of recurring reports, reducing manual effort and errors.

Resolved 100% of critical production issues within SLA.

SQL Server Report Developer / Production Support Analyst

Springboard Solutions

August 2011 – December 2018

Supported enterprise reporting systems integrating financial and operational data.

Worked with cross-functional teams to translate business reporting needs into technical solutions.

Reviewed database schemas and business rules to troubleshoot data inconsistencies.

Performed data validation and reconciliation across reporting and source systems.

Led production support for SQL Server, SSIS packages, and SSRS reports.

Managed database maintenance, backups, indexing, and performance tuning.

Assisted in reporting system upgrades and legacy system migration to SSRS.

Key Results:

Reduced data processing time by 30% through SQL and SSIS optimization.

Maintained 90%+ SLA resolution rate for production support issues.

EDUCATION

Master of Science, Computer Science

California State University, Long Beach

Bachelor of Engineering, Computer Science

Visveswaraiah Technological University, India

Contact this candidate