Summary
Overview
Work History
Education
Skills
Accomplishments
Projects
Timeline
Generic

KARTHIKRAJ RANGARAJ

San Francisco,California

Summary

Technocrat with 12 years and 6 months of working experience in SQL database, ETL Tools. With specialization in Azure's Data ecosystem .

Overview

13
13
years of professional experience

Work History

Project Manager

Ultragenyx
01.2023 - Current


  • Led the design and development of a scalable Azure-based analytics platform, improving data processing speed by using Azure Synapse
  • Built the pipelines to migrate the data from source to destination in Azure Synapse
  • Good hands-on Azure Synapse by creating Pipelines, Data flows and with Linked service
  • Implemented CI/CD pipelines within Azure DevOps to enhance team productivity and shorten release cycles.
  • Optimized database performance by using T-SQL
  • Started to built POC project by engaging with Microsoft Product Team on Fabric on the vision to move from Synapse to Fabric world on the future prospects.

Project Manager

Mylan
11.2021 - 12.2022
  • Facilitated project planning by effectively estimating technical tasks, resulting in superior sprint execution and 100% on-time delivery .
  • Developed extensive ETL pipelines utilizing Azure Data Factory
  • Integrated Apache Spark with Azure Databricks to streamline data pipeline constructions
  • Responsible for the L1/L2 support on application issues, and on servicing standard issues from users
  • Performed data migration from SQL SERVER to Azure Synapse Analytics Using staging concept with Azure data Lake storage GEN2

Senior Consultant

Blue Shield Of CA
08.2014 - 10.2021
  • Involved in all Analysis, Development, Testing, Tuning and Maintenance, as well as resolved problems during project implementation
  • Analyzed requirements specification from the business and assess feasibility of implementation
  • Prepared requirements specification, design specification and Unit Test case documents based on the business logic
  • Had been Responsible for preparing Impact analysis based on CR requirement
  • Have done Coding impact and dependencies finding based on the changes of business requirements
  • Migration plan preparation for the developed jobs
  • Experience in moving the data from heterogeneous data sources like oracle, json etc
  • Developing scalable and re-usable frameworks for ingesting

Product Analyst

Standard Chartered Bank
05.2011 - 08.2014
  • Executed complex SQL queries to analyze customer data
  • Created Informatica mappings, sessions and workflows using different transformations to implement business logic.
  • Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center Designer.
  • Updated existing Unix scripts and implemented same. Worked on Informatica Partitions for increase job performance
  • Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer and Transformation Developer

Education

Bachelor of Engineering -

Anna University Tiruchirappalli
Tiruchirapalli
04.2011

Skills

  • SQL
  • Python
  • Data Fabric
  • Azure Synapse
  • Azure Data factory
  • Azure Data Lake Gen1/2
  • Azure Logic app
  • Azure Databrick
  • Spark SQL
  • Informatica
  • Oracle

Accomplishments

Received "Blue Star" Award for my outstanding contribution in the Project activities .


Successfully optimized Azure SQL resource usage, slashing significant costs.



Projects

Cloud DataWarehouse (02/2023 - Present) - To migrate the commercial warehouse from existing 3rd party vendor-maintained AWS cloud to the new Azure based cloud-data environment hosted by Ultragenyx and support the application.


Mylan Analytics (11/2021 -12/2022) - This project mainly focuses on reporting and analysis for plan and actual in the areas of brand and marketing contribution which includes gross sales / standard COGS, gross to net sales, brand marketing expenses, and other marketing contribution, marketing. The solution is ultimately intended to serve as an enterprise wide data warehouse.


Consumer Billing and Shield Accelerate (08/2014 - 10/2021) - Blue Shield are launching a new approach to paying providers that will process members’ claims in real time. By developing a scalable cloud platform that will integrate solutions from Blue Shield’s other technology partners, the companies will digitize health care claims using automated processing, artificial intelligence, and machine learning technologies to greatly improve the accuracy and timeliness of billing information and claims payment.


CreditMate ( 05/2011 - 07/2014) - Credit Mate is an “in-house “software used commonly in Standard Chartered Bank. It is part of an  initiative to improve the end-to-end credit process. It aims to improve the quality of data, ensure  compliance to credit policies, and create standardized processes across customer segments and  geographies. 

Timeline

Project Manager

Ultragenyx
01.2023 - Current

Project Manager

Mylan
11.2021 - 12.2022

Senior Consultant

Blue Shield Of CA
08.2014 - 10.2021

Product Analyst

Standard Chartered Bank
05.2011 - 08.2014

Bachelor of Engineering -

Anna University Tiruchirappalli
KARTHIKRAJ RANGARAJ