Ab Initio System Support

Eidan Fazelian

Mobile: 847-***-**** **************@*****.***

Summary of Relevant Experience

Ab Initio graphs, ETL, Power Center ETL, UNIX, SQL, Teradata, Oracle, DB2, MySQL, SAS Coding.

Ab Initio Components, CO>OP, GDE, EME, Data Profiler, Conduct > It and Metadata HUB, BRE.

Data Warehousing, Shell Scripting, Total Application and System Support, Analysis and Design.

C / C++ Coding, Re-Engineering, Innovation, SLDC, as well as Process Improvements and Enhancements.

Proficient on Job scheduling AutoSys, Control-M, Performance Tuning, Change Management.

Credit Data and Credit data Processing Expert. Complete documentation, Debugging.

Testing & Trouble Shooting:

Root-Cause finding, problem solving, detail analysis, Q/C, Q/A, DQE, DQD, and UAT Testing.

Performance Tuning, Quality Monitoring, data integrity, working on data deficiencies with SOR.

Education:

Southern Illinois University – Edwardsville

Bachelor of Science: Computer Science, Minor: Mathematics

Honors & Awards:

Award for Date of Birth Replacement Project

Award for Reduction of Quarterly Build Cost

Damage control on First National Bank of Omaha legal action against TransUnion Credit Company.

Fixing the edit Sequence Number that links the Spouses Credit information to the main subject.

Recognition from Bank One File Compare Team

Professional Experience:

Jan 2019 – Apr 2019 Wells Fargo Banking System Contract

Oct 2022 – Jan 2024 ETL Developer, Senior Database Engineer System Support

Coding ETL on various Ab Initio components, Investigation of the older graph Tuning for performance, and speed.

Examining the customer requirements, analysis, coding, testing and implementing.

Interrogations of the production servers for any failed job, solution implemented and restart the Job.

Codes reviews, enhancements, DQE, DQD on financial data as wells as Data Profiler and data integrity

Change implementing, Data Hub ETL, Job Fail Investigation, data Debugging, Data investigation with SOR.

Examine all the servers for data processing for job Fail root causes, and Zero bytes client files.

Implementing Agile Scrum concepts and Job stream flow. PAC2000, JIRA, ServiceNow.

Teradata SQL coding, Process improvement, Data investigation, Error solving, code implementing.

Production Servers interrogation on failed, defects examining Quick View, WCC Console on the graphs.

AutoSys tool vastly use for investigation, production Jobs fixing to keep production Continuing.

Consumer Lending Applications Total Support For: SSDM, MISSD, MID, and CMDOS Using AutoSys.

Consumer Shared Applications Total Support For: EDLBC, CNAPP, BYRD, 1DWH Using AutoSys.

Apr 2017 – Dec 2018 Allstate Insurance Company Employee

Service Engineer, ETL, Ab Initio developer, System Support.

Enhance Ab Initio Architect on Operational System environment production cycle, Debugging, root cause

finding, Coding, testing and implementing change orders as well, Total System and Agent support.

Investigation of all Failed Jobs, Error files, Root cause, and Solution Implementing on XML data files.

Change Management, Jira processing, tracking activities, as well as support for Hewitt payroll and Retirements.

Implementing Agile Scrum environment as member of Agile Team, Co-Ordinate with global off Shore team.

Application and System Support, as well as Agents Support. Examining production Ab Initio graphs for Speed.

on heavy Traffic Production Jobs Run. Collect Business requirements and translate them in codes.

Continues development and enhance to speed the process and eliminate waste.

Examining Ab Initio components failures for Max Tolerance and Min Tolerance of Errors and defect data.

Q/C, DQE, DQD on the processes and the client third party data, Waste eliminations.

Technologies, Ab Initio, UNIX, SQL, ETL, DML, Shell Scripting, and data verifications and Profiling.

Sept 2011 - Sep 2013 Capital One Bank, Plano, Texas Employee

SR. system Support (SME), ETL Ab Initio Developer.

Develop, Design, Code, and Re-construct Ab Initio ETL graphs with various Ab Initio Components.

