Raj Priya Ramprasad
Edmonton,AB
Summary
Result Driven Data Engineer/ETL developer with 3+ years experience in building Datawarehouse/Data migration applications in finance/telecom sector. Worked with different clients to design, develop and implement different ETL pipelines using various technology stacks. Having good knowledge on hosting Analytical datawarehouse application on prem infrastructure and on cloud platforms. Designed and developed data ingestion and data extraction frameworks for code reusability. Known for providing quick, effective solutions to automate and optimize data management processes. Currently working on souring data from different enterprise allegation systems to support the bank’s conduct risk analytical and reporting needs and other high priority projects under allegations space and focus on learning technologies in the DevOps space. Always eager to learn and looking for scope of innovation in day to day work to keep motivated.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Data Engineer
Suriya Informatics Solutions Pvt. Ltd
09.2012 - 10.2016
- Created database objects like Procedures, Triggers and Views using T-SQL in Development and Production environment in SQL Server 2008 R2.
- Created SSIS packages for transferring data from various data sources Excel, *Txt file, *CSV files.
- Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, transformation
- Designed the ETL process, including data read/write, data transformations, errorhandling, process design, logging and Development.
- Generated multiple Enterprise reports using SSRS from SQL Server Database included
- Involved in setting up Ab Initio environment
- Create Generic graphs and Ab initio ETL data flows.
- Analyze the existing SSIS packages and migrate it to Ab initio
Data Engineer
Prime Inspection Service
11.2020 - 07.2021
- Worked as a ETL consultant for Wells Fargo, SunTrust banks.
- Displayed responsibility, ownership and accountability for deliverables in development lifecycle.
- Executed various Ab Initio parallelism techniques and developed Ab Initio graphs using pipeline data and component parallelisms.
- Developed conversion and system implementation plans.
- Identify and document all the technical and system specifications by analyzing the
existing ETL Code to identify the true data sources for ingestion. - Adhere to Do-No-Harm approach and migrate to retrofit the existing ETL applications into Data lake to use HDFS storage.
- Capture and ensure End-to-End data flow lineage in Metadata Hub. Utilize features / graphs prebuilt using Ab initio components in the Data Lake Environment.
- Modifying the existing applications to ensure proper integration with Hadoop File System.
- Build ETL packages to load from data lake to IBM DB2 tables for ad hoc query analysis and reporting.
- Worked with off shore team to discuss, guide and track the progress of development. Work on preparing the cut over of the application on to Lake.
Education
Bachelor of Engineering - Electronics And Communication Engineering
Anna University
Chennai04.2012
Skills
Operating System:
- Windows
- MacOS
Database/server:
- My SQL
- Python 36 (pandas, NumPy, Matplottlib)
- Jupter notebook
- MS SQL (SSIS)
- Apache Spark
- NoSQL Databases
- Machine Learning
Programming Language:
- Python
- C, C
Nationality
Canadian
Certification
- Python
- C, C++
- Data Engineering and Bigdata
Timeline
Data Engineer
Prime Inspection Service
11.2020 - 07.2021
Data Engineer
Suriya Informatics Solutions Pvt. Ltd
09.2012 - 10.2016
Bachelor of Engineering - Electronics And Communication Engineering
Anna University
- Python
- C, C++
- Data Engineering and Bigdata
Similar Profiles
Goutham YalkaGoutham Yalka
RPA /UIPATH DEVELOPER at CosMicIT Informatics India Pvt Ltd (Client :TCS)RPA /UIPATH DEVELOPER at CosMicIT Informatics India Pvt Ltd (Client :TCS)
T SARANYAT SARANYA
District Rollout Manager at Prakhar Software Solutions Pvt.Ltd. under the Govt. project of National Informatics Centre(NIC)District Rollout Manager at Prakhar Software Solutions Pvt.Ltd. under the Govt. project of National Informatics Centre(NIC)
Nitin ChoudhariNitin Choudhari
Software Engineer at Acute Informatics Pvt LtdSoftware Engineer at Acute Informatics Pvt Ltd