TECHNICAL SKILLS:

Database Programming and Database Management: ASE Sybase 11/12.5/15: Sybase replication administration; Oracle 7/8/8i/9i/10/11g/12c; Oracle E - Business, Oracle Application Server; Oracle Financials; Mysql 5; Postrgres 8.4; SQL Server 6.5/7/2000/20 ; MS Access 97/2003/2003 ; Backup and recovery; Oracle Web-DB; Apex

Database Programming Languages and Methodologies: SQL; PL/SQL; Transact SQL; OLTP/ OLAP/ MOLAP; OLE; ODBC; MDX; Dimensions; (Multi) Cubes; SQL Loader; DTS 2000; SSIS, SSAS, Bulk Loader; Replication (Sybase and Oracle);

Database Tools: SQL Developer; Toad; Essbase; Oracle Designer; Express; isql; Oracle Enterprise Manager; Sql Navigator

Unix: Solaris 2.6, 7, 8, 9, 10; AIX; HP-UX; CompaqTru64; SCO; Linux SuSE 10.1/2/3 11.1/2/ ; Red Hat; Installation, Network implementation, backup, recovery, security;

Unix Scripting: Korn shell; csh; Bourne; bash; Perl; Awk; sed; php;crontab; at; Autosys; Control-M; CGI; Veritas; Apache; Veritas Volume Manger; Networker;Windows XP; Windows NT; 2000 Advanced Server; 2003 Server; Professional; 2008r2, AD;98; ME; IIS; TCP-IP/DHCP; DTC; ActiveX; AT; CScript (Windows Scripting); DOS scripting, ftp scripting;

Web Technology: AJAX; HTML5; XHTML; CSS1/2/3 XML; JQuery; Spry; Javascript; PHP; mod perl; Oracle Web Db; application running any of the following: Application Server (OAS/9iAS); Oracle Beans; Java Beans; Web Sphere 5.1; Apache Web Server; JVM; J2EE; Proxy Server; DNS Server; Android.

Data Warehousing: Oracle Grid and Cloud Control; AWS setup and configuration. Design; Planning; Requirement gather; Implementation; Logical and Physical Data Modeling; Data Mart Design and Implementation; Meta-data generation and maintenance; Relational Data Modeling; UML Modeling; Report;

Reporting Tools: Business Objects 5/6/XI; BO Universe Design/user admin and support; Impromptu/Scheduler; SQL; Oracle Forms; Oracle Reports; Crystal Reports

ETL;Oracle Warehouse Builder; Informatica Power Center 5-8.6.1; Unix Scripting; TXT Files: SQL; Data integrator; Sqlloader; PLSQL; Cognos Powerhouse/ Powerplay

Programming Lanuages: C; C++; PLSQL; Visual Studio 6.0 / .NET; Visual InterDev; Visual Basic; VBA; Java; JSP; PHP;Unix Shells (all); Perl; Javascript

Various: VMWare;git;CS4/5/6; OO Design; Kana Connect/ Response/ Forms / Kana Server Administration; Crystal Reports; Address Doctor; IBM AS400 extractions; Test Director; CVS; SAP Oracle Backend (ABAB); SAS data load and extraction Programming; Siebel 8.1/8.2, CRM and eCRM data integration (ETL) into data warehouse; Control-M; UC4

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Database Developer - Big Data Development, Reporting Streams

Responsibilities:

• Hadoop, Oracle, perl, python environment.
• Solr programming and configuration
• ETL xml and flat file loading and processing.
• Technical solution design, implementation and deployment.
• UAT Testing.
• SQL, functions, procedural programming.
• Netezza and Oracle development.
• JAVA backend programming
• Business Object Universe with Plsql Backend
• Datastage / Sybase to Oracle Hadoop migration
• VBS office automation for documentation generation (workflows in Visio)

Confidential, New York City, New York

Database Developer Finance Reporting

Responsibilities:

• Large scale data driven application development.
• Debug and troubleshooting. Testing.
• SSAS Cube building for MSSQL based Data Warehouse (Oracle Source)
• Exedata performance tuning.
• PLSQL Package and procedure and functions programing.
• Database setup, install, configuration in complex environments on Window and Linux.
• Oracle 11g, 12c development.
• AWS migration for redhat and centos 7.2 based server environments.
• Database install and configuration.
• Cassandra, solr/lucene, Hadoop search engine, setup, design, and configuration.
• Mysql and MSSQLServer support.
• Functions, stored procedure
• Performance tuning improvements.
• Business Objects Universe Design and Deployment
• JavaScript, PHP, SQL development.
• Git, Grunt, NodeJs
• Cronicle job scheduling
• UI and JavaScript library implementations.
• Documentation.
• Third Party Software modules implementation.
• Data Quality test design and deployment.
• Schema, functional, logical design

