SQL Developer

JANE TATAR

* ******* ****, ************, **, **772, 508-***-****, **********@*****.***

PROFILE

Programmer with 6 years database development experience using languages such as SQL, Python, C. Certified in SQL Querying on a MS/SQL server, and data warehouse implementation. Hands-on experience with design, coding, and testing software applications; creating queries, reports, forms, managing technical documentation. Working experience with large volume data. Work effectively independently, or as a part of a team. Skills and knowledge are updated in 2015-2016 at New Horizons Computer Learning Center (Database and Business Program).

TECHNICAL SKILLS

Languages: SQL, T-SQL, RPG IV, ILE/400, CLP, LISP, BASIC, Python, XML, VBA, C

Operating Systems: Linux, Unix, OS/400

Data Base: MS SQL, Oracle, MS Access, DB2/400

PROFESSIONAL EXPERIENCE

Database and Business Program, New Horizons Computer Learning Center, Nashua, NH 2016

SQL Querying

Querying MS SQL Server 2014

Implementing a Data Warehouse with MS SQL Server 2014

Developing MS SQL Server Databases 2014

Access 2013 Programming with VBA

Oracle 12c SQL Fundamentals

Network Display QA Analyst, National Grid, Northborough MA 2013- 2015

Maintained Network Displays: updated displays in accordance with operation's display change request, making graphic changes and checked similar work performed by peers using Picture Editor 500 computer graphic software

Interpreted, applied and documented change requests

Linked dynamic display elements into the Energy Management Database (Oracle) and documented in MS Access databases

Created queries to obtain more effective access to data

Moved to US 2011-2013

Engineering Technician, Genivar Inc, Ottawa, Ontario 2007- 2011

Produced structural and bridge engineering detailed scale design

Collected and analyzed data, developed scripts for automatic calculations and generating reports

Jane Tatar 508-***-**** Page 2

Engineering Technician, NORR Engineering, Ottawa, Ontario 2007

Implemented electrical, lighting and power layouts utilizing CAD tools, examined technical design to comply with industry standards

Completed technical documentation, maintained project archive, organized and maintained project related database

Maternity leave 2004 – 2007

Software Developer, Mashbir Lazarchan Ltd., Netanya, Israel 2001 – 2003

Project: Legal Management System

Performed full software development cycle for Legal Management System to promote more effective management for Company Legal Department

Created new database, which included information about company properties, rented units, client’s contact, contracts with partners

Designed, implemented and tested user interfaces and applications for obtaining requested information, related to company expanses and profit, creating reports, performing calculations and analysing data

Developed mechanisms of agreements follow-up, including an automatic notice for service termination

Maintained new system, provided users training and support after implementation

Project: Department Store Goods Tracking System

Gathered users requirements for Goods Tracking System

Designed and developed major parts of goods routing tracking system

Provided customer support and training for a new enhancement, performed troubleshooting

Software Developer, United Health Insurance Company, Tel Aviv, Israel 1998 – 2001

Project: Health Information System

Designed and implemented extension of a software Client Management System, created new functionalities to manage clients personal and medical condition information

Redesigned and implemented new features for a Service Contract Billing System of external health care companies

Participated in design and development of Pharmacy Billing System, which validates and tracks customer benefits and includes reporting functionalities

Reviewed and analyzed existing data and programs to ensure their efficiency

Developed, reviewed and performed test plans to validate scalability and ensure the quality

Provided post-implementation support and troubleshooting

EDUCATION

Master in Mechanical Engineering, Saint Petersburg State University, Russia

AS/400 and RPG Programming Diploma, Kedem College, Israel

Database and Business Program, New Horizons Computer Learning Center, Nashua, NH 2016

Python for Informatics, Cousera.com 2015

Contact this candidate