- Directly coordinating with user to gather the requirements.
- Creating Users, Groups and assigning roles as per security requirements.
- Raising and tracking Service Requests with Oracle Corporation on OBIEE issues.
- Deploying RPD and Web Catalog.
- Designed report by using direct source system like PL/SQL
- ODI Designer is used for reverse engineering tables from database to develop projects, and release scenarios.
- ODI Interfaces successfully created and deployed to DW.
- ODI designer used to create refresh variables to use in ODI packages.
- Loaded metadata and data from Oracle to Hyperion essbase using ODI interfaces.
- Created ODI (Synopsis) interfaces for loading the data from Source System to DW and from DW to different Datamart.
- Designed reports from PLSQL Query and Created dashboard and Analysis from SQL Query.
- Deployed Custom images help links, View.css files and common.css files.
- Supports monthly schedule activities for moving the code from Dev. to stage and Production.
- Configured usage tracking which would help to track the applications usage.
- Analyzing the specifications provided by the Business user.
- Understanding Business Data.
- Expertise in the AIM methodology, Documentation, Configuration of applications, testing, end user
- Training and support for Oracle financials R12.11i GL,AP,AR,CM and FA modules
- Participated in multiple Oracle apps 11 implementations in multi org/multicurrency scenarios, Order
- Management and worked as areas involving pricing, purchasing, and inventory
- RedesignedCashManagement, Payments Business Processes and IT operations
- Getting Data from the JD Edwards as one of the source and configured in the Clear case
- Coordinate ETL team for the Production data issue and mapping failures.
- Involved in Control-M Changes for the job insertion and monitor the workflows.
- Developed RPD creation by including all the functional requirements.
- Inserting new Users and modifying the existing Users access by using the LDAP authentication.
- Creating hierarchies in business model.
- Experience in PeopleSoft HRMS (HR/ NA and Global Payroll/ Base Benefits/ Benefit Administration/ eApplications
- Proficient in People Tools - Application Designer, Application Engine, Upgrade Assistant, Maintain Security, File Layout, Component Interface, Process Scheduler, PS Query and Data Mover.
- Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.
- Involved in documentation of technical specifications and developing test cases.
- Involved in full length Life-Cycle implementation of PeopleSoft modules.
- Good Conceptual understanding of various PeopleSoft Applications.
- Designed different views view Selector, Legend, MAP viewer
- Working extensively in Answers and Dashboards.
- Design solution using MDM
- Facilitate Data load and syndication
- Develop MDM solutions for workflows, de-duplication, validations Etc
- Complete MDM Project documentation
- Experience on Discoverer Reports and dashboard development
- Created the requests and view the results in different views like table, compound layout, chart and pivot table.
- Developing different brand level reports, filters, and prompts by using web.
- Performing the Unit and Integration testing.
- Experience with Table partitioning and compression, materialized Views, Parallel Queries
- Created Initializations Blocks and variables to implement Security at RPD level.
- Worked on 24/7 support during the quarter close.
- Worked on Fragmentation at RPD level
- Complex SQL and PL/SQL with strong performance tuning capability
- Provide support in the implementation of OBIEE components
- Install, upgrade and configure all components of OBIEE
- Proficiency with Data Analysis tools with Analytical experience
- Design and implement data in various layers including physical, business and presentation
- Assist the teams in generating dashboards and reports properly
- Use the best practices of business intelligence to administer the analytical solutions
- Perform validation of data on the reports and monitor the performance status of the same
- Assist and administer the deployment process of UNIX, OBIEE and repository codes
- Prepare monthly reports and present it to the management
- Assess production faults and critical issues followed by identification of the root cause
- Provide remedial measures to the production issues or process failure
- Train the administration team on new OBIEE and ETL tools
- Converts business requirements and specifications into Tableau presentation and data layer application
- Designs and creates data views in SQL and influences decisions regarding infrastructure and back-end data solutions in order to enable evolving analytical needs.
- Designs and develops Teradata data structures based on reporting requirements.
- Utilizes presentation layer mock-up software to effectively visualize and demonstrate proposed user interface dashboard and scorecard solutions in order to gain buy-in on requirements.
- Actively participates in and influences discussions around reporting requirements, infrastructure needs, and design with matrix partners.
- Deep understanding of key business applications as primary sources of data for presentation and data layer application solutions.
- Increases organizational and personal capacity by mentoring and enabling team members to complete coding and testing assignments in coordination with on-shore delivery leads.
- Deploying Informatica jobs by using Control-M tool and Monitor the Job failures.
Environment: OBIEE12.2.1.0.0,, Oracle11.2, EM, Web logic Console, Informatica, Control-M Changes, Jira,Windows NT,JD Edwards, Oracle Financial Services R12,PL/SQL, Peoplesoft HCM 9.0/8.8,MDM,OBIP
Business Model Strategy
