Summary
Overview
Work History
Education
Skills
Websites
Certification
Accomplishments
Languages
Timeline
Generic

JAYAKRISHNAN MG

Chennai

Summary

Technical Lead - Data Analytics with 12 years of experience in the IT and services industry, specializing in Data
Engineering and Business Intelligence. Proficient in Agile/Scrum methodologies with a strong background in
multiple domains, including Insurance, Banking, and Retail. Expertise in design and development of databases
and data warehouses including ETL process. Known for productivity and efficiency in completing projects.
Possess strong skills in algorithm design, system architecture, and code optimization. Good in problem-solving,
communication, and teamwork, ensuring successful collaboration on complex projects.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Technical Lead

UST Global Ltd
Chennai
10.2019 - Current
  • Client: Walmart International
  • Project : ASDA Divestiture
  • Clarity is a project management tool fully owned by Walmart International. ASDA another retail giant located in UK, has acquired this application and some other apps owned by Walmart. Played a key role in this Data migration process from Walmart to ASDA with the help of Cloud platforms.
  • Development of Python and PySpark scripts for each Clarity modules using PyCharm Community Edition and Creation of ETL jobs using Pentaho Kettle tool.
  • Involved in developing Azure data bricks notebooks and data pipelines in ADF to trigger the notebook runs based on user inputs
  • Development of Databricks notebooks in Python, Spark SQL and Pyspark
  • Working on the Databricks to pull the data in Parquet/Avro files stored in ADLS storage and load it in the destination tables which is either Mongo DB or Azure SQL DB
  • Spark job creation and scheduling the jobs by passing the user selection as input arguments
  • Interacted with the business users, collected the requirements, analyse the requirements, design, and recommend solutions.
  • Designed data warehousing solutions, applying dimensional modeling techniques for optimized data retrieval.
  • Conducted data analysis using SQL and Python to derive insights and support decision-making processes.
  • Documented data architecture designs and changes, ensuring knowledge transfer and system maintainability.
  • Automated data quality checks and error handling processes to ensure the integrity and reliability of datasets.
  • Optimized SQL queries and database schemas for performance improvements in data retrieval operations.

Lead Software Engineer

Nest Information Technologies
Dubai
07.2018 - 10.2019
  • Client: Dubai Islamic Bank
  • Project: Immediate Payment Interface Application
  • Dubai Islamic Bank is the largest Islamic bank in the UAE by assets and a public joint stock company listed on the Dubai Financial Market. Spearheading the evolution of the global Islamic finance industry, DIB is also the world's first full-service Islamic bank and the third largest Islamic bank in the world. The Bank is present in seven markets worldwide and is expanding its global footprint to further grow and develop the industry.
  • Immediate Payment Interface (IPI) is an instant payment inter-bank electronic funds
    transfer system in UAE. IPI offers an inter-bank electronic fund transfer service through any channel. This
    service is available 24/7 throughout the year including bank holidays.
  • Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports
  • Responsible for installation and Configuration of SQL Server 2005 and 2008 database and configuration of Report manager
  • Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008/2005
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
  • Developed, deployed, and monitored SSIS Packages run and involved in troubleshooting the job fail.
  • Monitored system performance metrics to identify potential bottlenecks or areas of improvement.
  • Analyzed code and corrected errors to optimize output.
  • Researched new technologies and methodologies to propose innovative software solutions.

Senior Software Engineer

Conduent Business Services LLP
Kochi
09.2012 - 07.2018
  • Rio Tinto is a Logistics Company and is a leading global BPO provider with a worldwide presence of 50 solution centers across 22 countries in North America, Europe Stream provides its clients a broad, fullservice offering of truly innovative and comprehensive BPO services in sales and revenue generation, technical support, customer care and back office offerings
  • Interacted with Team and Analysis, Design and Develop database using Normalization and RDBMS
  • Involved in Design, Development and testing of the system
  • Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan)
  • Developed User Defined Functions and created Views and Reviewed existing business procedures and recommended and implemented changes
  • Creating and automating the regular Jobs, Tuned and Optimized SQL Queries using Execution Plan
  • Rebuilding Indexes and Tables as part of Performance Tuning Exercise
  • Reviewed existing business procedures and recommended and implemented changes
  • Responsible for setting preferences for various ad-hoc requests and distribution of tasks.

Education

B. TECH - Electronics and Instrumentation

Adi Shankara Institute of Engineering And Technology
Kochi
07-2012

Higher Secondary Education - Computer Science

Cardinal Higher Secondary School
Kochi
06-2010

High School Education -

Mary Matha HSS
Kochi
05-2008

Skills

  • Pentaho DI/Kettle
  • Azure Databricks
  • Azure Data Factory
  • Azure Data Lake
  • Pyspark
  • Airflow DAG
  • Python
  • SQL
  • Microsoft SSIS
  • MS Power BI
  • JIRA
  • Microsoft VSS
  • TortoiseSVN
  • SQL Server
  • Oracle
  • PostgreSQL
  • Microsoft Visual Studio
  • Azure Data Studio
  • GitHub Desktop
  • PyCharm
  • IntelliJ IDEA
  • Azure Storage Explorer

Websites

Certification

  • Azure Professional Data Engineer - DP - 203
  • Azure Fundamentals - AZ - 900
  • Pentaho Data Integration (Intellipaat)
  • Microsoft Business Intelligence (Intellipaat)
  • Data Warehousing using ERWIN tool (Intellipaat)

Accomplishments

  • Onsite experience in Dubai for 6 months for project implementation.
  • Experienced in various programming architectures and technologies.
  • Created highly effective new program that significantly impacted efficiency and improved operations.
  • Consistently maintained high customer satisfaction ratings.

Languages

English
First Language
English
Proficient (C2)
C2
Malayalam
Proficient (C2)
C2
Tamil
Advanced (C1)
C1
Hindi
Intermediate (B1)
B1

Timeline

Technical Lead

UST Global Ltd
10.2019 - Current

Lead Software Engineer

Nest Information Technologies
07.2018 - 10.2019

Senior Software Engineer

Conduent Business Services LLP
09.2012 - 07.2018

B. TECH - Electronics and Instrumentation

Adi Shankara Institute of Engineering And Technology

Higher Secondary Education - Computer Science

Cardinal Higher Secondary School

High School Education -

Mary Matha HSS

Similar Profiles

CREATE PROFILE
JAYAKRISHNAN MG