Tarun Kumar

About Tarun Kumar

Currently working with Ernst and Young as Project Lead having almost 9 years of IT…

Experience

1. Lead Dotnet Consultant

   EY

   Feb 2016 — Present · Dallas-Fort Worth, TX, US

   Worked on Web application “CompassView” using.net framework and MVC 5 architecture. Used ADO.NET and data objects such as Data Adapter, Dataset, Data Tables• Extensive experience on Database design, Modeling and Database maintenance in MS SQL Server environment• Implemented various operations like Import and Export of bulk data, backup and restoring databases in SQL Server.• Performed around 150 databases migrations from one server to another server. Coordinated with operations team in migrating the databases as per there schedule.• Implemented a User Interface \"LYNX\" using C# and SQL Server for the operations team to enable the loading of payroll files and have a visual representation to track the loading operations. Improved the efficiency of operations team by 70%.• Created a desktop application “SUPERREPORTS” using C# and SQL SERVER to generate 4 different types of reports for 150 clients and performed various formatting on reports handled by the application using Epplus plugin.• Designed and Developed ETL - SSIS packages to automate the loading of multiple payroll files in SQL serverdatabases, to gather, process and analyze payroll data for various clients.• Developed Sql agent jobs, proxies and environment variables in MS Sql Server to initiate SSIS packages.• Used Team foundation Server (TFS) and VSTS for version control and Shelve pending changes of the source codealong with the maintenance of the builds and the relevant documents of the same.• Design and Developed team portal on Sharepoint 2013. Developed various pages like Issue tracker, log tracker, Projectsetup etc.• Created Technical documents, Business requirement documents (BRD) and Functional requirement documents(FRD).• Responsible for maintaining all four environments – DEV, QA, UAT and PRODUCTION.• Worked on Tableau Desktop for data visualization, Reporting and Analysis, Cross Map, Scatter Plots, Geographic Map,Pie Charts and Bar Charts, Page Trails and Density Chart.

Education

• The University of Texas at Dallas - School of Management

  Master's Degree

  2014 — 2015

• Guru Gobind Singh Indraprastha University

  Bachelor's Degree

  2006 — 2010

Skills

• Data Analysis
• Crystal Reports
• Html
• Operations Management
• Python
• Java Enterprise Edition
• Mysql
• Jdbc
• Jsf
• Ssrs
• Spreadsheets
• Java
• Databases
• Ms Excel Pivot Tables
• Sas E-Miner
• Tableau
• Sql
• Microsoft Project
• Hibernate
• Microsoft Sql Server
• Jira
• Servlets
• Software Project Management
• Javabeans
• Ssas 2008
• Sdlc
• Sql Server Integration Services (Ssis)
• Struts
• Jsp
• Core Java
• Sap Netweaver
• Business Intelligence
• Agile Methodologies
• Google Analytics
• Software Development Life Cycle (Sdlc)
• Javascript
• J2ee Application Development
• V Lookups
• Pl/Sql
• R