DICE is an end-to-end process for the countries from sales data Integration to end user dashboards built in Qlik Sense. Sales Integrator as part of the DICE to deliver harmonized sales data considering data integrity checks, market definition rules, data transformation rules etc. All data is stored in AWS Cloud cluster.

Project : Quote Store & COINS (Compensation and Incentives)

Client    : Dell International, Hyderabad, India

Role       : Bigdata Engineer

Responsibilities:

• Having experience in writing Hive queries & Hive Scripts.
• Handled importing and exporting data to HDFS and Hive using Sqoop.
• Load and transform large sets of structured and semi structured data.
• Written Hive queries for data analysis to meet the business requirements.
• Involved in processing the data by using apache Hive from HDFS.
• Used Spark API over Cloudera Hadoop YARN to perform analytics on data in Hive.
• Configured Control-m jobs to automate the data flow.

Project : Global Channel Partner Program (Vistex Data integration)

Client    : Dell International, Hyderabad, India

Role       : Bigdata Developer

• Confidential

Responsibilities:

• Developed Spark code in Scala using Spark SQL & Data Frames for aggregation.
• Created schema in Hive with performance optimization using bucketing & partitioning.
• Experienced in working with spark eco system using Spark SQL and Scala queries on different formats like Text file, CSV file.

• Confidential -

Responsibilities:

• Worked as an individual contributor at Oracle IDC Bangalore and involved in:
• Working with an Agile, Scrum methodology to ensure delivery of high-quality work with every monthly iteration/Sprint
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Defined various facts and Dimensions in the data mart including Fact-less Facts, Aggregate and Summary facts.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.