Business Intelligence Quality Engineering

Khaleel Ahmed

Oracle E-Business Suite (EBS) Technical Consultant Business Intelligence

U.S. Permanent Resident **********@*****.*** 408-***-****)

LinkedIn Profile

SUMMARY

Dynamic and results-oriented IT professional with extensive experience in Oracle Applications, ERP solutions, Business Intelligence (BI), Data Integration and Quality Engineering. Proficient in delivering scalable enterprise solutions spanning the full Software Development Life Cycle (SDLC), with a specialized focus on Oracle E-Business Suite (EBS) R12.2.x. Adept in database and application performance tuning, custom development, and cross-platform integrations with Salesforce and Workday. Experienced in formulating and executing comprehensive test plans, defining quality engineering processes, and delivering seamless end-to-end system integrations. Demonstrated ability to collaborate effectively with cross-functional teams and stakeholders, ensuring successful project delivery aligned with strategic business objectives.

CORE COMPETENCIES

•Oracle ERP Expertise: Oracle EBS R12.2.x, Financials, CRM, HRMS, OM, TCA, OIC

•Database Development & Performance Tuning: Oracle SQL, PL/SQL, PostgreSQL, AWR, TKPROF, Statspack, Query Optimization

•Oracle ERP Expertise: Oracle EBS R12.2.x, Financials, CRM, HRMS, OM, TCA, OIC

•Oracle EBS R12.x Order Management (OM) Module, Order to Cash (O2C) Lifecycle Management, Customization of OM Workflows

•Integration with Inventory, Shipping & Receivables, Technical Troubleshooting

•Database Development & Performance Tuning: Oracle SQL, PL/SQL, PostgreSQL, AWR, TKPROF, Statspack, Query Optimization

•Quality Engineering & Test Management: Expertise in defining and executing end-to-end test strategies including functional, regression, integration, and system testing across enterprise applications and microservices architectures.

•Quality Engineering & Test Management: Expertise in defining and executing end-to-end test strategies including functional, regression, integration, and system testing across enterprise applications and microservices architectures.

•Application Development: Oracle Forms, Oracle Reports, Workflow, XML Publisher, Oracle APEX, Shell Scripting, SOA Web Services, RICE Components, FNDLOAD and SQL Loader

•Automation & Infrastructure: Unix Shell Scripting, PowerShell, Oracle RAC, Grid Infrastructure

•Programming Languages: Python, C, C++, Java, Perl

•Documentation: MD50, MD70, Technical Design Documents, Test Plans

•Data Warehousing & Integration: Snowflake, Talend, Pentaho, Amazon ETL Manager

•Business Intelligence & Reporting: Tableau, Power BI, OBIEE, Excel (Pivot Tables, VLOOKUP)

KEY ACHIEVEMENTS

Oracle E-Business Suite (eBS) Development & Customization

•Designed, developed, and maintained RICE components (Reports, Interfaces, Conversions, Extensions) for Oracle Order Management, AR, AP, and Inventory modules.

•Customized Oracle Forms & Reports using Forms Builder & Reports Builder to meet client-specific business requirements.

•Managed end-to-end Order Management (OM) processes including order capture, pricing, scheduling, shipping, and returns, ensuring alignment with complex business requirements.

•Integrated OM seamlessly with Inventory, Shipping, and Receivables modules, as well as external systems for real-time data flow and accurate order tracking.

•Developed and maintained technical solutions using PL/SQL and interface programs to support OM-related extensions and data conversions.

•Analyzed functional requirements, mapped business processes, and provided scalable solutions for the complete Order to Cash (O2C) cycle.

•Developed and optimized Concurrent Programs using PL/SQL, Shell Scripting, and host-based solutions to automate critical business processes.

•Extended and customized Oracle Workflows for complex approval hierarchies and business event-driven processes.

•Built PL/SQL packages, procedures, and APIs to support ETL processes, data integrations, and Open Interface transactions.

•Led end-to-end Oracle EBS integrations with third-party systems (Salesforce, Workday, legacy apps) using SOA Web Services, REST APIs, UTL_FILE, and FTP.

•Participated in full Oracle implementation cycles (requirements gathering, CRP, UAT, go-live, and post-production support).

Performance Tuning & Database Optimization

Optimized complex SQL & PL/SQL queries, improving database performance by 40%+ and reducing report execution time.

Enhanced data retrieval speeds for business-critical applications by refining indexing strategies and query execution plans.

Developed automated monitoring scripts (Shell, PL/SQL) to proactively track system health and performance bottlenecks.

System Integration & Middleware Solutions

Designed and deployed SOA-based Web Services & Business Events to facilitate real-time data exchange between Oracle EBS and external platforms.

Engineered custom interfaces using PL/SQL, APIs, and scheduled jobs to ensure seamless data synchronization across hybrid environments.

