SUMMARY

• Over 30 years experience in Business Intelligence using SQL - based OLAP and Data Warehouse reporting tools. Also experience in application development and support including COBOL, CL, JCL, DB2, IMS and CICS
• DB2 and SQL Server SQL Database Design, Development, ETL and maintenance throughout many project life cycles.
• Extensive Data Cleansing, Business Analysis, Tabular, Matrix and Pivot Table Report development.
• Advanced knowledge of OS400, zOS and Microsoft Windows; MS Office, VBA macros, shell script languages
• Outstanding written and vocal communication skills resulting in effective interaction at all organizational levels.

AREAS OF EXPERTISE:

• RPG2,3, ILE, Free and COBOL iSeries DB2 queries, tables etc
• Krengel XML Suite web service iSeries Screens and Subfiles
• SQL Server 2005,-08R2,-12
• ER/Star Schemas via ERWin
• Data Warehouse population
• ETL using DB2 SQL, T-SQL
• Mainframe COBOL,JCL,4GLs

PROFESSIONAL EXPERIENCE

Confidential iSeries COBOL Developer / SQL Developer

Responsibilities:

• Learning iSeries licensing and customer service applications for assuming retiree's role in a transition to web technology.
• Liquor/Cannabis retail and wholesale client license and permit database maintenance in iSeries COBOL and DB2/UDB.

Confidential

Mainframe UFT Tester

Responsibilities:

• Intensive testing of converted IMSDC aircraft engineering data entry/update transactions using HP Unified Functional Testing to test recorded IMSDC scripts in a Micro Focus Enterprise Visual Studio Server environment.
• Utilized zOS JCL, FileAid and TSO/ISPF in testing mainframe and converted Micro Focus COBOL applications.
• Results were unacceptable causing a decision to restaff with vendor consultants.

Confidential iSeries ILE RPG Developer

Responsibilities:

• Worked in Agile/Rally SDLC environment for development and support of iSeries and mainframe ILE debit and credit card production systems to provide analytical results from legacy systems.
• Made modifications to ILE RPG Free interactive task management subfile application for maintenance of programming task schedule and tracking reports.

Confidential iSeries COBOL Developer

Responsibilities:

• Worked in agile SDLC environment for development and production support of 22 states' Electronic Lien Titles. New state development, issue diagnosis/resolution and new lien conversions utilizing ILE COBOL with embedded SQL and CLLE.
• Developed a new test environment build tool to allow developers’ using a true test database and a full set of test objects for any of the 22 ELT states lacking a full strength test environment, which was over 15 of them. There was no change management software installed on the system, so test environments were urgently needed.
• DB2 UDB Data Analysis, SQL ETL and iSeries COBOL supporting 22 state motor vehicle Electronic Lien Titling applications.

Confidential iSeries RPG Developer

Responsibilities:

• Developed a new interactive vendor interface application for vehicle total loss evaluation utilizing DDS for DSPFs, PFs, LFs & PRTFs, ILE RPG with embedded SQL and CLLE in an Aldon LMI environment. Used Hawkeye for claims job statistics.
• Made enhancements to interactive RPG3 and RPG4 automobile claim dispatching and adjuster assignment applications.

Confidential iSeries RPG Developer

Responsibilities:

• Utilized Krengel XML Suite for RPG Free SOA WebSphere Java/JDBC application servlets to develop Intelligent Home Restore Account servlet in WebSphere environment.
• Developed a new interactive subfile application for fast track telephone number inventory maintenance in RPG Free with embedded SQL.
• Used MSFT Query intensively for creation of EXCEL test cases and BI results as required by IT and business principals.
• Developed a new ILE CL and RPG Free batch SQL ETL application utilizing complex SQL CTE queries to speed query execution. The ETL result was a pipe delimited customer address and house key information file encrypted with ZMOD10 PGP encryption software before FTP transmission to partner site Windows Directories containing 1000s of XLSX files, causing related files to group together.

Confidential, San Francisco, CA

SQL Server Developer

Responsibilities:

