Jeff Humphreys

Business Analyst

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

Greenleaf, ID 83626

208-***-****

sd4yxo@r.postjobfree.com

SUMMARY OF EXPERIENCE

Business analyst and report developer with 22 years experience in designing and building custom databases and ETLs on Oracle and Microsoft SQL Server platforms. I have used Linux, UNIX and Window environments. Determined self-starter with excellent analytical skills. Comfortable working with customers and identifying subtle requirements.

TECHNICAL PROFICIENCY

Software:

Excel, Word, Access, Visio, Subversion, ClearCase, ksh

Operating Systems:

Windows 95/98/NT/2000/XP, UNIX, linux

Languages:

SQL, PL/SQL, T-SQL, Visual C++, C++, U++, Access Basic, Visual Basic 3, 4, and 6, Pascal, JavaScript, Actuate Basic, Actimize Basic

Database Environments:

Oracle RDBMS V7, 8, 8i, 9i, 10g and 11g, Microsoft SQL Server 6.5, 2000 and 2005, DB2, Teradata, Access 2.0, postgreSQL 8.4, dBASE III/IV, FoxPro, FoxBase, Clipper, Arago

Tools:

PL/SQL Developer, DTS Packages, Toad, SQuirreL SQL Client, pgAdmin, ERWin 3.5, Oracle Forms 4.5, Embarcadero

Reporting Tools:

Actimize 3, Actuate 5, 6, and 7, MicroStrategy 7 and 8, Crystal Reports.

WORK HISTORY

Business Analyst - Compliance Technology

Banc of America Securities/Merrill Lynch

Public Company; 10,001+ employees; BAC; Banking industry

July 2003 – November 2011 (8 years 5 months) New York City, NY; Greenleaf, Idaho

Started as Business Analyst and Actuate report developer.

Moved into database architect, designer, builder, and ETL author.

Converted Montgomery Securities compliance reporting system to BofA in NYC.

Designed and built Compliance Technology's first MicroStrategy system for generating and mailing reports.

Designed and built Fixed Income Compliance database to support Actimize surveillance modeling.

Designed and developed surveillance models from Compliance requirements.

Procured data feeds from internal data providers as well as external, such as Thompson, FINRA, MSRB, and Bloomberg.

Constructed data feeds using DTS packages in SQL Server 2000. System is still live and highest performing Compliance Tech reporting solution.

Designed highly maintainable framework of Actimize Basic functions that never duplicates business logic implementation, and consolidated all shared queries into single components. Worked with user on output report XML.

Wrote Oracle XML extraction queries for alert reporting.

Engaged dynamically with data suppliers at all tiers.

Worked with watch/restrict list database design, affiliate investment monitoring database design, Equity surveillance models, and Equity Aggregation reporting.

Assisted migration of BofA database to Merrill Lynch warehouse.

Wrote technical documents.

Deconstructed ETLs for offshore implementation.

Environment: Oracle RDBMS V9i, 10g and 11g, Microsoft SQL Server 2000 and 2005, DB2, Access 2.0, Actimize, Actuate, MicroStrategy

Project Manager

Citibank

Public Company; 10,001+ employees; C; Financial Services industry

March 2003 – July 2003 (5 months) New York City, NY

Administered database-driven Oracle/Java/C++/VB framework for Actuate development on Citibank’s CitiDirect Online reporting system. Extended framework functionality with additional presentation logic. Installed and configured Actuate 6 on production servers. Worked closely with Actuate to resolve critical bugs and gain diagnostic patches. Documented existing processes. Analyzed performance in relation to advanced server settings. Developed SQL scripts for rapid analysis of production issues.

Designed Access 2000 tool to collect web-based documents across 21 servers, and parse into history tables. Tool also executed web URLs into Actuate to verify user view was valid. Also sorted and verified patches being deployed to production. Debugged and solved problems involving multi-language support, RTF and PDF generation, dynamic frame layouts. Setup small lab for off-line Actuate service pack, fix, and release testing.

Report Developer/Analyst

Arrow Electronics

Public Company; 10,001+ employees; ARW; Logistics and Supply Chain industry

October 1999 – March 2003 (3 years 6 months) Englewood, CO

Developed web applications for Arrow’s first intranet using Java and J2EE, which provided opportunities to explore new technologies and design patterns.

Developed complex SQL for global inventory price analysis across 6 disparate accounting systems.

Reduced critical Actuate report generation time from 7 days to less than 14 hours by converting contractor’s design to an experimental design that unioned layered output from full outer joins into a data-laden support table against which several complex reports could be run.

Developed web-based multi-layer drilling reports in an OOD reporting tool called Actuate.

Provided report solutions for an Obsolescence Review system that solved complex reporting requirements using Oracle 9i’s Analytical CUBE function to create cross-tab data that was then converted into 3 vertical flows by customer / product / total which each pushed out 3 vertical sub-flows of over-threshold / under-threshold / total. The report allowed the customer to identify over-reserved parts and possible savings by reducing unnecessary reservations.

Developed high-performance SQL for identifying users meeting boolean search criteria based on LDAP fields. The solution was unique in that it allowed intuitive use by users without having to know how to query the database.

Contact this candidate