Troubleshot and resolved integration failures between Oracle EBS and cloud/legacy systems, ensuring data consistency.

Testing & Quality Assurance

Spearheaded end-to-end testing (functional, regression, integration) for Oracle EBS upgrades and customizations.

Ensured data accuracy and process integrity during cross-platform integrations (EBS Salesforce Workday).

Tracked and reported defect resolution progress, test coverage, and risk mitigation strategies during project reviews.

Business Intelligence & Reporting

Developed interactive dashboards in Tableau & Power BI to visualize key business metrics for leadership.

Created Excel-based analytical models (PivotTables, VLOOKUP) for tracking project KPIs and operational trends.

Designed executive presentations (PowerPoint) with embedded charts, slicers, and Visio workflow diagrams.

Project Leadership & Support

Provided L2/L3 production support, conducted root cause analysis (RCA), and implemented permanent fixes for recurring issues.

Acted as Onsite Coordinator for global teams, ensuring alignment on deliverables, risk management, and timeline adherence.

Managed real-time project dashboards (Excel/PPT) to communicate progress, risks, and resolutions to stakeholders.

PROFESSIONAL EXPERIENCE

Visa Inc. – Senior Consultant

Foster City, CA Dec 2015 – Present

Customized solutions to troubleshoot and eliminate duplicate records for re-hired employees, improving data integrity across HR systems using PL/SQL package procedure by invoking standard APIs.

Streamlined integration between Workday and Oracle EBS HR, enhancing synchronization and reducing manual data reconciliation.

Designed and implemented an automated process to Hold and Release bundles of concurrent jobs, using PL/SQL package and Unix Shell scripting by significantly reducing downtime during weekend and server reboot cycles.

Developed a variety of ad-hoc and scheduled reports using Report Builder, XML Publisher, and SQL, for the business users by enabling better decision-making and operational visibility for stakeholders.

Engineered RESTful microservices and implemented external integration points.

Built data pipelines and reporting solutions with Tableau, Power BI, and Excel.

Automated reporting processes through Excel Macros, reducing manual intervention.

Supported Apps DBA activities including patching, cloning, and system performance tuning using AWR and Statspack.

Ultimo Software Solutions Inc. – Senior Consultant

San Jose, CA Jan 2014 – Dec 2015

Customized Oracle Applications and developed RICE components.

Facilitated global delivery by coordinating with distributed teams.

Projects:

oMotorola Mobility: Migrated and integrated Oracle EBS infrastructure.

oComplete Genomics: Built ETL jobs and Tableau dashboards.

oVMware: Administered WebLogic Server and created SOA composites.

Propelsys Technologies LLC – Programmer Analyst

Feb 2009 – Dec 2013

Delivered ERP implementations, custom developments, and BI solutions.

Key Projects:

oAmazon Lab126: Developed ETL pipelines with Pentaho/Talend, OBIEE dashboards, and dimensional models.

oVMware RevStreams: Implemented custom ERP interfaces for revenue recognition.

oCalix: Integrated Salesforce with Oracle RMA; implemented inbound/outbound EDI (810/850/855/856).

oNetApp Everest: Built and exposed PL/SQL packages as web services using ISG; supported Oracle-SFDC data synchronization.

oSymantec: Led offshore coordination, worked on Customer Data Hub (CDH), TCA integrations, and documented functional requirements (MD50).

Wipro Technologies Ltd. – Systems Manager/Consultant

Bangalore, India & Mountain View, CA Dec 2000 – Feb 2009

Delivered end-to-end technical solutions for Oracle EBS across clients like Cisco Systems, NSTAR Electric, Emerson Motors, and General Motors.

Key Projects:

oCisco Systems – Oracle Incentive Compensation (R12): Developed custom workflows for rate approval and calendar-aware notifications using Oracle Time & Labor. Built data conversions using PL/SQL and shell scripts; migrated RDF reports to XML Publisher.

oNSTAR Electric – Oracle CRM Call Center Implementation: Developed Daily Update interfaces for data sync with Mainframe; implemented complex APIs, developed custom screens, and automated data workflows through shell scripting and CRON jobs.

oEmerson Motors – Oracle Apps Support: Delivered custom reports (Order Status, Backlog, Sales Commissions), applied patches, and led production support including forms/reports tuning and FAX integration for Order Workflow.

oGeneral Motors – GPIM: Migrated multi-source data (SQL Server, Mainframe) to Oracle; built 90+ reports and automated batch processing through shell scripts.

EDUCATION

Master of Computer Applications (MCA) – Nagarjuna University, Andhra Pradesh, India

Bachelor of Science (B.Sc.) – S.R.R. & C.V.R. Government College, Andhra Pradesh, India

Contact this candidate