Business Analyst Software Development

PROFESSIONAL SUMMARY:

**+ Years of IT industry experience focused on Oil/Gas Industries, PEO industries applications, starting from the Analysis, design and Implementation of Business application and Custom processes.

Expertise software development professional in software design, development and integration projects and ready to take challenging opportunities during implementation.

Have deep expertise and relevant qualifications to provide the best abilities.

Have extensive level of competency in aspects of Oracle 12c/11g/10g/9i/8i, PLSQL, SQL*Plus, TOAD, SQL Developer and SQL *LOADER, Reports 10g, Forms10g, APEX

Experience in ERP System as Business Analyst, Team Lead, Techno Functional Consultant

Hands on experience in Oracle EBS Financials AR, AP, GL PA, FA, PO, INV (Financials, Purchase Order, Core HR, Enterprise Asset Management, Inventory and Fixed Assets) and others, ensuring comprehensive understanding of end-to-end business processes.

Designed and developed robust ETL processes to integrate data from multiple sources into the Autonomous Data Warehouse (ADW), ensuring data consistency and accuracy.

Automated ETL workflows using Oracle Data Integrator (ODI) and other tools, reducing manual intervention by 60%.

Extensive proficiency in Oracle EBS RICEFW development, encompassing Reports, Interfaces, Conversions, Extensions, Forms, and Workflows, XML/BI Publisher reports (BIP), Discoverer reports.

Expertise in implementation, Rollouts, Migration, Production Support, customization, consolidation, integration and upgrading various business applications using Oracle Applications 11i and R12 (12.2.2, 12.2.11).

Expertise in developing and managing Oracle forms, OAF pages, forms customization & personalization, Oracle reports, BI/XML Publisher reports, PL/SQL and shell scripting.

Expertise in the development and customization of Forms, Reports, Oracle APEX (18.1, 19.1, 20.1) applications.

Hands-on experience with migration projects like migrating the Oracle Forms & Reports from lower version to higher version, also expertise in migrating the Oracle forms to Oracle APEX applications.

Experience in REST Web Services, APEX report queries & report layout. Good knowledge in front end development using APEX.

Highly skilled in Service-Oriented Architecture (SOA), BPEL and proficient in designing and implementing Application Programming Interfaces (APIs) to facilitate seamless system interactions.

Expertise using the File adapters, Database adapters, JMS, Queue adapters to integrate with external systems.

Worked on all Oracle eBusiness components like SQL, PL/SQL & XML, Oracle Forms and Reports, BI Publisher, Oracle Workflow Builder, developing shell scripts, Oracle Apex, and Oracle Database 12C.

Hands-on experience in diverse programming languages such as Java/J2EE, REST API, SOAP, etc., enabling effective integration and development across multiple platforms.

Developed custom scripts and extensions to enhance OAC functionalities and meet specific business needs.

Customized OAC’s analytics and visualization components to align with organizational standards and user preferences.

Administrative knowledge of source control tools, Build and Release management process like SVN, HP PPM, Oracle ACE

Good Project Management skills managing multiple projects.

Strong technical, analytical, problem solving, decision making, communication and organization skills.

Team player and goal oriented, with a commitment towards excellence.

Self-motivated and avid learner in emerging technologies.

Have excellent communication, interpersonal and leadership skills along with very good understanding and experience working in a highly qualified environment.

TECHNICAL SKILLS:

Database

Oracle (10g/11g/12c), Microsoft SQL Server 2012

Database Tools

SQL Developer, TOAD, SQL Management Studio

Report Utilities

Oracle Reports 6i/10g, XML/BI Publisher Reports (BIP), SQL Server Reporting Services (SSRS)

Languages

SQL, PL/SQL, Unix Shell Script, XML, JSON

Applications

MS Office (Word/ Excel/ PowerPoint/ Access)

ERP

Oracle Applications EBS R12.2.2, 12.2.11

Data Warehouse Tools

Autonomous Data Warehouse (ADW), Oracle Data Integrator (ODI) Informatica, SQL Server Integration Services (SSIS)

Middleware

OracleSOA suite 11g/12c, Oracle Integration Cloud (OIC), Oracle Analytics cloud (OAC)

PROFESSIONAL EXPERIENCE:

Client Name

Employer Flexible

09/2019 – 02/2024

Role

Sr.Oracle EBS Technical Consultant

Environment

Oracle SQL, PL/SQL, Forms/Reports 10g, XML/BI Publisher (BIP),

Oracle EBS 12.2.11, Oracle SOA 12c, APEX, ODI

Developed integration process to connect to other application with the Organization native application to extract data.

Developed and implemented complex PL/SQL stored procedures to automate critical business processes, such as invoice processing, order fulfillment, and inventory management, resulting in a 50% reduction in processing time.

