Sopheap Tep

• Budgeting plan for data warehouse project and release proposal to seek for the approval from senior management.
• Lead on agreement with vendor to obtain proper Tools for Data warehouse
• Work with IT and vendors to achieve data platform purpose for Prince bank.
• Propose various technologies including DBMS, EPM, ETL, and virtualization tools in the initial stage as a team's strategy
• Explore the data analysis for data report generation and feature development
• Coordinate with relevant team to obtain thorough requirements for bank wide report
• Develop insights to Improve the bank's capacity with advance analytics
• Planning for migration existing report from BI report to Power BI report server
• Handle as a project owner to propose the enhancement on Account Opening system
• Forming the project team and release business requirement for Flexi system
• Regularly Monitor project's progress to ensure project on track and on schedule
• Resolve project issues by suggesting practical solutions to project team
• Used critical thinking to break down problems, evaluate solutions and make decisions.

• Lead MIS team for In-House development
• Improve and enhance Loan Originate System
• Set up support team to handle complaint raise by branch and sale team about LOS
• Study and propose solution for new loan process flow.
• Design and Lead on setting up data integration system(ETL) for SBILH bank.
• Lead team to gathering new requirement and write a proposal accordingly.
• Liaise with vary team to get data glossary for data governance.
• Lead team to design mobile banking and ATM process flow for digital project
• Lead team to upgrade API Fund transfer application by Applying new LHPP API aggregator.
• Manage and implement NBC report for SBILH bank.
• Lead various projects from early stage of studying to implementation stage for such as Queue system, CRM and Avaya project.
• Handle as a Project manager to implement AML/CFT project
• Build a good relationship with Vendors as well as internal team in company
• Form the project team and execute the project plan.

• Work with French team for technical design, development, testing and delivery for BI solutions.
• Support South Africa project by generating daily report to measure the ETL performance.
• Conducts on analyses of functional business processes and functional requirements
• Lead and direct execute RUCIS project for Business logic and Informatica part.
• Team member that respond for ETL part for new Danone project in Russia
• Lead team to design ETL and PostgreSQL procedure as well as trigger for Hout traco project.
• Lead and execute Scamor Project to replace current excel report to Jedox EPM tool.
• Conduct a research on Snowflake, which is cloud database

§ Business analyst

• Business Support and conduct a Technical feasibility study.
• Implement MIS policies to ensure that data is keep in secure place and accuracy.
• Support finance team on business impact report and analyst on effectiveness of marketing campaigns.
• Generate historical data to support business team for making a better decision.
• Extract data from vary source for churn prediction and sale analyst report
• Lead team to collect and gathering user requirement for system development.
• Support business user to ensure that project is meet requirement.
• Generate sale commission.

§ Data warehouse/BI

• Gathering requirement of ETL and staging design.
• Conduct on Data model design for data warehouse.
• Lead team to design ETL process as well as BI report
• Lead team to create Data glossary/dictionary for reporting.
• Support on Ad Hoc and daily basis reports.
• Advice team to measure workload of ETL system and source control.
• Proposes for reporting solution.

§ Management /Project Management

• Prepares detail project plans, schedule, budget and work distribution structure.
• Manage project schedule and regularly check on project progression.
• Supervise and motivate MIS team to improve team performance.
• Implement new technology and solutions to improve company productivity.
• Coordinate with all key stakeholders to ensure that projects are on time delivery.
• Raise some ideas and solution for specific projects.
• Develop CDR decode tools by using Asn.1 library to replace Huawei mediation.

• Perform source data analysis.
• Estimate workload, technical design, build and test ETL system.
• Develops and implements BI tool and application for data analyst.
• Install and upgrade the Oracle database server and application.
• Conduct a database architecture design for Profiling database.
• Installed, configured, created database SQL server, Oracle, MySQL.
• Monitoring all files that transfer from Billing system and Network switching to DW by making sure that there are no any files were missing.
• Maintain and enhance MIS Reporting system.
• Applied Text processing like Awk, seed to clean up and get expectation data from input files.

• Translate business requirement to technical features.
• Analyst technical specification and applied work break down technique for projects task
• Develop the applications and delivery in a time frame manner.
• Conduct functional and non-functional testing.
• Managing MIS databases and making sure all MIS reporting system were working smoot.
• Conduct a Mock up interface to design UI and UX.
• Support SUN system, which is a Mobitel financial system.
• Support MyHR system which is an HR system developed by MIS.
• Design the database architecture for application in various database like oracle, MySQL, Sql server, PostgreSQL, DB2 and Informix.

• Hand on development of Billing system for ISP as team member.
• Responsible for Developing POS system.
• Configuring and install VoIP-PBX system.
• Configure and deploy hotspot system for customer such as hotel.
• Set and configure Email server
• Set policy to control data usage for whole BRC group.