Randy S. Benzel
303-919-5310
Summary: 22 years of Business Intelligence / Data Warehouse / Enterprise Reporting experience with specializations across the BI spectrum. Source-side competencies are data analysis (statistics, unique values, outliers), source-to-target mapping, requirements gathering and analysis, project scoping and resource planning. Integration layer skills include advanced Informatica development, bash / ksh / DML scripting, pre-calculated aggregates, unit / system / regression testing, and ETL performance tuning. Presentation level knowledge includes relational, dimensional, and Data Vault modeling (ERD, logical, physical), DDL scripting, expert Business Objects development and support, enterprise dashboards, and reporting system implementations.
Current Position: Business Intelligence Consultant – Encana Oil and Gas (USA), Inc.
Lead Data Modeler on the Data Vault-structured Production Operations Warehouse and all dimensional Star-Schema reporting marts.
Lead Business Objects XIR3 development and support for the entire USA Division, including Webi, Deski, and Universe development, enhancements, troubleshooting, user support, and education.
Lead Informatica Developer on Data Vault to Data Mart data movement. Supporting Informatica Developer on operational source to Data Vault ETL.
Introduced and implemented the Data Vault hybrid modeling approach for Encana USA's only enterprise data integration solution, the Production Operations Warehouse.
Authored content and teach full and half-day training classes in Introductory and Level 2 Business Objects Webi development.
Previous Position: Business Intelligence Consultant – Great West Healthcare
Informatica development in an Oracle 10g environment. Extract and transform policy and member medical benefits information from a Trizetto Facets database into an Operational Data Store. Built two administrative utilities (Execution Broker and Workflow Monitor) in Informatica. Presented both utilities at the Denver Informatica User Group Meeting in February 2007.
Phase 1 Informatica coding to extract, then aggregate out-of-pocket and overall lifetime benefit accumulations from two legacy mainframe claims administration systems (BEN and CompuTrak). Phase 2 applies Facets benefit configurations at a policy-division-class-product level. Phase 3 loads Facets-ready ABI keyword records. After import, the success and resubmit logs are evaluated through Informatica to reconcile the import results with the staged records.
Designed, built, and deployed an Accumulator Threshold Mart to track the results of conversion efforts, including post-conversion changes to benefit configurations and adding or removing members. When members meet or exceed benefit maximums in Facets, the Threshold Mart records this event for the business to evaluate. The accumulator contribution from Legacy is included in the Mart and used to determine whether manual adjustments are necessary to Legacy to remain synchronized with Facets. Complex business rules are implemented to handle one and two-way cross-apply, carry-over, plan year vs. calendar year, and coordination of benefits.
Previous Position: Data Warehouse Architect and Technical Lead – Catholic Heath Initiatives
Lead data modeler for the Patient Activity Data Warehouse. Designed and implemented 33 dimensions, 21 facts, and 28 audit / reject / load control / working tables.
Data integration including UB92 extracts from 60 health care facilities, patient satisfaction results, severity adjustments, core measures, and employee climate assessments.
Modeled the Network data mart, wrote ETL to populate, documented and delivered the solution to the dashboard team to serve as a data source for the networking component of the IT Dashboard.
Lead Informatica developer / administrator for the Enterprise Information Management team. Mentor staff developers on their ETL approach, code migration and deployment standards, quality assurance testing methods, weekly project tracking, and defining processes for the team.
Lead Business Objects XiR2 Developer and Administrator. Responsible for all Universe (semantic layer) development, all report development (full-client and Webi), user administration, trouble-shooting, and system upgrades. Designed and implemented 20 standard reports that are delivered weekly / quarterly through the Business Objects system.
Conduct weekly “On the Plate” and pre-development review meetings with technical team. Track development progress, estimate delivery dates, and lead “Code Review” meetings prior to production deployment. Offer guidance on performance management goal-setting and yearly employee reviews.
Industry Experience: Oil and Natural Gas Production and Transportation, Healthcare Insurance and Services, Online Travel, Investments and Retirement, Pharmaceutical Marketing, Medical Manufacturing, and Electric Utility.
Application Experience: Informatica, Business Objects, Power Designer, ERWin, WebTrends, SourceSafe, UNIX, Project, Visio, Power Point, Excel.
Database Experience: SQL Server, Sybase, Oracle, Essbase, DB2.
Employment History:
EnCana Oil and Gas (USA) – May 2008 to Present
Cigna – October 2006 to April 2008
Catholic Health Initiatives – November 2004 to September 2006
CheapTickets.com / Cendant – March 2003 to October 2004
Idea Integration – September 2002 to February 2003
Braun Consulting – March 2000 to August 2002
Xcel Energy – May 1999 to February 2000
Kinder Morgan – May 1996 to April 1999
Coastal Corporation – November 1992 to April 1996
Education:
Colorado College – BS Economics 1993, Accounting Emphasis (3.6 GPA)
Eaton High School – Salutatorian 1988 (3.98 GPA)
Training and Coursework:
Business Objects XI: Administering Servers
Business Objects XI: Administering Users and Content
Business Objects XI: Designing Dashboards
Business Objects XI: Crystal Reporting I / II / III
Business Objects XI: Implementing Business Views
The Data Warehouse Institute World Conference (November 2005).
Denver Informatica User Group
Business Objects User Group
Additional Technical Experience and Accomplishments:
Informatica:
Development and upgrade experience on versions through 9.x of Informatica Power Center.
Lead Informatica Developer on a data warehouse project at Pharmacia in New Jersey. Responsible for the ETL code to populate four reporting data marts and two relational data warehouses. Delivered client documentation on the data model designs, source to target mappings, business rules, Informatica production deployment procedures, and transformation details for each mapping.
Built AutoSys schedules to control Informatica sessions that transformed and loaded Janus investment fund buys and sells.
Senior ETL developer on the Trip Network BI team. Built maps to move flat and relational data from internal and external source systems, then integrate that data into the Corporate dimensional data warehouse that stores transactional sales detail, customer profile information, and online search results. Completed multi-step, complex ETL to gather travel insurance purchases from OLTP systems and then load to the data warehouse, including a flat-file feed for the insurance provider’s billing and policy issuance system. Extracted data from several SQL Server databases to join offline sales transactions and travel agent metrics with the existing online data warehouse fact and dimension tables. Support the Trip Network data warehouse 24/7 through automatic error alerts built into each production workflow. Pro-active monitoring was built to send alerts when near-real-time production jobs fell over 30 minutes behind. Conduct technical interviews of Informatica contractors that apply for temporary work.
UNIX:
Coded korn shell scripts to support day-to-day warehouse operations, automated file transfer of source files from remote FTP servers, pre-session working table loads via isql, and file manipulation and modification routines to add data to existing data.
Built cron-initiated shell scripts that compress and archive Apache log files to manage server disk space.
Authored file modification / de-duplicating scripts to perform last-minute changes to files before they are made available to external data consumers.
Proficient on the UNIX command line including skills to manage files across network servers.
openssl, GnuPG, FTP, SFTP, bash, ksh.
Business Objects:
Led company-wide upgrade of Business Objects 6.5 to XiR2 and R2 to XIR3. Built and implemented security model, an IT Executive dashboard, and migrated Publisher reports to the XI distribution framework.
Business Objects Administrator and Lead Developer role at four previous employers.
Universe design, user administration, report development, distribution, and end-user education.
Net IQ WebTrends:
Lead Administrator role for software installation and configuration on Solaris servers, first-line technical support contact, and 24/7 monitoring of two Apache web servers that collect information about every hit and page view to the CheapTickets.com website.
Lead Administrator and Chief Developer role for WebTrends Warehouse Builder. This product parses through linear Apache web logs and transforms the data into a relational format that is loaded to an Oracle 9i database.
Responsible for creation and configuration of import profiles and associated filters, visit transaction tables, and monitoring of daily imports from the Apache logs to the Oracle database.
Developed all ETL to extract visit, unique visitor, page-view, and path-analysis data from Oracle to the Sybase Corporate data warehouse.