Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
Download Resume Format
Kylie Harris
P.O. Box 631001
Irving, TX 75001
Home (214) 621-9876
Email - kylie.harris@hotmail.com
Objective:
To provide technical database operational and architectural design support using Oracle relational database technologies. The position will allow me to use my analytical skills to design process architectures based on Oracle 11g and Netezza platforms supporting BI and data warehousing applications. My Oracle database migration experience has enabled me to create proven automated processes to load and manage load metadata. My goal is to function as a team leader and provide well designed methods to enhance the efficiency of ETL processes between enterprise business applications within the existing heterogeneous database application infrastructure.
Work Experience:
Electronic Transaction Consultants Corp ETCC, Database Administrator 01/11 present
SuperMedia, LLC, Database Administrator 11/07 12/10
Enkitec, Inc, Database Consultant 05/07 10/07
Pepsi Co Business Solutions Group, Database Consultant 07/05 5/07
First Horizon National Corp, Enterprise Technology Architect, 11/04 7/05
Apogen Technologies/Science Engineering & Associates, Database Architect 1/03 10/04
TIG Specialty Insurance, Data Warehousing Consultant, 7/01 12/02
First Horizon Home Loans, Database Consultant, 2/00 6/01
Entergy Services Inc, Senior IT Consultant, 6/98 2/00
Education:
Bachelor of Science, Computer Information Systems, Tulane University, 1988
Database Products:
Oracle Products:
RDBMS v7.3.4/v8.0.4/v8i/v9.2, 10g, 11g ASM, RAC, Grid Control
Data Warehouse Appliance:
Netezza Twin Fin Data Warehouse Appliance
Business Intelligence Products:
Microstrategy v9.0 Administration
IBM Data Stage Administration
Microsoft Products:
MS SQL Server 2000/2005, Microsoft Clustering Services, 64 bit database architecture
Operating Systems:
UNIX (Solaris, Sun/OS, HP-UX, AIX), MS Windows NT/2000/2003 Server
ETL (Extract Transform Load) Products:
IBM Data Stage
Informatica Power Center/Power Designer v7.1.2/6.2/5.2, Microsoft DTS
Specialty Training:
OBIEE (instructor led)
Informatica version 8 (Informatica Corp. instructor led)
Microstrategy v9.0 (Administrator)
Management/Leadership Skills:
Project Management, Systems Management, and experience as Team Lead for database technology section
Specialty Skills:
Data Warehouse Architecture and Design, Database Administration, Performance Tuning, Application Development Consulting, Capacity Planning Management, Database Server Consolidation, Clustering Technologies, Enterprise Cost Recovery Models
Life Cycle Expertise:
Requirement Analysis, ER Modeling using Erwin, Data Modeling, Logical Database Design, Physical Database Design, Database Administration, Application Development, Stress Testing, Database Tuning, Configuration Management, Training, Production System Deployment Support
Other Skills:
Oracle Financials Physical Database Administration (cloning), Knowledge of Data modeling, Data warehouse design using Star schema methodologies, Perl, Korn Shell Scripting, Awk
Project Experience:
Electronic Transaction Consultants Corp, ETCC
01/2011 current
Performed Oracle database administration duties including providing day-to-day support of application development team, backup and recovery activities and performance tuning tasks. Other duties include support of Oracle application server and Oracle RAC database environments. Provide guidance for performing standard process architectures. Perform design and support duties to implement data warehouse solution.
11/2007 12/2011
SuperMedia, LLC
Performed Business Intelligence and data warehouse support for the SuperMedia 14 Terabyte enterprise data warehouse system. The support included SQL query optimization, release SQL code migration and performance tuning. Designed and implemented automated custom data refresh scripted processes to support Production and Testing environments. Performed data warehouse migration from Oracle 10g to Netezza Twin Fin Data Warehouse Appliance. Created custom scripted processes to monitor and report on database utilitzation in the data warehouse environment. Performed data modeling activities to support data warehouse and dimensional MART models. Day to day duties include maintaining the proper disk space thresholds for the data warehouse and other production applications supported. Maintained RMAN database backup and recovery processes. Provided on call 24x7 support for operational database systems. Managed 14 Terabyte data warehouse system by managing database space efficiently using Oracle partition technology, and tuning poorly performing SQL processes.
5/2007 10/2007
Enkitec, Inc.
Installed and configured Oracle 10g RAC ASM databases. Installed and configured RMAN and Grid Control for production database environment. Implemented Oracle 10g partitioning for the customers primary production application tables.
7/2005 5/2007
Pepsi Co Business Solutions Group
Database professional supporting a very large and complex heterogeneous database environment including Oracle 7.3.4/8i/9i and 10g databases. Performed database related tasks including database creation and cloning of Oracle databases. Provided database construction, testing and analysis support of TIBCO, SAP and SAP BW environments. Provide Capacity Planning services to estimate application volume and database sizing requirements. Support application development activities by creating database objects and providing SQL query and process tuning support.
11/2004 7/2005
First Horizon National Corporation
Performed as an Enterprise database architect responsible for architecting and designing databases to facilitate application processes. Analyzed application data source systems to define reporting data warehouse objects. Support heterogeneous database environment including Oracle and MS SQL Server 2000 32 bit and 64 bit clusters to provide data warehouse enhancements as requested. Designed & implemented ETL SQL programs to support monitor system performance and capacity of data warehouse loads. Developed internal procedures to document and provide baselines for more efficient data warehouse process management to improve customer service and system availability. Enhanced the Enterprise IT Service Charges Model by performing analysis on new systems and providing SQL scripts and programs to capture cost metrics across the enterprise. Designed and maintained Microsoft DTS ETL product application process to capture home loan data from external vendors.
1/2003 10/2004
Science Engineering & Associates (Apogen Technologies)
Database architect for the US Governments Dept of Energy EEOICPA program where the project work was conducted on a US Navy facility. My duties included the design & implementation of Oracle SQL and PL/SQL programs. These programs provided services to provide data cleansing and analysis of Claim Case application data and congressional reporting for the Federal program. Design and construction of custom PL/SQL data extraction processes (ETL) to support proof of concept data warehouse application. Prepared design document for the initial design of the Data Warehouse model for the Dept. of Energy program Case Data subject matter. Designed and implemented a plan to migrate the current UNIX environment to a more powerful Solaris server. Architected and designed a high availability Oracle database standby architecture for the programs application availability requirement.
7/2001-12/2002
TIG Specialty Insurance, Inc.
Data warehouse DBA responsible for architecting and designing models to operate on application data source systems and data warehouse tables and views. Support development & production efforts in a widely distributed data warehouse environment by performing as a data warehouse architect. Duties included setup and configured Oracle 8i/9i database development in a 24x7 production environment. Designed financial controller databases and supporting ETL process to support EDI (Electronic Data Interchange) applications using Informatica Power Center to process insurance premium and claim transactions. The ETL process consisted of analysis of source systems, meetings with business analyst to create the technical specification document to build the production data feed, create mappings and transformations. For the Financial Data Warehouse support, duties included design & implementation of load processes in an Oracle/UNIX environment written in PL/SQL and UNIX Korn shell scripting.
2/2000-6/2001
First Horizon Home Loans, Inc.
Provided expert database support for application development efforts by performing as a lead DBA who installed, setup and configured Oracle 8i database development and test environments. Designed and created ETL process applications including financial contracts, bank reconciliation and accounting data archival project by designing and creating Korn Shell & PL/SQL programs. Provide logical data modeling services in the design of a new home loan origination application and reporting environment using Business Objects. Performed database application design and constructed application schema objects to support home loan applications. Design database infrastructure and implemented time & project management application in a SQL Server database environment.
1998-2/2000
Entergy Services, Inc.
Provide architecture, design and construction database support in the development, test and production of Oracle and Sybase databases in a 24x7 environment. Supported applications include financial, data warehouse and electrical power generation application infrastructure. Designed and built data warehouse tables and views using data modeling techniques. Consulting services provided include database design, query optimization, database performance tuning and backup & recovery. Provided capacity planning and server consolidation services for Entergys test systems.
Led a team of database administrators and provided database infrastructure design expertise. Provide testing support for all corporate mission critical and important applications for Year 2000 certification testing. The application testing was performed on the following database server platforms: Oracle, Sybase, Microsoft SQL Server and DB2 databases running on Sun Solaris and IBM AIX servers.
1997-1998
Oracle Consulting
Provide Oracle data warehouse architecture and design services. Provide performance tuning services (query optimization and database configuration) performance and capacity planning for Oschner Health Plan. The Oracle database environment consisted of Dynix on Sequent SMP servers. Designed reporting data warehouse model and initial data loads for the environment for medical and clinical service providers. Designed and implemented ETL design standards and created technical specification for the data transformation process. Provide data warehousing and business intelligence consulting services such as source systems analysis and requirements gathering and BI tool demonstrations and application prototyping.
1996-1997
IBM Open Systems Center
Provided database administration design and performance tuning services (query optimization, database configuration) for Oracle, Sybase, Microsoft SQL Server and DB2databases running on IBM AIX servers. These DBA services were performed for leading insurance-investment, telecommunications, medical and telephone companies. Provided training to customer and IBM personnel on database design and performance & tuning techniques. Provided data warehouse design support for Oracle parallel server very large applications and databases running in the IBM Scalable Parallel server environment. Provided IBM technical training sessions to IBM architects and customer personnel on Internet database connectivity. Enrolled in the IBM IT Architect Certification program.
1994-1996
Entergy Services
Provided database administration and data warehouse support for Oracle, Sybase and Microsoft SQL Server databases. Provided logical and physical database design for financial contract management system, human resource and marketing database application systems. Designed logical data models and physical models to implement a marketing application as a data mart/operational data store. Wrote performance monitoring stored procedures & ETL shell scripts in this complex database environment. Designed and created stored procedures to provide a corporate hierarchy rollup for a human resource department.
1994
Medical Center of Louisiana
Provided database and systems administration support for the implementation of the StatLAN/OASIS medical orders system. Services included ETL application design consulting and database design. This system interfaced with the LA State hospital patient admission system using HL7.
1993-94
Freeport McMoRan
Provided application design consulting services by creating an ETL process, which extracts corporate financial consolidation system using Informix 4GL, custom C programs and UNIX shell scripts. Designed and implemented an Informix database to support this ETL application from Today/SFL source system. The consolidation system benefited the financial controller group by reducing the amount of time required to summarize financial information for the corporation from days to minutes.
1992-1993
Mobil Research Center
Provided UNIX system administration and network administration support for the Mobil Research Center in Farmers Branch, TX comprised of IBM, Digital, HP, Silicon Graphics and Auspex UNIX servers.
1990-1992
E-Systems Inc.
Provided UNIX system administration support for the application development efforts. Designed and implemented a source code configuration management system to manage the development project. Designed databases for the Software Configuration Management & Release system using Informix 4GL language with Informix and Ingres databases.
1977-1990
Amoco Corporation
Provided extraction applications support by analyzing financial information data sources. Provided custom programming for corporate computer security applications reporting environment. The programs provide tracking information for financial assets and computer access.
P.O. Box 631001
Irving, TX 75001
Home (214) 621-9876
Email - kylie.harris@hotmail.com
Objective:
To provide technical database operational and architectural design support using Oracle relational database technologies. The position will allow me to use my analytical skills to design process architectures based on Oracle 11g and Netezza platforms supporting BI and data warehousing applications. My Oracle database migration experience has enabled me to create proven automated processes to load and manage load metadata. My goal is to function as a team leader and provide well designed methods to enhance the efficiency of ETL processes between enterprise business applications within the existing heterogeneous database application infrastructure.
Work Experience:
Electronic Transaction Consultants Corp ETCC, Database Administrator 01/11 present
SuperMedia, LLC, Database Administrator 11/07 12/10
Enkitec, Inc, Database Consultant 05/07 10/07
Pepsi Co Business Solutions Group, Database Consultant 07/05 5/07
First Horizon National Corp, Enterprise Technology Architect, 11/04 7/05
Apogen Technologies/Science Engineering & Associates, Database Architect 1/03 10/04
TIG Specialty Insurance, Data Warehousing Consultant, 7/01 12/02
First Horizon Home Loans, Database Consultant, 2/00 6/01
Entergy Services Inc, Senior IT Consultant, 6/98 2/00
Education:
Bachelor of Science, Computer Information Systems, Tulane University, 1988
Database Products:
Oracle Products:
RDBMS v7.3.4/v8.0.4/v8i/v9.2, 10g, 11g ASM, RAC, Grid Control
Data Warehouse Appliance:
Netezza Twin Fin Data Warehouse Appliance
Business Intelligence Products:
Microstrategy v9.0 Administration
IBM Data Stage Administration
Microsoft Products:
MS SQL Server 2000/2005, Microsoft Clustering Services, 64 bit database architecture
Operating Systems:
UNIX (Solaris, Sun/OS, HP-UX, AIX), MS Windows NT/2000/2003 Server
ETL (Extract Transform Load) Products:
IBM Data Stage
Informatica Power Center/Power Designer v7.1.2/6.2/5.2, Microsoft DTS
Specialty Training:
OBIEE (instructor led)
Informatica version 8 (Informatica Corp. instructor led)
Microstrategy v9.0 (Administrator)
Management/Leadership Skills:
Project Management, Systems Management, and experience as Team Lead for database technology section
Specialty Skills:
Data Warehouse Architecture and Design, Database Administration, Performance Tuning, Application Development Consulting, Capacity Planning Management, Database Server Consolidation, Clustering Technologies, Enterprise Cost Recovery Models
Life Cycle Expertise:
Requirement Analysis, ER Modeling using Erwin, Data Modeling, Logical Database Design, Physical Database Design, Database Administration, Application Development, Stress Testing, Database Tuning, Configuration Management, Training, Production System Deployment Support
Other Skills:
Oracle Financials Physical Database Administration (cloning), Knowledge of Data modeling, Data warehouse design using Star schema methodologies, Perl, Korn Shell Scripting, Awk
Project Experience:
Electronic Transaction Consultants Corp, ETCC
01/2011 current
Performed Oracle database administration duties including providing day-to-day support of application development team, backup and recovery activities and performance tuning tasks. Other duties include support of Oracle application server and Oracle RAC database environments. Provide guidance for performing standard process architectures. Perform design and support duties to implement data warehouse solution.
11/2007 12/2011
SuperMedia, LLC
Performed Business Intelligence and data warehouse support for the SuperMedia 14 Terabyte enterprise data warehouse system. The support included SQL query optimization, release SQL code migration and performance tuning. Designed and implemented automated custom data refresh scripted processes to support Production and Testing environments. Performed data warehouse migration from Oracle 10g to Netezza Twin Fin Data Warehouse Appliance. Created custom scripted processes to monitor and report on database utilitzation in the data warehouse environment. Performed data modeling activities to support data warehouse and dimensional MART models. Day to day duties include maintaining the proper disk space thresholds for the data warehouse and other production applications supported. Maintained RMAN database backup and recovery processes. Provided on call 24x7 support for operational database systems. Managed 14 Terabyte data warehouse system by managing database space efficiently using Oracle partition technology, and tuning poorly performing SQL processes.
5/2007 10/2007
Enkitec, Inc.
Installed and configured Oracle 10g RAC ASM databases. Installed and configured RMAN and Grid Control for production database environment. Implemented Oracle 10g partitioning for the customers primary production application tables.
7/2005 5/2007
Pepsi Co Business Solutions Group
Database professional supporting a very large and complex heterogeneous database environment including Oracle 7.3.4/8i/9i and 10g databases. Performed database related tasks including database creation and cloning of Oracle databases. Provided database construction, testing and analysis support of TIBCO, SAP and SAP BW environments. Provide Capacity Planning services to estimate application volume and database sizing requirements. Support application development activities by creating database objects and providing SQL query and process tuning support.
11/2004 7/2005
First Horizon National Corporation
Performed as an Enterprise database architect responsible for architecting and designing databases to facilitate application processes. Analyzed application data source systems to define reporting data warehouse objects. Support heterogeneous database environment including Oracle and MS SQL Server 2000 32 bit and 64 bit clusters to provide data warehouse enhancements as requested. Designed & implemented ETL SQL programs to support monitor system performance and capacity of data warehouse loads. Developed internal procedures to document and provide baselines for more efficient data warehouse process management to improve customer service and system availability. Enhanced the Enterprise IT Service Charges Model by performing analysis on new systems and providing SQL scripts and programs to capture cost metrics across the enterprise. Designed and maintained Microsoft DTS ETL product application process to capture home loan data from external vendors.
1/2003 10/2004
Science Engineering & Associates (Apogen Technologies)
Database architect for the US Governments Dept of Energy EEOICPA program where the project work was conducted on a US Navy facility. My duties included the design & implementation of Oracle SQL and PL/SQL programs. These programs provided services to provide data cleansing and analysis of Claim Case application data and congressional reporting for the Federal program. Design and construction of custom PL/SQL data extraction processes (ETL) to support proof of concept data warehouse application. Prepared design document for the initial design of the Data Warehouse model for the Dept. of Energy program Case Data subject matter. Designed and implemented a plan to migrate the current UNIX environment to a more powerful Solaris server. Architected and designed a high availability Oracle database standby architecture for the programs application availability requirement.
7/2001-12/2002
TIG Specialty Insurance, Inc.
Data warehouse DBA responsible for architecting and designing models to operate on application data source systems and data warehouse tables and views. Support development & production efforts in a widely distributed data warehouse environment by performing as a data warehouse architect. Duties included setup and configured Oracle 8i/9i database development in a 24x7 production environment. Designed financial controller databases and supporting ETL process to support EDI (Electronic Data Interchange) applications using Informatica Power Center to process insurance premium and claim transactions. The ETL process consisted of analysis of source systems, meetings with business analyst to create the technical specification document to build the production data feed, create mappings and transformations. For the Financial Data Warehouse support, duties included design & implementation of load processes in an Oracle/UNIX environment written in PL/SQL and UNIX Korn shell scripting.
2/2000-6/2001
First Horizon Home Loans, Inc.
Provided expert database support for application development efforts by performing as a lead DBA who installed, setup and configured Oracle 8i database development and test environments. Designed and created ETL process applications including financial contracts, bank reconciliation and accounting data archival project by designing and creating Korn Shell & PL/SQL programs. Provide logical data modeling services in the design of a new home loan origination application and reporting environment using Business Objects. Performed database application design and constructed application schema objects to support home loan applications. Design database infrastructure and implemented time & project management application in a SQL Server database environment.
1998-2/2000
Entergy Services, Inc.
Provide architecture, design and construction database support in the development, test and production of Oracle and Sybase databases in a 24x7 environment. Supported applications include financial, data warehouse and electrical power generation application infrastructure. Designed and built data warehouse tables and views using data modeling techniques. Consulting services provided include database design, query optimization, database performance tuning and backup & recovery. Provided capacity planning and server consolidation services for Entergys test systems.
Led a team of database administrators and provided database infrastructure design expertise. Provide testing support for all corporate mission critical and important applications for Year 2000 certification testing. The application testing was performed on the following database server platforms: Oracle, Sybase, Microsoft SQL Server and DB2 databases running on Sun Solaris and IBM AIX servers.
1997-1998
Oracle Consulting
Provide Oracle data warehouse architecture and design services. Provide performance tuning services (query optimization and database configuration) performance and capacity planning for Oschner Health Plan. The Oracle database environment consisted of Dynix on Sequent SMP servers. Designed reporting data warehouse model and initial data loads for the environment for medical and clinical service providers. Designed and implemented ETL design standards and created technical specification for the data transformation process. Provide data warehousing and business intelligence consulting services such as source systems analysis and requirements gathering and BI tool demonstrations and application prototyping.
1996-1997
IBM Open Systems Center
Provided database administration design and performance tuning services (query optimization, database configuration) for Oracle, Sybase, Microsoft SQL Server and DB2databases running on IBM AIX servers. These DBA services were performed for leading insurance-investment, telecommunications, medical and telephone companies. Provided training to customer and IBM personnel on database design and performance & tuning techniques. Provided data warehouse design support for Oracle parallel server very large applications and databases running in the IBM Scalable Parallel server environment. Provided IBM technical training sessions to IBM architects and customer personnel on Internet database connectivity. Enrolled in the IBM IT Architect Certification program.
1994-1996
Entergy Services
Provided database administration and data warehouse support for Oracle, Sybase and Microsoft SQL Server databases. Provided logical and physical database design for financial contract management system, human resource and marketing database application systems. Designed logical data models and physical models to implement a marketing application as a data mart/operational data store. Wrote performance monitoring stored procedures & ETL shell scripts in this complex database environment. Designed and created stored procedures to provide a corporate hierarchy rollup for a human resource department.
1994
Medical Center of Louisiana
Provided database and systems administration support for the implementation of the StatLAN/OASIS medical orders system. Services included ETL application design consulting and database design. This system interfaced with the LA State hospital patient admission system using HL7.
1993-94
Freeport McMoRan
Provided application design consulting services by creating an ETL process, which extracts corporate financial consolidation system using Informix 4GL, custom C programs and UNIX shell scripts. Designed and implemented an Informix database to support this ETL application from Today/SFL source system. The consolidation system benefited the financial controller group by reducing the amount of time required to summarize financial information for the corporation from days to minutes.
1992-1993
Mobil Research Center
Provided UNIX system administration and network administration support for the Mobil Research Center in Farmers Branch, TX comprised of IBM, Digital, HP, Silicon Graphics and Auspex UNIX servers.
1990-1992
E-Systems Inc.
Provided UNIX system administration support for the application development efforts. Designed and implemented a source code configuration management system to manage the development project. Designed databases for the Software Configuration Management & Release system using Informix 4GL language with Informix and Ingres databases.
1977-1990
Amoco Corporation
Provided extraction applications support by analyzing financial information data sources. Provided custom programming for corporate computer security applications reporting environment. The programs provide tracking information for financial assets and computer access.
Download Resume Format
.JPG)
0 comments:
Post a Comment