SUMMARY:

Creative and innovative Business Intelligence Analyst with extensive experience in the development, upgrade, and support of report applications and data warehouse ETL. Proven success enhancing existing systems with new features and performance improvements. Background in accounting and financial reporting.

CORE STRENGTHS IN:

• Business Intelligence Troubleshooting and Problem Solving
• Product Concept, Design, and Specification Cross - function communication
• Data Warehouse Agile development

TECHNICAL SKILLS:

Platforms: MVS/TSO, VM/CMS, Unix, Windows 3.1 through 10, MS/DOS, RHEL, WebSphere

Languages: FOCUS, SQL, SQL Plus, PL/SQL, VBA, JCL, REXX, COBOL, HTML, JavaScript

Databases: IBM DB2, FOCUS, Oracle, SQL Server, Greenplum

Tools: FOCUS 6.5 through 7.7.03, WebFOCUS 4.2 through 8.2.27, QMF, QMF for Windows, TableauMicroSoft Office 365, Hyperion, Brio Query, QlikView, Lync, SharePoint, SCTM Silk, Borland Caliber, Lotus 123, Quattro Pro, WordPerfect

Additional: Dashboards, Scorecards, WebFOCUS InfoAssist+, Developer Studio, Administrator console, ReportCaster console, Resource Analyzer, AGILE

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Sr. WebFOCUS Developer

Responsibilities:

• As part of an AGILE team, developed new reports and visualizations for the DDBIB department of SSA.
• Working with a team, tested upgrade of WebFOCUS 8.2.01m to 8.2.27 for application compatibility and installation soundness.
• Utilized WebFOCUS 7.7.03, 8.2.01m and 8.2.27, App Studio, InfoAssist+, ReportCaster, Toad, Greenplum, Microsoft Teams, Skype, SharePoint.

Confidential, Parkersburg, WV

Middleware Administrator

Responsibilities:

• Provided support for over 35,000 users on WebFOCUS network servers.
• Working with a team, installed WebFOCUS 8.2.07 onto two RHEL servers and transferred an existing WebFOCUS/Java application from the previous servers into the new environments.
• Utilized WebFOCUS 8.2.27, RHEL, WebSphere, SharePoint, Microsoft Teams, Skype Tectia, Jira.

Confidential, Baltimore, MD

Sr. WebFOCUS Developer/Administrator

Responsibilities:

• Member of a team to convert several and various mainframe FOCUS 7.6.11 programs and applications to WebFOCUS 7.7.03, and 8.2.02.
• Provided Systems Administrator support to FOCUS/WebFOCUS technical team in maintaining and troubleshooting WebFOCUS 7.7.03, 8.1.05, and 8.2.02.
• Provided Systems Administrator support to FOCUS/WebFOCUS technical team in installation and configuration of WebFOCUS 8.1.05 and 8.2.01m.
• Appointed AGILE SME for decommissioning team. Member of AGILE user group.
• Utilized JCL, MVS, TSO/ISPF, FOCUS 7.6.11, WebFOCUS 7.7.03, 8.1.05, and 8.2.01m, App Studio, InfoAssist+, Dev Studio, FOCUS sink machine/FDS, ReportCaster, Resource Analyzer, AGILE Version One, HTML, JavaScript, SQL, DB2, Oracle, TSO/ISPF

Confidential, Nashville, TN

Sr. WebFOCUS Developer/Administrator

Responsibilities:

• Developed and supported interactive KPI reports as part of an AGILE team effort in creating a logistics industry customer portal innovation called Ovation.
• This portal is an external, customer-oriented business intelligence tool for clients of OHL to actively manage metrics pertinent to their logistics interests.
• Performed on-going Systems Administrator duties as needed, including diagnostics, configuration, and maintenance of servers and environments using WF Administrator Console, ReportCaster console, and Resource Analyzer utilities
• Utilized WebFOCUS 8.1.05, Dev Studio, ReportCaster, App Studio, Resource Analyzer, MicroSoft Office 365, MicroSoft Lync, Sharepoint

