Reporting and Business Intelligence
Minimum of 8 to 10 years of experience in Report building and Business Intelligence with
Profound knowledge on Oracle BI Publisher and BI Analytics with Oracle Fusion HCM domain especially in Core HR, Payroll and Absences modules
Primary skill:
- Experience generating BI publisher reports, dashboards and drill-down reports
- BI Publisher (RTF design/ eText/ Scheduling/ Parameter Handling/Bursting/backup and migration of reports to different pods)
- Design Oracle BI Publisher Data Models, Data sets and Templates/sub-templates
- Strong PL/SQL and Advanced PL/SQL experience
- Solid understanding of performance tuning best practices and experience improving end-to-end processing times
- Knowledge on the data models related to Fusion HCM (Core HR, Absence and Payroll modules)
Nice to have skills:
- Experience generating BI publisher reports, dashboards and drill-down reports
- Strong OBI Administrator activity
- Create mobile applications with Oracle Business Intelligence Mobile App Designer
- Use BI Mobile to access BI Content
- Create and modify Interactive Dashboards
- Knowledge of additional reporting tools viz. HCM Extract / OTBI / Analysis Dashboard would be an added advantage
Behavioural and Process Skills
- Experience working in Agile teams
- Self-motivated and self-directed abilities to prioritize and execute tasks in a high-pressure environment with "time-critical" deadlines
- Proven analytical, evaluative, and problem-solving abilities
- Possesses a team and customer service provision orientation
Shubham Vishwakarma
Full Stack Developer - Averlon
Similar jobs
Job Description:
7+ years of experience as a Techno-Functional specialist supporting a finance organization with an emphasis on project management.
Must have 2-3 Project implementation and more than one support experience in Oracle EBS R12.
Expert level knowledge of Oracle Applications Framework, Oracle Workflow, Oracle Forms, Oracle Report, XML Report, PLSQL
Functional knowledge in financial module like, GL,AP, AR PO, Project is must Extensive use of oracle APIs and interfaces Experience in performance tuning of the code Experience in shell scripting.
Worked on Oracle Alert, AME, OAM ,DFF etc Good to have ADF experience Good to have ORDS experience Good to have exposure in cloud technology.
Responsibilities:
Act as a senior liaison between Business partners and IT communities Facilitate cross-functional teams through business process and application initiatives from requirements definition to prototyping, design, development, testing, training, and deployment.
Create technical designs to support business requirements.
Lead the development of technical solutions. Communicate project status and escalate issues to management. Develop and execute system test plans and scenarios.
Assist in preparing training materials for deployment of applications, modules, enhancements and bug fixes.
Assist in developing baseline datasets and reports to support testing of technical solutions.
Position Overview
Oracle Apex Engineer with good experience building reports using the latest versions of Oracle Apex
and experience in Apex Upgrade. Should have a good working knowledge of Oracle
Applications(R12).
Skills
1-2 end to end implementation/development project
Strong detail, quality, and solution orientation
5+ years of experience designing and implementing technical solutions that are aligned with
business strategy
5 years of applications development experience with Oracle APEX, Oracle SQL, PL/SQL
5+ years of Oracle APEX experience
5+ years experience in Oracle Databases
5+ years experience using PL/SQL
5+ years of JavaScript, HTML, CSS, and REST services
Oracle APEX 4.2 experience is a must and ability to Upgrade to higher versions
Ability to work on SQL performance issues
Ability to think critically and solve complex issues
Ability to work independently, while engaging the customer and providing information to the team
Strong ability to communicate both verbally and in writing with internal and external teams
Ability to prioritize across multiple projects and meet deadlines
Experience adapting in a dynamic work environment
Experience working in a customer-focused environment
Ability to troubleshooting issue
Proficiency in analysis, design, development, testing, implementation, and maintenance of
applications in Oracle Application Express (APEX).
Excellent conceptual knowledge of Oracle 11g.
Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions,
packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor,
Dynamic SQL.
Good knowledge of using PL/SQL Wrappers to protect the PL/SQL procedures and packages.
Job Description:
- To resolve the tickets raised as per the defined standards of time, cost, and quality for increased customer satisfaction.
Skills and Experience
- Good SQL & PLSQL knowledge.
- Good Unix basic commands knowledge.
- Good Unix scripting knowledge will be an advantage.
- ANSI SQL
- Unix - Others/
- Experience - Fresher
Job Description:
As a L3 analyst, you will play a key role within the Application Management team, leading services for its customer(s). This service has responsibility for the smooth daily operational running of the Client platform both in the cloud and on-premises. The Client application is business critical and centrally manages data for trading, settlement, risk, client and regulatory reporting systems. As a L3 analyst, you will be responsible for supporting complex infrastructure and application issues raised by L1/L2 support teams, and business analysts. You would also be working on client requests for enhancements, fixes, maintaining custom code, and following the best practices such as Agile, DevOps, etc.
The role is a technical role requiring a good technical knowledge of SQL/PLSQ, Core Java along with good debugging skill while supporting client implementations. You should have basic understanding on Unix system and commands. The ability to troubleshoot issues, assist users and help write specifications is essential. This position also works with product management to improve the software engineering processes and practices associated with continuously building, deploying, and updating software and environments.
- Accountability and primary responsibility/duties:
- A typical day would look like as follows: -
- 40% support issues.
- 40% configuration/development work.
- 20% continuous improvement, automation, CICD, so on.
- Activities would range across the lifecycle from discovery to post-implementation support.
- Understanding client’s requirement, replicate the problem and providing the solution
- Understanding and developing new requirements coming in from BAs (Business Analysts) and customers.
- Update the existing functionality based on client needs.
- Develop changes that cater to enhancing the product and/or fixing production issues
- Prepare product releases of software components. (Java/SQL-PLSQL)
- Contribute in all phases of the development cycle. (development/Deployment/Testing, peer review)
- Create technical document for all changes made.
Required Qualifications/Knowledge/Skills
- Bachelor’s degree in Computer Science or related field
- Strong basics and working experience in following technologies: -
- Core Java.
- SQL / PLSQL coding.
- Object Oriented Programming concepts and data structures.
- Working knowledge on Unix platform
- Working knowledge on XSLT and XML handling
- Basic understanding App & web server working knowledge (JBOSS, WebLogic and WebSphere) and debugging skills.
- Advantageous to have:
- Working understanding on CICD, Dev-ops technologies.
- Queuing technologies including Kafka, MQ, Solace.
- Scripting including Python, Unix, java.
- Hands on knowledge of Dev ops processes and tools Good interpersonal and communication skills.
- Power BI Report development.
- Building Analysis Services reporting models.
- Developing visual reports, KPI scorecards, and dashboards using Power BI desktop.
- Connecting data sources, importing data, and transforming data for Business intelligence.
- Analytical thinking for translating data into informative reports and visuals.
- Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.
- Should have an edge over making DAX queries in Power BI desktop.
- Expert in using advanced-level calculations on the data set.
- Responsible for design methodology and project documentaries.
- Should be able to develop tabular and multidimensional models that are compatible with data warehouse standards.
- Very good communication skills must be able to discuss the requirements effectively with the client teams, and with internal teams.
The ideal candidate will be familiar with the full software design life cycle. They should have experience in designing, coding, testing and consistently managing applications They should be comfortable coding in a number of languages and have an ability to test code in order to maintain high-quality code.
Responsibilities
- Design, code, test and manage various applications
- Collaborate with engineering team and product team to establish best products
- Follow outlined standards of quality related to code and systems
- Develop automated tests and conduct performance tuning
Qualifications
- Bachelor of Science in Information Technology
- 1+ years of experience working with .NET, Asp.net or relevant experiences
- Experience developing web-based applications in Asp.net, Dot net Core, jQuery, HTML5, Rest base API integration
- Understanding DB,PL/SQL, Webform
- Experience working in agile development environment
● Good knowledge of Dimensional data warehouse systems
● Reporting data models with SSIS and MS SQL Server
● Knowledge of all aspects of BI preferably data modeling, data
● integration, data analysis, and reporting
● Good working knowledge of MS Azure environment
● Knowledge of BI tools like Tableau or PowerBI
● Good communication skills
The main roles and responsibilities of a Power BI developer are discussed below:
- Power BI development and administration.
- Building Analysis Services reporting models.
- Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
- Connecting to data sources, importing data and transforming data for Business Intelligence.
- Excellent in analytical thinking for translating data into informative visuals and reports.
- Able to implement row level security on data and have an understanding of application security layer models in https://powerbi.microsoft.com/en-us/">Power BI.
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon