Chaitanya Appikonda

Project Description: Migrate the legacy financial reporting platform to a cloud based solution leveraging Snowflake and Tableau

• Document user requirements into system solution and develop implementation plan and schedule
• Conduct workshops with key stakeholders from business teams to gather requirements and deliver working reporting solutions.
• Identifying data sources and develop an integration plan to the cloud data warehouse solution
• Design and develop data models and table structures for data warehouse
• Identify and develop key reports and dashboards in Tableau from the EDW

Project Description: Migrate the on-premise EDW (data warehouse) on Oracle to a cloud based solution leveraging AWS, Snowflake and Tableau

• Design and build a data warehouse in Snowflake to support sales & marketing, operations and finance reporting and analytics
• Develop a data model in Snowflake from existing star schema based Oracle data warehouse to fit the Snowflake cloud solution
• Build integrations with source systems viz, sales and distribution systems and AWS data lake to Snowflake
• Develop and implement the data migration strategy from Oracle data warehouse to cloud data platform
• Design dashboards in Tableau which provides a comprehensive view of revenue metrics

Project Description: Migrate the enterprise data warehouse to a cloud based solution leveraging Snowflake and Azure data platform

• Responsible for re-design & develop business intelligence & DW solution for a major barge operator in US
• Develop a dimensional model for transformation layer and aggregated views for presentation layer
• Redesign and remodel the data marts in the cloud Snowflake solution
• Designed the ETL pipelines for acquiring the data required for analysis and modelling
• Created Tableau reports and dashboards for management consumption

Project Description: As a reporting & analytics platform lead, design, build and maintain the business intelligence and reporting platform.

• Design and build data marts in Oracle data warehouse based on business requirements
• Lead a team of data modelers, ETL developers to support the data platform
• Design and build the data pipelines to EDW using ODI (Oracle Data Integrator)
• Enable Continuous Delivery (CD) to production for all data warehousing and reporting platform build and maintenance
• Performance tuning, data model changes for better query performance

Project Description: Design and implement a supply chain analytics platform for a manufacturing client which supports the product demand and supply analytics

• As part of supply chain analytics team, built data marts and OLAP cubes in Oracle Essbase
• Developed ETL pipelines using Oracle Data Integrator to Essbase
• Develop new Reports, ODI data flows as per the business requirements
• Built dashboards for management consumption in Hyperion

Project Description: Maintain and enhance a reporting solution for a travel client which supports the sales and financial analytics

• Developed and maintained financial planning & forecasting software for the finance teams
• Developed OLAP cubes in Essbase and financial reports in Oracle Financial Reporting tool for analysis and external reporting
• Developed reports for the consumption of management and external reporting such as SEC and GAAP

Project Description: As a data analyst and report developer, analyzed transactional data of the consumer division of the bank, designed & created reports for internal management consumption

• Was responsible for performing data analysis and reconciliation of transactional data and generate reports for management
• Developed GAAP & SEC compliant reports for external reporting
• Automated the report generation process and monitor the same to ensure the reports are distributed on a timely manner