Software Engineer Data Analyst

BORIS SAPOZHNIKOV

Lincoln,RI

***** *-****: *********@*****.***

Cell: 401-***-****

Senior software Engineer /Data Analyst with 20+ years experience in the IT field developing systems for a wide range of business applications.

Expertise includes:

Proficient understanding of Software Development Life Cycle(SDLC)

Ability to work in Scrum/Agile style

Strong data and business analysis skills with attention to details

Comprehensive knowledge of Complex Data Modeling/Entity Relationship Modeling and Design

Successful at solving practical problems in a proactive and realistic manner

Proficient at organizing tasks and meeting critical timelines.

Programming Languages SQL Loader, SQL, Transact SQL, SQL*Plus, PowerBuilder, PHP, HTML, CSS, Ajax JQuery

Databases: SQL Server, MS Access, Watcom SQL, ORACE 8.0

Sybase SQL Anywhere Interactive, MySQL

Platforms: Windows NT, UNIX/Linux

Software: TOAD, Erwin, SQL Developer, SQL Navigator, Rapid SQL, TFS, SQL Server Integration Services (SSIS), MSWord, Excel, MS Project, CVS, SVN

Rehab at Home 3/2017 to 02/2019

Fall River, MA

Senior software Engineer /Data Analyst

Participate in mass Data conversion from external Application to

internal database.

Communicating with the clients from other departments, summarize the requirements, providing management with the time and effort estimation.

Improving data processes creating SQL functions, stored procedures.

Coordinated system test & reviewed test results

Optimizing MySQL DB queries, tuning SQL for improving performance,

creating indexes

Improving data processes creating generic functions/objects for different business tasks

Therapy Resources Management 3/2002 to 03/2017

Fall River, MA

Senior software Engineer /Data Analyst

Working with Big Data

Creating complex SQL queries with lots of Joins to get the desired data

Process data through analytical Milliman Grouper application

Creating Risk Factor reports

Acquire, manage, manipulate, and analyze data and report results.

Identify problematic areas and made research to determine the best course of action to correct the data. Analyze and solve issues with current systems, processes, and data feeds.

Support the process of loading data from Excel to Oracle

and Ms Access DB

Oracle database programming using Partitioning, Materialized Views

Create and update process and workflow documentation

Cross-Country Group 05/2000 to 10/2000

Medford, MA

Senior Programmer/Analyst

Developed and implemented new module for existing Roadside Application

Recommended and implemented various Enhancements and bug fixes

Was responsible for Productions support through out my stay with the company. Improving data processes creating SQL functions, stored procedures.

Creating Risk Factor reports

Newcourt 06/1999 to 05/2000

Westborough, MA

Senior Programmer/Analyst

Senior Programmer/Analyst for the Customer service applications designed to Collect charges, billing information and print Invoices for International Leasing Company. This software products uses Power builder as the front –end GUI and Oracle Database as the back-end.

Designed and develop new GUI for companies online report system

Created scripts using SQL Loader to transfer data from text files and Excel files to Oracle database

Created and ran custom reports using Variable Billing Application for internal users

Implemented Enhancements, bugs fixes

Was responsible for productions support for Co. Applications (Variable Billing, Collection, Flex Invoice)

Suggested and implemented code changes that tuned the application and made it customer user friendly

Implemented new business rules defined by marketing department.

Kayak Lab, Inc. 03/1993 to 11/1996

Providence, RI

Independent Consultant

Designed and developed new GUI for a client/server Application (Purchase Order System)

Build and extend class libraries

Performed Customer support and integration of the application software

Wrote reports

Tuned/optimized SQL

Analyzed and improved GUI performance

Fixed application defects and unit tested it

Smith Barney Inc. 02/1992 to 10/1992

New York, NY

QA Engineer

Performed Beta Testing & Beta II testing for Mutual Fund Companies

Created test plans

Coordinated the system test & reviewed test results

The Research Institute of Organic Synthesis 08/1986 to 01/1990

Odessa, USSR

Researcher

Designed data analyst and number of others programs

Designed several databases to help collect and analyses the data for different scientific project.

Performed statistical Analysis

D+H (formally Davis + Henderson Intercheques) 1996 – 2012

North York, Ontario

Software Developer/Analyst

Performed Modeling/Schema design for Oracle DB

Transferred data from Oracle DB to SQL Server DB and to MS Access

Developed PL/SQL scripts for complex business requirements through analysis, design, development, testing, debugging and documentation phases. Scripts included Oracle procedures, functions packages, triggers

Created scripts using SQL Loader to transfer data from text files and Excel files to Oracle database

Reporting to the Development Manager, designed, developed and maintained D+H applications using PowerBuilder as a GUI and SQL SERVER and Oracle as a backend.

Created UNIX Shell scripts for Job Scheduler

Development process using PowerBuilder included:

-Creation of Ancestors and User Objects using Object Inheritance.

-Designing PowerBuilder GUI (windows, datawindows, user objects)

-Database access included dynamic SQL

Migration from PowerBuilder 4.0 to 5.4, 5.4 to 9.0.

Performed database tuning and optimization (schema and SQL)

Worked closely with Quality Assurance group assisting in creating test plans, test cases and test execution

Designed, developed and implemented Revenue System Reports

using SQL*Plus and PL/SQL

B.S. in Civil Engineering Odessa Polytechnic Institute Odessa, USSR 1981-1986

PowerBuilder Foundation Classes Sybase learning Center Burlington, MA 1998

Adaptive Server Enterprise 11.5 Sybase learning Center Boston, MA 1998

Advance Computer Program InfoLab Computer Center Boston, MA 1996-1997

Studies in Computer Graphics Rhode Island College Providence, RI 1992-1993

English Language Studies Brown University Providence, RI 1991

Reference furnished upon request.

PROFILE

TECHNICAL HIGHLIGHTS

EMPLOYMENT HISTORY

EDUCATION AND PROFESSIONAL TRAINING

Contact this candidate