Summary
Overview
Work History
Education
Skills
Websites
Certification
Languages
Timeline
Generic

KIRUTHIKA DINAKARAN

Mississauga,ON

Summary

A Data Developer with almost 5 years of solid experience in data collection, extraction, reporting, automation, cleaning, analysis, manipulation, migration and maintenance. Strong experience in Reporting and Visualizing KPI’s related to Retail & Logistics Operations, sales, products and compliance, performance metrics security transactional data. Worked on Data Modelling, Data Lifecycle Management DLM, Data Quality Management DQM, ETL flow Data Pipelines, Validation, Data Integration (ETL/ELT Processes), Process analysis, Project management and Migration projects for Financial, Wealth Data Assets. Demonstrated experience in handling large datasets, and relational databases in different organizations and solid understanding of tuning queries & utilizing best practices addressing and metadata standards. Operational experience with SQL based databases including Oracle and Microsoft SQL Server. Skilled in Data Analytics and Visualization tools: SQL, Microsoft Power BI, Tableau. Used Linux shell scripting for inbound source file management to get data from server to HDFS. Effectively communicated in both verbal and written forms, collaborative team player prioritized and completed committed deliverables on time, translated business requirements into technical and non-technical audience.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Big Data Developer

CTDI – Oakville, Canada(Contract)
03.2022 - Current
  • Developed Python Re-usable framework modules for ETL for extracting ADLS Delta table SQL queries
  • Developed and Optimized PySpark modules to help improve the profitability of MCE Wireless and CPE business by 10%
  • Worked on Landing, Ingestion, Curation and Analytical zones and handled Change Data Captures CDC and Slowly Changing Dimension SCD's.
  • Created powerful Tableau dashboards from analytical zones to do DQ dimension checks, Null Checks, total record count checks.
  • Developed P & L reports daily and reconciled the Daily, Weekly, Monthly changes with variable tiers cost.
  • Achieved significant cost savings through resource optimization strategies including proper partitioning, indexing, caching, and compression techniques within the big data environment.
  • Wrote software that scaled to petabytes of data and supported millions of transactions per second.
  • We used to involve in designing the structure of databases to ensure efficient data storage and retrieval
  • We decide on the schema, tables, and relationships between different entities
  • Helped organization to migrate wealth data assets from on-prem to azure cloud from assessing pipelines in lower environments and pushed promoted code to higher environments for converged data analysis
  • Constructed data reporting, visualizations, dashboards using Oracle SQL, Advanced Excel and Power BI for business KPIs that reduced manual reporting work by 8 hours
  • Ensuring data accuracy, consistency, and integrity is a critical aspect of a DBA's role
  • We implement constraints, validations, and data quality checks to maintain the reliability of the data
  • Using Performance tuning method we used improve the speed of the query
  • Engaged in SQL data processing for reselling business for different vendors/companies in North America
  • Extensively used SQL and Linux shell scripting to manipulate and query data from different SQL servers
  • Created advanced windowing SQL functions to extract the data based on window frame, set date, set patterns, aggregation patterns, Top N, and Bottom N set of rows for advanced data extraction.
  • Streamlined complex data workflows by automating tasks using scheduling tools like Apache Airflow or Oozie.

Bid Data Developer

Atos, India
05.2020 - 01.2022
  • Created new database for ecommerce website with deep learning computer vision numerous simple to complex queries, views, indexes (clustered and no clustered), store procedures involving multi-table joins, self joins and correlated sub queries
  • Used ServiceNow to create support tickets for upstream, downstream teams, used extensively to manage incidents, changes and Risk management
  • Used stored procedures, triggers, and views to provide structured data to business units by combining millions of rows of data from 6 disparate data sources
  • Communication with client to understand business needs, business performance, business strategy, Problem-solving, decision-making and translate those business needs into actionable reports in Power BI saving 16 hours of manual work each week
  • Using advanced analytics SQL and Excel identified common customer complaints amongst new customers leading to changed that improved new customer satisfaction
  • Interacting with stakeholders to understand business requirement and in mapping transformation rules from Legacy System to SAP
  • Created and developed 100+ dashboards execution for Management and Quality team that saved $500k in reporting and provided room for process improvement
  • Constructed Data reporting, visualizations, KPI Scorecards, dashboards using Power BI, Advanced Excel for ad-hoc Business and Data team
  • Enhanced continuous development initiatives and performed week kaizen events to improve the productivity and efficiency of different departments
  • Communicated with clients to understand business needs and translate those business needs into actionable reports saving 16 hours of manual work each week
  • Performed data engineering import of data from RDBMS to Amazon S3 using Talend ETL and then importing to HDFS to process the huge amounts of Data
  • Performed Import and Export of data into HDFS and Hive using Sqoop and managed data within the environment.

Education

Bachelor of Engineering -

ANNA University
05.2019

Skills

  • Apache Spark
  • Extract, Transform, Load (ETL)
  • Microsoft SQL Server
  • Business Analysis
  • Microsoft Azure
  • Git
  • Databases
  • Hive HQL
  • Data Warehousing
  • Python (Programming Language)
  • Data Analytics
  • SQL
  • Analytical Thinking
  • Distributed Systems
  • Data Partitioning
  • ETL development
  • Metadata Management
  • Performance Tuning
  • Data Cataloging
  • SQL Databases
  • Data programming
  • Data Lineage
  • Python Programming
  • Data Engineering
  • Data Migration
  • Hadoop Ecosystem
  • Data Modeling
  • Data Management
  • Big Data Architecture
  • Azure Services

Certification

  • Certified Microsoft SQL Server 2019 Admin
  • AZ-900 Azure Fundamentals
  • Power BI Desktop Certified Associate
  • Oracle Certified Administrator
  • Certified Lean and Six Sigma Greenbelt

Languages

English
Full Professional

Timeline

Big Data Developer

CTDI – Oakville, Canada(Contract)
03.2022 - Current

Bid Data Developer

Atos, India
05.2020 - 01.2022

Bachelor of Engineering -

ANNA University

Similar Profiles

CREATE PROFILE
KIRUTHIKA DINAKARAN