Himadri Majee

Senior Data Analyst

Tentacle SSO SDN Bhd•  August 2023 - Present•  Malaysia

Develop, debug, maintenance, UAT of engagement related data mart. Test ETL loaded data to be used in reporting. Development and UAT of Monthly report. Liaise with LOBs to strategize upcoming engagement. Monitor and performance analysis of campaign engagements using Power Bi. Maintain and innovate a robust framework for effective client engagement data management. Liaising with IT and analytics divisions on campaign performance data and reporting. Leads and campaign response data exploration using Python to facilitate propensity scoring.

Senior SAS Consultant

Accionlabs Technologies•  November 2021 - May 2023•  Malaysia

Develop, debug, maintenance and monitor of T-1 datamarts and batch jobs to update them. Maintenance and automating reports like MIS. Data migration from Oracle to SAS to Postgres cloud. Data cleansing and transformation for ingestion from data lake to SQL database using Azure data bricks SQL notebook. Development of recurring report and automate to schedule it via Control -M. Liaise, negotiate and coordinate with business users to customise and amend report as per the request. Analyze business requirements to perform feasibility studies / gap analysis / functional / technical design in the areas of data profiling, cleansing and transformation. Design / Document / Implement / Test / Deploy solutions to meet the business needs. Build appropriate SAS programs to create SAS datasets from various data marts, external data sources and other data sources based on business requirements. Reconstructing and managing specific data marts requirements and customer data mapping from business perspective. Strategically planning for migratory / scalable data warehouse roadmap for future. Exploratory data analysis and testing using Python and SQL.

SAS Consultant

Apar Technologies SDN BHD•  December 2019 - November 2021•  Malaysia

Requirement gathering: Liaising with Business unit from Decision Management to gather requirement for any Adhoc based/periodical/repeated campaigns. Automation of repeated or periodical campaign to reduce man hours. Data Extraction and manipulation production data according to the request form (LRF). SAS Scripting to retrieve vendor compatible communication base files for different channels of communication such as SMS/EDM/Messenger/Banners/FB and google via DMP. Internal team review for campaigns built by associates as a process of SOP. Tracking of campaign performance and report building for Business unit to interpret the success parameters. Fulfilment: Extraction of campaign acquired customers eligible for fulfilment in accordance with fulfilment LRF. Strategy consultation based on the campaign outcome liaising stakeholders and product owners.

Data Analyst

BancaSella S.P.A•  May 2018 - November 2019•  Malaysia

Data extraction: Adhoc basis data extraction from relevant database tables and create update and validate lead. CRM Loading for campaigns for CanaliDiretti (Directed Channels of marketing) SQL scripting and production release using smart SVN and MIP tools. Introduction of documentation in confluence. Scrum call and Incident management via Jira.

Associate

Cognizant•  March 2016 - April 2018•  Malaysia

Mobile Feedback: Text-mine sensitive words from survey responses and draw reports to Market Research Surveys for compliance purposes from mobile and web app. Analyse web traffic for different Line of Business-like Brokerage using Adobe Omniture (Adobe Analytics) Welcome Kit reconciliation: To audit and reconcile the Welcome Kits. Web traffic reporting. Design data marts for various matrices and customer information using SAS EG and IBM DB2. Maintaining Long matrices for different campaign related tools, and maintaining their monthly performances and cohort data. MTD pacing or forecast, weekly and monthly by linear extrapolation method. Maintaining cash enrolment and fulfilment databases and updating them.

Programmer Analyst

Cognizant•  March 2014 - March 2016•  Malaysia

Campaign designing and reporting - Develop campaign based on the RF provided by the clients on weekly, monthly repetitive and adhoc basis on IBM DB2 in TOAD editor. Creation and maintenance of LOBs for easy access and time management. Automation of repeated campaigns by scheduling in UNICA. Upgrade of LOB for further criteria enhancements introduced by clients. Internal tasks of consolidation of job monitoring of fellow associates including clients and onsite counter parts.

Programmer Analyst Trainee

Cognizant•  January 2014 - May 2014•  Malaysia

Migrate Dashboard and employee details Monitoring of migrated details using OBIEE. Delivering Analysis based on client requests