Summary
Overview
Work History
Education
Skills
Websites
Certification
Languages
Open For International Visits
Personal Information
Timeline
Generic

ALPESH SUBHASH PRADHAN

Mumbai

Summary

Technology specialist with 19 years of expertise in Database Management and Programming. Master's degree in Information Management. Currently leads Data Engineering at Media.net, driving cross-departmental initiatives to deliver innovative database solutions that meet organizational objectives. Proven skills in analytics, team leadership, and resource management, supported by strong communication abilities.

Overview

20
20
years of professional experience
1
1
Certification

Work History

Manager (Data Engineering)

Media.net
Mumbai
08.2018 - Current
  • Designed and developed robust database systems for products related push notification services, lead generation
  • Participated in code reviews, offering feedback on database development best practices.
  • Assisted in creating databases to efficiently store large data sets.
  • Engaged in back-end development activities, emphasizing database management and server-side logic.

RookMedia
08.2013 - Current
  • Company Overview: Rookmedia is a 2nd largest domain traffic monetization program catering to advertisers and publishers.
  • Developed Data-warehouse for using SSIS and SQL server.
  • Developed multidimensional data models using SSAS which helps analysing data at various levels.
  • Instrumental in Database Designing and Implementation for different modules which are capable of serving around 120 million views per day and growing.
  • Set up the disaster recovery plan & developed maintenance plans.
  • Set up highly scalable architecture setting up the archiving process.
  • Developed ETL processes to manage data life cycle using SSIS.
  • Rookmedia is a 2nd largest domain traffic monetization program catering to advertisers and publishers.

Skenzo
01.2006 - Current
  • Company Overview: Skenzo is a world leader in internet traffic monetization business and No 1 fastest growing domain parking company worldwide for 2006 & 2007. Skenzo's context analysis and parking engine powers millions of domain names, serves billions of page views & analyzes terabytes of data in real-time to deliver maximum advertiser & publisher value.
  • Designed and developed database system for various features of product.
  • Real time serving module using T-SQL on OLTP Databases.
  • Built Audit process which focuses on different calculations using T-SQL.
  • Developed various statistical reporting modules providing right predictions of product performance.
  • Developed stored procedures, triggers to incorporate business logic.
  • Automation of major Database activities and developing monitoring system.
  • Developed Knowledge management process & ETL processes using DTS/ SSIS.
  • Database Log shipping, Database Mirroring and Database Backup.
  • Skenzo is a world leader in internet traffic monetization business and No 1 fastest growing domain parking company worldwide for 2006 & 2007. Skenzo's context analysis and parking engine powers millions of domain names, serves billions of page views & analyzes terabytes of data in real-time to deliver maximum advertiser & publisher value.

Domain Advertising
08.2010 - 06.2012
  • Company Overview: DomainAdvertising.com is a domain traffic monetization program that caters to serious advertisers and publishers bringing sustainable value as well as maximum returns.
  • Database Designing and Implementation for different modules which are capable of serving around 1 million views per day and growing.
  • Set up the disaster recovery plan and developed maintenance plans.
  • Set up highly scalable architecture and archiving process.
  • Developed ETL processes using DTS/ SSIS.
  • Data Migration using command line (non-graphical) mode.
  • DomainAdvertising.com is a domain traffic monetization program that caters to serious advertisers and publishers bringing sustainable value as well as maximum returns.

Big Jumbo
01.2007 - 12.2011
  • Company Overview: BigJumbo caters exclusively to small & mid-sized domain portfolio holders. It enables all domain publishers to receive high payouts and addresses their traffic monetization needs in a simple and efficient way.
  • Contributed in Audit processing for different advertisers.
  • Set up the disaster recovery plan and maintenance plans.
  • Set up highly scalable architecture which is capable of serving around 4 million views per day.
  • Setting up the archiving process and different types of Database Replications between servers.
  • BigJumbo caters exclusively to small & mid-sized domain portfolio holders. It enables all domain publishers to receive high payouts and addresses their traffic monetization needs in a simple and efficient way.

