Aditi Kapoor

Sr. Engineer IT Architect Email: ad2unn@r.postjobfree.com

Phone: 678-***-****

Professional Summary:

Enterprise Architect responsible for designing and implementing third party interfaces with Oracle EBusiness Suite adopting latest and best coding standards, adhering to IT Risk and Security standards and ensuring optimal performance. The role requires interacting with customers and developers coordinating the requirements and design implementations and delivery efficiently and with rigor.

Support, research and evaluation of emerging data technology, industry, and market trends to assist in integration development with Oracle EBS like REST webservices using ISG (Integrated SOA Gateway)

Organize demands and requests from business and technical partners.

Coordinate architecture efforts across multiple pillar app teams interfacing or leveraging the ERP’s data

Lead reusable solutions that can be shared/utilized across the businesses utilizing our ERPs.

Also act as operations lead ensuring that EBS is running at its best performance all the time. Monitor and report any hot spots proactively and perform iterative performance tuning exercises on the highly customized global single instance of Oracle EBS. Provide proactive tuning recommendations of both live production database using v$views and reviewing awr reports for performance incidents occurred in past, provide sql tuning recommendations after reading tkprof, sql monitor report.

Exploring solutions to integrate Oracle’s MSCA or Oracle Mobile App with secured internal networks to Oracle ERP.

Comprehensive knowledge about different interfaces, integration options from external sources to and from Oracle ERP.

Strong collaboration, team building, interpersonal and communication skills with proficiency at grasping new technical concepts quickly & utilizing the same in a productive manner. Motivate team for a collaborative environment.

Ability to deal with complex issues, problems, and resolve quickly whether to fix a production problem or implementation of a new solution.

Technical Skills:

BI Applications & ERP

OBIEE 11g, Qlikview, Oracle EBS R12.2.10 Oracle DB 19c

Engineering systems

Exadata.

Database

Oracle 11g, Oracle 10g, Oracle 12c

Operating System

HP-UX, RHEL Linux, Oracle Enterprise Linux, Windows Server 2003, 2008.

Performance Monitoring tools

AWR, Tkprof, sqlt, HP LoadRunner 9.5, Jmeter OEM, vmstat,netstat,iostat, Oswatcher,sqlt, Oracle’s Application Testing Suite.

Programming

SQL, PL/SQL, UNIX Shell Scripting,

Tools

Toad, SQL Loader, Oracle Developer 2000, OEM, SQL Tuning Advisor.

Professional Experience:

Employer: Wabtec Inc. Dec 2014 –Till date

Project : Integrating external applications with Oracle EBS.

Role: Architect the integrations based on technology, data and real time vs batch mode sync.

Design and Deliver integrations between HICX (Global Vendor management platform) and Oracle to send Supplier, Supplier sites, Contacts and Bank account.

Design and deliver integrations between Coupa (Platform for Sourcing and expense management) and Oracle ERP based on REST Webservices for creating and updating Purchase Orders, creating, and updating receipts into Oracle.

Explore Integrated SOA Gateway and come up with Order Management Webservices model which marketplace applications could consume to find out about Products, their availability, prices and ultimately submit an order.

Design and deliver Inventory REST webservices giving information about on hand availability of an item by sub inventory, locator and org etc.

Design and Deliver material pick webservices from eServices to Oracle ERP along with printing RTN’s and PTN’s.

Communicate with several cross functional teams interpreting their business requirements into Functional and Technical Specification.

Drive the development process, ensure global standards are met, participate in UAT’s.

Track defects, resolve them for the business users and document each.

Project : Lead Oracle SOA Suite upgrade from 11g to 12c for 8 different integrations.

Role : Techno Functional Integration architect.

Gather list of integrations using Oracle SOA Suite 11g specific to GE transportation. Plan timelines and coordinate with various external partners, SOA DevOps team, SOA Admin teams to come together and perform SIT’s and UATs while we upgrade from 11g to 12c.

Log issues, solve problems, communicate stakeholders, manage costings for support.

Project : Lead migrations for all sftp connections to Globalscape

Role : Integrations Architect.

