Senior Oracle Developer

Nancy Chow

East Brunswick NJ 732-***-**** *********@*******.***

Professional Summary

Over 20 years of experience as an Oracle Developer in Dow Jones and AT&T with expertise in Analysis, Design, Database Normalization, Implementation and Production Support of Business Applications using the Oracle Relational Database Management System (RDBMS).

Led teams through all phases of SDLC at several large Oracle Apps life-cycle implementations with timely delivery against aggressive deadlines.

Two years of experience in Web based, Client/Server, Distributed Systems using Java/J2EE Technologies

Strong experience in SQL Performance Tuning using Indexes, Table Partitioning, Materialized Views, Analytic Functions, Execution Plan, Data Warehouse and ETL concepts.

Experience in Oracle LOB data types including LOB, BLOB and CLOB.

Expertise in various programming languages and platforms such as C, C++, Pro*c, HTML, XML, Java, Unix, Linux and Web Applications.

Exceptionally self motivated to accept challenges, active in learning new concepts, team oriented.

Excellent communication and interpersonal skills.

Worked with scrum teams in Agile environment.

Technical Expertise

Databases: Oracle 8i/9i/10g/11g, SQL, PL/SQL, SQL Loader, Export/Import, Data Pump, Triggers, Stored Procedures and Packages, SQL *PLUS, SQL Developer, Oracle Spatial, SQL Server, Sybase, OLAP

Languages/Utilities: C++, C, Pro*C, Java, Shell Script, Awk, HTML, XML, TCP Sockets, Xerces-C, Cobol

Operating Systems: UNIX, LINUX, Windows, Apache

Other Tools: Eclipse, Microsoft SQL Server Management Studio, Oracle Discoverer, GDBM (hash database), MapInfo MapMarker Plus, MapInfo MapXtreme, SVN, GIT, PVCS

Professional Experience

Dow Jones - Nov 2005 to March 2016 - Application Development Consultant

Experience in multiple major projects within Dow Jones Newswires Organization focusing on Oracle PL/SQL and C++ development and also involving in projects with other technologies such as Java, Web Applications, SQL Server and MongoDB.

Elementized News Project

The application delivers headlines in precisely tagged elements on a low latency feed. Numerical data, timestamps and other information are placed into XML-tagged fields, allowing trading models and computer programs to process, interpret and take action on breaking news quickly. This project won the Best Data Solution in year 2007.

Responsibilities:

Designed and developed a Mapping System using Oracle 11g database to map over 350 Economic Indicators and Corporate News to auto-published headlines in 15 languages.

Developed and maintained an Unix based application to parse the Elementized Data using Xerces-C, configure headlines in different languages using the Mapping System and send headlines for publication.

Reduced development time and cost by the automation of HTML templates for publishing Elementized Data.

Developed SQL queries and PL/SQL using cursors, Analytic Functions, Materialized views, etc.

Implemented character encoding conversion for various languages.

Interfaced with Editors globally to gather different language requirements and provide ongoing support in production.

Automated Reports for Management.

Converted application from Unix Solaris to Amazon Cloud Linux.

Acted as Scrum Master to facilitate the daily standup, set up retrospective, sprint review and planning sessions.

Environment: Oracle SQL, DDL, PL/SQL, SQL Developer, SQL *Plus, DML, DDL, C, C++, Shell Scripts, awk, Unix, Linux, Amazon Cloud, TCP Sockets, Xerces-C, gdb, GDBM

News Archival Project

This is the Archival System for historical news. Data can be used to create algorithms for application such as risk management, arbitrage, and pre-trade and post-trade analysis.

Responsibilities:

Performed data analysis and rectified data for 20+ years of historical news from various sources such as Oracle, SQL Server, Access and Excel Spreadsheet.

Performed data modeling and normalization.

Created PL/SQL stored procedures to query BLOB and CLOB data type using DBMS_LOB.

Designed and developed in-house ETL process for the initial load of the historical news data into Oracle 11g partitioned databases.

Performed SQL tuning using various tools like Explain Plan and SQL Trace.

Designed and developed applications to load Multicast Messages and Elementized Data from multiple servers to one centralized Oracle database.

Environment: Oracle SQL, DDL, PL/SQL, SQL Developer, SQL *Plus, DML, DDL, Oracle Export/Import and Data Pump, Unix, C, C++, Pro*C, Shell Scripts, Awk, TCP Sockets, gdb, SQL Server, Access Database

Time Series Data Project

This is a Java based REST Web Service Application allowing customers to query Corporate Earnings and Economic Indicators in time series. This application consists of the Client Layer, REST Web Service Layer, Business Service Layer and Persistence Layer.

Responsibilities:

Developed Java APIs to load Excel Spreadsheet Data into MongoDB, a schema-less database.

