Pushpalatha Subbakkagari

• I.T. Professional with 3.2 years of experience in MICROSOFT SQL SERVER Development with a talent for analyzing problems, developing and simplifying procedures and finding innovative solutions.
• Good exposure to DATA WAREHOUSING CONCEPTS. Experince in the field of IT Testing services with focus on DATABASE and ETL TESTING Ability to work independently or within a Team. Good Inter Personal skills, team player. Strong Knowledge on SQL Commands (DML, DQL, TCL, DDL).
• Good Knowledge in Software Development Life Cycle SDLC and Test Life Cycle STLC.
• Extensively used Workflow manager, Workflow monitor in Informatica ETL Tool.
• Extensive experience with SQL Server and T-SQL in constructing Stored procedures, Table variables,Userfunctions, While loops, Views, Indexes, Cursors. Strong knowledge On SQL Triggers (For triggers, instead of triggers).
• Experience on SQL-Joins, Set operators. Strong Knowledge on Systemfunctions(String functions, date functions, Aggregate functions, Rank functions, Cast and Convert functions) Experience on Temp-tables, Sub queries, CTE(Common table expression) and Recursive CTE.
• Used xml and xml data types in stored procedures for passing multiple values through parameters. Strong knowledge On Dynamic SQL (Execute Sql), TCL (Transaction Control Language) and Error handling. Good Knowledge on Performance Tuning and creating indexes In-order to improve Query Performance.
• Strong Knowledge on loading data from different source systems(Flat file source, Excel source) into SQL server Through SQL Import Export Wizard.
• Knowledge on SCD1, SCD2 techniques and Normalization concepts. Extensive experience in: Installing all versions of SQL Server(SQL server 2008/2012).

• Date of Birth: 04/11/99
• Gender: Female
• Nationality: Indian
• Marital Status: Unmarried

PROJECT NAME #3: 

RxS STRATEGIES HEALTH  CARE CLIENT : JOHN MCLAUGHLIN'S (USA)  

TEAM SIZE : 14  

DURATION : FEB 2023 - JAN 2024  

TECHNOLOGIES : SQL SERVER 2017 - 2019 AND  MS - EXCEL

DESCRIPTION :

DHS is an application which maintains all the  information about patient details under this we  have active Modules are Pharmacy Module,  Doctors Module. This module deals with the retail  sale of medicines to general customers & OPD  patients, and issue of medicines to the in-patients in  the hospital. Its functions include online drug  prescription and inventory management and billing  of drugs, surgical and consumables. There is a link  between Doctor module and Pharmacy Module. It  stores All Medical information means drug  information.

ROLES & CONTRIBUTION:

• Participated in testing STM (Source Target Mapping) documents and make sure they are in synchronization with BRD
• Involved in preparation and execution of test cases
• Validating source and target tables as per Requirements
• Validating duplicates in target tables
• Validating new and old checksums
• checking the count is matched between source and target tables
• Null checks, duplicates checks and tables count checks
• Participated in Weekly Project status and bug status meetings and updated the testing Progress.
• Involved in meetings with business analyst and developers during requirements gathering
• Prepared test cases, test data, requirements gathering, change in requirements etc.
• Attending calls for updating the status on a daily basis
• Defect tracking and reporting
• Verifying the column mapping between source and target databases
• Worked closely with Dev team.

PROJECT NAME #2 : 

DOCTORS - PHARMACY  MODULE SYSTEMS  

CLIENT : NORTON'S HOSPITAL  (USA)  

TEAM SIZE : 8  TECHNOLOGIES : SQL SERVER 2008 - 2012 & MS  EXCEL  DURATION :  JUN 2021 - JAN 2023

DESCRIPTION:  

DHS is an application which maintains all the  information about patient details under this we  have active Modules are Pharmacy Module,  Doctors Module. This module deals with the retail sale of medicines to general customers & OPD  patients, and issue of medicines to the in-patients in  the hospital. Its functions include online drug  prescription and inventory management and billing  of drugs, surgical and consumables. There is a link  between Doctor module and Pharmacy Module. It  stores All Medical information means drug  information.

ROLES & CONTRIBUTION:

• Participated in testing STM (Source Target Mapping) documents and make sure they are in synchronization with BRD
• Involved in preparation and execution of test cases
• Validating source and target tables as per Requirements
• Validating duplicates in target tables
• Validating new and old checksums
• checking the count is matched between source and target tables
• Null checks, duplicates checks and tables count checks
• Participated in Weekly Project status and bug status meetings and updated the testing Progress.
• Involved in meetings with business analyst and developers during requirements gathering
• Prepared test cases, test data, requirements gathering, change in requirements etc.
• Attending calls for updating the status on a daily basis
• Defect tracking and reporting
• Verifying the column mapping between source and target databases
• Worked closely with Dev team.

PROJECT NAME #1 : 

HEALTH CARE SYSTEM  

CLIENT : NORTON'S HOSPITAL  (USA)  

TEAM SIZE : 8  

TECHNOLOGIES : SQL SERVER 2008 & MS  EXCEL DURATION : NOV 2020 - MAY 2021

DESCRIPTION:

DHS is an application which maintains all the  information about patient details under this we  have active Modules are Registration, Outpatient,  Billing (OP Billing), Inpatient Billing (IP Billing), OT  Modules etc. DHS caters primarily to the  professionals of Medical, visionary doctors, Nursing,  Pharmacy, Physiotherapy, Paramedical, Allied  Health, and the related fields. Major Service  Offerings are in the fields of Healthcare and Medical  Microjob and Journals Publishing, And Research &  Publication Consultation and Assistance.We have been a part of your lives and have dispensed  quality medical information related to all fields and  diseases.DHS would help the hospital group to  integrate the data under a system which avoids  possibility of human error, since the tests and  feeding of information are automated. This would  allow it to store the information on electronic  format. The data could then be offered as an  electronic patient health record (PHR), to the  patients for future treatments and checkups. It has  totally 28 modules till now which includes  Registration, Wards IP and OP, ES, Admissions &  Transfers, Material Management.

ROLES & CONTRIBUTION:

• Participated in testing STM (Source Target Mapping) documents and make sure they are in synchronization with BRD
• Involved in preparation and execution of test cases
• Validating source and target tables as per Requirements
• Validating duplicates in target tables
• Validating new and old checksums
• checking the count is matched between source and target tables
• Null checks, duplicates checks and tables count checks
• Participated in Weekly Project status and bug status meetings and updated the testing Progress.
• Involved in meetings with business analyst and developers during requirements gathering
• Prepared test cases, test data, requirements gathering, change in requirements etc.
• Attending calls for updating the status on a daily basis
• Defect tracking and reporting
• Verifying the column mapping between source and target databases
• Worked closely with Dev team.