DEEPAK DADARWAL Sr Tech Lead for Database
No reviews yet

I am providing complete practical session based on IT industry experience. It helped to student to grow with IT career and survive for development, implementation and support project. Also provide help for technical support for project solution as think tank. I have trained more than 15000 students since I am working on this trainer profession. My aim to make student IT professional as per his/her need. I usually offer training demo before start actual course content. My course content cover Basic to Advance with real examples. I am professionally trainer to CDac Courses, Corporate training from MNC, Institution training program. Most of time I deliver classroom training but due to COVID i am covering my all session online. I am also helping student to make his/her investment double via learning. Please feel free to connect for technical and functional training.
Stay Safe and Happy Learning :)
Please find below Technical Skill:
 DB Development in Oracle SQL, PL-SQL
 DB Development in SQL,T-SQL for MSSQL Server
 DB Development in Postgres-SQL & Administration
 Data Migration from legacy system to target system
 RICEW Development on R12
 R12 Apps Techno-Functional
 Workflow Development
 Shell Script Development
 PowerShell Script Development
 Python Script Development
 DB Development for ETL.
 Analytics with Excel
 Python with data science
 Development for Data Visualization Tibco Spot fire, PowerBI, Tableau, Sisense etc

Subjects

  • PostgreSQL Expert

  • Oracle Database 11g &12c Expert

  • Oracle Apps Technical Expert

  • SSRS, SSIS, SQL Server Expert

  • Oracle Financials ERP R12 Expert

Experience

  • Tech Lead (Mar, 2020–Present) at Tech Mahindra pune
    Currently employed as a Database Developer, I have honed my skills in designing and implementing efficient database solutions, optimizing code and queries for performance, and ensuring data integrity and security. My experience includes collaborating with cross-functional teams to understand business requirements and translate them into scalable and maintainable database solutions.

    Some key highlights of my qualifications include:
     Proficient in SQL and PL/SQL development, DB Tuning, including advanced query optimization techniques.
     Demonstrated expertise in developing functions, procedures, packages, and triggers to automate business processes and enhance system functionality.
     Proven ability to perform code and query tuning to optimize database performance and improve overall system efficiency.
     Strong problem-solving skills and attention to detail, with a focus on delivering high-quality solutions that meet business objectives.
     Excellent communication and interpersonal skills, with the ability to effectively collaborate with team members and stakeholders.
    I am particularly drawn to the opportunity to contribute to client's mission of revolutionizing the restaurant industry through innovative technology solutions. I am eager to leverage my skills and experience to help drive the success of your projects and contribute to the growth and advancement of your organization.
  • Technology Lead (Aug, 2019–Mar, 2020) at Triashksha Automation
    Currently working with client Mphasis, Pune for B2B project of their client related CR development using oracle database SQL,PLSQL, and shell script. Good coordination with team and database development. Good experience to handle client
  • Sr System Analyst (May, 2014–Aug, 2019) at Ebixcash Software India Pvt Ltd
    Worked with client DHFL for Go Live implementation and data migration using oracle database SQL, PLSQL, and Workflow. Good understanding on LOS, LMS, and CMS modules. Good experience to handle client
    Data Migration – DHFL, Mumbai Role: Project Leader Technologies: Oracle SQL, PL/SQL & API Responsibilities: Client interaction for requirements gathering, Go Live master data preparation, Migration approach and template explanation for product DB structure.  Developed Utility for data migration from legacy to Indus product LOS 5.10.  Analyzing source data and mapping it to staging, then after validating to target tables.  Data reconciliation report based on data migration.  Team Co-ordination for time based project delivery.  Leading project over all for technical development.  Master data upload branch basis implementation.  Go Live preparation and branch roll out

    Application Development – VP Bank, Vietnam Role: Technical developer Technologies: Oracle SQL, PL/SQL, Workflow Responsibilities:  Developed technical product workflow for CLO portfolio based on functional requirement.  Integrated Decision, Notification, User, System and Event based activity to workflow.  Created procedure, function, triggers, package for workflow process automate.  Team Co-ordination and client interaction for CRs Dev.

    Application Development – Canara Bank, Bangalore Role: Technical developer Technologies: Oracle SQL, PL/SQL, Workflow Responsibilities:  Developed technical product workflow for CLO, Retail, Education portfolio based on functional requirement.  Integrated Decision, Notification, User, System and Event based activity to workflow.  Developed procedure, function, triggers, package for workflow process automate. Responsible for Unit testing of the PL/SQL code.  Over all product testing basis on each portfolio based workflow.
  • Engineer (May, 2011–May, 2014) at Vyom(iWarelogic) Private Ltd, Pune
    Here my role was to Integrate PTC PLM product with Oracle R12 using Tibco Adapter tables and oracle RICEW components. I was engaged to enhance the integration interface Inventory, BOM, Routing, ECO, oracle configurator modules using Oracle R12 interface public API.
    R12 Integration – PTC Software, Pune Role: Techno-Functional Developer Technologies: R12 RICEW Responsibilities:  Development of API using standard API’s available in Oracle for Data Migration from the legacy system to Inventory, BOM, Routing, Engineering, & Oracle Configurator ATO model etc.  I have automated all integration test cases and delivered to the respective team.  Extensively developed PL/SQL Procedures, Functions, Form Triggers and Packages.  Technical Document preparation for all module interface development. 7. R12 Development – Vyomlabs, Pune Role: Techno-Functional Developer Technologies: R12 RICEW Responsibilities:  Designed rdf with parameters as per MD50.  Rdf transferred to appl_top’s report/us folder on remote server.  Executable register under concurrent program and value set under Application validation.  Define program with registered executable and parameters.  Attached program to request group (OM Concurrent Programs) with Order Management Application and test the same as per requirement & Prepared MD70 document for the report.
  • Trainer (Apr, 2010–Apr, 2011) at Netcom college, sikar
    Worked as trainer for teaching subject like database, c, cpp, java, sql server, postgres, mysql etc
  • Assistand Professor (Sep, 2009–Mar, 2010) at Seth gyaniram bansidhar Podar College, Nawalgarh, Rajasthan
    I was in teach profession during academic year. I taught DBMS, C, Analytics and Oracle data development.
    Also covered OCA certification content.
  • Engineer (Jun, 2006–Aug, 2009) at Mulberry Silks Ltd, Bangalore
    Recruited to support and develop implemented ERP Software Silk ERP for silk export company. Here my role was to support Order Management and production planning integrated to each production stage, to make Order status available real-time. This is despite the frequency of Order Cancellations, order Amendments, in-process Material/fabric transfers.

Education

  • MCA (Jun, 2002–Jul, 2005) from JRN DEEMED UNIVERSITY–scored 75

Fee details

    ₹500–1,500/hour (US$5.95–17.84/hour)

    Min/Max for online session. Also it will vary as per count of attendees.

Reviews

No reviews yet. Be the first one to review this tutor.