ARTUR DJULUKIAN
*** ******** ******, *** ** Fort Lee, NJ 07024 Phone: 201-***-****; 201-***-**** *********@*****.***
Personal Summary
A highly efficient, self-motivated and detail-oriented data/business analyst, with an excellent ability to solve problems using analytic techniques and introduce creative solutions, has extensive experience in the development and data modeling of database systems. A quick learner, who can absorb new ideas, now is looking for a suitable position with an ambitious company.
Key Skills
Systems Knowledge
Databases:
MS SQL Server 2000-2012, MS Access 2003-2010, FoxPro 2x-9x
Languages:
SQL, VBA, HTML, Visual FoxPro
Software:
MS Excel 2003-2010 (pivots, tables/charts, slicers, V&H lookups, macros, VBA),
MS Access 2003-2010 (union and cross tab queries), MS PowerPoint, MS Word
Problem Solving
Strategic mindset, creativity and attention to details
Ability to manage multiple tasks and deadlines with limited supervision
Experience with manipulating large data sets, forecasting, budgeting, income and expense analysis
Team Player ( Priority to achieve specific team goals)
Experience
09/2007 - Present My Motors Incorporation, North Bergen, New Jersey
Data/Business Analyst
Accomplished
The flexible data models’ design and implementation for:
Budgeting
Trend analysis for the customers and vendors financial activities
Pricing System
Shipping cost’s expense optimal minimization
Responsibilities
Study the problem and design the models, paying attention to details
Initial Assessment and Existing Systems Evaluation
User Requirements Clarification and Feasibility Evaluation
Logical and Physical Design, Quality Assurance, Installation and Fine-tuning
Build and maintain master databases
Data architect, data modeling, data mapping, data cleansing
Extract data from the different data sources
Transforms the data for storing it in the proper format for the purposes of querying and analysis
Load in final databases
Identify and report potential data issues and determine ways to optimize data quality
Data analysis and reporting using MS Excel, MS Access and complex (nested) SQL queries
Review budget versus actuals and profit and loss statements to prepare variance analysis reports
Trend Analysis for company’s and customer’s Financial Statements, Sales, Revenues, Profits
Budgets, Accounts Receivable, Accounts Payable, Bank Reconciliation and Billing Issues
Pricing System Based on Customers Activity and Vendors’ Offers Comparison by Brands
Special Orders Pricing, and other Issues of the Managerial (cost) Accounting
Various Custom Reports
Share knowledge and experience
Supplying qualitative and quantitative data to colleagues and clients.
Presenting complex information to various audiences using MS Excel and MS PowerPoint
Providing analytical insight for optimal business decision making, forecasting
09/1997 – 03/2005 Georgian Railway Company, Tbilisi, Republic of Georgia
Database/Application Developer
Accomplished
Design, development, data modeling, and support of “Container Registration System” and “Train Engine Registration and Maintenance System” business applications written in Visual FoxPro utilizing SQL as back end.
Responsibilities
Database architecture. Data mapping. Database logical and physical modeling. Data analysis.
Data cleansing, data conversion and transformation, data load and export.
Development and optimization of numerous T-SQL Procedures and SQL queries.
Application design, development and installation.
Generation of on-demand reports for end-users using Visual FoxPro, MS Excel, Crystal Reports.
Quality assurance. Technical documentation. Consulting.
Work in team and spread knowledge and experience to the other employees.
Education
Bergen Community College, Paramus, New Jersey
2008 - 2010
Associate in Business Administration, Accounting
GPA: 3.98
Tbilisi State University, Tbilisi, Republic of Georgia
1991 - 1996
M.S. in Computer Science and Applied Mathematics
Additional Skills
Network and PC Troubleshooting
Accounting Systems
Turbo Tax
QuickBooks
Foreign Languages
Russian
Georgian
Armenian