Posts tagged SQL
Microsoft SQL Server 2008 R2 – a business overview for software developer
Feb 8th
I am a certified SQL 2005 Technology Specialist. While this means a lot from a professional point of view, the new technologies come toward us, developers, too fast sometimes. It is quite a while since SQL 2008 was launched, and now SQL 2008 R2 brings its novelties. One good developer must keep up to date with its skills, otherwise the quality and quantity of his or hers work will suffer. New technologies means usually more productive developers – and I wish to stay on the wave instead under it.
Alensa Online
Feb 11th
Position: Team Leader and Lead Developer in Alensa Online – Software Development department
I was part of Alensa team between January 2007 and August 2008. Only the opportunity to study Media Informatics Master, held by RWTH Aachen University, could gave me enough reasons to leave Alensa Online that I enjoyed so much for almost two years.
I was in charge with our brand new solution for an online Healthcare project – Alensa Online. The Alensa Online Shopping site (www.alensa.ro) consists of an internet healthcare platform in Europe that would simplify research and self education related to health issues, and provides the customers with an interface allowing them to easily get their health questions answered by professionals. It was first developed by a third party company, then I took over the responsibility of developing and maintaining the solution.
My responsibilities were quite complex because I was the first hired person, very similar with Softwise company. This reminded me about the joy and responsibility that comes with this. Another nice surprise was to find in person of Mr. Alex Savic, the CEO of the company, a friend with whom I shared both technical discussions and personal development ones, he was one the most supportive about my decision to study in RWTH Aachen.
Shortly, at Alensa Online I were in charge with:
- Architecting and developing the web based solution using Microsoft ASP.NET / C# and SQL 2005 Server technologies;
- Performing server administration, configuration and maintenance for the Windows 2003 server, for IIS 6 and for SQL 2005 database server;
- Executing architectural modifications in order to make the website user friendly;
- Identifying, designing and developing solutions;
- Periodically testing the site functionalities and thus creating a real test environment, test cases and bug fixes;
- Performing code review, corrections and code optimization;
- Analyzing hardware/software requirements and proposing hardware/software improvements and suggestions (for example, choosing an appropriate hosting partner);
- Implementing real time traffic analysis tool to help the management department;
- Conducting internal training for his colleagues. More >
Ubisoft
Jan 26th
Position: Senior Developer
Ubisoft is a leading international developer, publisher and distributor of interactive entertainment products. Between June 2006 and February 2007, I participated in a in-house project. It mainly customizes the data workflow through PeopleSoft implementation in manufacture. The goal of the project was to improve the workflow of the production process by combining the needs of different regional subsidiaries into larger orders which can reside in a much lower price per unit.
My responsibilities included working with:
- Application Engines;
- Crystal Reporting System;
- database objects: fields, tables, views, work derived records, queries etc.;
- creating pages with Peoplesoft framework, tables with more than two levels and transactional operations;
- import / export of files: CSV, Crystal reports;
- unitary and primary testing;
- migration from / to development database.
- migration from / to testing database.
Some examples my tasks:
- Crystal reports generation through jobs sent to clients mail;
- excel csv files export / import regarding partners order data, also the logic needed to be approved by the headquarters;
- create editable pages for data in multilevel tables.
The job also required to be a fluent French speaker since the communication with the consultants and the team leaders was conducted in this language and just occasionally in English.
Novensys Corporation
Jan 22nd
Position: Microsoft Business Solution Software Engineer
I was part of Novensys team from November 2005 till June 2006.
When I started working with them, the first challenge appeared: being the first company that implemented Navision in Romania, they were exigent from the employment process. They also offered specialization classes in Microsoft Navision product, so I and the rest of the team were trained by with a Microsoft Navision specialist for two weeks. Then two exams established my Certification as Microsoft Navision developer with very high scores (96 points out of 100, for the first examination, and 100 points, at the second exam).
After earning my certification as Navision developer, I was part of a team working for one of our most important clients. My main responsibilities included Navision solution development and customization.
Responsibilities:
- implementation of documented updates,
- new screens design,
- new reports development using custom Navision Reporting,
- primary testing functionalities,
- Native Navision database design, tables and records updates, data verification
- user preferences maintenance in the application,
- communication with the consultants.
Tools used:
- Microsoft Navision IDE
https://mcp.microsoft.com/authenticate/validatemcp.aspx
Transcript ID: 770644 Access Code: radupoenaru
The two certifications that I earned during the time in which I was part of the Novensys team motivated me to achieve the recognition of my SQL skills also, becoming Microsoft Certified Technology Specialist in SQL 2005
Totalsoft
Jan 9th
Position: Senior Developer
I had the pleasure of working in Totalsoft Charisma team between the February, 2004 and the November, 2005.
In almost two years, I had the opportunity of working on a large variety of the company’s products, but mainly I was a key member in the team developing the Charisma Business Commander product. Charisma BC is the solution which brought TotalSoft’s recognition on the market of pharmaceutical distribution, being implemented by six of the largest companies in this complex activity sector in Romania. Tens of thousands of daily transactions carried out all over the country are achieved with through this application who manages their warehouses.
I also developed some features on the associated Sales Force Automation tool. It is a WindowsCE application running on smart devices (PDAs). This application enabled sales persons to check the stocks and create orders on pharmacy site, thus improving their flexibility in serving their customers – pharmacies.
My responsibilities were:
- developing new product functionalities
- testing and bug fixing
- product customization for different clients having different requirements
- product modifications due to business logic changes
- business layer development
- document flux optimization
- database developments, data transfer and records coherence verification
- requirement gathering, analysis and engineering after in-depth discussions with the customers
In order to accomplish the tasks, I used the following technologies on daily basis:
- Delphi 5,6 Enterprise
- SQL Server 2000
- Crystal Reporting system
- Microsoft Visual Studio 2003, .Net 1.1 Webforms, Winforms, Smart Device programming
- Microsoft Visual Source Safe
Later on, because I proved to be a reliable and efficient developer, I was assigned the denomination process due to the transition from the Romanian old currency – the leu (ROL) to the new leu (RON). I completed the task for both Business Commander and Sales Force Automation successfully, proving both to my colleagues and me that I worth the challenge and gaining even more trust in my capabilities.
I also had both the opportunity and the challenge to conduct the discussions with the clients of the software that I developed regarding their specific requirements for the resulted product. I also was in charge the product implementation and customization at customers’ sites, creating and encouraging a very close professional relationship with them to better understanding their idea about the product.
CursValutar
Jan 7th
Uses: Borland Delphi 7 VCL, HTTP, HTML Parsing, JavaScript, PHP server side script
The program parses web pages from Romanian National Bank site (www.bnr.ro), offering the latest currency ratings, among with a currency calculator, a very useful converter. The program was designed by me in Softwise Development company as a low resource program, hidden in the tray bar of Windows, while periodically checking BNR site and warning the refreshing of the currencies rate. Another feature is that it shows the trend of the user selected currency over the time, allowing you know how it fluctuates – improving the user decision.
The application is designed to be used as a simple, easy to use tool, providing without any previously knowledge of software usage the full functionality and power to the end user.It also has enough options to allow user to customize the time of refreshing data from the BNR site, the visible currencies (although all are refreshed, user may want to see just a number of them), the program start), and the calculator part – a tool visible in the main window of program (in right-bottom corner), but also in a separate window, which can be set to become visible as user clicks on the tray icon.
Softwise Development
Jan 4th
Positions: Junior to Senior Developer, Project Manager
Softwise Development is the company that shaped me as developer. I worked there for 2 years, between January 2002 and January 2004. I enjoyed there not only a good atmosphere, but also discovered a friend in the person of Mr. Dan Trutia, CEO of the company. I was his first employee and I believe that we created a good team. Together we raised the company to a 10 people business, having international contractors while working in software outsourcing industry.
There I had quite a few projects, challenge being the word of the day. I learn a lot about developing Object Oriented applications in Delphi 5 and 6, Access databases, PHP and MySQL, Windows API programming and not to mention user accessibility techniques, helping users with eye problems.
In the last six months of his employment, I was trusted with the responsibility to manage several projects to completion in budget and timely manner, being advanced to project manager. I enjoyed this opportunity and tried my best to prove my professional potential and leadership ability. Being a manager on several projects, I was responsible for conducting many meetings with the customers, conducting requirement analysis and requirements engineering that lead to successful projects.
Responsibilities:
- Delivering IT projects to user specification, on time and on budget
- Testing functionalities and modules
- Documenting IT policies and procedures
- Scheduling the project tasks
- Maintaining the IT security in line with group specifications
- Database maintenance, data updates and records checking
Technologies that I used were:
- Borland Delphi 6 and 7 Enterprise, custom built controls.
- Microsoft Access and Microsoft SQL databases, ADO
- Windows ‘98 Api programming
- PHP and MySQL for server-side applications
Working in Fraunhofer Institute of Technology
Mar 2nd
Starting today, I work as a Student Helper in Fraunhofer Institute for Applied Information Technology. The branch from Sankt Augustin, which I joined, is focused on the research of human-centered computing in a process context. I will activate in the Cooperation and Community Support department, which deals with the research and development of community portals, (mobile) communities and cooperation, Internet-based groupware, cooperative knowledge management, application service providing for cooperative work and virtual teams, rating and recommender systems and cooperative learning environments.
The head of the department is Prof. Wolfgang Prinz, PhD and I will work closely with Mr. Nils Jeners, researcher in FIT. I had the pleasure of attending Mr. Prinz course, CSCW and Groupware, while being student in the Media Informatics Master, held by RWTH Aachen University. CSCW stands for Computer Supported Collaborative Work.
My first task is to study the Twitter community, applications based on it and the actual phenomena. My work should help in better understanding the aspects of human behavior, social interaction between humans and in particular the tools and services used for microblogging. This will allow also to discover ways to extract patterns in the context of this technology, who is changing the ways that people interact and socialize over the Internet.
