Sarath kumar

• Worked as a Support Specialist in NIQ, specializing in the OGRDS system.
• Streamlined the process of receiving and processing exceptions in the autocoding module, ensuring efficient delivery to end consumers.
• Created Database Objects such as Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, and Cursors as per business requirements.
• Developed a robust database architecture, optimizing data retrieval and storage processes for improved performance.
• Proficient in Ref cursor, bulk collect, PLSQL Collections, Dynamic SQL, Exception handling, Indexes, and correlated subqueries.
• Utilized advanced PL/SQL techniques, such as Ref cursor and bulk collect, to enhance the efficiency and accuracy of data processing.
• Experienced in debugging and tuning PL/SQL code using Explain plan for Oracle database. Utilized SQL loader for loading data from interfacing application flat files.
• Identified and resolved performance bottlenecks in the PL/SQL code, resulting in significant improvements in database query execution time.
• Collaborated with cross-functional teams to gather requirements and provide timely and accurate data solutions.
• Fostered effective communication and ensured alignment between technical and business teams, resulting in seamless integration of data solutions into existing business processes.

• Created a responsive web application using MERN & PERN stack to enhance user experience and improve overall performance.
• Acted as module owner for the orders and payments module, allowing salespeople to easily track their orders and incentives, resulting in increased sales and improved efficiency.
• Utilized multiple react libraries to develop innovative features and improve usability of the web application.
• Built and deployed the Appraisal builder & leaderboard modules from scratch, providing a streamlined system for performance evaluation and recognition.
• Integrated third-party vendor APIs, such as digio and SendGrid, to enable seamless document verification and e-signature capabilities, optimizing workflow and enhancing security.

• Module owner for the autocoding, surgery, and reports jobs, ensuring smooth and efficient operation.
• Proficient in debugging production issues and skillful at backtracing code to identify and resolve bugs, minimizing system downtime and improving overall performance.
• Subject Matter Expert (SME) for autocoding in Ogrds, responsible for receiving and processing exceptions and effectively communicating them to end consumers, contributing to seamless data flow and accurate coding.
• Created various SQL objects, including tables, views, sequences, synonyms, stored procedures, functions, packages, and cursors, aligned with business requirements, enabling efficient data management and manipulation.
• Skilled in using Ref cursors, bulk collect, PL/SQL collections, dynamic SQL, exception handling, indexes, and correlated subqueries, enhancing query performance and optimizing database operations.
• Proficient in debugging and tuning PL/SQL code using Explain plan for Oracle, ensuring efficient and effective execution of database operations.

• Developed internal tools for the publishing domain.

Improved efficiency and accuracy in the publishing process.

• Utilized Xmetal tool and XML files to publish books into e-pub format.

Streamlined the publishing process and enhanced the quality of e-books.

• Built an in-house application using HTML, CSS, and JavaScript.

Improved productivity by providing a user-friendly tool for internal teams.

• Provided 24/7 support in highly demanding environments.

Ensured uninterrupted operations and minimized downtime for critical processes.

• Prepared design documents, detail design documents, table architecture, and use cases documents.

Facilitated smooth project execution by providing comprehensive documentation for reference.