Sundeep M K S

As an accomplished Oracle Developer, I bring a robust six-year track record in the IT industry, specializing in database development. My expertise is deeply rooted in the Health Care Sector, where I have honed my skills and knowledge. I possess an in-depth understanding of Oracle Architecture, complemented by a comprehensive grasp of Data Dictionary, DBMS Packages, and advanced Normalization Techniques. My development proficiency is demonstrated through my adeptness in crafting intricate SQL queries, Stored Procedures, Functions, and Packages. Additionally, I am skilled in the creation of Database Triggers and SQL Loader scripts, all of which underscore my technical acumen and commitment to excellence in database management and optimization.

• Secured Striving for Excellence Award - Cognizant Technology Solutions
• Secured AOQ (Associate of Quater) - Cognizant Technology Solutions
• Secured Above & Beyond award for CTB (Change the Business) - 2019 - Cognizant Technology Solutions

• Requirement Analysis and Design Analysis of functionality received from the clients.
• Coding and code reviews.
• Creating and Verifying Unit test cases and unit test plan document for the developed modules.
• Interacting with business analyst to identify proper design solutions.
• Taking ownership of all developed modules.

EMBLEM HEALTH - Post Production Maintenance (PPM) (01/2023 - Present)

• Analyzing the requirement for each newly created PPM across membership tower and preparing the code design once requirement is finalized.
• Implementation of the code design and unit testing is done in development regions along with unit test case document.
• Deployment to test region, validating the defects in testing region and providing the defect fix if required.
• Deployment to production and production validation support until warranty period is covered.

EMBLEM HEALTH - Enrollment Error Reduction (04/2022 - 12/2022)

• Analyzing Various errors which can be eliminated instead of getting captured in the error report and processing them successfully in the FACETS system.
• Modifying the components accordingly to restrict the transaction getting captured in the report and to process them into FACETS.

EMBLEM HEALTH - CNY Anthem Enrollment (04/2021 - 03/2022)

• Enrolling City of New York Subscribers to FACETS system from Anthem system.
• Validations are performed on whether members fulfill the criteria required by the business and facets system.
• Once validations are successful, members are enrolled into facets. If unsuccessful, they are pulled in error reports and sent for business review.

EMBLEM HEALTH - GHI Enrollment Performance Tuning (01/2021 - 03/2021)

• Identifying the areas where performance is low while processing a large number of records.
• Modifying the queries accordingly to increase the performance while processing a large number of records.

EMBLEM HEALTH - Facets FET DB Upgrade (05/2019 -12/2020)

• Identifying the components which have an impact due to the FET upgrade and Analyzing the impact.
• Modifying the components which have impact according to the new FET structure and Testing whether existing functionality is not affected.
• Deploying the changes in the components to production.

EMBLEM HEALTH - Provider Assignment Process (01/2018 - 06/2018)

• Enrolling City of New York Subscribers to FACETS system from QCARE system enrolled in HMO plans.
• Validations are performed on whether members fulfill the criteria required by the business and facets system.
• Once validations are successful, members are enrolled into facets. If unsuccessful, they are pulled in error reports and sent for business review.

EMBLEM HEALTH - Provider Assignment Process (01/2018 - 06/2018)

• Assigning valid Primary care provider (PCP) to the members enrolled.
• If Primary Care Provider is not initially assigned to the members at the enrollment time, the Provider assignment process will automatically assign the default PCP for a period of 60 days.
• If Default PCP is assigned to a subscriber for more than 60 days, the Provider assignment process will automatically assign Primary Care Provider based on the Plans opted for and the area where the customer is residing.

EMBLEM HEALTH - Enrollment Kit process in FACETS (03/2017 - 12/2017)

• The Enrollment Kit process consists of sending ID cards and Welcome kit letter extracts for the subscribers who are initially enrolled in the FACETS system with valid products.
• ID Cards and welcome extracts are extracted after various validations based on their eligibility, Providers assigned, and product opted by the members.
• The Extracts are finally sent from FACETS to corresponding Vendors for printing ID cards, Welcome Kit and are dispatched to the customers.