Resume

Sign in

BI ETL SQL Programmer Analyst

Location:
Ventura, California, United States
Posted:
November 14, 2018

Contact this candidate

Resume:

Bruce Kube **** E Hillery Dr, Phoenix, AZ *****

602-***-****, ac7o1x@r.postjobfree.com

Experience:

A seasoned professional with over 25 years of experience in creative and innovative solutions for business.

Extensive experience in all areas of Information Technology, including programming, support, systems design and management.

Strengths:

1) Ability to analyze the relationship between the needs of the computer user and their available resources;

2) Capacity for rapidly gaining expertise in new computer technologies and technology applications;

3) Excellence at providing management with the information they need for making business choices,

including highly developed proposals, reports, alternatives and plans.

Education:

Bachelors of Science in Computer Science, 1987, University of Nebraska, Lincoln, Nebraska

Positions Held:

ETL Developer

Make A Wish Foundation, Phoenix, AZ

Jan 2018 – March 2018

Provide recommendations on ETL infrastructure and select third-party tools for implementation. Evaluate buy-vs-build. Data profiling. Initial design of data warehouse. Using MS-SQL 2012, 2014, T-SQL, SSIS, and Visual Studio 2015.

Database Consultant

AP Professionals, for Banner Healthcare

Oct 2017 – Dec 2017

