Senior Database & BI Manager\Architect with a solid 25 years of strong Business/Solutions Analyst & IT experience as a Manager, Consultant & executive. Extensive experience in Leading and Coordinating multiple complex Database projects including Cloud Migrations, Architecting & Managing Cloud Architectures & Configurations, in addition to Domestic and Global “go-live” implementation of Cloud Hybrid Models. Also have varied experience as a Business Intelligence Manager in Building Data Warehouses and Implementing Report Suites & Functionality. I have experience in guiding teams in Design, Redesign, Re-engineering of cutting-edge DB solutions, driving greater efficiencies, engagement & bottom-line. Skilled at coordinating and managing projects through effective communication and strong follow-through. Served as the Liaison between Technical Teams and User Communities to ensure requirements are appropriately gathered and implemented. Operationally skilled at building strong technical teams and improving processes, compliance governance, support procedures, and business metrics that will increase the efficiency of an organization while identifying areas of organizational strategy, financial efficiency, and architectural improvements.

Core competencies include: - Architecting & Implementing a Data Analytical Platform (DAP), Azure & AWS Cloud Computing & Technologies, SQL Server & Oracle DBMS & Management, Business Intelligence & Data Warehousing, Strategic Cloud Initiative Migration Planning, Business Process Optimization, Technology Strategy & Analytics, Process Redesign & Change Management, Technical Operations Teams Management.

PROFESSIONAL EXPERIENCE

NGL Energy Partners, Denver, CO

Senior DB Solutions Manager/ DB Solutions Architect 2/2020 - Present

In my current role as a DB Solutions Manager/Architect I am spearheading company-wide Reporting & BI Initiative for the Business Community. Current responsibilities include, interviewing Business Users & Upper level (C-Level) Management, prototyping a POC, Overseeing & Managing Architecture & Design of Data Structures and BI Data Marts & Data Warehouses. I am also managing our Cloud Infrastructure & Databases in Azure thus accomplishing our Key Company Objectives & Initiatives Supporting our Internal Company Processes & Projects. All the time, I am continuously helping to build positive relationships with internal customers i.e. Business Community and Internal Leadership.

Architecting & Implementing a Data Analytical Platform (DAP) which will be used to connect to dozens of data sources, load those raw sources into a data acquisition staging area, then transform that raw data into a number of data warehouses and data marts. This curated data ultimately feeds reports, visualizations, and analytics. The DAP represents a one-stop shop for our company’s data delivery needs and provides a 360-degree view of our enterprise’s activities.

Leading a Team for building Azure SQL Data Warehouse (With Synapse Analytics) for Business Reporting & IOT Scada System Reporting.

Managing Cloud Azure & On-Prem SQL Environments, Performance Improvement\Monitoring. Leading a team for troubleshooting, performance analysis, problem resolution, maintenance, Backups\High Availability, as well as User Support for Critical and Back-Office Databases.

Successful Cloud Data migrations to Azure for Key Business initiatives from SQL Server systems (SQL 2016) to Azure SQL DB

Sound Understanding of Cloud Relational DBMS (Azure SQL DB & Managed SQL Instance)

Proficient in SQL Server 2017, 2016, 2014, 2012 - (SQL Server Database design, Architecture Design, Security, SQL Server Log Shipping, Replication, T-SQL)

Overseeing Successful Database Management Projects (Data Warehousing & Business Intelligence, Performance, Infrastructure, Production & Development) for Critical Internal Client Projects

Overseeing Several Key DB Disaster Recovery\Fault-Tolerance\High Availability Projects in SQL Server (SQL Always On, DAG, SQL Server Clustering)

Managing Production DBA Work to Support Developers\Testers\Users

Acting as a Liaison between DB Reporting Team & Business Field Engineers (Using Power BI, Power-Automate, PowerApps, SSAS, SSRS)

Hitachi Vantara, Englewood, CO

Senior DB Solutions Manager/ DB Solutions Architect 4/2013 - 2/2020

In my role as a DB Solutions Manager/Architect I have spearheaded several Projects and Initiatives. Some of these are SQL Server\Oracle BI\Power BI Projects & ERP Upgrade Initiatives, Support business processes, Undertake several Key Database Projects - System Improvements & Enhancements. I have also worked with Off-shore Teams in Malaysia & India to accomplish Key Company Objectives & Initiatives Supporting our Clients and Internal Company Processes & Projects. All the time, I have continuously helped to build positive relationships with external & internal customers.

Managing Operational DBMS Environments, Performance Improvement\Monitoring. Leading couple of teams for trouble-shooting, performance analysis, problem resolution, maintenance, Backups\High Availability, as well as User Support for Critical and Back-Office Databases.

