SUMMARY

• Around 9 years of combined IT technical proficiency and functional experience in Oracle ERP, E - Business Suite & Oracle Database with hands-on expertise in comprehensive Data Integration, Data Analysis, Application Design, Development and end-to-end Implementation of business applications for Data Analytics & Marketing, Pharmaceuticals, Hospitality, E -commerce & Distribution clients
• Strong Functional knowledge of the Oracle e-Business Suite (EBS) Financial & SCM modules like Accounts Receivable (AR), Accounts Payables (AP), General Ledger (GL), Inventory (INV), Purchasing (PO), Order Management (OM), Manufacturing & customized modules.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support and experience in both the Waterfall and Agile scrum project implementation methodology.
• Hands on experience in admin and user configuration of the EBS applications.
• Extensive experience in Oracle database development and creating Stored Procedures, PL/SQL Packages, Triggers and Functions.
• Strong knowledge in Oracle cursor management, analytical functions and exception handling.
• Extensive development experience in Extract-Transformation & Loading (ETL) of data from multiple sources such as Oracle, SAP, Flat Files, CSV files into GSA (Global Staging Area) & EDM (Enterprise Data Mart) systems for reporting & analysis.
• Strong expertise in using Oracle Forms & Reports Developer Suite 11g for the development and deployment of Oracle forms and reports components.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *Plus, Toad, SQL*Loader & UNIX shell scripting for high volume data warehousing instances.
• Expertise in real-time production job monitoring using Autosys, debugging failed jobs and Production support using Service Now
• Hands on experience in designing, developing & customizing Oracle Applications Forms & Reports using Oracle Forms & Reports Builder 10g & 11g.
• Experience with Data dictionary, Database normalization theory techniques, Performance tuning and Entity Relation design techniques.
• Conducted requirement-gathering analysis, documentation with help of Application Implementation Methodology (AIM).
• Experience in advanced PL/SQL concepts like Bulk Collect and For All.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views and Database links.
• Enforced data integrity using integrity constraints and database triggers.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and TKProf.
• In-depth knowledge of the Cost-based and Rule-based query optimization techniques.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT) and System Integration Testing.
• Hands-on experience in creating project plan using Microsoft Project.
• Excellent in team collaboration, quick adaptation and problem solving with good communication skills.
• Interaction with the offshore development team for development of reports and changes needed in the requirements.

TECHNICAL SKILLS

Databases: Oracle10g/11g/12c/18c

Languages: SQL, PL/SQL, UNIX

Database Tools: SQL Developer, SQL*Loader, SQL*Plus, Toad

Oracle Development: Oracle Forms and Reports 10g/11g

ERP: Oracle e-Business Suite (EBS) 11i/R12

Job Scheduling: Autosys

Service Management Tools: Service Now, Service Manager.

Project Management Tools: MS Project, MS Office Suite, Share Point, Jira

Testing Tools: HP Quality Center

Source Code/Version Tool: MKS Integrity, GIT, Bitbucket

SFTP Tools: Putty, WinSCP

PROFESSIONAL EXPERIENCE

Confidential, Downers Grove, IL

Sr. Oracle Developer/Consultant

Responsibilities:

• Worked as a Senior Oracle Solutions Developer for Altria’s Phase 2 & Phase 3 changes.
• Involved in the Phase 3 Data Model & Planning sessions and roadmap discussions.
• Defined and discussed application and backend requirements by consulting with clients and the system architects.
• Developed complex PL/SQL packages and procedures for the different user stories and performed end-to-end unit testing.
• Performed code review and walkthrough with the system architects to ensure that the development meets the account specific development framework and is in line with the business requirements.
• Performed system testing results review to ensure that all the functionalities covered in the requirements are tested and the positive and negative scenarios are covered.
• Assisted in the UAT and post-implementation troubleshooting of the new application components and releases.
• Created new jobs in the Acxiom job scheduling application ‘Fuse’ for the user stories.
• Worked with the project-tracking tool Jira to update and document the assigned stories and progress it through the SDLC pipeline.
• Worked with the code management tool GIT/Bitbucket to check-in the database code and make sure the release/master branch is up-to-date.
• Extensively worked on Agile methodology and attended standup meetings.
• Prepared the release plan and the deployment components spreadsheets to help in the seamless production implementation.
• Managed the release documents in SharePoint, in support of the internal and external audits.

Confidential, Chicago, IL

Sr. Oracle Developer/Support Analyst

Responsibilities:

