SUMMARY:

• Over 8years of extensive experience as Oracle PL/SQL Developer which involves Data analysis, design, development, implementation, integration, testing and support.
• Besides the PL/SQL development, have experience in developing Oracle Forms & Reports using Reports 10g/6i and Forms 10g/6i.
• Extensive experience in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Robust experience in RICEW modules and held positions where major responsibilities included coding, unit testing reports, interfaces, conversions & enhancement programs, workflows and performance tuning on the backend side and considerable experience in UNIX Scripting.
• Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End - User Training and Supporting for Oracle Financials R12/11i GL, AP, AR, CM, and FA modules.
• Experience in the Client-Server application development using Oracle 11g/10g/PL/SQL, SQL PLUS, TOAD and SQL Loader.
• Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility & TKProf.
• Hands-on experience working with Smart BPM Methodology and Direct Capture of Objectives tool (DCO Tool- Application Profile and Application Document) for capturing business requirements.
• Extensive experience in using database tools like TOAD, SQL Developer, SQL*Loader, SQL *Plus, MS Access.
• Proficiency in writing PL/SQL Packages, Stored Procedures, Functions, Packages, Database Triggers, views, collections (nested tables and arrays), records, sequences, Materialized views, Constraints and other database objects, Indexes, Sequence, Synonyms, Roles and privileges using SQL and PL/SQL.
• Experienced in Database Design, Migration, Data Modeling, and Systems Architecture, Planning, Testing and Trouble Shooting, Schema Design.
• Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables.
• Experience in using DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Worked with both Onsite-Offshore project models and proven characteristics of being highly motivated.
• Strong interpersonal, problem-solving and analytical skills. Self-Starter and ability to work independently without any supervision.
• Excellent team player and can work on both development and maintenance phases of the project.

TECHNICAL SKILLS:

ERP Versions: Oracle E-Business Suite R12, 11i

Languages: SQL, PL/SQL, J2SE, UNIX, PowerShell/Perl scripting HTML, XML, C and Java Scripts.

Database: Oracle 9i/10g/11g, SQL Server 2005/2008/2012, MS Access

Development Tools: TOAD, SQL*Developer, SQL*Loader, BI Publisher, FND LOAD,SQL*PLUS,Forms & Reports 10g/9i/6i, Oracle Discoverer10g, XML Publisher, Workflow Builder, ADI & EDI Gateway, Putty, Citrix, ETL INformatica.

Version Control: TFS, Tortoise SVN and VSS.

Tracking Tools: Quality Center, DB Doppler, PEGA related Tools-PMF

Document Methodologies: BR100, BP80,MD.070, MD.120, TE.020, CV.040

Operating Systems: Windows, UNIX, SUN SOLARIS, LINUX.

PROFESSIONAL EXPERIENCE:

Confidential,VA

Oracle PL/SQL Developer/SQL Server Developer

Responsibilities:

• Worked on SQL Server 2008 R2 and 2012 for different parts of the project.
• Working closely with Business Analyst (BA) to create NEW Report as well as modification in an existing Report as per business requirement.
• Created a report for management on the Claims received and the summary of claim statuses of outstanding and paid claims.
• Worked on claims adjudication process and the production claims from different markets.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Worked on analyzing, design, develop, test, troubleshoot, optimize, enhance and maintain data integration and EDI applications in various formats that include HIPAA standard formats (e.g. 837, 834), other regulatory formats, and custom file layouts using a combination of SQL and data mapping tools.
• Involved in performance tuning - analyzing query plans, query tuning, partitioning and optimizer hints.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages, loading the data into flat file and Excel file destinations.
• Managed performance and tuning of SQL queries and fixed the slow running queries in order to improve the package execution time. understanding of insurance file processes related to maintaining eligibility, compliance checks(includes HIPAA 834, Text, CSV, and XML files, FTP/SFTP, etc)
• Wide knowledge in creating tables, sequences, views. Wrote and maintained stored procedures, PL/SQL and SQL statements, and triggers to be used in Oracle environment and created standardized exceptions handling.
• Extensive experience in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Worked on part of SSIS life cycle in modifying SSIS packages, trouble shooting process, deploying and executing the packages in both the environments (Development and QA).
• Worked on SQL Server 2008 R2 and 2012 for different parts of the project.
• Managed performance and tuning of SQL queries and fixed the slow running queries in order to improve the package execution time.

