chanra sekhar

sas di developer

About

SAS DI Developer at Accenture

Country

india

City

bengaluru

Industry

information technology and services

Skill

sas data integration, sas add in for ms, sas data integration studio, sas add in for ms office. sas/base, sas/macros, sas olap cube studio, sas information map, sas information map studio, sas dash boards, sas web report studio, sas management console, sas information, sas enterprise guide, sas information delivery portal

Experience

management trainee

hdfc bank

2011-6 - 2012-6 · 1 yr 1 mo

* Designed and developed Extract, Transform, Load (ETL) processes using Base SAS, Data Integration Studio. * Developed Daily, Weekly and Quarterly reports using Various Transformations. * Validating the Data using Data Validation Transformation. * Utilized Slowly Changing Dimensions to track changes over time * Using Apply Lookup Standardization to apply Data flux Schemas. * Developed star schemas for effective reporting on high volumes of data * Scheduling the Jobs According to the Flow Design Document * Migration of Jobs. * Coding SAS programs with the use of SAS/Base and SAS/Macros for Pre & Post Process.

sas di developer

accenture

2012-7 - Present · 14 yrs 3 mos

* Software Profitional with 3 years of core Expertise on SAS Base & SAS DI Studio. * Good hands on experience in Pharma, Banking & Financial domains. * Expertise in Design & Development of ETL processes for Data Integration projects to build data marts. * Extensively worked on transformations Splitter, Lookup, Data Validation, Extract, Join & SCD Type 2. * Experienced in creating SAS OLAP Cubes with numerous dimensions & levels of data. * Experienced in Creation of SAS WRS Reports, Portal pages & different types of Portlets. * Extensive knowledge of using Base SAS, SAS/Macros, SAS/SQL, SAS/STAT & SAS ODS. * Proficient in working on UNIX and Windows platform