Azure Data Architect
Resume:
Santha K. Kaliappan
Azure Data Architect
US CITIZEN
SECURITY CLEARANCE: CLEARABLE
Aldie, VA 20105
****************@*****.***
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