Ranjan Goenka, Developer in Mount Kisco, NY, United States

Ranjan Goenka

Data Warehouse Design Developer

Location
Mount Kisco, NY, United States
Toptal Member Since
June 24, 2020

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 available for hire
Hire Ranjan

Portfolio

Transamerica
Erwin, SQL Server Integration Services (SSIS)...
IAC Applications
Amazon Web Services (AWS), Jenkins, GitHub, Perl, PyCharm, PuTTY, Windows...
Stockkings Holdings
Amazon Web Services (AWS), Oracle PL/SQL, SQL, Oracle

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.

Work Experience

2018 - 2019

Senior Data and Reporting Consultant

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 (Transact-SQL), SQL, Oracle, Microsoft SQL Server
2017 - 2018

Senior Data Engineer Consultant

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, Python, Oracle, ParAccel, Snowflake
2015 - 2017

Director of Information Technology

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), Oracle PL/SQL, SQL, Oracle
2008 - 2015

Lead Database Consultant

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, SQL Server Reporting Services (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 (Transact-SQL), Snowflake, SQL, Perl, Crystal, Python

Paradigms

ETL, Database Design

Platforms

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

Storage

Amazon S3 (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, Shell Scripting

Tools

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

Education

1994 - 1998

Bachelor's Degree in Textile Technolgy

University of Rajasthan - Bhilwara, India