Ayan C.

 Microsoft Certified python professional having over 10+ years of IT experience in software development with a strong background in Retail & Healthcare domain.  Extensively worked on analysis and analytical platform where need to help business partners in making decision over iPhone/medicine marketing and campaigning.  5+ years’ work experience in analytics, running projects from beginning to end, delivering results to senior level leaders, academy teams on tools developed.  Extensively worked on automation of regular process using python data structure ,pandas, json and flask framework.  Helped Healthcare business team to design On time refill of Drug campaign which intern increased purchase profit by 5%.  Worked on writing various Teradata Utility Scripts like Bteq, Multiload, Fastload, Fastexport , creating Unix Script to process files, developing python script to parse json files and using Tableau to create various dashboards.  Excellent hands on experience in writing various algorithm on o Teradata Utility Scripts like Bteq, Multiload, Fastload, Fastexport . o Developing python script to perform  parsing (json and xml)  Excel report automation  Pandas operation  Web application using Flask framework.  Web scrapping using BeautifulSoup & scrapy.  Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics etc.  Proficient in preparing high/low level documents like design and functional specifications.  Good understanding of data warehouse architecture, Dimensional modelling and Reporting.  Has delivered robust end-to-end solutions applying sound technical fundamentals.