Ranjan Goenka, Data Warehouse Design Developer in Mount Kisco, NY, United States
Ranjan Goenka

Data Warehouse Design Developer in Mount Kisco, NY, United States

Member since December 11, 2019
Ranjan is a seasoned database architect, designer, and developer with more than 20 years of experience in the database design development, architecture, data governance, data quality management, data warehousing, and business intelligence. Ranjan has the skills to fulfill any data engineering role and enjoys solving business problems using database technology.
Ranjan is now available for hire

Portfolio

Experience

Location

Mount Kisco, NY, United States

Availability

Part-time

Preferred Environment

PostgreSQL, Microsoft SQL Server, Oracle, Snowflake

The most amazing...

...thing I've done was to lead the multi-year, multimillion-dollar initiative to build an enterprise-risk system for one of the biggest insurance companies.

Employment

  • Senior Data and Reporting Consultant

    2018 - 2019
    Transamerica
    • Developed a centralized enterprise-wide data warehouse database that has the ability to source the raw data from both internal and external sources and in the form of structured and unstructured data.
    • Established new database development standards and common database architecture which can be leveraged across multiple projects.
    • Worked closely with senior stakeholders in the ALM department to prioritize business requirements and also led the team of developers.
    • Created a generic ETL processing and error-logging mechanism.
    Technologies: Erwin, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau, Python, T-SQL, SQL, Oracle, Microsoft SQL Server
  • Senior Data Engineer Consultant

    2017 - 2018
    IAC Applications
    • Helped the client in a data warehouse migration project from an on-premise ParAccel database to Snowflake AWS cloud to provide robust and on-demand scalable architecture.
    • Wrote a common Python script that unloads the data from megacycle on-premise database and loads it into the Snowflake cloud database.
    • Converted various legacy process which was written in Perl to Python.
    • Created a generic ETL processing and error logging mechanism.
    Technologies: Amazon Web Services (AWS), Jenkins, GitHub, Perl, PyCharm, PuTTY, Windows, Linux, AWS, Python, Oracle, ParAccel, Snowflake
  • Director of Information Technology

    2015 - 2017
    Stockkings Holdings
    • Designed, developed, and maintained a transaction database for a web-based application.
    • Established, hired, and led the information technology department.
    • Collaborated with senior management, developers, and technical support teams to define project requirements and specifications.
    • Organized and facilitated agile and scrum meetings, which included sprint planning, daily scrums or stand-ups, sprint check-ins, and sprint review and retrospectives.
    Technologies: Amazon Web Services (AWS), AWS, Oracle PL/SQL, SQL, Oracle
  • Lead Database Consultant

    2008 - 2015
    MBIA, Inc.
    • Designed and developed a database for an in-house workflow system that enables internal business users to track the claims.
    • Designed and developed a database for an in-house claims transaction system to be able to store claims related information.
    • Designed and built a database for an in-house rating score system.
    • Oversaw unit and system tests and assisted users with acceptance testing.
    Technologies: Linux, Shell Scripting, Oracle Developer 2000 (D2K), Crystal, SSRS, Tableau, PL/SQL, SQL, Oracle

Experience

  • Development of a Centralized Data Warehouse Database

    I led a multi-year, multimillion-dollar initiative to build an enterprise risk system for one of the biggest insurance companies. I also developed a centralized enterprise-wide data warehouse database that has the ability to source the raw data from both internal and external sources and in the form of structured and unstructured data.

Skills

  • Languages

    T-SQL, Snowflake, SQL, Perl, Crystal, Python
  • Tools

    SSRS, Tableau, Erwin, PuTTY, PyCharm, GitHub, Jenkins, Oracle Developer 2000 (D2K)
  • Paradigms

    ETL, Database Design
  • Platforms

    Oracle, ParAccel, Linux, Windows, Amazon Web Services (AWS)
  • Storage

    AWS S3, Oracle SQL Developer, Oracle PL/SQL, SQL Server 2016, Microsoft SQL Server, PostgreSQL, SQL Server Reporting Services (SSRS), PL/SQL, SQL Server Integration Services (SSIS)
  • Other

    Data Warehouse Design, Data Warehousing, AWS, Shell Scripting

Education

  • Bachelor's Degree in Textile Technolgy
    1994 - 1998
    University of Rajasthan - Bhilwara, India

To view more profiles

Join Toptal
Share it with others