Developer Project

Alexander Merkuryev

978-***-**** *********@*********.***

Senior Oracle Developer/Architect

. A hands-on database developer who is known to consistently deliver on

high visibility projects.

. Strong Oracle Architect skills. Specialized in advanced database

design and tuning. Worked in all phases of project life cycle and

functioned as Lead Application Designer and Database Architect.

. Netezza hands-on developing and tuning.

. Deep ETL experience with Informatica and custom-built systems.

. MS degree in Applied Mathematics and Cybernetics with over 20 years of

professional experience in the IT, specializing in the implementation

of Oracle technologies within the government, financial, and

marketing/CRM services sectors.

Skills

Oracle (7 to 11g) SQL, PL/SQL Visionary solution finder

Netezza Problem solver

ETL (Informatica, sql loader, nzload) Team player

Shell scripting, Perl

Scheduling (Control-M, Autosys)

Professional Experience

FIDELITY INVESTMENTS, Merrimack, NH 2005-2013

Principal Software Engineer

FMR Co - Quantitative Database Engineer (2012-06/2013)

. Delivered various code enhancements to PROD systems as a part of

Tactical Developer responsibilities, including ETL Framework

workflows, Informatica workflows, Autosys jobs and boxes, Oracle

stored procedures and tables, and Perl and shell scripts.

. Designed and developed several metadata sub-systems: Quantitative

Management Reports loader, and Data Quality Monitoring System.

. Created universal Netezza Pivoting code to help quantitative analysts

in their analysis.

Fidelity Risk Workstation (RWS) (2010-2012)

. Led data analysis, modeling, and solution design and development of

Lockup Engine: a complex rules engine for dynamic recalculation of

clients' requirement levels in Term Agreement context.

. Led migration of Risk Workstation to Exadata hardware, including

setting up of Control-M batch cycles, Oracle databases, and Reporting

tools.

. Converted more than 30 legacy reports to Business Objects.

IT eXcellence Dashboard (ITX) (2009-2009)

. Designed and built the IT eXcellence Dashboard: a comprehensive IT

reporting tool that provided summaries and detailed project budget

information.

. Led all project lifecycle phases from requirement gathering to

production support.

Fidelity Enterprise Messaging Project (FMX) (2005-2008)

. Designed and developed Fidelity Enterprise Messaging Project (FMX)

Scheduler.

. Created FMX daily performance reporting.

. Designed and implemented FMX Purge System to delete millions of

expired messages per hour from the messaging OLTP database with

hundreds of millions of messages.

. Improved billing practices by creating budget management tool to

compare budget to billed hours.

WORK'N'GEAR, Weymouth, MA 2004-2005

Senior Oracle Developer/Architect - Contractor

Developed the marketing database for Work'N'Gear from start to finish,

including initial design, data load, ETL, weekly update process,

aggregations, reporting, and documentation.

PREVISION MARKETING LLC, Lincoln, MA 1999-2005

Senior Oracle Developer/Architect

Developed CRM solutions for multiple clients: Monster.com, American Ski,

Cole Haan, etc.

. Created universal process management system which controls all parts

of periodic database update cycle.

. Developed Response Engine - set PL/SQL packages for customers'

response calculation.

. Developed data extract, transformation and load (ETL) layer - tens of

millions records per process.

. Performed data cleansing and match/merge using FirstLogic PostalSoft

tools and custom Perl scripts.

. Created and optimized shell scripts, batch files, and scheduling OS

and Oracle jobs.

AVICOMP SERVICES AG, Moscow, Russia 1998-1999

Oracle Applications Developer/Analyst

Performed setup of Oracle General Ledger, Inventory, Purchasing,

Receivables. Imported data from legacy system into Oracle Applications

database. Customized Oracle Account Generator processes using Oracle

Workflow facilities. Developed custom PL/SQL package with required

functionality and integrated its functions into Account Generator

processes.

CFED INC., Tver, Russia 1996-1998

Oracle Developer/Analyst

Participated in the USAID-funded project "Development of Real Property

Taxation Information Management System". This project was executed in

Russia in framework of the federal Real Property Taxation reform.

. Designed and developed software for Property Valuation processing

. Created Data Retrieval Module

. Designed and developed Statistics Module

. Developed Property Data Entry Module

. DLL for Visual Basic applications access to Oracle database

GAZPROM JSC, Moscow, Russia 1994-1995

Software Developer/Analyst

Worked on United Network Personnel Information Management System project.

Designed and developed Personnel Rewards and Personnel Training modules.

ROSINTECH, Tver, Russia 1992-1994

Programmer

Worked on CASE-Technology for distributed application system

interconnection.

Education

Netezza, Fidelity, Merrimack, NH (2013)

Informatica, Fidelity, Merrimack, NH (2012)

Oracle Applications Training, Moscow, Russia (1999)

MS, Applied Mathematics & Cybernetics, Kalinin State University, Tver,

Russia (1992)

Contact this candidate