Sales Project
Resume:
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, 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)
• 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/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 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/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 –functions, cubes and macros, 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 (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 Access
REFERENCES: Available upon request
LANGUAGES: Russian, Ukrainian
Contact this candidate