Data Analyst Office

Alfred L. Cody

**** *. ********* ***.

Orange, CA 92869

D: 714-***-**** E: 714-***-**** C: 714-***-****

Email: adj221@r.postjobfree.com

Objective: To obtain an IT position utilizing SQL Server, MS Access, Crystal Reports technologies

Certifications: Microsoft Certified Solutions Associate SQL Server (MCSA) January 2021

Microsoft Certified Professional Data Management and Analytics January 2021

Front-End Web Development Certificate from W3Cx October 2020

Certificate in Production and Inventory Management (CPIM) July 1989

Education: M.S. Management Science, California State University, Fullerton 1988

B.A. Business Administration, emphasis MIS, with honors, California State University, Fullerton 1986

Relevant Experience and Skills:

SQL Server and Business Intelligence, New Horizons December 2020 Skills Acquired: Transact-SQL, SSIS, MS Access and Crystal Reports

Certificate in Excel for Data Analyst 2017, Edx Online

Certificate in C Programming Language, CSUF 1994

Experience: Infosys Inc.- Technology Analyst, January 2019 – May 2020

While at Wells Fargo, responsibilities included learning various remediation processes and completing specific remediation efforts such as adding comments to notepad records or setting warning flags for an input list of accounts. Software projects included enlargement of notepad buffer and the GAP refund project. Participated on Collections Agile/SCRUM team.

Technology Platform: Unisys MCP, CANDE, COBOL74, WFL, DMSII, COMS/MARC, Programmer’s Workbench, Microsoft Office

Conduent Inc. – Sr. Programmer/Analyst, October 1999 – December 2018

Responsibilities include development of major enhancements to the Guarantee Loan System (GSL); Completion of medium size system development request (SDRs); Research of day to day Trouble Tickets; Participating in an on-call rotation to provide 7 by 24 support of GSL production batch processing.

Major Development highlights:

2003-2004: Redesign of Borrower Incentive System. Movement of incentive plan from account level to disbursement level to allow a borrower to have multiple incentive plans within an account. Introduction of separate status values for each benefit reduction type (ACH Reduction, Interest Reduction, and Rebates) to track the benefit life cycle for each benefit type separately. Establishment of Incentive plan setup and qualification screens (ACMS tasks) to allow user entry of new incentive plans.

2007: Addition of confirmation step to all GSL parameter screens. This confirmation step would bring up a confirmation box with a Yes/No option to allow user one final review point before committing a GSL parameter change.

2008-2009: Redesign of Adhoc client reporting system. Introduced database tables to hold client reporting parameters and field definitions. Built online screen to allow users to set up new parameters and can select the fields they want reported. Further enhancements provided for a user directed batch cycle indicator – daily, weekly, and/or month-end. The adhoc process was automated to query the adhoc database table for all adhocs belonging to a cycle, build a scheduler file, and then start the scheduler file in the appropriate batch environment, i.e. – daily, weekly, or month-end.

2009-2010: Billing Account Number (BAN) for GSL online screens. Participated as a member of a team to implement the Billing Account Number to GSL Online screens. Provided input to high-level design to change ACMS screen forms (IFDL), server modules, and task steps (.TDF files) to incorporate the BAN. Coded, tested, and implemented five GSL online screens.

2010 – 2011: Income Based Repayment (IBR) for GSL system. Lead the design and programming for a section of the development of IBR into the GSL system. Programmed the new financial IBR concepts such as IBR government interest accrual (IBR IRGC), IBR borrower interest accrual (IBR IRB), and IBR average daily interest (IBR ADI) into the accrual process. Programmed the payment application rules specific to IBR into the payment process and enabled IBR processing to occur in the transaction reapplication process.

2014 – 2015: Service member processing for GSL system (SCRA). Lead the design and programming for a section of the development of SCRA into the GSL system. Programmed the new financial SCRA concepts such as SCRA ADB and SCRA SH ADB into the accrual process.

Technology Platform: Itanium/Alpha/VAX VMS COBOL, ACMS, Oracle RDB (RDBMS), SQL, DCL, Reflections, Microsoft Office (Excel, Word, and Access), Sharepoint

Accenture Inc. – Information System Engineer, January 1994 – September 1999

Responsibilities included supervising 5 – 7 programmer/analyst; assisted programmers in starting their assignments; reviewed code changes prior to implementation. Duties also included programming and implementing code changes to stabilize the production batch environment. Also responded and resolved high priority job aborts and billing issues as part of day to day activity. This position was the result of Pactel Cellular outsourcing development to Accenture.

Technology Platform: Itanium/Alpha/VAX VMS COBOL, ACMS, Oracle RDB, SQL, DCL, Reflections, Microsoft Office

Pactel Cellular – Production Support Analyst, October 1990 – December 1993

Responsibilities included providing first response support for batch and online issues on the cellular billing system (PRISM). The source of the work was from operations and the helpdesk in the form of trouble tickets. Worked with on-call programmers to resolve major issues occurring in the cellular billing system. Implemented small programming fixes into production code.

Technology Platform: Itanium/Alpha/VAX VMS COBOL, ACMS, Oracle RDB, SQL, DCL, Reflections, Microsoft Office

Unisys Corporation – Programmer/Analyst, January 1987 – September 1990

Debugged, maintained, and developed software for the Procurement Information Module (PIM) of the Burroughs Advanced Manufacturing Control System (BAMCS). Responsibilities included the development of reports in RP3 – Reporter. Developed and implemented the History Card screen for the PIM Module which enabled users to enter and maintain freeform notes for purchase parts. Participated on off hours on-call rotation to support Production.

Technology Platform: Unisys MCP, CANDE, COBOL74, WFL, DMSII, COMS/MARC

Contact this candidate