Around 20+ years of professional experience in business application software design, development, Integration, testing and maintenance. Expertise in COBOL, DB2, CICS, JCL, VSAM, RACF and TERADATA SQL and utilities and targeting for TERADATA certifications. Exposure in creating databases, tables, macros, views, stored procedure, joins, concepts of TASM Rules. Worked with Teradata utilities like TPUMP, BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files. Hands on experience using query tools like IBM SQL Developer, Teradata SQL Assistant and Query man. Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace in Teradata. Well versed with all stages of Software Development Life Cycle (SDLC) i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing. Very good in fast learning, Analytical thinking, decision making and problem solving skills with Strong Technical Skills. Involved in review meetings with Project Managers, Onsite/Offshore Teams and Business Associates. Expertise in SPUFI, QMF, and FILEAID as testing tools and for data manipulation and Data cleansing. Proficient in IBM utilities and Tools like XPEDITER, ENDEAVOR, CHANGEMAN, CA-INTERTEST, ABEND-AID, PANVALET, SYNC SORT, FILEAID FOR DB2, STARTOOL FOR DB2. Expertise in Production Support Environment approaches & procedures and Ability to quickly resolve the ongoing issues, troubleshoot the problems, decision making and problem solving skills. Good Communication, Presentation and Interpersonal skills with excellent problem solving capabilities Supported/maintenance of several applications in handling of user requests, system enhancements, front-end and back-end interface modifications and production installation.
-
CognizantUnited States -
Mainframe Application Db2 /Prod AnalystCognizant Oct 2014 - PresentTeaneck, New Jersey, UsRole 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. -
Service Delivery ManagerCognizant Mar 2021 - Sep 2024Teaneck, New Jersey, Us -
Mainframe LeadMphasis May 2011 - Oct 2014Bangalore, Karnataka, In -
Dw - Mainframe & Teradata - Production Support AnalystBank Of America May 2009 - Apr 2011Charlotte, Nc, Us• 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. -
Senior Software EngineerNess Technologies 2006 - 2008New York, Ny, Us
Vishnu K Education Details
-
Adichunchunagiri Institute TechnologyElectronics And Communications Engineering
Frequently Asked Questions about Vishnu K
What company does Vishnu K work for?
Vishnu K works for Cognizant
What is Vishnu K's role at the current company?
Vishnu K's current role is Teradata Analyst.
What schools did Vishnu K attend?
Vishnu K attended Adichunchunagiri Institute Technology.
Who are Vishnu K's colleagues?
Vishnu K's colleagues are Karthik Jayachandran, Aniket Singh, Sampath Kumar Bandari, Priyanka Darade, Aditi Das, Ambady Menon, Ramesh Babu.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial