SUMMARY

• Consultant with 8 years of experience in SQL, PLSQL, Linux, Unix and Domain experience in Oracle E Business Suite, Confidential ERP(Oracle Financials - ERP Practice). Skilled in developing Oracle Stored Procedures, Packages, Functions, Triggers, Scripting and hands on experience on Oracle Apps ERP modules such as General Ledger, Accounts Payable, Accounts Receivable, Inventory, Order Management and Fixed Assets. Proficient in implementing RICE (Reports, Interfaces, Configuration and Enhancements) and BI cubes.
• In depth knowledge in SDLC methodologies such as Waterfall and Agile. Strong interpersonal, behavioral and organizational skills.

TECHNICAL SKILLS

Programming Languages: SQL, PLSQL, C, C++, JAVA, FOP. Scripting Languages Shell, Perl, Python, JavaScript. OS Linux, UNIX, Android, Windows.

Database: Oracle 10g, Oracle11g, Oracle12c.

PROFESSIONAL EXPERIENCE

Confidential, Sterling, VA

Senior Oracle EBS Developer

Responsibilities:

• Oracle EBS consultant for ERP implementation - North America, India and R12 Germany practice.
• Engage in corporate liaison with clients and stakeholders for requirement gathering, status updates, code review and revision on a daily basis.
• Participate in technical design discussions and brainstorming business and technical architecture. Take ownership on conceptual, logical and physical data models along with corresponding metadata.
• Lead team of Oracle PL/SQL developers involved in database development using Oracle 10g.
• Create test structures and data sets in SQL and develop PL/SQL Packages, Procedures, Functions for validating the financial business flow, process data from staging to presentation using business logic, reference data lookup and analyze MD050 (Functional design documents) on specification for Reports and create MD070 (Technical design document) for all enhancement requirements.
• Create Oracle Forms and Reports for modules AR, AP, OM, GL and FA.
• Worked on customizing Payment Approval workflow to run back-end concurrent program whenever a new Payment terms has been created.
• Work extensively with the Development and Business team to help upgrade 10g and 11i to 12c applications and resolved the post upgrade bugs and menu changes on the GL and AR modules and developed BI reports to analyze the financial accounting models.
• Fix bug and modify existing RICEW objects as per additional business requirements identified post go-live.
• Resolve third party software database applications issues interacting with the database.
• Developed and implemented Unix shell scripts for automation of database processing.
• Spearheaded the metrics team and developed project management plan to migrate Domestic and International reporting metrics from a 14 day close process to a 7 day close process and improved project efficiency by 21.46%.
• Lead PMO office tasks as a Project Quality Consultant and Defect Prevention Analyst, create project plans using MPP for audits and ensure quality standards between the client team, off-shore team and the on-shore team is maintained.
• Support the growth and career development of junior resources by serving as a mentor.
• Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Imported and exported Tables, Users and Schemas and performedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Did Unit Testing of Database PL/SQL Packages, Procedures, Functions and Database Triggers.
• Used CRM APIs for upload the service request information from AFA (Legacy System) to oracle apps ERP.

Confidential, Detroit, MI

Oracle EBS Developer

Responsibilities:

• Worked with the business process owners in collecting their specifications and Analysis. Engaged in corporate liaison with clients and stakeholders for requirement gathering, status updates, code review and revision on a daily basis.
• Conducted requirements gathering workshops, prepared AS-IS(BP- 040),TO-BE(BP080), GAP analysis, Application setups (BR-100), Functional design (MD050) documents and conducted CRP,SIT, UAT sessions and user training for accounting professions and users using AIM methodology.
• Prepared Test cases TE-020,040 for Financials modules AP, AR, FA, CM, GL, AGIS and Project Costing.
• Created Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders,Key / Descriptive Flex field Segments / Values, Security Rules, Categories, Document Sequence Assignment, Multi-org Setup and Profile Options.
• Analyzed and Designed the Data Mart model using Star Schema model with Facts and Dimension table
• Involved in working with the Data analyst’s in Data analysis, Data Modelling and Data Profiling.
• Worked with consultants and business partners to analyze response and risk models to improve perational efficiencies. Assisted the data architects in planning ETL procedures
• Ensured data quality is maintained and conducted data validation in regard to the business requirements.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Provided post production support for all financial modules with month end closing related as well as regular issues.
• Designed and developed ETL routines in BODS, modified or created new Data services jobs to meet project requirements.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
• Used SVN version management to manage various versions of the procedures and functions of the application.
• Designed numerous Oracle Forms and Reports by interacting directly with End Users and Business
• Analyst.
• Logged defects in Defect Manager, monitored their status and tracked them to closure using JIRA.
• Worked extensively through Agile development methodology by dividing the application into iterations

Confidential, Chicago, IL

Oracle Financials Developer

Responsibilities:

• Involved in data conversion process for migrating the legacy systems from SAP to Oracle EBS using XML.
• Developed a new payment format using XML that was implemented in subsequent product releases.
• Customized client requirements for multiple languages for multiple bank branches.
• Migrated custom Oracle reports and packages from Oracle 11i to R12.
• Developed Oracle forms that uses XML Inbound Invoice Process to list out various transactions and developed a common payment type to view them under a particular external category.
• Developed Oracle Reports including the Oracle Payables Invoice Import Report, Purchase Order Header Update Report, Oracle Supplier Merge Report and Invoice Aging Report.
• Worked on SQL query tuning and performance improvement of existing batch processing work products.
• Integrated Oracle Applications with third party applications like SOA, EBAO, XP Gateway by using PLSQL packages, Java and created a mechanism to send notification with detailed information about the error records which fails during the transmission.
• Devised detailed test plans and performed integration testing, functional testing for customization which were introduced into the system in order to meet the client’s business process requirement.
• Proposed various value added components to automate the manual transactions handled in the manufacturing units and thus helped enhance the business process of the client.
• Performed analysis, design, development, end to end testing and documentation of customized reports and forms as per the clients business requirement.
• Provided technical and functional support to various Oracle Application modules like purchasing, order management, enterprise asset management and inventory by strictly adhering to the SLA.

Confidential

Oracle Consultant

Responsibilities:

• Implemented business logic with Oracle-stored procedures, functions and triggers using PL/SQL.
• Created database triggers, sequences, stored procedures, and other database objects usingToad.
• Developed data model,PL/SQL Queries, SQL Query tuning process,andSchemas.
• Used various LOVS (List of Values) and record groups at various points in the runtime.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints for Rule based optimization.
• DevelopedSQLandPL/SQLscripts to transfer tables across the schemas and databases.
• Performed Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions, and DB Triggers.
• Validated the functions and procedures inside the package using the various fields in Oracle APEX.
• Participated in Production Support and troubleshooting data quality and integrity issues.
• Provided oracle database technical consulting and proficiency in database architecture and administration.
• Designed and implemented capacity planning, backup/recovery, tuning, and monitoring strategies.
• Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.
• Worked on system programming (Shell and SQL) to automate database pickup, monitoring and ther DBA functions.

Confidential

Associate Oracle Financials Consultant

Responsibilities:

• Developed SQL queries to analyze and manipulate data for a major insurance client NIC.
• Worked on generating customized Oracle Reports and Forms in modules such as AR, AP and FA.
• Developed UNIX shell scripts to perform a refresh of test data from Prod Database and scheduled them using cron tab.
• Developed a new payment format using XML that was implemented in subsequent product releases.
• Developed Oracle forms that uses XML Inbound Invoice Process to list out various transactions and developed a common payment type to view them under a particular external category.
• Developed Oracle Reports including the Oracle Payables Invoice Import Report, Purchase Order Header Update Report, Oracle Supplier Merge Report and Invoice Aging Report.
• Responsible for developmental lead activities during the implementation of EBS R12financial application in AR, GL, CM modules.
• Designed complicated conversions and interfaces to transfer third party data intoOracle. Responsible for code review activities.
• Involved in migration of data from UAT to Prod environment by closely working with the onsite team.
• Involved in creating CC artifacts, Traceability matrix and deployment scripts for various environment in accordance with Oracle AIM Methodology.
• Received CMMI Level 5 Certification from Carnegie Mellon University for contribution on L5 audits and was an Integral part of Confidential ’s Oracle universe CMMI metrics team for data collection and validation of the projects’ metrics data.
• Received ‘League of Extraordinary-2012’ employee award.

Confidential

Oracle Intern

Responsibilities:

• Trained under Oracle EBS implementation projects under the Enterprise Application Services.
• Worked across the verticals and horizontals under Confidential .
• Develop SQL, PLSQL, Shell scripts as per EAS group requirements.
• Responsible to provide functional and technical direction for solutions around customspecific business requirements.
• Collaborate with business users, trouble shoot issues, log Service Requests (SR) withOracle, and work with Oracle Applications DBA to apply patches. Managing user community and ticketing system.
• Developed systems requirements, design and prototype, test, train, define support procedures and implement business solutions.
• Responsible for planning, directing and forecasting the hours of technical and functional offshore team. Responsible for assisting in development activities of offshore team.