Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Yogesh Rajwade

Lutz,United States

Summary

Seasoned Data Engineer experienced developing applications, databases and cloud computing solutions. Smart professional with proven troubleshooting and debugging capabilities for resolving complex technical issues.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Lead software engineer

Nielsen
03.2018 - Current
  • Build, manage, and develop a API based spark application with team comprised of 8 personnel, provide coaching and mentorship, conduct performance evaluations, and establish inclusive work cultures
  • Coordinate with cross-functional teams to identify process gaps and develop solutions, resulting in scalable and high performance application
  • Collaborated with product managers and designers to define project scope, timelines, and deliverables
  • Conducted code reviews and provided technical guidance and mentorship to team members
  • Successfully delivered project within the designated time frame and budget
  • Communicated project updates and progress to stakeholders and upper management
  • Identified and resolved complex technical issues and challenges during development
  • Implemented agile methodologies to improve project efficiency and team collaboration
  • Conducted training sessions for new team members and facilitated knowledge sharing within the team
  • Designed and implemented scalable software architecture for the application, utilizing technologies such as spark, paython, and airflow
  • Supporting application with runs in AWS EKS and written in golang.

Sr Odi Developer

Astrosoft technology
09.2017 - 03.2018
  • Building the ETL solutions using Oracle Data Integrator (ODI), Netezza and Oracle
  • Implemented complex functionality or by developing the new Custom Packages and Interfaces as per the business
  • Build and implementation include stand-alone and Java EE agents, ODI studio tools
  • Proficient in applying the ODI Product patches/bugs and upgrading activities on client instances
  • Worked with Oracle product development team for fixing various Load performance issues, Patches and other Product bugs through Service requests
  • Adhered to the client standards and Oracle best practices while implementing the solutions
  • Implement the Performance tuning techniques in ODI to improve Extract & Load performance
  • Developed complex business logic through ODI and then scheduling the packages in Load plan.

Technical Lead

Tata consultancy services
09.2015 - 08.2017
  • Preparing the impact & risk analysis and assessing the effort estimations
  • Review and translate the business requirements into High level and Low level Tech design
  • Leading the technical team by working closely with business analysts to understand technical requirements and conducting POC’s, and helping in preparing functional specification document
  • Building the ETL solutions using Oracle Data Integrator (ODI), Netezza and Oracle
  • Implemented complex functionality or by developing the new Custom Packages and Interfaces as per the business
  • Build and implementation include stand-alone and Java EE agents, ODI studio tools
  • Proficient in applying the ODI Product patches/bugs and upgrading activities on client instances
  • Worked with Oracle product development team for fixing various Load performance issues, Patches and other Product bugs through Service requests
  • Adhered to the client standards and Oracle best practices while implementing the solutions
  • Implement the Performance tuning techniques in ODI to improve Extract & Load performance
  • Developed complex business logic through ODI and then scheduling the packages in Load plan
  • Conduct Peer-peer code reviews, prepared Unit test scripts and executing them
  • Prepared detail migrations tasks for the code migration from Lower to Higher instances
  • Troubleshooting the load performance, data issues and then providing detail root cause analysis
  • Scheduling and monitoring of the Full and Incremental load cycles from Console and through ODI operator navigator
  • Effective coordination with Source, DBAs and other Up/down stream teams during Implementation and support phases.

IT Analyst

Tata consultancy services
09.2010 - 08.2015
  • Design and development of ODI projects as per business requirement
  • Effort estimation, impact analysis , design and development of new system change request
  • Responsible for providing ODI design solution for new business requirement
  • Responsible for preparing the technical design document for new requirements
  • Responsible for development of the ODI mappings and workflows
  • ODI Code standardization and following existing process structure
  • Point of contact for any ODI ETL related issues
  • Perform root cause analysis for critical and recurring incidents
  • Responsible for the initial phase planning, designing of the complete development process
  • Sole responsible for developing database objects like triggers, views, procedures etc to migrate data
  • Sole responsible for development of the end to end mapping for individual staging tables to implement the business logic
  • Worked on performance tuning of ODI interface
  • Production support on DB related issues, updates and changes.

Software Enginner

Verizon Data Services
06.2008 - 09.2010
  • Created ODI design documents and mappings
  • Used these design documents in development of ODI interfaces/packages
  • Performance tuned the interfaces, queries through use of indexes, ranks, Oracle hints etc
  • Wrote unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team
  • Unit tested for all the possible test scenarios
  • Responsible for implementing the change data capture to populate the staging area
  • Responsible for developing database views and stored procedure on staging area to clean up source data as according to the requirement
  • Designing the archiving strategy for the intermediate staging tables on the OLTP system
  • Did SQL and PL/SQL programming for ODI and oracle
  • Worked extensively with ODI Designer, operator and metadata Navigator
  • Involved in rotational production support
  • Leading the offshore development team and actively involved in development for several components
  • Working closely with project manager to update the development status during the client meetings.

Web Programmer

XSInfoways
06.2007 - 06.2008
  • Developed web application for different domain like Shopping cart and Student management for University
  • Supported and deployed multiple web application using PHP/MYSQL.

Web Programmer

Vedant Solutions
02.2007 - 06.2007
  • Developed web application for different domain like Project tracking and discussion forum
  • Supported and deployed multiple web application using PHP/MYSQL.

Education

Bachelor of Engineering in Computer Science -

Guru Ramdas Khalsa Institute of Technology College
Jabalpur, MP

Skills

  • Spark Scala/Sql
  • AWS
  • Airflow
  • Database(Oracle,Postgres,Netezza,Sql Server)
  • Oracle Data Integrator (ETL Tool)
  • Kubernetes
  • Gitlab
  • Python/Pyspark
  • Performance Optimization
  • Team Collaboration
  • Agile Methodologies
  • Advanced Debugging
  • Technical Leadership

Certification

AWS Certified Solutions Architect - Associate, AWS, 08/2022

Timeline

Lead software engineer

Nielsen
03.2018 - Current

Sr Odi Developer

Astrosoft technology
09.2017 - 03.2018

Technical Lead

Tata consultancy services
09.2015 - 08.2017

IT Analyst

Tata consultancy services
09.2010 - 08.2015

Software Enginner

Verizon Data Services
06.2008 - 09.2010

Web Programmer

XSInfoways
06.2007 - 06.2008

Web Programmer

Vedant Solutions
02.2007 - 06.2007

Bachelor of Engineering in Computer Science -

Guru Ramdas Khalsa Institute of Technology College
Yogesh Rajwade