• Writing Stored procedure to extract data to extract data from SQL server. • Writing ETL code to extract the data from Remedy and other applications for data migration to new platform. • Extensive use of SQL queries, stored procedures to extract the data from SQL Server as per business requirement. • Extensive experience in developing tools using VBA, Excel environment. • Created Excel based tools to move/format data between sheets based on selection criteria using the Excel Object Model, VBA, Events, Right Click Events, Combo boxes, and Double click events. • Maintaining the existing VBA tools as per Business process changes and improve their performance. • Preparing AM’s wise and span’s wise production comparison report for different segments. • Preparing Utilization and efficiency comparison also production target and achievement comparison summary. • Preparing day start inventory Report and target sheet for Business operations. • Preparing Daily weekly and monthly Quality report and the improvement areas. • Preparing other business analysis reports for Operations. • Generating code for automation of report/exporting data to excel and other format. • Automating the business process into VBA coding so that it can be processed by system automatically without user intervention. • Coding and managing business automation process project so that these can be delivered on time with quality and performance. • Preparing business analysis reports for Higher Management • Make sure each team should complete their assigned target to for day and advice operations action plan to meet the daily goals. • Participate in business requirements meetings and analyze the requirements and gain good knowledge of the application from both technical and business perspectives. • Developing tools, reports to automate claims processing (UNET) using VBA.