Arun Bhakuni Email and Phone Number

Operating system and language:• Worked on unix operating system and windows applications.• Have good expertise to create various unix shell scripts for automation and for new job requirements.• Worked on migration of various unix servers.• Supported 3000+ unix jobs and doing enhancements.• Modified Pro*C programs to new requirements and security standards. Database:• Design and developed store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.• Worked on performance tuning and bad data framework on Oracle 11g database.• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.• Worked on database migration from 10g to 11g.• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.• Established Data Warehouse under Oracle database. Environment includes backup & recovery, partitioning, performance monitoring and capacity planning procedures.• Worked on data loading of feed files using sql loader or external tables.• Worked to create dynamic sqls.• Worked on teradata database : created triggers, indexes as data model changes.• Worked on teradata utilities like Bteq,fastload,fastexport,multiload for loading unloading of teradata tables. • Worked on creating Java based UDF for the teradata.Tools Used:• Have good expertise on Informatica (ETL tool). Developed and maintained complex Informatica mappings. Involved with moving data from flat files, including Excel files, to an Oracle Environment.• Used Informatica as Data Masking tool to mask sensitive data to be provided for non production environments.• Worked on Control-M, Toad, Informatica, WSFTP,HPSM and Serena Change Manager tools.