PERSONAL INFORMATION
Ali Elmi
Second Floor – No.16, Vezvaee St, Motahari Ave., 156******* Tehran (Iran)
acqtg6@r.postjobfree.com
Computer skills
Languages:
C, C++, C#, VB, Java,.NET, HTML, CSS, Delphi
Databases:
SQL Server, MySQL, Oracle, Access, FoxPro, BDE
Design:
UML (Work with Rational Rose and relevant software)
Source Control:
SVN (and its plugin in .NET and Delphi)
Report Builder:
FastReport, Stimulsoft, Report Builder
Web:
WCF, Web service, ASP.NET, Wordpress
Operating System:
Windows, Linux, DOS, Android, Win CE, Symbian
Job-related skills
Scrum – Agile - BPMS
Professional DB skills
-Advanced knowledge of T-SQL and SQL Server
- Performance Tuning
-Monitor database performance
-SQL Server Reporting Services
-SSIS
-Build all maintenance jobs
-Capacity Planning of database
-Ability to analyse, design and develop complex queries and data transformations
-Ability to train and lead junior developers and DBAs to ensure successful completion of development projects
-CLR Programming
-Converting DBs Including FoxPro, Access, MySQL, MS-SQL to each other
WORK EXPERIENCE
2013 – Present
Team Leader
Pendar Pajouh Electronics - [Software Development Company]
Pendar Pajouh is a Telecom company which works on software projects on telecom area like HotBilling, CRM and HelpDesk. I was Team leader and senior developer of Billing.
• Leading programmers and database developers, communicating with customers.
• Assessment of client needs and requirements.
• Analysing software requirements and designing required algorithms and solutions for developing applications.
• Organized training workshops to improve the performance of the members
• Determined the duties and responsibilities of individuals in a team.
• Analyse and resolve technical and application problems.
• Design and development of databases with use of MS SQL Server.
• Composing required software documents
• Using and configuring SVN software as source control solution
• Testing and debugging of the developed software
• Deploying and presenting the produced software to the customers also teaching them instructions of programs.
Projects Description:
• Billing: developed for the purpose of maintaining financial information of clients of telecommunication, calculation and issuance of invoices.
Technologies: C# .Net 4, WPF, SQL Server 2012, EF, WCF
2011 – Present
SQL SERVER DBA/Consultant (part time) / Developer
Royan Institute, Tehran (Iran)
Royan Institute is a public non-governmental non-profitable organization. It is research institute for Reproductive Biomedicine and infertility treatments. Now this institute acts as leader of Stem Cell research and also one of the best clinics for infertility treatment.
I was responsible to fix the DB, figure out the structure and maintain a SQL Server DB (source code was not available)
Tuning DB- Performance Testing
Design and develop Medical Record Management System
Technologies: C#, SQL Server
2011 – 2013
Developer & Analyser
Pegahe Aftab - [Software Development Company]
• Develop, analyse and debug following subsystem
Roll call, Personnel System, PM, Asset, SCADA
• Develop an application for devices using windows CE in order to collect data and import it to SCADA windows application
Technologies: Delphi 7, Delphi XE3, C#.Net, SQL Server 2008
2010 – 2011
Project Manager
Rashen System Aria - [Software Development Company]
• Setting up a new source control and change from TFS to Subversion(TortoiseSVN)
• Develop a customized FastReport to create runtime report in our applications.
• Prepare UML diagrams
• Leading programmers
• Analyse and resolve technical and application problems
• Analyse Preventive Maintenance (PM) and freezing systems.
• Fully develop and implementation of freezing system.
• Develop a program to Encrypt / Decrypt almost every objects of SQL Server database.
Technologies: VB.NET, SQL Server
2009 – 2012
Faculty member (part time)
Azad University Shahre Rey Branch, Tehran (Iran)
I used to teach Operating System, Database, Technical English, Visual Basic and C++
2009 – 2010
Developer & Analyzer
RAJA (Iran Railway Co)
A professional team including me analyse and develop a Schedule & Train Tour Tickets Booking program for Iran Railway Co. All clients in each province connect to this program and purchase ticket simultaneously. Iran Railway co as a national program of reserve and buy ticket via this application.
My main responsibility was to tune queries, database and also improve application to perform correct and fast. I have developed a programs (by using threads) to simulate real situations.
More than 2,000 concurrent in a race condition situation use DB.
Responsibilities:
• Reorganize the structure of MySQL DB
• Implement web service with C#.net and consuming via Delphi
• Configure IIS, web service and develop sample program to reach the highest performance.
• Tune and speed up application. Major parts including ‘scheduling module’ have improved running 20 times faster.
Technologies: Delphi, MySQL(on Linux), C#, IIS
2004 – 2006
Software Developer
BETAJA [Military Service]
I have received a standing order due in part to my qualification. So I spent 20 month of mandatory military service in BETAJA.
• Work with payroll system. Add some modules to it. Improve performance and tune MS-SQL DB.
• Design and analyse Personnel System, develop initial modules.
• Co-operate in a team to manage software solutions.
• Design and develop soldiers patrol schedule
Technologies: Delphi, SQL Server
2002 – 2004
Software Developer / Senior Programmer
Tarh Pardazane Azarakhsh - [Software Development Company]
(Continue to work after Post-Graduation) 2008-2009
As a System Analyst I involved in analysing the requirements of customer by visiting their place and prepared the requirement specification in detail. My communication skill was excellent which helped in presenting and communicating my views in precise and clear way to client and hence could get satisfied customers for the organization. I also analysed the technical requirements and details required for developing the system and proposed solutions for implementing the same.
As an Application Developer managed group of programmers and we developed Roll Call System, Library System, Personnel Evaluate System, and Dynamic Form Builder.
In addition, a converter tools in order to convert FoxPro, localized Txt in DOS and Access format, has developed by me to import data into SQL Server .
I need to mention that, some of these programs are widely used in more than 500 cities.
Technologies: C#, Delphi, SQL Server, Oracle- NHibernate
2000 – 2001
Developer - Software Developer
Iranian Handicraft Organization, Tehran
• develop a windows application showing identification of all Iranians carpets and rugs.
• develop website of the organisation.
Technologies: Delphi, BDE(Borland Database Engine), HTML, ASP, MS Access
EDUCATION AND TRAINING
1996 – 1998
Leadership of Computer
Shokuh Institute, Tehran (Iran)
1998 – 2000
Provisional Graduation in computer
Azad University South Branch, Tehran
2000 – 2003
Software Engineering – BE
Azad University (Iran)
2007 – 2009
MSC in Scientific Computing
University of Pune, Pune (India)
PERSONAL SKILLS
languages
Persian(Native)
English (PROFESSIONAL WORKING PROFICIENCY)
French( ELEMENTARY PROFICIENCY)
Arabic, Hindi ( LIMITED WORKING PROFICIENCY)
Communication skills
Excellent Communication skill to present points precisely and clearly
Good team player and have excellent interaction skill to coordinate and work within a team
Good deliver output in less time without losing efficiency
capable problem solving ability and analytics kill to solve the problem efficiently
References
Available upon request