ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 102
Resume Example SQL Developer #0102 ประมาณ 1128 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SQL Developer ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 3 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 3 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 3 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- ประสบการณ์ 3 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
Professional Summary
JESSICA CLAIRE - Microsoft Certified Professional with Six years of IT Experience in Database Design, Development and Implementation of Microsoft SQL Server 2005/2008/2008R2 in Development, Test and Production Environments - Experience in working on full Software Development Life Cycle (SDLC). - Experience in developing optimized SQL using best practices. - Expertise in writing dynamic-SQL, complex stored procedures, functions and views. - Hands on Experience in performance tuning using execution plans, SQL Profilerand DMVs. - Incorporated complex business logic into stored procedures and functions for reusability. - Experience in creating packages, jobs, sending alerts using SQL Mail and extended stored procedures. - Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle and DB2. - Strong debugging skills and the ability to solve complex problems. - Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance. - Experience in Creating and Updating Statistics to improve the SQL Server Performance. - In-depth knowledge of T-SQL, SSRS, SSIS, Reporting and Analytics. - Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services. - Experience in creating SSIS packages using with Error Handling. - Experience in enhancing and deploying the SSIS Packages from development server to production server. - Adept at capturing the execution errors in SSIS for analysis purposes. - Experience in sync processes between two databases using SSIS. - Experience in importing/exporting data between different sources like Oracle/XML/Excel etc. using SSIS/DTS utility. - Created stored procedure for generating reports using SQL Server Reporting Services (SSRS). - Experienced in creating various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports and Multi-valued parameters. - Experience in administrating the created reports and assigning permission to the valid users for executing the reports. - Experience in deploying created reports to report server. - Experience in developing cubes using SQL Server Analysis Services (SSAS) SKILL SUMMARY - Databases: MS SQL Server 2012/2008R2/2008, T-SQL, SQL Server Management Studio, Business Intelligence Development Studio BIDS, SQL Server Agent, Data Transformation Services DTS, SQL Server Integration Services SSIS, SQL Server Reporting Services SSRS, SQL Server Analysis Services SSAS, PL/SQL - Programming Language: C++, Python, PL/SQL
Experience
SQL Developer10/2020 - Current
Louisiana State University
- Documentation Tools: MS Office Including MS Project, VISIO - Operation Systems: Windows, Mac, UNIX, LINUX
- Worked on requirements Analysis, Physical and Logical design development using Erwin, normalization, and SQL Server Enterprise manager
- Used tools such as performance monitor, query execution plans to increase the efficiency of the queries
- Managed and scheduled daily jobs relating to data transfers, backup and restore.
- Migrated DTS packages and converted them to SSIS packages in SQL Server 2008.
- Used ETL Transformations to copy columns and load data from source like Oracle, DB2, Flat files to destination databases.
- Implemented different types of Replication models including Snapshot and Transactional replications.
- Created reports using Cascading parameters and Drill-Through Reports, Sub reports, Parameterized Reports, Report Models and ad hoc Reports.
- Experience in Generating Report Models, Refining and Enhancing the Report Models, Deploying Report Model, Creating Reports on Report Models.
- Designed reports using SQL Server Reporting Services SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports.
- Modified and tuned stored procedures, triggers, views and indexes to provide best performance.
- Analyzed, identified and implemented user roles and assigned relative database access privileges.
- Securing Access to Reports, Authorizing Users at the Home Level and Project Level, Managing Reporting Services Roles.
- Environment: MS SQL Server 2008/2012, Erwin, DB2, ER Studio, MS SQL Integration Services, MS SQL Reporting Services 2008, MS Excel, Windows Server 2007
SQL Developer05/2019 - 08/2021
Louisiana State University
- Gathered business requirement from the end users.
- Involved in creating complex stored procedures according to business logic and also for the creation of RDL for reporting.
- Worked with nested Stored Procedures and Functions.
- Involved in the performance tuning of the existing SQL code.
- Coded with complex customer data related to events such as Delinquency, Bankruptcy, and Collections etc.
- Created objects like tables and views and developed SSIS packages to load data.
- Implemented Incremental Loading into the target tables/views in SSIS.
- Created SSIS packages for moving data between databases.
- Involved in maintaining the Error-Logging for the SSIS packages.
- The data is moved with one-to-many relationships between tables and many to one relationship between tables.
- Created Jobs, Alerts using SQL Server Mail Agent in SSIS.
- Developed SSIS Packages and stored procedures to retrieve all accounts from various systems like Settlements, Foreclosures, Transactions and Mortgage to name a few.
- Created mock-up data for testing the reports.
- Involved in the performance tuning of table valued functions.
- Responsible for creating reports using SSRS.
- Created Drill Down, Drill Through and Cascaded Parameterized reports according to the customer requirement. Environment: Microsoft SQL Server 2008, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, Microsoft Team Foundation Server.
SQL Developer02/2017 - 04/2019
Louisiana State University
- Designed and normalized the database and created different objects like Tables, Views Stored Procedures, UDFs, Indexes Rules and defaults on MS SQL Server.
- Involved in installing and migrating legacy database to MS SQL Server 2008R2.
- Research with team members and came up with the high level design, impact analysis document with several solutions to the problem during implementation proposed new system.
- Created several SSIS package to import Flat files CSV into data tables.
- These packages were scheduled in regular time interval.
- Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
- Created SQL Server reports using SSRS and exported them to Excel format for managers and QA team for easy validation.
- Applied various data transformations like Lookup, Sort, Multitasking, Conditional Split, Derived column.
- Perform data validation checks and filtered bad data.
- Used Sequence Container, Execute SQL Task, Send Mail Task, Precedence Constraint, Script Task to achieve business requirement in the control flow.
- Responsible for the ad-hoc reporting, modification and regenerating on request.
- Building scorecards and dashboards using the Performance Point Services 2010 with BI application.
- Schedule the reports to run daily, weekly and monthly and also automatically emailed reports to department directors and analyst to review it.
- Environment: MS SQL Server 2008R2 SSRS/SSAS/SSIS, Point Services 2010, Microsoft office 2010, T-SQL, Windows 7.
Education
- Bachelor of Science: CS
- University of Washington
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SQL Developer ประสบการณ์ 3 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 3 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