Satya Ch Email and Phone Number

• Importing data from relational data stores to Hadoop using Sqoop • Creating various Mapreduce jobs for performing ETL transformations on the transactional and application specific data sources. • Wrote and executed PIG scripts using Grunt shell. • Big data analysis using Pig and User defined functions (UDF). • Performed joins, group by and other operations in MapReduce by using Java and PIG. • Processed the output from PIG, Hive and formatted it before sending to the Hadoop output file. • Used HIVE definition to map the output file to tables. • Wrote map reduce/Hbase jobs • Reviewed the HDFS usage and system design for future scalability and fault-tolerance; • Worked with HBASE NOSQL database. • Experienced in analyzing Mongo DB and compare it with other open-source NoSQL databases to find which one of them better suites the current requirements. • Responsible for importing and exporting data into HDFS and Hive using Sqoop • Continuous monitoring and managing the Hadoop cluster using Cloudera Manager • Have good experience with NOSQL database • Involved in creating Hive tables, loading with data and writing hive queries, which will run internally in map, reduce way

• Involved in Migration of ArisG 4.1 to ArisG 6.3 • Involved in requirement gathering of migration, customization analysis documents. • Involved in mapping document preparation • Involved in preparation of UTCD (unit test cases document) and help the customer in execution. • Involved in unit level testing. • Involved in IQ (installation qualification) preparation. • Support the user to accept testing. • Involved in Bug Fixing. • Coded Trigger, Packages and materialized views for transferring data from one system to other system. • Coded PL-SQL packaged for migrating the data between the systems. • Code PL-SQL packaged for customization of system as per the client requirement. • Code oracle procedures and triggers for customization of product roles • Code oracle procedure distribution Rules for maintenance module. • Worked with reporting team for designing the client specific reports. • Reporting team for coding report module package for client specific changed. • Used advanced oracle concepts collections, Temporary tables and materialized views • Used Oracle query optimization techniques for data migration and customized reports

• Involved in multiples short length projects • Involved in SDLC gathering requirements from end users • Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using PL/SQL and functions and procedure for common utilities. • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL. • Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQL package. • Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables. • Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities. • Created and manipulated stored procedures, functions, packages and triggers using TOAD. Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.• Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS, and REF CURSORS. • Created materialized views using different clauses like FAST, COMPLETE, FOURCE, ON COMMIT. • Experience in using various oracle pl/sql collections VARRAYS, NESTED TABLE, ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2 • Involved in creating various utility scripts to generate log files in UNIX using shell scripts. • Involved in migrating database from Oracle 9i to 10g database. Involved in developing screens and generating reports.