Summary
Overview
Work History
Education
Skills
Corporate Achievements
Projects
Disclaimer
Timeline
Generic
Ashar Aqeel

Ashar Aqeel

Senior Technical Lead
Ghaziabad,UP

Summary

Total 12 Years’ Experience in Banking and Financial domain with Nucleus Software Exports Limited, Noida. Work for Nucleus Software Finnone LMS (D2K /JAVA) and PL/SQL Technology. Extensive technical knowledge and experience on ORACLE procedures, functions, packages, triggers, SQL & performance tuning. Adept at maintaining cordial relationship with client with better client interaction skills and provide the best solution by Product knowledge. Expertise in Group GL Reconciliation & Template handling. Experience in development, Peer & User acceptance testing & version control. Have Involved in Analyzing the Detailed Functional Specification of Various Custom Components Implemented for Resolution of Real Time Issues. Have Hands on Programming Experience in Oracle SQL and PLSQL.

Overview

12
12
years of professional experience

Work History

Senior Technical Lead

Nucleus Software Exports Limited
02.2012 - Current

More than 12+ years of programming experience as an Oracle PL/SQL Developer in all phases of Software Development Life Cycle (SDLC) including Analysis,
Design, Data Modeling(Logical and Physical) and implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).


Expertise in creating relational database development, for creating complex databse queries, writing Contraints, Indexes, Views, Packages, Stored Procedures,
Cursors and Functions using PL/SQL in Oracle databases.

Expertise in Database Performance Tuning, Performance monitoring and Optimization using Oracle hints, Explain plans, TK-prof.

Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export.

Experience in development of custom Oracle forms and reports application.

Used several Oracle provided packages such as DBMS JOB, DBMS Profiler, DBMS STATS and DBMS Scheduler packages.

Skilful in working with the tools like SQL*PLUS, TOAD, PL/SQL Developer.

Education

10th -

GBSSS Tukmeerpur Delhi, C.B.S.E

12th - undefined

Pratibha Vikash Vidyalaya, Yamuna Vihar Delhi, C.B.S.E

B. Tech(Computer Science) 2007-11 - undefined

Ambedkar Institute Of Technology , Delhi, GGSIPU , Delhi

Skills

PL/SQL

undefined

Corporate Achievements

  • Awarded Spot award in 2019 and 2020
  • Awarded Customer Delight award in 2017
  • Awarded Behind the Scene award in 2016.
  • Awarded Team Award in 2015.
  • Awarded Employee of the Month Award, in 2014.

Projects

Axis bank, Mumbai, 2012 - 2016, This project involved enhancements and performance tuning requirements. Loan auto authorization: Wherein user have to do disbursal initiation and system will auto authorize the loan which has been punched in Loan Origination System. Fate upload: This involved update of actual status of PDC (Post Dated Cheques) . Bulk Rescheduling upload: This involved automation of rescheduling activity wherein user want to change the repayment schedule of a loan. Billing process Tuning: This is vital process in Finnone product as this creates EMI due on billing date, so slow processing caused loss in business hours of Axis Bank. GL Reconciliation: Being a bank/financial organization it must have reconciled GL balances before financial end, I check the GL balances and shared clarification if found any. It is a monthly activity which is done on month end. Disbursal Initiation: This is the process to purchase new contracts from LOS module and to move contracts into LMS, this process was taking time to push the data into LMS.


Hero Fincorp, Delhi, 2016 - 2020, This project involved enhancements and performance tuning requirements. Receipt Automation: This include automation of receipts wherein user will upload data in file through process and these receipts will automatically be updated as bounced, clear or canceled through this process. Presentation Process Automation: Presentation process is a vital process in financial organization and automation of this process reduced a lot of manual interventions and manual errors. Combined Repayment Schedule: In this change customer asked for combined repayment schedule for partially disbursed cases. FRR Process: In this change customer asked for FRR process to be enabled based on product, scheme, uploaded agreements and flexible parameters on which they can restructure repayment schedule of loan. IMD Cancellation: In this requirement customer has asked to manage IMD money as income or refund as per their requirement loan wise. Auto closure Maturity: In this change system should pick all those matured or foreclose eligible cases automatically and process these cases for closure. There should be handling of cutoff amount on the basis of type of closure request. Many other enhancements: Broken period accrual, Crilic Report generation, Eod Bod process execution from backend and dependent process execution. 


OVF Bank of Spain, Delhi, 2020 - 2021, In this project I was aligned with a team to complete the implementation of Bank of Spain wherein my responsibility was to accomplish interface implementation in the project. I was awarded with Behind the Scene award for completing implementation within target date. 

GMF Chile, Delhi, 2021 - Present, In this project I was aligned with a team to monitor day to day financial requirement of business. My role is to smoothen the regular functionality of Finnone and look for the proper coordination of Finnone with other organization which will help business to perform better. Last month I got SPOT award for providing key defect fix for Chile project.

Disclaimer

All the above information given here are true and I bear all the responsibility of these details.

Timeline

Senior Technical Lead

Nucleus Software Exports Limited
02.2012 - Current

10th -

GBSSS Tukmeerpur Delhi, C.B.S.E

12th - undefined

Pratibha Vikash Vidyalaya, Yamuna Vihar Delhi, C.B.S.E

B. Tech(Computer Science) 2007-11 - undefined

Ambedkar Institute Of Technology , Delhi, GGSIPU , Delhi
Ashar AqeelSenior Technical Lead