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
Machine learning basics
Advanced ETL development
Azure Data Factory
Predictive Data Modeling
Business intelligence tools
Powershell
Python
DBT
Snowflake
Data Architecture and Data Governance
Oracle pl/Sql
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 -