Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Timeline
Generic

Srinivasan Rajasekaran

Milpitas,USA

Summary

7 years experience in Power BI, Microsoft SSRS and Data modelling using MS SQL Server and PostgreSQL. 7 years experience in Database development and administration to support financial product and the corresponding data warehousing. 7 years experience in Azure DevOps. 5 years experience in data ingestion using MS SSIS and Python. 1 year experience in data modelling in Microsoft Data Fabric.. Excellent Data analytical experience around financial and legal data. Excellent in performance Optimization in Power BI and Database. Insightful Analytics Engineer known for high productivity and efficiency in task completion. Possess strong skills in data modeling, statistical analysis, and machine learning algorithms. Excel in problem-solving, critical thinking, and effective communication, ensuring successful project outcomes through collaboration and innovative solutions. Highly-motivated employee with desire to take on new challenges. Strong work ethic, adaptability, and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.

Overview

7
7
years of professional experience

Work History

Senior Database and Analytics Engineer

Alphastream Technologies
Bengaluru, India
07.2024 - 01.2025
  • Analyze business requirements and translate them into detailed technical specifications for Business Intelligence (BI) solutions, ensuring alignment with organizational goals
  • Design and implement comprehensive data warehousing solutions to effectively consolidate data from multiple sources, supporting robust data analysis and reporting
  • Create Dashboards using PowerBI to support the product team
  • Design, develop, and optimize SQL objects, including Views, Functions, and Stored Procedures, tailored to meet specific business needs and improve database performance
  • Provision, configure, and manage SQL VMs in Azure, ensuring optimal performance, security, and cost-effectiveness in cloud environments
  • Migration of SQL Server artifacts to PostgreSQL
  • Responsible for training junior engineers, fostering a culture of teamwork, innovation, and continuous improvement
  • Developed ETL processes to efficiently integrate case management data, improving data accuracy and reducing processing time by 50%
  • Designed trend analytics dashboards that provided actionable insights, enabling data-driven decision-making and identifying key patterns in legal case outcomes

SQL Developer

Crédit Agricole Corporate and Investment Bank
Singapore
09.2023 - 06.2024
  • Developed Custom SQL Code for Validating Data Dictionary between Database and Reporting
  • Designed Complex SQL Objects for banking financial data
  • Query Optimization and Error Handling in the complex store Procedures
  • Requirements Gathering from Business stakeholders and translating them into SQL Logic

Database Engineer

Alphastream Technologies
Bengaluru, India
06.2022 - 09.2023
  • Analyze business requirements and translate them into detailed technical specifications for Business Intelligence (BI) solutions, ensuring alignment with organizational goals
  • Design and implement comprehensive data warehousing solutions to effectively consolidate data from multiple sources, supporting robust data analysis and reporting
  • Design, develop, and optimize SQL Server objects, including Views, Functions, and Stored Procedures, tailored to meet specific business needs and improve database performance
  • Provision, configure, and manage SQL Server VMs in Azure, ensuring optimal performance, security, and cost-effectiveness in cloud environments
  • Designed high-performance stored procedures that improved UI loading time from 10 seconds to 50 milliseconds
  • Automated data validation processes, increasing accuracy and reducing manual effort by 90%

SQL Analytics Consultant

RheinBrücke IT Consulting Pvt Ltd
Chennai, India
01.2022 - 05.2022
  • Worked with the Analytics Team to design Reports in SSRC and Power BI based on the business requirements
  • Design and implement comprehensive data warehousing solutions to effectively consolidate data from multiple sources, supporting robust data analysis and reporting
  • Design, develop, and optimize SQL Server objects, including Views, Functions, and Stored Procedures, tailored to meet specific business needs and improve database performance
  • Designed and developed SSRS reports to deliver actionable insights and enhance data-driven decision-making

Software Engineer

Customer Analytics Pvt Ltd
Chennai, India
06.2021 - 12.2021
  • Data extraction using SQL and Python for Importing Test Cases, Plans into Azure DevOps
  • Supported to manage large, complex related databases
  • Extracted Data from Large XMLs and transformed them in SQL

Software Engineer

RheinBrücke IT Consulting Pvt ltd
Chennai, India
02.2018 - 06.2021
  • Designed and developed SSRS reports and Power BI dashboards to deliver actionable insights and enhance data-driven decision-making
  • Design, develop, and optimize SQL Server objects, including Views, Functions, and Stored Procedures, tailored to meet specific business needs and improve database performance
  • Responsible for requirement gathering and develop Reports and Dashboard
  • Designed SSRS Generator in C# to Generate Static Reports (RDL File) Based on the product Configuration

Education

B.E. - Computer Science Engineering

Anna University
Chennai, India
05.2017

Skills

  • SQL Server Reporting Service (SSRS)
  • Power BI
  • SQL Server Analysis Services (SSAS)
  • SQL Server Integration Services (SSIS)
  • Python
  • SQL server
  • Microsoft Data Fabric
  • MSSQL
  • MySQL
  • PostgreSQL
  • Azure DevOps
  • Jenkins
  • AWS S3
  • Dynamo DB
  • Elastic search

Accomplishments

  • Authored 'Smart Vehicles with IoT,' ISBN: 978-81-931933-0-3, contributing to advancements in IoT applications in automotive technology.
  • Published a Paper titled 'Smart Vehicles with Everything,' IEEE, ISBN: 978-1-5090-5256-1, 2016, highlighting innovative approaches to smart vehicle integration.

Timeline

Senior Database and Analytics Engineer

Alphastream Technologies
07.2024 - 01.2025

SQL Developer

Crédit Agricole Corporate and Investment Bank
09.2023 - 06.2024

Database Engineer

Alphastream Technologies
06.2022 - 09.2023

SQL Analytics Consultant

RheinBrücke IT Consulting Pvt Ltd
01.2022 - 05.2022

Software Engineer

Customer Analytics Pvt Ltd
06.2021 - 12.2021

Software Engineer

RheinBrücke IT Consulting Pvt ltd
02.2018 - 06.2021

B.E. - Computer Science Engineering

Anna University
Srinivasan Rajasekaran