Summary
Overview
Work History
Education
Skills
References
Softwaretoolsskills
Timeline
Generic

Bernard Doaks

fresno,tx

Summary

A self-motivated individual seeking a dynamic and challenging position with an organization that will utilize my years of experience and professional expertise in the information technology arena.

Manage high visibility projects Design, develop, and implement enterprise-wide reporting solutions Design and develop executive dashboards Creating and maintaining stored procedures, views, user functions, and database triggers Develop complex reports which includes financial, operations, Dashboards, KPI, scorecard, and OLAP style reports Develop complex SQL queries, views, and stored procedures Instrumental in the designing of data warehouse processes Data modeling Defining standards and best practices as well as creating appropriate documentation software tools / skills Business intelligence tools: SSRS, Report Builder, SSAS, MDX, SSMS, Power BI, Incorta, WebFocus, Crystal Reports, familiarity with Tableau Data Visualization tools: SSRS, Incorta, Power BI ETL: SSIS, Data Migrator Languages: SQL, WebFocus, HTML, CSS, JavaScript, XML, Dialog Manager, JAVA COBOL, COBOL II, SAS, CLIST, PL/1, REXX, PDL, SDT, JCL Other tools: SQL Server Management Studio (SSMS), Visual Studio, TFS, UC4, SharePoint, TEAMS, Project Insight, Remedy, Developer Studio, Report CasterMicrosoft Project, EXCEL, Microsoft Word, MS Access, RUMBA, EXTRA, CC MAIL Database administration tools: SQL Server Management Studio (SSMS) Data modeling tools: CA Erwin Environments: SQL Server 2019, UNIX, ORACLE, INFORMIX, EDA, OS/MVS-XA, TSO/ISPF, VM/CMS, ROSCOE, VSAM, JES2, JES3, ACF2, RACF, TPX, NETMAN, NETVIEW, LIBRARIAN, PANVALET, PROFS Highly-motivated employee with desire to take on new challenges. Strong work ethic, adaptability, and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.

Overview

40
40
years of professional experience

Work History

Senior BI Developer

GC Service LP.
HOUSTON, TX
05.2005 - 05.2024
  • Managing, mentoring, and leading a team of developers in designing, development, and implementation of reporting solutions
  • Assisting in the development and design of enterprise data warehouse
  • Managing high visibility projects, gathering requirements and working closely with business users
  • Development of self-service applications, complex reports which include operational, financial, KPI, and OLAP style reports
  • In addition, utilizing SQL to create and maintain stored procedures, views, user function, and database triggers
  • Duties also include the creation of executive dashboards and user interfaces
  • Manage user’s expectations and reporting to upper management.

Senior BI Consultant

Information Builders Inc.
Houston, TX
01.1999 - 04.2005
  • Working with various clients in various industries mentoring on IBI suite of products, advising clients on best practices, managing projects, developing self-service reporting applications, and complex report writing
  • Duties included working with IBI products such as Developer Studio, Dashboard, Data Migrator (ETL), Report Caster and MRE on multiple platforms
  • Environments includes UNIX/Oracle, UNIX/Informix, windows NT, Windows 2000, TSO/MVS.

Senior Consultant

WorldSpan
Atlanta, GA
03.1997 - 12.1998
  • Development, enhancement, and maintenance of all FOCUS applications
  • Duties also included the conversion for FOCUS applications to a client server environment
  • Required gathering of requirements and heavy user interactions.

Senior Consultant

Enron Corp.
Houston, TX
10.1996 - 03.1997
  • Worked as part of the tactical development team responsible for the maintenance, enhancement, and development of a FOCUS based oil and gas system
  • Responsibilities required in-depth knowledge of HLI and multi-record processing in a CMS/VM environment.

Senior Consultant

Amoco Corp.
Houston, TX
09.1995 - 01.1997
  • Responsible for the maintenance, enhancements and the day to day support of several financial applications
  • Systems supported included Facility and Service Charge-outs, Commercial Check Reporting, and Appropriations and Liabilities systems.

Senior Consultant

WorldSpan
Atlanta, GA
06.1994 - 09.1995
  • Responsible for maintaining all FOCUS applications which included an Equipment Tracking and Inventory System and a Machine Discrepancy Reporting System
  • Also responsible for the analysis and designing of all interfaces to and from other existing applications.

Consultant / Systems Analyst

Amresco Services
Dallas, TX
03.1994 - 05.1994
  • Position included working in a MVS/TSO and client server environment converting a mortgage and loan system from mainframe FOCUS to PC FOCUS
  • Duties also included analyzing data, designing FOCUS databases, and modifying the master file descriptions and FOCUS programs to run under PC FOCUS.

Consultant / Systems Analyst

Enron Corp.
Houston, TX
10.1993 - 03.1994
  • Worked as one of an eight member development team in a VM/CMS environment utilizing FOCUS to develop an Oil and Gas Imbalance system
  • Duties included designing and creating full screen forms for data entry, utilizing the SPA for multi-record processing, HLI processing, and heavy user interface.

Consultant / Systems Analyst

Shell Oil Company
Houston, TX
04.1993 - 10.1993
  • Worked as a key member of the Base Support Reduction Team to analyze and eliminate reoccurring production problems, and to provide maintenance and enhancements to existing systems in the financial area.

