Khyati Mehta
S. Setauket, NY 11720
*******@*******.***
EXPERIENCE
Swim King Pools Inc., Rocky Point, New York 2006-Present
Controller/App Admin/Bus. Processes Re-engineer/CRM-ERP Implementation/Payroll/Analyst/Bookkeeper
Review, analyze, and evaluate business systems and user needs and translate it to functional requirements
Determine company's long-term systems needs to accomplish company's business objectives by doing change management
Support critical business strategies by developing, implementing, and maintaining business applications systems
Clean and maintained Records and information within Netsuite system as well as other application
Create & Customize reports and searches in Netsuite as per individual needs within sales, marketing, accounting, retail and service departments
Developing and customizing Forms, Fields, records types of Netsuite as per individual and business needs
Daily and monthly bank reconciliation and other financial transactions
Create Journal entries and handle general accounting work
Perform Account payable & receivable functions
Reconcile Credit Card transactions
Re-engineer business processes of various departments including sales, marketing, account receivable, account payable, Human resources, service, retail
Train current and new employees in using of Netsuite
Prepare weekly payroll thru ADP payroll system
Calculate and Process Sales commission
Manage and control access level for each employee as per their role in the system
Assist outside accountant in Quarter and year ending work
Cash management, re-imbursement and reconciliation
Maintain accounting books thru entering transactions, bank reconciliation and reporting tools for multiple companies
Process inter-company transactions
Doing complete bookkeeping work using quickbooks for owner’s other entity
Ramp Chevrolet Inc., Pt. Jefferson Sta., New York 2005-2006
Database Manager
Development, Design, Management, Implementation of online Databases.
Monitoring of various databases to improve efficiency and profitability as affected by inventory levels and inventory turns.
Assisting Inventory Control Manager and upper management in building, developing, maintaining, implementing, and administration for Inventory control.
Finalize auto trades for the company.
Download and Upload invoices like data from GM Application to QuickBase.
Create reports for various purposes of Inventory Control.
JP Morgan Chase Bank, Stony Brook, New York 2002-2004 Client Associate
Higher Level Technologies Inc., Bohemia, New York 2001-2002 Programmer/Analyst
The Pay-O-Matic Corp., Syosset, New York 2000-2001 VBA Programmer
EDUCATION
University of Phoenix, Phoenix, Arizona
Master of Information Systems March 2008
3.5 GPA
St. Josephs College, Patchogue, New York June 2006
BS in Computer Information Systems
3.9 GPA
TECHNICAL SUMMARY
Hardware: IBM 3090, IBM PC
Languages: COBOL II, OS/MVS, JCL, DB2/SQL, ORACLE 8,
Java, Microsoft Visual Basic 6.0, PASCAL, JAVA Script, Visual Studio C++
6.0, HTML, MS Access 97 and 2000
Software: TSO/PDF, Microfocus Workbench/COBOL, Personal ORACLE 8, Oracle Table handling and Reports Development, WORD, MS Visual Studio, Macromedia Dreamweaver and Ultradev, Fireworks, MS office 2000, QuickBase, Netsuite Fully Integrated Business System, Intuit Quick Books 9.0
Concepts: Problem analysis, Structured Programming Design and Techniques, Debugging, Testing procedures, Database and File manipulation, Table Handling, Development of reports, Oracle Databases, Understanding of General Ledger, Oracle Applications, Accounts Payable, Accounts Receivable, Inventory Control, Relational Databases
LANGUAGES: English, Hindi, and Gujarati