Richard Chandra Email and Phone Number

-Lead and manage the development team in the Data Warehouse area, both related to projects or Business As Usual/Enhancement requests-Supervise all incoming CR to the team-Provide direction, guidance in technical matters to the team regarding visualization and data ingestionMaintain trust index (Dashboard)-Analyze requirement from user such as : Datamart, OLAP, Dashboard, Reporting files using SFTP-Ensuring standard data development goes well-Review code has been develop by Data Engineer-Create dashboard performance for KPI & progress for status development-Tuning performance for existing Job / Script running slowly-Give insight to users that want to create report before submit CR

- Develop & preparing data based on business requirement- Develop ETL for load & transformation data using SSIS / Talend / DataWorks- Migration data from onprem to bigdata- Creating Graph Analytic using Elasticsearch- Development data using NoSQL (GCP/Alicloud/PostgreSQL)

-Creating & maintaining data warehouse from data source-Creating & maintaining ETL for data warehouse-Creating & enhancing script for development data warehouse-Creating visualization report using BI Tools

- Analyze customer data using database Oracle, MySQL, SQL_Server - Creating dashboard using Tableau- Develop tools for reporting with SSRS, Excel, Tableau, Table View- Creating job data transformation (ETL) using Pentaho - Creating automatic report on Telegram- Processing end to end report- Cleanup data from any resource- Create scheduler job for automatic report

Working to help business creating documents for client request. Analyze big data needed to improve the quality of business. Providing solutions from analysis results. Having good analytical, mathematical skill and expert in excel. Duties : Analyzing big data to increase sales.Presenting analyze result in excel with pivot method.Provide solutions to problem found.Support the development of marketing strategy for fueling business growth using data-driven approach.

Creating process ETL with multiple database to improve time to processing data.Duties : Research & develop requirement of a project.Understanding flow of a project from input to output. Using ETL/SSIS for creating output in the form of reports and Data transfer.Creating business model for user requirement.Testing & Review output of a project. Training other programmer after new research is done.

Collecting, collating and carrying out complex data analysis in support of management & customer requests. Also involved in reporting statistical findings to work colleagues and senior managers. Duties : Manipulating, cleansing & processing data using Excel, Access and SQL. Responsible for loading, extracting and validation of client data. Liaising with end-users and 3rd party suppliers. Analyzing raw data, drawing conclusions & developing recommendations Writing SQL Server scripts to manipulate data for data loads and extracts. Developing data analytical databases from complex financial source data. Performing daily system checks. Data entry, data auditing, creating data reports & monitoring all data for accuracy. Designing, developing and implementing new functionality. Advising on the suitability of methodologies and suggesting improvements. Carrying out specified data processing and statistical techniques. Supplying qualitative and quantitative data to colleagues & clients.