Oracle Plsql Developer Resume

PROFILE:

• Around 6 Years of IT experience, 5.8 Years of Oracle PL/SQL Programming experience
• 3 years of Strong Unix Shell Programming Experience
• 1.6 year of Informatica Experience
• Building software components using Oracle 9i, 10g, 11g (SQL, PL/SQL).
• Involved in tuning of Data Base.
• Performing Unit Test for the software components before the release.
• Expertise in writing SQL queries.
• 24X7 support in Production.

SUMMARY:

• SDLC: Around 6 years of IT Experience Oracle Development experience including analysis, modeling, design, coding, testing, administration, maintenance of Oracle Database systems on Windows, UNIX and NT platforms.
• Oracle: Around 6 years of solid database experience on Oracle 11g/10g/9i/8i/8.0/7.3, PL/SQL, SQL *Loader, Physical database design, Logical database design, Data Modeling (PowerBuilder), Data Mapping, Cleansing, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Security Administration, Resource Management, Software Maintenance, User & Security Management, Oracle Tuning & Optimization.
• PL/SQL: Around 6 years of strong back-end programming experience using PL/SQL, SQL, MS SQL, HTML, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL.
• Informatica: 1.6 Years of work experience in defect fixing, Monitoring and back tracking in Informatica mappings.
• Databases: Oracle 11g/10g/9i
• Optimization Techniques: Around 6 years of Performance Tuning experience on Explain Plan, HINTS, TK Proof and Trace.
• Data Cleansing: 4 years of strong Data Cleansing experience using PL/SQL, SQL Coding, and UNIX Shell Scripting.
• UNIX: 3 years of UNIX experience on Unix Shell Scripting, Autosys, Sun Solaris.

EDUCATION:

• Master In Computer Application (MCA)
• BSc. (Computer Science Hons.)

TECHNICAL SKILLS:

Oracle

PL/SQL, SQL, Database Design (both Physical and Logical), Data Exports & Imports, Performance Tuning, Administration, Software Maintenance, User & Security Management, Query Optimization, Export/Import Utilities

Databases

Oracle 11g/10g/9i

Programming

SQL, PL/SQL, Unix Shell Scripting

Environment

Windows 2008/2000, Red Hat Linux, Windows 98/NT/2000/XP, Unix Sun Solaris and Linux, Informatica 7.1.2, Autosys(WCC), TOAD 9.5, SQL*Loader, Sql Developer

CERTIFICATIONS:

• Completed OCP (ORACLE Certified Professional) in PL/SQL
• Completed OCA (ORACLE Certified Associate) in Program with PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Stamford, CT
Senior Oracle PL/SQL Developer May'12 - till date

Confidential, is the world\'s leading information technology research and advisory company. We deliver the technology-related insight necessary for our clients to make the right decisions, every day.Through the resources of Gartner Research, Gartner Executive Programs, Gartner Consulting and Gartner Events, we work with every client to research, analyze and interpret the business of IT within the context of their individual role. Founded in 1979, Gartner is headquartered in Stamford, Connecticut, USA.
I am working in design and development of several modules including duplicate clean up and data migration.

Responsibilities:

• Gathering development requirement from client's functional team and from functional design specification documents.
• Authoring the technical design documents for the given functional design.
• Performed logical database design.
• Involved in development of code from scratch for the given requirement.
• Optimized the Oracle PL/SQL queries by Performance Tuning.
• Working in data analysis & data cleansing.
• Data load through informatica work flows and mappings.
• Tuning of PL/SQL Stored Procedures using HINTS in Explain Plan.
• Attaining daily status meeting and other meetings with end client to take proper clarifications.
• Creating test cases for System Testing (Development Environment), Integration Testing (UAT) and Production (Post Implementation Review).
• Review of the performance testing results and providing input to the testers or Production support team.
• Directly involved in process improvement plans and implementing business change

Technology : Oracle 10g/11g, Red Hat Linux
Environment: TOAD 10.5, WinSCP, Putty, Autosys (WCC), Informatica 7.1.2

