JOSHI V

• 6 years of experience in software development with expertise in C, Pro*C, SQL, PL/SQL, and UNIX environments.

• Strong command of Oracle technologies including development of packages , procedures, functions, triggers , and advanced cursor management and exception handling .

• Hands-on experience in SQL and PL/SQL performance tuning to optimize application efficiency and reduce execution times.

• Skilled in cloud-native application development using AWS Lambda , API Gateway, and DynamoDB.

• Proficient in Python development , building reusable and testable code, integrating with third-party APIs, and supporting frontend-backend workflows.

• Experience in infrastructure automation and deployment using AWS services.

• Adept at query optimization, database tuning , and ensuring high availability and scalability of applications.

• Experienced in integrating Oracle PL/SQL systems with AWS services such as Lambda, S3, API Gateway, and DynamoDB to build scalable, cloud-native automation and reporting solutions.

Title : Derivatives Pricing & PnL Reporting System

Client : Goldman Sachs, UK

Software : Sun Solaris, Oracle 9i, 10g,11g,12c,19c (SQL and PL/SQL), Linux, Shell Scripting

Tools : Control-M, WinSCP, GIT, FileZilla, Beyond compare, Vi editor,

Putty, SQL Developer.

Team Size 7

Description :

Created a pricing and PnL reconciliation module for equity and credit derivatives. Integrated with front-office trading desks, pricing engines, and the general ledger. Provided real-time intraday valuation, Greeks calculation, and end-of-day PnL for risk and finance teams.

Responsibility:

· Created PL/SQL packages , procedures , and implemented ref cursors .

· Automated data loading and validations using shell scripting .

· Designed file handling and reporting using Pro*C .

· Wrote ad-hoc queries for business analysis and credit evaluations.

· Conducted internal knowledge-sharing sessions.

· Designed and maintained Pro*C programs for file-based ingestion of customer and loan data from external systems.

· Built report generation tools in Pro*C for regulatory and internal credit risk assessments.

· Developed Python-AWS Lambda integrations that triggered Oracle PL/SQL procedures

to analyze risk data on demand.

· Leveraged AWS DynamoDB to store metadata related to credit risk engines and report generation.

· Automated periodic uploads of Oracle-based credit reports to S3 buckets , applying encryption and access control.

· Design and implement relational database schemas , tables, indexes, and constraints using PostgreSQL.

· Develop and maintain functions, stored procedures, and views using PL/pgSQL.

· Migrate legacy databases to PostgreSQL, ensuring accurate data mapping and type conversion.