Developer Oracle

Sr Oracle Developer

Contact Karthik: *******@************.***/732-***-****

I am looking only in NJ and NY city.

[pic]

CAREER SUMMARY

< Results-driven IT professional with 9 years of success in supporting

complex, deadline-driven operations.

< Expertise in Oracle PL/SQL development on UNIX, Solaris and Windows

environment.

< Implemented full life cycle projects and provided II line Production

Support for large production environments.

< Expertise in analyzing explain plans, TKPROF, AWR, ADDM to identify

the bottlenecks in the application. Used tuning techniques to improve

the query performance.

< Oracle Certified Associate in Oracle 9i SQL&PLSQL development.

< Developed RDBMS and WEB based applications for banking/finance majors

like Citibank & ABN AMRO Bank, Thomson Reuters and pharmaceuticals

major like Bristol Myers Squibb, Medco and New Jersey CASS.

< Experience in leading team of size 6.

< Possess knowledge of Identity Management Process. Customized and

supported Psynch application.

< Used Toad Benchmark factory to run stress test

< Experience in creating data models using ERWIN.

< Expertise in handling large volume of data and worked on production

databases of size up to 10 terabytes.

< Adhere to quality standards and best practices.

< Self motivated, proactive, flexible and possess good client

interaction skills.

< Quick and enthusiastic learner, team player and possess ability to

work independently.

< Ability to interact and motivate the team to bring out the best from

them.

< Actively participated in the 2007 CMMI Assessment.

TECHNICAL SKILLS

. Operating Systems: UNIX (HP, Sun Solaris), MS Windows 2000, XP

. Languages: PL/SQL, T-SQL, Java, C, C/Korn Shell scripting, HTML,

JavaScript, VBA, C#

. Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2000, MS-Access 2000

. Tools: P-Synch, ERWIN, SQL*LOADER, IMPORT/EXPORT, TOAD, SQL Navigator,

PL/SQL Developer, FTP, Eclipse, MS Excel, Bench Mark factory, PEGA,

Scrum framework, Team Foundation Server, Project management framework

. Version Control: Team Foundation Server, MS Visual Source Safe,

Clearcase

. Web/App Servers/Middleware: Weblogic 6.1, iPlanet 7.0/Sun one,

Webshpere, IIS

PROFESSIONAL EXPERIENCE

HP/State of New Jersey Apr 2014 - Present

Senior Oracle Developer

Environment: Oracle 11g/10g, PL/SQL, HP UNIX, WINDOWS 2000/XP, MS Excel,

HTML, Java script, SVN, TOAD, HP Quality Control, Autosys

HP has developed New Jersey Consolidated Assistance Support System

(NJ CASS) for the state of New Jersey. I am part of the Interface team

whose main focus is to read the data from the core CASS application and

send the output files to its various business partners.

Responsibilities

. Participated in the design discussions to refactor the entire application

. Developed packages, functions, triggers adhering to the functional

specification document.

. Used UTL_FILE, Parallel hints and PIPE function to generate the output

files that has several thousands of records in few seconds.

. Refactored the existing system for better performance using the latest

query tuning techniques

. Write complex queries using Analytical functions, hints, With

Clause/Subquery refactorings

. Worked with Application DBA to setup Materialized views, Table partitions

. Performed peer code reviews to meet the coding standards

. Worked on Defect fixes in System test and UAT environments. Was

recognized for fixing many defects with a quick turn around time.

. Mentored team members on Query writing and PL/SQL object creation

S&P

Senior Oracle Developer Dec 2013 - Jan 2014

Environment: Oracle 11g/10g, PL/SQL, HP UNIX, WINDOWS 2000/XP, MS Excel,

HTML, Java script, CVS, TOAD

RDSM is a rating direct warehouse where the S&P ratings and the

supporting information are stored. This project is to split the warehouses

into two and ensure that the data is consistent on either side.

Responsibilities

. Learned the Ratings data flow and its interaction with various other

systems

. Design and develop packages, procedures, functions and triggers

. Helped to create health check reports

. Used Optimization techniques like Partitioning tables, Hints, Indexes and

optimized queries to improve performance

