Himanshu Dandle
Database Engineer | Data Scientist
Pune,MH
Summary
I am a software professional with 15 years plus years of experience in IT industry. Having vast experience in oracle database, performance tuning, ETL in development with agile methodologies with collaborative partnership with all stakeholders.
I have good knowledge in cloud computing technology like MS Azure along with python and R programming wrt machine learning/AI.
Currently Pursuing Microsoft Certification for MS Azure Data Science Associate.
Additionally, I have excellent communication skills, critical thinking, problem solving and decision-making skills apart from being highly productive in both team-based and individual contributor roles.
Overview
4
4
Certifications
20
20
years of professional experience
Work History
Assistant Vice President
Deutsche Bank
Pune, India
03.2018 - Current
- Achieved performance benefit from 8 hrs to 4 hrs of long running batches by sql tuning of interface views and used bulk collect and dynamic sql by using bind variables to optimize sql plan.
- Implementing ML Predictive Analysis of Credit rating of different entities based on ML modelling using python with different algorithms like (Regression,SVM,Decision tree, Random forest and neural network).
- Developing oracle pl-sql packages/procedures and sql query to provide business solutions that empowered business partners to yield report for analysis using oracle analytical functions, collections, partitioning.
- Reviewed, identified, updated and prioritized strategic initiatives to provide comprehensive support to tech enablement of sourcing data using vault framework into data mart in scaled agile environment.
- Facilitated FT/UAT testing with QA team for adoption Automation testing.
Sr. Principal Consultant
4. Oracle Financial Services Ltd
Mumbai, MH
06.2011 - 06.2021
- Delivered enhancement in AML/CRM/CIBIL model into HDFC DWH using OFSAA and T-Sql due to which helps to maintain and extend relationship for future business opportunities.
- Used T2T,F2T ETL to load data from multiple sources into DWH using OFSAA and ERWIN as modelling tool.
- Liaised with customer for requirements of projects and prepare understanding/proposal document to better understand customer requirement and recommend appropriate solutions via functional and specification document.
- Developing pl/sql and T-sql procedures, functions, packages, analysis, designing and unit testing and facilitating/Performing UAT and SIT testing with QA team.
- Initiated Performance tuning solution of pl/sql packages used in long running batches by using advanced oracle features like bulk collect, partitioning ,sql tuning ,collections, analytical functions etc.
- Authored details work plans with team to meet business priorities and deadlines.
- Updated all stakeholders on key milestones for projects by Sending weekly status reports to client and management.
Senior Consultant Specialist
HSBC Software Development
Pune, MH
10.2016 - 03.2018
- Achieved performance benefit of different long running batches by resolving issues with DOP,plan flip and bad sql plan.
- Transformed legacy archiving into strategic archiving method using partition exchange and applied business rule to ,which reduces archiving batches timing from 8 hrs to 5 hrs.
- Adoption of converting legacy code into advanced pl/sql packages which increased performance ,code maintenance and reusability.
- Identified issues, analyzed pl/sql code and provided solutions to improve performance.
Associate
JP Morgan Chase
Mumbai, MH
07.2013 - 09.2016
- Implemented successfully Operation efficiency Capital stock processing automation to send granular level transaction details to accounting team to help NAV calculation which was done manually previously and also implemented same in their DR server which has improved turn around time. Used oracle UTL_File,GTT,bulk collect ,Unix shell script for sftp transfer ,AutoSys for scheduling.
- Worked as System/Business analyst role to understand business requirement from business and prepare function and specification document, followed up with walkthrough of FS/SS document with development team and preparing and testing test cases (on ALM) in UAT/SIT.
- Achieved performance tuning of legacy data masking framework from 40 hrs to 6 hrs which yielded benefit to business for testing cycle.
- Facilitating/Performing UAT/SIT/Performance testing with QA team to improve testing automation.
Project Leader
L&T InfoTech Ltd
Mumbai, MH
12.2009 - 05.2011
- Database designing, development and maintenance of existing application, sql query optimization, and performance tuning pl/sql objects.
- Interaction with Business team for requirement gathering.
- Conducting Code reviews of peers and provide suggestions for PL/SQL programs to fix bugs and to improve performance.
Education
Bachelor of Engineering - Mechanical Engineering
Madhav Institute of Technology And Science
Gwalior, MPPG Diploma - Computer Application
CDAC
Skills
Oracle
undefinedCertification
Data Science with Python and R
Additional Information
Done multiple case studies for different machine learning using frameworks (TensorFlow, Scikit-learn, etc.)
1) Sentiment analysis for tweets using NLP and Neural network with Python and R.
2) Credit card fraud detection
3) Kaggle pneumonia detection using CNN
- Used data processing using MICE, PCA, Data Normalization, feature engineering, outlier treatment.
- Deployment of ML models as real time and batch interference pipeline on Azure.
Timeline
Data Science with Python and R
07-2020
Assistant Vice President
Deutsche Bank
03.2018 - Current
Senior Consultant Specialist
HSBC Software Development
10.2016 - 03.2018
Associate
JP Morgan Chase
07.2013 - 09.2016
Sr. Principal Consultant
4. Oracle Financial Services Ltd
06.2011 - 06.2021
Project Leader
L&T InfoTech Ltd
12.2009 - 05.2011
PG Diploma - Computer Application
CDAC
Bachelor of Engineering - Mechanical Engineering
Madhav Institute of Technology And Science
Similar Profiles
Dnyaneshwar BhogilDnyaneshwar Bhogil
Trade and Transaction Analyst at Deutsche Bank Group, Deutsche BankTrade and Transaction Analyst at Deutsche Bank Group, Deutsche Bank
PRADEEP KUMARPRADEEP KUMAR
Assistant Vice President at Deutsche India Private Limited (Deutsche Bank Group)Assistant Vice President at Deutsche India Private Limited (Deutsche Bank Group)
Manoj Singh SolankiManoj Singh Solanki
Senior Analyst at Deutsche India Pvt. Ltd- Deutsche Bank GroupSenior Analyst at Deutsche India Pvt. Ltd- Deutsche Bank Group
Amit KulkarniAmit Kulkarni
Vice President at Deutsche India Pvt. Ltd, Deutsche Bank of India, DBOIVice President at Deutsche India Pvt. Ltd, Deutsche Bank of India, DBOI
Milind PatilMilind Patil
Senior Software Engineer at Netcracker Technology SolutionsSenior Software Engineer at Netcracker Technology Solutions