Hadi Fiuzat Email & Phone Number

Kansas City, Missouri Area

Involved in creating the Test Automation framework and scripts for Online Banking and Credit Card processing. Implemented BPM based solution for Closed Loan Systems using Appian.-- Involved in the preparation of test cases, communicating with software developers on quality issues following it up with bug reports, developing, executing and maintaining test scripts.-- Designed and developed reusable user defined functions, generic functions with well-versed VB and Java scripting in Quick Test Professional 9.X.-- Created and executed SQL queries in order to view successful transactions of data.

Lead Analyst on CIPRESS which encapsulates an Oracle National Data Warehouse with a Graphical User Interface for Cost and Route analysis.Business Analyst and Project Lead Duties:-- Led planning meetings, JAD sessions, analysis development, test inspections, and other project meeting throughout project life cycle.-- Conducted interviews and developed business cases to implement Exact Express changes, developed training materials and instructed clients on new processes and procedures.-- Delegate and coordinate tasks among programmers.-- Create technical design plans for COBOL mainframe portion of project using MS Word.-- Build test scripts detailing scenarios for enhancements as well as regression tests.-- Provide project status reports to upper-management on a weekly basis.-- Update weekly project plan to give work estimates and advised on design.-- Actively involved in design sessions developing a large forecasting model on data mart.Technical Duties:-- Performed Quality Assurance testing for a large portion of the National Data Warehouse – Created and supported SQL scripts to QA the Data Mart.-- Applied Visual Explain to locate and resolve performance tune issues with complex queries.-- Utilized Visual Studio to design Windows forms applications.-- Create workflow and Entity Relationship diagrams.

- Responsibilities: project lead; all requirements gathering and defining functionality; identifying and designing screens; developing test plans.- Selected to design and develop (VB.Net) 72 modules for loan origination, underwriting, processing and closing.- Responsible for the design and development of over 300 SQL Server stored procedures to execute over 2000 business rules in the Loan Application module.- Utilized VB.Net and ASP to fully automate the Transfer of 12,048 fields to the AS400 system for servicing of the loans.- Utilized Crystal Reports to write over 300 queries/reports used daily by business.

Business and Data Analyst on the Sprint PCS Business Billing conversion project. -- Used SQL to analyze source billing database in order to map each field to target database.-- Define business requirements for billing hierarchies and account demographics in JAD sessions.-- Create high level and detailed VISIO process flow diagrams for conversion developers.-- Conceptualized, designed and created an MS Access application as a technical solution. This application allowed Business Analysts to layout data field transformations, enter test conditions and expected results.-- Work with business contacts from other systems to determine impacts, assess risk and discuss conversion concept.-- Participate in design process for “streaming” conversion concept (no database outages, one account at a time, parallel processing.

- Designed Oracle database containing approximately 50 tables for A/R, A/P, sales and marketing, utilizing ERwin as the database design tool.- Personally designed and built 75% of the GUI front-end using Delphi.- Developed over 50 PL/SQL scripts for the back-end processes.- Led daily interactions and calls with end users.

-- Wrote over twenty Delphi processes to perform various tasks from populating the Hyperion Data Warehouse to creating the Process Scheduler. The Hyperion system is a client server application used to collect, consolidate, analyze and report on business information.

-- Responsible for new development and maintenance on the Pharmacy Clinical Information system using COBOL and the C programming language.

-- Application include: Credit Balancing, Human Resources, Direct Marketing, Inventory systems and Sales Tax-- Wrote the first C program to explode Sybase data to specific mainframe files for daily updates.-- Responsible for creating new on-line functions for the Credit Balancing system using Mantis and connecting to a DB2 database. This accomplishment was subsequently used as a standard by the systems development group.