Thomson Reuters May 2012 - Nov 2013

Senior Oracle Developer

Environment: Oracle 11g/10g, PL/SQL, C#, HP UNIX, WINDOWS 2000/XP, MS

Excel, HTML, Java script, Team Foundation Server, TOAD, Bench Mark Factory,

Sharepoint

Thomson Reuters Tax and Accounting division has developed

various state of the art products and ONESOURCE Operation Transfer pricing

is one of them. I was part of the development team for Operational Transfer

pricing product and support various clients like Ford, Halliburton and

Statestreet.

Responsibilities:

. Used Optimization techniques like Partitioning tables, Hints, Indexes and

optimized queries to improve performance

. Participated in design discussions to optimize and improve the formula

and report engine

. Supported the implementation of temporal design into the database for a

key operation that helped us save 80% of disk space

. Design and develop packages, procedures, functions and triggers

. Implement exception handling in all the modules and created a feature

that will help to debug faster.

. Breakdown components into work units and delegate tasks to programmers

. Assist in developing project plans. Create and manage tasks in Team

foundation server

. Provide mentoring and guidance to other team members

. Run stress tests using Bench mark factory and come up with statistics to

measure the performance on large client schemas.

. Hands-on experience using OEM to monitor the production database to

identify the bottlenecks. Analyze the explain plan, TKPROF, wait events

etc to find the root cause of performance issues.

. Perform preliminary DBA tasks like creating users, copying schemas,

taking backups and grant access. Coordinate with the core DBA team for

staging and production deployment. Monitor the database sessions and

identify bottlenecks that is slowing down the application

. Experience in using oracle concepts like Bulk Collect, PL/SQL tables,

Varrarys

. Run queries to identity the tablespace usage, long running queries, wait

times, redologs and buffer space usage, tables that are candidates for

compact/shrink

. Run AWR reports to analyze and identify issues in the

database/application

. Used ADDM to diagnose the performance issue.

. Used Agile methodology and actively participated in scrum

Medco/Express Scripts March 2012 - May 2012

Lead

Environment: Oracle 11g, P-Synch, PL/SQL, SQL*LOADER, TOAD, Java, JSP,

Webshpere, HP UNIX, WINDOWS 2000/XP, MS Excel, HTML, Java script, PEGA,

Sharepoint, Project management framework

Medco is the leading Pharmacy benefit manager in the industry. I was

working in one of their Physician Advocacy product (Call center workflow

management system) which was reengineered using the leading development

tool called PEGA.

Responsibilities:

. Develop PL/SQL objects like Packages, Stored Procedures, and Functions

. Perform validation testing to confirm the test results against the

database

. Incorporate complex SQL statement into PEGA, a java based development

tool

. Manage a 5 member team spread in Onsite and offshore.

. Implement the above in Agile methodology using Scrum framework

Bristol Myers Squibb

May 2009 - Sep 2011

Senior Oracle Developer

Client: Bristol Myers Squibb

Environment: Oracle 9i/10g/11g, P-Synch, PL/SQL, SQL*LOADER, TOAD, Java,

JSP, Webshpere, HP UNIX, WINDOWS 2000/XP, MS Excel, HTML, Java script

Bristol Myers Squibb excels in Pharmaceutical industry. I

support and manage their Identify Management Database and Password

Management Solution (P-Synch).

Responsibilities:

. Manage Password Management System tool and support the incidents on a

daily basis.

. Migrate database from Oracle 9i to Oracle 10g & Oracle 11g.

. Develop PL/SQL objects like Packages, Stored Procedures, and Functions.

. Enhance and Maintain Java based tools to automate the report generation

process and create Excel reports on the fly using JAVA API's.

. Design and develop Perl based tools.

. Create, modify and manage primary data base objects such as Views,

Tables, Indexes, Sequences, and Synonyms.

. Monitor tickets in Remedy and solve the issues promptly.

. Prepare Status Reports, Monthly Metrics and attend status meetings.

Mphasis an EDS Company / ELECTRONIC DATA SYSTEMS (EDS), India

May 2006 - Feb

2008

SME, Oracle Developer

