Reza Roghanizadeh

Experience

• 

  Razi Vaccine & Serum Research Institute

  Mar 2006 - Dec 2006

  Software Programmer

  The Razi Vaccine & Serum Research Institute is an Iranian pharmaceutical and biological institute• Analysis modeling with RUP methodology for laboratory processes• Database Design & Development using SQL Server2000• Software Development for implementing laboratory automation with C#. Net 2003• Technologies: MS SQL Server, C#.NET, SSRS, Rational Rose

• 

  Maskan Bank

  May 2007 - Mar 2009

  Software Programmer

  • Cooperation in the design of the comprehensive statistical system of Maskan Bank• Oracle Database Maintenance• Database Design and Development with Oracle10g and SQL Navigator • Software Development using C#. Net 2005• Designing and Developing Reports with SQL Server Reporting Service• Technologies: MS SQL Server, ASP.NET, C#.Net, Oracle 10g, SQL Navigator, SSRS

• 

  بانک ملی ایران | Bank Melli Iran

  Nov 2008 - Mar 2009

  Bank Clerk

  Bank Clerk

• 

  Railway of Iran

  Apr 2009 - now

  Senior Software Database Developer

  The railway company focuses on transporting goods (freight) and individuals (passengers) by railcars.I am Working in the railway data mining and intelligence office• Designing a rail transport management system for increasing the efficiency of rail freight transport• Structured modeling of railway statistical items for data engineering and data warehouse design• design management dashboards and analytical reports for the railway business using BI tools • Create Tables, triggers with SQL, Implement Stored Procedures, Functions, Views, Data Integrity in rail databases• Experience in Normalization and Relational Database Management systems• Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting Databases in IT office of Railway company• Writing complex queries Involving Multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions• Performance Tuning and Query Optimization• Using ETL Tools and developing packages in DTS• Designing Analytic Database with Building Dimensions and cubes with star schema and other models for OLAP in railway• Create many Drill through, Drill Down and parametric reports using Reporting Services• Using Index tuning wizard, SQL Profiler and Query Execution Plan for monitoring and tuning Performance• Developing PowerBI dashboard reports and using DAX features for the key performance indicator• Designing and Developing data visualization using PowerBI and Python Matplotlib• Data Analysis and Data Visualization with Python• Technologies: BI Tools (SSIS, SSAS, SSRS) , MS SQL Server , T-SQL , Query Optimization , Power BI , DAX , ETL , Docker , High Availability , Table in-memory , Python (Pandas, NumPy , Matplotlib , SciKit-learn , SciPy , ...) Show less