Ab Initio ETL on big financial data files, monitoring banking production files as well as servers.

ETL Jobs on Banking Recoveries and Collections, Maintained US Cards Credit Card Database.

Support, maintain, and implement new processes to the production documents. Trouble Shooting

Change Management Analysis, preparation, Reviewing the testing and detail planning.

Escalation of the production problems. Advising the L-2 to resolving production issues and problems.

Monthly status reports on Production Jobs, ETL, Embossing, Payments, CAC, Fulfillment, Share point.

Created SLA bank report, SAS report on the files attributes as well on the Warehouse data files.

Technologies, Ab Initio, UNIX, Teradata, SQL, ETL, Change Management, ITIL.

June 2007 – July 2011 Walgreens Company, Deerfield, Contract

ETL Ab Initio Developer, System Support

Designing, coding, analyzing, testing, resolving production issues and batch application support.

Create DSS create Transaction file, load, and FTP on daily bases Mondays. Process Monthly Aggregation Files

DSS_DAILY reject production files investigated for Root Cause, and Solution were implemented on all Jobs.

Participated in Graph Design and problem solving on 340B archived projects.

Develop, Design, Code, and Re-construct Ab Initio ETL graphs with various Ab Initio Components.

ETL drug file and data populating the customer files using Ab Initio ETL for data extractions.

Examined Ab Initio production graphs, tested data for integrity, Validity, and identified the root causes.

Change Management ITIL, Analysis, preparation, detail planning with DFD, gathering of requirements.

Technologies, UNIX, Oracle, P/L SQL, Ab Initio, ETL, Data Warehouse, and system Support.

Jan 2005 - June 2007 Discover Financial Risk Management Riverwood IL 1099 Contract

ETL Ab Initio developer, System Support Independent Consultant

SAS Programming and SAS report creation

Develop, Design, Code, Re-construct Ab Initio ETL graphs with various Ab Initio Components.

Teradata SQL coding and data extracting to create production file, Risk Finding and Risk solving.

Ab Initio CO>OP, GDE, EME, Data Profiler, Risk finding and elimination of Waste to Minimizing CPU Timing.

Creations of Cash Advances process, Payment Process, Finance Charges Process and Balance Transfer.

Coding, Analysis, Design, and UAT testing, including designing and solving production issues.

Solve Production Issues on daily run bases, and implementing the required solutions.

ETL tools used to extract data from CIMS to create tables and files for various internal customers.

High volume data trafficking ETL using Ab Initio, UNIX, AutoSys Scripting and Teradata Utilities.

SAS Report on BANK_Card_Lend_Id, Categories of 612 Attributes each on Manner of Payment MOP.

Coded and installed 837 Newly Attributes on the output file, SAS Report on 837 attributes.

Gathering of the data, testing the requested changes preparing full documentation. All changes were tested for

accuracy, speed, data integrity, and the fast turnarounds, Change to Production Jobs Flow Implemented

Technologies, Teradata, SQL, UNIX, Data Warehouse, SAS coding, ETL, Ab Initio

Pre-Jan 2004 TransUnion, Credit Info System Chicago, IL Employee

Senior Technical Analyst, System Support

Responsibilities included system design, analysis, coding, Enhancement, Financial saving, Revenue generating.

Simplified the operation flow of credit information, finances, and product management.

Converted Edit program, Match Program, and Select Program to C coding (CSP) from Mainframe Assembler.

Its output was further evaluated for data integrity. Many programs were designed and implemented for accuracy

of the daily processes. Allstate Fraudulent Accounts (Fraud Catcher Project).

Technologies involved, Mainframe, C / C++, Assembler, Sync-Sort, JCL, SAS coding.

Data Base Building design, Build Performance data base from scratch contain all financial and credit as well as

demographic data to distinguish financial performance Monitoring, System support, UAT, Performance Tuning.

Build, performance monitoring and system support, Converting all processes to “ C “ coding from Assembler.

Building Performance Database that includes Demographic and Financial Data for the business customers.

Contact this candidate