Summary
Overview
Work History
Education
Skills
Project
Other Responsibilities
Timeline
Generic

Ravneet Kaur

Tomball,TX

Summary

Skilled Business Intelligence Developer with background in designing, developing, and maintaining BI solutions. Proficiency in data warehouse design and data mining enhances abilities in crafting effective business strategies based on data-driven insights. Strengths include strong analytical skills, problem-solving ability, and familiarity with BI technologies such as Microsoft Power BI and Oracle BI. Previous work has driven significant improvement in operational efficiency through implementation of robust BI systems.

Overview

6
6
years of professional experience

Work History

Associate Engineer

Emerson IT
Mohali, Punjab
01.2017 - 11.2022

· Over 5 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle EBS.

· Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

· Involved in Agile methodology for the last 2 Years.

· Participation in requirement gathering and translating business needs to technical specifications.

· Involvement in creating functional and technical requirement specification documents with the help of business users and maintaining them.

· Develop and execute reports, Bug fixes in any existing solutions, optimizations, and enhancement to the code, document processes, and generate required metadata.

· Develop database objects like Stored procedures, functions, and packages in Oracle 11g and 12c in SQL and PLSQL using tools like TOAD, SQL Developer, and SQL Plus and then use them for creating BI reports /dashboards using edge applications such as Noetix and POWERBI.

· To regularly monitor BI reports, check their performance, and tune them when performance degrades by analyzing trace files as a part of the system health check process.

· To troubleshoot the data issues in BI solutions such as Noetix reports and conduct unit testing while creating new solutions.

· Coordinate with different teams to provide an efficient solution (existing or new) to business users as per their requirements.

· Contributes throughout project life cycles, from planning to production implementation, including the creation of functional designs, technical designs, and test plans for repository models and hierarchies.

· Work closely with the team lead and manager to analyze the problem and propose its related solution in a timely manner in an agile environment. Attending Daily scrum meetings to discuss the issues and progress made on current projects/assignments and update the DEVOPS accordingly.

· Knowledge transfer to new team members regarding the edge applications used within the team. Involvement in creating functional and technical requirement specification documents with the help of business users and maintaining them.

Intern

Emerson IT
Mohali, Punjab
01.2017 - 12.2017
  • Maintained accurate records of all activities performed throughout internship period.
  • Prepared reports summarizing project progress and results for management review.
  • Assisted with event planning, support and execution of virtual and in-person engagements.

Education

MBA - INTERNATIONAL BUSINESS AND MARKETING

Punjab University
Chandigarh
05-2021

Bachelor of Science - Computer Science And Programming

Punjabi University
Patiala
05-2017

Skills

Databases: 11g and R12

Languages:- SQL, PL/SQL

Tools:- Noetix , Tableau, POWER BI, SQL Server Reporting services(SSRS)

Other Tools:- DEVOPS, Serena Business Manager (SBM), Service Now

Project

R12 upgrade:-

· Upgrading BI Applications such as Noetix to R12

· Making all the views, reports compatible to R12 by modifying underlying code

Creation of reports, dashboards for newly set up Business Units:-

· Understanding requirements from business and developed views using SQL which were further used for data extraction purposes

· Created reports , dashboard using tools as Noetix, POWER BI for business for daily, monthend reporting

BI Application upgrade:-

· Worked on Noetix application upgrade .

· Created project plan, upgraded Noetix views and other objects , performed sanity checks on Applications after upgrade, worked on project issues logged after upgrade such as performance issues.

Fixing Invalid objects:-

· Worked on fixing invalid objects present in database by either deleting them or fixing them as per R12 standards

Improve Performance of BI reports and dashboards:-

· Identifying all the programs , dashboards and reports which are long running and tuning them either by modifying the code or by applying hints or through optimizer

Agile methodology:-

· Attending agile training , acquiring SAF-e agilist certifications , attending/leading Scrum meetings, Attending PI planning events.

Other Responsibilities

· Was responsible for providing Knowledge transfers to new team members .

· Creating documentation for KT’s.

· Providing monthly training on how to use BI tools such as POWERBI, Noetix reports to new business users

· Leading status calls with vendors, sending MOM to the whole team

Quality check of new joinees tasks(code, processes followed)

Timeline

Associate Engineer

Emerson IT
01.2017 - 11.2022

Intern

Emerson IT
01.2017 - 12.2017

MBA - INTERNATIONAL BUSINESS AND MARKETING

Punjab University

Bachelor of Science - Computer Science And Programming

Punjabi University
Ravneet Kaur