Oracle Pl/sql Developer Resume
MN
SUMMARY:
- Over 7 years of experience in Information Technology with a strong background in PL/SQL and its related technologies.
- 7 years of experience in Oracle 9i/10g databases and Oracle 11g.
- Specialized in SQL, PL/SQL and database design, development and data modeling techniques.
- Proficient in writing stored procedures, packages and functions using SQL & PL/SQL in Oracle.
- Proficient in understanding business processes/requirements and translating them into technical requirements.
- Strong with relational database design concepts.
- Knowledge on developing ETL program for supporting Data Extraction, transformations and loading using Data stage.
- Expertise in using advanced pl/Sql Object types.
- Good Knowledge on SQL Performance Tuning & PL/SQL Tuning via explain plan.
- Resolve all internal data exceptions in timely and accurate manner.
- End - to-End implementation experience including Requirement gathering and Design, Estimations, Development, Testing (technical and functional), Implementation and Support.
- Extensively used QUEST Tools (TOAD, PL/SQL developer), SQL*PLUS and SQL Loader.
- Experience with Agile development methodologies.
- Knowledge on developing UNIX Shell scripts (Korn shell).
- Excellent analytical skills, self-motivated, team player with effective communication and leadership qualities.
- Ability to adapt to any environment and ability to learn new technologies quickly yet efficiently.
TECHNICAL SKILLS:
Languages: SQL, PL/SQL, JAVA, ASP C, C++
Operating System: LINUX and WINDOWS
Databases: Oracle 11g/10g and 9i.
Scripts : UNIX - SHELL Scripting, XML and HTML
Tools: TOAD, PL/SQL Developer, VSS, Clarify, Citrix, SQL Loader, Data stage 8.5
PROFESSIONAL EXPERIENCE:
Confidential, MN
Oracle PL/SQL Developer
Responsibilities:
- Extensively involved in the Design and Documentation.
- Working closely with the business users to understand the requirements and converting them into project level technical capabilities.
- Extensively used SQL*LOADER to load data from flat files.
- Created External Tables to load data from flat files where one to many and many to one relations exists between the flat files and Back office Database tables.
- Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
- Followed entire SDLC life cycle and SDLC process defined by Client.
- Resolving incidents/tickets as per SLA.
- Proactively monitoring the system.
- Production server’s maintenance and taking initiatives to reduce ticket count.
- Taking Initiatives to improve the performance of the application.
- Involved in migration activities, major production deployments.
- Review the code changes done by development team.
Environment: Oracle Database 11g, Unix shell scripting, SQL*Plus, TOAD, SQL*Loader.
Confidential, New Century, KS
Oracle PL/SQL Developer
Responsibilities:
- Identify, compare, and resolve data quality problems.
- Evaluate large dataset for quality and accuracy.
- Determine business impact level for data quality issues.
- Determine business impact level for data quality issues.
- Studied the existing data sources with a view to know whether they support the required reporting and generated change data capture request.
- Involved in the creation of database objects like tables, views, stored procedures, functions and indexes.
- Developed ETL jobs as per business rules using ETL design document.
- Involved in creating sessions and Workflows using Data stage Workflow Manager.
- Involved in Data Migration from Development Environment to staging environment for every sprint.
- Involved in Data conversion from staging environment to Production environment.
- Involved in Performance Tuning at mapping level and session level.
- Used complex transformations like Lookup, Update Strategy, Sequence Generator and Stored.
- Procedure while developing Mapplets and Mappings using Data stage Designer Tool.
- Used Data stage mappings to load data from Source to Target.
- Enhanced the reusability of the sessions across different workflows.
- Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
- Research and determine scope and complexity of issue so as to identify steps to fix issue.
- Develop process improvements to enhance overall data quality.
- Develop and execute data cleanup measures.
- Maintain a record of original data and corrected data.
Environment: Oracle Database 11g, Data stage 8.5, SQL*Plus, TOAD, SQL*Loader.
Confidential, Virginia Beach, VA
Oracle PL/SQL Developer
Responsibilities:
- Extensively involved in the Design and Documentation.
- Working closely with the business users to understand the requirements and converting them into project level technical capabilities.
- Extensively used SQL*LOADER to load data from flat files.
- Wrote packages and views to display the data in the front end.
- Design, development & testing of all PL/SQL stored procedures to improve performance of the code.
- Wrote PL/SQL procedures for processing business logic in the database.
- Tuned SQL queries for better performance.
Environment: Oracle Database 11g, Unix Shell scripting, SQL*Plus, TOAD, SQL*Loader.
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Responsible for analyze, design, test and debug the business applications.
- Development includes construction of Procedures, Functions and Packages in PL/SQL.
- Working closely with the business users to understand the requirements and converting them into project level technical capabilities.
- Designed and developed many of the components.
- Wrote shell scripting to load the data from source to destination using Sql loader.
- Wrote packages to display the data in front end.
- Migrate the data from 9i to 11g database.
- Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.
Environment: Oracle 11g, PL/SQL, Unix Shell scripting, Sql loader, .net
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Responsible for Instigating Project Plans, Identify client needs, Design & Development, Testing, Documenting and Deliver.
- Wrote packages and views to display the data in the front end.
- Design, development & testing of all PL/SQL stored procedures to improve performance of the code.
- Wrote PL/SQL procedures for processing business logic in the database.
- Tuned SQL queries for better performance.
- Resolved the production bugs.
- Working closely with the business users to understand the requirements and converting them into project level technical capabilities.
- Followed entire SDLC life cycle and SDLC process defined by Client.
- Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.
- Interacted with users to resolve any issues during the development and enhancement phases.
- Responsible for providing 2nd Line Support for BTGS - Diplomat Applications
- Resolving incidents/tickets as per SLA.
- Proactively monitoring the system.
- Production server’s maintenance and taking initiatives to reduce ticket count.
- Taking Initiatives to improve the performance of the application.
- Involved in migration activities, major production deployments.
- Review the code changes done by development team.
Environment: IIS Web Server, ASP, Oracle 10g,PL/SQL, XML, Web Services, VB
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Designed and developed Migration of Wireline customers CR for Wireline prepaid and postpaid customers.
- Used TOAD for faster application design and developments.
- Wrote complex views to display the data in front end.
- Developed stored procedures using types, to send bulk amount of data to front end application using PL/SQL, Oracle 9i.
- Used indexes and partitions to retrieve the data from the database for faster purpose.
- Developed batches in Shell scripts to create a report of the details to be sent to the bank for verification, fetch the file from remote server to local server after verification and update the details in the database for Automatic Debit Facility.
- Wrote complex quires to get the customer information.
- Created rate plans and price plans with discounts in Geneva.
- Developed stored procedures, functions and packages in augmenting the business using PL/SQL, Oracle 9i for sending SMS/Email to the customer’s mail id /phone number.
- Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.
- Worked with the Production support team to resolve the issues and with the implementation teams for successful fixes on Test and production environments.
- Interacted with users to resolve any issues during the development and enhancement phases.
Environment: Oracle 9i, PL/SQL, Geneve Billing System, Unix Shell scripting.