Successful Cloud Data migrations to AWS/Azure for several Key Business initiatives from Oracle ERP & SQL Server systems (SQL 2017, 2016, 2014, 2012) (SCOM Systems)

Sound Understanding of Cloud Relational DBMS (AWS RDS) and Non-Relational DBMS (Dynamo DB)

Proficient in SQL Server 2017, 2016, 2014, 2012 - (SCOM Systems), SQL Server Database design, Architecture Design, Security, SQL Server Log Shipping, Replication, T-SQL

Enhancing Organizations Data Streams (Collection, Dispersion) and generate Analytics providing insights into the Business (DW & BI Initiatives).

Overseeing Successful Database Management Projects (Data Warehousing & Business Intelligence, Performance, Infrastructure, Production & Development) for several Critical External & Internal Client Projects

Provide day-to-day Database Management of Production & Engineering Database Projects & Back-Office Operations

Overseeing Several Key DB Disaster Recovery\Fault-Tolerance\High Availability Projects in SQL Server\Oracle (SQL Always On, DAG, SQL Server Clustering)

Managing Apps DBA & Production DBA Work to Support Developers\Testers\Users

Acting as a Liaison between DB Reporting Team & Enterprise Reporting Teams (Using Power BI, SSAS, SSRS)

eBags, Inc., Greenwood Village, CO 12/2005 - 3/2013

Senior DBA/Team Lead

I was working as a Hands-On Team Lead of the Database Production\Development Teams. Also functioned as an SQL Server/Oracle Go-to guy for Troubleshooting Key Critical Production & Development DBA Issues. I managed a number of Key projects as well as regular Production and Development DBA duties. I was responsible in enhancing our organization’s Data Streams and generate Analytics providing insights into the Business Verticals, Highly profitable E-mail Campaigns, Customer Segmentation, Response Modeling, A/B split test measurement, Forecasting and Trend Validation. I spear-headed one of our Major migrations of Data for our biggest client (Tumi) from Oracle to SQL Server. The entire project consisted of setting up the SQL Clusters, Databases, Database Mirroring, Database Replication, DB Security, Backups\Recovery Solution, Database Monitoring, Performance Monitoring, etc. In addition to this I was also leading the Design & Architecture Teams for Databases (DB Architecture/Data Modeling). I was also involved with Migrating our Oracle 9i system to Oracle 10g and then finally upgrading it to Oracle 11g.

Other duties involved Proposing Database Solutions to Clients, Handling Several Key Client Projects, Database Project Management, Performance Monitoring of Databases\Database Servers, Rebuilding Database Servers, Installing and Patching Database Software, Design, Development & Implementation of Database and Application Solutions, Cleansing and Architecture of Data, Production Support, Database Reporting (canned and ad-hoc), Implementing Oracle Data guard for Failover/High Availability, RMAN for Backups/Restores, Apps DBA work to support Developers/Testers.

DB Project Management/Team Lead of Critical Client External/Internal Projects

Enhancing Companies Data Streams and generate Analytics providing insights into the Business. highly profitable e-mail campaigns, customer segmentation, response modeling, A/B split test measurement, forecasting and trend validation.

Responsible as a Team for the ongoing expansion of an enterprise data warehouse (EDW) using the Data Vault architecture, operational reporting and advanced analytics environment. EDW was in Oracle while the Reporting and OLAPs were built in Oracle & SQL Server.

Managing Architecture & Design of Data Structures and Databases

Overseeing the DB Migration project for Tumi from Oracle 10g to SQL Server 2012

Overseeing the DB Migration projects of Oracle 9i/Windows to Oracle 10g/Linux

Managing Production DBA Duties as a Senior Oracle/Sql Server DBA/Developer.

Database Reporting (canned and Ad-hoc) as a part of the Enterprise Database Reporting Team

Implementing Sql Server Database-Mirroring & Clustering for Failover/High Availability

Implementing Sql Server Replication for Reporting

Implementing Oracle Data guard for Failover/High Availability

Implementing RMAN for Backups/Restores

Apps DBA work to support Developers/Testers/Client UAT Testing

Monitor Performance of Client Databases and our Database Servers\ Build Database Servers

OpSource & Webroot, Denver, CO 3/2003 – 11/2005

Senior DBA/Solutions Analyst

I was working in a Senior DBA Role and some of my duties involved proposing Database Solutions to Clients, Performance Monitoring of Databases & Database Servers, Rebuilding Database Servers, Installing Database Software, Design, Development & Implementation of Database and Application Solutions, Cleansing and Rearchitecting of Data, Replicating Threat Research Spyware Data, Rearchitecting Data processes and Remodeling of existing Data Structures. I have sound knowledge of the 4 basic Subject areas: Database Design, Database Architecture, Database Administration, and Database Programming.

