Kothakapu Keerthana Email & Phone Number

Prince Edward Island, Canada

• Complete solution provider responsible for ETL from operational systems, data modelling, data retention in department data mart and report building in R-Shiny. Extensive use of Excel for Data Analysis. • Identification and correction of data quality and process issues leading to significant and impactful result corrections.• Significant use of Pentaho DI, Oracle SQL, MS-SQL, GitLab, R-Studio, Crystal Reports, BOE. Expertise in creating Crystal reports based on the client’s requirements and scheduling/maintaining the scheduled reports in Business Objects.• Developed shiny applications and dashboards using various R packages based on clients request at provincial level.• Working on converting Business objects reports to R reports.

Charlottetown,Pei, Canada

A subject matter expert on IT BI Systems, responsible for troubleshooting escalated technical issues in BI tools, Data Warehouses and Data Marts.• Responsible for Advanced business as usual support and troubleshooting of undocumented BI issues.• Building Enhancements and small change, under 120 hours, in OBIEE, Informatica 9/10 , SQL Server (Multiple environments) and Crystal Reports.• Working with my team or alone. Responsible for prioritizing incidents and enhancements without management intervention.• Significant use of Informatica, OBI and SQL Server, Autosys. Supporting Power BI applications.