Designed and enforced data integrity rules by creating and managing constraints within the Oracle database, ensuring accurate and consistent data across all modules.

Utilized cursors extensively for iterative processing of data sets within PL/SQL procedures, enhancing data manipulation capabilities and streamlining batch processing tasks.

As part of the application enhancements/ Production support prepared the SQL Scripts (DDL, DML, DQL,) hands on experience preparing the complex SQL queries.

Collaborated with cross-functional teams to integrate third-party applications with Oracle EBS using APIs, ensuring seamless data flow and system interoperability.

Experience in extending EBS functionality through custom reports, interfaces, conversions, and extensions (RICE components).

Handled the Benefit enrollment Oracle APEX application issues with off cycle renewal Clients on their FSA, HSA, Health Dental, Elections process while the internal team face the issues during their Benefit Enrollment process.

Prepared the SQL queries/ Reports to send the Employee Enrollment data to the external carriers (BCBS, MetLife, United Health Care) Carries via EDI process

Build/updated custom applications using APEX, PL/SQL packages and triggers to accommodate the business requirements.

Designed and developed data integration solutions using Oracle Data Integrator (ODI), ensuring seamless data flow across diverse systems.

Created and maintained complex ODI mappings, procedures, and packages to transform and load data efficiently.

Implemented data quality checks and validation routines within ODI to ensure accuracy and consistency of data.

Established data governance policies and procedures to maintain data integrity and compliance with industry standards.

Integrated data from various sources such as databases, flat files, and cloud platforms into ODI, ensuring comprehensive data coverage.

Configured and managed connections to heterogeneous data sources, including Oracle, SQL Server, MySQL, and NoSQL databases.

Successfully integrated DevOps practices into multiple projects, improving deployment efficiency and reducing downtime.

Worked closely with business analysts, solution architects, and stakeholders to define integration requirements, data mappings, message formats, and service contracts for seamless interoperability between systems.

Act as an Onsite Technical lead to under the Business requirements/ existing issues/ understanding the problems and worked with offshore team of 10 members with all assigned tasks.

Client Name

Noble Energy

07/2016 – 09/2019

Role

Oracle EBS Technical Lead

Environment

Oracle SQL, PL/SQL, Forms/Reports 10g, XML/BI Publisher,

Oracle EBS 12.2.3, Oracle SOA 11g,ADW, OAC

This projects deals with the Oil & Gas data using Oracle ERP system, worked on different modules in this industry like Oracle Financial, Projects (Account Payables, Account Receivables, General Ledger, Purchase Order, Core HR, Enterprise Asset Management, Inventory and Fixed Assets)

Manage project execution throughout the project lifecycle processes including preparation of appropriate execution plan that will ensure successful project delivery.

Understanding and implementing business requirements, analysis, design, development and implementation into the system.

Spearheaded the implementation and deployment of Oracle Autonomous Data Warehouse (ADW), ensuring seamless integration with existing data infrastructure.

Managed end-to-end deployment processes including data migration, schema design, and system configuration.

Developed advanced analytics solutions leveraging ADW's built-in analytics capabilities, providing actionable insights for business decision-making.

Created comprehensive dashboards and reports using Oracle Analytics Cloud integrated with ADW.

Develop and customize forms & reports in EU production, Revenue, DOI, JVA modules and other oracle standard modules such as HRMS, AP, AR, GL, PA, FA, PO, INV and iSupplier etc.

Created Oracle forms, OAF, forms customization & personalization, BI publisher, Oracle 10g reports, PL/SQL functions, stored procedures, cursors, packages, triggers and performed query tuning.

Involved in optimizing the Performance of Database Objects.

Played Key lead role on BIP & Discoverer reports implementation project with the team of 5members.

Involved in the development of the technical design documents. Prepared technical documents.

Development of New SOA composites according to client requirement documents and Enhancements to the existing SOA composites. Migrated around 12 SOA composites from SOA 10g to SOA 11g.

Worked on around 12 SOA processes which includes calling Oracle Stored procedures, File data extraction, Validations and Integration with multiple systems.

Designed and implemented over 10 integration solutions using Oracle Integration Cloud, streamlining data flow between on-premises and cloud applications.

Automated business processes, reducing manual intervention by 50% and increasing operational efficiency.

Designed and developed interactive dashboards and reports using Oracle Analytics Cloud (OAC) to provide real-time insights for business decision-making.

Leveraged OAC's data visualization tools to create compelling visual representations of complex data sets.

Built and maintained robust data models within OAC, ensuring efficient data flow and accurate reporting.

Prepared and transformed data using OAC’s data preparation features to enhance data quality and consistency.

