Designs and develops complicated Transactional and Business Intelligence databases for Aviation industry. Implemented company database migration process from OrientDB to PostgreSQL.Technology used: ER/Studio Data Architect , PostgreSQL, OrientDB, PL/pgSQL, Python

Designed and developed company Business Intelligent system for Human Resources industry. Data Warehouse design and ETL development.Technology used: ER/Studio Data Architect , SQL Server, SSMS, T-SQL, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake, U-SQL, Power BI, SSAS

Database design, development, maintenance, performance tuning for the startup in the wellness and healthcare industry. Performed DBA responsibilities for all database instances. Developed and implemented migration from old medical diagnoses and procedures coding system ICD9 to the new ICD10. Worked on migration from Oracle to PostgreSQL. Technology used: Oracle, PostgreSQL, SQL Server, SQL, PL/SQL, PL/pgSQL, Perl, PowerShell, Oracle Developer, PgAdmin, SQL Power Architect

Logical and physical database design for Enterprise Data Warehouse and OLTP systems. Integration and ETL processes design and development. Leading role in the database performance. Mentor role for database developers. Metadata management. Technology used: Oracle, Greenplum, PostgreSQL, SQL Server, SQL, PL/SQL, PL/pgSQL, Informatica, Erwin, ERStudio, Perl, Java, Spring, Spring Batch

Led the data design for new Claim Rewrite project. Developed all physical database design, took active part in conceptual and logical design, participated in requirement gathering. Provided technical leadership and direction to software developers in the design of database objects and SQL performance tuning. Defined and enforced standards and conventions. Managed the data dictionary/metadata. Maintained all versions of logical and physical data models for production, test and development databases.Designed and developed the Audit/History database and synchronization mechanism. Designed ETL approach for refreshing Active Data Warehouse. Developed and supported Data Recovery procedures. Had regular DBA responsibility for many databases: maintenance, performance tuning, backup and recovery policy and implementation, troubleshooting.Technology used: Oracle, SQL, PL/SQL, Erwin, OEM, RMAN

Was responsible for building the logical and physical model of the Data Warehouse including staging area, dimensions and fact tables; development of procedures for initial creation and refresh (ETL) of Data Warehouse; monitoring and tuning of Data Warehouse performance including applications, queries, database, operating system and network; writing complex reports and queries; assessment current systems data; evaluation multiple data sources; providing data for external businesses in different formats; assistance with legacy data sourcing, extraction, transportation, loading; assistance with query tool administration.Was involved in Claim Rewrite Project as a Data Modeler/Architect.Technology used: Oracle, SQL, PL/SQL, Erwin, Oracle Warehouse Builder

Worked on the MIS (Management Information System) project at Delta Dental Plan of Michigan. Was a mentor for the local DBA team. Supported several production and development databases. Was responsible for daily maintenance, backup and recovery planning and implementation, performance tuning, resources planning and management, evaluation of hardware and software requirements for the Data Warehouse.Took part in logical and physical modeling of the Data Warehouse database. Created the first pilot version of the Data Warehouse. Was involved in initial data load from the IDMS database to the source Oracle database (raw database) and in daily refresh of the raw database from IDMS.Technology used: Oracle, SQL, PL/SQL, Erwin, Oracle Warehouse Builder

Logical and physical database design for Enterprise Data Warehouse and OLTP systems, integration and ETL development, reports and analytics, performance tuning and scalability.