Santosh Jilhewar

About Santosh Jilhewar

Result-oriented professional offering 14+ Years of experience in Application and Decision Support Systems Analysis, Design, Development, Enhancement, Production Support, Testing and Implementation.• Strong exposure to functionalities like creating Tables, Cursors, Stored Procedures, Functions, Packages, Triggers, Indexes, Collections, File handling (UTL_FILE), Autonomous transactions, background jobs and advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Records, Types, Dynamic SQL, Materialized Views and Analytical Functions.• Experience with Data flow diagrams, Data Dictionary, Database normalization theory techniques and design techniques.• Expertise in implementing collection, bulk processing of data. • Involved in SQL Query tuning and provided tuning recommendations to PL/SQL jobs, time/CPU consuming queries• Expertise in performance analysis, monitoring and SQL query tuning, reduction of response time, while designing scalable applications from scratch using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Oracle.• Expertise in writing large/complex queries using SQL.• Skilled in using tools such as SQL Developer and TOAD and loading data from flat files using SQL Loader and External Tables• Experience in managing roles and grants of users and objects.• Skilled in developing interfaces and reports for downstream and upstream systems.• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star and snowflake schema modeling.• Experience in Implementation of Oracle Partitions for very large objects storage and performance enhancements• Good knowledge in optimization techniques of application and handling big amount of data.• Very versed in creating dashboard and reports such as drill down, drill through, Parameterized, Cascading, Sub and Matrix using SSRS.• 8 years of experience in design, development, implementation, conversion, support and maintenance on Flexcube corporate banking product.• Good knowledge on DDA, GL, Liquidity management, Loan syndication, Loans and deposits, Time deposit, Core accounting, Secondary trading and customer modules of Flexcube corporate banking product.• Proficient in preparing high/low level documents like design and functional specifications. • Domain experience in Risk Management and Finance Reporting.

Experience

1. Vice President

   AIG

   Dec 2024 — Present · Wilton, CT, US

Skills

• Sql
• Performance Tuning
• Pl/Sql
• Sql Server Reporting Services (Ssrs)
• Javascript
• Unix
• Flexcube (4.x,7.x,10.3 and 12.0)
• Databases
• Sdlc
• Xml
• Html
• Shell Scripting
• Oracle
• Requirements Analysis