Sql Server Data

Jason Ennor

Castle Rock, CO • 303-***-**** • *****.*****@*****.***

Profile

Oracle Database expert

Analytical and detail oriented. Innovation driver, able to provide strong technical leadership,

direction and mentoring. Strong SDLC process and methodology experience. Experienced

managing geographically disperse teams. Business analysis, evaluation, resource allocation,

systems specification, design, managing client relations, development, user acceptance testing,

implementation, and day to day support of enterprise wide cross functional high availability

strategic systems, Able to troubleshoot critical production issues, manage conflict, and

communicate up to the Executive level. Able to drive efficiencies and add value strategically and

tactically. Proficient in the use of software development methodologies, logistical planning and

data architectures. Strong background in data modeling, database and web design. SQL

optimization and performance.

In my spare time I enjoy maintaining a technical Blog and developing zoho apps. See my results

of an online Oracle proficiency test See my LinkedIn Profile

Education

BSc Computer Science

Skills

Oracle

Oracle 11gr2 10g 9i 8i XE, Application Express APEX, SQL Developer, SQL Data Modeler, PLSQL Developer, Enterprise

Manager, VPD

Languages

SQL, PL/SQL, Unix Shell Scripting, JavaScript, HTML, XML, CSS, PHP

Platforms

Windows, Linux, Unix. Amazon Web Services (AWS), MySQL, SQL Server

Tools

Eclipse, Subversion, SQL Server, Microsoft Access, Microsoft Visual Source Safe (VSS), CVS

Work Experience

2008

Comcast, DTC

Senior Enterprise Data Architect

• Managing the day to day development of business and operational support systems by an onshore team and an offshore

team

Rated "Highly Effective" in annual reviews

•

• ScrumMaster for an Agile develpment team integrating BPM, Jira Ticketing, Reporting and database utilizing Java

Hibernate Spring MVC JSP JSF OpenFaces Crystal Reports

• Implemented an Entity Attribute Value with Classes and Relationships EAV/CR metadata database design allowing

Master Data Management (MDM) data integration across the business

Designed a robust Data Access Layer to integrate with Java, incorporating fully automatic

•

data quality, auditing, history, cAsE iNsEnSiTiVe and recycle features

Implemented SAAS approval workflow system with internal and vendor approvals

•

Instituted SAAS secure password authentication sharing system

•

Amazon Web Services (AWS) Oracle 'cloud' implementation

•

salesforce.com API integration

•

Designed and developed billing system with change data capture and data archiving for Finance

•

Championed Test Driven Development techniques, Agile Methodology, and a new architecture

•

Pushed adoption of google docs, improving collaboration

•

Received a Recognition Award for reducing support calls

•

Automated password resets using plsql and html, saving time and improving security

•

Designed Data Auditing, History, Recent Changes, and Undo features for legacy systems, reducing Support Calls

•

Innovated a new agile release process allowing hot releases, reducing speed and quality of deployments

•

Pioneered a single sign on solution utilizing Active Directory Web Services, saving time on new development

•

Streamlined areas of responsibility, improving resource utilization

•

• Pioneered the use of Instant Messaging, Reservationless Conference Calling, and Live Meeting, partnering with the

training department to roll out adoption company wide

Led Best Practices PL/SQL training for database and application development teams, reducing bugs

•

2007

Reed Business Information (Multi channel Marketing), Highlands Ranch

Data Warehouse Developer

Maintained 3TB PL/SQL Data Warehouse (several billion rows), used to for print

•

subscription management and Direct Marketing list processing (address matching and

de duplication)

Created a Data Warehouse / Business Intelligence (DWH/BI) solution using PL/SQL and

•

SQL Server implemented using Agile Methodology to support online newsletter

subscription business

Instrumental in adoption of a wiki for document management

•

Web development using PHP Eclipse SubVersion and MySQL

•

2006

Verizon Wireless, Colorado Springs

Technical Architect

1TB Data Warehouse utilizing PL/SQL ETL from 17 disparate systems to support

•

customer billing

Developed a suite of automated random test data generation scripts, saving much time

•

and providing more rigorous testing data

Conducted technical interviews

•

Lead team effort to determine viability of database design

•

Introduction of SharePoint for document management, greatly improving documentation

•

quality

Implemented Microsoft Visual Source Safe for Source Control and Change Management,

•

ensuring more accurate releases

Replaced large Packages of PL/SQL code with Oracle Views feature, improving quality

•

and performance

Designed new development methodology encapsulating business rules as reusable

•

PL/SQL Procedures and Functions, improving speed and quality of development

Instigated method of sending documents as links in Outlook email, reducing a wide

•

problem of email quota usage

Setup and ran regular team knowledge sharing sessions for PL/SQL training,

•

standardization, and code reviews

Creation of documentation to aid new hire integration, saving time and effort of senior

•

staff

1996

Oracle Corporation, Colorado Springs

Senior Developer

• Managed global team of 10 developers supporting Oracle Product Development of global 356x24x7 strategic high

availability web OLTP PL/SQL Web Application with 400 million rows and 900 concurrent users. This system was also the

primary benchmark test platform for new Oracle Database releases

• Designed Virtual Private Database (VPD) feature to restrict access to customer sensitive information on software security

vulnerabilities

Reduced support calls 30% by targeting user interface improvements based on call volume

•

Designed and developed new PL/SQL HTML CSS User Interface to mimic Oracle Applications

•

Introduced a prototyping methodology, reducing scope creep, speeding production implementations, and reducing bugs

•

Replaced written documentation with an online Help system, reducing costs

•

Responsible for ensuring web designs met 508 accessibility guidelines

•

Managed tuning and code optimization, liaising with DBA Team to identify performance bottlenecks

•

Introduced use of Source Code Repository to manage multiple concurrent releases

•

Managed day to day application support by allocating resources

•

Activities

2009

Membership of Toastmasters

2008

Membership of Rocky Mountain Oracle Users Group (RMOUG)

2006

Dale Carnegie Training

Subscriptions

BaseLine, ComputerWorld, Database Trends and Applications, eWeek, InformationWeek, Oracle

Magazine, SD Times

Contact this candidate