Karxxxxxx - SQL SSIS Developet Job Profile in Raritan, NJ

Karanbeer “KB” Singh SQL Database Developer Flemington, NJ

SQL SSIS Developer and Certified Salesforce Administrator with 6 years of database management experience excited to leverage SQL Server understanding into a new role. Experience with database and CRM best practices including database design, change management, and object relations.

? Created optimal technical solutions to user needs with in-depth system analysis.

? Supported project enabling delivery efficiencies and technical resolution.

? Exceptional understanding of organizational security strategies.

? Fluent in English, Hindi, and Punjabi

Credentials

? Salesforce Certified Administrator

? Salesforce Certified Associate

? SQL Server Developer

Skills

Salesforce

? Flows and Automations

? Page Layouts and Lightning Components

? Security: roles, profiles, public groups

? Reports & Dashboards

? Validation Rules

? Data Loader & Data Import Wizard

? MS SQL Server

? T-SQL

? ETL SQL Server Integration Services (ssis)

? Project Management

? Data Warehouse

? Data Visualizations

? Project coordination

Experience

MS SQL Server/SSIS Developer 2017 – 2024

Solix Inc. | Parsippany, NJ

? Created custom database objects and procedures from identified user needs.

? Deployed change sets from QA and UAT environments to production while following best practices.

? Collaborated with end users to identify bugs to resolve support tickets.

? Create SSIS packages and setup jobs for data Import and export to and from text and csv files using SSIS packages and SQL import Data Wizard.

? Used Redgate Data compare to obfuscate data in test environments, compare databases and generate SQL scripts to migrate to production.

? Employed data security strategies with user roles and profiles to maintain proper user access.

? Update business processes and requirements to ensure best practices are maintained.

SSIS Developer (REMOTE) 2022 – 2023

USI insurance Group

? Created jobs to extract, transform and load data into target database tables using SSIS.

? Prepared technical documentation for different processes and implemented the new procedures and process.

? Worked extensively on complete data mapping of all source systems as part of data analysis.

? Worked on data archival process by transforming data crossing different platforms.

? Created ETL extraction strategies as part of development plan to extract and load data from source to staging and to Destination server tables.