• Developed Generics Department Supplier and Product scorecards for large chain customer demand and supplier pricing.
• ETL, SSRS and EXCEL development in support of Business Intelligence analytics using a 10+TB Data Warehouse.
• Improved automation in 20 Hospital customer monthly EXCEL Pivot Table reports, converting to SQL Server from Oracle.
• Developed SQL Server 2008R2 T-SQL S-Procs and UDFs for use in SSRS reports in a multi-database environment.
• Developed and maintained 12 SSRS 2008R2 tabular, matrix and dashboard reports including drill down.
• Developed and tuned complex joined queries accessing Oracle/SQL Server wholesale sales data warehouses.
• Imported 7 Supplier Contact lists maintained in EXCEL and WORD into an Access 2007 departmental DB that I designed.
• Import/Export/CSV Data manipulation utilizing Microsoft Office 2007 VBA Macros to populate EXCEL pivot table scorecards.

Confidential

AS/400 COBOL Developer

Responsibilities:

• Made changes in WINS insurance enterprise application COBOL code in claims, commissions and premium subject areas.
• Developed and expanded DB2 based replacement for APL Loss Reserving System utilizing COBOL and batch SQL queries.
• SQL Server 2000 Insert Select query development and execution transforming DB table data into conversion XML.
• SQL Server 2005 Reporting Services (SSRS) report development and maintenance (over 30 accounting and management reports) in an OOA team development environment.
• Developed California, Nevada and Arizona DMV weekly proof of insurance transmissions in COBOL, SQL, CL and SFTP.
• Converted 100+ NGS Query accounting and operational reports to SEQUEL, a DB2/UDB BI and dashboard tool.
• Created SQL Server DB, table, index, view, USP, linked server & alias.

Confidential

Release Quality Assurance Analyst

Responsibilities:

• Re-sized DB2 databases and tablespaces as changes occurred between software builds.
• Installed and operated third party integrated WEB software: Apache Web Server, BEA Tuxedo/Jolt and Brio SQR Server.
• Modified configuration scripts to achieve correct functioning of Servers.

Confidential

AS400 RPG Developer

Responsibilities:

• Recorded team-developed physical DB2 OLAP and Star Schema data models using Erwin 3.51.
• Created and maintained AS/400 DB2 SQL for all tables, indexes and views. Trained employees in DB2.
• Administered Business Objects Universes, trained users in accessing the data warehouse.

Confidential

Oracle Database Developer

Responsibilities:

• Extracted denormalized legacy database design from a production Oracle 5.1 physical schema into ERWin.
• Recorded new OLAP data model team-developed in Rational Rose as ERWin 3.51 physical data model database.
• Coded Oracle PL/SQL scripts and Pro-C programs to map the legacy system tables to the new schema, cleanse data and load new master tables.

Confidential, San Francisco, CA

AS/400 Programmer Analyst

Responsibilities:

• Performed troubleshooting, modified RPG 3 programs and System 36 OCL.
• Performed regression testing per formal change requests in a production support environment in Distribution Systems.

Confidential

Senior Programmer Analyst

Responsibilities:

• Delivered an FTP based data interface between two S390 legacy applications -- including specific portions of the KPFS membership database -- and a new UNIX system. Utilized SAS/IMS for analysis of membership statistics.
• Wrote ETL data mapping specifications based on data models built with ERWin 3.51.
• Maintained integrity and content of 4 pricing test databases implemented on DB2/MVS and DB2/UDB for Windows NT 4.1 after SYBASE platform was dropped.

Confidential

Mainframe Programmer Analyst

Responsibilities:

• Expanded D&B/S Fixed Assets software package and in-house systems to accommodate the merger with First Interstate Bank.
• Used VS COBOL II, DB2, JCL, VSAM, CICS, REXX.

Confidential, San Francisco, CA

Mainframe and AS/400 RPG Programmer Analyst

Responsibilities:

• Converted MSA personnel/payroll history to Software 2000 compatible AS/400 tables using Pan-Valet, IDCAMS, JCL and VS COBOL II to extract the MSA VSAM files and AS/400 COBOL to populate the tables.
• Developed 5 BPICS reports for the warehouse manager in San Leandro using CL, RPG3 and Query.