Amirhosein Mahdiani

Experience

• 

  Zharfpouyan

  Mar 1391 - Mar 1393

  Technical Expert

  Zharfpouyan Engineering Research Company has started its activity since 2003, with the aim of becoming a leading company in the field of information and communication technology and helping to protect the country's information assets.The most important achievement of this company at present is the production of native and secure network routers in different categories, which has been exploited as the first secure native router in the country's network infrastructure.• Worked as a technical expert to test and configuration of Cisco Routers نمایش موارد کمتر

• 

  Rahnegar Gostar

  May 1395 - May 1396

  Oracle PL/SQL Developer

  • Created and maintained Oracle database objects like tables, views, materialized views, indexes, constraints, sequence, synonyms and database link using SQL.• Designed and Developed database application using PL/SQL, Oracle Forms and Oracle Reports.• Build and Support internal solutions while conducting systems analysis, design, coding, testing and troubleshooting of new and existing applications .• Worked with other developers and business users to provide complete solutions.• Wrote complex SQL using joins, sub¬-queries and correlated sub¬-queries. نمایش موارد کمتر

• 

  East Golden Systems

  Aug 1398 - now

  Oracle PL/SQL Developer

  • Developed Custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.• Developed Stored Procedures, Functions, Packages ,Views, Triggers, Tables, Constraints and SQL Scripts using PL/SQL.• Collaborated in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.• Added JavaScript functionality to existing application pages and where possible using dynamic actions in APEX.• Worked with business customers, developers and Oracle Support to research, document and resolve Oracle system issues.• Created indexes which led to faster retrieval of data that enhanced the database’s overall performanced by 45%.• Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.• Used SQL Loader to load data from various sources into an Oracle database. نمایش موارد کمتر