Daniel Moy Email & Phone Number

Northfield, IL

I am working the company's mandate to:- modernize and upgrade the reporting function of its accounting and sales analysis reporting,- develop the Business Intelligence companion piece to the modernized and upgraded sales analysis reporting function.Using: SQL Server, SQL Server Reporting Services (SSRS)

Greater Chicago Area

• Responsible for converting customer criteria to SQL statements and extracting the consumer credit data with JCL, and creating distribution reports using SAS and Easytrieve for verification of data.
• Performed more than 150 account solicitations, portfolio reviews, and monthly audits annually, improving accuracy and minimizing risks for the customer.
• To reduce operating expenses, converted nine data extraction projects from the mainframe platform to a new open systems platform saving several million dollars.

Trans Union

• Responsible for converting customer criteria to SQL statements and extracting the consumer credit data with JCL, and creating distribution reports using SAS and Easytrieve for verification of data.
• Performed account solicitations, portfolio reviews, and monthly audits annually, improving accuracy and minimizing risks for the customer.

Logility, Inc.

• Assigned to write COBOL code according to company-designed specifications in addition to performing perform unit and system testing.
• Added additional functionality to supply chain software leased to Federal Express improving its ability to manage shipments and deliveries.

Health Care Services Corporation

• Responsible for designing and coding executable deliverables (COBOL, DB2/SQL), as well as writing test cases and scripts, executing system testing, and documenting results.
• Provided coding and testing streamlining adjudication and processing of patient claims from five business days to one day.
• Increased claim processing capacity to handle up to 1 million claims daily.
• Provided high-level training to 50 members of other application groups, stakeholders, and production support teams on the modernized functionality of new application.

CVS/Caremark

• Responsible for designing and coding executable deliverables (COBOL, DB2/SQL), writing test cases and test scripts, executing system testing, and documenting results.
• Converted batch sorting jobs from Syncsort to DFSORT, saving more than $1 million in software licensing expense.
• Designed and created the data mining job stream of more than 1,000 patients daily to determine eligibility for health care flexible spending account.
• Provided coding, testing and production support to the existing Pharmacy Benefit Eligibility Manager (PBM) application to facilitate changes mandated by federal regulations or business requirements.

United States

• Responsible for designing and coding (COBOL, DB2/SQL); writing test cases and test scripts, and executing system testing.
• Produced components for both batch and online applications in company’s multi-year modernization project.

United States

• Responsible for designing and coding (COBOL, DB2/SQL); writing test cases and test scripts, and executing system testing.
• Coded and tested various mainframe components, converting apparel merchandise applications to the Kmart platform, replacing the Sears legacy application and reducing purchase order process from seven to 1-2 business.

United States

• Responsible for designing and coding (COBOL, DB2/SQL); writing test cases and test scripts, and executing system testing.
• Provided daily data mining and statistical tracking to marketing department for decision support, processing thousands of transactions per day, to increase customer usage of telephone banking channel.
• Coded and tested various mainframe components, achieving multi-million dollar operating savings through the conversion of several separate and duplicate batch/online retail/corporate banking applications.
• Instrumental with in-sourcing of time-shared insurance application usage to the Chase platform.

United States

• Tested and assisted in the install and provided production support of the Hogan Earnings Analysis System to give the bank the ability to measure its profitability at a corporate, state or cost center level, assisting.
• Developed a data extract from the Hogan Earnings Analysis System to feed a separate PC-based package and provide the means to help measure an increase the bank’s market share in commercial loans and similar products by.
• Decommissioned applications and archived files during the shutdown of First of America applications and passed relevant files to National City per federal and bank requirements
• Executed processes to convert bank files for Y2K.
• As a Data Warehouse Analyst executed batch jobs loading the National City Data Warehouse.

United States

Hogan DDA Programmer Analyst

United States

Mainframe Programmer Analyst IBM BAL and COBOL, IMS, DB2, VSAM

Diploma, Computer Science For Business, Computer Science For Business

B.A., History, Political Science

College Prep Diploma, College Prep Curriculum