I have over thirty years of IT work experience in all levels from Computer Operator through Vice-President/Owner of my own consulting firm. I am equally qualified to perform programming or manage and lead major projects with budgets in excess of 5 million dollars and personnel from 1 through 50. Most recently I have been involved with Business Intelligence projects.

TECHNICAL SKILLS

• WEBFOCUS (10 years)
• FOCUS, PC FOCUS (25 years)
• JAVA, HTML, ASP (4 years)
• CRYSTAL BUSINESS OBJECTS (2 years)
• MS Reporting Services (6 months)
• Microstrategy (6 Months)
• COBOL, COBOL II (25 years)
• IBM JCL, Utilities (25 years)
• IBM MVS, TSO ISPF (15 years)
• IBM VM/CMS (10 years)
• DB2, IMS, IDMS (15 years)
• SAS Mainframe (15 years)
• Oracle 9i 10g (3 Years)
• MS OFFICE, Access, Excel, Word, PowerPoint (10 years)
• MS Project (7 years)

PROFESSIONAL EXPERIENCE

July 2009 December 2009

Confidential, Oklahoma City

WebFocus Technical Lead

Conducted several JAD sessions to define report Flows and look and feel with the end users. Worked closely with the Data Analyst to develop the DW and ETL data mapping. Developed and published a complete design document as well as detailed specifications for use by a team of report developers. As a member of the development team was responsible for the development of all HTML launch pages and 3 reporting templates each template containing about 30 individual reports. Involved heavy use of advanced Graphing capabilities within WebFocus. Was instrumental in the development and method of capture for some manual data coming from sources outside the department. All development was 508c Compliant

Environment: Oracle 10g, WebFocus 7.6.9, MRE, Developer Studio, Report Caster, Java Script, MS Office, ACCESS, VISIO, MS Project, zLinux, 508c Compliant

November 2008 December 2008

Confidential,Willmington, DE

Consultant

Part of a team to convert the last 27 Microstratagy Reports to WebFocus. These reports were Active reports with additional drilldowns. I was responsible for mentoring 3 individuals in the use and development of Webfocus Developing Reports and drilldowns, and HTML Launch pages.

Environment: Oracle, WebFocus, MRE, Developer Studio, Report Caster, Java Script, MS Office, ACCESS, VISIO, MS Project. Microstratagy .

October 2007 December 2008

Confidential,Philadelphia

Consultant

Business Intelligence interface from SQL Server based DB used to track Tasks and Air emissions for the refinery industry. Our developed reporting system met government reporting requirements. Additionally was considered the subject area expert for Webfocus. I was responsible for mentoring 3 individuals in the use and development of Webfocus Environment Developing Reports, Graphs, and HTML Launch pages. In Addition was responsible for a release migration from WebFocus 7.1 to 7.6 was responsible for reporting inventory containing 105 reports about 25 self services and 75 in an MRE environment. I also was responsible for about 50 different metadata synonyms. This migration also included a server upgrade.

Environment: SQL Server, WebFocus, MRE, Developer Studio, Report Caster, Java Script, MS Office, ACCESS, VISIO, MS Project, MS Reporting Services .

February 2007 June 2007

Confidential,

Consultant

Resposible for the assistance and setup of the reporting interface from SAP to WebFocus. Worked closely with the SAP DW analysts to establish views of the database to produce the required reports and graphs. Met with users and Business Analysts to identify and priorities the required reports.

Environment: SAP, WebFocus, MRE, Developer Studio, Report Caster, Java Script, MS Office, ACCESS, VISIO, MS Project, ABAP, Unix

June 2007 October 2007

Confidential,

Consultant

Worked closely with the SAP DW analysts to establish views of the database to produce the required reports and graphs. Met with users and Business Analysts to identify and prioritize the required reports. Developed phase 1 reports, BID and provided training to users for Phase 1 reporting.

Environment: SAP, WebFocus, MRE, Developer Studio, Report Caster, Dashboard, Java Script, MS Office, ACCESS, VISIO, MS Project, ABAP, Unix

October 2006 February 2007

Confidential,

Consultant

Report conversion from old Legacy reports to WebFocus reports. Reports where first grouped into about 150 templates by user group fields required act.. This grouping was done with the help of several existing BAs that were very familiar with the business requirements do to many years of company experience. The effort was performed in conjunction with a data normalization effort and conversion from DB2 to Oracle. Many of the Templates involved the creation of Launch Pages in HTML with attached Java script.

Environment: DB2, SQL, IBM Mainframe, WEBFOCUS, MRE, Studio Developer, Report Caster, Java Script, MS Office, ACCESS, VISIO, MS Project, UNIX,.

October 2005 July 2006

