*** ********** **. **** ********
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.