Engineer Data

Curriculum Vitae – Page *

Alejandro Ramos

Nationality: Argentine

ID: 31492262

Date of Birth: March 3, 1985

Age: 33 years

E-mail: *******@*****.***

Skype: alex.ora.3385

Phone: +54911 – 3465-3385

Visa - Expiration Date: July 2023- Type: B1/B2 - Country: EEUU Executive Summary

Information Technology engineer with international experience. Alejandro have over 13 years of work experience in different companies in the IT Sector always dedicated to the delivery of services, the last 7 at executive level responsible for areas of system development, implementation and support, serving clients from different business areas: Financial, Manufacturing, Consumer, Government, Transportation and Telecommunications; in Argentina, Chile, Uruguay, Brazil, EEUU and abroad.

Designer, builder and manager of Big Data infrastructures

A collaborative engineering professional with substantial experience designing and executing solutions for complex business problems involving large scale data warehousing, real-time analytics and reporting solutions. Known for using the right tools when and where they make sense and creating an intuitive architecture that helps organizations effectively analyze and process terabytes of structured and unstructured data.

Databases and Tools: MySQL, MS SQL Server, Oracle, DB2, NoSQL: HBase, SAP HANA, HDFS, Cassandra, MongoDB, CouchDB, Vertica, Greenplum, Pentaho and Teradata.

Hive, Pig and Hadoop Streaming, MapReduce, R, SPSS, SAS, Python, MATLAB, CUDA Dev Nvidia.

TECHNICAL SKILLS SUMMARY

Operating Systems: Windows, Linux and UNIX.

Programming Languages: Oracle PL/SQL, Hyperion Oracle, R, .NET, Java*, HTML*, TSQL Microsoft, Python and Data science libraries: Tensorflow, Scipy, etc .

Databases: Oracle, DB2, MongoDB, MS SQL Server, MS Access, Oracle, MySQL, PostgreSQL, Progress. Hadoop: Hbase, Cassandra, etc.

Applications: TOAD, Erwin, Star Team, Remedy, MS Office, MS Project, MS Sharepoint, Visio, Oracle Financials*, Oracle PeopleSoft*, Oracle JDEdwards*,SQL Server Management Curriculum Vitae – Page 2

Studio, Analysis Services, Reporting Services, Oracle Workbench, Oracle RMAN, Oracle DataGuard, SQLPLUS, Oracle SQL Developer. Oracle Exadata Machine.

Hyperion, Weblogic, OBI, ODI, OAS. Exalogic,EBS,Golden Gate.

Cloud: Verizon cloud; Amazon AWS: S3, EC2, EBS,RDS; Terremark DC.; Windows Azure; IBM SoftLayer; Oracle Cloud: SAAS, PAAS, IAAS; IBM Bluemix. Google Cloud.

Hadoop distriutions: Cloudera, Apache Hadoop, MapR. Main Tools: Hive, Pig and Hadoop Streaming, MapReduce, R, SPSS, SAS, Python, MATLAB, CUDA Dev Nvidia.

Cloud: AWS EC2, s3, ECS. Docker, Ansible, Terraform. Puppet.

Linux: Wide variety of distributions as internet servers, file server etc, also programmer of base applications for user land and kernel. Advanced use of Cryptography in protocols

Information Security and secure programming.

EDUCATION

Bachelor in Computer Science: Universidad Tecnologica Nacional, Buenos aires 2006- 2011

Electrical Technician Engineer: Luis A. Huergo. Buenos Aires 2000-2005

Master in Computer Science: Universidad Abierta Interamericana. Buenos Aires 2013-2015.

M.S. in Statistics: Stanford University of California: Data Science 2017-2018. CERTIFICATIONS AND CONTINUING EDUCATION

GSMS, Quality Assurance, ITIL, CMMi, ISO – 9000 Gilbarco / IBM. 2006

Financial Industry Training Gilbarco. 2007

Microsoft SQL Server MCDBA: Educacion IT BA. 2007

MySQL DBA: Educacion IT BA. 2008

ORACLE DBA: Educacion IT BA - Proydesa Institute. 2010

Big Data: Hadoop Oracle Certified (Oracle 2017)

Linux Administrator: Educacion IT BA. 2010

Cloud Computing : ITBA. 2014

