Systems Analyst Sql Server

PRABHA KANNAN

****, ********* *****, **********, ** -30004

Mobile (WhatsApp): +91-988*******

Mobile (Alternate): +1-470-***-****

E-mail: *******************@*****.***

Professional Summary

SQL Developer / Database Analyst with 12+ years of experience in designing, optimizing, and managing enterprise-level databases across healthcare, mining, and financial domains. Proficient in MS SQL Server (2005–2022), T-SQL, SSIS, performance tuning, and ETL processes. Recognized for improving query performance, leading data migration projects, and collaborating with global teams. Authorized to work in the U.S. on L2 visa (no VISA sponsorship required).

Core Skills

SQL Server 2005–2022 T-SQL Stored Procedures Functions Triggers

Database Design Query Optimization Indexing Performance Tuning

SSIS (ETL Development) Data Migration ER Modelling

C#, VB.NET, ADO.NET, ASP.NET XML HTML JavaScript

Azure DevOps TFS Git Agile & SDLC

Domain Expertise: Healthcare, Mining, Financial Services

Professional Experience

Senior Systems Analyst

Equiniti India Jan 2017 – Dec 2024

Client: UK Pensions (NHS / MyCSP, UK)

Optimized SQL stored procedures and functions, reducing execution time by 40%.

Designed ER diagrams, tables, and validation logic for pension administration systems.

Led integration of DataSure (data migration tool) with Compendia (workflow system).

Partnered with U.K. client teams during an on-site engagement in Crawley.

Recognized as Best Performer for SQL performance optimization.

Promoted from Senior Software Engineer to Senior Systems Analyst for outstanding contributions.

Key Technologies: SQL Server 2022, VB.NET, Azure DevOps Repo

Programmer Analyst

Computer Sciences Corporation Jul 2012 – Jan 2017

Client: BHPB Coal (Mining, Australia)

Developed SQL queries, stored procedures, triggers, and automation scripts.

Converted manual workflows into automated SQL jobs, improving efficiency.

Created and optimized SQL objects and SSIS reports for mining operations.

Diagnosed and resolved performance bottlenecks using SQL Profiler & Tuning Advisor.

Client: HFHS – CarePlus Next Generation (Healthcare, U.S.)

Built SQL procedures, queries, and database objects for EMR system.

Performed unit and integration testing, ensuring data accuracy and system reliability.

Enabled clinicians with real-time, accurate access to patient data.

Key Technologies: SQL Server 2005–2014, SSIS, C#.NET, ADO.NET, Web Services

Education

B.E. Computer Science & Engineering – Anna University, India (2012)

Certifications & Achievements

Recognized by UK NHS client for SQL performance improvements.

Multiple awards for high performance and project delivery.

Career Progression: Promoted from Senior Software Engineer Senior Systems Analyst.

Work Authorization

L2 Visa Holder – Authorized to work in the U.S. without employer sponsorship.

Contact this candidate