SANDEEP SINGH

Responsibilities:

• Currently Working for QNB (Qatar National Bank) client in Doha, Qatar.
• Contributed to continuous improvement based on learning from ideas, client implementation, and previous experiences.
• 
  
• Role of 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/11g/12c databases with Oracle Scheduler and Oracle jobs. Additionally includes Unit testing and integrated testing of each module.
• Involved in Analysis, Requirements Gathering and documenting Functional & Technical specifications.
• Involving in preparing high-level requirements documentation for successful implementation of requirements.
• Involving in team discussions for successful decomposition of requirements to various tasks.
• Oracle PL/SQL Java sources have been used in Files handling, SMS registration and Email notification.
• Worked on Big XML files loading (*1-2GB) through SQL* Loader utility and data transformation using XML TABLE mechanism provided by oracle.
• Have knowledge on use of DomSource document to read xml node-list.
• Made use of ref cursor feature for developing complex oracle reports.
• Involved in performance tuning of SQL Queries.

Projects Assigned are as follows:

• E-Statement Project: QR Image Base 64 Encoding/Decoding using java Encoder Java source plus QR Binary data retrieval from core banking Equation System.
• FRS Global MAS 610 Migration (Singapore Unit): Currently working on Migrating existing RRS extracts from traditional FRS to MAS 610 version.
• ATM Forecasting System: Worked on building ATM Cash management System to monitor ATM(s) current cash balance and initiate Replenishment orders to keep ATM cash ready.
• ATM Cash/Dispute Settlement: Worked on building ATM Dispute System by loading ATM trail files to mark cash dispensing/deposit errors and initiate settlements between customer and bank a/c.
• Wages Protection System (Kuwait/Oman): Working on implementation of WPS in QNB developed on Dot Net MVC framework, Oracle 12c Db and Crystal Report XI.

Tools/Environment/DB: Oracle 12c, PL/SQL, SQL, Crystal Reports XI/VS 2010/2013.

Responsibilities:

• Selected Twice as Best Oracle Consultant for Efforts in Implementing Salary System and Dividend System for QNB.
• Worked on Oracle Forms/Reports 9i migration to Dot net front end using MVC, C#, VB, JS with backend data layer connected on oracle 11g/12c database with PL/SQL code.
• Main objective is to automate Debit/Credit systems in order to perform transactions directly in Core Bank system i.e. EQUATION. 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.
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader. PL/SQL Bulk Collect to process data containing millions of records.
• Use Collections like variable arrays, nested tables.
• Worked on developing ETL scripts for Data Ware House (DWH) reporting project.

Projects Assigned are as follows:

• OGG (Oracle Golden Gate) replicator ETL process handling through PL/SQL code.
• Dot Net Migration Project: Recently migrating Oracle Application developed on Forms/ Reports 9i to Dot net MVC framework.
• IBAN (International Bank Account Number): Implemented IBAN in all in-House modules of QNB to accept IBAN in order to perform transactions.
• Debit cards/Payroll cards System: Cards generation, Mapping of accounts with core bank Equation.
• Dividend System: To process dividends for all companies enrolled with QNB.
• Bulk Payment System: To import /process/export/ perform Debit credit on core banking Equation using oracle jobs automation/ Web-Services architecture.
• Government Salaries System (GVS): To import /process/export/ perform debit credit of salaries on core banking Equation using oracle jobs automation/ Web-Services architecture. Module includes 9 countries handling.
• Direct Debit Payment: To perform automated import export of files in core banking Equation. Java source has been used to read import files.
• Initial Public Offering: To process IPO enrollment with Qatar.
• Electronic-IPO Crystal XI: Reporting for dot net application for E-IPO application.

Tools/Environment/DB: Oracle 9/10g/11g, PL/SQL, SQL, Oracle Forms9i/Reports 9i, Crystal Reports XI/VS 2010/2013.

Responsibilities:

• Worked for 3 different client projects, one domestic and other two international.
• Successfully handled 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 data from database in Forms 10g. Designed forms to activate reports at form level passing query criteria.

Projects Assigned are as follows:

• Project Name: Division of Worker Compensation (USA): Project Contribution: Worked in 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 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 entire reporting development based on Crystal Reports XI with application through dot net code. Development includes stored procedures written in SQL Server 2005 integrated through XML into application.
• Project Name: AG Pension (Domestic): Project Contribution: Handled 5 sites which include UAT for 3 sites and post UAT support for remaining sites. Went to various places including NE for UAT.

Tools/Environment/DB: Oracle10g database, Crystal reports XI, Micro Strategy 8, Visual Studio 2008, SQL server 2005 database, Forms 10g, Reports 10g, PL/SQL Language,

Platform: Windows2000 PRO, Windows XP PRO, Red Hat 9

Responsibilities:

• Identified issues, analyzed information and provided solutions to problems
• 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.
• 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.

Project Name: Maintenance for Internal Clients

• Project Description: Forms and reports development/maintenance in developed in oracle 9i forms and reports with oracle 9i as database. Code is integrated through java into application.
• Project Contribution: Worked in construction of Forms and reports in oracle 9i with Oracle 9i database. Performed excellently with active participation in documentation phases of requirement and design specification.

Environment: Oracle 6i/9i, PL/SQL, SQL, TOAD, Windows98/NT/XP.