Back to Search Results

Dwayne H.

Sr. SQL/SAS DI Studio Developer

Commitment
0/ 5
Competency
0/ 5
Reliability
0/ 5
  • Overall Experience: 16 Years  
  • Agile Software Development:
  • Algorithm Development:
  • Alpha software:
  • Amazon Relational Database Service:
  • Advanced Message Queuing Protocol - (AMQP):
+ More

Dwayne H. 

Sr. SQL/SAS DI Studio Developer

Commitment
0/5
Competency
0/5
Reliability
0/5

Time zones ready to work

  • Central Daylight [UTC -5]
  • Mountain Daylight [UTC -6]
  • Pacific Daylight [UTC -7]
  • Eastern EST [UTC +3]
  • Eastern European [UTC +2]
  • Greenwich Mean [UTC ±0]
  • Further EET [UTC +3]
  • Australian EDT [UTC +11]
  • Australian CDT [UTC +10:30]
  • New Delhi [UTC +5]
  • Dubai [UTC +4]
  • Singapore [UTC +7]
  • China (West) [UTC +6]
  • Hong Kong (East China) [UTC +8]
  • Eastern Daylight [UTC -4]

Willing to travel to client location: Yes  

About Me 

Sr. SQL/SAS DI Studio Developer with sixteen years of professional experience in technical leadership roles in financial Services in Big Data Analytics as SAS Grid implem
Sr. SQL/SAS DI Studio Developer with sixteen years of professional experience in technical leadership roles in financial Services in Big Data Analytics as SAS Grid implementation and support manager, Industry Solutions Architect, SAS Platform administrator and developer, SAS Principal, SAS Trainer and Data Warehousing consultant for Fortune 100 financial services companies. This experience includes involvement in all phases of the software development life cycle: analysis, design, implementation and system testing. Accustomed to communication with cross-functional business units to create/gather business requirements and translate them into system solutions. Extensive experience in Windows and UNIX environments, managing multiple concurrent projects.
Show More

Interview Videos

Signup to see videos

Risk-Free Trial, Pay Only If Satisfied.

Portfolios

Data Management

Website Link:

Role:

• Design, development, and dissemination of reporting and visualization for Amgen Compliance internal clients

• Build data structures in SAS BI and use them to build automated reports

• Requirements collection for SAS process creation

• Create and maintain document

• Design, development, and dissemination of reporting and visualization for Amgen Compliance internal clients

• Build data structures in SAS BI and use them to build automated reports

• Requirements collection for SAS process creation

• Create and maintain documentation on the requirements and associated SAS processes

• Data mapping between ODS (Archive Oracle DB) and CDL (New Redshift DB)

Show More

Skills: SAS 9.4SAS AccessSAS Enterprise GuideSAS Management consoleSAS Stored process

Tools: Sas enterprise guideSAS BASESAS MACROSAS SQLSAS ACCESSTeradata SQL AssistantRedshiftLinux Red HatSAS SMCSAS 9.4

DirecTV/AT&T

Website Link:

Role:

· Partner with cross functional teams such as Finance, Strategy, Business Analytics and Customer Care to understand enterprise trends, competitive environment and their impacts on subscriber behavior and provide conclusions and recommendations to business owners.

· Partner with cross functional teams such as Finance, Strategy, Business Analytics and Customer Care to understand enterprise trends, competitive environment and their impacts on subscriber behavior and provide conclusions and recommendations to business owners.

· Provide insight into and develop new ideas and approaches to improve operational results.

· Perform ad hoc analytics on large/diverse datasets using various tools and techniques

· Perform data extraction, aggregation, and quality checking from multiple data sources to prepares statistical and narrative reports and recommendations

· Perform data mining and data analysis activities to conclude fraud, policy non-compliance or training opportunity and hence drive new strategies

· Initiate proactive investigations into data issues that impact reporting, analysis, or program execution

· Consolidate information and present to program managers and senior management in a clear and concise manner.

· Create insightful dashboard reports and qualitative analysis using data from multiple sources

· Support tools for data analysis, controls automation, and audit support.

· Implement data analytic routines to provide identification, analysis, and reporting of audit results

· Support special Ad Hoc Projects - ability to step in and assist management on initiatives as they come up across transaction management

· Ability to prioritize and execute multiple overlapping projects while working in a fast-paced and dynamic environment

· Strong attention to detail

· Access and compile large amounts of data in SAS, Teradata SQL Assistant, Cognos, and Tableau

