Database engineer Resume

SUMMARY:

10+ years of Oracle DB applications development, financial and analytical reports implementation, ETL, software maintenance, testing, and troubleshooting.
Experienced in: prototyping, testing and implementation with database stored procedures, shell - scripts, reports engines for high-loaded back-end payment processing system; eliciting business requirements, documenting functional and nonfunctional specification.
Working knowledge of: basic algorithms, data structures, and complexity analysis; software development life cycle phases;
Used MongoDB for retrieving and updating log data.
Interested in big data storage and handling tools (Cassandra, Hadoop, Hive, Impala, MongoDB, Spark).

TECHNICAL SKILLS:

Databases design and development: Oracle, Windows SQL Server, PL/SQL and T-SQL stored procedures, Toad for Oracle, SQL Developer, SQL Server Management Studio; SQL Server Analysis Services.

Scripting: Unix-shell, Perl;

Basic administrative skills: Linux, Windows Server 2008;

Data handling: Python (numpy, pandas, scikit-learn);

Monitoring, publishing: Nagios, Wordpress ;

Source control management systems: SVN, Git;

Bugtracking systems: Mantis, Trac;

Reporting tools: Crystal Reports, Microsoft Excel; noSQL: MongoDB.

PROFESSIONAL EXPERIENCE:

Confidential

Database engineer

Implemented data quality control system for daily generated financial and information reports.
Outcome: online monitoring dashboards with different metrics of over 2 M daily processed transactions were provided to an operational team.
* Provided implementation and maintenance of financial data reconciliation module for over 2 M credit card transactions daily.
Outcome: tools for successful daily monitoring of outstanding balances provided to an operational and accounting teams.
Investigated the compliance of used software solutions with PCI DSS audit technical requirements. Implemented about 10 modules for automatic detection of PCI DSS requirements non - compliance in test and production environments.
Outcome: PCI compliance awareness report allowed to detect and eliminate threats at early stages on daily basis.
Developed an automated daily report of potentially fraudulent transactions with credit cards.
Outcome: risk monitoring department got a tool to trace and prevent financial fund transfers caused by fraudulent transactions in the total amount over $1 M.
* Prototyped a multidimensional dataset and a cube for on-demand reports of turnover depending on time, location, card category, cardholder age, merchant service charges and other slices.
Outcome: an implemented reporting system was built on the basis of the prototype using in-house technologies without OLAP.

Data engineer

Confidential

* Implemented card processing back - end migration modules. Outcome: data center processing increased from 0.5 M to 2 M financial transactions daily.
* D eveloped and maintained automated disputes resolution modules with PL/SQL, Unix-shell, and Visual Basic. It allowed delegating simplified operations to customer support specialists.
Established card processing control and monitoring system (batch data processing workflow) with the use of Bash and Perl scripts plus PL/SQL function/procedures.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship