• Supporting investigations related to anti-money laundering and other compliance issues by developing data analytics based solutions and data products.

1. Developed a data product for TV Analytics incorporating profitability models for TV Channels and Content Providers. Designed the dashboard to provide actionable insights.2. Provided analysis on Mobile Network statistics. Applied clustering algorithms to find out high, medium, low usage areas3. Worked on customer segmentation to identify usage patterns of customers which help to develop new mobile tariff plans4. Anomaly detection to identify anomalous waiver requests5. Migrating datamarts and databases to AWS

1. Involve with various teams like Finance, Marketing, Supply Chain teams within the organization to support their business analytics activities.2. Performing text mining and finding useful insights by applying topic extraction, topic modelling, sentiment analysis, n-gram tokenization NLP methodologies.3. Text mining/NLP on financial reports.4. Finding patterns and trends within data and present them to business users in the forms of reports and dashboards.5. Perform social media analytics to support activities of marketing team.

1. Design, develop and deliver end-to-end Business Intelligence (BI) projects from data extraction layer to presentation dashboard and reports.2. Extract, Transform and Load data (ETL) as per the project requirements.3. Was solely responsible for creating and enhancing the datawarehouse of one of the agencies of Singapore Government. The datawarehouse was built on the top of one of the web application. The main task was to data analysis, to the data modelling and then load the data into datawarehouse. Then use this data to create reports and dashboards and present them to users. Was heavily involved in consulting with users.4. Another project with the same agency. The project was to build a datawarehouse which would consume data from various agencies and help users to forecast certain cases. The main tasks were to consolidate data from various agencies and then perform primary data analysis. The other part was to build a data model and apply perfect schema to support the datawarehouse. 5. Responsible for making decisions specific to project tasks.6. ETL and Reports development and automation.

Involved in the team of analysts who are building a bench-marking solution for clients based on Net Promoter Score (NPS) and other components.Roles and Responsibilities:1) Extraction of social media data using R and Python scripts.2) Preliminary data analysis.3) Data cleaning and data transformation.4) Data preparation in order to apply text mining techniques.5) Text mining techniques like Sentiment Analysis, WordCloud, Concept Extraction and Categorization,Topic Modelling6) Creation of dashboardTools: R, Python, Tableau, Qlikview

While working with Nitor, I was dealing with Microsoft BI Suite and was mainly working on SSIS and SSAS. Also done reporting with SSRS upto some extent. Have worked on the designing on dimensional model and requirement analysis. Also, involved in the creation of the data warehouse using ETL tools. Also designed OLAP cubes using SSAS which would be later used in the creation of reports and dashboards.

Dimensional Modelling and Audit Process:Was involved in designing a dimensional model using the concepts on slowly changing dimensions. Also designed an audit process which could verify whether same data would get passed from the source system to the final database which was used to generate different reports. Data Migration:Designed a process to get excel sheet data in SQL Server.Data Cleansing was done on SQL Server data. Then designed a SSIS process to load the data in SugarCRM database i.e. MySQL Database.

Dealing with MSSQLServer Analysis, Reporting as well as Integration services. Generated OLAP cubes using SSAS and reports using SSRS.