Highlights

• 6+ Years of experience in SQL/T-SQL using Microsoft SQL Server 2016/2012/2008R2.


• I have been working with Teknikoz from July 23 to Present.


• Have Experience in Sybase(Rapid SQL) Developer


• Expertise in developing Store procedures, Database triggers, and Stored Functions.


• I have Good experience in the Health Care Domain.


• Hands-on experience in Developing SQL Server Reporting Service-Reports(Grouping, Matrix, Drill Down, Drill through Reports) and report Subscriptions in SSRS.


• Good experience in Product Development &Production Support Projects.


• Good experience in Database Performance Tuning.


• Good Experience in Performance tuning of SQL Queries and Store procedures with the help of SQL Profiler.


• Extensive experience in Troubleshooting production issues.


• Experience in Data Migration from Oracle to SQLServer.


• Experience in Data Transfer between SQL Servers using tools like Bulk Copy(BCP) and export/Import Utility.


• Experience in Database Administrative activities like Database Creation, Database Backup/Restore, Job Scheduling, Index Rebuild/Reorganize, Create/Update Statistics and Maintenance plans.

Skills

Primary Skills

SQL

SQL Queries

Secondary Skills

Data Migration

Projects

Software Engineer (6 months)

• Product:     Anthem Clients


• Client.   :     PSR 15914(Anthem NY)


• Environment:   DEV and QA servers


• Project Description: AIM Specialty Health is a separate company providing utilization review services on behalf of Anthem Blue Cross and Blue Shield. AIM services include management of Cardiology and Genetic Testing. Musculoskeletal, Radiology, Radiation Therapy, Rehabilitation (PT, OT, ST), Sleep Testing and Therapy, Specialty Pharmacy, and Upper Gastrointestinal Endoscopy. All these services require precertification or pre-notification. AIM also administers the Cancer Care Quality Program


• Lead Solutions Engineer - New Client On-boarding | Oncology, Specialty Drugs, Radiology


• Develop technical solutions in a highly conversational OLTP environment


• Perform hands-on software development and design while serving as a team lead and mentor for two developers


• Research and document gaps in DevOps data tools and processes


• Lead Database Engineer - Preauthorization Program | Health plan partners/clients


• Served as a technical lead for database-centric software development projects of high complexity


• Conduct design and SQL code walk-thru of AlM database solutions to ensure adherence to the business requirements quality, and company standards


• Assess performance and develop scalable solutions






Responsibilities:






• Created stored procedures, triggers, functions, and views.


• Involved in troubleshooting and fine-tuning the database for performance.


• Analyze long-running slow queries and tune.


• Worked on Jira stories which the business analyst assigned


• Updating Daily status to the team during onshore timings at the end of the day


• Pushing the code to release the branch through the bit bucket


• Identifying and Resolving Blocking and Locking related issues


• Involved in index Analysis and Performance Tuning.


• Deploying new code base release to UAT and Production Environments.


• Respond to trouble tickets and fix any database issues.

Software Engineer (12 months)

• Product:     Anthem Clients


• Client.           :     PSR 16024(Anthem CR)


• Environment:   Dev and QA servers


• Project Description: AIM Specialty Health is a separate company providing utilization review services on behalf of Anthem Blue Cross and Blue Shield. AIM services include management of Cardiology and Genetic Testing. Musculoskeletal, Radiology, Radiation Therapy, Rehabilitation (PT, OT, ST), Sleep Testing and Therapy, Specialty Pharmacy, and Upper Gastrointestinal Endoscopy. All these services require precertification or pre-notification. AIM also administers the Cancer Care Quality Program


• Lead Solutions Engineer - New Client On-boarding | Oncology, Specialty Drugs, Radiology


• Develop technical solutions in a highly conversational OLTP environment


• Perform hands-on software development and design while serving as a team lead and mentor for two developers


• Research and document gaps in DevOps data tools and processes


• Lead Database Engineer - Preauthorization Program | Health plan partners/clients


• Served as a technical lead for database-centric software development projects of high complexity


• Conduct design and SQL code walk-thru of AlM database solutions to ensure adherence to the business requirements quality, and company standards


• Assess performance and develop scalable solutions






Responsibilities:






• Created stored procedures, triggers, functions, and views.


• Involved in troubleshooting and fine-tuning the database for performance.


• Analyze long-running slow queries and tune.


• Worked on Jira stories which the business analyst assigned


• Updating Daily status to the team during onshore timings at the end of the day


• Pushing the code to release the branch through the bit bucket


• Identifying and Resolving Blocking and Locking related issues


• Involved in index Analysis and Performance Tuning.


• Deploying new code base release to UAT and Production Environments.


• Respond to trouble tickets and fix any database issues.

Software Engineer (5 months)

• Product:     Anthem Clients


• Client.           :     PSR 16024(Anthem CR)


• Environment:   Dev and QA servers


• Project Description: AIM Specialty Health is a separate company providing utilization review services on behalf of Anthem Blue Cross and Blue Shield. AIM services include management of Cardiology and Genetic Testing. Musculoskeletal, Radiology, Radiation Therapy, Rehabilitation (PT, OT, ST), Sleep Testing and Therapy, Specialty Pharmacy, and Upper Gastrointestinal Endoscopy. All these services require precertification or pre-notification. AIM also administers the Cancer Care Quality Program