Globalscape is a managed file transfer software with features like bi directional, secured file transfers based on said frequency, archiving and error handling policies built in. Using the same managed to migrate 20 odd independent sftp integrations over to globalscape successfully.

Required coordination with multiple stake holders, showcased problem solving skills and honed functional knowledge of these integrations.

Project: Proof of concept exploring Integrated SOA Gateway

Explore Integrated SOA Gateway and develop a proof of concept to enable it in Transportation’s ERP instance.

Present on its usage, benefits and possible practical business use cases.

Document and plan what it takes to enable ISG on R12.2.5.

Showcase and present how to convert a custom and a standard API into a REST webservice and

and the technical and cost benefits of doing so.

Project: Explore Mobility solutions for Oracle MSCA

Role: Explore and work upon POC of Mobile apps that could be used to perform warehouse management tasks and help in increasing the operational efficiency.

Get involved and understand the technical architecture of the third party app and how it will interface with ERP.

Apply necessary application patches to enable the EBS mobile Apps using adpatch utility.

Explore MWA architecture and also explore in parallel possibilities for offline capability where transactions could be made even when there is no network available.

Collaborate with SOA team for OSB access and development

Explore Oracles Integrated SOA Gateway for exposing Standard API’s into REST web services and make them available to be consumed in the mobile app.

Understand the technical aspects of how the data will flow both ways from ERP to App and App to ERP in both Online and Offline mode.

Drive implementation, SIT, UAT

Perform Performance test.

Project: Oracle EBS R12.2.5 implementation:

Role: Oracle Apps DBA

R12.2 Implementation and Support.

Successfully installed and configured oracle applications R12.2.5 on exalogic and Exadata systems.

Extensively worked on latest Online patching tools of Oracle applications (adop) and cloned multiple instances of oracle applications R12.2.5 using adcfgclone.

Worked as Single point of contact from offshore in the ERP re-implementation project and collaborated with different global teams.

Involved in the Oracle ERP and Planning applications re-implementation project.

Working experience on MWA & MFS applications in integrated Ebiz environments.

Get involved in Troubleshooting, patching and other issues.

Concurrent Manager Issues.

Installed Databases through EM and Validated Databases. Raise service now tickets to support OEM Issues and Creating case/Incidents and CR’s for Sysadmin issues and Technical issues.

Project: R12 Performance Testing and support

Role: Perform Performance/Regression test prior to major application upgrade from R11 to R12 and R12.2.3 to R12.2.5 with Endeca plug ins for E Business Suite. Provide Performance Support post R12 upgrade.

Supervised requirement gathering, Prominent Test cases, Test set up using Load runner controller.

Designed a strategy for monitoring mission & business critical databases across enterprise and implemented it without flaws.

Monitoring of performance tests. Analysis of AWR. Top SQL analysis.

Assured optimal performance of programs post R12 upgrade.

Monitoring of Concurrent Manager Performance and ensuring optimal performance.

Ensured performance issues by monitoring and review of application logs, trace files, alert logs, and concurrent logs, reports involving CPU, I/O Activity, and memory utilization.

Project: Proactive Performance tuning

Role: Monitor and tune the top concurrent programs that current consume most of the DB time.

Created, modified, and executed SQL statements daily for data retrieval and development in Oracle relational databases to gather data pertaining to worst performing concurrent programs, top worst performing sqls on db by physical/logical reads.

Create Performance Dashboard giving information about the performance of various concurrent programs and their history using qlikview. Implemented standardized performance metrics, enhancements, and changes to key performance indicators.

Drive Process change to integrate the code review for performance for top high-risk customizations even before they go into production.

Project: AutoKill Utility

Role: Develop a mechanism to stop running unoptimized code on production environment.

Understand the different users and their roles.

Define various monitoring parameters, analyse the patterns in the query usage.

Design a utility that would probe and audit the sessions

Developed the utility to kill the sessions automatically if they try to run unoptimized code. Used PL/SQL to develop them.

Analyze the audited sessions, Look for definitive patterns, log bugs against each.

Contact this candidate