Patti Belsky Email & Phone Number

Green Bay, Wisconsin Area

Supporting Lawson 10.0.9 HR Benefits, Payroll, and Absence Management.

Columbia Falls Mt

IT Steward of Lawson 9.0.1.14 Financials, HR/Payroll, Employee and Manager Self-Service on SQL Server 2008 R2, SQL 2012. Managed successful Lawson upgrades: 8.0.3 -> 8.1, 8.1 -> 9.0, 9.0 -> 9.0.1, 9.0.1 -> 10.Primary development, maintenance, and production support programmer for Lawson systemCreator of Lawson ITIL Service Playbook.Tools UsedLawson 4GL COBOL, LID, Lawson Add-ins for Excel, Infor Process Designer (Process Flow), SQL Server… Show more IT Steward of Lawson 9.0.1.14 Financials, HR/Payroll, Employee and Manager Self-Service on SQL Server 2008 R2, SQL 2012. Managed successful Lawson upgrades: 8.0.3 -> 8.1, 8.1 -> 9.0, 9.0 -> 9.0.1, 9.0.1 -> 10.Primary development, maintenance, and production support programmer for Lawson systemCreator of Lawson ITIL Service Playbook.Tools UsedLawson 4GL COBOL, LID, Lawson Add-ins for Excel, Infor Process Designer (Process Flow), SQL Server Management Studio, PowerShell, Unix utilities, VBA, MS Office, Infor Xtreme Support Knowledge Base. Light SSRS.As a current member of the Corporate Systems team:-Serve as Project Manager for all Lawson ERP projects, and Lawson subject matter expert for IT projects. -Identify and develop custom solutions for Lawson system using 4GL COBOL, T-SQL stored procedures over application and system tables, Windows batch files, PowerShell scripting, Infor Process Designer(Process Flow) -Customize and maintain Lawson 4GL COBOL, javascript, and html source code, T-SQL stored procedures, MS Access database applications, Process Flows, Windows batch files, and PowerShell scripts. -Support custom Excel and MS Access applications used to upload payables and receivables transactions to the Lawson database.-Create and execute SQL for production data changes to the Lawson application database using SQL Server Management Studio.-Maintain Lawson ITIL Service Playbook.-Perform peer technical reviews of all SQL behind SSRS reports over Lawson application database Show less

Greater Chicago Area

Tools UsedSQL, SAS, JCL, MVS COBOL, IBM Utilities, DB2, Code1Group1, CA7, Changeman, Fileaid, Unix, MS OfficeAs a member of the Corporate division, Customer Privacy team:-Provided COBOL/SQL support for mainframe system to create marketing suppression files to comply with state and federal laws-Fulfilled ad hoc requests from Marketing, Compliance, and Legal departments for customer and non-customer do-not-solicit listing confirmation and analysisAs a member of… Show more Tools UsedSQL, SAS, JCL, MVS COBOL, IBM Utilities, DB2, Code1Group1, CA7, Changeman, Fileaid, Unix, MS OfficeAs a member of the Corporate division, Customer Privacy team:-Provided COBOL/SQL support for mainframe system to create marketing suppression files to comply with state and federal laws-Fulfilled ad hoc requests from Marketing, Compliance, and Legal departments for customer and non-customer do-not-solicit listing confirmation and analysisAs a member of the Private label Credit Card division, Data Warehouse team:-Provided COBOL/SQL support for mainframe customer credit account performance and credit application data warehouses systems, and extracts interfaced to downstream applications.-Promoted to Senior Analyst April 2003As a member of the Consumer Lending division, Customer Information Management Cross-Sell team:-Provided COBOL/SQL/SAS support for mainframe system to create cross-sell lead files-Fulfilled ad hoc requests from Marketing department for extracts and analysis related to cross-sell-Integrated Code1Group1 geographic information into cross-sell campaigns for improved population targeting-Mentored and trained junior team members Show less

Chicago Board Of Trade

Tools UsedMVS COBOL, Easytrieve, Fileaid, IBM Utilities, SCAM, MS Access, VBA, MS OfficeAs an IT Consultant on the Chicago Board of Trade Member Services team:-Provided support and enhancement of mainframe and MS Access Member Services systems, including Member Information, General Ledger, Budget, and Accounts Receivable. -Fulfilled ad hoc requests for member information systems data-Led development team for exchange fee receivables system for joint venture… Show more Tools UsedMVS COBOL, Easytrieve, Fileaid, IBM Utilities, SCAM, MS Access, VBA, MS OfficeAs an IT Consultant on the Chicago Board of Trade Member Services team:-Provided support and enhancement of mainframe and MS Access Member Services systems, including Member Information, General Ledger, Budget, and Accounts Receivable. -Fulfilled ad hoc requests for member information systems data-Led development team for exchange fee receivables system for joint venture with Deutsche Borse-Mentored junior team members Show less

Greater Chicago Area

Tools UsedMVS COBOL, Easytrieve, Fileaid, IBM Utilities, Unix utilities, VSAM, Fileaid, MS Access, VBA, MS OfficeAs a member of the Financial Systems MIS team:-Created and maintained reporting jobs, and fulfilled ad hoc requests bringing together data from patient management, accounts payable, general ledger, materials management, and budgeting systems on mainframe, Unix, and MS Access platforms using COBOL, light Unix scripting, and MS Access.-Developed automated… Show more Tools UsedMVS COBOL, Easytrieve, Fileaid, IBM Utilities, Unix utilities, VSAM, Fileaid, MS Access, VBA, MS OfficeAs a member of the Financial Systems MIS team:-Created and maintained reporting jobs, and fulfilled ad hoc requests bringing together data from patient management, accounts payable, general ledger, materials management, and budgeting systems on mainframe, Unix, and MS Access platforms using COBOL, light Unix scripting, and MS Access.-Developed automated Flight For Life flight log and Financial Systems team time reporting application using MS Access. Show less

Greater Chicago Area

-Began career in claims department of Starmark subsidiary.-Selected for company sponsorship in De Paul University Computer Career Program (see Education section). -Promoted to Programmer Analyst upon graduation and assigned to team supporting legacy mainframe life insurance enrollment system.

Erlangen Area, Germany

As a member of the MRI World Wide Service team:-Performed German-to-English translation of technical and end user documentation and buisness correspondence relating to the installation and service of Siemens' MRI product line.-Created original technical modification instructions in English for servicing Siemens' MRI products.

College Of Computing And Digital Media

Graduate of Computer Career Program (CCP), a thirty-week, restricted enrollment, accelerated certificate program designed for degreed.

Bs Criminal Justice