Буду благодарен, если подскажете, что исправить.
Vyacheslav
Email: -
Phone: -
Russia, Kaliningrad
DATABASE ARCHITECT
SUMMARY OF QUALIFICATIONS:
• Database Architect with more than 20 years of hand-on experience in developing and creating databases to support business logic
• Able to communicate with different representatives of business process to collect necessary information
• Proficient in analysing and understanding business requirements on the basis of collected data
• Profound knowledge of database architectural strategies to better address business needs
• Solid experience in implementing every database lifecycle stage from analysis to maintenance
• Can make changes in database structure to address new business requirements
• Possesses deep knowledge and practical skills in providing database technical functionality, such as performance, reliability and security
• Experienced in designing database interfaces using C++ and Objective-C programming languages
TECHNICAL SKILLS:
Platforms: OS X, Windows
Database Management Systems: PostgreSQL, Microsoft SQL Server, MySQL, SQLite
Database Administration Tools: pgAdmin, Navicat
Database Interface Applications: ProjectDB, Microsoft Access
Programming Languages: SQL, C++, Objective-C
PROFESSIONAL EXPERIENCE:
2008 - Present, Database Architect, Balt Assistance Ltd (Medical assistance), Kaliningrad, Russia
• Analysed peculiarities of company’s business process, requirements, existing software (was used to keep track of sold insurance policies)
• Designed and established a new database on the basis of Microsoft SQL Server to cover the whole business process of the company, including such business tasks as filling in the form of the new case, tracking the status and history of each case
• Employed functions, procedures and database interface application ProjectDB to create reports on key parameters (including number of registered cases, medical treatment expenses, commission revenues) in such dimensions as time, region or insurance company that sold the policy
• Carried out transition to PostgreSQL DBMS
• Created triggers to effectively support business process (automated sending notification emails to insurance companies upon registration of new cases, changing the status of the case upon fulfilment of pre-defined requirements)
• Automated a range of activities, excluded intermediate stages in employees’ work (receiving and sending emails and text messages directly from the database, saving call records to database, issuing several invoices at a time)
• Collaborated with PBX administrator to develop and integrate a PBX management system into the database and interface to provide a quick and simple method to distribute incoming calls, thus, excluding the necessity to wait for the PBX administrator to make changes in Asterisk command-line interface
• Collaborated with a team of developers to integrate designed for the call centre application, that was managed with functions stored in the database
• Devised and implemented a method that allowed to apply for technical help to the IT department of the company directly from the mentioned above call centre application
• Provided secure remote access to database for the clients (insurance companies) allowing a possibility to track the history and status of each case, get statistical data on registered cases, fulfil necessary actions (confirm coverage of the expenses, send comments) in the database, hence, resulting in providing information immediately and excluding intermediate steps in interaction between the company and insurance companies
2002 - 2007, Database Architect, OJSC Almak (Meat production, wholesale and retail), Kaliningrad, Russia
• Analysed the state of the business process, introduced clear division of tasks performed at each stage of the business process
• Developed a database on the basis of Microsoft SQL Server
• Introduced a call centre system to accept orders from the clients
• Created a mechanism to automatically work out routes for delivery cars to cut transportation expenses
• Developed methods to get reports on deliveries to the clients and clients’ debts with reference to managers working with them
• Set up a system to keep track of stock and every production stage in the database
• Created methods to calculate actual amount and cost of raw material that was used during production
• Devised methods to calculate necessary amount of raw material to be bought on the basis of product specifications and key production parameters
• Created methods to prepare real-time financial reports on profitability of the company
• Some time later, optimised the database
• Reduced time necessary to query data and get reports for long periods of time
• Introduced bar code scanners at each production stage from receiving raw material to getting end products to add necessary information to the database
• Developed a mechanism to draw up the staff schedule
• Adopted a check-in/out system to track the actual working hours of employees
• Elaborated methods for salary calculation on the basis of staff schedule and check-in/out system
• Expanded the accounting system to include a new unit - supermarket
• Integrated two business - production and sales
• Created a mechanism to deliver reports on the state of each department, business and holding company as a whole
• Employed ProjectDB software as a database interface application during construction of the company’s accounting system
2000 - 2002, Database Architect, State Baking Company (Bakery production and sales), Kaliningrad, Russia
• Established a database on the basis of Microsoft SQL Server to reengineer business processes
• Designed and implemented an accounting system to support a large structure consisting of three plants and 25 stores
• Created methods for detailed calculation of raw material, package and transportation expenses
• Devised and introduces a call centre system to accept orders from the clients
• Automated the process of drawing up waybills (about 200 - 300 per day), as a result decreased spent time
• Developed a mechanism to work out routes for delivery cars to decrease transportation expenses
• Created a mechanism to automatically plan routes for collecting sale proceeds from stores
• Worked out methods to keep track of clients’ debts with reference to managers working with them, thus, providing an opportunity to have balanced sales
• Used ProjectDB software as database interface
1992 - 1999, Database Architect, Continent Bank, Industrial Bank (Banking and Financial Sector), Naberezhnye Chelny, Russia
• Using Microsoft Access, created a database aimed at tracking transaction day of the bank to support business process
• Developed and introduced a system to track labor hours
• Added forms of various documents to automatically fill them with information from the database
• Created a system to keep track of posted financial documents
• Developed a way to record information about clients and employees in the database
• Devised and adopted methods to create financial reports on accounts balance and bank statement
• Created mechanisms to exchange financial documents with the processing centre
EDUCATION:
Vocational Secondary Education, Computer Hardware Engineering, State Institute in Naberezhnye Chelny
PERSONAL:
Employment Authorisation: H1B sponsorship required.
