SUMMARY:

• Solutions - oriented Oracle Systems Architect/DBA /Developer with notable success throughout development of a broad range of fully integrated Oracle and SAS -based solutions, including financial data solutions, while participating in planning, strategy, analysis, and implementation of robust systems supporting core business needs in regulated environments.
• Oracle: 12 years of solid database experience on Oracle architecting hardware and software solutions, doing Physical Database Design, Logical Database Design, Data Modeling, Gap Analysis, Data Mapping, Cleansing, Massaging, Transformations, Data Exports/Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Security Administration, Resource Management, Software Maintenance, User & Security Management, and Oracle Tuning/Optimization..
• Recent experience architecting and delivering a SAS 9.4 GRID solution for the CCAR (Comprehensive Capital Analysis and Review) model execution platform for a major financial institution.
• Recent exposure to Exadata and Large Scale Data Warehousing (34 Terabytes)
• 12 years of strong backend programming experience using PLSQL, SQL, MS SQL, Syase and Sql Server Transact SQL.
• Experience developing PL/SQL Packages related to financial data associated with agency and non-agency mortgages, Credit Risk, Basel Compliance, Credit Default Swaps (CDS), and Structured Finance.
• Oracle DBA experience includes: Tuning, Oracle PLSQL Development, Apex 4.2.1, AnyChart 6.0.1 and Oracle PL/SQL Development
• Strong Unix Operating System admin and Unix Shell scripting ability

CORE COMPETENCIES:

• Advanced PL*SQL
• Performance Tuning/ Monitoring
• Programming Transact SQL
• ETL Design and Development
• Infrastructure Provisioning
• Oracle Database Architecture
• Oracle Performance Trending
• Unix Shell Scriptin
• Disaster Recovery Planning
• Hardware Capacity Planning
• Complete SDLC
• SOX Compliance
• Systems Engineering
• Storage System Evaluation
• Financials Development
• Systems Integration
• Oracle DBA
• Systems Migration
• Complete Technology Stack Provisioning
• Accounting Conversions
• ITIL - Service Now
• Control-M 8.0
• SalesForce

TECHNICAL SKILLS:

