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

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

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

Resume Example SQL Developer #0240 ประมาณ 1940 คำ

เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง SQL BI Developer / Reporting Tools: SSRS (SQL Server Reporting Services) ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 6 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้

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

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

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

JESSICA CLAIRE
SQL BI Developer / Reporting Tools: SSRS (SQL Server Reporting Services)
Montgomery Street, San Francisco, CA 94105 (555) 432-1000 - [email]

Professional Summary

- Over 6 Years of experience in BI solutions using T-SQL, SSRS, SSIS, SSAS and Data modeling, Database Design, Programming using DDL, DML, DCL commands for various business applications. - Interacted with technical team and Business users to perform analysis of business requirements and transformed them into technical requirements for ETL and Reporting needs. - Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases. - Experience in Creating Tables, Views, Complex Stored Procedures to facilitate efficient data manipulation, data integrity and other T- SQL statements for various applications. - Optimized the T-SQL query performance with modifications in T-SQL queries, removing unnecessary columns, establishing necessary joins. - Experience in coding the T-SQL using the Temp tables, Table variables by analyzing the Business logics. - Generated complex Transact SQL(T-SQL) queries, Sub queries, Co-related sub queries, and Dynamic SQL queries. Programming in SQL Server - Using the Stored Procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs) - Proficient in Performance Tuning/Query optimization using indexes. Tuning the performance of stored procedures and large T-SQL Queries using Clustered Indexes, efficient coding standards. - Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency. - Expertise in Migrating the DTS packages to SSIS and to SSDT. - Well experience in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS) 2008/2008 R2/2012/2014 and 2016 - Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS. - Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring various Connection Managers using SSIS. - Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS. - Involved in usage of various SSIS components such as For loop, For-each loop, Fuzzy lookup and hands on experience in Event Handlers, Error Handlers etc. - Experienced in creating master and child packages, Package Configurations and Logging Using SSIS. - Excellent knowledge of using Variables and Expressions in packages of SSIS. - Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling SSIS Packages - Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users. - Experience in different type of reports including Tabular forms, Matrix form, Conditional, Drill down, List items, Charts and Sub Reports. - Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS) 2008 R2/2012/2014 - Involved in handling Enterprise wide reporting needs using SQL Reporting Services, Crystal Reports. - Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling for FACT and Dimension Tables using SQL Server Analysis Services. - Worked in dimensional modeling with Star & Snowflake schemas and created the Data Source Views (DSV) and SSAS Cubes using the identified Fact and Dimensional Tables. - Experienced in writing Queries using SQL Server Analysis Services (SSAS). - Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures and Partitions. - Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. 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 BI Developer / Reporting Tools: SSRS (SQL Server Reporting Services)05/2016 - Current
Crystal Reports
  • Tools: Microsoft Visual Studio 2014/2012/2008, MS Office, Teradata SQL Assistance, Oracle SQL Developer
  • ETL Tools: SSIS (SQL Server Integration Services), DTS
The Furniture Mart - Baxter, MN, United States of America
  • Office Depot, Inc.is an Americanoffice supplyretailing company headquartered inBoca Raton, Florida, United States of America. The company has combined annual sales of approximately $14 billion, employs about 66,000 associates, and serves consumers and businesses in 59 countries with more than 2,200 retail stores, e-commerce sites and abusiness-to- businesssales organization
  • Developed Stored Procedures, User Defined Functions, Views, Triggers, T-SQL Scripting for complex business logic.
  • Extensively used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.
  • Optimized the database by creating various clustered, non-clustered indexes and indexed views.
  • Involved in creating, maintaining tables and Performance tuning of long running stored procedures and Queries.
  • Worked on rewriting the Old Oracle Stored Procedures to T-SQL by deep understanding of the business logic.
  • Worked on creating complex queries to pull up data from various tables using Loops and creating variables.
  • Extracted large volumes of data from various data sources and loaded the data into target data destinations by performing different kinds of transformations using SQL Server Integration services (SSIS).
  • Created SSIS/SSDT packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files, Oracle, Teradata Etc.,) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
  • Involved in migrating the data in between SQL Server, Oracle and Teradata.
  • Worked in scripting Teradata load utilities(Fast load and Multi Load) and used to run through SSIS by using Execute Process task
  • Scheduling the Jobs using the ESP Jobs scheduler in Mainframes.
  • Extensively Worked on Migrating the DTS packages to SSIS (2008) and to SSDT(2014).
  • Have deployed packages on different servers by using Project Deployment in SSIS 2012/2014 using Project and Package Parameters.
  • Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.
  • Created complex SSIS packages using proper Control and Data flow elements.
  • Extensively worked on Variables and Complex Expressions in packages of SSIS
  • Documented all the processes involved in maintaining the database and all the SSDT packages for future reference.
  • Environment: Microsoft Windows 2008 Advanced Server, Microsoft SQL Server 2014/2012/2008R2, Visual Studio 2008,2012 and 2013,SQL Assistance, SQL Developer, Main Frames, Oracle, Teradata, SSIS, SSRS, OLAP, Tortoise.