• Lead Solutions Engineer - New Client On-boarding | Oncology, Specialty Drugs, Radiology


• Develop technical solutions in a highly conversational OLTP environment


• Perform hands-on software development and design while serving as a team lead and mentor for two developers


• Research and document gaps in DevOps data tools and processes


• Lead Database Engineer - Preauthorization Program | Health plan partners/clients


• Served as a technical lead for database-centric software development projects of high complexity


• Conduct design and SQL code walk-thru of AlM database solutions to ensure adherence to the business requirements quality, and company standards


• Assess performance and develop scalable solutions






Responsibilities:






• Created stored procedures, triggers, functions, and views.


• Involved in troubleshooting and fine-tuning the database for performance.


• Analyze long-running slow queries and tune.


• Worked on Jira stories which the business analyst assigned


• Updating Daily status to the team during onshore timings at the end of the day


• Pushing the code to release the branch through the bit bucket


• Identifying and Resolving Blocking and Locking related issues


• Involved in index Analysis and Performance Tuning.


• Deploying new code base release to UAT and Production Environments.


• Respond to trouble tickets and fix any database issues.

Sr. Database Developer (12 months)

Product:  Laboratory Information System(LIS)





Client:    Vijaya Diagnostics,





Environment:  SQL Server 2012, ASP.Net 3.5, IIS 7.0, Windows 7/2003.





Project Description: HIMS.NET has been developed based on HIMS VB 6.0 product for processing and management of various hospital's information. This package is flexible and modular and can be customized to suit the needs of different hospitals. The entire system consists of various information modules catering to different activities of a hospital. The Various Modules are Front Office, In/Out Patients, Billing, Laboratory, Medical Records, Financial management, Pharmacy, Security Management, Shift Collections, Nurse Management, Doctors and Stores, etc.,





Responsibilities:






• Created stored procedures, triggers, functions, and views.


• Database Administrator in a production environment.


• Involved in creating procedures for database backups.


• Involved in troubleshooting and fine-tuning the database for performance.


• Analyze long-running slow queries and tune.


• Created SQL server Reports using SSRS.


• Created Cross-Tab, Drill-down, Drill-down, and Sub-Report using and linked reports using SQL Server Reporting Services.


• Creating Stored Procedures for report generation.


• Creating MIS Reports for Daily Collection.


• Identifying and Resolving Blocking and Locking related issues


• Involved in index Analysis and Performance Tuning.


• Deploying new code base release to UAT and Production Environments.


• Respond to trouble tickets and fix any database issues.

Database Developer (12 months)

Product:  Laboratory Information System(LIS)





Client:    Vijaya Diagnostics,





Environment:  SQL Server 2012, ASP.Net 3.5, IIS 7.0, Windows 7/2003.





Project Description: HIMS.NET has been developed based on HIMS VB 6.0 product for processing and management of various hospital's information. This package is flexible and modular and can be customized to suit the needs of different hospitals. The entire system consists of various information modules catering to different activities of a hospital. The Various Modules are Front Office, In/Out Patients, Billing, Laboratory, Medical Records, Financial management, Pharmacy, Security Management, Shift Collections, Nurse Management, Doctors and Stores, etc.,





Responsibilities:






• Created stored procedures, triggers, functions, and views.


• Database Administrator in a production environment.


• Involved in creating procedures for database backups.


• Involved in troubleshooting and fine-tuning the database for performance.


• Analyze long-running slow queries and tune.


• Created SQL server Reports using SSRS.


• Created Cross-Tab, Drill-down, Drill-down, and Sub-Report using and linked reports using SQL Server Reporting Services.


• Creating Stored Procedures for report generation.


• Creating MIS Reports for Daily Collection.


• Identifying and Resolving Blocking and Locking related issues


• Involved in index Analysis and Performance Tuning.


• Deploying new code base release to UAT and Production Environments.


• Respond to trouble tickets and fix any database issues.

Database Developer (12 months)

Product:  Laboratory Information System(LIS)





Client:    Vijaya Diagnostics,





Environment:  SQL Server 2012, ASP.Net 3.5, IIS 7.0, Windows 7/2003.





Project Description: HIMS.NET has been developed based on HIMS VB 6.0 product for processing and management of various hospital's information. This package is flexible and modular and can be customized to suit the needs of different hospitals. The entire system consists of various information modules catering to different activities of a hospital. The Various Modules are Front Office, In/Out Patients, Billing, Laboratory, Medical Records, Financial management, Pharmacy, Security Management, Shift Collections, Nurse Management, Doctors and Stores, etc.,





Responsibilities:






• Created stored procedures, triggers, functions, and views.


• Database Administrator in a production environment.


• Involved in creating procedures for database backups.


• Involved in troubleshooting and fine-tuning the database for performance.


• Analyze long-running slow queries and tune.


• Created SQL server Reports using SSRS.


• Created Cross-Tab, Drill-down, Drill-down, and Sub-Report using and linked reports using SQL Server Reporting Services.


• Creating Stored Procedures for report generation.


• Creating MIS Reports for Daily Collection.


• Identifying and Resolving Blocking and Locking related issues


• Involved in index Analysis and Performance Tuning.


• Deploying new code base release to UAT and Production Environments.


• Respond to trouble tickets and fix any database issues.