SUMMARY:

• Innovative, technically inclined, and high - powered professional with extensive and progressive background in IT business.
• Demonstrate results-driven performance in environments where functional responsibilities are aligned to business strategies.
• Thrive in operating and maintaining state-of-the-art technology systems, with reliable management information tools specific to company’s business and its markets.
• Exemplify unparalleled ability in the implementation and management of diverse programs concurrently.

TECHNICAL SKILLS:

Operating Systems: HP Unix; MAC OSX; Windows; HP VMS; IBM MVS/JES2

Networking Tools: VMWare Workstation, TCP/IP, FTP, SSL, SSH, IIS

Hardware: Complete PC system assembly, servers, workstations, peripherals, PC, MAC

Software: Oracle; SQL*Plus; Toad; Informatica PowerCenter; SQL Server/SSIS; Attunity; Microsoft Office

Programming Languages: SQL; PL/SQL; T-SQL; Unix Shell Scripting; COBOL

PROFESSIONAL EXPERIENCE:

Confidential, Exton, PA

Informatica Developer

Responsibilities:

• Working for a client in Center City Philadelphia to convert their in-house mainframe COBOL Payroll system to an external vendor (Ultimate). The date from the HR system is accessed via an Oracle view that we are using to load the new “middleware” system to get data, via XML files, to Ultimate. This includes working with the IT team and Payroll team alongside of Ultimate. It also includes teaching the clients employees how to use Oracle, SQL and Informatica, since they are COBOL/VSAM developers.

Confidential, Philadelphia, PA

Business Intelligence Engineer

Responsibilities:

• Was on the Marketing team in which we converted the external marketing system (Merkle) to inhouse utilizing Informatica. This includes converting Netezza packages to Informatica mappings and reworking the Merkle Informatica mappings to Urban standards, which includes, for speed purposes, streamlining the code rather than running mappings one job at a time. Work with the Microstrategy team to produce reports for the Urban brands. Worked closely with the Merchandising team accessing SSIS and T-SQL packages.

Confidential, Horsham, PA

Data Engineer II

Responsibilities:

• Responsibilities include the collaboration with business analysts, data architects, statisticians and project managers to determine data integration requirements, while ensuring best practices and standards are followed in design and development; development and automation of new data management solutions using PL/SQL, Informatica and Oracle Warehouse Builder; production support and issue resolution of existing ETL processes; proactive monitoring of data integration processes within data services architecture; timely and consistent delivery of high quality solutions that meet design and requirements specifications; provide technical mentoring to other team members.

Confidential, King of Prussia, PA

DATABASE DEVELOPER II

Responsibilities:

• Responsible for support of the ODS and Data Warehouse. Currently involved with the conversion from the current Dunn and Bradstreet MDM solution to an Informatica/Siperian solution including IDQ. Involved in the testing of the Informatica PowerCenter 8.6 to 9.1 upgrade. Have responsibility for our teams databases including creating/modifying tables, views, links, materialized views and synonyms as well as their initialization.

Confidential, Philadelphia, PA

SENIOR APPLICATION ENGINEER

Responsibilities:

• Assume various responsibilities, including loading the Data Warehouse, DataMart, ODS and various other Oracle databases from a VMS RMS system and SQL Server utilizing Informatica PowerCenter 8.1, SQL Loader, COBOL Programs, Unix Scripting and Attunity.
• Reduced the load time of the Data Warehouse 6+ hours by changing the way the data is acquired on the VMS operating system.
• Automated the Month End Data Warehouse load reconciliation to reduce manual processes and reduce the time to release the Data Warehouse to the business.
• Reduced departmental disk space by removing redundant information.
• Converted Oracle Transparent Gateway pull from VMS to Attunity.

Confidential, Philadelphia, PA

SENIOR DEVELOPER

Responsibilities:

• Converted various manual and tedious functions into an automated system comprised of an indexed table to determine the date and time of execution.
• Converted various lender data input from tape to FTP. This saved the time of sending tapes back and forth and by using PGP it made the transfer of the data secure.

Confidential, Princeton, NJ

CLINICAL TRIAL LOTUS NOTES ADMIN

Responsibilities:

• Managed the Lotus Notes servers that contained patient responses to drug testing for major drug companies. Patients called into our IVR and the data was placed on the Lotus Notes servers. I worked with the drug companies to synchronize their servers with our servers so that the information was transmitted to them daily. Was responsible for all aspects of the Lotus Notes servers including software maintenance.

Confidential, Hightstown, NJ

SENIOR SYSTEMS PROGRAMMER

Responsibilities:

• Responsible for the installation/modification of Systems Software on an IBM Mainframe. In addition to maintenance of the MVS/JES2 operating system, some of the other products maintained were Computer Associates products CA1, CA7, and CA11. Also worked closely with the CICS/DB2 team and VSAM team to maintain proper system performance.