Administrative Assistant Sql Server

Prerna Goyal

*** ********** ****, *** **** (***) 899 - 5910

Jersey City, NJ 07310 ******.***@*****.***

Skills

• Systems: Windows XP/Vista/7, Linux

• Software: MS Office (Word, Excel, Access, PowerPoint), MS Outlook, MS Visio.

• Database: MS SQL Server, Oracle PL/SQL.

• Languages: XML, HTML

Education

• Oracle PL/SQL Classroom Training, ECS, Iselin, NJ (Apr 12- Jul 12)

• Bachelor of Technology in Computer Sc & Engg., Punjab Tech University, India (2005-2009)

• Knowledge of Oracle 10g, 11g, SQL DBMS / PLSQL, sql*loader, Toad.

• Experience in writing SQL statements, PL/SQL code for the database objects such as tables, views, indexes, sequences, procedures, functions, packages, and triggers.

Working Experience

• Log on computer and mailing services, New York, NY (Apr 2012)

Title: Data Processing Coordinator

Generates and Exports data from Excel spreadsheets to MS Access database and generates queries and tables using pivot tables.

Establishes and maintains data processing and computer code files with the help of BCC Mail Manager Software.

Provides data processing support of various activities of the department.

Assists in formulating data processing procedures.

• Mix Nouveau Apparel & Logistics, New York, NY (Aug 2009 - Sep 2011)

Title: Data Administrative Assistant

Worked closely with logistics providers to assure on-time shipments. Maintained shipment data, issues reports, and responded to customer inquiries regarding status of shipments.

Experience in tracking inventory and reviewing current and future orders/inventory. Track flow of goods globally and domestically.

2 yrs of Office Experience including weekly and monthly uploading of data into the system and generating financial and inventory reports using Excel.

Processing EDI from various clients and modify and update data.

Responsible for daily management of debts and collections, cash allocation and rectification of previously mismanaged accounts.

• SLR InfoTech Pvt. Ltd, Punjab, India (Aug 2008 - Jun 2009)

Title: Technology Intern

Documented and analyzed business requirements.

Created SQL Server reports for data collections using SQL Server 2008.

Increased system performance by optimizing stored procedures and queries.

Developed systems using rapid software prototyping system with case tools and object oriented design methods.

Tested the data integrity of the reports, stored procedures, tested UI.

Contact this candidate