Platforms: UNIX (Solaris 10, (Sun T4-8), Exadata V3, SunOS, Red-Hat Linux 6.6, Linux SLES 10, HP-UX (HP DL580, HPDL380 Gen9), IBM AIX, Windows 2000/2003 Server, Citric 6.5, VMware 6.0, storage including EMC VMAX, EMC Isilon x400, RamSan 620 SSD, Fusion I/O ioDuo SSD

Oracle: Oracle 11.2.0.3 RAC, 10.3.4RAC, 9.2.0.1.0/8.1.7/7.3.4, Enterprise Manager, AWR, Oracle OBIEE 11.1.1.6/7, Oracle Fusion Middleware, WebLogic 10.3.6, Oracle APEX 4.2.1, AnyChart 6.011, PL*SQL, RMAN

Tools: Sybase/SQL Server Transact-SQL, Python 3.6.1 PyCharm IDE, C, XML, Jbuilder, PowerBuilder, Eclipse IDE, JDBC, ODBC, UNIX shell scripting, AutoSys, Control M 8.0, Tuxedo, Tomcat 4.1.18, Iplanet Web Server, Crystal Reports 10.x, Cognos Report Net 8.x, Framework Manager 8.x, Toad 10.6, Erwin, BCP, SQL*Loader, HP OpenView, BMC Patrol, EMC SnapView/Navisphere, Callidus TrueComp, Quality Center, SVN, ClearCase, SAS 9.4, SAS EG 6.1. Citrix 6.5, VMware 6.0. Argus LookAhead and TrueCapital, Service Now, Informatica 9.3

PROFESSIONAL EXPERIENCE:

Confidential, Broadway, New York, NY

Senior Database Architect/DBA

Responsibilities:

• Established coding standards for existing and new PSQL Packages
• Restructured database tables, partitioning many to take advantage of parallelism and partition pruning on large tables.
• Developed various PLSQL packages for ETL associated with new MicroStrategy Dashboards..
• Assisted in AWS cloud migration POC for the database, Informatica and Microstrategy components.
• Responsible for migrating existing Crontab Unix based scheduling system to Control M 8.0.
• Reduced database resource consumption by 40%
• Evaluating slamDB and RESTful architectures for ETL, Integrating HomeCare HomeBase EMR data to our data warehouse.

Confidential, Jersey City, NJ

Senior Infrastructure/Systems Architect/DBA

• Architected and migrated users to SAS Grid Environment
• Sized and provisioned additional expansion of the SAS GRID Environment.
• Altered the standard DL580 configuration adding an additional dual ported FC card to increase I/O throughput for the provisioning of our Basel model Oracle database server.
• Coordinated AIX to Linux migration for all groups in Retail Risk Analytics group. This included capacity planning, new hardware and software selection and migration. This included Service Now Project Request, Change Requests and incidents.
• Responsible for implementing COB environments for all of our supported applications.
• Designed and coded Employee Entitlements feed based in Perl and Oracle 11.2.0.3 under a Linux 6.5 environment

Confidential, Madison Avenue, New York, NY

Senior Oracle DBA/Database Developer

• Designed and coded common ETL functions which were used by the ETL development team to employ standards and common design patterns.
• Gathered requirements from business users, designed and coded ETL processes for PCDW Data Warehouse.
• Standardized the UNIX environments for Batch ETL, setting up control M with in/out conditions to schedule ETL jobs and dependencies, coding UNIX shell wrapper scripts for interfacing with remote systems via JDBC and SOAP.
• Was responsible for UNIX and Database environment setup for Oracle Fusion (RCU repositiory creation) and OBIEE 11.1.1.6. Established a work around for an Oracle bug in LINUX SLES 10 which prevented the re-linking of Oracle executables during OBIEE Installation. .
• Implemented a Logon Trigger to prevent production database logons by non audited users. Established an auditing mechanism to log both successful and unsuccessful logons in order to meet SOX and regulatory compliance.
• Was responsible for ensuring SOX compliance throughout our software development Life Cycle
• Resolved performance issues across all tiers of the PCDW platform, including UNIX OS, Oracle RAC Database, SQL tuning, Oracle OBIEE Server, and Oracle Weblogic Server 10.3.6.
• Redesigned and implemented our database Monitoring Facility which gathers historical AWR information from our PCDW Data warehouse and Trading applications and charts database performance on a month over month basis. Based on Oracle APEX, Weblogic, PLSQL and UNIX Shell scripts, the application was migrated from Singapore to NYC. Migration and re-design included upgrading from Oracle APEX 3.2 to Oracle APEX 4.2.1. Made necessary code changes to accommodate the new JAVA version of AnyChart. I also upgraded Weblogic to 10.3.6. Application provides month to month comparison Database and Application performance. Coded new plugins via UNIX shell scripts for monitoring UNIX OS and OBIEE report performance as well.
• Currently working directly with Confidential on the migration of our application and database tiers to Sun Super Cluster, Exadata V3 and ZFS.. Evaluating application migration strategy, cost benefit analysis and application performance gains utilizing the application/database appliance.
• Re-Architected, designed and implemented our weekend gather statstics and partition table maintenance job utilizing dbms scheduler for multi-threading purposes. Improved weekend maintenance batch performance and by 45%.

Confidential, Pine St

Oracle PLSQL /ETL Developer

Responsibilities:

• Led design, development, and implementation of PLSQL packages to load and transform data (ETL) for the various accounting reports associated with FAS133, FAS157 and FAS161). Data was received from various Confidential business units in a multitude of formats.
• Was responsible for the development of a business rules engine for validating received securities data from various business units of Confidential . The engine was implemented in PLSQL in an Oracle 10G, Unix environment.
• Was responsible for the implementation of a Business Rules Engine which replaced hard coded business logic with table driven business rules, realizing code re-use capability, and reduced development time and greater reliability.
• Responsible for the maintenance and enhancements to the JAVA based valuation engine component of Confidentials ERM system calculating CVA and MVA for the positions held by Confidential business Units.
• Responsible for performance tuning, diagnosing and resolving both database and application bottlenecks.
• Responsible for implementing an ETL solution from the Oracle 10G environment to the SQL Server 2005 based ClarityCPM environment using SQL Server and Transact SQL.

Confidential, Wall St

Consultant/Senior Oracle PLSQL Developer

