Sandesh Pawar, Software Developer in Pune, Maharashtra, India
Sandesh Pawar

Software Developer in Pune, Maharashtra, India

Member since April 23, 2017
Sandesh, in short, is an extremely capable database developer—specializing in SQL Server, MySQL, MongoDB, and Spark among others. In 2011, he started his career working with relational databases, later as a BI lead, and more recently, working as a DBA lead and DB architect. Sandesh also has worked in an R&D department and handled VLDBs for critical clients and is skilled in data and DW modeling.
Sandesh is now available for hire

Portfolio

  • Confidential
    Azure, SQL Server, Data Lake, MSBI, Power BI, Big Data
  • CartHook, Inc. (via Toptal)
    Amazon Web Services (AWS), MySQL, Aurora, Percona Tool, Database Migration, RDS
  • Confidential
    AWS, MongoDB, Elasticsearch, SQL Server, Redshift, MySQL, Spark, Hive, Presto...

Experience

  • SQL Server DBA, 7 years
  • SQL Server BI, 6 years
  • MongoDB, 6 years
  • SQL Server Analysis Services (SSAS), 5 years
  • MySQL, 3 years
  • Amazon Web Services (AWS), 3 years
  • Azure, 3 years
  • Redshift, 2 years

Location

Pune, Maharashtra, India

Availability

Full-time

Preferred Environment

Windows, Linux, SQL, SSDT, SSMS, Workbench

The most amazing...

...thing I’ve done was to design a data lake on AWS which involves data transformation and storage in the ORC format and a quick retrieval with Presto.

Employment

  • BI and Database Architect

    2018 - PRESENT
    Confidential
    • Prototyped a continuous streaming ETL requirement with the help of SQL Server CDC, Azure Event Hub, and Azure Stream Analytics Job. SQL Server CDC to capture changed data and event hub and stream analytics services will push data from the source to destination data sources.
    • Implemented sharding and partitioning in Azure SQL Database based on use cases.
    • Designed a data lake architecture and a partitioning strategy to store historical data.
    • Innovated and researched different options to implement SMART ETL Metadata Driven concept.
    • Designed and developed different analytical/operational dashboards and historical reports in SSRS and Power BI.
    Technologies: Azure, SQL Server, Data Lake, MSBI, Power BI, Big Data
  • Freelance Database Specialist

    2018 - 2018
    CartHook, Inc. (via Toptal)
    • Designed and implemented a strategy for character encoding changes in MySQL all without downtime.
    • Evaluated a one-way replica feature of Aurora RDS replica for zero downtime.
    • Dynamically generated a script for modifications of a large number of tables to increase turnaround time.
    • Prepared a dynamic script for verification of content before and after migration.
    • Suggested best practices for a MySQL table design for better performance.
    • Handled the migration activity from end-to-end in the staging and production environments.
    Technologies: Amazon Web Services (AWS), MySQL, Aurora, Percona Tool, Database Migration, RDS
  • DBA Lead | DB Architect

    2016 - 2018
    Confidential
    • Evaluated different NoSQL databases and selected them based on project requirements.
    • Created a multitenant and scalable schema design using MySQL and Aurora RDS.
    • Architected and implemented a data lake using Spark, Hive, and EMR Hadoop.
    • Designed and implemented Redshift DW as a central data store.
    Technologies: AWS, MongoDB, Elasticsearch, SQL Server, Redshift, MySQL, Spark, Hive, Presto, Kylin
  • Business Intelligence (BI) Lead

    2013 - 2016
    Cognizant
    • Led a team of four individuals in the implementation of different BI solutions for a healthcare's core systems; specifically implemented a central DW and SSAS cube.
    • Built SSRS reporting solutions for different clients.
    • Designed and prototyped scorecard/dashboard management reporting systems for claims turnaround time and processor’s productivity reports.
    • Implemented reconciliation reports to compare data across different source systems—resulting in significant FTE savings and increased SLA.
    • Managed the smooth transition from SSRS 2005 to SSRS 2014 reports and SSRS to PowerBI for multiple clients.
    • Created an ETL solution using SSIS packages.
    • Designed the packages in order to extract data from SQL/Sybase database, flat files, and then loaded into a SQL server database.
    • Designed ETL packages with the SSIS framework. It deals with different data sources (SQL server, flat files, and Excel) and loaded the data into target data sources by performing different kinds of transformations using SQL server integration services.
    • Migrated number of DTS packages (SQL 2000) to SQL Server 2012 SSIS database.
    • Developed and designed a data warehouse/cube.
    • Created a relational database design for a claims-and-financial data warehouse. With the help of ETL packages, the data gets loaded into a centralized data warehouse.
    • Designed different measure groups and dimensions; also implemented MDX scripts for a number of reports.
    • Implemented an ad-hoc reporting solution with the help of SSAS for the finance DW.
    Technologies: SQL Server, SSIS, SSAS, SSRS, DBA
  • Database Developer | Database Administrator (DBA)

    2011 - 2013
    Persistent Systems Limited
    • Gained significant hands-on experience in database schema design and complex stored procedures. Was also exposed to different BI development tools and DW development.
    • Designed and developed more than 50+ tables; all the tables were indexed and tuned, then de-normalized when necessary to improve performance.
    • Developed more than 100 stored procedures complete with parameters, RETURN values, complex multi-table JOINs and cursors.
    • Performance-tested, troubleshot, and optimized using SQL profiler, execution plans, and DMVs.
    • Implemented database mirroring, log shipping, and transaction replication as a high availability solution for different customers as per requirements specified in SLA.
    • Designed a collections schema in MongoDB for unstructured data from social networks; also automated the data flow process for real-time data.
    • Performed query tuning for reports developed in SQL server to reduce the response time by 60% in some cases.
    • Designed and developed an engagement analysis schema on top of an existing framework.
    • Wrote analysis reports—using the open source reporting tool JasperSoft—to provide accurate reports about activities.
    Technologies: SQL Server, MongoDB, SSIS, SSAS, SSRS, MySQL

