UnitedHealth GroupAssociate Architect
Feb. 2014 - Jan. 2016Gurgaon, IndiaWorking as EDW Data Architect on the following aspects:
• Data modelling for EDW.
• Study Industry specific data model from Oracle and Teradata and recommend implementation accordingly.
• Write and Review Data Initialization Scripts
• Data Cleansing and De-duping activities.
• Data Profiling.
• Data Extraction using ETL.
• To develop new Data Models by analyzing new requirements, Use cases and Business Domain Models.
• To finalize deployment strategies.
• Analysis of Execution Plans and fine tuning Stored Procedures for performance Improvements.
• Setting up new acquisition channel from different sources.
• Building transformation rules for common format layers.
• Evaluating different options in Big Data Area under Hadoop platform.
• Building prototypes for future projects Complex Event Processing (CEP) using STORM and KAFKA to process Real time streaming data. All these implementations were done in Java.
• Big Data Implementations using HDFS, HIVE, MAP REDUCE, FLUME, KAFKA.
• Participate in Data Governance calls to establish MDM framework for need of the organization. Provide necessary feedback on data pain points and interface with business to get sign off on critical data monitoring activities.