Now you can Instantly Chat with Sudhakar!
About Me
I am Data warehouse design and developer with primary skills on MSBI technologies.
Currently working on Snowflake Cloud Datawarehouse with python programming to do ELT process.
Intersted to work on complete Data Engineering and Dat...
Intersted to work on complete Data Engineering and Data Science Projects.
Show MoreSkills
Portfolio Projects
Description
The existing Datawarehouse in Netezza to be migrated to Snowflake . In this project we have used Snowflake hosted in AWS , Linux machine to develop the python script , AWS S3 to load the data files extracted from Netezza . Snowflake Datawarehouse is a Datawarehouse as a service provided to focus on using data not managing. It is a Multi cluster shared data architecture with separated storage and compute.
To extract the data from Netezza an external table is used to unload data to files and those file split in too few MB/GB files depending on size of table in Netezza and uploaded to S3 and then copied to snowflake using COPY command. Initially database and schemas are created in Snowflake by extracting the DDL
Show More Show LessDescription
The Cassady Remote Configurator is a platform to store the Configuration data of multiple controller’s configuration data in cloud and synchronize with OIP IoT platform that contains telemetry data. The Azure database for PostgreSQL (Paas) is used to store the controller data and azure web job, EventHub, Blob services is used to facilitate the D2C and C2D paths to synchronize the data between controller and remote database.
Show More Show LessDescription
The BI Project is extracting data from trade system using ETL solution and provides business users in business intelligence to analyze the trade exceptions. The SQL server is used to store the data, SSIS (SQL server Integration services) ETL is used to transform the data in business needs and SSAS (SQL server Analysis services) provides the data in multi-dimensional view to analyze. Similar way trade data is extracted from file system and provide business users in business intelligence to analyze the movement of trades through different systems and same tools are used as mentioned above. Jasper reports developed from I report tool to be integrated in framework developed using Java to support the similar way as reporting tool as UI.
Show More Show LessDescription
The Project is developing a FATP (Finance and actuarial transformation Program) data warehouse. It is divided into two modules GRIP and Reserving. GRIP (Gross & Reinsurance Process) which mainly deals with data of ongoing process of the business. Reserving is the process where the GRIP data is analyzed and stored to handle the Solvency. Solvency is the amount of risk that can be handled during disaster. FATP is initiated as part of its Solvency Smart initiative to provide a fundamental shift in their ability to improve its reporting capabilities in accordance with the regulation by utilizing a combination of technology solutions and enhanced efficiency in the actuarial reserving and financial reporting process to reduce report generation time lines and increase emphasis on analytic and understanding business results.
Show More Show LessDescription
The BI Project is extracting data from Centralized Storage of Odeon Cinema transactional data using ETL solution to create exporting financial data and transforming into the required export format which can be consumed by the AMC Oracle system. The SQL server is used to store the data, SSIS (SQL server Integration services) ETL is used to transform the data in business needs. SSIS Solution is developed in a way it accepts different parameters dynamically to generating finance report of individual cinema that can be used to reconcile against their finance system.
Show More Show Less