Prabhakaran V

Company Overview:
HDFC Bank Limited is one of India's leading banking and financial services institutions, offering a wide range of services including retail and wholesale banking, loans, credit cards, and digital platforms such as PayZapp and SmartBUY.

Role Summary:
Worked as a Data Analyst in the Credit Card department, focusing on data-driven decision-making, regulatory reporting, and business intelligence solutions to support credit card operations and compliance

Key Responsibilities:

• Designed and developed automated dashboards and reports using Power BI to support high-level management decisions.
• Extracted, cleaned, and analyzed large datasets using SQL from multiple sources to track credit card performance metrics such as sourcing, spending, payments, charges, and loan activities.
• Performed ad-hoc data analysis and generated insights to support various business functions and initiatives.
• Collaborated with cross-functional teams to gather and translate business requirements into data-driven solutions and technical specifications.
• Created and maintained SQL stored procedures to automate manual reporting processes and improve operational efficiency.
• Developed and maintained RBI compliance reports, ensuring accurate and timely submissions.
• Participated in limit enhancement processes for credit card and overdraft products through detailed data validation and reporting.
• Authored business documents including Business Requirement Documents (BRDs) and process flow documentation to support project implementation.
• Worked closely with business stakeholders to support regulatory audits and ensure compliance with internal and external data policies.

Key Achievements:

• Successfully transitioned multiple manual reports into automated solutions, reducing turnaround time and improving data accuracy.
• Contributed to business intelligence strategy by integrating complex datasets into actionable insights using visualization tools.
• Recognized for cross-departmental coordination and timely delivery of compliance-related reporting.

Company Overview:
Sedin Technologies is an IT consulting, system integration, and software services company founded in 2006. Headquartered in Chennai, India, Sedin has expanded globally with offices in the United States, Canada, Malaysia, and Australia. The company specializes in full-stack development, enterprise-specific solutions, data analytics, and engineering, catering to both startups and large-scale enterprises.

Role Summary:
As a Software Developer at Sedin Technologies, I was responsible for performing SQL development, deploying application fixes and patches, and enhancing database performance. My role involved designing and optimizing database objects, ensuring efficient data handling, and contributing to the development of scalable solutions.

Key Responsibilities:

• SQL Development: Developed and optimized SQL queries, stored procedures, functions, and triggers to support application functionality and performance.
• Database Design: Created and maintained database objects such as tables and indexes, ensuring data integrity and efficient access.
• Performance Optimization: Analyzed and improved the performance of T-SQL stored procedures and queries, reducing execution times and resource consumption.
• Application Deployment: Coordinated the deployment of application fixes, patches, and improvements, ensuring minimal downtime and seamless updates.
• Data Handling: Managed large data types and complex data structures, implementing efficient solutions for data storage and retrieval.
• Code Reusability: Provided recommendations for the development of new code or reuse of existing code, promoting efficiency and maintainability.

Key Achievements:

• Performance Enhancements: Successfully optimized database queries and stored procedures, leading to a significant reduction in processing times and improved application performance.
• Scalable Solutions: Designed and implemented database structures that supported the scalability of applications, accommodating growing data volumes and user loads.
• Collaboration: Worked closely with cross-functional teams to understand business requirements and translate them into technical solutions, ensuring alignment with organizational goals.

Company Overview:
Matrimony.com Limited is India's leading online matrimony service provider, offering a wide range of matchmaking platforms catering to various communities, professions, and regions.The company operates brands like Bharat Matrimony, Elite Matrimony, Community Matrimony, and Jodii.

Role Summary:
As a Campaign Analyst & Developer at Matrimony.com, I was responsible for leveraging data to drive marketing campaigns, enhance customer engagement, and support business decision-making through advanced analytics and reporting.

Key Responsibilities:

