Experience

Perbadanan Insurans Deposit Malaysia

• Financial Services
• 1 - 100 Employee

• Senior BI consultant

  • Apr 2022 - Present



Ramco Systems

• India
• Software Development
• 700 & Above Employee

• Senior System Analyst

  • Apr 2019 - Present

  • Developed and managing SSIS (ETL) Package for uploading Master data (TEXT file format) from SAP to Ramco. • Implemented automatic PGP encryption and decryption for upload file and success files.• Managing the Support Process for above mentioned projects in APAC region with 5 member team in INDIA.• Involved in Requirement gathering & Development process for verifying requirements based on system functionality.• Preparing project plan to meet customer requirement on project delivery.• Handling Customer Escalations for the above mentioned projects.• Preparing customer survey to ensure smooth Support process & improvement.• Preparing daily & monthly dashboards using issue logging system to analyze issues trending to present that to management.

• System Analyst

  • Oct 2016 - Mar 2019

  • Developed & Managed SSIS ETL package to process Employee attendance by loading employee clock details from TEXT file.• Developed & Managed SSIS ETL package to process Employee Master data into ramco systems from CSV file.• Developed & Managed T-SQL package to process Employee Master data into ramco systems from TEXT file.• Used NIFI ETL Tool to load employee master data from user format to system required format.• Requirement gathering from the application users wherever they require new changes in the system.• Preparing system process flow diagrams to present the requirement & process to technical teams to develop the new requirement.• Providing Database production support to the customers which includes following activities.• Works on Support tickets, Maintenance tasks and assigned projects at discretion of the Reporting Coordinator.• Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking• Configuring and troubleshooting high availability scenarios like Log Shipping.• Managing Database Mirroring with High Availability Mode in SQL 2012• Maintained & Monitored Alert/Schedule to make smooth replication process.• Ensure and maintain sound backup and recovery policies and procedures.• Database performance monitoring and tuning when required as per application and business requirements.• Backup and restoring the databases from production to test environment.• Ensuring Data consistency in the database through DBCC commands.• Working with business analyst group to ascertain their database reporting needs.• Take the database reporting needs and turn them into powerful SQL queries that will extract data and compile it into meaningful reports.• Ensured that the existing data warehouses, reporting systems, various tools were adequately supported.

• Program Analyst

  • Feb 2014 - Sep 2016

  • Developed SSIS ETL package to process Employee attendance by loading employee clock details from TEXT file.• Developed SSIS ETL package to process Employee Master data into ramco systems from CSV file.• Developed T-SQL package to process Employee Master data into ramco systems from TEXT file.• Providing Database production support to the customers which includes following activities.• Works on Support tickets, Maintenance tasks and assigned projects at discretion of the Reporting Coordinator.• Performed SQL Server version upgrades and patch installs by communicating with appropriate teams.• Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking• Configuring and troubleshooting high availability scenarios like Log Shipping.• Implemented Database Mirroring with High Availability Mode in SQL 2012• Maintained & Monitored Alert/Schedule to make smooth replication process.• Ensure and maintain sound backup and recovery policies and procedures.• Database performance monitoring and tuning when required as per application and business requirements.• Backup and restoring the databases from production to test environment.• Ensuring Data consistency in the database through DBCC commands.• Working with business analyst group to ascertain their database reporting needs.• Take the database reporting needs and turn them into powerful SQL queries that will extract data and compile it into meaningful reports.• Ensured that the existing data warehouses, reporting systems, various tools were adequately supported.• Updated existing and created new reports using Microsoft SQL Server Reporting Services.• Providing Connection between MS SQL & MS Excel to load data into Excel, Users to prepare their own report.



Firstsource

• India
• Outsourcing and Offshoring Consulting
• 700 & Above Employee

• Process Associate

  • Feb 2013 - Feb 2014

  • Performed data upload & report process of 10 Million records in to the system using MS SQL & T-SQL Package on daily basis. • Prepared daily ageing report to Business users. • Prepared adhoc reports to business user whenever they were in need Using MS Excel & MS Access. • Uploaded the adhoc data using MS Access & Excel Macro. • Provided 24*7 support during my tenure. • Prepared process flow document for Adhoc reports to ensure perfect delivery on the requirement. • Prepared Fetch/Search report using Excel Macro for Business users.