• Oversaw simultaneous client engagements, providing data architecture guidance and technical leadership for 5–10 customer accounts at a time.• Led the data product migration of many on-premise data warehouses to Snowflake Cloud on Google Cloud, AWS, Azure, ensuring successful migrations supporting PowerBI and Tableau dashboards.• Architected and managed modern data platform loading processes including streaming solutions with Kafka and or Snowpipe, improving operational efficiency by at least 40%.• Setup automated CIS Security Benchmark checks utilizing custom Python solution and alerts for when critical security items occur.• Secured platform with Functional RBAC roles, SSO, Multifactor, PrivateLink and Network policies.• Proactively identified and articulated best practices and improvements to customers on how to best leverage their Cloud Data Platform.• Skillfully navigated complex customer environments and built Epics, Stories, and Tasks in order to mature and improve our customer’s data platform utilizing Servicenow, Azure Devops, or Jira. Delegated to and coached Engineers and ensured successful and timely delivery of these Epics through an Agile release process.• Provided thought leadership by recommending the right technologies and approaches to solving problems that help ensure performance, security, scalability, and user satisfaction.• Extensive experience in providing architectural guidance and operational support across a large user base for a cloud-native data warehouse (Snowflake and Databricks)• Designed and deployed solutions with infrastructure as code solutions using Terraform and or AWS Cloud Formation• Workflow Management and Orchestration through Astronomer Airflow and Azure Data Factory.• Well versed with continuous integration and deployment frameworks with hands-on experience using CI/CD tools like Bitbucket, Github, Flyway, Liquibase, to build pipelines and deployment automation structures using Jenkins, Azure Devops workflows.

• Worked on complex multi-year conversion on-premise Data Warehouse over to Azure Cloud and cloud-based Snowflake and Synapse Datamart.• Designed and implemented data pipelines using Snowflake, Azure Data Factory, and Azure Synapse.• Setup multi-region DR and HA platform for Snowflake Datamart consisting of failover groups, Azure blob storage accounts, integration accounts and Snowpipe on Azure blob storage and queues.• Created Zero copy clones on Snowflake databases and structures, including functional roles and data masking.• Azure provisioning of accounts into Snowflake and setting up of security model using Azure RBAC roles, APIM, and replicated Azure active directory groups into functional/technical Snowflake roles.• Designed and deployed Azure Data Factory for data transformations and ETL.• Utilized GIT, ADO pipelines and GIT repos for testing and deploying Snowflake, Azure Synapse Analytics, Azure Data Factory through Dev, Test, UAT, and Production environments.• Setup and transitioned Microsoft Dynamics 365 financial data and reports from BYOD export utility into Azure Synapse Analytics.• Experience working with Docker and AKS, including containerization of data science forecasting and prediction models with persisted BLOB storage.• Worked with Tableau, Power Bi, and ThoughtSpot Reporting teams to connect to DW warehouses including setting up security and masking.• Performed all Azure DEVOPS code review and pull requests for DATA team (30 developers and engineers)• Designed POCs of SNOWPARK, Databricks, Azure Synapse Analytics for data science and DW teams.• ITIL certification in Change control management

• Provide Leadership and Mentoring for Data Analytic team comprised of DBAs and ETL Developers• Perform reviews, and design (IDP) career development plans for all DBAs and ETL Developers• Design and develop Extract Transfer and Load (ETL) Code to migrate and integrate data from disparate data sources related to specific projects as well as the data warehouse• Manage team code standards, integrity of production code base, and other ETL developers on specific projects; enforce proper source control and re-usability of extract and load code as well as various standard transformations that will apply to all systems• Manage the process of identifying opportunities for new architectural initiatives; make recommendations on increasing scalability and robustness of platforms and solutions within IT• Establish policies and industry leading practices for optimizing data throughput/accessibility; create and maintain business intelligence and data warehousing design principles using industry leading practices

• Hired and groomed Database Team of 4 DBAs and a group of Remote DBAs. • Provide Leadership and Mentoring• Develop and maintain over 128 SQL Servers through all phases of SDLC• Plan, recommend and implement capacity, growth and changes for SQL architecture.• Maintain system resources of database servers to ensure production systems meet high availability requirements.• Ensure that database related hardware enhancements are scheduled and implemented in a timely manner.• Develop, maintain a data archive strategy.• Manage the changes to the architecture in compliance with company Configuration and Change Management SOPs and industry best practices. • Plan, implement, test and document sound backup and recovery procedures.• Monitor and troubleshoot system performance proactively and establish written procedures for incident avoidance.• Ensure all company SOPs and Work Instructions pertaining to data backup and recovery are adhered to.• Provide expert assistance to Sr. / System Developers, to ensure that development efforts do not adversely affect production operations.• Provide assistance, templates, documentation and training in SQL to staff.• Identify and support the resolution of application problems that may affect the SQL environment.• Provide after hours on-call support for critical database issues.• Act as liaison between application programmers and DBMS vendor to report and resolve problems.• Implement and maintain a maintenance plan for the SQL environment.• Develop and manage a suite of utilities that manage, maintain and report SQL Server performance.• Monitor error logs, database and log space, user activity and resource utilization of production environment.• Develop recommendations for data architecture and software/database design• Participate in system requirements definition.• Review/approve new products design for best practices

• Provide primary DBA support for installation, upgrading and maintaining the SQL environments.• Plan, recommend and implement capacity, growth and changes for SQL architecture.• Maintain system resources of database servers to ensure production systems meet high availability requirements.• Ensure that database related hardware enhancements are scheduled and implemented in a timely manner.• Develop, maintain a data archive strategy.• Manage the changes to the architecture in compliance with company Configuration and Change Management SOPs and industry best practices. • Plan, implement, test and document sound backup and recovery procedures.• Monitor and troubleshoot system performance proactively and establish written procedures for incident avoidance.• Ensure all company SOPs and Work Instructions pertaining to data backup and recovery are adhered to• Provide expert assistance to Sr. / System Developers, to ensure that development efforts do not adversely affect production operations.• Provide assistance, templates, documentation and training in SQL to staff.• Identify and support the resolution of application problems that may affect the SQL environment.• Provide after hours on-call support for critical database issues.• Act as liaison between application programmers and DBMS vendor to report and resolve problems.• Implement and maintain a maintenance plan for the SQL environment.• Develop and manage a suite of utilities that manage, maintain and report SQL Server performance.• Monitor error logs, database and log space, user activity and resource utilization of production environment.• Tune environment as required. • Develop recommendations for new product architecture and software/database design• Participate in system requirements definition.• Recommend implementation strategies• Review/approve new products design for best practices

• Provided support for all SQL Servers development through production. • Designed and executed migration for 2 main production databases from SQL Server 2000 to SQL Server 2008 which also included move to new SAN and servers running on Windows 2008 server.• Implemented new code deployment method saving 6 hours per environment/ per release using Red Gate SQL Compare and Data Compare.• Developed data warehouse using SSAS, MDX queries and linked servers to provide seem-less integration into current object oriented architecture.• Installed SSRS and designed reporting structures to satisfy all reporting needs.• Developed trending and Diagnostics platform to monitor production database environments utilizing Idera's Diagnostics Manager.• Developed automated unit testing and baseline mechanism using SSRS, SSAS, and Report Builder 2.• Designed new disaster recovery plan utilizing Idera's SQL Safe.• Re-engineered and performance tuned code to utilize more set based processing and accordance with best practices.• Taught developers to build SSIS packages and the basics of Analysis services so they can start converting DTS packages and start utilizing the power of Analysis services.• Technology used: MS SQL Server 2008/2000, SSAS, SSRS, Report Builder 2.0, SQLSafe, Diagnostics Manager, DMX, Data and schema compare.