· Analyzing data in SAS

· Interpret and quantify trends on the operational aspects of various bundle partners in SAS

· Effectively communicate concise findings and recommendations to senior management and leaders

· Creating and enhancing various analytical tools that will help improve the operational results

· Develop requirements and perform testing on the associated analytical tools

Environments:SAS, Teradata SQL Assistant, Cognos and Tableau

Show More

Skills: Teradata SQL AssistantCognosTableau

Tools: Visual Studio Online

Winehouse

Website Link:

Role:

· Access Data from WIN08-PDCVH database (MS SQL Server)

· Perform weekly checks on WIN08-PDCVH database to validate WineHouse SQL (POS Database) replication to the SAS Server (WHSASSRV)

· Manage data across the following WIN08-PDCVH tables: C

· Access Data from WIN08-PDCVH database (MS SQL Server)

· Perform weekly checks on WIN08-PDCVH database to validate WineHouse SQL (POS Database) replication to the SAS Server (WHSASSRV)

· Manage data across the following WIN08-PDCVH tables: Category, Customer, Department, Item, QuantityDiscount, Supplier, SupplierList, Transaction, TransactionEntryCheck to ensure SAS processes run error-free by checking SAS log files and underlying datasets

· Check WineHouse SAS Portal via the Web Browser to ensure the presenting data layer (Portal Reports) display correct data

Environments: SAS base, SAS macros, SAS proc procedures, SAS datastep

Show More

Skills: SAS MacrosSAS Data Integration

Tools: Visual Studio Online

Kaiser Permanente

Website Link:

Role:

· Convert and streamline SAS projects and programs/analysis to run intuitively on UNIX, PC and Mainframe in batch mode.

· Installed and maintained SAS GRID client applications like Base SAS, Enterprise Guide, and Enterprise Miner on user machines as needed.

· Convert and streamline SAS projects and programs/analysis to run intuitively on UNIX, PC and Mainframe in batch mode.

· Installed and maintained SAS GRID client applications like Base SAS, Enterprise Guide, and Enterprise Miner on user machines as needed.

· Trouble shooting client applications like Enterprise Guide and Base SAS in GRID environment.

· Involved in gathering and analyzing business requirements and detail technical design of ETL to support data around OpQ – Specialty Care and OpQ – Primary Care

· Involved in the construction of the ETL process- extracting data from multiple databases (SQL Server, Oracle, Teradata) using SAS DI Studio, SAS/Access, SAS SQL procedures, creation of permanent SAS data sets within UNIX directories using Transformations according to the Business Requirements and Loading of data in to the appropriate OpQ data sets and OpQ Oracle History tables

· Perform the ETL tuning for OpQ by using lookup instead of join if possible, removing unnecessary component, making use of the indexes on the tables

· Register multiple data sources (raw external files, datasets, database tables) into meta-folders using DI Studi

· Create, modify metadata definitions for raw external files, datasets, database tables using DI Studio

· Convert SAS DI Studio jobs into LSF flows that can be automatically triggered by time or file events to run on Platform Process Manager Server

· Developed Packages, SQL Scripts and Database Triggers to populate the historic data in stage OpQ Oracle History Tables

· Developed structural changes to database objects according to business logic

· Used SQL*Loader scripts to load the flat files into the stage OpQ Oracle Database

· Performed application SQL Tuning using SQL Trace and Explain plan

· Created simple and complex views

· Used various SQL Expressions in standalone procedures and functions

· Wrote complex SQL scripts and was POC for performance tuning of SQL queries

· Used Export/Import Oracle utilities of Data Pump to move data to different testing environments

· Worked on Unix Shell Scripting for scheduling batch jobs using Crontab

Environments: SAS DI Studio, SAS/Access, SAS SQL, UNIX, Oracle 11g/10g, SQL, PL/SQL, SQL*PLUS9.2.0.3, TOAD 10.6, SQL Developer 3.1, ORACLE 11g,10g, SQL* Plus, UNIX, PL/SQL Developer,

VISIO

Show More

Skills: SQL

Tools: Visual Studio Online

Freedom Specialty Insurance

Website Link:

Role:

· Develop SAS programs using Enterprise Guide to prepare data, develop, evaluate and validate predictive models

· Extensively used SAS Grid architecture on UNIX/Linux to perform job and workflow scheduling

· Design and build

· Develop SAS programs using Enterprise Guide to prepare data, develop, evaluate and validate predictive models

