About

Prabhakaran Jayaraman — Senior Data Engineer. Favorite topics: Power BI, SQL Server (T-SQL), SQL Server (SSIS), SQL Server (SSRS), Azure Data Factory, TIBCO Jaspersoft.

Career, end to end

Experience

Technical Lead | 16+ Years | Primary SKill – Data Warehousing (DW) & Monitoring Systems | MSSQL • Snowflake • Databricks • Python • SSIS • SSAS • SSRS • Power BI • Jasper Soft • ADF | Healthcare, Insurance & Retail

Secondary Skill | HTML5 • CSS3 • C#/.NET • ASP.NET Core & Web API • Web Service

Technical Lead

Current

L&T Technology Services · Full-time

Jun 2026 – Present · 3 mos · Pune District, Maharashtra, India · Remote

Technical Team Lead

Intelliswift – An LTTS Company · Full-time

Oct 2025 – Jun 2026 · 9 mos · Pune City, Maharashtra, India · Hybrid

Skills: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) +9 more

Manager C2

Capgemini · Full-time

Oct 2021 – Sep 2025 · 4 yrs

Skills: Extract, Transform, Load (ETL), Databases +8 more

Accenture

9 yrs 10 mos

Application Development Specialist

Full-time · Nov 2020 – Oct 2021 · 1 yr

Show role details
  • Extensive experience in data transformation and loading (ETL) using SQL Server Integration Services (SSIS).
  • Built workflows with Data Flow, Execute SQL, File System, and Bulk Insert tasks and containers.
  • Worked with transformations such as Derived Column, Conditional Split, Aggregate, Sort, Data Conversion, Merge Join, Lookup, and Union All.
  • Created and scheduled daily and weekly SSIS packages as SQL Server Agent jobs.
  • Strong background in SQL Server 2008 database development and migration.
  • Deep working knowledge of SQL Server concepts — DML, DDL, DCL, functions, stored procedures, joins, indexes, subqueries, constraints, views, and more — across SQL Server 2005, 2008 R2, and 2012.
  • Strong grounding in dimensional modeling and T-SQL for tables, triggers, user functions, views, and relational data models.
  • Built backend validation through insert/update/delete triggers and views for reporting.
  • Wrote stored procedures for varied application tasks and tuned them alongside development teams.
  • Handled data extraction, cleansing, integration, and loading across multiple sources using SSIS, with package- and task-level logging.
  • Configured SSIS packages with the Package Configuration Wizard to run across environments.
  • Worked within ServiceNow and Jira across the software development cycle.

Skills: Extract, Transform, Load (ETL), Jasper Reports

Application Development Senior Analyst

Jan 2016 – Oct 2020 · 4 yrs 10 mos · Bangalore

Show role details
  • Worked across UI technologies including HTML5, CSS3, jQuery, JavaScript, and Bootstrap.
  • Designed SQL Server databases and developed queries, views, functions, stored procedures, and triggers.
  • Used Photoshop CS3 for image correction, banner creation, and icon design.
  • Built on ASP.NET 2.0/3.5 with C# and Entity Framework.
  • Handled testing, implementation, and user training phases of development.
  • Delivered work across finance, banking, and health domains.
  • Designed and developed ASP.NET forms using Visual Studio 2015.

Skills: Extract, Transform, Load (ETL)

Application Development Analyst

Mar 2014 – Dec 2016 · 2 yrs 10 mos · Bangalore

Show role details
  • Built standardized SSRS reports to meet client requirements.
  • Delivered tabular, matrix, drill-down, drill-through, parameter, cascading, sub-, and chart reports.

Skills: Extract, Transform, Load (ETL)

Associate

Jan 2012 – Feb 2014 · 2 yrs 2 mos · Bangalore

Senior Software Engineer

Zenta · Full-time

Jun 2011 – Dec 2011 · 7 mos · Chennai, Tamil Nadu

Show role details
  • Developed stored procedures, functions, and triggers for data integrity using T-SQL in SQL Server.
  • Designed and implemented stored procedures and views in SQL Server 2008.
  • Displayed, edited, and deleted data using the DataGrid control.
  • Used AJAX calls to fetch data from the database and render it on the page.

Software Engineer

CYOURS – India · Full-time

Jun 2008 – Mar 2011 · 2 yrs 10 mos · Chennai, Tamil Nadu

Show role details
  • Designed, coded, and implemented GUIs using ASP.NET Web Forms, HTML, and CSS.
  • Developed stored procedures, functions, and triggers for data integrity in SQL Server.
  • Used JavaScript for client-side validation and event handling.
  • Designed and implemented stored procedures and views in SQL Server 2005.
  • Displayed, edited, and deleted data using the DataGrid control.
  • Used AJAX calls to fetch data from the database and render it on the page.
  • Provided ongoing application support and maintenance.

Prabhakaran Jayaraman