• Campaign Development & Execution: Designed and implemented targeted marketing campaigns using IBM Unica Campaign, aligning with business objectives and customer segmentation strategies.
• Data Analysis & Segmentation: Analyzed customer data to identify segments based on behavior, preferences, and demographics, enabling personalized marketing efforts.
• Database Management: Developed and maintained SQL-based solutions, including tables, stored procedures, views, and indexes, to support data processing and reporting needs.
• Data Integration & Migration: Extracted data from various sources, transformed it to meet business requirements, and migrated it to target systems, ensuring data integrity and consistency.
• Reporting & Visualization: Created and managed reports and dashboards using Power BI, providing actionable insights to stakeholders and supporting data-driven decision-making.
• Quality Assurance: Conducted data validation and testing to ensure the accuracy and reliability of campaign data and reporting outputs.
• Collaboration & Documentation: Worked closely with business teams to understand requirements, document processes, and deliver solutions that meet organizational goals.

Key Achievements:

• Enhanced Campaign Effectiveness: Improved targeting and personalization of marketing campaigns, leading to increased customer engagement and conversion rates.
• Optimized Data Processes: Streamlined data workflows and automated reporting processes, reducing manual effort and turnaround time.
• Supported Strategic Decisions: Provided timely and accurate data insights that informed strategic business decisions and contributed to organizational growth.

Company Overview:
Claritaz TechLabs is an IT services and consulting company specializing in developing and implementing ERP solutions for various clients. The company focuses on business process management software that integrates essential business departments.

Role Summary:
As a SQL Developer at Claritaz TechLabs, I was responsible for supporting ERP product development and implementation, ensuring data integrity, and providing analytical insights to optimize business processes.

Key Responsibilities:

• ERP Product Implementation: Assisted in the deployment and customization of ERP solutions based on client specifications, ensuring alignment with business objectives.
• Database Development: Utilized Oracle 10g/11g/12c to design and develop database objects, including tables, stored procedures, functions, and views, to support ERP functionalities.
• Forms and Reports Design: Created and maintained user interfaces and reports using Oracle Forms Builder and Oracle Reports Builder, facilitating efficient data entry and reporting.
• Data Migration: Managed the extraction, transformation, and loading (ETL) of data from legacy systems to the new ERP platform, ensuring data accuracy and consistency.
• Business Process Analysis: Collaborated with clients to understand their business processes, identifying areas for improvement and recommending ERP solutions to enhance efficiency.
• Testing and Quality Assurance: Conducted thorough testing of ERP modules, identifying and resolving defects to ensure system reliability and performance.
• Documentation: Prepared detailed documentation for ERP configurations, customizations, and user guides to support client training and system maintenance.

Key Achievements:

• Successful ERP Deployments: Contributed to the successful implementation of ERP solutions for multiple clients, leading to improved business operations and client satisfaction.
• Enhanced Data Integrity: Ensured accurate data migration and integration, reducing data discrepancies and enhancing decision-making capabilities.
• Process Optimization: Identified and streamlined business processes through ERP customization, resulting in increased operational efficiency

Company Overview:
Ramco Systems is a global enterprise software company specializing in cloud-based ERP solutions. Their offerings encompass various modules, including Manufacturing, Finance, Supply Chain Management, Human Capital Management, and Enterprise Asset Management, designed to streamline business processes and enhance operational

Role Summary:
As a Project Trainee at Ramco Systems, I was responsible for supporting ERP product development and implementation. My role involved working with MSSQL technologies, managing data migration, and collaborating with cross-functional teams to meet client requirements.

Key Responsibilities:

• Report Development: Created Advanced and Enterprise Reports using the RDW (Report Development Workbench) tool.
• Backend Integration: Worked closely with the front-end team to implement core business logic via stored procedures and functions.
• Database Development: Designed and implemented Stored Procedures, Triggers, Views, Joins, and Constraints to fulfill business requirements.
• Performance Optimization: Conducted SQL performance tuning using tools such as SQL Profiler and Execution Plans; optimized performance through strategic indexing.
• Feature Enhancement & Support: Participated in the development of new functionalities as per Business Requirements and Functional Specifications, and handled defect resolution.
• UI/Report Design: Built user interfaces using Oracle Forms Builder and reports using Oracle 10g Reports Builder.
• ERP Implementation: Involved in end-to-end ERP product implementation tailored to client-specific business processes.

Key Achievements:

• Successful ERP Deployments: Contributed to the successful implementation of ERP solutions for multiple clients, leading to improved business operations and client satisfaction.