Environment: MS SQL Server Management Studio 2008/2012, Query Analyzer, SQL Profiler, Informatica powercentre, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), CRYSTAL, PERL, Exploring FacetsDB, SSRS, FACETS, TRIZETTO, JIRA, Visual Studio 2008/2010, Oracle, Tidal.

Confidential, San Jose, CA

Oracle Sr. PL/SQL Developer

• Understanding existing functionality, carryout impact analysis for the requested enhancements and present it to customer.
• Ability to create Functional Spec document based on business requirements
• Developing Complex SQL & PL/SQL code for supply chain application.
• Analyzed the database tables and indexes and then rebuilt the indexes if there is fragmentation in indexes.
• Developed Perl scripts to automate frequent reports for the users
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Robust experience in RICEW modules and held positions where major responsibilities included coding, unit testing reports, interfaces, conversions & enhancement programs, workflows and performance tuning on the backend side and considerable experience in UNIX Scripting.
• Developing various PL/SQL stored procedures, functions and packages.
• Worked on generating Level-4,8, 12 traces for the levels -10046, 10053 traces using DB doppler
• Participated in complicated tasks like backup strategy tuning, load balancing and other routine tasks
• Work within GSSC to identify, define, develop and execute modeling approaches and projects under the direction of project managers or sponsors; Participate in development of modeling approaches in partnership.
• Tasks included development and execution of Unit Testing, source code management via Subversion (SVN) and construction of SQL deployment scripts for the various test environments, DEV.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan and DBMS PROFILER.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT).
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Used joins, indexes effectively in where clauses for Query optimization.

Environment: SQL *Plus, SQL *Loader, Data Loader, Crystal, PL/SQL, BOM, PERL, TOAD, SQL Developer, SQL Trace, Hints, Indexes, Materialized views, Stored Procedures, Triggers, Explain Plan, TkProf, and DBMS PROFILER.

Confidential,Florence, SC

Oracle Sr. PL/SQL Developer

