LEON OROZCO

B.S. In Computer Systems Engineering

***** ***** ****** **. ****** Tx, 76244 USA

Mobile. 817-***-**** E-mail: addaea@r.postjobfree.com

Professional Summary

●Over 15+ years of experience working for national and multi-country organizations, focusing on manage and leading projects that covers iot, telematic, financial, accounting, automotive manufacturing applications and other business solutions.

●Strong experience providing architect and design solutions. Hand on designing solutions and architecting infrastructure implementations.

●Experience on amazon web services.

●Experience as a software engineer leading, coordinating, designing and programming systems, working in a variety of enterprises in different languages and platforms.

●Customer F2F experience with strong experience architecting customer solutions, serving as technical lead for all develop and connectivity solutions between internal users, external trading partners, external communications network providers and customers, responsible for advanced troubleshooting with new and existing trading partners and customers to solve development and connectivity issues.

●Works directly with VPs, directors and managers to understand and prioritize opportunities where data and analytical insights can provide significant business intelligence solutions. Leading and helping the team to developing complex queries, unix/Linux shell scripting and coding solutions.

●Provide E2E professional solutions with strong use of the technology custom fitting the ETL solutions for BI, EDI electronic data interchange, multiples SQL databases like Oracle, Sybase, DB2 and others sources.

●Data modeling to understand, interpret and implement data warehouse requirements.

●Experience as a developer maintain and support the enterprise data warehouse systems and corresponding data mart.

●Strong experience write SQL, store procedures, PL/SQL code, shell scripting to extract, transform and load data from multiple sources and databases aligned with customer/user specifications.

●Work with various levels of software developers foreign and national practice agile and waterfall methodology.

●Experience E2E with virtualization VMware vSphere System Administrator: detection of VMware issues, planning, performance monitoring and maintenance to ensure high availability.

●Experience designing solution on premise and cloud solutions. (storage, email, databases, IOT, web applications, IOT service execution APIs ). AWS, Azure & google cloud.

Professional Experience

Sirius XM Irving, TX (May 2016 – Jan 2020)

Sirius XM Connected Vehicle Services

Senior Information Systems Engineer

Integration Systems Engineer.

●Responsible of architect designs. Includes back office, Infrastructure, network connectivity, Datawarehouse solutions, middleware, encryption, SSH, certificates, AOTA, FOTA, APIs development, Web portal, LDAP, SSO, SAML, OIDC, OAuth, Mobile Apps and projects. Supporting IOT to OEM Telematics, Connected Vehicle Programs and remote service execution APIs. Worked closed with IDM and IAM team to support multiple authentications and authorizations.

●Customer F2F experience with strong experience architecting customer solutions, serving as technical lead for all develop and connectivity solutions between internal users, external trading partners, external communications network providers and customers, responsible for advanced troubleshooting with new and existing trading partners and customers to solve development and connectivity issues.

●Responsible of Backoffice solutions, including database design, ETL Solution designs, OBIEE new financial, administrative, telematic reports and customer sftp feeds solutions.

●Supporting customers automotive OEM and tier 1 partners (Toyota, Honda, Hyundai, FCA, Denso, Conti, Ficosa, others) in multiples environments. Prove of concept (POC), DEV, SIT, staging and production.

●Responsible of systems requirements specifications (SRS) ensure different teams follow the policies, standards, SRS and guidelines. Practice of Agile methodology.

●Projects: WAM FCA, WAM Nissan, Toyota MY17, Toyota One App, Honda MY17, Honda CPO, Honda MY21, Hyundai migration.

Condumex, Inc., Grand Prairie, Texas (January 2010 – May 2016)

(Multinational tier one automotive industry)

ETL & Software Architect

●Identify new business needs and changes to the current Oracle Financial Data Warehouse

●Responsible for design and implementation of new Oracle Financial Data Warehouse according to requirements

●Integration with Oracle Internet Directory (OID) (LDAP) on SSO with internal multiple systems.

●Exposed to Oracle Identity Management as IDM.

●Provide business intelligence analytics design, and technology to the different levels of the business responsible of data modeling of new ETL requirements.

●E2E solution design for BI software and technical standards and specifications, Coding Oracle PL/SQL packages & store procedures, design new databases and

●customize Oracle Applications

●Designed new protocol interfaces to extract data from different Oracle Apps modules: GL, OE, PO, AP, AR, INV, (general ledger, order entry, purchasing,

●payable, receivables, inventory) and others sources.

