Suryakant Ker Email & Phone Number

Bengaluru Area, India

Understanding client environment and BI solution and performing reverse engineering for documentation. Involve in requirement gathering meetings to understand requirements and future usage for the reports and documented them.Working on prototype for Request for Proposal (RFP) for technologies like Talend, QuerySurge, Sisense with database like MySQL, SQL.Performing source system data analysis in order to manage source to target data mapping.Worked on data migration projects; requiring consolidating data from MySQL, SQL Server maintaining referential integrity. Performed data cleansing enrichment and mapping tasks. Performing source system data analysis in order to manage source to target data mapping.Working on of ETL & ELT Integration project for data migration.

Bengaluru Area, India

Responsible for managing 4 core products Casino Management System (CMP), CAGE, Pre-Commitment (PC) and Power Venue (PV) for US, Canada and Australia region. Worked as both individual contributor and managing a small team. Database upgrade solution (Version to Version/Build to Build) Environment related solution (Replication, Always-On, TDE) Purge and Archive Solution Minimum Downtime Upgrade Solution Performance Tuning Production Support

Bangaluru

Domain :: VisualizationSub Domain :: Configuration Management and vCloud Automation Center. Key features of Configuration management includes ::• Centralized configuration change execution across VMware infrastructure and Windows, Linux and Unix operating systems• Extensive and continuous configuration data collection, configuration assessment and change auditing• Unified reporting of configuration data and compliance-assessment results• Automated remediation of "out-of-compliance" configurations• Ability to assess OS patch status and deploy patches as neededKey features of Automation Center are ::Deliver a Personalized Self-service Experience• Deliver infrastructure, application and custom services through a unified IT service catalog.• Meet specific business needs at the right service level with personalized, policy-based governance.• Automate and accelerate IT service delivery.Deploy Across Multi-Vendor, Multi-Cloud Infrastructure• Provide investment protection for current and future technology choices.• Deliver governance and control to enable hybrid cloud deployments.• Gain flexibility to choose the right cloud platform and location that meets the business needs. Technologies used ::SQL Server 2008 R2, SSRS, vPostgres, .NET, C#

Bengaluru Area, India

Domain :: Field Services (Property Mortgage) Technologies ::SQL Server 2008 R2, SSRS, DB2, SSRS 2008 R2Responsibilities ::Creating reports as per business requirement.Managing Report Server, Subscriptions. Making sure SLA are met w.r.t delivery of daily, weekly, monthly, quarterly, yearly and adhoc reports.ETL (starQuest data replicator) from DB2 to SQL Server.Performance Tuning of ETL tool, Reports and DB objects.Initiative :: Improved the performance of ETL process (DB2 to SQL Server) from 8-10 hours to 4-5 Hours.

Resolving work unit (tickets) in the shortest possible time and provided optimized solution.Performance tuning for store procedures and SSIS packages.Developed hQUEST application as deviation to ePMO application and MSP.Conducted 2 training sessions on SQL Server Reporting Services (SSRS).Reviewing other team member’s work for accuracy w.r.t. requirement and optimization.Involved in developing checklist to reduce the occurrence to defects. Participating in Internal Audits.

Maintenance and enhancement of various internal applications.Technologies :: ASP.NET, C#, SQL Server, HTML, CSS

Education record

Activities and Societies: National Cadet Corps (NCC)

M.Sc - It 2007 B, Information Technology

B.Sc, Physics