ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 246
Resume Example SQL Developer #0246 ประมาณ 1311 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SQL BI Developer ระดับอาวุโส มีประสบการณ์รวมประมาณ 7 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 3 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 7 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Tableau, Power BI ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา SQL ให้ความสำคัญ
- ประสบการณ์ 3 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 23+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
Dedicated Business Intelligence Developer with 7+ years of experience in identifying problem areas within business data streams, designing. and managing BI and analytical solutions that turn raw data into meaningful data. Having handy experience with receiving and monitoring data from multiple data streams, including MSSQL, SSIS, SSRS data sources. Profound knowledge of industry-specific data such as Transportation, Retail, and Telecommunication. Experienced in working in different environments such as Development, UAT, and Production.
Experience
SQL BI Developer05/2020 - Current
Gep - Clark
- Develop complex database objects Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for SSIS packages and SSRS reports.
- Gather, analyze, and document business requirements and business rules by directly working with end users/clients.
- Create and maintain documents such as Documentation Roadmaps, DATA Models, ETL Execution Plans, Configuration Management Procedures, and Project Plans.
- 10% working with PM's on clarifying business requirements.
- 20% Misc. work and ad hoc work with sprints and projects.
- Extract and load SharePoint lists and Surveys Data into SQL Server Database with SQL Server Integration Services.
- Create and execute scheduled administrative tasks using SQL Server Agent
- Create and execute scheduled administrative tasks using SQL Server Agent
- Created SSIS packages to clean and load data to data warehouse.
- Created packages in SSIS with error handling using Event handlers.
- Developed T-SQL Scripts to validate data after loading process. Modified and tested T-SQL stored procedures
SQL BI Developer (SQL, SSIS, SSAS, SSRS, Power BI)05/2018 - 05/2020
STL Truckers - City
- Created and designed database inventory application for maintenance and safety department that saved company $700/week in labor cost that was vanishing like company expanse.
- Developed and measured win/loss analysis template to identify financial status and risks.
- Responsible for installations and configurations of Operation Systems and Servers that connect workers in overseas country.
- Created database applications utilizing multi-tier ideas with utilization of SQL statement and Store Procedures to fetch, update, and control databases on SQL Server 2012 and Oracle 11g.
- Wrote complex sub-queries like Correlated and Nested sub-queries, and aggregate window functions to find monthly running total freights and products that are transported most frequently in year.
- In-depth knowledge in Normalization /De-normalization and database design methodology, SQL query performance tuning through creating or modifying clustered and non-clustered indexes, setting transaction isolation levels as well as changing complex query structures.
- Expert at checking, rebuilding, and reorganizing internal and external fragmentation in SQL.
- Structured and created plenty of SSIS packages using Data Flow Task, Execute SQL Task, and Script Task for ETL projects.
- Designed several For Loop containers, For each Loop, and Sequence containers in SSIS.
- Profound knowledge in understanding ERDS and Database Models.
- Skilled in using Synchronous (Data Conversion and Derived Column, Multicast, Row count, etc.) and Asynchronous transformation (including Sort, Fuzzy Lookup, etc.) to perform various transformations to SSIS package.
- Utilized complex UDF, Store Procedures, Views, and Triggers for solving different business requirements.
- Used DML triggers (such as after/instead of Update, Delete, and Insert) to maintain referential integrity of data.
- Assisted Data Architects in building data warehouse entities like fact tables, dimensions that are involved in Snowflake Schemas.
- Used Breakpoint and Checkpoints to debug/troubleshoot package while loading into data warehouse.
- Performed continuously incremental loads to load data OLTP environment to OLAP environment.
- Built many OLAP cubes in SSAS.
- Created perspectives for Finance, Operational Management, Accounting, and Sales departments using OLAP cubes.
- Wrote complex DAX queries in SSAS to generate computed columns according to business requirements before pushing them to GitHub.
- Deployed many SSIS packages into SSIS catalog.
- Scheduled several jobs to run SSIS packages into SSIS catalog.
- Helped Business Analysis team in preparing documentation such as data mapping files and data analysis forms.
- Worked with all departments such as management, hiring, accounting, dispatching, maintenance, and safety teams to implement row-level security and policies.
- Hands-on experience in creating summary reports and ad-hoc reports using SQL Server Reporting Services.
- Created SSRS and Power BI reports sourcing from SSAS Multidimensional OLAP and Tabular model cubes with MDX and DAX.
- Worked on various DAX expressions in Power Pivot based on business requirements.
- Deployed lots of custom reports, parameterized reports, drill down and drill through reports, as well as, created numerous subscriptions for Management.
SQL/SSIS/MSBI Developer09/2015 - 04/2018
Merchant Chimp - City
- Wrote clear, well organized, and most efficient transactions in SQL.
- Widely used upper-level backend SQL Server programming including various databases such as relational databases.
- Utilized TSQL and PL/SQL scripts to create and drop database objects involving tables, indexes, views, primary and foreign keys, and constraints (check, default, not null constraints, and so on).
- Developed tables and built relationship between parent and child tables using primary and foreign keys.
- Responsible for design and creating indexes including Clustered and Non-clustered indexes, covering, filtering, and complex indexes.
- Developed and actualized multiple-table connections, User Defined Functions by using complex Joins like Cross apply, Outer apply, Inner Join, Outer Join, and Self Join.
- Modified properties of SQL Server and Database to do Performance Tuning.
- Used Event Handler to troubleshoot errors and failures in SSIS packages and different tasks.
- Performed Extracting and Transforming, Load (ETL) to pull and modify data from different sources such as Flat files, Excel files, CSV files to SQL Server Database.
- Implemented various Aggregate functions, Conditional Split, Merge Join, Look-Up, Derived Column, Fuzzy Lookup, Fuzzy Grouping, DQS (Data Quality Services) cleansing transformations for data cleansing, removing empty spaces, eliminate data redundancy.
- Hands-on experience on Azure Data Factory and Azure Data Lakes.
- Liaise with internal groups and customers to comprehend product changes and how affect related reports and visualizations.
- Highly skilled in creating dimensions, facts, and schemas including star schemas, snowflake schemas.
- Build rock-solid reports and user-friendly data visualizations using SQL Server Reporting Services and Power-BI.
- Loaded data using Analytics Engine in Power Pivot.
- Skilled in building Pivot tables and charts using power pivot, and creating calculated columns and measures using formulas.
- Understanding of various types of data viewers such as Column Chart, Histogram, Grid.
- Profound experience in creating dashboards, editing reports using Power BI Services.
- Pinned plenty of reports into multiple dashboards in Power BI Services.
- Skilled at generating drill-down reports, fixed headers for reports using Power BI report builder.
- Created reports using parameters configured so that it would switch from UAT into production environment in Power BI
- Added bookmarks, slicers to report in order to filter data.
- Using Power BI created different visualization such as cards, multi-row cards, KPIs in order to show Total Revenue, Total Costs, and Total Profits for managers of companies.
- Created templates for frequently reporting requests to improve productivity.
- 70% working on tasks being given. Focus work on business needs to record in needed format.
- Bachelor of Science: Computer Science, 05/2014
Skills
Query AnalyzerSQL Server Management StudioSQL ProfilerSQL Server Analysis Service (SSAS)Microsoft AzureSSRSSSASDTS)Reporting/Visualization tools: Power-BITableauMicrosoftSSISExcelPower BIVMUNIX (SolarisSun/OSLinux).Others: MS OfficeAdobe ProductsUI/UX toolsGitGitHub
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SQL BI Developer ประสบการณ์ 7 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 3 ตำแหน่ง พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