Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Raju Ranjan

Raju Ranjan

Gainesville,VA

Summary

Adept ETL & AWS Architect with a proven track record at Bigdata Dimension Inc., I excel in migrating legacy systems to AWS Cloud, leveraging Talend and Snowflake. Skilled in performance optimization and cloud technologies, my innovative solutions enhance data integrity and efficiency. Demonstrates strong analytical abilities and a commitment to delivering high-quality results.

Overview

18
18
years of professional experience
1
1
Certification

Work History

ETL & AWS Architect

Bigdata Dimension Inc.
09.2019 - Current
  • Client: Fannie Mae, VA.
  • MF Lyft & Shift is a migration project from a legacy system consisting of Unix, Ab Initio, and Oracle to AWS Cloud Oracle RDS using Talend ETL.
  • EDL is an AWS Glue catalog-based cloud data lake solution that sources data from the upstream RDS system and S3 bucket based on events.
  • Designed and created the Talend framework for the migration of Ab Initio flow to Talend ETL.
  • Created complex mappings in Talend 7.1 using tMap, tJoin, tReplicate, tParallelize, tFixedFlowInput, tAggregateRow, tFilterRow, tIterateToFlow, tFlowToIterate, tDie, tWarn, tLogCatcher, tHiveInput, tHiveOutput, etc.
  • Performance tuning of Talend components to use parallelization, and enable logging.
  • Lambda design and development, creation of SNS, SQS, EventBridge rules, CloudFormation templates, CloudWatch alarms, PySpark jobs, resiliency failover design, and design for scaling.
  • Vulnerability remediation for SQL, command injection, improper shutdown, etc.

Sr. ETL Talend, Snowflake Lead

Syntel Inc.
Baltimore
01.2019 - 08.2019
  • Company Overview: Client: Transamerica, Baltimore.
  • The Index Universal Life (IUL) process is for generating Greeks and attribution.
  • The Charles River Trading System is used by traders to hedge risk by trading in derivative products like futures, FX forwards, swaptions, IR swaps, bond forwards, and total return swaps.
  • Creating new tables and an audit process to load the new input files from CRD.
  • Design and develop an end-to-end ETL process from various source systems to the staging area, from staging to data marts, and data load.
  • Design a dimensional model, data lake architecture, and data vault 2.0 on Snowflake, and use the Snowflake logical data warehouse for compute.
  • Well-versed in Snowflake features like clustering, time travel, cloning, logical data warehouse, caching, etc.
  • Creating conceptual, logical, and physical data models in Visio 2013.

Data Engineering Lead

Syntel Inc.
NY
03.2017 - 12.2018
  • Company Overview: Client: State Street Bank, NY
  • General Ledger Reporting System(GLSR) is reporting database and is primarily used for calculating fund’s Net Asset Value(NAV) for internal business users as well as external clients
  • Reports include transaction, custody, holdings, trial balance, P&L, cash & recon, general ledger, Corporate actions, Accruals & Amortization reports
  • Worked in industrial agile software development process i.e
  • Daily Stand-ups, pre-iteration meetings, Iteration planning, Backlog refinement, Demo calls, Retrospective calls
  • Worked on Snowflake Schemas and Data Warehousing
  • Analysis of Test Track tickets and creating JIRA stories
  • Support user and production queries
  • Performance tuning of slow running queries and stored procedures in Sybase ASE
  • Replication testing and configuration for new tables in Sybase ASE
  • Stored procedure migration from ASE to Sybase IQ for performance enhancement
  • Maintenance and development of existing reports in Jasper
  • Designing new reports in Jasper using tables, charts and graphs, crosstabs, grouping and sorting
  • Data analysis using graphs and historical values
  • Client: State Street Bank, NY

Sr. Database Consultant

Cognizant
07.2010 - 03.2017
  • Company Overview: Client: JPMC, Norges Bank, Ameriprise Financial(Minneapolis), BNY Mellon(NY)
  • Algo is the proprietary Market Risk application to calculate Value at Risk (VaR) and generating the reports for BMYM Management and Federal regulatory
  • Stored procedures and database objects (Tables, views, triggers etc) development in Sybase 15.0 related to regulatory changes
  • Performance tuning for slow running stored procedures and redesigning indexes and tables
  • Preparing data dictionary for the project, developing SSIS packages to load data in the risk database
  • Unix Shell scripting to automate the manual works viz
  • Reports validation, job re-runs
  • Enhance the system documentation
  • Resolve open issues and concerns as discussed and defined by BNYM management
  • Analyse, design, code, unit/system testing, support UAT, implementation and release management
  • Establishing the frequency of data, data granularity, data loading strategy i.e
  • Delta load, full load
  • Ensuring the correctness and integrity of data via control file and other validation methods
  • Data warehouse experience in Star Schema, Snowflake Schema, Slowly Changing Dimensions (SCD) techniques etc
  • Client: JPMC, Norges Bank, Ameriprise Financial(Minneapolis), BNY Mellon(NY)

Database Developer

LNT Infotech
01.2007 - 07.2010
  • Company Overview: Client: Citigroup.
  • Impact Analysis of Any Business Logic Change.
  • Writing stored procedures, triggers, performance tuning, etc.
  • Completing the whole life cycle of the project, which encompasses requirement gathering, preparing MDD, development, unit testing, integration testing in the UA environment, release preparation plans, and finally, production rollout.
  • Sybase migration from 12.5 to 15.

Education

PGD - Advanced Software Design and Development

CDAC Noida
01.2007

B.E - Computer Sc & Engg.

BCE Bhagalpur
01.2006

Skills

  • Experience with Talend Versions 5x to 71
  • Informatica 7x/8x, CDI-PC
  • SSIS
  • Experience with Big Data Tools
  • Spark, HDFS, MapReduce, Hive
  • Database: Sybase 155
  • SQL Server 2008/2012
  • Oracle 9i/10g
  • Teradata
  • AWS Redshift
  • Snowflake
  • Language: C, Java, Python
  • Modelling Tools: Visio, Erwin 712
  • Cloud Technologies: AWS

Certification

  • AWS Certified Solution Architect – Associate
  • AWS Certified Machine Learning – Specialty
  • Passed Level-I of CFA Exam
  • MongoDB Certified Developer
  • Neo4j Certified Professional

Timeline

ETL & AWS Architect

Bigdata Dimension Inc.
09.2019 - Current

Sr. ETL Talend, Snowflake Lead

Syntel Inc.
01.2019 - 08.2019

Data Engineering Lead

Syntel Inc.
03.2017 - 12.2018

Sr. Database Consultant

Cognizant
07.2010 - 03.2017

Database Developer

LNT Infotech
01.2007 - 07.2010

PGD - Advanced Software Design and Development

CDAC Noida

B.E - Computer Sc & Engg.

BCE Bhagalpur

Similar Profiles

CREATE PROFILE
Raju Ranjan