SUMMARY

More then10 years of focused experience in IT industry in various fields like banking, insurance, financial, retail, clinical trial recruitment management and Enrollment. Experience in all phases of the system development and implementation life cycle. Strong experience and expertise in Oracle Application RICEW (Reports, Interfaces, Conversions, Extensions, Work flow. ( Oracle EBS 11i,R12), SUGAR CRM. Extensive experience in relational database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management. Extensive experience of SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support, interface with clients. Experience working in Agile delivery models,

COMPUTER SKILLS:

Languages

• PL/SQL, Oracle Forms 4.5,6.i, 9i, Oracle Reports 3.0, 6i, 9i, Oracle Portal 3.0, UNIX, Shell Script.

Development Environment

• Oracle Cloud R11, Oracle Identity Manager,, Oracle HCM, OTL, GL,PPM,AR,AP, Oracle BI Publisher, Oracle HCM Data Loader, Oracle 10.2.0.2, R12,11i (Financial), Oracle Workflow 2.6.3.5 DBA Studio, RMAN, SQL* PLUS, Developer 2000, Erwin, TOAD, SQL Navigator, Reflection for Unix, Tarantella, BI Publisher, APEX 4.0,5.0, Discoverer Administrator, Discoverer Desktop 10.1.2.1, Serena PVCS Version Manager 8.3.0.0, HP PPM 7.5.0 SP7, DataLoader 5.4.1.0, PL SQL based extensions (RICE objects), ERWIN 7.

Software

• Oracle 6.0,7.2, 7.3, 8.0.5, 8.1.5, 8.1.6, 8.1.7, 9.2,10.2.0.1,10.2.0.2, 11g  RAC, Oracle9i Application Server,  Access 97, 2000.
• UNIX SUN, AIX, and HP - UX11i, Linux, Windows XP, NT, 2000, 2003 and DOS, Windows Server 2003.

EXPERIENCE:

Oracle Fusion System Administrator/Production Support

Confidential,  Washington, PA

Responsibilites:

• Create/change users in OIM
• Post-clone steps after clone of test environment
• Help investigate and resolve system functional technical errors.
• Work alongside our implementation partners to assist with technical issue resolution.
• Report, track, and resolve application related issues with Oracle Support.
• Manage the ticketing support queue in Sunrise.
• Develop ad hoc reports for Finance.
• Troubleshooting on systems and data, and generate solutions which may include systems modifications, enhancements or new procedures.
• Design, develop, configure and test systems functionality changes, such as but not limited to creating flexfields, updating mapping tables, building payroll elements and table setup.
• Maintain integrations to and from Oracle Fusion Cloud.
• Assist with the transition to each new release of Oracle Fusion Cloud.
• Configure email notification rules.
• Validate and fix interface loading user from workday to Oracle using Oracle HCM Data Loader.
• Add/modify vacation rules for approvers.
• Create smart forms, giving privileges to use them, downloading images to use in smart forms.

Senior Oracle Developer/team leader

Confidential, Oak, PA

Responsibilities:

• Developed PL/SQL code Data Access Layers for use by client applications (views)
• Designed and developed dashboard that shows summarized market value and associated cost on monthly basis for plotting Investment Value over time graph, setup User Authorization and Authentication schemas, developed master/details and classic reports, complex forms to manage various data entry tables in the database out of which reports are generated using APEX 5.0
• Work closely with development teams to ensure successful implementation
• Support refactoring of existing database schemas to support consolidation roadmap
• Worked with senior architects to understand new designs
• Provided post implementation and ongoing production support
• Managed reference data stored in Oracle DBs
• Performed manual testing, wrote test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements.
• Migrated data from external sources to Oracle

Senior Software Engineer/DBA

Confidential,  Horsham, PA 

Responsibilities:

• Designed, developed and deployed automatic load messages for medication reminders into Retention Messages application.
• Designed, developed application for integration of Clinical Conductor software with Acurian RMGrean (for Site Services).
• Designed, developed processes to monitor every day automated jobs, including cron jobs and Oracle jobs and designed and developed
• Designed, developed process that creates delinquent cases and loaded to Sugar CRM
• Wrote complex business rule data validation using Oracle Packages.
• Extensively used the advanced features of PL/SQL like Records, reference cursors, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the applications.

Developer/DBA

Confidential, Philadelphia PA

Responsibilities:

• Developed online and batch test plans using Y2K critical test dates.Extracting, transforming and loading (ETL) data from spreadsheets to database tables. 
• Creating new process that migrated embedded sql (in *.net code) from PRICE MANAGEMENT application to pl/sql code.
• Modified all objects (packages, views) that used old public database links by using synonyms of new private database links.
• Migrated user and all permissions from one schema to another in development as per request. Created test plan for migration. Created process that adds new rates for 2015 year.
• Review and update accounts/schema profiles on development instance by creating scripts that revoke direct object/system privileges from users, evaluating them and assign needed privileges to existed or new roles. All tasks done using Oracle 11.2.03 database and PL/SQL/SQL for scripts.

Oracle EBS Production Support Consultant

Confidential, Jamesburg, PA

Responsibilities:

• Create and maintain automated/scheduled tasks.
• Install/update applications.
• Code/Packaged Deployment using HP PPM. 
•  Using PVCS 8.0 SDLC Change Control and Deployment policies, migration including
• Prepared technical and functional design documents (MD50,MD70) for customizations and conversions using
• Scheduling processes to run using Runbook Alert. Created users including Portal users .
• Assigning roles, group users in Marketview. Coping roles from one user to another using

Confidential, Conshohocken, PA 

Responsibilities:

• Migration DB 11g from windows server to Linux.
• Installed, configured Oracle 11g db on Linux server
• Created backup scripts to backup data.
• Created batch scripts on windows server to migrate data from Otsuka pharmaceutical client data   to Emptoris application.
• Researched, tested and installed Application Patches.
• Managed Technical Assistance Requests (TARs).
• Backup and recovery production and test db.
• Created scripts that will mail any errors to user via mail.
• Supported users on demand on windows server.
• Troubleshooter Oracle performance and non-performance related issues.

 Oracle EBS DBA/Developer

Confidential, Paoli, PA

Responsibilities:

• Developed, designed Tax Area Id assignment program and real-time tax area id assignment programs that populate oracle tables by getting data from Vertex.
• Created Workflow process that notified user, if TAID is not assigned.
• Created installation scripts, that install custom tax link to, that link Oracle apps to
• Created Business Events, custom subscriptions for real time tax area id assignment .
• Customized client extension process that will be used in AR,AP, Autoinvoice, Service Contracts and Quotes modules .
• Created MD50 - function and MD70 - technical specifications for all processes.

Oracle DBA/Developer

Confidential, Burlington, NJ 

Responsibilities:

• Full (24/7 x 365) DBA support for 53 databases storing over 8 TB (8,000G) of data implementing on SUSE Linux and SUN Solaris. Backup and Recovery - verification procedures using RMAN, restoring production databases on different machine. Perform 7 x 24 hour support on a rotation basis and wear a blackberry device, standard setup, procedures and documentation. 
• Provide 24/7/365 primary support of all Oracle databases and related systems. DBA support for development process; table design as requested, trigger / procedure development, query tuning. Monitor all database systems utilizing vendor supplied and standard tools. Ensure that all systems are backed up and monitored according to the business requirements and notify the data owners when there are failures. Ensure optimal resilience of deployed systems and meet all disaster recovery and compliance requirements dictated by the business. Migrate databases from 8.1.7 to 10.2.0.2.
• Rebuild schemas to partition tables and indexes for easy manageability and performance. Tuning databases using init.ora parameter file and UNIX utilities. Tuning sql statements for developers using explain plan and tkprof utilities.
• Integrated custom forms using Oracle Forms 6.0i, Reports 6i and PL/SQL procedure in Oracle 11i to implement additional business requirements and custom reporting.
• Designed, developed electronic process in AP module that void Checks in old set of books an
• Modified custom reports for HR modules.
• Implemented automated Journal Entry (JE) approval process using Oracle Workflow Builder 2.0.
• Created MD50 - function and MD70 - technical specifications for all processes.

Oracle Developer

Confidential,  New York

Responsibilities:

• Total Return Swap (TRS)  - Financial Reporting System used internally to generate settlements and PNL for bonds and loans for counter parties. Involved in the design, development and setup of a batch processing and report generating system.
• Developed new and modified existing packages/procedures/functions/triggers/views using Oracle 9i database.
• Created Financial and Statistical reports in Excel, Adobe and HTML formats utilizing REF cursors and analytical functions.
• Optimized existing business and code logic within SQL and PLSQL to achieve superior performance and reusability. Utilized explain plan, trace files, DBMS PROFILER package to identify potential bottlenecks,
• Modified parsing logic in existing Perl scripts used in batch processing.
• Interacted with clients to resolve production issues.
• Support UAT and Production environments.
• Creating Bond Transaction, Loan Transaction, Customer Statement, Next Settlement and other reports using Oracle Reports  6i tools.