Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Certification
Timeline
Generic
Ponraj Velusamy

Ponraj Velusamy

Associate Architect
Bengaluru

Summary

  • I have 13+ years’ experience in Azure Data Factory, Azure Devops, PowerShell,
    Python, Azure Data Lake, Databricks, SQL Server, SSIS, SSAS, SSRS,Power Bi, MachineLearning with role as Associate Architect.
    • Responsibilities take care of development project and co ordination with the team members to make the project a success.
    • Working in Strategic Insights and Analytics system. It is Enterprise BI solutions
    • Enthusiastic learner who quickly grasps new concepts and technical skills.
    • Worked Azure Data Factory for fetch the Data from on-premises to Azure Datawarehouse.
    • Build tool to extra JIRA worklog into JSON file. Build a datamart.

Overview

14
14
years of professional experience
2
2
Certifications

Work History

Associate Architect

Carelon Global Solutions
11.2020 - Current
  • Developed comprehensive architectural plans to meet specific budgetary requirements and project timelines.
  • Attended industry conferences and workshops to stay updated on current trends in architecture and design practices.
  • Improved client satisfaction with timely and efficient project deliveries, maintaining excellent communication throughout the process.
  • Design converting SSIS Package into Azure Data Factory solution
  • Implement and solutioning for Cloud Migration
  • Fixing high critical issues and managing medium team size for project development.

Senior Associate

Cognizant
05.2019 - 11.2020
  • Collaborated with cross-functional teams to drive successful completion of complex projects within deadlines.
  • Creating Data model for build DataMart for Business Operation Executives
    • Write a powershell script to fetch the records from various source. such as oracle.
    Teradata..Etc.
    • Created SSIS Package for ETL purpose.
    • Improved performance on Reporting stored procedure.
    • Created SQL Agent job to schedule PowerShell, ETL, procedures task.
    • Managing and encouraging the Team to provide the right support client.
    • Prepared Bi-weekly status report and send the client.
    • PAAS Migration - Converting SSIS Package to Azure Data Factory
    • Configuring Failure and success mail by using Send grid and logic Apps.


Database Specialist

FIS Global
11.2018 - 05.2019
  • Creating automation powershell script to check TLS 1.2 enabled on Database
  • Backup and restore Database to various server
  • Complex queries performance tuning and create stored procedure
  • Performed capacity planning activities related to storage optimization and resource utilization.
  • Ensured high availability of databases through regular monitoring, maintenance, and backup procedures.

Tech Lead

Accenture Service Pvt.Ltd
10.2014 - 11.2017
  • Mentored junior developers, fostering a culture of continuous learning and skill improvement.
  • Collaborated with product managers to define technical requirements and develop innovative solutions for complex problems.
  • Extracting the Data from root Unbuntu server using hive query and load into destination
    RedHat-Server.
    • Configuring Eclipse and run the Spark Automated Deployment command.
    • Enabling the team to complete their user stories
    • Workerd Ambari, Hue services, HDFS,File browser, Zoo Keeper
  • Played key role in SQL Upgrade 2014 and Data Archival release.
    • Involved in all stages of DA release-planning,design,build,testing and
    deployment
    • I had expertise knowledge and able to deliver quality code on time.
    • I have deep knowledge on SQL upgrade + Data Archival techniques /
    Processes.
    • I took build coordinator role and able to make sure build files are accurate and
    maintain timelines with various stakeholders.

Software Engineer

Ramco Systems Pvt Ltd
12.2013 - 09.2014
  • Developed scalable and maintainable code, ensuring long-term stability of the software.
  • Developed database structure and architecture to accommodate user requirements.
  • Created stored procedures, triggers, tables, views and functions using T-SQL.
  • Optimized existing queries to improve performance of the system.
  • Designed and implemented data migration from legacy systems to new databases.
  • Designed ERP Tool for Aviation MR tool.

Software Engineer

ProtechSoft System Pvt Ltd
05.2011 - 12.2013
  • Developed scalable and maintainable code, ensuring long-term stability of the software.
  • Integrated new technologies into existing systems, increasing capabilities and improving overall performance.
  • Developed reusable components that significantly reduced development effort on multiple projects.
  • Implemented effective debugging strategies, resulting in fewer software defects and increased reliability.
  • Developed complex Oracle PL and SQL packages, procedures, functions and triggers to support application development.
  • Analyzed existing database objects for performance issues and implemented tuning solutions.
  • Performed code reviews, debugging, optimization and fine-tuning of SQL queries and PL and SQL programs.

Education

No Degree - Data Science And Machine Learning

Scaler
Bangalore
04.2001 -

Master of Science - Computer Science And Information Technology

Madurai Kamarajar University
Madurai, India
04.2001 -

Skills

Microsoft SQL

Websites

Accomplishments

  • Couple of times got awards for extraordinary performance in Delivery unit Level.
  • Accenture Celebrate Excellence (ACE) in Numero Uno category for great technical delivery and batch job and application performance improvement.
  • Avanade Orange award for 40K users Application improvement.
  • IMPACT Awards received for Savings 22k$ for building automation tool.

Certification

DP-200 Implementing Azure Data Solutions

Timeline

Associate Architect

Carelon Global Solutions
11.2020 - Current

DP-200 Implementing Azure Data Solutions

12-2019

Senior Associate

Cognizant
05.2019 - 11.2020

Database Specialist

FIS Global
11.2018 - 05.2019

70-461- Querying Microsoft Sql Server

06-2015

Tech Lead

Accenture Service Pvt.Ltd
10.2014 - 11.2017

Software Engineer

Ramco Systems Pvt Ltd
12.2013 - 09.2014

Software Engineer

ProtechSoft System Pvt Ltd
05.2011 - 12.2013

No Degree - Data Science And Machine Learning

Scaler
04.2001 -

Master of Science - Computer Science And Information Technology

Madurai Kamarajar University
04.2001 -

Similar Profiles

CREATE PROFILE
Ponraj VelusamyAssociate Architect