Overview
Work History
Education
Skills
Domains
Professional Summary
Overall Experience
Timeline
Generic
Ashwini Sanapa

Ashwini Sanapa

Pune

Overview

7
7
years of professional experience

Work History

Senior Associate

Synechron Technologies Pvt. Ltd.
01.2021 - 07.2024
  • Project: ADE (Asset Distribution Engine)
  • Client: HSBC (Global Trade and Receivables Finance)
  • Duration: May 2021 to February 2023
  • Description: HRD (HSBC Receivable Discounting) was a system that distributed assets to investors, including financial and non-financial institutions, banks, etc
  • The system acquired these assets from another system (IFAI) via a job scheduler (Control- m)
  • Throughout this process, we created an investor profile, set up programs, made offers, completed sales, and ensured maturity and final settlement to investors
  • Responsibilities:
  • Worked with SQL Developer
  • Developed complex SQL queries, including subqueries, correlated queries, and nested queries
  • Performed data modeling for ADE and supported over 3-5 projects within the team
  • Engaged in performance tuning and data migration tasks
  • Handled client communications as required

Senior Software Developer

Majesco
05.2019 - 10.2020
  • Project: Workers compensation (WK)
  • Client: National Council on Compensation Insurance (NCCI)
  • Duration: May-19 to Oct-20
  • Description: Workers' compensation is a form of insurance providing wage replacement and medical benefits to employees injured in the course of employment in exchange for mandatory relinquishment of the employee's right to sue his or her employer for the tort of negligence
  • The trade-off between assured, limited coverage and lack of recourse outside the worker compensation system is known as the compensation bargain
  • One of the problems that the compensation bargain solved is the problem of employers becoming insolvent because of high damage awards
  • Responsibilities:
  • Worked in Dev Studio
  • Developed packages, procedures, and functions for the application
  • Wrote complex SQL queries, including subqueries, correlated queries, and nested queries
  • Focused on rates, loss cost, and form development according to NCCI guidelines
  • Environment: Oracle, Dev Studio Tool

System Analyst

Indus Software Technologies
12.2017 - 04.2019
  • Project: Management Appraisal Repayment Collateral Insurance System (MARCIS)
  • Client: Standard Chartered Bank (SCB), South Africa
  • Duration: Dec-17 to Apr-19
  • Description: Standard Chartered South Africa, whose full name is Standard Chartered Bank South Africa, but often referred to as Standard Chartered South Africa, is a commercial bank in South Africa
  • A subsidiary of British Standard Chartered it is registered as a Foreign Bank, by the South African Reserve Bank
  • Responsibilities:
  • Created Oracle Tables, Views, Constraints, Synonyms, Sequences
  • Used Analytical functions, Decode, case statement while writing complex SQL queries
  • Developed packages, procedures, functions for the application
  • Developed complex SQL queries including Sub queries, correlated queries, and Nested queries
  • Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance
  • Involved in working with EXPLICIT CURSORS, and REF CURSORS
  • Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT
  • Involved in generating numbers for PRIMARY KEY VALUES using Oracle SEQUENCE objects
  • Involved in creation of various indexes on relational tables, which are BTREE, BITMAP and FUNCTION BASED INDEX
  • Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE and USER
  • Environment: Oracle

Education

Bachelor of Engineering - Information Technology

Nagpur University

Skills

Oracle 10g

Domains

  • Payroll
  • Banking
  • Insurance

Professional Summary

Proficiency in Oracle PL/ SQL development, including analysis, design, and implementation of business applications utilizing Oracle RDBMS., Comprehensive experience in all SDLC phases and Agile development ensuring timely delivery within stringent deadlines., Skilled in the creation and optimization of database objects like Tables, Views, Indexes, and utilizing partitioning techniques., Development of Stored Procedures, Functions, Packages, and Triggers for diverse business requirements., Profound experience in writing complex SQL queries and performance tuning to optimize application and database performance., Adept in creating materialized views for data replication and formatting data to meet client requirements., Demonstrates excellent communication skills and the ability to work effectively within a team environment., Quality-conscious and dedicated, with an emphasis on learning new technologies and delivering within specified timelines., History of working in payroll processing, financial assets distribution, and insurance, reflecting diverse industry knowledge., Committed to continual learning and quickly adapting to new technologies, as well as enhancing system performance through code and query refinements.

Overall Experience

8 Years 8 Months

Timeline

Senior Associate

Synechron Technologies Pvt. Ltd.
01.2021 - 07.2024

Senior Software Developer

Majesco
05.2019 - 10.2020

System Analyst

Indus Software Technologies
12.2017 - 04.2019

Bachelor of Engineering - Information Technology

Nagpur University

Similar Profiles

CREATE PROFILE
Ashwini Sanapa