●Responsible infrastructure design solution to support all business necessities including Goggle cloud solution, AWS S3, S3 Glacier, data lake with AWS Glue, windows and Unix/Linux Server, Macs, desktop, laptops. responsible of VMware infrastructure architect and VMware’s DR.

●Responsible of the enterprise design of MDM solution. Implemented with Cisco Meraki. Manage corporate mobile devices AOTA & FOTA.

●Design of monitors for BI portal performance, ensure metadata repository is accurate and updated regularly. Perform data load monitoring, analysis and resolution.

Condumex, Inc., Grand Prairie, Texas (December 2000 – January 2010)

(Multinational tier one automotive industry)

Principal Software Engineer

●E2E responsible of architect and design new functionality for data warehouse. Developed in Sybase & Oracle database using PL/SQL, UNIX shell scripting, Toad & SQL Navigator, Sun Solaris, HTML & JavaScript, network infrastructure, virtual Servers, DHCP, DNS, LDAP. VMware platform.

●Responsible of the solution, design and develop of store procedures, UNIX shell scripting to transform and load information from Oracle databases and others into Sybase databases creating data warehouse and performing complex queries and analysis for the BI portal.

●Establish E2E electronic interchange with auto OEM companies Ford, Toyota, GM and tier one automotive industry Delphi Packard, Tyco Electronics USA & Germany, Yazaki, Molex and others companies in USA, European Union and Latin America. Using different protocols and specifications. Oracle & Sybase DB and UNIX shell scripting, Oracle PL/SQL, Oracle Database and Oracle Apps.

●Experience on automation, scripting and windows based applications, tools: AutoIt Script Editor.

Brokerage Firm and Bank Interacciones. Mexico City (July 1996 – December 2000)

Developer Systems Manager

●Designed relational database, construction of client -server applications, use of Oracle Database, Delphi, Crystal Report and Power designer, SQL Navigator.

●Developed the following systems: mutual funds accounting system, Forwards and Futures Financial System (Derivative Market) Application management's decision support system for data warehouse, directive level (custom fit it to the business tools).

●Designed a middleware gateway to process B2B, EDI Electronic Data Interchange between brokerage firm, Stock exchange and Bloomberg over TCP/IP.

●Processed multiple data feeds over protocol TCP/IP, Ethernet, IPX, sockets. (news, facts, stocks operations, etc.)

●Management system of projects.

Technical Summary

Languages and Tools: R, Git/GitHub, ERP Oracle Apps, Progress, Sybase, Oracle Database, PL/SQL, SQL Plus, UNIX shell scripting, SQL Loader, Postfix, Mailman, EDI Gentran Director, FTP, SFTP, (X12, EDIFACT), Pascal/Delphi, HTML, Java, JavaScript, C++, C, Crystal Report, SQL Navigator, Toad, database designer software CASE Studio, ER Diagram tool, Ms Office, Microsoft Visio. Hyper V, VMWare, file encryption pgp & gpg, SSH, SFTP, SSL & TLS, App Dynamics

Platforms: Cloud technologies (Google cloud, Microsoft Azure, AWS), Dell Servers, Sun Solaris, Windows servers, Active Directory (AD), Windows Office, TCP/IP, IPX, Ethernet, security tools (LDAP), Oracle Internet Directory (OID), DHCP, DNS, Cisco and Meraki VPN, switches, Cisco & Meraki routers, remote access, Oracle Linux Server, Red Hat Linux, Progress (Symix).

Education

Bachelor in Computer Systems Engineering

ITESM (in English: Monterrey Institute of Technology and Higher Education) Mex.

Latest Certificates:

●AWS Certified Cloud Practitioner (CLF)

Certification Date Aug 2018 – Aug 2020

License Validation Number XG5ZBJK2CMRQQ7C6

Amazon Web services

●Data Science: R Basics

VALID CERTIFICATE ID ee2e9bb8deec4e06b131fdd355a675f4

Present License Harvard University through edX.

●Data Science: Productivity Tools with R

VALID CERTIFICATE ID 21003d7d3ed142ab84fd308788a08157

Present License Harvard University through edX.

●Data Science: Visualization with R

VALID CERTIFICATE ID 78560a33d60c436e85e33aac5543d0e1

Present License Harvard University through edX.

Contact this candidate