Aliso Viejo, CA **656
15+ years of experience in data analysis, system and database administration
Proven record in software design and implementation
Broad experience in project planning and development
Expert user of software utilized by financial institutions
Educational background and experience in mathematical modeling and statistical analysis
Highly organized with strong analytical ability to analyze and solve problems
Self motivated, confident and dedicated to meeting objectives in timely and efficient manner COMPUTER SKILLS
Commercial packages such as SPSS, SWIFT Alliance, Trade Innovation, Opics, Tigers’ LynxLC, CyberLynx, Hyperion, Hyperion’s Data Integration Management, Smart View, Web Analysis and more
MS SQL, Oracle, PostgreSQL, IBM DB2, and MS Access Databases
Visual Basic, Python, Dot Net, and Pearl
Windows XP/7, Windows NT/2000 and Linux platforms
MS Office, MS Project, Business Object, Crystal Report, Dreamweaver and more PROFESSIONAL EXPERIENCE
Bank of the West – Commercial Banking Group
Data Analytics Analyst: 2012-2019
Worked on different databases, MS SQL, Oracle, and PostgreSQL
Prepared reports using Crystal Report and published in Business Object Enterprise
Automated many manual processes in preparing reports for management
Implemented nightly extraction of data from XML blobs to be used in daily reports from MS SQL server
Bank of the West – Finance Performance Management 2008 – 2010 Financial Analyst IV:
Modeled cost allocation for a number of cost centers for an important company project that sought to utilize activity based costing. The model validated HPCM calculation on these cost centers. The successful implementation of this project led to companywide use of the tool in planning and profitability analysis
Automated manual driver data preparation with required calculations, formatting, verifications and historical analysis prior to uploading to the cube. This resulted in faster processing, eliminated possible errors and made it very easy to prepare list of any missing assignments in the HPCM
Successfully implemented data sourcing from different systems. Prepared documentation and final verification for drivers that could be automatically downloaded from source system and for drivers that could be manually sourced from business units
Bank of the West - Regional Banking Group 2004 – 2008 Senior Incentive Plan Manager:
Automated data collection and processing for incentive plans and other companywide marketing campaigns requiring databases for tracking. Designed and prepared comprehensive reports for stated Regional Managers, Branch Managers, Private Bankers and TeleSales incentive plans.
Performed analysis on effect of influencing parameters on the incentive payouts.
Participated on the implementation of Motivator project and carried out data and calculation verification and comparison with the existing database.
Greater Bay Bancorp, International Banking Division 1999 –2004 Network Administrator:
Developed system to prepare combined monthly income reports by account officers/customers from DB2, SQL and Access databases.
Implemented office automation and prepared Crystal Reports to extract statistical data from different databases.
Managed and maintained the SWIFT, Trade Innovation, Cyber Lynx, Opics Servers and provided support for the Window NT/2000 work stations.
Implemented software updates and resolved operational problems.
Installed software setup and testing for desktop LynxLc and CyberLynx as well as data migrations.
Provided customer support for LynxLc and CyberLynx softwares. Kara Energy Management and Engineering Consultants 1991 – 1999 Project manager and system analyst:
Initiated projects, negotiated and finalized contracts
Developed software for comparative performance evaluation of subsidiary companies
Designed, developed and implemented decision model to prioritize backlogged projects for minimal effect on the overall operation and performance of the corporation.
Developed production cost calculation software and customized for several companies.
Performed feasibility studies and prepared required presentation reports for the banks and lenders and successfully obtained required finances.
Analyzed data relationships and designed forecasting model for scenario analysis to investigate effect of energy price increase on different sectors of economy Operation Technology Inc. 1987 - 1991
System Analyst and Computer Programmer:
Designed computer software for simulation and modeling of ground grid calculations in large electrical power systems.
Participated in development and coding of ETAP software in particular the ground grid calculations and 3 dimensional graphical presentations of the grid potentials.
Customer support and software product enhancement. EDUCATION
Masters of Science in Operations Research - University of Pennsylvania, Philadelphia, Pennsylvania
Bachelor of Science in General / Chemical Engineering - Abadan Institute of Technology, Abadan, Iran