Sql Server Developer
Resume:
Kire Hajba
****.*****@*****.***
SUMMARY
• Over four years of working with Databases and developing applications using .Net technologies.
• Over three years of web design experience
• Highly proficient in design and analysis of Databases
• Performed extensive design and development using T-SQL, PL/SQL, MSSQL, ORACLE, Sybase and MySql
databases.
• Experience in Reporting Services, Business Intelligence, Integration services, optimization of databases,
administration of databases, developing databases
• Experience in HTML, DHTML, AJAX, JavaScript, SEO, Flash technologies
• Worked with Spring and Hibernate frameworks.
• Experience with UML, Use cases
• Complete life cycle, design and development experience for various projects involving multi-tier architecture.
• Versatile team player & fast learner with excellent client management, inter-personal communication
skills and presentation abilities.
• An energetic, result oriented, highly organized and proven skilled problem-solver.
TECHNICAL SKILLS
Languages Java, C/C++, C#, VB.NET/Pascal
IBM DB2, Oracle 9i, 10g, MSSQL Server 2000/2005/2008, Postgree, MySQL,
Databases
Sybase
Web Technologies HTML, DHTML, JavaScript, XML, XSD, AJAX, ASP.NET, Tapestry
UNIX, Windows 98/NT/2000/XP/Vista/7, Windows Server 2003/2008,
Operating Systems
RedHeat Enterprise Linux 5
Web Servers Apache Tomcat, Windows Server 2003/2008
Database Servers SQL Server 2000/2005/2008, Oracle 9i/10g
Tools MS SQL Management Studio, MySQL, Postgree, Hibernate
IDEs Eclipse, MS Visual Studio 8/2005/2008
OOD UML
EXPERIENCE
Seavus - Database Developer November 2010 to present
Database administrator, Database developer.
Responsibilities:
Migration from MySQL 5 to MSSQL 2008 R2 database.
Writing procedure for data migration.
Rewriting SQL queries, procedures.
Rewriting SQL queries for further use in report building.
Redesigning and rebuilding reports in SSRS 2008
Seavus – ST Ericsson Reporting May 2010 to November 2010
Database administrator, Database developer
Responsibilities:
MS SQL 2005 Business Intelligence and MS SQL 2005 Developer
ST Ericsson Reporting department has a goal to design, develop and maintenance reports for the
STE managers. The reports have goal to show the test results and development path of the
developing platforms to the managers who are leading the projects.
Responsibilities:
- Collect requirements from the end users
- Build the report logic
- Design the report
- Build and optimize T-SQL queries
- Maintenance and optimization of the current reports
Seavus September 2009 – April 2010
Database administrator
Agency for anti money laundry: Project for internal use of the agency for anti money
laundry, making statistics and saving records for agency for anti money laundry of R.
Macedonia.
Responsibilities:
- Creating and investigation of normalization of the database ER diagram
- Giving suggestions on normalization
- Database support
Environment/Tools: ORACLE 10g
Biro for public procurement: E-system for working of the Biro for public procurement.
Responsibilities:
- Creating reports for the purposes of the biro for public procurement
- Optimization of the existing reports
Environment/Tools: MSSQL 2005, SQL Server Profiler, Database Engine Tuning Advisor, Visual
Studio, SQL server Reporting services
Telephone bills invoices: System, for processing and sending invoices to the final customers.
Conversion of the invoice document from PDF format, to XML and creating database with
all records for further use for sending invoices mails or creating reports.
Responsibilities:
- Database developer
- System integrator
Environment/Tools: MSSQL 2005
Hydrobiological Institute Ohrid April 2008 - August 2008
CMS system: Web content management (WCM) system was build for the needs of the institute.
The system simplifies the publication of web content to web sites in particular, allowing content
creators to submit content without requiring technical knowledge of HTML or the uploading of
files.
Responsibilities:
• Collecting business requirements from the client and building specifications for the application
• Designing use cases
• Designing the user interface using DHTML and AJAX
• Designing and developing the web application using C# on .Net 3.5
• Developing Web services
• Designing database
• Writing stored procedures
• Configuring SQL server
• Configuring Web server
• Installing the application on Web server
• Gave a presentation of the assessment and recommendation to the client.
Environment/Tools: MSSQL 2005/2008, SQL Server 2003, .NET 2.0/3.5, C#, DHTML, AJAX, Adobe
Dreamviewer CS4, Visual Studio 2005/2008
Hajbatours October 2007 - December 2008
.NET Developer/ Database Administrator
ERP system: Integrated system used to manage internal resources in a travel agency, including
financial resources, tangible assets and human resources.
Responsibilities:
• Collecting business requirements from the client and building specifications for the application
• Designing use cases
• Designing the user interface using DHTML and AJAX
• Designing and developing the application using C# on .NET 2.0
• Developing Web services
• Designing database
• Writing stored procedures used in the application
• Building reports using reporting services
• Configuring SQL server
• Configuring Web server
• Installing the application on Web server
• Search engine optimization
• Gave a presentation of the assessment and recommendation to the client.
E-business CMS system: Web content management (WCM) system that was build for the needs
of the travel agency. The system simplifies the publication of web content to web sites, besides
that, the system represents full e commerce application that provides searching, reservation and
payments for hotels, car rentals, airplane tickets, and other services provided by the client.
• Collecting business requirements from the client and building specifications for the application
• Designing use cases
• Designing the user interface using DHTML and AJAX
• Designing and developing the web application using C# on .NET 3.5
• Developed services for Credit card Processing using the API provided by the credit cards
payment gateway vendor
• Developed services for online reservation of hotels, airplane tickets, car rental and other services
provided by the client
• Developing Web services
• Designing database
• Writing stored procedures
• Configuring SQL server
• Configuring Web server
• Installing the application on Web server
• Gave a presentation of the assessment and recommendation to the client.
• Maintaining the application
• Optimizing and changing modules of the application
Environment/Tools: MSSQL 2005/2008, SQL Server 2003, .NET 2.0/3.5, C#, DHTML, AJAX,
Adobe Dreamviewer CS4, Visual Studio 2005/2008
HOTAM - Hotel Association of Macedonia February 2007 –August 2007
.NET Developer/ Database Administrator
Hotel ERP system: Integrated system used for managing multiple hotel facilities (restaurants,
bars, internet center, etc.), including financial resources, services invoicing, tangible assets and
human resources.
The system provides a service that gives feeds about the state of the hotel, for example, number
of available/taken rooms and beds.
• Collecting business requirements from the client and building specifications for the application
• Designing use cases
• Designing the user interface using DHTML and AJAX
• Designing and developing the web application using C# on .Net 2.0
• Developed services for Credit card Processing using the API provided by the credit cards
payment gateway vendor
• Developed services for online reservation of hotels
• Developing Web services
• Designing database
• Writing stored procedures
• Configuring SQL server
• Configuring Web server
• Gave a presentation of the assessment and recommendation to the client.
Environment/Tools: MSSQL 2005/2008, SQL Server 2003, .NET 2.0/3.5, C#, DHTML, AJAX, Adobe
Dreamviewer CS4, Visual Studio 2005/2008
ERP School system October 2006 –August 2007
Java Developer/ Database Administrator
ERP system: It is an interactive platform for all entities Students, Teachers, Management,
Alumni, Guests, and Experts of an educational institution. This education ERP handles all the
requirements for easy education management for chain of schools/colleges
• Collecting business requirements from the client and building specifications for the application
• Designing use cases
• Designing the user interface using DHTML and AJAX
• Designing and developing the web application using Java and Tapestry
• Designing database
• Writing stored procedures using PL/SQL
• Configuring database server
• Configuring Apache Tomcat web server
• Installing the application on web server
• Gave a presentation of the assessment and recommendation to the client.
• Maintaining the application
• Optimizing and changing modules of the application
Environment/Tools: ORACLE 10g, Java, Eclipse, Tapestry, Hibernate, Dreamveawer CS 2, Spring
Web site development 2004 – 2008
• Developing and maintenance of web sites
• Writing CSS
• Writing HTML/XHTML/DHTML
• Writing JavaScript codes, AJAX
• Search engine optimization
• Configuring web servers
• Web site deployment on web servers
List of some of the sites that are developed:
www.hajbatours.com
www.web-design-chef.com (not active at the moment)
www.kristino.com.mk
www.lozani.info (not active at the moment)
www.hio.edu.mk/GEC/index.html
www.hio.edu.mk/SIAL/index.html
www.lonormaalproject.info
www.aquamk.com
Developing flash applications 2002 – 2006
• Developing and maintenance flash applications
• Designing flash components
• Developing XML data source
• Connecting XML data source with flash applications
List of some of the projects:
• Multimedia presentation for endemic species of Flora and Fauna in National park
“Galichica”
• Multimedia presentation for Confederation of Scouts in Macedonia
• Multimedia presentation for Hotel association of Macedonia - HOTAM
• Encyclopedia of endemic species of flora and fauna in Macedonia
• Tourist guide of Macedonia
• Tourist guide of Ohrid
• Encyclopedia for ancient crafts of Macedonia
• Software for four to seven years old children
Education:
Bachelor of Science, Computer Science – Institute of Informatics at University of Ss Cyril and
Methodius
Diploma work: CMS (Content Management System) for people with disabilities (children on age 3-5
years)
• Implementing feature that enables children who can’t read to use the application
by using pictures and voice guides
• Implementing features that enables children who doesn’t have developed motor
skills to use the program
Contact this candidate