Lokesh Kandati
Bangalore
Summary
Willing to work under a challenging and professional environment with exposure to new technologies like MS SQL Server and ETL Developer in the area of MS SQL SERVER 2016, with enterprise portal, and where there is ample scope for organizational growth as well as individual growth.
Career Summary:
- Having 5 years of experience in system design, development, and support of Microsoft SQL Server 2016 in development, test, and production environments.
- Having 2 years of experience in analyzing, loading, extracting, validating, and transforming of unstructured international roaming data using SQL queries in Oracle SQL Developer and Advanced Excel.
- Hands-on experience in scripting T-SQL queries, complex stored procedures, and user-defined functions (UDFs).
- Experience in creating, maintaining database objects like Temporary Tables, Table Variables, Indexes, Functions, and views.
- Good experience on Joins, Set Operators, CTEs, Cursors, Subqueries, Constraints, and Identity property.
- Good experience in Ranking Functions, Aggregate Functions, Date Functions, and String Functions.
- Good hands-on experience in developing and implementing packages using Microsoft SQL Server Integration Services (SSIS).
- Good experience in Merge, Merge Join, Union all, Sort, Derived Column, Conditional Split, Multicast, Row Count, Aggregate, Data Conversion, and various other transformations to manipulate data in an SSIS package at the Data Flow level.
- Experience in providing logging, error handling by using event handler, checkpoints, and logging for SSIS packages.
- Experience in deploying the SSIS packages into the integration catalog and scheduling the jobs through SQL Server Agent.
Overview
8
8
years of professional experience
6
6
years of post-secondary education
Work History
Sr Operations Analyst
Syniverse technologies
01.2020 - Current
- Created mapping document in different stages like source, destination and perform data load.
- Involved in creating indexes, views, complex stored procedures, user-defined functions, derived tables and common table expressions (CTEs).
- Created SSIS packages to validate, extract, transform, and load data into SQL server. Worked with integration services for transferring and reviewing data.
- Utilized SSIS to implement the Slowly Changing Transformation (SCD) to maintain historical data.
- Created Event Handlers for the Packages for Error Handling.
- Involved in data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).
- Writing complex SQL queries using joins, subqueries, and retrieving data from different SQL Server Databases, applying business logic, loading into tables, and creating views for end users.
- Created DDL scripts to create database schema and database objects like tables, stored procedures, views, functions, and cursors using T-SQL.
- Developed complex stored procedures, views, and temporary tables as per the requirement.
- Creating queries with the help of Aggregate, Ranking, Date, and String functions.
- Identify the long-running queries, procedures, and perform tuning and optimization on top of these objects.
Customer Operations Specialist
Syniverse technologies
07.2017 - 01.2020
- Responsible for profiling, loading, extraction, validation, and transformation of unstructured data using SQL queries in Oracle SQL Developer and Advanced Excel.
- Generated reports to help management with making key decisions.
- Created client-level reports, scorecards, and dashboards indicating International Roaming data file flow.
- Design, Development, and testing of Inter Operator Tariff based on the client's requirement.
- Validate roaming data files, correcting the files when errors are found in UNIX.
Assistant Software Engineer
Jackfruit Software & Systems Pvt Ltd
02.2017 - 07.2017
- Performed functional, system, smoke, integration, and regression testing.
- Logged the defects in JIRA in order to perform the defect lifecycle.
- Resolved issues by clarifying the basics, investigating, and exploring alternative solutions.
- Involved in defect review meetings, weekly status meetings, and walkthrough, and interacted with business analysts and developers for resolving defects.
Education
Bachelor of Engineering - Electronics And Communications Engineering
Channabasaveshwara Institute of Technology
Tumkur 09.2011 - 02.2016
Pre-University Education - Science Education
Sarvodaya Pre University College
Tumkur 06.2009 - 03.2011
Skills
SQL
MS SQL Server
ETL
SSIS
Oracle SQL Developer
Accomplishments
- Received an award for preparing an SQL query to reduce 70% the time taken for preparing a daily dashboard in 2018.
- Received a Customer Champion award in Aug 2019 for receiving appreciation from multiple customers for taking the responsibility in resolving their issues effectively.
- Received an award in May 2019 for working on a new emergency DCH migration project.
Timeline
Sr Operations Analyst
Syniverse technologies
01.2020 - Current
Customer Operations Specialist
Syniverse technologies
07.2017 - 01.2020
Assistant Software Engineer
Jackfruit Software & Systems Pvt Ltd
02.2017 - 07.2017
Bachelor of Engineering - Electronics And Communications Engineering
Channabasaveshwara Institute of Technology
09.2011 - 02.2016
Pre-University Education - Science Education
Sarvodaya Pre University College
06.2009 - 03.2011
Similar Profiles
Jacqueline LimJacqueline Lim
Senior Field Marketing Manager - APAC at Syniverse TechnologiesSenior Field Marketing Manager - APAC at Syniverse Technologies
ANAND NOSSAMANAND NOSSAM
SYSTEM ENGINEER at SYNIVERSE TECHNOLOGIESSYSTEM ENGINEER at SYNIVERSE TECHNOLOGIES
Tabassum BanuTabassum Banu
Billing Specialist at Syniverse Technologies Services India Pvt LtdBilling Specialist at Syniverse Technologies Services India Pvt Ltd