SUMMARY:

• Information Technology professional with extensive background in analysis, design, development, testing, implementation and maintenance of data processing systems for medium and large - scale applications.
• Proven success in understanding and implementing systems to meet end-user needs.

TECHNICAL SKILLS:

• Oracle RDBMS and Tools ((PL/SQL, SQL*Plus)
• Teradata RDBMS and Tools (BTEQ, TPT and SQL Assistant)
• SQL Server
• Kalido DIW (Dynamic Information Warehouse)
• Syncsort’s DMExpress
• Informatica
• Unix Shell Scripting
• Windows Batch Scripting
• ERwin Data Modeler
• Microsoft Office (Word, Excel, Powerpoint, Visio)

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Consultant - Technical Architect

• Designed and developed an encryption/decryption module to be used by all Informatica interfaces that require encrypting or decrypting files. An important and critical component of the integration process since Univision provides/consumes data with Personally Identifiable Information (PII) when dealing with external vendors.
• Managed the build phase of integration projects to migrate legacy interfaces into Informatica. This allowed Univision to streamline their integration solution by using Informatica on all interfaces and reducing the number of physical and virtual servers.
• Managed the build phase of Local Media Dashboard project. The integration collects pacing, actuals and estimates information from local media (Radio and Local TV) traffic systems. The information gathered is used in the Local Media Dashboard.
• Designed and developed the integration to bring radio pacing data from Wide Orbit into Kalido DIW when the client replaced Marketron Radio Traffic System. The integration was developed using Informatica.
• Designed and developed the integration for SFDC Upfront project which required extracting deal information from SFDC and loading into a Teradata database for use of Upfront Reporting. The integration was developed using DMExpress.
• Developed the processing of El Rey invoice files generated by Wide Orbit. The invoice files are validated, transformed and loaded into Oracle EBS Interface Tables. The integration was developed using DMExpress.

Confidential, Teaneck, NJ

Integration Services Engineer

• Designed and developed interfaces for the company's Business on Books (BOB). Created interfaces that extract pacing information from different Traffic Systems (Dealmaker, Marketron, OSI, etc.) and load them into Kalido DIW. The integrations were developed using Windows batch scripts and Oracle PL/SQL.
• Designed and developed interfaces for Univision Management's Contribution Margin Cube (CMC). The CMC is used for profit analysis at Network/Program Level. Responsible for building interfaces that extract data from VCI Sales System and load them into Kalido DIW. Integrations were developed using DMExpress, Unix shell scripts, Windows batch scripts and Oracle PL/SQL.
• Supported existing interfaces that extract reloadable and prepaid card data from a SQL Server database and load them into the warehouse. The card account and transaction information are provided by TxVia - a payment technology company. The information loaded in the warehouse is used by Univision Card Services department. Maintained interfaces that were developed using SSIS, Oracle’s PL/SQL, Windows batch scripts and Kalido DIW.

Confidential, Mahwah, NJ

Senior Programmer/Analyst

• Prepared the technical specifications document for interfaces to Warehouse and Store Receipts Modules. This enhanced the monitoring of receipts information flow from different systems. Involved in program development of new batch programs using Unix Shell, SQL*Plus and PL/SQL.
• Improved business user visibility of Wal-Mart Sales and Inventory by designing a process flow for extracting information from Retail Link. Developed modules for validating, processing and loading into JDA ODBMS using Unix Shell and PL/SQL.
• Upgraded Uniface Development Software from version 6 to 8 by coordinating with JDA Support remotely to accomplish the upgrade. Revised all forms with codes that were no longer compatible with Uniface 8.
• Automated the write-off process of closed stores by providing business users a data entry screen and by building procedures that generate write-off transactions using Uniface, Unix Shell and PL/SQL.
• Provided on-call production support for batch jobs that ran after business hours. Has extensive knowledge of all Merchandising System batch jobs. Has the expertise to identify issues on both Unix Shell and PL/SQL scripts and provide solutions to resolve the issues immediately.
• Supported production by providing users with adhoc reports critical for business analysis using SQL*Plus and PL/SQL scripts.

Confidential, New York, NY

Consultant - Programmer/Analyst

• Modified standard Oracle Financials AP reports using Oracle Reports to address the requirements of the users using Oracle Reports.
• Provided a facility to load invoice records into Oracle AP from different sources using SQL*Loader and PL/SQL.
• Prepared detailed analysis and design specifications that were used by developers stationed overseas.
• Monitored and ensured accuracy of data during implementation of AP interface modules on-site.
• Provided business users visibility of data errors and ability to correct the errors by developing error correction screens and inquiry screens using Oracle Forms.
• Provided business users with Interface Processing reports using Oracle Reports.

Confidential

Senior Programmer/Analyst

• Involved in the development and implementation of the initial release of Customer Management System using Oracle Forms, PL/SQL, SQL*Plus and Oracle Reports.
• Managed the Facilities Management System project. Conducted data gathering and analysis. Prepared design and technical specifications. Monitored the development and implementation of the project.

Confidential

Consultant - Programmer/Analyst

• Managed the Hospital Purchasing System and Warehouse Inventory System projects.
• Conducted systems investigation and data gathering for Admitting and Billing System, Hospital Purchasing System, Warehouse Inventory System and Payment and Collection System.
• Prepared analysis, design and program specifications documentation.
• Developed data entry, inquiry and processing screens using SQL*Forms.
• Created reports and developed a program that generates the billing statement using PRO*C.
• Fine-tuned processing modules developed in SQL*Forms and Pro*C, increasing reliability and response time.

Confidential

Programmer/Analyst

• Prepared analysis, design and program specifications for Materials Management System and Integrated Payroll System.
• Developed data entry, processing and inquiry Screens using SQL*Forms.
• Provided interface to ER system that retrieves employee receivables during payroll processing using PL/SQL.
• Provided interface that transmits payroll information to Oracle GL using PL/SQL.
• Created PRO*C scripts for Stock Plan processing, payroll computations, generation of pay slips and reports.
• Created SQL*Loader script to load existing data from the mainframe to oracle prior to production run.
• Created Menu using SQL*Menu.