Santha K. Kaliappan

Azure Data Architect

US CITIZEN

SECURITY CLEARANCE: CLEARABLE

Aldie, VA 20105

703-***-****

adh1i9@r.postjobfree.com

Education: MCA (Master’s in Computer Applications)

Bharathiar University

BSc Mathematics

Bharathiar University

Senior Azure Database Architect with over 18 years of professional experience in database architecture, design and development of web based and client server applications with experience in all stages of software development life cycle. Experienced in providing technical guidance and direction in defining the data architecture strategy for individual projects and the entire organization.

Works with senior management, technical and client teams to determine data requirements and best practices for advance data manipulation, storage, and analytics strategies. Delivers data management visions, goals, priorities, design principles, and operating policies in support of the business goals of the organization.

Hands on experience and deep interest in Azure non-relational data solutions such as Azure Data Factory, Azure Cosmos DB, Azure Machine Learning, Large-Scale Data Processing with Azure Data Lake Storage, Data Streaming Solution with Azure Streaming Analytics, Azure Synapse Analytics and Data engineering with Azure Databricks, Big Data Tools (Hadoop), Spark and Data Science languages (R, Python, Scala).

Azure hands-on experience & managing technical teams/projects, Azure cloud IaaS, PaaS Architect, Design, engineering & Solid understanding of native Cloud architecture/On-Prem networking, migrating On-premises database to Azure SQL Database, SQL Managed instance, SQL Elastic pool on Azure & SQL server in Azure VM. Managing Azure resource groups, subscriptions, Azure blob, File Storage, Vnet, subnet, load balancing & azure active directory users & groups.

Responsible for providing leadership in Database Administration to all cross functions in the department as a Subject matter Expert (SME). Solid experience translating business requirements into conceptual, logical, and physical data models. Worked closely with system architects, development teams, business analysts to deploy MDM projects using SQL Server Master Data Services.

Led a team of database architects in successfully migrating several projects from DB2 to SQL Server. Involved from the project initiation phase through design, development, and deployment of SQL Server database in production and part of the maintenance team. Involved in setting up Informatica’s AI-powered Enterprise Data Catalog to deliver automated, granular end-to-end lineage including business glossaries.

Has extensive hands on experience using SQL Server in Azure SQL, SQL Server 2019/2016, and all versions until 6.5, Oracle versions from 12c to 9i and several other databases in OLTP and Data Warehousing.

Has vast experience in management and implementation of database models, data flow diagrams, database schematics, database scripts, SSDT, TFS Database Projects, DacPacs and data standards to support a robust data management infrastructure, Extraction/ Transformation and Load (ETL) strategy, design and implementation. Always provides guidance and work leadership to less-experienced staff members. Has experience in large-scale (multi-terabyte), scalable, highly available and reliable database architectures.

SKILL SETS

Database: Microsoft SQL Server Versions 2019/2016/2014/2012/2008/2005/2000/7.0/6.5

Oracle 10g/9i/8.x/7.x, Azure SQL, Mongo DB, MS Access

Languages: C#, C++, TSQL, SQL * Plus, PL/SQL, PowerShell, Python, XML, JSON, XQuery, XPath, Shell Scripting

Development Methods: Agile, Scrum, Iterative, Rational Unified Process

Big Data Tools: Hadoop-HDFS, Spark, R, Scala

Web Technologies: ASP.NET, VB.NET, WebAPI, REST API, WCF, SOAP

Azure Data Platform: Azure Cosmos DB, Azure Data Lake (ADLS), Data Factory (ADF), HDInsight/Databricks, Azure Machine Learning, Auto ML, NoSQL, Azure Synapse, Kafka, Azure Stream Analytics, Power BI

Cloud Platforms: Azure (PaaS & IaaS)

Web Client Technologies: HTML5, CSS, JavaScript

Portals & Collaboration: SharePoint

Tools: Visual Studio, VS Code, GitHub, Team Foundation Server, NuGet, Quest Software Tools (TOAD), SQL * Loader, BCP, Visual Source Safe (VSS), Visual Interdev, Erwin, PCAnywhere, Crystal Reports 9.0/8.5/8.0/4.5, Visio, Rational Rose, FoxPro, Clipper, SSIS, SSRS, Business Objects, SQL Server Master Data Services, Informatica

Microsoft Office: Word, Excel, Visio, PowerPoint, OneNote, Outlook, Skype

Employment: Applied Information Sciences 2010 – Present

Cascades Technologies Inc 2007 – 2010

NIS Solutions Inc 2002 – 2007

Wrenchead Inc 2000 – 2002

Various clients 1999 – 2000

PROFESSIONAL EXPERIENCE

Applied Information Sciences Inc., December 2010 - Present

Client: Geico Insurance – December 2010 to Present

Azure Data Architect

Hands on experience with Azure cloud tools including Azure Databricks, Azure Synapse, Machine Learning, Data Lake Factory, and Azure Blob storage.

Azure hands-on experience & managing technical teams/projects, Azure cloud IaaS, PaaS Architect, Design, engineering & Solid understanding of native Cloud architecture/On-Prem networking, migrating On-premises database to Azure SQL Database, SQL Managed instance, SQL Elastic pool on Azure & SQL server in Azure VM. Managing Azure resource groups, subscriptions, Azure blob, File Storage, Vnet, subnet, load balancing & azure active directory users & groups.

Designed Azure ML predictive analytic model with images from cars that are stored in Azure data lake Storage.

Used Azure Data Factory's copy data tool to ingest data from more than 10 data sources from on premise / on cloud to prep, cleanse, and transformed the data based on business rules and stored the data in SQL Server for consumption using Power BI and other reporting tools.

