Now you can Instantly Chat with Pavan Kumar!
About Me
Over 7 years of Total IT professional experience includes requirements gathering, data analysis, design, development, testing various modules, deployments and documentation. Hands on experience in various big data application phases like data ingesti...
Show MoreSkills
Portfolio Projects
Description
This project is about migration project for reporting in Tableau. All the data from different sources will be placed in Data Lake (HDFS). From this HDFS folder, transformations will be done and loaded finally into hive target tables. This will be input to Tableau for reporting.
Show More Show LessDescription
CMP Finance is about the daily credit and debit transaction balances validation of all the customers. It has various business rules to validate daily transactions to check whether all the transaction are done correct on daily and monthly basis. Some data is stored in Amazon S3, Amazon RedShift and used by other teams.
Show More Show LessDescription
Decommissioning the mainframes application running in PL/1 to Datastage and DB2 to Teradata. Reports are extracted as fixed width delimited files from Teradata. Building screens in Excel and python with Teradata as database for user interface. Generating alerts via mails. Archiving and purging of backup files in the windows server. UNIX scripts for the files transfer.
Show More Show Less