Mayur V. Email & Phone Number

Primary responsibilities includes to work with major US state tax agencies as a 'Data/Information Architect' and “Conversion Lead” on implementing agency wide Integrated Tax Systems. As Principal Solution Engineer Lead, closely working with client business analysts, analyzing the business requirements to align technical design and provide the best solution by leading a team to turn the data system into a product for the Revenue Premier suite from RSI.Responsibilities: • Design, develop, test, document, analyze, and support critical and complex software applications for the purpose of extracting, transforming a loading legacy data from mainframe file and other file types into relational database tables. This includes new development, modifications to existing code, and defect fixes.• Taking technical ownership of many aspects of the product systems including: taxpayer accounting, revenue accounting, financial transaction processing, forms processing, registration, demographics management, collections, billing, and refunds.• Analyze legacy data and create mappings into modernized database tables, including documenting business rules needed to transform legacy data into the appropriate table entry.• Modifications to existing code and defect fixes: Deliver complete and thorough fixes to reported defects in the conversion code base. This includes drawing on a solid understanding of RPTP and software development principles to deliver a comprehensive fix that avoids unforeseen problems with other components by developing solution using MS SQL Server, SSIS, SSRS and PowerBI.• Support production data migration from legacy systems to Cloud based conversion environment, and extract, transform and load data across data tables into the RPTP database tables.• Often guide client and team members (onsite - offshore co-ordination) with approaches & solutions in terms of converting existence system data to RSI integrated tax processing system.

Atlanta, Georgia, United States

• Primarily responsible for the development of reporting applications for the Global Procurement function and managed the development of a global spend datamart combining information for disparate accounts payable and receivable systems.• Developed complex SQL, T-SQL, Stored Procedures, Functions, Views, Triggers, Indexes and Performance Tuning in MS SQL Server environment.• Developed MS BI Stack (SSIS, SSRS, SSAS) with Visual Studio 2008-2019.• Designed ETL/ELT Developer utilizing SSIS, T-SQL (Bulk Insert), bulk copy program utility (bcp), SSMS Import/Export Wizard.• Developed Tabular and OLAP cubes in SSAS supporting KPI and multidimensional data mining.• Implemented side by side migration and in-place upgrade of MS SQL SERVER 2008/2012/2014 to 2016/2017/2019.• MS SQL Server 2008R2-2019 Database Administration tasks including installation, auditing, database design, creation, normalization, partitioning and optimization, backup, restore, replication, scheduling and clustering.• Designed incremental loads utilizing T-SQL with XML and hash bytes, and/or in SSIS through Control Table.• Performed High Availability (HA) and Disaster Recovery (DR) options for SQL Server.• Data Conversion, Data Migration and Data Validation using SSIS and DTS services across different databases like Oracle, IBM DB2, MS Access and flat file.• Managed Oracle 11g and 12c database.• Developed Power BI/Tableau reports and dashboards to collaborate, publish and share visual reports with both internal and external stakeholders and clients.

Master'S Degree, Computer And Information Systems

Master'S Degree, Business Administration And Management, General

Master'S Degree, Health/Health Care Administration/Management