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.
· 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.
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
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.
· 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)