• Serve as the Subject Matter Expert for the applications & the data mart.
• Currently serving as the senior onsite developer and liaison between the business team and the offshore resources for major and minor enhancements.
• Have regular meetings with the business to understand & analyze the requirements for the enhancement projects.
• Provide estimates & perform impact analysis for enhancements in Compass & LSI Action ERM applications.
• Responsible for creating the capital projects user/functional requirements, estimation, data mapping & integration documents along with the high level and low-level technical design documents.
• Performed the organization setup and admin configuration setup for the financial & SCM modules.
• Involved in complex development and testing of the balance sheet hierarchy in Compass Oracle database.
• Involved in the requirements discussion with business and analysis of the Capital projects.
• Involved with study of existing system, preparing the BRD100/ Functional (MD50), Technical (MD70) design document and Conversion Data Mapping Document (CV40).
• Performed Impact analysis & part of the core team for the modernization of the Compass application.
• Analyzed and created new models and mappings for the data loading process into the GSA (Global Staging Area), from sources like flat files, SAP extract file etc.
• Did reverse engineering for the data sources and targets.
• Work closely with the Project Manager and Data Architect.
• Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Worked with business to develop views for the OLAP data processing and interface to the TM1 downstream applications.
• Working on multiple development projects including creating a weekly financial report for the Finance department, updating & cleaning up the existing financial hierarchy data, among others.
• Developed interfaces to load the data from flat files, SAP to staging area and from staging area to Compass.
• Implemented logic to archive the source files with date stamp affixed after the successful load.
• Perform unit and integration testing. Created various test scenarios to test the application.
• Involved in the analysis and enhancements in the EBS applications (Compass, LSI, Action ERM) using Oracle Forms and reports developer.
• Defined the lookup relationship and master-detail relationship on the objects that helps in associating the record and defining a parent-child relationship in which the master object controls certain behaviors of the detail object respectively.
• Monitor the scheduled batch processing jobs with the help of Agents & analyze and debug the execution statistics & errors in case of fall-outs.
• Created the database objects like staging tables, mapping tables with necessary constraints, views, and packages to load the data into Compass.
• Worked in Production support for the applications and resolved the issues in a timely manner.
• Created Mapping and Design Document, Database objects, PL/SQL API's for interface jobs and Load Plans.
• Developed Unix Shell Scripts to call PL/SQL scripts and SQL scripts.
• Monitor the daily & monthly Unix shell script & Cron jobs using Autosys & debugged any errors or failures.
• Performed the Year End Rollover for Compass & reconciled the data after rollover.
• Performed Month End closing process for Compass along with the business support team.

Confidential, Bethesda, MD

Oracle Developer

Responsibilities:

• Developed advanced PL/SQL packages, procedures, triggers, functions, indexes and collections to implement the business logic, using Toad.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Performed meeting within Business stakeholders, DBAs, Quality Assurances and End users of Business to understand and analyze the high-level requirements.
• Recommended best solutions and methods per requirements and specifications.
• Involved in designing the Oracle Applications forms & reports from the high-level requirements.
• Developed new forms & reports for the financial & order management modules in Oracle Applications using Oracle Forms & Reports, from the database tables & stored procedures.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Developed PL/SQL triggers and master tables for the applications and applied integrity constraints to enforce data integrity.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Involved in Unit Testing Stored Procedures and Functions.
• Involved in troubleshooting performance issues and bugs within packages, forms, and reports using explain plan and TKProf.
• Developed Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to end product of forms.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Developed procedures using Dynamic SQL.
• Worked with the Development team in the development and enhancement of the PLSQL packages and Oracle forms, making them more flexible toward future changes.
• Resolving the issues on priority basis.
• Responsible for Analyzing and Implementing the Change Requests.
• Assisted in design of tables, databases, forms, and reports; connected forms with Oracle Applications.
• With secondary role, handled tasks like creating, maintaining and updating the project plan and evaluating the impact of changes on the project plans, if any.
• Performed project planning and tracking activities with respect to budgeted cost, demand forecasts, time over-runs to ensure timely execution of projects with best practices.
• Generated the weekly/monthly project status reports.

Confidentia

Oracle Developer

Responsibilities:

• Developed stored procedures to extract the data from different sources and load it into staging tables.
• Analyzing the data and Mapping the data requirements developing Stored Procedures, Functions and Triggers.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Utilized SQL*Loader to load flat files into database tables.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Performed SQL tuning using Explain Plan, TkProf, Hints and indexes.
• Partitioned tables and indexes for better performance of application
• Contacting Application Team and clients to gather the information for migration.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Developed and deployed Oracle forms in all the project environments through Dev, Test, and Prod.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed reports using complex queries as per client request as a part of production support.
• Provided on call support, solved the user issues and made necessary changes.
• Resolving Production severity Issues in time and meeting the SLA.

Confidential

Oracle Developer

Responsibilities:

• Diligently studied and analyzed the high and low-level business requirements document.
• Participated in estimating and preparing test plans for the Financial Module.
• Created triggers for transaction adjustment, Auto Adjustment, defined Vendors, Invoices, Tracking of payments, Prepayments.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging.
• Developed procedures using Dynamic SQL.
• Develop UNIX shell scripts to administer the system.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Created/modified various Packages, Stored Procedure & Functions as part of the data validation and cleansing process.
• Created tables to capture errors and data that failed Validation Checks.
• Re-validated corrected data from source and re-processed to get them loaded to the oracle target.
• Re-worked on the BAD Files that were generated by SQL Loader.
• Administered offshore-onsite status calls.

Confidential

Oracle Developer

Responsibilities:

• Created LLD (Technical Design Document) for the forms and packages to be developed.
• Worked with the Development team in the development and enhancement of the PLSQL packages and Oracle forms, making them more flexible toward future changes.
• Assisted in design of tables, databases, forms, and reports; connected forms with Oracle Applications.
• Responsible for preparing the Knowledge Management documents.