Tarun Kumar
New Delhi
Summary
Seeking a position to utilize my skills and abilities in the Information Technology Industry that offers professional growth with being resourceful, innovative and flexible.
9.6 years of professional experience in working with Database, created SQL scripts, stored procedures, functions, views, triggers etc using MS SQL Server. Extensive experience in creating Microsoft SSRS reports for data visualization using report builder 3.0. More than 6 years of experience in SSIS ETL. 2 Years of professional experience in Azure Data Factory. Basic Knowledge of Azure Data Fundamentals like Azure Data Lakes and Azure Data Bricks. Hands on experience on working with Control-M for creating and managing work flows. Data modelling, Reports, Dashboard Creation knowledge on Power BI. Basic knowledge of Python (Numpy & Panda libraries). Identified and reported any data issues, conducted detailed weekly reports. Experience in Kentico 7 CMS. Experienced in Deployment (Site hosting, Migrations, Script Generations, Code Management). Good Analytical and Debugging skills.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Develop Analyst 1
Inforica (SEB group)
Gurugram
11.2017 - 12.2021
Software Developer
Aon India Pvt Ltd
Gurugram
02.2014 - 03.2017
Module Lead
Mphasis India Pvt Ltd
Noida
Education
Skills
- Windows 7/8/10
- Visual Studio
- SSMS 2018
- Report Builder 30
- ETL tools (SSIS)
- MS SQL 2012
- Power BI Desktop
- Azure Portal
- SQL
- C#
- Python
- MSSQL Server
- HTML
- CSS
- Agile Framework
- Atlassian Jira
- Visual Studio 2017
- Visual Studio Code
- MS SQL Server Management Studio
- SQL Server Data Tools 2012
- Python 30
- PYCharm
Certification
- Microsoft Certified in Azure Data Fundamentals, 08/2021
- Certified in Power BI Desktop through Coursera, 09/2021
- Basic SQL Server from IIHT, 05/2014
- Python for Data Science, In progress
Personal Information
- Father's Name: Roshan Lal
- Marital Status: Single
Projects
Flex Plus, 20, SQL Server, SSRS, SSIS, C#, Much like Flex System 5 it is also a web based solution which enables companies to manage health benefits they offer to their employees through several features mentioned below. It is based on the technologies like ASP.NET, ADO.NET, C#.NET, JavaScript, Ajax, MSSQL Server etc. Simple data entry using web forms, radio buttons, and drop-down. Built-in mandatory compliance checks in accordance with legislation. Exports: Premium, Payroll and Carrier. Reporting with the help of Custom Report builder and standard reports., Software Developer Developed all the reports for various clients using report builder 3.0 and MS SQL Server. Report logic written in Stored Procedures. Various types of SSRS reports generated – Drill Down, Drill Through and Matrix Reports. Data Transformation and Load through SSIS using SSDT 2012. Delivered Power BI reporting solutions in Power BI. Used ADO.NET objects such as Data Adapter, Data Reader, Dataset and Data List for reading/updating records in the database. 5500 Reporting Project, 12, GCP, Control M, SQL Server, SSIS, The objective of this project was to pull the investment transactional data from Google cloud and load that data to the newly created SQL database tables. Then the loaded data was consumed inside the crystal reports which were sent to Internal Revenue Service (IRS) of United States. Key Highlights: SQL Agent Jobs were used to execute the SSIS packages on monthly basis SQL Agent jobs in turn was called by control M jobs to load the monthly data Three types of reports were generated – Monthly, Quarterly and Yearly. Generated reports were placed in a SFTP server in encrypted format. Detailed transactional reports were generated, Dev Lead Closely working with client to understand the requirement and convey same to the team. Involved in the creation of store procedures, functions and various other objects in MS SQL Server. Planning and development from the scratch. Merlin UK ADP, 8, ADF, Azure SQL, SSIS, Previous payroll integration from Cornerstone(CSOD) to ADP had been causing numerous errors in the ADP system. These errors require manual investigation and correction on weekly basis, leading to increased inefficiency. With approximately 6000 employee records on weekly basis, the process had become arduous and highly inefficient. We developed the middleware solution for data transformation so that the entire manual intervention could be avoided and the entire flow could be carried out without errors and with high efficiency. The objective of this project was to pull the employees HR data from CSV files present in SFTP server and load it to Azure SQL database after doing some transformation and calculations. Then the loaded data was consumed to generate payroll reports for fixed and variable employees. These payroll files are then sent to ADP for payroll processing. Key Highlights: Data was automatically loaded on weekly basis using scheduled adf triggers. Various validation checks were included in the data flow to match up the required criteria for payroll processing. Detailed payroll reports were generated based on all the deductions and transactions., Technical Team Lead Closely working with client to understand the requirement and convey same to the team. Complete involvement as a developer along with team handling.
Timeline
Develop Analyst 1
Inforica (SEB group)
11.2017 - 12.2021
Software Developer
Aon India Pvt Ltd
02.2014 - 03.2017
Module Lead
Mphasis India Pvt Ltd
Similar Profiles
Sowjanya JSowjanya J
Linux Administrator at InforicaLinux Administrator at Inforica
Alice AhlstromAlice Ahlstrom
Communications Officer, Private Wealth Management & Family Office at SEB GroupCommunications Officer, Private Wealth Management & Family Office at SEB Group
Kush PatelKush Patel
Marketing Associate at SEB Group of Companies Inc.Marketing Associate at SEB Group of Companies Inc.
NIRPREET KAURNIRPREET KAUR
Partner at Lex Jurists, Advocates & SolicitorsPartner at Lex Jurists, Advocates & Solicitors
Deepanshu AroraDeepanshu Arora
Deputy Manager at Saatvik Green Energy LimitedDeputy Manager at Saatvik Green Energy Limited