Client: ABN AMRO BANK

Environment: Oracle 8i, 10g, PL/SQL, SQL*LOADER, TOAD, Java, JSP,

Webshpere, HP UNIX, WINDOWS 2000/XP, MS Excel, Clearcase, HTML, Java script

ABN AMRO Bank maintains Corporate Client and Account

information in multiple mainframe systems across continents and moves it to

an Oracle database which is administered and maintained by us. I was

involved in new development, enhancements and II line production support

using ITIL Framework.

Achievements:

< Solved performance issues by fixing the necessary queries in stored

procedures and views. Received accolades from superiors and

recognition from client for solving them quickly and immediately after

joining the ABN team.

< Quickly learned the system, always met SLA's and provided best

solution(s).

Responsibilities:

. Created, modified and managed primary data base objects such as

Tables, Indexes, Sequences, and Synonyms.

. Created SQL*LOADER scripts to upload the files received from various

Mainframe system into appropriate staging tables.

. Developed PL/SQL objects like Packages, Stored Procedures, and

Functions to move the data from staging tables to the consolidated

tables. Also incorporated business logic to perform necessary

validations and verifications.

. Prepared Schema creation scripts for each application users and grant

scripts to provide appropriate access to them.

. Created Materialized views/Snapshot for other application owners to

access data periodically.

. Created complex SQL queries/views to generate ad hoc reports from the

database.

. Tuned the SQL queries using Indexes and Hints to fix the performance

issues in the system.

. Created partitions for faster data retrieval.

. Extensively coordinated with DBA team to execute the fixes on

Production database, fix the disk usage issues, plan the database

design, to start/stop the database.

. Exported the production data to test database to run the deployment

scripts before moving it to production. This is done while cleaning up

polluted production data and updating/deleting large amount of

data/tables. Then performed appropriate test, generated reports for

comparison and submitted the report to the clients.

. Coordinated with UNIX administrators during deployment of frontend

modules and to start/stop the servers after providing necessary

scripts.

. Implemented changes requests. The activities include Requirement

gathering, Analysis, Estimation, Design, Development, Testing and

Implementation coordination.

. Monitored the batch processes to ensure that the data is uploaded into

our database as per the schedule.

. Monitor the volume of data uploaded in to the database.

. Monitored tickets/incidents, analyzed, debugged and provided quick

solution(s) / workarounds meeting the SLA adhering ITIL standards.

Identified the frequently occurring and unique tickets/incidents for

future references.

. Proactively identified the potential problems in the system and

communicated the root cause analysis and the possible workaround /

solution to the client.

. Scheduled status meeting call with the client to discuss the open

problems, ongoing change requests and critical incidents reported in

that period. Together prioritize the open problems and request the

client to create Change requests.

. Created deployment scripts, manuals and provided support during

deployment weekends.

. Created necessary technical design documents, test plans, test cases

and supporting quality documents.

. Performed Code review and quality documents review.

. Prepared Status Reports, Monthly Shift Rosters.

. Provided 24x7 production support and quickly solved the issues in the

production environment.

Ramco Systems, India Sep 2002 - May

2006

Team Lead, Oracle Developer

Client: Citibank N.A

Environment: Oracle 10g, Pl/Sql, J2EE, Weblogic 6.1, iPlanet 7.0/Sun One,

UNIX (Solaris, HPUX), CRON, Shell Scripting, ERWIN, TOAD, MS Excel, VBA, MS

VSS, MS Project, Windows XP/2000, PL/SQL Developer, SQL Navigator

Citibank is a diversified financial service company.

Implemented full life cycle projects in cash management division of

citigroup. Implemented systems like Customer Statement Delivery System,

Reconciliation system, Mutual fund sweep system, Easy Pay and Interest

Warrant Dividend Warrant system. I was responsible for Requirement

gathering, Prototyping, Coding, Testing, Bug fixing and maintenance

support.

Achievements:

< Achieved milestones under immense pressure. Delivered the project

ahead of the delivery date.

< Suggested the use of iText API, Java mail to design and develop the

robust PDF creation and mailing process to dispatch huge volume of

statements to the corporate customers of the bank. The statements were

