Chandan jha

1.Documentation of business requirements and technical changes 2.Creating SAS macros and PL/SQL procedure for technical tasks 3.Performance enhancements of long running jobs 4.Automation of manual processes 5.Design of unit test framework 6. Operations handling

* Performing transformation and validation on the extracted data. * Development of datamarts and standard reports. * Enhancement in scheduling framework to support parallel processing * Performance enhancement in ETL process to support huge data volumes(in billions). * Migration of SAS from 9.3 to 9.4

* Writing base sas code and SQL code to read the structure of source file and load the source file(flat file) into a sas dataset. * Writing base sas code and sql code to read the structure of target table and load the flat file into the target table. * Performing transformation and validation on the extracted data. * Datamart job creation in DI studio using SAS and PL/SQL code . * Dynamic generation of SAS code using metadata . * End to end development of scheduling framework using shell and SAS.

* Creating Stored Process to create standard reports. * Creating macros and prompts for report parameters. * Producing report output in the form of html, pdf , excel and pivot. * Performance improvement

* Extracting data from external file and performing transformation and validation of data and subsequently loading the data to warehouse. * Creating metadata for external files, tables and creating jobs for extraction, transformation and load to warehouse. * Re-designing of existing SAS codes to match the current requirement.

3 months professional learning program at TCS in following areas:- 1. .Net 2. SQL, PL/SQL 3. UNIX