Confidential

Data Warehouse Finance Reporting Developer

Responsibilities:

• Design Test cases for proof of concept for data warehouse Microsoft Business Services reporting.
• Cube design and building implementation.
• Implement data reports for world-wide data centers.
• Data Quality test design and deployment.
• TeraData developer.
• Coordinate with multiple teams, rollout date and responsibilities.
• SQL procedures and trigger develop for finance reporting system.
• Performance tuning.
• Oracle DB 12c data sourcing.

Confidential

Oracle Database Developer Specialist

Responsibilities:

• Deployment planning and testing.
• SQL reports Management reports.
• PLSQL procedure/package, shell scripting programming.
• Perl programming debugging
• DB2 sql and support.
• Database and process reverse engineering.
• Shell scripting automation.
• Text indexing in, solr/lucene, for document search engine, setup, design, and configuration.
• Java application debugging.
• Windows package (MSI) programming, and deployment planning.
• Java, C and C# programming.
• UC4 job scheduling
• Technical Specification / Business Process and other technical documentation.
• Documentation of data flow, system design and data modeling.
• Business reporting and front end requirements gathering (Data Warehouse reporting).
• Data extraction and loading bug fixing and error checking.
• XML application data exchange
• XSD validation.
• Linus, Solaris, and Windows administration.
• Database creation.
• Records Management.

Confidential

Oracle DBA Database Developer Specialist

Responsibilities:

• Deployment planning and testing windows packaging (WIX, MSI Packaging).
• SQL reports Management reports.
• PLSQL procedure/package, shell scripting programming.
• Database and process performance tuning.
• Very large database tuning and design.
• Sybase procedure writing and tuning.
• Java backend.
• ETL process change release testing.
• Perl and shell scripting.
• Search engine setup and implementation in Solr.
• Informatica 8.1.6 ETL programming and repository administration.
• Business Objects universe design and implementation.
• Business Process and technical documentation.
• SAP BODI Data Intergrator.
• Excel BI reporting.
• Teradata SQL development.
• Apex Application using PLSQL
• Documentation of data flow, system design and data modeling.
• Business reporting and front end requirements gathering.
• Data extraction and loading bug fixing and error checking.
• XML generation from Oracle to SSIS.
• XSD validation.
• Solaris, AIX, Linux management.
• Regular expression for data cleansing and data management.
• Backup and recovery RMAN setup.
• Oracle Standby database using Dataguard Setup.

Confidential

Data Migration Specialist

Responsibilities:

• Data and ETL migration using shell and Perl scripting.
• C++ programming and debugging for calculation engine integration.
• Wrote Database procedures.
• Automation of testing of new package releases.
• Support setup of new server hosting in Active Directory (MS) and Linux.
• Business Reporting Migration from Access/ excel/ SQL to Oracle.
• Process definition based upon requirements specifications.
• Automation for testing and data quality with SQL, shell, Perl scripting, and PL/SQL.
• Modeling and documenting existing designs.
• Other various technical documentation.

Confidential

Portfolio Trading Reconciliation Reporting Specialist

Responsibilities:

• Crystal Reports xCelsius
• Wrote Crystal reports for Positions, Transactions, and Cash Balance.
• Migration of database view to Crystal Reports.
• Testing of change releases.
• Performance Tuning MSSQL 2005 and Crystal Reports (SQL).
• Implemented Prompting and selected criteria in Crystal Reports.
• Wrote database procedures and functions.
• Automation for testing and data quality.
• Data loading and ETL logic mapping.
• Modeling and documenting existing system new functionality.
• Business Process and technical documentation.

Confidential

Web / ETL Application Developer

Responsibilities:

• ETL programming using workflows/mapping/maplets in Informatica Power Center 8.6.
• Power Center Repository Upgrade and Server Migrations to 8.6.
• Power Center User and System Administration.
• Performance Tuning for Oracle 11G.
• PL/SQL package/procedure and function Programming.
• Modeling and documenting existing designs.
• Automation of job control and bug fixing for major release.
• Testing of minor release changes.
• Business Process and technical documentation.

Confidential

Oracle Web Application Specialist

Responsibilities:

