SAS BI Developer Resume

SUMMARY:

10 years’ experience in delivering Business Intelligence and data warehouse solution
Strong knowledge of Oracle BI (OWB,ODI,OBIEE) and SAS BI (DIS,BRM,MIP,VA)
Excellent knowledge of Data Integration and Data Management
Excellent problem solving and organizational skills

TECHNICAL SKILLS:

Database: Oracle 10g/11g, DB2, MS SQL Server 2012/2014, TOAD

Programmation: SQL, PL / SQL, SAS Base, SAS Macro, SAS SQL, SAS STAT, Python, R, Shell Script

Technologie BI: OBIEE 11g, BIAPPS, ODI 11g, OWB, SAS Enterprise Guide, SAS Studio, SAS DI, SAS MIP, SAS BRM, SAS VA

WORK EXPERIENCE:

SAS BI Developer

Confidential

Responsibilities:

Set up the data file server with all the required directories and libraries;
Developed and implement ETLs, using SAS Data Integration Studio, validated data from sources and prepared them according to the structure expected by other collective provisioning calculation processes.
Developed using MIP, the models and the UDLs (User Defined Logic) required for the calculation of the collective provision (PD, LGD, EAD, ECL);
Create and document using BRM, business rules that can be used in ETLs to validate data, perform allocation of categories to loans.
Developed in DIS, Jobs to assemble and integrate the data resulting from the calculation, allocation of categories as well as the source data required for analysis and reporting.
Developed and set up extractors, using SAS Data Integration Studio, to produce files for source systems (disclosure, accounting injection)
Develop using Visual Analytics, reports, dashboards and data visualization screens for analysis and data mining purposes

Oracle BI Developer (OBIEE, ODI)

Confidential

Responsibilities:

SAS Developer

Confidential

Responsibilities:

Analyzed the data sources for the data warehouse power supply
Developed ETL mappings to feed the data warehouse
Conducted unit tests, integrated tests and functional tests
Developed SAS data loading programs in the warehouse
Performed unit tests, integrated tests and functional tests
Participated and supported different series of tests (performance, system and acceptance tests)

Confidential

ETL Developer (OWB)

Responsibilities:

Participated in the analysis of the solution;
Designed, maintained and monitored ETL treatment to feed the warehouse
Documented properly the code by applying the standards and standards in effect
Written or updated documentation of the deliverables according to the methodology
Created and maintained unit test data
Performed unit tests, integrated tests and functional tests in accordance with methodology and processes
Participated and support the different series of tests (performance, system and acceptance tests)
Participated in the planning of deliveries and ensure their follow-up during deployments
Communicated on a daily basis with members of the development team, specialists, IT developers

SAS Developer

Confidential

Responsibilities:

Oracle BI Developer

Confidential

Responsibilities:

Production models iteratively in order to target the needs and confirm the scope of the work
Data profiling to validate data quality of FLORA source system
Data modeling and architecture of the treatment of the storage layer to jump start the construction works of these;
Data modeling and architectural treatments and the presentation layer and the architecture board predefined reports, charts, and ad hoc reports from EXCEL
Realization of data loading treatment monitoring of the implementation of the treatments of the presentation layer of the establishment of the cubes and the of predefined reports and dashboards and ad hoc
Maintained evolution of existing counters (EDM, BIPM, CFE) done in parallel
Created PL / SQL processing units
Created OWB processing units
Participated in meetings with the client
Performed analysis on processing to be established
Provided PL / SQL development support
Performed unit and functional testing

SAS Developer

Confidential

Responsibilities:

SAS Programer Analyst

Confidential

Responsibilities: