$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Software Eng - SQL - Documentation
Anto Joy
,
ILFORD, United Kingdom
Experience
Other titles
Skills
I'm offering
12+ years of IT experience, with expertise in Design, Development, Integration of migration and conversion projects using Oracle PLSQL, Shell Scripting and Autosys based technologies and good exposure in Banking and Financial Solution including 4+ years in project lead roles.
Looking for technical or creative dev kind of stuff. Open for social media or documentation type of stuff as well.
Looking for technical or creative dev kind of stuff. Open for social media or documentation type of stuff as well.
Markets
United Kingdom
Language
English
Fluently
Ready for
Ongoing relation / part-time
Available
My experience
2014 - ?
job
Senior software Developer
Bank of Montreal, CANADA.
Description
Loan IQ, designed by Misys, is an integrated commercial lending system designed for the syndication and distribution of large and medium commercial loans. Loan IQ is also the booking system for Commercial and Business Banking. The system is accessed through an installed application
Loan IQ integrates the origination, distribution, trading, loan servicing and management control and portfolio management business processes
Loan IQ records the bank's entire loan and exposure related credit activity.
We have close to 600+ reports for Loan IQ, developed using crystal reports and scheduled and maintained in Business Objects.
Responsibilities
• Analyzing the business rules from DRS documents and preparation of the Technical design documents.
• Providing design walkthroughs and technical inputs to the project team.
• Coordinating with clients and external teams on requirement analysis and impact analysis of the project
• Creating Crystal reports, adhoc queries, stored procedures, table scripts based on the requirement provided by Loan IQ BA's.
• Code reviewing from the quality and performance point of view.
• Create reconciliation process to validate the data from source with that loaded to database.
• Setting up and configure the reports in Business objects and schedule the reports as per DRS
• Used Clearcase as the Code Repository.
• Preparing Unit and System test plan to cover all the requirements.
• Extensively used Quality Center for Defect Tracking.
Solution Environment Windows, SQL Server, Unix
Tool/ Technology Loan IQ , Advanced Query tuning tool, Shell Scripts, Clearcase.
Work Location Fir First Canadian Place, Bank Of Montreal, Toronto & Siruseri Chennai
Project CAU Migration
Loan IQ, designed by Misys, is an integrated commercial lending system designed for the syndication and distribution of large and medium commercial loans. Loan IQ is also the booking system for Commercial and Business Banking. The system is accessed through an installed application
Loan IQ integrates the origination, distribution, trading, loan servicing and management control and portfolio management business processes
Loan IQ records the bank's entire loan and exposure related credit activity.
We have close to 600+ reports for Loan IQ, developed using crystal reports and scheduled and maintained in Business Objects.
Responsibilities
• Analyzing the business rules from DRS documents and preparation of the Technical design documents.
• Providing design walkthroughs and technical inputs to the project team.
• Coordinating with clients and external teams on requirement analysis and impact analysis of the project
• Creating Crystal reports, adhoc queries, stored procedures, table scripts based on the requirement provided by Loan IQ BA's.
• Code reviewing from the quality and performance point of view.
• Create reconciliation process to validate the data from source with that loaded to database.
• Setting up and configure the reports in Business objects and schedule the reports as per DRS
• Used Clearcase as the Code Repository.
• Preparing Unit and System test plan to cover all the requirements.
• Extensively used Quality Center for Defect Tracking.
Solution Environment Windows, SQL Server, Unix
Tool/ Technology Loan IQ , Advanced Query tuning tool, Shell Scripts, Clearcase.
Work Location Fir First Canadian Place, Bank Of Montreal, Toronto & Siruseri Chennai
Project CAU Migration
Unix, Processes, UP, Tuning, Booking, Stored procedures, Server, Software, Banking, Design, Developer, Technology, Windows, Management, Test, Database, SQL Server, Sql
2012 - 2013
job
Senior software Developer
Royal Bank Of Scotland.
Description
FARM project is addressing the issue for various feed in Royal Bank of Scotland. This is an audit regulatory requirement to make sure there are no sanctioned entities in the source system. Currently some of the feeds are doing the same by manual verification. This project addresses those issues using automated CLIF database. It regulates all the important feeds to send their details to CLIF team which in turn will do the validation and raise the alert for PEP and sanctioned entities.
Responsibilities
• Analyzing the business rules from BRD documents and preparation of the Technical design documents.
• Providing design walkthroughs and technical inputs to the project team.
• Creating Sequence of Events (SOE) documents for the production implementation.
• Coordinating with clients and external teams on requirement analysis and impact analysis of the project
• Creating Stored Procedures, Functions ,table scripts and UNIX shell scripts to load data from CSV files to database along with Error handling
• Code reviewing from the quality and performance point of view.
• Create reconciliation process to validate the data from source with that loaded to database.
• Used Clearcase as the Code Repository.
• Preparing Unit and System test plan to cover all the requirements.
• Extensively used Clearquest for Defect Tracking.
Solution Environment UNIX, Oracle 10g
Tool/ Technology Ab Initio , Control M, TOAD, Shell Scripts, Clearcase, Clearquest, UNIX.
Work Location TATA Consultancy Services, Chennai - India
Project CRMS - Legal Entity Onboarding
FARM project is addressing the issue for various feed in Royal Bank of Scotland. This is an audit regulatory requirement to make sure there are no sanctioned entities in the source system. Currently some of the feeds are doing the same by manual verification. This project addresses those issues using automated CLIF database. It regulates all the important feeds to send their details to CLIF team which in turn will do the validation and raise the alert for PEP and sanctioned entities.
Responsibilities
• Analyzing the business rules from BRD documents and preparation of the Technical design documents.
• Providing design walkthroughs and technical inputs to the project team.
• Creating Sequence of Events (SOE) documents for the production implementation.
• Coordinating with clients and external teams on requirement analysis and impact analysis of the project
• Creating Stored Procedures, Functions ,table scripts and UNIX shell scripts to load data from CSV files to database along with Error handling
• Code reviewing from the quality and performance point of view.
• Create reconciliation process to validate the data from source with that loaded to database.
• Used Clearcase as the Code Repository.
• Preparing Unit and System test plan to cover all the requirements.
• Extensively used Clearquest for Defect Tracking.
Solution Environment UNIX, Oracle 10g
Tool/ Technology Ab Initio , Control M, TOAD, Shell Scripts, Clearcase, Clearquest, UNIX.
Work Location TATA Consultancy Services, Chennai - India
Project CRMS - Legal Entity Onboarding
Unix, Production, Regulatory, Audit, Stored procedures, Software, Audit, Implementation, Onboarding, Design, Developer, Technology, It, Test, Oracle, Database, SoMe
2011 - 2012
job
Project Lead - Onsite
Bank Of America.
Description
Legal Entity On-boarding (LEO) project is addressing the need for a single integrated system within Bank of America for Storing the Anti Money Laundering(AML) data for the different lines of Business within the bank. This will reduce the number of duplicate AML KYC entities and reduce the application maintenance cost.
Responsibilities
• Analyzing the business rules from BRD documents and preparation of the Technical design documents.
• Providing design walkthroughs and technical inputs to the project team.
• Coordinating with clients and external teams on requirement analysis and impact analysis of the project
• Detailed Analysis of the requirements, High Level and Low Level Design Documentation.
• Co ordination with offshore team to explain the design and requirement.
• Creating Stored Procedures, Functions ,table scripts and UNIX shell scripts to load data from source team files to database along with Error handling
• Creating Batch jobs using Autosys Job Scheduler.
• Code reviewing from the quality and performance point of view.
• Used Clearcase as the Code Repository.
• Preparing Unit and System test plan to cover all the requirements.
• Extensively used Clearquest for Defect Tracking.
• Unit Testing and Integration Testing of developed modules.
• Fixing of Defects raised during SIT and UAT.
• Created SharePoint path to maintain the project related documents.
Legal Entity On-boarding (LEO) project is addressing the need for a single integrated system within Bank of America for Storing the Anti Money Laundering(AML) data for the different lines of Business within the bank. This will reduce the number of duplicate AML KYC entities and reduce the application maintenance cost.
Responsibilities
• Analyzing the business rules from BRD documents and preparation of the Technical design documents.
• Providing design walkthroughs and technical inputs to the project team.
• Coordinating with clients and external teams on requirement analysis and impact analysis of the project
• Detailed Analysis of the requirements, High Level and Low Level Design Documentation.
• Co ordination with offshore team to explain the design and requirement.
• Creating Stored Procedures, Functions ,table scripts and UNIX shell scripts to load data from source team files to database along with Error handling
• Creating Batch jobs using Autosys Job Scheduler.
• Code reviewing from the quality and performance point of view.
• Used Clearcase as the Code Repository.
• Preparing Unit and System test plan to cover all the requirements.
• Extensively used Clearquest for Defect Tracking.
• Unit Testing and Integration Testing of developed modules.
• Fixing of Defects raised during SIT and UAT.
• Created SharePoint path to maintain the project related documents.
Design, Database, SharePoint, Test, Integration, Unix, Offshore, Testing, Stored procedures, KYC
Anto's reviews
Anto has not received any reviews on Worksome.
Contact Anto Joy
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Anto directly in Worksome.
are ready to help you
and get specific bids from skilled talent in Denmark