Bi Architect Resume
Atlanta, GA
Narrative:
Highly motivated and accomplished BI architect and database administrator responsible for installation and management of large data volume critical systems. I’ve worked in several large companies where I have orchastrated business intelligence applications to interface with all departments and executive levels. Providing business critical and timely reporing are always top priorities in business intelligence. I have a vast background designing, installing, maintaining, architecting database systems. Employing the all the principles of data modeling to create the logical and physical designs to support Business Intelligence, Data Warehousing, OLTP and Financial database systems. Industries include but are not limited to Utilities, Banking and Finance, Merchant Services, Telecommunications, Health Care, Transportation, Human Resources and Manufacturing. I have over 15 years of experience with business critical Software and Database technology. I bring a vast knowledge of systems, networks, database and software implementations and integrations. I have experienc with a number of different ETL tools and have no problem learing additional tools. My expertise also includes implementing new technology, tuning and optimization, SQL and PL/SQL
EDUCATION:
BS, Computer Science
SOFTWARE: Oracle RAC Database, OBIEE, Oracle IDM, Oracle UCM, GRID Control, Oracle Beehive, Oracle BAM, Oracle App Server, ODI (Oracle Data Integrator), Data Guard, BAM (Business Activity Monitor), Oracle Financials (10, 11, 11i), PeopleSoft, Lawson, Weblogic, Apache, Erwin, Essbase, Datastage (ETL), Data Mirror (ETL), Ab Initio (ETL), Oracle OWB (ETL), Unix Script, Business Objects, Cognos, Brio, Crystal Reports, SQL Server, Sybase, Novell Netware, Java, HTML, Cobol, BMC Patrol, Veritas, Perl, MS Project, Visio
O/S: Linux, Unix (Sun, HP, AIX, AT& T), Windows
ORACLE TOOLS: RMAN, Oracle Development Suite, Oracle Designer, Oracle Application Server, PL/SQL (Triggers, Procedures, Packages), SQL*Plus, SQL*Loader, Replication, Snapshots, Materialized Views, Oracle Workflow
ORACLE APPLICATIONS
SUPPORT: General Ledger, Oracle Payables, Oracle Fixed Assets, Oracle Purchasing, Oracle Accounts Receivable, Oracle Cash Management, Oracle Inventory and others
EXPERIENCE:
Confidential,Atlanta GA 09/10 Present
Contract BI Architect
- Responsible for application design and development of expenses financial analyzer.
- Development of models used with OBIEE to create dashboards for upper management.
- Responsible for the logical and physical design of database supporting the statisical analyzer for company profit and lost.
- Responsible for development of forecasting company expenses for future years.
- Responsible for development of profit plan to support upper management.
- Development efforts using Oracle 11g, OBIEE, PL/SQL
Confidential, Atlanta GA (9/07 08/10)
Business Intelligence and Database
- Responsibility for installation and configuration of millions of dollars in Oracle software. This includes Oracle RAC databases, OBIEE, Oracle applications server (Apache, Weblogic), Single Sign On, Oracle Portal, GRID Control, Oracle Data Integrator, OWB, Identity Management, Universal Content Management, Audit Vault and Database Vault.
- Responsible for Business Intelligence enterprise including data architecture, data modeling, data warehouse and reporting for 15 million daily transactions.
- Directly responsible for tuning and optimization of complex queries.
- Tasked with conversion of enterprise from SQL Server due to capacity and performance issue to Oracle RAC technology.
- Work directly with departments and executives to provde the reporting and mission critical information to drive profits and control cost.
- Responsible for Business Intelligence and reporting to provide key performance metrics to business units.
- I have a vast knowledge of technology, to include but not limited to Software, Hardware, Networks, Storage and Architecture to deliver the highest quality of applications and systems.
- After spending many years as a DBA I find those skill come in very handing in business intelligence.
- Working with Oracle product managers directly I bring a outstanding relationship with Oracle.
- Working with OBIEE, Oracle (10,11), Linux, Sql-Server (05,08), Java, .Net, Erwin, ODI, OWB, IDM, Audit Vault, TDE, Portal, Weblogic, Apache and other technology.
Confidential,Atlanta, GA (3/04 8/07)
Business Intelligence and Database
- Responsible for full life cycle development and database administration of data warehouse projects. Projects include custom reporting engine and flexible hierarchy architecture.
- Responsible for system design, configuration and product decisions for critical 20+ terabyte data warehouse systems.
- Responsible for installation and configuration of Business Intelligence systems.
- Responsible for data modeling and architecture of enterprise wide data warehouse web enabled J2EE system.
- System components include portal technology, discoverer, business intelligence tools, report servers and RAC 10g database.
- Responsible for ETL design, development and automation of load process. Including a streaming process to load millions of transactions per day.
- Responsible for database configuration and administration for data warehouse systems. Designing physical layout which includes partitioning, VPD policies, and TDE technology.
- Directly responsible for the architecture and technology and technical direction of major company projects.
- Key member of staff for all decision concerning systems, architecture, and configuration of internal computer systems.
- Conduct interviews with key department personnel to assess business needs and data warehouse requirements.
- Working with Unix (Sun Solaris), Linux (Redhat), Oracle (V9, V10g), Sql-Server, Windows XP, ErWin, Oracle OWB, Oracle Portal, Java and other technologies.
Confidential, Atlanta, GA (2/03 3/04)
Contract Architect / Database Administrator
- Responsible for installation and administration of Oracle database systems.
- Responsible for logical and physical database designs and implementations.
- Responsible for developing project plans, system specifications and detail documentations.
- Responsible for reverse engineering of database systems using ERWin.
- Responsible for tuning and optimizing Database, Applications, and Operating system.
- Responsible for technical hardware and software configurations and plans.
- Responsible for managing Oracle and Lawson financial and human resource system.
Confidential, Atlanta, GA (8/01 1/03)
Contract Architect / Warehouse Database Administrator
- Responsible for conducting interviews and developing functional requirements.
- Responsible for developing project plans (MS Project, Visio) and managing project team assignments.
- Administration of databases for product, test and development systems.
- Responsible for full life cycle development of data warehouse project.
- Responsible for technical hardware architecture and software solutions.
- Responsible for managing financial and personnel resources to budgetary constraints.
- Responsible for Data Dictionary and Data Models, which leverage multiple legacy systems.
- Responsible for logical database and physical Data Warehouse schema designs and implementation.
- Working with Unix (Sun Solaris), Windows 2000 and with Oracle database versions 8i and 9i.
- Other applications used to deliver decision support include WebMethods, Informatica PowerMart (ETL) and Business Objects. .
Confidential,Atlanta, GA (9/00 -7/01)
Contract Database Administrator / Fincncials
- Responsible for installation and administration of multiple Oracle Financial (11.0 and 11i) database systems.
- Handle upgrades, installs, cloning and migrations for different versions of Oracle Financials.
- Troubleshoot and install patches when applicable to maintain the smooth operation of the applications.
- Setup and use RMAN in the backup and recovery strategy for the database.
- Also work with the users and functional analyst to resolve problems and implement changes in Oracle and Lawson applications.
- Responsible for installing and configuring software (Optio, ADI, SmartDB, Java etc…).
- Working with version 11.0 and 11i Applications with Sun Solaris versions 2.5 and 2.6 with database versions 8.0 and 8.1.
Confidential, Atlanta, GA (4/99-9/00)
Contract DBA Warehouse / Data Modeling
- Responsible for (Erwin) logical/physical redesign and build multiple Oracle databases for a custom application.
- Handle upgrades, installs and migrations for different versions of Oracle and different platforms.
- Advise and direct the developers on technical issues and problem resolutions.
- Use ETL and PL/SQL for data scrubbing, triggers and procedures.
- Responsible for selection of hardware and software products.
- Troubleshoot and setup the development and production environments, as well as backup and recovery efforts with RMAN.
- In addition to Oracle administration, also handle Unix administration, Essbase administration and Datastage administration.
- The project includes both OLTP and Warehouse databases, which I tune, maintain and configure.
- Develop project plan using MS Project.
- Working with Sun Solaris versions 2.5 and 2.6 and database versions 8.0 and 8.1.
Confidential,Atlanta, GA (4/97-4/99)
Contract DBA / Warehouse Architect
- Manage technical staff and resources facilitating successful projects.
- Responsible for multiple warehouse databases, which furnish critical decision support information in the company.
- Responsible for Datamart and Warehouse design and build for decision support.
- Responsible for hardware and software architecture.
- Provide logical and physical database designs using Oracle\'s Designer 2000 and ErWin.
- Produce PLSQL load and backup procedures along with any other services to complete the life cycle of database management.
- Manage tuning of the database and queries, database migrations and upgrades.
- Space management and database rebuilds are among my responsibility.
- Work in multiple environments to include but not limited to Oracle 7 and 8, and Novell, Sun, HP and NT computers.
- Produce project plans for multiple projects using MS Project.
- Provide replication and snapshot database solutions for customer.
- Work with multiple customers to provide them with the best solution to fit their company needs, in the decision support area.
- Oracle installs and upgrades are part of my responsibilities.
Confidential,Atlanta, GA (8/95-4/97)
Contract Database Administrator- Responsible for the administration of five critical Oracle 7 database systems including production, development and training.
- These databases are responsible for processing all telephone service orders for nine states.
- Duties include insuring database integrity, storage allocation, system recovery, configuration changes, software upgrades and development.
- Tune OS and database parameters and objects to insure system peak performance for 500 users and system interfaces.
- Analyze and monitor database activity to provide capacity planning, identify potential problems and reorganize database when necessary.
- Provide guidance to co-workers and develop utilities, triggers and procedures to automate manual processes. Using Sun 1000 and 2000 systems running Solaris operating system.
Confidential, Hampton, VA (9/93-8/95)
Manager, Database Engineer