Senior Developer Resume Philadelphia, PA - Hire IT People

TECHNICAL SKILLS:

Databases: Oracle, Microsoft SQL Server

Software: Toad, Informatica 9.5.1, Oracle SQL Developer, Oracle SQL*Plus, Oracle SQL*Loader, Microsoft Office, Powerbuilder 7

Programming Languages: SQL, PL/SQL, HTML, JavaScript, ASP, VBScript, CSS, WebDav, SAS, FOCUS

Operating Systems: Windows, Linux, and Unix

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Senior Developer

Responsibilities:

Implemented a development environment for the original data warehouse. Previously, all coding and testing was done in production. Creating a development area allowed us to add new data fields and functionality without impacting users’ reports in production.
Worked with the ODS business sponsor to implement data standards for the ODS. ODS uses codes to look up names and descriptions for locations, carriers and containers.
Identified, created and implemented global master reference tables. Master reference tables include SCAC Codes, UN Location Codes, ISO Container Type & Size Codes, ISO Country Codes, ISO Subdivision Codes, U.S. Schedule D & K Codes, Lloyd’s Vessel Codes, and IATA Airport Codes.
Developed a global master reference website that allows users to view data in the master reference tables.
Developed a new load process for SCAC Codes that improved data quality and load time by 50%. The new process replaced the quarterly files with daily files, which has a column to indicate which SCAC codes are to be added, updated or deleted.
Made process improvements to main Informatica workflow that loaded the data warehouse reducing load runs from 4 hours down to about 10 minutes and in turn reduced file crash ratios.
Made process improvements to the container status workflow that reduced load time from 60 minutes to 90 seconds.

Confidential, Exton, PA

Consultant

Responsibilities:

Developed a real - time collaborative web site that enabled engineers to collaborate over the Internet. Web site allowed engineers to conduct on-line meetings via chat, instant messaging, white board, video, and audio, and work on team projects through project folder collaboration and task workflow. Site used the Exchange 2000 Server and its Conferencing and Workflow products to deliver the site’s functionality.
Created the project folder functionality that enabled engineers to create folders and subfolders, store content, and retrieve content from the folders. Enabled the web site to do web conferencing while presenting content to the engineers.

Confidential, Horsham, PA

Consultant

Responsibilities:

Implemented a keyword search feature that returned links based on keywords entered by the user. Similar to AOL’s keyword search functionality.
Implemented a workflow application that enabled contractors to submit their timesheet, obtain approval, send the approved timesheet to the consulting agency, reconcile invoices, and submit an Accounts Payable voucher to the Accounting department.
Enabled the Firm’s cafeteria to receive catering orders for special events.
Enabled the Firm’s employees to review and change their medical, dental, legal, TRSA, and supplemental life insurance benefits.
Enabled internal and external users to apply for jobs online and HR to enter job openings.
Performed Y2K testing that resulted in only minor date formatting changes to Confidential.

Confidential, Princeton, NJ

Programmer

Responsibilities:

Created an Excel application that would generate up to 24 charts on one side of a 8.5 inch sheet for 700 branch offices, 32 sales districts and 3 sales regions.
Member of a 3-person project team that created a data warehouse, which resulted in 50% reduction of mainframe cost within the first year of rollout.
Integrated six Private Client Marketing web sites into one secure web site with 5 levels of security.
Created an informational web site that explained the Firm’s new product development lifecycle and listed the new products in development.
Created a web site that explained the basics of Outlook 97 and minimized the need to formally train users on Outlook 97 as the department migrated from cc:Mail to Outlook 97.