• System design and data modeling.
• Business reporting and front end requirements gathering.
• Implementation of reporting in Oracle and MYSQL.
• Data extraction - Interface defining.
• Perl, PHP and Shell programming.
• Regular expression.
• PL/SQL programming.
• Informatica Configuration and Administration.
• Automation of reporting and metadata creation.
• ETL programming with OWB and Informatica.
• Business Process and technical documentation.

Confidential

Data Warehouse Specialist

Responsibilities:

• Laboratory study statistical data extraction.
• Oracle Database Migration from 8i to 11GR2 and Upgrade Planning.
• PHP Web Application for metadata management.
• MSSQL Server 2005 Data Warehouse Administration.
• Data extraction design and defining.
• PL/SQL Programming.
• Shell scripting.
• Designed and Implemented Web Application in Ajax / PHP / Oracle.
• BO XI 2 - Business Object Reporting Universe implementation for Bio Study Data
• ETL Programming in (OWB) Oracle Warehouse Builder.
• Automation of reports.
• Business Process and technical documentation.

Confidential

Oracle Specialist in Portfolio Management

Responsibilities:

• Business Requirements into Oracle Packages implementation.
• Oracle PL/SQL programming.
• Technical lead to improvement performance due to doubling of source data
• Tuning (700% improvement) across entire load.
• Extracts to portfolio management systems (AAA).
• DB Lead to migrate two databases and applications into one.
• Automation of reports.
• Shell scripting.
• DB2 sql and support.
• AIX management.
• Testing of change releases.
• Oracle database migration and upgrade from 9i to 10g.
• Business Process and technical documentation.

Confidential

Business Reporting Specialist

Responsibilities:

• Business Reporting for Sales, After Sales, Finance and HR departments.
• Designed and implemented 48 reports using Crystal Reports - Oracle based reporting system.
• Implemented Prompting and selected criteria in Crystal Reports
• Performance tuning of reporting systems.
• Change Management process design for reporting.
• Automation of reports.
• Requirements Gathering.
• Release testing.
• Data modeling and Business process modeling.
• ETL Programming workflows in Informatica PowerCenter.

Confidential

Business Reporting Specialist

Responsibilities:

• Business Objects Universe and Report design.
• Project Management for business stake holders and process owners.
• Logical data modeling and ETL process design.
• Process Design.
• Shell scripting.
• DB2 as sourcing system, (ETL extraction).
• Testing of change releases.
• Siebel Repository migration
• Siebel Object creation and management.
• Migrated Microsoft Access database to Oracle, rewritten in PLSQL for ETL.
• Writing, Implementation and testing of PLSQL packages, procedure, and functions.
• Data Mart design and implementation.
• Logical and Physical Data Modeling.
• Tests Planning and implementation.
• Technical Documentation of New and Existing Systems.
• Documentation of Architecture, load processing and current reporting structure.
• Feeder system specifications.
• Migration of existing applications to new platform.

Confidential

Business Reporting Specialist

Responsibilities:

• Project Management duties for business stake holders and process owners.
• Data Warehouse and Reporting Modeling and Design.
• Oracle and MS SQL Server Programming.
• PLSQL Programming of Packages and Procedures.
• Logical and Physical Data Modeling.
• Planning and implementation of Tests.
• Informatica process design and implementation.
• Technical Documentation of New and Existing Systems.
• Documentation of Architecture, load processing and current reporting structure.
• Feeder system specifications.
• Testing of change releases.
• Oracle Warehouse Builder mappings.
• Migration of existing applications to new platform.
• Oracle 10g Setup and Configuration for 3 Tier Application Environment
• Unix shell and Perl scripting for ETL and Job Scheduling.

Confidential

Senior Database Specialist

Responsibilities:

• PLSQL Programming for Risk Assessment Applications.
• Extensive documentation using Summit D framework from Price Waterhouse Coopers
• Documentation generation.
• Code review and re-factoring.

Julius Baer Zürich

Senior Data Specialist

Responsibilities:

• Specified, defined, designed, wrote and Implemented Portfolio Management Data Mart
• Unix KSH and Perl programming, documentation, implementation.
• Extraction Process automation.
• Designed Batch Process architecture.
• Management report generation and delivery writing.
• Concept Design for ETL load process.
• UC4 scheduling programming.
• Testing of change releases.
• Load Monitoring Management and process design.
• Data Model design for existing Application Environment
• Legacy system integration planning and implementation.
• Release Management concept and architecture defining.
• Documentation of Architecture, load processing and current reporting structure.

Confidential

Senior Data Business Intelligence

Responsibilities:

