Senior Business Intelligence Developer

OBJECTIVE

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.

SKILLS PROFILE

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

EMPLOYMENT HISTORY

Senior BI Developer

May 2005 – May 2024

GC Service LP., HOUSTON, TX

Responsibilities include: 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.

Software and tools: SSRS, SSIS, SSAS, SQL, Incorta, Report Builder, Visual Studio, TFS, SQL Server Management Studio (SSMS), UC4, TEAMS, WebFocus, Developer Studio, Report Caster, Report Library, HTML Composer, SharePoint, HTML, JavaScript, Dialog Manager

Senior BI Consultant

Jan 1999 – Apr 2005

Information Builders Inc., Houston, TX

Responsibilities included: 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.

Software and tools: SQL, WebFocus, Developer Studio, Report Caster, Report Library, Managed Reporting Administration, Data Migrator (ETL), HTML, JavaScript, Dialog Manager

Senior Consultant

Mar 1997 – Dec 1998

WorldSpan, Atlanta, GA

Responsibilities included: 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.

Languages used: FOCUS, COBOL, SQL, and CLIST.

Senior Consultant

Oct 1996 – Mar 1997

Enron Corp., Houston, TX

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

Sep 1995 = Jan 1997

Amoco Corp., Houston, TX

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. Languages used were PL/1, SQL, REXX, CLIST, and FOCUS. The environment CMS/VM and MVS/TSO.

Senior Consultant

Jun 1994 – Sep 1995

WorldSpan, Atlanta, GA

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. Other languages used included COBOL, SQL, PDL, SDT, and CLIST. Duties required heavy user interface.

Consultant / Systems Analyst

Mar 1994 – May 1994

Amresco Services, Dallas, TX

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

Oct 1993 – Mar 1994

Enron Corp., Houston, TX

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

Apr 1993 – Oct 1993

Shell Oil Company, Houston, TX

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. Languages used included COBOL, COBOL II, SQL, MARK IV, and JCL.

Consultant / Systems Analyst

Jul 1990 – Jan 1993

Exxon Company USA, Houston, TX

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. I also aided in the analysis, design, and implementation of major projects. The position required heavy user interface.

Programmer Analyst / Quality Assurance Specialist

Mar 1988 – Jul 1990

System One Corp,, Houston, TX

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. I also supported NETMAN developing new screens and customized reports through the OLCF facility, and trouble shooting. Other languages used were COBOL, SAS, and FOCUS.

Programmer Analyst

May 1984 – Feb 1988

Associates Corporation of North America,, South Bend, IN

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. I also supported NETMAN developing new screens and customized reports through the OLCF facility, and trouble shooting. Other languages used were COBOL, SAS, and FOCUS.

EDUCATION

Bachelor of Science in Computer Science

Trine University, Angola, IN

Minor: Accounting

REFERENCES

Available upon request

Contact this candidate