SQL Developer Resume

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer

Responsibilities:

Build Download and Insert Data Modules into MariaDB using Python Luigi, NoSQL
Build Restaurant Recommendation Database using PySpark, MariaDB (NoSQL)
Build Rest - API to expose recommendations as service using Python Flask, Flask-Alchemy, and MariaDB
Building Unit-Test, and Deployment Package - Virtualbox, Vagrant with Unix Script, Python PIP
Build and maintain MariaDB Unix Backup script using mariabackup utility

Confidential

SQL Developer

Responsibilities:

Building scraping module(s) - download and store into MariaDB (NoSQL) using Python Beautifulsoap, Silenium, and Airflow

Database Developer

Confidential - New York, NY

Responsibilities:

Build SSIS packages for various State Attendance Upload - SSIS, Trans-SQL, Cognos
List Rental Project - Create Data Extraction Packages using Talend, Trans-SQL
Data validation of various report output(s); data mapping research project(s); miscellaneous automation task(s) using Python Pandas
Work on 360 Data Analytics Project - Microsoft Power BI
Create and maintain Database Model, create and maintain Talend/Trans-SQL loading data procedures

Database Developer

Confidential - Port Washington, NY

Responsibilities:

Install Talend Enterprise Software 4.0 - Windows 2008 Server
Work on ODS SSIS Package - include/expand additional data sources and transformations into existing package
Build and deploy Talend Packages to replace various legacy ETL processes: Trans-SQL, PL/SQL procedures

Oracle Data warehouse Consultant

Confidential - New York, NY

Responsibilities:

DBA Consultant

Confidential - New York, NY

Responsibilities:

Oracle/SQL Server Production DBA - Oracle 9i, 10g and SQL Server 2005, 2008
Capacity and resource planning; On-going support/enhance/migrate/upgrade of databases for applications; Setup Oracle Data Guard, SQL Server Log Shipping and Mirroring; Setup Oracle Enterprise Manager monitor databases
HP-UX RISC, Itanium, and Windows Server
Build and deploy Oracle Backup Unix and Windows Scripts for OS.
Document Oracle Database Migration from HPUX RISC into Itanium; Upgrade SDESK, OpenView, and STG databases from Oracle 9i onto 10g from HP RISC into Itanium.
Identify and outline essential and non-essential pre-requirements at the operating system level before installing Oracle Database software in the following areas: HP-UX RISC and Itanium patchset bundles.

Database Programmer

Confidential - New York, NY

Responsibilities:

Maintain and enhance ETL send and retrieve data onto search system - DTS, Trans-SQL

Application Developer

Confidential - Yonkers, NY

Responsibilities:

Application Developer

Confidential - New York, NY

Responsibilities:

Work on build/enhance/maintain of various web applications:
Work on build/enhance/maintain ETL processes in various integration assignments: