Sr. Business Intelligence Specialist

Brian Harris

**** ***** *** **. #*** San Diego, CA 92111 858-***-**** ac3ro8@r.postjobfree.com

PROFILE

Senior Data Warehouse Specialist with expertise in SQL development. Numerous technical competencies including AGILE, ETL, Cloud, SaaS, Oracle, MySql, SQL Server, DB2. Communicate effectively one-on-one or in groups, working with clients or delivering trainings. Exceptional ability to build client relationships and manage realistic expectations for project deliverables and timelines within their IT infrastructure. Excellent verbal/written communication skills, including active listening. Strong programming, database ETL development, report creation and network administration skills.

PROFESSIONAL EXPERIENCE

XIFIN, Inc., San Diego, CA 3/2014 – Present

Sr. Business Intelligence Specialist

As an ETL Developer work with confidential Patient History Information (PHI) to move customers’ online transaction processing (OLTP) database from cloud storage to the data warehouse.

Troubleshoot and develop solutions for ETL/Oracle performance issues.

Troubleshoot and develop solutions to improve data accuracy.

Provide production support by performing nightly ETL jobs for 150+ customers. Research and resolve data load (ETL) issues from the different data environments.

Develop custom business intelligence reports on SAP (Oracle) including troubleshooting (bug fixes).

Work with SQL reporting services (SSRS) to produce standard and ad hoc reports.

Investigate bugs for the Enablement Support Team, providing problem identification with four hours and customer resolution within two days.

Service-Now, San Diego, CA 1/2013 – 3/2014

Technical Associate Developer – Performance Dept.

Supported client performance issues for an enterprise IT cloud company / SaaS provider offering automation of manual tasks, process standardization, and consolidation of legacy systems.

Troubleshot, diagnosed and provided solutions for performance issues for hosted clients in a Mysql/Oracle/MSSQLServer environment (primarily Unix).

Analyzed client performance issues related to network, database and user interface (UI). Performed analysis of transaction logs, Java wrapper logs, data structure and data distribution (VLDB databases), Javascript and Java Code.

Managed projects as assigned including investigation and resolution processes for ServiceNow application support to internal employees and clients, utilizing expertise in investigating technical problems and determining root cause/corrective action.

Hewlett Packard - Peregrine Systems, San Diego, CA 12/1999 – 1/2013

Technical Consultant Level IV - NASA/ACES Project (7/2011 – 1/2013)

Member of the HP Enterprise Services division supporting the $2.5 billion Agency Consolidated End-User Services (ACES) contract; worked from a remote home office.

Served on numerous implementation teams, uCMDB, DDMI and AssetManager, to manage and maintain the IT infrastructure across the agency’s research and flight centers.

Primary production support resource/subject matter expert (SME) to multiple application teams for Oracle DBA.

Created standard Oracle reports to address key operational needs and produce ad hoc reports.

Technical Support Engineer Level III / Database Specialist (12/1999 – 7/2011)

Administered 3rd level escalated technical support to Fortune 500 accounts using AssetManager software. Identified, researched, and resolved technical issues through phone support and WebEx.

Provided implementation and migration support to the services and consulting community.

Worked closely with client’s Asset Management Administrator for strategic planning, hardware requirements and adherence to best practices. Provided recommendations to meet customer performance requirements.

Mentored and trained 1st and 2nd Level Engineers to ensure growth of technical expertise.

Continuously evaluated and improved key technical support processes and tools as a KCS (Knowledge Centered Support) Core Team Member.

Wrote, edited, and maintained technical documentation for U.S., European, and China based development and technical support teams, and provided direct technical support.

Managed database administration/tuning issues on Oracle, Sybase, MSSQL Server, DB2.

Trained department staff in basic Oracle and DB2 administration as the Oracle SME.

Independent Contractor, San Diego, CA 6/1999 – 12/1999

IT Consultant

Provided IT services for the San Diego Insurance Adjusters Association (SDIAA) including Web development, Active Server Page development (Access Database, forms), Interactive e-mail, Style Sheets, Relational Database Development, and created contact tracking database using MS Access.

KBM Building Maintenance, San Diego, CA 10/1996 – 10/1999

Manager of Customer Relations / MS Access Developer / Web Developer

Hired for a new position to reduce account losses due to lack of consistent account management. Rebuilt and strengthened client relations leading to decreased cancellations by 80% over 3 years.

Trained 200 employees (managers, front line and administrative staff) on customer service trainings, presenting information through employee newsletters and group trainings in Spanish and English.

Developed a customer service reporting system utilizing MS Access on a Windows 95/98 platform.

Part of implementation/Administration team for new Access software package (WINTEAM).

Created corporate website utilizing HTML, Adobe PhotoShop and Image Styler (Windows 95/98).

Sony Electronics, San Diego, CA 10/1990 - 10/1996

Service Representative

Provided technical support to customers, troubleshooting problems on electronic products.

MILITARY EXPERIENCE

Security Police Supervisor - United States Air Force, Cheyenne, WY

TECHNICAL SUMMARY

Unix, Linux, Windows

Oracle 8i, 9i, 10G, 11G PL/SQL

Java Scripting

SAP Data Services (ETL) / SAP Business Intelligence

Data Warehouse Development

Microsoft SQL Server 6.5, 7.0, 2000, 2005, 2008 T-SQL

Sybase 12.0, Sybase 12.5

IBM DB2 7.2, 8.1, 8.2.

MySql 5.0, 5.5, 5.6

Software: Microsoft Office Suite, MS Access, CRM systems (Service Manager)

INDUSTRY CERTIFICATIONS

Oracle Certified Professional 8i, 9i, 10G

IBM Certified Database Associate V8.1

SSPA Certified Support Professional

ServiceNow Certified System Administrator

EDUCATION

UC San Diego Extension, La Jolla, CA - Oracle, DB2, Unix, Java, MSSQL Server, Linux, Shell Scripting classes

University of Phoenix, San Diego, CA – BS, Business Administration and Management, 1995

Contact this candidate