Resume

Sign in

Programmer / Analyst

Location:
North Chicago, Illinois, United States
Posted:
December 04, 2017

Contact this candidate

James Becker

Computer Programmer/Analyst

(224) ***-**** Mundelein, IL

Qualifications Summary

I am an accomplished Senior SAS Programmer/Business Data Analyst with over 20 years of programming, analytical, problem solving, and documentation experience. In addition, 7 years of managing, troubleshooting and instructing experience.

I have programmed in functional areas of Credit Risk, Risk Management, Sales and Marketing, Customer Service, Merchant Funding, Credit & Collections, Statistical Analysis and IT.

Technical Experience

LANGUAGES (years) SAS (24) COBOL (8) NATURAL (2) ACCESS (8) VISUAL BASIC (6)

HTML (9) ASP(9) ORACLE (9) STATISTICA (1) PERL/SCL (2)

SOFTWARE SKILLS (years) JCL (12) SQL (19) DB2 (10) EXCEL, WORD, POWERPOINT (12)

SharePoint / XML(1) Spotfire (2)

PLATFORM (years) PC/SERVER (14) AS400/MAINFRAME (11) UNIX (2)

Related Achievements

Converted data from multiple platforms into consolidated analytical reports which were instrumental in finance company merger, which doubled account portfolio.

Converted projects from mainframe to client-server based environment, to utilize system resources and new analytical reporting tools using Oracle, Teradata and SAS datasets.

Negotiated specialized programming niche by creating a solution that compiled a set of department production reports and saved organization $250K in out-sourcing fees.

Acted as senior analyst and troubleshooting manager to help multiple teams create efficient code that ran hundreds of analytical reports, which ultimately minimized CPU usage saving resources and run-time.

Utilized multiple system data sources using Mainframe SAS, COBOL/Natural, and PC SAS/Visual Basic to create monthly Credit & Collections and Credit Risk Databases.

Designed, implemented, coded, tested, debugged, and maintained numerous productionalized programs and challenging adhoc analytical reports while acting as department troubleshooting manager to analyze portfolio data.

Taught SAS Classes for new programmers entering Collection MIS department.

Management Consultant for leading finance company during their relocation process. Transferred data reports and led mainframe training for future prospective programmers.

Received outstanding achievement award due to command of programming language and report efficiency.

Designed, implemented, coded, tested, debugged, and maintained numerous clinical reports for submission to the FDA.

Lead Member of a three-programmer team to create an online Intranet system for Statistical report retrievals for our scientists to create reports for FDA submission from the LIMS/SAP system data to lessen the requests for the statistical team. Saving company of 1-2 FTE per yr.

Professional Experience

SAS Consultant (Marketing Anaylst ) Abbvie Mettawa, IL May/2016-Current

SAS Consultant (IT SAS Specialist ) Abbvie Abbott Park, IL Dec/2014- Mar/2016

SAS Consultant (Programmer/Analyst) HSBC Mettawa, IL Dec/2012- Mar/2014

SAS Consultant (Programmer/Analyst) GlaxoSmithKline Zebulon, NC Jan/2002- Dec/2011

SAS Consultant (Programmer/Analyst) IBM/Qualex Durham, NC May/2000-May/2001

Programmer/Analyst Household Financial Corporation Prospect Hts, IL Dec/1997-Nov/1999

Programmer/Analyst Dontech (Ameritech Yellow Pages) Chicago, IL Jul/1995-Dec/1997

MIS Programmer/Consultant Household Retail Services, Inc. Wood Dale, IL Jul/1995-Mar/1996

Collection Specialist/MIS Programmer Household Retail Services, Inc. Wood Dale, IL Jun/1987-Jul/1995

Education

Blackburn College, Carlinville Illinois May 1991

B.A Computer Science/Mathematics

Educational Accomplishments

Blackburn College, Carlinville Illinois

Worked 15 hours per week in Collegial Work-Study Program. Designed, developed and implemented user friendly applications in C++ on DEC VAX. (Blackburn Financial Aid and Student Business Office Databases)

Chosen as the Blackburn nominee for the United States MCM competition in Mathematical Modeling.

Lab Assistant for college students in troubleshooting problems in LOTUS, WP, DBASE and other programming languages and tools.

James Becker

Computer Programmer/Analyst

ac3k7t@r.postjobfree.com

WORK EXPERIENCE

SAS Knowledge SAS: FUNCTIONS, FORMATS, REPORTS, MACROS, PROCEDURES, XML, ETL

PACKAGES : BASE SAS, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, EG/BI

OTHER: SDLC, UTC, UAT, ADAM, SDTM, CDISC

Abbvie Mettawa, IL

May-2016 to Dec-2017 Designed, implemented, coded, tested, debugged, and maintained SAS Marketing Applications for all departments using PC SAS.

Instrumental in creating an Analytical Database used within the company.

PC SAS, SQL, EXCEL, PowerPoint

Abbvie Abbott Park, IL

Dec-2014 to Mar-2016 Designed, implemented, coded, tested, debugged, and maintained IT SAS Applications for all departments using PC SAS and UNIX SAS.

Instrumental in helping the IT Team respond/resolve issue tickets from system users.

Maintained knowledge base surrounding all SAS Utilities used within the company.

PC SAS, UNIX SAS, SQL, EXCEL, Spotfire, PERL/SCL

HSBC Mettawa, IL

Dec-2012 to Mar-2014 Designed, implemented, coded, tested, debugged, and maintained month end programs for data collection and analysis, using PC SAS and Mainframe SAS.

Instrumental in automating month end processes to save time and resources, reducing processes to a fraction of the time and eliminated a majority of the manual work.

PC SAS, Mainframe SAS, SQL, JCL, ETL, CLIST, EXCEL, VBA, TSO/ISPF

GLAXOSMITHKLINE Zebulon, NC

Jan-2002 to Dec-2011 Designed, implemented, coded, tested, debugged, and maintained statistical programs and clinical analytical reports from the LIMS system data for submission to the FDA using PC SAS and SAS HTML/ASP.

Reported and provided key insight into clinical development performance and resourcing. Designed project database to store data (1M+) records.

Fulfilled unexpected department requests for analysis with adhoc analytical reports.

Team Lead Member of a programming team to create an online Intranet system for Statistical report retrievals for our Scientists and Process Engineers to create reports for FDA submission to lessen requests for the statistical team, saving company 1-2 FTE.

PC SAS, ETL, HTML/ASP, DB2, SQL, Access, EXCEL, VBA, Oracle/Toad, XML, SharePoint

IBM/QUALEX Durham, NC

May-2000 to May-2001 Produced adhoc analytical reports to fulfill unexpected department requests to analyze company portfolio.

Maintained Sales and Marketing programs and reports for production.

Mainframe SAS, SQL, JCL, ETL, TSO/ISPF

HOUSEHOLD INTERNATIONAL Prospect Heights/Elmhurst/Wood Dale, IL

Dec-1992 to Nov-1999 Senior Programmer designed, implemented, coded, tested, debugged, and maintained Credit Risk Department SAS Database using Mainframe SAS, COBOL and PC SAS.

Created adhoc analytical reports while acting as department troubleshooting manager.

Mainframe SAS, SQL, Mainframe COBOL, PC SAS, ETL, JCL, TSO/ISPF, CLIST



Contact this candidate