Highlights:? 14 years of experience in System Analysis, Design, Development, Testing and Implementation of Software Applications and providing support for the effective implementation of Enterprise Applications software. ? Excellent functional knowledge on domain of Financial/Banking/IT Sector. ? Over 10 years of prior experience using Designing and Development of applications using SQL, PL/SQL, Oracle Database 9i/10g/11g, Oracle Forms 9i & Reports 9i, Oracle Forms 10g & Reports 10g. ? Have Extensive experience in IT Industry, in different phases of the software development life cycle such as requirements gathering, analysis, design, development, administration, testing, implementation and documentation of general application.

Skills:PL/SQL, SQL, ORACLE FORMS REPORTS 6i/9i/10g, ORACLE DATABASE 9i/10g/11g, Crystal XI Reports

Goal:Eager to contribute, highly applicable application development skills, ability to personalize service delivery, analyze application needs and translate them into executable strategies for the firm.

Certification:Oracle Certified Professional in Forms 9i

Honor:Letters of Appreciation from Client (Qatar National Bank) in Current Job

Senior System Analyst 06/2019 - current
Global Technology Services, doha, Doha Qatar
Industry: IT
Currently Working for QNB (Qatar National Bank) client in Doha, Qatar. ? The role Development includes Project Designing phase, Effort Estimation, Coding, SQL performance tuning and Statistical reporting. ? Involved in Analysis, Requirements Gathering and documenting Functional & Technical specifications. ? Oracle PL/SQL Java sources have been used in Files handling, SMS registration and Email notification.
--
Senior System Analyst 03/2011 - 05/2019
Gulf Business Machines W.L.L, Doha, Doha Qatar
Industry: IT Software Solutions
Worked as Oracle Consultant for QNB (Qatar National Bank) client in Doha, Qatar. Handling the Technical/Functional Oracle Consultant role on In-House oracle Application projects.
• In-House Banking Application for (QNB) in Qatar, offers a full range of Retail, Corporate, Investment, Treasury, Wealth Management, and Islamic Banking products and services for individuals, corporate institutions and government entities in Qatar as well as internationally. The current assignment is an open contract with GBM on work visa in Qatar. • The role Development includes project designing phase, effort estimation, coding, SQL performance tuning and Statistical reporting. Also includes designing forms on Oracle DS 9i with backend Oracle 9i/10g/11 g databases with Oracle Scheduler and oracle jobs. Additionally includes Unit testing and integrated testing of each module. • The main objective is to automate the Debit/Credit systems in order to perform transactions directly in Core Bank system i.e. EQUATION. The architecture used has Oracle generated HTTP request to Middleware which hosts various Web-Services in order to talk with Core System. • Designed web based front-end screens using Forms 9i, generated custom reports using Reports 9i. Developed User interface (UI) with functionality in Forms 9i. Creating SQL, Object Views, PL/SQL database objects. Used native Dynamic SQL (DBMS_SQL, EXECUTE_IMMEDIATE). Made use of ref cursor feature for developing complex oracle reports. • Java sources have been used in Files handling, SMS registration and Email notification.--
Software Engineer 11/2007 - 03/2011
HCL Technologies, Gurgaon, Delhi NCR India
Industry: IT Software Solutions
Worked as Software Engineer in Various projects
• Worked for 3 different clients one domestic and other two international. • Successfully handled the entire reporting module development on Business objects XI Crystal Reports XI integration through stored procedure written in SQL Server 2005 as well as oracle 10g. • Involved in Testing (Both Unit and Integration Level) and Implementation. Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges. • Involved extensively in development of PL/SQL Packages, Stored procedures, Triggers. Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges. • Developed User interface (UI) with functionality in Forms 10g. Designed menu driven form for data entry, data retrieval and data editing in Forms 10g. • Designed forms for query criteria to access the data from the database in Forms 10g. Designed forms to activate the reports at form level passing the query criteria. Project Name: Division of Worker Compensation (USA) Project Contribution: Worked in the construction of DWH reports in Crystal XI with Oracle 10g database. ETL script writing for incremental data push from application DB to DWH schema. Project Name: TN-SACWIS (USA) Project Contribution: Worked in the construction of Forms and reports in Crystal XI with Oracle 10g database. Successfully completed documentation for requirement and design phase. Project Name: IRAS (Singapore) Project Contribution: Handled the entire reporting development based on Crystal Reports XI with the application through dot net code. The development includes stored procedures written in SQL Server 2005 integrated through XML in to the application.--
Oracle Developer 01/2005 - 10/2007
Credence Systems Pvt Ltd, New Delhi, Delhi India
Industry: IT Software Solutions
Worked as Software Engineer/Oracle Developer
• Extensively used of PL/SQL Stored Procedures, Functions, Form Triggers and Packages. Developed web based front-end screens using Forms 6i/9i, generated custom reports using Reports 6i/9i. Creating SQL, Object Views, PL/SQL database objects. Used TOAD, PL/SQL developer tools for faster application design and developments. Developed SQL queries. Involved in Testing (Both Unit and Integration Level) and Implementation • Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges. Involved extensively in development of PL/SQL Packages, Stored procedures, Triggers. Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges. • Developed User interface (UI) with functionality in Forms 9i. Designed menu driven form for data entry, data retrieval and data editing in Forms 9i.Designed forms for query criteria to access the data from the database in Forms 9i. Designed forms to activate the reports at form level passing the query criteria. Used native Dynamic SQL (DBMS_SQL, EXECUTE_IMMEDIATE). Made use of ref cursor feature for developing complex oracle--

Guru Gobind Singh Indraprastha University 07/2000 - 06/2004
New Delhi, Delhi, India
Degree: Bachelor's Degree
Major:Information Technology
Successfully completed Bachelor's degree(IT) in First Division

Login to view resume: Senior System Analyst -