Webhosting. Info
12.2007 - 12.2010
  • Company Overview: Webhosting. Info is the largest provider of statistics & research in web services industry. Its patent pending algorithm monitors 1.3+ million DNS servers, 35+ million domain names and approximately 2 billion IP Address, gathering statistics, patterns and trends that are analyzed to generate unparalleled reports presenting micro & macro statistics about Web Services industry.
  • Built modules which added more in depth statistics on the website.
  • Setup of different servers with SQL server to implement the new architecture.
  • Provided real time support for all the different issues related to SQL server.
  • Accountable for database maintenance.
  • Efficiently developed ETL processes using DTS/ SSIS.
  • Set up Database backup process, database replication.
  • Automated all the processes.
  • Webhosting. Info is the largest provider of statistics & research in web services industry. Its patent pending algorithm monitors 1.3+ million DNS servers, 35+ million domain names and approximately 2 billion IP Address, gathering statistics, patterns and trends that are analyzed to generate unparalleled reports presenting micro & macro statistics about Web Services industry.

Education

MBA - Information Management

MET Institute of Management

Diploma - Computer Applications

NIIT

Bachelor of Science -

Mumbai University

Skills

  • Amazon Web Services
  • Amazon Redshift
  • AWS Data Migration Service
  • SQL Server 2005 to 2019
  • MySQL
  • scripting with Python
  • Scheduling with Airflow
  • Enterprise database management
  • Database architect
  • Data life cycle management
  • Database design, development, implementation, and administration
  • Data warehousing, mining, and modeling
  • Microsoft SQL Server (SSIS), (SSRS), (SSAS)
  • Familiarity with related networking and hardware systems
  • Stakeholder management
  • Team management and building
  • Domain monetization
  • Email monetization
  • Web hosting
  • Domain registration
  • Ad network
  • Ad provider
  • E-commerce
  • Notification services
  • Lead generation
  • Architecting large database-centric solutions
  • Developing large databases
  • Optimizing large databases
  • Troubleshooting large databases
  • Maintaining large databases
  • T-SQL
  • Data integrity
  • Creating tables
  • Managing data in tables
  • Creating indexes
  • Advanced stored procedure programming
  • Dynamic stored procedures
  • Remote stored procedures
  • Recursive stored procedures
  • Extended stored procedures
  • Using cursor variables
  • Error handling in stored procedures
  • Implementing transactions
  • InnoDB
  • My SAM
  • In memory
  • Federated
  • Replications
  • System tables
  • Table Partitioning
  • Data Migration
  • High availability techniques
  • Disaster Recovery Planning
  • Database Replication
  • Database backup and restore
  • Database Log Shipping
  • Database Mirroring
  • Creating DTS/SSIS Packages
  • Indexing Algorithms
  • Issue-Tracking Tools
  • JIRA
  • Asana
  • Trello
  • Git

Websites

Certification

Microsoft Certified Professional in Designing & Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Languages

Marathi
First Language
English
Proficient (C2)
C2
Hindi
Upper Intermediate (B2)
B2
Deutsch
Beginner
A1

Open For International Visits

Yes (preferably short term)

Personal Information

  • Location Preference: India
  • Birth Month-Year: November 1983

Timeline

Manager (Data Engineering)

Media.net
08.2018 - Current

RookMedia
08.2013 - Current

Domain Advertising
08.2010 - 06.2012

Webhosting. Info
12.2007 - 12.2010

Big Jumbo
01.2007 - 12.2011

Skenzo
01.2006 - Current

MBA - Information Management

MET Institute of Management

Diploma - Computer Applications

NIIT

Bachelor of Science -

Mumbai University

Similar Profiles

CREATE PROFILE
ALPESH SUBHASH PRADHAN