Contract role to convert existing ETL processes into current formats (DTS, BCP, Powershell, T-SQL, SSIS, (Microsoft SQL Server 2014 & 2016, and Visual Studio 2015)

Data Analyst and Programmer

Opera Solutions Inc.

May 2017 – current

Analyze existing ETL and data management processes, recommend and implement improvements. Working with healthcare.gov infrastructure. Microsoft SQL Server 2016, SSIS, Visual Studio.

SQL Programmer

Plain Green Loans

March 2017 – May 2017

Develop code with Microsoft SQL Server used for financial reporting, dashboard and ETL processes.

Data Warehouse Developer

TriWest Healthcare Alliance, Data Management

January 2016 - October 2016

Create new data warehouse environment for veteran-specific healthcare network. Performed initial discovery and developed strategic plans and layout for fact/dimension-based model from previous relational system using Microsoft SQL Server 2012 stack (T-SQL, SSIS, SSRS, PowerPivot) Extensive analysis and rework of business processes, including management dashboards and operational reporting.

SQL Programmer

American Express, Decision Science (contract with Insight Global, then converted to FTE)

June 2013 - January 2016

Generate SQL code used for Anti Money Laundering surveillance of financial transaction and demographic data. Productionalize SQL queries for off-shore resources to implement using Sybase, Teradata and Perl.

Data Manager

Assist Technologies

Aug 2012 - April 2013

Data analyst position responsible for overall data quality for electronic clinical data management provider. Combined role of SQL Server DBA, developer, analyst and QA. Enhancement of existing procedures from row-based logic to set-based logic. Creation of reporting and auditing systems using SQL Server 2008 R2, Integration Services (SSIS) and Reporting Services (SSRS). Expansion of existing business intelligence & reporting systems to provide improvements.

Business Analyst & SQL Programmer

Cox Communications

Sept 2011 - Aug 2012

Programmer analyst position in sales support with largest local cable provider. Development of reporting and dashboards with SQL Server 2008 R2, Integration Services (SSIS) and Reporting Services (SSRS). Analysis of existing business intelligence and reporting systems to provide improvements.

Contract SQL Programmer

Technology Staffing Solutions, Scottsdale, Arizona

May 2010 - March 2011

Creation of executive level dashboard reporting for foreclose department in nation-wide bank. Integrating SQL Server Reporting Services 2000 and 2005, SSIS, Sharepoint and MS Excel. Extensive systems & business analysis across multiple departments and reports.

SQL Programmer

DPC&S, Phoenix, Arizona

November 2009 - May 2010

SQL programming with SQL Server 2005. Very heavy use of stored procedures, multi-dozen table query logic, SSIS, Reporting Services. Integration with MS Office.

Contract FoxPro & SQL Programmer

National Health Benefits Corporation, Scottsdale, Arizona

August 2008 - May 2009

Conversion of massive Visual FoxPro ETL (837 EDI) system into SQL Server 2005. Extensive and creative use of SQL Server SSIS and Reporting Services, as well as VB.Net and integration with MS-Office.

Director of Information Technology

Strategic Alliance Marketing, Scottsdale, Arizona

November 2006 - August 2008

Provided technology vision of enterprise-wide architectures and direction for entire company. This included re-engineering and enhancing SQL and FoxPro database platforms, supervision of IT staff, and creation of new strategic initiatives. Platforms included Visual FoxPro (v5-9), SQL Server 2000/2005 and MS-Office.

Applications Manager and Programmer Analyst

Northern Arizona Regional Behavioral Health Authority (NARBHA), Flagstaff, Arizona

December 2003 - August 2005

Systems analysis and design using Microsoft Visual FoxPro to support the departments of Finance, Quality Management, and Clinical Operations. Projects included design of new data analysis tools and reporting systems, re-design of existing code and support of legacy systems. I was promoted to a management position after one year, supervising a small team of programmers. In that position, I was highly effective in interfacing with upper management, as well as in leading my team in unprecedented production and achievement.

Systems Analyst and Network Administrator

Trendstat Capital Management, Inc., Scottsdale, Arizona

August 1995 - April 2003

My extensive systems analysis and FoxPro programming skills were used at Trendstat in many areas, including implementation of Electronic Data Interchange (EDI) formats for the investment industry, integration of proprietary programs with Internet data standards as well as various billing & client management systems, and conversion of all company systems from FoxPro for Windows into Visual FoxPro. Past projects have included creating the company Web site, integrating Web with FoxPro data and creation of Internet-based marketing materials. Conversion of the company's workstations to Windows 2000 and XP, and converted several FoxPro systems into Visual Basic.

Senior Programmer / Analyst, U-Haul Int’l, Inc., Phoenix, Arizona

April 1993 - August 1995

Lead programmer/analyst for management reporting group at U-Haul headquarters. Project Lead for re-engineering project that moved a mainframe/minicomputer based 1,500 site P&L reporting system onto a PC based platform. The programming languages used were FoxPro, Visual FoxPro and Excel VBA. Extensive interaction with highest levels of company management to show broad capabilities of PC-based data processing. Business re-engineering and system design for more efficient and productive reporting for company management. Technical products included Windows NT, Progress, FoxPro, SQL, Hyperion and all Microsoft Office automation tools.

PC Software Specialist, U-Haul Int’l, Inc., Phoenix, Arizona

November 1992 - April 1993

Lead software support person for U-Haul headquarters. Designed and implemented solutions for business requirements. Implemented new software packages, primarily in Windows 3.1 on Novell 3.11, with emphasis on office automation tools. Programmed macro-based systems in Microsoft Excel and Word, as well as data-analysis systems with FoxPro 2.5 for DOS and Windows programming. Network management, mini-to-mainframe interoperability and PC hardware skills also utilized.

Computer Systems Administrator, telACCESS, Inc., Scottsdale, Arizona

January 1991 - November 1992

Data systems administrator for telACCESS, a start-up service bureau focusing on data processing and communications for nationally based marketing organizations. Developed business plan financial projections, service models and complete data processing system for the two main areas of the business: voice mail and automated order-entry. Managed staff and contract programmers in development of financial, billing, data-entry, administration and in-house data systems. Extensive FoxPro for DOS programming, including hardware controls and integration with outside vendors.

Systems Administrator, The Environmental Recycling Group (ERG), Irvine, California

October 1989 - October 1990

Responsible for all phases of computer operations and utilization at ERG, a group of companies that creates ecologically pro-active marketing campaigns. This position began with the analysis of the work patterns of the various teams: sales & marketing, office organization, recycling machine systems, accounting and the extensive data processing needs of these teams. This analysis led to the development of several comprehensive systems: contact and activity tracking for sales and marketing; extensively automated procedures for word processing and office needs; data collection, analysis and reporting procedures for machine and accounting systems; and most importantly, a structure for the coordination and management of these varied parts.

Data Systems Coordinator, Lendrum Associates, Phoenix, Arizona

April 1989 - October 1989

Primary responsibility at Lendrum was developing systems that utilized existing computer resources to their fullest potential. This required proficiency with AutoCAD, WordPerfect, Lotus 1-2-3 and Lotus Freelance. It also required understanding the latest technological advances in microcomputer hardware and software and the combination of this with Lendrum's needs.



Contact this candidate