Resume Susan: Senior Oracle DBA consultant 

 

 

We only do consulting. 

No permanent job inquiries please.

 

Click here for Consulting rates.

 

 


Susan is a talented DBA with extensive experience in Oracle, particularly Financials.  She also has an impressive amount of experience with a variety of different architectures.  She is a certified accountant, an Oracle Certified Professional and is currently working on her OCM.

She enjoys volunteering her time at local schools.

Educational Background

1997-1998                     Business Network Analyst
1995-1996                    
Computer Science
1986-1995                    
Certified General Accountants
1982-1983                    
Business Administration

Professional Associations

19861995                  Certified General Accountant    
2001-2007                   Oracle Certified Professional
                                    Oracle Certified Master (in progress)

Technical Background

 

2006                             Eclipsys Software Sunrise Clinical Manager

2006                             Tecsys Software Clinical Supply Chain

2007                             Veritas Storage Foundation for Oracle 10g RAC

2006                             SQL Server 2005 Administration

2005                             Oracle 10G Administration 1 & 2

2001                             Oracle Certified Professional  8i

1999                             Fastrack to Powerbuilder, Online Business Systems.

1999                             Solaris 2.6 System Administration, Sun Microsystems.

1997                             Microcomputer Business Network Analyst
                                     Validectorian Award by class instructors

 

Architecture Experience Summary

  • Successful background working with stakeholders to develop architecture framework that aligns strategy, processes, and IT assets with business goals.

  • Work closely with project managers, developers, and focus groups to avoid redundancy, minimize expenditures, and improve overall synergy within organization.
  • In-depth experience establishing best practices and guidelines for selecting, developing, and implementing information systems within enterprise.
  • Acute knowledge of hardware, software, networking, applications, and systems engineering.
  • Familiar with architectural concepts of Information Technology Infrastructure Library, Open Group Architecture Framework, TOGAF and Institute of Electrical and Electronics Engineers.
  • Excellent communication, presentation, and organizational skills.

Technical Experience Summary

  • Database Architecture in Oracle 6x/7x/8x/9x/10g  (10 years including 7x24 hour support)

  • Database Administration in Oracle 6x/7x/8x/9x/10g  (10 years including 7x24 hour support)

  • Database Administration in DB2 (2 Years)

  • Database Administration SQL Server 2005/2000/7/6.5 (5 years including 7x24 hour support)

  • Database Administration Progress ver 8&9 (2 years)

  • Redhat Linux infrastructure upgrade

  • Database 9i Windows to 10g Linux infrastructure migration

  • Architectural Design, Bench Marking, Decision Making (10 years)

  • Database Design, Modeling, and Analysis (10 years)

  • Design & Development experience in ERP, CRM, Health Care, Manufacturing, Logistics, Agriculture, Telecom,  Pension/Financial Accounting & Management, etc. (10 years++)

  • HL7 Interfaces, design, test, implementation (2 years).

  • Implementation of Hosting services, using Linux (7 years)

  • Cognos reporting (8 years)

Professional Work Experience

January 2011 Oracle Solution Architect

  • Oracle Migration Project
  • Solutions for data center re-organization

July 2015 - December 2015  Senior Business Analyst

  • Emphasis on Financial Architectures
  • End to end Project Delivery from Project Charter to UAT testing

September 2008 Completion July 2015 

                                Project Team Lead, Solution Architect

                                Healthcare Employees Pension and Benefits

  • Custom Application Re-architecture using Oracle 10g Linux/Oracle AS 10g

  • Collect Requirements created custom repository for reporting
  • Development Integration Requirements
  • High level Functional and Non-Functional Requirements
  • Organize Project Team and Timelines
  • Design Solution and update Process/Procedures to align
  • Provide skills requirements for Future State of application
  • Workflow process Re-engineering
  • Tool Evaluation for developers
  • Evaluate Oracle BI tool for Reporting
  • Estimates, Budgets and resource assignment.

Mar 07 November 2008 -  Healthcare Employees Pension and Benefits Plan
                                               Solution Design Architect the solution upgrades are
                                               complete.  The project was completed two months early,
                                               under budget.

  • Gap Analysis for Pension, Disability and Rehabilitation System with    recommendations on areas requiring improvement
  • Architectural Design of Upgrade for Application/Database/Forms/Reports
  • Window to Linux Platform conversions, Data Conversion and Middle Tier Updates for new compilers and removal of obsolete functionality.
  • Development of Solutions Design Oracle Database, Forms and Reports
  • Implementation of Solutions Design, project planning, estimates on delivery of milestones. Development of implementation and test strategy Upgrade forms from 5 to 10g, upgrade database from 9i to 10g and from Windows to Linux. Deployment on new hardware.
  • Technical leadership and mentoring of Database Administrators and Oracle Developers
  • Security and Network Infrastructure implementation
  • Assisted Director of Information Services in technical interview of Oracle Developer for 6 months contract

 Jun 07 Jan 08       SAP Implementation Senior Business Analyst

  • Design of Future State Processes to SAP transactions
  • High Level Model of Design Cash Issuance Processing
  • High Level Model of Design Report Distribution Processing
  • Test and train Users on use on implementation of distribution list, cost center reporting and other reporting requirements
  • Test and train users on implementation of cheque printing for integration of existing systems and certifications.

Jan/06 June 07     Lead, Database Administrator lead, Co-Lead HL7 Interfaces

  • Formalize and standardize implementation procedures for project work, implement standards for database builds, security and OFA guidelines.
  • Staff Recruitment and Interview
  • Develop standards for PHIA and PHIPPA
  • Assessment of project readiness

Additional Experience:

Technical coordinator for Implementation Testing

  • Test Plan/Test Result research and co-coordinated downstream
  • System test sets for Client Registry implementation (patient records). 

 

Oracle DBA Project Lead DBA

Oracle 9i Database Administration SIMS 

  • Clone Oracle Database for Prod/Train instances for AIX San Configurations, Veritas clustered, backups, shell scripting for Surgical Instrumentation Management System. DBA Lead for all project activities. T2P Production planning. (7x24 support)

 

SQL Server 2005 Project Lead DBA

SQL DBA SQL Server 2005 SITS

  • Surgical Instrumentation Tracking System setup of database on SAN configuration. DBA Lead for all project activities. T2P Production planning. (7x24 support)

 

Oracle DBA Project Lead DBA

Oracle DBA CSCIS 

  • Clinical Supply Chain Management Information Systems. (7x24 support) for Implementation of Materials Management for Hospital.

  • Install and deploy Oracle 10g database, setup all Oracle software and services, with maintenance routines.  DBA Lead for all project activities.  T2P Production planning.

 

HL7 Interfaces - Integration Co-Lead Business Analyst

  • Project 1 - Regional Healthcare System Implementation (7x24 support)
  • Responsible requirements, system specs and deploying development resources to ensure completion of the interfaces.  Functional and Unit testing.  Build and deploy interface to application, troubleshooting.  Use Cases and requirements by interface specification.  Project co-lead for all interface implementation activities. T2P Production planning.
  • AWAC

International Indigenous Connectivity Network

Requirements for Community Based Infrastructure.

 

 

Mar 05 - Nov/05        Consultant - Senior Business Analyst,
                                    Database Administrator, System Analyst

  • Project 3 Ongoing support for Oracle Financials for local newspaper.  Needs Analysis.

  • Project 2 - End to end Analysis for Amalgamation of Dealer Funds for large investment firm. Preparation of Application Development plans including identification of test cases.

  • Project 1 - Feasibility Study for Regional Health Authority.

  • Requirements study, gap analysis, vision statements,

  • Executive summary reports, review of technical environment.

  • Internal Projects setup development environment using Oracle. Prepare presentation on Zachman Framework for Architecture SIG.         

 

2004-2005                  Senior Programmer Analyst

  • Defined project requirements, analysis for best practices.

  • Project Management. Design and develop solutions for Financial interfaces to MRP/ERP. Analysis for existing for Financial interfaces to MRP/ERP. Analysis for existing projects, and developed solutions using Oracle, PL/SQL, Progress, Cognos Impromptu and Unix.  

 

2003 -2004                 Consultant Database Administrator

  • SQL Server conversion project.  Failover strategy, change management process, and security. Custom developed Application, Watson, and Oracle 9, Implementation requirements. SQL Server deployment. (7x24 support)

                                               

2001-2003                 Consultant Database Administrator/Programmer Analyst

  • Business system analysis for customized financial applications.

  • Design and build of application, coding and project planning using

  • SQL, stored procedures, package programming, and triggers.

  • Re-engineer of Oracle DB, performance tuning and recovery set-     up. Using UML, Linux, Oracle 8i, Microsoft Project and PL/SQL Developer and CVS Version control. Quality Control testing. Process engineering and standards documentation.

  • Liaison with developers for issues requiring resolution.

 

 

2000 2001              Senior Systems Integrator Vice President

  • Design/Develop databases/repositories for clients as required using SQL Server 7.0, SQL Server 2000. Design and build project

  • Management Database using SQL Server for trouble ticket reporting and customer relationship management. Handle customer disputes, allocation of resources to projects, resolve system issues as required in ASP environment. Prepare model for new business requirements. Maintain client backups and recovery of data where required. Work with client to ensure requirements are met.   (7x24 support)

                                 Vice President Information Technology

  • Due diligence for pre-IPO Securities compliance.

                                   

 

1997 - 2000              Programmer/Analyst

  • Application Development using client server languages such as 4 GL, C, Embedded SQL, Unix scripting, Perl, and PL/SQL.

  • Relational databases such as Progress, Oracle and DB2.

  • Projects included billing system enhancements, new development projects such as Telpay/EDI and charges of finance overdue interest. Collection process development, Microsoft Office.

  • Real time application development such as on-line registrations. Design of reporting tools using Unix/Excel/Access/Cognos Data Warehousing Tools. Documentation of processes/user manuals. 

  • Responsible for trouble-shooting of internet billing in a client/server environment. Help Desk support for the customer service representatives, tier3.  (7x24 support)

 

1991 2002                Financial Consulting Independent (various)

                                    Accountant, Business Advisor

  • Preparation of Financial Statements in all levels of reporting small corporate matters to large government departments. Consult billing for Engineers/Technical, financial accounting systems such as Accpac and Simply Accounting.

  • Implementation of new financial systems. Database design and implementation for reporting issues outside of financial reporting requirements.

 

1990-1993                  Revenue Accountant/ Manager of Accounting            

  • In depth knowledge of the Public Administration Act including voucher issuance and authorization for all departmental spending.  Fleet vehicles for Taxable benefits. Worked with in a management capacity to oversee commitment accounting systems,  Employee reviews, and position descriptions for support staff, creating and reporting matrixes of measurements for evaluation of work performance. Compiling statistics of workgroup performance. Perform analysis of system requirements and implementation of new systems. Cost sharing agreements administration, contract Administration. Responsible for financial year reporting, forecasting of future and potential revenues. Troubleshooting System issues and implementation of new systems. 

  

1986 1990         Vendor Accounts Administrator/Licensing Clerk

  • Collection of vendor licensing revenues, responsible for timely collection of crown funds, revenue forecasting, sales statistics.

  • Set-up licensing system from manual records. Review existing policy of collection issues; prepare review of bankruptcy and receivership with provincial/federal jurisdiction.

           

 

IT Application and Support Tools

 

Database Technologies Used

Oracle 7.X.X, Oracle8i  8.1.7,Oracle 9i, Oracle 10g, Oracle 11g, Progress 8.2, DB2, SQL Server 7.0, SQL Server 2000,  SQL Server 2005, Access 95, Access 97, Access 2000, and Btrieve.  RAC and Veritas support for Oracle.

 

Network Technologies

Novell 4.11, Novell 5.0, Windows NT/2000 Server, LAN and WAN hosting, Linux platforms..

 

Operating Systems Supported

Linux/Unix, Windows 2000 Server, Windows NT 4.0, and Windows NT Client, SCO UNIX, Citrix. Redhat Enterprise 3.0 and up. AIX 5.2 and up.

 

Application Programming

PL/SQL Developer, SQL, 4GL scripting, UNIX shell scripting, C, Java, JavaScript,  HTML, Embedded SQL, Perl, Cognos scripting/data modeling, Powerbuilder

Microsoft Back Office.

 

Analytical Tools

Visio for Enterprise Architects, Enterprise Architect 7.5 a UML 2.1 based modeling tool for designing and constructing software systems, for business process modeling, and for generalized modeling purposes such as visualizing existing systems and processes