Kishorekumar M

SME for 500+ SSRS Reports & 100+ SSIS Packages Architect-ed, Designed & Implemented On-Prem to Cloud migration as well as SQL Server 2008 To 2012 Upgrade of Databases, SSRS Reports(500+) and SSIS Packages(100+) Developed 100+ Hierarchical Reports for Business Needs Worked on very complex Data Models & Transformations for Upstream & Downstream reporting Provided Solutions to Business Critical situations Onshore-Offshore Co-ordination Quickly learnt SAP BO and worked on Functionality Gap Analysis between Oracle OBIEE and SAP BO Built 3 Complex & Business Critical Reports in SAP BO as a POC for OBIEE To SAP BO migration Optimized and fine-tuned Queries for better Reports and ETL performance Worked as Onsite Lead for IAP(Infosys Automation Platform)

Land Track Lead with 5 .Net Applications/ 300+ SSRS Reports/ 30+ SSIS ETL Packages Responsible for Requirements gathering & Analysis, Onsite - Offshore co-ordination IIS and SSRS Admin Architect-ed, Desgined & Implemented On-Prem to Cloud migration of entire Land Track - SQL Server upgrade from 2008 To 2012 - Windows Server Upgrade from 2008 To 2012 - 5 .Net Applications - 6 Databases - 300+ Reports - 30+ ETL Packages - IIS Upgrade from 6.0 to 7.5 with Backward compatibility Configuration Developed WCF Services for Business needs which run in the Background Asynchronously for better User Experience Automated 10+ Maintenance Jobs which would have saved ~50Hrs/Month

.Net Technologies(WINDOWS/WEB), SQL SERVER, BI(SSIS/SSAS/SSRS/POWER BI), SAP BO, DATA MODELING, ORACLE, MPP, ITIL(SERVICE NOW/ REMEDY), Onsite-Offshore Coordinator, IAP(Infosys Automation Platform)

Built Admin Tool for Tidal Jobs monitoring Designed the UI with JQuery for better User Experience

Architect-ed, Designed and Developed RTSC ( Real Time Surveillance Center) to provide continuous monitoring, surveillance, and optimization services for permanently installed down hole and wellhead equipment. This service makes asynchronous calls to an external web service dynamically to pull the data and updates the RTSC database with that data. This process requires parallel processing of the requests which is developed using Thread Pool concepts.

Architect-ed, Designed Major Developments & Enhancements Team Management activities like planning, co-ordination and guidance in Domain & Technical aspects Client Interfacing Requirements Analysis & Documentation Built Complex and Hierarchical SSRS Reports Perform Code Review for all Deliverables before Prod Deployment Data Modeling & Query performance Optimization

.Net Technologies(Windows/ Web), SQL SERVER, ORACLE, CRYSTAL REPORTS