• Designed and developed PLSQL packages to load and transform static and dynamic mortgage performance data from Loan Performance, Inc. to our local mortgage performance modeling data warehouse..
• Responsible for significantly increasing data access performance by tuning SQL and partitioning large tables (specifically ABS dynamic data ~ 837million rows) appropriately.
• Responsible for setting up an Oracle OLAP environment using Analytical Workspace Manager and loading non agency MBS/ABS data creating cubes for BI reporting. Used Oracle Spreadsheet add in for reporting and comparisons of model data vs actual data.
• Was responsible for diagnosing and resolving performance problems associated with the ETL applications. This included reviewing Statspack reports, coupled with VMSTAT and SAR output to determine performance bottlenecks.
• Implemented a series of data validation scripts to ensure the validity of CPR and SMM values calculated during data transformation.
• Implemented generic packages/procedures for sending e-mail notification from PLSQL and logging ETL process steps into a central log table. Logged information included step performance statistics

Confidential

Senior Oracle PLSQL/BI Developer

• Re-engineering effort, to bring SAP order information and Siebel CRM information through a Callidus TrueComp sales compensation system into the corporate data warehouse. Re-engineered database refresh/migration processes for business intelligence reports, reducing the processing time from 9 hours to 55 minutes. This was accomplished by reducing I/O operations, tuning SQL, eliminating redundant database, using in memory structures for processing and making use of partitioned tables.
• Prepared data for loading into the Hyperion Cubes.
• Was responsible for obtaining and assessing business requirements and establishing the appropriate systems design, logical and physical data models to satisfy not only the current requirements but also to accommodate future requirements with minimal coding changes.
• Was responsible for coordinating with Senior management with respect to project tasks and establishing timelines and resources to staff the development efforts associated with established business intelligence requirements .
• Acted as mentor to a team of DBAs and developers supporting the BI environment. Was SME for establishing the new dimensions used in the Hyperion Essbase OLAP solution.

Confidential

Consultant/Data PLSQL Developer/Oracle Specialist

• Developed PLSQL package to replicate data from remote financial transaction feeder systems into the Transaction Hub Credit Risk and Basel Compliance environments. This package included logging of the process, while maintaining end user data availability while the data refresh process was taking place. This was accomplished using partitioned tables and the exchange partition facility. All code was maintained in Clear Case source control.
• Implemented a financial data archival facility, to archive old financial transaction data into historical tables. This implementation included logging and storing record counts associated with the process. This implementation was done using PLSQL packages.
• Restructured several large tables into partitioned tables realizing significant performance gains within the batch window.
• Responsible for diagnosing and resolving performance problems associated with the THUB applications. This included reviewing Statspack reports, coupled with VMSTAT and SAR output to determine performance bottlenecks.
• Was also responsible for releasing data model versions maintained in ER Studio to the development, QA and production environments.

Confidential

Consultant/PLSQL Developer/Oracle Specialist

• Developed PLSQL stored procedures and functions to support Confidential ’s Data warehouse business code assignment facility used in loading the fact tables within their data warehouse environment.
• Implemented Ascential Software’s Datastage jobs using Datastage Designer, Version Control and Datastage Director for data extraction, transformation and loading of the data warehouse. Was also responsible for developing Unix Shell scripts to support the batch processing of these datastage ETL jobs and integrating this processing within the Unix based batch processing environment.
• Reviewed SQL for performance enhancements and made recommendations for SGA tuning based on the results of Statspack reports utilizing performance snapshots gathered during the night data warehouse batch processing window.

Oracle Developer/Tuning Specialist

• Developed stored procedures to support ETL of data for the customized Cognos Reporting 7 from Callidus DataMart.
• Designed and implemented a PLSQL package which provided record level Security as per he business requirements, returning a refcursor to the Cognos 7 Reportnet.
• Architected and implemented inter-system report delivery between corporate database server and Cognos reporting platform utilizing AIX Unix SFTP and NT based Techtia SFTP server, including the generation of appropriately formatted certificates. This facilitated delivery of .csv files generated in Oracle directories on the database server and integrating the delivery with the Cognos 7 reporting platform.
• Proactively identified, diagnosed, and resolved performance issues, diligently monitoring application performance using Oracle Statspack and Windows NT performance monitoring solutions.
• Utilized diverse skill set to successfully deliver a Java based interface to several SAP BAPIs (Business Application Interfaces) using the SAP Java Connector. This successful implementation made use of oracle’s dbms pipe to and an external java program and java virtual machine due to the SAP java connector’s JINI interface.
• Was responsible for performance tuning, both at the database level using Spot Light Monitoring from Quest as well as at the application SQL level using Explain Plan and TKPROF.
• Was also responsible for developing a PL*SQL package using Oracle's dbms xmldom utility to translate publication and subscription XML files from the DataMirror replication product to different environments.