Data science and analytics manager with expertise in data governance and database administration. Proven ability to optimize data pipelines and improve operational efficiency. Skilled in cross-functional team management, delivering impactful results through innovative solutions and strategic vendor partnerships.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Experience
Raytheon Technologies
12.2017 - Current
Data governance: Maintaining data security and privacy, regulatory compliance, and building policies, procedures, and processes to secure, manage, and derive value from organizational data using Immuta.
Database Administration. Responsible for managing and optimizing the Snowflake warehouses, ensuring their stability, performance, and scalability, user and role management, security implementation, performance monitoring, data loading, data governance, cost optimization, and integration with third-party tools.
Database and Platform Support:
I analyzed project requirements, designed, and set up a scheme and access control for ETL processes to load enterprise data into the Data Warehouse.
Managed version control and deployment of data applications and database changes.
Created monthly reports for senior management summarizing operational performance metrics.
Optimized query performance for large scale analytic queries running on distributed computing clusters.
Evaluated new technologies that could be used to enhance the organization's analytics capabilities.
Assessed data processing proposals and requirements to determine project feasibility.
Performed root cause analysis of anomalies identified in data sets.
Provided guidance and support on best practices related to data quality assurance and governance procedures.
Collaborated with cross-functional teams to define business requirements for analytics projects.
Migrated the Teradata database to Snowflake.
Developed and implemented data models, database designs, data access and table maintenance codes.
Monitored data systems performance, identifying bottlenecks and implementing solutions to maintain system efficiency.
Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing.
Collaborated with data scientists and analysts to understand data needs and implement appropriate data models and structures.
Participated in agile development processes, contributing to sprint planning, stand-ups, and reviews to ensure timely delivery of data projects.
Documented data architecture designs and changes, ensuring knowledge transfer and system maintainability.
Researched and integrated new data technologies and tools to keep the data architecture modern and efficient..
Developed and managed enterprise-wide data analytics environments.
Demonstrated strong problem-solving skills, resolving issues efficiently and effectively.
Senior Manager. (Operations & Delivery)
Cognizant Tech Solution, US
04.2012 - 11.2017
Operations and Delivery Manager, leads offshore and onsite teams to provide 24/7 maintenance and support for business intelligence, analytics, data warehouse databases, Teradata, big data, and DWH tools.
Database design, modeling, user access path setup, profile, role, and privileges definitions, and granular access control setup on data. DB capacity planning and customization, automation of the DB administration process.
Teradata database upgrade and hardware floor swipe to migrate version. 13.10 to 14.10 & 15.10. From Teradata Enterprise Hardware System 66 Series to 67 Series. Involve and coordinate with the Teradata GSC team, business, application, and DBA teams in all the stages of migration to move 500 TB of data across DEV, TEST, QA, and production.
Work with Teradata CSR and device procedure to migrate backup jobs and BAR system upgrade from normal Arcmain and tape backup to Taragui with multi-stream back system with NetBackup and EMC2 Data Domain configuration.
Datalab configuration and automation of DB provisioning and user access through Viewpoint Datalab portlets.
Exposure DB control parameter setting and CNS term to configure database parameters and system maintenance.
Configure and automate the process of SCAN DISK and PACK Disk and analysis log weekly basis to identify block corruption and improve more space usage.
TTU client rollout through BMC BladeLogic/Microsoft SCCM automation to package and install Enterprise wide desktops and servers. Major rollout to update 500 Application Servers & 15K user desktops for every alternate year to make TTU version compatible with Teradata database upgrade.
TASM workload configuration, throttles and filters setup, workload allocation to DB ids and PDCR reporting on database ids IO and CPU usages using PDCR Data.
ODBC system DSN configuration maintenance in line with 3DNS and Load balancer configuration.
Viewpoint portal upgrade, maintenance and configure viewpoint portlets to monitor, alerting and user access through roles and portlet privilege setup.
Supervise remedy ticket system on indent/service request and change controls and allocates work to team members in onshore and offshore to apply DDL/DML through migration path schemas from DEV to Prod.
Responsible for communicating and coordinating with all line of business, Application managers, Core DA and Teradata vendor for any DB related activities like database/firmware upgrade, patch installation and audit reporting.
Organize Monthly Governance Meeting to update the clients and stake holder on the support/project happening on support metrics reports on baseline, schedule, work in progress, and work completed & reports on project progress and other project specific information and manages project scope and change control and escalating issues where necessary.
Devising team shift plans, On Call rotation schedules, identify team training requirement and organize training, cross skilling team member across various technologies.
Backup data replication setup through NetBackup and ensure the Data and backup jobs are available to restore for DR system.
Prepare monthly system availability, chargeback, and elastics usage report on system CPU and I/O usage by business and elastics usage.
Big Data - Hadoop engineering support on user access, project container setup, Ranger policy setup, and resource partitions.
Proficiency in executing change control, service requests, incident management, and problem management to adhere to the SLA and change rollout.
Education
Master Degree in Science -
Bharathidasan University
Higher Diploma in Software Engineering -
Aptech Computer Education
Skills
Data governance
Database administration
Data analysis
Data pipeline design
Change management
Cross-functional team management
Vendor management
Database Auditing and reporting
Affiliations
Travelling
Documentary
Photography
Accomplishments
Collaboration award for Teradata to snowflake migration. This save the additional license cost of Teradata as well support the enterprise goal of ONE Data Eco System.
CORE - For Achieving CORE apprentice certification from RTX.
Accountability award for help the data visualization team in fixing data issue to avoid escalation and meet their SLAs
Collaboration Award for working with team to configuring the Tool Athena for data visualization.
Accountability Award for Immuta migration from Aero to Xeta Cloud.