· Extensively used SAS Grid architecture on UNIX/Linux to perform job and workflow scheduling

· Design and build highly interactive SAS applications using SAS BI suite and OLAP tools

· Create interfaces between UNIX, Window and Web environments using SAS programs, DI Studio Jobs, and tools to obtain and maintain data from external vendors.

· Provided programming / implementation support for different SAS tools (SAS FORECAST STUDIO, SAS-EMINE, SAS-EGUIDE, BASE SAS, SAS GRID)

· Create, refine and manipulate SAS reports, graphs and dashboards using Web Report Studio

· Sourcing data from Main SCA, ADR, Derivative Shareholder Actions, Investment Shareholder Actions, and Investment Banking E&O databases within Freedom Specialty’s Peregrine Model.

· Extract, Transform, and Load data into Main SCA, ADR, Derivative Shareholder Actions, Investment Shareholder Actions, and Investment Banking E&O databases

· Developed Packages, SQL Scripts and Database Triggers to populate the historic data in stage Oracle SCA Litigations Database History Tables

· Developed structural changes to database objects according to business logic

· Used SQL*Loader scripts to load the flat files into the stage Oracle SCA Litigations Database

· Performed application SQL Tuning using SQL Trace and Explain plan

· Created simple and complex views

· Used various SQL Expressions in standalone procedures and functions

· Wrote complex SQL scripts and was POC for performance tuning of SQL queries

· Used Export/Import Oracle utilities of Data Pump to move data to different testing environments

· Worked on Unix Shell Scripting for scheduling batch jobs using Crontab

Environments: SAS DI Studio, SAS/Access, SAS SQL, SAS BI suite and OLAP tools, UNIX, Main SCA,ADR, Derivative Shareholder Actions, Investment Shareholder Actions, and Investment Banking E&O

Oracle databases, Oracle 11g/10g, SQL, PL/SQL, SQL*PLUS9.2.0.3, TOAD 10.6, SQL Developer 3.1,

ORACLE 11g, 10g, SQL* Plus, UNIX, PL/SQL Developer, VISIO

Show More

Skills: Statistical Analysis Software - SASUnixOracle 10gOracle 11gTools For Oracle Application Development - TOADPL/SQLSQL

Tools: Visual Studio Online

Employment

Data Management Manager

2018/07 - 2020/03

Skills: Statistical Analysis Software - SASPL/SQLT SQLTools For Oracle Application Development - TOADOracleFlux

Your Role and Responsibilities:

· Design, development, and dissemination of reporting and visualization for Amgen Compliance internal clients

· Build data structures in SAS BI and use them to build automated reports

· Requirements collection for SAS process creation

· Design, development, and dissemination of reporting and visualization for Amgen Compliance internal clients

· Build data structures in SAS BI and use them to build automated reports

· Requirements collection for SAS process creation

· Create and maintain documentation on the requirements and associated SAS processes

· Data mapping between ODS (Archive Oracle DB) and CDL (New Redshift DB)

Show More

Contingent SAS Developer/Analyst

2015/10 - 2016/03

Skills: TeradataCognosTableau

Your Role and Responsibilities:

· Partner with cross functional teams such as Finance, Strategy, Business Analytics and Customer Care to understand enterprise trends, competitive environment and their impacts on subscriber behavior and provide conclusions and recommendations to business owners.

· Partner with cross functional teams such as Finance, Strategy, Business Analytics and Customer Care to understand enterprise trends, competitive environment and their impacts on subscriber behavior and provide conclusions and recommendations to business owners.

· Provide insight into and develop new ideas and approaches to improve operational results.

· Perform ad hoc analytics on large/diverse datasets using various tools and techniques

· Perform data extraction, aggregation, and quality checking from multiple data sources to prepares statistical and narrative reports and recommendations

· Perform data mining and data analysis activities to conclude fraud, policy non-compliance or training opportunity and hence drive new strategies

· Initiate proactive investigations into data issues that impact reporting, analysis, or program execution

· Consolidate information and present to program managers and senior management in a clear and concise manner.

· Create insightful dashboard reports and qualitative analysis using data from multiple sources

· Support tools for data analysis, controls automation, and audit support.

· Implement data analytic routines to provide identification, analysis, and reporting of audit results

· Support special Ad Hoc Projects - ability to step in and assist management on initiatives as they come up across transaction management

· Ability to prioritize and execute multiple overlapping projects while working in a fast-paced and dynamic environment

· Strong attention to detail

