EXECUTIVE SUMMARY:

• 15+ years as Datastage Integrator providing interface solutions between SAP and diverse systems as Databases as Oracle and Informix, SFT servers, etcetera; also including support for fix errors on productions systems and developing interfaces from design, test, phases to implement on production systems
• 12 year of experience for support and design of interfaces and process for XI/PI process and interfaces
• 6 years of experiences as support lead for production integration systems

TECHNICAL SKILLS:

Idioms: Spanish as native language, English, Portuguese

Languages: Datastage, XI/P/POI, Informatica, Oracle, design integration process, develop scripts on Windows and Unix systems

Database: Oracle, Informix

OS: Windows, Unix

Other Tools: SQL Developer, ITIL

Methodologies: ITIL

PROFESSIONAL EXPERIENCE:

Confidential

Lead ETL Dev/Admin Integrator, Austin, TX

Responsibilities:

• Develop fix and new interfaces for Mexico integration between SAP and No SAP system for 18 countries on LATAM
• Develop of enhancements to get better performance for 150 Mexico and Caribbean interfaces using Datastage for LATAM
• Develop of enhancements to get better performance for 250 interfaces using SAP XI/PI/PO for LATAM
• Interfaces using IDOCs/Proxy/BAPIs
• Connection with third part using webservices
• Connection with third part using SFTP protocols
• Perform fixes
• Perform enhancements
• Perform activities to improve performance
• Control of documentations
• Develop of interfaces for integration for projects on Pepsico
• Developer activities
• Analysis of requirements for interfaces and blue print
• Develop of 200 interfaces to send information between SAP ECC system and 62 different No - SAP System
• Develop of connections with CAS system using webservices
• Develop of interfaces to adapt and manage XML files
• Develop interfaces using especial SAP Plug in for Datastage
• Develop of customer function modules to include complex transformation on interfaces
• Develop interfaces using standard stages
• Keep updated all documentation for interfaces using ITIL model
• Perform fixes for jobs failing on Datastage
• Perform analysis for adapt interfaces to new business rules
• Perform enfacements to improve performance getting about 50% of reduction on running time
• Ownership to have systems running on last version
• Ownership for relationship with DataStage vendor for get annual licenses
• Manage developers’ team ensuring high quality codes and apply best practices
• Manage all documentation, technical and functional, for about 400 interfaces on LATAM
• Ensure not disruption of interfaces service
• Manage relationship with developers from vendors
• Provide fast response on case of error and disruptions to recover interfaces services
• Manage extend team for ABAP and WorkFlow
• Manage the relationship with final users to ensure quality integration service
• Ensure compliance with SOX controls for interfaces
• Provide continuous monitoring process for proactive response in case of disruption
• Ensure 7x24 support coordinating have always 1 resource to attend incidents
• Provide feedback about performance for internal and external developers for DataSatage and XI
• Manage offshore developers to commit with death lines for projects
• Manage relationship with different support areas on Pepsico
• Ensure full knowledge transfer from external and internal developer to support team for new interface or fixed applied
• Ownership of all objects migrated from Develop and Quality environments to Production environments
• Manage of offshore developers and support team on India and Brazil
• Administrative task for Datastage:
• Create/change/erase users
• Assign roles
• Provide audit controls
• Install patches and upgrades
• Install SAP plug in
• Migration from version 7.5 to version 8.5
• Migration from version 8.5 to version 11.5
• Administration of access to Oracle databases
• Administration of JDBC access
• Administration of schedules
• Administration of SAP system access
• Recover Datastage when fail
• Tuning of Datastage to improve performance by changing the uvodbc.config
• Management of develops and process to move to productions
• Ensure quality code
• Ensure apply best practices
• Ensure apply of institutional policies for naming conventions, file access, security, etc

Programming: Datastage, XI, PI, Informatica

Tools: DataStage 8.5, JAVA, ABAP, SQL, Databases, SFTP, Infosphere Data Integrator, SAP/R3, Word, Power Point, Windows.

Confidential

Integration developer

Responsibilities:

• Provide Support for production interfaces for sales and inventory systems using datastage as main ETL tool
• Resolve issues, problems with users
• Fix errors on delivered systems
• Continuous improvement and enhancements for production systems
• Ensure system ready for delivery sales plan every year
• Support for merchandising buyer for Confidential
• Support for credit area
• Develop of interfaces to load data from sales system to CRM SAP system

Programming: Datastage

Tools: DataStage 8.5, SQL, Databases, SFTP, Word, Power Point, Windows.