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