Data Warehouse/business Intelligence Developer Resume
Boca Raton, FL
PROFESSIONAL EXPERIENCE:
Confidential, Boca Raton, FL
Data Warehouse/Business Intelligence Developer
Responsibilities:
- Data warehouse support
- ETL process improvement and troubleshooting
- Troubleshooting and enhancing UNIX scripts
- Writing Datastage 7.5 and 8.7 jobs
- Vendor Management
- Data analysis
Environment: SQL Developer Teradata Datastage 7.5/8.7 UNIX AS400
Confidential, FL
Systems Developer
Responsibilities:
- Data warehouse support
- Architecting Clickstream data warehouse
- ETL process improvement and troubleshooting
- Troubleshooting and enhancing UNIX scripts
- Writing new Datastage and SSIS jobs
- Troubleshooting Business Objects reports (6.5 and XI)
- Resolving ETL issues with nightly loads
- Vendor Management
- Updating UNIX scripts to implement real time load monitoring
- Creating triggers and stored procedures in SQL Server and Oracle
- Creating tables and indexes in SQL Server and Oracle
- Data analysis
Environment: SQL PLUS SQL Developer Oracle (10g) Oracle (11g) SQL Server 2008 R2 SSIS Visual Studio 2010 BIDS Datastage Business Objects (6.5 and XI) UNIX Welland Export
Confidential, Cincinnati, OH
Oracle Support Engineer
Responsibilities:
- Support and Troubleshooting of CSF Application
- Resolving tickets for end users
- Accessing log files to identify issues
Environment: SQL PLUS PL/SQL Oracle (10g) Oracle Forms 4.5 VAX/DCL
Confidential, Cincinnati, OH
Oracle Developer
Responsibilities:
- Implementing audit tables
- Designed and developed procedures to transform data from source systems to Oracle database
- Worked heavily with the ETL processes
- Worked with business users and developers to troubleshoot issues with staging data
- Worked with implementing custom validation package
- Worked on Oracle performance tuning
Environment: SQL PLUS PL/SQL Oracle (10g) Toad Data Manager Change Man (Source Code Control)
Confidential
Oracle Developer
Responsibilities:
- Wrote XML parsing engine in JAVA
- Creating functional and technical designs for Reports and Interfaces
- Creating data warehouse extract designs for ETL process
- Creating complex views based off of business logic for ETL process
- Worked with business users to get designs for extracts from mainframes to Oracle
- Mapping data from Cincom to Oracle
- Creating and updating PL/SQL packages in Oracle
- Worked with E - Commerce Gateway for a solution to print EDI purchase orders
- Aided in configuration of AventX
- Configure and support for Applimations
- Designed and implemented new purchase order
- Trained end users on creating custom help files
- RICE development
Environment: SQL PLUS PL/SQL Oracle (11i) Java SQL Developer Toad Oracle Forms 6i Oracle Reports 6i
Confidential Cincinnati, OH
Software Developer
Responsibilities:
- Data Modeling with Normalization to third normal form
- Modeled database for application
- Created views, stored procedures and tables
- Aided with creating reports using Crystal Reports
- Created unique Query Strings to bypass the need for a login
Environment: SQL Server VB.Net and Asp .Net