Power Bi Report Writer

Radha Chilkur

720-***-**** Houston, Texas ********@*****.*** https://www.linkedin.com/in/radha-chilkur No Sponsorship required. Visa Status: Green Card

DATABASE REPORT WRITER

Epic Certified Power BI Microsoft Excel Crystal Reports

Database Report Writer with around 5 years’ experience working in IT. Proficient in leveraging Crystal Reports, Microsoft Excel and Power BI to create insightful, data-driven reports and dashboards for strategic decision-making. Proficient in PL/SQL, Oracle database. Experienced in creating robust, clean, and scalable complex SQL queries. Highly skilled in data collection, interpretation, and trend analysis, with a focus on time management.

CERTIFICATIONS

EPIC CERTIFICATIONS

Clinical Data Model

Clarity Data Model

Caboodle Data Model

Cogito Fundamentals

TECHNICAL SKILLS

Epic Data Models: Clarity Data Model, Caboodle, Chronicles, Clinical

Power BI, Crystal Reports, Business objects,

SQL: Subqueries, CTE’s, Stored Procedures, PL/SQL, Window functions

Languages: Python(Data Science)

Cogito: Radar, Reporting Workbench, Slicer Dicer, Analytics Catalog

MS Technologies: MS SQL Server, SSIS, MS-Word, MS-Excel(advanced)

Database: Oracle SQL developer, SQL Server

Concepts: Waterfall, Scrum, Kanban, Agile methodologies, Object Oriented Programming

Tools: Qvera Interface Engine, ServiceNow

Currently Pursuing Post-Graduate Program in Data Science & Business Analytics from University of Texas, Austin. [09/24 – Present]

WORK EXPERIENCE

Ascension Health care [07/2023 - 01/2024]

Clarity Report Writer

Developing complex operational and project-related reports including design, documentation, development, testing, implementation, and ongoing support using Epic Clarity Data model

Responsible for the development and modification of internal and client-facing Clarity reports on an ongoing basis using Crystal Reports, Business Objects Enterprise, and Epic Crystal Integration, and SQL queries.

Responsible for the development and modification of reports in Epic's Reporting Workbench Reports.

Constructing stored procedures, views and SQL queries for report requirements and submit data to the clinical analyst for validation.

Attended meetings with Clinical and Business analysts to understand the upgrade process and activities. Documenting workflows, processes, and results

Responsible for providing report design, development, testing, debugs, programming and modification support, and maintenance of reports in multiple databases, environments, and applications for efficient and effective reporting.

As per user’s request, some of the reports Converted Crystal reports to cogito SQL reports and Power BI Reports

Monument Health – Rapid City, South Dakota [10/2022 – 5/2023]

Programmer Analyst

Write SQL queries and Stored Procedures, CTEs and window functions against Epic Clarity/Caboodle Databases.

Design, develop, and maintain Cogito Reporting Workbench reports.

Maintain regular communication with Epic representatives and works with the Epic representatives and end user community to ensure the system meets the organization’s needs.

Knowledge of statistical methods in Python, write Python scripts for data extraction

Analyse data using Python libraries such as NumPy, Pandas, and Seaborn

Softn Solutions LLC – Houston, Texas [08/2021- 08/2022]

Software Quality Assurance Engineer

Worked as an Interface Engine tester which includes testing new interfaces to translate and transfer Healthcare Data between Health care units. Testing Interfaces and Mapping data that was implemented using Qvera Interface Engine and JavaScript.

Understanding of production environment management Agile development methods like Scrum, and Kanban

Experience with or exposure to REST Web APIs (XML and JSON)

Working support for existing applications including troubleshooting and bug fixes.

Work closely with backend developers, business analysts in a highly collaborative and Agile team environment

Proficient in performing Unit testing, System testing, Integrated testing, Regression testing and assisting with UAT.

Involved in creating test plans/ reviewing test cases, business process test scripts and defects using Azure Devops Test plans.

Applauded for executing extensive testing on complex workflows in a very short time.

Just in Trend – Katy, Texas [01/2021 – 07/2021]

Analyst

Created interactive and visually engaging dashboards in Tableau and Power BI to facilitate data understanding for non-technical users

Katy Independent School District – Katy, Texas [03/2018 – 03/2021]

Substitute Teacher

Computer Science substitute teacher

Communicate and interact appropriately and professionally with students and colleagues.

Project: Evaluation of Peptide Mass Spectrometry data in Proteomics – Denver, Colorado University of Colorado, Denver

Understanding the data, Data Preparation, Data Mining

Analysis and Visualization and Cluster Validity measures. Environment: Weka3

Software Engineer Tech Mahindra erstwhile Satyam Computer Services Limited – Hyderabad

Create custom SQL queries to extract data from the data sources • Work with complex SQL statements and stored procedures • Information gathering, analyze user request and translate into functional specifications • Responsible for overseeing the Quality procedures related to the project which includes working on Microsoft Project • Excellent written skills. • Was responsible solely for bringing out the requirements and analysis document for the software

EDUCATION

University of Colorado - Denver, Colorado

Masters – Computer Science, May 2006

Osmania University - Hyderabad, Telangana, India

Masters – Computer Applications, May 2000

Osmania University - Hyderabad, Telangana, India

Bachelors – Mathematics, Physics, Chemistry, May 1997

VOLUNTEER EXPERIENCE

VT Seva Communications Lead- Houston, Texas 2019- Current

PVSA Approved – Nonprofit organization.

Communicate events on various social media. Interact with the board members regionally and nationally.

Maintain current Website. Design Flyers in Canva, Google drawings

Make Forms using the Formsite.

Prajna Sunday school Coordinator – Houston, Texas 2016-Current

Sunday school

Make lesson plans, conduct tests. Review and monitor progress for the students.

Organize events, plan skits for the class and school.

Seven Lakes Junior High – Katy, Texas 2016-Current

Contact this candidate