-- Design structure of new data warehouse -- Write T-SQL scripts and stored procedures to scrub, normalize, transform and load data-- Automate Star Measure reporting for Medicare clients

-- Design and build reports for Student, Personal, and Installment Lending departments using Base SAS 9.4 and SQL Server Reporting Services 2012--Formulate new query and design logic for dozens of existing SAS and SSRS reports to meet constantly changing needs of the business--Deep dive data analysis to enable business leaders to answer mission critical questions--Comply with bank policy and procedure for testing, documenting and roll out of new code--Recommend changes to SQL Server Integration Services packages and SQL Server Management Studio jobs and stored procedures to improve performance or accuracy of data.--Maintain Microsoft SQL Server data warehouse, design new tables, jobs and SSIS packages to extract, transform, load and store data

-- Technical team member on upgrade of Oracle E-Business Suite 11.5.10 to 12.2.3; retrofit, redevelop and test custom code, troubleshoot errors, research patches, apply solutions via application and database configuration changes-- Design and code new PL/SQL stored procedures in response to business needs within the Corporate Controller's group (Accounts Payable, General Ledger, Fixed Assets, Projects, Purchasing)-- Modify existing PL/SQL code and Unix scripts-- Write all requirements and testing documentation associated with Oracle projects-- Update firewall rules to ensure network traffic between Citizens Bank colleagues, applications, and externally hosted Oracle EBS servers.-- Create forms and modify internal web content using HTML, JavaScript and MS SQL Server-- Build MS Access databases and MS Excel workbooks enhanced with VBA to provide additional analysis and automation on smaller projects

This part time position is the best of both worlds: a job and a hobby! I've enjoyed being a part of this team since 1999.

--Reversed $40K annual loss through design and implementation of an outbound shipping policy for 1000+ products from nearly 30 manufacturers--Renegotiated warehousing contracts annually, shrinking logistics budget by 17% in 2010 by lowering carrier shipping rates, capping storage fees, reducing value-added-service charges --Authored quality control and packing procedures which decreased picking errors and damaged inventory, completely eliminating several recurring problems --Improved average order turnaround time by 24 hours through restructuring of order processing methods--Collaborated with UPS Supply Chain Solutions to establish sales to Canada; also managed all necessary tax, customs, and cost documentation and analysis--Reduced inventory on hand while increasing availability of best-sellers by modifying purchasing schedule and reorganizing product collection into permanent and seasonal groups

--Implemented standard processes for confirming purchase order information which encouraged transparency and retained large volume accounts through 2008-2010 economic recession--Hired and trained employees to become proficient in corresponding with customers, general accounting, order processing, inventory allocation, and logistic methods--Executed a $750K inventory liquidation and various cost/benefit analysis on overstock sales and promotions--Assisted in design and editing of bi-annual catalog--Drew on first hand knowledge of French language and culture to educate customers and sales team about CDF product

--Automated tradeshow order writing with installation of barcode scanning system, minimizing down time associated with back-office order processing--Directed construction of 1000-square-foot national showroom in Atlanta, GA: negotiated multiple-year lease, designed layout, hired and supervised general contractor --Attended and performed start to finish organization of up to 12 tradeshows per year in US and Canada

-- Performed set-up/break-down and basic troubleshooting of necessary mics, cables, mixers, and computers-- Diagrammed sets and logged sessions

SUMMER POSITION-Organized and managed all festival transportation needs-Key resource for festival, assisting patrons with local accommodations, attractions, and restaurants-Maintained box office records, ticket orders, mailing and guest lists

-Strengthened students' oral expression skills in colloquial English-Engaged groups of 12 to 50 students demonstrating beginner to advanced abilities in English-Guided students on culture immersion trips to New York City, England, and Ireland