julia humes

About

IT professional with over 15 years insurance industry experience within the field of development, technical support and administration for Client Server, Mainframe, UNIX applications and enterprise application systems. Specialties: Oracle, Sybase and MS Access database application development; user workflow process automation; application technical support.

Country

united states

City

chicago

Industry

individual & family services

Skill

access, sql, visual basic, unix, microsoft excel, insurance, peoplesoft, pl/sql, business objects, crystal reports, visio, process improvement, sdlc, data analysis

Experience

consultant

scudder investments

2000-1 - 2000-1 · 1 mo

Analysis, design and support of Visual C++ and Unix components of complex, time-critical investment applications; consulting and technical support to end-users.

consultant

blue cross and blue shield of illinois, montana, new mexico, oklahoma & texas

1999-1 - 2000-1 · 1 yr 1 mo

consultant

interactive business systems, inc.

1998-1 - 2000-1 · 2 yrs 1 mo

systems analyst

3m health care

1996-1 - 1998-1 · 2 yrs 1 mo

technical analyst

cna insurance

1985-1 - 1996-1 · 11 yrs 1 mo

* Collaborated with team to evaluate and collect data for the cost/benefit analyses of financial investment software packages * Oracle and Sybase database design and development * Executed application system and integration testing * Provided on-call production support, program development and maintenance to mainframe COBOL applications * Supervised coding and testing activities of junior programmers * Developed GUI interfaces using Open Database Connectivity (ODBC) to connect to Oracle and Sybase Relational Database Management Systems (RDBMS)

sql data analyst - marketing loyalty analytics

true value company

2010-8 - 2012-9 · 2 yrs 2 mos

Constructed complex SQL queries and procedures to calculate key metrics as coupon redemption rate, % of sales on True Value Rewards card and ROI for analyzing effectiveness of marketing campaigns. Utilized Business Objects and Oracle for reporting and dashboard calculations.

accounting systems analyst

mcdonald's corporation

2010-4 - 2010-8 · 5 mos

* Develop new Excel-based financial analysis reports using SQL and VBA automation. * Gather user requirements and translate into new reports. * Write new SQL queries to gather/summarize data. * Modify existing reports and Accounting tools as required by users. * Write ad-hoc SQL scripts as needed to support the Accounting system users.

application development specialist

cna insurance

2000-1 - 2009-1 · 9 yrs 1 mo

* Tier 2 application support for n_tier enterprise application: * Worked with business users, development staff, application vendor and Tier III personnel in troubleshooting issues * Managed PeopleSoft and Remedy Help Desk queues * Partnered with Quality Assurance pre-production test data * fulfillment and application testing using TestDirector * Designed and developed a variety of workflow process automation * applications using Access, Excel, VBA and UNIX shell scripting * Supported Oracle platformed Data Warehouse: * Maintenance and enhancements to Control-M, Informatica and * UNIX components of the system * Second and third-level technical support of Visual Basic and Visual C++ Legal Office application software on Desktops and Notebooks * Visual Basic application development and support * Oracle Reports and Oracle Forms development * Maintenance and development of reports using Crystal Reports and Business Objects * Development, maintenance and administration of Business Objects universes