Senior Data and Reporting Consultant
2018 - 2019Transamerica- 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 ServerSenior Data Engineer Consultant
2017 - 2018IAC 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, SnowflakeDirector of Information Technology
2015 - 2017Stockkings 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, OracleLead Database Consultant
2008 - 2015MBIA, 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
Ranjan Goenka
Data Warehouse Design Developer in Mount Kisco, NY, United States
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 now available for hire
Portfolio
- TransamericaErwin, SQL Server Integration Services (SSIS)...
- IAC ApplicationsAmazon Web Services (AWS), Jenkins, GitHub, Perl, PyCharm, PuTTY, Windows...
- Stockkings HoldingsAmazon Web Services (AWS), Oracle PL/SQL, SQL, Oracle
Experience
- Oracle 20 years
- Data Warehouse Design 15 years
- Database Design 15 years
- Data Warehousing 15 years
- Tableau 5 years
- SQL Server 2016 5 years
- Python 3 years
- Amazon Web Services (AWS) 3 years
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
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, PythonTools
SSRS, Tableau, Erwin, PuTTY, PyCharm, GitHub, Jenkins, Oracle Developer 2000 (D2K)Paradigms
ETL, Database DesignPlatforms
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
Education
- Bachelor's Degree in Textile Technolgy1994 - 1998University of Rajasthan - Bhilwara, India
