Chennai, Tamil Nadu, India
Data Architecture
• Define, Design, and implement database solutions to manage business critical applications of HP’s esteemed clients.
• Working at present with Universal Music group working on the Rights and Repertoire application that is used to pass in songs metadata for all saleable assets in the company
• Designed Data architecture, performance improvement and Production database management and maintenance solutions for business critical application databases like Global Warranty Analysis and Review Part, Production Volumes Data Mart, IMDS, Negotiation Tracking System, Job Number Database, Emission & Fuel Economy Compliance System, Model Option Rates used in General Motors to run business.
• Identify solution/process improvement to improve productivity
• Database Tuning, Database redesign to improve performance by Bitmap indexing, Database Partitioning and other techniques, PL/SQL programming to meet new requirements
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.