• Concept Design for ETL load process in PowerCenter.
• Business requirement gathering from Sales, Marketing, Operations, Ledger, Account Management
• Business Objects Universe Design, Implementation, Management, Updates
• Business Objects Report writing for Churn, Sales, Operations, Product, Real Estate and Networks
• Provided Sales and Management Teams with technical support.
• Provided CRM Center with technical support.
• KPI reporting in accounts receivable, accounts payable, general ledger.
• ETL Process Management writing in Data Integrator, Unix bash, ksh shells.
• Load Monitoring Management and process design.
• Designed/Rewrote Sales Data Mart in PL-SQL.
• Wrote ERD Diagram for Datamarts.

Confidential

Senior Data Specialist

Responsibilities:

• Performance tuned Credit Risk application Basel I and Basel II
• 50% CPU improvement, 800% Running time improvement.
• Packages, procedures, and functions for credit calculations.
• Benchmarking of ETL, and Reporting application Servers.
• Upgraded Oracle 8i to 9i.
• Brio Portal Reports.
• Informatica Powercenter ETL logic and design programming
• Informatica Administration and configuration.
• SQL, PLSQL, and Query Tuning.
• Database instance Tuning.
• Front-end reporting security role implementation.
• UNIX programs in awk, ksh, for package transfers, and export/import of database.
• Data quality checking automation.
• Control M scheduling scripting
• Sed programs for migration of server scripts in ETL environment.
• Wrote various PLSQL and SQL based applications to control, change and manage business rule change management, allowing greater control and flexibility, with reduced time to completion for each change.
• Spreadsheet loading automation and error detection.
• Documented existing systems and applications.

Confidential

Database Specialist

Responsibilities:

• Wrote Oracle Stored procedures to deliver data to Java front end application.
• Wrote and implemented load and reporting extracts in TSQL and PLSQL.
• Sybase - Oracle—UNIX (sed, awk, ksh, sh, csh) programming, stored procedures, loading, extracting, ftp, sqlldr, bcp, triggers, flat file, Sybase to oracle, oracle to Sybase.
• Performance tuning both back and front end applications.
• Oracle Applications fixed asset Module reports.
• Wrote and automated performance and database monitoring facilities.
• Programmed and Implemented largest IT Equities project for 2004- complete system loads and reporting structure reorganization of Wealth Management, Investment Bank, Business Banking and Private Banking for IB cross product structures.
• Implemented trade load extractions (some new others reworked) and with edge calculation logic, to reporting extractions, to front end release and rollout to Business Objects, within multi-national replicating environment.
• Gather user specs and implement changes in finance reports.
• Support traders and reporting teams daily (trade load error solutions, wrote bug fixes, maintained production systems.
• Shell scripting. (awk, sed, ksh, csh).
• Front and Backend testing with Test Director.
• XML based report generation via PLSQL
• Wrote Sybase procedures for complex business rules.
• Oracle Business Object Support.
• Daily Sybase and Oracle replication administration.
• Daily Sybase and Oracle data base administration duties.
• Wrote new and updated existing trade loads.
• Business Objects admin and design.
• Performed daily run-the-bank tasks (bug fixes, minor loads changes, etc.).
• Exports, imports, restores, extracts and refresh data.

Confidential, Washington, DC

Data Warehouse Lead Project Implementer Contractor

Responsibilities:

• Lead project to expand and renew load process of US Military Personal Data. cron, awk, sed job processing.
• Sybase and Oracle DBA duties (backup, restore, security).
• Informatica Powercenter Mappings definition with PLSQL.
• ETL process management and programming.
• ETL analysis, implantation, upgrade.
• HP-UX with Oracle 9i parallel processing.
• FTP file scripting both UNIX and NT.
• Data Model design and implantation.
• Multiple system extracts.
• Off lining older data.

Confidential

Data Warehouse Team Application Designer/Developer Contractor

Responsibilities:

• Designed, planned, and implemented data warehouse applications in Cognos Powerplay, Sybase, Oracle 9i, 8.1.7.3, VBA MS Access for flight data, sales tracking analysis, and human resource reports.
• Implemented business logic with SQL stored procedures;
• Designed and implemented aggregated nightly cube refreshing with Cognos Scheduler, Transformer and Powerplay.
• Shell and Perl programming.
• Managed sourcing interfaces for SAP with Oracle, DB2, and Sybase.
• Data Modeling and project planning;
• Met regularly with business owners to target best reporting practices;
• Updated outdated applications, increasing both efficiency, effectiveness and performance;
• Designed load processes from sources, ETL layer and to reporting layer;
• Automated data extraction, cleansing, and load processes;
• Automated Excel and Cognos extract report generation.
• Set up email notification for failed load processes;
• Documented business requirements and system specifications;
• Developed multiple PLSQL, T-SQL programs.

Confidential, New York, NY

Senior DBA for Global Data Warehouse Team

Responsibilities:

• Production and 2 Level db support across teams and organizations.
• Planned, implemented, and managed Informatica Powercenter, Power Mart ETL with repository databases between Oracle data warehouse and eCRM applications, Kana Connect and Response;
• Planned built and managed terabyte UNIX based global data warehouse, its ETL processes in flat file feeds and direct data base connections, plus the applications (Web, Shell, SQL,C++ and Java based).
• Implemented online indexing strategy across business.
• Business and developer user-support.
• Automated Excel extract report generation.
• Automated load and data cleansing processes.
• Managed Production Contact Center databases, performing updates, backups, and other usual tasks in Oracle 7, 8i and 9i.
• Managed SQL Server Production Databases for the entire Web Shop.
• Created End-User-Layer reporting schema and model for Oracle Designer 6i Dimensional and Materialized View reporting using Java and Oracle Discoverer;
• Lead project to implement XML and .NET with Oracle Data Warehouse and SQL Server 2000/Win2k based e-Commerce;
• Developed multiple PLSQL, T-SQL, Perl and PHP programs;
• Perl and Korn Shell Scripts.
• AIX Management.
• Implemented Web Statistic backend Application on SQL Server 2000.
• Restored and migrated SQL Server 6.5 and 7.0 databases to Oracle 8.1.6;
• Wrote and implemented Visual Basic programs with .DLL interfaces for database linked applications such as Address Doctor for SQL Server 2000 data cleansing processing;
• Responsible for all installs, upgrade and system specifications involving data warehouse and Contact Center;
• Performed multiple upgrades and patch applications in Oracle 7.0,.8.1.5, 8.1.6, 8.1.7, 9i and SQL Server 6.5,7.0,2000;
• Created Web based reports with OAS, Developer and Jscript and Java.
• Added ABAB queries to standard report tree.

Confidential, New York, NY

Oracle / DB2 / SQL Consultant DBA/Programmer

Responsibilities:

• Implemented Database XML technology across multiple organizations;
• Redesigned Data Warehouses to improve application performance.
• Shell scripting.
• Standardized Backup and restore.
• Clustered environment administration.
• SQL tuning.

Confidential, New York, NY

Consultant DBA/Data Programmer

Responsibilities:

• Wrote multiple programs in Visual Basic, C++ and PLSQL;
• Oracle Applications and Financials administration/reporting;
• Essbase and Business Objects application administration and ad-hoc reporting of dimensions;
• Designed, built and managed large OLAP data warehouses and OLTP application back-end databases;
• Migrated legacy systems (dbase III and Access) into Oracle 7.3.4 and 8.0.5 running on Unix and Windows NT;
• Clintrial 4 setups and maintenance for Health Care Companies;
• SQL Server migration;
• Created backup scripts; triggers and indexes to reduce I/O usage;
• Enhanced Visual Basic and C++ programs with Active X and ASP extensions;
• Applied redo logs when necessary and performed backups with RMAN and LEGATO utilities;
• Implemented highly successful plans for SGA, JAVA Cache, SQL Pool tuning strategies for revitalization and performance gains of production databases and applications;
• Performed Hot/Cold Backups;
• Wrote Embedded and Dynamic SQL in VB;
• Configured automated DTS and SQL Loader Sessions;
• DB2 on HP-UX Apache monitoring and installations;
• Perl, Korn, and Bourne Shell Scripting;
• Created online Oracle Forms and Business Object reports;
• Helped create programs to maintain application’s effectiveness;
• Statistical reporting with SAP Basis / FI / CO / SD / PP.

Confidential, New York, NY

Consultant DBA/Programmer

Responsibilities:

• Unix shell scripting and programming.
• Production DBA support.
• Backup/restore strategy and implementation.
• Oxford Insurance.

Confidential, Binghamton, NY

UNIX Solaris Systems and NT Administrator, Help Desk

Responsibilities:

• Performed system maintenance;
• Cleaned disk caches;
• Shell scripts Korn, Bourne and awk;
• POP/TCP/IP Administration;
• Network Administration;
• Managed Sun/Solaris UNIX Environment, permissions, quotas, accounts, and batch processes;
• Administered NT 3.x and NT 3.51environments.