SUMMARY

• Oracle Business Intelligence and Weblogic Lead with 12+ years of experience in ERP, BI and Data Warehousing projects with OBIEE, Informatica, ODI and Golden Gate replication.
• Specialized at change management and business processes from ITIL methodology to Agile collaboration.
• Skilled in the complete life - cycle of a release from requirements gathering to implementation and post production.
• Excellent communication and collaboration skills interfacing with multiple stakeholders and bringing the release to completion.

TECHNICAL SKILLS

Languages: PL/SQL, Unix Shell Scripting

Tools: ETLs using Informatica and ODI, EM and other monitoring tools.

OS: Oracle Linux, RedHat, Windows.

Database: Oracle RAC DB 12c, 11g.

Functional: Oracle and Siebel CRM, Financials and HRMS.

Trainings: Oracle Cloud SaaS, IaaS, PaaS, Weblogic 12c and 11g Administration Essentials

PROFESSIONAL EXPERIENCE

Confidential

Principal IT Consultant

Core Technologies: Oracle Business Intelligence(OBIEE) 12.2.2.1, Informatica 9.6.1, Oracle RAC DB 12c, ODI, Golden Gate

Responsibilities:

• Production Engineering BI Lead and Change/Release Coordinator MyOracle Support Analytics is a strategic Data Warehouse that enables the business to understand and analyze the CRM implementation at Oracle. This DW is used as a reporting tool for Senior Management to review metrics for CRM performance and is critical to the operations of the organization. I am responsible for managing the BI team in the administration of the suite of applications and ETLs and interfacing the support of these applications with the business users.
• Winner of the Production Engineering team: "Way to go" award for outstanding performance with BI projects delivery
• Always striving for customer satisfaction is the go-to person for all user issues and requests. Responsible for managing communication and requirements with internal business user group.
• Responsible for Installation, Administration, release and production support for the BI Applications, databases and several other Weblogic based fmw apps.
• Demonstrated technical expertise during numerous critical production and P1 issues and upgrades
• Quick learner, always willing to investigate and work on latest technologies and demonstrating expertise in Analytics.
• Excellent communication skills collaborating with several teams bringing new releases to completion
• Team leadership skills, trained the offshore teams regularly and managed work distribution between offshore and HQ.
• Techno-functional profile with strong business skills, gap analysis, business requirements definition, functional design & test plan development
• Responsible for Release management, change management and led Release Readiness Review meetings for the team.
• Collaborated with the business and developers to help create the data model and functional design documents.
• Responsible for Performance Tuning after the 11g and 12c upgrades for OBIEE.
• Responsible for bug tracking and bug fixes, assigning and assisting offshore teams with bug resolution.
• Successfully implemented several enhancement projects to the BI application.
• Conducted weekly meetings as well as additional ones for projects to keep all stakeholders informed, and keep up with production status.
• Supported UAT, staging, PSR(Performance/Scalability/Reliability) testing and environments.
• Was responsible for Data Migrations, Operational Data Store, OBIEE 12c and 11 g upgrades, Exalytics HA Clustering project,
• A meticulous planner, always organized and dedicated to completing assigned tasks
• Earned Customer appreciation for excellent response times to all issues and regular status updates.
• Automation and scripting of code deployments
• Scripting of backups, system maintenance and other repetitive tasks.
• Improved efficiencies for the MOS Organization by optimizing monitoring, reducing emails, improving shift handover, CAB and change control processes
• Responsible for application monitoring using EMCC for BI and Weblogic apps, Setup Metric extensions to monitor non standard metrics.
• Responsible for all support documentation, KM documents for Standard Operating Procedures.

Confidential

IT Application Operations Analyst

Core Technologies: (PeopleSoft Financials 8.8, Database- IBM DB2 UDB 8.2, Ariba Buyer 8.2, Siebel eBiz 7.7, PeopleSoft HRMS)

Responsibilities:

• Managed and administered multiple applications, environments and complex interfaces between them, the primary one being PeopleSoft Financials 8.8.
• Responsible for complex tier-two support for PeopleSoft issues, especially supporting the month-end and quarter-close financial activity. Also, responsible for assisting business units close their books worldwide.
• Organizing and structuring the BackOffice operations by defining and documenting policies and Standard Operating Procedures (SOPs). Developing best practices for business users and resolution documents for the BO team.
• A contributor to the PeopleSoft Financials 8.8 upgrade, re-designing old customizations to the new system..
• Was granted the Siebel IT release award for March 2005 for outstanding contributions to the Hummingbird DM upgrade project. Coordinating proactively and effectively managing resources, scope and timelines, executed effectively, managing multiple parallel tasks and completing all deliverables in line with standard IT processes.
• Planned and managed end-to-end release processes, analyzed, reported on release and operational metrics to management.
• Sarbanes Oxley Compliance: Managed, coordinated and spearheaded the SOX compliance project and IT audit for 2005. Interfacing with Internal and External auditors (Protiviti and KPMG), and leading the audit from IT, organized quarterly self audits and was the central point of communication on the audit process.

