Murali Tharan S

--EDUCATION -) B.E-EEE, Karpagam College of Engineering, Coimbatore, 7.6 CGPA CORE COMPETENCIES        Python (including Pyspark), SQL, SAS, ETL Data Governance & Risk Management Big Data & Hadoop Data Lake Cloud Platforms: AWS, GCP, Azure Visualization Tools: Tableau, Power BI Automation of Reporting & Processes Data Quality Validation & Insights TECHNICAL SKILLS      Languages: Python, SQL, HTML, CSS Frameworks: Django, AWS, VBA Macros ETL Tools: SSIS, Python (Pandas) Visualization Tools: Power BI, Tableau, MS Excel Database Platforms: SQL Server, PostgreSQL, Oracle, MySQL, MS Access Tools: SQL Server Management Studio (SSMS), Snow Inventory, CyberArk, ServiceNow (CMDB), Visual Studio Code, Jupyter Notebook MURALI THARAN S Chasing dynamic roles preferably in Information Technology sector, with a focus to leverage expertise in IT Security and Data Management domain to drive efficiency and success. Targeting roles ideally in Bangalore, Coimbatore and Chennai for the right career prospects. PROFILE SUMMARY            WORK EXPERIENCE Carelon Global Solutions, Bangalore ( An Elevance Company) Designation- Senior Analyst AWS Certified Solutions Architect – Proficiency in architecting scalable and cost-efficient solutions on AWS. ACHIEVEMENTS & AWARDS      Letter of Appreciation – Carelon for exceptional performance in managing and securing over 13,000 service IDs within CyberArk vaults. Best Performer Award (Q2) – Carelon for successful automation of database governance and service ID management. TCS GEMS Appreciation Award for developing a comprehensive fullstack web application using Python and SQL. TCS GEMS Recognition for delivering 5+ Python live sessions to offshore teams. On the Spot Team Award – TCS for organizing Info Security Week, (Oct 2022 - Present) 2.5 Years* Key Roles and Responsibilities:  CERTIFICATIONS  4.6+ years of comprehensive experience in IT security, data integration, and automation, with a strong focus on Python development, SQL, AWS and ETL. Expertise in developing Python-driven automation solutions for database governance across 13,000+ cloud and on-premises database instances, ensuring daily compliance and improving operational efficiency. Proficient in SAS for integrating multiple data sources into a unified platform, enabling seamless data merging, transformation, and formatted exports for analysis and reporting. Automated data validation and compliance checks using SAS, Python, and SQL, reducing manual effort by 50% and improving data accuracy. SQL development expertise, including query optimization, index management, and data transformation using SSIS, Python ETL pipelines, and SAS for largescale data processing. Proficient in using AWS services, with knowledge of cloud platforms like GCP and Azure, ensuring seamless data integration and compliance. Hands-on experience in AWS services like EC2, AWS Config, and CIDR range whitelisting, ensuring secure, scalable deployments. Strong understanding of CyberArk for ID vaulting and password rotation, enhancing credential security and automating account management. Proven track record of working with JIRA and ServiceNow (CMDB) for incident tracking and asset management. Adept at creating insightful visualizations and reports using Power BI, Tableau, and Excel, delivering actionable insights to stakeholders. Demonstrated leadership and collaboration skills, driving multiple end-to-end data migration projects from MS Access to full-stack applications (backendfocused).      Spearheading Python-based automation for database governance and reporting across 13,000+ database instances (SQL, Oracle, PostgreSQL, MySQL, Sybase). Automated non-vaulted account identification and integrated CyberArk for secure credential management, reducing manual effort by 15+ hours per week. Developed Python scripts to extract and transform data from Snow Inventory and ensured seamless integration into centralized repositories. Enhanced operational workflows by integrating ServiceNow (CMDB) for tracking and compliance reporting. Leveraging AWS EC2 and Config for resource management, automation, and CIDR whitelisting to maintain security compliance. Built real-time dashboards using Power BI to monitor database compliance and automation metrics. PREVIOUS WORK EXPERI ENCE Tata Consultancy Services, Chennai Designation- Systems Engineer Client - Cigna (Aug 2020 - Sep 2022) 2.1 Years Key Roles and Responsibilities:    Developed a full-stack web application using Django and SQL Server, streamlining reporting processes and reducing manual tasks by 70%. Led the migration of legacy SSIS packages to Python ETL workflows using Pandas, enhancing data processing capabilities. Automated data retrieval and transformation processes using Python for ad hoc reporting and integrated with SQL databases for seamless data access.  fostering a culture of security awareness. Learning Achievement Award – TCS for completing multiple learning programs and certifications.  Managed and optimized production jobs for SSIS, SAS, and Python scripts, ensuring error-free execution and timely data delivery. PROJECTS UND ERTAKEN Carelon Global Solutions (Oct 2022 – Present) PERSONAL DETAILS Enterprise Database Governance     Date of Birth: 29th March 1999 Languages: English and Tamil Address: Bangalore- 560037    Governed 30,000+ database instances, ensuring compliance and restricted access to authorized personnel daily. Automated a daily failure tracker using Python to monitor database issues and notify the DBA team for prompt resolution. Collaborated with DBAs to fix database-side failures while managing code-side logic changes for continuous compliance. Led ID vaulting and password rotation in CyberArk, securing privileged accounts and ensuring data protection. Enterprise Release Management    Automated the execution of 100+ stored procedures in sequence using Python, significantly reducing manual effort. Designed Python-based logging and integrated SQL Server with SharePoint for real-time data representation and visibility. Applied advanced Python and SAS scripting for data manipulation, merging multiple data sources into a unified dataset for accurate reporting. Tata Consultancy Services (Aug 2020 – Sep 2022) Python Ad-Hoc Automation    Automated ad-hoc reporting workflows using Python and SAS, improving operational efficiency and reducing manual intervention by 50%. Integrated SQL Server and SAS queries to create robust backend solutions for streamlined reporting processes. Utilized SAS for connecting to multiple data sources, consolidating data into a single structured format for processing and export. Quality Assurance with ETL     Led a team of two in designing and maintaining key SSIS packages for Cigna, optimizing data integration and ensuring data accuracy. Utilized SAS for merging and formatting data from multiple sources to ensure consistency before processing. Monitored and optimized 200+ SSIS ETL jobs and 100+ SAS Job, improving performance and reducing failure rates by 30%. Worked closely with stakeholders and DBAs to validate data consistency and ensure compliance with business requirements. MS Access to Full-Stack Migration    Migrated a legacy MS Access database to a SQL Server backend while developing a full-stack website. Designed custom stored procedures and views, significantly enhancing database performance and reliability. Developed real-time reporting modules for better data access and user interaction. Production Support (Team Lead)    Acted as Team Lead (TL), managing 200+ SSIS jobs and 150+ SAS jobs daily using CA Workstation to ensure optimal performance and reliability. Conducted root cause analysis for job failures, coordinated with cross-functional teams for resolution, and optimized SQL queries to improve performance. Mentored junior team members and ensured timely delivery of critical data to business stakeholders.