Resume

Sign in

Data Analyst

Location:
White Plains, New York, United States
Posted:
June 13, 2018

Contact this candidate

Resume:

*** ********** **. **** ********

White Plains, NY 10607 Tel: 917-***-**** ac5vej@r.postjobfree.com

Objective: To obtain a challenging position that would utilize my experience in Data Analysis.

Summary: Over twenty years of extensive experience in Business Analysis, Projects Managing and Computer program development. Use Data Cleansing and Data Profiling to provide accurate reports.

MS SQL Server, Sybase SQL Server, MS Access and Microsoft Office, Younique PLM. Good communication skills combined with problem solving abilities and technical proficiency.

Skills: Hardware: IBM PC and compatible

Operating Systems: OS2, Windows NT 4.0, Windows95, 98, Me, XP, 2007, 2008 and 2010

Software/BI: VB. NET 2010/2016, MS Office 2007-2016, ODBC API, COM, ActiveX controls, third-party controls for VB.NET, Quattro Pro 5.0, Pascal, Lotus 1-2-3, Crystal report 8.0, HTML, Excel advance functions, pivot table and macros, QlickView

Database Tools: MS SQL Server 2005 -2016, Datawarehouse database, Sybase SQL Server 11.0, MS Access 2010-2016

Experience:

9/2017 – current Henkel

Business Intelligence and Data Management

Create process for migrating data to SAP application

Design Report Tracking Application that allows users to keep track of reports

Manage data process for new Environment.

Convert Excel applications to Access

Participated in Forecasting using Excel functions such as Vloockup, IFsums, match, index and so on as well as Pivot tables and charts.

11/2016 - 08/2017 Endurance Insurance holding, Purchase NY

Business Analyst/Data Analyst

Created complex queries for Claim reports using company DataWarehouse database.

Analyzed, Designed and Implemented procedures that allowed company to move from old system to new environment

Provided data comparison for data architect group

Created tables, views, SSIS package to support new data structure

Validated data processes and compared data sources

09/07 – 11/16 Triboro Quilt Manufacturing

Senior Developer/Data Analyst/Business Analyst

Deeply involved in various projects which required Data Analysis, designing and implementing data processing as well as documentation

Involved in full life circle of design, developing and implementation of various web applications for internal needs

In charge of company’s DBs and DataWarehouse

Created data migration procedures, which allowed to migrate data amongst different platforms and Databases such as AS400, MS SQL 2005,2008 and MS Access

Project leader for outside applications (WebFocus, QlickView, PLM, ESPS, Younique PLM, Dynamics and ERP). Provided support, service, and communication with vendors

Architecture data structure for different reports that have been frequently requested by Finance, Sales, and Executive Departments

Created various Crystal reports

Provided technical assistance to co-workers

Participated in restoring DBs, recovering network issues and removing viruses from servers

Helped Finance Department with creating Financial reports.

Application designed in VB.net 2010/2013 (MS Visual Studio), MS SQL 2005 and 2008, MS Office 2007 and 2010, VBA for application, Webfocus7.8 with Data Management tools and Crystal Report, QlikView

7/03-09/07 Volt Inc/Procurestaff Inc

Senior Audit Data Analyst

Developed Auditing Reports for Billing, Accounting, upper Management, MSP, VMO.

Created numbers of reports that handled Invoices, Time Cards and Vouchers.

Re-wrote Sales Trend Report that showed money flow weekly and monthly

Re-developed weekly Reports that analyzed and displayed all information received during the week

All reports were written in Excel using VBA and Excel’s macro, SQL Stored procedures and DTS packages, Access database.

6/00 – 7/03 Lockheed Martin IMS, Tarrytown, NY

Senior Programmer Analyst

Participated in developing applications for Child Support. These applications allow different states to receive money via Electronics, Phone, Credit Card, etc. and send them to the payment process center.

Validated Flat File against our database and insert correct records into tables.

Designed and tested application that processed flat file and transferred it to Data Base through full Data validation, which lets users balance, edit, and delete records

Created standard reports

The applications were written in Visual Basic 6.0; MS SQL Server 7.0 & 6.5; Access 2000; RDO and ADO 2.5

4/97 – 6/00 District Attorney, Brooklyn, NY

Computer Programmer

Involved in full circle of developing, coding, implementing and designing applications internally for Criminal Justice department (Domestic Violence, Technical Services, Alternative Sentence, etc.). The applications allow a particular department to manage and monitor their needs depending on requirements and conditions.

Designed a few applications with full data/time validation, debugging, testing. Applications used ADO control

Developed Database for different project with tables, stored procedures, queries for Access

Created a number of standard project status reports using Crystal 7.0.

The applications were written in Visual Basic 6.0, Access 97, MS SQL Server 6.5. The applications used Sheridan Design & Data control and Crystal Report 6.0-7.0.

1993-4/97 Mercy College, NY

Computer Class Instructor

Conducted laboratory classes in Quattro Pro for Windows, Lotus 1-2-3.

Assisted students in development of various projects using Pascal, Quattro Pro for Windows.

Responsible for installation and testing of hardware and software.

Education:

1980-1986 Lugansk University, the Ukraine.

Degree: B.S. Electronic Engineer

Minor: Computer Science

1994-1995 Mercy College, NY

Computer Science courses

1999Microsoft Approved Course

Mastering Microsoft Visual Basic 6.0 Development

References Available upon request.



Contact this candidate