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.
• 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.