Summary of the Skills: Experience in management, supervision, assessment of team of diverse background. Contributed to product road-map preparation and presentation to get buy-in from executives. Collaborate with cross functional teams in offshore location to build products and services that solve complex workflows. Experience in tasks delegation, problem resolution by rolling up own sleeves, mentoring, and guiding to team members to encourage work productivity and delivery on-time. Experience in effective vertical and horizontal communications to get the projects completed on time and within budget. Hands on experience in preparing technical documentations (BRD, TRD, ACD, HLD, LLD) and operation runbook. Assessment of training needs for team members, preparation of multimedia training content, and conduction of training. Experiences in AWS Infrastructure services such as EC2 instance, Cloud Formation Template, S3 bucket, VPC, VPC peering, IAM Role and Policy, RDS instance, RedShift, DynamoDB, Lambda function using Python, Cloud Watch Log, Route 53 DNS etc. Experiences in MS Azure Portal and Cloud SQL Server deployment. Knowledge on Snowflake and Databricks. Data Pipeline design by Databricks notebook using Python. OpsGenie integration for monitoring and alerting. Experiences in relational and dimensional data modeling, logical and physical design of relational and dimensional databases. Experiences in Query optimization, performance tuning, and monitoring of Cloud Snowflake, RedShift and RDS instance, and MS SQL cluster servers in Active/Active configuration. Experience in failover support, transactional replication, distributed query between SQL, RedShift and Oracle using Linked Server, ETL from heterogeneous data sources ( .csv, relational, XML, JSON) using SSIS, Python Notebook (Databricks), SQL SET based Rule Engine Design for Data Exception reporting. Ensuring security by S3 Encryption, SSL enabled connection, IAM roles, custom policy for S3 access, putting endpoint behind ZScaler and removing Inbound IP, remediation of vulnerability identified by Rapid7 and Dome9 reports. Possess Project Management skills using Agile and Waterfall. Use MS AzureDevOps to plan, implement and monitor Epics, Features, PBI and Tasks. Worked with diverse user groups to gather requirements through effective communication with Senior Management, Cross-functional teams, Tech-savvy and non-Tech-savvy end-users. Working with onsite and India team for implementation of projects on a 24x7 rollout plan. Participated in E2E Data Marts solution development. Conformed organization’s standards and business strategies in design, development and deployment of Data Warehouse and Data Marts, client/server and web-based applications. Provided on-call and after hour (24x7) support for customer facing business critical production systems. Also participated in hardware upgrade, applications of patch/service pack, and worked to ensure systems and databases security assurance. Progressive domain expertise in the areas of management, supervision, implementation of Integration, IS /IT projects in industry, academia, and government. Strong ability to plan, forecast, set-up goals, implement solutions, coordinate various operational groups’ day-to-day activities. Proven project management and people skills to ensure high availability of mission-critical applications and infrastructure. Excellent problem solving, organizational & customer service skills. Ability to lead technical team for delivery of Data Warehouse, Data Analytics, Data Governance, and Business Intelligence (BI) solutions through in-house development, or COTS deployment. Demonstrated skills in design and development of web-based, e-commerce and client/server applications that include concept development, planning, requirements analysis, design, development, integration, testing, implementation, operations, and maintenance.