Manufacturer & Exporter of Bedlinen and Bathlinen products Focused on Natural Fibres as Cotton, Bamboo, Linen, Hemp, Wool and Silk

Prepress - Thermal CTP, Bureau House, CTP Plate Importer

Inspired towards value creation and building long term business relations with our client partners

I have been working as BI developer. I have hands on experience with SAS DI Studio, SAS Visual Analytics as well as SAS Management Console. During this development period, I have used various SAS transformations(i.e. SQL Join, Extract, User Written Code, Delete, Update, Create Table, Surrogate Key Generator, Table Loader, SCD, Append, Loop, Transpose, Export as PDF) along with pass-through facility of Database.ETL Responsibilities :- Designing and implementing of incremental job flows in SAS DI- SAS job's Unit testing- SAS job performance tuning- Error data report generation from daily ETL monitoring- Communication with source data provider regarding error reportAdmin Responsibilities : - SAS as well LSF Server Start/Stop- Deployment of job to production environment using SAS Management Console.- Job flow scheduling using LSF server- Monitoring activities(i.e. Memory utilization, Job status, I/O traffic etc.)- Creation and assignment of USER, ROLE and GROUP- Registering new Library- Job monitoring at production environment to troubleshoot job execution issues.- SAS DI & LSF license renewal Visualization Responsibilities :- Preparing Data sources- Creating derived objects- Designing Reports and Exploration - Scheduling and managing LASR table loadIn addition to that I have designed ETL framework using SAS DI job to achieve CDC(Change Data Capture) and to monitor daily status of job execution.

During this role, I was responsible for developing Analytical reports and Visualise them on ASP.Net based inhouse framework.Key Responsibilities:-Develop sql, pl/sql based stored procedure that results analytical data from Data warehouse-Develop complex query using subquery and Joins.-Performance tuning of quiriesTechnology:PostgreSQL, ASP.Net

During this time, I had been working as Microstrategy report developer as well as dashboard designer. I had also completed two global certification (MSTR Report Developer, MSTR Dashboard Designer) .