· Access and compile large amounts of data in SAS, Teradata SQL Assistant, Cognos, and Tableau

· Analyzing data in SAS

· Interpret and quantify trends on the operational aspects of various bundle partners in SAS

· Effectively communicate concise findings and recommendations to senior management and leaders

· Creating and enhancing various analytical tools that will help improve the operational results

· Develop requirements and perform testing on the associated analytical tools

Environments:SAS, Teradata SQL Assistant, Cognos and Tableau
 

Show More

Sr. Sas Consultant

2015/01 - 2015/07

Skills: Statistical Analysis Software - SASSAS Macros

Your Role and Responsibilities:

· Responsible for Effective operation of the Central Analytics Environment (CAE).

· Responsible for Integration of SAS grid with Cloudera Hadoop implementation.

· Responsible for SAS middle-tier implementation.

· Administ

· Responsible for Effective operation of the Central Analytics Environment (CAE).

· Responsible for Integration of SAS grid with Cloudera Hadoop implementation.

· Responsible for SAS middle-tier implementation.

· Administering the SAS9 software environment including installation, configuration, tuning, upgrades and hot-fixes developing and documenting administration processes & system configuration.

· Monitoring and logging SAS servers and tune servers for optimal performance and Storage management - do more with less.

· Monitoring and managing hosts, jobs, users and queues in the SAS Grid environment.

· Evaluation and migration to newer versions of SAS Grid environment.

· Designing, implementing and maintaining the security framework for CAE.

· Recommending appropriate tools and technology for modeling and analysis work.

· Developing and delivering SAS training including SAS Grid for end users and administrators.

· Optimizing use of environment resources for business.

· Actively planning and prioritizing requests for resources.

· SAS SME to support the CAE business user community.

· New software evaluation.

· Support of all Production / Development environment related issues

· SAS Analytics administration expertise to debug user issues.

· Performing daily tasks of SAS / Unix system administration, including file system performance monitoring, reviewing OS patch

· Resource and infrastructure planning.

Environments: SAS Grid, Platform LSF, Management Console (with Metacoda), SASGSUB, Enterprise Guide, SAS Enterprise Miner, SAS EBI, Web Reports studio, DI Studio, Add-in for Microsoft Office, Stored Processes, OLAP Cube, Studio, Analytics Pro, Base, Macros, Connect, ODS.

Show More

SAS Administrator

2016/03 - 2019/02

Skills: SASUnix

Your Role and Responsibilities:

On-boarding new users into the SAS Environment / Metadata. Creation of user account both in UNIX and SAS Metadata. Creation of Access Control Levels and ACL groups for user assignment for segregated access to data. Perform SAS Version upgrades. Application of SAS patches. Systematic and environmenta
On-boarding new users into the SAS Environment / Metadata. Creation of user account both in UNIX and SAS Metadata. Creation of Access Control Levels and ACL groups for user assignment for segregated access to data. Perform SAS Version upgrades. Application of SAS patches. Systematic and environmental configuration of SAS application. Perform SAS Data Migration. SAS Usage reporting. Monitoring overall health of the SAS System (Memory, CPU, I/O, Page Swaps, etc). Assisting users by debugging their code for errors, helping them to optimize their code for better performance.
Show More

SAS BI Developer

2014/05 - 2014/09

Skills: SASMssql

Your Role and Responsibilities:

Access Data from WIN08-PDCVH database (MS SQL Server) Perform weekly checks on WIN08-PDCVH database to validate WineHouse SQL (POS Database) replication to the SAS Server (WHSASSRV) Manage data across the following WIN08-PDCVH tables: Category, Customer, Department, Item, QuantityDiscount, Supplier,
Access Data from WIN08-PDCVH database (MS SQL Server) Perform weekly checks on WIN08-PDCVH database to validate WineHouse SQL (POS Database) replication to the SAS Server (WHSASSRV) Manage data across the following WIN08-PDCVH tables: Category, Customer, Department, Item, QuantityDiscount, Supplier, SupplierList, Transaction, TransactionEntryCheck to ensure SAS processes run error-free by checking SAS log files and underlying datasets Check WineHouse SAS Portal via the Web Browser to ensure the presenting data layer (Portal Reports) display correct data
Show More
+ More

Education

1996 - 2000

Skills

Agile Software Development Algorithm Development Alpha software Amazon Relational Database Service Advanced Message Queuing Protocol - (AMQP)
+ More

Preferred Languages

English - Fluent