SHUAIB KHAN

Richmond, TX USA

+1-646-***-****

adt0fw@r.postjobfree.com, Linkedin.com/in/shuaib-f-khan/ Enterprise Data Architect

Leadership Project Management Database Specialist An IT professional with 20 years of experience as an Oracle database specialist. Managed large corporate databases for various clients in the Oil & Gas, Media, and Finance industries. Possessing leadership skills including analytical decision- making, communication, delegation, teamwork, adaptability, creative problem-solving, trustworthiness, and tech savviness. Experienced in project management including effective communication, negotiation, scheduling, time management, technical expertise, risk management, and critical thinking.

• database design • data governance • project cost control

• data modeling • data warehousing • business process automation

• data quality • business intelligence • agile project management

• database development • query optimization • application development

• database security • reporting • release management CERTIFICATIONS

• Introduction to Microsoft Azure Cloud Services

• Microsoft Azure Mgmt. Tools & Security Solutions

• Microsoft Azure Services and Lifecycles

• Data Warehousing and Business Intelligence

EXPERIENCE:

Capgemini America

Data Architect, Financial Services Business Unit (FSBU), Remote, USA Feb 2022 – Aug 2022 Provided data management solutions for various clients in the financial domain.

• Maintained existing data models for Bread Financial (formerly Alliance Data Systems) leading to better data management and key decision-making.

• Created data models relating to retail banking using Oracle Data Modeler and Microsoft Visio. Data models were proposed to financial clients like Goldman Sachs and JPMorgan for better data management and key decision- making.

Occidental Petroleum

HSE Data Architect, Houston, TX USA Feb 2021 – Aug 2021 Created data management solutions in the health, safety, and environment (HSE) sector after the acquisition of Anadarko.

• Created data models in Microsoft Visio for data from legacy-based source systems leading to a reduction of data redundancy, duplicated data, data variances, data discrepancies, and better data efficiencies.

• Data models were used by an online analytic system for upper management leading to better decision-making.

• Created design and procedural documentation providing the development team with the information needed to develop an online analytical system.

• Coordinated with the integration team to provide source data to the data warehouse for better analytic processing and creating data marts.

• Worked on creating data governance guidelines relating to accountability, data stewardship, data quality standards, data principles, transparency, data provisioning, Saudi Aramco, Oct 2009 – Jun 2020

Sr. Data Architect, Expec Computer Center (ECC), Dhahran, KSA. (Jul 2014 – Jun 2020) Maintained a corporate database for the upstream business line providing the petroleum engineering department with the most updated data to make key business decisions

• Gathered requirements and translated them into logical and conceptual data models for better data management Page 2

• Created physical data model in Oracle Designer and deployed data model DDL in the corporate database working with release management and DBA team leading to the availability of the most updated data to the petroleum engineering department for key decision making. Tools used were Oracle SQL Developer, SQL Plus

• Documented business rules for data quality assessments as part of the data governance guidelines defined that were implemented in the corporate database preventing bad data from entering the database and leading to more healthy data.

• Created standard and dynamic data models for data quality assessment business rules receiving data from the corporate database. These data quality data models were used by a data quality system that was reviewed by upstream management monthly to review bad data

• Defined and documented data quality standards, naming conventions, and archival strategies as part of the data governance guidelines defined leading to data consistency, and data trustworthiness.

• Created an online data dictionary showing all data models in the upstream business line for all users in the upstream department so that users can make the best business decisions.

• Created data warehouse data model in a star schema and snowflake schema with fact tables and dimension tables for optimized performance to be used for data marts and analytical processing

• Created batch jobs feeding aggregated data from the corporate database to the data warehouse for users to review upstream aggregated data aiding in better decision-making. Tools used were TOAD and SQL Developer.

• Implemented business rules and audit rules in the corporate database using TOAD and SQL Developer in Oracle PL/SQL with complex SQL queries, packages, procedures, functions, and triggers leading to more robust data.

• Implemented data security using Oracle roles and privileges with Field Grain Access Control (FGAC) leading to more secure data and preventing data leakage.

PMT Consultant, Aramco Americas, Houston, TX, USA (Oct 2009 – Jun 2014) Worked with the Project Management Team (PMT) on the Sadara project (Saudi Aramco and Dow Chemicals) and the Yasref project (Saudi Aramco and Sinopec) as an Oracle Primavera Unifier administrator

• Used Oracle Primavera Unifier for cost control and business process automation allowing users to better manage project costs, forecasting, and reporting. Responsibilities included requirements gathering, user administration, creating reports with Oracle SQL, user manuals, and training manuals.

• Designed change management system and security workflow model in Microsoft Visio for document management to be implemented in Microsoft SharePoint with Active Directory (AD) groups and SharePoint groups providing users with an online, secure document portal leading to a more secure online platform for all engineering documents.

Time Inc., TimeWarner

Senior Analyst, New York, NY, USA Apr 2002 – Aug 2009 Maintained customized business intelligence application for the Consumer Marketing department called CircManager or Circulation Manager. The system provided reporting for eighty-five magazines.

• Developed reports using complex Oracle SQL queries, partitions, and temporary tables allowing the consumer marketing department to make better business decisions using TOAD and SQL Plus.

• Developed the server-side component of the business intelligence application in Visual C#.Net using C# and Oracle SQL aiding in the effort of the availability of a system providing ad-hoc reporting for the consumer marketing department.

• Maintained all database changes in Erwin allowing the application development team the most updated database model with all database changes.

ADDITIONAL EXPERIENCE:

• Cunningham Graphics International, ADP – Visual Basic Programmer

• Vignette Corporation – Professional Services Consultant

• DMR Consulting Group – Consultant, Merrill Lynch, and Chase Manhattan Bank

• Integrated Business Systems – Client/Server Programmer Analyst

• Odyssey Software Group – Client/Server Programmer Analyst

• Access Information Technologies – Client/Server Junior Programmer EDUCATION:

Bachelor of Engineering, SUNY at Stony Brook, Stony Brook, NY Majors: Computer Science, Computer Engineering, Applied Math, and Statistics

Contact this candidate