Designed and developed Java APIs in the Business Service Layer to retrieve data from the Persistence Layer, format JSON-like response and pass the response back to the Web Service Layer.

Developed Data Access Object (DAO) in the Persistence Layer to retrieve data from MongoDB.

Developed Backfill Excel Reports for data gaps.

Environment: Java, JAXB, XML, REST Web Service, Apache, Json, MongoDB, log4j

SEC 13F Headlines Automation Project

This is Java application to produce headlines for investment changes, adds or deletes for major investment managers.

Responsibilities:

Created event handler to process incoming XML data.

Analyzed, designed and developed complex business logic to roll up multiple levels of data and determine if investment is change, add or delete and stored the result as json format in MongoDB.

Designed and developed Java APIs in the Business Service Layer to retrieve data from the Persistence Layer, format JSON-like response and pass the response back to the Web Service Layer.

Environment: Java, JAXB, XML, REST Web Service, Apache, Json, MongoDB, log4j

Low Latency News Service Project

The Low Latency News service provides an interface to the integrating applications to search for news content and subsequently subscribe to the real-time news updates. Responsibilities:

Developed Java API to process HTTP Requests and pass response back

Developed mapping between relational database tables and object oriented java objects using Hibernate.

Designed and developed Java API for multiple permission levels.

Environment: Java, JDBC, XML, Web Service, Apache, Oracle 11g, ORM, log4j

AT & T Communications - Feb 1988 to Aug 2005 - Project Lead

Location And Building Inventory Project

The is one of the components in the Database of Record, a Data Warehouse Project. It collected different inventory data such as switch capacity, equipment, ordering, and sales from the various systems. The data was then normalized and reconciled in order to build Oracle Data Marts to support Metrics, Operational Reports and user Ad Hoc Queries.

Project led a team of 4 to 6 developers to develop a variety of web-based tools that allow users to easily view and download reports as well as perform ad-hoc queries to analyze in support of business decisions.

Designed and developed ETL to extract data from various databases such as Oracle and Sybase, translate and load the data to Oracle 8i databases using PL/SQL, Oracle stored procedures, C, Pro*C, Unix Shell Scripts, SQL Loader on UNIX platform.

Designed and developed web interface for ad hoc, viewing and downloading, updating data using ASP, VBScript, JavaScript, HTML on the Window NT/2000 and IIS platform.

Developed processes to add and retrieve geographic coordinates to building addresses, provide mapping for analyzing business data using Oracle Spatial, MapInfo MapMarker Plus and MapXtreme.

Designed and Implemented a Monitoring Process interfacing with Tivoli to track, alarm and report job failures. This process creates process log, sends messages to IBM Tivoli Management System for critical errors to create trouble tickets, generate email and paging messages to production support.

Using Oracle Discoverer, designed and created End User Layers from Oracle 8i database, developed easy-to-use web interface to “drill down” on specific metrics to identify root causes, “roll up” data to summarize results and to “slice & dice” data for customized report views

Led the implementation of server migration and Oracle Upgrade.

Developed Project Plan, tracked testing results, documented Installation Plan and Backout Plan.

Environment: C, Pro-C, Oracle SQL, DDL, PL/SQL, SQL Developer, SQL *Plus, DML, DDL, SQL Loader, Oracle Spatial, Oracle Discoverer, Awk and Shell Scripts, MapInfo MapMarker Plus, MapXtreme, Interdev, IIS, PVCS

Integrated Sales and Services System (ISS)

Led a project team of as many as 4 members in developing and maintaining the Common Table Domain on UNIX, Oracle, Tuxedo Platform.

Represented the organization in a Data Team to define table data for all involved systems and ensure data integrity across organizations.

Performed data analysis and developed data requirement for Integrated Order Taker and New York Local Projects.

Designed Relational Information Model using Teamwork.

Enhanced the Load Process to accommodate the ever-increasing amount of data.

Environment: C, Pro-C, SQL Loader, Awk and Shell Scripts on UNIX, Oracle, Tuxedo Platform.

Stepout Billing Project

Led a project team of as many as 6 members in developing and maintaining the Post Bill System. Job duties included system analysis, design, coding and unit testing.

Supported Journal Interface, Tolldata Interface, etc.

Environment: COBOL, IMS, DB2, JCL, MVS

Billing Adjustment and Collection

Developed and maintained the Billing Adjustment and Collection in both Online and Offline environments.

Provided problem resolution of production problems and recommended system enhancements.

Interfaced with Data Centers and User Groups.

Environment: Pl/1, IMS/DB, IMSVSAM, JCL, MVS

EDUCATION

Bernard M. Baruch College - BBA June 1987

Major: Management Information System. Minor: Statistics

Contact this candidate