Fahim Ahmad

Experienced Oracle Database Administrator with over 11 years of expertise in SQL, PL/SQL, performance tuning, and Unix OS. Proficient in advanced tuning techniques, Oracle APEX, materialized views, and index strategies for scalable solutions. Specialized in EU asset management regulatory reporting (SFDR, PRIIPS, etc) with compliance-focused database design. Skilled in DevOps tools (Docker, Azure, Git) and programming (Python, Java, C#). Passionate about delivering efficient, future-ready database solutions.

Worked with SFDR(EET, Periodic and Entity level), PRIIPS(EPT and KIDs) reporting. Managed Oracle Databases and developed PL/SQL modules. Performed SQL performance tuning to enhance efficiency. Analyzed requirements for EU asset management regulations. Designed new database modules for regulatory compliance.

Training on Database Objects, database development, knowledge sharing of banking domain. Knowledge sharing on best practices of software development. Code review to the developers.

Developed a product and customer recommendation engine using Machine Learning. Designed server-side PL/SQL scripts for data manipulation, validation, and materialized views for remote instances. Created PL/SQL procedures, functions, and packages. Tuned SQL, PL/SQL, and applications for performance. Optimized data retrieval with bulk collections. Used Oracle objects to generate and deliver data to middleware servers. Collaborated with third-party vendors for data mapping.

Data and performance analysis from addition and removal of indexes. Analyze SQL to use hints to optimize the query execution plan. PL/SQL scripts using UTL\_FILE package to generate customized reports. Use of Oracle development tools like Toad, PL/SQL and SQL* plus depending on the need of the tasks. Pipe functions for different application reports. Data cleaning and data migration from branch banking to CBS. Requirement analysis for the possible development in the system.

Design unit testing and generate test cases for unit test. Debug Java and PL/SQL codes to analyze and finding exact solutions. Created records, tables and collections to improve Query performance. Design ETL tools for database migration. Performed Database Administration of all database objects.

Implementation experience in complete System Development Life Cycle. Query Optimization, Performance Tuning and DBA solutions.

Courses: Project Management, Database Architecture, Computer Data and Network Security, Advanced OOP, Computer Networking, Software Testing, etc.

Major Courses: Programming Fundamentals, Discrete Mathematics, Linear Algebra, Database Systems, OOP, Design and Analysis of Algorithms, Software Design Patterns, Distributed Systems, Artificial Intelligence