Dharmendra Chavda Email & Phone Number

Gurgaon, Haryana

Lead a team of 12 members who have strong knowledge in SAS and Oracle programming responsible for managing the all ETL, campaigns, reports, robotic process and business delivery.Responsible for the gather all business requirements, analyze in depth, explain and distribute within team members and share the estimate time with the business team. Developed and implemented the campaign management data marts which enable partner management team to planning for the campaign and reduce… Show more Lead a team of 12 members who have strong knowledge in SAS and Oracle programming responsible for managing the all ETL, campaigns, reports, robotic process and business delivery.Responsible for the gather all business requirements, analyze in depth, explain and distribute within team members and share the estimate time with the business team. Developed and implemented the campaign management data marts which enable partner management team to planning for the campaign and reduce the campaign execution time. This solution is increase the capacity of campaign execution near to real time and increase the marketing revenue by 50%. Developed and implementation of the campaign reporting solution using SAS and Oracle which enable the partner to view the campaign performance by next day morning instead of waiting of 10 days using legacy system after completion of campaigns.Developed and implementation of the on demand reporting solution using SAS and Tableau which enable the business team to view the business performance using various filters with drag and drop functionality. Time to time mentor the team members, create the growth path, created the process for knowledge sharing and explain and appreciate the business impact by the process which are they involve. First time in PAYBACK India history won the PINACLE award to all team members instead of year best Project. Show less

Gurgaon, Haryana

Noida, Uttar Pradesh

Worked as Data Management lead for implementation of the RWA solution using SAS CSFB and RWA. Lead a team of 6 members (2 from Sutra Analytics and 4 from SAS Indonesia) who have strong knowledge in SAS DI. Design and implement customized SAS DDS using DI which was leverage for SAS CSFB and SAS RRM engine for CIMB bank.Created the Data Management plan for all IV phases which involve documentations such like high level design, low level design, task distribution within team members… Show more Worked as Data Management lead for implementation of the RWA solution using SAS CSFB and RWA. Lead a team of 6 members (2 from Sutra Analytics and 4 from SAS Indonesia) who have strong knowledge in SAS DI. Design and implement customized SAS DDS using DI which was leverage for SAS CSFB and SAS RRM engine for CIMB bank.Created the Data Management plan for all IV phases which involve documentations such like high level design, low level design, task distribution within team members, production migration planning.Develop and implement end to end reporting solution using SAS WRS with user role base access. Involve in integration solution for various SAS tool as required during the project.Won award of best project implementation of the year in south east asia region. Show less

Gurgaon, Haryana

Involved in the development and implementation of the complete SAS ETL marts which are base for all reporting, analytical and campaign deployment purposesResponsible for the maintenance and modifications of the Campaign Management Data Mart (CMDM) and BI reports on regular intervalsDesigning and developing the reports based on the clients requirements and scheduling the reports on regular deliverables through SAS Management Console and LSFLead a team of 4 members who have strong… Show more Involved in the development and implementation of the complete SAS ETL marts which are base for all reporting, analytical and campaign deployment purposesResponsible for the maintenance and modifications of the Campaign Management Data Mart (CMDM) and BI reports on regular intervalsDesigning and developing the reports based on the clients requirements and scheduling the reports on regular deliverables through SAS Management Console and LSFLead a team of 4 members who have strong knowledge in SAS programming, automation, process development and campaign deploymentResponsible for end-to-end automation which involves integrating the SAS system with various other platforms and third party data vendors for the response managementResponsibility also involves on the implementation of the Tableau which integrates with the Oracle for internal reporting purposes. Show less

Mumbai Area, India

Worked on implementation of standard SAS IIS DDS 3.2 for Health, Travel, Motor Insurance for Reliance Corporation.Involve in generating cluster id for customer across Motor, Travel and Health Insurance policy holders wide using dfPower Studio for Reliance General Insurance Understanding the project requirement and developed the utility for cleaning and improving the customers data for Reliance General Insurance using ASP .Net. which going to use by call center.Created & Modify… Show more Worked on implementation of standard SAS IIS DDS 3.2 for Health, Travel, Motor Insurance for Reliance Corporation.Involve in generating cluster id for customer across Motor, Travel and Health Insurance policy holders wide using dfPower Studio for Reliance General Insurance Understanding the project requirement and developed the utility for cleaning and improving the customers data for Reliance General Insurance using ASP .Net. which going to use by call center.Created & Modify reports using SAS BI toolsets (SAS WRS, SAS Information Maps, SAS OLAP Cube Studio, SAS OLAP Viewer and SAS Enterprise Guide) for RGI Corporation Ltd.Worked on implementation of CMDM (Campaign Management Data Mart) for Idea Cellular Ltd.Design and implement CMDM and end to end reporting solution for PAYBACK India Show less

Understanding existing system reports requirement and Business rules.Handled change request for existing project.Responsible for taking monthly backup of entire production system. Writing SAS scripts & Stored Procedures to create reports as per business required.Developed ETL Jobs to load data from the Source System (SQL to Oracle) & created multi-dimensional Cube.Created & Modify reports using SAS BI toolsets (SAS WRS, SAS Information Maps, SAS OLAP Cube Studio, SAS OLAP… Show more Understanding existing system reports requirement and Business rules.Handled change request for existing project.Responsible for taking monthly backup of entire production system. Writing SAS scripts & Stored Procedures to create reports as per business required.Developed ETL Jobs to load data from the Source System (SQL to Oracle) & created multi-dimensional Cube.Created & Modify reports using SAS BI toolsets (SAS WRS, SAS Information Maps, SAS OLAP Cube Studio, SAS OLAP Viewer and SAS Enterprise Guide).Used SAS Management Console to create various business users and Schedule various jobs.Configured user role wise Portal Pages using SAS Portal and handled user level authorization using SAS Management Console.Responsible for up the SAS Portal services Show less

Master Of Computer Applications - Mca, Computer Science, Distinction

Master Of Mathematics, Mathematics