|
|
 |
| |
Abraham Zachariah
Technical
Skills
Databases:
Oracle RDBMS V. 11g, 10g, 9i, 8i, 8, 7.x, SQL
Server, Microsoft Access
Software:
SQL, PL/SQL, Informatica, Oracle Forms & Reports,
Delphi, Visual Basic, SQR, C, Pro*C, SQL*Loader,
Crystal Reports, Perl, Eagle Pace, Eagle Star, Shell
Scripts.
Front End Tools:
Oracle Forms, Delphi, TOAD,
PL/SQL Developer, DBTRACK, Microsoft FrontPage
Data Warehouse:
Informatica Power Center,
SQL*Loader, PL/SQL, Oracle Import & Export
Design Tools:
Erwin, Designer 2000, MS Project
Version Control :
Microsoft Visual SourceSafe, Star Team, Rational
Clear Case, PVCS, SVN
Operating Systems:
HP-UX 11.0 (SAM), Sun Solaris 7 and 8, Windows (Vista,
XP, 2000, NT, 98, 95, 3.1), MS-DOS
Experience as an Oracle Consultant
Apr 2009 – Present
Health and Human Services
Commission, Austin ,
TX
Development and Implementation
of Match Ievs Project. Enhancements and Performance Tuning of
OIG projects that monitors of any irregularities of the State
Aid to the Applicants.
Role:
 |
