Summary:

Skills: Databases: Oracle 7.3/8i/9i/10G/11G

Languages: PL/SQL, Python/Perl, Java, and SQL

BI Appliance: Exadata V2, Netezza, Vertica, ParAccel

ER Tools: PowerDesigner and Erwin

SAM: CVS, Perforce Tools: gdb, ant, Autosys, ADDM, AWR, bash, exp, imp, JIRA, SQL Loader, SQL Plus, SQL Trace, Toad, tkprof, and XMLSpy Google: Borg, GFS, Mapreduce, Sawzall, Bigtable

Netezza: Aginity Workbench, NZPLSQL, UDF/UDX

EXPERIENCE:

Confidential

ORACLE DEVELOPER

Consultant

As Global US Markets Analytics Technology team member I'm mostly involved in DW design and implementation and ETL development using Oracle SQL, PL/SQL and Python.

• Worked with architects, DBA's, and business analysts to understand integration direction.
• Involved in many aspects of automation concerning the data lifecycle: data design, data mapping, SQL and PL/SQL, SQL tuning, workflow creation and definition, ad-hoc and scheduled reporting and other critical elements concerning the automation, tuning and enhancement of the existing and future process.
• Created logical and physical data models, metadata mapping. Participated in technical design reviews, code reviews.
• Provided technical leadership, participated in multiple cross-functional SDLC efforts.
• Written and tuned SQL ad-hoc and scheduled reports and PL/SQL code.
• Created multiple database objects: tables, views, types, sequences, partitions, stored procedures, functions, global temporary tables and pipelined functions.
• In scope of Exadata, Netezza, ParAccel evaluation scripted Trade Volumes reporting core data and code migration from Oracle to target platform.

Environment: SQL, PL/SQL, Python/bash Tools: TOAD, SQL Plus, SQL Loader, SQL Tools, Talend DB: Oracle 10G/11G R2 OS: RH Linux. BI Appliance: Exadata V2, ParAccel, Netezza.

Confidential

BI ENGINEER

Confidential I was involved in development and maintenance of Ads Data BI-DWH Data Warehouse. Day-to-day duties included development of new ETL pipelines, monitoring of GETL and its internal components running on Google cloud computing infrastructure, job scheduling, log processing, and maintenance of development documentation.

Responsibilities:

• Created application configuration and deployment packages using Python, Shell, and Perforce in compliance with corporate standards. Provided support to the applications developers and business teams with data model design, development, and tuning of their applications.
• Performed system maintenance like space management, archival backup, performance. Written scripts for large files transfer from external systems.
• Assisted in operational support and application maintenance efforts. Resolved data validation, job preemption quota, connectivity, cloud weather issues. Resolved issues with RPC and TCP/IP, network latency, routing, master/slave lease, quota, and process utilization.
• Designed application tests obeying general testing guidelines using Python. Performed rewrite of old AdSense pipelines written in Python to new distributed platform. Completed incremental fact pipeline for AdsDb Fact tables. Automated data validation process.
• Created Python scripts harvesting application performance metrics vars , data validation, util for legacy-ETL-to-GETL automation.
• Managed operations of existing systems and supported existing applications: performed debugging, profiling, SQL tuning, data quality checking, monitoring, quick prototyping, and testing using Python and C .

Environment: Python 2.4, C , XML, bash, Java, SQL Tools: SQL Plus, gdb, pdb, Toad, Perforce, Erwin, Eclipse, Blaze, Forge Databases: BigTable, Oracle 10G R2, MySQL, Netezza OS: Ubuntu 8.04 Debian Linux

Confidential

ORACLE PL/SQL DEVELOPER

Consultant

Confidential team member, I am responsible for design and maintenance of CDR database Fixed Income Central Data Repository , and Oracle development for transactional and reporting applications and custom ETL solutions.

Responsibilities:

• Also analyzed data requirements for FI clients and designed data feeds, Perl parsers, and PL/SQL APIs for number of FIRC FI applications like: FIPB Fixed Income Primary Brokerage , Credit Arbitrage, Excalibur, and MarginFlex. Applied releases and created ETL jobs for integration of MarketData data sources and adoption of new subscribers into CDR Data warehouse infrastructure.
• Trouble-shouted problems and provided workarounds for them. Tuned SQL and PL/SQL to improve database performance.
• Performed release peer-reviews. Worked closely with other developers.
• Created multiple database objects for ETL batch processing and client reporting APIs: tables, sequences, views, materialized views, packages, stored procedures, triggers, synonyms, collections, types, indexes, and Dynamic SQL.
• Estimated, analyzed, designed, implemented and tested database projects of different scope. Written design and user project documentation.
• Using C and Pro C created set of tools for data transformation, applications for peer review automation, and auto submission of PL/SQL to version control system.

Confidential

ORACLE DEVELOPER

Consultant

As Oracle Developer I was responsible for design and development of order management application for Charles River prime brokerage Merrill Lynch and APL CheckFree using Python, and Oracle. Responsibilities included requirement gathering, system architecture design, implementation, testing, and deployment. Major accomplishments included a complete refactoring of the existing PL/SQL code base and creation of trade order simulator. The redesigned system was broken down to well documented modules interfacing with application and APL instead of one complicated PL//SQL package. Each procedure was instrumented for unit/regression testing. Based on provided specifications on CRTS equity trading interface, fixed income interface, equity and FIT data structures performed database design and existing stored database code refactoring.

Responsibilities:

• Designed and implemented web UI for testing/simulation of APL trade orders using Python and PL/SQL
• Documented all existing and new code, presentation and business logic.
• Performed code, and database changes for PL/SQL, and database design for Oracle
• Fixed bugs, applied patches and participated in release planning.

Environment: Python, ksh, SQL, PL/SQL Tools: Source Safe, Erwin, AQ Databases: Oracle OS: RH Linux, HP-UX, Windows 2000

Confidential

ORACLE DEVELOPER

Consultant

Oracle Developer responsible for development of a new trading platform for structured credit derivatives. Supported existing Structured Credit products Scorpius, Orion, Sals, and Credit Broil.

Responsibilities:

• Analyzed requirements and contributed to data model design.
• Created multiple database objects for new application: tables, sequences, views, materialized views, PL/SQL packages, stored procedures, triggers, synonyms, collections, types and indexes.
• Fixed bugs, applied patches and participated in release planning.
• Tuned SQL and PL/SQL to improve database performance.
• Worked closely with C .NET application developers.
• Created framework for PL/SQL instrumentation. Written project documentation.
• Created multiple SQL, PL/SQL, Perl, and Unix shell scripts for database application maintenance.
• Performed load/stress, contention tests for performance and locking problems prevention in versioning.

Confidential

ORACLE DEVELOPER H1-B

Consultant.

As part of FIRC data acquisition and reporting team I performed reporting applications development.

Responsibilities:

• Modified existing reporting software necessary to perform data collection.
• Enhanced existing reporting platform that met the needs of both executive and operational management.
• Created Perl framework for OCP, PVBP and STRESS financial reports.
• Created multiple Sybase database objects.
• Using Perl and Sybase created workflow system that integrated incident documentation with functionality to automate triage and prioritization.