• Analyzed, designed and developed ETL process based in IBM platform InfoSphere DataStage for populating fixed and prepaid telephony inventory model into a Teradata data base technology, for Telefónica Client. • Analyze and develop data models for expanding and adding new features in current implemented Teradata data models. • Tested data consistency and integrity.
• Designed, planned and executed Sybase database migration to Microsoft SQL Server 2012 including data structure adaptation, new procedures, functionalities and existing data. • Designed new data structure based on information gathering and business needs. • Improved stored procedure performance. • Defined tables, indexes and materialized views. • Supported development team with new database developments and requirements. • Elaborated technical database documentation. • Participated in information gathering directly with the client in English language.
• Designed and implemented reliable, scalable and high-performance solutions to meet the service levels associated with the MSSQL database. • Ensured cooperation and communication within the devolvement team. • Recommended data architectures solutions. • Enhanced stored procedure performance.
• Leaded a development team, ensuring compliance with development standards and best practices. • Defined T-SQL development standards. • Tuning and performance queries. • Created database modeling for the Banplus Online migration to its new version under SOA architecture. • Managed Microsoft SQL Server for development environments.
• Designed and developed complexed ETL for a data interface. • Developed basic SSIS package. • Attended to incidents and failures related to the database. • Developed multiples projects and solution in T-SQL.
• Certificated and planned productions deployments. • Leaded a development team, ensuring compliance with the deliverables for each stage of the assigned projects. • Attended development requirements. • Followed up projects and requirements across all its development cycle.
• Participated in information gathering. • Developed multiple financial projects in T-SQL based in COBIS CORP. • Followed up projects and requirements across all its development cycle. • Supported productions deployments.
• Developed COAFE’S intranet web page. • Developed several technical manuals. • Supported productions deployments.