Wallstreet Institute: Advanced Language English. Advanced Technical English. 2001-2016

PMP: Educacion IT BA. 2015

SCRUM MASTER: UTN BA. 2016

GCP: Google Certified Professional Cloud Architect 2016.

AWS: AWS Certified Solution Architect – Professional 2015.

AWS: AWS Certified DevOps Engineer – Professional 2018. Professional Experience

Chevron

Data Scientist

2017- present

Builder of Power BI and Qlik View report from heterogeneous data sources.

Mentoring of Data Science courses for internal employees. Curriculum Vitae – Page 3

Creation Machine learning algorithms for reports and recommendation systems.

Microsoft Azure architecture design for data stores and data lakes and Hybrid stores from on premises data stores.

Currently using machine learning with python on azure and Anaconda tool for data visualization reports such as Power BI, Qlik View and Spotfire.

The main thing here is to make use of "What if" for predictive reports and dynamics dashboards reports.

Clouds: AWS, Azure and GCP.

Oracle

Big Data Engineer Cloud Architect

2015- 2017

By using the Oracle Big Data Appliance, I have created tons of reports with python and SciPy, I have also created Machine learning algorithms for cases of study on “What if” forecast dashboards.

Senior Principal Advanced Data Engineer for customer DIRECTV.

Reviews customer incidents to ascertain cause, impact to the customer environment, remediation activities and identify continues service improvements.

Collects, creates, and provides regular reporting to the customer describing service results, value add, recommendations, and issue resolution.

Works with the customer and internal Oracle team to ensure stability of connectivity between the customer data center and Oracle NOC.

Monitors and tunes the system to achieve optimum performance levels in standalone and multi- tiered environments.

Conducts system analysis, configuration management and develops improvements for system software performance, availability and reliability.

Perform Incident resolution, Problem Determination and Root Cause Analysis in accordance with Service Level Agreements.

Designs, develops, recommends and implements new or revised system software, utilities and automated processes as necessary.

Provides technical expertise for system Transitions, Migrations and Consolidations.

Comprehensive troubleshooting skills

Outstanding written and verbal communication skills

Oracle Cloud.

Tools: Hive, Pig and Hadoop Streaming, MapReduce, R, SPSS, SAS, Weka, MATLAB.

Designed a large data warehouse using star schema, flow-flake. View my tips on SlideShare (insert link)

Designed and developed Big Data analytics platform for processing customer viewing preferences and social media comments using Java, Hadoop, Hive and Pig.

Integrated Hadoop into traditional ETL, accelerating the extraction, transformation, and loading of massive structured and unstructured data.

Loaded the aggregate data into a relational database for reporting, dash boarding and ad-hoc analyses, which revealed ways to lower operating costs and offset the rising cost of programming.

Curriculum Vitae – Page 4

IBM

Data Lead Sr.

2014-2015

Data leader at IBM with a team of 12 DBAs from EEUU, India, Brazil, China and Egypt.

We are responsible of Operation and Support of corporate financial applications for E-pricer Project at IBM.

Production support readiness. Implement work and quality processes, Agile engineering methodologies and processes for Production Support services.

Manage financial, material and human resources. Request resources and ensure they are in a timely manner.

Ensure and maintain the daily operations of financial systems, meeting defined Service Levels Agreements.

Collaboration with groups along all the organizations, to attend services request or resolve problems.

Validate, negotiate and authorize complex and critical service requests.

Continuous service status communication with the client at executive levels.

Initial implementation of work processes; ITIL engineering methodologies and processes for Maintenance, Requirement definition, Analysis and Design, Quality Assurance, Testing and Application Implementation. Additionally, configuration management and change control process.

Assist the team members to ensure the proper implementation of internal methodology.

Provide quality assurance for the services requested; Review functional specifications, technical specifications, unit test and handover. Ensure compliance with local and global standards into IBM standard.

Create strategies and solutions to improve the daily operation.

Consistently reduced operating costs.

Support definition of new solutions and business proposals. Support to Projects Estimating.

Consolidate financial information for the collection of HP services to customer. Main achievements:

I performed the transition of IT services from IBM India to IBM local IT team. A smooth transition was achieved without interruptions while maintaining service levels expected by the client.

I started the implementation of IBM Agile processes and working methods on the applications area. This will have established a standard work process under best practices in IT industry.

