Sr Business Analyst/ Web Developer

PAUL KRUMBACH

**** ****** **** **

Conyers, GA **094

770-***-**** **********@*****.***

770-***-**** (CELL) **********@*****.***

SUMMARY

Experienced IT Professional with demonstrated ability to create innovative solutions to real business problems by determining business needs and analyzing user requests. Effectively determines end user needs, designing efficient data extraction and presenting data in usable formats. Skilled at reducing work load for operational and business personnel by using my experience across multiple platforms and languages.

TECHNICAL SKILLS

Analysis Gather business requirements from end user

Design Design application systems and programs to extract data from various platforms and databases

Databases DB2, Domino, Access, Excel

Languages SQL, RPG, CL, HTML, LotusScript, DOS, REXX

Past Language COBOL, JAVA, C++, JCL, FORTRAN, BASIC, IDMS

Personal use Windows (currently Windows 7), Linux

Windows Applications Word, PowerPoint, Excel, Access, Brio, Open Office, Lotus Symphony, Outlook

PROFESSIONAL EXPERIENCE

IBM CORP., Atlanta, GA 1995 – 2010

IBM I Technical Support – Advanced 2005 – 2010

Primary application support for IBM sales division data warehouse

• Reduced support effort by 60% by creating automated systems in to upload files from ACSCII to EBCDIC, and format for input into data warehouse.

• Replaced old program processes with SQL to increase efficiency.

• Developed new process for data extracts per user requirements to provide EXCEL data for further analysis.

• Increased speed of error detection by creating processes to e-mail notification of program issues rather than needing to scan job logs.

• Wrote HTML real time status for data warehouse to provide more accurate and timely information.

• Created Team Room for all applications documentation in a single location, improving data storage and availability of documentation.

• Worked with team to implement new Domino Application allowing end users to request profile changes, improving customer service and expediting requests.

• Designed and implemented Lotus Domino Application to replace older system, adding new functionality for verification of data.

• Constructed and implemented intranet site for data warehouse users to get additional data increasing operational efficiency.

• Wrote custom SQL report extracts for use by managers to verify management hierarchy.

PAUL KRUMBACH PAGE TWO

IBM CORP. (Continued)

IBM I Technical Support 1995 – 2005

Automated redundant operations tasks

• Designed and implemented “lights out” backup system for 10 iSeries systems, including reporting of tapes used, and allowing for remote access to the console.

• Identified and corrected recurring problems in operations activities reduce problem calls, and maintain SLA agreements.

• Installed OS upgrades, and fixes as needed to maintain effective operations.

• Updated system security, making them “Audit Ready” to comply with all regulatory and internal requirements.

GEORGIA-PACIFIC CORPORATION, Atlanta, GA

Senior System Analyst, IBM 309X Mainframe; IBM AS/400; Windows

COCA-COLA ENTERPRISES, Atlanta, GA

Programmer Analyst, IBM AS/400; IBM 308X Mainframe

GEORGIA-PACIFIC CORPORATION, Atlanta, GA

Programmer Analyst / IBM 308X Mainframe; IBM AS/400

NORFOLK SOUTHERN CORPORATION, Atlanta, GA

Sr. Programmer / IBM 308X Mainframes

GEORGIA STATE UNIVERSITY, Atlanta, GA

Data Processing Supervisor

EDUCATION

• MA, Actuarial Science, Georgia State, Atlanta, GA, (1 year of course work completed)

• BA, Biology, University Of Chicago, Chicago, IL

SPECIAL AWARDS

(From end users for outstanding Customer Service)

• THANKS! AWARD (3), 2009 • INFORMAL AWARD – TEAM, 2000

• THANKS! AWARD (2), 2008 • INFORMAL AWARD, 1999

• THANKS! AWARD, 2007 • INFORMAL AWARD – TEAM, 1996

• THANKS! AWARD, 2006

Contact this candidate