• Worked with AP Team to reconcile AP with General Ledger by developing Accounts Payable Trail Balance report, Posted payment register report, Posted invoice register report and Unaccounted Transaction report.
• Executed the Payables Transfer to GL program and resolved the issues during the process.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import data from legacy system.
• Developed various reports ‘Customer Statement of Account’, ‘Core Debit memo’ and AR Invoice Report.
• Participated in R12 upgrade project - upgrading from 11.5.10.2 to R 12.1.3.
• Created Night Cycle jobs using job Scheduler. ( Millions of Data loaded every day)
• Experience in performance Tuning using Explain plan and hints. Experience with Query Optimization procedures using SQL Advisors in Oracle 11g.
• Performed Bulk Loading of Data using PL/SQL (Bulk Load Features from Staging Environment to individual Schemas for Loan Approval Process at regular Refresh Rates.
• Developing Perl modules to load the financial statements of different banks, implementing business validation on statement level, deriving discrete and LTM (last twelve months) statements based on available statements of an issuer and calculating ratios for analysts based on predefined formulas.
• Involved in development of shell scripts to send invoices to customer through mailing.
• By using different application tuning techniques, performed tuning on customized application including reports and back end programs.
• Improved the performance of the database by proper table space management.
• Analyze the various project requirements and transferring the knowledge to offshore team. Identifying and developing the reusable modules and templates, this will help in improving the productivity of the team.

Environment: Oracle Apps Release 12.1.3, RICEW, GL, AR, Discoverer, XML Publisher, XML, UNIX Shell Script, PERL,SQL *Plus, SQL *Loader, Data Loader, PL/SQL, BOM, TOAD, SQL Developer, D2K, Interfaces, Forms9i/10g/11g, Reports 9i/10g/11g.

Confidential, Orlando FL

Oracle Sr. PL/SQL Developer

• Responsible for Business meetings, conversion of business rules into technical specifications
• Developed ETL metadata driven mappings based on the Functional Requirements
• Worked with various active and passive transformations in Informatica PowerCenter.
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer.
• Developed UNIX shell scripts to run the workflows and automated the scripts to run daily loads using TIDAL scheduler.
• Handled various loads like Daily Loads, Weekly Loads, Monthly Loads, and Quarterly Loads using Incremental Loading Technique.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Automized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Performed performance tuning using the DBMS PROFILER package, this checks the run time behavior.

Environment: Oracle applications EBS 11i (11.5.10), R12,Oracle Designer10g, GL, PL/SQL, Developer 2000(D2K), (Reports 9i/10g/11g and Forms 9i/10g/11g), OAF, SQL Developer, SQL*Plus, TOAD, XML Publisher, BI Publisher, SQL*Loader, AP, AR, GL, Discoverer.

Confidential, MD

Oracle Developer / Forms & Reports Developer

• Besides the database responsibilities, also had the opportunity to involve in developing Oracle Forms & Reports.
• Involved in development of custom reports using Reports 10g and XML/ BI Publisher.
• Performing full analysis to divest the unnecessary DB Schemas/Objects and to make sure that there is no impact to the up-stream and down-stream systems/links.
• Interfaced data from the Flat Files into Interface tables of Oracle Receivables using SQL*Loader.
• Designed a custom Interface to: Update the customer account numbers that are no longer active, Create a relationship with the newly added customer account numbers. Delete the existing outdated customer account number relationship and Update the shipping details of the existing customer account numbers.
• Designed relational databases from scratch for different applications in a way that maximum performance is achieved.
• Wide knowledge in creating tables, sequences, views. Wrote and maintained stored procedures, PL/SQL and SQL statements, and triggers to be used in Oracle environment and created standardized exceptions handling.
• Responsible for Review and Mapping of business requirements, preparation of functional design document (MD50) and technical design document (MD70) and providing solutions using oracle AIM methodologies.
• Performed Unit Testing of various objects and performed defect analysis during the pre-production stage.

Environment: Oracle Applications R12, Oracle 10g, Oracle Reports 10g, Oracle Forms 10g, BI/XML Publisher, SQL, PL/SQL, UNIX, TOAD, Workflow Builder, SQL*Developer, MD50, MD70, Interfaces, AIM, LDT, shell scripts, Discoverer.

Confidential

Oracle Developer

• Participated in analysis, design, development, testing, and implementation of various financial Systems using Oracle 11i, Developer 2000 and PL/SQL.
• Coordinated between management, users and technical teams for Requirement Gathering.
• Worked with various functional experts to implement their functional knowledge into business rules in turn as working code modules like procedures and functions.
• Involved in the migration of data from different source to Oracle using SQL Loader and from Oracle to Oracle using PL/SQL.
• Work closely with functional and development team to implement Oracle Financial Modules (AP, GL, AR), create Applications Users, Responsibilities, Report Sets, Menu and Functions.
• Developed new and modified existing packages, Database triggers, stored procedure and other code modules using PL/SQL in support of business requirements.
• Developed Shell Scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Generated UNIX shell scripts for automating daily load processes.
• Involved in user acceptance testing of the application.
• Developed Pre and Post SQL scripts, PL/SQL stored procedures and functions.

Environment: SQL Developer, UNIX, SQL, AOL, PL/SQL, XML, Forms 6i/10g, Discoverer(d2k), SQL*Loader, Reports 6i/10g, TOAD.