I assured the correct day to day operation of IBM applications fulfilling SLAs. Environment

DB2 10

Oracle Cluster 12c

AIX Unix from IBM

IBM Mainframe

Curriculum Vitae – Page 5

IBM power systems

Java

Comafi Bank Argentina

Data Manager

2013-2014

IT DBA Manager for Comafi Bank, responsible of Operation and Support of corporate financial applications for Comafi. Oracle RAC Implementing and tuning. Microsoft Dynamics AX ERP with SQL Server 2012.

Lead the transition of IT services from IBM to Comafi IT Team.

Production support readiness. Implement work and quality processes, Bank engineering methodologies and processes for Production Support services.

Manage financial, material and human resources. Request resources and ensure they are in a timely manner. Project budgeting and planning control.

Ensure and maintain the daily operations of financial systems, meeting defined Service Levels Agreements.

Collaboration with groups along all the organizations, to attend services request or resolve problems. Point of contact with different groups for the Argentina application side.

Validate, negotiate and authorize complex and critical service requests.

Continuous service status communication with the client at executive levels.

Initial implementation of work processes; Bank engineering methodologies and processes for Maintenance, Requirement definition, Analysis and Design, Quality Assurance, Testing and Application Implementation. Additionally, configuration management and change control process.

Assist the team members to ensure the proper implementation of internal methodology.

Provide quality assurance for the services requested; Review functional specifications, technical specifications, unit test and handover. Ensure compliance with local and global standards into Bank standard.

Microsoft Dynamics AX owner. Monitor and maintain Dynamics controls for the IT Production Support area.

Create strategies and solutions to improve the daily operation.

Develop and maintain up-to-date IT contingency plans for Oracle database systems and SQL Server systems (Dynamics AX).

Consistently reduced operating costs.

Support definition of new solutions and business proposals. Support to Projects Estimating.

Consolidate financial information for the collection of HP services to customer.

Installed and configured Apache Hadoop, Hive and Pig environment on the prototype server.

Configured SQL database to store Hive metadata.

Loaded unstructured data into Hadoop File System (HDFS).

Created ETL jobs to load Twitter JSON data and server data into MongoDB and transported MongoDB into the Data Warehouse.

Created reports and dashboards using structured and unstructured data. Curriculum Vitae – Page 6

Main achievements:

I performed the transition of IT services from IBM to Comafi local IT team. A smooth transition was achieved without interruptions while maintaining service levels expected by the client.

I started the implementation of Bank standard processes and working methods on the applications area.

I assured the correct day to day operation of Comafi Bank applications fulfilling SLAs. Environment

Oracle Database 11g Cluster

SQL Server database 2012r2

Microsoft Dynamics AX

Intranet Integrity / Treasury

Control-M

Microsoft Sharepoint

Centos Linux

Java

Windows Server 2012

SUN Solaris

Hadoop

Mongo DB

RENATEA

Cloud Architect and Data SR

2012-2013

Head of production support area for PostgreSQL, SQL Server applications. Responsible of Operation and Production Support and Upgrades.

Production support readiness. Implement work and quality processes, ITIL engineering methodologies and processes for Production Support services.

Ensure and maintain the daily operations of applications under my scope, meeting defined Service Levels Agreements.

Validate, negotiate and authorize complex and critical service requests.

Initial implementation of work processes: ITIL engineering methodologies and processes for Maintenance, Requirement definition, Analysis and Design, Quality

Responsible for the development of Database projects. Environment

PostgreSQL

SQL Server 2008r2

Windows Server 2005-2008

Linux Debian 5

Axeso5

Curriculum Vitae – Page 7

Cloud Architect

2012-2013

Head of production support area for MySQL, MongoDB, SQL Server applications. Responsible of Operation and Production Support.

Lead the transition of IT services from Physical servers systems to Cloud systems: Amazon Cloud Services, Verizon Cloud Services.

Production support readiness. Implement work and quality processes, ITIL engineering methodologies and processes for Production Support services.

Ensure and maintain the daily operations of applications under my scope, meeting defined Service Levels Agreements.

Manage financial, material and human resources. Request resources and ensure they are in a timely manner. Project budgeting and planning control.

Staff management and control for 15+ DBA and Developers consultants from Argentina.