• Provided production level support for all SQL Servers and over 150 applications. • Helped setup and coordinate TFS (Team Foundation Server) for all development deployments.• Implemented Idera's Compliance Manager and Idera's SQL Secure to analyze and assist in auditing 33 Production Financial Database servers to become SOX compliant.• Implemented new disaster Recovery strategies utilizing Idera SQLSafe, Double Take and EMC Cloning.• Developed trending and Diagnostics platform to monitor database environment utilizing SQL Sentry Event Manager and Idera's Diagnostics Manager.• Developed SQL 2005 implementation plan and strategy for upgrading SQL Server 2000 servers to SQL Server 2005.• Responsible for moving code from one environment to the next and working with developers to fine tune applications• Responsible for support of MOLAP structures using Analysis Services 2005 and reporting structures in MS EXCEL and Reporting Services 2005.• Developed and deployed SSIS packages.• Developed reporting architecture with Reporting Services 2005• Assisted in the development of ETL Standards and Best Practices Documentation.• Technology used: TFS, Visual Studio DB Pro, MS SQL Server 2005/2000, SQL Safe, Event Manager, Compliance Manager, SQLSecure,Diagnostics Manager, SQL LITESPEED, Transact SQL, Stored Procedures, optimization, Windows 2000/2003 Server, Reporting Services, Analysis Services, Double Take, OLAP, MOLAP, Data Warehousing

• Provided production level support for originally 67 SQL Servers, and 9 Oracle Servers. • Assisted with implementation of the SAN migration to consolidate the number of SQL servers down to 12. • Updated all servers to latest service packs and patches. • Developed Database Standards to ensure developers and programmers were following best practices and good coding standards. • Responsible for the promotion of database objects throughout the different environments. • Set up Reporting Services. • Reorganized architecture of some servers for better performance. • Evaluated backup software and strategies to ensure better availability of backup and recovery procedures. • Performed ORACLE switch over from a WINDOWS based environment to an AIX UNIX based environment while consolidating Oracle servers to 3. • Set up the Oracle database servers and configured each of those servers with alerts, RMAN, and archive log backups. • Automated Oracle startup and shutdown procedures. • Set up ORACLE clients and ORACLE developer installations for developers. • Helped install new Timekeeper server and setup replication for them. • Migrated a server to SQL SERVER 2005. • Helped setup Biztalk SERVER 2004 and worked on performance issues. • Helped performance tune Informatica jobs. • Started on conversion of DW from Microstrategy based data mart to full scale DW utilizing Analysis Services in SQL Server.• Technology used: MS SQL Server 2005/2000, Oracle 9i/10G, Grid Controller, SQL Compare, SQL Safe, SQL Schedule, Diagnostics Manager, SQL LITESPEED, Transact SQL, Stored Procedures, optimization, Windows 2000/2003 Server, Reporting Services, Analysis Services, Triggers, OLAP, Data Warehousing

• Worked with a diverse team of DBA's, analysts, lawyers, and healthcare industry specialists in organizing and structuring data for analysis, which was then used for expert testimony in multi $billion class action lawsuits. • Ran the data centers primarily for the Healthcare/Litigation Divisions. • Developed the Data Acquisition and Management Protocol (DAMP) for which all data is acquired, scrubbed, profiled, and imported into data centers. • Developed Disaster Recovery and off-site data plans for all Healthcare databases and file servers utilizing SQL LITESPEED and Veritas BACKUP EXEC/NETBACKUP used in the BALTIMORE, VIENNA, ATLANTA AND WASHINGTON DC offices. • Responsible for system maintenance and performance tuning of over 500 databases (some of which are 5 TB in size.)• Often called upon for individual tasks in other divisions when performance tuning needs arise• Optimized databases, queries, indexes, execution plans, stored procedures, and various ETL Processes for analysis and data storage. • Partitioned data across SAN volumes as well as individual database filegroups for performance boosts. • Prepared and implemented an upgrade of one server to SQL SERVER 2005 and then analyzed other databases for ideal fit and performance comparisons (Sybase IQ, SQL SERVER 2005, BORLAND INTERBASE.)• Technology used: MS SQL Server 2005/2000, SYBASE IQ, BORLAND INTERBASE, MS Access, ODBC, TCPIP, Transact SQL, Stored Procedures, SQL optimization, Windows 2000/2003 Server, Visio, Crystal Reports, DTS, Triggers,OLAP, Data Warehousing, BCP, SQL LITESPEED, DATIRIS DATA PROFILER, VERITAS BACKUP EXEC/NETBACKUP

• Built first Homeland Security database. • Worked on Government Department of Defense initiatives tracking hardware for Government contracts.