ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 233
Resume Example SQL Developer #0233 ประมาณ 1275 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SQL Developer ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 5 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 7 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 5 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- ประสบการณ์ 7 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 16+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
<tuning Over 5 year of IT Experience in Database Design and Bi development on MS SQL Server 2014, 2012,2008 versions on various development, test and production environments with various business domains. *Experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS). *Proficient in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes Created various Complex Formula Reports to query the database for business Intelligence. *Strong DBA/ /Development skills writing T-SQL scripts, worked extensively on ETL process using DTS, SSIS packages, handling data quality issues and generating various types sof reports using SSRS on OLAP databases. *Demonstrated expertise in MS 5 SQL Server 2012/2008/2005 and Microsoft Business Intelligence (MS-BI) tools like SSIS (MS SQL Server Integration Services), SSRS (MS SQL Server Reporting Services), SSAS (MS SQL Server Analysis Services) and T-SQL scripts. "Experience in optimization and performance tuning using SQL profiler, wizard, Performance Monitor and Execution plan. "Evaluates and and refine Business Intelligence business objectives, decision support needs, data and performance requirements to meet departmental/project level objectives. *Provides design support for the development of business intelligence solutions. *Works on multiple tasks/projects as team member. *Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems. *Proficient in the use of query and reporting analysis tools. *Standardize data collection by by developing methods for database for database design and validation reports. *Evaluates and validate quality of performance on completeness of Business Intelligence models and solutions. *Strong understanding of application systems, and business intelligence methods and the ability to quickly learn new software solutions. *Experience in deploying created reports in various sources like Web browser, XML and PDF. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements. *Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
Experience
SQL DeveloperGreat Falls, MT. 2016-03/2017
Wells Fargo
- Involved in Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
- Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
- Installed SQL Server 2014 and Management tools using SQL Server Setup Program.
- Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio.
- Analyzed business requirements and built logical data models that describe all the data and relationships between the data.
Perform DML, DDL Operations as per the Business requirement. / Creating views and / ares the Business Reports.
- prepares
- Resolved production issues by modifying backend code as and when required.
- Used different joins, sub queries and nested query in SQL query.
- Documented the data such as entity relationships and attributes, file descriptions and definitions.
- Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor.
- Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
- Testing of code functionality using testing environment.
SQL/Bi developer / Created SQL Server Reports using SSRS for management.
Neogenomics Laboratories
- Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.
- Documented the data such as entity relationships and attributes, file descriptions and definitions. Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical requirements.
- Participated in developing logical model and implementing requirements on SQL Server 2012. Created the
- Created the database for the reporting team.
- Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
- Ensured Data Recovery, Maintenance, and Data Integrity and space requirements for physical Database.
- Monitored performance and optimized SQL queries for maximum efficiency.
- Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
- Created indexed views and appropriate indexes to reduce the running time for complex queries. To keep track of data manipulations using Audit functionalities.
- Generated custom and parameterized reports using SSRS.
- Reorganized database structures as needed, automated procedures at regular intervals. Optimized long running Stored Procedures and queries for effective data retrieval.
- Optimized SQL queries for improved performance and availability.
- Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases.
SQL developer & TesterGreenwich 03/2013 - 04/2014
Wells Fargo
- Participated in developing logical model and implementing requirements on SQL Server 2008. Created the database for the reporting team.
Solved various T-SQL issues using Query Analyzer.
- Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers. Created ad hoc T-SQL Queries.
- Created backup and restore operations.
- Created Database Triggers to implement business requirements.
- Created complex Stored Procedures and Functions to support the front-end application.
- Optimized SQL queries for improved performance and availability.
- Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test database databases.
- Ensured Data Recovery, Maintenance, and Data Integrity and space requirements for physical
Database.
- Reorganized database structures as needed, automated procedures at regular intervals. Optimized long running Stored Procedures and queries for effective data retrieval.
- Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
- Worked with DBA to maintain referential integrity by defining table and column level options such as primary/foreign keys, cascade delete and column constraints on applicable data-mart tables. Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
Cognizant - SQL DeveloperCity, STATE- 04/2012 - 02/2013
- Participated in developing logical model and implementing requirements on SQL Server 2008. Created the database for the reporting team.
- Optimized SQL queries for improved performance and availability.
- Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases.
- Designed and developed the database based on these requirements.
- Carried out a Developer's role on MS SQL Server 2008, MS Access Databases (using DTS (Data Transformation Service), T (Transact)-SQL, Stored Procedures and Views).
- Involved in migration of SQL server 7 to SQL server 2008 using Upgrade Advisor.
- Installed and Configured SQL Server 2008, Created Logins, Users and Maintenance Plans managing use of Disk space, memory and connections to the database.
- Involved in assisting QA team in deploying and testing the application, which uses SQL Server as a database.
- Involved in creation of stored procedures, triggers using T-SQL according to the requirement of the projects.
- Involved in Performance tuning and optimizing for SQL Server Application by using performance monitor.
Education
- San Francisco State University
- Bachelor of Arts: Business Administration
Skills
Languages: SQL. HTMLXML. MySQLManagement StudioSolution ExplorerLinuxMac. ETL Tools: Informatica PowerWorkflowMonitorSSIS/SSRS.PowerShell.Tools: MS Visual StudioMSOffice (WordExcelPowerPointAccess).
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SQL Developer ประสบการณ์ 5 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 7 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