Developed various Stored
Procedures, Triggers, Functions with PL/SQL for Match Ievs
project. |
|
Created and
implemented ETL programs that uploads Match Ievs data to the
Audit Data Warehouse. |
|
Responsible for Requirement
Gathering, Analysis, Logical Design and Development Match Ievs
project. |
|
Created various
Database Objects for
Match Ievs project which generates
various Reports that points out the irregularities in a
person’s income level and the current State Aid.
|
|
Database Performance Tuning of
Match Ievs Application. |
|
Tuning RDPS application code
using the DBMS Profiler, Tkprof and Explain Plans. |
|
Support and Maintenance of
various OIG Applications. |
Environment:
Oracle 10g, SQL, PL/SQL, SQL, Unix Shell Scripts, Rational
ClearCase, PL/SQL Developer, TOAD, Dbtrack, Unix
Nov 2007 – Apr 2009
Brown Brothers Harriman (BBH),
Boston,
MA
Data modeling, Development and
Implementation of various Oracle Database projects for the Fund
Accounting division that supports Eagle Star/Pace Panels and
Reports systems
Role:
|
Data Modeled, Developed and
Maintained NML and Russel Downstream Client Reporting
Projects. |
|
Created Portfolio Valuation
and Net Asset Value reports with Eagle Star and Oracle Stored
Procedures. |
|
Production Support of various
Eagle Star and Eagle Pace Exporters and
Uploaders. |
|
Created and Maintained Schemes
for Pace Uploaders and Exporters for Fund Accounting System. |
|
Performance Tuning
of Oracle Stored Procedures and Functions. |
|
Designed and Developed various
Oracle Packages, Stored Procedures and Functions that supports
Eagle Pace Uploaders and
Exporters. |
Environment:
Oracle 10g/9i , Eagle Star, Eagle Pace, PL/SQL, Mercator 6.7,
Unix, TOAD, DBTRACK, PVCS 8.1,
SVN
Dec
2006 - Oct 2007
Level3 Communications, Denver, CO
Responsible for the Design, Development and Maintenance of
ETL programs that uploads data into
Transaction
History and Reporting databases
Role:
|
Responsible for
Project Scope planning and staffing the team |
|
Designed various
Load programs and Stored Procedures with PL/SQL and
Informatica Power Center. |
|
In charge of various
Data Migration projects
consisting
of data sourcing, mapping, conversion and loading.
|
|
Implemented various Data Cleanup procedures, Transformations,
Scripts, Stored Procedures and Test plans. |
|
Troubleshooting and
Correcting of Data Acquisition failures from different
sources. |
|
Performance Tuning
of existing and new PL/SQL programs. |
Environment:
Oracle 10g , Informatica PowerCenter 8.1, PL/SQL, Shell
Scripts, Erwin, TOAD, DBTRACK
Jul 2006 - Dec 2007
Chicago Board of Trade, Chicago,
IL
Design and the Creation of
Outright/Spreads Load project for Time and Sales tracking for
Futures and Options where Trade data is extracted, transformed
and loaded into Trade Admin database and Data mart.
Role:
|
Responsible for
requirement analysis, process analysis, design and
development. |
|
Data Modeled Outright/Spreads
Load project. |
|
Created various Partitioned
Tables, Partitioned Indexes, Materialized Views for the
project. |
|
Developed Stored Procedures
and PL/SQL scripts that extract Trade data from ODM database,
convert prices into TREX, TICKS and CBOT formats, convert
contract month, create contract key and handle various
correction entries. |
|
Migrated data from various Trade Databases to the data mart
using Informatica PowerCenter. |
|
Translated and Loaded the business processes into Informatica
mappings for building the data mart. |
Environment: Oracle 10g & 9(i), Star Team,
Informatica Power Center 7.1, Unix Shell Scripts, PL/SQL,
DBTRACK, TOAD
Jun 2005 - Jul 2006
Cisco Systems, Austin, TX
Data
Architect and Team Lead for SDPO and MTTR projects. SDPO
automates the closing of the tickets that are generated by
certain customer related issues such as power outages, reboots,
and line bounces. MTTR tool provides Cisco technicians with a
mechanism to determine the order in which they should work on
tickets.
Role:
| Created
Oracle infrastructure and designed SDPO and MTTR applications. |
|
Assembled and Managed a team of six Developers that achieved
strong business unit satisfaction by providing consistent
results in quality and timelines. |
|
Involved in the design, development and implementation of the
Enterprise Data Warehousing (EDW) process and Data Mart. |
|
Designed ETL Mappings for the source systems data extractions,
data transformations, data staging, movement and aggregation. |
|
Performed extensive Design Reviews, Code Reviews and Test Plan
& Test Case Reviews for development team. |
Environment: Oracle 10g, & 9(i), Informatica PowerCenter 7.1, Oracle Forms &
Reports, Star Team, PL/SQL, DBTRACK, TOAD
Dec
2004 - May 2005
JP Morgan Chase, Jersey City, NJ
Enhancements, troubleshooting and support for Broker
Surveillance Application which
analyzes and monitor the sales
practices and trading compliance and reduces the possibility of
losses from fines, penalties and settlements. Using data
management and data mining technology, it helps to uncover rules
violations and identify suspect activities.
Role:
|
Performed data analysis and data
migration from the existing system into new system. |
|
Created Eagle Pace scripts to load
Sales data into Broker Surveillance tables. |
|
Created various stored procedures to
call from within the master procedure as well as Eagle Pace to
meet the business needs. |
Environment: Oracle 9(i), Eagle Pace, PERL, SQL Loader,
PL/SQL, Unix Shell Scripts, Rational ClearCase, Toad
Apr 2004 - Dec 2004
State Street Bank, Boston, MA
Designed and Implemented PHT project where Up to the
Minute data for the Positions, Holdings and Trading are made
available for all divisions of the Bank. PHT provides as-of
Position data and as-of Holdings data for trading dates and for
settlement dates to various investment funds, as well as
eliminates redundant data from the current system.
A single Accounting Transaction
Processing Engine will handle all inbound share transactions
that update Position, Holdings and Holding Encumbrances.
Role:
|
Designed
and Created Oracle database objects for the Loading and
Reporting of Positions, Holdings and Trading of Fixed Income
Securities among different portfolios. |
|
Created Scripts to test
various modules against real portfolio data and performed Unit
/ Integration testing. |
|
Responsible for Performance
Tuning and Sql Query enhancements for Repository Systems. |
Environment: Oracle 9(i), PL/SQL, SQL Loader, Unix Shell Scripts, Rational
ClearCase, Toad
Aug 2000 - Apr 2003
Bank of America, Dallas, TX
Design,
Development and Production Support of Bank of America's Global
Government Banking group Applications which provides special
banking services for the federal government. Two of those
systems were Bankruptcy and US Courts Applications which are
the rewrites of existing systems based on Sql Server database,
which are converted to Oracle and with online banking
functionality. Numerous enhancements were also implemented for
the applications. And the third system, USAMM was a new
application which manages deposits made by various government
agencies that must be forwarded to the treasury each day.
Role:
|
Performed Requirement
Gathering, Analysis, Logical Design and Development of
Bankruptcy, US Courts and Usamm Applications. |
|
Created various Shell Scripts,
Stored Procedures and Triggers as well as the User Interface
with Oracle forms 6i and Reports 6i. |
|
In charge of SQL and PL/SQL
Performance Tuning of Modules for the applications. |
Designed and implemented Data
Conversion and Loading projects for Bankruptcy and US Courts
that include Mapping, Converting and migrating data to Oracle
Databases.
|
Successfully completed three
major Data Conversion projects with data originated from
different SQL Server and Access databases, Excel spreadsheets
and various text files. |
|
Created Unix Shell Scripts for
automatic conversion and uploading of data. |
|
Responsible for maintaining
Data Quality throughout the environment by verifying the data
structure and by making sure data is captured correctly. |
|
Designed and developed mapping, transformation logic and
processes in Informatica for implementing business rules and
standardization of source data from multiple systems into the
data warehouse. |
|
Created complex Informatica mappings that involved extensive
use of transformations like Aggregator, Filter, Router,
Expression, Joiner, Sequence generator. |
Administration of Oracle 8(i)
and Sql Server 2000 databases for Courts System that manages the
financial transactions of various Courts around the country.
|
Monitoring of database
operational functions and statistics to ensure system
availability. |
|
Performance tuning of database
as well as applications. |
|
Responsible for managing user
access to the database. |
Environment:
Oracle 9(i) & 8(i), SQL Server 2000, Microsoft
Access, Informatica PowerCenter 5.1, Oracle Forms 6i, Reports
6i, PL/SQL, SQL Loader, RMAN, Erwin, Visual SourceSafe, HP-UX,
Unix Shell Scripts, Toad, HTML, FrontPage
Mar
1999 - Aug 2000
DMR Consulting Group, Dallas, TX
Provided Database expertise to
clients in Managing their Application environments as well as
improving the current architecture and support structure of the
databases for clients, Airline Pilots Association of American
Airlines as well as for the wholesale long distance calls
provider IXC Telecommunications.
Role:
|
Modeled and Designed an Oracle
database structure with Designer 2000, which stores membership
data for Airline Pilots Association. Responsibilities
included logical & physical design of the Database and the
Application. |
|
Designed and developed Parse
and Merge programs with Visual Basic, where different text
files containing the Pilots Information are parsed and merged
into SQL Server database tables and created various reports
from the updated tables with Crystal Reports. |
|
Administered SQL Server 7 &
6.5 database. |
| Developed
and Maintained Rate Import System for the wholesale billing
division of IXC Telecommunications. Duties included
gathering of Customer Requisites, Designing of the Rates
Import Application, Developing and Performance Tuning of the
Application. |
Environment:
Oracle 8(i), 8, SQL Server 7 & 6.5, Visual Basic, Designer
2000, Transact SQL, PL/SQL, SQR,
Crystal Reports, Oracle Forms 5
& Reports 3, Sql Loader, Toad, Unix Shell Scripts, Visual
Interdev, VBScript, XML, HTML
Mar
1998 - Mar 1999
Nationwide Insurance Co, Columbus,
OH
Development, Maintenance and
Upgrade of AIMS (Agents Information and Management System)
database for the management of Current as well as for the
Renewal/Termination of Insurance Agents.
Role:
|
Developed and Supported AIMS
application with Oracle PL/SQL, Forms 4.5 and Reports 2.5. |
|
Provided Database
Administration support to ongoing development efforts by
administering and maintaining Oracle 7.3 database,
environments and schemas for AIMS. |
|
Performed Database Tuning –
SGA tuning, Shared Pool tuning, SQL, PL/SQL areas, Disk I/O
tuning, routine checks of log and trace files to checkup the
database activities. |
|
In charge of User Security and
Access management. |
Environment:
Oracle 8 & 7.3,
Developer 2000 Forms 4.5 & Reports 2.5, Sql Loader, Oracle
Import/Export, PL/SQL, Pro*C, Microsoft Access, Unix Shell
Scripts, Sun Solaris 7, Windows NT
EDUCATION/CERTIFICATIONS
Oracle Certified Professional DBA Oracle Corporation
California
Master of Commerce,
University of Kerala,
India
M.I.S,
Financial Accounting, Cost Accounting, Corporate Taxation,
Economics.
|
|
 
|
