Business Intelligence, ETL, Data Analytics, R, T-SQL, SSMS

Natalia Kutova

Phone:

(*** ***- ****

Email:

acuelf@r.postjobfree.com

Professional Summary:

Experience in Business Intelligence, ETL process, data analysis, data mining, database analysis, test cases development, quality assurance, business process reengineering, software testing and implementation, with strong business/domain knowledge of Banking and Finance/Accounting.

Technical Skills:

Programming Languages Python (basic), Visual Basic, R BI Tools Tableau,

SAS

Analytics,

MicroStrategy,

Halo

Prism Databases T- SQL,

MS

SQL

Server,

ERD Data Analysis SSAS,

ETL,

SPSS,

MS

Excel,

MS

Access,

XLMiner,

Weka data

mining

tool

Other MS

Visio,

MS

Project

Halo Business Intelligence, San Diego, CA

Role: Business Intelligence Support Specialist 10/2014- Present Responsibilities:

• Extracted, transformed and loaded data from various data sources to the staging database, defined measures and dimensions for OLAP cube.

• Developed DW Bus Matrix for Business Intelligence products.

• Developed requirements for financial dashboards.

• Implemented a Business Intelligence program to improve dashboard and analysis capabilities.

• Developed demand forecasting model for retail clients.

• Reviewed data for accuracy, redundancy, and mining.

• Reviewed technical documents, executed steps listed in the documentations and verified if the steps are in logical sense.

• Reviewed requirements for testability and usability; consulted development staff with regards to system functionality.

• Conducted software QA cycle to verify and assign bugs.

• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.

Swenson Advisors, LLP - Accounting Firm, San Diego, CA Role: Business Data Analyst/Accounting Assistant 10/2010 – 6/2014 Responsibilities:

• Assisted in performing audit and financial statement preparation.

• Performed marketing data analysis and reports.

• Performed customer data analysis to ensure effective marketing campaign.

• Analyzed

client

database

and

identified

potential

target

market.

• Reconciled inter-company accounts data.

• Analyzed large data sets, perform data mining, develop tables, and construct graphs and charts with statistical data using advanced Excel techniques to develop reports.

World Trade Center San Diego, San Diego, CA

Role: Finance/Accounting Data Analyst Intern 4/2010 – 10/2010 Responsibilities:

• Performed customer data analysis to ensure effective marketing campaign.

• Assisted in performing audit and financial statement preparation.

• Prepared expenditure reports, account reconciliation, and journal entries.

• Assisted in month-end and year-end close.

• Responsible for timely processing of accounts receivable/payable. ING Bank Ukraine, Kiev, Ukraine

Role: Business Analyst/Credit operations officer 3/2008 – 2/2009 Responsibilities:

• Applied various data analytics models in fraud detection and prevention.

• Responsible for timely processing of accounts payable.

• Analyzed database to determine and evaluate loan credit risk.

• Participated in the project on the retail banking products implementation.

• Worked directly with Quality Assurance and Development team to write and develop test cases for banking software implementation. PJCS Universal Bank, Kiev, Ukraine

Role: Back-office Processing Senior Officer 7/2007 – 3/2008 Responsibilities:

• Prepared nonperforming loans analysis and monthly reports.

• Prepared, examined, and analysed accounting records.

• Participated in SAP implementation project.

• Provided support to the QA and Development team during the development phase.

Platinum Bank Ukraine, Kiev, Ukraine

Role: Back-office Operations Manager 12/2005 – 7/2007 Responsibilities:

• Provided support for internal and external auditors

• Analyzed loan portfolio and evaluated risk associated with lending

• Prepared monthly and year closing reports

• Prepared, examined, and analysed accounting records

• Analysed ERP system and implemented improvements

• Worked with development team during ERP upgrade

Education:

MS Information Systems (2013 – Exp. May 2016)

(Data Analysis, Accounting)

San Diego State University, San Diego, CA

Certificate, Data Mining (2014 – Exp. Dec 2015)

University of California, San Diego, CA

Master of Business Administration (Nov 2011)

(International Business)

Southern States University, San Diego, CA

Bachelor in Finance

Kiev National University, Kiev, Ukraine (May 2007)

Contact this candidate