Nasrullah D. Email & Phone Number

Project : OFSAA module PFT

- Develop SQL queries and create dashboard Report as BI process.- Use Tableau create dashboard as User requirement.- Experience in database Google Cloud Platform(GCP) and BigQuery.- Create shell script to build Data Mart support Dashboard Report.- Gathering the business requirement from Users and transform business to program specification, design Data Mart and Report.- Analyze the business needs and proposed technical solutions within Digital Media projects.- Through… Show more - Develop SQL queries and create dashboard Report as BI process.- Use Tableau create dashboard as User requirement.- Experience in database Google Cloud Platform(GCP) and BigQuery.- Create shell script to build Data Mart support Dashboard Report.- Gathering the business requirement from Users and transform business to program specification, design Data Mart and Report.- Analyze the business needs and proposed technical solutions within Digital Media projects.- Through understanding of batch jobs using Airflow. Show less

Responsipility :- Develop complex PL/SQL and SQL queries for create Oracle BI Publisher Report, data extraction transform load (ETL) and BI process.- Design and transform the data from the core system to Data warehouse,Data mart, Migrate data by Shell script call batch process and Data Stage.- Experience in database design, data integration, data pipeline development, big data (HIVE, BigSQL) and business intelligence applications.- Analyze the business needs and proposed… Show more Responsipility :- Develop complex PL/SQL and SQL queries for create Oracle BI Publisher Report, data extraction transform load (ETL) and BI process.- Design and transform the data from the core system to Data warehouse,Data mart, Migrate data by Shell script call batch process and Data Stage.- Experience in database design, data integration, data pipeline development, big data (HIVE, BigSQL) and business intelligence applications.- Analyze the business needs and proposed technical solutions within Bank projects.- Tuning SQL statements for performance, Indexing optimization and troubleshooting.- Through understanding of batch jobs using Ctrl-M.- To do program testing (Unit Test) completely before UAT, support UAT and prepare program and script for system go to production.- Identify tools and technologies to be used in the project as well as reusable objects that could be customized for the project.- Guide team in coding as per design.- Guide the developers identifying, preparing and conducting unit test cases and fixing defect based on results. Show less

Bangkok Metropolitan Area, Thailand

Project Name : Oracle e-Business Suite, Oracle Fusion.Responsibility : - Develop complex query, report and maintain computer programs by using SQL and PL/SQL for Migration and integration on Oracle Implementations Upgrade projects R11i and R12 . - Collaborate with team and related improve company productivity. - Tuning SQL statements for performance. - Document the product/functionality.… Show more Project Name : Oracle e-Business Suite, Oracle Fusion.Responsibility : - Develop complex query, report and maintain computer programs by using SQL and PL/SQL for Migration and integration on Oracle Implementations Upgrade projects R11i and R12 . - Collaborate with team and related improve company productivity. - Tuning SQL statements for performance. - Document the product/functionality. - Provide technical support to clients and other associates to help all users to track and solve their problems. - Analyst and resolve issue on production and VPN on customer site. - Assign Tasks and ensure tasks are completed on time and meet the necessary standards. - Contributes to team effort by accomplishing related results as needed. Show less

Bangkok Metropolitan Area, Thailand

Project Name : Trading Applications system (WholeSale , Retail)Responsibility : - Gathering the business requirements from Users and transform business to program specification, design database,Package,store procedure and Report. - Analyst and design J2EE Web Application using Spring , Hibernate, build prototypes and represent to users.- Coding programs either PL/SQL, Store procedure, Shell script, Batch process and IReport.- Develops and maintains applications and… Show more Project Name : Trading Applications system (WholeSale , Retail)Responsibility : - Gathering the business requirements from Users and transform business to program specification, design database,Package,store procedure and Report. - Analyst and design J2EE Web Application using Spring , Hibernate, build prototypes and represent to users.- Coding programs either PL/SQL, Store procedure, Shell script, Batch process and IReport.- Develops and maintains applications and databases by evaluating client needs; analyzing requirements; developing software systems in time and properly.- To do program testing (Unit Test), SIT (System Integrate Test) completely before UAT, support UAT and prepare program and script for system go to production.- Monitor log of Control-M job, Job Scheduler.- Create and Design Data Model and ETL (Data Stage)- Support ticket and help all users to track and solve their problems and send reports to users.- Analyst and resolve issue on production. Project Name : Channel Management System (Calculate compensation for Dealer of AIS) Responsibility :- Gathering the business requirements from users and build program specification, design database and Package and store procedure. - Create screen prototype.- Coding programs PL/SQL ,Shell script call batch process and Pro C (Tuxedo).- Create specification document(Hibernate, Service, Detail design Document)- Support Programmer, Tester and user - Analyst and resolve issue on production Show less

Kasikorn Bank Headquarter

Project Name : Automated Teller Machine (ATM) Responsibility: - Design and build CI (state and screen) for use on ATM machine.- Create ATM transaction and testing application on ATM system. - Monitor transaction's information on Base24(Tandem) system. - Coding TAL programming.

Project Name : Compensation for Dealer Responsibility :- To be a consultant of Advanced Info Service Public Company Limited (AIS) on behalf Optimus Soft.- Scope of duty is coding program by using C, Pro C and coding PL/SQL, Shell Script. - Used Oracle9i Database and Tuxedo (middleware). - Unit test programs for any error/bug before submitted to System Analyst.