
Jim Rothwell
- Systems Analyst
- Valencia, CA
- Member Since Mar 15, 2023
|
Summary:
Application Portfolio
iSeries-centric Accomplishments
Other Platforms/Misc.
JIM ROTHWELLPage Two (Continued)
Training and Conferences |
· 20+ years varied IT experience, including 20+ years of experience with AS/400 (iSeries, IBM i) platform, developing in both RPG (ILE) and COBOL. · 10+ years’ extensive experience in software vendor liason for F.Logic’s F&L Licensing and F&L for Focus Features applications, Counterpoint’s iMaestro and Rights Clearance apps, and DSI’s Digital Rights Management (DRM) application, managing problem resolution and program installation and upgrades. · Have been a member of the Film Technical Solutions Group, as Technical Lead for iSeries and Microsoft platforms/tech stacks, for 4 years, directing activities of onsite Dev Lead and offshore development and maintenance team. · Started with Universal/NBCUniversal in 1998 as a Y2K remediation contractor, converting to employee status in 2000, starting with Studio Operations, supporting ORBIT and Infinium A/R, moving to Film group in 2007, to support Film and Music legal and licensing systems.
· Mixture of MS SQL/.Net/ASP, supported in-house, for which I provide technical support and contract resources management; and iSeries-hosted native, desktop, and web-based applications (both IIS/ASP and Java/WebSphere) that are vendor-supported and for which I perform all upgrades, level one support, and health monitoring.
· Designed, developed, and supported a comprehensive report distribution system (RePortal) providing totally automated spooled file conversion to PDF and email distribution to users, with optional customized report collating, utilizing state-of-art ILE modular design with job-to-job communications via data queues to provide fault-tolerant, plug-in modules for simple new report and user additions. · Designed and developed numerous tools used across application teams, in support of Sarbannes-Oxley (SOX) system security requirements, including automated system and application account provisioning and deprovisioning. · Developed several iSeries/Apache/RPG/JavaScript-based web applications using CNC Corp. Valence (ExtJS-based), CGIDEV2, and Support Central (GE) frameworks, for both IT and business client use. · Prepared NBCU Controllership/SOX reviews for iSeries and other applications. · Collaborated with GE and NBCU Security and Audit teams to conduct periodic reviews and security remediation efforts. · Developed self-service iSeries account/password management via Support Central frontend and RPG web service/stored procedure backend. · Performed system analytics, conducting regular reviews of DASD and CPU usage among various application systems and groups, for system performance evaluation and capacity forecasting. · Developed a video selection gallery and playback functionality, in support of the Film Group, using iSeries Apache-hosted HTML5 and Javascript.
· Created and supported several GE Support Central Community websites and workflows for both IT teams and business clients. · Editor/coordinator for Film IT Weekly Communications newsletter. · Responsible for operation of MoveIT FTP tool, a 600+ user, internal and B2B website, creating a new web instance for Universal Product Licensing Group and developing and conducting user training for the tool. · Have developed numerous productivity tools, for both IT and business clients. · Conducted formal iSeries training sessions and continuously mentor colleagues on iSeries topics.
· Microsoft TechEd 2013 · COMMON 2012 · RPG & DB2 Summit · .Net Development 30-hour course · GE’s Support Central Bootcamp · PHP on iSeries Programming · SQL Server Administration · ASNA Wings Using Open Access for RPG
|
|
|
|
|
Experience: 2010-2015
June 1998 to 2010 |
NBCUniversal TECHNICAL LEAD, FILM TECHNICAL SOLUTIONS GROUP
· Responsible for technical support and oversight of development and maintenance of all IBM i/RPG and Windows ASP.Net/MSSQL-based applications in the legal and licensing portfolio for the Film division. · Directed activities of onsite Dev Leads and offshore development and support team. · Developed and lead SOX audits and DR planning and verifications. · Developed a SOAP-based web service for self-service password and profile administration · Conceived and developed the IBM i user profile administration stored procedure-based (SQLRPG) interface for the enterprise-wide Identity Management (IDM) system and implemented utility across all the NBCU IBM i LPARs. 2010- 2014 T
Universal Studios/NBC Universal SYSTEMS ANALYST/CONSULTANT UNDER CONTRACT TO STUDIO OPERATIONS DIVISION OF UNIVERSAL STUDIOS, INC. (CONVERTED TO UNIVERSAL EMPLOYEE NOV.1, 2000).
· Support Studio Operations Job Cost system and related Infinium based financial applications. · Primary support, developer for inter-application interfaces (using TIBCO), designing and developing custom routing and message processing daemons to interface legacy applications to SAP financials. |
|
|
· Sole developer of sophisticated queue-based report distribution system featuring email delivery of PDF conversions of report files, and web browser-based reports archive. System required custom Apache web server configuration, and custom code using RPG CGI (CGIDEV2), extensive JavaScript, HTML, CSS, and the latest AJAX techniques, to provide a self-service reports portal and email-based distribution system. · Designed, developed, and implemented browser-based inquiry system for studio emergency services, to enable rapid access to emergency contact information by security and emergency personnel. · (See page one for current/recent activity)
|
|
July 1993 to June 1998
|
Buena Vista Home Entertainment (Disney) SYSTEMS ANALYST
· Responsible for supporting Customer Service department of this distributor of Disney and ABC video product. · Designed, developed, and maintained numerous application systems used to enter and process sales orders. Entry and maintenance program coded in COBOL; all other programs RPG, with supporting CL. Extensive use of ILE RPG and SQLRPG, together with Query/400 and standalone SQL. · Served as a primary member of Standards Committee for this 100-plus programmer shop, setting programming standards, techniques, and conventions. · Provided guidance and education to junior programmers. · Developed many system utilities used by programming staff.
|
|
|
|
JIM ROTHWELLPage Three(Continued)
Oct. 1992 to July 1993
|
Foundation Health Plans, Pasadena, CA SYSTEMS ANALYST UNDER CONTRACT TO ADMINISTRATOR OF CALIFORNIA STATE A.I.M. PROGRAM.
· Maintained and enhanced AS/400-based A.I.M. membership/eligibility system. · Provided COBOL programming and database design to produce reports and data extracts used by the California Major Risk Medical Insurance Board.
|
|
|
|
|
|
|
|
|
|
|
Oct. 1992 to July 1993
|
Frederick's of Hollywood, Hollywood, CA SYSTEMS ANALYST
· Responsible for supporting Personnel/Payroll system for major retailer. · Performed system installation and release upgrades. · Developed and supported modifications to software package, including COBOL and RPG programs, DDS and SDA generated display files and subfiles. · Designed and developed programs and databases to customize and enhance personnel, payroll, and budget systems.
|
|
|
|
|
|
|
|
May 1991 to Oct. 1992 |
Montgomery Ryland Inc., Fountain Valley, CA PROGRAMMER/ANALYST FOR CONSULTING/FACILITIES MANAGEMENT FIRM
· Worked exclusively at client's HMO site in Pasadena. · Provided on-site support for Computer Science Corporation (CSC) software, liaison between client's users and CSC. · Technical support, including problem analysis and resolution, installation and maintenance of CSC releases. · Trained and assisted DP staff in programming functions on the AS/400 and CSC system technical subjects. · Developed/supported local modifications and custom interfaces to CSC software, providing support of backup/recovery for same. · Maintained/supported security for AS/400 & CSC system. · Performed product analysis and evaluation of software packages. · Designed, developed, implemented, and maintained custom programs for client. · Managed assignments to junior programmers. · Extensive COBOL, CL, CMD, and Query design and programming. · Performed programming request analysis and project estimates.
|
|
Jan. 1989 to May 1991 |
Buffums, Inc., Long Beach, CA SENIOR PROGRAMMER FOR RETAIL BUSINESS
· Designed and developed from scratch an on-line, multi-user database manager. · Worked primarily in new development of interactive inventory control and purchase order management system. · Extensive COBOL, DDS, and CL programming, with some RPG, on AS/400. · Maintained programming for retail/financial applications using COBOL and assembler. · Designed and developed many utilities including automated tape library, invoicing, and mailing list systems on NCR TOWER via SMART Database under UNIX. |