Data Project
Resume:
CURRICULAM VITAE
Dilip Kumar Bhanja ******.***@*****.***
Profile
Working Assistant Manager a with 14+years of experience in successful design, development and implementation and support of web, client-server.
worked on client location (UK) as a onsite coordinator.
Good understanding on the functional domain(Banking and Financial) of the application.
Interacting with client to gather the requirement and making the team member to understand the functionality for the application and requirement.
Analyze and fix any data related issue causing by other system.
Oracle FCCM (Mantas) implementation and data migration.
DIS data mapping, encryption and data Quality.
Thresholds analysis and tuning.
Watch list and threshold implementation
Mantas batch scheduling and Batch run with Control-M.
Mantas batch scheduling and Batch run with Control-M.
Customize or develop new Oracle FCCM (Mantas) scenarios if out of box scenario doesn't satisfy red flag requirements Mantas scenario development with scenario developer
Involving in fixing the Critical production issue.
Preparing weekly, monthly report for call with the client.
Giving helping hand to make understand the requirement, issue to team member.
Involving on Quality audit.
Involving on DR issue during the DR activity.
Involving in implementing the code in UAT, QAT (Pre prod) and Prod.
Involving on guiding to team to write Unit test case, preparing business logic document etc.
Writing the script to clearing the old files from the server as per the retention policy.
Writing the script for getting data in the form of file, dblink from source system and loading those files into our system as per the locations.
Involving on writing the script for automating the various manual activity. Like generating the reports as per the business requirement and sending the report to the business with the attachment.
Managing of 15 member team.
Scheduling the jobs in Control-M and Geneos.
Explain the data field requirements of different source files require to run the identified trade surveillance scenarios and work with source system for data mapping and data assessment to ensure that data is sourced in good quality.
Work with the business to understand the requirement to prioritize the alerts and apply scoring rules.
Implement alerts assignment rules.
User set up and management
Investigate the issues like alerts not generated, data not populated correctly etc in all phases of the projects
TECHNICAL SKILLS
Databases
Oracle 8i,9i,10g,11g
Languages
PL/SQL, SQL, Unix Shell Script,AML -Mantas(OFSAA, FCCM )
Platforms
Hp-UX 12,UNIX, Windows 2000 Server, Windows NT 4.0
Tools
10gAs, SQL* Loader, SQL Plus, Toad,clarify,dbsymphony,Control-M,Geneos,Matas,Jira,Servicenow
Version Control
SVN
ACADEMIC QUALIFICATION
Degree
University
Marks Obtained
B.E (Bachelor of Engineering) in Electronics & Telecommunication
B.I.E.T, Orissa
67%
EXPERIENCE SUMMARY
Company
Client
Location
Period
Accenture LLP
Crediti swis
HCL America Inc
UBS
USA(NJ)
Mar 2018-Till date
HCL Technology
DB
Bangalore
Mar 2010 –Feb 2018
IGATE Global Solutions
GE Commercial Finance, Australia
Bangalore
Feb 2007 – Mar-2010
IGATE Global Solutions
GE CORPORATE
Bangalore
Sep 2006 – June 2007
Artech Infosystems Private Limited
Celestica
Hyderabad
July 2005 – Sep 2006
PERSONAL INFO
Name
Dilip Kumar Bhanja
Nationality
Indian
Country Living
USA
Marital Status
Married
PROFESSIONAL EXPERIENCE
ASSIGNMENT – I
Company
Accenture
Client
Credit suciss
Project Name
AML(Anti money laundering)
Project Environment
Oracle 9i/10g, PL/SQL, Shell Script,Mantas
Project Period
Oct - 2019 – Till Date
Anti-money laundering (AML) refers to the laws, regulations and procedures intended to prevent criminals from disguising illegally obtained funds as legitimate income. Though anti-money laundering laws cover a limited range of transactions and criminal behavior, their implications are far-reaching. For example, AML regulations require banks and other financial institutions that issue credit or accept customer deposits to follow rules that ensure they are not aiding
Roles and Responsibilities
Good understanding on the functional domain of the application.
Monitor, track and ensure all AML relevant legislative and regulatory changes are duly considered and that local AML policies and procedures reflect required regulatory and CS internal standards.
Conduct periodic review of Mantas Scenarios and Thresholds review as required
Manage BAU Change Management process (Change Requests, BoW changes etc.).
Alert routing and Watchlist maintenance
Worked on Business, Geography, Entity and Activity risk projects
Provide management with enough, frequent and objective information to get an accurate picture of the ML risks the bank is exposed through its activities and individual business
Analyze and fix any data related issue causing by other system.
Involved in IM call for P3C or above incident to fix the production P3c or above incident.
Identify the repeated incident and Create knowledge based article (KEDB). This enhance the response and resolution time of the incident.
Involve on the RCA for the application functional issue.
Explain the data field requirements of different source files require to run the identified trade surveillance scenarios and work with source system for data mapping and data assessment to ensure that data is sourced in good quality.
Work with the business to understand the requirement to prioritize the alerts and apply scoring rules.
Involved on DR activity that has been scheduled as per the datacenter.
ASSIGNMENT – II
Company
HCL America Inc
Client
UBS
Project Name
SABRE
Project Environment
Oracle 9i/10g, PL/SQL, Shell Script
Project Period
Mar - 2018 – Sep-2019
SABRE is a platform which give generates the swap trade on the top of hedging trade. This is is Middle office which accept transactional information like hedging trade,satic data like client, instrument information,price information from various upsteam system and generate the swap trade with cashflow,postion details in SABRE as per the swap algorithms and provide the information to the down system like P&L,regulatory and reconciliation system for their reporting and forecasting..
This is also some time act as a front office where business stack holder can book the trade as per the trader request. Application has future to do the amendment of the client detail, speed value, maturity date for the specific trade..This also have feature to upload the static client information.
Roles and Responsibilities
Good understanding on the functional domain of the application.
Analyze and fix any data related issue causing by other system.
Involved in IM call for P3C or above incident to fix the production P3c or above incident.
Good understanding ITIL process.
Implemented Geneos across the DB to avoid the SOD and health checks.
Identify the repeated incident and Create knowledge based article (KEDB). This enhance the response and resolution time of the incident.
Weekly setting up the call with the SL3/Dev team to track the PM status or any long pending issue.
Involve on the RCA for the application functional issue.
Explain the data field requirements of different source files require to run the identified trade surveillance scenarios and work with source system for data mapping and data assessment to ensure that data is sourced in good quality.
Work with the business to understand the requirement to prioritize the alerts and apply scoring rules.
Implement alerts assignment rules.
User set up and management
Run the batch using control-M and generate the alerts.
Investigate the issues like alerts not generated, data not populated correctly etc in all phases of the projects
Track all the SL to avoid any breaches.
Implement production changes as per the steps mentioned in the GCM.
Involved on the new application or any release activity transition from Dev team.
Involved on DR activity that has been scheduled as per the datacenter.
Created incident and SR matrix which help the team to track the process of the incident and SR .
ASSIGNMENT – III
Company
HCL Technologies
Client
Deutsche Bank
Project Name
LiMA
Project Environment
Oracle 9i/10g, PL/SQL, Shell Script,Mantas
Project Period
May - 2011 – Feb 2018
Liquidity Risk is the risk to a bank’s earnings and capital arising from the inability to meet obligations in a timely manner when they come due without incurring unacceptable losses.It is the responsibility of the Group Treasury - Liquidity Management (GT - LM) to ensure that sufficient funds are available at a reasonable cost to meet contractual and potential payment obligations.The general approach for the system has been to show all payments and cash receipts as they fall due. To achieve this the cashflow profile of all positions of both, the trading and banking books, are shown for two months (fifty-six calendar days). The positions are taken as a snapshot at the end of the business day for which the reports are generated. The cashflows are aggregated and netted for each day, currency and trading area. After this process these daily totals, called ECL, are then cumulated along the tenors. These cumulated figures are called Maximum Cash Outflows, or MCOs.Where this treatment is materially different to the expected outcome, for example call accounts with a 48 hours’ notice period, various models have been applied to provide a more realistic forecast. All exposures are represented in billions of Eurosor for the smaller exposures, in Millions of Euro The net of all the currencies is also aggregated and represents the short term liquidity exposure of DB Group, irrespective of currency.
Roles and Responsibilities
Good understanding on the functional domain of the application.
Analyze and fix any data related issue causing by other system.
Involved in IM call for P3C or above incident to fix the production P3c or above incident.
Good understanding ITIL process.
Implemented Geneos across the DB to avoid the SOD and health checks.
Identify the repeated incident and Create knowledge based article (KEDB). This enhance the response and resolution time of the incident.
Weekly setting up the call with the SL3/Dev team to track the PM status or any long pending issue.
Involve on the RCA for the application functional issue.
Explain the data field requirements of different source files require to run the identified trade surveillance scenarios and work with source system for data mapping and data assessment to ensure that data is sourced in good quality.
Work with the business to understand the requirement to prioritize the alerts and apply scoring rules.
Implement alerts assignment rules.
User set up and management
Run the batch using control-M and generate the alerts.
Investigate the issues like alerts not generated, data not populated correctly etc in all phases of the projects
Track all the SL to avoid any breaches.
Implement production changes as per the steps mentioned in the GCM.
Involved on the new application or any release activity transition from Dev team.
Involved on DR activity that has been scheduled as per the datacenter.
Created incident and SR matrix which help the team to track the process of the incident and SR .
ASSIGNMENT – IV
Company
HCL Technologies
Client
Deutsche Bank
Project Name
PRAMS
Project Environment
Oracle 9i, PL/SQL, Shell script
Project Period
Mar - 2010 – Apr-2011
PRAMS is Position Risk Analysis and Management System.Mark to Market Nominal Positions is End of the Holdings multiplied by the price. These positions are net of sales and Purchase i.e. Securities held at end of the day.End of Day Positions is number of Bonds/shares/stocks held (net of sales and purchases).PRAMS collates and consolidates the positions for the Fixed Income business Group around the world for Deutsche Bank.Means, Whatever trade done any part of the world by the authorized traders on behalf of Deutsche Bank or by the Bank, directly is collated by PRAMS.PRAMS, after collating the positions, reports this in terms of risk exposure on these holdings. Infact, PRAMS doesn’t calculate the risk exposure for the positions. It just gives an aggregate figure and also reports the netted positions at the different levels of organizational hierarchy.
PRAMS receives the price, positions and security data from various sources, Bloomberg being the major source.Through Bloomberg, PRAMS, receives the data for Singapore (BBSGP), New York (BBNY), Europe (BBSBI), Asia Pacific (BBAP), Tokyo (SPTOK). Others being, INNY (dbMortgage), Sydney Positions and Securities, Argentina (INARG and INABD) etc.These systems can be referred to as upstream systems. In turn, PRAMS extract the data for Positions, Securities and supplies to the other systems can be called as Downstream systems.The most important system being GRIT (Global Risk Information Technology). This system assesses the risk based on the data supplied by PRAMS.A key feature of PRAMS is security rating. PRAMS have a logic in place for select the ratings based on the ratings suggested by upstream systems. There are many factors depending on which, PRAMS rates the securities.
Roles and Responsibilities
Good understanding on the functional domain of the application.
Analyze and fix any data related issue causing by other system.
Involved in IM call for P3C or above incident to fix the production P3c or above incident.
Good understanding ITIL process.
Implemented Geneos across the DB to avoid the SOD and health checks.
Identify the repeated incident and Create knowledge based article (KEDB). This enhance the response and resolution time of the incident.
Weekly setting up the call with the SL3/Dev team to track the PM status or any long pending issue.
Involve on the RCA for the application functional issue.
Have good understanding on the ASM.
Track all the SL to avoid any breaches.
Implement production changes as per the steps mentioned in the GCM.
Involved on the new application or any release activity transition from Dev team.
Involved on DR activity that has been scheduled as per the datacenter.
Created incident and SR matrix which help the team to track the process of the incident and SR .
ASSIGNMENT – V
Company
IGATE Global solutions, Australia.
Client
GE Commercial Finance – Custom Fleet, Australia.
Project Name
COBRA – Key Access, Key Online, VSP
Project Environment
Oracle 9i, PL/SQL, Java Script
Project Period
July - 2007 – Till Date
Custom Fleet is part of GE Commercial Finance, one of the world's leading automotive financial services and fleet management companies, supporting a fleet in excess of 1.5 million vehicles in 22 countries. COBRA supports all aspects of managing vehicle leasing and fleet management contracts. COBRA manages the following leasing contracts like operational lease, financial lease, credit finance, revolving credit, short-term rental, novated lease, service contract & fleet management. COBRA automates the overall administrative aspects of vehicle leasing contracts - from creating a prospect to remarketing of the end-of-contract vehicle. COBRA takes care of the logistics of document management and effectively provides a workflow management tool for customizing the specific administrative procedures required.
The batch system interacts with parent lease system called Leasebase. There are hourly batch and overnight batch that synchronize the data between two systems. The vehicle information and vehicle strategy are retrieved from JATO system and synchronized. The vehicle information is also passed to another system called 1Link.
Roles and Responsibilities
Gathering requirement and preparing System design specification.
Analysing the effort time to deliver and resource planning.
Created tables, views, indexes, sequences and developed procedures, functions, stored procedures. Creation of PL/SQL package and number of database objects for building distribution table and enforcing all validation rules.
Design the screens and the logics to reduce the complexity of the code.
Developing the module and also allocating resources for development.
Closely co-ordinate and work with developer in the developing and system testing.
Attending and fixing production defects that comes through clarify case from L3 team.
Preparing complete weekly status report for clients and keeping them updated.
ASSIGNMENT – VI
Company
IGATE Global solutions, Australia.
Client
GE Commercial Finance – Custom Fleet, Australia.
Project Name
COBRA – Key Access, Key Online, VSP
Project Environment
Oracle 9i, PL/SQL, Java Script
Project Period
July - 2007 – Till Date
Custom Fleet is part of GE Commercial Finance, one of the world's leading automotive financial services and fleet management companies, supporting a fleet in excess of 1.5 million vehicles in 22 countries. COBRA supports all aspects of managing vehicle leasing and fleet management contracts. COBRA manages the following leasing contracts like operational lease, financial lease, credit finance, revolving credit, short-term rental, novated lease, service contract & fleet management. COBRA automates the overall administrative aspects of vehicle leasing contracts - from creating a prospect to remarketing of the end-of-contract vehicle. COBRA takes care of the logistics of document management and effectively provides a workflow management tool for customizing the specific administrative procedures required.
The batch system interacts with parent lease system called Leasebase. There are hourly batch and overnight batch that synchronize the data between two systems. The vehicle information and vehicle strategy are retrieved from JATO system and synchronized. The vehicle information is also passed to another system called 1Link.
Roles and Responsibilities
Gathering requirement and preparing System design specification.
Analysing the effort time to deliver and resource planning.
Created tables, views, indexes, sequences and developed procedures, functions, stored procedures. Creation of PL/SQL package and number of database objects for building distribution table and enforcing all validation rules.
Design the screens and the logics to reduce the complexity of the code.
Developing the module and also allocating resources for development.
Closely co-ordinate and work with developer in the developing and system testing.
Attending and fixing production defects that comes through clarify case from L3 team.
Preparing complete weekly status report for clients and keeping them updated.
ASSIGNMENT – VII
Company
IGATE Global solutions
Client
GE CORPORATE
Project Name
GE HR SYSTEM
Project Environment
Oracle 9i, PL/SQL, Unix shell script, SQL* Loader
Project Period
Sep-2006 – Feb 2007
Project Description
Ecompensation is a salary-planning tool for all the GE business worldwide. Ecompensation allows the users like compensation manager and system administrator to create plans like salary planning, bonus planning and combo plans etc. for a specific division in GE.
It is having various modules like Plan creation module, Admin module, Employee planning, Plan list module. Through this tool we can create a plan for the employee depending on their permissions to the different organization. Plan creation has various steps like entering plan details tab, plan population tab, target values tab, valid values tab for the unit.
After the plan is created, Ecompensation allows the HR or line manager to do the actual planning for the individual employee. Ecompensation admin modules consist of Change Administration, Hierarchy Administration, and Employee Administration, User Administration, User Reports, and User Administration etc
Roles and Responsibilities
Designed algorithm for implementing numerous client’s business rules. Created tables, views, indexes, sequences and developed procedures, functions, stored procedures. Creation of PL/SQL package and number of database objects for building distribution table and enforcing all validation rules.
Design the screens and the logics to reduce the complexity of the code.
Prepared the test cases for the users testing and the project documentation. Bug fixing and trouble shooting major cases, which were encountered while integrating testing and UAT.
Optimization of queries by creating Indexes, Hints and testing all queries using Explain Plan.
ASSIGNMENT – VIII
Company
Artech Infosystems Private Limited
Client
IBM India (Hyadrabad)
Project Name
Celestica
Project Environment
Oracle 9i, PL/SQL, Unix shell script, SQL* Loader, PL/SQL Developer, Discoverer
Project Period
Jul-2005 – Sep 2006
Project Description
The SCMDW application allows Celestica International Inc. Toronto HQ to have a full control on their Electronic Manufacturing Services, Fulfillment Services, After Marketing Services by extending the Right information to Appropriate authority in Right time with consistent data and information in the form of Reports for internal customers and external clients. SCMDW is a data warehouse of unique kind in North America – in terms of size-wise it is 1.2 terabyte application runs on Oracle 9i Enterprise Edition (9.2.0.6) on IBM Aix 5.2 operating system with tools that include Oracle Workflow 2.6 and Oracle Warehouse Builder, Tivoli Workload scheduler 1.3 patch 5. It holds the schemas of highly normalized database referred to as scm3NFD and data warehouse referred to as SCMDM.
.
Roles and Responsibilities
Designed algorithm for implementing numerous client’s business rules. Created tables, views, indexes, sequences and developed procedures, functions, stored procedures. Creation of PL/SQL package and number of database objects for building distribution table and enforcing all validation rules.
Design the screens and the logics to reduce the complexity of the code.
Numerous front-end applications like forms and reports where created using Forms 6i and Reports 6i.
Critical reports and Labels were development-using Reports6i.
Design the screens and the logics to reduce the complexity of the code.
Prepared the test cases for the users testing and the project documentation. Bug fixing and trouble shooting major cases, which were encountered while integrating testing and UAT.
Optimization of queries by creating Indexes, Hints and testing all queries using Explain Plan.
Place : North Carolina Name: Dilip Kumar Bhanja
Date :
Contact this candidate