Integrated OAC with various data sources such as Oracle databases, cloud services, and third-party applications to ensure comprehensive data coverage.

Configured data connections and automated data refresh schedules to keep analytics up-to-date.

Report to the Project Manager, assume responsibility for providing leadership and direction for the delivery of project.

Act as the point of contact between the Business analysts and development team to construct the activities.

Client Name

BHP Billiton Ltd.

05/2012 – 07/2016

Role

Oracle EBS Technical Lead

Environment

Oracle SQL, PL/SQL, Forms/Reports 10g, XML/BI Publisher, Oracle EBS 12.2

This projects deals with the Oil & Gas data using Oracle ERP system, worked on different modules in this industry like Oracle Financial, Projects (Account Payables, Account Receivables, General Ledger, Purchase Order, Core HR, Enterprise Asset Management, Inventory and Fixed Assets)

Manage project execution throughout the project lifecycle processes including preparation of appropriate execution plan that will ensure successful project delivery.

Understanding and implementing business requirements, analysis, design, development and implementation into the system.

Designed, developed, and optimized complex SQL report queries, stored procedures, functions, triggers, and packages to support business logic and data manipulation requirements.

Implemented performance tuning techniques such as indexing, query optimization, and execution plan analysis to enhance database performance and scalability.

Utilized advanced SQL, PL/SQL features and constructs such as cursor variables, collections (nested tables, associative arrays), bulk processing (FORALL, BULK COLLECT), dynamic SQL, and exception handling to achieve efficient and maintainable code.

Expertise in using the PL/SQL collections variables when passing the bulk data to the external application.

Integrated PL/SQL code with Oracle database objects (tables, views, sequences, indexes) and external systems through database links, Oracle Gateway, and web services, ensuring seamless data integration and interoperability.

Implemented error handling and logging mechanisms using PL/SQL exception handling, logging frameworks (e.g., DBMS_OUTPUT, UTL_FILE, Logger), and custom error handling routines to capture, report, and troubleshoot runtime errors effectively.

Collaborated with database administrators (DBAs) to design and implement data models, database schemas, data migration scripts, and database maintenance tasks using PL/SQL scripting and automation tools (e.g., SQL Developer).

Integrated Oracle Forms applications with backend Oracle databases, leveraging SQL and PL/SQL to perform data manipulation, transaction processing, and business logic execution within forms.

Enhanced performance and scalability of Oracle Reports applications through optimization techniques such as query tuning, indexing, caching, and server-side processing optimizations.

Mentored and trained junior developers or team members on advanced concepts, coding standards, performance optimization techniques, and best practices to foster knowledge sharing and skills development within the team.

Client Name

Petrohawk Energy Corporation

10/2011 – 05/2012

Role

Oracle Reports Developer

Environment

Oracle SQL, PL/SQL 10g, Forms, Reports10g, SQL * Loader, Hyperion Interactive Studio

Designed the reports using Oracle Reports Builder 10g & BI Publisher

Registered the developed reports into Oracle Applications

Worked on reports performance tuning using plan execution.

Created MD.050, MD.070 Report Functional and Technical Design Documents

Also worked on the new reports/dashboard development using Hyperion Interactive Studio.

Created the Report Data models based on the report requirements.

Involved in the analysis of the existing data of the business and prepared the report field mappings.

Analysed mapping documents provided by functional consultants

Created Tables, Synonyms, Sequences and Views, Functions and Packages

Created stored procedures to perform the initial level of validating and transforming data

Loaded data from source systems to staging tables using oracle utilities

Analyzed query execution plans, identified performance bottlenecks, and evaluated resource utilization metrics to pinpoint areas for improvement.

Worked on the conversion of the legacy report queries into Oracle Reports, with enhanced report layout and metrics.

Implemented proactive monitoring and maintenance routines, resulting in increased system stability and reduced incidents of performance degradation.

Client Name

ADCO (Abu Dhabi Company for Onshore Oil Operations)

03/2011 – 10/2011

Role

Oracle EBS Developer

Environment

Oracle SQL, SQL* Loader, PL/SQL, Forms/Reports 10g, Oracle EBS 11.5.10.2

Migrated data from Legacy systems to ERP Oracle Database.

Loaded data from source systems to staging tables using oracle utilities

Coded complex logics using as per the transformation logic rules

Implemented PL/SQL procedures, packages for the interfaces between modules

Involved in developing, modification, maintenance and implementing forms & Reports.

Migration of the Oracle Reports from 6i to 10g.

Facilitated modification and enhancement of Oracle Stored Procedures and Packages

Converted data from one format to another and Data Migration from Legacy systems to Oracle

EDUCATION

Bachelor of Technology in Electronics & Communication Engineering (ECE)

Contact this candidate