Validate, negotiate and authorize complex and critical service requests.

Initial implementation of work processes: ITIL engineering methodologies and processes for Maintenance, Requirement definition, Analysis and Design, Quality Assurance, Testing and Application Implementation. Additionally, Configuration Management and Incident processes.

Responsible for the development of Database projects. Project Implementation, monitoring and status review at the managerial level.

Assist the PMs, leaders, team members and 3rd party vendors to ensure the proper implementation of internal services methodology and processes.

Provide quality assurance for the services requested; Review functional specifications, technical specifications, unit test and handover. Ensure compliance with local and global standards into ITIL.

Coordinate and support development projects executed by 3rd party vendors to ensure compliance with contract requirements and standards defined between ITIL process.

Support definition of new solutions and business proposals. Support to Projects Estimating. Environment

MYSQL 5

SQL Server 2008

Amazon Cloud Systems

Verizon Cloud Systems

Windows Server

Java

Centos Linux

Philips Morris International

DBA SR for GLS Project

2011-2012

Responsible for the implementation and management of GLS

Management of Production Support & New Development services for ERPs.

Implementation of models of global work for projects with Latin America and United States. Assist the team members to ensure the proper implementation of internal services methodology. Curriculum Vitae – Page 8

Support selling the service of development, maintenance and support on ERPs with local clients and abroad. Enterprise Application Management / EAM portfolio architect supporting new business proposals. Support on project estimation for EAM services.

Support projects in work migration from remote sites in USA, Brazil, Switzerland, Canada, Philippine to Argentina.

Collaboration with DBAs, Developers, QAs and Functionals groups from USA, Brazil, Switzerland, Canada, Philippine and India to attend services requests or resolve project technical problems. Point of contact with different groups.

Project staffing and teams integration. Responsible of selection of experienced consultants with high skills and proficiencies. Management of relationships with vendors and internal resourcing areas to obtain resources.

Management of the Oracle and SQL Server databases. Environment

Oracle Database

Oracle Applications

SQL Server

JDEdwards (OW & WS)

Celistics Holding

DBA and Technical Leader

2010-2011

Responsible for Development and Production Support areas for Business Intelligence with technologies such as: SQL Server, MySQL, Oracle, Microsoft Dynamics AX.

Ensure and maintain the daily operations of Microsoft Dynamics applications in production environments.

Technical Leader, OLAP Database designer and developer.

Responsible of the definition and design of Microsoft Dynamics application solutions for user’s requirements, based on OLAP and DWH concepts. Production of solution designs and optimization.

Implementation of work processes: ITIL engineering methodologies and processes for Maintenance and new Development, Requirement Definition, Analysis and Design, Production, Quality Assurance, Testing, Implementation and Installation.

Definition of new solutions and business proposals. Projects Estimating.

Execute Benchmarking and product evaluation: Microsoft Dynamics, Oracle, SAP R3, Hyperion products (Analyzer, Reports, Balance Score Card) Environment

Hyperion Oracle

Microsoft Dynamics Brio - Hyperion Intelligence

MYSQL

MS Access

MS SQL Server

UNIX, W2K, WXP, WNT

Curriculum Vitae – Page 9

Gilbarco Latin America SRL

DBA Lead Consultant

2005-2010

Responsible for Development for Business Intelligence applications for the top executives of the main Gas and Oil companies in Latinamerica (Exon mobile, Terpel, YPF, Shell, Petrobras).

Technical Leader, OLAP designer and developer.

Development of the card Serviclub rewards, a software solution that rewards customers for their buys.

Development of the KPI – Key Performance Indicators for Gilbarco. Environment

SQL Server, MySQL, Oracle

Unix and Linux

Windows 95, Windows NT, W2K

Teletech Argentina

Developer Jr.

2004-2005

Team member of the development project Intranet and HR Systems at Teletech, attending core business functions and areas like sales, distribution, manufacturing, inventory.

System Development: Definition, Analysis, Design, Production, Optimization, Implementation and Installation using Teletech corporate methodologies.

Object oriented programming using T-SQL and C++.

Development of object classes and code libraries, design and development standards for SQL Server.

Implementation of Configuration Management concepts, Testing & Quality controls. Environment

Windows 95

MS DOS

SQL DBMS

Windows Servers

Contact this candidate