Developed/Deployed/Scheduled multiple Data Factory pipelines based on business needs for Sales and Billing teams

Succeeded in Responsible for consistent 40% SQL query performance improvement in a production environment going with full countrywide volume in few months. This is accomplished with combination of changes in queries and table level index modifications. Tables reduced in size from 2 TB to 800GB due to dropped indices as part of this performance tuning effort.

Principal database architect in the migration of DB2 Mainframe databases to SQL Server for multiple applications and successfully deployed in production.

Used Query Store to get production query statistics to make educated decisions to improve performance.

Architected data archiving solution to handle high data volume and improve application performance through SQL Server Partitioning as needed

Involved in setting up Informatica’s AI-powered Enterprise Data Catalog to deliver automated, granular end-to-end lineage including business glossaries

Designed, Developed, Deployed and Scheduled SSIS Packages for multiple requirements for Auto and Cycle New Business projects. Involved in Troubleshooting and Optimizing SSIS package performance.

Involved in the migration of on-premises database to Microsoft Azure Cloud Infrastructure as a service model.

Manage SQL Server databases in Azure-IAAS and helped setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers

Worked with analysts, SMEs, and other DBAs in Legacy Database Analysis and instrumental in the creation of new database design.

Involved in Detail Database analysis and managed data mapping to legacy systems

Worked heavily in Team Foundation Server, SQL Server Data Tools and Visual Studio database projects

Principal architect in the design of data conversion of client database

Worked closely with developers in the development of data map user interface

Worked on SQL Server versions 2008 R2, 2010, 2012,2016 and 2019, Visual Studio version from 2010 until 2017, Visual Studio Online, GitHub, Team Foundation Server - Database Projects, Microsoft Visio, SSIS and SSRS.

Cascades Technologies Inc., January 2007 – November 2010

Client: NIH- National Institute of Allergy and Infectious Disease (NIAID)-Division of Microbiology and Infectious Disease (DMID) – January 2007 to November 2010

Senior Database Administrator

Created many complex Stored Procedures, Functions, Views, and tables as per client requirement.

Used SQLXML to load data from XML files to SQL Server 2005/2000 tables based on XML schema.

Worked with ASP.NET, VB.NET, C# and created web services to interact with external systems

Implemented SQL Server 2005 Full Text Index for robust search functionality.

Client: American Type Culture Collection (ATCC) – March 2009 to November 2010

Senior Database Administrator

Database Creation/Administration, Server Installation, Development and Production Support

Involved in System Development Life Cycle of this project.

Worked with SQL Server 2005, ASP.NET, VB.NET, C#, JavaScript, to help creating web pages

Created many complex Stored Procedures, Functions, Views and tables as per client requirement.

Used SQLXML to load data from XML files to SQL Server 2005 tables based on XML schema.

Responsible for loading the XML data from the client and providing the data analysis.

Worked as a core database architect to provide extensive search capabilities using SQL Server 2005 Full Text Index functionality.

NIS Solutions, March 2002 – January 2007

Client: Housing and Urban Development (HUD), Washington DC - July 2003 – January 2007

Project Lead / Senior DBA

Involved in System Development Life Cycle of this project.

Lead a Team of size 5.

Database Creation/Administration, Server Installation, Development and Production Support

Worked with Oracle 10g, ASP.NET, VB.NET, C#, JavaScript, to create intranet and web pages

Created PL/SQL packages, procedures, and functions as per requirement

Created complex reports using Crystal Reports Enterprise Server / SQL Server 2000 for all departments by combining various sources of data like Microsoft Access, Microsoft SQL Server, and Oracle.

Implemented a .NET application with C# and MS SQL Server 2000/2005 on the back end

Client: Naval Sea Systems Command, NAVSEA-Washington DC - April 2003 – June 2003

Project Lead / Senior DBA

Server Installation, Database Administration, Production and Development Support

Creation of Oracle Schema, Users and maintaining the health of Oracle 9i / 8i Servers

Creating Tables, Views, Stored Procedures, Functions, and Indexes

Import / Export Oracle Schema’s between Servers, Used TOAD for managing Oracle DB

Client: Newark Housing Authority, Newark, NJ - March 2002 – March 2003

Senior DBA / Senior Programmer Analyst / Team Lead

Lead a Team Size of 3 Database Administrators / Developers

Used Replication Server in SQL Server 2000 for distributing data and Stored Procedures

Experience in configuring SQLMAIL and managed SQL Databases in Cluster Servers

Involved in cleansing the data warehouse data from legacy applications such as Clipper and Data Flex

Created complex reports using Crystal Reports Enterprise Server / SQL Server 2000 by combining various sources of data like Clipper Files, Data Flex data files, Microsoft Access and Spread Sheets

Created many Data Transformation Services (DTS) packages and schedule those packages as jobs

Wrenchead.com, NY Oct 2000 – Feb2002

Senior DBA

Used Replication Server in SQL Server 2000 for distributing data and Stored Procedures. Implemented replication between the databases on the servers connected by LANs/Internet.

Coded many Stored Procedures / Triggers / Functions in SQL Server 2000 / 7.0

Configured SQL Mail successfully in all servers including Cluster Servers.

Created many Data Transformation Services (DTS) packages along with VBScript & Visual Basic

Worked with NetIQ to manage Fail Over Clustering in Windows NT

Delivered SQL Server data in different platforms including SQL Server, DB2 in AS/400, and PAC Files.

South West Group Inc, NY September 1999 – September 2000. Senior DBA / Senior Programmer Analyst Southern Export Services, GA February 1999 - August 1999. Programmer Analyst / DBA

Contact this candidate