อยากได้ Resume ที่โดดเด่นกว่าตัวอย่างนี้?

ใช้ตัวอย่างเป็นแนวทางได้ แต่ Resume ที่ชนะต้องเขียนให้ตรงกับตำแหน่ง และประสบการณ์ของคุณ เราเป็นมืออาชีพรับเขียน Resume และ Cover Letter ภาษาอังกฤษ รับประกันความพึงพอใจ

รับเขียน Resumeรับเขียน Cover Letter

ตัวอย่าง Resume นักพัฒนา ETL (ETL Developer) ฉบับที่ 142

Resume Example ETL Developer #0142 ประมาณ 1830 คำ

เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง Senior BI Developer ระดับอาวุโส มีประสบการณ์รวมประมาณ 7 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้

จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 3 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ

สิ่งที่ควรสังเกตในตัวอย่างนี้

เนื้อหาในเรซูเม่ฉบับนี้

Resume Example
Senior BI Developer
100 Montgomery St. 10th Floor- (555) 432-1000-

Professional Summary

JESSICA CLAIRE Senior MS Business Intelligence Developer, with over 7 years of experience in querying, designing, maintaining databases, and developing Business Intelligence Solutions on MS SQL Server. A wide experience in working in different industry domains like energy, consulting and insurance. Committed team player with excellent time management skills that prioritizes client satisfaction. PROFESSIONAL SUMMARY Strong Experience in Microsoft Business Intelligence (MSBI), ETL Data Warehouse, OLTP & OLAP using SQL Server Integration Services (SSIS) and Azure Data Factory V2 (ADF2), Reporting (SSRS/Power BI), Analysis Services (SSAS) and MS SQL Server (2012-2019). Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Clustering, T-SQL, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/ Export, Triggers and Cursors and various SQL server objects like schemas, tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE (common table expression), Table Variables and Stored Procedures. Developed physical data models, created DDL (Data Definition Language) scripts and DML (Data Manipulation language) scripts to manipulate the SQL Database. Expertise in Extracting, Transformation and Loading (ETL) using various tools like export/import data and SQL Server Integration services. Created, Developed, Tested and Deployed Packages into production servers by creating package configurations. Expert in merging Data from various complex Data sources, Populating Dimension and Fact tables in Data warehouses, Cleaning and Standardizing the data loaded into OLTP and OLAP databases using SSIS. Good understanding of Normalization /De-normalization and database design methodology. Experience in creating ETL process, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies, Including Star and Snowflake schema. Skillful in developing PBIX files in both Power BI Desktop and Power BI Services platforms and in uploading them into Report Server and Cloud Services with proper row level security settings. Seasoned in building Tabular models within Power BI Desktop and writing complex DAX queries to create measures and calculated columns. Skilled in Analyses Service, particularly in building Tabular models on top of DW/DM/DB, and writing complex DAX and MDX queries against the models. Experience in creating Report models for Ad-hoc reports, Drill Down, Drill Through, Parameterized, Cascading, Conditional, Table (List), Matrix (Crosstab), Charts, Sub-Reports, Indicators, Bar Graphs & Line Graphs, Dashboards, Ad-hoc reports using SSRS. Expert in Performance Tuning of Complex T-SQL codes, SSIS packages, Power BI/SSRS reports. Experience pushing and pulling data from Azure blob. Experience in developing and deploying backend services to Azure clouds. Good understanding of migration of on-premise SQL Server schemas to the cloud on Azure SQL Server DB and Azure VM and development and maintenance of databases across both on-premise and cloud deployments. Hands-on experience with Azure Data Factory V2, Data Flows, Azure Data Lake, Azure Synapse, Azure Analysis Services, Snowflake and other cloud tools. Solid understanding in maintenance and administration of SSIS by creating SQL Agent Jobs, Alerts, Mail Notifications, and schedule DTS/SSIS Packages by SQL Agent, Windows Scheduler and other third-party tools. Excellent analytical, communication and interpersonal skills and proficient in writing and presenting complex technical concepts, comfortable working independently and with different size of teams, self-motivated and goal oriented.

Experience

Senior BI Developer01/2020 - Current
American Medical Association
  • Loss prevention
  • Cash register operations
  • Product promotions
  • Played a key role in Sprint Planning for Agile Methodology, Feature grooming, and calculated Users Story Points and helped with Backlog prioritization. Performed code reviews for Pull Requests via Azure DevOps and participated in application architecture and design and other phases of SDLC.
  • Strong experience with SQL Server and T-SQL in implementing, maintaining developing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Databases Models, creating and updating tables and checking the database consistency by executing DBCC commands.
  • Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures. Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
  • Built reports for different domains such as Finance, Accounting, Management, and other client teams.
  • Created Power BI reports on account information, research reports using ad-hoc reporting to be used by clients and advisors. Created reports on both cascading and standard parameters. Worked on Power BI in creating dashboards and reports and visualizing data.
  • Accounting Reports included Year-To-Date, Month-To-Date, Period Close reports, Transaction and Snapshot reports for General Ledger, Budget reports, etc.
  • Developed filters, reports, dashboards and also created chart types, visualizations and complex DAX calculations to manipulate the data in Power BI.
  • Created reports using Power BI Desktop and deployed to Power BI Service to share with end users via Workspaces and Apps which implemented Row Level Security and User Group management.
  • Used various formatting techniques and features like interactive sorting, grouping, slicer, bookmarks, RLS, PLS and many others to create user friendly reports.
