*

Nagasubramanian (Naga)

Pleasanton, CA

Email: adhxch@r.postjobfree.com

Mobile: 425-***-****

Professional Summary

Overall 10+ Years of professional experience in software industry with exposure to SaaS, PaaS & IaaS.

Passionate in engineering solutions with distributed architecture and well versed in SDLC and Agile methodologies.

Experience enterprise Dimensional Data-modelling, Business Intelligence and OLAP reporting.

Experience in HR, Finance and Risk compliance functional area.

Proven abilities in stakeholder interests and provide IT solutions in line with core business objectives

Comfort interacting with people across hierarchical/functional levels for ensuring smooth engineering and product development.

Technical Skills

Programming Language Java, Python, Oracle PL-SQL, JavaScript Data Science OBIEE 12c, BI Publisher, ODI, Informatica, Tableau Version Control ADE and CVS/ GIT

IDE Oracle ADF

Environment Windows, Oracle Linux, Unix, Dockers/Kubernetes Professional Experience

Oracle Corporation 2015 To Till Date

HCM Fusion Workforce Environmental, Health and Safety (EHS) Environment: Oracle ADF, Java, Oracle Database 11g, OTBI, SQL-PLSQL, ADE, GIT

Design and developed Cloud based HCM Application using Oracle ADF, Java.

Responsible for EHS Fusion Data model changes.

Responsible for continuous integration and Release activities.

Used Oracle Fusion Functional Setup Manager (FSM) to implement enhancements

Creation of Custom Security for Oracle HCM Cloud which includes Create/Modify Data roles, its Security Profiles, Job Roles, Application Roles and Duty Roles. Oracle Corporation 2014 -2015

HCM Fusion Governance, Risk and Compliance (GRC)

Environment: OTBI,OBIEE 11g, BI Publisher, Oracle Database 11g, SQL, PL-SQL, GIT, Jenkins

Developed ADF business components (EO, VO, EO Associations and View links).

Developed the RPD using joins, complex joins, complex measures, hierarchies, and security.

Created Dimensional Hierarchy, Level based Measures and aggregate navigation in BMM layer.

Designed and developed custom reports and dashboards with different Analytics views.

Responsible for tuning the OTBI reports/dashboards performance. 2

Oracle Corporation 2013-2014

Frog Migration Business Objects (BO) with Oracle Business Intelligence Environment: OBIEE 11g, BI Publisher, Oracle Database 11g.

Designed Schema using Fact, Dimensions, and Physical, Logical, and Alias tables.

Developed custom dashboards and scorecards using Oracle Answers.

Mentor the enhancement team on OBIEE enhancement and change request.

Actively participated in gathering business requirements.

Managed security privileges for each subject area and dashboards according to user requirements.

Implemented ETL process to load data into target Oracle tables.

Analyzed query plans and fine-tuned complicated SQL. Cognizant 2012 -2013

Cummins

Environment: OBIEE 11g, Informatica, SQL, PL SQL, UNIX

Assisted in performance tuning from DHW to OBIEE queries.

Mentor the enhancement team on OBIEE enhancement and change request

Actively participated in gathering business requirements Amplify Systems 2011 -2012

Amazon

Environment: OBIEE 10g, Oracle EBS, Oracle 11g R2, Informatica, Data net.

Developed PL/SQL blocks to generate reports for business.

Installation of BI Publisher stand-alone system in Linux Rhel.

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. Oracle Financial Services 2006 – 2011

OFSAA Development

Environment: Java, OBIEE 10g, SQL, PL SQL, Erwin, UNIX, JavaScript.

Developed custom reports using OBIEE Answers, 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. Educational Qualification and Certification

Master of Science (Information Technology) from Annamalai University.

Bachelor of Science (Mathematics) from Madras University.

Contact this candidate