encrypted in the PDF to provide security.

< Used Indexes, Hints to optimize the queries used in the reports.

Initially the query ran for 45 min, post tuning the query executed in

3 seconds.

< Rated 10(being the highest) in the consecutive appraisal cycle

< Management of many aspects of the software engineering and product

lifecycle, including: design, development, code review, documentation,

testing, version control, prototyping, deployment and client

engagement.

Responsibilities:

. Wrote efficient stored procedures, packages, triggers, functions to

incorporate the business logic, upload data in to respective tables

and to perform audit trail.

. Used UTL_FILE package to read and write data to the files.

. Executed dynamic queries, PL/SQL blocks, created DDL objects using

execute immediate statement and DBMS_SQL package.

. Created oracle jobs using DBMS_JOBS and DBMS_SCHEDULER (Oracle 10g)

package.

. Created logical and physical model and performed reverse engineering

using ERWIN.

. Extensively involved in SQL Query tuning using Hints, Indexes.

Analysed Explain Plan to understand the query execution plan. Achieved

great results after tuning slow running queries used in views/reports.

. Partitioned tables and implemented appropriate local and global

partition indexes to quickly fetch the data.

. Incorporated Cursors and exception handling in the PL/SQL code.

. Wrote DDL Scripts to create and modify database objects like tables,

Indexes, views

. Installed oracle and created tablespace, schemas and assigned

appropriate role/rights to the user. Took regular backup of the

database.

. In-depth knowledge of new features in oracle like External Table,

merge update, Bulk collection, VARRAYS and PL/SQL tables. Used couple

of features in the stored procedures.

. Studied the existing system and created a batch job to synchronize the

data between systems on a daily basis until the old system was

decommissioned. Used SQL*LOADER to upload the file into our database.

. Integrated C Routine into the Pl/SQL code to calculate the checksum of

the file.

. Studied the existing system and devised a migration plan to move the

huge volume of data from MS SQL Server in to the new system running on

Oracle 10g. Involved in the preparation of Data Migration Plan.

. Created Reports using complex SQL queries for the clients review.

. Wrote Unix Shell Scripts (Korn shell) to automatically invoke the Java

routines

. Created UNIX jobs using Crontab.

. Coded Java routine using iText API to create PDF, attach the customer

statement, encrypt and e-mail the PDF to the customers using Java Mail

API.

. Involved in writing VBA Macros for generating excel based report for

the clients based on the requirement.

. Involved in gathering requirement, analysis, estimation, design and

creating necessary design and technical documents from the functional

specification documents.

. Performed Unit Testing, Load Testing, Integration Testing and

supported System Testing and UAT.

. Coordinated with Business Analyst and conducted discussions to ensure

that the necessary functionalities have been incorporated in the

system.

. Involved in troubleshooting and fixing the UAT/Production issues

. Coordinated with DBA/UNIX administrators during UAT/Production

deployment and while running the fixes on UAT/Production environments.

. Performed Peer Code Review and Design Review.

. Provided Maintenance support after go-live.

. Created necessary quality documents and manuals.

Client: In-house ERP Project

Environment: MS SQL Server 2000, VB 6.0, IIS, MTS, MS VSS, Crystal Reports,

Windows XP/2000

Enterprise Application 4.0 is Ramco System's Indigenous ERP Solution.

It is tailored to provide the best enterprise business solution in the

industry. This is a web-based product developed for organizations running

their business across geographical boundaries.

Responsibilities:

. Interacted with Business Analysts to understand the business

requirements

. Coded stored procedures, views for the Receivables Management Module

using T-SQL.

. Created reports using Crystal Reports. Wrote SQL queries to generate

the business data for the reports.

. Performed Unit Testing.

. Performed debugging and bug fixing.

. Created necessary technical documents and quality documents.

EDUCATION

. Master of Computer Application (MCA), University of Madras, India

. Bachelor of Science (B.Sc) in Computer Science, Queen Mary's College,

India

CERTIFICATION

. Oracle Certified Associate

o 1Z-007 Oracle 9i SQL

o 1Z-147 Oracle 9i PL/SQL

Contact this candidate