Poguttuezhini

Poguttuezhini

Solution Architect
India

نبذة عني

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…

الخبرة

Senior Technical Manager

HCL Permanent
Aug 2021 - حتى الآن · 4 سنوات 10 أشهر

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

Aspire System Pvt Ltd, Chennai
May 2020 - Aug 2021 · 1 سنة 3 أشهر

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

Newt global Ltd,Chennai
Feb 2019 - May 2020 · 1 سنة 3 أشهر

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

Professional Consulting/ freelancer
Jun 2017 - Jan 2019 · 1 سنة 7 أشهر

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

Wipro Ltd. Chennai
Aug 2010 - Jan 2017 · 6 سنوات 5 أشهر

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

HCL Technologies Ltd ,Chennai
Nov 2007 - Jul 2009 · 1 سنة 8 أشهر

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

UST Global, Chennai
Sep 2007 - Nov 2007 · 2 أشهر

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

Xansa India Ltd , Chennai, Pune
Dec 2006 - Sep 2007 · 9 أشهر

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

Brooks Software Ltd, Chennai
Sep 2006 - Dec 2006 · 3 أشهر

Senior Oracle DBA

Ford India Ltd, Chennai
Apr 2006 - Sep 2006 · 5 أشهر

Consultant

Polaris Software Lab Ltd, Chennai
Oct 2005 - Apr 2006 · 6 أشهر

DBA

Zenith InfoTech Ltd, Mumbai
Jun 2004 - Oct 2005 · 1 سنة 4 أشهر

Associate

HCL Perot System Ltd, Bangalore, Noida
Dec 2003 - Jun 2004 · 6 أشهر

Program Analyst

National informatics Center, Chennai
Sep 2002 - Nov 2003 · 1 سنة 2 أشهر

Developer & DBA

BeyondEx Solutions, Chennai
May 2000 - Aug 2002 · 2 سنوات 3 أشهر

Sr Consultant, EDP dept

PHC MFG India ltd, Chennai
Apr 1998 - May 2000 · 2 سنوات 1 شهر

Developer & EDP Executive

Veer International, TN
Feb 1996 - Mar 1998 · 2 سنوات 1 شهر

Senior Technical Manager- Technical Delivery

HCL Technologies Ltd, Chennai
Aug 2021

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.

المهارات

جيرا إدارة البرامج إدارة الإصدارات نظام التحليل الإحصائي (SAS) سكرم إدارة التجربة من أدوبي أجايل بروتوكول الوصول البسيط للكائنات (SOAP) أباتشي بيغ دورة حياة التطوير البرمجي أوراكل EBS منهجية إدارة المشاريع Database Management Data Management Delivery Management Technical Delivery Solution Architecture Data Services Consulting Cloud Computing Project Delivery IT Operations Pre-sales VB Oracle PostgreSQL MS SQL Server MySQL MongoDB SAP Basis BigQuery Snowflake Hadoop HBase Spark Pig Hive Sqoop Erwin TOAD ADF Databricks Tableau Power BI Talend Spoon Airflow Tivoli Python Control-M Autosys Data Strategy Data Modeling Data Architecture Data Migration Metadata Management Master Data Management Data Analytics Data Integration Data Governance Data Transformation Data Discovery
الإبلاغ عن هذا الملف الشخصي؟