Business Intelligence Developer
Resume:
Ken Gray
Lester Prairie, MN ****4
********@*****.***
curriculum vitae
Background Summary
Business Intelligence Developer with over 15 years experience (industries include healthcare, finance, and retail).
●Over 14 years reporting experience (Spotfire, Crystal Reports, Cognos, MicroStrategy, Business Objects, WebFOCUS, and Tableau).
●4 years Spotfire analytic development.
●3 years Agile development experience.
●10 years administration enterprise report distribution system.
●10 years Crystal Reports development and MS-Access database creation and maintenance.
●10 years MS-Access database development.
●5 years Unify query development (5r, similar to SQL) and process automation (using Korn shell scripting).
●2 years experience Opalis job stream development.
●2 years server administration (Windows Server 2003).
●2 years VMS automation process maintenance.
●1 year SQL Server 2000/2005 DTS administration/development.
Experience
Business Intelligence Developer (2/2015 - Current)
Verisk Retail
●Develop new Spotfire analytics within a multi-tenancy application environment.
●Code raw T-SQL queries for use within the Spotfire environment.
●Develop methods and scripts for using IronPython within Spotfire analytics to expand functionality.
●Architect method for multi-tenancy Spotfire implementation.
●Enhance Spotfire analytics via IronPython coding.
Business Intelligence Developer (10/2011 - 1/2015)
Digi-Key(contract worker via Concord USA and later as FTE)
●Maintain and develop current inventory of Spotfire analytics and advise on future enhancements.
●Develop new reports in MicroStrategy.
●Develop proof of concept analytics in Tableau.
●Meet with database team to determine necessary data structures and assist in planning etl scripts.
●Manage analytic migrations between environments.
●Validate analytic results using sql queries against Oracle data sources.
●Assist system administrator in resolving environment performance issues.
Business Intelligence Developer (9/2010 – 10/2011)
Wells Fargo/Tek Systems
●Document data warehouse etl process for project review team.
●Build SharePoint documentation and work-flow sites for 10-12 member team.
●Lead the daily team review meeting for ETL process.
●Responsible for end user communication (900+ user group).
●Business Objects report development.
Business Intelligence Developer (4/2010 – 9/2010)
US Bank/Tek Systems
●Assisted in designing over two-hundred WebFOCUS reports from specification documentation.
●Advised in environment planning decisions for the WebFOCUS project implementation.
●Worked with WebFOCUS administration and database administration personnel to modify current environment to link together the DB2 reporting connection with SQL-Server reporting connections.
●Acted as subject matter expert on the current production Crystal Reports environment work-flow so that 'As-Is' documentation could be produced.
●Created lookup tables in SQL-Server to assist in WebFOCUS report design.
●Provided concise documentation for outside departments to understand: environment, work-flow, and scheduling methodologies.
Programmer Analyst (3/2010 – 4/2010)
US Bank/Tek Systems
●Created two-hundred and fifteen report specification documents for reporting environment conversion.
●Maintained primary documentation source files for report design.
●Researched and communicated the complexities of the current reporting environment to US Bank WebFOCUS team members.
●Completed twelve week term of consultancy in six weeks due to scripting and work-flow efficiency.
Database Programmer/Analyst (8/2007 – 11/2009)
University of Missouri Health System
●Supervise automation processes comprising the following systems/sources: VMS/MUMPS/CACHE; SQL Server 2000/2005; Cognos cube sources; raw text files.
●Manage and develop queries within GE Centricity Business application (VMS).
●Maintain availability of seven Microsoft 2003 Enterprise servers (both virtual and physical).
●Administrate SQL Server 2000/2005.
●Develop and maintain automation processes within: VMS (cron); Opalis software environment; Windows Scheduled Tasks.
●Maintain enterprise report distribution system.
●Develop and administrate Cognos 7.4 environment (including Cognos macro automation environment).
●Primary trainer for Cognos PowerPlay within the Health System.
●Administrate documentation wiki for current work group.
●Assisted IT staff with Crystal Reports design and scheduling.
Private IT Consulting (2007 – 11/2009)
various clients
●Assist in server room configuration and setups.
●Provide desktop support.
●Assist in full network rebuilds and installations.
●Automation programming using 3G/4G scripting environment QuickMacros (http://www.quickmacros.com).
●Building network cabling and physical switch setup.
Programmer Specialist (4/2000 - 8/2007)
University of Missouri Health System
●Responsible for gathering information from different sources and architectures (e.g. Oracle, SQL, Unify, MS-Access) and produce reports for the enterprise via Crystal Reports.
●Coded custom queries via SQL like language for database loads.
●Created original production databases or tables as well as appropriate cross-referencing tables.
●Responsible for administration duties for the online report distribution intranet site.
●Acted as a liaison between vendors and hospital staff when expanded utilization is required of current systems.
●Established automated procedures for current report deliveries.
●Coordinated data retrieval from numerous departments for placement into the online report distribution system.
●Reviewed and evaluated changes to the online report distribution system.
Computer Operator II (6/1998 – 4/2000)
BJC Health Systems
●Monitored over 21 different systems including: an IDX server, numerous AIX servers, 4 Novell servers, a Cerner Classic Lab System, as well as numerous dial-up connections using various methods of connection.
●Performed system and performance maintenance on 3 different AS/400 systems (supported five different facilities as level II support for their AS/400 requirements).
●Assisted the programmers/analysts on special projects for the various systems above.
●Worked closely with the programming staff in analyzing and correcting nightly processing and performance problems within all 3 AS/400 systems.
●Received promotion to Operator II after serving only 10 months as Operator I.
EDUCATION
Bachelor's Degrees
University of Missouri-Columbia
BA Psychology
BA Philosophy
BA Classical Studies
Associate Degree
Mineral Area College
AA Psychology
Professional Activities
StackOverflow Member
User Id: Keng http://stackoverflow.com/users/730/keng
Contact this candidate