Chitra Devi Shanmugam

Urjanet is now part of Arcadia and it connects to nearly 10,000 electricity, natural gas, water, waste, cable, and telecom providers all over the world. My Contributions are Hands-on experience in the implementation of cloud data warehouses using Snowflake. Experience in Snowflake, building solutions for Historical and Incremental data load into Snowflake, that performs Data Extraction from Legacy system in AWS MySQL server. Designing and developing data integration solutions using DBT. Hands-on experience in AWS Cloud technology. Test the data using DBT (schema tests, referential integrity tests, customs test) and ensures data quality. Debug DBT to debug complex chains of queries. They can be split into multiple models and macros that can be tested separately. To create Analytics reports and data visualization dashboards using complex snowflake sql and Hex Analytic tools.

Urjanet is the world's leading Utility Data aggregator used by Fortune 500 companies and their providers to make smarter decisions on their energy spend and sustainability efforts. My Contribution @Urjanet includes, Responsible for the DBA operations. Optimize DB operations with MySQL performance tuning techniques and configurations. Involvement in the entire SDLC processes including Requirement analysis,Design,Development,Testing, and Implementation. Database design to support reporting requirements. Development of Stored procedures, Triggers, Functions and Complex SQL queries as part of reporting. Data Analysis using R-Programming and intuitive analysis using Python. Create Data Extraction ,Transform and Load Applications using Scripting Languages like R programming and Shell Scripting. BI Report generation using Tableau.

The goal was to build a Audience Data warehouse for a global measurement and data analytics company, that contains data regarding the Statistics of the program / Channel tuned , duration viewed and the audience of the program.The data collected through Electronic metering system are loaded in upstream CORE Application .This projects extracts data from the CORE system and applies specific business rules as per the requirement and loaded in to the ADW which is further used by the downstream reporting system. My contribution includes , Technically leading the team by performing Requirement Analysis, Design, Code review and Implementation Support. Onsite offshore Co-ordination. Technically Mentoring junior Team members.

This goal of this project is to build and maintain a Data warehouse for for leading international Financial institution , for Loan administration system as the bank transitions from current system to the new state of the art, SAP and internet based system, it plans to move the existing staff to the development of new system. This application is used to disburse, bill and account for the loans given by World Bank to the countries or its authorized representatives around the world. This system also interfaces with treasury and projects (in SAP). My contribution includes , Onsite Lead working at customer's place at USA for 1+ year and offshore Lead for 2 years. Technically leading the team by performing Requirement Analysis, Design, Code review and Implementation Support. Coordinating with testing team members to prepare test result.

The goal of this project is to develop an integrated Information System for Educational Institutions. This system will have details like students and staff with their photographs, Exhaustive search facilities, Hierarchical view for the whole Institution, Access rights to ensure security, Online help for all the Modules. My contribution includes, Requirement collection, Analysis and Design, Coding, Installation, documentation, testing, integration, deployment, training and support. Debugged and tested stored procedures to improve the performance. Creation and maintenance of database user accounts.