Confidential, Bloomfield CT
Senior Oracle PL/SQL Developer Feb'12 - May'12

Confidential, in Bloomfield, Connecticut, is a global health services company.HP is the implementation partner for CIGNA to execute theHIPAA 4010A to 5010 Migrationprojects for all of the CIGNA's health insurance subsidiary companies. HP works with EDIFECS, Deloitte, Oracle and IBM products to upgrade and manage all of the Cigna's broker gateways and claim engines environments that are aimed to deliver cost-effective, on time and easy flow of EDI transaction for CIGNA, which will reduce administrative cost and increase productivity, and will lay a foundation for ICD 10 implementation.I was involved in Sql side and also in Informatica Mappings to fix the defects with high priority. Involved in writing complex Sql queries and also involved in modification of sql queries required to tune the data base. Also I was updating EDI transactions with the HIPAA 4010 to HIPAA 5010 changes and for that participated in full life cycle implementations (SDLC) from project initiation to final deployment.

Responsibilities:

• Performed GAP analysis of 5010 EDI transaction using implementation guide to identify the changes in the segments and data elements
• Gathered Business Requirements, interacted with the users, project manager and QA team to get a better understanding of the Business Processes
• Optimized the Oracle PL/SQL queries by Performance Tuning.
• Experience in data analysis & data cleansing.
• Worked in Informatica mapping to get the root cause of any defect.
• Worked in Informatica Designer part and worked in back tracking of column values from XML file or XML_CLOB.
• Tuning of PL/SQL Stored Procedures using HINTS in Explain Plan.
• Analysis and fixing of the defects/bugs in production with high priority.
• Working with Business analyst to solve high priority data base issues.
• Impact Analysis for change requests from client.
• Attaining daily status meeting and other meetings with end client to take proper clarifications.
• Created test cases for System Testing (Development Environment), Integration Testing (UAT) and Production (Post Implementation Review) in Agile/Scrum environment.
• Review of the performance testing results and providing input to the testers or Production support team.
• Supported the testing team with Defect Management, Requirement Analysis and SQL development for back-end and regression testing.
• Directly involved in process improvement plans and implementing business change

Technology : Oracle 11g, Informatica 7.1.2
Environment: TOAD 10.5, Pl/Sql Developer 5.1, WinSCP, Putty, Autosys (WCC), Informatica Power Centre Designer, Informatica Power Centre Workflow Manager

Confidential, CT
Senior Oracle PL/SQL Developer Jan'11 - Dec'11

Confidential, is a leading provider of life insurance, group and employee benefits, automobile and home owners insurance and business insurance - as well as investment products, annuities, mutual funds, and college savings plans. The Hartford serves millions of customers worldwide - including individuals, institutions, and businesses - through independent agents and brokers, financial institutions, and online.

Catastrophe Risk Manager (CatRM) Migration Project (IM Services):
Catastrophe Risk Manager (CatRM) helps to analyze the risk and exposure for a proposed new business or changes to an existing business. CatRM is used to analyze the impact that a new or renewed business will have on exposure and Probable Maximum Loss (PML), Estimated Average Annual Loss (EAAL) in a specific location. CatRM application was build in Oracle 10 g environments. As part of CatRM migration project, application is to be migrated to Oracle 11g environment.

Responsibilities:

• Analysis and enhancement upon source to target mappings
• Experience in data analysis & data cleansing
• Designed and developed database tables and loaded into new target Databases
• As-Is system analysis with special emphasis on system integration and data migration needs.
• Designing the overall architecture for the system integration and data migration based on functional requirement.
• Arrange the review for the solution design to ensure it conforms to the Enterprise Architecture.
• Review of the developed code to check for non-compliance to the technical specification and the coding standards and suggesting improvements to the same.
• Review of the performance testing results and providing inputs to the developers on how to modify the code to improve the performance.
• Providing the technical inputs to the DBAs and Data Modelers on the release.
• In addition to the aforementioned responsibilities, I also used to provide the technical assessment on the developed application in time to time.
• Causal analysis and fixing of the defects/bugs uncovered during the development.
• Attaining daily client meeting and providing reports to the project manager on the development quality.
• Optimized the Oracle PL/SQL queries by Performance Tuning.