Confidential, Herndon, VA

Sr. WebFOCUS Developer

Responsibilities:

• Developed and supported WebFOCUS dashboard reports as part of an AGILE team effort in converting existing mainframe reports from Software AG Natural-Adabas.
• Utilized WebFOCUS 7.7.04, Dev Studio, ReportCaster, MicroSoft Office, MicroSoft Lync, SCTM Silk, Borland Caliber, Serena Change Management

Confidential, Cary, NC

WebFOCUS Developer

Responsibilities:

• Developed and supported WebFOCUS dashboard reports as part of a team effort in converting existing reports from existing MicroSoft Excel and Access reports.
• Performed POC evaluation on QlikView as an alternative or partner to WebFOCUS as the Business Intelligence reporting tool
• Utilized WebFOCUS 7.7.03, MicroSoft Office, SQL Server 2008, Sharepoint, and Spaces

Confidential, Miami, FL

Sr. IT Consultant

Responsibilities:

• Maintained, updated, improved, and enhanced over 32 mainframe applications encompassing vendor invoicing, rebates, depreciation and accruals, and sales force commissions.
• Managed and serviced most complex user-interfacing accounting and invoice applications, including both EDI and manual invoice receiving systems.
• Transformed business client requests into customer-satisfied changes and upgrades.
• Resolved production batch job problems as they occurred to ensure one-time only occurrence.
• Utilized JCL, MVS, TSO/ISPF, FOCUS 7.0.9, DB2, and Visio.

Confidential, Lowell, AR

BI Analyst

Responsibilities:

• WebFOCUS Developer/Administrator
• Built and supported multiple enterprise Business Intelligence (BI) data warehouse extract, transformation, and load (ETL) applications.
• Created numerous decision support systems (DSS) and reporting applications for the Truck business unit.
• Created and supported numerous data extract and load procedures for the data warehouse.
• Created and supported numerous WebFOCUS applications, including the AR Scorecard, ASM
• Scorecard, Daily Trailers, and EDI reports.
• Resolved production batch job problems as they occurred to ensure one-time only occurrence.
• Performed Systems Administrator duties for the WebFOCUS server, including maintaining ReportCaster scheduling, systems maintenance and upgrade.
• Lead project to upgrade WebFOCUS version from 5.2 to 7.1 to 7.6
• Utilized JCL, MVS, TSO/ISPF, WebFOCUS 7.6, ReportCaster, Developer Studio, MS Access QMF/DB2, COBOL, and QMF for Windows.

Confidential, Addison, TX

Programmer Analyst

Responsibilities:

• Maintained, updated, improved, and enhanced Business Intelligence enterprise BI data warehouse ETL and entity relationship diagram (ERD).
• Supported power-users and end-users in developing and troubleshooting in-house developed applications.
• Utilized JCL, MVS, FOCUS, QMF/DB2, TSO/ISPF, and REXX.

Confidential, St. Louis, MO

Programmer Analyst

Responsibilities:

• Maintained, updated, improved, and enhanced Business Intelligence enterprise BI data warehouse ETL and (ERD).
• Supported power and end-users in developing and troubleshooting in-house developed applications.
• Assisted with FOCUS upgrade to version 7.2.
• QA database and program testing prior to production installation.
• Utilized JCL, MVS, FOCUS, WebFOCUS 4.2, FOCUS for Unix, Unix, SQL, SQL*Plus, PL/SQL, Brio Query, QMF/DB2, TSO/ISPF, Oracle, and MS Access.

Confidential, Louisville, KY

Programmer Analyst

Responsibilities:

• Supported and maintained claims data extraction system.
• Created documentation and end - user manuals.
• Created extracts of data to support Actuate web application.
• Utilized JCL, MVS, FOCUS, TSO/ISPF, QMF/DB2, and MS Access.

Confidential, Philadelphia, PA

Programmer Analyst

Responsibilities:

• Supported and maintained claims data extraction system.
• Created documentation and end-user manuals.
• Utilized JCL, MVS, FOCUS, TSO/ISPF