Firman Ardiansyah

Firman Ardiansyah

Followers of Firman Ardiansyah422 followers
location of Firman ArdiansyahBandung, West Java, Indonesia

Connect with Firman Ardiansyah to Send Message

Connect

Connect with Firman Ardiansyah to Send Message

Connect
  • Timeline

  • About me

    Senior Data Engineer di PT Smartfren Telecom Tbk

  • Education

    • Institut Teknologi Telkom

      2012 - 2016
      Bachelor’s Degree Electrical and Electronics Engineering S1

      Lulusan 2016 Telkom University

    • Institut Teknologi Telkom

      2012 - 2016
      Bachelor of Engineering (B.Eng.) Electrical Engineering Technologies/Technicians
  • Experience

    • Telkom University

      May 2014 - Aug 2016
      • Robotics Engineer

        Jan 2014 - Aug 2016
      • Assistant of Electrical Measurement

        May 2014 - Jun 2014
    • PT.Pertamina (Persero)

      Jul 2014 - Aug 2014
      Internship
    • Improva Data Media

      Jul 2015 - Aug 2015
      Internship
    • Tech Mahindra

      Oct 2016 - Sept 2018
      Software Engineer

      1. To Monitor the daily load process of MIS angie, Data-Warehouse and ReportDB and resolve any issues as per the Standard Operational Procedure. 2. Debug Issues by analysing the SQL queries and BO Reports and thereby resolve the errors.3. Create vital Project Documents for DataStage version 11.3 Upgrade and BusinessObject version 4.2 Upgrade.4. Add partition for MIS angie, Data warehouse and ReportDB at beginning of every month incase of job failure due to absence of partition.Tools :Programming SQLETLGreenPlumOracle 11gIBM WebSphere DataStageBusiness ObjectsBusiness IntelligenceUnixPgAdmin IIIToadPutty Show less

    • PT Kamoro Maxima Integra

      Sept 2018 - Sept 2019
      SQL Developer

      Work On Reporting Departments. Manage System of Data Warehousebased on project with PT. SMARTFREN Tbk.create a new report base on request user.Analisyst data and report.Create work flow in ETL infomatica.optimize the query on report and Flow.Meeting with REVA team for discuss the new report and requirement..Configuration New product.Modify Report.Migration Report From old DB (oracle) to New DB (green Plum)

    • Tech Mahindra

      Sept 2019 - Nov 2021
      Software Engineer

      Work On MIS Operation Departments. Manage System of DataWarehouse based on project with PT. H3I or 3 INDONESIA.my job desks:Developing SQL Query for reporting and analysisDesigned and Developed ETL DataStage for user requirementCreate BO reports for Daily, weekly, and MonthlyCreated UNIX shell scripts to run and controlling the ETL DataStage flowConfiguration new product parameter for reportingCreate new data visualization from a raw data based on client requirementDebug Issues by analysing the SQL queries and BO Reports and thereby resolve the errorsMonitor Data Warehouse load (ETL Monitoring)Monitor Daily, weekly, and Monthly ReportsFix issue of ETL loadResolve user request like reload report, Rerun old reports, and etc using IBM Datastage, SAP Bussiness Object or pgAdmin(postgree SQL)Resolved issues reported as Trouble Ticket and Service Request Show less

    • PT Smartfren Telecom Tbk

      Nov 2021 - now
      Senior Data Engineer
  • Licenses & Certifications