Business Intelligence Analyst

James Meszaros

Business Analyst/Developer Profile

***********@*********.*** • 714-***-****

LinkedIn • Corona, CA 92881-4832

Results-driven and dedicated professional with strong background in analyzing business processes, executing data-driven solutions, and identifying opportunities for improvement. Business Intelligence leader with expertise in data analytics, inventory optimization, and sales performance for major fashion retailer. Ability to translate complex business needs into actionable insights, using expertise in reporting, workflow automation, and system enhancements. Committed to delivering innovative solutions, aligning with organizational goals, and enhancing operational performance. Adept at documenting requirements, collaborating with cross-functional teams, and ensuring seamless communication between stakeholders.

Areas of Expertise

Project Management

Team Training & Leadership

System Configuration

Business Intelligence

Process Automation

Data Management

Technical Support

System Analysis

Customer Relationship Management

Cross-Functional Collaboration

Workflow Optimization

Process Improvement

Professional Experience

Senior Programmer/Analyst, Pacific Sunwear of California/PSEB, Anaheim, CA 2012 – 2025

Supported and maintained custom SQL, RPG, CL, based ETL Systems for Business Intelligence / data transfer for major Clothing/Fashion Retailer. Developed, implemented, and supported Micros Relate Customer Management (Oracle Retail Customer Engagement) system. Maintained and supported IBM i / AS/400 software. Utilized extensive programming experience in SQL, RPG Free, RPG IV (ILE), RPG III, and CL/400. Upgraded and maintained Automate/Robot Automation Suite software tasks. Used IBM and third-party programming utilities, including PDM, Hawkeye, and Query/400. Provided analysis and support for various platform and software upgrade/conversion projects. Led system configuration, support, and maintenance for IBM PureData for Analytics (Netezza).

Provided support and maintenance for custom SQL, RPG, and CL-based BI / ETL systems, while facilitating business intelligence data transfers.

Administered and maintained Fortra AUTOMATE Job Scheduler for Business Intelligence and Customer Relationship Management processes.

I.T. Manager/System Engineer/Developer, Allied Refrigeration, Inc., Signal Hill, CA 2003 – 2012

Supported and maintained a PRMS Distribution/Sales/Accounting System for a major Air Conditioning Parts Wholesaler/Distributor. Maintained and supported AS/400 Hardware and Operating System Software. Developed, implemented, supported and maintained an Elite Document Imaging and Signature Capture System. Developed, implemented, supported and maintained an Elite Document Credit Card Processing System. Utilized extensive programming experience in SQL, RPG IV (ILE), RPG III and CL/400. Supported Host Connectivity solutions (iSeries Access, TN3270, etc.). Implemented, supported and maintained third-party system software (Hawkeye, etc.). Maintained and upgraded ROBOT Automation Suite software. Administered Microsoft Windows Server 2003, 2008 and Network. Designed, implemented and supported MPLS Wide Area Network.

Provided support and maintenance for Distribution/Sales/Accounting while facilitating POS/business transactions.

Developed, implemented, and supported an Elite Document Imaging, Credit Card Processing, Signature Capture System.

Additional Experience

System Admin/Engineer/Analyst/Developer, Pilkington Aerospace

System Admin/Engineer/Analyst/Developer, City of Anaheim

Sr. Programmer/Analyst, Pan Pacific Benefit Administrators

I.T. Manager/Programmer Analyst, Urban West Communities

Engineer/Analyst/Developer/Consultant, Eclipse Data Management

Programmer/Analyst, Healthgroup International

Education & Training

Computer Learning Center, Los Angeles - RPG Programming for AS/400 AS/400 System Operations AS/400 System Utilities IBM 4341 RPG II & COBOL System Design/Analysis

IBM Technical Education Center, Norwalk - System/36 Operations RPG II Programming Display Station Design Work Station File Coding

Los Angeles Valley College, Valley Glen - Computer Sciences/Business

Qualifications

SQL, Database Management, DB2 Programming Netezza Appliance/Snowflake Configuration

IBM System i (iSeries, AS/400) Midrange Support Operating System Administration & Software Support

Hardware System Administration & Support System and Programming Utilities System/Control Language Programming

Management, Project Leadership, and Staff Training Business Intelligence ETL Design & Development

Business and Industry-Specific Accounting & Financials Management & Leadership Consulting

RPG Free, RPG IV, and RPG III Programming Subfile Programming & Processing AS/SET ADK (CASE 4GL) Programming

Screen & Report Design Tools Host/P.C./LAN Connectivity (Client Access, EDI) HTML/Web Coding & Web Page Design

Windows Server Configuration & Management MIMIX Data Replication Software

ROBOT Automation Suite Installation & Maintenance Fortra AUTOMATE Job Scheduler

Micros Relate Customer Management Oracle Retail Customer Engagement System

Elite Document Imaging Software & Hardware Elite Credit Card Processing Software & Hardware

Technical Proficiencies

SQL Netezza Snowflake Postgresql IBM i RPG Free RPG IV (ILE) RPG III RPG II CL/400 HTML AS/SET ADK (CASE 4GL) COBOL DB2 C Business BASIC-4 Pascal Assembler FORTRAN Thousands of programs written.

Contact this candidate