Confidential

Technical Specialist- Programmer Analyst

Core Technology: (PeopleSoft 8.4, Database- IBM DB2 UDB 7.2)

Responsibilities:

• Involved in design, development and testing phases of project lifecycle of Electronic-Invoicing project at Honda. This project accomplished sending Purchasing data to external system and accepting invoices electronically to create vouchers in PeopleSoft.
• As a technical specialist in PeopleSoft took ownership of purchasing module, executing all design, development and maintenance for this core module and its integration with AP, Vendors and ARIBA
• Successfully executed expansion of core functionalities like PO Close, PO Dispatch, designed and created new customizations like Savings module to track the savings achieved by each buyer on Purchase Orders, Buyer Workload tracking etc.
• Setup and managed Workflow routings and authority for PO Approvals.
• Analyzed and Implemented PeopleSoft bundles testing, including upgrades and QA efforts.
• Contributed to corporate wide system change/optimizations, design discussions and reviews.
• Had 100% record for timely resolution of field issues, several of which involved working with other teams/departments to bring about successful closure of open issues.
• Actively participated in requirements gathering and design of enhancements to the modules with Business Users.
• Achieved business users’ satisfaction and confidence through Dynamic and efficient management of the module.

Confidential

Programmer Analyst

Core Technology: (PeopleSoft 8.4, Database- Oracle 8i)

Responsibilities:

• Scrutinized Requirements Specifications and held design/brainstorming sessions with end users to conceptualize conversion of the entire system to PeopleSoft.
• Aggressively pursued objectives to beat deadlines by more than 20%, while completing data mapping including the challenging task of reverse engineering from the mainframe financial programs to provide a clean set of business rules in PeopleSoft environment
• Maximized efficiency and effectiveness by rebuilding and tuning business processes.
• Evaluated, Analyzed and completed high-level and detailed design of major modules.
• Successfully implemented the interfaces between PeopleSoft GL and external systems that transferred accounting transaction data in the form of flat files from all over the world.
• Administered the PeopleSoft and Database installation. Also was responsible for their maintenance.
• Redesigned mainframe logic/implementation while taking it over to PeopleSoft, in the process improving performance by about 300%.
• Planned expansion of development team. Trained and supported the development team and User group.

Confidential

Programmer Analyst

Core Technology: (PeopleSoft 8, Database- Oracle 8i)

Responsibilities:

• Accomplished continuous support to PeopleSoft Purchasing and Accounts Payables system for Confidential .
• Was responsible for daily batch jobs and cycles, production issues and custom enhancements.
• Handled the role of DBA for multiple PeopleSoft databases. Created, installed and configured various development and test instances of PeopleSoft for different teams. Handled PeopleSoft security and administration at various levels.
• Successfully administered database tuning and monitoring for optimization and efficiency.
• Created and implemented interfaces to integrate PeopleSoft with external systems using online PeopleCode and component interface technology.
• Wrote Unix scripts to support batch jobs and system security.
• Trained, mentored and prepared other team members to various tasks from database tuning, efficiency and server administration to PeopleSoft PO and AP modules.

Confidential

Software Engineer

Core Technology: (PeopleSoft 8.4, Database- Oracle 8i/MS SQL Server)

Responsibilities:

• Core team member for customer specific customizations to PeopleSoft. This involved studying customizations done in the Vantive product, WWCCS (World Wide Customer Care System) and applying these to PeopleSoft as applicable.
• Participated in “fit gap” analysis, field mapping, data migration plans which were prepared as precursor to migration.
• Completed data mapping and reverse engineering from Vantive to PeopleSoft achieving clear business rules and specifications, which were appreciated by the client.
• Developed the interfaces and online edits using IScripts, WebLibraries, Business Interlinks, Component Interfaces and PeopleCode/PeopleTools 8.4. This involved self study and research into the subject matter using various sources.
• Accomplished QA guidelines- The nature of the project required an Incident Root Cause Analysis after each phase to mitigate the risks involved and documentation of the same for all stages of the project.
• Responsible for Database and PeopleSoft installation, configuration and administration.