Database Team Lead Resume
Morrisville, NC
Introduction:
I am a database developer with demonstrated experience in planning, developing and implementing relational database to address business requirements, operation of client services, product support, and quality assurance. Proficient in Oracle stored programs, RDBMS design, database conversion, ETL, datawarehouse, reporting system. Adept at crisis management, trouble-shooting, problem-solving, and negotiating.
Experience:
December, 2005 – September, 2008 Confidential Morrisville, NC
Position: Database Team Lead of FRCO (Financial Risk Control Operation)
Responsibilities:
Oracle Database Design and Pl/SQL Development: Base on the business requirements, I designed and developed Oracle Pl/SQL programs for three different globalized corporate financial applications. The work includes developing, optimizing , unit testing, implementing and maintaining PL/SQL stored procedures, i.e. packages, procedures, functions, etc.
Reporting Database (Data Warehouse): I also developed reports from the database upon clients’ requests, or assist other functional groups to produced such reports; meanwhile, I designed new reporting data warehouse to meet the increasing demands by various organization of the company. Trained with ‘Informatica Developer Level I’, ‘Businese Object Universe Design’ in April 2008. Participated with the data warehouse and ETL process design, devlop and the reporting database build.
Business Analysis: Cooperated with four of the critical business branches within the firm, i.e. Corporate Real-estate, Account Payable, Expense & Supply Management and Legal Compliance Department, to analyze business rules and requirements according to the company standard, industry regulation and accounting needs.
The job also involves daily communication with the application users in New York, London, Singapore and Zurich to gather information, address and resolve day to day issues, plan enhancement to the existing product and design the global deployment. Set priority and balance work load for the database team.
April, 2005 -- December , 2005 Confidential Cary, NC
Position: Oracle Database Analyst
Responsibilities:
I was working as a Data Analyst at Election System & Software for the US voter registration database conversion project (Government Contract). The main responsibilities were:
- Analyze legacy data gathered from county governments across the United States;
- Establish/modify business rules base on the specified requirements of different local government;
- Design and remodel ETL process with various database tools (Data Junction, Toad, etc);
- Implement the conversion process and load data into the Oracle database with SQL and PLSQL;
- Create detail documentation on each State/County’s conversion process;
- Communicate with county governments to address and resolve issues discovered during the conversion.
August, 2001 – April, 2005 Confidential Durham, NC
Position: Development Oracle DBA/ Software Developer
Responsibilities:
I was working as a development DBA and database lead for NIEHS ‘National Toxicology Program’ database conversion project (Government Contract). The main responsibilities were:
- Examine and analyze business areas based on animal clinical trials requirements for ‘Toxicology Database Management System’ (TDMS) and ‘Laboratory Database Administration System’(LDAS);
- Design and modify Oracle database to demonstrate the logical context for the functional specifications, process flows, data models and relationship;
- Implement database, convert existing ADABAS data and load existing studies into Oracle;
- Utilized SQL, PLSQL and Java language to develop applications that automate the laboratory data to TDMS’s receive, upload and reporting process;
- Provide database administration, maintenance, update, backup/recovery, performance tuning for on going development;
- Utilize multiple tools across wide range of technologies to accomplish everyday tasks, including Oracle Enterprise Management Console, Oracle Designer, SQL Navigator, SQL*PLUS, NetBean, Java, XML, XSLT, HTML, MS Access, MS Visio, Excel, etc.
March, 2001 – August, 2001 Confidential Raleigh, NC
Position: Computer Programming Instructor
Responsibilities:
- College instructor of Java, C++, Oracle (SQL/PLSQL), Programming Logic and Design Concepts. Providing consultations to students with programming needs in Visual Basic, HTML, JavaScript and MS Access.
1998 – 1999 Confidential NSW, Australia
Position: Legal Work Assistant
Responsibilities:
Provided legal documentation preparation, appointment arrangement and other office administrative to support solicitors who gave free legal information and professional help toward under privileged groups in the community.
Education:
Postgraduate:
Confidential University
Rewards: LLB - Law degree
Undergraduate:
Confidential University
Rewards: BS - Athletic Physiology
Vocational:
Confidential College
Rewards: Vocational training on computer programming