Senior SQL SSIS/SSRS Developer / (AIG)American International Group, Inc - City, STATE05/2015 - 05/2016
  • American International Group, Inc. (AIG) is a leading international insurance organization serving customers in more than 100 countries and jurisdictions. AIG companies serve commercial, institutional and individual customers through one of the most extensive worldwide property-casualty networks of any insure. In addition, AIG companies are leading providers of life insurance and retirement services in the United States.
  • Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports, OLAP reporting, dashboards, and Scorecards.
  • Involved in the dimensional modeling of Data warehouse using Erwin tool
  • Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation
  • Used Different String and Date time functions to manipulate the data using T-SQL.
  • Extensively worked on Views, cursors, CTE's, schemas, permissions and performance issues with client/server database design.
  • Created many database objects like tables, views, indexes, functions and advanced queries for database in both development and production environments using SQL Server Management Studio's Database engine.
  • Migrated SSIS Packages of SQL Server 2008 to SQL Server 2012 as per business requirement
  • Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS)
  • Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
  • Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages
  • Created ETL process using SSIS to transfer data from heterogeneous data sources.
  • Have deployed packages on different servers by using Project Deployment in SSIS 2012 using Project and Package Parameters.
  • Created different type of reports including Cross-tab, Conditional, and Drill-down, OLAP and Sub reports.
  • Good understanding of Microsoft Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
  • Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
  • Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS)Designed and formatted SSRS Reports using Parameters and Expressions for the
Reports.
  • Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
  • Environment: Microsoft Windows 2008 Advanced Server, Microsoft SQL Server 2014/2012/2008R2, SSIS, SSRS (SQL Server Reporting Services), OLAP, Oracle SQL Developer, TFS, Erwin
Senior Analyst, SQL Developer09/2010 - 10/2014
GLOBAL LOGIC
  • GlobalLogic is an offshore software R&D services company that was founded in 2000 and has headquarters in San Jose, California. It is a privately held company founded by Apax Partners. Global Logic provides full-lifecycle product development services, including experience design, product engineering, content engineering, and labs. The company specializes in big data and analytics, cloud, design, DevOps, embedded, Internet of Things, mobile, and security practices. GlobalLogic works with both start-ups and mature product and services companies in the automotive, finance, media and communications, hi-tech, medical technology, and retail industries
  • Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.
  • Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.
  • Worked on creating complex queries to pull up data from various tables using Loops and creating variables.
  • Developed Stored Procedures in SQL Server 2012/2014 and modified existing stored procedures as needed.
  • Extensively designed the packages and data mapping using Data flow task, For each Loop Container, Execute SQL Task, File System task and Script Task in SSIS Designer.
  • Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Flat Files, Excel and other OLEDB, ODBC data sources.
  • Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
  • Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
  • Experienced in creating jobs Alerts, Alerts,SQL Mail Agent, and Scheduling SSIS Packages using SQL Server
Agent job.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
  • Involved in Analyzing, designing, building of OLAP cubes with SSAS 2008(R2) Identified and defined Fact relationships in SSAS.
  • Defined KPI's, Actions and Calculations in SSAS using MDX.
  • Developed Query for generating Drill Down and Drill Through Reports in SSRS 2012 and 2008.
  • Designed and formatted SSRS Reports using Parameters and Expressions for the Reports.
  • Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
  • Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
  • Environment: SQL Server 2012/2008R(2), MS Server Integration services, SSRS (MS server Reporting Services), SSAS, Window 2007/2008 Server, Crystal Reports, Share Point Server 2010 and VB.net.

Skills

Languages: CC++T-SQLVB.NETORACLETERADATAMS-AccessWeb Technologies: HTMLXMLMS ExcelMS AccessMS FrontPage.SQL ProfilerQuery AnalyzerSQL Server Management StudioSSISSSRSSSASVisioMS Dos and UNIX

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

ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง SQL BI Developer / Reporting Tools: SSRS (SQL Server Reporting Services) ประสบการณ์ 6 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 6 ตำแหน่ง พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ

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

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