Mahesh Prasad Email and Phone Number

• Lead design and development phases during implementation of technology solutions.• Developed and optimized unix shell , oracle & informatica scripts.• Conducted analysis of the scope of improvement in the existing system and provided optimum solutions.•Supported number of POC (Proof of concepts) and internal product development for new requirements and technologies.

• Developed unix shell scripts , Teradata utilities (MLOAD, BTEQ, Fast Export, Fast Load, TPT, DATAMOVER , TPUMP)• Design and Development of Informatica Mappings, Sessions, Worklets, Workflows• Gathered and understood Requirement by collaborating with clients.• Created Project related documents. (FD, TD, PP) • Awarded for driving the fresher learning program .• Participated in recruitment drives.

• Developed shell scripts to manipulate and merge source file into a single file. • Filtered /Added columns or Data to a file at UNIX level. • Analyzed the source data files to develop corresponding loading utility.• Developed Netezza (NZLOAD,EXTERNAL TABLES) and Teradata (BTEQ IMPORT ,FLOAD,MLOAD,TPT) loading utilities (adhoc and as a part of scheduled automated shell script ) • Developed Teradata and Netezza Procedures to filter/refine the data i.e. removing duplicates, populating keys etc. • Teradata BTEQ and NZSQL to spool reports (adhoc as well as scheduled)• Developed automated script to schedule tasks like Collect statistics , Purging old data in Teradata , Generate Statistics , CTAS in Netezza , Server mount space alerts , file purging in Unix.• Developed datamover scripts to move data from 1 TD server to other.• Coordinating with TD team in case of issues.• Production Implementation and Post Production Support.