OBJECTIVE:

Certified Oracle DBA/Developer experienced in physical, logical design, implementation, database support, performance tuning and problem solving seeking to join a team of established Information Technology Department.

SUMMARY:

• Over 12+ years of IT experience in database design, analysis, implementation and support using Oracle and SQL Server databases. Experience with multiple large full scale production databases in OLTP and OLAP environments. SQL programming and Data Analysis utilizing TOAD for Oracle.
• 10+ years experience in data analysis and report development utilizing Cognos, Business Objects and Crystal Reports as well as in design, programming, testing, implementation and documentation of complex code.
• Over 8 plus years in ETL development utilizing informatica, Pentaho and customized Java based ETL applications.
• Over 6 years experiencing leading both functional and technical teams, full software development life cycle implementations. Established and managed change control process and procedures for entire team. Trained and mentored operational analysts and SQL developers.
• Over 6 years experience in managing large scale projects and resources. Excellent communicator and collaborator.
• 6 years of Oracle Ebusiness Suite experience in implementation, configuration and training to the user community.

SKILL:

SQL Server 2000 Administration Informatica ETL: Pentaho ETL (Kettle) Cognos Data Modeling and Mining Business Objects and Crystal Reports Java and C# HTML and XML

EXPERIENCE:

Confidential

Lead Data Analyst/Solutions Architect

Responsibilities:

• Designed and built ETL queries to create enterprise wide solutions for disparate business areas.
• Created solutions for the operational analysts in oracle e - business suite which increased productivity by 50% while generating campaign lists.
• Streamlined the campaign selection process from a 4 step process to a one step process using the Oracle ebusiness suite technology.
• Provided SQL training to operational analysts and performance tuning training to SQL developers to increase their efficiency in donor segmentation and list generation.
• Supported the entire company’s marketing department, in providing campaign list, donor segmentations and reporting on all their marketing efforts.
• Translated conceptual ideas and business rules into solutions design that enforced the business rules while satisfying industry best practices.
• Oversaw the work of a team of Data Analysts ensuring that the customer requests are assigned to the appropriate developer and delivered in a timely manner.
• Provided technical guidance and direction to more than 6 developers in defining the data architecture strategy for individual projects within the business and provide on-going coaching and skill development.
• Created and enforced quality assurance and procedures via design reviews and peer reviews to ensure accuracy and adherence to standards and business rules.

Confidential

Business Intelligence Engineer

Responsibilities:

• Plan and design and compose the ETL to create Oracle database tables
• Pull data from several Oracle tables to develop enterprise wide reports using Cognos.
• Managed and prioritized incoming requests for new content into the data warehouse.
• Managed and prioritized trouble tickets issued against the data warehouse and assigned them to the appropriate individual who can fix the problem as well as ensuring that open trouble tickets are kept to a minimum number.
• Supported 1100 users, regarding issues and requests as well as documentation of the data warehouse objects available to the users.
• Trained different levels of data warehouse users on how to write efficient SQL to pull data from the data warehouse.
• Trained new users on data warehouse tools and how to pull data from the data warehouse.
• XML metadata maintenance.

Confidential

Senior Programmer/Analyst

Responsibilities:

• Plan and design an SQL Server 2000 database.
• Pull data from an Oracle database to SQL Server 2000 database
• Write complex queries for business analysis
• Combine data from multiple tables using joins and sub queries.
• Developed and maintained the company’s Do Not Call database as well as their Profitability Database in SQL Server 2000.
• Migrated from proprietary database to Oracle 9i
• Developed ETL queries using Informatica to implement business logic as well as for report development to support the migration to Oracle 9i.
• Informatica Metadata maintenance.

Confidential, Indianapolis, IN

SQL Server 2000 DBA/Developer

Responsibilities:

• Design and implement an SQL Server 2000 database.
• Map an entity-relationship diagram to database table architecture.
• Write summary reports that aggregate data and are grouped by common values
• Implement a backup and recovery strategy as well as tune queries for better performance.
• Develop and create stored procedures, triggers and packages.
• Manage distributed databases and replication
• Combine data from multiple tables using joins and subqueries.
• Experienced in ANSI JOIN SQL syntax, complex queries
• Applied data warehousing concepts and ideas into developing databases.

Confidential, Houston, TX

Junior Database Administrator/Developer

Responsibilities:

• Promoted from Help Desk Analyst to DBA.
• Migrated from MS Access Database to SQL 7.0.
• Design databases, tables, indices and other associated tracking mechanisms to facilitate customer matching within the MS SQL Server RDBMS.
• Design and execute search queries for customer matching. Analyze the results of the search queries to determine the success of individual queries and the need for further matching attempts.
• Analyze existing data in order to attempt customer matches.
• Develop and create stored procedures, triggers and packages.
• Designed, tested, debug and implemented programming projects.
• Responded to and resolved daily technical problems in a professional and timely manner.
• Tracked and monitored problems to ensure a timely and effective solution.
• Dealt with problems involving printers, e-mail, modems, networking issues, desktop applications such as VB.
• Provide technical phone support, installation assistance, reproduce customer bug scenarios, and escalate applicable cases to appropriate department.