• Key Role in ERP Migration from AX 2012 on Prem to AX Dynamics 365• Enablement of Dynamics 365 Data Lake sync• Design bring the source data from D365 to Data Lake to on Prem database using Azure Data factory• Sales and Inventory DataMart Design and Development for both Dynamics AX and Dynamics 365• Support in the migration for open orders from AX2012 to Dynamics 365 with respect to the ETL pipeline and the reporting• Experience deploying SQL Server Instances to AWS Cloud Services• Experience Administrating Data Replication from on Prem to Cloud using 3rd Party tools (Attunity/Qlik)• Experience developing and Administrating Amazon Redshift• Experience Deploying and Managing Azure SQL Databases• Experience Deploying and Managing Azure Managed Instances• Manage Offshore Development team• Experience working Azure Cosmos DB• Experience Managing and Replicating multiple VLDBs on Prem and In the Cloud • Experience with SQL Clustering• Manage a Team of 5 Junior and Senior Database Administrators• Manage Environment of nearly 150 SQL Instances, more than 1,000 Databases and monitor almost 5,000 jobs• Experience working with and Managing Power BI• Experience building and Deploying Azure Data Factory Pipelines• Requirement gathering, Research & Development tasks, work estimation, change request management• Design and develop ETL pipelines to source data from Dynamics AX to the Data Mart• Designing and Developing data marts for Sales as well as Inventory Modules• Performance Optimizations for different ETL pipelines• Experience Performance Tuning using Query Store

#AzureDataFactory #AzureDatabricks #AzureSynapse #MicrosoftPowerBI #AzureDatalake #MicrosoftSQLServer #SQLServerReportingServices #SQLServerIntegrationServices #AmazonRedshift #Pipelines #DynamicsAX #Azure #SQLServer2017 #SQLServer2016 #SQLServer2019 #QueryStore

• Extensive experience working in Agile Software Development and its Principals (Daily Scrum\ Sprint Planning\ Sprints\ The Definition of Done \ Sprint Review and Retrospective)• Experienced in OLTP, OLAP, Data Mart/ Warehouse modeling Snow Flake Schema, Star Schema, Hierarchies Key, Dynamic Partitions and Aggregations• 7+ Years Experienced Working with TFS and other version control software.• Worked with TFS and Source Tree to control versions of all files & Folders (Check-out, Check-in)• Involved in the preparation of High level design documents and Low-level design documents.• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS)• Experience with OLAP cubes and Tabular models using SSAS• Design and developed multiple Cubes and Tabular Models.• Created multiple Type 2 mappings for both Dimension as well as Fact tables• Extensive experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2008R2/2012• Knowledgeable with Microsoft SQL Server 2016\SQL Azure • Experience working with Data Visualization Tools Tableau and Power BI.• Experienced with R Programming• Developed Aggregations, partitions and calculated members for cube as per business requirements.• Assisted the clients in developing tools or redesigning existing essential excel tools to be more robust, easier to use and can be deployed across multiple Business Units.• Created various Documents such as Source-to-Target Data Mapping Document, and Unit Test Cases Document.• Supporting daily loads and work with business users to handle rejected data.• Prepared test Scenarios and Test cases and involved in unit testing, system testing and user acceptance testing.• Knowledge of scripting (PowerShell, VB, Batch)

• Implements processes/procedures necessary to maintain the databases and related systems used within the ERP system Microsoft Dynamics AX.• Manages installation, configuration, patching/updating, performance tuning, and backups of ERP databases and application servers• Work involves planning, scheduling, and assigning database projects• Mentors and trains database administrators and application programming staff• Experienced Microsoft Dynamics promoting code through different environments using Model Store Method • Writes and maintains specifications and security policies• Performs database and application monitoring and tuning to ensure databases run at peak performance; troubleshoots performance issues• Experienced in Single Server, and Standard deployment of SSRS • Performance tune the ETL Process using Views, indexes, Hash function and Merge Function • Experienced with Spotlight • Toad for SQL Server 5.8 • SQL Doctor • Help star 2010 • Idera SQL Diagnostic • Red Gate (SQL Compare, SQL Data Compare) • Manage database permissions in accordance with SOX regulations & HR policies • Implement alerts and policies to insure systems are properly monitored • Experience with Transactional Replication • Experience with Database Mirroring • Experience SQL Clustering • Develop and/or help troubleshoot SSRS Reports for Application Team • Experience with performance tuning and query optimization • Database security, backups, and capacity planning • Experience supporting and/or developing SSRS and SSIS

Experience in extraction, transformation and loading (ETL) of data flows using SSIS with complex integration of SQL Server, flat file sources, AS400, and Sybase • Expert in writing T-SQL, working with SSIS(SQL Server Integration Services) data cleansing, data scrubbing and data migration • Expertise in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency • Sound knowledge of SQL server administrative skills including, backups, disaster recovery, database maintenance, user authorizations and database creation. • Created & formatted cross-tab, conditional, drill-down, summary, form, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports • Experience in providing SSRS server level, item level security & accessibility to various reports in multi-user environment • Expert in creating dashboards, scorecards and building reports using Report Portal 3.0 • Exposure to all phases of software development life cycle (SDLC) with in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem solving skills and escalation procedures • Responsible for automation of maintenance jobs, indexes configurations • Administering SQL Server securities, SQL Server automatic e-mail notification. • Managed SQL user logins, database user accounts, server roles, database roles • Designed complex SSIS packages with error handling as well as using various data transformations like conditional split, fuzzy look up, multi cast, column conversion, fuzzy grouping. • Deploying SSRS Reports in Share point 2010 integration environment, allow the business users to interact to those reports and implement securities for sensitive reports • Experience managing multiple instances

• Created numerous simple to complex queries involving self joins, correlated sub queries and XML techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.• Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the importation and exportation of data using XML and SSIS. • Created various reports according to the business requirements. Individually authored, installed, deployed and managed reports using SQL Server 2005 Reporting Services.• Individually designed a Promo Application according to business requirements, and implemented robust stored procedures, functions, and triggers to implement required functionalities.• Developed a backup and recovery plan based on the data availability requirements of Lockwood and on the potential impact of data loss on the business after considering and analyzing the different backup and recovery strategies. • Designed database maintenance plans to set up core maintenance tasks to make sure that the database performs well, is regularly backed up in case of system failure and is checked for inconsistencies. • Employed the Database Engine Tuning Advisor to analyze the performance effects of workloads and implemented its recommendations wherever appropriate. • Used the SQL Server Profiler tool to monitor the performance of SQL Server – particularly to analyze the performance of the stored procedures.• Analyzed different high availability solutions and implemented database mirroring and replication.• As part of a team, established security policy using windows domain accounts and implemented a security strategy to protect against threats and attacks.