Amit Kumar Email & Phone Number

Greater St. Louis

Greater St. Louis

Greater St. Louis

Greater St. Louis

Twinsburg, Ohio, United States

• Involved in creating functional and technical specification documents after gathering requirements from business users.
• Created database objects like tables, views, stored procedures, functions, joins, indexes and triggers in T-SQL based upon the functional specifications.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed complex ETL strategies to pull data from different sources like SQL server, DB2, oracle, and flat files etc and load it to the destination database after using multiple transformations.
• Involved in Data Integration by identifying the information needs within and across functional areas worked various SSIS Tasks like Execute SQL Task, Bulk Insert Task, Data Flow Task, FTP Task, Send Mail task, For Each.
• Writing VB.NET and C# coding in Script task and script component.

Rolla, Missouri, United States

• In-situ part qualification and defect detection mechanism using visual spectrum sensor and statistical process control model
• Statistical Analysis and visualization of Experimental data
• User Interface development for Sensor Application

Mysuru, Karnataka, India

• Experience in writing complex SQL queries to retrieve information from the databases depending on the business requirement.
• Experience in creating new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
• Developed stored procedures, user-defined functions, triggers, indexes, cursors and views in SQL Server, DB2 databases.
• Developed processes, automation of maintenance jobs, tuning SQL Server, data validations, locks and indexes configurations

Bhilai, Chhattisgarh, India

Varanasi, Uttar Pradesh, India