Lead Role for Ab-Initio Development,Sql,Pl/sql with Datawarehousing.
Tata Consultancy Services
Total years of experience :16 years, 11 Months
1. Currently working as a ETL Consultant for Lloyds banking Group, London Bridge. In this project working for One ledger program. This project is based on migration the banking ledgers in various systems into one standardized ledger using Accounting ledger finance management. In this, working as a Senior ETL consultant for migrating the incoming source data into Oracle fusion using AAH(Aptitude accounting hub by microgen).In this using Oracle 12C, Sql, Pl/sql, Data warehousing concepts, Unix shell scripting, Aptitude Accounting hub tool for ETL migration.
As part of Lloyds banking project completed certification for Microgen Aptitude consultant with 95% marks in Microgen plc co., London, United Kingdom.
2. worked for Virgin Media account in Hook, United kingdom for data designer role with Oracle 11g, 12c sql, pl/sql, Ab-Initio ETL Design, Unix shell scripting, Netezza, Microsoft Visio.
In this project working as key member for Nexflow Wayleaves project and in this project getting requirement from the client and accordingly providing the development activities with my offshore team. In this role providing end to end support for the Wayleaves project execution.
3. Worked for STC Operational Data Store Team as a Technical lead. In this team working with Ab-Initio ETL Tool in Oracle-11g Exadata environment. In ODS worked for ICMS, IRB and CRM data extracts through sql query and providing data to EDW, Revenue Assurance Team etc, ICMS team etc.In ODS, worked in Onsite as Ab-Initio developer and have good Co-Ordination with ODS Operations team for scheduling related activities in Ops-Console Scheduling tool. In ODS worked for tuning Sql, Pl/Sql related activities as per requirement. In ODS worked with Ab-Initio common graph functionality for giving extracts to various teams in STC.
ICMS (Landline Customers) : ICMS is a combination of CRM and Billing system.In this we are fetching payment details from sadad_payment_log_sadlog, epymnt_log_hstry_saeplog, account_pymnt_blpymnt. In this getting data in files and its getting processed at ODS end and loaded into table. Customer level details identified based on id_type and id_number.In this we are handling blpymnt for landline customers and we have demographic table for getting customer brief description. In this each customer can have more than 1 account and we can get details from cmacct file. In this we have details for the following key areas:
Customer Level Details in CMICUS and CMMAST files.
Segment level details in SASSIP files.
Demographic like gender, nationality etc. in SACMNT files.
All Active Service Order details in SVORDR files.
Sales Agent Level Details in SAUISA files.
Exchange level details in PLSAM files.
Rateplan details in SAORRP files.
All services and their expiry etc. in SUBXTL files.
Account Level details, Billing cycle details in CMACCT files.At ODS end, file’s data is getting populated into corresponding tables through replication, and if table is coming through replication then it indicates “00” at end.If “00” not at end, then this table will not be considered as main table.
Previously worked as team lead for Operation and Maintenance team in STC. In this we are working with Informatica 7.0, Siebel Analytics, Sql, Pl/sql, Unix Shell Scripting, Oracle 10g Performance Tunning.In this project we are creating Informatica Mapping, Creating Reports using Siebel Analytics and we are correcting data as well when there is having issues with data. In this we are generating Daily Basis reports like Daily Sales Report, QA Report, Daily Adjustment Report, Postpaid/Prepaid Customer Details as per client requirement. In this we are involved with Data Archival process as well, Generating Reconciliation report etc.
Database: Oracle 11g exadata, Sql, Pl/sql, DBA Activities, Performance Tuning
Tools: Ab-Initio (Ver - 3.6.0), Informatica Ver. - 7.0, Siebel Analytics Reporting tool.
Worked with sql, pl/sql, DBA Activities as Software Developer(Team Lead) In Tech Mahindra Ltd. In tech Mahindra, we are working for British Telecom (BT-04) Project.In this I worked with 3 Databases i.e. PIMS, PIRM and SPND.In Tech Mahindra; I designed complete SPND Application Database.
BACK END: - ORACLE 8i, 9i, 10g, schema based .xml, .xml build
FRONT END: - CORE JAVA WITH JAVA SWINGS.
PIMS Database based on Telecom Inventory Management System and this database is designed by Onsite (British Telecom), but now it’s completely hand over to me and my activity is to change in Database Structure as per User (British Telecom) Requirement.Nuspnd is completely designed by me as per British Telecom requirement.
In PIMS and SPND Database we are using .XML scripts for creating build. In PIRM, I have created complete ETL Process, SQL, PL/SQL, UNIX Shell scripts, .xml build.
Worked with sql, pl/sql, DBA Activities as Software Developer(Team Lead) In Tech Mahindra Ltd. In tech Mahindra, we are working for British Telecom (BT-04) Project.In this I worked with 3 Databases i.e. PIMS, PIRM and SPND.In Tech Mahindra; I designed complete SPND Application Database.
BACK END: - ORACLE 8i, 9i, 10g, schema based .xml, .xml build
FRONT END: - CORE JAVA WITH JAVA SWINGS.
PIMS Database based on Telecom Inventory Management System and this database is designed by Onsite (British Telecom), but now it’s completely hand over to me and my activity is to change in Database Structure as per User (British Telecom) Requirement.Nuspnd is completely designed by me as per British Telecom requirement.
In PIMS and SPND Database we are using .XML scripts for creating build. In PIRM, I have created complete ETL Process, SQL, PL/SQL, UNIX Shell scripts, .xml build.
Worked with sql, pl/sql, DBA Activities as Software Developer(Team Lead) In Tech Mahindra Ltd. In tech Mahindra, we are working for British Telecom (BT-04) Project.In this I worked with 3 Databases i.e. PIMS, PIRM and SPND.In Tech Mahindra; I designed complete SPND Application Database.
BACK END: - ORACLE 8i, 9i, 10g, schema based .xml, .xml build
FRONT END: - CORE JAVA WITH JAVA SWINGS.
PIMS Database based on Telecom Inventory Management System and this database is designed by Onsite (British Telecom), but now it’s completely hand over to me and my activity is to change in Database Structure as per User (British Telecom) Requirement.Nuspnd is completely designed by me as per British Telecom requirement.
In PIMS and SPND Database we are using .XML scripts for creating build. In PIRM, I have created complete ETL Process, SQL, PL/SQL, UNIX Shell scripts, .xml build.
Software development for Fincraft (Core Banking System) by Nelito Systems Ltd. For various co-operative banks and in this Software we are working for various Modules like Cash, Clearing, Bills etc. and purpose of this software is to provide core banking facility to various commercial banks.
->5. Software Development in Centurion Bank of Punjab for Core Banking System with finacle scripting as Front End and in this Project we worked on Sql, Pl/sql with Finacle scripting as front End. In this Project we have also build some .com files in Shell Scripting. In this we have handled overall clearing module, cash module, bills module, maintain sweep balances for various Bank Schemes. In this Project we are creating Packages, Functions, Procedures, Cursors, Triggers, Using Collections etc.
BACK END: - ORACLE 9I, SHELL SCRIPTING.
FRONT END:- FINACLE SCRIPTING, MRT
-> Software Development in Bank of India in UNIX, Sql, Pl/Sql with Finacle scripting as Front End, Maha Report (mrt) for generating Bank reports as per Bank requirement. In this project we have also build some .com files in shell scripting. In this we have handled overall clearing module, Deposits, Advances, cash module, bills module etc.In this we are creating Packages, Procedures, Functions, Cursors, Using Collections for generating Bank reports and We are firing triggers for controlling Bank Activities as per Requirement.
BACK END: - ORACLE 9I, SHELL SCRIPTING.
FRONT END: - FINACLE SCRIPTING, MRT.
DATABASE SIZE: - 7 TERABYTES
7. Software development (ETL Process Developer) for Bank of India in sql, pl/sql, Discoverer, shell scripting with OFSA (Oracle Financial Services Application).
BACK END: - ORACLE 9I, SQL, PL/SQL, SHELL SCRIPTING.
FRONT END: - DISCOVERER.
DATABASE SIZE:- 7 TERABYTES
In this we are Automating to our ETL Process by Sql, pl/sql, OFSA but for some sources like Deposits, Advances etc. we are loading data through External table into source table and then execute ETL Process i.e. Oracle Warehouse Builder for applying Business Rules on Data. Then after applying Business Rule, Data is Available for Bank Business Related Decisions. We are creating ETL Process and we are also working on Bank major reports Using sql, pl/sql, Unix, Discoverer like Priority Sector Report, Statistical Business Report for Bank, BSR-1, 2, 3, CA23 etc.After creating report in Discoverer we are Creating SQL ID(Execution of Pl/sql Code by User) in OFSA(Oracle Financial Services Application) and then User executes SQL ID and then report generates in Discoverer Reporting tool. In this OFSA is having Various Modules like:
1. Transfer Pricing
2. Cash Flow
3. Balance Control
4. Risk Management
In this we are working on Transfer Pricing and Balance Control and we are maintaining cash flow for deposits and advances and as per Bank requirement we are deciding on what basis we will calculate Transfer pricing for a particular module and then we are running Risk Management process but before Risk Management Process data should be loaded properly in Customized tables. In Transfer pricing we have Cash flow IDS and we are using Cash flow weighted term method for calculating cash flows.
We are Working on sql, pl/sql, Discoverer Reporting tool, Unix, OFSA(Oracle Financial Services Application) .In Pl/sql we are Creating Packages, Functions, Procedures, Collection(Type, varray Etc.), Triggers, Cursors, Using Bulk Collect Etc., for various Bank level Major Reports like: Ca23, Basic Statistical Return(BSR) Reports, Agriculture Report etc.
In this Project we are performing DBA activities(Basic Level) and in this project we are using Performance tuning for Fast Access of Discoverer reports, For fast access we are applying tuning rules and analyzing tables.
Software development for Fincraft (Core Banking System) by Nelito Systems Ltd. For various co-operative banks and in this Software we are working for various Modules like Cash, Clearing, Bills etc. and purpose of this software is to provide core banking facility to various commercial banks.
->5. Software Development in Centurion Bank of Punjab for Core Banking System with finacle scripting as Front End and in this Project we worked on Sql, Pl/sql with Finacle scripting as front End. In this Project we have also build some .com files in Shell Scripting. In this we have handled overall clearing module, cash module, bills module, maintain sweep balances for various Bank Schemes. In this Project we are creating Packages, Functions, Procedures, Cursors, Triggers, Using Collections etc.
BACK END: - ORACLE 9I, SHELL SCRIPTING.
FRONT END:- FINACLE SCRIPTING, MRT
-> Software Development in Bank of India in UNIX, Sql, Pl/Sql with Finacle scripting as Front End, Maha Report (mrt) for generating Bank reports as per Bank requirement. In this project we have also build some .com files in shell scripting. In this we have handled overall clearing module, Deposits, Advances, cash module, bills module etc.In this we are creating Packages, Procedures, Functions, Cursors, Using Collections for generating Bank reports and We are firing triggers for controlling Bank Activities as per Requirement.
BACK END: - ORACLE 9I, SHELL SCRIPTING.
FRONT END: - FINACLE SCRIPTING, MRT.
DATABASE SIZE: - 7 TERABYTES
7. Software development (ETL Process Developer) for Bank of India in sql, pl/sql, Discoverer, shell scripting with OFSA (Oracle Financial Services Application).
BACK END: - ORACLE 9I, SQL, PL/SQL, SHELL SCRIPTING.
FRONT END: - DISCOVERER.
DATABASE SIZE:- 7 TERABYTES
In this we are Automating to our ETL Process by Sql, pl/sql, OFSA but for some sources like Deposits, Advances etc. we are loading data through External table into source table and then execute ETL Process i.e. Oracle Warehouse Builder for applying Business Rules on Data. Then after applying Business Rule, Data is Available for Bank Business Related Decisions. We are creating ETL Process and we are also working on Bank major reports Using sql, pl/sql, Unix, Discoverer like Priority Sector Report, Statistical Business Report for Bank, BSR-1, 2, 3, CA23 etc.After creating report in Discoverer we are Creating SQL ID(Execution of Pl/sql Code by User) in OFSA(Oracle Financial Services Application) and then User executes SQL ID and then report generates in Discoverer Reporting tool. In this OFSA is having Various Modules like:
1. Transfer Pricing
2. Cash Flow
3. Balance Control
4. Risk Management
In this we are working on Transfer Pricing and Balance Control and we are maintaining cash flow for deposits and advances and as per Bank requirement we are deciding on what basis we will calculate Transfer pricing for a particular module and then we are running Risk Management process but before Risk Management Process data should be loaded properly in Customized tables. In Transfer pricing we have Cash flow IDS and we are using Cash flow weighted term method for calculating cash flows.
We are Working on sql, pl/sql, Discoverer Reporting tool, Unix, OFSA(Oracle Financial Services Application) .In Pl/sql we are Creating Packages, Functions, Procedures, Collection(Type, varray Etc.), Triggers, Cursors, Using Bulk Collect Etc., for various Bank level Major Reports like: Ca23, Basic Statistical Return(BSR) Reports, Agriculture Report etc.
In this Project we are performing DBA activities(Basic Level) and in this project we are using Performance tuning for Fast Access of Discoverer reports, For fast access we are applying tuning rules and analyzing tables.
First Class with Distinction in Master of Computer Application
First Class with Distinction in Bachelor of Computer Application.