Post Job Free

Resume

Sign in

Sql Server Developer

Location:
Germany
Posted:
July 19, 2015

Contact this candidate

Resume:

PERSONAL INFORMATION

Ali Elmi

Second Floor – No.16, Vezvaee St, Motahari Ave., 156******* Tehran (Iran)

+989*********

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



Contact this candidate