Microsoft Office Data
Resume:
Biljana Pindjurova
**** ** ****** ***** ***** Apt. 302, Hillsboro, OR, 97124
e-mail: *.**********@*****.***
Summary
* ***** ** ********** **** writing T-SQL queries and optimizing the queries in SQL Server 2012
6+ months of experience with C/C++, PASCAL
6+ months of experience with PHP, JavaScript, JSON, jQuery, HTML, CSS, XML
4+ years of experience with QNXT, CACTUS
Knowledge in RDBMS concepts, Views, Stored Procedures, Indexes and Constraints
Extensive knowledge and experience in producing tables and reports using various procedures and handling large databases to perform data manipulations
Ability to manage and complete tasks to the highest standard, with immense attention to detail and within agreed deadlines
Excellent computer skills and unique ability quickly to identify the root of a problem and to develop an effective solution
Proactive, confident and with a positive "can-do" attitude and strong work ethic
Able clearly to communicate technical data to non-technical colleagues and clients
Excellent communication, analytical, interpersonal, and presentation skills; expert at managing multiple projects simultaneously
Skills
Databases: Oracle 11g/10g, MS SQL Server
Software: MS Office, MS SQL Server Management Studio, MS Access, QNXT, CACTUS
Operating System: Windows, Linux/Unix
Scripting Languages: PHP, JavaScript, CSS, SQL
Certifications: MOS: MS Excel 2010 Expert, SQL queries
Education
Masters in Computer Science, January 2017- on going GPA: 3.88
University of Illinois Springfield
Graduate Level Coursework
2018: Completed “Advanced Database Concepts” class, UIS
Implementation of relational database for Dental clinic. Design algorithms, query implementation, execution and optimization, transaction processing, concurrency control, database recovery, distributed database, data mining concepts, data warehousing and database security. Project completed in Oracle 12c and MS Access.
2018: Completed “Database Admin Practicum” class, UIS
Database installation, User Security, Database Maintenance, Database Optimization and Schema Development using industry standard database systems. Using Microsoft SQL Database, Oracle Database, MySQL Database and associated database administration tools.
2017: Completed “Client-side Scripting” class, UIS
Design Rich Internet Application (RIA) using JavaScript, XML, AJAX, JQuery, PHP, HTML, CSS.
2017: Completed “Intro To Database Systems” class, UIS
Logical database design and development of Child Daycare Center, ER design and implementation and manipulation of the database using Oracle 12c, XML and SQL.
2017: Completed “Web Development & Programming” class, UIS
Creating dynamic web page using PHP for back end, using HTML, CSS to design the UI, MySQL to store the web data.
Bachelor in Computer Science, September 2009 GPA: 3.65
Technical University of Sofia
2009: Completed: Undergraduate Research, eLibrary application, TUS
Created eLibrary Windows application in C++. Using Borland C++ environment, Object Windows Library (OWL) and Visual Component Library (VCL) frameworks and SQL.
2008: Completed “Computer Programing Concepts II – C++ Programing Language”, class, TUS
2007: Completed “Computer Programing Concepts I – C Programing Language” class, TUS
2006: Completed “Introduction in programing language PASCAL” class, TUS
Experience
Care Oregon, Portland, OR March 2014 – Present
Provider Configuration Specialist
Provide regular auditing of provider data module to ensure data integrity utilizing an assortment of reporting tools such as Provider Troubleshooter, QNXT Reporting Services
Assist in the production and validation of provider data reporting, such as provider directories.
Communicate with internal and external customers as a QNXT provider module subject matter expert regarding provider configuration
Participate in annual 1099 workgroup to validate data and ensure accurate IRS filings
Use IRS e-services to validate tax identification numbers and social security numbers for IRS and DMAP requirements
Process IRS CP2100 error notices and follow regulatory process for correcting and tracking errors
Write SQL queries using joins, stored procedures and user defined functions to verify the data from the database based on the business requirement
Creating reports from SQL Server Management Studio using SQL queries
Columbia Sportswear, Beaverton, OR November 2013 – December 2013
Master Data Analyst
Setup styles (size, color, name, price, gender group, season) in Product Development System(PDM) from data provided on Excel spreadsheet
Branch attaching in the AS400 system(JDE) from data provided on Excel spreadsheet
Customer maintenance of master data in JDE from data provided on Excel spreadsheet
Putting manual credit memos in numeric and alphabetic order and filing them
Entering manual credit memos in the AS400 system (JDE)
Pricing manual credit memos in the AS400 system (JDE)
SentriLock, Portland, OR 2 weeks Project October 2013 – October 2013
Programmer
Accepting old lockboxes and old supra key, scanning their codes, checking in the database for correct information and entering information of the owner of the lockbox and supra key
Programming new lockboxes with new smart card, and completing the package with card reader and RAM
Holiday Retirement, Lake Oswego, OR 2 weeks Project August 2013 – August 2013
Data Entry Clerk
Working with CA Service Desk Management: creating tickets and assigning each ticket for exact group in the IT section, creating new and editing existing company member information
Working with Active Directory: creating and editing company member information, creating members Directory List Group
Working with Microsoft Office 365: creating members company email and assign each of them with given privileges
Working with Microsoft Office tools: Outlook, Word, Excel, PowerPoint
RiverSoft Computers, Strumica, Macedonia www.riversoft.com.mk February 2011 – March 2013
Office Administrator
Plan, develop and implement the general workstation assignments and administrative services. (Log-ins, passwords, updates, peripheral access)
Update and maintain databases such as mailing lists, contact lists and open client tickets/information/documentation
Supporting customer calls to assist in general troubleshooting and problem resolution; documenting resolution for team member reference; created ongoing client database and updated record of calls with emphasis on issues and issue resolution
Processing forms or applications to ensure accuracy and completeness, computing or verifies data, fees or payments, entering data and forwarding various files and paperwork
Prepare documents, email and file management. Create and maintain files in Microsoft Word, Excel and created various PowerPoint presentations for internal and external use
Create flyers and commercial materials in Adobe Photoshop and Coral Draw
Leadership Highlights
Two (2) years leading student council at Technical University of Sofia – Branch Plovdiv
Student interest and organization of class hierarchy and structure
Fundraising and accountability for managing allocation of funds for student use
Mediator and interface for students and faculty
Reporting and media handler for event reporting/achievement updates; via social media
Organizing and record documentation of ongoing agendas/goals and achievements
Outstanding leadership and strong attention to detail
Formed online record of meeting events, open discussions and future events/calendar
Other languages spoken:
Fluent in Macedonian, Bulgarian, Serbian
Intermediate in Spanish
Contact this candidate