Role of Technical Lead/SME for Application customer Information systems & Deposit batch cycles.• Monitoring of Application Cycles, provide solutions for Job Abends and provide technical direction the Offshore & Onshore Team.• Writing the Test cases, Review, Execute and Defect Tracking in HP service desk/Service now.• Preparation of Status report and Updates to the Client and onshore counterparts.• Writing the complex SQL queries with joins in DB2/SQL to provide the data as per requirements from PROD to Test regions.• Coordinate with Business Analyst and Development team to prepare technical analysis and project time-line estimates.• Perform Loads/Unloads to prepare the environment ready for Pre-Production Batch cycle in QA environment using PROD data.

• Responsible for scheduling of jobs & Monitoring of Jobs and re running if gets abortedand completion of Application Daily batch cycles (24/7 support).• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.• Created BTEQ scripts to transform data and Fastexport scripts to export data• Tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL andViews based on user and/or reporting requirements.• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.• Informing stakeholders for any outage observed & assure them to give a speedy resolution for the same also updating status of progress of restoration work.• Experience of PROD Application support during the HARDWARE Upgrade/Software Upgrade.• Experienced in RELOAD of application in the event daily cycles are been delayed due to business delay or application cycle delay.• Good Expertise on Teradata Manager, TDWM, PMON, SQL assistant and BTEQ and Can do Performance tuning, optimize complex SQL queries with Minimal guidance.• Developed MLOAD scripts to load data from Load Ready Files to Teradata Data Warehouse.• Periodic review meetings with the business team & Offshore/Onshore team to explain showstoppers & discuss all possibilities & approach to overcome the issues with periodic status updates.• Creating application flow Visio Diagrams and make the offshore team understand the process and plan for Coding & Testing and review of the code as per Business requirement.• Working on the supportability & Improvement of the existing system as part of ongoing process to reduce the production incidents to improve the performance of Application/system.• Able to handle ETL tools such as Ab Initio, Informatica to load data to Teradata and extract data from Teradata with Minimal Guidance.