AHLI United Bank is committed to bring seamless banking and a wider spectrum of value added financial services. By harvesting the latest technologies customers are able to conduct the banking transactions at anytime and anywhere in the world. Account Management module is designed and coded by our team.

Avis Budget Group, Inc. is a leading global provider of vehicle rental services, both through its Avis and Budget brands, which have more than 11,000 rental locations in approximately 180 countries around the world, and through its Zip car brand, which is the world's leading car sharing network, with more than one million members. Avis Budget Group operates most of its car rental offices in North America, Europe and Australia directly, and operates primarily through licensees in other parts of the world.

Responsibilities:

• Worked on Scrum Agile methodology to deliver on exact time line and with accuracy
• Worked under high pressure with Micro finance monitoring.
• Created and changes tables, synonyms, views, procedures, functions, packages, constraints, privileges to solve JIRA tickets.
• Created the database users with appropriate privileges in DEV, TEST, UAT DATABASES.
• Performed database refreshes, schema refreshes.
• Worked on database upgrades and performed patching using OPATCH.
• Performed RMAN backups and recoveries.
• Monitored the daily batch runs in stage and prod databases.
• Analyzed the batch process and changed batch procedures to improve the performance of the batch.
• Prepared shell scripts to transfer the required data from one server to other. And set CRON job to perform this task daily basis.
• Prepared scripts to automate database task.
• Performed code reviews for other team members fixes.
• Involved in scrum meetings with client to plan and estimate JIRA tickets.

Environment: Oracle 11g SQL, PL/SQL, SQL PLUS, SQL DEVELOPER

OFSA (Oracle Financial Services Analytics Applications): the system is used to calculate “transfer pricing” by JP Morgan for provision” of a business unit’s funds is approximated. The transfer price, known in OFSA as the funding amount, is calculated using a funding rate, which is the interest rate at which Treasury provides (i.e. the offer Rate) or receives(Bid Rate) money for or from the Business Units.

As the system(OFSA) is going to migrate into three different systems that is COFE – APAC,COFE – EMEA, COFE – AMERICA separate servers setup, databases creation, code migration and front – end applications formation need to be done.

Responsibilities:

• Created new procedures, functions, triggers, packages, and SQL*Loader scripts, and modified existing codes, tables, views, and SQL*Loader scripts
• Incorporated business rules and constraints and created new tables for all modules.
• Created the procedure that performs table partitioning according to the situations.
• Created the package that performs MV’s refreshment.
• Created the procedure that performs exchange partitioning.
• Worked closely with Administrator for proper backup and recovery plans.
• Created user id’s and granted them with appropriate roles and privileges after having discussions with all application owners in the project.
• Monitored performance and changed performance requirements through application of Database tuning and performance optimization techniques.
• Worked under tight schedules for successful development and implementation.
• Performed testing operations in different phases of the project.
• Worked in OFSA (Oracle Financial Services Applications front end. Performed OFSA operations from front end and back end (data base) as well. Performed testing, created deleted and changed user profiles. Given ledger code access to the users. Created folders and assigned roles, permissions, to them. Created and edited forms, transformations, allocation rules in OFSA.

Environment: Oracle 11g SQL, PL/SQL,SQL PLUS,TOAD

Spansion Japan Ltd. manufactures flash memory products in Japan. Its products enable storing and protecting digital content in the wireless, automotive, networking, and consumer electronics markets.

There is need for the company to build their effective, advanced Inventory Management System used to store their product details and generate reports for analysis and decision making.

Responsibilities:

• Involved in the whole life cycle of the project.
• Interacted with clients to understand their requirements.
• Involved in database design work like identifying entities and relationship among them.
• Involved in Table design.

• Programmed Packages, stored procedures, queries, and triggers on Oracle 10g.
• Unit and System Testing.
• Prepared scripts to create users and give appropriate privileges.
• Plan and supervise the daily activities of the application support
• Database Query tuning and Implementation.
• Involved in resolving production problems for the applications and ensure all support service level agreements are met.

• Worked with DBA team to create databases, table spaces, and adding data files.
• Performed RMAN backups and logical backups using IMPDP/EXPDP utilities.
• Used flashback technology in releasing new code.
• Prepared root cause analysis for problems occurred.
• Documented the project work for future analysis.

Environment: Oracle 11g SQL, PL/SQL, SQL PLUS, TOAD

The system has centralized database to maintain all relevant information regarding Credit Information. The transaction data will be ported to this centralized database from the branches either through data import or through manual entry. The system allows the user to generate various kinds of reports and queries.

Responsibilities:

• Involved in the whole life cycle of the project.
• Interacted with clients to understand their requirements.
• Involved in database design.
• Programmed Packages, stored procedures, queries, and triggers on Oracle 10g.
• Worked with DBA team to perform backups create and maintain external tables
• Unit and System Testing.

Environment: Oracle 10g, SQL PLUS, PL/SQL