Sanjay Kumar
6593891687 93891687
#02307 Block 108,Tampanies St 11
Current Location: Singapore
Title: / 6+ years core exp. in Oracle Tools,Unix with Banking Domain(credits, Mortgages, Loans and risk management)Work Experience: / 6.4 years
Skills: / PL/SQL,SQL,Forms 6i,Reports 6i,Discoverer,Informatica,OWB,Unix, Rational Rose,Clear Case, Java
Current Organization: / Nucleus Software Solutions Pte. Ltd.
Previous Organization(s): / Nucleus Software Exports Ltd.
Industry: / Banking/ Financial Services
Highest Degree Held: / MCA/PGDCA (Computers) ,IGNOU
Gender: / Male
Date of Birth: / 17th August 1979
Current Annual Salary (Rs. in Lacs): / 15.45
Detailed Resume:
SANJAY KUMAR (65-93891687)
Email ,
Oracle Consultant (Banking Domain)
•Over Six years of experience as Database Administrator, Developer/Analyst in Banking & Manufacturing.
•Experience in Banking, deep knowledge and experience in credits, Mortgages, Loans and risk management functions of banking.
•Experience in all phases of software development life cycle, namely, Requirement Analysis, Design, Development, Testing, Implementation and Support.
•Well conversant with RUP methodology and Client Server applications using different GUI Tools. Mainly, Oracle Forms, Reports, Discoverer, SQL, PL/SQL.
•Well versed in working with Oracle 8i/9i/10g and performing Database design and highly experienced in writing SQL queries, Stored Procedures, Triggers, using PL/SQL, Data Modeling and UNIX.
•Well experienced in database query tuning, performance tuning of reports and troubleshooting Oracle Application issues regarding setups, flexfields, concurrent manager processing etc.
•Worked on interfaces, conversions and extensions.
•Good communication skills, including verbal, written and developing and delivering application demonstrations to clients.
•Self motivated starter and a quick learner with leadership and interpersonal skills.
•Extensive international exposure includes Singapore, Japan.
•Flexible about work content and location and able to work independently with the client on site.
•CMM Level 5 Assessment Team Member in the Assessment for Nucleus Singapore.
TECHNICAL EXPERTISE:
Applications:Oracle APPS 11.5.10
Modules:General Ledger, Accounts Payables, Accounts Receivables, Application Object Library, Financial Statement Generator (FSG), Workflow, Fixed Assets
Oracle Tools:Forms 6i/5.0, Reports 6i/5.0, Designer 6i, Discoverer, Oracle warehouse
builder, SQL*Loader, Import/Export, TOAD
Languages:PL/SQL, HTML and XML
Database:Oracle 10g, 9i/9.x,8.x, SQL Server 2000 Professional
Operating Systems:Windows NT/2K, Sun Solaris, HP-UX, DOS
Other Tools:MS Project, Rational Rose, Erwin 3.5, Visio 5.0,DeZign, Smart Draw
6.20, Oracle Designer 6i,
Configuration
Management Tools Visual Source Safe 6.0, PVCS Dimension 7.1, Rational Clear Case
WORK EXPERIENCE
1.Sr. System Analyst, Nucleus Software Solutions Pte. Ltd., Singapore (From July 2005 )
2.System Analyst, Nucleus Software Solutions Pte. Ltd., Singapore (From July 2003 to June 2005)
3.Sr. Software Engineer, Nucleus Software Exports Ltd., Delhi, India (From April 2000 to Dec 2000)
4.System Engineer, Nippon Data Systems Ltd, New Delhi, India (From Oct 1998 to April 2000)
5.Technical Consultant, STG International Ltd., Delhi, India (From July 1998- Oct 1998)
2004 (MCA) Master of Computer Applications (Indira Gandhi National Open University, Delhi,
India)
2002 (BCA) Bachelor of Computer Application (Indira Gandhi National Open University, Delhi, India)
2000(B.Com) Bachelor of Commerce (Delhi University, India)
TRAININGS AND CERTIFICATIONS
2005ORACLE APPS 11.5.10 from Oracle University Mumbai in Nov05 Modules
GL,FA,AR,AP,CM.
2004Basic Japanese Course Cambridge Languages Linguaphone School of Languages, Singapore.
2004Listening & Oral Communication workshop from Singapore workforce development Agency.
2004Certificate from KPMG as training in CMM process and Assessment Team Member.
2004Oracle 9i SQL/PLSQL in May.
2001Certificate course in Oracle 8i DBA, Architecture & Administration, Backup & Recovery, Performance Tuning & Network Administration. (SQL STAR INTERNATIONAL LTD. New Delhi, India).
2000 Certificate course in Data Preparation & Computer Software (ITI Pusa, New Delhi, India)
PROJECTS UNDERTAKEN
1.Data Migration CRI (Credit Risk Interface 1.1 ) - From Jan2005 Till Date
CRI is a Global view of CePAC as it will be common system for Credit approval in Citi Bank. CePAC will be used for credit approval and related workflows, limited data population, and storage of pertinent information / documents in the electronic customer file in Europe, North America and Japan.
Client:CITI Bank New York (Asia, Latam, Eemea, JENA)
Operating System:Sun Solaris 5.8
Database:Oracle 9i, Oracle 10G (Oracle Streaming)
Development Tools: PL/SQL, SQL Loader, Export/Import, Oracle Replication, Excel
Design Tool:Rational Rose, Requisite Pro Requirement Tracking.
Role: Database Consultant /Database Administrator
Responsibilities
As Database Administrator
•Migration of Partitioned LOBS Database (350 GB) database to Non-partitioned database using Export/Import utilities.
•Database/Application performance tuning using Explain plans/stats as existing Tables partitions removed.
•Online/Offline Database backup scheduling.
•Setup online Replication with NY to SG Database using Oracle Replication common data.
•Writing UNIX scripts for batch processing jobs, different types of backups
•Public DB link setup between NY and SG Database for Online information exchange and replication.
•Creation of database, tablespaces, rollback segments and redo log files
•Creating a Test database and schemas on it which is very similar to existing production system environment
•Trouble shooting of problems faced in the system like locking, slow response, system crash etc.
•Ensuring smooth and safe system change operation in production system
•Normal DBA activities which includes managing users, privileges, grants, synonyms, performing data load and analyzing objects and so on
As Data Migration Consultant
•Requirement Analysis, Database analysis of existing production Database.
•Data Modelling, Logical and physical database design using ERWin
•Designed and Documented migration strategy for the project.
•Documented Data Conversion Plan, Test Plan and Test Activities.
•Coordination between all the teams regarding data hand-offs.
•Creation of stored procedures, functions, triggers using diff. features like utl_file, dbms_lob and conText search.
2.CePAC KOREA Migration - From May2005 15 Aug2005
Integration of Citigroup & KorAm Bank to form Citibank Korea Inc. and to comply with local regulatory requirements, there is a need to migrate all of Koreas data in CePAC from the Singapore Data Center to the Korea Data Center.
Role: Sr. Database Consultant
Responsibilities
•Data Migration Plan, schedule and Task list with interfaces.
•Documented Functional/System Test cases after migration.
•Ensured the data security/access that only Korea users have access on Korea customers.
•Migration to Korea should be transparent i.e. there should not be any change in functionality on CePAC for Korea users.
•Migration of Data from Regional Database to Korean database using Export/Import utility.
•Developed packages, procedures, functions and triggers for data migration.
•Write PL/SQL code using cursor, arrays, exceptions and advance constructs
•Develop client application and test plans
•Performance Tuning using Explain plan/stats.
•Backup Script preparation and scheduling of Database servers in Korea.
•Coordination between all the teams regarding data hand-offs and PAT Sign off.
•Installation of Oracle database server and client
•Oracle Database Migration from US7ASCII character set to UTF8.
•Creation of database, table-spaces, data-files and rollback segments
•Planning of logical database and physical layout
•Creation of users, roles, schemas, tables, indexes etc
3.FinnOne (Lending and Deposits Module ) Implementation Consultant (April 2005)
The flagship product of Nucleus is an integrated suite of applications designed to support the business offerings of banks and Financial Solutions companies. The Financial Suite provides a solution for both the asset side as well as the liability side of business, core financial accounting and customer service.
Client:Singapore Investment Finance Ltd.
Operating System:Windows NT
Database:Oracle 9i
Development Tools: Forms 6i, Reports 6i, Oracle Discoverer, PL/SQL, SQL Loader,
Export/Import, Informatica , Oracle Warehouse builder(OWB)
Role: Database Consultant/Report Developer as per
requirement in Discoverer
Responsibilities
•Developed packages, procedures, functions and triggers during implementation.
•Developed new forms and reports as customized requirements.
•Developed new data marts and Reports using Oracle Discoverer.
•Creation of database, table-spaces, data-files and rollback segments
•Planning of logical database and physical layout
•Creation of users, roles, schemas, tables, indexes etc
4.CePAC (Credit Approval SystemLDS Release 3.6) - From May2004 Dec2004
CePAC (Citigroup electronic Platform for the Approval of Credit) is a web-based application that allows for the electronic assembly, routing (workflow) and storage of all of the components of the Credit Risk Approval process, and a number of related processes. It includes an electronic credit file, tracking and auto notification of trigger dates and events, linkage to various functions within Operations, electronic communication within the approval / routing process, comprehensive metrics and a legal and documentation module. This application is live in 59 countries in Asia, CEEMEA, and LATAM regions
Client:CITI Bank Asia, Latam, Ceemea (59 countries)
Operating System:Sun Solaris
Database:Oracle 9i
Development Tools:WSAD, Rational Clear Case, J2EE, Java Script, PL/SQL
Design Tool:Rational Rose, Requisite Pro Requirement Tracking.
Role: System Analyst, Involved in the requirement analysis, design, development, testing. Prepared business requirement and detailed design documents. Also involved in the development and team management. Handled DBA activities.
Responsibilities
As Database Administrator
•Creation of new database users, roles, objects and User Session Management.
•Database Tuning, Application performance Tuning.
•Tuned the stored procedures and packages for Database performance improvement.
•Database backup using utilities (Export and Import).
•GAP study of existing application and prepared Data Conversion specification.
•Coordination with Application Support Team.
•Trouble shooting of problems faced in the system like locking, slow response, system crash etc.
•Creating Database links to access remote database.
•Development of store procedure, function and packages for migrating data from existing to new functionality.
•Interaction with oracle support and users.
•Ensuring smooth and safe system change operation in production system.
•Development of utility in SQL and Shell scripts.
•DBA activities that includes managing users, privileges, grants, synonyms, performing data load and analyzing objects and so on.
•Used database links and SQL Loader to migrate data across different platforms and applications.
As System Analyst
•Requirement Analysis and prepare Functional Requirement Document, Use Cases.
•Discussions and functional presentations to clients.
•Participate in the proposal process in the functional scooping of the RFP and to provide inputs in the estimation process.
•Review high-level design to verify completeness from functional aspects and understand the process/data models like RUP, UML etc.
•Prepare functional test cases and test plans.
•Provide functional guidance to offshore and onsite delivery teams.
5.CMM Level 5 Assessment (From 01 Feb2004 13 March 2004)
Involved as Assessment Team Member (ATM) in CMM Level 5 assessment for
Nucleus Software Solutions Pte Ltd., Singapore.
6.Flexcube Schedule Manager (From Sept03 Dec2003)
Managing all the on going SIT/UAT environment and coordinating with all the project managers in order to schedule the SIT/UAT with Flexcube Online and Batch. Planning the batches and restoration for environment preparation for future coming SIT/UAT testing.
Client:CITI Bank (Asia Pacific Technology Division), Singapore
Role:Flexcube Schedule Manager
7.Data Warehousing (From 20Aug 03 30 Oct03 )
To understand the business functionality and design the application aspects of the Project and implement the warehousing solutions using Oracle solutions.
Client:CITI Bank (Asia Pacific Technology Division), Singapore
Operating System:HP Unix 11
Database:Oracle 9i
Development Tools:Oracle Discoverer 4.8, Oracle Designer 6i, Oracle WarehouseBuilder
(OWB) 9.2
Role:System Analyst
Responsibilities
•Requirement analysis, Physical and Logocal database design using Oralce Designer
•Designed and Documented migration strategy for the project
•Involved in database mapping creation and performance tuning
•Documented Component Design Specification, Test Plan and Test activities
•Developed packages, procedures, functions and triggers to support ETL Process
•Designed, developed and tested the Mappings using OWB.
•Responsible for scheduling the jobs using the Job Scheduler
•Designed and developed Unix shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from & to different servers.
8.Bankruptcy Module for Deposits (From 16May 03 10Aug03)
Bankruptcy module is enhancement in Deposit module, which is already been implemented in Tokyo Star Bank as part of complete FinnOne suite. This is developed to handle bankruptcy in the bank, immediately feed will be sent to Insurance Agency through FTP and all the deposits will be marked as freeze and no transactions like withdrawal, maturity will be allowed.
Client:Tokyo Star Bank, Tokyo (Japan on Site)
Operating System:Solaris
Database:Oracle 8i
Application Server:Oracle 9i Application Server
Development Tools:Oracle Forms 6i & Reports 6i, Oracle Discoverer 4.8, TOAD 6.3
Role: System Analyst / Technical Lead.
Involved in the requirement analysis, design, development, testing, implementation, user training and skill transfer. Prepared business requirement and detailed design document. Developed batch programs, user interfaces and reports using PL/SQL, Forms & Reports. Involved in system testing and system integration testing. Involved in supporting the user testing and mentoring the client staff to support the application.
9.Regulatory Reporting Engine (From Nov 02 15May03)
This project is developed to automate the regulatory reporting system in Shinsei Bank as users are using excel to prepare reports. This project allows users to define fields dynamically and generate reports as per the rules and queries defined by users.
Client:Shinsei Bank, Tokyo (Japan on Site)
Operating System:Windows NT
Database:SQL Server 2000 on Windows NT
Application Server:IIS 5.0
Development Tools:ASP, HTML, Crystal Reports 9.0
Role: System Analyst. Involved in the requirement analysis, design, testing. Prepared user requirement specification, detailed design document. Involved in system testing and system integration testing. Written new procedure, functions in SQL server and deployed ASP pages and crystal reports on the IIS server.
10.OLECA-FLEXCUBE (OnLine Account Posting, Earmarking & Credit Availment From Jan01 Nov 02)
(OLECA) is a corporate banking gateway with Flexcube (iFlex product), which receives different types of accounting transactions in shape of MQ messages from different Front ends (COSMOS, SECORE, MM, FTI) and pass these MQ messages to Flexcube for Account Balance Check, Posting and Credit Facility availment.
Client:CITI Bank (Asia Pacific Technology Division), Singapore
Roll-out:South East Asia region, 14 countries in total
Operating System:Unix HP 11i
Database:Oracle 8i
Development Tools:IBM MQ Series, C, Pro*C, SSJS, PL/SQL, Shell scripting,
Citisafe security for each environment.
Role: Senior Developer. Involved in the requirement analysis,
design, development, testing, implementation, user training and skill transfer. Involved in
System testing and system integration testing.
Task Performed
•Recycling feature of online Transaction is implemented saving almost 2.5 time of F/E.
•Contingency RBMN for F/E and Flexcube implemented on very critical time lines. Which had saved effort of users to re-input the transaction.
•Auto monitoring system implemented in Unix to monitor the application processes and raise problem ticket(GTMS) in case of problem.
•Source code promotion procedure automated from SIT to UAT and UAT to PROD. Which had reduced promotion effort 1 md from 1.5 md.
•A new change promotion system (PVCS) implemented successfully without any help from Change Management.
•Queues in Oracle implemented for joining another interface like MQ. It saved extra load on MQ server and development efforts also.
•Production support provided for all the rolled countries and resolution given within SLA (Service Level Agreement).
•Creation of stored procedures, functions, triggers using diff. features like utl_file, dbms_lob.
•Trouble shooting of problems faced in the system like locking, slow response, system crash etc.
Achievements
Client has appreciated the dedication and work done for the success of this project and Nucleus Software has given the Best employee award as recognition.
11.OLECA-JAPAN (From Sept 01 - Dec 01)
OLECA is implemented altogether in different shape in Japan, as there is no CRMS and Flexcube existence. So, studied the Japan Credit Application for the information required for OLECA. Business requirement is also different in Japan from other countries. So, OLECA is working as Complete Accounting Server in Japan and taking decision related to Credit Limits and all.
Client:CITIBANK N.A, Japan
Operating System:Unix HP 11i
Database:Oracle 8i
Development Tools:IBM MQ Series, C, Pro*C, SSJS, PL/SQL, Shell
Scripting, Citisafe security for each environment.
Role: Senior Developer. Involved in the requirement analysis,
design, development, testing, implementation, user training and skill transfer. Involved in
System testing and system integration testing.
Task Performed
System processes 3 messages per second and each message contains 20 transactions.
BOD process is designed to refresh the database and it build complete database used in intra
day transactions in the short timelines.
Credit Limits are maintained at Group Level, each transaction should traverse the tree of
customer and update the limits.
OLECA is decision maker for all type of transactions in absence of Flexcube.
Complete Database design is change in absence of CRMS, designed the handoff in fashion to
cater the current design and minimum code changes.
Special handling required for Credit Transactions, which doesnt have authorisation.
Account pooling needs to be done in BOD to provide benefits to customers and save intra day
processing time.
12.FinnOne -FAS (Finance Against Securities From April00 Aug 00)