Firman Ardiansyah

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