Quality Assurance Project

Tatiana Krasnitsky-Grott

**** ***** ***.

Evanston, IL 60201

Cell 847-***-****

**********@*****.***

Summary

Relational database developer/administrator/analyst; data modeler; software/systems engineers; or technology consultant in information technology, publishing, manufacturing and other industries

Education and Training

2012 Northwestern University, School of Continuing Studies. Chicago, IL: Master of Science in Computer Information Systems

2006 ElementK: CompTia A+ Certificate

1986 Moscow Teacher Training University, Russia: Bachelor and Master of Arts in English and German Linguistics and Teaching

1984 Surrey University, Guildford, UK: Linguistic & Country Studies

Certification and Professional Skills

• Oracle DBA (Oracle Database 10g/11g, Clusterware and RAC, Fusion Middleware and other Oracle applications): database conceptual design, organization and architecture in compliance with the industry DBMS standards; system objects management; setting user roles and profiles; Oracle server installation, maintenance and tuning; capacity planning; backup and recovery techniques (RMAN, FLASHBACK DATABASE); network configuration; and security management

• SQL (DDL, DML, DCL): Oracle Database Enterprise, MySQL Community Server, SQL Plus, MS Access, FileMaker Pro

• Data modeling using ERwin, MS Visio, and other built-in database tools

• Basics of object-oriented programming: Java, JSP

• Basics of web design: HTML, JavaScript, XML, CSS

• Data Mining: exploring, processing, and analyzing data using classification, rule association and clustering techniques using Weka and SPSS

• Business Continuity and Disaster Recovery: Risk and Business Impact Assessment (BIA), business continuity planning, creating a recovery plan and solution

• Management of Information Security: security threat survey, risk analysis, control techniques, IT security plan based on ISO_IEC_27001 and 27002, NIST recommendations, governance standards

• Network Basics: LAN/WAN architecture and security

• Software agile project management

• OS: Mac OS X; Unix; MS Windows; Solaris;

• Software: MS Office Suite (advanced); MS Project; MS Visio; Adobe CS3 – CS5 (Photoshop, Acrobat, InDesign); VMware; Oracle VM

• Trilingual: English, Russian and German

Relevant Experience

Northwestern University, SCS

Information Systems Project

Role: Database application development, testing and troubleshooting

Fall 2012

Chicago, IL

• Created the ER diagram of the planned database, which modeled back- and front-end systems and mapped datatypes and relationships

• Created the data warehouse using MySQL

• Converted the customer’s original Excel files into a flat file format and imported the files in the data warehouse (extract)

• Converted the calculated files processed in Java to flat format and imported them in the data warehouse (transform and load)

• Created database back-end systems (tables and queries) in MySQL

• Created database front-end systems (queries, forms and reports) in MS Access

• Linked both systems through OBDC connection

• Created user interface in MS Access using navigation forms and VBA code

• Created and managed accounts, account privileges and access levels

• Prepared the final database application for publishing on the web server

Houghton Mifflin Harcourt

Administrator for Design and Development Solutions

March 2005 – present

Evanston, IL

• Update design and content of the certain intranet sites

• Maintain project allocation database and assist with project time metrics

• Perform print product decomposition and final design checks for the print-to-digital product conversion for the company web-based product

• Train staff in software applications and troubleshoot user problems (MS Office for Mac)

• Maintain correlation contracts and image databases (perform data entry, tracking, quality assurance, modify user interface and tools (SharePoint, FileMaker Pro, Lotus Notes)

• Process vendor contracts, invoices, and image use permission requests; Track and resolve vendor issues

• Generate financial and vendor reports in SAP, export, format and analyze data in different applications (Excel pivot tables, etc.)

• Update, maintain and troubleshoot the professional equipment (laptops, color printers, iPads)

Independent Contractor

English-Russian/Russian-English Translator and Interpreter

March 2003 – March 2005

Moscow, Russia and Chicago, IL

• Written and oral translation in technical, commercial, legal, mass media and educational areas publishing the output in the application of the original document

INVENSYS APV

Sales and Marketing Administrator; Translator/Interpreter

1998 – March 2003

Moscow, Russia

• Supervised customer database and file system and trained staff in using them

• Managed the office computer network for over 20 employees

• Performed immediate desktop support for MS Office users

• Translated technical and commercial documentation, interpreted on-site technical negotiations

• Generated sales and financial reports using Hyperion Enterprises and GAAP

Contact this candidate