SUMMARY:

An Information Systems professional with extensive experience in Relational Database (multi - database) development, INFORMATICA (PowerCenter Designer, Workflow Monitor and Workflow manager)/ Oracle ODI /SUNOPSIS data migration, and Applications development.

SKILL:

Business Objects Expert 3 years ago/7

C, Pro-C Intermediate3 years ago/5

Cobol, Pro-Cobol Expert 3 years ago/14

DCL Expert 3 years ago/12

ETL / ELT development Expert Currently used/15+

Flash MX, Action Scripting IntermediateCurrently used/5

Informatica PowerCenter Expert Currently used/9

ORACLE ODI IntermediateCurrently used/2+

Oracle SQL Expert Currently used/20+

PL/SQL Expert Currently used/15+

Sunopsis IntermediateCurrently used/2+

Team Management/Leadership Expert Currently used/28

Teradata Assistant (Queryman) Expert Currently used/15+

Teradata SQL Expert Currently used/20+

Teradata Utilities (BTEQ,MLoad Expert Currently used/20+

UNIX (Korn Shell Scripting) Expert Currently used/15+

WORK EXPERIENCE:

Confidential, Miami, Florida

Responsibilities:

• Manage all facets of the company.
• Confidential is a multifaceted company providing ETL/ELT development, Relational development using Teradata suite, Oracle, Informatica (PowerCenter Designer, Workflow Monitor and Workflow manager), Sunopsis (ODI) for a variety of industries.
• The other side of the business provides "cutting-edge" technology services in Fine Arts, Film/Digital Technology Production & Editing, Website Design/Development, Multimedia Design Presentation

Senior Oracle ODI Lead/ELT/ETL Developer

Confidential, Brooklyn, NY

Responsibilities:

• Oracle ODI Developer assigned to develop a Confidential Datawarehouse.
• Migrate various sources into the new Data Warehouse table(s) via Oracle ODI.
• The migration will provide data to the newly developed BISP front-end application, and the OBI-EE reporting Star Schema.
• Setup Topology Layer (Physical, Logical, Context, Agent)
• Utilized Designer to develop Interfaces, Procedures, Variable (Global/Local)
• Generated necessary Senarios
• Created/Utilized AGENT to execute via UNIX shell
• Utilized ODIToolbox to perform a variety of functions including operational functions
• Created/Modified a series of UNIX shell within the /bin structure as needed
• Created necessary directory structure to facilitate file disposition
• Monitored/Validated Operator production logs

Senior Oracle/Teradata ODI/FDM/Hyperion Developer

Confidential, Cincinnati, OH

Responsibilities:

• Oracle ODI Developer assigned to migrate Oracle/SQL Server data into Teradata via ODI.
• Developed transformation algorithms/expressions to transform source data.
• Setup Topology Layer (Physical, Logical, Context, Agent)
• Utilized Designer to develop Interfaces, Procedures, Variable (Global/Local)
• Generated necessary Senarios
• Created/Utilized AGENT to facilitate batch execution
• Utilized ODIToolbox to perform a variety of functions including operational functions
• Created/Modified a series of UNIX shell within the /bin structure as needed
• Created necessary directory structure to facilitate file disposition
• Monitored/Validated Operator production logs

Informatica/DB2/Teradata Developer

Confidential, Owning Miills, MD

Responsibilities:

• Informatica DB2 developer assigned to maintain existing financial portfolios and realtime exchange systems.
• Developed Informatica mappings to migrate data and reconcile data exceptions.

Oracle SQL/ODI AP Developer

Confidential, Burlington, NJ

Responsibilities:

• Oracle SQL/ODI AP Developer assigned to migrate Confidential AP application from Oracle 10g (host script driven) to 11i (application driven).
• The migration specifically incorporates 8 divisions currently stored in 8 independent schemas (10g) into 1 schema (11i).
• In order to successfully achieve this effort it was necessary to map the independent divisions and develop cross reference tables.
• Developed detailed specifications.
• Unix (Host scripts), SQLLoader scripts, PLSQL scripts, SQL scripts, etc.
• Register them within the Oracle 11i AP system.
• Create a Request set to drive the application.
• Utilized Oracle ODI creating interfaces to map and consolidate sources into a RMS environment.

Teradata/Oracle/Informatica Developer

Confidential, Plano, TX

Responsibilities:

• Devlopment utilizingTeradata utilities BTEQ, MLoad, FastLoad, and Tpump /Oracle/PLSQL/Informatica (PowerCenter Designer, Workflow Monitor and Workflow manager) ETL Developer/B.O.
• Developer - Consultant developer on the Sustainment team tasked with analysis, development, and implementation of processes for Sales & Commissions.
• Ensuring via AUDIT routines, and the monitoring of internet dashboards that orders placed from various point-of-sale systems are matched, and fulfilled.
• Production is driven by a Schedular system called MAESTRO. MAESTRO jobs execute scripts that process, and load input files into Oracle staging tables.
• Informatica (PowerCenter Designer, Workflow Monitor and Workflow manager) workflows transform and populate Teradata table(s).
• Subsequently, processes populate commissions extract table(s) that produce files sent to Confidential (external customers).
• Remedy is used to create and monitor the resolution of production issues. B.O. reports are produced for marketing and sales.

Teradata ETL Developer/Business Analyst

Confidential, Silver Springs, MD

Responsibilities:

• Teradata utilities BTEQ, MLoad, FastLoad, and Tpump /Informatica (PowerCenter Designer, Workflow Monitor and Workflow manager) ETL Developer - Consultant developer on a team tasked with Confidential data integration, ETL development, testing, deployment, and business unit integration from Teradata into SQL Server.
• Utilize SQLServer2005 Management Studio for BAT files execution of FastExport Scripts.
• Developed FastExport scripts and OLELoads for table transfers from Teradata to SQLServer.
• The position developed more as a Teradata Architect position. Proposed Teradata based solutions to address data transfers

Confidential, Winston-Salem, NC

Teradata/Informatica ETL Developer

Responsibilities:

• ETL development, testing, deployment, and business unit integration from SQL Server, DB2 into Teradata. Utilize Informatica (PowerCenter Designer, Workflow Monitor and Workflow manager) integration development tool to load data from various source systems, including flat-files. Perform testing, and optimizing of ETL (Extract, Transformation, Load) scripts. BTEQ scripts were written to create index and table level statistics.
• Audit & Error table checking routines were written via UNIX/BTEQ scripts.
• Developed Informatica (PowerCenter Designer, Workflow Monitor and Workflow manager) mappings/workflows/etc. utilizing PowerCenter 7.13/8.1 to drive varying data sources into production.
• As a part of development created associated repositories, source to target mappings/mapplets, workflows, and transformations.
• Utilize TIDAL as the enterprise scheduler.
• Developed Unix Korn Shell scripts to drive Teradata utilities BTEQ scripts. Unix scripts were also developed to execute data validation routines.
• These data validation routines were written to ensure data accuracy.• Validated, converted, and transformed flat files.

Teradata ETL Developer

Confidential, Birmingham, Alabama

Responsibilities:

• Developed utilizing Teradata utilities BTEQ, MLoad, FastLoad, Tpump, Teradata SQL queries to obtain preliminary counts for promotional campaigns.
• Utilize Teradata utilities to create outputs and load inputs to the system.
• Generate lead lists for promotion campaigns and deliver these leads to vendors.
• Load and analyze promotion response data.
• Transfer promotion-related data between platforms utilizing various mediums (including Informatica).
• Execute queries that analyze promotion results; deliver these results to clients.
• Participate in the requirement gathering/development process with business clients where they will be expected to contribute efficient, innovative solutions to meet the business needs.
• Participate in design and development activities in Visual Studio, Teradata, UNIX, and mainframe environments.

Teradata ETL Developer

Confidential

Responsibilities:

• Migrate Oracle Stored procedures to Teradata. Analyze & translate Oracle SQL/PLSQL as well as Oracle stored procedures into Teradata SQL preserving the tone and meaning of the original code.
• Developed applications utilizing Teradata utilities BTEQ, MLoad, FastLoad, and Tpump.
• Create & Modify existing Unix scripts to per new migration requirements.
• Create necessary test/production tables to support the migration. Perform testing & validate results.

Senior Teradata (ETL/ELT) Database Analyst/Developer - Consultant

Confidential, Salt Lake City, Utah

Responsibilities:

• Senior developer on a team tasked with Confidential, ELT development, testing, deployment, and business unit integration from Oracle to Teradata.
• Utilized SUNOPSIS, an ELT integration tool. Senarios are created that execute interfaces that extract, and load Oracle data into Teradata staging tables.
• The transformation process occurs primarily on the Teradata system into production tables for reporting. Utilized Teradata utilities BTEQ, MLoad, FastLoad, and Tpump development tool is utilized in the performance of interim testing, and optimizing of transformations. BTEQ scripts were written to populate associated relational tables.
• Joined the SUNOPSIS team due to my extensive data integration experience with Informatica (PowerCenter Designer, Workflow Monitor and Workflow manager).
• Developed SUNOPSIS interfaces/scenarios to drive the sourcing of data from an Oracle (Oracle SQL/PLSQL) platform into Teradata.
• Assisted in setting up the development topology and database configuration (context structure) in SUNOPSIS.
• The development context structure synchronizes source to target datastores.nt context structure synchronizes source to target datastores.