Sales Analyst

Resume Login

Search for: Jobs Resumes

Keywords or title City, state or zip code

Sales Business Analyst Project Financial Maintenance

Post jobs

Country: United States

State: Michigan

City: Madison Heights

ZIP: 48071

Salary: 55000.00

Posted date: 4/25/2012

Posted by: Irina Leen

Email: ******@*.***********.***

Contact Info:

Show Contact Info Send Message Free

Email me new resumes like this

Email

Resume Text:

Need to

promote your job postings

even more?

Subscribe

to

PostJobFree

Premium Membership!IRINA LEEN

Madison HTS, MI ***71

248 cell

******@*.***********.***

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, eComply, ePreProcessor, CCH Research, FDC,

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

Plains, VERTEX, AccountAblility, InSource, 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, HyperionPROFESSIONAL EXPERIENCE

04/2011PresentBack 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)

Collect information and transfer it to the presentation reports and graphs

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

for analyzed data by using Cubes, Pivot tables and macros

Consolidate weekly and monthly reports in the company web side (dashboard application)

Implemented business requirements and evolve them into technical systems for developers

Create reports per user request (data extracting/manipulating)

06/201009/2010Consultant at NETSTAR, Bloomfield Hills, MI

Business /Systems Analyst

Analyzed application for Ann Arbor Transportation Association, create/modify reports,

debug system errors (Access 2007, Excel macro, functions, P-tables and formatting, 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/200908/2009E.Richardson, CPA, Southfield, MI

Auditor/Accountant Analyst/

Detroit Public School: audited and analyzed Financial Statements for the school system

01/200711/2008General 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 functions, cubes and macros, Access, VBA, Crystal Reports)

05/200601/2007RYDER, 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/2006Arrow 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/200401/2006DELPHI, 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/200311/2004Varilease 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/20025/2003L. 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/20001/2002LASON, 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 19931994

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 (Excel, Word, PowerPoint)

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 AccessREFERENCES: Available upon requestLANGUAGES: Russian, Ukrainian

Show Contact Info Send Message Free

Similar Skills

sql resumes in

Grand Rapids, MI

sharepoint resumes in Grand Rapids, MI

sales resumes in Big Rapids, MI

qa resumes in Grand Rapids, MI

analyst resumes in Grand Rapids, MI

analyst resumes in Big Rapids, MI

sql resumes in Traverse City, MI

sabrix resumes

international tax resumes

pivot resumes

hyperion resumes

vertex resumes

financial analyst resumes

buyers resumes

ppt resumes

intercontinental resumes

Similar ResumesBusiness Analyst Project Management Data Manager

Wyncote, PA - oms, ba qa, funding, database design, index

Customer Service Manager Assistant Quality Assurance

Olive Branch, MS - charleston sc, trident, assistant director

QA Analyst, Tester

Canada, Toronto, ON - life cycle, hong kong, kong, oracle soa

mainframe QA Analyst

United States - php, mq, j2ee, tester, db2, bms, developer, qa

Business Analyst/QA

Iselin, NJ - loan modification, enhancement, subject matter

Qa analyst/tester

United States - xls, qtp, etl, cyber, csharp, hyderabad, vbscript

QA Analyst

United States - teradata, noida, gurgaon, scrum, qtp, sharepoint

Sr QA Analyst

United States - qtp, virtualization, ui, hyperion, waterfall, java

Business Analyst

United States - informatica, tibco, csharp, mq, aspnet, java

c2012 PostJobFree.com - Home - Latest Resumes - Post Job

Contact this candidate