Saritha T Email & Phone Number

United States

Project Name: Indicator System Quality BookProject Description: The project deals with the process of data generation for KPI (Key Performance Indicators). It includes generating the reports based on issues, sending automated emails through jobs and auto creation of escalations depending on the performance. The required data is stored in the database and procedures and packages run based on schedulers and the processes used to update the database.Responsibilities:Participated in Design, Coding, Development and ImplementationInvolved in the creation of tables necessary for applicationDeveloped SQL Queries (Sub queries, correlated subqueries and Join conditions). Worked on Stored Procedures, Functions and Packages. Use SQL developer tools for faster application design and developments. Translating business rules into procedures, packages, database triggers and functions using PL/SQL. Worked in Unit testing PL/ SQL Stored Procedures and Functions. Involved in writing Procedures, Functions, Triggers, Packages, Cursors, Dynamic SQLs, Views. Prepared Test Plans and participated in unit testing, system testing, thru production implementation. Worked on business requirements and functional specifications.Developed and tested reports.

Project Name: GamificationProject Description: The project deals with the process of revenue generation of the healthcare provider. It includes supporting the services like patient access, billing, and charge description and denial management. The required data is stored to the database while updating balances and claim status accordingly. UNIX shell scripting is used for the automation of the processes used to update databases.Responsibilities:Participated in Design, Coding, Development and ImplementationInvolved in the creation of tables necessary for applicationDeveloped SQL Queries (Sub queries, correlated subqueries and Join conditions). Worked on Stored Procedures, Functions and Packages. Use SQL developer tool for faster application design and developments. Translating business rules into procedures, packages, database triggers and functions using PL/SQL. Worked in Unit testing PL/ SQL Stored Procedures and Functions. Involved in writing Procedures, Functions, Triggers, Packages, Cursors, Dynamic SQLs, Views and data loading using SQL Loader utility for new/enhance requirements. Prepared Test Plans and participate in unit testing, system testing, thru production implementation. Worked on business requirements and functional specifications.

Project Name:ITR (Issue ToResolve)Project Description:ITR application acts like a documentation for the problems raised by the users. The tickets are routed automatically via emails to the responsible persons. The responsible persons can resolve the issue and enter the corrective actions for the problems.Responsibilities: Participated in design, documentation, development, implementation and testing.Involved in PL/SQL package coding, requirement documentation, testing analysis, and project timeline creation.Work with the backend part migrating various database applications to incorporate with the current application.Prepare guidelines for tuning of application code and assist the team.Developed job schedulers.Wrote database triggers and procedures.Used PL/SQL procedures and functions in packages to organize application.Used PL/SQL Exception Blocks for Trapping Exceptions, Trapping Predefined Oracle Server errors.Involved invalidation, Unit Testing, UAT, System Testing.Front end validations using Java Scripting.

Project Name: GamificationProject Description:The purpose of the Gamification is to provide constructive learning and testing of subject knowledge. It allows individual users to measure his/her knowledge about a particular topic which has been chosen by the trainer. Trainer will create the Quiz games every week. Users will play quiz games and based on accuracy & time taken, he will earn points. For each month, in every department based on accumulated points, user ranking will be there, and user will get rewards.Responsibilities:Application Development (Page and related things) and Database design.WrittenStored Procedures and Queries and Dynamic SQL.Optimized stored procedures for better performance.Created SQL Jobs and Scheduled as per the requirements.Backup/Restore between different environmentsWritten documentation like guides and Implementation plans.worked in analyzing and fix the issues on time.Developed Stored Procedures and Maintained Data Dictionary.Implemented Role based Authentication.