Eidan Fazelian

Mobile: 847-***-**** ad4ftj@r.postjobfree.com

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

June 2021 – July 2023 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.

May 2019 – May 2021 FedEx Software Company Contract

Ab Initio ETL, FedEx System Support, Memphis Tennessee

Coding Testing and Enhancing all the related Ab Initio graphs and Ab Initio components regarding the FedEx

Human resources Support for Work Day file, Retirement file, and Payroll file.

Core HR Flow. Over Seeing Ab Initio Hub Data on Employee Dimensions, Employee Job History, Organization,

HR Files Support, third party Vendors files verifications for data accuracy, Organizational Hierarchy maintaining.

Examining Integration coming in and Going out redirect Vendor Interface.

Creation various Schedules Flat Files for Various vendors, Verification and examining the Vendor input data.

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.

Oct 2013 - Jan 2017 Sears Holdings, Hoffman Estates IL Contract

System Engineer, ETL Ab Initio Developer

SQL Assist and, TSAM, Performance tuning, Trouble shooting, ETL, Change Management, ITIL, J2EE.

ETL best practice and support Teradata software upgrade Installations and Meet the SLA.

Teradata ETL, ELT, MySQL data tables transfer to DB2 database tables. Tomcat, J2EE, UNIX.

Performing Root Causes analysis and findings on critical failures implement solutions daily status report.

Collect customer business requirement, design and build system to answer business requirement.

Improve data quality for internal use, data studies, and data testing purposes.

Teradata ETL extraction data from CDW (customer data warehouse) for reporting purposes.

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, IL 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

Contact this candidate