Consultant / Systems Analyst

Exxon Company USA
Houston, TX
07.1990 - 01.1993
  • Worked as a productive member of the upstream financial team utilizing my FOCUS, SAS, COBOL, CLIST, and PL/1 skills
  • Responsible for the day to day support of their Employee Expense and Travel, On-line Check Register, Material Ticket, NETMAN, and KODAK systems.

Programmer Analyst / Quality Assurance Specialist

System One Corp
Houston, TX
03.1988 - 07.1990
  • Duties included maintenance, enhancements, and development programming to their MSA Payroll/Personnel system, handling change control process for IMS/ADF application, ACF2 rule writing for dataset security, and developing new in-house written systems using CLIST and Dialog Manager.

Programmer Analyst

Associates Corporation of North America
South Bend, IN
05.1984 - 02.1988
  • Duties included maintenance, enhancements, and development programming to their MSA Payroll/Personnel system, handling change control process for IMS/ADF application, ACF2 rule writing for dataset security, and developing new in-house written systems using CLIST and Dialog Manager.

Education

Bachelor of Science in Computer Science -

Trine University
Angola, IN

Skills

  • Manage high visibility projects
  • Design, develop, and implement enterprise-wide reporting solutions
  • Design and develop executive dashboards
  • Creating and maintaining stored procedures, views, user functions, and database triggers
  • Develop complex reports which includes financial, operations, Dashboards, KPI, scorecard, and OLAP style reports
  • Develop complex SQL queries, views, and stored procedures
  • Instrumental in the designing of data warehouse processes
  • Data modeling
  • Defining standards and best practices as well as creating appropriate documentation
  • Business intelligence tools: SSRS, Report Builder, SSAS, MDX, SSMS, Power BI, Incorta, WebFocus, Crystal Reports, familiarity with Tableau
  • Data Visualization tools: SSRS, Incorta, Power BI
  • ETL: SSIS, Data Migrator
  • Languages: SQL, WebFocus, HTML, CSS, JavaScript, XML, Dialog Manager, JAVA COBOL, COBOL II, SAS, CLIST, PL/1, REXX, PDL, SDT, JCL
  • Other tools: SQL Server Management Studio (SSMS), Visual Studio, TFS, UC4, SharePoint, TEAMS, Project Insight, Remedy, Developer Studio, Report CasterMicrosoft Project, EXCEL, Microsoft Word, MS Access, RUMBA, EXTRA, CC MAIL
  • Database administration tools: SQL Server Management Studio (SSMS)
  • Data modeling tools: CA Erwin
  • Environments: SQL Server 2019, UNIX, ORACLE, INFORMIX, EDA, OS/MVS-XA, TSO/ISPF, VM/CMS, ROSCOE, VSAM, JES2, JES3, ACF2, RACF, TPX, NETMAN, NETVIEW, LIBRARIAN, PANVALET, PROFS

References

Available upon request

Softwaretoolsskills

  • Business intelligence tools: SSRS, Report Builder, SSAS, MDX, SSMS, Power BI, Incorta, WebFocus, Crystal Reports, familiarity with Tableau
  • Data Visualization tools: SSRS, Incorta, Power BI
  • ETL: SSIS, Data Migrator
  • Languages: SQL, WebFocus, HTML, CSS, JavaScript, XML, Dialog Manager, JAVA COBOL, COBOL II, SAS, CLIST, PL/1, REXX, PDL, SDT, JCL
  • Other tools: SQL Server Management Studio (SSMS), Visual Studio, TFS, UC4, SharePoint, TEAMS, Project Insight, Remedy, Developer Studio, Report CasterMicrosoft Project, EXCEL, Microsoft Word, MS Access, RUMBA, EXTRA, CC MAIL
  • Database administration tools: SQL Server Management Studio (SSMS)
  • Data modeling tools: CA Erwin
  • Environments: SQL Server 2019, UNIX, ORACLE, INFORMIX, EDA, OS/MVS-XA, TSO/ISPF, VM/CMS, ROSCOE, VSAM, JES2, JES3, ACF2, RACF, TPX, NETMAN, NETVIEW, LIBRARIAN, PANVALET, PROFS

Timeline

Senior BI Developer

GC Service LP.
05.2005 - 05.2024

Senior BI Consultant

Information Builders Inc.
01.1999 - 04.2005

Senior Consultant

WorldSpan
03.1997 - 12.1998

Senior Consultant

Enron Corp.
10.1996 - 03.1997

Senior Consultant

Amoco Corp.
09.1995 - 01.1997

Senior Consultant

WorldSpan
06.1994 - 09.1995

Consultant / Systems Analyst

Amresco Services
03.1994 - 05.1994

Consultant / Systems Analyst

Enron Corp.
10.1993 - 03.1994

Consultant / Systems Analyst

Shell Oil Company
04.1993 - 10.1993

Consultant / Systems Analyst

Exxon Company USA
07.1990 - 01.1993

Programmer Analyst / Quality Assurance Specialist

System One Corp
03.1988 - 07.1990

Programmer Analyst

Associates Corporation of North America
05.1984 - 02.1988

Bachelor of Science in Computer Science -

Trine University

Similar Profiles

CREATE PROFILE
Bernard Doaks