Sales Project

IRINA LEEN

**** * ** **** **

Madison HTS, MI ***71

248-***-**** cell

abgvi9@r.postjobfree.com

CAREER SUMMARY

Multilingual Business/Financial Analyst with significant experience in a

variety of industries (Public Accounting, Publishing, Manufactory with 10

years in Automotive). A solid reputation for in-depth analysis and problem

solving. A self starter who works well individually or as a dynamic team

member with excellent written and oral communication skills and the ability

to translate verbal statements into IT requirements.

OPERATING SYSTEMS: WINDOWS 2007, WINDOWS NT, WINDOWS XP

SOFTWARE: Microsoft Office 97/2000/2003/2007/2010, SmartSuite 4.0,

QuickBooksPRO, Platinum 4.2a, Epicor 7.0b, ProSeries, PracticeManager,

ATB, PPT, E-Form, Account Ability, CorpTax/CorpInterntaional,

SharePoint, FDC, eComply, ePreProcessor, CCH Research, FDC, Hyperion,

Sabrix, CCH Sales Tax Solution, TaxStream,VTIMS, SunVTIMS, Project,

Great Plains, VERTEX, QuickBooksPro, AccountAblility, InSiurce,

SharePoint, Sabrix, CCH Sales Tax Solution, Business Objects Report

Writing

DATABASES: SQL 6.5/7.0/2000/2008 R2, Access

95/97/2003/2007, T-SQL, Hyperion

PROFESSIONAL EXPERIENCE

04/2011 - Present Back Office Support Systems, St. Clair Shores, MI

Business Analyst

. Audit data in existing report (Access 2010, Excel 2010)

. Develop reports and maintenance existing reports (SQL 2008 R2)

. Analyze financial reports for the department and follow up on the

recommendation

for analyzed data

. Compare weekly and monthly reports in the company web side

(dashboard application)

06/2010 - 09/2010 Consultant at NETSTAR, Bloomfield Hills, MI

Business /Systems Analyst

. Analyzed application for Ann Arbor Transportation Association,

create/modify reports, debug system errors (Access, Excel, SQL,

VBA)

. Implemented changes to the software to accommodate with existing

program

. Addressed business requirements from accounting department and

created technical documentation for technology group and end-user

05/2009 - 08/2009 E.Richardson, CPA, Southfield, MI

Auditor/Accountant Analyst/

* Detroit Public School: audited and analyzed Financial Statements

for the school system

01/2007 - 11/2008 General Motors Corporation, Warren, MI

Outbound Vehicle Logistics-Freight Audit and Payment Analyst

* Responsible to audit & pay Intercontinental and North American

outbound vehicle freight invoices and payment requests, analyze

data and resolve payment issues

* Worked with GM logistics buyers and logistics operation department

to resolve payment discrepancies

* Analyzed financial reports for the department, follow up on the

recommendation for analyzed data (Excel, Access, VBA, Crystal

Reports)

05/2006 - 01/2007 RYDER, Farmington Hills, MI

Business Analyst (Logistics)

. As a liaison between the business and technology group, designed

and implemented GL Coding Project (for VISTEON financial department

tracked freight payments),

. Closing cycle process between Premium Freight and Supplier Debit In

Access, VBA and SQL, Transfer Access DB to SQL 2005 by using VB

. Responsible for maintenance and support application (Supplier Debit

Report, Premium Freight, GL Coding Changes)

. Perform Database maintenance and assist clients (VISTEON and RYDER)

with integration of application, creating user Guide for new

projects

. Created ad-hoc reports in Excel (data extraction/manipulating,

Pivot tables and Vlookup function) for multiple clients.

03/2006-05/2006 Arrow Uniform LLC, Taylor, MI

Tax Analyst

* Registration and compliance for Sales and Use Tax in multiple

states

* Researching for Sales and Use Tax software compatible with existing

Accounting applications

* Created Sales/Use Tax documentation for training purpose

11/2004 - 01/2006 DELPHI, Troy, MI

Business/Financial Analyst (Tax Processing Department)

* Provide Tier 3 support of all Tax Applications, perform triage of

production problem, and assist with integration, QA and user

acceptance testing. Assist clients with data extraction,

manipulation and reporting ensuring continue meeting of key

deliverables.

* Contact International DELPHI division for technical support and

resolve problems with CorpInternational and FDC applications

* Responsible for domestic and international tax research on various

tax issues

* Responsible for support and maintenance of applications including

but not limited to CorpTax, CorpInternational, FDC, SharePoint,

eCompl and VERTEX ( for Sales and Use Tax Department ). Analyze

system databases, participate in testing and review of SOX

documentation, create and perform date-to-date database maintenance

in SQL and Access, data modeling and creating SQL

scripts/procedure/function per user request.

* Design and implement custom applications using Visual

Basic/SQL/Access.

* Create VBA front-end and VB code for customers using MS Excel

(heavy used Excel functions- Vlookup, data extraction/data

manipulation, Pivot tables)

6/2003 - 11/2004 Varilease Technology Finance Group, Inc, Walled Lake, MI

Accountant - Tax Specialist (Sales and Use Tax)

* Sales and Use tax for over 40 states (researching, registering

business in other states, review sales/use tax, creating reports

monthly and quarterly, e-filing, financial analysis and reporting).

10/2002 - 5/2003 L. BORCHENKO, C.P.A, PC, Farmington Hills, MI

In Charge Accountant

* Prepared Trial Balance, Balance sheet, and Financial Statements for

multiple clients

* Tax preparation (Individual Income Tax, C Corporation and S

Corporation, Individual Tax)

8/2000 - 1/2002 LASON, Inc. Troy, MI

Business/Financial Analyst

* Back-end support for financial applications Platinum 4.2a and

Epicor 7.0b (eBackOffice) by using T-SQL (creating stored

procedures, queries and scripts to fix users problems in GL, AR,

AP, Inventory, Fixed Assets)

* Involved in upgrade of databases to Platinum 4.2a (Cyber and Excel)

* Responsible for technical and financial application support and

maintenance (GL, AP, AR, Inventory)

* Created technical specifications in eEpicor 7.0b (eBackOffice)

based on

business requirements provided by accounting department

* Customize intelligence Explorer per user request (module of eEpicor

7.0b) by using Crystal Reports

* Implemented business requirements and evolve them into technical

systems for developers

EDUCATION

Mott Community College, Flint, MI 1993 - 1994

Courses: Financial Accounting

Odessa State University, Odessa, Ukraine 1984

BS in Accounting

PROFECCIONAL CERTIFICATIONS

New Horizons, Troy, MI 2011

Certificate: Lean Six Sigma Black Belt

New Horizons, Troy, MI 2010

Certification of completion Project 2007,

Certification of completion Office 2007/2010,

Certification of completion PMP Applying Project

Management Methodology,

Certification of completion Project Teams,

Certification of completion Project Scope and Time

Management, Certification of completion Project Risk

Management

H&R Block

2002

Certification of Accomplishment Income Tax Course

New Horizons, Troy, MI 2000

Certification in Programming with SQL

7.0

Certificate of completion Access 97 to

Access XP,

Excel 97 to Excel XP

CompuNet Continental, Inc., Southfield, MI 1997

Certification in programming with Visual Basic and MS Access

REFERENCES: Available upon request

LANGUAGES: Russian, Ukrainian

Contact this candidate