Обо мне

My name is Andrey Efremov and i am working as Oracle PL\SQL Developer at Luxoft.

I have 4+ years experience in PL/SQL development and Oracle performance tuning.

I am Oracle Certified Associate(OCA) and Oracle Certified SQL Expert.

I am interested in all long- and short-term projects all around the world and ready to relocate.

My past tasks covered for instance administrative and support activities in IT, data migration tasks and IT service management.

I have deep understanding of DWH\ETL\BI processing and Telecom BSS\OSS domain (Billing Systems, CSM, CRM, Mediation, Provisioning etc)

Technical skills:

- Languages: PL\SQL, R, Python, Bash\sh\ksh, XML

- Repository - CVS, SVN, GIT

- Deployment tools - uDeploy, VHS

- Unix - (Solaris, RedHat)

- Monitoring - GENEOS, NAGIOS

Профессиональные навыки
OracleEtlLinuxSQL
Опыт работы
Ведущий поставщик услуг в области разработки программного обеспечения и инновационных ИТ-решений
Oracle Developer
Январь 2016 — По настоящее время (3 года и 7 месяцев)
Project: Development for Deutsche Bank Financial Data Werehouse(STRIDE). Duties: - Perform all aspects of development life cycle including design, development, unit testing and documentation. - Troubleshoot and resolve production-related issues as they arise. - Create, troubleshoot and perform tuning on complex SQL, and PL/SQL queries.
Deployment Engineer
Апрель 2015 — По настоящее время (4 года и 4 месяца)
∙ Manage and perform application deployments and releases to Production, UAT and SIT systems across several technologies (Oracle, Java, Microstrategy) -Deploy metadata, packages and scripts to Oracle database and SAS engines using Udeploy. ∙ Coordinate deployment activities across several stakeholder teams, implement deployment plan and control its execution ∙ Communication with development and SL3 teams ∙ Environment configuration and releases performing - Troubleshoot Oracle\​bash scripts ∙ Issues root cause analysis, workaround search, solution proposal and estimation.
Входит в группу компаний «ВымпелКом Лтд», которая является одним из крупнейших мировых операторов связи
Amdocs CRM Administrator (Technical Support Engineer Tier2)
Ноябрь 2013 — Март 2015 (1 год и 5 месяцев)
Achivements: -Succesfully created a new monitoring mechanism (using VBA,PL\SQL,curl+NAGIOS) that prevented periodical critical authentication problems due to the problems with Microsoft IIS. -Succesfully planned, coordinated and performed migration of data storage from one cluster to another without any outages. -Succesfully planned, coordinated and performed migration of data storage from Windows cluster to Linux without any outages during system transformation. Day-to-day duties: -Administering and tuning of Amdocs Clarify CRM. -Support system users (ITIL 2 level). -Drive on defects of system. -Create PL\SQL scripts and procedures in order to modify data within system database if needed(DML). -Preparing and installing the system releases and patches. -Support and development of monitoring system (NAGIOS). -Support documentation relevance. - Support UAT, DEV environment (DML\DDL eg. add partitions, indexes, alter tables, grant previleges etc) -Configure SIT environments in order to integrate them with other systems (Glassfish, E-commerce, Campaign Management etc..) -Initiate activities to analyze and address the identified problems in the CRM-system. -Examine possible workarounds and escalate if required. -New CRM version implementation\migration activities.
Senior specialist.Technical support DPT - KEY customers support.
Февраль 2007 — Май 2010 (3 года и 4 месяца)
Technical support of KEY customers, network monitoring, coordination of accidents connected with VPN , corporate telephony, Internet. End-user network equipment configuration.
ЗАО "MVS-Telecom"
Москва
Technical support Manager/Team Lead
Октябрь 2012 — Ноябрь 2013 (1 год и 2 месяца)
- Coordination and management of company's product support. - Implementation/integration of BSS products - Billing(Charging) system, Provisioning, CRM, Mediation. - Define, manage and verifiy implementation scope. - Support of existing BSS users, drive addon sales. - Collection and analysis of requirements for the further system improvement. - Technical specification analysis, assisting in the design of the user interface and functions according to the business process model. - Interaction with the development team. - User manuals and FAQ's. - Financial control (invoices, factura invoices) - Perform pre-studies.
Technical support Manager
Май 2010 — Сентябрь 2012 (2 года и 5 месяцев)
- Implementation/integration of BSS products - Billing(Charging) system, Provisioning, CRM, Mediation. - Define, manage and verifiy implementation scope. - Support of existing BSS users, drive addon sales. - Collection and analysis of requirements for the further system improvement. - Technical specification analysis, assisting in the design of the user interface and functions according to the business process model. - Interaction with the development team. - User manuals and FAQ's. - Financial control (invoices, factura invoices) - Perform pre-studies.
Высшее образование
Поволжский государственный университет телекоммуникаций и информатики
Самара
Факультет: Базового телекоммуникационного образования
Сентябрь 2000—Сентябрь 2005 (5 лет)
Communication systems and switching, Engineer
Факультет: Телекоммуникаций и радиотехники
Январь 2000—Январь 2005 (5 лет)