Chandra Shekhar Email and Phone Number

•Requirement gathering & analysis in claims, provider and medical management area while interacting with clients•Create SQL Stored procedures, functions and other SQL objects to support data integration.•Involved in Design and Development of SSIS Packages using various Control Flow and Data Flow items to Extract, Transform and Load the Data•Scheduling the jobs using CONTROL-M job scheduler•Responsible for review of the deliverables from offshore claims and clinical areas •Assisted the team to understand domain specific requirement in claims and clinical areas•Organized successful cross training sessions within the teams to ensure all associates were aware of National Consumer Cost Tool•Design, develop and maintain reports, ETL packages, SQL queries and data models•Create cubes and dimension data using Microsoft SQL Server Analysis Services 2012 and build queries using MDX •Scheduling and Monitoring the ETL Packages for daily load through SQL Server job Agent •Developed the reports in the form of Matrix, Table and Chart using SSRS•Creation of report subscriptions to send the reports by mails by scheduling the reports•Preparation of unit test cases for the packages and reports developed•Work closely with onshore team in other region to deliver the service•Understanding the business needs and providing the solutions accordingly