Oracle Developer/Database Architect Resume Profile

Profile

Senior database developer with strong background in Oracle and MS SQL Server.Excellent verbal and written communication skills.Broad experience in big data warehousing, biotech, high-tech manufacturing, telecommunications, and finance.Strong background in accounting and business principles.Strong data mining and ETL skills.Researching Hadoop, Hive, Map Reduce,NoSQL, MPP and Tableau.

Technical Skills

Programming Languages: SQL, Transaction-SQL, PL/SQL, SQL Plus, SQL Loader, C , XML, HTML, Perl, C
Database Software: Oracle 11g/10g/ 9i /8i, Teradata 6.1, MS SQL Server, SQL Server Query Analyzer, SQL Enterprise Manager, MS Access, Toad, PL/SQL Developer, Oracle Developer, Oracle Designer, Oracle Forms and Reports, Oracle Manufacturing, Oracle Financials, Oracle Express, Business Objects, ER/Studio, ErWin, SAS, Brio, Cognos, Crystal Reports, Informatica, MicroStrategy, DataStage, Microsoft Visual SourceSafe 6.0, VMware 5.0.0, SQL Server Integration Services SSIS , Tortoise SVN version control
Web Software: Visual Studio .NET, Adobe Acrobat, JBuilder
Multimedia Software: Adobe Photoshop, Adobe Premiere
Accounting Software: Oracle Financials, MS Excel
Operating Systems: MS Windows, UNIX, Solaris 10, Mac OSX

Professional Experience

Confidential

Oracle Developer/Database Architect

Wrote PL/SQL and SQL scripts for multiple ETL data mapping projects to consolidate US Postal Service districts, facilities, and customer data. Consolidationsled to efficiency and costsavings.
Wrote PL/SQL packages, procedures, and database triggers for multiple web applications. Optimized both existing and new code performance.
Reverse-engineered existing processes to reduce complexity. For example, transformed seven-table join to three. Created and published simplified data model.
Created tables, data load scripts, and DBMS jobs that pivoted and loadedaggregated data for reporting
Created simplified mapping process and API documents for price changes. API documents supported training of new Java and database developers.
Set standards for price change data validation by providing sample scripts
Worked on Agile team, trained Java developers on SQL concepts like self-join, anti-join, and use of SQL built-in functions
Created ERD diagrams using Oracle Designer, Visio, and Toad
Set code-review standards. Established new and enforced existing database design standards. Published best practices and naming conventions documents for database team. Used code reviews as opportunity to improve team knowledge and compliance with coding standards.
Created physical data models and metadata for new web applications and new product functionality. Wrote scripts to create new database objects: schemas, tables, constraints, indexes, materialized views, synonyms, and grants. Ensured new object definitions were consistent with existing object definitions.
Used Oracle 11g, 10g, Oracle Designer, Toad and Tortoise SVN
Converted existing shell scripts from UNIX to Linux

Confidential

Oracle Developer

Worked on Oracle 10g conversion project combining North American and World Wide customer data sources
Created ETL PL/SQL stored procedures and SQL scripts, scrubbed and loaded big data. Optimized SQL using parallel execution hints.
Wrote SQL scripts for data reconciliation and validation of ETL data
Created Excel spreadsheets of detail and summary data for customer review
Created partitioned tables

Confidential

Data Mining/Data Warehouse consultant

Using stored procedures, SSIS, and SQL Server jobs, created dashboard productivity reports from multiple fraud-detection applications for managers and analysts to assess effectiveness of employees working fraud cases
Performed ETL mapping of Falcon application data, including pulls from Teradata warehouse
Optimized existing stored procedures, including improving run time of one stored procedure from 13 hours to 1 hour
Automated existing reporting. Forexample,changed dashboard spreadsheet to auto populate hours worked by linking to SQL Server data warehouse timecard table, saving eight working hours a day.
Created Cognos reports

Confidential

Senior SQL Developer

Back-end SQL Server developer for Planet Wholesale web application
Research reported bugs
Implemented bug fixes by creating data change scripts and modifying existing application stored procedures
Created new stored procedures to automate profile changes

Confidential

Database Developer

Back-end SQL Server developer of ProRep sales application developed for PCs and PDAs
Created stored procedures, views, user defined functions and entity relationship diagrams ERDs using ERWin. Pre-QA tested application using VMware.
Used Microsoft SQL Server, Visio, VMware, and Microsoft Visual SourceSafe

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship