Praveen Sk

IT professional with 3.3 years of experience as a PL/SQL Developer and Murex DataMart Developer. Having good knowledge in writing complex queries using Joins, Sub queries, Group Functions, Set operators. Proficient in Murex 3.1 DataMart design, report optimization, dynamic tables, feeders, and extractions.

Having good knowledge about Data Dictionary Tables in oracle. Having good knowledge about DDL, DML and DCL languages in Oracle. Good knowledge in Creation of database Object like Tables, Views, Sequence, Synonyms Constraints and Index.

Hands-on experience in Oracle 11g/12c/18c/21c with expertise in SQL and PL/SQL programming, database design, and performance tuning. Involved in complex database objects like Stored Procedures, Functions, Packages, Triggers using SQL and PLSQL. Experienced in data migration (SQL*Loader), bulk processing (FORALL, BULK COLLECT), and index-based optimization.

Having good knowledge in Global Temporary Table and Private Temporary Table. Adept at delivering customized reporting and automation solutions for both greenfield and maintenance projects.

Senior Software Engineer at COFORGE LIMITED (2025-01 – Present)

• Engaged in a Murex Greenfield implementation project for DataMart reporting
• Involved in report design discussions with users and business analysts to gather requirements and functional details
• Developed custom Datamart reports in Murex for front-office, back-office, and risk management teams, aligned with regulatory and internal reporting needs
• Worked on Intraday as well as User Driven report to fulfill the users requirement
• Created Dynamic tables, Datamart tables, Table Feeders, Batches of table feeders, Processing scripts as per the report requirement
• Developed SQL complex Queries as part of Extracting data from Datamart tables and created Datamart extraction to generate reports as per requirements
• Taking weekly CTT for common as well as report specific objects

Software Engineer at Redcloud Soft Solutions Private Limited (2022-09 – 2025-01)

• Created the PL/SQL procedures, functions, packages applying the business logic to update the database
• Analyzed the business requirements of the project by studying the Business Requirement Specification document
• Used the bulk collect to pull the records faster
• Created Indexes on the tables for faster retrieval of the data to enhance database performance
• Handled errors using Exception Handling extensively for the easy of debugging and displaying the error messages in the application
• Responsible for writing test cases and test scripts SQL Queries to validate the data in the data warehouse that are being loaded
• Collaborating with other developers, business analysts, and stakeholders to understand requirements and deliver solutions

Bachelor Of Technology in Computer Science and Engineering – Manakula Vinayagar Institute of Technology (2021)