Karanbeer Singh Email & Phone Number

● Created custom database objects and procedures from identified user needs. Helped maintain production servers and databases.● 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.● Created 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.● Helped gather and implement business requirements to design new Databases, tables, stored procedures, views, functions and ETL processes for import and export reporting.● Developed and managed SSIS packages and Azure DevOps pipelines. Migrated and upgraded SSIS Packages from 2012 to 2019.● Performed regression testing of all SQL server agent jobs in DEV, QA and UAT environments during server migration from 2012 to 2022.● 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.● Updated business processes and requirements to ensure best practices are maintained.

United States

● Created jobs to extract, transform and load data into target database tables using SSIS.● Created new table structures, added indexes, Identity, primary and foreign keys, developed stored procedures, view and functions according to business requirements.● Performed SQL query optimization, and database optimization by implementing new clustered and non-clustered indexes, primary and foreign keys.● Prepared technical documentation for different processes and implemented the new proceduresand process for ClaimsBatch project.● 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 sourceto staging and to Destination server tables.

Richmond, Virginia, United States

● Analyzed SQL queries to identify opportunities for improvements and created technical solutions.● Documented analysis results and identified performance improvement solutions.● Developed and maintained custom database objects, T-SQL queries, views, and stored procedures in multi-database environment and delivered application support.● Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.● Designed and developed customized extract, transform and load (ETL) applications per clientspecifications using SSIS.

Hillsborough, New Jersey, United States

● Provide Dispatch support, set up inbound and outbound shipments using LMS and JDE.● Collaborated with leadership to identify and resolve invoicing and shipping complications.● Developed KAN BAN procedures resulting in increased efficiency to manage shipping activities.● Implemented inventory locations and bar code systems for 500+ bays and racks.● Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.