SUMMARY:

• Java programming - core and server side: JDBC, threads, sockets, XML, JMS, JPA 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 every project below

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Software Engineer

Responsibilities:

• 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
• Prepared documents about the system

Environment: Oracle DB, PL/SQL, Java, Hibernate, Eclipse, JUnit, Enterprise Architect

Sr. Software Engineer

Responsibilities:

• 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

Software Engineer

Responsibilities:

• 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

Software Engineer

Responsibilities:

• 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

Software Engineer

Responsibilities:

• Developed ETL architecture and logic of the project and implemented them using XML marshalling/unmarshalling (SAX parsers, JAXB, XStream, serialization, reflection), business objects and their managers, POJOs, DAOs, O-R and XML persisters
• While business requirements changed, upadted the loader DB metadata
• Designed and implemented files and messages interchange architecture between Nielsen subsystems utilizing multithreading, JMS, FTP, NIO, regex and Tibco EMS
• Analyzed outputs of the loader; wrote many complex SQL queries, SPs and JDBC modules for disclosure of discrepancies in loaded data; promptly provided patches and fixes
• Prepared intranet documentation providing detailed description of all the features and configuration parameters of the application and giving recommendations to QA

Environment: Java, Hibernate, Tibco Suite, GlassFish AS, JUnit, log4j, Oracle, PostgreSQL, PL/SQL

Software Engineer

Responsibilities:

• Designed the architecture of the application
• Used XML-RPC and REST clients for communicating with Pikeo and Mob-it
• Developed the DB schema and implemented storing the communication status.

Environment: JDK, Hibernate, JUnit, log4j, MySQL, JRun, Eclipse, SVN

Software Engineer

Responsibilities:

• Fixed bugs in Java code and made data/metadata fixes in the database
• Implemented new features (concurrent notifications processing, instrument editing)

Environment: JDK, Eclipse, JUnit, MySQL, Linux, Perforce, Maven

Software Engineer

Responsibilities:

• Implemented persistence POJOs using using JPA and Hibernate
• Wrote views filtering/aggregating/linking data for simplifying the persistence layer
• Made corrections to the database schema
• Developed ETL processes

Environment: JDK, Hibernate, JUnit, Oracle DB, HSQLDB, Toad Data Modeler, ERwin, Maven, Jetty

Software Engineer

• Carried out research for persistence technology that provide platform-independent CRUD of the data and could be used for development under stringent timelines
• Designed and implemented the persistence layer and its MVC interface with other components of the application
• Cteated the data model for the operational database which included 120 entities
• The entire development process was iterative and agile, though carefully documented as far as Bayer’s software is classified by the FDA as a medical device

Environment: Java, Hibernate, Derby, MySQL, ERwin, JReport, log4j, JUnit

Software Engineer

Responsibilities:

• Contributed in creation of the client's DB model and the class diagram of the application
• Implemented object-relational persistence and mapping persistent entities and criteria objects of the client to the web services objects

Environment: ERwin, Rational Software Architect, Rational Data Architect, Hibernate, Cloudscape, JUnit

Software Engineer

Responsibilities:

• Developed a dimensional model for the data mart
• Developed sophisticated SQL/DDL scripts and stored procedures for data migration
• Developed code that parses and runs SQL scripts and processes the results and errors
• Developed XML-configurable functionality for the data import/export features.
• Conducted troubleshooting bug fixing support for the initial period

Environment: J2SE, Eclipse, Oracle DB, PL/SQL, ERwin, UNIX AIX, KornShell

Software Engineer

Responsibilities:

• Carried out all phases of SDLC for mission critical, foolproof POS and Inventory Management applications including identifying and formalizing business needs, data modeling, object-oriented analysis and design, creation of reusable components and libraries
• Developed a proprietary distributed real-time transactional point-of-sale system compatible with JavaPOS standard
• Developed a bonus system (CRM) to stimulate Estee Lauder and Clinique customers
• Wrote an in-house program for calculating vacation, disability and other time off of the company staff for the F.I.T. HR department
• Elaborated data synchronization between DW and ODS using replication technology
• Developed interfaces with terminal devices for the retail industry (cash registers, portable scanners, scales, bar-code printers, etc.)
• Developed data migration utilities between F.I.T. systems and systems of other companies

Environment: Java, Delphi, C++, Oracle, SQL Server, MySQL, TopLink, ERwin, PowerDesigner, ER/Studio