ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 220
Resume Example SQL Developer #0220 ประมาณ 1231 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SQL BI Developer / Gep ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 5 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ มี Professional Summary ที่สรุปความสามารถหลักก่อนเข้าสู่รายละเอียดประสบการณ์ทำงาน
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 5 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Tableau ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา SQL ให้ความสำคัญ
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 40+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
Around 2.5 years of IT experience including SQL Server Database Design, Implementation, Testing, Deployment and Maintenance. * Experience in developing BI Solutions for Enterprise Decision support systems using Microsoft suite of products like SSIS, SSRS and SSAS. SKILLS SQL Server 2016,SQL Server 2012, 2008 R2, 2008 (2 years), SQL Server Integration Services (SSIS) (2 years), SQL Server Reporting Services (SSRS) (2 years), SQL Server Analysis Services (SSAS) (1 year, MS Access (2 years), MS Excel (2 years), MS Word (2 years, MS Outlook (2 years), MS PowerPoint (2 years), SQL Server Management Studio (2 years), Visual Studio 2013, 2010, 2008 (2 years), Windows 7 (2 years), Windows Xp (2 years), Windows 8 (2 years),HTML5 (2 years), XML (2 years), CSS3 (2 years), Base-SAS. TECHNICAL SKILLS
Experience
SQL BI Developer / Gep07/2014 - 06/2015
- Experience with the full Software Development Life Cycle (SDLC).
- Experience building/optimizing cubes with SQL queries, and experience with Analysis Services (SSAS) and Reporting Services (SSRS) including database development, deployment, configuration, security and troubleshooting.
- Skillful in analyzing business workflows and transforming the requirements into UML Diagrams using Visio.
- Good knowledge of OLTP, OLAP, Data Mart/Warehouse modelling of Star and Snow-Flake Schema patterns as per normalization rules using Erwin.
- Exceptional SQL scripting and debugging skills including DDL, DML, DCL and TCL in SSMS and TOAD.
- Skilled tuning SQL Server Performance using tools like Index Tuning Wizard, SQL Profiler and Database Engine Tuning Advisor.
- Experience in creating dynamic ETL workflow canvas for validating, importing and exporting data from Excel, XML, Flat Files, SQL Servers and MS Access using SSIS.
- Experience in installing, configuring and upgrading SQL Server versions.
- Experience in configuring Linked Servers, monitoring, troubleshooting and migrating SQL Servers.
- Experience in performing backup with point in time restoration, fail over clusters, mirroring, replications and log shipping.
- Hands on experience in creating, scheduling and rendering visually rich and intuitive Data Insights using SSRS and Tableau.
- Experience in software configuration management using tools like VSS, TFVC and GitHub.
- Experience in creating and integrating Technical Design Documents to MS SharePoint and application.
- Willing to put in effort to improve outcome, making sure that the assigned sprint tasks done in a timely manner, despite time pressure and long hours.
- Willing to Relocate anywhere in the USA.
- Authorized to Work for any Employer in USA Choice Transportation is an Order Routing System accessible to transportation vendors, drivers and corporate office built for transporting clinicians to five boroughs of New York.
- The project aimed at migration of SQL Server 2005 to 2012, filtering the procurement data as per destination schema rules.
- The migration should provide all fields that will support BI reporting as out lined in RRD.
- Responsibilities.
- Analyze BRD documents and turn the same into proposed database using Erwin and MS Visio.
- Extensively used DDL, DML & TCL statements for defining, accessing and manipulating transactional systems.
- Created file groups, stored procedures, table valued functions, triggers and views using base tables with indexes, constraints, joins, grouping sets, window functions, set and pivot operators.
- Configured Linked Servers to access multiple SQL Server and Oracle instances.
- Used SQL Profiler, Index Tuning Wizard and Performance monitor for better execution plans of SQL queries.
- Developed SSIS packages for data validations and loadings from OLTP and file systems to the hive using block/ unblock transformations.
- Developed incremental loading packages using change data capture (CDC), slowly changing dimension (SCD).
- Scheduled the deployed SSIS packages using SQL Server Agent with event handlers.
- Worked on isolation levels of transactional queries to prevent dirty reads, non-repeatable reads, phantom reads and deadlocks.
- Worked on isolation levels of transactional queries to prevent dirty reads, non-repeatable reads, phantom reads and deadlocks.
- Worked on Toad to access Oracle Databases using PL/SQL procedures.
- Created behavior pattern dashboards and came up with effective demographic stories using charts, graphs, Gauge and ESRI maps.
- Created paginated reports with drill-down, drill-through and cascaded parameters for analyzing the past performance in specified business regions.
- Created Indexes and increased the performance of daily run reports by almost 20%.
- Responsible for Technical Design Documentation (TDD) of Schema, ETL Package and BI report development.
- Closed the logged defects using TFS with updates to ticket owner.
- Configured versions of SQL Queries using GitHub.
- Involved in daily standup meetings and knowledge transfer sessions.
Jr. SQL BI Developer05/2013 - 06/2014
Cinergy Techmatics Pvt. Ltd
- Voterite is a web application developed to create means for politicians, candidates and party leaders for establishing campaigns, seeking support and gaining votes within their constituency.
- It connects educated and social savvy across social networking sites to review the leaders.
- Responsibility.
- Used Erwin tool to understand the Database design and developed the database of specific file groups.
- Extensively worked on querying and debugging SQL scripts including base tables, stored procedures, table valued functions, triggers and views.
- Generated preformatted Excel and flat files (csv, tab and pipe delimiters) to marketing team using SSIS.
- Worked on transactional queries using isolation levels, try-catch blocks and error notifications.
- Extracted, Transformed and Loaded data from SQL Server and File systems using BCP, Bulk Insert utilities, Loop Containers, Look Up, Conditional Split, Derived Column, Aggregate transformations etc...
- Developed and scheduled SSIS packages of incremental data loads using Slowly Changing Dimension (SCD) and Event Handlers.
- Troubleshoot, debugged and performance tuned SSIS packages using SQL Profiler trace log files.
- Implemented applicable joins, clustered and non-clustered indexes for better query execution plans.
- Created macros, pivot tables, V & H lookups over MS Excel and generated daily roaster files.
- Tuned SQL Server performance using SQL profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
- Created SQL Server Agent Jobs and monitored the scheduled SSIS packages.
- Created categorical and trend analysis visualizations on periodic, financial and region segments using charts, graphs, Gauge and maps of SSRS.
- Developed SSRS canned reports for customer segmentation based on the size of organization, gross income and other parameters with filters, drill down, drill through and table calculations.
- Performed database mirroring and backups with differential and full recoveries over SQL Server 2012.
- Tracked and closed the bug tickets as per priority and severity using TFS.
- Responsible for Technical Design Documentation of Data Flows and BI reports developed and integrated them to SharePoint server.
Education
- Masters: Statistical Analytics
- Texas A&M University Kingsville · Statistical Analytics · May 2013
- Bachelors: Information Technology
- Jawaharlal Nehru Technological University - Andhra Pradesh Information Technology
Skills
backupBIcanvaschartsconfiguration managementDatabasesDatabasedatabase developmentDatabase designDCLdebuggingDMLDocumentationdriversErwinESRIETLXMLfinancialgraphsmacrosmarketingmeetingsaccessMS AccessMS ExcelExcelofficeMS OutlookMS PowerPointSharePointwindowWindows XPMS WordmigrationnetworkingOLAPOraclePL/SQLpivot tables
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SQL BI Developer / Gep ประสบการณ์ 5 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 2 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