Confidential,

Consultant

Data mining effort from historical data covering 5 years including the conversion of many data items to research usable data values. Also, included preparing a file to be sent to Trans Union to be credit scored. Some of the conversion items need to be reworked so while they were being reworked. I was moved to the QA team were I assisted in the initial setup of QA procedures for the Management Information Team. My major project on the QA team was the migration or WebFOCUS release from 5.3 to 7.1 this was done over a 3 month period and included the modification and testing of almost 1000 reports and there associated dashboards and metadata synonyms. An automated testing and discrepancy tracking system was instituted using Test Director. All Procedures were established to meet Sarbanes-Oxley reporting and record keeping requirements.

Environment: FOCUS, DB2, SQL, IBM Mainframe, WEBFOCUS, MRE, Studio Developer, ASP, SQL Server, MS Office, ACCESS, VISIO, MS Project, UNIX, Crystal/Business Objects.

April 2005 to October 2005

Confidential,

Consultant

Technical consultant for various clients. Included the development of many prototype systems and first user reports for new sales of WEBFOCUS. Also, included the upgrade from release 5.3 to 7.1 of WEBFOCUS.

Environment: FOCUS, DB2, SQL, WEBFOCUS, MRE, Studio Developer, ASP, SQL Server, MS Office, ACCESS, VISIO, MS Project, UNIX, Crystal/Business Objects

July 2004 to March 2005

Confidential,

Consultant – Finance

Technical consultant for the development and maintenance of 500+ financial reports in an MRE reporting environment.

Responsibilities:

• Act as mentor trainer for the overseas outsourcing project. Was responsible for the training and mentoring of one individual from India.
• Part of the Magic team responsible for data modeling of new data warehouse.
• Develop ad-hoc reports using Crystal/Business Objects

Environment: FOCUS, DB2, SQL, WEBFOCUS, MRE, Studio Developer, ASP, SQL Server, MS Office, ACCESS, VISIO, MS Project, UNIX, Crystal/Business Objects, Teradata

November 2003 to June 2004
Confidential,
Consultant – Finance Real Estate

Responsibilities:

• Technical lead assigned to maintain and develop as required the Real Estate Management System (REMS).
• Take charge of existing system and provide production support and Break-fix maintenance as required. Update documentation with current monthly cycle flow.
• Provide development of new reports to better suit business needs. Solve problems with feeds to and from various in house and external systems.
• Environment: COBOL, FOCUS, DB2, SQL, MS Office, ACCESS, VISIO, IBM JCL, IBM utilities, TSO/ISPF, MVS, VM, Teradata

August 2002 to April 2003
Confidential,
Consultant – Banking HR Systems

Responsibilities:

• Technical lead assigned to assist Business Analyst in establishing a technical solution to solve various problems with the 2002 Incentive Compensation System.
• Performed ‘Deep dive’ into existing system to establish best technical solution possible given the time constraint.
• Lead white board sessions to establish and clarify business requirements and technical solution.
• Managed team of 7 developers in implementing the technical solution and processing of 10 months of data averaging approximately 3 million transactions per month under tight deadline of November 1.
• Established several documentation and Best Practice procedures implemented by Key including a Defect Tracking Database.
• Currently working on implementing changes for the 2003 Plan.
• Assigned as a technical advisor on the upgrade to FOCUS release 7.2.
• Included training and use of RUP. In Data modeling (rational Rose) and project planning,
• Environment: COBOL, FOCUS, DB2, SQL, WEBFOCUS, ASP, SQL Server, MS Office, ACCESS, VISIO, MS Project, IBM JCL, IBM utilities, TSO/ISPF, MVS, SAS, RUP

November 2001 to March 2002
Confidential,
Consultant – Insurance Company

Responsibilities:

• Establish RAS server for access from home or while on the road.
• Produce various reports for many clients on a legacy mainframe and establish a method of transmitting these reports to either a server for display, or e-mail directly from the mainframe to the user. Modified existing shareware REXX procedure to e-mail utilizing UHC systems.
• Utilization of WEBFOCUS in the MRE (managed reporting environment) to manage and develop reports as required.
• Used FTP to download data extracted from DB2 databases via SAS and FOCUS to then be loaded to newly developed Access databases residing on the Server.
• Established production schedules and run procedures for approximately 35 different reports and extracts.
• Environment: COBOL, FOCUS, DB2, WEBFOCUS, ASP, SQL Server, MS Office, ACCESS, VISIO, MS Project, IBM JCL, IBM utilities, REXX TSO/ISPF, MVS, SAS, Oracle, COGNOS

EDUCATION:

TRAINING & CERTIFICATION

1981 – 2008 Many management and technical training schools