Summary
Overview
Work History
Education
Skills
Disclaimer
Personal Qualifications
Timeline
Generic

Rakesh Sunagar

Member Of Technical Staff
Bengaluru

Summary

Aspiring to have the best position in the Information Technology industry with qualitative services by working with employers and professionals whose environment and guidance allow me to build the best path for my career.

Having around 12+ years of Professional experience in IT industry, involved in MSBI projects with extensive usage of SSIS and SQL Server 2008/2012/2014. Excellent experience in Designing Database Objects like Tables, Constraints, Views. Extensive database programming Experience in writing T-SQL Stored procedures, User Defined Functions, Constraints, and using various DDL and DML commands. Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check and Unique) and generating Transaction SQL (T-SQL) Queries and Sub queries. Experience in the implementation of Common Table Expressions (CTE). Extensive knowledge in the implementation of Rank functions and Cursors. Experience in the implementation of Temporary Tables and Table variables. Skilled in creating subsets of data using CA BROADCOM tool and extensive database programming with T-SQL. Involved in Pre-PROD and Post-PROD data validation T-SQL Query. Preparation of mapping documents for all DB objects. Experienced in Data Analysis, Data Validation, and identifying data mismatch using SQL queries.

Overview

13
13
years of professional experience

Work History

Software Engineer III

Oracle-Cerner Healthcare Solutions Bangalore
02.2022 - Current
  • Project: TDG/Test Data Management
  • Description: Test Data Generation (TDG) is a critical phase in the software development lifecycle that involves creating, managing, and provisioning data sets for testing purposes.
  • Responsibilities: - Develop new patient concept as per fed scale healthcare requirement. - Support and create a n number of clone patients to target testing domain. - Creating a master subset of source patient using CA Broadcom tool. - Validate the data from source to target and clone the data. - Providing technical/functional support to various internal/external teams.
  • Environment: Sql Server, Oracle 11, SSIS, Subset, Datamaker, Ard-designer, Javelin

Software Engineer

Genpact Bangalore
06.2019 - 02.2022
  • Project: Data Intake/PDM
  • Description: Development and maintenance of applications used in web solutions
  • Processing tickets from Version one
  • Extraction of historic data from the warehouse for different Partners, migration of Data from one source another, handling the data modifications.
  • Responsibilities: - Develop new modules as per client requirement. - Support and debug SQL scripts and data objects such as procedures. - Enhancements of new DB objects and schema change of existing objects. - Creating SSIS package to migrate the data. - Providing technical/functional support to various internal/external teams, Stakeholder's and clients.
  • Environment: Sql Server, SSIS

Software Analyst

CENDUIT (INDIA) SERVICES PVT LTD Bangalore
03.2014 - 04.2019
  • Project: Clinical-Trails
  • Description: Novartis International AG is a Swiss multinational pharmaceutical company based in Basel, and Novartis manufactures Drugs and doing the clinical trials for the patients.
  • Responsibilities: - Analysis of existing SSIS packages, SSRS reports, SQL DB objects (SP, Functions, Tables, Views, etc.) and SQL agent jobs. - Provide innovative solutions to complex business problems. - Responsible for writing code and stored procedure to implement project functionalities. - Responsible for Providing data to users for data analysis and also debugging the any issues as reported and providing resolution in given SLA. - Responsible for Unit testing, Integration testing, and Bug fixing.
  • Environment: VB.Net, Sql Server, MS-Excel

Sr. Software Engineer

CENDUIT (INDIA) SERVICES PVT LTD Bangalore
08.2011 - 04.2019
  • Project: DER/Integration
  • Description: Merck Serono (EMD Serono in the United States and Canada) is a pharmaceutical company headquartered in Darmstadt, Germany.
  • Responsibilities: - Extracting the data from the database and providing solutions to clients based on the requirements. - Preparing technical information guideline document for each study, which helps PM to raise tickets by providing required information, and for supporting team to perform updates. - Working on Data changes, study changes through requests / through back end. - Creating adhoc reports to categorize the numerous patient details. - Provide innovative solutions to complex business problems. - Responsible for writing code and stored procedure to implement project functionalities. - Create SSIS package to integrate the data and verify the required data present in the database. - Responsible for Unit testing, Integration testing, and Bug fixing. - Study Configuration and go-live activities.
  • Environment: SSIS, MS-excel, Sql Server

Education

Bachelor Of Engineering - Information Science

Kalpataru Institute of Technology
Tiptur Karnataka
04.2009

Skills

Red-Gate, V1 (Version One), Git, Subset, Datamaker, Javelin, and ARD designer

Disclaimer

I solemnly do hereby declare that all statements made here are true to the best of my knowledge and belief.

Personal Qualifications

Bachelor of Engineering, VTU University, KIT (ISE)

Timeline

Software Engineer III

Oracle-Cerner Healthcare Solutions Bangalore
02.2022 - Current

Software Engineer

Genpact Bangalore
06.2019 - 02.2022

Software Analyst

CENDUIT (INDIA) SERVICES PVT LTD Bangalore
03.2014 - 04.2019

Sr. Software Engineer

CENDUIT (INDIA) SERVICES PVT LTD Bangalore
08.2011 - 04.2019

Bachelor Of Engineering - Information Science

Kalpataru Institute of Technology
Rakesh SunagarMember Of Technical Staff