ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 236
Resume Example SQL Developer #0236 ประมาณ 2042 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง MBIA Bond Insurance / Purchase(Greater New York), New York / MBIA Insurance Deal Analysis System มีประสบการณ์รวมประมาณ 9 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 12 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 9 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- ประสบการณ์ 12 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 18+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
9+ years of experience in IT industry with emphasis on Analysis, Design, Development, Implementation and Management of projects using ETL/Oracle (Sql, PL/SQL).
Experience
Position
- Insurance domain knowledge - Claims adjudication, Pricing, Provider networks.
MBIA Bond Insurance / Purchase(Greater New York), New York / MBIA Insurance Deal Analysis System09/2015 Current
Sr Oracle PL/SQL Developer (Consultant)
- Midas empowers the largest municipal bond insurer product to MBIA. Which would provide financial guarantee insurance and other specialized financial services.
- Creating new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements. Working on SQL*Loader to load data from flat files obtained from various facilities every day.
- Expertise in UNIX shell Scripts according to the changing needs of the project and client requirements.
- Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
- Involving in continuous enhancements and fixing of production problems.
- Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
- Developing PL/SQL triggers and master tables for automatic creation of primary keys.
- Creating PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
- Extensively working to create new tables, views, queries for new enhancement in the application using TOAD.
- Creating indexes on the tables for faster retrieval of the data to enhance database performance.
- Involving in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
- Extensively performance tuning SQL and PL/SQL tuning and Application (OLTP & OLAP) tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
- Extensively involving in creating hints to direct the optimizer to choose an optimum query execution plan.
- Expertise in Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
- Creating PL/SQL scripts to extract the data from the operational database into simple flat text files using UTLFILE package.
- Partitioning the fact tables and materialized views to enhance the performance.
- Creating collections (nested tables and arrays) for improving Query performance by
- reducing context switching and Dynamic SQL using Pragma Autonomous Transaction to avoid mutating problem in database trigger.
- Handling errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Environment: Oracle 11g database, SQL, PL/SQL, Toad, XML, JIRA, PLSQL-Developer, Unix Scripting, Perl, Windows7, JAVA
WorkForce Now (WFN)City, STATE- 04/2015 - 08/2015
Syllable - Sr Oracle PL/SQL Developer (Consultant)
- ADP Workforce Now empowers clients to effectively address business challenges with a flexible, secure and integrated HCM solution that supports the full spectrum of HR needs - from recruitment to retirement and everything in between.
- Creating new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & TraditionalCursors, Dynamic SQL, Table functions as part of Project/Application requirements.
- Working on SQL*Loader to load data from flat files obtained from various facilities every day. Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from WFN 7.0 database to WFN 8.0 database.
- Expertise in UNIX shell Scripts according to the changing needs of the project and client requirements.
- Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
- Involving in continuous enhancements and fixing of production problems.
Generated server
- rver side PL/SQL scripts for data manipulation and validation and materialized views for remoteinstances.
- Developing PL/SQL triggers and master tables for automatic creation of primary keys. Creating PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.Extensively working to create new tables, views, queries for new enhancement in the application using TOAD.
- Creating indexes on the tables for faster retrieval of the data to enhance database performance.I nvolving in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and Mampulate mes manipulate files.
- Extensively performance tuning SQL and PL/SQL tuning and Application (OLTP & OLAP) tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE. Extensively involving in creating hints to direct the optimizer to choose an optimum query execution plan.
- Expertise in Bulk Collections for better performance and easy retrieval of data, by reducing context Switching between SQL and PL/SQL engines.
- Creating PL/SQL scripts to extract the data from the operational database into simple flat text
filesusing UTLFILE package.
- Partitioning the fact tables and materialized views to enhance the performance.
- Creating collections (nested tables and arrays) for improving Query performance by reducing context switching and Dynamic SQL using Pragma Autonomous Transaction to avoid mutating problem in databaseTrigger.
- Handling errors using Exception Handling extensively for the ease of debugging and displaying the errorMessages in the application.
- Environment: Oracle 11g database, SQL, PL/SQL, Toad, XML, JIRA, PLSQL-Developer, Unix Scripting, Perl, Windows7.
Credit Suisse - Equity IT / New York City, New York
Sr Oracle PL/SQL Developer (Consultant) Advanced Execution Services (AES)
- AES helps over a thousand institutions and hedge funds reduce market impact, improve performance vs benchmarks add consistency to their trading process. AES group provides Credit Suisse's award winning suite of algorithmic trading strategies, tools and analytics for global trading. A single connection for your desk to AES will get your access to liquidity around the world. Algorithmic Trading/ Crossfinder (Dark Pool), Direct Market Acess, Smart order routing are key the engines part of AES.
- Creating new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements. Working on SQL*Loader to load data from flat files obtained from various facilities every day. Expertise in UNIX shellScripts according to the changing needs of the project and client requirements.
- Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
- Involving in continuous enhancements and fixing of production problems.
- Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
- Developing PL/SQL triggers and master tables for automatic creation of primary keys. Creating PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart.
- Extensively working to create new tables, views, queries for new enhancement in the application using TOAD.
- Creating indexes on the tables for faster retrieval of the data to enhance database performance. Involving in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
Extensively
- Extensively performance tunning SQL and PL/SQL tuning and Application (OLTP & OLAP) tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
- Extensively involving in creating hints to direct the optimizer to choose an optimum query execution plan.
- Expertise in Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
- Creating PL/SQL scripts to extract the data from the operational database into simple flat text files using UTLFILE package.
Partitioning
- the fact tables and materialized views to enhance the performance. Creating collections (nested tables and arrays) for improving Query performance by reducing context switching and Dynamic SQL.
- Using Pragma Autonomous Transaction to avoid mutating problem in database trigger.
- Handling errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Extensive scripting in PERL to generate regulatory reports and deliver to Business.
- Environment: Oracle 11g database, SQL, PL/SQL, Toad, XML, JIRA, PLSQL-Developer, Unix Scripting, Perl, Windows7.
Delta Dental of Virginia Insurance / Delta Claim System
Sr Oracle PL/SQL developer (Consultant)
- DCS integrates Claims, Eligibility and Billing functions. Claims are keyed directly into DCS2000, One step claims processing feature keeps how DCS delivers superior service to Members, Providers and Employer Groups. Subscriber/Groups/Claims data would be loaded using various ETL methods and necessary strategy would be applied by system for Adjudication/Pricing and Enrollments.
- Involved in the maintenance and enhancement of the application. Maintaining Logical and Physical structure of the database.
- Creating table spaces, tables, views, scripts for automatic operations of the database activities. Coded various stored procedures, packages and triggers to incorporate business logic into the application.
- Used the technical document to design the database tables.
- Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping. Gather Database and User Level Statistics and Analyze Overall System Performance. Designed/developed tables, views, various SQL queries, stored procedures, functions. Monitor Monitor database and system backups, developed Oracle Stored procedures, functions
- packages, and triggers that pull data for reports. Develop UNIX shell scripts to administer the system.
- Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
- Responsible for purging and archiving the production databases.
- Used UTLJOB to automate the PL/SQL procedures and packages.
- Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procedures & functions.
- Performed logical backup using export and import utilities. Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
Involved in Unit Testing Stored Procedures and Functions
- Created SQL*Loader scripts to load data into the temporary staging tables. Created Custom Triggers, Stored Procedures, Packages and SQL Scripts. Involved in uploading of the data from flat files into Databases and validated the data with PL/ SQL procedures.
- Performance Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
- Environment: Oracle 10g/11g database, SQL, PL/SQL, Oracle Stored-procedures/functions, Java 1.5
Developer, Unix Scripting, JAVA / Electronic Deposit Account Opening (eDAO)
MySQL, Toad, XML, JIRA, SQL Oracle PL/SQL Developer (Consultant Fidelity National Information Services
- eDAO would provide financial institutions with the ability to offer an enhanced New Account Opening workflow via the internet to their customers. This new account opening includes internal verification & external verification, using alerts to notify applicants about the outcome of their application, added notes for an application and enhanced application management features by providing advance search options and the ability to re-submit applications that could not be completed successfully.
- Responsible for design and development backend applications in Oracle, PL/SQL.
- Delivery of onsite and offshore ETL development for the clients.
- Performance tuning of backend queries used for online applications.
- Prioritization of projects based on business needs and timely deployment of ETL code.
- Designed ETL workflows in various tools like Informatica, DataStage and SSIS.
Software Engineer
iGATE Global Solutions
Education
- Bachelor of Engineering in Computer Science - Model
- Engineering College
Skills
Developed DDL/DML scriptsProficient in OraclePL/SQLDataStage.stored procedurescursors (ImplicitExplicitREF)packagestriggers and creating tablesPL/SQL DeveloperSQL Developer.PartitioningIndexesSQL TraceTKPROF and Explain Plan.Agile (XPSCRUM).
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง MBIA Bond Insurance / Purchase(Greater New York), New York / MBIA Insurance Deal Analysis System ประสบการณ์ 9 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 12 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