BI Developer03/2016 - 12/2019
Expeditors International Of Washington, Inc.
  • Actively participated in daily scrum meetings, sprint planning/grooming sessions, and discussed new requested features/user- stories/tasks with Business Analysts and updated the status of tasks assigned on Jira.
  • Played a main role in the Migration Project, where all data from Legacy SAP Business Warehouse (BW) has been migrated to MS SQL Server Enterprise Data Warehouse (EDW), as well as, all SAP Business Objects Reports have been migrated to Power BI Services Platform.
  • Actively participated in development of SSIS ETL packages and underlining complex Stored Procedure to migrate historical data piece of the project from SAP System to MS SQL Server and develop SSIS packages with incremental load logic from all upstream CRM Source Systems.
  • Wrote complex SPs/UDFs to clean 'dirty' data while migration/transformation from old system to new EDW.
  • Contributed to develop the conceptual/logical/physical data modeling of the current EDW, identified the fact tables and it is related dimension (dim) tables and coded them with FK/PK relationships and applied appropriate constraints to ensure the quality and integrity of the data warehouse.
  • Developed over 10 separated complex SSAS Tabular Models to supports reports in the areas like Demographics, Income and Expense, Instructor Qualification, Device Utilization, Opportunity Management, Reservation, Endorsements & Checks, and Pricing.
  • Developed descriptive and user-friendly Self-Service Models for end users to create their own PBI Dashboards /Reports per their own needs.
  • Migrated/re-developed/enhanced over 30 dashboards/reports from SAP Business Objects platform into Power BI Service.
  • Mainly used Direct Query method connecting to above mentioned SSAS Tabular Models as a source.
  • Developed measures with complex dynamic DAX queries to calculate all the required KPIs requested.
  • Wrote Power Query (M) scripts to make sure the SSAS Tabular Models are sourcing only the needed data and to improve performance, i.e., smartly used aggregations instead of brining all the underlining data, removed unneeded columns, and filtered unnecessary old data by brining only data for the last 4-5 per end user agreement.
  • Created several .rdl reports with Power BI Report Builder to meet the specific requirements of the end users which could not be satisfied by PBI Desktop/Services, i.e., the Managerial Report was supposed to be a single continuous page, with the ability to export to PDF as a continues page.
  • Applied row level securities in all Power BI Reports and assigned AD Groups, created Run Books and scheduled and monitored data source refreshes accordingly.
  • Handled all the weekly deployment from DEV to QAT/UAT/PROD environments.
  • On demand bases provided non-standard and ad-hoc reports requested by management.
ETL Developer01/2014 - 02/2016
Salient Crgt
  • Used Team Foundation Server to report bugs and to maintain product backlog items. Setup various Team Projects into different Team Project Collections in TFS environment. Tested the data with complex queries, joins and sub queries.
  • Developed tables, views, indexes, CTEs, functions and advanced queries for databases. Created complex stored procedures, functions, cursors, and SQL joins for applications. Created Indexes and maintained fill factor for fast and efficient reporting process.
  • Involved in performance tuning and monitoring T-SQL blocks. Created the deployment scripts after the development is done for every project.
  • Used SQL Server Profiler to monitor for long running queries and tune them to improve performance.
  • Developed SSIS packages to bring data from SQL Server, Oracle, Excel, XML, and Flat Files into SQL db. Worked on tasks like Execute SQL, ftp, Send mail, for each loop container, derived column, conditional split.
  • Used script task to write C# code to satisfy business rules. Created packages with error handling and used package configurations for deployment. Developed packages to send E mail alert and log into SQL table for any issues (on error).
  • Created and Deployed the SSIS packages and scheduled the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
  • Used the Bulk Copy Program (BCP) to load large volumes of data from files into tables.
  • Created SSIS packages to transfer data across heterogeneous data sources. Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data.
  • Developed slowly changing dimension SCD-Type 0, 1, 2 in SSIS to update the old data in dimension tables when the new source data is loaded. Also automated the process by deploying the packages into SQL server and creating jobs in SQL Server Agent. - Worked extensively on system analysis, designing, development, implementation, testing of projects.
  • Automated manual process using Advanced ETL such as auto extract data from Smartsheet and load it into SQL server using Script task and merge statement.
  • Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement using SQL Server Reporting Services (SSRS).
  • Involved in integration of SharePoint with SSRS and managed reports subscriptions, delivery, generation, rendering via SharePoint UI. Developed Complex reports using SSRS and created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a date. Rendered the SSRS reports in the form PDF, PowerPoint, Excel, and CSV formats as per the client requirements. Documented all kinds of SSRS reports and SSIS packages.
  • Involved in Creation of Dimensions using Star and Snowflake Schema in SQL Server Analysis Services (SSAS).
  • Involved in defining the source to target data mappings, business rules and data definitions.
  • Created Joins and sub-queries for complex queries having multiple tables from different databases involved, daily supported the system wide replication tasks including monitoring, alerting, and problem resolution.
  • Pulled data into MS SQL Server Database from different DBMS databases like Oracle, Teradata with ETL packages.

Education

  • Master of Science: 09/2011
  • Gaziantep University - Gaziantep
  • Bachelor of Science: 05/2009
  • Inonu University - Malatya
  • Microsoft Certified: Data Analyst Associate (Power BI) 07/25/2021 Link Oracle Certified Associate, Java SE 8 Programmer 11/30/2020

Skills

Guest servicesInventory control proceduresMerchandising expertise

สรุปว่าจะได้อะไรจากตัวอย่างนี้

ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง Senior BI Developer ประสบการณ์ 7 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 3 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ

อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ

← ตัวอย่างก่อนหน้า (#0141)กลับไปหน้านักพัฒนา ETLตัวอย่างถัดไป (#0143) →