• 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)

· 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

· 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

· 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

· 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