Robert Iii A. Email and Phone Number

– Design & implement the squad’s data strategy required for data to power machine learning based algorithms– Develop and share data as a product with data, metadata, code and policy as one architecture– Architect solutions utilizing transactional databases, operational data stores and analytical datawarehouses– Design, build and optimize data pipelines, architectures and data sets in Azure and GCP– Work closely with application developers in defining the domain data semantic, mapping data from application context to the data product context to be used for machine learning

– Develop complex ETL and Analytics Programs using SQL and Stored Procedures– Develop, maintain and support SSIS packages related to ETL process– Responsible for data profiling as well as SQL and database tuning / optimization– Analyze client requirements and design technical solutions based on requirements– Perform day to day troubleshooting of issues related to QA and Production– Design ETL audit control and scheduling processes– Managing and versioning the SSIS projects using Visual Studio Foundation Server

– Leads the Change Requests and Break fixes Team for Operations– Leads the Release and Deployment Team– Oversee deployment of change request and break fix codes related to Web UI, API, ETL and DB in AWS Platform through Jenkins pipeline– Implement change requests and break fix codes related to Web UI, API, ETL and DB in AWS Platform– Investigate, provide RCA and resolve defect tickets raised by QA and Product Owner– Act as L2 Support in investigating defect tickets and change requests escalated by L1– Development of ETL/DW jobs in AWS Platform (Redshift, Athena, Glue, S3, etc.)– Helped in PowerBI Reporting architecture and integration in AWS Platform– Handles enhancement requests for PowerBI Dashboard

– Leads the backend and data warehouse development team– Gathers data requirements from business users or other teams– Coordinate with other teams for development and enhancement of new ETL processes in TSQL– Acts as level 3 support in investigating incident cases escalated by ICT support team from external groups– Perform data requests from other departments

– Helped in the development and support of the new ON BI Data Warehouse and former Fairchild Semiconductor Data Warehouse– Creation and enhancement of the ETL processes in Oracle ODI and SAP BODS– Schedule and execute the ETL processes through Control-M and Autosys– Create and maintain documentation of the data and ETL processes– Ensure stable daily operations of the running processes in the former Fairchild Semiconductor Data Warehouse and for newly created processes in ON Data Warehouse– Coordinate with other teams for development and enhancement of new ETL processes – Investigate/resolve incident cases assigned to the team from external groups– Providing RCA, implementing temporary and permanent fixes to avoid recurring issues

– Develop, maintain and execute ETL tasks in SSIS or Pentaho– Maintain documentation of the data and ETL processes– Automate the process of validating data quality and ETL tasks– Perform data requests from Senior Researchers– Learn new technologies to be used on a new project

– MS SQL 2005, 2008R2 and 2012 database and server administration– Manage scheduled production deployments, production fixes and ensure their success– Ensure stable daily operations of supported applications– Identify disruptions in Production processes, investigate issues and propose solutions– Execute assigned Production migration tasks– Investigate/resolve Remedy cases assigned to the team from external groups – Address job failures and resolve Service Center tickets– Document process and technical info (reference, procedures, and resolutions.)