Business Intelligence Data Management Team* Informatica 9.6.1, Erwin Data Modeler 9.2, SQL, PL-SQL, Oracle 10g, Netezza* Led project teams to deliver back-end data warehouse solutions. Performed overall project management, analysis, architecture and solution design, development, and implementation of business and non-business initiatives for the data warehouse.* Created a development life cycle checklist to improve consistency between projects and assist new developers. * Extensive experience creating logical and physical data models for the data warehouse* Reverse engineered several existing systems for documentation* Wrote complex SQL for analysis and data profiling * Maintained abbreviations used in the data warehouse* Determined a method to merge complete subject areas into the master model, which allowed the team to overcome constraints with simultaneous development in the master model* Communicated with project sponsors to understand and document business requirements.* Wrote ETL technical design and load specifications for in-house and offshore developers* Coded ETL processes across many subject areas* Introduced Informatica Mapping Architect for Visio to Con-way. Created Visio templates to drive automated mapping generation, reducing coding by 50% on multiple projects* Monitored and tuned queries and data loads* Organized and conducted "boot-camp" induction training for new team members. Mentored associate developers.* I am the go-to person to address questions of data integrity and proper usage for data related to freight movement and optimization.

Service Center Management and Reporting Team, Linehaul / Loadplan Systems* SQL, PL-SQL, Oracle 8i / 9i / 10g, UNIX, Java / J2EE, Visual Basic, UNIX* Gathered business requirements from end-users for application enhancements* Wrote extensive PL-SQL as enhancements to Linehaul Automation, Con-way's freight movement optimization system. * Wrote extensive SQL to research questions and problems, and for ad-hoc reporting* Made enhancements to the Linehaul Java web application* Introduced Struts to the Linehaul web application* Wrote and maintained UNIX application scripts* Made enhancements to a Visual Basic client program* Wrote substantial technical system documentation for Linehaul Automation* Supported the batch and web interfaces to the Linehaul optimization C++ model.* Participated in a frequent on-call rotation for a complex, critical, highly-visible system

Corrections Team* JCL, COBOL, CICS* Analyzed legacy systems to establish requirements for data archival and retrieval* Designed the batch application interface for use with a vendor archive and retrieval product* Java/J2EE, Javascript, HTML, Struts* Gathered business requirements for the Corrections system* Created EJBs to communicate with Cool:Gen Java proxies* Designed and coded JSPs for correcting shipment information* Wrote control logic within the Struts frameworkApplication Support Team* JCL, COBOL, EZTrieve, VBA* Supported service performance reporting on the Sales system* Gathered reporting requirements from sales reps and external customers* Created ad-hoc reports to satisfy requests from external customers* Wrote macros in MS Excel to format custom reports* Created a database in MS Access to track customer requests for reports