Technology : Oracle 10g/11g, Red Hat Linux
Environment: TOAD 10.5, WinSCP, Putty, Autosys (WCC), Informatica 7.1.2

Confidential, USA
Senior Oracle PL/SQL Developer Feb'08 - Jan'11

Confidential, is a global information and advertising research company with leading market positions and recognized brands in marketing and media information, online intelligence, business publications and trade shows. Nielsen's clients rely on its information, insight and analysis for their sales and marketing solutions.

Quality Search Initiative (QSI):
The main purpose of QSI is to build blueprints for output deliverables. These blueprints are formally called Instructions within QSI. QSI was implemented as a product specific specifying system and has a large number of options in the creation and modification of the product dimension. The non product dimension was there in QSI also. The product is linked with the characteristics of Base size or Color which was being mapped to product after the characteristic resolve process complete.
This projects aims at tuning from Java and SQL side for better performance of an existing application, Espec. In addition to this some additional features enhancing the capabilities of the application, worked in OLAP process with Data Warehousing concept.

Responsibilities:

• Gathering development requirement from client's functional team and from functional design specification documents.
• Authoring the technical design documents for the given functional design.
• Performed logical database design.
• Created logical and physical database objects - table spaces, tables, indexes, referential integrity constraints, and triggers to development needs.
• Responsible for the development of pipelined functions using ref cursors and PL/SQL stored procedures as per client requirement.
• Responsible for developing technical components for the following Oracle Applications modules: Custom Char Resolve, Conversion Resolve, Upc Resolve, Scope Resolve, View/Subtotal Resolve, Hierarch Resolve.
• Optimized the Oracle PL/SQL queries by Performance Tuning.
• Working in OLAP process with 5 tera byte of Database.
• Working with STAR schema and FACT tables.
• Worked on enhancement of existing pipelined functions and packages.
• Testing codes developed by self and team.
• Bug Fixing while in Production with top priority.

Technology : Oracle 10g Application (Data Warehousing, OLAP), Sun Solaris OS
Environment: TOAD, WinSCP, Putty, Sql* Loader

P & G China:
The basic objective of the project is to set up E-commerce Online Retail Sales Tracking infrastructure for CHINA. This includes the Panel Recruitment development and Wrapper Processing. Panel Recruitment development includes design and development of different web pages. These web pages are browsed by different users of China. Wrapper Processing includes a number of back end processes.
At Project level, I was involved in development of new emails which also included development of new procedures and modifications to existing ones. I have taken responsibility of Impact analysis, Requirement gathering and development of Base and Retail Processing for China. I have also involved in populating RT tables with Chinese character and then in bringing Sign Off from Msci, PQA/FQA team with Chinese data.

Responsibilities:

• Analyzing and understanding the functional requirements.
• Coding complex business requirements algorithms.
• Single point of contact for all database changes and handled all DML and DDL scripts in code repository.
• Authoring respective HLD and technical design documents.
• Optimized the Oracle PL/SQL queries by Performance Tuning.
• Create reusable DDL, DML SQL queries that can be used for different input data to validate against the User Interface.
• Basic DBA activities like Creation and management of tables, indexes, Procedures, Functions, packages, database links.
• Synonyms and other database objects.
• Support and Defect Prevention in QA and PROD with top priority.
• Running the jobs in back end
• Worked with file manipulation operations of Unix
• Impact Analysis for change requests from client.
• Dropped and recreated the indices on tables for performance improvements.
• Wrote unit & system test cases to check the functionality of the new modules.
• Developed the code to load the Target database Tables
• Optimized the Oracle PL/SQL queries by Performance Tuning.
• Fine-tuning of PL/SQL Stored Procedures using HINTS in Explain Plan.
• Hands on experience on testing database fail over and fail back
• Dropped and recreated the indices on tables for performance improvements.

