Pramod Dabhade

Experience

• 

  Charak Pharmaceutical Pvt. Ltd

  Feb 2009 - Oct 2010

  ERP Executive and Technical Support Engineer

  Successfully implemented Sales and Distribution application across C&F Agent. Developed utility using .Net for uploading excel files to SQL DatabaseEnsured high performance for SQL Server database.Monitored Database Backups. Resolved L1 and L2 issue reported in Sales and Distribution application

• 

  Sun Pharmaceutical Ltd

  Dec 2010 - Apr 2012

  Functional and Technical Support Engineer

  Developed BI Reports for EPR models using PL-SQL.Introduces Online channel for Order processing, reduced human dependancy as well processing TATSupported BI Developers, End users from the application aspects.Developed ETL jobs for DWH system.

• 

  HDFC Bank

  May 2012 - Feb 2022

  Design, developed, and implement an application for sending real-time SMS notificationSuccessfully completed stack (HW/ SW) upgrade for multiple applications.Successful implementation of CRM System for HDFC Securities.Deployed an enterprise-level OTP solution ( Snorkel).Managed Enhancements /Incident / Problem and change for BAU applications.Implement Trading Portfolio application for end-user.Successfully handled HW migration from IBM system to Oracle OSCImplemented DR for trading systemDeployed / refresh multiple environment ( UAT / SIT / PreProd ) as per the requirement Show less TCS BaNCS Securities TradingMonitor Database Storage Structure under(ASM, User-Managed file System) Perform Oracle software Patching using OPatch Utility.Perform and Monitor RMAN Backup and Restoration.Maintain Database Clone for SIT/UAT purposes.Perform Logical Backup as per business requirement. Provide regular status reports to management on application status and other metrics.Handling Incident/Change / Release Management Process to Monitor, trace, document Incident. Maintain database scheduler jobs for maintaining high availability.Implement automation in a critical system process to minimize manual intervention.TCS BaNCS e-IPOImplementation /deployment of the e-IPO system on the Solaris Platform.Migration of Database from IBM AIX to Solaris.Automation of all critical system process with Autosys tool.Capacity (storage/memory etc. Resource) forecasting for system with analyzing daily and weekly growth.Implementation of Database logical/RMAN backup, Application backup policy with veritas backup tool Perform Complete SIT for a new system.Implementation ITIL process for Incident, Change, and Release Management. Show less

  • Integration Solution Manager

    Oct 2015 - Feb 2022

  • Production Support Engineer

    Nov 2014 - Apr 2019

  • Production Support Engineer

    May 2012 - Oct 2014
• 

  HDFC securities

  Apr 2019 - Feb 2022

  Senior Manager

  -Demonstrating Leadership and Initiative by reviewing and updating processes, procedures and tools as IT-Ops lead that resulted in a 64% improvement in IT-Ops processing time.-Having to show confidence and capability when fighting for and personally delivering a refactor of our database that gave a 58% time reduction for the Order Processing system.-Strategic focus, data driven and with a keen understanding of business requirements.-Initiating a customer segment analysis across 400k customers resulting in improved brand loyalty and increased sales.-Architecting and developing a data warehouse for data stored at 1 minute intervals as a foundation of future analytics.-Perform trend forecasting for orders using Facebook Prophet library.-Wholistic approach to insights and performance, introducing ELK stack for internal system logs and volume matrix. Show less

• 

  Freespace

  Dec 2021 - now

  Lead Software Engineer – Data Analytics

  -Co-Founded an analytics department less than a year ago that has now been deemed “the driving force” for the organization-Instrumental in building out Business Intelligence at Freespace, designing and developing the core office analytics datasets used by some of the world’s largest companies.-Showing vision and initiative when building out "Return to Work" forecasting models that have been critical for client decision making and have fostered an internal demand for additional machine learning insights.-Lead Developer for media data as well as the "Freespace Index" the Index internationally recognised and contributions cited in multiple major publications including Bloomberg, The Guardian and Financial Times.-Respected communicator though data and in person, getting positive feedback on multiple occasions from clients when presenting data and solutions. Show less