Vijay Battina Email and Phone Number

Subject Matter Expert in designing and developing data pipelines and proficient in:ETL Microsoft SQL ServerOracleCI/CD using JenkinsGITWorkdayJIRATableauPower BIPythonVB.NETAWSGCP

Migrated SSIS Packages, Databases from SQL 2005 to SQL 2014, and Migrated Packages to SSIS 2015 which also included re-writing many scripts/ logics in Visual Studio 2015.Thorough knowledge of backup & restore to establish disaster recovery policies and procedures.Database restores, database purges, systems analysis, application support, network support, FTP support, EDI support, quality assurance support, managed documentation for DBA department, multi-tier database, and application support for the various support departments throughout the company. Set up processes and routines to automate tasks for administrative departments, utilizing EX functions, and MS SQL Server Transact-SQL.Created and still maintaining more than 150+ packages in SSIS which includes pulling/modifying data that comes from Oracle to integrate it with our accounting system Microsoft Dynamics GP.Providing support for Accounting Team and customizing many billing routines are part of day-to-day activities.Automated many Daily/Monthly reports from Oracle Database.Part of developing a Customer Portal for the company (To help the Customers/Dealers to sign up and pay the invoices online).Providing support for Microsoft Dynamics GP, Preparing 3000 plus Invoices per month, De-duping raw data into billable data, calculating taxes for the invoices using Avalara.