I have also had sufficient Database Developer experience writing and formulating SQL queries in T-SQL and MySQL. I have developed them in the form of Batch Scripts, Stored Procedures, Jobs, Scripts, etc. I have also had sufficient experience writing and formulating open queries between mysql and sql server, replicating sql server and my sql databases, and writing distributed queries and transactions between different linked servers.

Production DBA Duties as a Sql Server/Oracle DBA/Developer.

Requirements Gathering and Mapping of Requirements to the Current & Proposed Workflow.

Develop a solid Design Document for the design of the proposed system, which would satisfy the requirements signed off on and how they will be addressed.

Help to understand architecture and deployment issues related to the hardware, RDBMS, and front-end applications

Develop an ERD and use that to develop and design a Database for managing all the transactions (data) flow.

Develop Data models and Process Flow models to define the data flow.

Monitor Performance of Client Databases and their Database Servers

Build Client Database Servers and Web Servers

Maximize skill transfer between Clients & Technical Support Staff.

Ciber Solutions, Greenwood Village, CO 11/1996 – 02/2003

Senior Software Solutions Consultant

I was part of a Team (as a Consultant) that was responsible to Implement Oracle CRM Modules with existing Client Applications for couple of our Top clients then (Colorado Bureau of Investigation). I was the Database Lead on all Implementations. We also implemented Sales Product Suite of Reporting Applications using MicroStrategy for our top MicroStrategy Customers (JD Edwards, MCI). Also was instrumental in implementing some Key Application & Inventory Platform Changes, Chargeback System, Reporting Application Changes at IBM Global Services, Downtown Denver.

Requirements Gathering and Mapping of Requirements to the Current & Proposed Workflow.

Develop a solid Design Document for the proposed system, which would satisfy the requirements signed off on and also how they will be addressed.

Develop a User-friendly Web-Interface providing a standard look and feel in the entire system and Implement the Three Oracle CRM modules & Oracle CRM Technology Foundation

Help to understand architecture and deployment issues related to the Hardware, RDBMS, and Front-end applications

Develop Data models and Process Flow models to define the data flow and also develop an ERD and use that to develop and design a Database for managing all the transactions (data) flow.

Test and Integrate the Suite of Applications and finally release a Fully Functional Suite to the FFLs and CBI Agents that will allow the CBI agents integrated access to all systems and DBs

Maximize skill transfer between FFLs and CBIs agents & Support Staff.

Design a Comprehensive data model and make Schema Design recommendations For MicroStrategy Implementations

Develop & Test a Generic Product Suite of Applications using MicroStrategy 7.0 and finally Integrate & Release a Fully functional Product Suite to various top clients.

Maximize skills transfer between MicroStrategy consulting staff and Clients Support Staff.

EDUCATION AND CERTIFICATIONS

Regis University, Denver, Colorado

Master of Computer Information Systems – Major – E-Commerce - 1999 to 2003 (GPA = 3.9)

Mumbai University, Mumbai, India

Bachelor of Engineering – Major - Electronics – 1994 (With Honors)

TECHNICAL AND PROFESSIONAL CERTIFICATIONS

Microsoft Azure

Azure Solutions Architect, Cloud Platform Architecture & Infrastructure – MCSD: Azure Solutions Architect (MCSA, MCSE) - Certified

Microsoft SQL Server

MCITP-DBA – Microsoft SQL Server - Certified

Microsoft SQL Server

MCITP-Developer – Microsoft SQL Server - Certified

Microsoft SQL Server

MCTS – Microsoft SQL Server - Certified

Amazon Web Services

AWS Solution Architect (Associate) (Certification in progress)

Amazon Web Services

AWS Cloud Practitioner - Certified

Amazon Web Services

AWS Cloud Primer - Certified

MicroStrategy 7.0, 10.0

Certified

IT Infrastructure Library (ITIL)

IT Infrastructure Library (ITIL) (Foundation) - December 2016 - Certified

TECHNICAL SKILLS SUMMARY

Cloud Implementations – Amazon Web Services - AWS, Microsoft - Azure

DBMS -

SQL Server – 2017, 2016, 2014, 2012, 2008R2 - (SCOM Systems), SQL Server Database design, Architecture Design, Security, SQL Server Log Shipping, Replication, SQL Always On, DAG, SQL Server Clustering

Oracle 18c, 13c, 12c, 11g

Cloud DBMS – PostgreSQL, MySQL, Azure SQL DB

Business Intelligence Tools/Reporting Tools: MicroStrategy 10.0, 7.0 (Certified), SSRS, SSIS, SSAS, Power BI

Oracle Supporting Technologies – Oracle Workflow, Oracle CRM

Operating Systems: Linux (Red-Hat), Solaris, Windows NT, Windows Family

Languages: C++, C, PL-SQL, T-SQL, Java

Contact this candidate