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 Loop Container, Script Task etc.• Writing VB.NET and C# coding in Script task and script component.• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from source systems.• Migration of DTS package to SSIS package• Used SQL Profiler to optimize existing and newly written Stored Procedures• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.• Deployed SSIS package on the server and scheduled the packages using SQL Server Agent Services.• Providing support for scheduled ETL packages and deployed reports on rotation basis• Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports using Crystal RS. • Scheduled the monthly Reports/weekly reports/daily reports Based on user Requirements

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• Worked on Performance tuning of ETL transformations, data validations and Stored Procedures• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS.• Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, pie chart reports, drill down, drill through etc. Using SSRS based on Relational and OLAP databases.• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server and scheduled the monthly/weekly/daily reports to run automatically and send the reports via email.• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis ,design, creation of mapping documents, specification writing, development, testing, and implementation.• Prepare KT (Knowledge Transition) sessions. Guide and mentor newly joined members to understand functional requirements and technical aspects

Bhilai, Chhattisgarh, India

Varanasi, Uttar Pradesh, India