ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 235
Resume Example SQL Developer #0235 ประมาณ 1935 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง Project: - Health-e-Arizona Plus (HEA Plus) มีประสบการณ์รวมประมาณ 8 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 10 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 8 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Power BI ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา SQL ให้ความสำคัญ
- ประสบการณ์ 10 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 25+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
8+ years of IT experience in Data Design and Development on Microsoft SQL Server 2019/2016/2012/2008R2/2005, T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Packages, SSRS and Data-warehousing. Experience in in using Business Intelligence tools (SSIS, SSRS, SSAS) in MS SQL Server 2019/ 2016/2012/2008 Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity. Extensive knowledge of Normalization and Relational Database Management Systems. Good understanding in database and data warehousing concepts (OLTP & OLAP). Hands on experience on various SQL Server Services like Integration Services (SSIS), Reporting Services (SSRS) and and Analysis Services (SSAS). Great ability to to create and manage various database objects like tables, views. Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions. Experience in Performance Tuning and Query Optimization. - Experienced in using ETL tools in (SSIS) MS SQL 2016/2012/2008/2008 R2 and DTS in MS SQL 2000 Hands on experience create views and books. using cubes, Experience in Extracting, ting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS Server by using BCP utility, DTS and SSIS services. SQL Server - Developed Dynamic packages using SSIS and Implemented Incremental Data Loading. Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task. Data analysis and data migration by transferring them using SSIS packages. - Experience with logical and physical data modeling and database design using Erwin. - Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS). - Deployed and processed SSAS cube weekly to update information by using SQL Server Agent. - Expert in creating simple and parameterized reports and complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS). - Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS. Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance. Capable of forming and maintaining positive and productive working relationships in internal/ external and team environments. Solid understanding of Software Development Life Cycle (SDLC). Worked in Agile Environment. Expertise in using TFS to open bugs, create task and user stories, initiate change requests. Used GIT as part of TFS source control to deploy solutions.
Experience
Position
- The Furniture Mart - Senior SQL BI Developer / DBA Davenport, IA 11/2015 Current
Project: - Health-e-Arizona Plus (HEA Plus)
- Introducing Health-e-Arizona Plus. AHCCCS and DES collaborated to develop a new system to apply for AHCCCS Health Insurance, Kids Care, Nutrition Assistance and Cash Assistance benefits and to connect to the Federal Insurance Marketplace. The Federal Insurance Marketplace provides Premium Tax Credits and Cost Sharing Reduction programs to help many Arizonans with the cost of health insurance.
- Proactively monitored the database systems to ensure secure services with minimum downtime Reviewed code written by coders/test TSQL code written by others
- Maintained and audited database level security
- Experience in Database Backup and Restore and Disaster Recovery procedures and Daily routines like security administration and monitoring automated jobs.
PositionExperience in SQL server migration from 2008R2 - 2012 and 2012 - 2016.
- Provided emergency and urgent support as required by the business and/or application owner to ensure availability and integrity of the application and data
- Evaluated performance of SQL Server stored procedures, functions, and triggers and made recommendations on how to resolve performance issues
- Developed a data import through SSIS that cleans and processes data monthly to keep two enterprise systems in sync
- Experience in SQL Server data migration from legacy database servers to SQL server. Extensively involved in the design of the Data Extraction, Transformation and Loading (ETL) control, developed several complex SSIS packages with several data transformation components Created complex stored procedures and SSIS packages for converting the data Developed Dynamic packages using SSIS and Implemented Incremental Data Loading. Scheduling and maintaining SSIS Packages and batch jobs thru SQL Server Agent on a weekly basis. Implemented Error Logging using Event Handlers and implemented logging in SSIS Packages Identified areas of data de-normalization and proposed methods of f normalizing i it
- Worked I on the team responsible for data modelling and approving all DDL changes Merged code and validated the correct code were moving in the promotion scripts Worked with developers to increase their knowledge and increase the quality of code by providing guidance in schema design, efficient T-SQL, index strategies, set-based logic, etc. from a performance perspective
- Identified database performance improvement opportunities via monitoring and analysis of database servers (DMV's, extended events, etc.) and proposed multiple enhancements to management
- Diagnosed active performance issues in production database environments Refactored database objects to improve performance
- Collaborated across multiple departments to make sure everyone was communicating clearly and moving forward for the betterment of the company
- Hands on experience with Microsoft SQL Server / Team Foundation Server (TFS) / Visual Studio / Redgate
- Tools: SQL Server 2019, 2016, 2012, 2008 R2 Enterprise Edition, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Windows Server 2005, 2010, Oracle 9i, Sybase, TFS.
SQL BI DeveloperNorth Branch, MN 05/2015- 10/2015
The Furniture Mart
- Spencer Stuart is a global executive search and leadership consulting firm. The firm offers services and expertise in Executive Search, Board Services, Succession Planning, Executive Assessment, and Leadership Advisory Services. Spencer Stuart is justifiably famous for the introduction of a new method for finding and placing managers. The modus operandi of the firm is to combine a management talent search with management consulting. Responsibilities:
- Actively participated in interactions with users, team lead, DBAs and technical manager to fully understand the requirements of the system
- Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintained Referential Integrity
- Created different kinds of reports like tabular reports, matrix reports, sub-reports, drill-down
- reports, ad-hoc reports, etc. and deployed them to the report manager using SSRS
- Developed complex SSRS reports using multiple data providers, global variables, expressions, user- defined objects, aggregate aware objects, charts, and synchronized queries Created SSIS packages with error handling to populate data from various data sources Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL
Server
- server
- Configured SSIS packages using Package configuration wizard to allow packages run on different environments envir
- Worked with Meta-Data Driven SSIS Packages to pull the data from various sources and load to Datamart
- Created systems for capturing error data in a flat-file using flat-file destination, sending the error data in the flat file attached to the corresponding mail ids using Sent Mail Task, and correcting error data error data
Experienced in ETL Data Warehouse environment
- Responsible for creating jobs in SSIS and for ETL job scheduled to run daily, weekly and monthly Participated in the issues associated with ETL Data Warehouse Failure
- Established Checkpoints to implement restart ability of SSIS packages
- Created ETL packages in SSIS and conducted data migration processes in the SQL Server environment using SQL Server Integration Services
- Worked with project teams for migrating SSIS Packages from SQL Server 2008 to SQL Server 2012 Involved in fine-tuning and performance and query optimization of the database as required by the application
- Tools: SQL Server 2012,2008R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), OLAP, Team City, Tortoise SVN, Visual Studio 2010, JIRA, MS Excel 2007.
Alight - SQL BI DeveloperIA, State 12/2014 - 04/2015
- Deloitte Risk Management System (DRMS) is a tool that participating member firms use for completing the process of documenting and approving client and engagement acceptance/continuance decisions. The system can be used by all the Deloitte functions (Audit, ERS, Consulting, Tax, & FAS) within the participating member firm. DRMS 4.5 is a component of the Deloitte Global Risk Tools (DGRT) program suite of tools. DRMS introduces Deloitte-standard reporting platform SQL Server Reporting Services (SSRS) to the current DRMS Solution it offers Full-featured reporting functionality, Faster more efficient deployment of reports, Ad-hoc/self-service reporting. Responsibilities:
- Managing Database Objects: tables, indexes, views, etc.
- Creating complex stored procedures, tables, and views and other SQL joins and statements for applications.
- Handling primary second level support for problems encountered with production processing, including off hours support.
- Working with client for resolving different bug fixes of data migration by writing different queries using joins, cursors and loops.
- Maintaining and managing SQL Server for development, test and production environments.
- Starting and stopping SQL Server and SQL Server Agent services and providing on-call SQL Database Operational Support to users.
- Developing, maintaining and supporting SQL applications and supporting .NET developers. Created different kinds of reports like tabular reports, matrix reports, sub-reports, drill down reports etc. and deployed them to the report manager using SQL Server Reporting Services (SSRS). Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
- Deployed reports created report schedules and subscriptions. Managing and securing reports using SSRS.
Position
Built ad-hoc reports using SQL Server Reporting Services (SSRS).
- Developing different complex SSIS packages for data extracting by using DFT, merge joins, union, executive SQL tasks, script components, different source and target systems either flat file, Excel or RDBMS. of RDBMS.
- Installing, Upgrading and Configuring of Microsoft SQL Server and Database, Creating and using Stored Procedures, Using Defined Functions, Triggers, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
- Tools: Windows Server 2008, SQL Server 2012, T-SQL, Visual Studio 2010, SQL Builder, ADO.Net, C#.Net, SQL Server Integration Services, SQL Server Reporting Services.
SQL DeveloperCity, STATE. 01/2012 - 08/2013
Shine Kreations
- Shine Kreations is E-Commerce website which handles selling products online and updates the new products on the website from time to time for the customers. It also controls the online delivery system for the products by providing tracking details with the help of local courier companies. Responsibilities:
- Interacted with team and analysis, design and developed database using ER diagram, normalization and relational database concept
- Involved in design, development and testing of the system
- Developed SQL Server stored procedures, tuned SQL queries (using indexes and execution plan)
- Developed user-defined functions and created views
- Created triggers to maintain the referential integrity
- Implemented exceptional ptional handling
Worked
- I on client requirement and wrote complex SQL queries to generate crystal reports
- Creating and automating the regular Jobs
- Tuned and optimized SQL queries using the execution plan and SQL profiler
- Rebuilding indexes and tables as part of performance tuning exercise
- Involved in performing database backup and recovery
- Worked on documentation using MS word
- Tools: Windows Server 2008 R2, SQL Server 2012.
Education
- Master of Science: Computer Science · Jawaharlal Nehru And
- Technological University
- Bachelor of Science: Computer Science
Skills
AccessMySQLData warehouse.DatabasPerformance MonitorQuery AnalyzerQuery OptimizerSQL ProfilerETLODBCSQL CMD.Languages: T-SQLC++PL/ SQLUMLXMLMS SharePointSQLServer Reporting Services(SSRS)Crystal ReportsOLAPSource Safe (VSS)MS DOSLinux.
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง Project: - Health-e-Arizona Plus (HEA Plus) ประสบการณ์ 8 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 10 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