•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.