Murugan Samiyappan
Singapore
Summary
Over 21 years of experience in software Development which includes 10 years of ONSITE(Singapore) Experience in implementing large-scale systems in Data Warehouse/Big data in diversified industry sectors including Banking, Insurance and Retail.
Overview
11
11
years of professional experience
1
1
Certificate
Work History
Lead Software Engineer
Great Eastern
Singapore
08.2022 - Current
- Designed and implemented real time data replication solutions using Qlik Replicate for heterogeneous databases.
- Configured, monitored and optimized data pipelines for high performance data movement.
- Ensured data consistency and integrity across multiple database systems.
- Migrated on-premise databases to cloud platforms.
- Automated data replication monitoring and alerting using python scripts.
- Automated data latency report alerting email using shell scripting.
- Automated no data capture [x] hours alerting email using shell scripting.
- Worked closely with business analyst and data architects to define ETL work flow and optimize replication strategies.
- Improved data replication efficiency by 30% by optimizing CDC (Change Data Capture) strategies.
- Automated failure detection and recovery, reducing manual intervention by 40%
- Environment: Qlik Replicate, Oracle, Yugabyte, Sql Developer, Linux
Lead Software Engineer
Great Eastern
Singapore
09.2019 - 10.2021
- Responsible for documentation and information security policies, procedures, and guidelines.
- Define a consistent process to obtain necessary data access (user and group level)
- Specify relevant mechanisms for delegating authority to accommodate data access.
- Coordinate with the Business team, data consumers, data producers & stakeholders and develop and achieve various long-term objectives for data architecture.
- Design short term resolutions to achieve all goals and prepare a data roadmap for management.
- Determine procedure to identify and collect all required data, validate process and recommend improvements to corporate data
- Involved SAS Viya 3.4 installation, 3.5 upgrade and CAS server components configuration.
- Involved in Application setup, Configuration and license activation and license management
- Ensure user login access, server, cluster and database level access to application users and developers.
- Security setup implementation Kerberos authentication setup for Big Data/hadoop files from SAS viya & CAS server.
- Environment: SAS Viya, Windows 10, Putty, RedHat Linux
Senior Software Engineer
Optimum Solutions (Citi Bank)
Singapore
01.2016 - 09.2019
- IBM Cognos 11.0.R7 Installation and configuration in distributed environment
- Security setup based on the Business requirement
- SSO integration with COGNOS BI server/Tableau servers
- Siteminder configurations for COGNOS Single sign on environment
- Created user groups and appropriate roles based on the business requirement.
- Performance tuning Cognos servers and ensure an availability to the business
- Cognos environment Monitoring, Jobs monitoring and provide best practice IBM COGNOS CITT portal customization includes login page and themes.
- Tableau desktop installation, Tableau server installation and activation.
- Tableau roles, user, site creation and implemented security for each site
- Tableau administration and support to the Tableau users across APAC region.
- Cloudera manager (CDH) installation and configuration, monitoring node performance and trouble shooting.
- Server Capacity planning, expanding server capacity and co-ordination with respective server provisioning team.
- Environment: SAS Viya, Windows 10, Putty, RedHat Linux
Senior Software Engineer
L&T InfoTech
Chennai, India
07.2015 - 12.2015
- IBM COGNOS 10.2.2 infra delivery, Administration & Support.
- Manage and appropriately escalates delivery impediments, risk, issues and changes associated to the product development
- Initiatives lead and motivate cross-functional teams and interact with all levels
- Analysis, planning, developing requirement documents
- Created issue tracker and monitor and closely work with the respective team to close an issues.
- Assigned monitor work of technical personnel, ensuring that project steps are in alignment.
- Cognos environment Monitoring, Jobs monitoring and provide best practice IBM COGNOS portal customization includes login page and themes.
- Effective monitoring of Production Jobs, Implementing Best practices, process improvement for stability, availability and performance of Cognos environment.
- Given better support to onsite team for deployment of reports and packages to various environments.
- Diagnosed root cause of issues in Production jobs and reports using Cognos server log files.
- Developed a customized application using Cognos SDK to integrate with autosys server for Job Scheduling
- Environment: Oracle, Windows 10,Putty, RedHat Linux, SQL Developer
Education
Master of Science - Computer
IndiaBachelor of Science - Computer
IndiaSkills
Led initiatives to develop scripts utilizing VBScript, JavaScript, and Unix shell scripts Guided team members in implementing automation strategies through innovative scripting solutions Contributed to the resolution of script issues, enhancing operational efficiency
Oversaw database management utilizing MS Access, MS SQL Server 2008, Oracle 9i, MariaDB, and YugabyteDB Enhanced data entry and retrieval processes to optimize database functionality Partnered with team members to effectively troubleshoot and resolve database challenges
Led application development initiatives utilizing Java, J2EE, C, and HTML Coordinated with team members to identify and resolve coding challenges Drove project success through active participation in software testing and debugging processes
Led data integration initiatives by effectively utilizing ETL tools Oversaw extraction, transformation, and loading of data with Informatica 81 Partnered with team members to identify and resolve data-related challenges
Led initiatives to enhance data analysis and visualization by utilizing reporting tools such as Cognos 1107 and Tableau Drove data-informed decision-making through strategic reporting practices Fostered collaboration among team members to elevate reporting capabilities
Oversaw system operations by managing troubleshooting efforts and implementing effective solutions Championed enhancements in system functionality through user feedback integration and adherence to industry best practices Drove improvements in system performance, contributing to elevated user satisfaction levels
Directed teams in the application of big data technologies, including Hadoop, Hive, and Spark, to optimize data processing capabilities Oversaw data storage and management initiatives through HDFS and Qlik, facilitating effective data visualization Championed the implementation of change data capture processes to uphold data accuracy and integrity
Certification
- IBM Cognos BI Solution Expert
- IBM Cognos BI Technical Specialist
- IBM Cognos 10 BI Administration
- IBM Cognos 10 BI Author
- Teradata basics Certification
- PMP (Project Management Professional)
- Cloudera (CDH) Administrator
Timeline
Lead Software Engineer
Great Eastern
08.2022 - Current
Lead Software Engineer
Great Eastern
09.2019 - 10.2021
Senior Software Engineer
Optimum Solutions (Citi Bank)
01.2016 - 09.2019
Senior Software Engineer
L&T InfoTech
07.2015 - 12.2015