Technology : Oracle 10g, PL/SQL(Objects and Performance Tuning), Sun Solaris OS
Environment: TOAD, WinSCP, Putty, SQL*Loader

RDD ONLINE:
This project is mainly deal with redesign of back end processing of existing RDD load process to Phoenix system and also any extract from RDD DB to external system.

This Project Contains following Modules:

• Site Census Script preparation
• HSO to Phoenix
• MRC Report
• Site Census is deal with redesign of back end processing of existing Site Census scripts and also an extract to external system.
• I was involved mainly on following different user story
• Site Census script conversion for given Site Census VSD files.
• Site Census script preparation in Sql and Pl/Sql.

In HSO to Phoenix, from database activities point of view, we were working in development of Sql scripts after analyzing the requirement. We will be receiving input files containing CPG data and pseudo brand data. We will be processing the CPG data along with the Base data for calculating the different aggregated matrices like Hits, audience, total session, total session time, total domain, total page view, total duration.

Also there is feed file generation, containing lookup information like parent, channel, brand, domain, category, subcategory, summary, ad support and CPG. The feed will be generated as per the predefined format provided.

In MRC report, from database activities point of view, we were working in creating and modifying sql scripts. We will be receiving input files containing panelists count from panel management team. And we are calculating their percentage.

Also feed file generation contains lookup information like parent, channel, brand, domain, category, subcategory, summary, ad support and CPG. The feed will be generated as per the predefined format provided.

Responsibilities:

• Gathering development and enhancement requirements from client's functional team and from functional design specification documents.
• Documenting the design approach and getting it approved from the client design authority
• Analysis and modification of existing scripts.
• Executing back end jobs inside putty using sqlsh and nohup command.
• Development of SQL and Pl/Sql scripts.
• Impact Analysis for change requests from client
• Migrating the scripts from Sql to Netezza.
• Prepare scripts for manipulating different files and creating the summary reports using UNIX environment.
• Worked with advance Unix commands like awk, sed.
• Developed the code for procedures, functions, packages and database triggers required in the application to implement the business logic.
• Create reusable DDL, DML SQL queries that can be used for different input test data to validate against the User Interface.
• Write Shell scripts to automate the processes.
• Involved in Unit and Integration testing.

Technology : Oracle 10g, sql,pl/sql, Sun Solaris OS, Netezza 7.3
Environment:

Confidential, India
Oracle PL/SQL Developer Dec'06 - Jan'08

BANC724 is a Banking Domain project implemented in various banking sectors.
This project has various modules like, cash receipt, cash payment, transfer module, where 1st. have to debit & then credit the same amount for a tallying scroll. Various deposit scheme modules like MMDC, MIQR, QIDR, RDS and CMDS.
Cancellation module helps for cancelling the scrolls, if any mistake done at the time of posting by bankers.
It helps customers by providing all type of account balance statements.
Also helps bankers by providing daily statement of cash receipt, payment, transfer, bank balance house keeping & on tally reports.
GLB & accounts balance tallying report, also difference report.
Helpful patches are available to update the amount difference between GLB & account balance.
It has also facility for day open, re-open & close, accordingly to calendar date wise.
So, BANC724 is a banking product developed on advanced technology with rigorous testing procedures that ensures stability, reliability and scalability. Support services like help desk functions etc helps a lot in catering the clients round the clock thus enabling to achieve total customer satisfaction.

Responsibilities:

• Installation of databases and integration of different banking applications with them.
• Designing different modules that are to be used in 724 software.
• Performance tuning of SQL-queries and database.
• Solving user end issues for accessing applications.
• Exchange Partitions, altering partition tables and modifying partitions.
• Monitoring daily loads to collect statistics, security trails and space estimates for new tables.
• Creation of db_links for different database connectivity.
• Normalized data relations (3 NF and beyond) and created relational constraints on objects
• Instrumental in developing critical database objects like Procedures, Packages and triggers.
• Involved in Oracle Database Administration.
• Involved in 24X7 support and maintenance work.

Technology : Oracle 9i, Sql, Pl/Sql, Sun Solaris OS