OSCAR RUIZ
WYLIE,TX
Summary
Information Technology Professional with 25+ years of proficiency in Business intelligence and Data Warehousing (DWH), Capacity Planning, Database Administration, Project Management, and Stakeholder Management Deft at constructing triggers, fact tables, user defined functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity. Possess multi-industry exposure including Healthcare, Chemical, Mortgage, Education, Manufacturing and Banking. Strategic developer with proficiency in using ETL methodology for supporting data extraction, transformations and loading processing in a corporate wide ETL solution using SQL & PL-SQL. Strong analytical skills with proficiency at grasping new concepts quickly and utilizing the same in a productive manner. Dexterity in managing software development life cycle (SDLC) including requirement analysis, design, coding, testing, and maintenance phases.
Overview
13
13
years of professional experience
Work History
Vice President; Software Engineer II
Bank of America
Addison, TX
11.2018 - Current
- Manage design, development, testing, and deployment of custom data warehouse systems; define data requirements and design databases to satisfy client business objectives. Enable ETL Development using Microsoft BI Stack 2022, 2019, and 2016. Deliver training to developers during the transition to SQL Server 2019. Engage in migrating SQL Server Jobs to the Autosys environment. Maintain SSIS and SQL objects in Team Foundation Services and SQL Source Control. Accountable for ensuring changes in business requirements into conversion process and base lined to reflect changes to the schedule, and testing processes. Effectuate data governance to ensure data follows policies. Devise strategies for Disaster Recovery Management, including planning and designing servers for back-up and recovery of server / database information.
- Technical Lead for migrating 24 SQL Servers across multiple versions of newer SQL version to comply with Bank Standards. This includes management of all software, disk management, and deployment planning
- Perform managerial duties with Manager is out of the office. This includes all team access requests, approvals for change management, visibility within manger meetings, and all other
- Managed and provisioned NDM, SFTP, and EWS production file transfer processes.
- Support, Mentor, and Guide a team of 5 developers with SSIS, SSRS, and SQL Server Queries
Data Warehouse Developer
Texas Capital Bank
11.2014 - 11.2018
- Carried out ETL Development using Microsoft BI Stack 2017 and 2012. Served as a Subject Matter Expert for various business applications and data source systems. Used the Business Intelligence Markup Language (BIML) to generate SSIS packages from source files to staging databases. Involved in Alteryx software development, database architecture, and TFS project level management. Participated in design reviews and assisted with allocation of functionality to specific system components; developed data models, implemented databases, and wrote stored procedures. Planned project activities including scoping, estimation, tracking, change management, delivery management & post implementation support.
- Spearheaded a team of SSIS developers while working on migrating and normalizing data from the Legacy System to the New Loan Portfolio System, reduced man hours subsequently.
- Ensured on time project delivery while ensuring better quality.
Senior Business Intelligence Developer
RealPage Inc.
07.2013 - 10.2014
- Participated in design sessions for development of ETL logic to meet business requirements for reporting and analytic databases. Managed design and architecture of flat data tables into type one and two fact/dimension tables. Served as FTP/B2B expert using all forms of protocols and various security methods, i.e., key exchange, host key, and encrypt/decryption of files. Designed, deployed, and tuned SSIS ETL solutions to incrementally load Enterprise Data Warehouse and Enterprise Reporting Systems. Designed logical and physical data models, metadata definitions, models, queries, and reports.
- Offered effective reporting solutions to optimize the data delivery process.
- Gained exposure in design, development, and coding of applications to satisfy requirements of one or more user areas.
Senior Consultant – Business Intelligence
Saxony Partners
05.2013 - 07.2013
- Used SSIS, VSS, and SQL Server 2012 to develop, test and authenticate source and destination data tables and related dimensions. Applied SQL Server 2012 enhancement to ETLs to obliterate “Package Configurations” management. Prepared ETL process documents to ensure best practices for later reference. Developed C# RESTful web services connection script tasks. Participated in the design, development and testing of the data components needed to support clients' reporting requirements and to integrate these designs into the overall client data strategy.
- Successfully completed major source to target mapping efforts to maintain project momentum.
- Worked closely with client management to identify/ specify business requirements and processes
Education
High School Diploma -
Sunset High School
Dallas, TX05-1987
No Degree -
Various SQL / Database / IT Technical Courses
Dallas01.2021
Skills
- Microsoft SQL Server
- Data Warehousing
- Business Intelligence
- ETL Development
- Database Administration
- SDLC Process
- Unix Administration / Shell Scripts
- Visual Studio 2022
- Data Modeling
- Project / Time Management
- Disaster Recovery Planning
- B2B Interface Administration
- SSRS / Tableau Reporting
- Jira / Team Foundation Services
- Oracle PL/SQL Developer
- Data/Application Governance
- Resiliency Testing
- People & Process Management
- Rotating On-Call Support
- C#, NET
- Tech Lead – Offshore Resources
- Methodologies: Agile and Waterfall Methodologies
- Technologies: Hive SQL/Azure Blob File Management/Azure Cloud SQL/HD Insight
- IDE: Visual Studio 2022 and 2019
- Platform: Team Foundation Services, Horizon Bit Bucket
- Server: SQL Server 2019/2016/2012 R2 SSIS, Reporting Services 2029, SSIS, Analysis Services, DTS packages, stored procedures and views utilizing Transact-SQL, Sybase SQL
- OS: Oracle 7, 8i, 10g, Sun Solaris
- Programming Languages: Unix Shell Scripting (all flavors of Unix), PowerShell, SFTP Scripting
- Tools: JIRA, Horizon, Kanban, Alteryx, Remedy
- Information Security – Password Vaulting
Additional Experience
- ETL Developer/Database Architecture/Technical Lead, Bank of America, Plano, Texas
- SQL Developer, Concentra Health Services, Addison, Texas
- ETL Developer, Brink’s Home Security, Irving, Texas
- Database Administrator, Radiology Inc., Dallas, Texas
- SQL Developer, Interceramic USA, Garland, Texas
- Business Analyst, Voyager Expanded Learning, Dallas, Texas
- Internet Database Programmer, Bank of America (Contractor - Analysts International), Dallas, Texas
- Reporting Analyst, Vologic, Dallas, Texas
- Programmer, North American Marketing/Logistics Division, Methanex Corporation, Addison, Texas
- Information Services Consultant, Baylor Health Care System, Dallas, Texas
Timeline
Vice President; Software Engineer II
Bank of America
11.2018 - Current
Data Warehouse Developer
Texas Capital Bank
11.2014 - 11.2018
Senior Business Intelligence Developer
RealPage Inc.
07.2013 - 10.2014
Senior Consultant – Business Intelligence
Saxony Partners
05.2013 - 07.2013
High School Diploma -
Sunset High School
No Degree -
Various SQL / Database / IT Technical Courses