Technical Lead
HCL Technologies Limited
Total years of experience :16 years, 11 Months
Citi Bank
•Working in Oracle PL/SQL development team for supporting CITI Warehouse Application - COTS (Consolidated Operational Transaction Store), Standalone applications like, PAS, GTSMIS, PAT, AML Mantas, etc. on new requirements, enhancements and bug fixing.
•Completed APAC - Indonesia Data Centre Migration and AIX-LINUX DB/APP Server migration for - PAS, GTSMIS, INDIA HISTORY along with incorporation of new business logic through IMR and AML Projects.
•Working on Platform migration activities like -Conversion, validation and deployment of Tivoli Jobs and Schedulers to Autosys with minimal impact to business.
•Migrating various db objects, app integrations with other systems from SIT to UAT and UAT to Production & COB, representing changes as necessary in Change Management. Involved in troubleshooting Application and database related issues. Prepared Instance strategy and Go-Live Plan for DBA/Unix/Middleware Team activities.
•Worked on Sync the DB, APP & configuration details from Production to UAT/PAT (PRE PROD).
•Developed Unix Shell Scripts, Tivoli - Autosys jobs & schedulers - to automate business processes and during new implementations, used PL/SQL objects, Shell scripts, jobs and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
•Involved in all phases of database development, from needs assessment to QA/QC, design and support.
•Documentation & Report preparation for all Projects, IMR and Task and preparation of KT Documents.
•Provided on-call support for production applications and Support of daily operations including job monitoring and troubleshooting of the 24x7 production. Troubleshooting various issues while performing Upgrade and Migration and documenting the same
Project: Scotia Bank (The Bank of Nova Scotia)
•Provided Support for BFSI - Capital Market - Fixed Income Module
Project: Vodafone India Pvt. Ltd., Maharashtra & Goa Circle
•Worked on ITIL Framework on Incident & Change management tool like Remedy and having exposure to Software Development Life Cycle. Worked on Knowledge transition phase for many more application from different vendor.
•Worked on Product Configurations like. PLAN, PROMO, COFU, Short codes, etc., also worked on various BSCS Applications and co-ordination with all other business support teams in order to run business smoothly and was involved in Vodafone RED plan configurations, UAT, PROD & other operational issues.
•Worked on product configurations with Central S&T Team, at circle/central with RA/UAT Teams and to make the product delivery within prescribed TAT.
•Worked towards system Migration from BSCS to AMDOCS, DISHA (HERCULES) and Involved in data clean-up activities to sync up between apps as per business/db migration requirements.
•Resolved Customer Billing Disputes of various types like VODAFONE RED / VBS / Retail - Plan wise SMS, VOICE, GPRS charging issues, RLH & IR Charging related issues, Customer/Business Awareness issues, System limitations and behavior (Plan-Bill cycle change) related issues, etc.
•Modification of PRO*C Code for adding new functionality of creating log of execution script in application for sending sms to customers.
•Maintaining DB/OS/User level compliance as per IBM-Vodafone Security Standards.
•Worked on DB Server Migration HPUX-AIX to get better performance while billing cycle execution and Involved in server patching activities, completed user UATs during migration.
•Worked on Unify UPSS/CPOS Migration, verifying data integrity with UPSS & BSCS Systems for PREPAID & POSTPAID in various aspects like services of the number, customer details including address, contract, sim, imsi details, to run migration smoothly.
•Was actively involved in coordination with various functional teams like Application Development, BILLING, S&T, ROAMING, MEDIATION, DBA, MIS Apps (ODS, BI, DWH, COGNOS), HLR/VLR/VAS and other business APPs (CRM, UPSS, CPOS, RECC, PCRF, RA, KV, DB, OSSAPPS, VSR I Reports, VSV Reports, etc.)
Project: Vodafone India Pvt. Ltd., Gujarat Circle
•Worked on Local Prepaid PPS System developed in D2K, developed and maintained new oracle forms & reports for MNP Rollout in India and Prepaid Blackberry charging validation process to control subscriber service charging to RIM.
•Achieved DB & SQL Performance Monitoring of database and SQL tuning to improve performance of db during month-end. Implemented of table partitioning for better sql execution and data management.
•PRO*C Code changes done for MTR/CDR loading which extracts data as required for in local circle database for adding four new balances as required by Marketing/IN Team to insert prepaid GPRS 3G MOC/MTC/RCF CDR loading process which it extracts and transforms the data in local circle database from data provided by IN CONVERSE/Central Teams.
•Automating day to day activities by developing in house utilities to automate batch exports in UNIX & Windows. This includes checking whether all databases are running, listener is running, Unix error messages, disk space availability, checking for errors in alert logs and trace files, etc.,
•Developed CFUDD (Create First call Unbar Document Decrement) process to gain control over distributors to identify the valuable customers for Vodafone. Participated in development of MPOWER, to facilitate distributors to gain daily activities via SMS to get better sales and also worked on MIS Reporting
Project: MBUSY/MBOSS/Prime site/POAPL System
•PL/SQL coding done for MBUSY System (Corporate Budgeting system), to plan/share the resources of the company, to prepare the budgeting values for business by generating quarterly - half yearly data for billings and revenue estimation and actual values.
•Worked on POAPL & Prime site system (digital & paper adverting system), for estimation, billing, contracting, allocation of quantity, Performa generation, for various kinds of advertisements.
•Integrated MBOSS System (Business Operating and Support System), with advanced functionalities, for smooth running of business operations. A roof for all functions of accounting & advertising, including- receipts, payments, sales, purchase, TDS, service tax, Income tax for business sections like TV, Radio, Press, Paper, Digital Media, Shooting, Hoarding, Film Banners, etc. with global brands like Prime site, POAPL, DDB Mudra, Ignite, Reliance ADAG, etc.
•Worked on db & sql tuning, monitoring table spaces, monitoring users, db shut down and startup, etc. and worked on load balancing servers while working on server, while performing Testing of the system and helping QA team in various aspects while testing of application. Also, Involved in low level designing.
-