SUMMARY

• Overall, 15 Years of professional experience in software industry with exposure to SaaS, PaaS and IaaS.
• Passionate in engineering solutions with distributed architecture and well versed in SDLC and Agile methodologies.
• Expertise in enterprise Dimensional Data - modelling, Business Intelligence and OLAP reporting.
• Experience in Core HR, Health and Safety, Finance and Risk compliance functional area.
• Have Significant international expertise working with/managing people from diverse backgrounds.
• Proven abilities in stakeholder interests and provide IT solutions in line with core business objectives.
• Excellent problem solving and inter-personal skills with strong technical background.
• Quick learner, able to work with conflicting priorities, excellent team player with the ability to meet deadlines under pressure.
• Comfort interacting with people across hierarchical/functional levels for ensuring smooth engineering

TECHNICAL S KILLS

Cloud/SaaS: Oracle Fusion HCM, Oracle Taleo Recruiting

Programming Languages: Java, Python, Oracle PL-SQL, JavaScript

Data Science: OBIEE, Oracle BI Apps, OTBI, BI Publisher, DAC, ODI, Informatica, Tableau

Version Control: ADE, CVS/ GIT and Jenkins

IDE: Oracle ADF

Environment: Windows, Oracle Linux, Unix, Dockers/Kubernetes

PROFESSIONAL EXPERIENCE

Confidential

Oracle Fusion Finance and SCM

Responsibilities:

• Responsible for working with Cross-functional team(s) to resolve application configuration management issues and coordinating with development team.
• Undertook making process improvements in Change Management and Release Management areas.
• Developing the OTBI and BI Publisher reports as per the requirement.
• Working closely with Oracle support team to receive required patches.

Confidential, Pleasanton, CA

Oracle Fusion HCM Workforce

Responsibilities:

• Extensively worked on data modelling, designing, and developing multiple responsive web (UI) pages for HNS using Oracle ADF technology (ADF Business components, task flows, page fragments) and Java.
• Designed Metadata repository(rpd) - Physical, Business Model & Mapping, and Presentation Layer(s).
• Developed interactive dashboards and BI Publisher reports based on product owner’s requirements.
• Developed ADF Model layer components (created, configured, tuned entity objects, view objects, application modules, associations, view links, LOVs, dependent LOVs, bindings, and data controls).
• Resolved complex issues/limitations observed during product development phase.
• Implemented data validations using java bean methods, also defined validation methods at ADF Model layer.
• Completed design activities related to public REST API within Oracle Fusion Domain for HNS.
• Finished design, development of security using Fusion Security Model, seed data, strings, descriptive flexfields and web UI (HNS) pages customizations using HCM Transaction Design Studio.
• Completed multi-lingual, oracle accessibility standards testing of web UI (HNS) and Functional Setup Manager (FSM) custom UI pages developed to address customer needs.
• Adhered to Oracle Fusion coding standards and instilled a peer review process within the team.
• Performed CI/CD activities using ADE to support agile product deployment, post deployment activities.
• Performed root cause analysis of customer issues and provided short/long term fixes accordingly.
• Ensured continuous feedback loop post customer issues, resulting in high quality product development.
• Responsible for designing and creating database views based on GRC Data analytics (DA) Schema to source data for Oracle Fusion GRC Intelligence (GRCI)
• Undertook ODI Installation, Configuration, creating master and Work repository. Setup of Topology, data Stores, projects.
• Implemented ODI interfaces and scenarios for extracting and loading data from a variety of datasources/targets.
• Responsible for Designing, Implementing and Testing Oracle ADF Business Components for GRC using JDeveloper 11g.
• Responsible for creating ADF business components (EO’s, VO’s, EO Associations, View Links andApplication Module) to be used by GRCI.
• Completed modeling the rpd based on existing DA rpd and simulated the existing reports using OTBI.
• Created Data source synchronization Information, Control listing reports and User access review dashboard.
• Succeeded in tuning the OTBI reports/BI Publisher Reports/dashboards performance.

Confidential

Oracle Taleo

Responsibilities:

• Performed in-depth analysis of legacy SAP BO reporting solution, TEE’s OLTP structures and new requirements
• Created reporting tables and other database objects (views, materialized views, partitions, indexes etc.)
• Created mapping of transaction tables vs derived tables and reporting layer tables.
• Created ETL jobs using custom PL/SQL code (Packages, Stored Procedures, Functions)
• Created reconciliation queries to ensure data quality (OLTP to Reporting).
• Created an audit and health monitoring layer for error logging and associated fixes.
• Completed design, development of semantic layer (OBIEE rpd) with Recruiting subject area.
• Migrated key Business Objects customer reports (Related to Recruiting BO Universe) to OBIEE.
• Tuned OBIEE login performance and Report (Query) performance in SaaS environment.
• Performed Recruiting subject area enhancements to add Onboarding/Performance Management modules.
• Worked closely with support team and resolved complex customer issues.
• Assisted in performance tuning from DHW to OBIEE queries.
• Mentor the enhancement team on OBIEE enhancement and change request
• Work closely with Global Support Center and L2 Desktop Support teams to continuously improve/promote L0, L1, and L2 fault-resolution.

Confidential

Support Engineer

Responsibilities:

• Developed PL/SQL blocks to generate reports for business.
• Installation of BI Publisher stand-alone system in Linux.
• Created BI Publisher reports for operational database.
• Configuring Security, Scheduler and the FTP share folder for BI publisher.
• Modified some of the existing reports and dashboards, fixing some of the issues related to performance, and data quality during production support.
• Developed custom reports using OBIEE Answers and assigned them to application specific dashboards.
• Developed the RPD using joins, complex joins, complex measures, hierarchies, and security.
• Used dynamic session and repository variables in filters and prompts and used presentation variables wherever user requires entering a value in the prompt and the report has to navigate based on the value of the prompt.
• Created various regulatory reports using BI Publisher (using data template and SQL queries).
• Designed and developed complex financial BI publisher report using rtf template, writing complex SQL queries in BI Publisher data set.
• Performed SQL tuning by using Explain Plan, hints, and Tkprof.
• Generation of volume data for performance testing and tuning the queries.