About Me
Result Oriented professional more than 25+ years of experience in database management, data management and delivery management. Highly Competent in technical delivery, solution architecture, data services, consulting, cl…
Result Oriented professional more than 25+ years of experience in database management, data management and delivery management. Highly Competent in technical delivery, solution architecture, data services, consulting, cloud computing, project delivery, IT operations and pre-sales. Worked as a VB Developer, Solution Architect, Database Manager, Production Support Manager, Service Delivery Manager, Project Manager and Release Manager. Providing 24x7 support with Onsite, and offshore models with various APAC, EMEA, and USA Clients in banking, insurance, healthcare, manufacturing, logistics, and government sectors. Strong understanding of business requirements, larger team management, leadership, negotiation and vendor management.
Experience
Senior Technical Manager
Working as a Senior Technical Manager- Technical Delivery, Involving Data Management which includes DB Migration, DB maintenance, support. Data Analytics, Data Visualization, Data Modeling, Data Governance, Data Integration, Data Quality, Data Pipeline, Metadata, Master Data implementation on CRM, ERP business data. Major Clients: Fujitsu, HCL Live, Google & Verizon.
Leading database migrations with heterogeneous, homogeneous, cross-platform, and multi-cloud. Several databases were migrated successfully from Oracle to PostgreSQL, PostgreSQL to BigQuery, PostgreSQL to Snowflake, MSSQL Server to MySQL, and Teradata to MySQL DB.
Implemented Metadata process, analytics solutions, Data Catalog, Data Integration, Data Pipeline, Data Governance strategies, Data Profiling, Data Cleansing, Data Orchestration, Data Lineage, Data Ingestion and Data Quality in Telecom, Financial sectors using Qlik, Informatica metadata management, erwin Data Catalog, Spoon, Oracle Enterprise Metadata Management, Talend tools.
Providing Master Data Management solution that comprise of Data Governance, Integration, Data Pipelines, Data Cleansing, Data Ingestion, Data validation, data protection, De-duplication and Standardizationusing with Qlik, Profisee, Talend and Spoon tools.
Extensively involving pre-Sales, POC, preparing Proposal, RFI, SOW for new projects, enhancements and Involving application design, database migration, application implementation, security polices, planning, Budgeting, Scheduling and Team management
Managing 25 member’s team which includes Developers, Data Analytics Engineering, Project managers, and Database support team, Application production support team. Presenting regular status report to Clients management for Data management, Application status which including SLA Adherence Report, WSR, SDR.
Technologies: Cloud platform (AWS, AZURE, Google), Database’s (Oracle, PostgreSQL, MS SQL Server, DynamoDB, AWS Glue, MySQL, BigQuery, Teradata, Bigdata (Hadoop, HBase, Spark, Pig, Hive, Sqoop) , OS (Linux, HP-UNIX, Windows), Talend, Spoon, Airflow, Snowflake, Profisee, SaaS, Informatica, Collibra.
Technical Architect
Worked as Technical Architect, involved Pre-Sales, POC, Proposal, RFI & Database Design, Database Migration, Data Integration, Data Analysis, Data Replication, Production Support with various clients.
Successfully migrated Retail databases from an on-prime database to Cloud (AWS/Azure).
Involved Schema conversion, Code Conversion, Data Integration, Data Governance, Data Lineage, Data Ingestion, Data Collecting, Data Cleaning, Data Profiling, Data Analysis and data migration using SCT, DMS & Ora2pg Tool, HVR, Talend, Informatica Tools.
Performed application, and database Testing including functional, Integration, Smoke, Sanity, Regression Testing, system, and end-to-end testing on SIT, UAT, and pre-post database application environment during data migration and implementation.
Responsible for database maintenance, Performance tuning, Support, and database administration for various databases.
Involved Production Support Oracle, PostgreSQL, MySQL, MongoDB, and MS SQL Server databases.
Database Architect
Worked as a Database Architect, involved in Product development, Data Analysis, Data Pipeline, Data Operations, Production Support, and Database Migration.
Major responsible for Schema conversion, Code Conversion, and data migration using SCT, DMS & Ora2pg, HVR, Talend Tool.
Performed database restructuring, data collecting, data cleaning, data analysis, Data integration, visualization, and statistical analyzing, Bigdata Hive, Spark, Sqoop.
Used Tableau, and Python for manufacturing, Insurance and Telcom environment.
Professional Consulting
Worked as a Professional Consulting with Vahai Technologies, BeyondEx Solutions and MacroWin Technologies.
Performed database migration, object reorganization and data conversation from Oracle to PostgreSQL and automation activities.
Maintenance of the health care Master Data Management, data review, removed error data, remove duplicate data, remove incomplete data and integrating data from various data sources using python, Spark, Qlik, Informatica Tools.
Performed data governances, data transfer using ADF and visualization using Tableau.
Architect, Service Delivery Manager, Production Support Manager, PM
Worked as an Architect, Service Delivery Manager, Application Production Support Manager, Project Manager and Change, Incident, Problem & Release Manager.
Successfully handled critical Projects with Banking, Healthcare, and Manufacturing which includes database production Support & maintenance, ETL Batch Management, Application development and support.
Worked as a Database Architect, DBA Manager for Baxter Healthcare US, APAC.
Major responsibilities were the database Configuration, database design, DB restructured, Upgrade, Patching, Oracle RAC nodes, Oracle ASM, Golden Gate.
Maintained Master Data Management for customer, location, product, supplier, Sales, Purchase with business-to-business (B2B) and business-to-consumer (B2C).
Analyzed and maintained health care data, sales, purchase and research data.
Performed data Integration, Data Analytics, data quality, data collection, Data conversion, extraction, loading, Transforming data, DB Security, data analysis and visualization in Oracle, Bigdata, MySQL, ETL, Informatica with Dev, UAT, SIT, Production Databases.
Worked as a Project Manager for Citi Bank Global-APAC.
Managed Batch programing development, Jobs integration, project deployment, post implementation monitoring.
Production support of banking batch jobs on Web servers, Java, .Net, Oracle, and ETL data warehouses.
Maintains production, DEV, UAT, and SIT environments; and oversees more than 5,000 scheduled tasks.
Managed Incident, Problem, Change, Capacity, Configuration with CRM, Cards, HRMS, and loan applications with 24x7 support.
Created the data pipelines, data extraction, transformation, and loading from a range of data sources on Oracle databases, ETL data warehousing by utilizing Python, SQL, and Talend.
Automated tasks using CRON, OEM, SQL Server agent jobs, Tivoli-Scheduler & Monitoring, Autosys, Control-M, Cloud Services.
Worked as a Project Manager for Allstate Insurance, US.
Major responsible was project initiation, project planning, project budgeting, scheduling, change, Team Management, handling escalations and maintained SLA, KPI as per Statement of work.
Developed Insurance applications, Testing, data validation, provided support and Maintenance including life, Motorcycle, Auto, Home, Business, and Travel using Java.
Performed application testing which includes functional, Integration, smoke, Sanity, Regression Testing, system and end to end testing.
Handled Release management including planning, monitoring, implementing minor, major releases and coordination with Various customers.
Preparing and raising project Invoicing for every quarterly basis.
Closely working with sales and technical team’s.
Worked as a Service Delivery manager, Production Support Manager for Lloyds Bank Global-UK.
Managed Banking Application Production Support Team, Database support Team and UNIX administrator Team.
Managed the configuration, change, incident, problem, and capacity for the CRM, Cards, assert, Cash, Insurance, HRMS, loan applications, webserver, and databases.
Handled a massive amount of incident, problem, and change requests with over 100 tickets per day.
Managed vital Banking ETL applications with over 250 upstream and downstream apps.
Managed shared Services with more than 40 resources including L1, L2, L3 with 24/7 environment during Working with Wipro.
Worked for Philip Morris International.
Successfully increased database performance more than 50% capacity for Manufacturing Organization.
Increased the Database Performance, restructuring the database, reorganized the database of the objects and tune OS configuration, tuned the complex SQL scripts, rescheduled the batch jobs and daily backup.
Project Lead
Worked as a Project Lead with Database Maintenance and middleware Application support in an environment that has healthcare Care, Telecom Divisions for Merck, and BT-UK Clients.
The major responsibilities were Database Maintenance, Application Support, Database Migration, Cloning, DB Upgrade, and patching.
Practiced Database Backup, Recovery, and DB Security and handled more than 100 databases with Oracle, MSSQL, and SAP databases.
Involved in System copy, SAP performance tuning, Authorization setup, Backup, and Restore.
Designed and planned zero downtime upgrades and practiced Batch/Schedule Management using Control-M.
Managed SQL Server Databases.
Performed backup/recovery, performance, and tuning.
Implemented automatic monitoring scripts for various applications, databases, and OS.
Involved Transition went to Singapore, Gathered KT, and implemented separate ODC for Merck DB support.
Consultant
Worked as a Consultant, performed as an Oracle database administrator for Manufacturing and Health Care Divisions for Navistar, WellPoint Clients.
Effectively involved Database design, Modeling, Database Migration, and database supporting in Oracle, MSSQL Server and SAP Basis environments.
Implemented automated tasks such as Data loading, Data Extraction, Data Transforming from various sources.
Monitored database background jobs, Analyses ADDM Reports, AWR report, Query Optimizer, Execution Plans, SQL Tuning Advisor for database performance related issue.
Worked on PLSQL stored procedures and functions to support internal processes and improved system performance.
Database installation, applying patches, DB user Security, monitoring database performance, disk space utilization management and I/O contention issues.
Developed and maintained PL/ SQL Procedures, Triggers, Packages.
DBA Specialist
Worked as DBA Specialist in Database Maintenance and support division for BT, BOOTS-UK Clients.
Database Installation, Configuration, Performance tuning, Apps patching & Cloning, Backup/Recovery and Team Management.
Involved in Incident, Problem, Change, capacity Management and Release Management in database environments.
DBA Lead
Senior Oracle DBA
Consultant
DBA
Associate
Program Analyst
Developer & DBA
Sr Consultant, EDP dept
Developer & EDP Executive
Senior Technical Manager- Technical Delivery
Working as a Senior Technical Manager- Technical Delivery, involving Data Management which includes DB Migration, DB maintenance, support.
Data Analytics, Data Visualization, Data Modeling, Data Governance, Data Integration, Data Quality, Data Pipeline, Metadata, Master Data implementation on CRM, ERP business data.
Leading database migrations with heterogeneous, homogeneous, cross-platform, and multi-cloud.
Several databases were migrated successfully from Oracle to PostgreSQL, PostgreSQL to BigQuery, PostgreSQL to Snowflake, MSSQL Server to MySQL, and Teradata to MySQL DB.
Implemented Metadata process, analytics solutions, Data Catalog, Data Integration, Data Pipeline, Data Governance strategies, Data Profiling, Data Cleansing, Data Orchestration, Data Lineage, Data Ingestion and Data Quality in Telecom, Financial sectors using Qlik, Informatica metadata management, erwin Data Catalog, Spoon, Oracle Enterprise Metadata Management, Talend tools.
Providing Master Data Management solution that comprise of Data Governance, Integration, Data Pipelines, Data Cleansing, Data Ingestion, Data validation, data protection, De-duplication and Standardization using Qlik, Profisee, Talend and Spoon tools.
Extensively involving pre-Sales, POC, preparing Proposal, RFI, SOW for new projects, enhancements and involving application design, database migration, application implementation, security polices, planning, Budgeting, Scheduling and Team management.
Managing 25 member’s team which includes Developers, Data Analytics Engineering, Project managers, and Database support team, Application production support team.
Presenting regular status report to Clients management for Data management, Application status which including SLA Adherence Report, WSR, SDR.