Experience

  • Online Shopping Platform Database Design and Development (Development)

    • Performed query tuning for reports developed in MySQL to reduce response time by 60% in some cases.
    • Designed and developed engagement analysis schema on top of an existing framework.
    • Wrote analysis reports—using the open source reporting tool, JasperSoft—to provide accurate reports about activities.

  • Power BI Reporting Solution (Development)

    • Designed and developed Power BI dashboards and reports.
    • Designed a data model for Power BI reports.
    • Deployed Power BI reports.

  • Data Lake Architecture Design and Spark Implementation (Development)

    • Created the architecture for a data lake based on a number of AWS services.
    • Evaluated ORC vs Parquet performance and made the decision to store data in the ORC format.
    • Developed Spark PySpark jobs to move data from different files.

  • ETL Solution using SSIS Packages (Development)

    • Designed the packages in order to extract data from SQL/Sybase database, flat files, and loaded into an SQL server database
    • Designed ETL packages with the SSIS framework. It deals with different data sources (SQL server, flat files, and Excel) and loads the data into target data sources by performing different kinds of transformations using SQL server integration services
    • Migrated number of DTS packages (SQL 2000) to SQL Server 2012 SSIS database.

  • SSRS Reporting Solution for Different Clients (Development)

    • Designed and prototyped scorecard/dashboard management reporting systems for claims turnaround time and processor’s productivity reports.
    • Implemented reconciliation reports to compare data across different source systems. It resulted in significant FTE savings and increased SLA.
    • Managed a smooth transition from SSRS 2005 to SSRS 2014 reports and SSRS to PowerBI for multiple clients.

  • Data Warehouse and SSAS Multidimensional/Tabular Model Design and Development (Development)

    • Created the relational database design for a claims-and-financial data warehouse. With the help of ETL packages, the data gets loaded into a central data warehouse.
    • Designed different measure groups and dimensions.
    • Implemented MDX scripts for a number of reports.
    • Implemented ad-hoc reporting solution with the help of SSAS for the finance DW.

  • Database Design and Development for Gamification Projects (Development)

    • Designed and developed more than 50 tables. All the tables were indexed and tuned, then de-normalized when necessary to improve performance.
    • Developed more than 100 stored procedures with parameters, RETURN values, complex multi-table JOINs and cursors.
    • Performance tested, troubleshot, and optimized (using SQL Profiler, execution plans, and DMVs).

  • Database High Availability Implementation and Production Support (Development)

    • Implemented SQL Server HA solutions for clients using the below solutions:
    1) Log shipping
    2) Database mirroring
    3) Transaction replication
    4) Always on

Skills

  • Languages

    SQL, T-SQL
  • Frameworks

    AWS EMR, Spark
  • Tools

    MySQL Workbench, SQL Server BI, Amazon Elastic MapReduce (EMR), AWS Glue, Spark SQL, iReport Designer, Microsoft Power BI
  • Paradigms

    Dimensional Modeling
  • Platforms

    Amazon Web Services (AWS), Azure
  • Storage

    SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server DBA, SQL Server 2014, Database Backups, Database Modeling, SQL Server Reporting Services (SSRS), AWS DynamoDB, MySQL, MongoDB, Amazon Aurora, Database Migration, Database Replication, Elasticsearch, Redshift, SSAS Tabular, SQL Server Data Tools (SSDT), SQL Server Management Studio, Apache Hive
  • Other

    Query Optimization, High Availability, Log Shipping, Performance Optimization, Business Continuity & Disaster Recovery (BCDR), Multidimensional Expressions (MDX), DAX, Always On

Education

  • Bachelor of Technology degree in Computer Science and Engineering
    2007 - 2011
    Walchand College of Engineering, Sangli - Sangli, Maharashtra, India
  • Higher secondary school certificate in Basics
    2007 - 2007
    Pune University - Pune, Maharashtra, India
  • Secondary school certificate in Basics
    2005 - 2005
    Pune University - Pune, Maharashtra, India
Certifications
  • AWS Certified Solutions Architect - Associate
    APRIL 2017 - PRESENT
    AWS
  • Microsoft Certified Technology Specialist SQL Server 2008 Business Intelligence and Developmen
    APRIL 2015 - PRESENT
    Microsoft
  • Microsoft Certified Technology Specialist SQL Server 2008 Implementation and Maintenance
    JUNE 2013 - PRESENT
    Microsoft
  • Microsoft Certified Technology Specialist SQL Server 2008 Database Developmen
    NOVEMBER 2011 - PRESENT
    Microsoft
  • Microsoft Certified SQL Server Associate
    JANUARY 2011 - PRESENT
    Microsoft

To view more profiles

Join Toptal
I really like this profile
Share it with others