• Core member of ETL(Extract, Transform and Load) and Development team using SAS based Multi-Tenant Data Warehouse System for Marketing Analytics of a US-based Fortune 50 Healthcare Distributor.
• Created Tableau dashboards for graphical visualization of the sales and market position of the Client.
• Interacted and collaborated directly with clients to understand the business requirements and developed SAS programs for creating data mart.
• Developed SAS codes to generate Net Promoter Score. This helped client to target the customers at risk.
• Developed SQL codes in Aginity workbench to classify client’s customer base by applying business logics on IMS segments and Class of trade.
• Automated the process pipeline with integrated quality checks using SAS which reduced the process run from 22 days to 10 days.
• Responsible for designing and conducting knowledge transfer sessions to new hires in the team.