SUMMARY OF EXPERIENCE

TECHNICAL EXPERIENCE

• Microsoft Technologies:
• Microsoft SQL Server Ver. 7 through 2012, SSIS, SSRS, SSAS, Visual Basic, VBScript, Microsoft Project, PowerShell
• RDBMS's:
• SQL Server 7.0 through SQL Server 2012, MySQL, Oracle 7-11G, Informix, Teradata
• Operating Systems:
• Windows NT/2000/2003/2008, UNIX Solaris, HP-UX , Windows 7
• Source Control:
• VSS
• Others:
• UML, Toad, Informatica Power Center, Datastage, Pentaho BI, Genio, Erwin

PROFESSIONAL EXPERIENCE

Confidential

• Migration from MSSQL 2008-R2 to Oracle 11-g.
• Responsible for migrating database objects Stored procedures from TSQL to PL-SQL, testing and reviewing the results obtained in both RDBMS are exactly the same.
• Making Test cases for Data quality asurance.

Confidential

• Working with Microsoft partner monitoring and troubleshooting windows azure installation for a customer with a big volume of information 300 GB per week .
• Administration of an on premise server with MSSQL 2012.
• Generation of SSIS processes to load data between both environments.
• Manage of backup of the information, use of SSRS to get information about the variation of volume monthly and weekly.

Confidential

• Generating ETL process with Pentaho BI for migrating data between the new system and the changed to have historical information.
• Making reports to confirm the information from the source and target systems to guarantee the correct flow of the information.
• Responsible for design, scheduling, and migration from other system for the medical appointments.

Confidential

• Technical support to DWH production environment.
• Reviewing and solving problems with the daily load process 24X7 .
• Analysis and generation of ETL processes of new requirements or changes to the existents.
• Giving recommendations or making the necessary changes to the current processes to improve the response time in the global information load.
• Making data cleansing and detecting risks in reliability of the stored information with random reviews looking for errors in consistency.

Confidential

• Technical support to CRM production environment.
• Data cleansing of the information retrieved from internet.
• Analysis of the information and generation of Queries solving the targets for specific campaigns of the marketing area.
• Analysis of the results of the campaign making more cleansing to the information.
• SSIS process for updating information from main office.
• Analyze and change of data structure for lack or incomplete information.

Confidential

• Review and documentation of existent ETL process.
• Review of the new requirements.
• Creation of new process including new requirements.
• Test of results in both versions.
• Documentation of process and liberation forms.

Confidential

• Analysis of requirements of the DWH cubes.
• Made changes.
• Creation of new process including new requirements.
• Test of results in both versions.
• Documentation of process and liberation forms.

Confidential

• Responsible for Database support, troubleshooting, planning and migration. Resource planning and coordination for application migrations with project managers, application and web app teams. Project involved guidance and adherence to standardized procedures for planned data center consolidation for worldwide centers using in-house corporate and third party applications based on SQL 7 in upgrade project to SQL 2000, 2005 and 2008 in different periods of time.
• Implementing normalization to database object naming conventions and standards for programming.
• Monitoring of database size and disk space in Production, Staging Development environments
• Performed installation of SQL Enterprise on all the environments to have standardized installations.
• Performed installation of SQL Server Service Packs.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers.
• Creation and scheduling of Maintenance plans database and log backups and cleanups , DTS to SISS package conversions. Business Intelligence package design. Created tables and performed data imports and restores for successful migration. Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights.
• Good Knowledge of using SSRS SQL Server Reporting Services .
• Performed Production support and on Call duties.
• Created monitoring scripts to alert for production issues.

Confidential

• Maintenance and creation of requirements for life insurance area.
• Maintenance reports with oracle Reports.
• Maintenance applications with forms 3.0.
• Maintenance of ux shell scripting for data import and export.

Confidential

• Maintenance of KPI indicators in vertical application to banking business.
• Maintenance reports with Crystal Reports.
• Maintenance applications with VB 6.0.
• Maintenance of ux shell scripting for data import and export on oracle database.

Confidential

• Maintenance of call control application for a banking company.
• Maintenance reports with Crystal Reports.
• Maintenance applications with VB 6.0.
• Maintenance of ux shell scripting for data import and export on Oracle database.

Confidential

• Acquisition of equipment and manage of providers for maintenance and guaranties issues.
• Administration of Novell LAN.

Confidential

• Acquisition of equipment and manage of providers for maintenance and guaranties issues.
• Administration of Novell LAN.

Confidential

• Project to manage the maintenance process for construction machinery.
• Analysis and design of the database.
• Analysis and design of the application
• Implementation
• Training
• Documentation

Confidential

• Participating in every process of software life with different clients and RDBMS and ISAM rechnologies.
• Analysis and design of the databases.
• Analysis and design of the application
• Testing
• Training
• Documentation