Uploaded File
Alexey
alexeypanphilov@gmail.com
415-260-5212
Mountain View, CA 94035
Core/Back-End Java Developer
13 years experience W2
0
Recommendations
Average rating
42
Profile views
Summary

15+ years IT experience, including:

  • Java programming
  • core and back-end: JDBC, XML, JMS, JPA, concurrency et al.
  • Developing ETL, ORM, business logic, algorithms, and data structures
  • SQL, PL/SQL and T-SQL programming for Oracle, SQL Server, MySQL and other RDBMSs
  • Developing highly normalized data models for ODS and DW as well as dimensional ones for data marts for various subject areas (health care, financial, retail et al.) while facilitating JAD sessions with SME and implementing all the phases of database design: determining data rules, creating conceptual-, logical
  • and physical data models
  • Developing unit, performance and integration test plans and cases
  • for most projects below

Experience
Backend Developer
Information Technology
Jul 2019 - present
Sunnyvale, CA

Developed backoffice application for batch processing for Live Financial Help business:

  • Designed the API
  • Designed the database
  • Developed incoming file names and their content processing in AWS Lambda concurrent environment
  • Implemented AWS S3 buckets KMS-encrypted data transfer to Salesforce, DB and client application endpoint
  • Created Jenkins pipeline for CI/CD
  • Developed unit, performance and destructive tests
  • Completely docummented the application
  • Wrote a troubleshooting manual Environment: Java, SQL, Amazon Aurora, MySQL, RESTful API, JUnit, GitLab
AWS Continuous Deployment Continuous Integration Gitlab Java Jenkins Junit MySQL Salesforce SQL REST
Remove Skill
Software Developer
Sep 2014 - May 2019
Vienna, VA
Developed batch processing features of a Bill Pay system and data migration in a data warehouse:
  • Developed the Batch Framework
  • a reusable object-oriented packages allowing to develop batch processes with minimal effort
  • Developed ETL processes based on the Batch Framework and also for migrating data from ODS to DW and from DW to DM
  • Designed and implemented algorithms and used concurrent approach to decrease times of data processing
  • Designed test cases, wrote tests, found and fixed bugs
  • Provided technical support and training
  • Prepared specifications and manuals about the systems Environment: Oracle DB, PL/SQL, Java, Hibernate, Eclipse, JUnit, Enterprise Architect
Data Warehousing Eclipse Enterprise Architecture ETL Hibernate Java Junit Oracle SQL PL/SQL
Remove Skill
Sr. Software Engineer
Nov 2011 - Jun 2014
Santa Clara, CA
Developed a Workforce optimization system; particularly Work Allocation Management and Forecasting and Scheduling subsystems
  • Designed and implemented algorithms for optimal work allocation and other tasks
  • Designed and implemented work tasks filtering by many criteria
  • Utilized linear programming for calculating optimal work load proportions in work flows
  • Wrote ETL adapters to import data from external systems in JSON, XML and other formats
  • Found and fixed a lot of defects Environment: Java EE, SQL Server, Microsoft Visual Studio, IntelliJ IDEA, Eclipse, HP Quality Center
Eclipse ETL J2EE Java JSON Software Engineer SQL SQL Server Visual Studio XML HP QC OPTIM
Remove Skill
Software Engineer
Apr 2011 - Oct 2011
Milpitas, CA
Developed the Cisco TelePrasence managing system:
  • Fixed bugs reported by QAs and discovered by myself
  • Developed utilities for simplifying bug fixing
  • Elaborated an algorithm for generating random values out of available subsets Environment: Java SE 6, Informix, SVN, Linux, Eclipse
Cisco Eclipse J2EE Java Linux Software Engineer SVN
Remove Skill
Software Engineer
Oct 2009 - Mar 2011
Sunnyvale, CA
Developed an application for processing media data and assembling them into presentations:
  • Carried out research among available Java media processing technologies
  • Designed the architecture of the application
  • Elaborated ad hoc data structures and algorithms; utilized merge sorting of media frames for timed media streams processing; ensured multiple threads synchronization. Environment: Java, StAX, JMF, ffmpeg, xuggler, red5, MySQL, Adobe Flex, Eclipse, Linux
Adobe Flex Eclipse Java Linux MySQL Software Engineer C++ C# AWS
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Physics
National Research Nuclear University (former Moscow Engineering Physics Institute), 1982 - 1988
Skills
Eclipse
2019
9
Java
2021
9
ETL
2019
7
SQL
2021
7
Junit
2021
5
PL/SQL
2019
5
Data Warehousing
2019
4
Enterprise Architecture
2019
4
Hibernate
2019
4
Oracle
2019
4
Software Engineer
2014
4
HP QC
2014
3
J2EE
2014
3
OPTIM
2014
3
AWS
2021
2
JSON
2014
2
MySQL
2021
2
REST
2021
2
SQL Server
2014
2
Visual Studio
2014
2
XML
2014
2
Adobe Flex
2011
1
C#
2011
1
C++
2011
1
Linux
2011
1
Ant
0
1
Apache
0
1
Cisco
2011
1
Continuous Deployment
2021
1
Continuous Integration
2021
1
Data Marts
0
1
Data Modeling
0
1
Database Design
0
1
Design Patterns
0
1
Gitlab
2021
1
iSQL
0
1
JDBC
0
1
Jenkins
2021
1
JMS
0
1
JPA
0
1
Maven
0
1
OOP
0
1
Salesforce
2021
1
SVN
2011
1
T-SQL
0
1
UML
0
1
Unified Modeling Language (UML)
0
1
UNIX
0
1