Pedro Oroz

SUMMARY OF EXPERIENCE

* ***** ** ** ********* with various RDBMS(Teradata, MSSQL, Informix, DB2,Oracle) and ETL Tools(Hummingbird Genio, Pentaho, IPC, Datastage) and Customers(Nextel, Samsung, SHCP, Autofin, Compartamos,ISSSTE) giving technical support, creating and maintaining ETL Process and implementing DWH Process and changes or creation of objects in the data model.

8+ years as DBA administering databases with sql server versions between 7-2012 Azure included on cloud computing, on premise and cluster installations, managing backup and restore, High Availability and Disaster Recovery processes. Manage of trouble shooting, checking performance of the servers, giving performance and tuning to the objects of the DB, managing users and permissions to the DB and automating repetitive tasks, design and improvement of data models, implementing and recommending the use of best practices for queries and database objects.

8 years designing, building and implementing and/or maintaining systems like legal retrieval, assurance, web pages, banking, calls measurement, payroll, sales from analysis and design programming and implementation process of the projects.

5 year as PL-SQL Developer, with oracle projects with systems like assurance, calls duration, payroll, and database migration.

1 year as Web Master, giving technical support in Linux, implementing VPN

TECHNICAL EXPERIENCE

Microsoft Technologies:

Microsoft SQL Server Ver. 7 through 2016, SSIS, SSRS, SSAS, Visual Basic, VBScript, Microsoft Project, PowerShell

RDBMS’s:

SQL Server 7.0 through SQL Server 2014, MySQL, Oracle 7-11G, Informix, Teradata

Operating Systems:

Windows Server,NT/2000/2003/2008, UNIX(Solaris, HP-UX),Linux, Windows 7

Source Control:

VSS, GitHub,TFS

Others:

UML, Toad, Informatica Power Center, Datastage, Pentaho BI, Genio, Erwin, Jira, DBSchema

EDUCATION

Bachelor’s Degree, in Computer Area- Universidad del Valle de México, MX 20012-2015

COURSES

MCDBA: 2274,2275,2277C,2278,2071,2073,2072,2779,2780

Pentaho: Training boot camp

DataStage: Basics

Informatica Power Center: Level 1,2

Teradata: Basics

MCP Certificated

70-461 Querying MSSQL 2012/2014

70-462 Administering MSSQL 2012/2014

Contact Information

Cellphone +521**********

Phone +525*********

Mail ac4jmm@r.postjobfree.com

PROFESSIONAL EXPERIENCE

May’17 – Current BI MSSQL

Vantis-Walmart Mexico City

Generating SSAS,SSIS and SSRS, improve performance for existing processes.

Feb’17 – May’2017 BI MSSQL

An Extend-BestDay Cancun Q ROO

Generating SSIS and SSRS, improve the performance for existing processes.

Aug’16 – Nov’2016 DBA MSSQL

Hotel Connections Mexico,D.F.

Administering databases in MSSQL 2012 AWS and on premise.

Generating SSIS and SSRS, improve the performance for existing processes and troubleshooting the Database Servers.

Dic’15 – Jul’2016 Sql Developer Sr.

Globant – Credit suisse Mexico,D.F.

Reviewing and improving the database model for BI processes.

Generating SSIS and SSRS, improve the performance for existing processes and troubleshooting the Database Servers.

Jul’15 – Oct’2015 DBA-BI MSSQL

PortoMX – J&J Mexico,D.F.

Administering databases in MSSQL 2012 AWS and on premise.

Generating SSIS and SSRS, improve the performance for existing processes and troubleshooting the Database Servers.

Sep’14 – Jun2015 DBA MSSQL

Infomedia – GNP Mexico,D.F.

Administering databases in MSSQL Server from 6.5 to 2012 Versions.

Installing the RDBMS clusters included and giving technical support to productive servers, establishing Backup and maintenance plans to the servers.

Apr’14 – Ago’14 Senior PL-SQL

Sullexis – PTC Houston, TX

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.

May ’13 – Dec ’13 DBA-MSSQL

Microsoft-Extend Solutions México, D.F.

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.

Oct ’12 –Apr ‘13 ETL-Developer

ISSSTE – Porto MX México, DF

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.

Mar ‘11 – Sep’12 Technical Support DWH

Nextel- HP México, D.F.

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.

Nov ‘10 – Feb’11 Technical Support CRM

Samsung- México, D.F.

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.

Creating reports to Sales force about measures of results for every division

Making cubes of product sales and vendors by region

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.

May ‘10 – Nov’10 ETL Developer

Axa Seguros- México, D.F.

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.

Getting information about sales area and sending the files to get measures on different departments.

Feb ‘10 – May’10 BI Analist-ETL Developer

S.H.C.P.- México, D.F.

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.

Feb ‘05 – Feb’10 DBA MSSQL

Financiera Compartamos- México, D.F.

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.

Making KPI to validate the target compliment of the sales force and marketing area and making dashboard for monthly meeting.

Nov ‘02 – Jan’05 PL-SQL Developer

Mapfre Tepeyac- México, D.F.

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.

Apr ‘00 – Oct ’02 Consultant

Banamex- México, D.F.

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.

Apr 1999 – mar ’00 Consultant

Serfin- México, D.F.

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.

Apr 1997 – mar 1999 Network Administrator

Cadbury Beverages- México, D.F.

Acquisition of equipment and manage of providers for maintenance and guaranties issues.

Administration of Novell LAN.

Apr 1995 – mar 1997 System Analyst

Grupo ICA- México, D.F.

Project to manage the maintenance process for construction machinery.

Analysis and design of the database.

Analysis and design of the application

Implementation

Training

Documentation

Apr 1988 – mar 1995 Various

Asesoria y Sistemas de Computo- México, D.F.

Participating in every process of software life with different clients and RDBMS and ISAM technologies.

Analysis and design of the databases.

Analysis and design of the application

Testing

Training

Documentation

Contact this candidate