Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
background-images

Sudhakar Navale

Pune

Summary

Experienced Oracle programming language professional with over a decade of expertise specializing in technology architecture. Skilled in effectively analyzing complex problems and translating them into actionable solutions for technical teams. Passionate and value-driven approach to driving innovation and efficiency in project delivery. Adept at leveraging technical understanding to optimize processes and enhance overall project outcomes.

Overview

10
10
years of professional experience

Work History

Technology Architect

Cognizant Technology Solutions, CTS
11.2023 - Current
  • Interaction with clients and stakeholders to gather requirement.
  • Design and implementation of complex structures to support enterprise applications and Data Modeling.
  • Preparing the UI/UX screen and work with java developers to build it.
  • Wrote complex SQL quires with analytical functions which involving multiple tables, joins to retrieve data from database.
  • Developed and designed various database objects like Stored procedures, Functions, Packages, Triggers, Cursors, Views,Materialized View, Temp table,CTE,Global temp table, Index,partitions,Exception handling and collections.
  • Involved migration of LoanIQ7.7 ( Database structure change and API changes).
  • Involved in debugging SQL and SQL query optimization.
  • Performing Smoke testing, Regression testing and Functional Acceptance testing.
  • Build Automation script for testing and automated manual repeating tasks.
  • Maintained code source versioning and Azure Pipelines(CI/CD) and prepared UAT and Production deployment runbook.
  • Prepared Liquibase SQL scripts for SQL deployments.
  • Managed Openshift Pods ,Grafana, Tracing API's.
  • Stakeholder and Squad demo's.
  • Mentoring new joiner and technical evaluation for squad.

Specialist IIOT

LTIMindtree
10.2021 - 11.2023
  • Have worked on complete requirement like Requirement gathering, Assessment & planning of work, Development & Implementation.
  • Playing architect role providing suggestions & improvement plan based on scenarios provided from clients (Related to SQL & Python).
  • Have developed Database objects and python Scripts in Ignition. Automating multiple tasks to reduce manual work.
  • Playing Lead developer role and closely working clients/businesses.
  • Handling and managing three applications independently.
  • Have Explore on Python scripting and AWS S3 bucket.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Collaborated with Product owner and upstream and downstream to design, build and test systems.
  • Created some Custom reports and Forms for the end users to check the details and errors.
  • Troubleshooting the application issues and customer support.

Application Development Senior Analyst

Accenture Solutions Private
05.2021 - 09.2021
  • Worked on user requirements and prepare the TDD documents.
  • Worked on impact analysis as per user requirements.
  • Worked on design and development activity.
  • Developed SQL stored Procedures, Views, Packages, Cursors, Exceptions, Bulk collections.
  • Internal code review and code walkthrough.
  • Worked on unit testing and logs the test cases in Jira tool.
  • Build ETL Config files in JSON and passed to PySpark job.
  • Tested the build Config files and upload in Bit bucket.
  • Maintaining the deployment changes and uploading on Team link.

IT Analyst

Tata Consultancy Services (TCS)
03.2015 - 04.2021
  • Worked on user requirements and prepare the TDD documents.
  • Worked on impact analysis as per user requirements.
  • Worked on design and development activity.
  • Automated multiple manual tasks to reduce manual efforts from Support team by sing PL/SQL and Unix shell scripting.
  • Preparing the change code in documents and share with internal review.
  • Developed multiple PL/SQL stored Procedures, Views, Packages, Cursors, Exceptions, Bulk collections.
  • Wrote various SQL Report queries to fetch out business required data from Oracle DB and Snowflake DB.
  • Debugging the PL/SQL codes and fixing the issues and Unix shell scripting bugs.
  • Providing support to Business team and point of contact for PII data.
  • Analysis on existing process and fixed multiple bugs/issues and deploy with new changes.
  • Tracking the changes in documents with existing code with impacted analysis & new proposed code.
  • Updating Status & Daily completion task on OneNote page for Customer.
  • Used Service Now application for track the issues/changes ticket/service requests.
  • Scheduling/de-scheduling jobs in crontab.
  • Worked multiple Ad-hoc requests and provided the requested data to end users.

Education

Master of Science - Computer Science

Sangola College Sangola
Sangola, India
01-2018

Bachelor of Science - Computer Science

Sangola College Sangola
Pune
01-2014

Skills

  • Domain: Banking & Finance, Insurance, IOT, Internal Services
  • Programming Languages: SQL, PL/SQL, MS SQL Server, Snowflake, Python
  • Version Control: Git, BitBucket, Azure Repo
  • Tools/Packages / Framework / ERP Components: Visual Studio Code, Oracle SQL Developer, MS SQL Server, MS Azure, Data Bricks, Bit Bucket, Tortoise Git, SQL Server Management Studio, Talend Open Studio, Putty, WinSCP, Python, Jira, ServiceNow, HP ALM, OneNote, Notepad, SCADA,Oracle SQL developer data modeler, Liquibase, Azure Pipeline,Confluence, IntelliJ, Postman, Redhot OpenShift, Azure Key Valut
  • Monitoring & Altering - Granfana, TracING

Accomplishments

    LTIMindtree -

  • The Above & Beyond Award Received for Phillips66
  • Recognition for Python job Automation for Phillips66

    • TCS-

  • On the Spot Award Received for Western Union
  • Service & Commitment

Timeline

Technology Architect

Cognizant Technology Solutions, CTS
11.2023 - Current

Specialist IIOT

LTIMindtree
10.2021 - 11.2023

Application Development Senior Analyst

Accenture Solutions Private
05.2021 - 09.2021

IT Analyst

Tata Consultancy Services (TCS)
03.2015 - 04.2021

Master of Science - Computer Science

Sangola College Sangola

Bachelor of Science - Computer Science

Sangola College Sangola

Similar Profiles

CREATE PROFILE
Sudhakar Navale